SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002577s ]
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.009401s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001957s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003149s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002181s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.002771s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001809s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005660s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003051s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002196s ]
UPDATE `stock_search` SET `count` = 2386 , `updatetime` = '2026-06-07 02:08:47' WHERE `partno` = '210' [ RunTime:0.005171s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000245s ]
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.000448s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002476s ]
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.403979s ]
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.132667s ]
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.023825s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325776 LIMIT 4 [ RunTime:0.024021s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325776 ORDER BY `minOrder` ASC [ RunTime:0.023606s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325776 ORDER BY `unit` DESC [ RunTime:0.032481s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325776 LIMIT 2 [ RunTime:0.008504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325776 ORDER BY `minOrder` ASC [ RunTime:0.019588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325773 LIMIT 4 [ RunTime:0.014069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325773 ORDER BY `minOrder` ASC [ RunTime:0.021737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325773 ORDER BY `unit` DESC [ RunTime:0.008429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325773 LIMIT 2 [ RunTime:0.015443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325773 ORDER BY `minOrder` ASC [ RunTime:0.009978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325769 LIMIT 4 [ RunTime:0.017584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.015271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325769 ORDER BY `unit` DESC [ RunTime:0.020140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325769 LIMIT 2 [ RunTime:0.010476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.003216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325688 LIMIT 4 [ RunTime:0.019080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325688 ORDER BY `minOrder` ASC [ RunTime:0.017364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325688 ORDER BY `unit` DESC [ RunTime:0.018650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325688 LIMIT 2 [ RunTime:0.019368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325688 ORDER BY `minOrder` ASC [ RunTime:0.006063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325658 LIMIT 4 [ RunTime:0.022876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325658 ORDER BY `minOrder` ASC [ RunTime:0.011672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325658 ORDER BY `unit` DESC [ RunTime:0.018666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325658 LIMIT 2 [ RunTime:0.017384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325658 ORDER BY `minOrder` ASC [ RunTime:0.008178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325631 LIMIT 4 [ RunTime:0.017248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325631 ORDER BY `minOrder` ASC [ RunTime:0.006988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325631 ORDER BY `unit` DESC [ RunTime:0.021062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325631 LIMIT 2 [ RunTime:0.009267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325631 ORDER BY `minOrder` ASC [ RunTime:0.003742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325618 LIMIT 4 [ RunTime:0.016819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325618 ORDER BY `minOrder` ASC [ RunTime:0.015250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325618 ORDER BY `unit` DESC [ RunTime:0.030637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325618 LIMIT 2 [ RunTime:0.039170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325618 ORDER BY `minOrder` ASC [ RunTime:0.019066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325595 LIMIT 4 [ RunTime:0.009669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325595 ORDER BY `minOrder` ASC [ RunTime:0.028256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325595 ORDER BY `unit` DESC [ RunTime:0.016597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325595 LIMIT 2 [ RunTime:0.030423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325595 ORDER BY `minOrder` ASC [ RunTime:0.006708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325594 LIMIT 4 [ RunTime:0.071043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.030965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325594 ORDER BY `unit` DESC [ RunTime:0.086308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325594 LIMIT 2 [ RunTime:0.025250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.007749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325571 LIMIT 4 [ RunTime:0.028269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.018725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325571 ORDER BY `unit` DESC [ RunTime:0.082338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325571 LIMIT 2 [ RunTime:0.029525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.034969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321024 LIMIT 4 [ RunTime:0.038136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321024 ORDER BY `minOrder` ASC [ RunTime:0.090470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321024 ORDER BY `unit` DESC [ RunTime:0.030410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321024 LIMIT 2 [ RunTime:0.066976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321024 ORDER BY `minOrder` ASC [ RunTime:0.038939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321022 LIMIT 4 [ RunTime:0.078388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321022 ORDER BY `minOrder` ASC [ RunTime:0.048917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321022 ORDER BY `unit` DESC [ RunTime:0.034401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321022 LIMIT 2 [ RunTime:0.032083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321022 ORDER BY `minOrder` ASC [ RunTime:0.033526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321021 LIMIT 4 [ RunTime:0.051309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321021 ORDER BY `minOrder` ASC [ RunTime:0.083125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321021 ORDER BY `unit` DESC [ RunTime:0.013669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321021 LIMIT 2 [ RunTime:0.017964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321021 ORDER BY `minOrder` ASC [ RunTime:0.004798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321020 LIMIT 4 [ RunTime:0.040873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321020 ORDER BY `minOrder` ASC [ RunTime:0.012205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321020 ORDER BY `unit` DESC [ RunTime:0.037419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321020 LIMIT 2 [ RunTime:0.024358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321020 ORDER BY `minOrder` ASC [ RunTime:0.028116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321018 LIMIT 4 [ RunTime:0.037501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321018 ORDER BY `minOrder` ASC [ RunTime:0.083946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321018 ORDER BY `unit` DESC [ RunTime:0.025199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321018 LIMIT 2 [ RunTime:0.054984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321018 ORDER BY `minOrder` ASC [ RunTime:0.017706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321017 LIMIT 4 [ RunTime:0.024149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321017 ORDER BY `minOrder` ASC [ RunTime:0.024643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321017 ORDER BY `unit` DESC [ RunTime:0.075052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321017 LIMIT 2 [ RunTime:0.053052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321017 ORDER BY `minOrder` ASC [ RunTime:0.033917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321016 LIMIT 4 [ RunTime:0.064676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321016 ORDER BY `minOrder` ASC [ RunTime:0.067142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321016 ORDER BY `unit` DESC [ RunTime:0.061476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321016 LIMIT 2 [ RunTime:0.062942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321016 ORDER BY `minOrder` ASC [ RunTime:0.057438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320885 LIMIT 4 [ RunTime:0.101238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320885 ORDER BY `minOrder` ASC [ RunTime:0.024578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320885 ORDER BY `unit` DESC [ RunTime:0.060929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320885 LIMIT 2 [ RunTime:0.050074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320885 ORDER BY `minOrder` ASC [ RunTime:0.062377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320883 LIMIT 4 [ RunTime:0.075389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320883 ORDER BY `minOrder` ASC [ RunTime:0.121027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320883 ORDER BY `unit` DESC [ RunTime:0.092117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320883 LIMIT 2 [ RunTime:0.059897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320883 ORDER BY `minOrder` ASC [ RunTime:0.017464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320836 LIMIT 4 [ RunTime:0.057250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320836 ORDER BY `minOrder` ASC [ RunTime:0.095344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320836 ORDER BY `unit` DESC [ RunTime:0.048910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320836 LIMIT 2 [ RunTime:0.027678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320836 ORDER BY `minOrder` ASC [ RunTime:0.017073s ]
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.106734s ]