SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003115s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000706s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002021s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001451s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000350s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000239s ]
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.000429s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002040s ]
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.014936s ]
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.017007s ]
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.014295s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234 LIMIT 4 [ RunTime:0.030393s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234 ORDER BY `minOrder` ASC [ RunTime:0.016393s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234 ORDER BY `unit` DESC [ RunTime:0.078061s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234 LIMIT 2 [ RunTime:0.049684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234 ORDER BY `minOrder` ASC [ RunTime:0.016334s ]
select * from pdf where partno='SN74LS11N' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.037154s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74LS11N' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.019887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15233 LIMIT 4 [ RunTime:0.073287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15233 ORDER BY `minOrder` ASC [ RunTime:0.014271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15233 ORDER BY `unit` DESC [ RunTime:0.017345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15233 LIMIT 2 [ RunTime:0.037104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15233 ORDER BY `minOrder` ASC [ RunTime:0.025805s ]
select * from pdf where partno='172338-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.028425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172338-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.018826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232 LIMIT 4 [ RunTime:0.019388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232 ORDER BY `minOrder` ASC [ RunTime:0.066558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232 ORDER BY `unit` DESC [ RunTime:0.023768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232 LIMIT 2 [ RunTime:0.041510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232 ORDER BY `minOrder` ASC [ RunTime:0.022521s ]
select * from pdf where partno='LQH44PN3R3MP0L' and brandshort='MURATA' limit 1 [ RunTime:0.019042s ]
select foldpath,foldpath2,filename from pdf_file where id=2126344 limit 1 [ RunTime:0.054557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LQH44PN3R3MP0L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.053390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231 LIMIT 4 [ RunTime:0.037284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231 ORDER BY `minOrder` ASC [ RunTime:0.034144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231 ORDER BY `unit` DESC [ RunTime:0.045751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231 LIMIT 2 [ RunTime:0.070858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231 ORDER BY `minOrder` ASC [ RunTime:0.019280s ]
select * from pdf where partno='MCWR06X3000FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.031785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X3000FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.020690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15230 LIMIT 4 [ RunTime:0.035504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15230 ORDER BY `minOrder` ASC [ RunTime:0.019803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15230 ORDER BY `unit` DESC [ RunTime:0.030340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15230 LIMIT 2 [ RunTime:0.036617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15230 ORDER BY `minOrder` ASC [ RunTime:0.013722s ]
select * from pdf where partno='112-40064' and brandshort='EPT' limit 1 [ RunTime:0.032775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '112-40064' OR `brand` LIKE 'EPT%' ) ) LIMIT 1 [ RunTime:0.012575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15229 LIMIT 4 [ RunTime:0.069766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15229 ORDER BY `minOrder` ASC [ RunTime:0.059084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15229 ORDER BY `unit` DESC [ RunTime:0.011020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15229 LIMIT 2 [ RunTime:0.039150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15229 ORDER BY `minOrder` ASC [ RunTime:0.035218s ]
select * from pdf where partno='MMBZ33VAL,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.058851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMBZ33VAL,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.070149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15228 LIMIT 4 [ RunTime:0.045222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228 ORDER BY `minOrder` ASC [ RunTime:0.055343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15228 ORDER BY `unit` DESC [ RunTime:0.066658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15228 LIMIT 2 [ RunTime:0.086638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228 ORDER BY `minOrder` ASC [ RunTime:0.020254s ]
select * from pdf where partno='BFP740ESDH6327XTSA1' and brandshort='INFINEON' limit 1 [ RunTime:0.095047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BFP740ESDH6327XTSA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.043754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227 LIMIT 4 [ RunTime:0.033577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227 ORDER BY `minOrder` ASC [ RunTime:0.038938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15227 ORDER BY `unit` DESC [ RunTime:0.054753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15227 LIMIT 2 [ RunTime:0.037345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227 ORDER BY `minOrder` ASC [ RunTime:0.004577s ]
select * from pdf where partno='CRCW120675R0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.030591s ]
select foldpath,foldpath2,filename from pdf_file where id=1295037 limit 1 [ RunTime:0.037826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW120675R0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.069369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226 LIMIT 4 [ RunTime:0.085810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226 ORDER BY `minOrder` ASC [ RunTime:0.038239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226 ORDER BY `unit` DESC [ RunTime:0.100203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226 LIMIT 2 [ RunTime:0.087268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226 ORDER BY `minOrder` ASC [ RunTime:0.026942s ]
select * from pdf where partno='0603B104K500CT' and brandshort='WALSIN' limit 1 [ RunTime:0.049130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0603B104K500CT' OR `brand` LIKE 'WALSIN%' ) ) LIMIT 1 [ RunTime:0.023765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225 LIMIT 4 [ RunTime:0.002566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225 ORDER BY `minOrder` ASC [ RunTime:0.007856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225 ORDER BY `unit` DESC [ RunTime:0.008135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225 LIMIT 2 [ RunTime:0.002761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='ABI-001-RC' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.007777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ABI-001-RC' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.012419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224 LIMIT 4 [ RunTime:0.034071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224 ORDER BY `minOrder` ASC [ RunTime:0.043007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224 ORDER BY `unit` DESC [ RunTime:0.019775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224 LIMIT 2 [ RunTime:0.012788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224 ORDER BY `minOrder` ASC [ RunTime:0.005012s ]
select * from pdf where partno='MRS25000C4990FCT00' and brandshort='VISHAY' limit 1 [ RunTime:0.037046s ]
select foldpath,foldpath2,filename from pdf_file where id=1525849 limit 1 [ RunTime:0.023275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRS25000C4990FCT00' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.048037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223 LIMIT 4 [ RunTime:0.013542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223 ORDER BY `minOrder` ASC [ RunTime:0.049577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223 ORDER BY `unit` DESC [ RunTime:0.041766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223 LIMIT 2 [ RunTime:0.012488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223 ORDER BY `minOrder` ASC [ RunTime:0.021066s ]
select * from pdf where partno='1N4004RL' and brandshort='ONSEMI' limit 1 [ RunTime:0.038845s ]
select foldpath,foldpath2,filename from pdf_file where id=306824 limit 1 [ RunTime:0.069569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4004RL' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.048095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222 LIMIT 4 [ RunTime:0.010990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222 ORDER BY `minOrder` ASC [ RunTime:0.009863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15222 ORDER BY `unit` DESC [ RunTime:0.040459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15222 LIMIT 2 [ RunTime:0.013669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222 ORDER BY `minOrder` ASC [ RunTime:0.022026s ]
select * from pdf where partno='5501-25SA-02-F1' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.038274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5501-25SA-02-F1' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.109163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15221 LIMIT 4 [ RunTime:0.024310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15221 ORDER BY `minOrder` ASC [ RunTime:0.019997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15221 ORDER BY `unit` DESC [ RunTime:0.039268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15221 LIMIT 2 [ RunTime:0.047246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15221 ORDER BY `minOrder` ASC [ RunTime:0.034504s ]
select * from pdf where partno='25.413.5' and brandshort='MULTICOMP' limit 1 [ RunTime:0.040342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25.413.5' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.087104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15220 LIMIT 4 [ RunTime:0.005073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220 ORDER BY `minOrder` ASC [ RunTime:0.032708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15220 ORDER BY `unit` DESC [ RunTime:0.108423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15220 LIMIT 2 [ RunTime:0.085772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220 ORDER BY `minOrder` ASC [ RunTime:0.020706s ]
select * from pdf where partno='005.03.173' and brandshort='ETTINGER' limit 1 [ RunTime:0.025070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '005.03.173' OR `brand` LIKE 'ETTINGER%' ) ) LIMIT 1 [ RunTime:0.029293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219 LIMIT 4 [ RunTime:0.004182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219 ORDER BY `unit` DESC [ RunTime:0.009721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219 LIMIT 2 [ RunTime:0.040823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.003004s ]
select * from pdf where partno='26101' and brandshort='WIHA' limit 1 [ RunTime:0.036197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26101' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.010132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218 LIMIT 4 [ RunTime:0.016723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.024280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218 ORDER BY `unit` DESC [ RunTime:0.031568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218 LIMIT 2 [ RunTime:0.053767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='OEP8000' and brandshort='OEP OXFORD ELECTRICAL PRODUCTS' limit 1 [ RunTime:0.051472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OEP8000' OR `brand` LIKE 'OEP (OXFORD ELECTRICAL PRODUCTS)%' ) ) LIMIT 1 [ RunTime:0.050618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15217 LIMIT 4 [ RunTime:0.001618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217 ORDER BY `minOrder` ASC [ RunTime:0.027191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15217 ORDER BY `unit` DESC [ RunTime:0.007145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15217 LIMIT 2 [ RunTime:0.029231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217 ORDER BY `minOrder` ASC [ RunTime:0.006112s ]
select * from pdf where partno='RC1218FK-071R2L' and brandshort='YAGEO' limit 1 [ RunTime:0.028736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC1218FK-071R2L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.060042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216 LIMIT 4 [ RunTime:0.037881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216 ORDER BY `minOrder` ASC [ RunTime:0.014621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216 ORDER BY `unit` DESC [ RunTime:0.019143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216 LIMIT 2 [ RunTime:0.059460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216 ORDER BY `minOrder` ASC [ RunTime:0.013467s ]
select * from pdf where partno='BZX79-C2V4,113' and brandshort='NEXPERIA' limit 1 [ RunTime:0.012455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX79-C2V4,113' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.063409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15215 LIMIT 4 [ RunTime:0.022687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215 ORDER BY `minOrder` ASC [ RunTime:0.009904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15215 ORDER BY `unit` DESC [ RunTime:0.052694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15215 LIMIT 2 [ RunTime:0.033770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215 ORDER BY `minOrder` ASC [ RunTime:0.019297s ]
select * from pdf where partno='ERJP06F1821V' and brandshort='PANASONIC' limit 1 [ RunTime:0.040923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJP06F1821V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.049358s ]
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.013385s ]