SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001476s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.045516s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.009026s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.051460s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002375s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.032231s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.022923s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.051203s ]
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.021371s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003269s ]
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.015898s ]
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 1020,20 [ RunTime:0.127171s ]
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 ('15234','15233','15232','15231','15230','15229','15228','15227','15226','15225','15224','15223','15222','15221','15220','15219','15218','15217','15216','15215') ORDER BY FIELD(s.id, 15234,15233,15232,15231,15230,15229,15228,15227,15226,15225,15224,15223,15222,15221,15220,15219,15218,15217,15216,15215) [ RunTime:0.088759s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234 LIMIT 4 [ RunTime:0.048323s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.017723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234 ORDER BY `minOrder` ASC [ RunTime:0.080220s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234 ORDER BY `unit` DESC [ RunTime:0.133331s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234 LIMIT 2 [ RunTime:0.155780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234 ORDER BY `minOrder` ASC [ RunTime:0.064203s ]
select * from pdf where partno='SN74LS11N' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.042487s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74LS11N' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.194998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15233 LIMIT 4 [ RunTime:0.105333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15233 ORDER BY `minOrder` ASC [ RunTime:0.119720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15233 ORDER BY `unit` DESC [ RunTime:0.041693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15233 LIMIT 2 [ RunTime:0.105208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15233 ORDER BY `minOrder` ASC [ RunTime:0.079366s ]
select * from pdf where partno='172338-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.117731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172338-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.056928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232 LIMIT 4 [ RunTime:0.052586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232 ORDER BY `minOrder` ASC [ RunTime:0.027943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232 ORDER BY `unit` DESC [ RunTime:0.032643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232 LIMIT 2 [ RunTime:0.035508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232 ORDER BY `minOrder` ASC [ RunTime:0.069467s ]
select * from pdf where partno='LQH44PN3R3MP0L' and brandshort='MURATA' limit 1 [ RunTime:0.060680s ]
select foldpath,foldpath2,filename from pdf_file where id=2126344 limit 1 [ RunTime:0.070986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LQH44PN3R3MP0L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.060779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231 LIMIT 4 [ RunTime:0.077972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231 ORDER BY `minOrder` ASC [ RunTime:0.021849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231 ORDER BY `unit` DESC [ RunTime:0.160161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231 LIMIT 2 [ RunTime:0.063406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231 ORDER BY `minOrder` ASC [ RunTime:0.025449s ]
select * from pdf where partno='MCWR06X3000FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.084402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X3000FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.050670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15230 LIMIT 4 [ RunTime:0.039076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15230 ORDER BY `minOrder` ASC [ RunTime:0.073444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15230 ORDER BY `unit` DESC [ RunTime:0.010024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15230 LIMIT 2 [ RunTime:0.093917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15230 ORDER BY `minOrder` ASC [ RunTime:0.071844s ]
select * from pdf where partno='112-40064' and brandshort='EPT' limit 1 [ RunTime:0.022202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '112-40064' OR `brand` LIKE 'EPT%' ) ) LIMIT 1 [ RunTime:0.028950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15229 LIMIT 4 [ RunTime:0.065800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15229 ORDER BY `minOrder` ASC [ RunTime:0.161200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15229 ORDER BY `unit` DESC [ RunTime:0.040964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15229 LIMIT 2 [ RunTime:0.049302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15229 ORDER BY `minOrder` ASC [ RunTime:0.030960s ]
select * from pdf where partno='MMBZ33VAL,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.077290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMBZ33VAL,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.116436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15228 LIMIT 4 [ RunTime:0.033608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228 ORDER BY `minOrder` ASC [ RunTime:0.076540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15228 ORDER BY `unit` DESC [ RunTime:0.144649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15228 LIMIT 2 [ RunTime:0.101093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228 ORDER BY `minOrder` ASC [ RunTime:0.024465s ]
select * from pdf where partno='BFP740ESDH6327XTSA1' and brandshort='INFINEON' limit 1 [ RunTime:0.080472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BFP740ESDH6327XTSA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.077806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227 LIMIT 4 [ RunTime:0.094041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227 ORDER BY `minOrder` ASC [ RunTime:0.027228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15227 ORDER BY `unit` DESC [ RunTime:0.039059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15227 LIMIT 2 [ RunTime:0.072179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227 ORDER BY `minOrder` ASC [ RunTime:0.024716s ]
select * from pdf where partno='CRCW120675R0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.051885s ]
select foldpath,foldpath2,filename from pdf_file where id=1295037 limit 1 [ RunTime:0.005230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW120675R0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.033556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226 LIMIT 4 [ RunTime:0.038942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226 ORDER BY `minOrder` ASC [ RunTime:0.005797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226 ORDER BY `unit` DESC [ RunTime:0.002658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226 LIMIT 2 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226 ORDER BY `minOrder` ASC [ RunTime:0.007806s ]
select * from pdf where partno='0603B104K500CT' and brandshort='WALSIN' limit 1 [ RunTime:0.004772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0603B104K500CT' OR `brand` LIKE 'WALSIN%' ) ) LIMIT 1 [ RunTime:0.003569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225 LIMIT 4 [ RunTime:0.016093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225 ORDER BY `minOrder` ASC [ RunTime:0.006537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225 ORDER BY `unit` DESC [ RunTime:0.012522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225 LIMIT 2 [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225 ORDER BY `minOrder` ASC [ RunTime:0.010167s ]
select * from pdf where partno='ABI-001-RC' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ABI-001-RC' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.000950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224 LIMIT 4 [ RunTime:0.006726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224 ORDER BY `minOrder` ASC [ RunTime:0.026502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224 ORDER BY `unit` DESC [ RunTime:0.030646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224 LIMIT 2 [ RunTime:0.044606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224 ORDER BY `minOrder` ASC [ RunTime:0.017360s ]
select * from pdf where partno='MRS25000C4990FCT00' and brandshort='VISHAY' limit 1 [ RunTime:0.024383s ]
select foldpath,foldpath2,filename from pdf_file where id=1525849 limit 1 [ RunTime:0.023336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRS25000C4990FCT00' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.045718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223 LIMIT 4 [ RunTime:0.019761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223 ORDER BY `minOrder` ASC [ RunTime:0.045772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223 ORDER BY `unit` DESC [ RunTime:0.003034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223 LIMIT 2 [ RunTime:0.009161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223 ORDER BY `minOrder` ASC [ RunTime:0.010690s ]
select * from pdf where partno='1N4004RL' and brandshort='ONSEMI' limit 1 [ RunTime:0.016868s ]
select foldpath,foldpath2,filename from pdf_file where id=306824 limit 1 [ RunTime:0.009428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4004RL' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.025495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222 LIMIT 4 [ RunTime:0.022610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222 ORDER BY `minOrder` ASC [ RunTime:0.014993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15222 ORDER BY `unit` DESC [ RunTime:0.007503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15222 LIMIT 2 [ RunTime:0.008520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222 ORDER BY `minOrder` ASC [ RunTime:0.012142s ]
select * from pdf where partno='5501-25SA-02-F1' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.020543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5501-25SA-02-F1' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.014397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15221 LIMIT 4 [ RunTime:0.041882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15221 ORDER BY `minOrder` ASC [ RunTime:0.003385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15221 ORDER BY `unit` DESC [ RunTime:0.039093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15221 LIMIT 2 [ RunTime:0.004682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15221 ORDER BY `minOrder` ASC [ RunTime:0.002740s ]
select * from pdf where partno='25.413.5' and brandshort='MULTICOMP' limit 1 [ RunTime:0.013956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25.413.5' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.015127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15220 LIMIT 4 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220 ORDER BY `minOrder` ASC [ RunTime:0.021321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15220 ORDER BY `unit` DESC [ RunTime:0.024034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15220 LIMIT 2 [ RunTime:0.022362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
select * from pdf where partno='005.03.173' and brandshort='ETTINGER' limit 1 [ RunTime:0.032509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '005.03.173' OR `brand` LIKE 'ETTINGER%' ) ) LIMIT 1 [ RunTime:0.015840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219 LIMIT 4 [ RunTime:0.019750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.035618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219 ORDER BY `unit` DESC [ RunTime:0.026261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219 LIMIT 2 [ RunTime:0.062985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='26101' and brandshort='WIHA' limit 1 [ RunTime:0.041605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26101' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.039592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218 LIMIT 4 [ RunTime:0.054417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.013375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218 ORDER BY `unit` DESC [ RunTime:0.041095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218 LIMIT 2 [ RunTime:0.100345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.019760s ]
select * from pdf where partno='OEP8000' and brandshort='OEP OXFORD ELECTRICAL PRODUCTS' limit 1 [ RunTime:0.061206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OEP8000' OR `brand` LIKE 'OEP (OXFORD ELECTRICAL PRODUCTS)%' ) ) LIMIT 1 [ RunTime:0.088169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15217 LIMIT 4 [ RunTime:0.025278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217 ORDER BY `minOrder` ASC [ RunTime:0.063105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15217 ORDER BY `unit` DESC [ RunTime:0.031124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15217 LIMIT 2 [ RunTime:0.005774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217 ORDER BY `minOrder` ASC [ RunTime:0.001267s ]
select * from pdf where partno='RC1218FK-071R2L' and brandshort='YAGEO' limit 1 [ RunTime:0.023884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC1218FK-071R2L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.043030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216 LIMIT 4 [ RunTime:0.017784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216 ORDER BY `minOrder` ASC [ RunTime:0.020248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216 ORDER BY `unit` DESC [ RunTime:0.034719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216 LIMIT 2 [ RunTime:0.010150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216 ORDER BY `minOrder` ASC [ RunTime:0.008643s ]
select * from pdf where partno='BZX79-C2V4,113' and brandshort='NEXPERIA' limit 1 [ RunTime:0.006370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX79-C2V4,113' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.003160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15215 LIMIT 4 [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215 ORDER BY `minOrder` ASC [ RunTime:0.003962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15215 ORDER BY `unit` DESC [ RunTime:0.008566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15215 LIMIT 2 [ RunTime:0.029643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215 ORDER BY `minOrder` ASC [ RunTime:0.008969s ]
select * from pdf where partno='ERJP06F1821V' and brandshort='PANASONIC' limit 1 [ RunTime:0.013659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJP06F1821V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.041951s ]
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.024958s ]