SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001358s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=P1200&page=2&srecordnum=36' [ RunTime:0.009279s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002475s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000557s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001214s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003707s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002643s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001598s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P1200' LIMIT 1 [ RunTime:0.001240s ]
UPDATE `stock_search` SET `count` = 17936 , `updatetime` = '2026-06-11 11:01:55' WHERE `partno` = 'P1200' [ RunTime:0.003877s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002715s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000267s ]
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.005734s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001708s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'P1200%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.007342s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'P1200%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.004224s ]
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 ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32645333','32645304','16657542','16657498','16657078','16656986','16656985','16656951','16656947','14795880','14795837','14795407','13901204','13901013','13901012','13900954') ORDER BY FIELD(s.id, 32645333,32645304,16657542,16657498,16657078,16656986,16656985,16656951,16656947,14795880,14795837,14795407,13901204,13901013,13901012,13900954) [ RunTime:0.003248s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645333 LIMIT 4 [ RunTime:0.004611s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645333 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645333 ORDER BY `unit` DESC [ RunTime:0.001148s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645333 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645333 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='P1200SBLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002211s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SBLRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645304 LIMIT 4 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645304 ORDER BY `minOrder` ASC [ RunTime:0.002122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645304 ORDER BY `unit` DESC [ RunTime:0.000868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645304 LIMIT 2 [ RunTime:0.000757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645304 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='P1200SA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003889s ]
SELECT `id` FROM `stock` WHERE `id` <> 32645304 AND `partno` = 'P1200SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656947 [ RunTime:0.004392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657542 LIMIT 4 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657542 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657542 ORDER BY `unit` DESC [ RunTime:0.000802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657542 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657542 ORDER BY `minOrder` ASC [ RunTime:0.002230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657498 LIMIT 4 [ RunTime:0.014072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657498 ORDER BY `minOrder` ASC [ RunTime:0.011858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657498 ORDER BY `unit` DESC [ RunTime:0.012505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657498 LIMIT 2 [ RunTime:0.006937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657498 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657078 LIMIT 4 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657078 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657078 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657078 LIMIT 2 [ RunTime:0.002586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657078 ORDER BY `minOrder` ASC [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656986 LIMIT 4 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656986 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656986 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656986 LIMIT 2 [ RunTime:0.001835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656986 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656985 LIMIT 4 [ RunTime:0.010526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656985 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656985 ORDER BY `unit` DESC [ RunTime:0.002314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656985 LIMIT 2 [ RunTime:0.007868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656985 ORDER BY `minOrder` ASC [ RunTime:0.004527s ]
select * from pdf where partno='P1200Q12ALRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656951 LIMIT 4 [ RunTime:0.003075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656951 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656951 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656951 LIMIT 2 [ RunTime:0.017092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656951 ORDER BY `minOrder` ASC [ RunTime:0.011558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656947 LIMIT 4 [ RunTime:0.003145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656947 ORDER BY `minOrder` ASC [ RunTime:0.011661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656947 ORDER BY `unit` DESC [ RunTime:0.007571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656947 LIMIT 2 [ RunTime:0.010321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656947 ORDER BY `minOrder` ASC [ RunTime:0.007313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795880 LIMIT 4 [ RunTime:0.012895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795880 ORDER BY `minOrder` ASC [ RunTime:0.019155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14795880 ORDER BY `unit` DESC [ RunTime:0.003357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14795880 LIMIT 2 [ RunTime:0.002669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795880 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795837 LIMIT 4 [ RunTime:0.001342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795837 ORDER BY `minOrder` ASC [ RunTime:0.003951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14795837 ORDER BY `unit` DESC [ RunTime:0.004917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14795837 LIMIT 2 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795837 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795407 LIMIT 4 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795407 ORDER BY `minOrder` ASC [ RunTime:0.004408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14795407 ORDER BY `unit` DESC [ RunTime:0.003067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14795407 LIMIT 2 [ RunTime:0.002665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795407 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901204 LIMIT 4 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901204 ORDER BY `minOrder` ASC [ RunTime:0.000842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901204 ORDER BY `unit` DESC [ RunTime:0.000847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901204 LIMIT 2 [ RunTime:0.003906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901204 ORDER BY `minOrder` ASC [ RunTime:0.001806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901013 LIMIT 4 [ RunTime:0.004068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901013 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901013 ORDER BY `unit` DESC [ RunTime:0.007933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901013 LIMIT 2 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901013 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='P1200SCMCLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901012 LIMIT 4 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901012 ORDER BY `minOrder` ASC [ RunTime:0.002672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901012 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901012 LIMIT 2 [ RunTime:0.000942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901012 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
select * from pdf where partno='P1200Q12BLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900954 LIMIT 4 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900954 ORDER BY `minOrder` ASC [ RunTime:0.002056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900954 ORDER BY `unit` DESC [ RunTime:0.000446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900954 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900954 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'P1200%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001471s ]