SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003072s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038016s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13886793 LIMIT 5 [ RunTime:0.089495s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13886793 ORDER BY `minOrder` ASC [ RunTime:0.012156s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13886793 ORDER BY `unit` DESC [ RunTime:0.028554s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13886793 LIMIT 2 [ RunTime:0.050490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13886793 ORDER BY `minOrder` ASC [ RunTime:0.050095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637125 LIMIT 5 [ RunTime:0.039910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637125 ORDER BY `minOrder` ASC [ RunTime:0.060704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637125 ORDER BY `unit` DESC [ RunTime:0.093530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637125 LIMIT 2 [ RunTime:0.118362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637125 ORDER BY `minOrder` ASC [ RunTime:0.026223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636715 LIMIT 5 [ RunTime:0.048577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636715 ORDER BY `minOrder` ASC [ RunTime:0.046642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16636715 ORDER BY `unit` DESC [ RunTime:0.005256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16636715 LIMIT 2 [ RunTime:0.065042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636715 ORDER BY `minOrder` ASC [ RunTime:0.020888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636658 LIMIT 5 [ RunTime:0.131966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636658 ORDER BY `minOrder` ASC [ RunTime:0.159194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16636658 ORDER BY `unit` DESC [ RunTime:0.087279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16636658 LIMIT 2 [ RunTime:0.116717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636658 ORDER BY `minOrder` ASC [ RunTime:0.023210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636657 LIMIT 5 [ RunTime:0.022416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636657 ORDER BY `minOrder` ASC [ RunTime:0.012435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16636657 ORDER BY `unit` DESC [ RunTime:0.014455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16636657 LIMIT 2 [ RunTime:0.024555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636657 ORDER BY `minOrder` ASC [ RunTime:0.041240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636350 LIMIT 5 [ RunTime:0.043172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636350 ORDER BY `minOrder` ASC [ RunTime:0.019869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16636350 ORDER BY `unit` DESC [ RunTime:0.014615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16636350 LIMIT 2 [ RunTime:0.026751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636350 ORDER BY `minOrder` ASC [ RunTime:0.032212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14770596 LIMIT 5 [ RunTime:0.060580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14770596 ORDER BY `minOrder` ASC [ RunTime:0.031278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14770596 ORDER BY `unit` DESC [ RunTime:0.007004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14770596 LIMIT 2 [ RunTime:0.040712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14770596 ORDER BY `minOrder` ASC [ RunTime:0.019369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13877712 LIMIT 5 [ RunTime:0.080530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13877712 ORDER BY `minOrder` ASC [ RunTime:0.036597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13877712 ORDER BY `unit` DESC [ RunTime:0.083864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13877712 LIMIT 2 [ RunTime:0.050081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13877712 ORDER BY `minOrder` ASC [ RunTime:0.027224s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031893s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64335047 LIMIT 5 [ RunTime:0.056362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335047 ORDER BY `minOrder` ASC [ RunTime:0.028090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64335047 ORDER BY `unit` DESC [ RunTime:0.013319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64335047 LIMIT 2 [ RunTime:0.039506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335047 ORDER BY `minOrder` ASC [ RunTime:0.035848s ]
select * from pdf where partno='R0.5D-1212/HP' and brandshort='Recom Power' limit 1 [ RunTime:0.010905s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212/HP' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.021361s ]
SELECT `id` FROM `stock` WHERE `id` <> 64335047 AND `partno` = 'R0.5D-1212/HP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.013681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636715 [ RunTime:0.016547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64334761 LIMIT 5 [ RunTime:0.053448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64334761 ORDER BY `minOrder` ASC [ RunTime:0.023821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64334761 ORDER BY `unit` DESC [ RunTime:0.048076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64334761 LIMIT 2 [ RunTime:0.063204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64334761 ORDER BY `minOrder` ASC [ RunTime:0.022874s ]
select * from pdf where partno='R0.5D-1212/HP-R' and brandshort='Recom Power' limit 1 [ RunTime:0.044235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212/HP-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.033163s ]
SELECT `id` FROM `stock` WHERE `id` <> 64334761 AND `partno` = 'R0.5D-1212/HP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.059286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637125 [ RunTime:0.067470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64334038 LIMIT 5 [ RunTime:0.045455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64334038 ORDER BY `minOrder` ASC [ RunTime:0.039319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64334038 ORDER BY `unit` DESC [ RunTime:0.017520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64334038 LIMIT 2 [ RunTime:0.046347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64334038 ORDER BY `minOrder` ASC [ RunTime:0.017542s ]
select * from pdf where partno='R0.5D-1212/P' and brandshort='Recom Power' limit 1 [ RunTime:0.035897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212/P' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.048489s ]
SELECT `id` FROM `stock` WHERE `id` <> 64334038 AND `partno` = 'R0.5D-1212/P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.076071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13877712 [ RunTime:0.055954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64334037 LIMIT 5 [ RunTime:0.061063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64334037 ORDER BY `minOrder` ASC [ RunTime:0.020809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64334037 ORDER BY `unit` DESC [ RunTime:0.028364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64334037 LIMIT 2 [ RunTime:0.097623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64334037 ORDER BY `minOrder` ASC [ RunTime:0.044748s ]
select * from pdf where partno='R0.5D-1212/H' and brandshort='Recom Power' limit 1 [ RunTime:0.021182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212/H' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.080414s ]
SELECT `id` FROM `stock` WHERE `id` <> 64334037 AND `partno` = 'R0.5D-1212/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.022634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14770596 [ RunTime:0.005954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64333876 LIMIT 5 [ RunTime:0.076216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64333876 ORDER BY `minOrder` ASC [ RunTime:0.093811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64333876 ORDER BY `unit` DESC [ RunTime:0.070045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64333876 LIMIT 2 [ RunTime:0.081841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64333876 ORDER BY `minOrder` ASC [ RunTime:0.092276s ]
select * from pdf where partno='R0.5D-1212/P-R' and brandshort='Recom Power' limit 1 [ RunTime:0.025948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212/P-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.065659s ]
SELECT `id` FROM `stock` WHERE `id` <> 64333876 AND `partno` = 'R0.5D-1212/P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.064614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636658 [ RunTime:0.037836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64333871 LIMIT 5 [ RunTime:0.057551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64333871 ORDER BY `minOrder` ASC [ RunTime:0.044759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64333871 ORDER BY `unit` DESC [ RunTime:0.017005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64333871 LIMIT 2 [ RunTime:0.011801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64333871 ORDER BY `minOrder` ASC [ RunTime:0.030934s ]
select * from pdf where partno='R0.5D-1212/H-R' and brandshort='Recom Power' limit 1 [ RunTime:0.052803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212/H-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.011609s ]
SELECT `id` FROM `stock` WHERE `id` <> 64333871 AND `partno` = 'R0.5D-1212/H-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.036570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636657 [ RunTime:0.027182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64332887 LIMIT 5 [ RunTime:0.023021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64332887 ORDER BY `minOrder` ASC [ RunTime:0.011092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64332887 ORDER BY `unit` DESC [ RunTime:0.031514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64332887 LIMIT 2 [ RunTime:0.029304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64332887 ORDER BY `minOrder` ASC [ RunTime:0.011997s ]
select * from pdf where partno='R0.5D-1212-R' and brandshort='Recom Power' limit 1 [ RunTime:0.021084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.005578s ]
SELECT `id` FROM `stock` WHERE `id` <> 64332887 AND `partno` = 'R0.5D-1212-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.007443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636350 [ RunTime:0.035716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64297403 LIMIT 5 [ RunTime:0.032205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64297403 ORDER BY `minOrder` ASC [ RunTime:0.037790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64297403 ORDER BY `unit` DESC [ RunTime:0.029122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64297403 LIMIT 2 [ RunTime:0.005182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64297403 ORDER BY `minOrder` ASC [ RunTime:0.024684s ]
select * from pdf where partno='R0.5D-1212' and brandshort='Recom Power' limit 1 [ RunTime:0.064743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.5D-1212' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.010708s ]
SELECT `id` FROM `stock` WHERE `id` <> 64297403 AND `partno` = 'R0.5D-1212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.030136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13886793 [ RunTime:0.020755s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031959s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046410s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014346s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003265s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003757s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001458s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004632s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.5D-1212%' OR `brand` LIKE 'R0.5D-1212%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009884s ]