SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001318s ]
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.321825s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001452s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.029718s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001329s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.023609s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.005013s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.022477s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002467s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.167607s ]
UPDATE `stock_search` SET `count` = 2361 , `updatetime` = '2026-06-07 01:13:05' WHERE `partno` = '210' [ RunTime:0.046259s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.021046s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.032748s ]
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.018387s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.005024s ]
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.103601s ]
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 4400,20 [ RunTime:0.129529s ]
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 ('13325776','13325773','13325769','13325688','13325658','13325631','13325618','13325595','13325594','13325571','13321024','13321022','13321021','13321020','13321018','13321017','13321016','13320885','13320883','13320836') ORDER BY FIELD(s.id, 13325776,13325773,13325769,13325688,13325658,13325631,13325618,13325595,13325594,13325571,13321024,13321022,13321021,13321020,13321018,13321017,13321016,13320885,13320883,13320836) [ RunTime:0.016953s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325776 LIMIT 4 [ RunTime:0.060520s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325776 ORDER BY `minOrder` ASC [ RunTime:0.021806s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325776 ORDER BY `unit` DESC [ RunTime:0.046099s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325776 LIMIT 2 [ RunTime:0.053309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325776 ORDER BY `minOrder` ASC [ RunTime:0.081532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325773 LIMIT 4 [ RunTime:0.058375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325773 ORDER BY `minOrder` ASC [ RunTime:0.034159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325773 ORDER BY `unit` DESC [ RunTime:0.062186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325773 LIMIT 2 [ RunTime:0.057249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325773 ORDER BY `minOrder` ASC [ RunTime:0.044982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325769 LIMIT 4 [ RunTime:0.015282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.051564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325769 ORDER BY `unit` DESC [ RunTime:0.038419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325769 LIMIT 2 [ RunTime:0.027800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.018975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325688 LIMIT 4 [ RunTime:0.041960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325688 ORDER BY `minOrder` ASC [ RunTime:0.024487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325688 ORDER BY `unit` DESC [ RunTime:0.047579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325688 LIMIT 2 [ RunTime:0.044426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325688 ORDER BY `minOrder` ASC [ RunTime:0.017711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325658 LIMIT 4 [ RunTime:0.024837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325658 ORDER BY `minOrder` ASC [ RunTime:0.037419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325658 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325658 LIMIT 2 [ RunTime:0.010464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325658 ORDER BY `minOrder` ASC [ RunTime:0.011405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325631 LIMIT 4 [ RunTime:0.024190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325631 ORDER BY `minOrder` ASC [ RunTime:0.009783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325631 ORDER BY `unit` DESC [ RunTime:0.003753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325631 LIMIT 2 [ RunTime:0.014490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325631 ORDER BY `minOrder` ASC [ RunTime:0.008841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325618 LIMIT 4 [ RunTime:0.018782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325618 ORDER BY `minOrder` ASC [ RunTime:0.008285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325618 ORDER BY `unit` DESC [ RunTime:0.049047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325618 LIMIT 2 [ RunTime:0.007985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325618 ORDER BY `minOrder` ASC [ RunTime:0.063952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325595 LIMIT 4 [ RunTime:0.107633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325595 ORDER BY `minOrder` ASC [ RunTime:0.007553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325595 ORDER BY `unit` DESC [ RunTime:0.004491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325595 LIMIT 2 [ RunTime:0.017950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325595 ORDER BY `minOrder` ASC [ RunTime:0.008606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325594 LIMIT 4 [ RunTime:0.006314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.005299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325594 ORDER BY `unit` DESC [ RunTime:0.031659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325594 LIMIT 2 [ RunTime:0.073138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.050630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325571 LIMIT 4 [ RunTime:0.061146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.052586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325571 ORDER BY `unit` DESC [ RunTime:0.129252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325571 LIMIT 2 [ RunTime:0.092634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.041325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321024 LIMIT 4 [ RunTime:0.063240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321024 ORDER BY `minOrder` ASC [ RunTime:0.075385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321024 ORDER BY `unit` DESC [ RunTime:0.068990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321024 LIMIT 2 [ RunTime:0.032065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321024 ORDER BY `minOrder` ASC [ RunTime:0.071722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321022 LIMIT 4 [ RunTime:0.026481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321022 ORDER BY `minOrder` ASC [ RunTime:0.070389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321022 ORDER BY `unit` DESC [ RunTime:0.050369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321022 LIMIT 2 [ RunTime:0.038206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321022 ORDER BY `minOrder` ASC [ RunTime:0.025998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321021 LIMIT 4 [ RunTime:0.082212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321021 ORDER BY `minOrder` ASC [ RunTime:0.062553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321021 ORDER BY `unit` DESC [ RunTime:0.017406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321021 LIMIT 2 [ RunTime:0.004804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321021 ORDER BY `minOrder` ASC [ RunTime:0.039672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321020 LIMIT 4 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321020 ORDER BY `minOrder` ASC [ RunTime:0.073565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321020 ORDER BY `unit` DESC [ RunTime:0.054073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321020 LIMIT 2 [ RunTime:0.018275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321020 ORDER BY `minOrder` ASC [ RunTime:0.017562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321018 LIMIT 4 [ RunTime:0.027412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321018 ORDER BY `minOrder` ASC [ RunTime:0.019107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321018 ORDER BY `unit` DESC [ RunTime:0.030757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321018 LIMIT 2 [ RunTime:0.086122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321018 ORDER BY `minOrder` ASC [ RunTime:0.020794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321017 LIMIT 4 [ RunTime:0.069066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321017 ORDER BY `minOrder` ASC [ RunTime:0.037145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321017 ORDER BY `unit` DESC [ RunTime:0.063989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321017 LIMIT 2 [ RunTime:0.048167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321017 ORDER BY `minOrder` ASC [ RunTime:0.041529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321016 LIMIT 4 [ RunTime:0.110170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321016 ORDER BY `minOrder` ASC [ RunTime:0.038188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321016 ORDER BY `unit` DESC [ RunTime:0.052280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321016 LIMIT 2 [ RunTime:0.141608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321016 ORDER BY `minOrder` ASC [ RunTime:0.059809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320885 LIMIT 4 [ RunTime:0.037835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320885 ORDER BY `minOrder` ASC [ RunTime:0.078587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320885 ORDER BY `unit` DESC [ RunTime:0.048480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320885 LIMIT 2 [ RunTime:0.042618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320885 ORDER BY `minOrder` ASC [ RunTime:0.058624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320883 LIMIT 4 [ RunTime:0.032793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320883 ORDER BY `minOrder` ASC [ RunTime:0.024673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320883 ORDER BY `unit` DESC [ RunTime:0.027930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320883 LIMIT 2 [ RunTime:0.024805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320883 ORDER BY `minOrder` ASC [ RunTime:0.033321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320836 LIMIT 4 [ RunTime:0.015850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320836 ORDER BY `minOrder` ASC [ RunTime:0.005095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320836 ORDER BY `unit` DESC [ RunTime:0.016503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320836 LIMIT 2 [ RunTime:0.057269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320836 ORDER BY `minOrder` ASC [ RunTime:0.048267s ]
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.109646s ]