SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001384s ]
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=473&srecordnum=10000' [ RunTime:0.001660s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001607s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001982s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002062s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002102s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004099s ]
UPDATE `stock_search` SET `count` = 1160 , `updatetime` = '2026-06-11 21:57:54' WHERE `partno` = '228' [ RunTime:0.009681s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000283s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000256s ]
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.000462s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002314s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.231544s ]
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 9440,20 [ RunTime:0.184410s ]
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 ('12451902','12451901','12451900','12451899','12451898','12451897','12451896','12451895','12451894','12451893','12451892','12451891','12451890','12451889','12451888','12451887','12451886','12451885','12451884','12451883') ORDER BY FIELD(s.id, 12451902,12451901,12451900,12451899,12451898,12451897,12451896,12451895,12451894,12451893,12451892,12451891,12451890,12451889,12451888,12451887,12451886,12451885,12451884,12451883) [ RunTime:0.010616s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451902 LIMIT 4 [ RunTime:0.027051s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451902 ORDER BY `minOrder` ASC [ RunTime:0.020189s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.016030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451902 ORDER BY `unit` DESC [ RunTime:0.026885s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451902 LIMIT 2 [ RunTime:0.003228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451902 ORDER BY `minOrder` ASC [ RunTime:0.027063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451901 LIMIT 4 [ RunTime:0.036427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451901 ORDER BY `minOrder` ASC [ RunTime:0.032600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451901 ORDER BY `unit` DESC [ RunTime:0.018411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451901 LIMIT 2 [ RunTime:0.045526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451901 ORDER BY `minOrder` ASC [ RunTime:0.021792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451900 LIMIT 4 [ RunTime:0.013869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451900 ORDER BY `minOrder` ASC [ RunTime:0.027869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451900 ORDER BY `unit` DESC [ RunTime:0.016561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451900 LIMIT 2 [ RunTime:0.036833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451900 ORDER BY `minOrder` ASC [ RunTime:0.022566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451899 LIMIT 4 [ RunTime:0.019500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451899 ORDER BY `minOrder` ASC [ RunTime:0.004223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451899 ORDER BY `unit` DESC [ RunTime:0.066342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451899 LIMIT 2 [ RunTime:0.061265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451899 ORDER BY `minOrder` ASC [ RunTime:0.042722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451898 LIMIT 4 [ RunTime:0.022972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451898 ORDER BY `minOrder` ASC [ RunTime:0.059357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451898 ORDER BY `unit` DESC [ RunTime:0.032738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451898 LIMIT 2 [ RunTime:0.048670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451898 ORDER BY `minOrder` ASC [ RunTime:0.041601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451897 LIMIT 4 [ RunTime:0.020950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451897 ORDER BY `minOrder` ASC [ RunTime:0.031722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451897 ORDER BY `unit` DESC [ RunTime:0.061135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451897 LIMIT 2 [ RunTime:0.037493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451897 ORDER BY `minOrder` ASC [ RunTime:0.014044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451896 LIMIT 4 [ RunTime:0.015708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451896 ORDER BY `minOrder` ASC [ RunTime:0.136079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451896 ORDER BY `unit` DESC [ RunTime:0.055450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451896 LIMIT 2 [ RunTime:0.012796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451896 ORDER BY `minOrder` ASC [ RunTime:0.008031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451895 LIMIT 4 [ RunTime:0.044755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451895 ORDER BY `minOrder` ASC [ RunTime:0.045514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451895 ORDER BY `unit` DESC [ RunTime:0.029736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451895 LIMIT 2 [ RunTime:0.010926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451895 ORDER BY `minOrder` ASC [ RunTime:0.016477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451894 LIMIT 4 [ RunTime:0.012084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451894 ORDER BY `minOrder` ASC [ RunTime:0.011916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451894 ORDER BY `unit` DESC [ RunTime:0.036667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451894 LIMIT 2 [ RunTime:0.056789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451894 ORDER BY `minOrder` ASC [ RunTime:0.020468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451893 LIMIT 4 [ RunTime:0.008085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451893 ORDER BY `minOrder` ASC [ RunTime:0.036751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451893 ORDER BY `unit` DESC [ RunTime:0.019980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451893 LIMIT 2 [ RunTime:0.016176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451893 ORDER BY `minOrder` ASC [ RunTime:0.048772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451892 LIMIT 4 [ RunTime:0.032113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451892 ORDER BY `minOrder` ASC [ RunTime:0.037409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451892 ORDER BY `unit` DESC [ RunTime:0.022679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451892 LIMIT 2 [ RunTime:0.022381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451892 ORDER BY `minOrder` ASC [ RunTime:0.018000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451891 LIMIT 4 [ RunTime:0.018552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451891 ORDER BY `minOrder` ASC [ RunTime:0.018852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451891 ORDER BY `unit` DESC [ RunTime:0.026717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451891 LIMIT 2 [ RunTime:0.018931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451891 ORDER BY `minOrder` ASC [ RunTime:0.012410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451890 LIMIT 4 [ RunTime:0.060012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451890 ORDER BY `minOrder` ASC [ RunTime:0.053836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451890 ORDER BY `unit` DESC [ RunTime:0.012717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451890 LIMIT 2 [ RunTime:0.012832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451890 ORDER BY `minOrder` ASC [ RunTime:0.024433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451889 LIMIT 4 [ RunTime:0.040467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451889 ORDER BY `minOrder` ASC [ RunTime:0.043406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451889 ORDER BY `unit` DESC [ RunTime:0.018413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451889 LIMIT 2 [ RunTime:0.023201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451889 ORDER BY `minOrder` ASC [ RunTime:0.004023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451888 LIMIT 4 [ RunTime:0.023130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451888 ORDER BY `minOrder` ASC [ RunTime:0.014981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451888 ORDER BY `unit` DESC [ RunTime:0.017433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451888 LIMIT 2 [ RunTime:0.028798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451888 ORDER BY `minOrder` ASC [ RunTime:0.017448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451887 LIMIT 4 [ RunTime:0.050910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451887 ORDER BY `minOrder` ASC [ RunTime:0.036478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451887 ORDER BY `unit` DESC [ RunTime:0.025348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451887 LIMIT 2 [ RunTime:0.055917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451887 ORDER BY `minOrder` ASC [ RunTime:0.024507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451886 LIMIT 4 [ RunTime:0.016569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451886 ORDER BY `minOrder` ASC [ RunTime:0.061005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451886 ORDER BY `unit` DESC [ RunTime:0.054600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451886 LIMIT 2 [ RunTime:0.025203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451886 ORDER BY `minOrder` ASC [ RunTime:0.007887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451885 LIMIT 4 [ RunTime:0.005375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451885 ORDER BY `minOrder` ASC [ RunTime:0.036519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451885 ORDER BY `unit` DESC [ RunTime:0.010212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451885 LIMIT 2 [ RunTime:0.122986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451885 ORDER BY `minOrder` ASC [ RunTime:0.007624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451884 LIMIT 4 [ RunTime:0.023371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451884 ORDER BY `minOrder` ASC [ RunTime:0.083507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451884 ORDER BY `unit` DESC [ RunTime:0.044031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451884 LIMIT 2 [ RunTime:0.049348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451884 ORDER BY `minOrder` ASC [ RunTime:0.032619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451883 LIMIT 4 [ RunTime:0.017662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451883 ORDER BY `minOrder` ASC [ RunTime:0.005258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451883 ORDER BY `unit` DESC [ RunTime:0.129903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451883 LIMIT 2 [ RunTime:0.082729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451883 ORDER BY `minOrder` ASC [ RunTime:0.009542s ]
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.007721s ]