SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001938s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000566s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001820s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001364s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000993s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001629s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000384s ]
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.000794s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001874s ]
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.009060s ]
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.008842s ]
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.003929s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194 LIMIT 4 [ RunTime:0.002589s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.007800s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16194 ORDER BY `unit` DESC [ RunTime:0.006661s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16194 LIMIT 2 [ RunTime:0.002482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.002953s ]
select * from pdf where partno='61794-1.' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.012345s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61794-1.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.018382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193 LIMIT 4 [ RunTime:0.025386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.020334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16193 ORDER BY `unit` DESC [ RunTime:0.002090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16193 LIMIT 2 [ RunTime:0.008256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.000938s ]
select * from pdf where partno='926902-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.010405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '926902-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.009105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192 LIMIT 4 [ RunTime:0.011814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.007586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192 ORDER BY `unit` DESC [ RunTime:0.013854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192 LIMIT 2 [ RunTime:0.011106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.003666s ]
select * from pdf where partno='LDEIF3470KA0N00' and brandshort='KEMET' limit 1 [ RunTime:0.013070s ]
select foldpath,foldpath2,filename from pdf_file where id=1495047 limit 1 [ RunTime:0.009916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LDEIF3470KA0N00' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.026530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191 LIMIT 4 [ RunTime:0.017359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.005921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191 ORDER BY `unit` DESC [ RunTime:0.011361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191 LIMIT 2 [ RunTime:0.008387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
select * from pdf where partno='783631-01' and brandshort='NI' limit 1 [ RunTime:0.002412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '783631-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.016537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16190 LIMIT 4 [ RunTime:0.002504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.007635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16190 ORDER BY `unit` DESC [ RunTime:0.008870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16190 LIMIT 2 [ RunTime:0.013775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.004874s ]
select * from pdf where partno='RK73B1JTTD200J.' and brandshort='KOA' limit 1 [ RunTime:0.007184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73B1JTTD200J.' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.004829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16189 LIMIT 4 [ RunTime:0.012258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.009510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16189 ORDER BY `unit` DESC [ RunTime:0.013934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16189 LIMIT 2 [ RunTime:0.007160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.006390s ]
select * from pdf where partno='591-2601-013F.' and brandshort='DIALIGHT' limit 1 [ RunTime:0.009598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '591-2601-013F.' OR `brand` LIKE 'DIALIGHT%' ) ) LIMIT 1 [ RunTime:0.021255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16188 LIMIT 4 [ RunTime:0.013843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.020164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16188 ORDER BY `unit` DESC [ RunTime:0.009651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16188 LIMIT 2 [ RunTime:0.007561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.001035s ]
select * from pdf where partno='RC0603FR-0727RL' and brandshort='YAGEO' limit 1 [ RunTime:0.011331s ]
select foldpath,foldpath2,filename from pdf_file where id=1976034 limit 1 [ RunTime:0.000912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603FR-0727RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187 LIMIT 4 [ RunTime:0.006275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.005166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187 ORDER BY `unit` DESC [ RunTime:0.002559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187 LIMIT 2 [ RunTime:0.004852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.003121s ]
select * from pdf where partno='ZE05H-2P-2H' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.009619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZE05H-2P-2H' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.013353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186 LIMIT 4 [ RunTime:0.009311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.013757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16186 ORDER BY `unit` DESC [ RunTime:0.004261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16186 LIMIT 2 [ RunTime:0.001068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.004825s ]
select * from pdf where partno='UPW1E471MPD' and brandshort='NICHICON' limit 1 [ RunTime:0.005029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UPW1E471MPD' OR `brand` LIKE 'NICHICON%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185 LIMIT 4 [ RunTime:0.001987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.007430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16185 ORDER BY `unit` DESC [ RunTime:0.008563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16185 LIMIT 2 [ RunTime:0.003697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.003764s ]
select * from pdf where partno='VTX-146-080-212' and brandshort='VIGORTRONIX' limit 1 [ RunTime:0.010530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VTX-146-080-212' OR `brand` LIKE 'VIGORTRONIX%' ) ) LIMIT 1 [ RunTime:0.006694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16184 LIMIT 4 [ RunTime:0.008527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.009757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16184 ORDER BY `unit` DESC [ RunTime:0.005449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16184 LIMIT 2 [ RunTime:0.002230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.004452s ]
select * from pdf where partno='V23333Z0001B046' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.003777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V23333Z0001B046' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16183 LIMIT 4 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16183 ORDER BY `unit` DESC [ RunTime:0.002697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16183 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.002456s ]
select * from pdf where partno='0402CS-18NXGLU' and brandshort='COILCRAFT' limit 1 [ RunTime:0.006057s ]
select foldpath,foldpath2,filename from pdf_file where id=1133160 limit 1 [ RunTime:0.007440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0402CS-18NXGLU' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182 LIMIT 4 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.001291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182 ORDER BY `unit` DESC [ RunTime:0.001089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182 LIMIT 2 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
select * from pdf where partno='103000A01F1202' and brandshort='MOLEX' limit 1 [ RunTime:0.003706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103000A01F1202' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.001694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16181 LIMIT 4 [ RunTime:0.002687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.005202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16181 ORDER BY `unit` DESC [ RunTime:0.004152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16181 LIMIT 2 [ RunTime:0.004478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.005010s ]
select * from pdf where partno='1N5817-T' and brandshort='DIODES INC.' limit 1 [ RunTime:0.012160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5817-T' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.011628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16180 LIMIT 4 [ RunTime:0.014414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.004632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16180 ORDER BY `unit` DESC [ RunTime:0.004531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16180 LIMIT 2 [ RunTime:0.001713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='CTB9300/2A' and brandshort='CAMDENBOSS' limit 1 [ RunTime:0.005875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CTB9300/2A' OR `brand` LIKE 'CAMDENBOSS%' ) ) LIMIT 1 [ RunTime:0.002484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16179 LIMIT 4 [ RunTime:0.001242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.001406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16179 ORDER BY `unit` DESC [ RunTime:0.002866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16179 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
select * from pdf where partno='C0603C475K9PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.007962s ]
select foldpath,foldpath2,filename from pdf_file where id=530939 limit 1 [ RunTime:0.007555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C475K9PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16178 LIMIT 4 [ RunTime:0.003673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16178 ORDER BY `unit` DESC [ RunTime:0.005344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16178 LIMIT 2 [ RunTime:0.007206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.002328s ]
select * from pdf where partno='VLR-02V' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.009878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VLR-02V' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.009242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16177 LIMIT 4 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.005299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16177 ORDER BY `unit` DESC [ RunTime:0.007095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16177 LIMIT 2 [ RunTime:0.005602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='B32641B0183J000' and brandshort='EPCOS' limit 1 [ RunTime:0.006648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B32641B0183J000' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.003659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16176 LIMIT 4 [ RunTime:0.010346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.015019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16176 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16176 LIMIT 2 [ RunTime:0.003492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.002746s ]
select * from pdf where partno='RK73H1ETTP40R2F' and brandshort='KOA' limit 1 [ RunTime:0.006768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73H1ETTP40R2F' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.001015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16175 LIMIT 4 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16175 ORDER BY `unit` DESC [ RunTime:0.010817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16175 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='MCF 0.25W 100K' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.002064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCF 0.25W 100K' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.001030s ]
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.010349s ]