SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001464s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.216968s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585759 LIMIT 5 [ RunTime:0.056557s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.076063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585759 ORDER BY `minOrder` ASC [ RunTime:0.111384s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.022308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585759 ORDER BY `unit` DESC [ RunTime:0.083730s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585759 LIMIT 2 [ RunTime:0.098434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585759 ORDER BY `minOrder` ASC [ RunTime:0.037465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512002 LIMIT 5 [ RunTime:0.052091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512002 ORDER BY `minOrder` ASC [ RunTime:0.080908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13512002 ORDER BY `unit` DESC [ RunTime:0.094879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13512002 LIMIT 2 [ RunTime:0.062312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512002 ORDER BY `minOrder` ASC [ RunTime:0.029873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12050397 LIMIT 5 [ RunTime:0.047060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12050397 ORDER BY `minOrder` ASC [ RunTime:0.044453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12050397 ORDER BY `unit` DESC [ RunTime:0.043666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12050397 LIMIT 2 [ RunTime:0.047922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12050397 ORDER BY `minOrder` ASC [ RunTime:0.041405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349711 LIMIT 5 [ RunTime:0.039243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349711 ORDER BY `minOrder` ASC [ RunTime:0.074715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349711 ORDER BY `unit` DESC [ RunTime:0.097062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349711 LIMIT 2 [ RunTime:0.057715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349711 ORDER BY `minOrder` ASC [ RunTime:0.005923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496292 LIMIT 5 [ RunTime:0.040651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496292 ORDER BY `minOrder` ASC [ RunTime:0.076509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496292 ORDER BY `unit` DESC [ RunTime:0.026765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496292 LIMIT 2 [ RunTime:0.045138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496292 ORDER BY `minOrder` ASC [ RunTime:0.003721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170784 LIMIT 5 [ RunTime:0.041304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19170784 ORDER BY `minOrder` ASC [ RunTime:0.024493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19170784 ORDER BY `unit` DESC [ RunTime:0.031512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19170784 LIMIT 2 [ RunTime:0.018161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19170784 ORDER BY `minOrder` ASC [ RunTime:0.006298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12871883 LIMIT 5 [ RunTime:0.005348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12871883 ORDER BY `minOrder` ASC [ RunTime:0.034830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12871883 ORDER BY `unit` DESC [ RunTime:0.046507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12871883 LIMIT 2 [ RunTime:0.040612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12871883 ORDER BY `minOrder` ASC [ RunTime:0.020545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170791 LIMIT 5 [ RunTime:0.010368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19170791 ORDER BY `minOrder` ASC [ RunTime:0.022265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19170791 ORDER BY `unit` DESC [ RunTime:0.025408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19170791 LIMIT 2 [ RunTime:0.057877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19170791 ORDER BY `minOrder` ASC [ RunTime:0.025167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269473 LIMIT 5 [ RunTime:0.028351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269473 ORDER BY `minOrder` ASC [ RunTime:0.007676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15269473 ORDER BY `unit` DESC [ RunTime:0.012458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15269473 LIMIT 2 [ RunTime:0.009939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269473 ORDER BY `minOrder` ASC [ RunTime:0.006147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631317 LIMIT 5 [ RunTime:0.012278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631317 ORDER BY `minOrder` ASC [ RunTime:0.001219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12631317 ORDER BY `unit` DESC [ RunTime:0.000726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12631317 LIMIT 2 [ RunTime:0.017223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631317 ORDER BY `minOrder` ASC [ RunTime:0.006595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170970 LIMIT 5 [ RunTime:0.015406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19170970 ORDER BY `minOrder` ASC [ RunTime:0.001034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19170970 ORDER BY `unit` DESC [ RunTime:0.017089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19170970 LIMIT 2 [ RunTime:0.005886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19170970 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542427 LIMIT 5 [ RunTime:0.014995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542427 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19542427 ORDER BY `unit` DESC [ RunTime:0.001972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19542427 LIMIT 2 [ RunTime:0.001841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542427 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
select * from pdf where partno='914CE19-6' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.006257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11390448 LIMIT 5 [ RunTime:0.032011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11390448 ORDER BY `minOrder` ASC [ RunTime:0.004763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11390448 ORDER BY `unit` DESC [ RunTime:0.007864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11390448 LIMIT 2 [ RunTime:0.012716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11390448 ORDER BY `minOrder` ASC [ RunTime:0.004377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909485 LIMIT 5 [ RunTime:0.021421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909485 ORDER BY `minOrder` ASC [ RunTime:0.010826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909485 ORDER BY `unit` DESC [ RunTime:0.004039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909485 LIMIT 2 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909485 ORDER BY `minOrder` ASC [ RunTime:0.011437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510540 LIMIT 5 [ RunTime:0.008735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510540 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510540 ORDER BY `unit` DESC [ RunTime:0.010780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510540 LIMIT 2 [ RunTime:0.028927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510540 ORDER BY `minOrder` ASC [ RunTime:0.006119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14629257 LIMIT 5 [ RunTime:0.002132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14629257 ORDER BY `minOrder` ASC [ RunTime:0.015941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14629257 ORDER BY `unit` DESC [ RunTime:0.003305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14629257 LIMIT 2 [ RunTime:0.015013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14629257 ORDER BY `minOrder` ASC [ RunTime:0.012699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542433 LIMIT 5 [ RunTime:0.013627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542433 ORDER BY `minOrder` ASC [ RunTime:0.013241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19542433 ORDER BY `unit` DESC [ RunTime:0.060082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19542433 LIMIT 2 [ RunTime:0.026548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542433 ORDER BY `minOrder` ASC [ RunTime:0.011824s ]
select * from pdf where partno='914CE18-3AL1' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.023854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542430 LIMIT 5 [ RunTime:0.043316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542430 ORDER BY `minOrder` ASC [ RunTime:0.035829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19542430 ORDER BY `unit` DESC [ RunTime:0.006126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19542430 LIMIT 2 [ RunTime:0.009336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542430 ORDER BY `minOrder` ASC [ RunTime:0.009515s ]
select * from pdf where partno='914CE1-15' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.019414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12158691 LIMIT 5 [ RunTime:0.023808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12158691 ORDER BY `minOrder` ASC [ RunTime:0.054165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12158691 ORDER BY `unit` DESC [ RunTime:0.020241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12158691 LIMIT 2 [ RunTime:0.022916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12158691 ORDER BY `minOrder` ASC [ RunTime:0.038686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13570914 LIMIT 5 [ RunTime:0.019613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13570914 ORDER BY `minOrder` ASC [ RunTime:0.030349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13570914 ORDER BY `unit` DESC [ RunTime:0.016910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13570914 LIMIT 2 [ RunTime:0.033463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13570914 ORDER BY `minOrder` ASC [ RunTime:0.040112s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51100281 LIMIT 5 [ RunTime:0.051168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51100281 ORDER BY `minOrder` ASC [ RunTime:0.058402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51100281 ORDER BY `unit` DESC [ RunTime:0.030702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51100281 LIMIT 2 [ RunTime:0.075674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51100281 ORDER BY `minOrder` ASC [ RunTime:0.024518s ]
select * from pdf where partno='914125-dhuv' and brandshort='metcal' limit 1 [ RunTime:0.036994s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914125-dhuv' OR `brand` LIKE 'metcal%' ) ) LIMIT 1 [ RunTime:0.019913s ]
SELECT `id` FROM `stock` WHERE `id` <> 51100281 AND `partno` = '914125-dhuv' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metcal%' ) [ RunTime:0.019981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16994966 [ RunTime:0.045455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082853 LIMIT 5 [ RunTime:0.023880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082853 ORDER BY `minOrder` ASC [ RunTime:0.025207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082853 ORDER BY `unit` DESC [ RunTime:0.020283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082853 LIMIT 2 [ RunTime:0.041055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082853 ORDER BY `minOrder` ASC [ RunTime:0.008086s ]
select * from pdf where partno='914ce1-3a' and brandshort='honeywell' limit 1 [ RunTime:0.022219s ]
select foldpath,foldpath2,filename from pdf_file where id=1210977 limit 1 [ RunTime:0.012470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914ce1-3a' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.012327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51100261 LIMIT 5 [ RunTime:0.008925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51100261 ORDER BY `minOrder` ASC [ RunTime:0.029126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51100261 ORDER BY `unit` DESC [ RunTime:0.061350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51100261 LIMIT 2 [ RunTime:0.050965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51100261 ORDER BY `minOrder` ASC [ RunTime:0.056388s ]
select * from pdf where partno='914150-te' and brandshort='metcal' limit 1 [ RunTime:0.069914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914150-te' OR `brand` LIKE 'metcal%' ) ) LIMIT 1 [ RunTime:0.046234s ]
SELECT `id` FROM `stock` WHERE `id` <> 51100261 AND `partno` = '914150-te' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metcal%' ) [ RunTime:0.056574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995056 [ RunTime:0.042899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255405 LIMIT 5 [ RunTime:0.011863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255405 ORDER BY `minOrder` ASC [ RunTime:0.008913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255405 ORDER BY `unit` DESC [ RunTime:0.074803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255405 LIMIT 2 [ RunTime:0.003710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255405 ORDER BY `minOrder` ASC [ RunTime:0.011374s ]
select * from pdf where partno='91487-241lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.011248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91487-241lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.022600s ]
SELECT `id` FROM `stock` WHERE `id` <> 32255405 AND `partno` = '91487-241lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.018300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282974 LIMIT 5 [ RunTime:0.020096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282974 ORDER BY `minOrder` ASC [ RunTime:0.061690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282974 ORDER BY `unit` DESC [ RunTime:0.030159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282974 LIMIT 2 [ RunTime:0.031555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282974 ORDER BY `minOrder` ASC [ RunTime:0.026895s ]
select * from pdf where partno='9140' and brandshort='b&k precision' limit 1 [ RunTime:0.029554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9140' OR `brand` LIKE 'b&k precision%' ) ) LIMIT 1 [ RunTime:0.021919s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282974 AND `partno` = '9140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.037068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909485 [ RunTime:0.068415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282975 LIMIT 5 [ RunTime:0.003223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282975 ORDER BY `minOrder` ASC [ RunTime:0.031015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282975 ORDER BY `unit` DESC [ RunTime:0.026857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282975 LIMIT 2 [ RunTime:0.005679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282975 ORDER BY `minOrder` ASC [ RunTime:0.029621s ]
select * from pdf where partno='9141' and brandshort='b&k precision' limit 1 [ RunTime:0.016022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9141' OR `brand` LIKE 'b&k precision%' ) ) LIMIT 1 [ RunTime:0.016814s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282975 AND `partno` = '9141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.007945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986771 [ RunTime:0.005655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32185354 LIMIT 5 [ RunTime:0.012662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185354 ORDER BY `minOrder` ASC [ RunTime:0.024631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32185354 ORDER BY `unit` DESC [ RunTime:0.017809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32185354 LIMIT 2 [ RunTime:0.010878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185354 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='914049-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914049-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.006308s ]
SELECT `id` FROM `stock` WHERE `id` <> 32185354 AND `partno` = '914049-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283016 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283016 ORDER BY `minOrder` ASC [ RunTime:0.003288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283016 ORDER BY `unit` DESC [ RunTime:0.005193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283016 LIMIT 2 [ RunTime:0.009690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283016 ORDER BY `minOrder` ASC [ RunTime:0.007203s ]
select * from pdf where partno='9140-gpib' and brandshort='b&k precision' limit 1 [ RunTime:0.004954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9140-gpib' OR `brand` LIKE 'b&k precision%' ) ) LIMIT 1 [ RunTime:0.001684s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283016 AND `partno` = '9140-gpib' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.030171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986774 [ RunTime:0.009621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283003 LIMIT 5 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283003 ORDER BY `minOrder` ASC [ RunTime:0.003659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283003 ORDER BY `unit` DESC [ RunTime:0.003549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283003 LIMIT 2 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283003 ORDER BY `minOrder` ASC [ RunTime:0.002866s ]
select * from pdf where partno='9141-gpib' and brandshort='b&k precision' limit 1 [ RunTime:0.001152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9141-gpib' OR `brand` LIKE 'b&k precision%' ) ) LIMIT 1 [ RunTime:0.005982s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283003 AND `partno` = '9141-gpib' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.002021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986773 [ RunTime:0.005444s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60939327 LIMIT 5 [ RunTime:0.001789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939327 ORDER BY `minOrder` ASC [ RunTime:0.001124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60939327 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60939327 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939327 ORDER BY `minOrder` ASC [ RunTime:0.000859s ]
select * from pdf where partno='914' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000839s ]
SELECT `id` FROM `stock` WHERE `id` <> 60939327 AND `partno` = '914' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.002134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585759 [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63155809 LIMIT 5 [ RunTime:0.002312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63155809 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63155809 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63155809 LIMIT 2 [ RunTime:0.001491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63155809 ORDER BY `minOrder` ASC [ RunTime:0.003830s ]
select * from pdf where partno='914300000A' and brandshort='WEC' limit 1 [ RunTime:0.002091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914300000A' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63363812 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63363812 ORDER BY `minOrder` ASC [ RunTime:0.006536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63363812 ORDER BY `unit` DESC [ RunTime:0.001221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63363812 LIMIT 2 [ RunTime:0.003988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63363812 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='91400A035' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.000821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91400A035' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.004559s ]
SELECT `id` FROM `stock` WHERE `id` <> 63363812 AND `partno` = '91400A035' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63225038 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225038 ORDER BY `minOrder` ASC [ RunTime:0.003953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63225038 ORDER BY `unit` DESC [ RunTime:0.002161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63225038 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225038 ORDER BY `minOrder` ASC [ RunTime:0.005680s ]
select * from pdf where partno='9146' and brandshort='Radial Magnets, Inc.' limit 1 [ RunTime:0.002640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9146' OR `brand` LIKE 'Radial Magnets, Inc.%' ) ) LIMIT 1 [ RunTime:0.003472s ]
SELECT `id` FROM `stock` WHERE `id` <> 63225038 AND `partno` = '9146' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radial magnets, inc.%' ) [ RunTime:0.000943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170784 [ RunTime:0.002382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63374840 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63374840 ORDER BY `minOrder` ASC [ RunTime:0.003561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63374840 ORDER BY `unit` DESC [ RunTime:0.002425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63374840 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63374840 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='9141' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.006087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9141' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.009542s ]
SELECT `id` FROM `stock` WHERE `id` <> 63374840 AND `partno` = '9141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12050397 [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59946256 LIMIT 5 [ RunTime:0.001670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59946256 ORDER BY `minOrder` ASC [ RunTime:0.001776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59946256 ORDER BY `unit` DESC [ RunTime:0.006214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59946256 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59946256 ORDER BY `minOrder` ASC [ RunTime:0.002717s ]
select * from pdf where partno='91488-571LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.008436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91488-571LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000871s ]
SELECT `id` FROM `stock` WHERE `id` <> 59946256 AND `partno` = '91488-571LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496292 [ RunTime:0.013629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60370083 LIMIT 5 [ RunTime:0.007389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60370083 ORDER BY `minOrder` ASC [ RunTime:0.004544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60370083 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60370083 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60370083 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
select * from pdf where partno='91400A041' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.001738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91400A041' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.001915s ]
SELECT `id` FROM `stock` WHERE `id` <> 60370083 AND `partno` = '91400A041' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.006567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12871883 [ RunTime:0.001563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63225298 LIMIT 5 [ RunTime:0.001787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225298 ORDER BY `minOrder` ASC [ RunTime:0.006490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63225298 ORDER BY `unit` DESC [ RunTime:0.004998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63225298 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225298 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='9149' and brandshort='Radial Magnets, Inc.' limit 1 [ RunTime:0.001227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9149' OR `brand` LIKE 'Radial Magnets, Inc.%' ) ) LIMIT 1 [ RunTime:0.004539s ]
SELECT `id` FROM `stock` WHERE `id` <> 63225298 AND `partno` = '9149' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radial magnets, inc.%' ) [ RunTime:0.013067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170970 [ RunTime:0.003482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63225305 LIMIT 5 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225305 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63225305 ORDER BY `unit` DESC [ RunTime:0.008895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63225305 LIMIT 2 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225305 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
select * from pdf where partno='9144' and brandshort='Radial Magnets, Inc.' limit 1 [ RunTime:0.003536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9144' OR `brand` LIKE 'Radial Magnets, Inc.%' ) ) LIMIT 1 [ RunTime:0.007535s ]
SELECT `id` FROM `stock` WHERE `id` <> 63225305 AND `partno` = '9144' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radial magnets, inc.%' ) [ RunTime:0.006159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170791 [ RunTime:0.015678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523683 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523683 ORDER BY `minOrder` ASC [ RunTime:0.001370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523683 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523683 LIMIT 2 [ RunTime:0.017514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523683 ORDER BY `minOrder` ASC [ RunTime:0.006749s ]
select * from pdf where partno='9140' and brandshort='B&K Precision' limit 1 [ RunTime:0.014175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9140' OR `brand` LIKE 'B&K Precision%' ) ) LIMIT 1 [ RunTime:0.010599s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523683 AND `partno` = '9140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.006591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909485 [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63459955 LIMIT 5 [ RunTime:0.003232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63459955 ORDER BY `minOrder` ASC [ RunTime:0.002402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63459955 ORDER BY `unit` DESC [ RunTime:0.006942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63459955 LIMIT 2 [ RunTime:0.002322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63459955 ORDER BY `minOrder` ASC [ RunTime:0.003484s ]
select * from pdf where partno='914810' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.003389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914810' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.008191s ]
SELECT `id` FROM `stock` WHERE `id` <> 63459955 AND `partno` = '914810' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.013251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269473 [ RunTime:0.002943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59942475 LIMIT 5 [ RunTime:0.003772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59942475 ORDER BY `minOrder` ASC [ RunTime:0.008586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59942475 ORDER BY `unit` DESC [ RunTime:0.004144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59942475 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59942475 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='91487-241LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91487-241LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003237s ]
SELECT `id` FROM `stock` WHERE `id` <> 59942475 AND `partno` = '91487-241LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631317 [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62456062 LIMIT 5 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62456062 ORDER BY `minOrder` ASC [ RunTime:0.002547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62456062 ORDER BY `unit` DESC [ RunTime:0.003955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62456062 LIMIT 2 [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62456062 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
select * from pdf where partno='9140343R054' and brandshort='Ease Electronics' limit 1 [ RunTime:0.012951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9140343R054' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.004785s ]
SELECT `id` FROM `stock` WHERE `id` <> 62456062 AND `partno` = '9140343R054' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.015257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14629257 [ RunTime:0.006506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753555 LIMIT 5 [ RunTime:0.004408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753555 ORDER BY `minOrder` ASC [ RunTime:0.005617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753555 ORDER BY `unit` DESC [ RunTime:0.002266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753555 LIMIT 2 [ RunTime:0.003275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753555 ORDER BY `minOrder` ASC [ RunTime:0.005899s ]
select * from pdf where partno='9140-4500PL' and brandshort='3M' limit 1 [ RunTime:0.002323s ]
select foldpath,foldpath2,filename from pdf_file where id=1609616 limit 1 [ RunTime:0.000614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9140-4500PL' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.010768s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753555 AND `partno` = '9140-4500PL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.001391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63225313 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225313 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63225313 ORDER BY `unit` DESC [ RunTime:0.002400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63225313 LIMIT 2 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63225313 ORDER BY `minOrder` ASC [ RunTime:0.001491s ]
select * from pdf where partno='9145' and brandshort='Radial Magnets, Inc.' limit 1 [ RunTime:0.001516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9145' OR `brand` LIKE 'Radial Magnets, Inc.%' ) ) LIMIT 1 [ RunTime:0.003715s ]
SELECT `id` FROM `stock` WHERE `id` <> 63225313 AND `partno` = '9145' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radial magnets, inc.%' ) [ RunTime:0.006173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170984 [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58395260 LIMIT 5 [ RunTime:0.001592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58395260 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58395260 ORDER BY `unit` DESC [ RunTime:0.007807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58395260 LIMIT 2 [ RunTime:0.007174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58395260 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
select * from pdf where partno='914CE19-6' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914CE19-6' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000956s ]
SELECT `id` FROM `stock` WHERE `id` <> 58395260 AND `partno` = '914CE19-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.002918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542427 [ RunTime:0.001702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913488 LIMIT 5 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913488 ORDER BY `minOrder` ASC [ RunTime:0.004316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913488 ORDER BY `unit` DESC [ RunTime:0.004553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913488 LIMIT 2 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913488 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='9148-9513-000' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.002391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9148-9513-000' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.003337s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913488 AND `partno` = '9148-9513-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.008027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682098 [ RunTime:0.003761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58397144 LIMIT 5 [ RunTime:0.001047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58397144 ORDER BY `minOrder` ASC [ RunTime:0.000905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58397144 ORDER BY `unit` DESC [ RunTime:0.003287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58397144 LIMIT 2 [ RunTime:0.003624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58397144 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='914CE20-N77' and brandshort='WEC' limit 1 [ RunTime:0.003799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914CE20-N77' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513057 LIMIT 5 [ RunTime:0.004303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513057 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513057 ORDER BY `unit` DESC [ RunTime:0.009762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513057 LIMIT 2 [ RunTime:0.002021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513057 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='91473' and brandshort='Wiha' limit 1 [ RunTime:0.004853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91473' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.001035s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513057 AND `partno` = '91473' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.004372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58596294 LIMIT 5 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58596294 ORDER BY `minOrder` ASC [ RunTime:0.001175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58596294 ORDER BY `unit` DESC [ RunTime:0.003333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58596294 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58596294 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='914125-DHUV' and brandshort='Metcal' limit 1 [ RunTime:0.002243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '914125-DHUV' OR `brand` LIKE 'Metcal%' ) ) LIMIT 1 [ RunTime:0.000523s ]
SELECT `id` FROM `stock` WHERE `id` <> 58596294 AND `partno` = '914125-DHUV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metcal%' ) [ RunTime:0.003321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16994966 [ RunTime:0.000295s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000797s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002069s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001615s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000764s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000617s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000737s ]
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 '914%' OR `brand` LIKE '914%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000797s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '914%' OR `brand` LIKE '914%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013517s ]