SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002783s ]
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=468&srecordnum=10000' [ RunTime:0.024978s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001550s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003522s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001700s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.002720s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001852s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004105s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001645s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.008303s ]
UPDATE `stock_search` SET `count` = 1174 , `updatetime` = '2026-06-12 01:18:18' WHERE `partno` = '228' [ RunTime:0.004304s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002302s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000371s ]
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.000465s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001881s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.109174s ]
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 9340,20 [ RunTime:0.179540s ]
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 ('12452043','12452042','12452041','12452040','12452039','12452038','12452037','12452036','12452035','12452034','12452033','12452032','12452031','12452030','12452029','12452028','12452027','12452026','12452025','12452024') ORDER BY FIELD(s.id, 12452043,12452042,12452041,12452040,12452039,12452038,12452037,12452036,12452035,12452034,12452033,12452032,12452031,12452030,12452029,12452028,12452027,12452026,12452025,12452024) [ RunTime:0.022914s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452043 LIMIT 4 [ RunTime:0.014975s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452043 ORDER BY `minOrder` ASC [ RunTime:0.014104s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452043 ORDER BY `unit` DESC [ RunTime:0.002738s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452043 LIMIT 2 [ RunTime:0.013217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452043 ORDER BY `minOrder` ASC [ RunTime:0.017619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452042 LIMIT 4 [ RunTime:0.010825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452042 ORDER BY `minOrder` ASC [ RunTime:0.011954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452042 ORDER BY `unit` DESC [ RunTime:0.027535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452042 LIMIT 2 [ RunTime:0.033129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452042 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452041 LIMIT 4 [ RunTime:0.064129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452041 ORDER BY `minOrder` ASC [ RunTime:0.044438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452041 ORDER BY `unit` DESC [ RunTime:0.036249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452041 LIMIT 2 [ RunTime:0.010642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452041 ORDER BY `minOrder` ASC [ RunTime:0.008013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452040 LIMIT 4 [ RunTime:0.008959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452040 ORDER BY `minOrder` ASC [ RunTime:0.039272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452040 ORDER BY `unit` DESC [ RunTime:0.011804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452040 LIMIT 2 [ RunTime:0.027776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452040 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452039 LIMIT 4 [ RunTime:0.005598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452039 ORDER BY `minOrder` ASC [ RunTime:0.017544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452039 ORDER BY `unit` DESC [ RunTime:0.093633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452039 LIMIT 2 [ RunTime:0.012541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452039 ORDER BY `minOrder` ASC [ RunTime:0.013835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452038 LIMIT 4 [ RunTime:0.006845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452038 ORDER BY `minOrder` ASC [ RunTime:0.062936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452038 ORDER BY `unit` DESC [ RunTime:0.023429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452038 LIMIT 2 [ RunTime:0.025758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452038 ORDER BY `minOrder` ASC [ RunTime:0.009292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452037 LIMIT 4 [ RunTime:0.036820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452037 ORDER BY `minOrder` ASC [ RunTime:0.053089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452037 ORDER BY `unit` DESC [ RunTime:0.047551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452037 LIMIT 2 [ RunTime:0.042178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452037 ORDER BY `minOrder` ASC [ RunTime:0.026524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452036 LIMIT 4 [ RunTime:0.017259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452036 ORDER BY `minOrder` ASC [ RunTime:0.036205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452036 ORDER BY `unit` DESC [ RunTime:0.025774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452036 LIMIT 2 [ RunTime:0.022972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452036 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452035 LIMIT 4 [ RunTime:0.022681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452035 ORDER BY `minOrder` ASC [ RunTime:0.010976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452035 ORDER BY `unit` DESC [ RunTime:0.009624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452035 LIMIT 2 [ RunTime:0.010800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452035 ORDER BY `minOrder` ASC [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452034 LIMIT 4 [ RunTime:0.019274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452034 ORDER BY `minOrder` ASC [ RunTime:0.026752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452034 ORDER BY `unit` DESC [ RunTime:0.013139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452034 LIMIT 2 [ RunTime:0.023520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452034 ORDER BY `minOrder` ASC [ RunTime:0.005355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452033 LIMIT 4 [ RunTime:0.005916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452033 ORDER BY `minOrder` ASC [ RunTime:0.042799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452033 ORDER BY `unit` DESC [ RunTime:0.016977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452033 LIMIT 2 [ RunTime:0.019239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452033 ORDER BY `minOrder` ASC [ RunTime:0.002986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452032 LIMIT 4 [ RunTime:0.007496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452032 ORDER BY `minOrder` ASC [ RunTime:0.040689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452032 ORDER BY `unit` DESC [ RunTime:0.035234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452032 LIMIT 2 [ RunTime:0.023830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452032 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452031 LIMIT 4 [ RunTime:0.028467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452031 ORDER BY `minOrder` ASC [ RunTime:0.008981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452031 ORDER BY `unit` DESC [ RunTime:0.004779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452031 LIMIT 2 [ RunTime:0.029453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452031 ORDER BY `minOrder` ASC [ RunTime:0.032952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452030 LIMIT 4 [ RunTime:0.010714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452030 ORDER BY `minOrder` ASC [ RunTime:0.013186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452030 ORDER BY `unit` DESC [ RunTime:0.069901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452030 LIMIT 2 [ RunTime:0.050695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452030 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452029 LIMIT 4 [ RunTime:0.018605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452029 ORDER BY `minOrder` ASC [ RunTime:0.007223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452029 ORDER BY `unit` DESC [ RunTime:0.026389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452029 LIMIT 2 [ RunTime:0.005609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452029 ORDER BY `minOrder` ASC [ RunTime:0.007524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452028 LIMIT 4 [ RunTime:0.009773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452028 ORDER BY `minOrder` ASC [ RunTime:0.006711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452028 ORDER BY `unit` DESC [ RunTime:0.002583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452028 LIMIT 2 [ RunTime:0.023955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452028 ORDER BY `minOrder` ASC [ RunTime:0.014981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452027 LIMIT 4 [ RunTime:0.007988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452027 ORDER BY `minOrder` ASC [ RunTime:0.028356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452027 ORDER BY `unit` DESC [ RunTime:0.010636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452027 LIMIT 2 [ RunTime:0.018866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452027 ORDER BY `minOrder` ASC [ RunTime:0.004106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452026 LIMIT 4 [ RunTime:0.018497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452026 ORDER BY `minOrder` ASC [ RunTime:0.084661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452026 ORDER BY `unit` DESC [ RunTime:0.001628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452026 LIMIT 2 [ RunTime:0.061186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452026 ORDER BY `minOrder` ASC [ RunTime:0.023229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452025 LIMIT 4 [ RunTime:0.118872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452025 ORDER BY `minOrder` ASC [ RunTime:0.054380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452025 ORDER BY `unit` DESC [ RunTime:0.019813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452025 LIMIT 2 [ RunTime:0.017528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452025 ORDER BY `minOrder` ASC [ RunTime:0.007265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452024 LIMIT 4 [ RunTime:0.008469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452024 ORDER BY `minOrder` ASC [ RunTime:0.020007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452024 ORDER BY `unit` DESC [ RunTime:0.027849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452024 LIMIT 2 [ RunTime:0.012283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452024 ORDER BY `minOrder` ASC [ RunTime:0.004118s ]
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.004057s ]