SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002138s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005113s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002805s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.004458s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002329s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002457s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002697s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006399s ]
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.000563s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002851s ]
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.013374s ]
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 780,20 [ RunTime:0.011772s ]
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 ('15474','15473','15472','15471','15470','15469','15468','15467','15466','15465','15464','15463','15462','15461','15460','15459','15458','15457','15456','15455') ORDER BY FIELD(s.id, 15474,15473,15472,15471,15470,15469,15468,15467,15466,15465,15464,15463,15462,15461,15460,15459,15458,15457,15456,15455) [ RunTime:0.005714s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474 LIMIT 4 [ RunTime:0.001295s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15474 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15474 LIMIT 2 [ RunTime:0.005694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474 ORDER BY `minOrder` ASC [ RunTime:0.003504s ]
select * from pdf where partno='2-520193-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.007188s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520193-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.004601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473 LIMIT 4 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473 ORDER BY `minOrder` ASC [ RunTime:0.011195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473 ORDER BY `unit` DESC [ RunTime:0.001494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473 LIMIT 2 [ RunTime:0.004247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473 ORDER BY `minOrder` ASC [ RunTime:0.003100s ]
select * from pdf where partno='SIR462DP-T1-GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.007818s ]
select foldpath,foldpath2,filename from pdf_file where id=1049685 limit 1 [ RunTime:0.002945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SIR462DP-T1-GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.016604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15472 LIMIT 4 [ RunTime:0.005919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15472 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15472 ORDER BY `unit` DESC [ RunTime:0.000757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15472 LIMIT 2 [ RunTime:0.003725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15472 ORDER BY `minOrder` ASC [ RunTime:0.002879s ]
select * from pdf where partno='LTM8022IV#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.004190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTM8022IV#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.002785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15471 LIMIT 4 [ RunTime:0.003331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15471 ORDER BY `minOrder` ASC [ RunTime:0.001129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15471 ORDER BY `unit` DESC [ RunTime:0.000851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15471 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15471 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='74HC1G00GW,125' and brandshort='NEXPERIA' limit 1 [ RunTime:0.001677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HC1G00GW,125' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.007101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15470 LIMIT 4 [ RunTime:0.009667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15470 ORDER BY `minOrder` ASC [ RunTime:0.004759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15470 ORDER BY `unit` DESC [ RunTime:0.004327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15470 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15470 ORDER BY `minOrder` ASC [ RunTime:0.002287s ]
select * from pdf where partno='726141002' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.005650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '726141002' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.009655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15469 LIMIT 4 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15469 ORDER BY `minOrder` ASC [ RunTime:0.009203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15469 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15469 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15469 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='207490-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '207490-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15468 LIMIT 4 [ RunTime:0.004546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15468 ORDER BY `minOrder` ASC [ RunTime:0.002949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15468 ORDER BY `unit` DESC [ RunTime:0.001407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15468 LIMIT 2 [ RunTime:0.004369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15468 ORDER BY `minOrder` ASC [ RunTime:0.002951s ]
select * from pdf where partno='CGA2B3X7R0J224K050BB' and brandshort='TDK' limit 1 [ RunTime:0.004905s ]
select foldpath,foldpath2,filename from pdf_file where id=1498717 limit 1 [ RunTime:0.001948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CGA2B3X7R0J224K050BB' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.006738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15467 LIMIT 4 [ RunTime:0.001636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15467 ORDER BY `minOrder` ASC [ RunTime:0.001777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15467 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15467 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15467 ORDER BY `minOrder` ASC [ RunTime:0.000190s ]
select * from pdf where partno='M24M01-DFDW6TP' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.002722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M24M01-DFDW6TP' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15466 LIMIT 4 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15466 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15466 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15466 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15466 ORDER BY `minOrder` ASC [ RunTime:0.001458s ]
select * from pdf where partno='09 02 264 6421' and brandshort='HARTING' limit 1 [ RunTime:0.009527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '09 02 264 6421' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15465 LIMIT 4 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15465 ORDER BY `minOrder` ASC [ RunTime:0.001328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15465 ORDER BY `unit` DESC [ RunTime:0.001168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15465 LIMIT 2 [ RunTime:0.013893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15465 ORDER BY `minOrder` ASC [ RunTime:0.001815s ]
select * from pdf where partno='2041119-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.006276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041119-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.028210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15464 LIMIT 4 [ RunTime:0.002856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15464 ORDER BY `minOrder` ASC [ RunTime:0.005989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15464 ORDER BY `unit` DESC [ RunTime:0.004700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15464 LIMIT 2 [ RunTime:0.001066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15464 ORDER BY `minOrder` ASC [ RunTime:0.000204s ]
select * from pdf where partno='UTP01619S' and brandshort='SOURIAU-SUNBANK / EATON' limit 1 [ RunTime:0.010580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP01619S' OR `brand` LIKE 'SOURIAU-SUNBANK / EATON%' ) ) LIMIT 1 [ RunTime:0.009169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15463 LIMIT 4 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15463 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15463 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15463 LIMIT 2 [ RunTime:0.004486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15463 ORDER BY `minOrder` ASC [ RunTime:0.002447s ]
select * from pdf where partno='LTC1566-1IS8#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.002864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1566-1IS8#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.006337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15462 LIMIT 4 [ RunTime:0.012371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15462 ORDER BY `minOrder` ASC [ RunTime:0.013379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15462 ORDER BY `unit` DESC [ RunTime:0.001871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15462 LIMIT 2 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15462 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='MCCTB106M016' and brandshort='MULTICOMP' limit 1 [ RunTime:0.001352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCCTB106M016' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.002650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15461 LIMIT 4 [ RunTime:0.010643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15461 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15461 ORDER BY `unit` DESC [ RunTime:0.002910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15461 LIMIT 2 [ RunTime:0.004403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15461 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='LM2903QS-13' and brandshort='DIODES INC.' limit 1 [ RunTime:0.004462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM2903QS-13' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.003635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15460 LIMIT 4 [ RunTime:0.009369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15460 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15460 ORDER BY `unit` DESC [ RunTime:0.012621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15460 LIMIT 2 [ RunTime:0.006960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15460 ORDER BY `minOrder` ASC [ RunTime:0.001462s ]
select * from pdf where partno='742841210' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.003527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '742841210' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.004361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15459 LIMIT 4 [ RunTime:0.014180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15459 ORDER BY `minOrder` ASC [ RunTime:0.011247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15459 ORDER BY `unit` DESC [ RunTime:0.007000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15459 LIMIT 2 [ RunTime:0.014549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15459 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='MS1V-T1K 32.768KHZ +-20PPM 12.5PF' and brandshort='MICRO CRYSTAL' limit 1 [ RunTime:0.001659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS1V-T1K 32.768KHZ +-20PPM 12.5PF' OR `brand` LIKE 'MICRO CRYSTAL%' ) ) LIMIT 1 [ RunTime:0.004717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15458 LIMIT 4 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15458 ORDER BY `minOrder` ASC [ RunTime:0.002491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15458 ORDER BY `unit` DESC [ RunTime:0.001509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15458 LIMIT 2 [ RunTime:0.011573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15458 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='SFM-105-02-L-D' and brandshort='SAMTEC' limit 1 [ RunTime:0.001691s ]
select foldpath,foldpath2,filename from pdf_file where id=1506124 limit 1 [ RunTime:0.006161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SFM-105-02-L-D' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.003709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15457 LIMIT 4 [ RunTime:0.004674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15457 ORDER BY `minOrder` ASC [ RunTime:0.003645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15457 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15457 LIMIT 2 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15457 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
select * from pdf where partno='ESD103B102ELSE6327XTSA1' and brandshort='INFINEON' limit 1 [ RunTime:0.001709s ]
select foldpath,foldpath2,filename from pdf_file where id=1311709 limit 1 [ RunTime:0.002350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESD103B102ELSE6327XTSA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.013541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15456 LIMIT 4 [ RunTime:0.014085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15456 ORDER BY `minOrder` ASC [ RunTime:0.014186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15456 ORDER BY `unit` DESC [ RunTime:0.005002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15456 LIMIT 2 [ RunTime:0.008618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15456 ORDER BY `minOrder` ASC [ RunTime:0.007859s ]
select * from pdf where partno='SMA5J33AHM3_A/H' and brandshort='VISHAY' limit 1 [ RunTime:0.003501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMA5J33AHM3_A/H' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.023596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15455 LIMIT 4 [ RunTime:0.014139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15455 ORDER BY `minOrder` ASC [ RunTime:0.012708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15455 ORDER BY `unit` DESC [ RunTime:0.001836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15455 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15455 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='TCM809SVLB713' and brandshort='MICROCHIP' limit 1 [ RunTime:0.022926s ]
select foldpath,foldpath2,filename from pdf_file where id=546557 limit 1 [ RunTime:0.011425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TCM809SVLB713' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.032389s ]
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.015020s ]