SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001506s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028538s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12608921 LIMIT 5 [ RunTime:0.012370s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12608921 ORDER BY `minOrder` ASC [ RunTime:0.024317s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12608921 ORDER BY `unit` DESC [ RunTime:0.009737s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12608921 LIMIT 2 [ RunTime:0.005865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12608921 ORDER BY `minOrder` ASC [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6680 LIMIT 5 [ RunTime:0.014451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6680 ORDER BY `minOrder` ASC [ RunTime:0.006214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6680 ORDER BY `unit` DESC [ RunTime:0.013215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6680 LIMIT 2 [ RunTime:0.008565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6680 ORDER BY `minOrder` ASC [ RunTime:0.016489s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375819-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.014987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12620020 LIMIT 5 [ RunTime:0.001328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12620020 ORDER BY `minOrder` ASC [ RunTime:0.006629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12620020 ORDER BY `unit` DESC [ RunTime:0.006036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12620020 LIMIT 2 [ RunTime:0.007930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12620020 ORDER BY `minOrder` ASC [ RunTime:0.008338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3270 LIMIT 5 [ RunTime:0.001064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3270 ORDER BY `minOrder` ASC [ RunTime:0.008173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3270 ORDER BY `unit` DESC [ RunTime:0.004251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3270 LIMIT 2 [ RunTime:0.002474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3270 ORDER BY `minOrder` ASC [ RunTime:0.005943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610632 LIMIT 5 [ RunTime:0.008257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610632 ORDER BY `minOrder` ASC [ RunTime:0.002959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610632 ORDER BY `unit` DESC [ RunTime:0.008012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610632 LIMIT 2 [ RunTime:0.007265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610632 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487592 LIMIT 5 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487592 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487592 ORDER BY `unit` DESC [ RunTime:0.001978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487592 LIMIT 2 [ RunTime:0.004302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487592 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631021 LIMIT 5 [ RunTime:0.001867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631021 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12631021 ORDER BY `unit` DESC [ RunTime:0.008763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12631021 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631021 ORDER BY `minOrder` ASC [ RunTime:0.005683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611144 LIMIT 5 [ RunTime:0.002382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611144 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611144 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611144 LIMIT 2 [ RunTime:0.003139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611144 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2661 LIMIT 5 [ RunTime:0.005455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2661 ORDER BY `minOrder` ASC [ RunTime:0.002463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2661 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2661 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2661 ORDER BY `minOrder` ASC [ RunTime:0.007662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12622222 LIMIT 5 [ RunTime:0.003064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12622222 ORDER BY `minOrder` ASC [ RunTime:0.003774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12622222 ORDER BY `unit` DESC [ RunTime:0.022078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12622222 LIMIT 2 [ RunTime:0.007057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12622222 ORDER BY `minOrder` ASC [ RunTime:0.005131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619479 LIMIT 5 [ RunTime:0.008479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619479 ORDER BY `minOrder` ASC [ RunTime:0.015747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619479 ORDER BY `unit` DESC [ RunTime:0.011871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619479 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619479 ORDER BY `minOrder` ASC [ RunTime:0.008508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616435 LIMIT 5 [ RunTime:0.001921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616435 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616435 ORDER BY `unit` DESC [ RunTime:0.003269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616435 LIMIT 2 [ RunTime:0.018512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616435 ORDER BY `minOrder` ASC [ RunTime:0.010494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489107 LIMIT 5 [ RunTime:0.013680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489107 ORDER BY `minOrder` ASC [ RunTime:0.005713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489107 ORDER BY `unit` DESC [ RunTime:0.005424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489107 LIMIT 2 [ RunTime:0.001474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489107 ORDER BY `minOrder` ASC [ RunTime:0.002985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616478 LIMIT 5 [ RunTime:0.005094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616478 ORDER BY `minOrder` ASC [ RunTime:0.003496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616478 ORDER BY `unit` DESC [ RunTime:0.004120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616478 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616478 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3271 LIMIT 5 [ RunTime:0.002297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3271 ORDER BY `minOrder` ASC [ RunTime:0.008046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3271 ORDER BY `unit` DESC [ RunTime:0.001382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3271 LIMIT 2 [ RunTime:0.005670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3271 ORDER BY `minOrder` ASC [ RunTime:0.003756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-8' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618873 LIMIT 5 [ RunTime:0.015461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618873 ORDER BY `minOrder` ASC [ RunTime:0.016438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618873 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618873 LIMIT 2 [ RunTime:0.012409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618873 ORDER BY `minOrder` ASC [ RunTime:0.003272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11403817 LIMIT 5 [ RunTime:0.012711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11403817 ORDER BY `minOrder` ASC [ RunTime:0.003982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11403817 ORDER BY `unit` DESC [ RunTime:0.007953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11403817 LIMIT 2 [ RunTime:0.002939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11403817 ORDER BY `minOrder` ASC [ RunTime:0.007042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11405476 LIMIT 5 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405476 ORDER BY `minOrder` ASC [ RunTime:0.007444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11405476 ORDER BY `unit` DESC [ RunTime:0.009130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11405476 LIMIT 2 [ RunTime:0.011044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405476 ORDER BY `minOrder` ASC [ RunTime:0.008264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11405475 LIMIT 5 [ RunTime:0.010607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405475 ORDER BY `minOrder` ASC [ RunTime:0.003609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11405475 ORDER BY `unit` DESC [ RunTime:0.029236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11405475 LIMIT 2 [ RunTime:0.006073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405475 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606116 LIMIT 5 [ RunTime:0.003522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606116 ORDER BY `minOrder` ASC [ RunTime:0.007636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606116 ORDER BY `unit` DESC [ RunTime:0.001771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606116 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606116 ORDER BY `minOrder` ASC [ RunTime:0.001296s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269834 LIMIT 5 [ RunTime:0.007022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269834 ORDER BY `minOrder` ASC [ RunTime:0.024295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269834 ORDER BY `unit` DESC [ RunTime:0.024472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269834 LIMIT 2 [ RunTime:0.027723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269834 ORDER BY `minOrder` ASC [ RunTime:0.001764s ]
select * from pdf where partno='1375799-1' and brandshort='te connectivity' limit 1 [ RunTime:0.011912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375799-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.040958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269893 LIMIT 5 [ RunTime:0.030050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269893 ORDER BY `minOrder` ASC [ RunTime:0.027562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269893 ORDER BY `unit` DESC [ RunTime:0.029508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269893 LIMIT 2 [ RunTime:0.033408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269893 ORDER BY `minOrder` ASC [ RunTime:0.010179s ]
select * from pdf where partno='1375795-2' and brandshort='te connectivity' limit 1 [ RunTime:0.028299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375795-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.039097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269874 LIMIT 5 [ RunTime:0.013711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269874 ORDER BY `minOrder` ASC [ RunTime:0.020450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269874 ORDER BY `unit` DESC [ RunTime:0.014717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269874 LIMIT 2 [ RunTime:0.029289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269874 ORDER BY `minOrder` ASC [ RunTime:0.026602s ]
select * from pdf where partno='1375795-5' and brandshort='te connectivity' limit 1 [ RunTime:0.032311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375795-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.065423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270371 LIMIT 5 [ RunTime:0.026984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270371 ORDER BY `minOrder` ASC [ RunTime:0.013229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270371 ORDER BY `unit` DESC [ RunTime:0.007491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270371 LIMIT 2 [ RunTime:0.004592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270371 ORDER BY `minOrder` ASC [ RunTime:0.002466s ]
select * from pdf where partno='1375963-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.019399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375963-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.016001s ]
SELECT `id` FROM `stock` WHERE `id` <> 32270371 AND `partno` = '1375963-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.027508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270259 LIMIT 5 [ RunTime:0.019258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270259 ORDER BY `minOrder` ASC [ RunTime:0.015198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270259 ORDER BY `unit` DESC [ RunTime:0.017996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270259 LIMIT 2 [ RunTime:0.037399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270259 ORDER BY `minOrder` ASC [ RunTime:0.012119s ]
select * from pdf where partno='1375800-1' and brandshort='te connectivity' limit 1 [ RunTime:0.012645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375800-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.029733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270183 LIMIT 5 [ RunTime:0.038843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270183 ORDER BY `minOrder` ASC [ RunTime:0.010186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270183 ORDER BY `unit` DESC [ RunTime:0.029286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270183 LIMIT 2 [ RunTime:0.005735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270183 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
select * from pdf where partno='1375796-2' and brandshort='te connectivity' limit 1 [ RunTime:0.001206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375796-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270215 LIMIT 5 [ RunTime:0.003016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270215 ORDER BY `minOrder` ASC [ RunTime:0.010972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270215 ORDER BY `unit` DESC [ RunTime:0.009601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270215 LIMIT 2 [ RunTime:0.012874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270215 ORDER BY `minOrder` ASC [ RunTime:0.001879s ]
select * from pdf where partno='1375796-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375796-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.021117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270472 LIMIT 5 [ RunTime:0.015720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270472 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270472 ORDER BY `unit` DESC [ RunTime:0.003077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270472 LIMIT 2 [ RunTime:0.005488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270472 ORDER BY `minOrder` ASC [ RunTime:0.002993s ]
select * from pdf where partno='1375799-4' and brandshort='te connectivity' limit 1 [ RunTime:0.012938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375799-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.040410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270592 LIMIT 5 [ RunTime:0.029712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270592 ORDER BY `minOrder` ASC [ RunTime:0.093890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270592 ORDER BY `unit` DESC [ RunTime:0.009896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270592 LIMIT 2 [ RunTime:0.014300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270592 ORDER BY `minOrder` ASC [ RunTime:0.019213s ]
select * from pdf where partno='1375967-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375967-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.035436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104562 LIMIT 5 [ RunTime:0.014426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104562 ORDER BY `minOrder` ASC [ RunTime:0.006811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104562 ORDER BY `unit` DESC [ RunTime:0.003951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104562 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104562 ORDER BY `minOrder` ASC [ RunTime:0.008461s ]
select * from pdf where partno='1375' and brandshort='adafruit' limit 1 [ RunTime:0.005115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.018546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082073 LIMIT 5 [ RunTime:0.008901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082073 ORDER BY `minOrder` ASC [ RunTime:0.010448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082073 ORDER BY `unit` DESC [ RunTime:0.019174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082073 LIMIT 2 [ RunTime:0.016082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082073 ORDER BY `minOrder` ASC [ RunTime:0.011091s ]
select * from pdf where partno='1375510000' and brandshort='weidmuller' limit 1 [ RunTime:0.001146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375510000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.011569s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082073 AND `partno` = '1375510000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.011442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866741 [ RunTime:0.001509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082452 LIMIT 5 [ RunTime:0.013139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082452 ORDER BY `minOrder` ASC [ RunTime:0.015545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082452 ORDER BY `unit` DESC [ RunTime:0.000987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082452 LIMIT 2 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082452 ORDER BY `minOrder` ASC [ RunTime:0.005547s ]
select * from pdf where partno='1375480000' and brandshort='weidmuller' limit 1 [ RunTime:0.020963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375480000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.007798s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082452 AND `partno` = '1375480000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.010347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866826 [ RunTime:0.008571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082451 LIMIT 5 [ RunTime:0.002965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082451 ORDER BY `minOrder` ASC [ RunTime:0.023340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082451 ORDER BY `unit` DESC [ RunTime:0.007048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082451 LIMIT 2 [ RunTime:0.004631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082451 ORDER BY `minOrder` ASC [ RunTime:0.004227s ]
select * from pdf where partno='1375470000' and brandshort='weidmuller' limit 1 [ RunTime:0.018080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375470000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.011422s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082451 AND `partno` = '1375470000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.010078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026327 [ RunTime:0.008939s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525112 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525112 ORDER BY `minOrder` ASC [ RunTime:0.007785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525112 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525112 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525112 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
select * from pdf where partno='1375819-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375819-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53076789 LIMIT 5 [ RunTime:0.003083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076789 ORDER BY `minOrder` ASC [ RunTime:0.003839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53076789 ORDER BY `unit` DESC [ RunTime:0.005631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53076789 LIMIT 2 [ RunTime:0.002047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076789 ORDER BY `minOrder` ASC [ RunTime:0.005292s ]
select * from pdf where partno='1375820-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525491 LIMIT 5 [ RunTime:0.004460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525491 ORDER BY `minOrder` ASC [ RunTime:0.014670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525491 ORDER BY `unit` DESC [ RunTime:0.002269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525491 LIMIT 2 [ RunTime:0.004935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525491 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='1375819-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375819-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015838s ]
SELECT `id` FROM `stock` WHERE `id` <> 53525491 AND `partno` = '1375819-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610632 [ RunTime:0.010999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53075889 LIMIT 5 [ RunTime:0.013065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53075889 ORDER BY `minOrder` ASC [ RunTime:0.006057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53075889 ORDER BY `unit` DESC [ RunTime:0.001400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53075889 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53075889 ORDER BY `minOrder` ASC [ RunTime:0.012129s ]
select * from pdf where partno='1375820-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525560 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525560 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525560 ORDER BY `unit` DESC [ RunTime:0.004492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525560 LIMIT 2 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525560 ORDER BY `minOrder` ASC [ RunTime:0.011016s ]
select * from pdf where partno='1375819-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375819-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018650s ]
SELECT `id` FROM `stock` WHERE `id` <> 53525560 AND `partno` = '1375819-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611144 [ RunTime:0.005868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53074982 LIMIT 5 [ RunTime:0.022114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53074982 ORDER BY `minOrder` ASC [ RunTime:0.005603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53074982 ORDER BY `unit` DESC [ RunTime:0.008546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53074982 LIMIT 2 [ RunTime:0.008888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53074982 ORDER BY `minOrder` ASC [ RunTime:0.027656s ]
select * from pdf where partno='1375820-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53076817 LIMIT 5 [ RunTime:0.002464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076817 ORDER BY `minOrder` ASC [ RunTime:0.015077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53076817 ORDER BY `unit` DESC [ RunTime:0.014916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53076817 LIMIT 2 [ RunTime:0.007140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076817 ORDER BY `minOrder` ASC [ RunTime:0.008041s ]
select * from pdf where partno='1375820-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008993s ]
SELECT `id` FROM `stock` WHERE `id` <> 53076817 AND `partno` = '1375820-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12622222 [ RunTime:0.014596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53075715 LIMIT 5 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53075715 ORDER BY `minOrder` ASC [ RunTime:0.025793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53075715 ORDER BY `unit` DESC [ RunTime:0.015782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53075715 LIMIT 2 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53075715 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='1375820-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.021538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53076634 LIMIT 5 [ RunTime:0.008203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076634 ORDER BY `minOrder` ASC [ RunTime:0.018983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53076634 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53076634 LIMIT 2 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076634 ORDER BY `minOrder` ASC [ RunTime:0.001095s ]
select * from pdf where partno='1375820-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003107s ]
SELECT `id` FROM `stock` WHERE `id` <> 53076634 AND `partno` = '1375820-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489107 [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53076280 LIMIT 5 [ RunTime:0.013143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076280 ORDER BY `minOrder` ASC [ RunTime:0.006690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53076280 ORDER BY `unit` DESC [ RunTime:0.002711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53076280 LIMIT 2 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076280 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
select * from pdf where partno='1375820-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004964s ]
SELECT `id` FROM `stock` WHERE `id` <> 53076280 AND `partno` = '1375820-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487592 [ RunTime:0.008944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54119874 LIMIT 5 [ RunTime:0.004578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119874 ORDER BY `minOrder` ASC [ RunTime:0.002194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54119874 ORDER BY `unit` DESC [ RunTime:0.006522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54119874 LIMIT 2 [ RunTime:0.004824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119874 ORDER BY `minOrder` ASC [ RunTime:0.001942s ]
select * from pdf where partno='1375795-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375795-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000478s ]
SELECT `id` FROM `stock` WHERE `id` <> 54119874 AND `partno` = '1375795-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53089588 LIMIT 5 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53089588 ORDER BY `minOrder` ASC [ RunTime:0.005644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53089588 ORDER BY `unit` DESC [ RunTime:0.001164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53089588 LIMIT 2 [ RunTime:0.005947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53089588 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='1375820-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006102s ]
SELECT `id` FROM `stock` WHERE `id` <> 53089588 AND `partno` = '1375820-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619479 [ RunTime:0.002097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53774964 LIMIT 5 [ RunTime:0.008574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53774964 ORDER BY `minOrder` ASC [ RunTime:0.008498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53774964 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53774964 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53774964 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='1375801-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375801-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004104s ]
SELECT `id` FROM `stock` WHERE `id` <> 53774964 AND `partno` = '1375801-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52899741 LIMIT 5 [ RunTime:0.007256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52899741 ORDER BY `minOrder` ASC [ RunTime:0.001664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52899741 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52899741 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52899741 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
select * from pdf where partno='1375870-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375870-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013109s ]
SELECT `id` FROM `stock` WHERE `id` <> 52899741 AND `partno` = '1375870-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12655438 [ RunTime:0.003882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53544696 LIMIT 5 [ RunTime:0.006843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53544696 ORDER BY `minOrder` ASC [ RunTime:0.010532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53544696 ORDER BY `unit` DESC [ RunTime:0.002079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53544696 LIMIT 2 [ RunTime:0.005999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53544696 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='1375618-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375618-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001960s ]
SELECT `id` FROM `stock` WHERE `id` <> 53544696 AND `partno` = '1375618-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616158 [ RunTime:0.008567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53085817 LIMIT 5 [ RunTime:0.003791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53085817 ORDER BY `minOrder` ASC [ RunTime:0.037356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53085817 ORDER BY `unit` DESC [ RunTime:0.006016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53085817 LIMIT 2 [ RunTime:0.002912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53085817 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='1375875-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375875-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009138s ]
SELECT `id` FROM `stock` WHERE `id` <> 53085817 AND `partno` = '1375875-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618873 [ RunTime:0.009437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54119855 LIMIT 5 [ RunTime:0.005627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119855 ORDER BY `minOrder` ASC [ RunTime:0.003393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54119855 ORDER BY `unit` DESC [ RunTime:0.000927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54119855 LIMIT 2 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119855 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='1375795-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375795-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010920s ]
SELECT `id` FROM `stock` WHERE `id` <> 54119855 AND `partno` = '1375795-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11402133 [ RunTime:0.008121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54119853 LIMIT 5 [ RunTime:0.007584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119853 ORDER BY `minOrder` ASC [ RunTime:0.006713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54119853 ORDER BY `unit` DESC [ RunTime:0.000780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54119853 LIMIT 2 [ RunTime:0.007976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119853 ORDER BY `minOrder` ASC [ RunTime:0.006830s ]
select * from pdf where partno='1375963-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375963-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002877s ]
SELECT `id` FROM `stock` WHERE `id` <> 54119853 AND `partno` = '1375963-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54119850 LIMIT 5 [ RunTime:0.000915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119850 ORDER BY `minOrder` ASC [ RunTime:0.001144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54119850 ORDER BY `unit` DESC [ RunTime:0.014116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54119850 LIMIT 2 [ RunTime:0.013945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119850 ORDER BY `minOrder` ASC [ RunTime:0.009614s ]
select * from pdf where partno='1375799-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375799-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001160s ]
SELECT `id` FROM `stock` WHERE `id` <> 54119850 AND `partno` = '1375799-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11392408 [ RunTime:0.023838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54120037 LIMIT 5 [ RunTime:0.008552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54120037 ORDER BY `minOrder` ASC [ RunTime:0.015694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54120037 ORDER BY `unit` DESC [ RunTime:0.016573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54120037 LIMIT 2 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54120037 ORDER BY `minOrder` ASC [ RunTime:0.003713s ]
select * from pdf where partno='1375967-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375967-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008914s ]
SELECT `id` FROM `stock` WHERE `id` <> 54120037 AND `partno` = '1375967-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003757s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019402s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012576s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002412s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003728s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012447s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011673s ]
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 '1375%' OR `brand` LIKE '1375%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008854s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1375%' OR `brand` LIKE '1375%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023511s ]