SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002425s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.142485s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002495s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.052246s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003740s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.030981s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003005s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.050980s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002049s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.136953s ]
UPDATE `stock_search` SET `count` = 2348 , `updatetime` = '2026-06-07 01:09:56' WHERE `partno` = '210' [ RunTime:0.049386s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.027058s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.070521s ]
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.051780s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001621s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.086510s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 4320,20 [ RunTime:0.229969s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('13479083','13478952','13478418','13478399','13478210','13478179','13478018','13477637','13477551','13477490','13477431','13474302','13427227','13427223','13406208','13406207','13406206','13392884','13392883','13392882') ORDER BY FIELD(s.id, 13479083,13478952,13478418,13478399,13478210,13478179,13478018,13477637,13477551,13477490,13477431,13474302,13427227,13427223,13406208,13406207,13406206,13392884,13392883,13392882) [ RunTime:0.098981s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13479083 LIMIT 4 [ RunTime:0.052378s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479083 ORDER BY `minOrder` ASC [ RunTime:0.027885s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.023669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13479083 ORDER BY `unit` DESC [ RunTime:0.135942s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13479083 LIMIT 2 [ RunTime:0.051070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479083 ORDER BY `minOrder` ASC [ RunTime:0.024806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478952 LIMIT 4 [ RunTime:0.144035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478952 ORDER BY `minOrder` ASC [ RunTime:0.003171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478952 ORDER BY `unit` DESC [ RunTime:0.032317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478952 LIMIT 2 [ RunTime:0.054984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478952 ORDER BY `minOrder` ASC [ RunTime:0.100374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478418 LIMIT 4 [ RunTime:0.088486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478418 ORDER BY `minOrder` ASC [ RunTime:0.076446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478418 ORDER BY `unit` DESC [ RunTime:0.118207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478418 LIMIT 2 [ RunTime:0.108680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478418 ORDER BY `minOrder` ASC [ RunTime:0.078534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478399 LIMIT 4 [ RunTime:0.051150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478399 ORDER BY `minOrder` ASC [ RunTime:0.036369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478399 ORDER BY `unit` DESC [ RunTime:0.137852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478399 LIMIT 2 [ RunTime:0.044606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478399 ORDER BY `minOrder` ASC [ RunTime:0.030674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478210 LIMIT 4 [ RunTime:0.051361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478210 ORDER BY `minOrder` ASC [ RunTime:0.051442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478210 ORDER BY `unit` DESC [ RunTime:0.050984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478210 LIMIT 2 [ RunTime:0.084394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478210 ORDER BY `minOrder` ASC [ RunTime:0.102310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478179 LIMIT 4 [ RunTime:0.051392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478179 ORDER BY `minOrder` ASC [ RunTime:0.046963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478179 ORDER BY `unit` DESC [ RunTime:0.097653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478179 LIMIT 2 [ RunTime:0.051711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478179 ORDER BY `minOrder` ASC [ RunTime:0.051243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478018 LIMIT 4 [ RunTime:0.145372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478018 ORDER BY `minOrder` ASC [ RunTime:0.099261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478018 ORDER BY `unit` DESC [ RunTime:0.076969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478018 LIMIT 2 [ RunTime:0.052454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478018 ORDER BY `minOrder` ASC [ RunTime:0.050906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13477637 LIMIT 4 [ RunTime:0.060891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477637 ORDER BY `minOrder` ASC [ RunTime:0.191937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13477637 ORDER BY `unit` DESC [ RunTime:0.187573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13477637 LIMIT 2 [ RunTime:0.088128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477637 ORDER BY `minOrder` ASC [ RunTime:0.058750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13477551 LIMIT 4 [ RunTime:0.104505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477551 ORDER BY `minOrder` ASC [ RunTime:0.117496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13477551 ORDER BY `unit` DESC [ RunTime:0.033382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13477551 LIMIT 2 [ RunTime:0.070861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477551 ORDER BY `minOrder` ASC [ RunTime:0.050712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13477490 LIMIT 4 [ RunTime:0.097907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477490 ORDER BY `minOrder` ASC [ RunTime:0.130273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13477490 ORDER BY `unit` DESC [ RunTime:0.119981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13477490 LIMIT 2 [ RunTime:0.071272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477490 ORDER BY `minOrder` ASC [ RunTime:0.091629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13477431 LIMIT 4 [ RunTime:0.092570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477431 ORDER BY `minOrder` ASC [ RunTime:0.060994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13477431 ORDER BY `unit` DESC [ RunTime:0.058780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13477431 LIMIT 2 [ RunTime:0.122418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13477431 ORDER BY `minOrder` ASC [ RunTime:0.034243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474302 LIMIT 4 [ RunTime:0.091730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474302 ORDER BY `minOrder` ASC [ RunTime:0.217156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474302 ORDER BY `unit` DESC [ RunTime:0.091193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474302 LIMIT 2 [ RunTime:0.089580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474302 ORDER BY `minOrder` ASC [ RunTime:0.167190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13427227 LIMIT 4 [ RunTime:0.094034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427227 ORDER BY `minOrder` ASC [ RunTime:0.172637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13427227 ORDER BY `unit` DESC [ RunTime:0.151317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13427227 LIMIT 2 [ RunTime:0.178989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427227 ORDER BY `minOrder` ASC [ RunTime:0.001752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13427223 LIMIT 4 [ RunTime:0.092528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427223 ORDER BY `minOrder` ASC [ RunTime:0.131901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13427223 ORDER BY `unit` DESC [ RunTime:0.355310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13427223 LIMIT 2 [ RunTime:0.121320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427223 ORDER BY `minOrder` ASC [ RunTime:0.070184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13406208 LIMIT 4 [ RunTime:0.051494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13406208 ORDER BY `minOrder` ASC [ RunTime:0.140601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13406208 ORDER BY `unit` DESC [ RunTime:0.168008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13406208 LIMIT 2 [ RunTime:0.057002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13406208 ORDER BY `minOrder` ASC [ RunTime:0.051135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13406207 LIMIT 4 [ RunTime:0.038298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13406207 ORDER BY `minOrder` ASC [ RunTime:0.093905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13406207 ORDER BY `unit` DESC [ RunTime:0.064009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13406207 LIMIT 2 [ RunTime:0.052793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13406207 ORDER BY `minOrder` ASC [ RunTime:0.058056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13406206 LIMIT 4 [ RunTime:0.049277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13406206 ORDER BY `minOrder` ASC [ RunTime:0.012827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13406206 ORDER BY `unit` DESC [ RunTime:0.023998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13406206 LIMIT 2 [ RunTime:0.070654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13406206 ORDER BY `minOrder` ASC [ RunTime:0.024298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392884 LIMIT 4 [ RunTime:0.036949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392884 ORDER BY `minOrder` ASC [ RunTime:0.006504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392884 ORDER BY `unit` DESC [ RunTime:0.034084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392884 LIMIT 2 [ RunTime:0.089545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392884 ORDER BY `minOrder` ASC [ RunTime:0.102187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392883 LIMIT 4 [ RunTime:0.029962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392883 ORDER BY `minOrder` ASC [ RunTime:0.040574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392883 ORDER BY `unit` DESC [ RunTime:0.079013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392883 LIMIT 2 [ RunTime:0.020561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392883 ORDER BY `minOrder` ASC [ RunTime:0.013314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392882 LIMIT 4 [ RunTime:0.009361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392882 ORDER BY `minOrder` ASC [ RunTime:0.013193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392882 ORDER BY `unit` DESC [ RunTime:0.029690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392882 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392882 ORDER BY `minOrder` ASC [ RunTime:0.034823s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.085073s ]