SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002093s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004182s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001556s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.009202s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001733s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002001s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005710s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005839s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.013818s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002491s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` = 4 AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.017989s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` = 4 AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 440,20 [ RunTime:0.008405s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('15814','15813','15812','15811','15810','15809','15808','15807','15806','15805','15804','15803','15802','15801','15800','15799','15798','15797','15796','15795') ORDER BY FIELD(s.id, 15814,15813,15812,15811,15810,15809,15808,15807,15806,15805,15804,15803,15802,15801,15800,15799,15798,15797,15796,15795) [ RunTime:0.005258s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15814 LIMIT 4 [ RunTime:0.002945s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15814 ORDER BY `minOrder` ASC [ RunTime:0.032850s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15814 ORDER BY `unit` DESC [ RunTime:0.002858s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15814 LIMIT 2 [ RunTime:0.004360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15814 ORDER BY `minOrder` ASC [ RunTime:0.003131s ]
select * from pdf where partno='C4D0112N-A' and brandshort='ELECTROSWITCH' limit 1 [ RunTime:0.001506s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C4D0112N-A' OR `brand` LIKE 'ELECTROSWITCH%' ) ) LIMIT 1 [ RunTime:0.005425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15813 LIMIT 4 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15813 ORDER BY `minOrder` ASC [ RunTime:0.002270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15813 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15813 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15813 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
select * from pdf where partno='ERJ3GEYJ222V' and brandshort='PANASONIC' limit 1 [ RunTime:0.005195s ]
select foldpath,foldpath2,filename from pdf_file where id=1135144 limit 1 [ RunTime:0.011560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ3GEYJ222V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.014495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15812 LIMIT 4 [ RunTime:0.009165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15812 ORDER BY `minOrder` ASC [ RunTime:0.006783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15812 ORDER BY `unit` DESC [ RunTime:0.003090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15812 LIMIT 2 [ RunTime:0.003236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15812 ORDER BY `minOrder` ASC [ RunTime:0.002093s ]
select * from pdf where partno='CRG1206F10K.' and brandshort='NEOHM - TE CONNECTIVITY' limit 1 [ RunTime:0.003875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRG1206F10K.' OR `brand` LIKE 'NEOHM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15811 LIMIT 4 [ RunTime:0.003428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15811 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15811 ORDER BY `unit` DESC [ RunTime:0.001224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15811 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15811 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='KSZ8795CLXIC' and brandshort='MICROCHIP' limit 1 [ RunTime:0.008149s ]
select foldpath,foldpath2,filename from pdf_file where id=1884230 limit 1 [ RunTime:0.003248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KSZ8795CLXIC' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.027009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15810 LIMIT 4 [ RunTime:0.001447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15810 ORDER BY `minOrder` ASC [ RunTime:0.010458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15810 ORDER BY `unit` DESC [ RunTime:0.009019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15810 LIMIT 2 [ RunTime:0.002437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15810 ORDER BY `minOrder` ASC [ RunTime:0.007731s ]
select * from pdf where partno='0603LS-561XGRC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.004469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0603LS-561XGRC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.009735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15809 LIMIT 4 [ RunTime:0.005098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15809 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15809 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15809 LIMIT 2 [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15809 ORDER BY `minOrder` ASC [ RunTime:0.002637s ]
select * from pdf where partno='1379217-3' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.002276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1379217-3' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.258143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15808 LIMIT 4 [ RunTime:0.006740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15808 ORDER BY `minOrder` ASC [ RunTime:0.040277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15808 ORDER BY `unit` DESC [ RunTime:0.054376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15808 LIMIT 2 [ RunTime:0.016636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15808 ORDER BY `minOrder` ASC [ RunTime:0.053484s ]
select * from pdf where partno='CPF0805B1M8E' and brandshort='NEOHM - TE CONNECTIVITY' limit 1 [ RunTime:0.046644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CPF0805B1M8E' OR `brand` LIKE 'NEOHM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.046794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15807 LIMIT 4 [ RunTime:0.062679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15807 ORDER BY `minOrder` ASC [ RunTime:0.039932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15807 ORDER BY `unit` DESC [ RunTime:0.093067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15807 LIMIT 2 [ RunTime:0.059501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15807 ORDER BY `minOrder` ASC [ RunTime:0.063712s ]
select * from pdf where partno='P6KE36A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.036395s ]
select foldpath,foldpath2,filename from pdf_file where id=445846 limit 1 [ RunTime:0.060339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE36A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.058547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15806 LIMIT 4 [ RunTime:0.040640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15806 ORDER BY `minOrder` ASC [ RunTime:0.068808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15806 ORDER BY `unit` DESC [ RunTime:0.073274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15806 LIMIT 2 [ RunTime:0.098922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15806 ORDER BY `minOrder` ASC [ RunTime:0.027071s ]
select * from pdf where partno='MC74HC595ADTR2G' and brandshort='ONSEMI' limit 1 [ RunTime:0.028461s ]
select foldpath,foldpath2,filename from pdf_file where id=1135691 limit 1 [ RunTime:0.008505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC74HC595ADTR2G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.019183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15805 LIMIT 4 [ RunTime:0.010321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15805 ORDER BY `minOrder` ASC [ RunTime:0.074732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15805 ORDER BY `unit` DESC [ RunTime:0.044501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15805 LIMIT 2 [ RunTime:0.051011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15805 ORDER BY `minOrder` ASC [ RunTime:0.021501s ]
select * from pdf where partno='L7805ABV' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.025712s ]
select foldpath,foldpath2,filename from pdf_file where id=265766 limit 1 [ RunTime:0.016643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L7805ABV' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.014874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15804 LIMIT 4 [ RunTime:0.014938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15804 ORDER BY `minOrder` ASC [ RunTime:0.007086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15804 ORDER BY `unit` DESC [ RunTime:0.012974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15804 LIMIT 2 [ RunTime:0.003380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15804 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='280358-0' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280358-0' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15803 LIMIT 4 [ RunTime:0.002066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15803 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15803 ORDER BY `unit` DESC [ RunTime:0.002232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15803 LIMIT 2 [ RunTime:0.003512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15803 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='B43644A5687M000' and brandshort='EPCOS' limit 1 [ RunTime:0.004273s ]
select foldpath,foldpath2,filename from pdf_file where id=1804329 limit 1 [ RunTime:0.002606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B43644A5687M000' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.002819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15802 LIMIT 4 [ RunTime:0.001265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15802 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15802 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15802 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15802 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='TPS51200DRCR' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.002464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPS51200DRCR' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.001413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15801 LIMIT 4 [ RunTime:0.001674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15801 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15801 ORDER BY `unit` DESC [ RunTime:0.001159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15801 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15801 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='WSL120600000ZEA9' and brandshort='VISHAY' limit 1 [ RunTime:0.001147s ]
select foldpath,foldpath2,filename from pdf_file where id=1919657 limit 1 [ RunTime:0.004129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WSL120600000ZEA9' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.011199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15800 LIMIT 4 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15800 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15800 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15800 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15800 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='SMBJ30CA' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.002393s ]
select foldpath,foldpath2,filename from pdf_file where id=422293 limit 1 [ RunTime:0.001329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.008627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15799 LIMIT 4 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15799 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15799 ORDER BY `unit` DESC [ RunTime:0.000530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15799 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15799 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='MC202472M090B20C7B' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC202472M090B20C7B' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15798 LIMIT 4 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15798 ORDER BY `minOrder` ASC [ RunTime:0.002701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15798 ORDER BY `unit` DESC [ RunTime:0.001833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15798 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15798 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='EEC0252B2-0000-A99' and brandshort='SUNON' limit 1 [ RunTime:0.001425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEC0252B2-0000-A99' OR `brand` LIKE 'SUNON%' ) ) LIMIT 1 [ RunTime:0.001677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15797 LIMIT 4 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15797 ORDER BY `minOrder` ASC [ RunTime:0.003043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15797 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15797 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15797 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='CB3LV-3C-50M000000' and brandshort='CTS' limit 1 [ RunTime:0.001552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB3LV-3C-50M000000' OR `brand` LIKE 'CTS%' ) ) LIMIT 1 [ RunTime:0.001100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15796 LIMIT 4 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15796 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15796 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15796 LIMIT 2 [ RunTime:0.001220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15796 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='MCWR04X4701FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR04X4701FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15795 LIMIT 4 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15795 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15795 ORDER BY `unit` DESC [ RunTime:0.000360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15795 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15795 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='IS25WP064A-JBLE' and brandshort='INTEGRATED SILICON SOLUTION ISSI' limit 1 [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IS25WP064A-JBLE' OR `brand` LIKE 'INTEGRATED SILICON SOLUTION (ISSI)%' ) ) LIMIT 1 [ RunTime:0.000843s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` = 4 AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.008250s ]