SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001331s ]
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.001663s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001384s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001562s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001659s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001342s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000512s ]
UPDATE `stock_search` SET `count` = 1860 , `updatetime` = '2026-06-06 20:02:47' WHERE `partno` = '210' [ RunTime:0.002856s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000276s ]
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.000352s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001919s ]
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.174595s ]
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 4660,20 [ RunTime:0.168280s ]
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 ('13188488','13188356','13188080','13188075','13187869','13187850','13187825','13187824','13187799','13187746','13187685','13187528','13187527','13187513','13187442','13187438','13187413','13187373','13187350','13175356') ORDER BY FIELD(s.id, 13188488,13188356,13188080,13188075,13187869,13187850,13187825,13187824,13187799,13187746,13187685,13187528,13187527,13187513,13187442,13187438,13187413,13187373,13187350,13175356) [ RunTime:0.013307s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.026295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188488 LIMIT 4 [ RunTime:0.025027s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188488 ORDER BY `minOrder` ASC [ RunTime:0.017181s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.024428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188488 ORDER BY `unit` DESC [ RunTime:0.024863s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188488 LIMIT 2 [ RunTime:0.014135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188488 ORDER BY `minOrder` ASC [ RunTime:0.005871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188356 LIMIT 4 [ RunTime:0.018957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188356 ORDER BY `minOrder` ASC [ RunTime:0.037246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188356 ORDER BY `unit` DESC [ RunTime:0.006585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188356 LIMIT 2 [ RunTime:0.070618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188356 ORDER BY `minOrder` ASC [ RunTime:0.015535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188080 LIMIT 4 [ RunTime:0.030007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188080 ORDER BY `minOrder` ASC [ RunTime:0.019212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188080 ORDER BY `unit` DESC [ RunTime:0.027571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188080 LIMIT 2 [ RunTime:0.018659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188080 ORDER BY `minOrder` ASC [ RunTime:0.029244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188075 LIMIT 4 [ RunTime:0.048440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188075 ORDER BY `minOrder` ASC [ RunTime:0.080379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188075 ORDER BY `unit` DESC [ RunTime:0.092636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188075 LIMIT 2 [ RunTime:0.042939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188075 ORDER BY `minOrder` ASC [ RunTime:0.020209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187869 LIMIT 4 [ RunTime:0.045793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187869 ORDER BY `minOrder` ASC [ RunTime:0.047577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187869 ORDER BY `unit` DESC [ RunTime:0.103123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187869 LIMIT 2 [ RunTime:0.027066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187869 ORDER BY `minOrder` ASC [ RunTime:0.043596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187850 LIMIT 4 [ RunTime:0.016322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187850 ORDER BY `minOrder` ASC [ RunTime:0.031642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187850 ORDER BY `unit` DESC [ RunTime:0.055249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187850 LIMIT 2 [ RunTime:0.005081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187850 ORDER BY `minOrder` ASC [ RunTime:0.035667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187825 LIMIT 4 [ RunTime:0.021918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187825 ORDER BY `minOrder` ASC [ RunTime:0.028383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187825 ORDER BY `unit` DESC [ RunTime:0.025621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187825 LIMIT 2 [ RunTime:0.013244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187825 ORDER BY `minOrder` ASC [ RunTime:0.004210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187824 LIMIT 4 [ RunTime:0.011387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187824 ORDER BY `minOrder` ASC [ RunTime:0.049808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187824 ORDER BY `unit` DESC [ RunTime:0.021583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187824 LIMIT 2 [ RunTime:0.044197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187824 ORDER BY `minOrder` ASC [ RunTime:0.051238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187799 LIMIT 4 [ RunTime:0.028623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187799 ORDER BY `minOrder` ASC [ RunTime:0.038969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187799 ORDER BY `unit` DESC [ RunTime:0.029424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187799 LIMIT 2 [ RunTime:0.007451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187799 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187746 LIMIT 4 [ RunTime:0.029934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187746 ORDER BY `minOrder` ASC [ RunTime:0.028464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187746 ORDER BY `unit` DESC [ RunTime:0.043391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187746 LIMIT 2 [ RunTime:0.053446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187746 ORDER BY `minOrder` ASC [ RunTime:0.009204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187685 LIMIT 4 [ RunTime:0.023763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187685 ORDER BY `minOrder` ASC [ RunTime:0.036942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187685 ORDER BY `unit` DESC [ RunTime:0.024466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187685 LIMIT 2 [ RunTime:0.017806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187685 ORDER BY `minOrder` ASC [ RunTime:0.030320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187528 LIMIT 4 [ RunTime:0.032914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187528 ORDER BY `minOrder` ASC [ RunTime:0.025125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187528 ORDER BY `unit` DESC [ RunTime:0.041278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187528 LIMIT 2 [ RunTime:0.076882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187528 ORDER BY `minOrder` ASC [ RunTime:0.008073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187527 LIMIT 4 [ RunTime:0.052397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187527 ORDER BY `minOrder` ASC [ RunTime:0.009320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187527 ORDER BY `unit` DESC [ RunTime:0.059387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187527 LIMIT 2 [ RunTime:0.019863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187527 ORDER BY `minOrder` ASC [ RunTime:0.005136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187513 LIMIT 4 [ RunTime:0.021293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187513 ORDER BY `minOrder` ASC [ RunTime:0.010660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187513 ORDER BY `unit` DESC [ RunTime:0.017794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187513 LIMIT 2 [ RunTime:0.023653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187513 ORDER BY `minOrder` ASC [ RunTime:0.033184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187442 LIMIT 4 [ RunTime:0.032167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187442 ORDER BY `minOrder` ASC [ RunTime:0.016385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187442 ORDER BY `unit` DESC [ RunTime:0.026286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187442 LIMIT 2 [ RunTime:0.012353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187442 ORDER BY `minOrder` ASC [ RunTime:0.007457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187438 LIMIT 4 [ RunTime:0.023197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187438 ORDER BY `minOrder` ASC [ RunTime:0.048343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187438 ORDER BY `unit` DESC [ RunTime:0.013212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187438 LIMIT 2 [ RunTime:0.005121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187438 ORDER BY `minOrder` ASC [ RunTime:0.004036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187413 LIMIT 4 [ RunTime:0.011285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187413 ORDER BY `minOrder` ASC [ RunTime:0.017122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187413 ORDER BY `unit` DESC [ RunTime:0.033519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187413 LIMIT 2 [ RunTime:0.007539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187413 ORDER BY `minOrder` ASC [ RunTime:0.005598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187373 LIMIT 4 [ RunTime:0.006196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187373 ORDER BY `minOrder` ASC [ RunTime:0.010478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187373 ORDER BY `unit` DESC [ RunTime:0.022438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187373 LIMIT 2 [ RunTime:0.013971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187373 ORDER BY `minOrder` ASC [ RunTime:0.009985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187350 LIMIT 4 [ RunTime:0.021421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187350 ORDER BY `minOrder` ASC [ RunTime:0.067500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187350 ORDER BY `unit` DESC [ RunTime:0.021350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187350 LIMIT 2 [ RunTime:0.024305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187350 ORDER BY `minOrder` ASC [ RunTime:0.021939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175356 LIMIT 4 [ RunTime:0.026529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.053521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175356 ORDER BY `unit` DESC [ RunTime:0.004474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175356 LIMIT 2 [ RunTime:0.018454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.019045s ]
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.005385s ]