SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001163s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005740s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001333s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.002806s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001110s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011639s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002925s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000213s ]
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.008527s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001519s ]
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.018528s ]
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.038477s ]
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.015150s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15214 LIMIT 4 [ RunTime:0.014422s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15214 ORDER BY `minOrder` ASC [ RunTime:0.021300s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15214 ORDER BY `unit` DESC [ RunTime:0.016246s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15214 LIMIT 2 [ RunTime:0.003149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15214 ORDER BY `minOrder` ASC [ RunTime:0.009938s ]
select * from pdf where partno='0903 296 6825' and brandshort='HARTING' limit 1 [ RunTime:0.012109s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.005687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0903 296 6825' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15213 LIMIT 4 [ RunTime:0.001893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213 ORDER BY `minOrder` ASC [ RunTime:0.004393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15213 ORDER BY `unit` DESC [ RunTime:0.015276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15213 LIMIT 2 [ RunTime:0.023837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213 ORDER BY `minOrder` ASC [ RunTime:0.001447s ]
select * from pdf where partno='SCT3060ALGC11' and brandshort='ROHM' limit 1 [ RunTime:0.013234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SCT3060ALGC11' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.016006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212 LIMIT 4 [ RunTime:0.028001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212 ORDER BY `minOrder` ASC [ RunTime:0.017827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212 ORDER BY `unit` DESC [ RunTime:0.015108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212 LIMIT 2 [ RunTime:0.013772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212 ORDER BY `minOrder` ASC [ RunTime:0.006519s ]
select * from pdf where partno='ERJPA3F4300V' and brandshort='PANASONIC' limit 1 [ RunTime:0.008385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJPA3F4300V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.036521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211 LIMIT 4 [ RunTime:0.008768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211 ORDER BY `minOrder` ASC [ RunTime:0.025732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15211 ORDER BY `unit` DESC [ RunTime:0.009291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15211 LIMIT 2 [ RunTime:0.010674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211 ORDER BY `minOrder` ASC [ RunTime:0.001588s ]
select * from pdf where partno='MCSC80-W2' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.012767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCSC80-W2' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.004942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210 LIMIT 4 [ RunTime:0.010318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210 ORDER BY `minOrder` ASC [ RunTime:0.018448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210 ORDER BY `unit` DESC [ RunTime:0.007172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210 LIMIT 2 [ RunTime:0.005000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210 ORDER BY `minOrder` ASC [ RunTime:0.007151s ]
select * from pdf where partno='BC846BPDW1T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.011771s ]
select foldpath,foldpath2,filename from pdf_file where id=952060 limit 1 [ RunTime:0.011585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC846BPDW1T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.026495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15209 LIMIT 4 [ RunTime:0.002867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209 ORDER BY `minOrder` ASC [ RunTime:0.030801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15209 ORDER BY `unit` DESC [ RunTime:0.003940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15209 LIMIT 2 [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209 ORDER BY `minOrder` ASC [ RunTime:0.007247s ]
select * from pdf where partno='C315C103K5R5TA' and brandshort='KEMET' limit 1 [ RunTime:0.021631s ]
select foldpath,foldpath2,filename from pdf_file where id=1637727 limit 1 [ RunTime:0.011069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C315C103K5R5TA' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.012406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15208 LIMIT 4 [ RunTime:0.006069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15208 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15208 ORDER BY `unit` DESC [ RunTime:0.001537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15208 LIMIT 2 [ RunTime:0.013541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15208 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='SMAJ28CA-13-F' and brandshort='DIODES INC.' limit 1 [ RunTime:0.007980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ28CA-13-F' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.027126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15207 LIMIT 4 [ RunTime:0.010292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207 ORDER BY `minOrder` ASC [ RunTime:0.005899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15207 ORDER BY `unit` DESC [ RunTime:0.010797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15207 LIMIT 2 [ RunTime:0.004211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207 ORDER BY `minOrder` ASC [ RunTime:0.001237s ]
select * from pdf where partno='D00120' and brandshort='DURATOOL' limit 1 [ RunTime:0.006446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D00120' OR `brand` LIKE 'DURATOOL%' ) ) LIMIT 1 [ RunTime:0.011895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206 LIMIT 4 [ RunTime:0.005205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206 ORDER BY `minOrder` ASC [ RunTime:0.001890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206 ORDER BY `unit` DESC [ RunTime:0.003670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206 LIMIT 2 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206 ORDER BY `minOrder` ASC [ RunTime:0.006138s ]
select * from pdf where partno='4-2103177-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.002885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4-2103177-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.009824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15205 LIMIT 4 [ RunTime:0.009223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15205 ORDER BY `minOrder` ASC [ RunTime:0.007142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15205 ORDER BY `unit` DESC [ RunTime:0.040205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15205 LIMIT 2 [ RunTime:0.030550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15205 ORDER BY `minOrder` ASC [ RunTime:0.013307s ]
select * from pdf where partno='CRCW080512K0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.020353s ]
select foldpath,foldpath2,filename from pdf_file where id=1523774 limit 1 [ RunTime:0.013129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW080512K0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.023633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204 LIMIT 4 [ RunTime:0.017192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204 ORDER BY `minOrder` ASC [ RunTime:0.008894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204 ORDER BY `unit` DESC [ RunTime:0.003661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204 LIMIT 2 [ RunTime:0.014229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204 ORDER BY `minOrder` ASC [ RunTime:0.011935s ]
select * from pdf where partno='MB6S' and brandshort='ONSEMI' limit 1 [ RunTime:0.007169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB6S' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.035397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203 LIMIT 4 [ RunTime:0.019970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203 ORDER BY `minOrder` ASC [ RunTime:0.018210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203 ORDER BY `unit` DESC [ RunTime:0.010999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203 LIMIT 2 [ RunTime:0.012436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203 ORDER BY `minOrder` ASC [ RunTime:0.013054s ]
select * from pdf where partno='SBCP53T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.016833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBCP53T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.033316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15202 LIMIT 4 [ RunTime:0.004444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202 ORDER BY `minOrder` ASC [ RunTime:0.024731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15202 ORDER BY `unit` DESC [ RunTime:0.010384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15202 LIMIT 2 [ RunTime:0.013371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202 ORDER BY `minOrder` ASC [ RunTime:0.004975s ]
select * from pdf where partno='415-0028-M1.5.' and brandshort='JOHNSON - CINCH CONNECTIVITY' limit 1 [ RunTime:0.024192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '415-0028-M1.5.' OR `brand` LIKE 'JOHNSON - CINCH CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.008171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15201 LIMIT 4 [ RunTime:0.004344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15201 ORDER BY `minOrder` ASC [ RunTime:0.028438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15201 ORDER BY `unit` DESC [ RunTime:0.015792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15201 LIMIT 2 [ RunTime:0.015177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15201 ORDER BY `minOrder` ASC [ RunTime:0.004281s ]
select * from pdf where partno='MAL214699901E3' and brandshort='VISHAY' limit 1 [ RunTime:0.006379s ]
select foldpath,foldpath2,filename from pdf_file where id=1919990 limit 1 [ RunTime:0.008415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAL214699901E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.018868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15200 LIMIT 4 [ RunTime:0.012037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15200 ORDER BY `minOrder` ASC [ RunTime:0.011706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15200 ORDER BY `unit` DESC [ RunTime:0.006756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15200 LIMIT 2 [ RunTime:0.016472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15200 ORDER BY `minOrder` ASC [ RunTime:0.003510s ]
select * from pdf where partno='350777-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.004184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '350777-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.010382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15199 LIMIT 4 [ RunTime:0.008016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15199 ORDER BY `minOrder` ASC [ RunTime:0.019679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15199 ORDER BY `unit` DESC [ RunTime:0.007299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15199 LIMIT 2 [ RunTime:0.006374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15199 ORDER BY `minOrder` ASC [ RunTime:0.015448s ]
select * from pdf where partno='C1005X7R1H473K050BB' and brandshort='TDK' limit 1 [ RunTime:0.013210s ]
select foldpath,foldpath2,filename from pdf_file where id=1497009 limit 1 [ RunTime:0.004695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1005X7R1H473K050BB' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.010361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15198 LIMIT 4 [ RunTime:0.016212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15198 ORDER BY `minOrder` ASC [ RunTime:0.015838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15198 ORDER BY `unit` DESC [ RunTime:0.014766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15198 LIMIT 2 [ RunTime:0.010075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15198 ORDER BY `minOrder` ASC [ RunTime:0.005694s ]
select * from pdf where partno='MAL214699602E3' and brandshort='VISHAY' limit 1 [ RunTime:0.004830s ]
select foldpath,foldpath2,filename from pdf_file where id=1055770 limit 1 [ RunTime:0.016238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAL214699602E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.027867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15197 LIMIT 4 [ RunTime:0.005696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15197 ORDER BY `minOrder` ASC [ RunTime:0.006003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15197 ORDER BY `unit` DESC [ RunTime:0.006175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15197 LIMIT 2 [ RunTime:0.000890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15197 ORDER BY `minOrder` ASC [ RunTime:0.004962s ]
select * from pdf where partno='08055A471FAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.001627s ]
select foldpath,foldpath2,filename from pdf_file where id=1512553 limit 1 [ RunTime:0.006941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '08055A471FAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.007281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15196 LIMIT 4 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15196 ORDER BY `minOrder` ASC [ RunTime:0.002086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15196 ORDER BY `unit` DESC [ RunTime:0.007924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15196 LIMIT 2 [ RunTime:0.002773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15196 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
select * from pdf where partno='HEF4066BT,653' and brandshort='NEXPERIA' limit 1 [ RunTime:0.014673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HEF4066BT,653' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.011956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15195 LIMIT 4 [ RunTime:0.005752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15195 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15195 ORDER BY `unit` DESC [ RunTime:0.004243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15195 LIMIT 2 [ RunTime:0.003128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15195 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='ASMB-KTF0-0A306' and brandshort='BROADCOM' limit 1 [ RunTime:0.006051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ASMB-KTF0-0A306' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.021203s ]
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.003049s ]