SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001617s ]
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.005424s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002510s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000718s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002130s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.005314s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003035s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008349s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002543s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004770s ]
UPDATE `stock_search` SET `count` = 2000 , `updatetime` = '2026-06-06 21:09:45' WHERE `partno` = '210' [ RunTime:0.000869s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012568s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003682s ]
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.006843s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001391s ]
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.002288s ]
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.052362s ]
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.012592s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188488 LIMIT 4 [ RunTime:0.009135s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188488 ORDER BY `minOrder` ASC [ RunTime:0.011921s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188488 ORDER BY `unit` DESC [ RunTime:0.004950s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188488 LIMIT 2 [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188488 ORDER BY `minOrder` ASC [ RunTime:0.003698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188356 LIMIT 4 [ RunTime:0.004791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188356 ORDER BY `minOrder` ASC [ RunTime:0.020540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188356 ORDER BY `unit` DESC [ RunTime:0.002086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188356 LIMIT 2 [ RunTime:0.008439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188356 ORDER BY `minOrder` ASC [ RunTime:0.013680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188080 LIMIT 4 [ RunTime:0.012180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188080 ORDER BY `minOrder` ASC [ RunTime:0.017347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188080 ORDER BY `unit` DESC [ RunTime:0.006851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188080 LIMIT 2 [ RunTime:0.020711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188080 ORDER BY `minOrder` ASC [ RunTime:0.021857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188075 LIMIT 4 [ RunTime:0.072505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188075 ORDER BY `minOrder` ASC [ RunTime:0.031754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188075 ORDER BY `unit` DESC [ RunTime:0.014143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188075 LIMIT 2 [ RunTime:0.004595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188075 ORDER BY `minOrder` ASC [ RunTime:0.026902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187869 LIMIT 4 [ RunTime:0.060251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187869 ORDER BY `minOrder` ASC [ RunTime:0.064281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187869 ORDER BY `unit` DESC [ RunTime:0.025852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187869 LIMIT 2 [ RunTime:0.070676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187869 ORDER BY `minOrder` ASC [ RunTime:0.019428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187850 LIMIT 4 [ RunTime:0.057303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187850 ORDER BY `minOrder` ASC [ RunTime:0.041347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187850 ORDER BY `unit` DESC [ RunTime:0.025215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187850 LIMIT 2 [ RunTime:0.028213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187850 ORDER BY `minOrder` ASC [ RunTime:0.013815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187825 LIMIT 4 [ RunTime:0.050012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187825 ORDER BY `minOrder` ASC [ RunTime:0.069659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187825 ORDER BY `unit` DESC [ RunTime:0.045030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187825 LIMIT 2 [ RunTime:0.126398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187825 ORDER BY `minOrder` ASC [ RunTime:0.021496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187824 LIMIT 4 [ RunTime:0.032816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187824 ORDER BY `minOrder` ASC [ RunTime:0.069536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187824 ORDER BY `unit` DESC [ RunTime:0.033950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187824 LIMIT 2 [ RunTime:0.042181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187824 ORDER BY `minOrder` ASC [ RunTime:0.018933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187799 LIMIT 4 [ RunTime:0.023313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187799 ORDER BY `minOrder` ASC [ RunTime:0.033724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187799 ORDER BY `unit` DESC [ RunTime:0.020758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187799 LIMIT 2 [ RunTime:0.038385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187799 ORDER BY `minOrder` ASC [ RunTime:0.028490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187746 LIMIT 4 [ RunTime:0.047074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187746 ORDER BY `minOrder` ASC [ RunTime:0.027516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187746 ORDER BY `unit` DESC [ RunTime:0.028204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187746 LIMIT 2 [ RunTime:0.029052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187746 ORDER BY `minOrder` ASC [ RunTime:0.032992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187685 LIMIT 4 [ RunTime:0.013373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187685 ORDER BY `minOrder` ASC [ RunTime:0.013169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187685 ORDER BY `unit` DESC [ RunTime:0.014137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187685 LIMIT 2 [ RunTime:0.017322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187685 ORDER BY `minOrder` ASC [ RunTime:0.015484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187528 LIMIT 4 [ RunTime:0.021508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187528 ORDER BY `minOrder` ASC [ RunTime:0.009236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187528 ORDER BY `unit` DESC [ RunTime:0.006815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187528 LIMIT 2 [ RunTime:0.009044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187528 ORDER BY `minOrder` ASC [ RunTime:0.004631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187527 LIMIT 4 [ RunTime:0.002907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187527 ORDER BY `minOrder` ASC [ RunTime:0.006695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187527 ORDER BY `unit` DESC [ RunTime:0.004574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187527 LIMIT 2 [ RunTime:0.010573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187527 ORDER BY `minOrder` ASC [ RunTime:0.001270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187513 LIMIT 4 [ RunTime:0.005689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187513 ORDER BY `minOrder` ASC [ RunTime:0.014021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187513 ORDER BY `unit` DESC [ RunTime:0.026881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187513 LIMIT 2 [ RunTime:0.015009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187513 ORDER BY `minOrder` ASC [ RunTime:0.010396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187442 LIMIT 4 [ RunTime:0.007966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187442 ORDER BY `minOrder` ASC [ RunTime:0.021244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187442 ORDER BY `unit` DESC [ RunTime:0.025289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187442 LIMIT 2 [ RunTime:0.020372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187442 ORDER BY `minOrder` ASC [ RunTime:0.012137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187438 LIMIT 4 [ RunTime:0.020732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187438 ORDER BY `minOrder` ASC [ RunTime:0.006334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187438 ORDER BY `unit` DESC [ RunTime:0.004853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187438 LIMIT 2 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187438 ORDER BY `minOrder` ASC [ RunTime:0.003775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187413 LIMIT 4 [ RunTime:0.002216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187413 ORDER BY `minOrder` ASC [ RunTime:0.019898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187413 ORDER BY `unit` DESC [ RunTime:0.018102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187413 LIMIT 2 [ RunTime:0.020145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187413 ORDER BY `minOrder` ASC [ RunTime:0.016000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187373 LIMIT 4 [ RunTime:0.032216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187373 ORDER BY `minOrder` ASC [ RunTime:0.025206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187373 ORDER BY `unit` DESC [ RunTime:0.029771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187373 LIMIT 2 [ RunTime:0.032062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187373 ORDER BY `minOrder` ASC [ RunTime:0.004341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187350 LIMIT 4 [ RunTime:0.017472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187350 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187350 ORDER BY `unit` DESC [ RunTime:0.016117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187350 LIMIT 2 [ RunTime:0.017037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187350 ORDER BY `minOrder` ASC [ RunTime:0.005088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175356 LIMIT 4 [ RunTime:0.005376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175356 ORDER BY `unit` DESC [ RunTime:0.003547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175356 LIMIT 2 [ RunTime:0.009229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.005325s ]
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.007871s ]