SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001302s ]
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://ic118.com/stock&keyword=4N25&page=1&srecordnum=122' [ RunTime:0.003682s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001094s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001756s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001409s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000230s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001539s ]
SELECT * FROM `stock_search` WHERE `partno` = '4N25' LIMIT 1 [ RunTime:0.000457s ]
UPDATE `stock_search` SET `count` = 1411 , `updatetime` = '2026-06-10 19:03:51' WHERE `partno` = '4N25' [ RunTime:0.003335s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000194s ]
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.001021s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001476s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '4N25%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.029460s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '4N25%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024356s ]
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 ('32231999','32145024','37649315','32231576','32144714','18693320','15203611','37650388','32231577','32144715','37648689','37650737','16991354','18692720','15204267','18691459','37648730','18692722','37648692','37648480') ORDER BY FIELD(s.id, 32231999,32145024,37649315,32231576,32144714,18693320,15203611,37650388,32231577,32144715,37648689,37650737,16991354,18692720,15204267,18691459,37648730,18692722,37648692,37648480) [ RunTime:0.059602s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32231999 LIMIT 4 [ RunTime:0.007177s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231999 ORDER BY `minOrder` ASC [ RunTime:0.028260s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32231999 ORDER BY `unit` DESC [ RunTime:0.021519s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32231999 LIMIT 2 [ RunTime:0.024641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231999 ORDER BY `minOrder` ASC [ RunTime:0.001838s ]
select * from pdf where partno='4n25sm' and brandshort='onsemi' limit 1 [ RunTime:0.040651s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4n25sm' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.034720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32145024 LIMIT 4 [ RunTime:0.025097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32145024 ORDER BY `minOrder` ASC [ RunTime:0.022904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32145024 ORDER BY `unit` DESC [ RunTime:0.030659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32145024 LIMIT 2 [ RunTime:0.037245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32145024 ORDER BY `minOrder` ASC [ RunTime:0.006865s ]
select * from pdf where partno='4n25sm' and brandshort='onsemi' limit 1 [ RunTime:0.018930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4n25sm' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.010807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37649315 LIMIT 4 [ RunTime:0.036975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649315 ORDER BY `minOrder` ASC [ RunTime:0.017166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37649315 ORDER BY `unit` DESC [ RunTime:0.045653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37649315 LIMIT 2 [ RunTime:0.025213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649315 ORDER BY `minOrder` ASC [ RunTime:0.015260s ]
select * from pdf where partno='4N25-000E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.030290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25-000E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.047174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32231576 LIMIT 4 [ RunTime:0.040096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231576 ORDER BY `minOrder` ASC [ RunTime:0.047584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32231576 ORDER BY `unit` DESC [ RunTime:0.031516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32231576 LIMIT 2 [ RunTime:0.007990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231576 ORDER BY `minOrder` ASC [ RunTime:0.003617s ]
select * from pdf where partno='4n25-000e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.031537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4n25-000e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.045592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32144714 LIMIT 4 [ RunTime:0.037942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32144714 ORDER BY `minOrder` ASC [ RunTime:0.032659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32144714 ORDER BY `unit` DESC [ RunTime:0.012072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32144714 LIMIT 2 [ RunTime:0.120568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32144714 ORDER BY `minOrder` ASC [ RunTime:0.023396s ]
select * from pdf where partno='4n25-000e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.014080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4n25-000e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.015281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693320 LIMIT 4 [ RunTime:0.084726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693320 ORDER BY `minOrder` ASC [ RunTime:0.022438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693320 ORDER BY `unit` DESC [ RunTime:0.051734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693320 LIMIT 2 [ RunTime:0.079699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693320 ORDER BY `minOrder` ASC [ RunTime:0.051878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203611 LIMIT 4 [ RunTime:0.029230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203611 ORDER BY `minOrder` ASC [ RunTime:0.025892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203611 ORDER BY `unit` DESC [ RunTime:0.018577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203611 LIMIT 2 [ RunTime:0.023977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203611 ORDER BY `minOrder` ASC [ RunTime:0.017283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37650388 LIMIT 4 [ RunTime:0.009641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650388 ORDER BY `minOrder` ASC [ RunTime:0.018744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37650388 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37650388 LIMIT 2 [ RunTime:0.011487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650388 ORDER BY `minOrder` ASC [ RunTime:0.007893s ]
select * from pdf where partno='4N25-360E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.025622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25-360E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.015486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32231577 LIMIT 4 [ RunTime:0.030141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231577 ORDER BY `minOrder` ASC [ RunTime:0.029035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32231577 ORDER BY `unit` DESC [ RunTime:0.020728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32231577 LIMIT 2 [ RunTime:0.025316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231577 ORDER BY `minOrder` ASC [ RunTime:0.042679s ]
select * from pdf where partno='4n25-500e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.020140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4n25-500e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.048486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32144715 LIMIT 4 [ RunTime:0.039655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32144715 ORDER BY `minOrder` ASC [ RunTime:0.028453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32144715 ORDER BY `unit` DESC [ RunTime:0.027434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32144715 LIMIT 2 [ RunTime:0.016313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32144715 ORDER BY `minOrder` ASC [ RunTime:0.030496s ]
select * from pdf where partno='4n25-500e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.008542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4n25-500e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.015798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648689 LIMIT 4 [ RunTime:0.010982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648689 ORDER BY `minOrder` ASC [ RunTime:0.013462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648689 ORDER BY `unit` DESC [ RunTime:0.022287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648689 LIMIT 2 [ RunTime:0.025270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648689 ORDER BY `minOrder` ASC [ RunTime:0.005547s ]
select * from pdf where partno='4N25M' and brandshort='onsemi' limit 1 [ RunTime:0.020861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.039814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37650737 LIMIT 4 [ RunTime:0.034806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650737 ORDER BY `minOrder` ASC [ RunTime:0.017795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37650737 ORDER BY `unit` DESC [ RunTime:0.014239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37650737 LIMIT 2 [ RunTime:0.023755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650737 ORDER BY `minOrder` ASC [ RunTime:0.037094s ]
select * from pdf where partno='4N25' and brandshort='Texas Instruments' limit 1 [ RunTime:0.028418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.020165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991354 LIMIT 4 [ RunTime:0.041469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991354 ORDER BY `minOrder` ASC [ RunTime:0.023173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991354 ORDER BY `unit` DESC [ RunTime:0.026873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991354 LIMIT 2 [ RunTime:0.034898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991354 ORDER BY `minOrder` ASC [ RunTime:0.018475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692720 LIMIT 4 [ RunTime:0.044211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692720 ORDER BY `minOrder` ASC [ RunTime:0.030692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692720 ORDER BY `unit` DESC [ RunTime:0.028505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692720 LIMIT 2 [ RunTime:0.067959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692720 ORDER BY `minOrder` ASC [ RunTime:0.003017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204267 LIMIT 4 [ RunTime:0.038207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204267 ORDER BY `minOrder` ASC [ RunTime:0.024313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204267 ORDER BY `unit` DESC [ RunTime:0.012227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204267 LIMIT 2 [ RunTime:0.046688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204267 ORDER BY `minOrder` ASC [ RunTime:0.035438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691459 LIMIT 4 [ RunTime:0.038718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691459 ORDER BY `minOrder` ASC [ RunTime:0.040571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691459 ORDER BY `unit` DESC [ RunTime:0.034187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691459 LIMIT 2 [ RunTime:0.062615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691459 ORDER BY `minOrder` ASC [ RunTime:0.017189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648730 LIMIT 4 [ RunTime:0.009741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648730 ORDER BY `minOrder` ASC [ RunTime:0.022218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648730 ORDER BY `unit` DESC [ RunTime:0.020413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648730 LIMIT 2 [ RunTime:0.027025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648730 ORDER BY `minOrder` ASC [ RunTime:0.010233s ]
select * from pdf where partno='4N25-500E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.032764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25-500E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.018269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692722 LIMIT 4 [ RunTime:0.031567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692722 ORDER BY `minOrder` ASC [ RunTime:0.045809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692722 ORDER BY `unit` DESC [ RunTime:0.042109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692722 LIMIT 2 [ RunTime:0.027336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692722 ORDER BY `minOrder` ASC [ RunTime:0.006705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648692 LIMIT 4 [ RunTime:0.031764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648692 ORDER BY `minOrder` ASC [ RunTime:0.114539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648692 ORDER BY `unit` DESC [ RunTime:0.018651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648692 LIMIT 2 [ RunTime:0.046276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648692 ORDER BY `minOrder` ASC [ RunTime:0.033848s ]
select * from pdf where partno='4N25SM' and brandshort='onsemi' limit 1 [ RunTime:0.032434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25SM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.040161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648480 LIMIT 4 [ RunTime:0.017488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648480 ORDER BY `minOrder` ASC [ RunTime:0.035215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648480 ORDER BY `unit` DESC [ RunTime:0.013336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648480 LIMIT 2 [ RunTime:0.024706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648480 ORDER BY `minOrder` ASC [ RunTime:0.047679s ]
select * from pdf where partno='4N25' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.029347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4N25' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.029930s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '4N25%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.052315s ]