SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001428s ]
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=472&srecordnum=10000' [ RunTime:0.001892s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001665s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001032s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001460s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001358s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001822s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000489s ]
UPDATE `stock_search` SET `count` = 1161 , `updatetime` = '2026-06-11 21:57:54' WHERE `partno` = '228' [ RunTime:0.007678s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000236s ]
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.003813s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001497s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.197416s ]
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 9420,20 [ RunTime:0.161755s ]
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 ('12451922','12451921','12451920','12451919','12451918','12451917','12451916','12451915','12451914','12451913','12451912','12451911','12451910','12451909','12451908','12451907','12451906','12451905','12451904','12451903') ORDER BY FIELD(s.id, 12451922,12451921,12451920,12451919,12451918,12451917,12451916,12451915,12451914,12451913,12451912,12451911,12451910,12451909,12451908,12451907,12451906,12451905,12451904,12451903) [ RunTime:0.028997s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451922 LIMIT 4 [ RunTime:0.030067s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.049035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451922 ORDER BY `minOrder` ASC [ RunTime:0.019238s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451922 ORDER BY `unit` DESC [ RunTime:0.024119s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451922 LIMIT 2 [ RunTime:0.012456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451922 ORDER BY `minOrder` ASC [ RunTime:0.003789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451921 LIMIT 4 [ RunTime:0.031879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451921 ORDER BY `minOrder` ASC [ RunTime:0.006548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451921 ORDER BY `unit` DESC [ RunTime:0.034128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451921 LIMIT 2 [ RunTime:0.051934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451921 ORDER BY `minOrder` ASC [ RunTime:0.022224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451920 LIMIT 4 [ RunTime:0.012453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451920 ORDER BY `minOrder` ASC [ RunTime:0.049191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451920 ORDER BY `unit` DESC [ RunTime:0.018400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451920 LIMIT 2 [ RunTime:0.029181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451920 ORDER BY `minOrder` ASC [ RunTime:0.005353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451919 LIMIT 4 [ RunTime:0.020009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451919 ORDER BY `minOrder` ASC [ RunTime:0.023631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451919 ORDER BY `unit` DESC [ RunTime:0.088095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451919 LIMIT 2 [ RunTime:0.065956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451919 ORDER BY `minOrder` ASC [ RunTime:0.024478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451918 LIMIT 4 [ RunTime:0.006486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451918 ORDER BY `minOrder` ASC [ RunTime:0.034379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451918 ORDER BY `unit` DESC [ RunTime:0.067691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451918 LIMIT 2 [ RunTime:0.060520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451918 ORDER BY `minOrder` ASC [ RunTime:0.005762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451917 LIMIT 4 [ RunTime:0.035710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451917 ORDER BY `minOrder` ASC [ RunTime:0.071603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451917 ORDER BY `unit` DESC [ RunTime:0.050280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451917 LIMIT 2 [ RunTime:0.052457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451917 ORDER BY `minOrder` ASC [ RunTime:0.049798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451916 LIMIT 4 [ RunTime:0.045566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451916 ORDER BY `minOrder` ASC [ RunTime:0.055051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451916 ORDER BY `unit` DESC [ RunTime:0.031840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451916 LIMIT 2 [ RunTime:0.078273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451916 ORDER BY `minOrder` ASC [ RunTime:0.028731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451915 LIMIT 4 [ RunTime:0.025601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451915 ORDER BY `minOrder` ASC [ RunTime:0.038799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451915 ORDER BY `unit` DESC [ RunTime:0.042231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451915 LIMIT 2 [ RunTime:0.043240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451915 ORDER BY `minOrder` ASC [ RunTime:0.012172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451914 LIMIT 4 [ RunTime:0.022690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451914 ORDER BY `minOrder` ASC [ RunTime:0.020732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451914 ORDER BY `unit` DESC [ RunTime:0.026618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451914 LIMIT 2 [ RunTime:0.031130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451914 ORDER BY `minOrder` ASC [ RunTime:0.061130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451913 LIMIT 4 [ RunTime:0.005247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451913 ORDER BY `minOrder` ASC [ RunTime:0.039034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451913 ORDER BY `unit` DESC [ RunTime:0.016741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451913 LIMIT 2 [ RunTime:0.041791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451913 ORDER BY `minOrder` ASC [ RunTime:0.015156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451912 LIMIT 4 [ RunTime:0.009545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451912 ORDER BY `minOrder` ASC [ RunTime:0.023277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451912 ORDER BY `unit` DESC [ RunTime:0.047836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451912 LIMIT 2 [ RunTime:0.055901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451912 ORDER BY `minOrder` ASC [ RunTime:0.021485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451911 LIMIT 4 [ RunTime:0.017626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451911 ORDER BY `minOrder` ASC [ RunTime:0.023972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451911 ORDER BY `unit` DESC [ RunTime:0.017606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451911 LIMIT 2 [ RunTime:0.018478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451911 ORDER BY `minOrder` ASC [ RunTime:0.020139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451910 LIMIT 4 [ RunTime:0.060177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451910 ORDER BY `minOrder` ASC [ RunTime:0.021766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451910 ORDER BY `unit` DESC [ RunTime:0.057485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451910 LIMIT 2 [ RunTime:0.006633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451910 ORDER BY `minOrder` ASC [ RunTime:0.003719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451909 LIMIT 4 [ RunTime:0.010183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451909 ORDER BY `minOrder` ASC [ RunTime:0.026719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451909 ORDER BY `unit` DESC [ RunTime:0.072067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451909 LIMIT 2 [ RunTime:0.055719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451909 ORDER BY `minOrder` ASC [ RunTime:0.006153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451908 LIMIT 4 [ RunTime:0.009127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451908 ORDER BY `minOrder` ASC [ RunTime:0.067630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451908 ORDER BY `unit` DESC [ RunTime:0.029739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451908 LIMIT 2 [ RunTime:0.034019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451908 ORDER BY `minOrder` ASC [ RunTime:0.027057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451907 LIMIT 4 [ RunTime:0.039007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451907 ORDER BY `minOrder` ASC [ RunTime:0.029502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451907 ORDER BY `unit` DESC [ RunTime:0.022455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451907 LIMIT 2 [ RunTime:0.042409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451907 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451906 LIMIT 4 [ RunTime:0.017315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451906 ORDER BY `minOrder` ASC [ RunTime:0.013222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451906 ORDER BY `unit` DESC [ RunTime:0.028767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451906 LIMIT 2 [ RunTime:0.070638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451906 ORDER BY `minOrder` ASC [ RunTime:0.015176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451905 LIMIT 4 [ RunTime:0.027734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451905 ORDER BY `minOrder` ASC [ RunTime:0.038607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451905 ORDER BY `unit` DESC [ RunTime:0.015366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451905 LIMIT 2 [ RunTime:0.066207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451905 ORDER BY `minOrder` ASC [ RunTime:0.020585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451904 LIMIT 4 [ RunTime:0.041645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451904 ORDER BY `minOrder` ASC [ RunTime:0.053776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451904 ORDER BY `unit` DESC [ RunTime:0.124709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451904 LIMIT 2 [ RunTime:0.060865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451904 ORDER BY `minOrder` ASC [ RunTime:0.007215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451903 LIMIT 4 [ RunTime:0.014964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451903 ORDER BY `minOrder` ASC [ RunTime:0.085397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451903 ORDER BY `unit` DESC [ RunTime:0.024029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451903 LIMIT 2 [ RunTime:0.038223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451903 ORDER BY `minOrder` ASC [ RunTime:0.017711s ]
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.017460s ]