SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001984s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002191s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.001046s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002362s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000287s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003806s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001755s ]
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.000497s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002125s ]
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.008613s ]
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.020873s ]
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.051882s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15214 LIMIT 4 [ RunTime:0.005885s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15214 ORDER BY `minOrder` ASC [ RunTime:0.042263s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15214 ORDER BY `unit` DESC [ RunTime:0.026496s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.027784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15214 LIMIT 2 [ RunTime:0.017961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15214 ORDER BY `minOrder` ASC [ RunTime:0.037252s ]
select * from pdf where partno='0903 296 6825' and brandshort='HARTING' limit 1 [ RunTime:0.032379s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0903 296 6825' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.049735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15213 LIMIT 4 [ RunTime:0.068574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213 ORDER BY `minOrder` ASC [ RunTime:0.072263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15213 ORDER BY `unit` DESC [ RunTime:0.025097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15213 LIMIT 2 [ RunTime:0.034247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213 ORDER BY `minOrder` ASC [ RunTime:0.045945s ]
select * from pdf where partno='SCT3060ALGC11' and brandshort='ROHM' limit 1 [ RunTime:0.025852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SCT3060ALGC11' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.036204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212 LIMIT 4 [ RunTime:0.013311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212 ORDER BY `minOrder` ASC [ RunTime:0.043639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212 ORDER BY `unit` DESC [ RunTime:0.049096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212 LIMIT 2 [ RunTime:0.047381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212 ORDER BY `minOrder` ASC [ RunTime:0.021252s ]
select * from pdf where partno='ERJPA3F4300V' and brandshort='PANASONIC' limit 1 [ RunTime:0.022562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJPA3F4300V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.024995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211 LIMIT 4 [ RunTime:0.065536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211 ORDER BY `minOrder` ASC [ RunTime:0.040909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15211 ORDER BY `unit` DESC [ RunTime:0.044135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15211 LIMIT 2 [ RunTime:0.062131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211 ORDER BY `minOrder` ASC [ RunTime:0.025634s ]
select * from pdf where partno='MCSC80-W2' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.046841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCSC80-W2' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.165531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210 LIMIT 4 [ RunTime:0.059231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210 ORDER BY `minOrder` ASC [ RunTime:0.043844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210 ORDER BY `unit` DESC [ RunTime:0.071122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210 LIMIT 2 [ RunTime:0.080458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210 ORDER BY `minOrder` ASC [ RunTime:0.032353s ]
select * from pdf where partno='BC846BPDW1T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.032469s ]
select foldpath,foldpath2,filename from pdf_file where id=952060 limit 1 [ RunTime:0.022715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC846BPDW1T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.093129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15209 LIMIT 4 [ RunTime:0.034565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209 ORDER BY `minOrder` ASC [ RunTime:0.023233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15209 ORDER BY `unit` DESC [ RunTime:0.041934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15209 LIMIT 2 [ RunTime:0.051060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209 ORDER BY `minOrder` ASC [ RunTime:0.030058s ]
select * from pdf where partno='C315C103K5R5TA' and brandshort='KEMET' limit 1 [ RunTime:0.033825s ]
select foldpath,foldpath2,filename from pdf_file where id=1637727 limit 1 [ RunTime:0.045825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C315C103K5R5TA' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.039151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15208 LIMIT 4 [ RunTime:0.046649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15208 ORDER BY `minOrder` ASC [ RunTime:0.020152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15208 ORDER BY `unit` DESC [ RunTime:0.060407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15208 LIMIT 2 [ RunTime:0.000971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15208 ORDER BY `minOrder` ASC [ RunTime:0.022470s ]
select * from pdf where partno='SMAJ28CA-13-F' and brandshort='DIODES INC.' limit 1 [ RunTime:0.128193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ28CA-13-F' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.021738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15207 LIMIT 4 [ RunTime:0.030293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207 ORDER BY `minOrder` ASC [ RunTime:0.030459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15207 ORDER BY `unit` DESC [ RunTime:0.096474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15207 LIMIT 2 [ RunTime:0.072774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207 ORDER BY `minOrder` ASC [ RunTime:0.044250s ]
select * from pdf where partno='D00120' and brandshort='DURATOOL' limit 1 [ RunTime:0.026731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D00120' OR `brand` LIKE 'DURATOOL%' ) ) LIMIT 1 [ RunTime:0.047304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206 LIMIT 4 [ RunTime:0.037152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206 ORDER BY `minOrder` ASC [ RunTime:0.021154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206 ORDER BY `unit` DESC [ RunTime:0.014258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206 LIMIT 2 [ RunTime:0.053726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206 ORDER BY `minOrder` ASC [ RunTime:0.014472s ]
select * from pdf where partno='4-2103177-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.029289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4-2103177-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.071038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15205 LIMIT 4 [ RunTime:0.035161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15205 ORDER BY `minOrder` ASC [ RunTime:0.008743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15205 ORDER BY `unit` DESC [ RunTime:0.043581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15205 LIMIT 2 [ RunTime:0.006936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15205 ORDER BY `minOrder` ASC [ RunTime:0.005769s ]
select * from pdf where partno='CRCW080512K0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.026986s ]
select foldpath,foldpath2,filename from pdf_file where id=1523774 limit 1 [ RunTime:0.020151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW080512K0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.053280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204 LIMIT 4 [ RunTime:0.008870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204 ORDER BY `minOrder` ASC [ RunTime:0.021777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204 ORDER BY `unit` DESC [ RunTime:0.077140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204 LIMIT 2 [ RunTime:0.047946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204 ORDER BY `minOrder` ASC [ RunTime:0.014705s ]
select * from pdf where partno='MB6S' and brandshort='ONSEMI' limit 1 [ RunTime:0.012663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB6S' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.034979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203 LIMIT 4 [ RunTime:0.012235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203 ORDER BY `minOrder` ASC [ RunTime:0.030015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203 ORDER BY `unit` DESC [ RunTime:0.091007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203 LIMIT 2 [ RunTime:0.025549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203 ORDER BY `minOrder` ASC [ RunTime:0.014640s ]
select * from pdf where partno='SBCP53T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.057238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBCP53T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.039430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15202 LIMIT 4 [ RunTime:0.059606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202 ORDER BY `minOrder` ASC [ RunTime:0.035712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15202 ORDER BY `unit` DESC [ RunTime:0.044718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15202 LIMIT 2 [ RunTime:0.073824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
select * from pdf where partno='415-0028-M1.5.' and brandshort='JOHNSON - CINCH CONNECTIVITY' limit 1 [ RunTime:0.020395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '415-0028-M1.5.' OR `brand` LIKE 'JOHNSON - CINCH CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.030116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15201 LIMIT 4 [ RunTime:0.036457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15201 ORDER BY `minOrder` ASC [ RunTime:0.120815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15201 ORDER BY `unit` DESC [ RunTime:0.032351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15201 LIMIT 2 [ RunTime:0.056121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15201 ORDER BY `minOrder` ASC [ RunTime:0.008741s ]
select * from pdf where partno='MAL214699901E3' and brandshort='VISHAY' limit 1 [ RunTime:0.038717s ]
select foldpath,foldpath2,filename from pdf_file where id=1919990 limit 1 [ RunTime:0.059762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAL214699901E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.033148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15200 LIMIT 4 [ RunTime:0.043205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15200 ORDER BY `minOrder` ASC [ RunTime:0.042019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15200 ORDER BY `unit` DESC [ RunTime:0.048329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15200 LIMIT 2 [ RunTime:0.066411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15200 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='350777-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.025271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '350777-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15199 LIMIT 4 [ RunTime:0.021346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15199 ORDER BY `minOrder` ASC [ RunTime:0.028663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15199 ORDER BY `unit` DESC [ RunTime:0.034921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15199 LIMIT 2 [ RunTime:0.066645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15199 ORDER BY `minOrder` ASC [ RunTime:0.022076s ]
select * from pdf where partno='C1005X7R1H473K050BB' and brandshort='TDK' limit 1 [ RunTime:0.035389s ]
select foldpath,foldpath2,filename from pdf_file where id=1497009 limit 1 [ RunTime:0.004193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1005X7R1H473K050BB' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.051763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15198 LIMIT 4 [ RunTime:0.023573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15198 ORDER BY `minOrder` ASC [ RunTime:0.006097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15198 ORDER BY `unit` DESC [ RunTime:0.063080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15198 LIMIT 2 [ RunTime:0.035415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15198 ORDER BY `minOrder` ASC [ RunTime:0.055414s ]
select * from pdf where partno='MAL214699602E3' and brandshort='VISHAY' limit 1 [ RunTime:0.047987s ]
select foldpath,foldpath2,filename from pdf_file where id=1055770 limit 1 [ RunTime:0.054990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAL214699602E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.040380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15197 LIMIT 4 [ RunTime:0.018002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15197 ORDER BY `minOrder` ASC [ RunTime:0.005046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15197 ORDER BY `unit` DESC [ RunTime:0.034365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15197 LIMIT 2 [ RunTime:0.037392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15197 ORDER BY `minOrder` ASC [ RunTime:0.013945s ]
select * from pdf where partno='08055A471FAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.020515s ]
select foldpath,foldpath2,filename from pdf_file where id=1512553 limit 1 [ RunTime:0.021478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '08055A471FAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.019305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15196 LIMIT 4 [ RunTime:0.012296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15196 ORDER BY `minOrder` ASC [ RunTime:0.015411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15196 ORDER BY `unit` DESC [ RunTime:0.049165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15196 LIMIT 2 [ RunTime:0.026274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15196 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='HEF4066BT,653' and brandshort='NEXPERIA' limit 1 [ RunTime:0.021506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HEF4066BT,653' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.023553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15195 LIMIT 4 [ RunTime:0.045498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15195 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15195 ORDER BY `unit` DESC [ RunTime:0.003328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15195 LIMIT 2 [ RunTime:0.010719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15195 ORDER BY `minOrder` ASC [ RunTime:0.011566s ]
select * from pdf where partno='ASMB-KTF0-0A306' and brandshort='BROADCOM' limit 1 [ RunTime:0.004528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ASMB-KTF0-0A306' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.002887s ]
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.003704s ]