SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002293s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034474s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5373 LIMIT 5 [ RunTime:0.034265s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5373 ORDER BY `minOrder` ASC [ RunTime:0.077955s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5373 ORDER BY `unit` DESC [ RunTime:0.033959s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.032998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5373 LIMIT 2 [ RunTime:0.033680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5373 ORDER BY `minOrder` ASC [ RunTime:0.035285s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1608CGCK' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.047094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5375 LIMIT 5 [ RunTime:0.059273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5375 ORDER BY `minOrder` ASC [ RunTime:0.043531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5375 ORDER BY `unit` DESC [ RunTime:0.071700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5375 LIMIT 2 [ RunTime:0.033851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5375 ORDER BY `minOrder` ASC [ RunTime:0.016692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1608SGC' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.048610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5374 LIMIT 5 [ RunTime:0.061121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5374 ORDER BY `minOrder` ASC [ RunTime:0.049102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5374 ORDER BY `unit` DESC [ RunTime:0.026232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5374 LIMIT 2 [ RunTime:0.064149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5374 ORDER BY `minOrder` ASC [ RunTime:0.001422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1608EC' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.029163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11252415 LIMIT 5 [ RunTime:0.053193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11252415 ORDER BY `minOrder` ASC [ RunTime:0.039243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11252415 ORDER BY `unit` DESC [ RunTime:0.053160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11252415 LIMIT 2 [ RunTime:0.027100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11252415 ORDER BY `minOrder` ASC [ RunTime:0.009029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12263447 LIMIT 5 [ RunTime:0.009950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12263447 ORDER BY `minOrder` ASC [ RunTime:0.008065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12263447 ORDER BY `unit` DESC [ RunTime:0.025919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12263447 LIMIT 2 [ RunTime:0.020595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12263447 ORDER BY `minOrder` ASC [ RunTime:0.008406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17159246 LIMIT 5 [ RunTime:0.023336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17159246 ORDER BY `minOrder` ASC [ RunTime:0.020159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17159246 ORDER BY `unit` DESC [ RunTime:0.002506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17159246 LIMIT 2 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17159246 ORDER BY `minOrder` ASC [ RunTime:0.005292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15380659 LIMIT 5 [ RunTime:0.005268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15380659 ORDER BY `minOrder` ASC [ RunTime:0.008547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15380659 ORDER BY `unit` DESC [ RunTime:0.001347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15380659 LIMIT 2 [ RunTime:0.001600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15380659 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15380658 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15380658 ORDER BY `minOrder` ASC [ RunTime:0.007827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15380658 ORDER BY `unit` DESC [ RunTime:0.001946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15380658 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15380658 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12273674 LIMIT 5 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12273674 ORDER BY `minOrder` ASC [ RunTime:0.002161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12273674 ORDER BY `unit` DESC [ RunTime:0.020670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12273674 LIMIT 2 [ RunTime:0.007097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12273674 ORDER BY `minOrder` ASC [ RunTime:0.002015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12272662 LIMIT 5 [ RunTime:0.015568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272662 ORDER BY `minOrder` ASC [ RunTime:0.016960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12272662 ORDER BY `unit` DESC [ RunTime:0.007632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12272662 LIMIT 2 [ RunTime:0.008082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272662 ORDER BY `minOrder` ASC [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12272643 LIMIT 5 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272643 ORDER BY `minOrder` ASC [ RunTime:0.003820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12272643 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12272643 LIMIT 2 [ RunTime:0.003166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272643 ORDER BY `minOrder` ASC [ RunTime:0.004329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12268677 LIMIT 5 [ RunTime:0.003967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12268677 ORDER BY `minOrder` ASC [ RunTime:0.018639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12268677 ORDER BY `unit` DESC [ RunTime:0.010742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12268677 LIMIT 2 [ RunTime:0.009404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12268677 ORDER BY `minOrder` ASC [ RunTime:0.001508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12267620 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12267620 ORDER BY `minOrder` ASC [ RunTime:0.002317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12267620 ORDER BY `unit` DESC [ RunTime:0.003639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12267620 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12267620 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12267603 LIMIT 5 [ RunTime:0.004075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12267603 ORDER BY `minOrder` ASC [ RunTime:0.004064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12267603 ORDER BY `unit` DESC [ RunTime:0.015787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12267603 LIMIT 2 [ RunTime:0.006184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12267603 ORDER BY `minOrder` ASC [ RunTime:0.012443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257558 LIMIT 5 [ RunTime:0.003225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257558 ORDER BY `minOrder` ASC [ RunTime:0.007693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11257558 ORDER BY `unit` DESC [ RunTime:0.024266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11257558 LIMIT 2 [ RunTime:0.037264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257558 ORDER BY `minOrder` ASC [ RunTime:0.004895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257272 LIMIT 5 [ RunTime:0.001300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257272 ORDER BY `minOrder` ASC [ RunTime:0.005172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11257272 ORDER BY `unit` DESC [ RunTime:0.006529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11257272 LIMIT 2 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257272 ORDER BY `minOrder` ASC [ RunTime:0.001567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257265 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257265 ORDER BY `minOrder` ASC [ RunTime:0.003192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11257265 ORDER BY `unit` DESC [ RunTime:0.002884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11257265 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257265 ORDER BY `minOrder` ASC [ RunTime:0.002388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11254507 LIMIT 5 [ RunTime:0.007929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11254507 ORDER BY `minOrder` ASC [ RunTime:0.001486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11254507 ORDER BY `unit` DESC [ RunTime:0.006360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11254507 LIMIT 2 [ RunTime:0.003823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11254507 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11254500 LIMIT 5 [ RunTime:0.002012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11254500 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11254500 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11254500 LIMIT 2 [ RunTime:0.003191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11254500 ORDER BY `minOrder` ASC [ RunTime:0.003959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12268617 LIMIT 5 [ RunTime:0.013849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12268617 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12268617 ORDER BY `unit` DESC [ RunTime:0.012887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12268617 LIMIT 2 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12268617 ORDER BY `minOrder` ASC [ RunTime:0.018492s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006032s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276371 LIMIT 5 [ RunTime:0.008217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276371 ORDER BY `minOrder` ASC [ RunTime:0.009349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276371 ORDER BY `unit` DESC [ RunTime:0.015666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276371 LIMIT 2 [ RunTime:0.004736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276371 ORDER BY `minOrder` ASC [ RunTime:0.002756s ]
select * from pdf where partno='KPT-1/2' and brandshort='Bertech' limit 1 [ RunTime:0.017152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1/2' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.014512s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276371 AND `partno` = 'KPT-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.013038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11252415 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276404 LIMIT 5 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276404 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276404 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276404 LIMIT 2 [ RunTime:0.003140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276404 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
select * from pdf where partno='KPT-1' and brandshort='Bertech' limit 1 [ RunTime:0.009724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.014874s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276404 AND `partno` = 'KPT-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.007223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12263447 [ RunTime:0.003420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276555 LIMIT 5 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276555 ORDER BY `minOrder` ASC [ RunTime:0.011302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276555 ORDER BY `unit` DESC [ RunTime:0.001094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276555 LIMIT 2 [ RunTime:0.003051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276555 ORDER BY `minOrder` ASC [ RunTime:0.008895s ]
select * from pdf where partno='KPT-1/4' and brandshort='Bertech' limit 1 [ RunTime:0.003607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1/4' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.000668s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276555 AND `partno` = 'KPT-1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.005299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12268617 [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276564 LIMIT 5 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276564 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276564 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276564 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276564 ORDER BY `minOrder` ASC [ RunTime:0.009342s ]
select * from pdf where partno='KPT-1/8' and brandshort='Bertech' limit 1 [ RunTime:0.010757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1/8' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.000857s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276564 AND `partno` = 'KPT-1/8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17161647 [ RunTime:0.002123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278654 LIMIT 5 [ RunTime:0.001678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278654 ORDER BY `minOrder` ASC [ RunTime:0.009442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278654 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278654 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278654 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='KPT-1 1/8' and brandshort='Bertech' limit 1 [ RunTime:0.000838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1 1/8' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.000803s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278654 AND `partno` = 'KPT-1 1/8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.003428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15380659 [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278623 LIMIT 5 [ RunTime:0.005927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278623 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278623 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278623 LIMIT 2 [ RunTime:0.005809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278623 ORDER BY `minOrder` ASC [ RunTime:0.004420s ]
select * from pdf where partno='KPT-15MM' and brandshort='Bertech' limit 1 [ RunTime:0.000760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-15MM' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.003530s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278623 AND `partno` = 'KPT-15MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.003047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15380658 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278610 LIMIT 5 [ RunTime:0.005554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278610 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278610 ORDER BY `unit` DESC [ RunTime:0.002906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278610 LIMIT 2 [ RunTime:0.003424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278610 ORDER BY `minOrder` ASC [ RunTime:0.003382s ]
select * from pdf where partno='KPT-11/16' and brandshort='Bertech' limit 1 [ RunTime:0.003798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-11/16' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.005885s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278610 AND `partno` = 'KPT-11/16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.001005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12268677 [ RunTime:0.003484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278391 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278391 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278391 ORDER BY `unit` DESC [ RunTime:0.005762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278391 LIMIT 2 [ RunTime:0.007592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278391 ORDER BY `minOrder` ASC [ RunTime:0.004006s ]
select * from pdf where partno='KPT-1 3/8' and brandshort='Bertech' limit 1 [ RunTime:0.005152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1 3/8' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.005903s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278391 AND `partno` = 'KPT-1 3/8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.002614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12267620 [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278383 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278383 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278383 ORDER BY `unit` DESC [ RunTime:0.007733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278383 LIMIT 2 [ RunTime:0.005077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278383 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='KPT-1 1/4' and brandshort='Bertech' limit 1 [ RunTime:0.001351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1 1/4' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.002175s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278383 AND `partno` = 'KPT-1 1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.002211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11254507 [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278360 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278360 ORDER BY `minOrder` ASC [ RunTime:0.004596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278360 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278360 LIMIT 2 [ RunTime:0.006593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278360 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='KPT-15/16' and brandshort='Bertech' limit 1 [ RunTime:0.004052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-15/16' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.000720s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278360 AND `partno` = 'KPT-15/16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17159246 [ RunTime:0.002611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278344 LIMIT 5 [ RunTime:0.010868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278344 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278344 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278344 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278344 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='KPT-13/16' and brandshort='Bertech' limit 1 [ RunTime:0.001086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-13/16' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.001258s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278344 AND `partno` = 'KPT-13/16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12267603 [ RunTime:0.002524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64278326 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278326 ORDER BY `minOrder` ASC [ RunTime:0.004063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64278326 ORDER BY `unit` DESC [ RunTime:0.001473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64278326 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64278326 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='KPT-10MM' and brandshort='Bertech' limit 1 [ RunTime:0.004427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-10MM' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.000764s ]
SELECT `id` FROM `stock` WHERE `id` <> 64278326 AND `partno` = 'KPT-10MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.002789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11254500 [ RunTime:0.000646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64277091 LIMIT 5 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64277091 ORDER BY `minOrder` ASC [ RunTime:0.007202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64277091 ORDER BY `unit` DESC [ RunTime:0.001534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64277091 LIMIT 2 [ RunTime:0.013295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64277091 ORDER BY `minOrder` ASC [ RunTime:0.002628s ]
select * from pdf where partno='KPT-10' and brandshort='Bertech' limit 1 [ RunTime:0.021218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-10' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.003886s ]
SELECT `id` FROM `stock` WHERE `id` <> 64277091 AND `partno` = 'KPT-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.012084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257558 [ RunTime:0.003842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64277059 LIMIT 5 [ RunTime:0.017354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64277059 ORDER BY `minOrder` ASC [ RunTime:0.009710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64277059 ORDER BY `unit` DESC [ RunTime:0.014275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64277059 LIMIT 2 [ RunTime:0.007472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64277059 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='KPT-125MM' and brandshort='Bertech' limit 1 [ RunTime:0.010247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-125MM' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.011492s ]
SELECT `id` FROM `stock` WHERE `id` <> 64277059 AND `partno` = 'KPT-125MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.013180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12273674 [ RunTime:0.013036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276953 LIMIT 5 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276953 ORDER BY `minOrder` ASC [ RunTime:0.002748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276953 ORDER BY `unit` DESC [ RunTime:0.008121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276953 LIMIT 2 [ RunTime:0.026698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276953 ORDER BY `minOrder` ASC [ RunTime:0.017742s ]
select * from pdf where partno='KPT-1 5/8' and brandshort='Bertech' limit 1 [ RunTime:0.016421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1 5/8' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.009735s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276953 AND `partno` = 'KPT-1 5/8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.026762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257272 [ RunTime:0.027214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276904 LIMIT 5 [ RunTime:0.015296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276904 ORDER BY `minOrder` ASC [ RunTime:0.011927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276904 ORDER BY `unit` DESC [ RunTime:0.012761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276904 LIMIT 2 [ RunTime:0.032814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276904 ORDER BY `minOrder` ASC [ RunTime:0.005817s ]
select * from pdf where partno='KPT-150MM' and brandshort='Bertech' limit 1 [ RunTime:0.022922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-150MM' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.026948s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276904 AND `partno` = 'KPT-150MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.012587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257265 [ RunTime:0.007339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276881 LIMIT 5 [ RunTime:0.015639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276881 ORDER BY `minOrder` ASC [ RunTime:0.011128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276881 ORDER BY `unit` DESC [ RunTime:0.022375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276881 LIMIT 2 [ RunTime:0.024686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276881 ORDER BY `minOrder` ASC [ RunTime:0.010527s ]
select * from pdf where partno='KPT-100MM' and brandshort='Bertech' limit 1 [ RunTime:0.027321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-100MM' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.006153s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276881 AND `partno` = 'KPT-100MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.015565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12272662 [ RunTime:0.019076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276817 LIMIT 5 [ RunTime:0.015662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276817 ORDER BY `minOrder` ASC [ RunTime:0.036247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276817 ORDER BY `unit` DESC [ RunTime:0.017409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276817 LIMIT 2 [ RunTime:0.003402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276817 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
select * from pdf where partno='KPT-1 3/4' and brandshort='Bertech' limit 1 [ RunTime:0.019795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1 3/4' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.042551s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276817 AND `partno` = 'KPT-1 3/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.022544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12272643 [ RunTime:0.015942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64276639 LIMIT 5 [ RunTime:0.033618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276639 ORDER BY `minOrder` ASC [ RunTime:0.024199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64276639 ORDER BY `unit` DESC [ RunTime:0.041999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64276639 LIMIT 2 [ RunTime:0.023273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64276639 ORDER BY `minOrder` ASC [ RunTime:0.034256s ]
select * from pdf where partno='KPT-1 1/2' and brandshort='Bertech' limit 1 [ RunTime:0.033237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-1 1/2' OR `brand` LIKE 'Bertech%' ) ) LIMIT 1 [ RunTime:0.065029s ]
SELECT `id` FROM `stock` WHERE `id` <> 64276639 AND `partno` = 'KPT-1 1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bertech%' ) [ RunTime:0.118775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11252432 [ RunTime:0.116311s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054039s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.109382s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.114380s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022916s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094442s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048387s ]
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 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062179s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'KPT-1%' OR `brand` LIKE 'KPT-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.068631s ]