SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002787s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028827s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15560863 LIMIT 5 [ RunTime:0.026689s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560863 ORDER BY `minOrder` ASC [ RunTime:0.007608s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15560863 ORDER BY `unit` DESC [ RunTime:0.034990s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15560863 LIMIT 2 [ RunTime:0.021870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560863 ORDER BY `minOrder` ASC [ RunTime:0.029135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671486 LIMIT 5 [ RunTime:0.013637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671486 ORDER BY `minOrder` ASC [ RunTime:0.078258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671486 ORDER BY `unit` DESC [ RunTime:0.015311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671486 LIMIT 2 [ RunTime:0.023402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671486 ORDER BY `minOrder` ASC [ RunTime:0.013986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17915926 LIMIT 5 [ RunTime:0.021576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17915926 ORDER BY `minOrder` ASC [ RunTime:0.021757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17915926 ORDER BY `unit` DESC [ RunTime:0.025662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17915926 LIMIT 2 [ RunTime:0.007587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17915926 ORDER BY `minOrder` ASC [ RunTime:0.014763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379070 LIMIT 5 [ RunTime:0.017490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379070 ORDER BY `minOrder` ASC [ RunTime:0.028388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379070 ORDER BY `unit` DESC [ RunTime:0.013075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379070 LIMIT 2 [ RunTime:0.017433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379070 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14079862 LIMIT 5 [ RunTime:0.007571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14079862 ORDER BY `minOrder` ASC [ RunTime:0.001199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14079862 ORDER BY `unit` DESC [ RunTime:0.008062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14079862 LIMIT 2 [ RunTime:0.004302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14079862 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320949 LIMIT 5 [ RunTime:0.001110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320949 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320949 ORDER BY `unit` DESC [ RunTime:0.004565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320949 LIMIT 2 [ RunTime:0.008959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320949 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509750 LIMIT 5 [ RunTime:0.004207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509750 ORDER BY `minOrder` ASC [ RunTime:0.001750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509750 ORDER BY `unit` DESC [ RunTime:0.002821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509750 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509750 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='61128-0050' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509704 LIMIT 5 [ RunTime:0.001912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509704 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509704 ORDER BY `unit` DESC [ RunTime:0.002680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509704 LIMIT 2 [ RunTime:0.005869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509704 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509699 LIMIT 5 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509699 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509699 ORDER BY `unit` DESC [ RunTime:0.002547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509699 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509699 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509694 LIMIT 5 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509694 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509694 ORDER BY `unit` DESC [ RunTime:0.000813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509694 LIMIT 2 [ RunTime:0.006549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509694 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
select * from pdf where partno='61127-0522' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509683 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509683 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509683 ORDER BY `unit` DESC [ RunTime:0.000969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509683 LIMIT 2 [ RunTime:0.003886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509683 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509209 LIMIT 5 [ RunTime:0.002497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509209 ORDER BY `minOrder` ASC [ RunTime:0.003298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509209 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509209 LIMIT 2 [ RunTime:0.001475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509209 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509106 LIMIT 5 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509106 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509106 ORDER BY `unit` DESC [ RunTime:0.001582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509106 LIMIT 2 [ RunTime:0.001276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509106 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509104 LIMIT 5 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509104 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509104 ORDER BY `unit` DESC [ RunTime:0.001595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509104 LIMIT 2 [ RunTime:0.002096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509104 ORDER BY `minOrder` ASC [ RunTime:0.003084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509103 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509103 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509103 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509103 LIMIT 2 [ RunTime:0.001355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509103 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509102 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509102 ORDER BY `minOrder` ASC [ RunTime:0.009204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509102 ORDER BY `unit` DESC [ RunTime:0.000769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509102 LIMIT 2 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509102 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412684 LIMIT 5 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412684 ORDER BY `minOrder` ASC [ RunTime:0.002738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412684 ORDER BY `unit` DESC [ RunTime:0.001831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412684 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412684 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412675 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412675 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412675 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412675 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412675 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='61127-5543' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412550 LIMIT 5 [ RunTime:0.016819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412550 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412550 ORDER BY `unit` DESC [ RunTime:0.002054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412550 LIMIT 2 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412550 ORDER BY `minOrder` ASC [ RunTime:0.001423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412381 LIMIT 5 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412381 ORDER BY `minOrder` ASC [ RunTime:0.002524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412381 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412381 LIMIT 2 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412381 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002168s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54170136 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54170136 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54170136 ORDER BY `unit` DESC [ RunTime:0.005406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54170136 LIMIT 2 [ RunTime:0.006068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54170136 ORDER BY `minOrder` ASC [ RunTime:0.001748s ]
select * from pdf where partno='61126-050CAHLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000782s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61126-050CAHLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001481s ]
SELECT `id` FROM `stock` WHERE `id` <> 54170136 AND `partno` = '61126-050CAHLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412550 [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53812158 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53812158 ORDER BY `minOrder` ASC [ RunTime:0.014079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53812158 ORDER BY `unit` DESC [ RunTime:0.002180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53812158 LIMIT 2 [ RunTime:0.006657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53812158 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='6112-1K' and brandshort='3M' limit 1 [ RunTime:0.000529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6112-1K' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.007200s ]
SELECT `id` FROM `stock` WHERE `id` <> 53812158 AND `partno` = '6112-1K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.003104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671486 [ RunTime:0.002229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575754 LIMIT 5 [ RunTime:0.001053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575754 ORDER BY `minOrder` ASC [ RunTime:0.008218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575754 ORDER BY `unit` DESC [ RunTime:0.005024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575754 LIMIT 2 [ RunTime:0.003881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575754 ORDER BY `minOrder` ASC [ RunTime:0.001452s ]
select * from pdf where partno='6112204000102' and brandshort='HARTING' limit 1 [ RunTime:0.001367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6112204000102' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009983s ]
SELECT `id` FROM `stock` WHERE `id` <> 53575754 AND `partno` = '6112204000102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.004393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15560863 [ RunTime:0.008042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53551939 LIMIT 5 [ RunTime:0.001839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53551939 ORDER BY `minOrder` ASC [ RunTime:0.005936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53551939 ORDER BY `unit` DESC [ RunTime:0.003650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53551939 LIMIT 2 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53551939 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
select * from pdf where partno='6112' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6112' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.015157s ]
SELECT `id` FROM `stock` WHERE `id` <> 53551939 AND `partno` = '6112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.006500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141964 LIMIT 5 [ RunTime:0.008698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141964 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141964 ORDER BY `unit` DESC [ RunTime:0.002271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141964 LIMIT 2 [ RunTime:0.003989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141964 ORDER BY `minOrder` ASC [ RunTime:0.007500s ]
select * from pdf where partno='6112-EP-252E' and brandshort='Ohmite' limit 1 [ RunTime:0.003121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6112-EP-252E' OR `brand` LIKE 'Ohmite%' ) ) LIMIT 1 [ RunTime:0.005415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141902 LIMIT 5 [ RunTime:0.006484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141902 ORDER BY `minOrder` ASC [ RunTime:0.004975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141902 ORDER BY `unit` DESC [ RunTime:0.001778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141902 LIMIT 2 [ RunTime:0.006848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141902 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
select * from pdf where partno='6112A-EN-170E' and brandshort='Ohmite' limit 1 [ RunTime:0.012039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6112A-EN-170E' OR `brand` LIKE 'Ohmite%' ) ) LIMIT 1 [ RunTime:0.011308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49545941 LIMIT 5 [ RunTime:0.005982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49545941 ORDER BY `minOrder` ASC [ RunTime:0.012901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49545941 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49545941 LIMIT 2 [ RunTime:0.006316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49545941 ORDER BY `minOrder` ASC [ RunTime:0.005021s ]
select * from pdf where partno='61120' and brandshort='Weidmüller' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61120' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 49545941 AND `partno` = '61120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320949 [ RunTime:0.008301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49199875 LIMIT 5 [ RunTime:0.001701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49199875 ORDER BY `minOrder` ASC [ RunTime:0.005818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49199875 ORDER BY `unit` DESC [ RunTime:0.005966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49199875 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49199875 ORDER BY `minOrder` ASC [ RunTime:0.005222s ]
select * from pdf where partno='611205' and brandshort='LAPP' limit 1 [ RunTime:0.001183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '611205' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.010931s ]
SELECT `id` FROM `stock` WHERE `id` <> 49199875 AND `partno` = '611205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.010996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379070 [ RunTime:0.000724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43817412 LIMIT 5 [ RunTime:0.003250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43817412 ORDER BY `minOrder` ASC [ RunTime:0.017382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43817412 ORDER BY `unit` DESC [ RunTime:0.007843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43817412 LIMIT 2 [ RunTime:0.010573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43817412 ORDER BY `minOrder` ASC [ RunTime:0.013783s ]
select * from pdf where partno='61125121-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.003211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61125121-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.005630s ]
SELECT `id` FROM `stock` WHERE `id` <> 43817412 AND `partno` = '61125121-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.006633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43800279 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43800279 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43800279 ORDER BY `unit` DESC [ RunTime:0.008301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43800279 LIMIT 2 [ RunTime:0.002354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43800279 ORDER BY `minOrder` ASC [ RunTime:0.005652s ]
select * from pdf where partno='61121182-E-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61121182-E-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.011197s ]
SELECT `id` FROM `stock` WHERE `id` <> 43800279 AND `partno` = '61121182-E-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.001026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43800262 LIMIT 5 [ RunTime:0.006732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43800262 ORDER BY `minOrder` ASC [ RunTime:0.003195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43800262 ORDER BY `unit` DESC [ RunTime:0.003778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43800262 LIMIT 2 [ RunTime:0.003761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43800262 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='61121162-E-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.006285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61121162-E-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.004723s ]
SELECT `id` FROM `stock` WHERE `id` <> 43800262 AND `partno` = '61121162-E-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.004175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43787871 LIMIT 5 [ RunTime:0.001193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43787871 ORDER BY `minOrder` ASC [ RunTime:0.004461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43787871 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43787871 LIMIT 2 [ RunTime:0.005791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43787871 ORDER BY `minOrder` ASC [ RunTime:0.004134s ]
select * from pdf where partno='61122281-E-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.008436s ]
select foldpath,foldpath2,filename from pdf_file where id=1493212 limit 1 [ RunTime:0.004947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61122281-E-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.004424s ]
SELECT `id` FROM `stock` WHERE `id` <> 43787871 AND `partno` = '61122281-E-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.018163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43786986 LIMIT 5 [ RunTime:0.008128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43786986 ORDER BY `minOrder` ASC [ RunTime:0.004401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43786986 ORDER BY `unit` DESC [ RunTime:0.002360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43786986 LIMIT 2 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43786986 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='61125461-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.005316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61125461-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.002642s ]
SELECT `id` FROM `stock` WHERE `id` <> 43786986 AND `partno` = '61125461-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.008365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43786959 LIMIT 5 [ RunTime:0.012862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43786959 ORDER BY `minOrder` ASC [ RunTime:0.001127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43786959 ORDER BY `unit` DESC [ RunTime:0.007683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43786959 LIMIT 2 [ RunTime:0.003006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43786959 ORDER BY `minOrder` ASC [ RunTime:0.002047s ]
select * from pdf where partno='61122471-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.003252s ]
select foldpath,foldpath2,filename from pdf_file where id=1755825 limit 1 [ RunTime:0.015495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61122471-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.011140s ]
SELECT `id` FROM `stock` WHERE `id` <> 43786959 AND `partno` = '61122471-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.016851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43786070 LIMIT 5 [ RunTime:0.027703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43786070 ORDER BY `minOrder` ASC [ RunTime:0.045271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43786070 ORDER BY `unit` DESC [ RunTime:0.009290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43786070 LIMIT 2 [ RunTime:0.011822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43786070 ORDER BY `minOrder` ASC [ RunTime:0.002958s ]
select * from pdf where partno='61122431-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.021764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61122431-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.010190s ]
SELECT `id` FROM `stock` WHERE `id` <> 43786070 AND `partno` = '61122431-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.010163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43785988 LIMIT 5 [ RunTime:0.010174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43785988 ORDER BY `minOrder` ASC [ RunTime:0.013256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43785988 ORDER BY `unit` DESC [ RunTime:0.001042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43785988 LIMIT 2 [ RunTime:0.003824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43785988 ORDER BY `minOrder` ASC [ RunTime:0.007350s ]
select * from pdf where partno='61122421-E-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.011630s ]
select foldpath,foldpath2,filename from pdf_file where id=1755825 limit 1 [ RunTime:0.002029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61122421-E-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.008173s ]
SELECT `id` FROM `stock` WHERE `id` <> 43785988 AND `partno` = '61122421-E-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.021361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43785456 LIMIT 5 [ RunTime:0.012138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43785456 ORDER BY `minOrder` ASC [ RunTime:0.022074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43785456 ORDER BY `unit` DESC [ RunTime:0.001949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43785456 LIMIT 2 [ RunTime:0.003389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43785456 ORDER BY `minOrder` ASC [ RunTime:0.004997s ]
select * from pdf where partno='61121481-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.023881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61121481-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.021847s ]
SELECT `id` FROM `stock` WHERE `id` <> 43785456 AND `partno` = '61121481-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.019584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43785455 LIMIT 5 [ RunTime:0.014069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43785455 ORDER BY `minOrder` ASC [ RunTime:0.005841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43785455 ORDER BY `unit` DESC [ RunTime:0.008861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43785455 LIMIT 2 [ RunTime:0.024819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43785455 ORDER BY `minOrder` ASC [ RunTime:0.009434s ]
select * from pdf where partno='61121281-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.001057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61121281-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.008048s ]
SELECT `id` FROM `stock` WHERE `id` <> 43785455 AND `partno` = '61121281-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.016910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43784837 LIMIT 5 [ RunTime:0.019406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43784837 ORDER BY `minOrder` ASC [ RunTime:0.013254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43784837 ORDER BY `unit` DESC [ RunTime:0.022675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43784837 LIMIT 2 [ RunTime:0.000955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43784837 ORDER BY `minOrder` ASC [ RunTime:0.008035s ]
select * from pdf where partno='61122416-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.017284s ]
select foldpath,foldpath2,filename from pdf_file where id=1493212 limit 1 [ RunTime:0.010241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61122416-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.017159s ]
SELECT `id` FROM `stock` WHERE `id` <> 43784837 AND `partno` = '61122416-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.019379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43784826 LIMIT 5 [ RunTime:0.022204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43784826 ORDER BY `minOrder` ASC [ RunTime:0.023810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43784826 ORDER BY `unit` DESC [ RunTime:0.011317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43784826 LIMIT 2 [ RunTime:0.005479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43784826 ORDER BY `minOrder` ASC [ RunTime:0.006743s ]
select * from pdf where partno='61125916-0-0-N' and brandshort='Carling Technologies' limit 1 [ RunTime:0.040038s ]
select foldpath,foldpath2,filename from pdf_file where id=1493212 limit 1 [ RunTime:0.016985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61125916-0-0-N' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.017978s ]
SELECT `id` FROM `stock` WHERE `id` <> 43784826 AND `partno` = '61125916-0-0-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.011765s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014009s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036325s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031867s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040212s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087819s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063048s ]
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 '6112%' OR `brand` LIKE '6112%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009869s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6112%' OR `brand` LIKE '6112%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.045102s ]