SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002256s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033725s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12707016 LIMIT 5 [ RunTime:0.027263s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12707016 ORDER BY `minOrder` ASC [ RunTime:0.011136s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12707016 ORDER BY `unit` DESC [ RunTime:0.049782s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12707016 LIMIT 2 [ RunTime:0.021343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12707016 ORDER BY `minOrder` ASC [ RunTime:0.020621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664240 LIMIT 5 [ RunTime:0.035591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664240 ORDER BY `minOrder` ASC [ RunTime:0.053886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12664240 ORDER BY `unit` DESC [ RunTime:0.009106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12664240 LIMIT 2 [ RunTime:0.034819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664240 ORDER BY `minOrder` ASC [ RunTime:0.031828s ]
select * from pdf where partno='CLM-132-02-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663472 LIMIT 5 [ RunTime:0.024157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663472 ORDER BY `minOrder` ASC [ RunTime:0.027426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663472 ORDER BY `unit` DESC [ RunTime:0.043661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663472 LIMIT 2 [ RunTime:0.042443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663472 ORDER BY `minOrder` ASC [ RunTime:0.032671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12652630 LIMIT 5 [ RunTime:0.024103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12652630 ORDER BY `minOrder` ASC [ RunTime:0.008598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12652630 ORDER BY `unit` DESC [ RunTime:0.041031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12652630 LIMIT 2 [ RunTime:0.045823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12652630 ORDER BY `minOrder` ASC [ RunTime:0.008300s ]
select * from pdf where partno='CLM-132-02-F-D-BE-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12652629 LIMIT 5 [ RunTime:0.025905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12652629 ORDER BY `minOrder` ASC [ RunTime:0.019780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12652629 ORDER BY `unit` DESC [ RunTime:0.002053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12652629 LIMIT 2 [ RunTime:0.009267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12652629 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
select * from pdf where partno='CLM-132-02-F-D-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12652437 LIMIT 5 [ RunTime:0.017755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12652437 ORDER BY `minOrder` ASC [ RunTime:0.017507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12652437 ORDER BY `unit` DESC [ RunTime:0.016695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12652437 LIMIT 2 [ RunTime:0.000965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12652437 ORDER BY `minOrder` ASC [ RunTime:0.010294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633993 LIMIT 5 [ RunTime:0.012306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633993 ORDER BY `minOrder` ASC [ RunTime:0.023470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12633993 ORDER BY `unit` DESC [ RunTime:0.018504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12633993 LIMIT 2 [ RunTime:0.009568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633993 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633381 LIMIT 5 [ RunTime:0.007105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633381 ORDER BY `minOrder` ASC [ RunTime:0.006248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12633381 ORDER BY `unit` DESC [ RunTime:0.043350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12633381 LIMIT 2 [ RunTime:0.018491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633381 ORDER BY `minOrder` ASC [ RunTime:0.014025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538136 LIMIT 5 [ RunTime:0.037118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11538136 ORDER BY `minOrder` ASC [ RunTime:0.024965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11538136 ORDER BY `unit` DESC [ RunTime:0.022348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11538136 LIMIT 2 [ RunTime:0.011696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11538136 ORDER BY `minOrder` ASC [ RunTime:0.008915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523526 LIMIT 5 [ RunTime:0.025441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523526 ORDER BY `minOrder` ASC [ RunTime:0.014864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11523526 ORDER BY `unit` DESC [ RunTime:0.006161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11523526 LIMIT 2 [ RunTime:0.008111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523526 ORDER BY `minOrder` ASC [ RunTime:0.013059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523512 LIMIT 5 [ RunTime:0.016116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523512 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11523512 ORDER BY `unit` DESC [ RunTime:0.003394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11523512 LIMIT 2 [ RunTime:0.008832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523512 ORDER BY `minOrder` ASC [ RunTime:0.001280s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005170s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59887432 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887432 ORDER BY `minOrder` ASC [ RunTime:0.002986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59887432 ORDER BY `unit` DESC [ RunTime:0.017204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59887432 LIMIT 2 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887432 ORDER BY `minOrder` ASC [ RunTime:0.016820s ]
select * from pdf where partno='CLM-132-02-F-D-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001198s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005606s ]
SELECT `id` FROM `stock` WHERE `id` <> 59887432 AND `partno` = 'CLM-132-02-F-D-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59887171 LIMIT 5 [ RunTime:0.003386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887171 ORDER BY `minOrder` ASC [ RunTime:0.008455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59887171 ORDER BY `unit` DESC [ RunTime:0.002009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59887171 LIMIT 2 [ RunTime:0.006227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887171 ORDER BY `minOrder` ASC [ RunTime:0.002175s ]
select * from pdf where partno='CLM-132-02-F-D-BE-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001825s ]
SELECT `id` FROM `stock` WHERE `id` <> 59887171 AND `partno` = 'CLM-132-02-F-D-BE-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12652630 [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59887170 LIMIT 5 [ RunTime:0.005130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887170 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59887170 ORDER BY `unit` DESC [ RunTime:0.010116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59887170 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887170 ORDER BY `minOrder` ASC [ RunTime:0.004446s ]
select * from pdf where partno='CLM-132-02-F-D-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007377s ]
SELECT `id` FROM `stock` WHERE `id` <> 59887170 AND `partno` = 'CLM-132-02-F-D-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12652629 [ RunTime:0.001792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59887071 LIMIT 5 [ RunTime:0.003151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887071 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59887071 ORDER BY `unit` DESC [ RunTime:0.001993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59887071 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59887071 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='CLM-132-02-F-D-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002188s ]
SELECT `id` FROM `stock` WHERE `id` <> 59887071 AND `partno` = 'CLM-132-02-F-D-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59886770 LIMIT 5 [ RunTime:0.004201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886770 ORDER BY `minOrder` ASC [ RunTime:0.006981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59886770 ORDER BY `unit` DESC [ RunTime:0.001466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59886770 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886770 ORDER BY `minOrder` ASC [ RunTime:0.006364s ]
select * from pdf where partno='CLM-132-02-F-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002389s ]
SELECT `id` FROM `stock` WHERE `id` <> 59886770 AND `partno` = 'CLM-132-02-F-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12652437 [ RunTime:0.001543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59886618 LIMIT 5 [ RunTime:0.003150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886618 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59886618 ORDER BY `unit` DESC [ RunTime:0.004457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59886618 LIMIT 2 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886618 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
select * from pdf where partno='CLM-132-02-F-D-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000630s ]
SELECT `id` FROM `stock` WHERE `id` <> 59886618 AND `partno` = 'CLM-132-02-F-D-BE-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59885040 LIMIT 5 [ RunTime:0.003635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59885040 ORDER BY `minOrder` ASC [ RunTime:0.020409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59885040 ORDER BY `unit` DESC [ RunTime:0.003245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59885040 LIMIT 2 [ RunTime:0.009863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59885040 ORDER BY `minOrder` ASC [ RunTime:0.002974s ]
select * from pdf where partno='CLM-132-02-F-D-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027974s ]
SELECT `id` FROM `stock` WHERE `id` <> 59885040 AND `partno` = 'CLM-132-02-F-D-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59884134 LIMIT 5 [ RunTime:0.017018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59884134 ORDER BY `minOrder` ASC [ RunTime:0.020740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59884134 ORDER BY `unit` DESC [ RunTime:0.010391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59884134 LIMIT 2 [ RunTime:0.003819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59884134 ORDER BY `minOrder` ASC [ RunTime:0.005814s ]
select * from pdf where partno='CLM-132-02-F-D-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021577s ]
SELECT `id` FROM `stock` WHERE `id` <> 59884134 AND `partno` = 'CLM-132-02-F-D-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59855394 LIMIT 5 [ RunTime:0.017820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59855394 ORDER BY `minOrder` ASC [ RunTime:0.028916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59855394 ORDER BY `unit` DESC [ RunTime:0.004083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59855394 LIMIT 2 [ RunTime:0.011365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59855394 ORDER BY `minOrder` ASC [ RunTime:0.008349s ]
select * from pdf where partno='CLM-132-02-F-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024601s ]
SELECT `id` FROM `stock` WHERE `id` <> 59855394 AND `partno` = 'CLM-132-02-F-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.048716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633993 [ RunTime:0.013396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59854058 LIMIT 5 [ RunTime:0.013577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854058 ORDER BY `minOrder` ASC [ RunTime:0.040299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59854058 ORDER BY `unit` DESC [ RunTime:0.052552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59854058 LIMIT 2 [ RunTime:0.026337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854058 ORDER BY `minOrder` ASC [ RunTime:0.038824s ]
select * from pdf where partno='CLM-132-02-F-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010591s ]
SELECT `id` FROM `stock` WHERE `id` <> 59854058 AND `partno` = 'CLM-132-02-F-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633381 [ RunTime:0.036281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59852831 LIMIT 5 [ RunTime:0.017093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852831 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59852831 ORDER BY `unit` DESC [ RunTime:0.005781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59852831 LIMIT 2 [ RunTime:0.012278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852831 ORDER BY `minOrder` ASC [ RunTime:0.019949s ]
select * from pdf where partno='CLM-132-02-F-D-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007963s ]
SELECT `id` FROM `stock` WHERE `id` <> 59852831 AND `partno` = 'CLM-132-02-F-D-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59851833 LIMIT 5 [ RunTime:0.028406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59851833 ORDER BY `minOrder` ASC [ RunTime:0.010026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59851833 ORDER BY `unit` DESC [ RunTime:0.015506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59851833 LIMIT 2 [ RunTime:0.025723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59851833 ORDER BY `minOrder` ASC [ RunTime:0.009721s ]
select * from pdf where partno='CLM-132-02-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013682s ]
SELECT `id` FROM `stock` WHERE `id` <> 59851833 AND `partno` = 'CLM-132-02-F-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12707016 [ RunTime:0.009016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59832645 LIMIT 5 [ RunTime:0.025173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59832645 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59832645 ORDER BY `unit` DESC [ RunTime:0.009912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59832645 LIMIT 2 [ RunTime:0.006641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59832645 ORDER BY `minOrder` ASC [ RunTime:0.007277s ]
select * from pdf where partno='CLM-132-02-F-D-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033184s ]
SELECT `id` FROM `stock` WHERE `id` <> 59832645 AND `partno` = 'CLM-132-02-F-D-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538136 [ RunTime:0.007612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59830709 LIMIT 5 [ RunTime:0.018122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830709 ORDER BY `minOrder` ASC [ RunTime:0.024981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59830709 ORDER BY `unit` DESC [ RunTime:0.022332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59830709 LIMIT 2 [ RunTime:0.038404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830709 ORDER BY `minOrder` ASC [ RunTime:0.049321s ]
select * from pdf where partno='CLM-132-02-F-D-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029974s ]
SELECT `id` FROM `stock` WHERE `id` <> 59830709 AND `partno` = 'CLM-132-02-F-D-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59781576 LIMIT 5 [ RunTime:0.021511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59781576 ORDER BY `minOrder` ASC [ RunTime:0.035062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59781576 ORDER BY `unit` DESC [ RunTime:0.004256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59781576 LIMIT 2 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59781576 ORDER BY `minOrder` ASC [ RunTime:0.009841s ]
select * from pdf where partno='CLM-132-02-F-D-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009738s ]
SELECT `id` FROM `stock` WHERE `id` <> 59781576 AND `partno` = 'CLM-132-02-F-D-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523526 [ RunTime:0.032863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59781535 LIMIT 5 [ RunTime:0.033262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59781535 ORDER BY `minOrder` ASC [ RunTime:0.038673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59781535 ORDER BY `unit` DESC [ RunTime:0.017416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59781535 LIMIT 2 [ RunTime:0.027555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59781535 ORDER BY `minOrder` ASC [ RunTime:0.020199s ]
select * from pdf where partno='CLM-132-02-F-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018524s ]
SELECT `id` FROM `stock` WHERE `id` <> 59781535 AND `partno` = 'CLM-132-02-F-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523512 [ RunTime:0.026986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59768343 LIMIT 5 [ RunTime:0.040496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59768343 ORDER BY `minOrder` ASC [ RunTime:0.018080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59768343 ORDER BY `unit` DESC [ RunTime:0.035046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59768343 LIMIT 2 [ RunTime:0.060115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59768343 ORDER BY `minOrder` ASC [ RunTime:0.014361s ]
select * from pdf where partno='CLM-132-02-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022940s ]
SELECT `id` FROM `stock` WHERE `id` <> 59768343 AND `partno` = 'CLM-132-02-F-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.055612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664240 [ RunTime:0.038161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59765927 LIMIT 5 [ RunTime:0.023885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765927 ORDER BY `minOrder` ASC [ RunTime:0.048436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59765927 ORDER BY `unit` DESC [ RunTime:0.033637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59765927 LIMIT 2 [ RunTime:0.013955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765927 ORDER BY `minOrder` ASC [ RunTime:0.007990s ]
select * from pdf where partno='CLM-132-02-F-D-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.087809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-132-02-F-D-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034493s ]
SELECT `id` FROM `stock` WHERE `id` <> 59765927 AND `partno` = 'CLM-132-02-F-D-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.062980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663472 [ RunTime:0.086618s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.095244s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038044s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098076s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025235s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044416s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038993s ]
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 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051242s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLM-132-02-F-D%' OR `brand` LIKE 'CLM-132-02-F-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.046472s ]