SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001864s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.003378s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001215s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002905s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001484s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001492s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004425s ]
UPDATE `stock_search` SET `count` = 4131 , `updatetime` = '2026-06-08 16:48:15' WHERE `partno` = '210' [ RunTime:0.013373s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000321s ]
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.009004s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001568s ]
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.166216s ]
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 5600,20 [ RunTime:0.132313s ]
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 ('19567510','19567509','19567508','19567507','19567506','19567505','19567504','19567501','19567500','19567499','19567498','19567497','19567496','19567495','19567494','19567493','19567492','19567491','19567490','19567489') ORDER BY FIELD(s.id, 19567510,19567509,19567508,19567507,19567506,19567505,19567504,19567501,19567500,19567499,19567498,19567497,19567496,19567495,19567494,19567493,19567492,19567491,19567490,19567489) [ RunTime:0.123774s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567510 LIMIT 4 [ RunTime:0.001210s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567510 ORDER BY `minOrder` ASC [ RunTime:0.007104s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567510 ORDER BY `unit` DESC [ RunTime:0.044116s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567510 LIMIT 2 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567510 ORDER BY `minOrder` ASC [ RunTime:0.002182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567509 LIMIT 4 [ RunTime:0.018168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567509 ORDER BY `minOrder` ASC [ RunTime:0.019779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567509 ORDER BY `unit` DESC [ RunTime:0.014802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567509 LIMIT 2 [ RunTime:0.016443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567509 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567508 LIMIT 4 [ RunTime:0.006814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567508 ORDER BY `minOrder` ASC [ RunTime:0.024440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567508 ORDER BY `unit` DESC [ RunTime:0.000873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567508 LIMIT 2 [ RunTime:0.004543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567508 ORDER BY `minOrder` ASC [ RunTime:0.011443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567507 LIMIT 4 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567507 ORDER BY `minOrder` ASC [ RunTime:0.009174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567507 ORDER BY `unit` DESC [ RunTime:0.011050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567507 LIMIT 2 [ RunTime:0.017371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567507 ORDER BY `minOrder` ASC [ RunTime:0.009958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567506 LIMIT 4 [ RunTime:0.012560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567506 ORDER BY `minOrder` ASC [ RunTime:0.008285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567506 ORDER BY `unit` DESC [ RunTime:0.010909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567506 LIMIT 2 [ RunTime:0.020935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567506 ORDER BY `minOrder` ASC [ RunTime:0.017056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567505 LIMIT 4 [ RunTime:0.020212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567505 ORDER BY `minOrder` ASC [ RunTime:0.034849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567505 ORDER BY `unit` DESC [ RunTime:0.036891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567505 LIMIT 2 [ RunTime:0.008437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567505 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567504 LIMIT 4 [ RunTime:0.003149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567504 ORDER BY `minOrder` ASC [ RunTime:0.029750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567504 ORDER BY `unit` DESC [ RunTime:0.028495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567504 LIMIT 2 [ RunTime:0.036457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567504 ORDER BY `minOrder` ASC [ RunTime:0.003673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567501 LIMIT 4 [ RunTime:0.012548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567501 ORDER BY `minOrder` ASC [ RunTime:0.025602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567501 ORDER BY `unit` DESC [ RunTime:0.026176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567501 LIMIT 2 [ RunTime:0.005553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567501 ORDER BY `minOrder` ASC [ RunTime:0.007066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567500 LIMIT 4 [ RunTime:0.007366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567500 ORDER BY `minOrder` ASC [ RunTime:0.016986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567500 ORDER BY `unit` DESC [ RunTime:0.000800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567500 LIMIT 2 [ RunTime:0.021310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567500 ORDER BY `minOrder` ASC [ RunTime:0.013609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567499 LIMIT 4 [ RunTime:0.005040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567499 ORDER BY `minOrder` ASC [ RunTime:0.028002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567499 ORDER BY `unit` DESC [ RunTime:0.010407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567499 LIMIT 2 [ RunTime:0.024950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567499 ORDER BY `minOrder` ASC [ RunTime:0.006156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567498 LIMIT 4 [ RunTime:0.009804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567498 ORDER BY `minOrder` ASC [ RunTime:0.034398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567498 ORDER BY `unit` DESC [ RunTime:0.011357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567498 LIMIT 2 [ RunTime:0.013911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567498 ORDER BY `minOrder` ASC [ RunTime:0.001668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567497 LIMIT 4 [ RunTime:0.021270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567497 ORDER BY `minOrder` ASC [ RunTime:0.001218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567497 ORDER BY `unit` DESC [ RunTime:0.026550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567497 LIMIT 2 [ RunTime:0.004998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567497 ORDER BY `minOrder` ASC [ RunTime:0.002645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567496 LIMIT 4 [ RunTime:0.015476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567496 ORDER BY `minOrder` ASC [ RunTime:0.029312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567496 ORDER BY `unit` DESC [ RunTime:0.026733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567496 LIMIT 2 [ RunTime:0.012845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567496 ORDER BY `minOrder` ASC [ RunTime:0.006543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567495 LIMIT 4 [ RunTime:0.001308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567495 ORDER BY `minOrder` ASC [ RunTime:0.032245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567495 ORDER BY `unit` DESC [ RunTime:0.011520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567495 LIMIT 2 [ RunTime:0.003462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567495 ORDER BY `minOrder` ASC [ RunTime:0.023248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567494 LIMIT 4 [ RunTime:0.014698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567494 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567494 ORDER BY `unit` DESC [ RunTime:0.014393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567494 LIMIT 2 [ RunTime:0.013888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567494 ORDER BY `minOrder` ASC [ RunTime:0.019953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567493 LIMIT 4 [ RunTime:0.009988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567493 ORDER BY `minOrder` ASC [ RunTime:0.047248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567493 ORDER BY `unit` DESC [ RunTime:0.030502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567493 LIMIT 2 [ RunTime:0.003872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567493 ORDER BY `minOrder` ASC [ RunTime:0.009498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567492 LIMIT 4 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567492 ORDER BY `minOrder` ASC [ RunTime:0.028340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567492 ORDER BY `unit` DESC [ RunTime:0.005136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567492 LIMIT 2 [ RunTime:0.010640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567492 ORDER BY `minOrder` ASC [ RunTime:0.011645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567491 LIMIT 4 [ RunTime:0.027221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567491 ORDER BY `minOrder` ASC [ RunTime:0.015578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567491 ORDER BY `unit` DESC [ RunTime:0.003090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567491 LIMIT 2 [ RunTime:0.008412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567491 ORDER BY `minOrder` ASC [ RunTime:0.004392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567490 LIMIT 4 [ RunTime:0.006750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567490 ORDER BY `minOrder` ASC [ RunTime:0.021376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567490 ORDER BY `unit` DESC [ RunTime:0.012752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567490 LIMIT 2 [ RunTime:0.003205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567490 ORDER BY `minOrder` ASC [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567489 LIMIT 4 [ RunTime:0.001344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567489 ORDER BY `minOrder` ASC [ RunTime:0.004501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567489 ORDER BY `unit` DESC [ RunTime:0.002388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567489 LIMIT 2 [ RunTime:0.006015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567489 ORDER BY `minOrder` ASC [ RunTime:0.001916s ]
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.081004s ]