SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003328s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?typeid=309' [ RunTime:0.003139s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002386s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013836s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002417s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000373s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002350s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000341s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 309 [ RunTime:0.000441s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 309 LIMIT 1 [ RunTime:0.003064s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002774s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '309' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014479s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3478 LIMIT 5 [ RunTime:0.023579s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3478 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3478 ORDER BY `unit` DESC [ RunTime:0.009313s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3478 LIMIT 2 [ RunTime:0.025673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3478 ORDER BY `minOrder` ASC [ RunTime:0.025612s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4651-103E/ST' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.005366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16558 LIMIT 5 [ RunTime:0.026283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16558 ORDER BY `minOrder` ASC [ RunTime:0.006799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16558 ORDER BY `unit` DESC [ RunTime:0.006312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16558 LIMIT 2 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16558 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='MCP4651-103E/ST' and brandshort='MICROCHIP' limit 1 [ RunTime:0.004420s ]
select foldpath,foldpath2,filename from pdf_file where id=1007320 limit 1 [ RunTime:0.031002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4651-103E/ST' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.015679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15538 LIMIT 5 [ RunTime:0.057598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15538 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15538 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15538 LIMIT 2 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15538 ORDER BY `minOrder` ASC [ RunTime:0.004054s ]
select * from pdf where partno='MCP4651-103E/ST' and brandshort='MICROCHIP' limit 1 [ RunTime:0.009633s ]
select foldpath,foldpath2,filename from pdf_file where id=1007320 limit 1 [ RunTime:0.008749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4651-103E/ST' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.020079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4191 LIMIT 5 [ RunTime:0.047750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4191 ORDER BY `minOrder` ASC [ RunTime:0.020632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4191 ORDER BY `unit` DESC [ RunTime:0.024746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4191 LIMIT 2 [ RunTime:0.053989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4191 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP40D17T-103E/LT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.068720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3688 LIMIT 5 [ RunTime:0.018793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3688 ORDER BY `minOrder` ASC [ RunTime:0.041961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3688 ORDER BY `unit` DESC [ RunTime:0.017014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3688 LIMIT 2 [ RunTime:0.010292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3688 ORDER BY `minOrder` ASC [ RunTime:0.117612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4017T-103E/LT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.011481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4192 LIMIT 5 [ RunTime:0.034562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4192 ORDER BY `minOrder` ASC [ RunTime:0.053084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4192 ORDER BY `unit` DESC [ RunTime:0.029172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4192 LIMIT 2 [ RunTime:0.050545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4192 ORDER BY `minOrder` ASC [ RunTime:0.015910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP40D18T-502E/LT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.010082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4472 LIMIT 5 [ RunTime:0.039924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4472 ORDER BY `minOrder` ASC [ RunTime:0.033479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4472 ORDER BY `unit` DESC [ RunTime:0.017415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4472 LIMIT 2 [ RunTime:0.044577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4472 ORDER BY `minOrder` ASC [ RunTime:0.014592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4652-104E/UN' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.029932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4432 LIMIT 5 [ RunTime:0.027528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4432 ORDER BY `minOrder` ASC [ RunTime:0.035160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4432 ORDER BY `unit` DESC [ RunTime:0.010361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4432 LIMIT 2 [ RunTime:0.028212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4432 ORDER BY `minOrder` ASC [ RunTime:0.010150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4011-202E/SN' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.006238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4473 LIMIT 5 [ RunTime:0.021152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4473 ORDER BY `minOrder` ASC [ RunTime:0.028082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4473 ORDER BY `unit` DESC [ RunTime:0.012441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4473 LIMIT 2 [ RunTime:0.029515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4473 ORDER BY `minOrder` ASC [ RunTime:0.052892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4151-103E/SN' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.007930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3479 LIMIT 5 [ RunTime:0.014856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3479 ORDER BY `minOrder` ASC [ RunTime:0.019995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3479 ORDER BY `unit` DESC [ RunTime:0.030124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3479 LIMIT 2 [ RunTime:0.016635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3479 ORDER BY `minOrder` ASC [ RunTime:0.008615s ]
select * from pdf where partno='MCP4661-103E/ST' and brandshort='MICROCHIP' limit 1 [ RunTime:0.014637s ]
select foldpath,foldpath2,filename from pdf_file where id=1007323 limit 1 [ RunTime:0.005532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4661-103E/ST' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.009140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7985 LIMIT 5 [ RunTime:0.014250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7985 ORDER BY `minOrder` ASC [ RunTime:0.017748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7985 ORDER BY `unit` DESC [ RunTime:0.019017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7985 LIMIT 2 [ RunTime:0.023403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7985 ORDER BY `minOrder` ASC [ RunTime:0.012241s ]
select * from pdf where partno='DS1881E-050+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.017913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1881E-050+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.008650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10299 LIMIT 5 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10299 ORDER BY `minOrder` ASC [ RunTime:0.033820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10299 ORDER BY `unit` DESC [ RunTime:0.004668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10299 LIMIT 2 [ RunTime:0.019000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10299 ORDER BY `minOrder` ASC [ RunTime:0.005734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'X95820WV14IZ-2.7T1' OR `brand` LIKE 'RENESAS%' ) ) LIMIT 1 [ RunTime:0.004860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3557 LIMIT 5 [ RunTime:0.010443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3557 ORDER BY `minOrder` ASC [ RunTime:0.021524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3557 ORDER BY `unit` DESC [ RunTime:0.004442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3557 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3557 ORDER BY `minOrder` ASC [ RunTime:0.004798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4551-103E/MS' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.001581s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '309' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010228s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '309' ) LIMIT 13 ) tmp GROUP BY `brand` [ RunTime:0.010284s ]