SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001773s ]
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=228&page=471&srecordnum=10000' [ RunTime:0.001767s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001813s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001097s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001401s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001765s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001166s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000319s ]
UPDATE `stock_search` SET `count` = 1161 , `updatetime` = '2026-06-11 21:57:54' WHERE `partno` = '228' [ RunTime:0.002993s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000262s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000205s ]
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.004283s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002624s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.193861s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 9400,20 [ RunTime:0.188929s ]
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 ('12451942','12451941','12451940','12451939','12451938','12451937','12451936','12451935','12451934','12451933','12451932','12451931','12451930','12451929','12451928','12451927','12451926','12451925','12451924','12451923') ORDER BY FIELD(s.id, 12451942,12451941,12451940,12451939,12451938,12451937,12451936,12451935,12451934,12451933,12451932,12451931,12451930,12451929,12451928,12451927,12451926,12451925,12451924,12451923) [ RunTime:0.078769s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451942 LIMIT 4 [ RunTime:0.030204s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451942 ORDER BY `minOrder` ASC [ RunTime:0.023550s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451942 ORDER BY `unit` DESC [ RunTime:0.032373s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451942 LIMIT 2 [ RunTime:0.022483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451942 ORDER BY `minOrder` ASC [ RunTime:0.016276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451941 LIMIT 4 [ RunTime:0.026143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451941 ORDER BY `minOrder` ASC [ RunTime:0.031317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451941 ORDER BY `unit` DESC [ RunTime:0.040905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451941 LIMIT 2 [ RunTime:0.055795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451941 ORDER BY `minOrder` ASC [ RunTime:0.009401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451940 LIMIT 4 [ RunTime:0.020975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451940 ORDER BY `minOrder` ASC [ RunTime:0.030831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451940 ORDER BY `unit` DESC [ RunTime:0.051338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451940 LIMIT 2 [ RunTime:0.056645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451940 ORDER BY `minOrder` ASC [ RunTime:0.047693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451939 LIMIT 4 [ RunTime:0.041987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451939 ORDER BY `minOrder` ASC [ RunTime:0.027630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451939 ORDER BY `unit` DESC [ RunTime:0.042854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451939 LIMIT 2 [ RunTime:0.058393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451939 ORDER BY `minOrder` ASC [ RunTime:0.018679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451938 LIMIT 4 [ RunTime:0.028171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451938 ORDER BY `minOrder` ASC [ RunTime:0.033146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451938 ORDER BY `unit` DESC [ RunTime:0.033230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451938 LIMIT 2 [ RunTime:0.035768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451938 ORDER BY `minOrder` ASC [ RunTime:0.017236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451937 LIMIT 4 [ RunTime:0.020503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451937 ORDER BY `minOrder` ASC [ RunTime:0.051979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451937 ORDER BY `unit` DESC [ RunTime:0.069796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451937 LIMIT 2 [ RunTime:0.018327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451937 ORDER BY `minOrder` ASC [ RunTime:0.028911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451936 LIMIT 4 [ RunTime:0.037402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451936 ORDER BY `minOrder` ASC [ RunTime:0.003535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451936 ORDER BY `unit` DESC [ RunTime:0.050977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451936 LIMIT 2 [ RunTime:0.059659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451936 ORDER BY `minOrder` ASC [ RunTime:0.012840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451935 LIMIT 4 [ RunTime:0.015120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451935 ORDER BY `minOrder` ASC [ RunTime:0.031194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451935 ORDER BY `unit` DESC [ RunTime:0.018378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451935 LIMIT 2 [ RunTime:0.014205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451935 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451934 LIMIT 4 [ RunTime:0.021819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451934 ORDER BY `minOrder` ASC [ RunTime:0.050332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451934 ORDER BY `unit` DESC [ RunTime:0.019735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451934 LIMIT 2 [ RunTime:0.025630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451934 ORDER BY `minOrder` ASC [ RunTime:0.023458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451933 LIMIT 4 [ RunTime:0.026532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451933 ORDER BY `minOrder` ASC [ RunTime:0.017434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451933 ORDER BY `unit` DESC [ RunTime:0.043250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451933 LIMIT 2 [ RunTime:0.035708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451933 ORDER BY `minOrder` ASC [ RunTime:0.020400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451932 LIMIT 4 [ RunTime:0.015513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451932 ORDER BY `minOrder` ASC [ RunTime:0.031483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451932 ORDER BY `unit` DESC [ RunTime:0.022489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451932 LIMIT 2 [ RunTime:0.025161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451932 ORDER BY `minOrder` ASC [ RunTime:0.007720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451931 LIMIT 4 [ RunTime:0.017846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451931 ORDER BY `minOrder` ASC [ RunTime:0.027825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451931 ORDER BY `unit` DESC [ RunTime:0.040919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451931 LIMIT 2 [ RunTime:0.089291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451931 ORDER BY `minOrder` ASC [ RunTime:0.013663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451930 LIMIT 4 [ RunTime:0.027827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451930 ORDER BY `minOrder` ASC [ RunTime:0.036365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451930 ORDER BY `unit` DESC [ RunTime:0.051838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451930 LIMIT 2 [ RunTime:0.038428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451930 ORDER BY `minOrder` ASC [ RunTime:0.019235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451929 LIMIT 4 [ RunTime:0.041414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451929 ORDER BY `minOrder` ASC [ RunTime:0.022176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451929 ORDER BY `unit` DESC [ RunTime:0.038808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451929 LIMIT 2 [ RunTime:0.022663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451929 ORDER BY `minOrder` ASC [ RunTime:0.017973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451928 LIMIT 4 [ RunTime:0.047848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451928 ORDER BY `minOrder` ASC [ RunTime:0.009511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451928 ORDER BY `unit` DESC [ RunTime:0.008945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451928 LIMIT 2 [ RunTime:0.054412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451928 ORDER BY `minOrder` ASC [ RunTime:0.009164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451927 LIMIT 4 [ RunTime:0.064078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451927 ORDER BY `minOrder` ASC [ RunTime:0.038078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451927 ORDER BY `unit` DESC [ RunTime:0.033678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451927 LIMIT 2 [ RunTime:0.019747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451927 ORDER BY `minOrder` ASC [ RunTime:0.015417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451926 LIMIT 4 [ RunTime:0.013497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451926 ORDER BY `minOrder` ASC [ RunTime:0.013561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451926 ORDER BY `unit` DESC [ RunTime:0.038011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451926 LIMIT 2 [ RunTime:0.016481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451926 ORDER BY `minOrder` ASC [ RunTime:0.040803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451925 LIMIT 4 [ RunTime:0.127992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451925 ORDER BY `minOrder` ASC [ RunTime:0.044250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451925 ORDER BY `unit` DESC [ RunTime:0.023644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451925 LIMIT 2 [ RunTime:0.082565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451925 ORDER BY `minOrder` ASC [ RunTime:0.019320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451924 LIMIT 4 [ RunTime:0.019017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451924 ORDER BY `minOrder` ASC [ RunTime:0.057622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451924 ORDER BY `unit` DESC [ RunTime:0.077846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451924 LIMIT 2 [ RunTime:0.061685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451924 ORDER BY `minOrder` ASC [ RunTime:0.026299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451923 LIMIT 4 [ RunTime:0.010592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451923 ORDER BY `minOrder` ASC [ RunTime:0.017545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451923 ORDER BY `unit` DESC [ RunTime:0.012544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451923 LIMIT 2 [ RunTime:0.056744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451923 ORDER BY `minOrder` ASC [ RunTime:0.021554s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.006790s ]