SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002287s ]
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.002016s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001852s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002391s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002178s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002032s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003286s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002943s ]
UPDATE `stock_search` SET `count` = 1533 , `updatetime` = '2026-06-06 18:48:20' WHERE `partno` = '210' [ RunTime:0.005405s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000305s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000256s ]
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.000444s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002349s ]
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.315575s ]
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.050451s ]
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.005625s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188488 LIMIT 4 [ RunTime:0.006401s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188488 ORDER BY `minOrder` ASC [ RunTime:0.000931s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188488 ORDER BY `unit` DESC [ RunTime:0.002890s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188488 LIMIT 2 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188488 ORDER BY `minOrder` ASC [ RunTime:0.003192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188356 LIMIT 4 [ RunTime:0.001135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188356 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188356 ORDER BY `unit` DESC [ RunTime:0.003210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188356 LIMIT 2 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188356 ORDER BY `minOrder` ASC [ RunTime:0.005791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188080 LIMIT 4 [ RunTime:0.003709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188080 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188080 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188080 LIMIT 2 [ RunTime:0.004372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188080 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188075 LIMIT 4 [ RunTime:0.002682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188075 ORDER BY `minOrder` ASC [ RunTime:0.003946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188075 ORDER BY `unit` DESC [ RunTime:0.007639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188075 LIMIT 2 [ RunTime:0.004483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188075 ORDER BY `minOrder` ASC [ RunTime:0.001988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187869 LIMIT 4 [ RunTime:0.006455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187869 ORDER BY `minOrder` ASC [ RunTime:0.007449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187869 ORDER BY `unit` DESC [ RunTime:0.014888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187869 LIMIT 2 [ RunTime:0.013921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187869 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187850 LIMIT 4 [ RunTime:0.008097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187850 ORDER BY `minOrder` ASC [ RunTime:0.015080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187850 ORDER BY `unit` DESC [ RunTime:0.009593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187850 LIMIT 2 [ RunTime:0.002106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187850 ORDER BY `minOrder` ASC [ RunTime:0.002194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187825 LIMIT 4 [ RunTime:0.003919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187825 ORDER BY `minOrder` ASC [ RunTime:0.009482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187825 ORDER BY `unit` DESC [ RunTime:0.014822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187825 LIMIT 2 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187825 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187824 LIMIT 4 [ RunTime:0.004691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187824 ORDER BY `minOrder` ASC [ RunTime:0.006832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187824 ORDER BY `unit` DESC [ RunTime:0.006350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187824 LIMIT 2 [ RunTime:0.007909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187824 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187799 LIMIT 4 [ RunTime:0.006527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187799 ORDER BY `minOrder` ASC [ RunTime:0.004169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187799 ORDER BY `unit` DESC [ RunTime:0.003247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187799 LIMIT 2 [ RunTime:0.011320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187799 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187746 LIMIT 4 [ RunTime:0.009203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187746 ORDER BY `minOrder` ASC [ RunTime:0.025061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187746 ORDER BY `unit` DESC [ RunTime:0.014512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187746 LIMIT 2 [ RunTime:0.021379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187746 ORDER BY `minOrder` ASC [ RunTime:0.005750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187685 LIMIT 4 [ RunTime:0.004440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187685 ORDER BY `minOrder` ASC [ RunTime:0.004266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187685 ORDER BY `unit` DESC [ RunTime:0.001756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187685 LIMIT 2 [ RunTime:0.003201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187685 ORDER BY `minOrder` ASC [ RunTime:0.003900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187528 LIMIT 4 [ RunTime:0.013077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187528 ORDER BY `minOrder` ASC [ RunTime:0.002152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187528 ORDER BY `unit` DESC [ RunTime:0.007924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187528 LIMIT 2 [ RunTime:0.001394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187528 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187527 LIMIT 4 [ RunTime:0.003409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187527 ORDER BY `minOrder` ASC [ RunTime:0.001634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187527 ORDER BY `unit` DESC [ RunTime:0.001546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187527 LIMIT 2 [ RunTime:0.002383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187527 ORDER BY `minOrder` ASC [ RunTime:0.002518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187513 LIMIT 4 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187513 ORDER BY `minOrder` ASC [ RunTime:0.005762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187513 ORDER BY `unit` DESC [ RunTime:0.000878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187513 LIMIT 2 [ RunTime:0.003134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187513 ORDER BY `minOrder` ASC [ RunTime:0.002747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187442 LIMIT 4 [ RunTime:0.002391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187442 ORDER BY `minOrder` ASC [ RunTime:0.003737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187442 ORDER BY `unit` DESC [ RunTime:0.004189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187442 LIMIT 2 [ RunTime:0.002608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187442 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187438 LIMIT 4 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187438 ORDER BY `minOrder` ASC [ RunTime:0.012588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187438 ORDER BY `unit` DESC [ RunTime:0.010398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187438 LIMIT 2 [ RunTime:0.004949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187438 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187413 LIMIT 4 [ RunTime:0.008298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187413 ORDER BY `minOrder` ASC [ RunTime:0.003910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187413 ORDER BY `unit` DESC [ RunTime:0.022922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187413 LIMIT 2 [ RunTime:0.008729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187413 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187373 LIMIT 4 [ RunTime:0.005598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187373 ORDER BY `minOrder` ASC [ RunTime:0.018658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187373 ORDER BY `unit` DESC [ RunTime:0.007135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187373 LIMIT 2 [ RunTime:0.010325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187373 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187350 LIMIT 4 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187350 ORDER BY `minOrder` ASC [ RunTime:0.002903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187350 ORDER BY `unit` DESC [ RunTime:0.006608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187350 LIMIT 2 [ RunTime:0.004788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187350 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175356 LIMIT 4 [ RunTime:0.012644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.004104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175356 ORDER BY `unit` DESC [ RunTime:0.010473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175356 LIMIT 2 [ RunTime:0.003452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
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.000425s ]