SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001278s ]
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=G501' [ RunTime:0.001696s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002111s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002487s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.002400s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001621s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003109s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001650s ]
SELECT * FROM `stock_search` WHERE `partno` = 'G501' LIMIT 1 [ RunTime:0.002426s ]
UPDATE `stock_search` SET `count` = 14570 , `updatetime` = '2026-06-13 11:30:52' WHERE `partno` = 'G501' [ RunTime:0.001782s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001825s ]
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 ( `partno` LIKE 'G501%' OR `brand` LIKE 'G501%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017299s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596008 LIMIT 4 [ RunTime:0.004462s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596008 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596008 ORDER BY `unit` DESC [ RunTime:0.002435s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596008 LIMIT 2 [ RunTime:0.003642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596008 ORDER BY `minOrder` ASC [ RunTime:0.001776s ]
select * from pdf where partno='G5015H24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.001093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 740 LIMIT 4 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 740 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 740 ORDER BY `unit` DESC [ RunTime:0.001866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 740 LIMIT 2 [ RunTime:0.002725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 740 ORDER BY `minOrder` ASC [ RunTime:0.002113s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501' OR `brand` LIKE 'CML INNOVATIVE TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.004451s ]
SELECT `id` FROM `stock` WHERE `id` <> 740 AND `partno` = 'G501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cml innovative technologies%' ) [ RunTime:0.002311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18594971 LIMIT 4 [ RunTime:0.005257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18594971 ORDER BY `minOrder` ASC [ RunTime:0.000946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18594971 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18594971 LIMIT 2 [ RunTime:0.002694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18594971 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='G5015E12B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33046148 LIMIT 4 [ RunTime:0.004292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33046148 ORDER BY `minOrder` ASC [ RunTime:0.005149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33046148 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33046148 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33046148 ORDER BY `minOrder` ASC [ RunTime:0.013651s ]
select * from pdf where partno='G5015M05B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.011288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015M05B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.014559s ]
SELECT `id` FROM `stock` WHERE `id` <> 33046148 AND `partno` = 'G5015M05B-RSR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mechatronics fan group%' ) [ RunTime:0.001188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169021 [ RunTime:0.001569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33048996 LIMIT 4 [ RunTime:0.010368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33048996 ORDER BY `minOrder` ASC [ RunTime:0.018131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33048996 ORDER BY `unit` DESC [ RunTime:0.003669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33048996 LIMIT 2 [ RunTime:0.017870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33048996 ORDER BY `minOrder` ASC [ RunTime:0.009796s ]
select * from pdf where partno='G5015E12B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.002136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015E12B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.007874s ]
SELECT `id` FROM `stock` WHERE `id` <> 33048996 AND `partno` = 'G5015E12B-RSR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mechatronics fan group%' ) [ RunTime:0.003936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18594971 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405310 LIMIT 4 [ RunTime:0.005476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405310 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405310 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405310 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405310 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405309 LIMIT 4 [ RunTime:0.006028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405309 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405309 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405309 LIMIT 2 [ RunTime:0.031723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405309 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405308 LIMIT 4 [ RunTime:0.004712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405308 ORDER BY `minOrder` ASC [ RunTime:0.001941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405308 ORDER BY `unit` DESC [ RunTime:0.014448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405308 LIMIT 2 [ RunTime:0.009504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405308 ORDER BY `minOrder` ASC [ RunTime:0.002063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405307 LIMIT 4 [ RunTime:0.004715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405307 ORDER BY `minOrder` ASC [ RunTime:0.010786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405307 ORDER BY `unit` DESC [ RunTime:0.012507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405307 LIMIT 2 [ RunTime:0.007774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405307 ORDER BY `minOrder` ASC [ RunTime:0.009141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405301 LIMIT 4 [ RunTime:0.006116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405301 ORDER BY `minOrder` ASC [ RunTime:0.002511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405301 ORDER BY `unit` DESC [ RunTime:0.009454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405301 LIMIT 2 [ RunTime:0.013428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405301 ORDER BY `minOrder` ASC [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405300 LIMIT 4 [ RunTime:0.002740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405300 ORDER BY `minOrder` ASC [ RunTime:0.000882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405300 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405300 LIMIT 2 [ RunTime:0.014134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405300 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405299 LIMIT 4 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405299 ORDER BY `minOrder` ASC [ RunTime:0.013213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405299 ORDER BY `unit` DESC [ RunTime:0.004812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405299 LIMIT 2 [ RunTime:0.002936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405299 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405296 LIMIT 4 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405296 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405296 ORDER BY `unit` DESC [ RunTime:0.003144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405296 LIMIT 2 [ RunTime:0.010120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405296 ORDER BY `minOrder` ASC [ RunTime:0.004248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535020 LIMIT 4 [ RunTime:0.007179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535020 ORDER BY `minOrder` ASC [ RunTime:0.012954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13535020 ORDER BY `unit` DESC [ RunTime:0.003433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13535020 LIMIT 2 [ RunTime:0.002219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535020 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535017 LIMIT 4 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535017 ORDER BY `minOrder` ASC [ RunTime:0.003296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13535017 ORDER BY `unit` DESC [ RunTime:0.003080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13535017 LIMIT 2 [ RunTime:0.008221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535017 ORDER BY `minOrder` ASC [ RunTime:0.009442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535016 LIMIT 4 [ RunTime:0.012008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535016 ORDER BY `minOrder` ASC [ RunTime:0.015456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13535016 ORDER BY `unit` DESC [ RunTime:0.005982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13535016 LIMIT 2 [ RunTime:0.008537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535016 ORDER BY `minOrder` ASC [ RunTime:0.009427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36508862 LIMIT 4 [ RunTime:0.002157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508862 ORDER BY `minOrder` ASC [ RunTime:0.003774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36508862 ORDER BY `unit` DESC [ RunTime:0.002838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36508862 LIMIT 2 [ RunTime:0.006864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508862 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='G501-1025-11' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.000962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1025-11' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.000857s ]
SELECT `id` FROM `stock` WHERE `id` <> 36508862 AND `partno` = 'G501-1025-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jacob gmbh%' ) [ RunTime:0.002700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405310 [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36508861 LIMIT 4 [ RunTime:0.003988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508861 ORDER BY `minOrder` ASC [ RunTime:0.033520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36508861 ORDER BY `unit` DESC [ RunTime:0.010585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36508861 LIMIT 2 [ RunTime:0.004545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508861 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
select * from pdf where partno='G501-1025-00' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.003080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1025-00' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.001078s ]
SELECT `id` FROM `stock` WHERE `id` <> 36508861 AND `partno` = 'G501-1025-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jacob gmbh%' ) [ RunTime:0.003115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405309 [ RunTime:0.016717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36508860 LIMIT 4 [ RunTime:0.004428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508860 ORDER BY `minOrder` ASC [ RunTime:0.009999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36508860 ORDER BY `unit` DESC [ RunTime:0.007546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36508860 LIMIT 2 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508860 ORDER BY `minOrder` ASC [ RunTime:0.008522s ]
select * from pdf where partno='G501-1025-02' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.001650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1025-02' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.002378s ]
SELECT `id` FROM `stock` WHERE `id` <> 36508860 AND `partno` = 'G501-1025-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jacob gmbh%' ) [ RunTime:0.000925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535020 [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36508859 LIMIT 4 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508859 ORDER BY `minOrder` ASC [ RunTime:0.016162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36508859 ORDER BY `unit` DESC [ RunTime:0.006100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36508859 LIMIT 2 [ RunTime:0.005974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36508859 ORDER BY `minOrder` ASC [ RunTime:0.006761s ]
select * from pdf where partno='G501-1025-01' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.002290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1025-01' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.002552s ]
SELECT `id` FROM `stock` WHERE `id` <> 36508859 AND `partno` = 'G501-1025-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jacob gmbh%' ) [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405307 [ RunTime:0.000587s ]
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 ( `partno` LIKE 'G501%' OR `brand` LIKE 'G501%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004048s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G501%' OR `brand` LIKE 'G501%' ) AND `s`.`status` <> '2' ) LIMIT 60 ) tmp GROUP BY `brand` [ RunTime:0.002963s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G501%' OR `brand` LIKE 'G501%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 LIMIT 60 [ RunTime:0.004499s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 313 [ RunTime:0.002760s ]