SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002834s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.024187s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001901s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.057776s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002446s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.039137s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.097499s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.080647s ]
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.033572s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002778s ]
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.017057s ]
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 1040,20 [ RunTime:0.244713s ]
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 ('15214','15213','15212','15211','15210','15209','15208','15207','15206','15205','15204','15203','15202','15201','15200','15199','15198','15197','15196','15195') ORDER BY FIELD(s.id, 15214,15213,15212,15211,15210,15209,15208,15207,15206,15205,15204,15203,15202,15201,15200,15199,15198,15197,15196,15195) [ RunTime:0.148448s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15214 LIMIT 4 [ RunTime:0.039849s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.034916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15214 ORDER BY `minOrder` ASC [ RunTime:0.038041s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15214 ORDER BY `unit` DESC [ RunTime:0.160366s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15214 LIMIT 2 [ RunTime:0.046218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15214 ORDER BY `minOrder` ASC [ RunTime:0.080947s ]
select * from pdf where partno='0903 296 6825' and brandshort='HARTING' limit 1 [ RunTime:0.117085s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0903 296 6825' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.067516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15213 LIMIT 4 [ RunTime:0.035009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213 ORDER BY `minOrder` ASC [ RunTime:0.101360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15213 ORDER BY `unit` DESC [ RunTime:0.071228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15213 LIMIT 2 [ RunTime:0.125110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213 ORDER BY `minOrder` ASC [ RunTime:0.075495s ]
select * from pdf where partno='SCT3060ALGC11' and brandshort='ROHM' limit 1 [ RunTime:0.083940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SCT3060ALGC11' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.096958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212 LIMIT 4 [ RunTime:0.056920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212 ORDER BY `minOrder` ASC [ RunTime:0.050226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212 ORDER BY `unit` DESC [ RunTime:0.029669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212 LIMIT 2 [ RunTime:0.037799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212 ORDER BY `minOrder` ASC [ RunTime:0.096119s ]
select * from pdf where partno='ERJPA3F4300V' and brandshort='PANASONIC' limit 1 [ RunTime:0.034176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJPA3F4300V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.038812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211 LIMIT 4 [ RunTime:0.073603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211 ORDER BY `minOrder` ASC [ RunTime:0.087218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15211 ORDER BY `unit` DESC [ RunTime:0.083051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15211 LIMIT 2 [ RunTime:0.058565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211 ORDER BY `minOrder` ASC [ RunTime:0.033804s ]
select * from pdf where partno='MCSC80-W2' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.109758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCSC80-W2' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.025230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210 LIMIT 4 [ RunTime:0.040941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210 ORDER BY `minOrder` ASC [ RunTime:0.168102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210 ORDER BY `unit` DESC [ RunTime:0.104154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210 LIMIT 2 [ RunTime:0.094087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210 ORDER BY `minOrder` ASC [ RunTime:0.130789s ]
select * from pdf where partno='BC846BPDW1T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.054369s ]
select foldpath,foldpath2,filename from pdf_file where id=952060 limit 1 [ RunTime:0.017375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC846BPDW1T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.103396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15209 LIMIT 4 [ RunTime:0.090093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209 ORDER BY `minOrder` ASC [ RunTime:0.119448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15209 ORDER BY `unit` DESC [ RunTime:0.109317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15209 LIMIT 2 [ RunTime:0.038734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209 ORDER BY `minOrder` ASC [ RunTime:0.039762s ]
select * from pdf where partno='C315C103K5R5TA' and brandshort='KEMET' limit 1 [ RunTime:0.162197s ]
select foldpath,foldpath2,filename from pdf_file where id=1637727 limit 1 [ RunTime:0.112158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C315C103K5R5TA' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.045109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15208 LIMIT 4 [ RunTime:0.065748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15208 ORDER BY `minOrder` ASC [ RunTime:0.006868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15208 ORDER BY `unit` DESC [ RunTime:0.044723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15208 LIMIT 2 [ RunTime:0.057333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15208 ORDER BY `minOrder` ASC [ RunTime:0.009057s ]
select * from pdf where partno='SMAJ28CA-13-F' and brandshort='DIODES INC.' limit 1 [ RunTime:0.024497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ28CA-13-F' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.038189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15207 LIMIT 4 [ RunTime:0.035152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207 ORDER BY `minOrder` ASC [ RunTime:0.031687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15207 ORDER BY `unit` DESC [ RunTime:0.024750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15207 LIMIT 2 [ RunTime:0.029577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207 ORDER BY `minOrder` ASC [ RunTime:0.021117s ]
select * from pdf where partno='D00120' and brandshort='DURATOOL' limit 1 [ RunTime:0.037240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D00120' OR `brand` LIKE 'DURATOOL%' ) ) LIMIT 1 [ RunTime:0.005938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206 LIMIT 4 [ RunTime:0.018862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206 ORDER BY `minOrder` ASC [ RunTime:0.016128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206 ORDER BY `unit` DESC [ RunTime:0.006062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206 LIMIT 2 [ RunTime:0.003636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206 ORDER BY `minOrder` ASC [ RunTime:0.007468s ]
select * from pdf where partno='4-2103177-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.009392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4-2103177-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.037625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15205 LIMIT 4 [ RunTime:0.012927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15205 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15205 ORDER BY `unit` DESC [ RunTime:0.007087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15205 LIMIT 2 [ RunTime:0.019142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15205 ORDER BY `minOrder` ASC [ RunTime:0.008732s ]
select * from pdf where partno='CRCW080512K0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.021262s ]
select foldpath,foldpath2,filename from pdf_file where id=1523774 limit 1 [ RunTime:0.011244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW080512K0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.039791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204 LIMIT 4 [ RunTime:0.023805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204 ORDER BY `minOrder` ASC [ RunTime:0.034132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204 ORDER BY `unit` DESC [ RunTime:0.028966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204 LIMIT 2 [ RunTime:0.005626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204 ORDER BY `minOrder` ASC [ RunTime:0.016856s ]
select * from pdf where partno='MB6S' and brandshort='ONSEMI' limit 1 [ RunTime:0.017289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB6S' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.025953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203 LIMIT 4 [ RunTime:0.025060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203 ORDER BY `minOrder` ASC [ RunTime:0.002046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203 ORDER BY `unit` DESC [ RunTime:0.005566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203 LIMIT 2 [ RunTime:0.023414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203 ORDER BY `minOrder` ASC [ RunTime:0.007090s ]
select * from pdf where partno='SBCP53T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.010567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBCP53T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.026036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15202 LIMIT 4 [ RunTime:0.022454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202 ORDER BY `minOrder` ASC [ RunTime:0.018834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15202 ORDER BY `unit` DESC [ RunTime:0.011589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15202 LIMIT 2 [ RunTime:0.011626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202 ORDER BY `minOrder` ASC [ RunTime:0.015135s ]
select * from pdf where partno='415-0028-M1.5.' and brandshort='JOHNSON - CINCH CONNECTIVITY' limit 1 [ RunTime:0.035294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '415-0028-M1.5.' OR `brand` LIKE 'JOHNSON - CINCH CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.020341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15201 LIMIT 4 [ RunTime:0.006139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15201 ORDER BY `minOrder` ASC [ RunTime:0.008037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15201 ORDER BY `unit` DESC [ RunTime:0.023712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15201 LIMIT 2 [ RunTime:0.004794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15201 ORDER BY `minOrder` ASC [ RunTime:0.011757s ]
select * from pdf where partno='MAL214699901E3' and brandshort='VISHAY' limit 1 [ RunTime:0.015616s ]
select foldpath,foldpath2,filename from pdf_file where id=1919990 limit 1 [ RunTime:0.011184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAL214699901E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.029804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15200 LIMIT 4 [ RunTime:0.007909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15200 ORDER BY `minOrder` ASC [ RunTime:0.022637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15200 ORDER BY `unit` DESC [ RunTime:0.012373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15200 LIMIT 2 [ RunTime:0.009766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15200 ORDER BY `minOrder` ASC [ RunTime:0.037508s ]
select * from pdf where partno='350777-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.007367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '350777-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.022454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15199 LIMIT 4 [ RunTime:0.025012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15199 ORDER BY `minOrder` ASC [ RunTime:0.022975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15199 ORDER BY `unit` DESC [ RunTime:0.032580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15199 LIMIT 2 [ RunTime:0.044996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15199 ORDER BY `minOrder` ASC [ RunTime:0.037544s ]
select * from pdf where partno='C1005X7R1H473K050BB' and brandshort='TDK' limit 1 [ RunTime:0.021412s ]
select foldpath,foldpath2,filename from pdf_file where id=1497009 limit 1 [ RunTime:0.004485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1005X7R1H473K050BB' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.067417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15198 LIMIT 4 [ RunTime:0.012752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15198 ORDER BY `minOrder` ASC [ RunTime:0.032803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15198 ORDER BY `unit` DESC [ RunTime:0.058967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15198 LIMIT 2 [ RunTime:0.054143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15198 ORDER BY `minOrder` ASC [ RunTime:0.020263s ]
select * from pdf where partno='MAL214699602E3' and brandshort='VISHAY' limit 1 [ RunTime:0.046590s ]
select foldpath,foldpath2,filename from pdf_file where id=1055770 limit 1 [ RunTime:0.056176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAL214699602E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.049103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15197 LIMIT 4 [ RunTime:0.044144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15197 ORDER BY `minOrder` ASC [ RunTime:0.015847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15197 ORDER BY `unit` DESC [ RunTime:0.018730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15197 LIMIT 2 [ RunTime:0.012088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15197 ORDER BY `minOrder` ASC [ RunTime:0.018249s ]
select * from pdf where partno='08055A471FAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.013561s ]
select foldpath,foldpath2,filename from pdf_file where id=1512553 limit 1 [ RunTime:0.045599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '08055A471FAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.032910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15196 LIMIT 4 [ RunTime:0.014082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15196 ORDER BY `minOrder` ASC [ RunTime:0.041948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15196 ORDER BY `unit` DESC [ RunTime:0.009907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15196 LIMIT 2 [ RunTime:0.011240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15196 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
select * from pdf where partno='HEF4066BT,653' and brandshort='NEXPERIA' limit 1 [ RunTime:0.004655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HEF4066BT,653' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.008505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15195 LIMIT 4 [ RunTime:0.011795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15195 ORDER BY `minOrder` ASC [ RunTime:0.033895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15195 ORDER BY `unit` DESC [ RunTime:0.006558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15195 LIMIT 2 [ RunTime:0.032364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15195 ORDER BY `minOrder` ASC [ RunTime:0.003157s ]
select * from pdf where partno='ASMB-KTF0-0A306' and brandshort='BROADCOM' limit 1 [ RunTime:0.030896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ASMB-KTF0-0A306' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.017878s ]
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.007050s ]