SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001637s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045337s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081070s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049118s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289426 LIMIT 5 [ RunTime:0.038418s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.017813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289426 ORDER BY `minOrder` ASC [ RunTime:0.061161s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289426 ORDER BY `unit` DESC [ RunTime:0.055810s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289426 LIMIT 2 [ RunTime:0.016596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289426 ORDER BY `minOrder` ASC [ RunTime:0.035076s ]
select * from pdf where partno='26700-141-5563D' and brandshort='Aven Tools' limit 1 [ RunTime:0.067618s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-5563D' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.056272s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289426 AND `partno` = '26700-141-5563D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.108652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289425 LIMIT 5 [ RunTime:0.013386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289425 ORDER BY `minOrder` ASC [ RunTime:0.091036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289425 ORDER BY `unit` DESC [ RunTime:0.075574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289425 LIMIT 2 [ RunTime:0.112579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289425 ORDER BY `minOrder` ASC [ RunTime:0.046801s ]
select * from pdf where partno='26700-141-534XYR' and brandshort='Aven Tools' limit 1 [ RunTime:0.058242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-534XYR' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.029108s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289425 AND `partno` = '26700-141-534XYR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.055704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289424 LIMIT 5 [ RunTime:0.040617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289424 ORDER BY `minOrder` ASC [ RunTime:0.025670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289424 ORDER BY `unit` DESC [ RunTime:0.082821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289424 LIMIT 2 [ RunTime:0.061990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289424 ORDER BY `minOrder` ASC [ RunTime:0.025429s ]
select * from pdf where partno='26700-141-556XYR' and brandshort='Aven Tools' limit 1 [ RunTime:0.070017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-556XYR' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.038192s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289424 AND `partno` = '26700-141-556XYR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.050700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289423 LIMIT 5 [ RunTime:0.040059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289423 ORDER BY `minOrder` ASC [ RunTime:0.068987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289423 ORDER BY `unit` DESC [ RunTime:0.040256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289423 LIMIT 2 [ RunTime:0.061257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289423 ORDER BY `minOrder` ASC [ RunTime:0.020799s ]
select * from pdf where partno='26700-141-4793D' and brandshort='Aven Tools' limit 1 [ RunTime:0.051180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-4793D' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.051420s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289423 AND `partno` = '26700-141-4793D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.061669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289422 LIMIT 5 [ RunTime:0.026836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289422 ORDER BY `minOrder` ASC [ RunTime:0.026351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289422 ORDER BY `unit` DESC [ RunTime:0.044400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289422 LIMIT 2 [ RunTime:0.010562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289422 ORDER BY `minOrder` ASC [ RunTime:0.025016s ]
select * from pdf where partno='26700-141-556' and brandshort='Aven Tools' limit 1 [ RunTime:0.007746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-556' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.047709s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289422 AND `partno` = '26700-141-556' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.065114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288869 LIMIT 5 [ RunTime:0.023887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288869 ORDER BY `minOrder` ASC [ RunTime:0.028923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288869 ORDER BY `unit` DESC [ RunTime:0.044579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288869 LIMIT 2 [ RunTime:0.010060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288869 ORDER BY `minOrder` ASC [ RunTime:0.009184s ]
select * from pdf where partno='26700-141-STND' and brandshort='Aven Tools' limit 1 [ RunTime:0.058679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-STND' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.020372s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288869 AND `partno` = '26700-141-STND' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.032395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288868 LIMIT 5 [ RunTime:0.063031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288868 ORDER BY `minOrder` ASC [ RunTime:0.040329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288868 ORDER BY `unit` DESC [ RunTime:0.027066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288868 LIMIT 2 [ RunTime:0.040777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288868 ORDER BY `minOrder` ASC [ RunTime:0.026858s ]
select * from pdf where partno='26700-141-3DA' and brandshort='Aven Tools' limit 1 [ RunTime:0.038523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-3DA' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.106412s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288868 AND `partno` = '26700-141-3DA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.063535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288860 LIMIT 5 [ RunTime:0.026824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288860 ORDER BY `minOrder` ASC [ RunTime:0.071769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288860 ORDER BY `unit` DESC [ RunTime:0.102182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288860 LIMIT 2 [ RunTime:0.071790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288860 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
select * from pdf where partno='26700-141-RLLED' and brandshort='Aven Tools' limit 1 [ RunTime:0.093917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-RLLED' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.063421s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288860 AND `partno` = '26700-141-RLLED' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.079227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289499 LIMIT 5 [ RunTime:0.132682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289499 ORDER BY `minOrder` ASC [ RunTime:0.022351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289499 ORDER BY `unit` DESC [ RunTime:0.046178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289499 LIMIT 2 [ RunTime:0.054001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289499 ORDER BY `minOrder` ASC [ RunTime:0.025135s ]
select * from pdf where partno='26700-141-5343D' and brandshort='Aven Tools' limit 1 [ RunTime:0.024448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-5343D' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.030253s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289499 AND `partno` = '26700-141-5343D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.038545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289498 LIMIT 5 [ RunTime:0.080505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289498 ORDER BY `minOrder` ASC [ RunTime:0.098171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289498 ORDER BY `unit` DESC [ RunTime:0.059233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289498 LIMIT 2 [ RunTime:0.052332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289498 ORDER BY `minOrder` ASC [ RunTime:0.047493s ]
select * from pdf where partno='26700-141-534' and brandshort='Aven Tools' limit 1 [ RunTime:0.033070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-534' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.099085s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289498 AND `partno` = '26700-141-534' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.102974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289497 LIMIT 5 [ RunTime:0.064566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289497 ORDER BY `minOrder` ASC [ RunTime:0.018673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289497 ORDER BY `unit` DESC [ RunTime:0.022805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289497 LIMIT 2 [ RunTime:0.074396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289497 ORDER BY `minOrder` ASC [ RunTime:0.043830s ]
select * from pdf where partno='26700-141-3D' and brandshort='Aven Tools' limit 1 [ RunTime:0.022954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-3D' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.018113s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289497 AND `partno` = '26700-141-3D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.014722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288981 LIMIT 5 [ RunTime:0.045890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288981 ORDER BY `minOrder` ASC [ RunTime:0.103708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288981 ORDER BY `unit` DESC [ RunTime:0.056440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288981 LIMIT 2 [ RunTime:0.045060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288981 ORDER BY `minOrder` ASC [ RunTime:0.097758s ]
select * from pdf where partno='26700-141-RLUV' and brandshort='Aven Tools' limit 1 [ RunTime:0.038745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-RLUV' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.043787s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288981 AND `partno` = '26700-141-RLUV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.054673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289496 LIMIT 5 [ RunTime:0.030065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289496 ORDER BY `minOrder` ASC [ RunTime:0.024598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289496 ORDER BY `unit` DESC [ RunTime:0.044491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289496 LIMIT 2 [ RunTime:0.003978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289496 ORDER BY `minOrder` ASC [ RunTime:0.043995s ]
select * from pdf where partno='26700-141-533' and brandshort='Aven Tools' limit 1 [ RunTime:0.028925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141-533' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.033450s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289496 AND `partno` = '26700-141-533' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.149251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64289495 LIMIT 5 [ RunTime:0.048885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289495 ORDER BY `minOrder` ASC [ RunTime:0.131507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64289495 ORDER BY `unit` DESC [ RunTime:0.041518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64289495 LIMIT 2 [ RunTime:0.027019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64289495 ORDER BY `minOrder` ASC [ RunTime:0.013673s ]
select * from pdf where partno='26700-141' and brandshort='Aven Tools' limit 1 [ RunTime:0.046525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26700-141' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.083101s ]
SELECT `id` FROM `stock` WHERE `id` <> 64289495 AND `partno` = '26700-141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.032640s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073495s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112608s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.134072s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079248s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053829s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.120361s ]
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 '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.131430s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '26700-141%' OR `brand` LIKE '26700-141%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.073008s ]