SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001512s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001510s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001406s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001287s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001745s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.006254s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002213s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005945s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001713s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005525s ]
UPDATE `stock_search` SET `count` = 1057 , `updatetime` = '2026-06-05 20:08:04' WHERE `partno` = '210' [ RunTime:0.015341s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.010785s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000443s ]
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.000468s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002127s ]
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.232569s ]
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 3160,20 [ RunTime:0.083356s ]
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 ('14362472','14354342','14354185','14353582','14353493','14352326','14318693','14318692','14318691','14318652','14318650','14317460','14317459','14300460','14300459','14300458','14300181','14299535','14280363','14280362') ORDER BY FIELD(s.id, 14362472,14354342,14354185,14353582,14353493,14352326,14318693,14318692,14318691,14318652,14318650,14317460,14317459,14300460,14300459,14300458,14300181,14299535,14280363,14280362) [ RunTime:0.017132s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14362472 LIMIT 4 [ RunTime:0.025019s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.017989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14362472 ORDER BY `minOrder` ASC [ RunTime:0.007766s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14362472 ORDER BY `unit` DESC [ RunTime:0.016946s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14362472 LIMIT 2 [ RunTime:0.035831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14362472 ORDER BY `minOrder` ASC [ RunTime:0.034835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354342 LIMIT 4 [ RunTime:0.013864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354342 ORDER BY `minOrder` ASC [ RunTime:0.036601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14354342 ORDER BY `unit` DESC [ RunTime:0.052411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14354342 LIMIT 2 [ RunTime:0.038224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354342 ORDER BY `minOrder` ASC [ RunTime:0.007976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354185 LIMIT 4 [ RunTime:0.031185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354185 ORDER BY `minOrder` ASC [ RunTime:0.030654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14354185 ORDER BY `unit` DESC [ RunTime:0.039465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14354185 LIMIT 2 [ RunTime:0.058897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354185 ORDER BY `minOrder` ASC [ RunTime:0.069035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14353582 LIMIT 4 [ RunTime:0.028517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14353582 ORDER BY `minOrder` ASC [ RunTime:0.015458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14353582 ORDER BY `unit` DESC [ RunTime:0.007102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14353582 LIMIT 2 [ RunTime:0.004895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14353582 ORDER BY `minOrder` ASC [ RunTime:0.013934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14353493 LIMIT 4 [ RunTime:0.008839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14353493 ORDER BY `minOrder` ASC [ RunTime:0.021370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14353493 ORDER BY `unit` DESC [ RunTime:0.021563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14353493 LIMIT 2 [ RunTime:0.010142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14353493 ORDER BY `minOrder` ASC [ RunTime:0.007416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352326 LIMIT 4 [ RunTime:0.018964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352326 ORDER BY `minOrder` ASC [ RunTime:0.015561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14352326 ORDER BY `unit` DESC [ RunTime:0.007021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14352326 LIMIT 2 [ RunTime:0.012375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352326 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14318693 LIMIT 4 [ RunTime:0.009689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318693 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14318693 ORDER BY `unit` DESC [ RunTime:0.006619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14318693 LIMIT 2 [ RunTime:0.005829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318693 ORDER BY `minOrder` ASC [ RunTime:0.002505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14318692 LIMIT 4 [ RunTime:0.006857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318692 ORDER BY `minOrder` ASC [ RunTime:0.006479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14318692 ORDER BY `unit` DESC [ RunTime:0.004352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14318692 LIMIT 2 [ RunTime:0.003186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318692 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14318691 LIMIT 4 [ RunTime:0.009696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318691 ORDER BY `minOrder` ASC [ RunTime:0.001687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14318691 ORDER BY `unit` DESC [ RunTime:0.007138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14318691 LIMIT 2 [ RunTime:0.002025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318691 ORDER BY `minOrder` ASC [ RunTime:0.004591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14318652 LIMIT 4 [ RunTime:0.005907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318652 ORDER BY `minOrder` ASC [ RunTime:0.003490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14318652 ORDER BY `unit` DESC [ RunTime:0.006645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14318652 LIMIT 2 [ RunTime:0.004413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318652 ORDER BY `minOrder` ASC [ RunTime:0.005288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14318650 LIMIT 4 [ RunTime:0.002280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318650 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14318650 ORDER BY `unit` DESC [ RunTime:0.000983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14318650 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14318650 ORDER BY `minOrder` ASC [ RunTime:0.044127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317460 LIMIT 4 [ RunTime:0.043623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317460 ORDER BY `minOrder` ASC [ RunTime:0.017053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317460 ORDER BY `unit` DESC [ RunTime:0.024447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317460 LIMIT 2 [ RunTime:0.054154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317460 ORDER BY `minOrder` ASC [ RunTime:0.054212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317459 LIMIT 4 [ RunTime:0.056190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317459 ORDER BY `minOrder` ASC [ RunTime:0.067206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317459 ORDER BY `unit` DESC [ RunTime:0.054755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317459 LIMIT 2 [ RunTime:0.038998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317459 ORDER BY `minOrder` ASC [ RunTime:0.063200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14300460 LIMIT 4 [ RunTime:0.013769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300460 ORDER BY `minOrder` ASC [ RunTime:0.010178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14300460 ORDER BY `unit` DESC [ RunTime:0.006269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14300460 LIMIT 2 [ RunTime:0.003243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300460 ORDER BY `minOrder` ASC [ RunTime:0.003637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14300459 LIMIT 4 [ RunTime:0.004773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300459 ORDER BY `minOrder` ASC [ RunTime:0.021078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14300459 ORDER BY `unit` DESC [ RunTime:0.003408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14300459 LIMIT 2 [ RunTime:0.003363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300459 ORDER BY `minOrder` ASC [ RunTime:0.003447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14300458 LIMIT 4 [ RunTime:0.002299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300458 ORDER BY `minOrder` ASC [ RunTime:0.006658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14300458 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14300458 LIMIT 2 [ RunTime:0.005700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300458 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14300181 LIMIT 4 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300181 ORDER BY `minOrder` ASC [ RunTime:0.003891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14300181 ORDER BY `unit` DESC [ RunTime:0.001247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14300181 LIMIT 2 [ RunTime:0.003202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14300181 ORDER BY `minOrder` ASC [ RunTime:0.004906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14299535 LIMIT 4 [ RunTime:0.008648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14299535 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14299535 ORDER BY `unit` DESC [ RunTime:0.002241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14299535 LIMIT 2 [ RunTime:0.003417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14299535 ORDER BY `minOrder` ASC [ RunTime:0.006987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280363 LIMIT 4 [ RunTime:0.008234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280363 ORDER BY `minOrder` ASC [ RunTime:0.005484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280363 ORDER BY `unit` DESC [ RunTime:0.006806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280363 LIMIT 2 [ RunTime:0.002761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280363 ORDER BY `minOrder` ASC [ RunTime:0.003725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280362 LIMIT 4 [ RunTime:0.002439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280362 ORDER BY `minOrder` ASC [ RunTime:0.004841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280362 ORDER BY `unit` DESC [ RunTime:0.013167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280362 LIMIT 2 [ RunTime:0.003966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280362 ORDER BY `minOrder` ASC [ RunTime:0.002438s ]
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.082685s ]