SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001259s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001694s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001470s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000234s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001065s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000849s ]
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.001024s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001317s ]
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.000605s ]
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 60,20 [ RunTime:0.006506s ]
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 ('16194','16193','16192','16191','16190','16189','16188','16187','16186','16185','16184','16183','16182','16181','16180','16179','16178','16177','16176','16175') ORDER BY FIELD(s.id, 16194,16193,16192,16191,16190,16189,16188,16187,16186,16185,16184,16183,16182,16181,16180,16179,16178,16177,16176,16175) [ RunTime:0.005756s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194 LIMIT 4 [ RunTime:0.004206s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.028810s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16194 ORDER BY `unit` DESC [ RunTime:0.021759s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16194 LIMIT 2 [ RunTime:0.018007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.002320s ]
select * from pdf where partno='61794-1.' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.011668s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61794-1.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.017419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193 LIMIT 4 [ RunTime:0.016605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.006048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16193 ORDER BY `unit` DESC [ RunTime:0.006196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16193 LIMIT 2 [ RunTime:0.035346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.004463s ]
select * from pdf where partno='926902-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.010185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '926902-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192 LIMIT 4 [ RunTime:0.005666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.018209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192 ORDER BY `unit` DESC [ RunTime:0.010792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192 LIMIT 2 [ RunTime:0.009840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.008490s ]
select * from pdf where partno='LDEIF3470KA0N00' and brandshort='KEMET' limit 1 [ RunTime:0.006186s ]
select foldpath,foldpath2,filename from pdf_file where id=1495047 limit 1 [ RunTime:0.006451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LDEIF3470KA0N00' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.007583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191 LIMIT 4 [ RunTime:0.004575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.010167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191 ORDER BY `unit` DESC [ RunTime:0.011599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191 LIMIT 2 [ RunTime:0.019501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.012163s ]
select * from pdf where partno='783631-01' and brandshort='NI' limit 1 [ RunTime:0.016353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '783631-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.029951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16190 LIMIT 4 [ RunTime:0.020263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.019339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16190 ORDER BY `unit` DESC [ RunTime:0.011997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16190 LIMIT 2 [ RunTime:0.009214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.008035s ]
select * from pdf where partno='RK73B1JTTD200J.' and brandshort='KOA' limit 1 [ RunTime:0.012641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73B1JTTD200J.' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.012824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16189 LIMIT 4 [ RunTime:0.018039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.005866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16189 ORDER BY `unit` DESC [ RunTime:0.020640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16189 LIMIT 2 [ RunTime:0.006176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.009895s ]
select * from pdf where partno='591-2601-013F.' and brandshort='DIALIGHT' limit 1 [ RunTime:0.010491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '591-2601-013F.' OR `brand` LIKE 'DIALIGHT%' ) ) LIMIT 1 [ RunTime:0.010694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16188 LIMIT 4 [ RunTime:0.001802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16188 ORDER BY `unit` DESC [ RunTime:0.003480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16188 LIMIT 2 [ RunTime:0.010782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.004748s ]
select * from pdf where partno='RC0603FR-0727RL' and brandshort='YAGEO' limit 1 [ RunTime:0.006138s ]
select foldpath,foldpath2,filename from pdf_file where id=1976034 limit 1 [ RunTime:0.001177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603FR-0727RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187 LIMIT 4 [ RunTime:0.011327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.008230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187 ORDER BY `unit` DESC [ RunTime:0.005355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187 LIMIT 2 [ RunTime:0.014304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.002077s ]
select * from pdf where partno='ZE05H-2P-2H' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.009488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZE05H-2P-2H' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.002031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186 LIMIT 4 [ RunTime:0.001048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.009519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16186 ORDER BY `unit` DESC [ RunTime:0.017523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16186 LIMIT 2 [ RunTime:0.001214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.012775s ]
select * from pdf where partno='UPW1E471MPD' and brandshort='NICHICON' limit 1 [ RunTime:0.018396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UPW1E471MPD' OR `brand` LIKE 'NICHICON%' ) ) LIMIT 1 [ RunTime:0.015619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185 LIMIT 4 [ RunTime:0.010235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.013517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16185 ORDER BY `unit` DESC [ RunTime:0.012474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16185 LIMIT 2 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='VTX-146-080-212' and brandshort='VIGORTRONIX' limit 1 [ RunTime:0.007248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VTX-146-080-212' OR `brand` LIKE 'VIGORTRONIX%' ) ) LIMIT 1 [ RunTime:0.013103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16184 LIMIT 4 [ RunTime:0.004096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.003379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16184 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16184 LIMIT 2 [ RunTime:0.010221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.005425s ]
select * from pdf where partno='V23333Z0001B046' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.011760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V23333Z0001B046' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.028813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16183 LIMIT 4 [ RunTime:0.021782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.013589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16183 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16183 LIMIT 2 [ RunTime:0.006092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.007260s ]
select * from pdf where partno='0402CS-18NXGLU' and brandshort='COILCRAFT' limit 1 [ RunTime:0.018883s ]
select foldpath,foldpath2,filename from pdf_file where id=1133160 limit 1 [ RunTime:0.017259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0402CS-18NXGLU' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.005354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182 LIMIT 4 [ RunTime:0.018113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.011895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182 ORDER BY `unit` DESC [ RunTime:0.003414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182 LIMIT 2 [ RunTime:0.005984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
select * from pdf where partno='103000A01F1202' and brandshort='MOLEX' limit 1 [ RunTime:0.003674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103000A01F1202' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.018279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16181 LIMIT 4 [ RunTime:0.005798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.004282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16181 ORDER BY `unit` DESC [ RunTime:0.001686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16181 LIMIT 2 [ RunTime:0.009841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.003462s ]
select * from pdf where partno='1N5817-T' and brandshort='DIODES INC.' limit 1 [ RunTime:0.018197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5817-T' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.008575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16180 LIMIT 4 [ RunTime:0.001751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.003684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16180 ORDER BY `unit` DESC [ RunTime:0.003763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16180 LIMIT 2 [ RunTime:0.004335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.021271s ]
select * from pdf where partno='CTB9300/2A' and brandshort='CAMDENBOSS' limit 1 [ RunTime:0.018879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CTB9300/2A' OR `brand` LIKE 'CAMDENBOSS%' ) ) LIMIT 1 [ RunTime:0.013342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16179 LIMIT 4 [ RunTime:0.006420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.021266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16179 ORDER BY `unit` DESC [ RunTime:0.014393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16179 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='C0603C475K9PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.008122s ]
select foldpath,foldpath2,filename from pdf_file where id=530939 limit 1 [ RunTime:0.003404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C475K9PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.016900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16178 LIMIT 4 [ RunTime:0.013940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.013433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16178 ORDER BY `unit` DESC [ RunTime:0.028953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16178 LIMIT 2 [ RunTime:0.024186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.006510s ]
select * from pdf where partno='VLR-02V' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.036354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VLR-02V' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.007758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16177 LIMIT 4 [ RunTime:0.020486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.047747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16177 ORDER BY `unit` DESC [ RunTime:0.028563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16177 LIMIT 2 [ RunTime:0.003784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
select * from pdf where partno='B32641B0183J000' and brandshort='EPCOS' limit 1 [ RunTime:0.004305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B32641B0183J000' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.002949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16176 LIMIT 4 [ RunTime:0.017827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.008685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16176 ORDER BY `unit` DESC [ RunTime:0.015298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16176 LIMIT 2 [ RunTime:0.006176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.006510s ]
select * from pdf where partno='RK73H1ETTP40R2F' and brandshort='KOA' limit 1 [ RunTime:0.004726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73H1ETTP40R2F' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.002814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16175 LIMIT 4 [ RunTime:0.013916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16175 ORDER BY `unit` DESC [ RunTime:0.013294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16175 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.002798s ]
select * from pdf where partno='MCF 0.25W 100K' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.017361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCF 0.25W 100K' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.003657s ]
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.003837s ]