SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002062s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002387s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002341s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000291s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000726s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000580s ]
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.004582s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002307s ]
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.008515s ]
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.005940s ]
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.018472s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194 LIMIT 4 [ RunTime:0.000781s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.016856s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16194 ORDER BY `unit` DESC [ RunTime:0.001703s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16194 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='61794-1.' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001512s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61794-1.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.027030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193 LIMIT 4 [ RunTime:0.021350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.030546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16193 ORDER BY `unit` DESC [ RunTime:0.016865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16193 LIMIT 2 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.012036s ]
select * from pdf where partno='926902-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.018493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '926902-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192 LIMIT 4 [ RunTime:0.030057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.022977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192 ORDER BY `unit` DESC [ RunTime:0.034927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192 LIMIT 2 [ RunTime:0.050636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.018085s ]
select * from pdf where partno='LDEIF3470KA0N00' and brandshort='KEMET' limit 1 [ RunTime:0.033990s ]
select foldpath,foldpath2,filename from pdf_file where id=1495047 limit 1 [ RunTime:0.058610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LDEIF3470KA0N00' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.045761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191 LIMIT 4 [ RunTime:0.026734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.033043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191 ORDER BY `unit` DESC [ RunTime:0.146681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191 LIMIT 2 [ RunTime:0.108234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.063028s ]
select * from pdf where partno='783631-01' and brandshort='NI' limit 1 [ RunTime:0.039020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '783631-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.050077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16190 LIMIT 4 [ RunTime:0.045812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.028031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16190 ORDER BY `unit` DESC [ RunTime:0.086618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16190 LIMIT 2 [ RunTime:0.031889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.022088s ]
select * from pdf where partno='RK73B1JTTD200J.' and brandshort='KOA' limit 1 [ RunTime:0.088474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73B1JTTD200J.' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.053891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16189 LIMIT 4 [ RunTime:0.025480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.043052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16189 ORDER BY `unit` DESC [ RunTime:0.108658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16189 LIMIT 2 [ RunTime:0.037984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.029432s ]
select * from pdf where partno='591-2601-013F.' and brandshort='DIALIGHT' limit 1 [ RunTime:0.077988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '591-2601-013F.' OR `brand` LIKE 'DIALIGHT%' ) ) LIMIT 1 [ RunTime:0.065351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16188 LIMIT 4 [ RunTime:0.046476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.078460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16188 ORDER BY `unit` DESC [ RunTime:0.021553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16188 LIMIT 2 [ RunTime:0.037790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.022663s ]
select * from pdf where partno='RC0603FR-0727RL' and brandshort='YAGEO' limit 1 [ RunTime:0.031878s ]
select foldpath,foldpath2,filename from pdf_file where id=1976034 limit 1 [ RunTime:0.026644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603FR-0727RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.026068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187 LIMIT 4 [ RunTime:0.020246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.084957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187 ORDER BY `unit` DESC [ RunTime:0.028845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187 LIMIT 2 [ RunTime:0.039748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.021265s ]
select * from pdf where partno='ZE05H-2P-2H' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.037282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZE05H-2P-2H' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.028529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186 LIMIT 4 [ RunTime:0.011096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.020106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16186 ORDER BY `unit` DESC [ RunTime:0.018492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16186 LIMIT 2 [ RunTime:0.010200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.008009s ]
select * from pdf where partno='UPW1E471MPD' and brandshort='NICHICON' limit 1 [ RunTime:0.014946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UPW1E471MPD' OR `brand` LIKE 'NICHICON%' ) ) LIMIT 1 [ RunTime:0.013693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185 LIMIT 4 [ RunTime:0.034977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.016097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16185 ORDER BY `unit` DESC [ RunTime:0.022509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16185 LIMIT 2 [ RunTime:0.063326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.008333s ]
select * from pdf where partno='VTX-146-080-212' and brandshort='VIGORTRONIX' limit 1 [ RunTime:0.021665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VTX-146-080-212' OR `brand` LIKE 'VIGORTRONIX%' ) ) LIMIT 1 [ RunTime:0.018364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16184 LIMIT 4 [ RunTime:0.013615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.040038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16184 ORDER BY `unit` DESC [ RunTime:0.014224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16184 LIMIT 2 [ RunTime:0.039911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.032588s ]
select * from pdf where partno='V23333Z0001B046' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.024809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V23333Z0001B046' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.021122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16183 LIMIT 4 [ RunTime:0.018131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16183 ORDER BY `unit` DESC [ RunTime:0.006250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16183 LIMIT 2 [ RunTime:0.028342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.019782s ]
select * from pdf where partno='0402CS-18NXGLU' and brandshort='COILCRAFT' limit 1 [ RunTime:0.057486s ]
select foldpath,foldpath2,filename from pdf_file where id=1133160 limit 1 [ RunTime:0.031347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0402CS-18NXGLU' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.046619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182 LIMIT 4 [ RunTime:0.046079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.016588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182 ORDER BY `unit` DESC [ RunTime:0.032874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182 LIMIT 2 [ RunTime:0.075481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.012125s ]
select * from pdf where partno='103000A01F1202' and brandshort='MOLEX' limit 1 [ RunTime:0.028853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103000A01F1202' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.030114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16181 LIMIT 4 [ RunTime:0.068885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.045141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16181 ORDER BY `unit` DESC [ RunTime:0.016125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16181 LIMIT 2 [ RunTime:0.006284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.012017s ]
select * from pdf where partno='1N5817-T' and brandshort='DIODES INC.' limit 1 [ RunTime:0.027260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5817-T' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.012945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16180 LIMIT 4 [ RunTime:0.003230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.032250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16180 ORDER BY `unit` DESC [ RunTime:0.023559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16180 LIMIT 2 [ RunTime:0.004364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.008182s ]
select * from pdf where partno='CTB9300/2A' and brandshort='CAMDENBOSS' limit 1 [ RunTime:0.007700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CTB9300/2A' OR `brand` LIKE 'CAMDENBOSS%' ) ) LIMIT 1 [ RunTime:0.011465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16179 LIMIT 4 [ RunTime:0.004180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.011187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16179 ORDER BY `unit` DESC [ RunTime:0.004052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16179 LIMIT 2 [ RunTime:0.023010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.030832s ]
select * from pdf where partno='C0603C475K9PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.051031s ]
select foldpath,foldpath2,filename from pdf_file where id=530939 limit 1 [ RunTime:0.116947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C475K9PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.032140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16178 LIMIT 4 [ RunTime:0.066216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.087499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16178 ORDER BY `unit` DESC [ RunTime:0.043689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16178 LIMIT 2 [ RunTime:0.022529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.005987s ]
select * from pdf where partno='VLR-02V' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.041438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VLR-02V' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.017635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16177 LIMIT 4 [ RunTime:0.025914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.050596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16177 ORDER BY `unit` DESC [ RunTime:0.080352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16177 LIMIT 2 [ RunTime:0.021214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.060672s ]
select * from pdf where partno='B32641B0183J000' and brandshort='EPCOS' limit 1 [ RunTime:0.032014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B32641B0183J000' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.063326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16176 LIMIT 4 [ RunTime:0.035750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.041512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16176 ORDER BY `unit` DESC [ RunTime:0.054382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16176 LIMIT 2 [ RunTime:0.047150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.007226s ]
select * from pdf where partno='RK73H1ETTP40R2F' and brandshort='KOA' limit 1 [ RunTime:0.049642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73H1ETTP40R2F' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.027974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16175 LIMIT 4 [ RunTime:0.004929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.044538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16175 ORDER BY `unit` DESC [ RunTime:0.028984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16175 LIMIT 2 [ RunTime:0.019265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='MCF 0.25W 100K' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.032913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCF 0.25W 100K' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.032390s ]
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.130609s ]