SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001271s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.012942s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001554s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.010981s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001657s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000665s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012094s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002324s ]
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.006990s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002737s ]
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.006503s ]
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.017225s ]
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.027046s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234 LIMIT 4 [ RunTime:0.010899s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234 ORDER BY `minOrder` ASC [ RunTime:0.012826s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234 ORDER BY `unit` DESC [ RunTime:0.003120s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234 LIMIT 2 [ RunTime:0.008493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234 ORDER BY `minOrder` ASC [ RunTime:0.002052s ]
select * from pdf where partno='SN74LS11N' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.016154s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74LS11N' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.005408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15233 LIMIT 4 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15233 ORDER BY `minOrder` ASC [ RunTime:0.002637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15233 ORDER BY `unit` DESC [ RunTime:0.009618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15233 LIMIT 2 [ RunTime:0.003602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15233 ORDER BY `minOrder` ASC [ RunTime:0.003047s ]
select * from pdf where partno='172338-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.018390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172338-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.012377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232 LIMIT 4 [ RunTime:0.002606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232 ORDER BY `minOrder` ASC [ RunTime:0.010495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232 ORDER BY `unit` DESC [ RunTime:0.010972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232 LIMIT 2 [ RunTime:0.005463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232 ORDER BY `minOrder` ASC [ RunTime:0.001065s ]
select * from pdf where partno='LQH44PN3R3MP0L' and brandshort='MURATA' limit 1 [ RunTime:0.014772s ]
select foldpath,foldpath2,filename from pdf_file where id=2126344 limit 1 [ RunTime:0.008820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LQH44PN3R3MP0L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.023184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231 LIMIT 4 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231 ORDER BY `minOrder` ASC [ RunTime:0.006431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231 ORDER BY `unit` DESC [ RunTime:0.010380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231 LIMIT 2 [ RunTime:0.012780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231 ORDER BY `minOrder` ASC [ RunTime:0.007316s ]
select * from pdf where partno='MCWR06X3000FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.002340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X3000FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.003128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15230 LIMIT 4 [ RunTime:0.005743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15230 ORDER BY `minOrder` ASC [ RunTime:0.005087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15230 ORDER BY `unit` DESC [ RunTime:0.019657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15230 LIMIT 2 [ RunTime:0.006405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15230 ORDER BY `minOrder` ASC [ RunTime:0.004369s ]
select * from pdf where partno='112-40064' and brandshort='EPT' limit 1 [ RunTime:0.009045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '112-40064' OR `brand` LIKE 'EPT%' ) ) LIMIT 1 [ RunTime:0.014787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15229 LIMIT 4 [ RunTime:0.013812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15229 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15229 ORDER BY `unit` DESC [ RunTime:0.004937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15229 LIMIT 2 [ RunTime:0.012467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15229 ORDER BY `minOrder` ASC [ RunTime:0.001991s ]
select * from pdf where partno='MMBZ33VAL,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.012607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMBZ33VAL,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.016230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15228 LIMIT 4 [ RunTime:0.018315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228 ORDER BY `minOrder` ASC [ RunTime:0.019451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15228 ORDER BY `unit` DESC [ RunTime:0.006093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15228 LIMIT 2 [ RunTime:0.003594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228 ORDER BY `minOrder` ASC [ RunTime:0.008647s ]
select * from pdf where partno='BFP740ESDH6327XTSA1' and brandshort='INFINEON' limit 1 [ RunTime:0.006577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BFP740ESDH6327XTSA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.013128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227 LIMIT 4 [ RunTime:0.007742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227 ORDER BY `minOrder` ASC [ RunTime:0.005552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15227 ORDER BY `unit` DESC [ RunTime:0.004123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15227 LIMIT 2 [ RunTime:0.001097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227 ORDER BY `minOrder` ASC [ RunTime:0.006420s ]
select * from pdf where partno='CRCW120675R0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.012636s ]
select foldpath,foldpath2,filename from pdf_file where id=1295037 limit 1 [ RunTime:0.008275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW120675R0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.023245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226 LIMIT 4 [ RunTime:0.021617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226 ORDER BY `minOrder` ASC [ RunTime:0.010879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226 ORDER BY `unit` DESC [ RunTime:0.007107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226 LIMIT 2 [ RunTime:0.021625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226 ORDER BY `minOrder` ASC [ RunTime:0.008052s ]
select * from pdf where partno='0603B104K500CT' and brandshort='WALSIN' limit 1 [ RunTime:0.008424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0603B104K500CT' OR `brand` LIKE 'WALSIN%' ) ) LIMIT 1 [ RunTime:0.012528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225 LIMIT 4 [ RunTime:0.011078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225 ORDER BY `minOrder` ASC [ RunTime:0.010022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225 ORDER BY `unit` DESC [ RunTime:0.000839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225 LIMIT 2 [ RunTime:0.007780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225 ORDER BY `minOrder` ASC [ RunTime:0.002460s ]
select * from pdf where partno='ABI-001-RC' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.003126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ABI-001-RC' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.003572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224 LIMIT 4 [ RunTime:0.019353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224 ORDER BY `minOrder` ASC [ RunTime:0.007674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224 ORDER BY `unit` DESC [ RunTime:0.004530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224 LIMIT 2 [ RunTime:0.010697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224 ORDER BY `minOrder` ASC [ RunTime:0.011771s ]
select * from pdf where partno='MRS25000C4990FCT00' and brandshort='VISHAY' limit 1 [ RunTime:0.009924s ]
select foldpath,foldpath2,filename from pdf_file where id=1525849 limit 1 [ RunTime:0.005225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRS25000C4990FCT00' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.024718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223 LIMIT 4 [ RunTime:0.008092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223 ORDER BY `minOrder` ASC [ RunTime:0.002887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223 ORDER BY `unit` DESC [ RunTime:0.023789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223 LIMIT 2 [ RunTime:0.006654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223 ORDER BY `minOrder` ASC [ RunTime:0.006523s ]
select * from pdf where partno='1N4004RL' and brandshort='ONSEMI' limit 1 [ RunTime:0.013199s ]
select foldpath,foldpath2,filename from pdf_file where id=306824 limit 1 [ RunTime:0.014754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4004RL' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.034907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222 LIMIT 4 [ RunTime:0.014787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15222 ORDER BY `unit` DESC [ RunTime:0.017477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15222 LIMIT 2 [ RunTime:0.012659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222 ORDER BY `minOrder` ASC [ RunTime:0.001383s ]
select * from pdf where partno='5501-25SA-02-F1' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.009163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5501-25SA-02-F1' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.012519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15221 LIMIT 4 [ RunTime:0.003105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15221 ORDER BY `minOrder` ASC [ RunTime:0.002612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15221 ORDER BY `unit` DESC [ RunTime:0.006527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15221 LIMIT 2 [ RunTime:0.025017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15221 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
select * from pdf where partno='25.413.5' and brandshort='MULTICOMP' limit 1 [ RunTime:0.013366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25.413.5' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.015084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15220 LIMIT 4 [ RunTime:0.012091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220 ORDER BY `minOrder` ASC [ RunTime:0.014446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15220 ORDER BY `unit` DESC [ RunTime:0.006277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15220 LIMIT 2 [ RunTime:0.001760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220 ORDER BY `minOrder` ASC [ RunTime:0.001356s ]
select * from pdf where partno='005.03.173' and brandshort='ETTINGER' limit 1 [ RunTime:0.006389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '005.03.173' OR `brand` LIKE 'ETTINGER%' ) ) LIMIT 1 [ RunTime:0.009769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219 LIMIT 4 [ RunTime:0.004044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.006855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219 ORDER BY `unit` DESC [ RunTime:0.002525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219 LIMIT 2 [ RunTime:0.007119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.004327s ]
select * from pdf where partno='26101' and brandshort='WIHA' limit 1 [ RunTime:0.008795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26101' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.002572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218 LIMIT 4 [ RunTime:0.006784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.002414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218 ORDER BY `unit` DESC [ RunTime:0.005451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
select * from pdf where partno='OEP8000' and brandshort='OEP OXFORD ELECTRICAL PRODUCTS' limit 1 [ RunTime:0.001457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OEP8000' OR `brand` LIKE 'OEP (OXFORD ELECTRICAL PRODUCTS)%' ) ) LIMIT 1 [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15217 LIMIT 4 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217 ORDER BY `minOrder` ASC [ RunTime:0.011227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15217 ORDER BY `unit` DESC [ RunTime:0.008633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15217 LIMIT 2 [ RunTime:0.002743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217 ORDER BY `minOrder` ASC [ RunTime:0.004911s ]
select * from pdf where partno='RC1218FK-071R2L' and brandshort='YAGEO' limit 1 [ RunTime:0.014416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC1218FK-071R2L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216 LIMIT 4 [ RunTime:0.016944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216 ORDER BY `minOrder` ASC [ RunTime:0.016250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216 ORDER BY `unit` DESC [ RunTime:0.006092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216 LIMIT 2 [ RunTime:0.013931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216 ORDER BY `minOrder` ASC [ RunTime:0.006276s ]
select * from pdf where partno='BZX79-C2V4,113' and brandshort='NEXPERIA' limit 1 [ RunTime:0.013350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX79-C2V4,113' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.012404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15215 LIMIT 4 [ RunTime:0.007289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215 ORDER BY `minOrder` ASC [ RunTime:0.012500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15215 ORDER BY `unit` DESC [ RunTime:0.005180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15215 LIMIT 2 [ RunTime:0.009858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215 ORDER BY `minOrder` ASC [ RunTime:0.003647s ]
select * from pdf where partno='ERJP06F1821V' and brandshort='PANASONIC' limit 1 [ RunTime:0.011714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJP06F1821V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.021417s ]
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.003148s ]