SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001655s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002333s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001518s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001816s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000280s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001255s ]
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.000997s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001577s ]
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.008841s ]
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 40,20 [ RunTime:0.004192s ]
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 ('16214','16213','16212','16211','16210','16209','16208','16207','16206','16205','16204','16203','16202','16201','16200','16199','16198','16197','16196','16195') ORDER BY FIELD(s.id, 16214,16213,16212,16211,16210,16209,16208,16207,16206,16205,16204,16203,16202,16201,16200,16199,16198,16197,16196,16195) [ RunTime:0.002175s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214 LIMIT 4 [ RunTime:0.004226s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16214 ORDER BY `unit` DESC [ RunTime:0.003109s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16214 LIMIT 2 [ RunTime:0.004683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214 ORDER BY `minOrder` ASC [ RunTime:0.010900s ]
select * from pdf where partno='EEHZC1K330P' and brandshort='PANASONIC' limit 1 [ RunTime:0.038341s ]
select foldpath,foldpath2,filename from pdf_file where id=2012613 limit 1 [ RunTime:0.007690s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEHZC1K330P' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.017696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213 LIMIT 4 [ RunTime:0.001858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213 ORDER BY `unit` DESC [ RunTime:0.006085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213 LIMIT 2 [ RunTime:0.009005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
select * from pdf where partno='640545-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.009035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640545-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.008647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212 LIMIT 4 [ RunTime:0.004948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212 ORDER BY `minOrder` ASC [ RunTime:0.002947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16212 ORDER BY `unit` DESC [ RunTime:0.008472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16212 LIMIT 2 [ RunTime:0.010897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212 ORDER BY `minOrder` ASC [ RunTime:0.006792s ]
select * from pdf where partno='0461164281.' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.006176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0461164281.' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.010632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16211 LIMIT 4 [ RunTime:0.009597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211 ORDER BY `minOrder` ASC [ RunTime:0.007620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16211 ORDER BY `unit` DESC [ RunTime:0.006871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16211 LIMIT 2 [ RunTime:0.003966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211 ORDER BY `minOrder` ASC [ RunTime:0.007743s ]
select * from pdf where partno='1123580000' and brandshort='WEIDMULLER' limit 1 [ RunTime:0.007888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1123580000' OR `brand` LIKE 'WEIDMULLER%' ) ) LIMIT 1 [ RunTime:0.012454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210 LIMIT 4 [ RunTime:0.008527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210 ORDER BY `minOrder` ASC [ RunTime:0.010680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16210 ORDER BY `unit` DESC [ RunTime:0.001622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16210 LIMIT 2 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210 ORDER BY `minOrder` ASC [ RunTime:0.006313s ]
select * from pdf where partno='ERA6AEB103V' and brandshort='PANASONIC' limit 1 [ RunTime:0.010416s ]
select foldpath,foldpath2,filename from pdf_file where id=1488371 limit 1 [ RunTime:0.003075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERA6AEB103V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.019751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209 LIMIT 4 [ RunTime:0.020760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209 ORDER BY `minOrder` ASC [ RunTime:0.006538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209 ORDER BY `unit` DESC [ RunTime:0.011393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209 LIMIT 2 [ RunTime:0.013089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209 ORDER BY `minOrder` ASC [ RunTime:0.003147s ]
select * from pdf where partno='353620350' and brandshort='MOLEX' limit 1 [ RunTime:0.012597s ]
select foldpath,foldpath2,filename from pdf_file where id=849183 limit 1 [ RunTime:0.006867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '353620350' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.015147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208 LIMIT 4 [ RunTime:0.012558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208 ORDER BY `minOrder` ASC [ RunTime:0.021272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208 ORDER BY `unit` DESC [ RunTime:0.016041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208 LIMIT 2 [ RunTime:0.007588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208 ORDER BY `minOrder` ASC [ RunTime:0.006150s ]
select * from pdf where partno='BCX56-10TX' and brandshort='NEXPERIA' limit 1 [ RunTime:0.004614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BCX56-10TX' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.017837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207 LIMIT 4 [ RunTime:0.001387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207 ORDER BY `minOrder` ASC [ RunTime:0.001936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16207 ORDER BY `unit` DESC [ RunTime:0.001270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16207 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207 ORDER BY `minOrder` ASC [ RunTime:0.005708s ]
select * from pdf where partno='BSC014NE2LSIATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.003506s ]
select foldpath,foldpath2,filename from pdf_file where id=1350976 limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSC014NE2LSIATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.003047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206 LIMIT 4 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206 ORDER BY `minOrder` ASC [ RunTime:0.004215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16206 ORDER BY `unit` DESC [ RunTime:0.005859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16206 LIMIT 2 [ RunTime:0.005928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206 ORDER BY `minOrder` ASC [ RunTime:0.004223s ]
select * from pdf where partno='5103308-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.005728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103308-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.019367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205 LIMIT 4 [ RunTime:0.010285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205 ORDER BY `minOrder` ASC [ RunTime:0.000858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16205 ORDER BY `unit` DESC [ RunTime:0.005781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16205 LIMIT 2 [ RunTime:0.006311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='AD7684BRMZRL7' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.004908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AD7684BRMZRL7' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.008172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16204 LIMIT 4 [ RunTime:0.009363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16204 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16204 ORDER BY `unit` DESC [ RunTime:0.003111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16204 LIMIT 2 [ RunTime:0.009372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16204 ORDER BY `minOrder` ASC [ RunTime:0.004571s ]
select * from pdf where partno='ERJ6ENF10R0V' and brandshort='PANASONIC' limit 1 [ RunTime:0.009544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ6ENF10R0V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.018556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16203 LIMIT 4 [ RunTime:0.004798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203 ORDER BY `minOrder` ASC [ RunTime:0.002137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16203 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16203 LIMIT 2 [ RunTime:0.001178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
select * from pdf where partno='BUK7S0R7-40HJ' and brandshort='NEXPERIA' limit 1 [ RunTime:0.001247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BUK7S0R7-40HJ' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16202 LIMIT 4 [ RunTime:0.002482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16202 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16202 ORDER BY `unit` DESC [ RunTime:0.000474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16202 LIMIT 2 [ RunTime:0.005553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16202 ORDER BY `minOrder` ASC [ RunTime:0.002186s ]
select * from pdf where partno='ERJ-PB3B6192V' and brandshort='PANASONIC' limit 1 [ RunTime:0.009938s ]
select foldpath,foldpath2,filename from pdf_file where id=1976083 limit 1 [ RunTime:0.000498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ-PB3B6192V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.008038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16201 LIMIT 4 [ RunTime:0.005594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201 ORDER BY `minOrder` ASC [ RunTime:0.003675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16201 ORDER BY `unit` DESC [ RunTime:0.003145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16201 LIMIT 2 [ RunTime:0.004083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201 ORDER BY `minOrder` ASC [ RunTime:0.001967s ]
select * from pdf where partno='MMSZ5250B' and brandshort='DIODES INC.' limit 1 [ RunTime:0.004789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMSZ5250B' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.005347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16200 LIMIT 4 [ RunTime:0.008818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16200 ORDER BY `minOrder` ASC [ RunTime:0.006031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16200 ORDER BY `unit` DESC [ RunTime:0.002060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16200 LIMIT 2 [ RunTime:0.001872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16200 ORDER BY `minOrder` ASC [ RunTime:0.003159s ]
select * from pdf where partno='779678-01' and brandshort='NI' limit 1 [ RunTime:0.008647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '779678-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.005441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16199 LIMIT 4 [ RunTime:0.001760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16199 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16199 ORDER BY `unit` DESC [ RunTime:0.004168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16199 LIMIT 2 [ RunTime:0.001454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16199 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='CRCW06030000Z0EA' and brandshort='VISHAY' limit 1 [ RunTime:0.003981s ]
select foldpath,foldpath2,filename from pdf_file where id=1141019 limit 1 [ RunTime:0.000490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW06030000Z0EA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.016884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16198 LIMIT 4 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16198 ORDER BY `minOrder` ASC [ RunTime:0.011242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16198 ORDER BY `unit` DESC [ RunTime:0.006071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16198 LIMIT 2 [ RunTime:0.004137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16198 ORDER BY `minOrder` ASC [ RunTime:0.002216s ]
select * from pdf where partno='3-644615-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.003723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3-644615-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197 LIMIT 4 [ RunTime:0.008030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197 ORDER BY `minOrder` ASC [ RunTime:0.003775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197 ORDER BY `unit` DESC [ RunTime:0.005158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197 LIMIT 2 [ RunTime:0.003874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
select * from pdf where partno='US1MFA' and brandshort='ONSEMI' limit 1 [ RunTime:0.001414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US1MFA' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196 LIMIT 4 [ RunTime:0.007491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196 ORDER BY `minOrder` ASC [ RunTime:0.003333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196 ORDER BY `unit` DESC [ RunTime:0.003421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196 LIMIT 2 [ RunTime:0.001657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
select * from pdf where partno='03-09-1032' and brandshort='MOLEX' limit 1 [ RunTime:0.000737s ]
select foldpath,foldpath2,filename from pdf_file where id=821118 limit 1 [ RunTime:0.000365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '03-09-1032' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.003234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16195 LIMIT 4 [ RunTime:0.004859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16195 ORDER BY `minOrder` ASC [ RunTime:0.006260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16195 ORDER BY `unit` DESC [ RunTime:0.007274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16195 LIMIT 2 [ RunTime:0.013048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16195 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
select * from pdf where partno='CRCW0402300KFKED' and brandshort='VISHAY' limit 1 [ RunTime:0.004798s ]
select foldpath,foldpath2,filename from pdf_file where id=1245034 limit 1 [ RunTime:0.003439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW0402300KFKED' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.020149s ]
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.009117s ]