SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001279s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001334s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001006s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000231s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000262s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000186s ]
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.000333s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001090s ]
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.004049s ]
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.003816s ]
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.003352s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474 LIMIT 4 [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15474 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15474 LIMIT 2 [ RunTime:0.002993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474 ORDER BY `minOrder` ASC [ RunTime:0.000166s ]
select * from pdf where partno='2-520193-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001524s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520193-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473 LIMIT 4 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473 LIMIT 2 [ RunTime:0.001560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='SIR462DP-T1-GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.001818s ]
select foldpath,foldpath2,filename from pdf_file where id=1049685 limit 1 [ RunTime:0.008059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SIR462DP-T1-GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.011449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15472 LIMIT 4 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15472 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15472 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15472 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15472 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='LTM8022IV#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.010284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTM8022IV#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.001008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15471 LIMIT 4 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15471 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15471 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15471 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15471 ORDER BY `minOrder` ASC [ RunTime:0.001338s ]
select * from pdf where partno='74HC1G00GW,125' and brandshort='NEXPERIA' limit 1 [ RunTime:0.014060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HC1G00GW,125' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.011551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15470 LIMIT 4 [ RunTime:0.001378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15470 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15470 ORDER BY `unit` DESC [ RunTime:0.004566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15470 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15470 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
select * from pdf where partno='726141002' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.004951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '726141002' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15469 LIMIT 4 [ RunTime:0.001724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15469 ORDER BY `minOrder` ASC [ RunTime:0.003029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15469 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15469 LIMIT 2 [ RunTime:0.000257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15469 ORDER BY `minOrder` ASC [ RunTime:0.001354s ]
select * from pdf where partno='207490-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.003043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '207490-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15468 LIMIT 4 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15468 ORDER BY `minOrder` ASC [ RunTime:0.005848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15468 ORDER BY `unit` DESC [ RunTime:0.002644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15468 LIMIT 2 [ RunTime:0.000923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15468 ORDER BY `minOrder` ASC [ RunTime:0.002300s ]
select * from pdf where partno='CGA2B3X7R0J224K050BB' and brandshort='TDK' limit 1 [ RunTime:0.003247s ]
select foldpath,foldpath2,filename from pdf_file where id=1498717 limit 1 [ RunTime:0.003608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CGA2B3X7R0J224K050BB' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.013521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15467 LIMIT 4 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15467 ORDER BY `minOrder` ASC [ RunTime:0.002971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15467 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15467 LIMIT 2 [ RunTime:0.000253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15467 ORDER BY `minOrder` ASC [ RunTime:0.000156s ]
select * from pdf where partno='M24M01-DFDW6TP' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.001398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M24M01-DFDW6TP' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.003545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15466 LIMIT 4 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15466 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15466 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15466 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15466 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
select * from pdf where partno='09 02 264 6421' and brandshort='HARTING' limit 1 [ RunTime:0.007101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '09 02 264 6421' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15465 LIMIT 4 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15465 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15465 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15465 LIMIT 2 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15465 ORDER BY `minOrder` ASC [ RunTime:0.000155s ]
select * from pdf where partno='2041119-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.004922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041119-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.015677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15464 LIMIT 4 [ RunTime:0.001751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15464 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15464 ORDER BY `unit` DESC [ RunTime:0.000265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15464 LIMIT 2 [ RunTime:0.001460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15464 ORDER BY `minOrder` ASC [ RunTime:0.003080s ]
select * from pdf where partno='UTP01619S' and brandshort='SOURIAU-SUNBANK / EATON' limit 1 [ RunTime:0.002965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP01619S' OR `brand` LIKE 'SOURIAU-SUNBANK / EATON%' ) ) LIMIT 1 [ RunTime:0.000747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15463 LIMIT 4 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15463 ORDER BY `minOrder` ASC [ RunTime:0.005769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15463 ORDER BY `unit` DESC [ RunTime:0.001602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15463 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15463 ORDER BY `minOrder` ASC [ RunTime:0.000159s ]
select * from pdf where partno='LTC1566-1IS8#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.004116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1566-1IS8#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15462 LIMIT 4 [ RunTime:0.001525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15462 ORDER BY `minOrder` ASC [ RunTime:0.004537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15462 ORDER BY `unit` DESC [ RunTime:0.001712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15462 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15462 ORDER BY `minOrder` ASC [ RunTime:0.000160s ]
select * from pdf where partno='MCCTB106M016' and brandshort='MULTICOMP' limit 1 [ RunTime:0.001337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCCTB106M016' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.005398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15461 LIMIT 4 [ RunTime:0.002120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15461 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15461 ORDER BY `unit` DESC [ RunTime:0.000266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15461 LIMIT 2 [ RunTime:0.000257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15461 ORDER BY `minOrder` ASC [ RunTime:0.000156s ]
select * from pdf where partno='LM2903QS-13' and brandshort='DIODES INC.' limit 1 [ RunTime:0.001488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM2903QS-13' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.004230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15460 LIMIT 4 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15460 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15460 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15460 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15460 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
select * from pdf where partno='742841210' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.001086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '742841210' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.005084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15459 LIMIT 4 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15459 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15459 ORDER BY `unit` DESC [ RunTime:0.000269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15459 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15459 ORDER BY `minOrder` ASC [ RunTime:0.000155s ]
select * from pdf where partno='MS1V-T1K 32.768KHZ +-20PPM 12.5PF' and brandshort='MICRO CRYSTAL' limit 1 [ RunTime:0.001522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS1V-T1K 32.768KHZ +-20PPM 12.5PF' OR `brand` LIKE 'MICRO CRYSTAL%' ) ) LIMIT 1 [ RunTime:0.003770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15458 LIMIT 4 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15458 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15458 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15458 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15458 ORDER BY `minOrder` ASC [ RunTime:0.000155s ]
select * from pdf where partno='SFM-105-02-L-D' and brandshort='SAMTEC' limit 1 [ RunTime:0.001351s ]
select foldpath,foldpath2,filename from pdf_file where id=1506124 limit 1 [ RunTime:0.001205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SFM-105-02-L-D' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.002031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15457 LIMIT 4 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15457 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15457 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15457 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15457 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
select * from pdf where partno='ESD103B102ELSE6327XTSA1' and brandshort='INFINEON' limit 1 [ RunTime:0.002963s ]
select foldpath,foldpath2,filename from pdf_file where id=1311709 limit 1 [ RunTime:0.000469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESD103B102ELSE6327XTSA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.006379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15456 LIMIT 4 [ RunTime:0.001570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15456 ORDER BY `minOrder` ASC [ RunTime:0.002978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15456 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15456 LIMIT 2 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15456 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
select * from pdf where partno='SMA5J33AHM3_A/H' and brandshort='VISHAY' limit 1 [ RunTime:0.002056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMA5J33AHM3_A/H' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.006772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15455 LIMIT 4 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15455 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15455 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15455 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15455 ORDER BY `minOrder` ASC [ RunTime:0.000159s ]
select * from pdf where partno='TCM809SVLB713' and brandshort='MICROCHIP' limit 1 [ RunTime:0.002796s ]
select foldpath,foldpath2,filename from pdf_file where id=546557 limit 1 [ RunTime:0.003482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TCM809SVLB713' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.013386s ]
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.004044s ]