SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001891s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011565s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422452 LIMIT 5 [ RunTime:0.009313s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422452 ORDER BY `minOrder` ASC [ RunTime:0.009824s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422452 ORDER BY `unit` DESC [ RunTime:0.005489s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422452 LIMIT 2 [ RunTime:0.010401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422452 ORDER BY `minOrder` ASC [ RunTime:0.002054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765627 LIMIT 5 [ RunTime:0.018959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765627 ORDER BY `minOrder` ASC [ RunTime:0.005760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765627 ORDER BY `unit` DESC [ RunTime:0.023216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765627 LIMIT 2 [ RunTime:0.020593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765627 ORDER BY `minOrder` ASC [ RunTime:0.012996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765626 LIMIT 5 [ RunTime:0.019941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765626 ORDER BY `minOrder` ASC [ RunTime:0.038046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765626 ORDER BY `unit` DESC [ RunTime:0.021263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765626 LIMIT 2 [ RunTime:0.003136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765626 ORDER BY `minOrder` ASC [ RunTime:0.024593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765625 LIMIT 5 [ RunTime:0.035063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765625 ORDER BY `minOrder` ASC [ RunTime:0.028861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765625 ORDER BY `unit` DESC [ RunTime:0.037631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765625 LIMIT 2 [ RunTime:0.053093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765625 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765624 LIMIT 5 [ RunTime:0.008810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765624 ORDER BY `minOrder` ASC [ RunTime:0.034518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765624 ORDER BY `unit` DESC [ RunTime:0.034755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765624 LIMIT 2 [ RunTime:0.046935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765624 ORDER BY `minOrder` ASC [ RunTime:0.068035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765623 LIMIT 5 [ RunTime:0.001463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765623 ORDER BY `minOrder` ASC [ RunTime:0.057756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765623 ORDER BY `unit` DESC [ RunTime:0.056585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765623 LIMIT 2 [ RunTime:0.013168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765623 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765622 LIMIT 5 [ RunTime:0.060830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765622 ORDER BY `minOrder` ASC [ RunTime:0.046418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765622 ORDER BY `unit` DESC [ RunTime:0.107940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765622 LIMIT 2 [ RunTime:0.050445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765622 ORDER BY `minOrder` ASC [ RunTime:0.010343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765621 LIMIT 5 [ RunTime:0.024012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765621 ORDER BY `minOrder` ASC [ RunTime:0.018108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765621 ORDER BY `unit` DESC [ RunTime:0.050794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765621 LIMIT 2 [ RunTime:0.034932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765621 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17765620 LIMIT 5 [ RunTime:0.012423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765620 ORDER BY `minOrder` ASC [ RunTime:0.018652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17765620 ORDER BY `unit` DESC [ RunTime:0.060748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17765620 LIMIT 2 [ RunTime:0.050593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17765620 ORDER BY `minOrder` ASC [ RunTime:0.025686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779155 LIMIT 5 [ RunTime:0.050495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779155 ORDER BY `minOrder` ASC [ RunTime:0.038907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779155 ORDER BY `unit` DESC [ RunTime:0.050369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779155 LIMIT 2 [ RunTime:0.077140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779155 ORDER BY `minOrder` ASC [ RunTime:0.027120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779154 LIMIT 5 [ RunTime:0.027435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779154 ORDER BY `minOrder` ASC [ RunTime:0.022012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779154 ORDER BY `unit` DESC [ RunTime:0.011302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779154 LIMIT 2 [ RunTime:0.047040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779154 ORDER BY `minOrder` ASC [ RunTime:0.006200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779153 LIMIT 5 [ RunTime:0.031686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779153 ORDER BY `minOrder` ASC [ RunTime:0.005602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779153 ORDER BY `unit` DESC [ RunTime:0.021386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779153 LIMIT 2 [ RunTime:0.029571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779153 ORDER BY `minOrder` ASC [ RunTime:0.008705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779152 LIMIT 5 [ RunTime:0.033110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779152 ORDER BY `minOrder` ASC [ RunTime:0.010634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779152 ORDER BY `unit` DESC [ RunTime:0.035074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779152 LIMIT 2 [ RunTime:0.017353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779152 ORDER BY `minOrder` ASC [ RunTime:0.016945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779151 LIMIT 5 [ RunTime:0.016791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779151 ORDER BY `minOrder` ASC [ RunTime:0.022246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779151 ORDER BY `unit` DESC [ RunTime:0.012661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779151 LIMIT 2 [ RunTime:0.014393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779151 ORDER BY `minOrder` ASC [ RunTime:0.042786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779150 LIMIT 5 [ RunTime:0.026126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779150 ORDER BY `minOrder` ASC [ RunTime:0.019962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779150 ORDER BY `unit` DESC [ RunTime:0.014846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779150 LIMIT 2 [ RunTime:0.012095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779150 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779149 LIMIT 5 [ RunTime:0.008100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779149 ORDER BY `minOrder` ASC [ RunTime:0.021168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779149 ORDER BY `unit` DESC [ RunTime:0.018804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779149 LIMIT 2 [ RunTime:0.019066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779149 ORDER BY `minOrder` ASC [ RunTime:0.012698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16624325 LIMIT 5 [ RunTime:0.032532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16624325 ORDER BY `minOrder` ASC [ RunTime:0.017845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16624325 ORDER BY `unit` DESC [ RunTime:0.034418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16624325 LIMIT 2 [ RunTime:0.021990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16624325 ORDER BY `minOrder` ASC [ RunTime:0.015448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15678757 LIMIT 5 [ RunTime:0.075302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15678757 ORDER BY `minOrder` ASC [ RunTime:0.010274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15678757 ORDER BY `unit` DESC [ RunTime:0.021566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15678757 LIMIT 2 [ RunTime:0.003174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15678757 ORDER BY `minOrder` ASC [ RunTime:0.016655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15678756 LIMIT 5 [ RunTime:0.011060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15678756 ORDER BY `minOrder` ASC [ RunTime:0.017355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15678756 ORDER BY `unit` DESC [ RunTime:0.014379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15678756 LIMIT 2 [ RunTime:0.018123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15678756 ORDER BY `minOrder` ASC [ RunTime:0.016108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15678755 LIMIT 5 [ RunTime:0.025127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15678755 ORDER BY `minOrder` ASC [ RunTime:0.021632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15678755 ORDER BY `unit` DESC [ RunTime:0.034098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15678755 LIMIT 2 [ RunTime:0.014985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15678755 ORDER BY `minOrder` ASC [ RunTime:0.001706s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096864 LIMIT 5 [ RunTime:0.011581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096864 ORDER BY `minOrder` ASC [ RunTime:0.002962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096864 ORDER BY `unit` DESC [ RunTime:0.012158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096864 LIMIT 2 [ RunTime:0.007225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096864 ORDER BY `minOrder` ASC [ RunTime:0.010414s ]
select * from pdf where partno='3366' and brandshort='adafruit' limit 1 [ RunTime:0.011285s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.004922s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63125974 LIMIT 5 [ RunTime:0.006517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63125974 ORDER BY `minOrder` ASC [ RunTime:0.020647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63125974 ORDER BY `unit` DESC [ RunTime:0.017710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63125974 LIMIT 2 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63125974 ORDER BY `minOrder` ASC [ RunTime:0.002091s ]
select * from pdf where partno='3366' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000626s ]
SELECT `id` FROM `stock` WHERE `id` <> 63125974 AND `partno` = '3366' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422452 [ RunTime:0.009120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64556518 LIMIT 5 [ RunTime:0.013910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556518 ORDER BY `minOrder` ASC [ RunTime:0.015487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64556518 ORDER BY `unit` DESC [ RunTime:0.019287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64556518 LIMIT 2 [ RunTime:0.021197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556518 ORDER BY `minOrder` ASC [ RunTime:0.020091s ]
select * from pdf where partno='3366CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007823s ]
SELECT `id` FROM `stock` WHERE `id` <> 64556518 AND `partno` = '3366CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.024373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63360751 LIMIT 5 [ RunTime:0.015701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63360751 ORDER BY `minOrder` ASC [ RunTime:0.021602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63360751 ORDER BY `unit` DESC [ RunTime:0.009227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63360751 LIMIT 2 [ RunTime:0.019830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63360751 ORDER BY `minOrder` ASC [ RunTime:0.005142s ]
select * from pdf where partno='3366' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.015986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009784s ]
SELECT `id` FROM `stock` WHERE `id` <> 63360751 AND `partno` = '3366' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.026760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63410015 LIMIT 5 [ RunTime:0.005962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63410015 ORDER BY `minOrder` ASC [ RunTime:0.012486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63410015 ORDER BY `unit` DESC [ RunTime:0.003161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63410015 LIMIT 2 [ RunTime:0.011368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63410015 ORDER BY `minOrder` ASC [ RunTime:0.004955s ]
select * from pdf where partno='3366' and brandshort='80/20, LLC' limit 1 [ RunTime:0.006924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.001800s ]
SELECT `id` FROM `stock` WHERE `id` <> 63410015 AND `partno` = '3366' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63128719 LIMIT 5 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63128719 ORDER BY `minOrder` ASC [ RunTime:0.006385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63128719 ORDER BY `unit` DESC [ RunTime:0.007399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63128719 LIMIT 2 [ RunTime:0.004177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63128719 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='3366F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.007329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.008157s ]
SELECT `id` FROM `stock` WHERE `id` <> 63128719 AND `partno` = '3366F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.004779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62977730 LIMIT 5 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62977730 ORDER BY `minOrder` ASC [ RunTime:0.005315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62977730 ORDER BY `unit` DESC [ RunTime:0.005824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62977730 LIMIT 2 [ RunTime:0.002113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62977730 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='33662121000195' and brandshort='HARTING' limit 1 [ RunTime:0.001322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662121000195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.012109s ]
SELECT `id` FROM `stock` WHERE `id` <> 62977730 AND `partno` = '33662121000195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.003984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62977688 LIMIT 5 [ RunTime:0.003437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62977688 ORDER BY `minOrder` ASC [ RunTime:0.008533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62977688 ORDER BY `unit` DESC [ RunTime:0.003384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62977688 LIMIT 2 [ RunTime:0.013873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62977688 ORDER BY `minOrder` ASC [ RunTime:0.006972s ]
select * from pdf where partno='33662121000194' and brandshort='HARTING' limit 1 [ RunTime:0.003456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662121000194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002995s ]
SELECT `id` FROM `stock` WHERE `id` <> 62977688 AND `partno` = '33662121000194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.010385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975989 LIMIT 5 [ RunTime:0.010809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975989 ORDER BY `minOrder` ASC [ RunTime:0.024839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975989 ORDER BY `unit` DESC [ RunTime:0.045583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975989 LIMIT 2 [ RunTime:0.038026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975989 ORDER BY `minOrder` ASC [ RunTime:0.012063s ]
select * from pdf where partno='33662120750195' and brandshort='HARTING' limit 1 [ RunTime:0.009753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120750195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.022048s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975989 AND `partno` = '33662120750195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.020305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975987 LIMIT 5 [ RunTime:0.003131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975987 ORDER BY `minOrder` ASC [ RunTime:0.029145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975987 ORDER BY `unit` DESC [ RunTime:0.042621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975987 LIMIT 2 [ RunTime:0.013972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975987 ORDER BY `minOrder` ASC [ RunTime:0.003741s ]
select * from pdf where partno='33662120750194' and brandshort='HARTING' limit 1 [ RunTime:0.003205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120750194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004769s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975987 AND `partno` = '33662120750194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.009264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975986 LIMIT 5 [ RunTime:0.022531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975986 ORDER BY `minOrder` ASC [ RunTime:0.016043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975986 ORDER BY `unit` DESC [ RunTime:0.008232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975986 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975986 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='33662120500195' and brandshort='HARTING' limit 1 [ RunTime:0.002970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120500195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010196s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975986 AND `partno` = '33662120500195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975985 LIMIT 5 [ RunTime:0.006766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975985 ORDER BY `minOrder` ASC [ RunTime:0.000884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975985 ORDER BY `unit` DESC [ RunTime:0.000564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975985 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975985 ORDER BY `minOrder` ASC [ RunTime:0.005391s ]
select * from pdf where partno='33662120500194' and brandshort='HARTING' limit 1 [ RunTime:0.006424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120500194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004866s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975985 AND `partno` = '33662120500194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975983 LIMIT 5 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975983 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975983 ORDER BY `unit` DESC [ RunTime:0.011104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975983 LIMIT 2 [ RunTime:0.001862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975983 ORDER BY `minOrder` ASC [ RunTime:0.006011s ]
select * from pdf where partno='33662120300195' and brandshort='HARTING' limit 1 [ RunTime:0.012837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120300195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002841s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975983 AND `partno` = '33662120300195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.006347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975982 LIMIT 5 [ RunTime:0.002924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975982 ORDER BY `minOrder` ASC [ RunTime:0.007065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975982 ORDER BY `unit` DESC [ RunTime:0.008249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975982 LIMIT 2 [ RunTime:0.008176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975982 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='33662120300194' and brandshort='HARTING' limit 1 [ RunTime:0.002947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120300194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005853s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975982 AND `partno` = '33662120300194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975981 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975981 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975981 ORDER BY `unit` DESC [ RunTime:0.001898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975981 LIMIT 2 [ RunTime:0.007725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975981 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='33662120200195' and brandshort='HARTING' limit 1 [ RunTime:0.001042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120200195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001822s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975981 AND `partno` = '33662120200195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975980 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975980 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975980 ORDER BY `unit` DESC [ RunTime:0.001664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975980 LIMIT 2 [ RunTime:0.008089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975980 ORDER BY `minOrder` ASC [ RunTime:0.007899s ]
select * from pdf where partno='33662120200194' and brandshort='HARTING' limit 1 [ RunTime:0.003995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120200194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005634s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975980 AND `partno` = '33662120200194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.026574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975979 LIMIT 5 [ RunTime:0.025457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975979 ORDER BY `minOrder` ASC [ RunTime:0.007156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975979 ORDER BY `unit` DESC [ RunTime:0.009687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975979 LIMIT 2 [ RunTime:0.013334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975979 ORDER BY `minOrder` ASC [ RunTime:0.001879s ]
select * from pdf where partno='33662120100194' and brandshort='HARTING' limit 1 [ RunTime:0.012174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120100194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004563s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975979 AND `partno` = '33662120100194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975978 LIMIT 5 [ RunTime:0.001224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975978 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975978 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975978 LIMIT 2 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975978 ORDER BY `minOrder` ASC [ RunTime:0.008684s ]
select * from pdf where partno='33662120100195' and brandshort='HARTING' limit 1 [ RunTime:0.012053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120100195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002682s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975978 AND `partno` = '33662120100195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.004195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975977 LIMIT 5 [ RunTime:0.005050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975977 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975977 ORDER BY `unit` DESC [ RunTime:0.002549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975977 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975977 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='33662120050195' and brandshort='HARTING' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120050195' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004355s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975977 AND `partno` = '33662120050195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.010205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975975 LIMIT 5 [ RunTime:0.007400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975975 ORDER BY `minOrder` ASC [ RunTime:0.003843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975975 ORDER BY `unit` DESC [ RunTime:0.000752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975975 LIMIT 2 [ RunTime:0.003708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975975 ORDER BY `minOrder` ASC [ RunTime:0.013541s ]
select * from pdf where partno='33662120050194' and brandshort='HARTING' limit 1 [ RunTime:0.004830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33662120050194' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001476s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975975 AND `partno` = '33662120050194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61934588 LIMIT 5 [ RunTime:0.004081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61934588 ORDER BY `minOrder` ASC [ RunTime:0.001896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61934588 ORDER BY `unit` DESC [ RunTime:0.005697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61934588 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61934588 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='3366-1002' and brandshort='3M' limit 1 [ RunTime:0.001320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3366-1002' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.006147s ]
SELECT `id` FROM `stock` WHERE `id` <> 61934588 AND `partno` = '3366-1002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.006004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11861623 [ RunTime:0.002104s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005072s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010744s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002516s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001232s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015574s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001412s ]
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 '3366%' OR `brand` LIKE '3366%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005705s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3366%' OR `brand` LIKE '3366%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001957s ]