SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001926s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016706s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784210 LIMIT 5 [ RunTime:0.026562s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784210 ORDER BY `minOrder` ASC [ RunTime:0.010392s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784210 ORDER BY `unit` DESC [ RunTime:0.016762s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784210 LIMIT 2 [ RunTime:0.008020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784210 ORDER BY `minOrder` ASC [ RunTime:0.005275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520700 LIMIT 5 [ RunTime:0.014166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520700 ORDER BY `minOrder` ASC [ RunTime:0.022771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520700 ORDER BY `unit` DESC [ RunTime:0.012422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520700 LIMIT 2 [ RunTime:0.016823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520700 ORDER BY `minOrder` ASC [ RunTime:0.019388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190369 LIMIT 5 [ RunTime:0.011248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190369 ORDER BY `minOrder` ASC [ RunTime:0.026829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190369 ORDER BY `unit` DESC [ RunTime:0.026562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190369 LIMIT 2 [ RunTime:0.030250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190369 ORDER BY `minOrder` ASC [ RunTime:0.013603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784265 LIMIT 5 [ RunTime:0.039217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784265 ORDER BY `minOrder` ASC [ RunTime:0.029395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784265 ORDER BY `unit` DESC [ RunTime:0.048949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784265 LIMIT 2 [ RunTime:0.038691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784265 ORDER BY `minOrder` ASC [ RunTime:0.010136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975690 LIMIT 5 [ RunTime:0.013341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975690 ORDER BY `minOrder` ASC [ RunTime:0.052875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975690 ORDER BY `unit` DESC [ RunTime:0.067256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975690 LIMIT 2 [ RunTime:0.035356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975690 ORDER BY `minOrder` ASC [ RunTime:0.010102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975689 LIMIT 5 [ RunTime:0.007767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975689 ORDER BY `minOrder` ASC [ RunTime:0.020013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975689 ORDER BY `unit` DESC [ RunTime:0.015510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975689 LIMIT 2 [ RunTime:0.031671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975689 ORDER BY `minOrder` ASC [ RunTime:0.010398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975688 LIMIT 5 [ RunTime:0.011704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975688 ORDER BY `minOrder` ASC [ RunTime:0.011183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975688 ORDER BY `unit` DESC [ RunTime:0.014645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975688 LIMIT 2 [ RunTime:0.027645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975688 ORDER BY `minOrder` ASC [ RunTime:0.010415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975647 LIMIT 5 [ RunTime:0.016850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975647 ORDER BY `minOrder` ASC [ RunTime:0.002461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975647 ORDER BY `unit` DESC [ RunTime:0.020375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975647 LIMIT 2 [ RunTime:0.012443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975647 ORDER BY `minOrder` ASC [ RunTime:0.005319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975405 LIMIT 5 [ RunTime:0.002839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975405 ORDER BY `minOrder` ASC [ RunTime:0.002416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975405 ORDER BY `unit` DESC [ RunTime:0.005808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975405 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975405 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975404 LIMIT 5 [ RunTime:0.002799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975404 ORDER BY `minOrder` ASC [ RunTime:0.008435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975404 ORDER BY `unit` DESC [ RunTime:0.001910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975404 LIMIT 2 [ RunTime:0.006003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975404 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975403 LIMIT 5 [ RunTime:0.003641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975403 ORDER BY `minOrder` ASC [ RunTime:0.001648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975403 ORDER BY `unit` DESC [ RunTime:0.010376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975403 LIMIT 2 [ RunTime:0.017199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975403 ORDER BY `minOrder` ASC [ RunTime:0.005411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975074 LIMIT 5 [ RunTime:0.028279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975074 ORDER BY `minOrder` ASC [ RunTime:0.034821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975074 ORDER BY `unit` DESC [ RunTime:0.008124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975074 LIMIT 2 [ RunTime:0.012801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975074 ORDER BY `minOrder` ASC [ RunTime:0.035652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974947 LIMIT 5 [ RunTime:0.017357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974947 ORDER BY `minOrder` ASC [ RunTime:0.022645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974947 ORDER BY `unit` DESC [ RunTime:0.012144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974947 LIMIT 2 [ RunTime:0.014523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974947 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974944 LIMIT 5 [ RunTime:0.010770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974944 ORDER BY `minOrder` ASC [ RunTime:0.016357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974944 ORDER BY `unit` DESC [ RunTime:0.037422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974944 LIMIT 2 [ RunTime:0.016334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974944 ORDER BY `minOrder` ASC [ RunTime:0.005912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784248 LIMIT 5 [ RunTime:0.004160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784248 ORDER BY `minOrder` ASC [ RunTime:0.001285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784248 ORDER BY `unit` DESC [ RunTime:0.005000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784248 LIMIT 2 [ RunTime:0.003291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784248 ORDER BY `minOrder` ASC [ RunTime:0.020754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781637 LIMIT 5 [ RunTime:0.009957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781637 ORDER BY `minOrder` ASC [ RunTime:0.008493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781637 ORDER BY `unit` DESC [ RunTime:0.004032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781637 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781637 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781636 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781636 ORDER BY `minOrder` ASC [ RunTime:0.009848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781636 ORDER BY `unit` DESC [ RunTime:0.008475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781636 LIMIT 2 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781636 ORDER BY `minOrder` ASC [ RunTime:0.003397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781635 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781635 ORDER BY `minOrder` ASC [ RunTime:0.005081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781635 ORDER BY `unit` DESC [ RunTime:0.014404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781635 LIMIT 2 [ RunTime:0.008463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781635 ORDER BY `minOrder` ASC [ RunTime:0.018073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781212 LIMIT 5 [ RunTime:0.010646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781212 ORDER BY `minOrder` ASC [ RunTime:0.007040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781212 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781212 LIMIT 2 [ RunTime:0.014291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781212 ORDER BY `minOrder` ASC [ RunTime:0.015824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781211 LIMIT 5 [ RunTime:0.008107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781211 ORDER BY `minOrder` ASC [ RunTime:0.011918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781211 ORDER BY `unit` DESC [ RunTime:0.018019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781211 LIMIT 2 [ RunTime:0.017435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781211 ORDER BY `minOrder` ASC [ RunTime:0.003460s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006047s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56522185 LIMIT 5 [ RunTime:0.003019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56522185 ORDER BY `minOrder` ASC [ RunTime:0.007190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56522185 ORDER BY `unit` DESC [ RunTime:0.013473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56522185 LIMIT 2 [ RunTime:0.009145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56522185 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
select * from pdf where partno='1052892' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012724s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052892' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013894s ]
SELECT `id` FROM `stock` WHERE `id` <> 56522185 AND `partno` = '1052892' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784210 [ RunTime:0.013091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56521796 LIMIT 5 [ RunTime:0.034354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521796 ORDER BY `minOrder` ASC [ RunTime:0.027327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56521796 ORDER BY `unit` DESC [ RunTime:0.007159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56521796 LIMIT 2 [ RunTime:0.016863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521796 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
select * from pdf where partno='1052885' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052885' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007778s ]
SELECT `id` FROM `stock` WHERE `id` <> 56521796 AND `partno` = '1052885' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784265 [ RunTime:0.003833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56521694 LIMIT 5 [ RunTime:0.014804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521694 ORDER BY `minOrder` ASC [ RunTime:0.011749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56521694 ORDER BY `unit` DESC [ RunTime:0.027815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56521694 LIMIT 2 [ RunTime:0.047816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521694 ORDER BY `minOrder` ASC [ RunTime:0.003776s ]
select * from pdf where partno='1052899' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052899' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024196s ]
SELECT `id` FROM `stock` WHERE `id` <> 56521694 AND `partno` = '1052899' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190369 [ RunTime:0.018362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56485182 LIMIT 5 [ RunTime:0.009481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56485182 ORDER BY `minOrder` ASC [ RunTime:0.014390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56485182 ORDER BY `unit` DESC [ RunTime:0.006352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56485182 LIMIT 2 [ RunTime:0.014436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56485182 ORDER BY `minOrder` ASC [ RunTime:0.012938s ]
select * from pdf where partno='1052829' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052829' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007053s ]
SELECT `id` FROM `stock` WHERE `id` <> 56485182 AND `partno` = '1052829' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520700 [ RunTime:0.015939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56523802 LIMIT 5 [ RunTime:0.014634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56523802 ORDER BY `minOrder` ASC [ RunTime:0.015822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56523802 ORDER BY `unit` DESC [ RunTime:0.013301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56523802 LIMIT 2 [ RunTime:0.006466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56523802 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='1052896' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052896' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006195s ]
SELECT `id` FROM `stock` WHERE `id` <> 56523802 AND `partno` = '1052896' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784248 [ RunTime:0.008586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60583392 LIMIT 5 [ RunTime:0.007465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60583392 ORDER BY `minOrder` ASC [ RunTime:0.007925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60583392 ORDER BY `unit` DESC [ RunTime:0.003169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60583392 LIMIT 2 [ RunTime:0.003254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60583392 ORDER BY `minOrder` ASC [ RunTime:0.001579s ]
select * from pdf where partno='10528.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.002738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10528.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000531s ]
SELECT `id` FROM `stock` WHERE `id` <> 60583392 AND `partno` = '10528.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.005579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12548472 [ RunTime:0.001825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57986997 LIMIT 5 [ RunTime:0.023792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986997 ORDER BY `minOrder` ASC [ RunTime:0.029269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57986997 ORDER BY `unit` DESC [ RunTime:0.007835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57986997 LIMIT 2 [ RunTime:0.011130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986997 ORDER BY `minOrder` ASC [ RunTime:0.008401s ]
select * from pdf where partno='1052866' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052866' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015404s ]
SELECT `id` FROM `stock` WHERE `id` <> 57986997 AND `partno` = '1052866' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775217 [ RunTime:0.006211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57986176 LIMIT 5 [ RunTime:0.007801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986176 ORDER BY `minOrder` ASC [ RunTime:0.006785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57986176 ORDER BY `unit` DESC [ RunTime:0.006155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57986176 LIMIT 2 [ RunTime:0.015561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986176 ORDER BY `minOrder` ASC [ RunTime:0.017412s ]
select * from pdf where partno='1052860' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052860' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025426s ]
SELECT `id` FROM `stock` WHERE `id` <> 57986176 AND `partno` = '1052860' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048037 [ RunTime:0.039267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57984243 LIMIT 5 [ RunTime:0.012879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984243 ORDER BY `minOrder` ASC [ RunTime:0.029010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57984243 ORDER BY `unit` DESC [ RunTime:0.005154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57984243 LIMIT 2 [ RunTime:0.056274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984243 ORDER BY `minOrder` ASC [ RunTime:0.027288s ]
select * from pdf where partno='1052861' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052861' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019502s ]
SELECT `id` FROM `stock` WHERE `id` <> 57984243 AND `partno` = '1052861' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.041354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223580 [ RunTime:0.017998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57983795 LIMIT 5 [ RunTime:0.028929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57983795 ORDER BY `minOrder` ASC [ RunTime:0.051237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57983795 ORDER BY `unit` DESC [ RunTime:0.027681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57983795 LIMIT 2 [ RunTime:0.016347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57983795 ORDER BY `minOrder` ASC [ RunTime:0.013228s ]
select * from pdf where partno='1052862' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052862' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033209s ]
SELECT `id` FROM `stock` WHERE `id` <> 57983795 AND `partno` = '1052862' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010576 [ RunTime:0.029568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56577601 LIMIT 5 [ RunTime:0.030068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577601 ORDER BY `minOrder` ASC [ RunTime:0.035873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56577601 ORDER BY `unit` DESC [ RunTime:0.012515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56577601 LIMIT 2 [ RunTime:0.013303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577601 ORDER BY `minOrder` ASC [ RunTime:0.035770s ]
select * from pdf where partno='10528A' and brandshort='Essentra Components' limit 1 [ RunTime:0.070712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10528A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.023617s ]
SELECT `id` FROM `stock` WHERE `id` <> 56577601 AND `partno` = '10528A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.070613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13324590 [ RunTime:0.066591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56570155 LIMIT 5 [ RunTime:0.021397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56570155 ORDER BY `minOrder` ASC [ RunTime:0.074727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56570155 ORDER BY `unit` DESC [ RunTime:0.020750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56570155 LIMIT 2 [ RunTime:0.028854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56570155 ORDER BY `minOrder` ASC [ RunTime:0.018953s ]
select * from pdf where partno='10528F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.086483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10528F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.035566s ]
SELECT `id` FROM `stock` WHERE `id` <> 56570155 AND `partno` = '10528F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.053630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56569283 LIMIT 5 [ RunTime:0.016322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569283 ORDER BY `minOrder` ASC [ RunTime:0.027293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56569283 ORDER BY `unit` DESC [ RunTime:0.015829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56569283 LIMIT 2 [ RunTime:0.011138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569283 ORDER BY `minOrder` ASC [ RunTime:0.018647s ]
select * from pdf where partno='10528' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.030148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10528' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.013117s ]
SELECT `id` FROM `stock` WHERE `id` <> 56569283 AND `partno` = '10528' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.022071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56534128 LIMIT 5 [ RunTime:0.017327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534128 ORDER BY `minOrder` ASC [ RunTime:0.023470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56534128 ORDER BY `unit` DESC [ RunTime:0.022378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56534128 LIMIT 2 [ RunTime:0.029236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534128 ORDER BY `minOrder` ASC [ RunTime:0.017511s ]
select * from pdf where partno='1052888' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.044084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052888' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035557s ]
SELECT `id` FROM `stock` WHERE `id` <> 56534128 AND `partno` = '1052888' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.042314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781637 [ RunTime:0.031663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56534127 LIMIT 5 [ RunTime:0.078434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534127 ORDER BY `minOrder` ASC [ RunTime:0.034292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56534127 ORDER BY `unit` DESC [ RunTime:0.015241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56534127 LIMIT 2 [ RunTime:0.043991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534127 ORDER BY `minOrder` ASC [ RunTime:0.009296s ]
select * from pdf where partno='1052886' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052886' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022479s ]
SELECT `id` FROM `stock` WHERE `id` <> 56534127 AND `partno` = '1052886' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.046023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781636 [ RunTime:0.034600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56534126 LIMIT 5 [ RunTime:0.014895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534126 ORDER BY `minOrder` ASC [ RunTime:0.027932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56534126 ORDER BY `unit` DESC [ RunTime:0.045947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56534126 LIMIT 2 [ RunTime:0.014241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534126 ORDER BY `minOrder` ASC [ RunTime:0.023900s ]
select * from pdf where partno='1052882' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.050068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052882' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013674s ]
SELECT `id` FROM `stock` WHERE `id` <> 56534126 AND `partno` = '1052882' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.048824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781635 [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56534125 LIMIT 5 [ RunTime:0.024965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534125 ORDER BY `minOrder` ASC [ RunTime:0.025040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56534125 ORDER BY `unit` DESC [ RunTime:0.013898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56534125 LIMIT 2 [ RunTime:0.015600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56534125 ORDER BY `minOrder` ASC [ RunTime:0.002331s ]
select * from pdf where partno='1052868' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.031479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052868' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036751s ]
SELECT `id` FROM `stock` WHERE `id` <> 56534125 AND `partno` = '1052868' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225254 [ RunTime:0.008377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56533506 LIMIT 5 [ RunTime:0.030143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56533506 ORDER BY `minOrder` ASC [ RunTime:0.034595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56533506 ORDER BY `unit` DESC [ RunTime:0.044057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56533506 LIMIT 2 [ RunTime:0.025123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56533506 ORDER BY `minOrder` ASC [ RunTime:0.019200s ]
select * from pdf where partno='1052893' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052893' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018833s ]
SELECT `id` FROM `stock` WHERE `id` <> 56533506 AND `partno` = '1052893' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.028576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781212 [ RunTime:0.031343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56533505 LIMIT 5 [ RunTime:0.026356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56533505 ORDER BY `minOrder` ASC [ RunTime:0.023728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56533505 ORDER BY `unit` DESC [ RunTime:0.018440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56533505 LIMIT 2 [ RunTime:0.009169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56533505 ORDER BY `minOrder` ASC [ RunTime:0.012465s ]
select * from pdf where partno='1052891' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052891' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030908s ]
SELECT `id` FROM `stock` WHERE `id` <> 56533505 AND `partno` = '1052891' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.046869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781211 [ RunTime:0.035272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56533504 LIMIT 5 [ RunTime:0.009142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56533504 ORDER BY `minOrder` ASC [ RunTime:0.009218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56533504 ORDER BY `unit` DESC [ RunTime:0.013283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56533504 LIMIT 2 [ RunTime:0.014875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56533504 ORDER BY `minOrder` ASC [ RunTime:0.009680s ]
select * from pdf where partno='1052889' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052889' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002172s ]
SELECT `id` FROM `stock` WHERE `id` <> 56533504 AND `partno` = '1052889' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011693 [ RunTime:0.027627s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004581s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010568s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004518s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004634s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012555s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001011s ]
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 '10528%' OR `brand` LIKE '10528%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001469s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10528%' OR `brand` LIKE '10528%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002851s ]