SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002081s ]
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=481&srecordnum=10000' [ RunTime:0.003519s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002788s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003511s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002340s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.006377s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001894s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001881s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000863s ]
UPDATE `stock_search` SET `count` = 1140 , `updatetime` = '2026-06-11 19:30:53' WHERE `partno` = '228' [ RunTime:0.001660s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000264s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000337s ]
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.003172s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002428s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.232677s ]
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 9600,20 [ RunTime:0.249617s ]
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 ('12451723','12451722','12451721','12451720','12451717','12451716','12451715','12451714','12451707','12451706','12451705','12451704','12451703','12451702','12451701','12451700','12451698','12451694','12451693','12451692') ORDER BY FIELD(s.id, 12451723,12451722,12451721,12451720,12451717,12451716,12451715,12451714,12451707,12451706,12451705,12451704,12451703,12451702,12451701,12451700,12451698,12451694,12451693,12451692) [ RunTime:0.022524s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451723 LIMIT 4 [ RunTime:0.015750s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451723 ORDER BY `minOrder` ASC [ RunTime:0.021944s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451723 ORDER BY `unit` DESC [ RunTime:0.028029s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451723 LIMIT 2 [ RunTime:0.018512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451723 ORDER BY `minOrder` ASC [ RunTime:0.005614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451722 LIMIT 4 [ RunTime:0.030732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451722 ORDER BY `minOrder` ASC [ RunTime:0.035836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451722 ORDER BY `unit` DESC [ RunTime:0.022842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451722 LIMIT 2 [ RunTime:0.027348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451722 ORDER BY `minOrder` ASC [ RunTime:0.039018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451721 LIMIT 4 [ RunTime:0.013934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451721 ORDER BY `minOrder` ASC [ RunTime:0.051952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451721 ORDER BY `unit` DESC [ RunTime:0.087731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451721 LIMIT 2 [ RunTime:0.068537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451721 ORDER BY `minOrder` ASC [ RunTime:0.025836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451720 LIMIT 4 [ RunTime:0.007037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451720 ORDER BY `minOrder` ASC [ RunTime:0.039589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451720 ORDER BY `unit` DESC [ RunTime:0.029350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451720 LIMIT 2 [ RunTime:0.034858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451720 ORDER BY `minOrder` ASC [ RunTime:0.013410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451717 LIMIT 4 [ RunTime:0.009350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451717 ORDER BY `minOrder` ASC [ RunTime:0.037161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451717 ORDER BY `unit` DESC [ RunTime:0.025930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451717 LIMIT 2 [ RunTime:0.052894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451717 ORDER BY `minOrder` ASC [ RunTime:0.009890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451716 LIMIT 4 [ RunTime:0.043898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451716 ORDER BY `minOrder` ASC [ RunTime:0.041284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451716 ORDER BY `unit` DESC [ RunTime:0.019348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451716 LIMIT 2 [ RunTime:0.016357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451716 ORDER BY `minOrder` ASC [ RunTime:0.010336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451715 LIMIT 4 [ RunTime:0.035183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451715 ORDER BY `minOrder` ASC [ RunTime:0.018123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451715 ORDER BY `unit` DESC [ RunTime:0.032142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451715 LIMIT 2 [ RunTime:0.043108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451715 ORDER BY `minOrder` ASC [ RunTime:0.010598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451714 LIMIT 4 [ RunTime:0.030261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451714 ORDER BY `minOrder` ASC [ RunTime:0.008311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451714 ORDER BY `unit` DESC [ RunTime:0.015222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451714 LIMIT 2 [ RunTime:0.029366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451714 ORDER BY `minOrder` ASC [ RunTime:0.001562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451707 LIMIT 4 [ RunTime:0.016951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451707 ORDER BY `minOrder` ASC [ RunTime:0.055100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451707 ORDER BY `unit` DESC [ RunTime:0.019831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451707 LIMIT 2 [ RunTime:0.012069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451707 ORDER BY `minOrder` ASC [ RunTime:0.021906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451706 LIMIT 4 [ RunTime:0.062237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451706 ORDER BY `minOrder` ASC [ RunTime:0.036561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451706 ORDER BY `unit` DESC [ RunTime:0.034732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451706 LIMIT 2 [ RunTime:0.012818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451706 ORDER BY `minOrder` ASC [ RunTime:0.015892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451705 LIMIT 4 [ RunTime:0.060508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451705 ORDER BY `minOrder` ASC [ RunTime:0.021359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451705 ORDER BY `unit` DESC [ RunTime:0.043865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451705 LIMIT 2 [ RunTime:0.041074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451705 ORDER BY `minOrder` ASC [ RunTime:0.037776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451704 LIMIT 4 [ RunTime:0.015065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451704 ORDER BY `minOrder` ASC [ RunTime:0.035281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451704 ORDER BY `unit` DESC [ RunTime:0.022412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451704 LIMIT 2 [ RunTime:0.021332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451704 ORDER BY `minOrder` ASC [ RunTime:0.028260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451703 LIMIT 4 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451703 ORDER BY `minOrder` ASC [ RunTime:0.044639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451703 ORDER BY `unit` DESC [ RunTime:0.023844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451703 LIMIT 2 [ RunTime:0.034926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451703 ORDER BY `minOrder` ASC [ RunTime:0.005000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451702 LIMIT 4 [ RunTime:0.076478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451702 ORDER BY `minOrder` ASC [ RunTime:0.054663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451702 ORDER BY `unit` DESC [ RunTime:0.042448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451702 LIMIT 2 [ RunTime:0.036554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451702 ORDER BY `minOrder` ASC [ RunTime:0.050483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451701 LIMIT 4 [ RunTime:0.024687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451701 ORDER BY `minOrder` ASC [ RunTime:0.046099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451701 ORDER BY `unit` DESC [ RunTime:0.021143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451701 LIMIT 2 [ RunTime:0.032158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451701 ORDER BY `minOrder` ASC [ RunTime:0.005300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451700 LIMIT 4 [ RunTime:0.018595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451700 ORDER BY `minOrder` ASC [ RunTime:0.050645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451700 ORDER BY `unit` DESC [ RunTime:0.023265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451700 LIMIT 2 [ RunTime:0.020524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451700 ORDER BY `minOrder` ASC [ RunTime:0.029734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451698 LIMIT 4 [ RunTime:0.037027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451698 ORDER BY `minOrder` ASC [ RunTime:0.025391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451698 ORDER BY `unit` DESC [ RunTime:0.084160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451698 LIMIT 2 [ RunTime:0.014200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451698 ORDER BY `minOrder` ASC [ RunTime:0.039256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451694 LIMIT 4 [ RunTime:0.050080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451694 ORDER BY `minOrder` ASC [ RunTime:0.044734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451694 ORDER BY `unit` DESC [ RunTime:0.033172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451694 LIMIT 2 [ RunTime:0.073387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451694 ORDER BY `minOrder` ASC [ RunTime:0.033824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451693 LIMIT 4 [ RunTime:0.024214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451693 ORDER BY `minOrder` ASC [ RunTime:0.053475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451693 ORDER BY `unit` DESC [ RunTime:0.035958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451693 LIMIT 2 [ RunTime:0.012596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451693 ORDER BY `minOrder` ASC [ RunTime:0.009461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451692 LIMIT 4 [ RunTime:0.012169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451692 ORDER BY `minOrder` ASC [ RunTime:0.027221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451692 ORDER BY `unit` DESC [ RunTime:0.004375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451692 LIMIT 2 [ RunTime:0.025586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451692 ORDER BY `minOrder` ASC [ RunTime:0.003498s ]
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.122226s ]