SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001655s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017400s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071546 LIMIT 5 [ RunTime:0.023067s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071546 ORDER BY `minOrder` ASC [ RunTime:0.010966s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071546 ORDER BY `unit` DESC [ RunTime:0.017791s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.026212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071546 LIMIT 2 [ RunTime:0.023853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071546 ORDER BY `minOrder` ASC [ RunTime:0.012495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348671 LIMIT 5 [ RunTime:0.059858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348671 ORDER BY `minOrder` ASC [ RunTime:0.043147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348671 ORDER BY `unit` DESC [ RunTime:0.012232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348671 LIMIT 2 [ RunTime:0.053328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348671 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20772 LIMIT 5 [ RunTime:0.046166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20772 ORDER BY `minOrder` ASC [ RunTime:0.065968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20772 ORDER BY `unit` DESC [ RunTime:0.049704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20772 LIMIT 2 [ RunTime:0.099472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20772 ORDER BY `minOrder` ASC [ RunTime:0.033569s ]
select * from pdf where partno='432028816' and brandshort='MOLEX' limit 1 [ RunTime:0.062564s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432028816' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.064896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20769 LIMIT 5 [ RunTime:0.079360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20769 ORDER BY `minOrder` ASC [ RunTime:0.096194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20769 ORDER BY `unit` DESC [ RunTime:0.083813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20769 LIMIT 2 [ RunTime:0.027502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20769 ORDER BY `minOrder` ASC [ RunTime:0.017558s ]
select * from pdf where partno='43202-8816' and brandshort='MOLEX' limit 1 [ RunTime:0.040641s ]
select foldpath,foldpath2,filename from pdf_file where id=764889 limit 1 [ RunTime:0.047766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43202-8816' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.053319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14942 LIMIT 5 [ RunTime:0.017483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14942 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14942 ORDER BY `unit` DESC [ RunTime:0.000902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14942 LIMIT 2 [ RunTime:0.005130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14942 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='432028816' and brandshort='MOLEX' limit 1 [ RunTime:0.000510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432028816' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12624592 LIMIT 5 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12624592 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12624592 ORDER BY `unit` DESC [ RunTime:0.005979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12624592 LIMIT 2 [ RunTime:0.003958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12624592 ORDER BY `minOrder` ASC [ RunTime:0.014719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368290 LIMIT 5 [ RunTime:0.022533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368290 ORDER BY `minOrder` ASC [ RunTime:0.009895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368290 ORDER BY `unit` DESC [ RunTime:0.004016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368290 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368290 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011871 LIMIT 5 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011871 ORDER BY `minOrder` ASC [ RunTime:0.010173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19011871 ORDER BY `unit` DESC [ RunTime:0.004424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19011871 LIMIT 2 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011871 ORDER BY `minOrder` ASC [ RunTime:0.001822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011623 LIMIT 5 [ RunTime:0.001968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011623 ORDER BY `minOrder` ASC [ RunTime:0.004516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19011623 ORDER BY `unit` DESC [ RunTime:0.006934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19011623 LIMIT 2 [ RunTime:0.005472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011623 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011600 LIMIT 5 [ RunTime:0.010650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011600 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19011600 ORDER BY `unit` DESC [ RunTime:0.015515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19011600 LIMIT 2 [ RunTime:0.005812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011600 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011542 LIMIT 5 [ RunTime:0.014134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011542 ORDER BY `minOrder` ASC [ RunTime:0.004924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19011542 ORDER BY `unit` DESC [ RunTime:0.024224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19011542 LIMIT 2 [ RunTime:0.043811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011542 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011496 LIMIT 5 [ RunTime:0.004140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011496 ORDER BY `minOrder` ASC [ RunTime:0.021147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19011496 ORDER BY `unit` DESC [ RunTime:0.003569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19011496 LIMIT 2 [ RunTime:0.005350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011496 ORDER BY `minOrder` ASC [ RunTime:0.004268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011349 LIMIT 5 [ RunTime:0.006193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011349 ORDER BY `minOrder` ASC [ RunTime:0.019776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19011349 ORDER BY `unit` DESC [ RunTime:0.011640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19011349 LIMIT 2 [ RunTime:0.012286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19011349 ORDER BY `minOrder` ASC [ RunTime:0.009062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19010993 LIMIT 5 [ RunTime:0.011083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19010993 ORDER BY `minOrder` ASC [ RunTime:0.032788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19010993 ORDER BY `unit` DESC [ RunTime:0.007579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19010993 LIMIT 2 [ RunTime:0.007120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19010993 ORDER BY `minOrder` ASC [ RunTime:0.002942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19002882 LIMIT 5 [ RunTime:0.052540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002882 ORDER BY `minOrder` ASC [ RunTime:0.030298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19002882 ORDER BY `unit` DESC [ RunTime:0.005133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19002882 LIMIT 2 [ RunTime:0.014271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002882 ORDER BY `minOrder` ASC [ RunTime:0.030649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18995802 LIMIT 5 [ RunTime:0.043519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18995802 ORDER BY `minOrder` ASC [ RunTime:0.031796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18995802 ORDER BY `unit` DESC [ RunTime:0.023277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18995802 LIMIT 2 [ RunTime:0.025187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18995802 ORDER BY `minOrder` ASC [ RunTime:0.016503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18995369 LIMIT 5 [ RunTime:0.019929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18995369 ORDER BY `minOrder` ASC [ RunTime:0.016069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18995369 ORDER BY `unit` DESC [ RunTime:0.012915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18995369 LIMIT 2 [ RunTime:0.014309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18995369 ORDER BY `minOrder` ASC [ RunTime:0.002036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18854274 LIMIT 5 [ RunTime:0.029794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18854274 ORDER BY `minOrder` ASC [ RunTime:0.020532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18854274 ORDER BY `unit` DESC [ RunTime:0.017428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18854274 LIMIT 2 [ RunTime:0.006354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18854274 ORDER BY `minOrder` ASC [ RunTime:0.011078s ]
select * from pdf where partno='4320-01072-0' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.001043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687425 LIMIT 5 [ RunTime:0.010910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687425 ORDER BY `minOrder` ASC [ RunTime:0.020256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687425 ORDER BY `unit` DESC [ RunTime:0.010498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687425 LIMIT 2 [ RunTime:0.005748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687425 ORDER BY `minOrder` ASC [ RunTime:0.016763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588499 LIMIT 5 [ RunTime:0.014746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588499 ORDER BY `minOrder` ASC [ RunTime:0.021381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18588499 ORDER BY `unit` DESC [ RunTime:0.018637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18588499 LIMIT 2 [ RunTime:0.017731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588499 ORDER BY `minOrder` ASC [ RunTime:0.002550s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32278832 LIMIT 5 [ RunTime:0.001591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32278832 ORDER BY `minOrder` ASC [ RunTime:0.026803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32278832 ORDER BY `unit` DESC [ RunTime:0.029704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32278832 LIMIT 2 [ RunTime:0.044518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32278832 ORDER BY `minOrder` ASC [ RunTime:0.013721s ]
select * from pdf where partno='43202-8816' and brandshort='molex' limit 1 [ RunTime:0.021655s ]
select foldpath,foldpath2,filename from pdf_file where id=764889 limit 1 [ RunTime:0.011697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43202-8816' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.060153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056569 LIMIT 5 [ RunTime:0.032152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056569 ORDER BY `minOrder` ASC [ RunTime:0.031871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056569 ORDER BY `unit` DESC [ RunTime:0.063474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056569 LIMIT 2 [ RunTime:0.027608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056569 ORDER BY `minOrder` ASC [ RunTime:0.018182s ]
select * from pdf where partno='4320n24-u' and brandshort='that' limit 1 [ RunTime:0.051816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320n24-u' OR `brand` LIKE 'that%' ) ) LIMIT 1 [ RunTime:0.020509s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056569 AND `partno` = '4320n24-u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%that%' ) [ RunTime:0.051185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279538 LIMIT 5 [ RunTime:0.042336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279538 ORDER BY `minOrder` ASC [ RunTime:0.044900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279538 ORDER BY `unit` DESC [ RunTime:0.010432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279538 LIMIT 2 [ RunTime:0.021021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279538 ORDER BY `minOrder` ASC [ RunTime:0.011032s ]
select * from pdf where partno='43202-6105' and brandshort='molex' limit 1 [ RunTime:0.013388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43202-6105' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.035812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085757 LIMIT 5 [ RunTime:0.015427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085757 ORDER BY `minOrder` ASC [ RunTime:0.023532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085757 ORDER BY `unit` DESC [ RunTime:0.018236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085757 LIMIT 2 [ RunTime:0.024057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085757 ORDER BY `minOrder` ASC [ RunTime:0.023403s ]
select * from pdf where partno='432021' and brandshort='nmb' limit 1 [ RunTime:0.024149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432021' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.010728s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085757 AND `partno` = '432021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.034470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004669 [ RunTime:0.024580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085715 LIMIT 5 [ RunTime:0.024778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085715 ORDER BY `minOrder` ASC [ RunTime:0.067190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085715 ORDER BY `unit` DESC [ RunTime:0.051157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085715 LIMIT 2 [ RunTime:0.048039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085715 ORDER BY `minOrder` ASC [ RunTime:0.008178s ]
select * from pdf where partno='432020' and brandshort='nmb' limit 1 [ RunTime:0.024439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432020' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.018816s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085715 AND `partno` = '432020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.010759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004670 [ RunTime:0.011708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279494 LIMIT 5 [ RunTime:0.014919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279494 ORDER BY `minOrder` ASC [ RunTime:0.025708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279494 ORDER BY `unit` DESC [ RunTime:0.002916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279494 LIMIT 2 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279494 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
select * from pdf where partno='43202-8919' and brandshort='molex' limit 1 [ RunTime:0.014766s ]
select foldpath,foldpath2,filename from pdf_file where id=851547 limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43202-8919' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.053430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279372 LIMIT 5 [ RunTime:0.031391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279372 ORDER BY `minOrder` ASC [ RunTime:0.011582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279372 ORDER BY `unit` DESC [ RunTime:0.011244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279372 LIMIT 2 [ RunTime:0.009327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279372 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
select * from pdf where partno='43202-8919' and brandshort='molex' limit 1 [ RunTime:0.005250s ]
select foldpath,foldpath2,filename from pdf_file where id=851547 limit 1 [ RunTime:0.008487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43202-8919' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.002174s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418422 LIMIT 5 [ RunTime:0.010098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418422 ORDER BY `minOrder` ASC [ RunTime:0.002960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418422 ORDER BY `unit` DESC [ RunTime:0.014533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418422 LIMIT 2 [ RunTime:0.013875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418422 ORDER BY `minOrder` ASC [ RunTime:0.004271s ]
select * from pdf where partno='432028824' and brandshort='Molex' limit 1 [ RunTime:0.005307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432028824' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739170 LIMIT 5 [ RunTime:0.010090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739170 ORDER BY `minOrder` ASC [ RunTime:0.010702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739170 ORDER BY `unit` DESC [ RunTime:0.005671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739170 LIMIT 2 [ RunTime:0.001171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739170 ORDER BY `minOrder` ASC [ RunTime:0.003699s ]
select * from pdf where partno='4320CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007178s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739170 AND `partno` = '4320CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.014662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348671 [ RunTime:0.001636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125689 LIMIT 5 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125689 ORDER BY `minOrder` ASC [ RunTime:0.010580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125689 ORDER BY `unit` DESC [ RunTime:0.005648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125689 LIMIT 2 [ RunTime:0.006884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125689 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='4320' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.004512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.003533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60369761 LIMIT 5 [ RunTime:0.001691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369761 ORDER BY `minOrder` ASC [ RunTime:0.003787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60369761 ORDER BY `unit` DESC [ RunTime:0.001983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60369761 LIMIT 2 [ RunTime:0.001985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369761 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
select * from pdf where partno='4320.0012' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.007356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320.0012' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.002270s ]
SELECT `id` FROM `stock` WHERE `id` <> 60369761 AND `partno` = '4320.0012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.001700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16382011 [ RunTime:0.000952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59797314 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59797314 ORDER BY `minOrder` ASC [ RunTime:0.000857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59797314 ORDER BY `unit` DESC [ RunTime:0.001900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59797314 LIMIT 2 [ RunTime:0.008974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59797314 ORDER BY `minOrder` ASC [ RunTime:0.002872s ]
select * from pdf where partno='4320-01074-0' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.002751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320-01074-0' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.000883s ]
SELECT `id` FROM `stock` WHERE `id` <> 59797314 AND `partno` = '4320-01074-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.002366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529188 [ RunTime:0.004770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58512939 LIMIT 5 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58512939 ORDER BY `minOrder` ASC [ RunTime:0.002696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58512939 ORDER BY `unit` DESC [ RunTime:0.020518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58512939 LIMIT 2 [ RunTime:0.013522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58512939 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
select * from pdf where partno='4320G10SB-M9' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.006577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320G10SB-M9' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.001383s ]
SELECT `id` FROM `stock` WHERE `id` <> 58512939 AND `partno` = '4320G10SB-M9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.000961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687425 [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57674664 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674664 ORDER BY `minOrder` ASC [ RunTime:0.004108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57674664 ORDER BY `unit` DESC [ RunTime:0.010549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57674664 LIMIT 2 [ RunTime:0.002425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674664 ORDER BY `minOrder` ASC [ RunTime:0.003792s ]
select * from pdf where partno='432052' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432052' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.008223s ]
SELECT `id` FROM `stock` WHERE `id` <> 57674664 AND `partno` = '432052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.003800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588499 [ RunTime:0.007153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57674658 LIMIT 5 [ RunTime:0.003400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674658 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57674658 ORDER BY `unit` DESC [ RunTime:0.001657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57674658 LIMIT 2 [ RunTime:0.001121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674658 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='432051' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432051' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000786s ]
SELECT `id` FROM `stock` WHERE `id` <> 57674658 AND `partno` = '432051' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.008001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588497 [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57674639 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674639 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57674639 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57674639 LIMIT 2 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674639 ORDER BY `minOrder` ASC [ RunTime:0.004516s ]
select * from pdf where partno='432002' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432002' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.015022s ]
SELECT `id` FROM `stock` WHERE `id` <> 57674639 AND `partno` = '432002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.003539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588486 [ RunTime:0.009586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57674636 LIMIT 5 [ RunTime:0.003646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674636 ORDER BY `minOrder` ASC [ RunTime:0.025526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57674636 ORDER BY `unit` DESC [ RunTime:0.004681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57674636 LIMIT 2 [ RunTime:0.003197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674636 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='432020' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432020' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000874s ]
SELECT `id` FROM `stock` WHERE `id` <> 57674636 AND `partno` = '432020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.001045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004670 [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57674635 LIMIT 5 [ RunTime:0.016998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674635 ORDER BY `minOrder` ASC [ RunTime:0.010523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57674635 ORDER BY `unit` DESC [ RunTime:0.005052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57674635 LIMIT 2 [ RunTime:0.003781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674635 ORDER BY `minOrder` ASC [ RunTime:0.003416s ]
select * from pdf where partno='432021' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432021' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.021344s ]
SELECT `id` FROM `stock` WHERE `id` <> 57674635 AND `partno` = '432021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.019630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004669 [ RunTime:0.015102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57674624 LIMIT 5 [ RunTime:0.007601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674624 ORDER BY `minOrder` ASC [ RunTime:0.067204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57674624 ORDER BY `unit` DESC [ RunTime:0.011384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57674624 LIMIT 2 [ RunTime:0.045341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57674624 ORDER BY `minOrder` ASC [ RunTime:0.015442s ]
select * from pdf where partno='432000' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.022087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '432000' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.004514s ]
SELECT `id` FROM `stock` WHERE `id` <> 57674624 AND `partno` = '432000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.002041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004663 [ RunTime:0.010514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57613374 LIMIT 5 [ RunTime:0.010027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57613374 ORDER BY `minOrder` ASC [ RunTime:0.005872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57613374 ORDER BY `unit` DESC [ RunTime:0.024092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57613374 LIMIT 2 [ RunTime:0.007436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57613374 ORDER BY `minOrder` ASC [ RunTime:0.000901s ]
select * from pdf where partno='4320AC51G04800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.009606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320AC51G04800' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.022015s ]
SELECT `id` FROM `stock` WHERE `id` <> 57613374 AND `partno` = '4320AC51G04800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.028074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989787 [ RunTime:0.015744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57612835 LIMIT 5 [ RunTime:0.009563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57612835 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57612835 ORDER BY `unit` DESC [ RunTime:0.013657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57612835 LIMIT 2 [ RunTime:0.001899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57612835 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
select * from pdf where partno='4320PA51H01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.019666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320PA51H01800' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.006970s ]
SELECT `id` FROM `stock` WHERE `id` <> 57612835 AND `partno` = '4320PA51H01800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.034596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262082 [ RunTime:0.009222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57297185 LIMIT 5 [ RunTime:0.013942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57297185 ORDER BY `minOrder` ASC [ RunTime:0.033516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57297185 ORDER BY `unit` DESC [ RunTime:0.003385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57297185 LIMIT 2 [ RunTime:0.011624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57297185 ORDER BY `minOrder` ASC [ RunTime:0.029794s ]
select * from pdf where partno='4320-01072-0' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.004023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320-01072-0' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.012398s ]
SELECT `id` FROM `stock` WHERE `id` <> 57297185 AND `partno` = '4320-01072-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.038028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18854274 [ RunTime:0.025270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56719675 LIMIT 5 [ RunTime:0.017564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56719675 ORDER BY `minOrder` ASC [ RunTime:0.037723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56719675 ORDER BY `unit` DESC [ RunTime:0.019272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56719675 LIMIT 2 [ RunTime:0.024516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56719675 ORDER BY `minOrder` ASC [ RunTime:0.023311s ]
select * from pdf where partno='4320' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.025241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.019137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56714035 LIMIT 5 [ RunTime:0.038407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56714035 ORDER BY `minOrder` ASC [ RunTime:0.031916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56714035 ORDER BY `unit` DESC [ RunTime:0.071150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56714035 LIMIT 2 [ RunTime:0.080766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56714035 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
select * from pdf where partno='4320' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4320' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.026023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56676638 LIMIT 5 [ RunTime:0.021277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56676638 ORDER BY `minOrder` ASC [ RunTime:0.020098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56676638 ORDER BY `unit` DESC [ RunTime:0.050469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56676638 LIMIT 2 [ RunTime:0.024344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56676638 ORDER BY `minOrder` ASC [ RunTime:0.021951s ]
select * from pdf where partno='43200100C1SP' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.040776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43200100C1SP' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.027305s ]
SELECT `id` FROM `stock` WHERE `id` <> 56676638 AND `partno` = '43200100C1SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.016428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011871 [ RunTime:0.030204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56676434 LIMIT 5 [ RunTime:0.018918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56676434 ORDER BY `minOrder` ASC [ RunTime:0.012642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56676434 ORDER BY `unit` DESC [ RunTime:0.039764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56676434 LIMIT 2 [ RunTime:0.006968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56676434 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='43201301SP' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43201301SP' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.006370s ]
SELECT `id` FROM `stock` WHERE `id` <> 56676434 AND `partno` = '43201301SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.016813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011623 [ RunTime:0.021704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56676401 LIMIT 5 [ RunTime:0.004055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56676401 ORDER BY `minOrder` ASC [ RunTime:0.004724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56676401 ORDER BY `unit` DESC [ RunTime:0.007632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56676401 LIMIT 2 [ RunTime:0.001036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56676401 ORDER BY `minOrder` ASC [ RunTime:0.002738s ]
select * from pdf where partno='43200201HESP' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.011597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '43200201HESP' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.006118s ]
SELECT `id` FROM `stock` WHERE `id` <> 56676401 AND `partno` = '43200201HESP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.004485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19011600 [ RunTime:0.004584s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010625s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001285s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006920s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004680s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014904s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016517s ]
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 '4320%' OR `brand` LIKE '4320%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005021s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4320%' OR `brand` LIKE '4320%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013757s ]