SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002742s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008090s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270913 LIMIT 5 [ RunTime:0.026871s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270913 ORDER BY `minOrder` ASC [ RunTime:0.026221s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19270913 ORDER BY `unit` DESC [ RunTime:0.031273s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19270913 LIMIT 2 [ RunTime:0.019738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270913 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270355 LIMIT 5 [ RunTime:0.023206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270355 ORDER BY `minOrder` ASC [ RunTime:0.037279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19270355 ORDER BY `unit` DESC [ RunTime:0.025266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19270355 LIMIT 2 [ RunTime:0.075108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270355 ORDER BY `minOrder` ASC [ RunTime:0.004530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270293 LIMIT 5 [ RunTime:0.032623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270293 ORDER BY `minOrder` ASC [ RunTime:0.028772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19270293 ORDER BY `unit` DESC [ RunTime:0.070849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19270293 LIMIT 2 [ RunTime:0.038174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270293 ORDER BY `minOrder` ASC [ RunTime:0.037840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818790 LIMIT 5 [ RunTime:0.085449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818790 ORDER BY `minOrder` ASC [ RunTime:0.054851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18818790 ORDER BY `unit` DESC [ RunTime:0.044063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18818790 LIMIT 2 [ RunTime:0.074595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818790 ORDER BY `minOrder` ASC [ RunTime:0.024826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815857 LIMIT 5 [ RunTime:0.084443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815857 ORDER BY `minOrder` ASC [ RunTime:0.053584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18815857 ORDER BY `unit` DESC [ RunTime:0.136688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18815857 LIMIT 2 [ RunTime:0.055772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815857 ORDER BY `minOrder` ASC [ RunTime:0.018008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232171 LIMIT 5 [ RunTime:0.068028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232171 ORDER BY `minOrder` ASC [ RunTime:0.041436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232171 ORDER BY `unit` DESC [ RunTime:0.116461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232171 LIMIT 2 [ RunTime:0.061194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232171 ORDER BY `minOrder` ASC [ RunTime:0.022684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232170 LIMIT 5 [ RunTime:0.008010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232170 ORDER BY `minOrder` ASC [ RunTime:0.029127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232170 ORDER BY `unit` DESC [ RunTime:0.038889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232170 LIMIT 2 [ RunTime:0.021262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232170 ORDER BY `minOrder` ASC [ RunTime:0.011895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14183446 LIMIT 5 [ RunTime:0.043615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14183446 ORDER BY `minOrder` ASC [ RunTime:0.021642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14183446 ORDER BY `unit` DESC [ RunTime:0.036156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14183446 LIMIT 2 [ RunTime:0.022927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14183446 ORDER BY `minOrder` ASC [ RunTime:0.042744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556058 LIMIT 5 [ RunTime:0.005007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556058 ORDER BY `minOrder` ASC [ RunTime:0.026402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556058 ORDER BY `unit` DESC [ RunTime:0.024759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556058 LIMIT 2 [ RunTime:0.025253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556058 ORDER BY `minOrder` ASC [ RunTime:0.007222s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019449s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64717368 LIMIT 5 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64717368 ORDER BY `minOrder` ASC [ RunTime:0.007860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64717368 ORDER BY `unit` DESC [ RunTime:0.023162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64717368 LIMIT 2 [ RunTime:0.005370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64717368 ORDER BY `minOrder` ASC [ RunTime:0.010369s ]
select * from pdf where partno='6040873' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017274s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040873' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.050345s ]
SELECT `id` FROM `stock` WHERE `id` <> 64717368 AND `partno` = '6040873' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818790 [ RunTime:0.036869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64715771 LIMIT 5 [ RunTime:0.035095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715771 ORDER BY `minOrder` ASC [ RunTime:0.023497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64715771 ORDER BY `unit` DESC [ RunTime:0.012356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64715771 LIMIT 2 [ RunTime:0.013770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715771 ORDER BY `minOrder` ASC [ RunTime:0.037487s ]
select * from pdf where partno='6040881' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040881' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007592s ]
SELECT `id` FROM `stock` WHERE `id` <> 64715771 AND `partno` = '6040881' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232171 [ RunTime:0.007425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64715770 LIMIT 5 [ RunTime:0.009083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715770 ORDER BY `minOrder` ASC [ RunTime:0.012896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64715770 ORDER BY `unit` DESC [ RunTime:0.016518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64715770 LIMIT 2 [ RunTime:0.014181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715770 ORDER BY `minOrder` ASC [ RunTime:0.007730s ]
select * from pdf where partno='6040880' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040880' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011995s ]
SELECT `id` FROM `stock` WHERE `id` <> 64715770 AND `partno` = '6040880' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232170 [ RunTime:0.016117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710901 LIMIT 5 [ RunTime:0.031028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710901 ORDER BY `minOrder` ASC [ RunTime:0.027403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710901 ORDER BY `unit` DESC [ RunTime:0.003530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710901 LIMIT 2 [ RunTime:0.018529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710901 ORDER BY `minOrder` ASC [ RunTime:0.011727s ]
select * from pdf where partno='6040874' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040874' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020455s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710901 AND `partno` = '6040874' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815857 [ RunTime:0.005208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64533110 LIMIT 5 [ RunTime:0.013281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64533110 ORDER BY `minOrder` ASC [ RunTime:0.021950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64533110 ORDER BY `unit` DESC [ RunTime:0.032246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64533110 LIMIT 2 [ RunTime:0.014931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64533110 ORDER BY `minOrder` ASC [ RunTime:0.007077s ]
select * from pdf where partno='60408' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60408' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.056128s ]
SELECT `id` FROM `stock` WHERE `id` <> 64533110 AND `partno` = '60408' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556058 [ RunTime:0.033679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63276928 LIMIT 5 [ RunTime:0.032809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63276928 ORDER BY `minOrder` ASC [ RunTime:0.041962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63276928 ORDER BY `unit` DESC [ RunTime:0.028882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63276928 LIMIT 2 [ RunTime:0.018639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63276928 ORDER BY `minOrder` ASC [ RunTime:0.014128s ]
select * from pdf where partno='6040875' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040875' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008082s ]
SELECT `id` FROM `stock` WHERE `id` <> 63276928 AND `partno` = '6040875' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270293 [ RunTime:0.014569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49459413 LIMIT 5 [ RunTime:0.020473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49459413 ORDER BY `minOrder` ASC [ RunTime:0.019230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49459413 ORDER BY `unit` DESC [ RunTime:0.006207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49459413 LIMIT 2 [ RunTime:0.012679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49459413 ORDER BY `minOrder` ASC [ RunTime:0.014718s ]
select * from pdf where partno='6040872' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040872' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013954s ]
SELECT `id` FROM `stock` WHERE `id` <> 49459413 AND `partno` = '6040872' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270913 [ RunTime:0.012629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49458402 LIMIT 5 [ RunTime:0.025406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49458402 ORDER BY `minOrder` ASC [ RunTime:0.008230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49458402 ORDER BY `unit` DESC [ RunTime:0.019474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49458402 LIMIT 2 [ RunTime:0.015245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49458402 ORDER BY `minOrder` ASC [ RunTime:0.028167s ]
select * from pdf where partno='6040876' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040876' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001070s ]
SELECT `id` FROM `stock` WHERE `id` <> 49458402 AND `partno` = '6040876' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270355 [ RunTime:0.008708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36653390 LIMIT 5 [ RunTime:0.023105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36653390 ORDER BY `minOrder` ASC [ RunTime:0.021189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36653390 ORDER BY `unit` DESC [ RunTime:0.018064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36653390 LIMIT 2 [ RunTime:0.025340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36653390 ORDER BY `minOrder` ASC [ RunTime:0.014518s ]
select * from pdf where partno='6040872' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040872' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006614s ]
SELECT `id` FROM `stock` WHERE `id` <> 36653390 AND `partno` = '6040872' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270913 [ RunTime:0.016803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36652379 LIMIT 5 [ RunTime:0.023841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36652379 ORDER BY `minOrder` ASC [ RunTime:0.038870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36652379 ORDER BY `unit` DESC [ RunTime:0.016023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36652379 LIMIT 2 [ RunTime:0.019997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36652379 ORDER BY `minOrder` ASC [ RunTime:0.025449s ]
select * from pdf where partno='6040876' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6040876' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005726s ]
SELECT `id` FROM `stock` WHERE `id` <> 36652379 AND `partno` = '6040876' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.045520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270355 [ RunTime:0.022561s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031578s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034735s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028757s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049170s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007302s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012435s ]
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 '60408%' OR `brand` LIKE '60408%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064731s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60408%' OR `brand` LIKE '60408%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.047879s ]