SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001084s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.70' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock/index?page=4&srecordnum=99&status=3' [ RunTime:0.005075s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001496s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010003s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001481s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.70' ) [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001220s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005543s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001354s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.018433s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17191 LIMIT 5 [ RunTime:0.021250s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17191 ORDER BY `minOrder` ASC [ RunTime:0.010911s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17191 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17191 LIMIT 2 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17191 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='TPS630702RNMR' and brandshort='TI' limit 1 [ RunTime:0.005209s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPS630702RNMR' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.034940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17181 LIMIT 5 [ RunTime:0.027438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17181 ORDER BY `minOrder` ASC [ RunTime:0.040238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17181 ORDER BY `unit` DESC [ RunTime:0.057505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17181 LIMIT 2 [ RunTime:0.035829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17181 ORDER BY `minOrder` ASC [ RunTime:0.023245s ]
select * from pdf where partno='HC32F460JEUA-QFN48TR' and brandshort='HDSC' limit 1 [ RunTime:0.044414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC32F460JEUA-QFN48TR' OR `brand` LIKE 'HDSC%' ) ) LIMIT 1 [ RunTime:0.040647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17248 LIMIT 5 [ RunTime:0.053036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17248 ORDER BY `minOrder` ASC [ RunTime:0.049676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17248 ORDER BY `unit` DESC [ RunTime:0.031445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17248 LIMIT 2 [ RunTime:0.027701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17248 ORDER BY `minOrder` ASC [ RunTime:0.046658s ]
select * from pdf where partno='BSP752R' and brandshort='INFINEON' limit 1 [ RunTime:0.029753s ]
select foldpath,foldpath2,filename from pdf_file where id=319176 limit 1 [ RunTime:0.032593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSP752R' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.065820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17246 LIMIT 5 [ RunTime:0.028163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17246 ORDER BY `minOrder` ASC [ RunTime:0.017260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17246 ORDER BY `unit` DESC [ RunTime:0.035948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17246 LIMIT 2 [ RunTime:0.016757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17246 ORDER BY `minOrder` ASC [ RunTime:0.011844s ]
select * from pdf where partno='IPA60R280P7S' and brandshort='INFINEON' limit 1 [ RunTime:0.002456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IPA60R280P7S' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.045961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17202 LIMIT 5 [ RunTime:0.058777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17202 ORDER BY `minOrder` ASC [ RunTime:0.026428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17202 ORDER BY `unit` DESC [ RunTime:0.020479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17202 LIMIT 2 [ RunTime:0.039806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17202 ORDER BY `minOrder` ASC [ RunTime:0.012758s ]
select * from pdf where partno='AM26C31IDR' and brandshort='TI' limit 1 [ RunTime:0.006024s ]
select foldpath,foldpath2,filename from pdf_file where id=315127 limit 1 [ RunTime:0.037974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM26C31IDR' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.075592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17167 LIMIT 5 [ RunTime:0.009281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17167 ORDER BY `minOrder` ASC [ RunTime:0.006291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17167 ORDER BY `unit` DESC [ RunTime:0.013671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17167 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17167 ORDER BY `minOrder` ASC [ RunTime:0.002809s ]
select * from pdf where partno='LM3526MX-L/NOPB' and brandshort='TI' limit 1 [ RunTime:0.047223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM3526MX-L/NOPB' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.040975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17231 LIMIT 5 [ RunTime:0.032858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17231 ORDER BY `minOrder` ASC [ RunTime:0.013733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17231 ORDER BY `unit` DESC [ RunTime:0.018081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17231 LIMIT 2 [ RunTime:0.032223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17231 ORDER BY `minOrder` ASC [ RunTime:0.003638s ]
select * from pdf where partno='STL76DN4LF7AG' and brandshort='ST' limit 1 [ RunTime:0.008863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STL76DN4LF7AG' OR `brand` LIKE 'ST%' ) ) LIMIT 1 [ RunTime:0.058952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17168 LIMIT 5 [ RunTime:0.004899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17168 ORDER BY `minOrder` ASC [ RunTime:0.004912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17168 ORDER BY `unit` DESC [ RunTime:0.004659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17168 LIMIT 2 [ RunTime:0.022541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17168 ORDER BY `minOrder` ASC [ RunTime:0.004812s ]
select * from pdf where partno='LM20BIM7/NOPB' and brandshort='TI' limit 1 [ RunTime:0.024833s ]
select foldpath,foldpath2,filename from pdf_file where id=1145668 limit 1 [ RunTime:0.015663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM20BIM7/NOPB' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.091309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17249 LIMIT 5 [ RunTime:0.029944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17249 ORDER BY `minOrder` ASC [ RunTime:0.020142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17249 ORDER BY `unit` DESC [ RunTime:0.035851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17249 LIMIT 2 [ RunTime:0.023997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17249 ORDER BY `minOrder` ASC [ RunTime:0.037192s ]
select * from pdf where partno='TLE7189F' and brandshort='INFINEON' limit 1 [ RunTime:0.021934s ]
select foldpath,foldpath2,filename from pdf_file where id=927874 limit 1 [ RunTime:0.006680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE7189F' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.036596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17184 LIMIT 5 [ RunTime:0.008439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17184 ORDER BY `minOrder` ASC [ RunTime:0.008517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17184 ORDER BY `unit` DESC [ RunTime:0.005598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17184 LIMIT 2 [ RunTime:0.009844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17184 ORDER BY `minOrder` ASC [ RunTime:0.003988s ]
select * from pdf where partno='HC32L072JATA-LQ48'limit 1 [ RunTime:0.005287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC32L072JATA-LQ48' OR `brand` LIKE '华大%' ) ) LIMIT 1 [ RunTime:0.030730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17227 LIMIT 5 [ RunTime:0.006017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17227 ORDER BY `minOrder` ASC [ RunTime:0.003798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17227 ORDER BY `unit` DESC [ RunTime:0.037568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17227 LIMIT 2 [ RunTime:0.029128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17227 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='EP1C3T100C8N' and brandshort='ALTERA' limit 1 [ RunTime:0.021674s ]
select foldpath,foldpath2,filename from pdf_file where id=661277 limit 1 [ RunTime:0.026089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EP1C3T100C8N' OR `brand` LIKE 'ALTERA%' ) ) LIMIT 1 [ RunTime:0.016986s ]
SELECT `id` FROM `stock` WHERE `id` <> 17227 AND `partno` = 'EP1C3T100C8N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altera%' ) [ RunTime:0.020138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15345009 [ RunTime:0.018760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17228 LIMIT 5 [ RunTime:0.013677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17228 ORDER BY `minOrder` ASC [ RunTime:0.018108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17228 ORDER BY `unit` DESC [ RunTime:0.035906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17228 LIMIT 2 [ RunTime:0.045148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17228 ORDER BY `minOrder` ASC [ RunTime:0.008917s ]
select * from pdf where partno='MCIMX280DVM4BR' and brandshort='FREESCALE' limit 1 [ RunTime:0.005606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCIMX280DVM4BR' OR `brand` LIKE 'FREESCALE%' ) ) LIMIT 1 [ RunTime:0.052640s ]
SELECT `id` FROM `stock` WHERE `id` <> 17228 AND `partno` = 'MCIMX280DVM4BR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale%' ) [ RunTime:0.013787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17175 LIMIT 5 [ RunTime:0.072934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17175 ORDER BY `minOrder` ASC [ RunTime:0.011676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17175 ORDER BY `unit` DESC [ RunTime:0.035806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17175 LIMIT 2 [ RunTime:0.067202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17175 ORDER BY `minOrder` ASC [ RunTime:0.038076s ]
select * from pdf where partno='LM25184QNGURQ1' and brandshort='TI' limit 1 [ RunTime:0.006900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM25184QNGURQ1' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.084821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17222 LIMIT 5 [ RunTime:0.004138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17222 ORDER BY `minOrder` ASC [ RunTime:0.024122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17222 ORDER BY `unit` DESC [ RunTime:0.003456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17222 LIMIT 2 [ RunTime:0.002549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17222 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='SQM120P06-07L_GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.002376s ]
select foldpath,foldpath2,filename from pdf_file where id=1590129 limit 1 [ RunTime:0.005700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SQM120P06-07L_GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.016163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17226 LIMIT 5 [ RunTime:0.004717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17226 ORDER BY `minOrder` ASC [ RunTime:0.015549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17226 ORDER BY `unit` DESC [ RunTime:0.049065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17226 LIMIT 2 [ RunTime:0.021375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17226 ORDER BY `minOrder` ASC [ RunTime:0.010554s ]
select * from pdf where partno='XC9572XL-7TQG100C' and brandshort='XILINX' limit 1 [ RunTime:0.020187s ]
select foldpath,foldpath2,filename from pdf_file where id=602452 limit 1 [ RunTime:0.028433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XC9572XL-7TQG100C' OR `brand` LIKE 'XILINX%' ) ) LIMIT 1 [ RunTime:0.012152s ]
SELECT `id` FROM `stock` WHERE `id` <> 17226 AND `partno` = 'XC9572XL-7TQG100C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%xilinx%' ) [ RunTime:0.025685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17185 LIMIT 5 [ RunTime:0.002431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17185 ORDER BY `minOrder` ASC [ RunTime:0.008646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17185 ORDER BY `unit` DESC [ RunTime:0.013270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17185 LIMIT 2 [ RunTime:0.012717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17185 ORDER BY `minOrder` ASC [ RunTime:0.017003s ]
select * from pdf where partno='HC32L176MATA-LQFP80' and brandshort='HDSC' limit 1 [ RunTime:0.019016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC32L176MATA-LQFP80' OR `brand` LIKE 'HDSC%' ) ) LIMIT 1 [ RunTime:0.028789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17234 LIMIT 5 [ RunTime:0.021569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17234 ORDER BY `minOrder` ASC [ RunTime:0.050839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17234 ORDER BY `unit` DESC [ RunTime:0.012424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17234 LIMIT 2 [ RunTime:0.005374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17234 ORDER BY `minOrder` ASC [ RunTime:0.008441s ]
select * from pdf where partno='BCM89530B1BPBG' and brandshort='BROADCOM' limit 1 [ RunTime:0.020265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BCM89530B1BPBG' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.056374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17194 LIMIT 5 [ RunTime:0.038279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17194 ORDER BY `minOrder` ASC [ RunTime:0.017380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17194 ORDER BY `unit` DESC [ RunTime:0.042838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17194 LIMIT 2 [ RunTime:0.020575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17194 ORDER BY `minOrder` ASC [ RunTime:0.014293s ]
select * from pdf where partno='LQH44PN1R0NP0L' and brandshort='MURATA' limit 1 [ RunTime:0.014893s ]
select foldpath,foldpath2,filename from pdf_file where id=692248 limit 1 [ RunTime:0.046612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LQH44PN1R0NP0L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.054901s ]
SELECT `id` FROM `stock` WHERE `id` <> 17194 AND `partno` = 'LQH44PN1R0NP0L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata%' ) [ RunTime:0.020753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14335681 [ RunTime:0.052936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17193 LIMIT 5 [ RunTime:0.009476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17193 ORDER BY `minOrder` ASC [ RunTime:0.017726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17193 ORDER BY `unit` DESC [ RunTime:0.050849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17193 LIMIT 2 [ RunTime:0.033248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17193 ORDER BY `minOrder` ASC [ RunTime:0.028465s ]
select * from pdf where partno='HD3SS460RNHR' and brandshort='TI' limit 1 [ RunTime:0.011616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HD3SS460RNHR' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.037177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17169 LIMIT 5 [ RunTime:0.007346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17169 ORDER BY `minOrder` ASC [ RunTime:0.059267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17169 ORDER BY `unit` DESC [ RunTime:0.054746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17169 LIMIT 2 [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17169 ORDER BY `minOrder` ASC [ RunTime:0.011295s ]
select * from pdf where partno='XC7Z020-1CLG400I' and brandshort='XILINX' limit 1 [ RunTime:0.032333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XC7Z020-1CLG400I' OR `brand` LIKE 'XILINX%' ) ) LIMIT 1 [ RunTime:0.015277s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.041789s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) ) tmp GROUP BY `brand` [ RunTime:0.025539s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) AND `categoryid` > 0 [ RunTime:0.015762s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (181,132,104) [ RunTime:0.014657s ]