SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001747s ]
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.005097s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001236s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001741s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001397s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002093s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001198s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005675s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001927s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.010637s ]
UPDATE `stock_search` SET `count` = 2137 , `updatetime` = '2026-06-07 00:03:09' WHERE `partno` = '210' [ RunTime:0.021209s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005747s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004560s ]
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.005717s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001552s ]
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.073921s ]
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 3820,20 [ RunTime:0.088538s ]
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 ('17295830','17295823','17295822','17295821','17295819','17295818','17295815','17295814','17295813','17295812','17295778','17295777','17295776','17295773','17295772','17295771','17295770','17295769','17295765','17295764') ORDER BY FIELD(s.id, 17295830,17295823,17295822,17295821,17295819,17295818,17295815,17295814,17295813,17295812,17295778,17295777,17295776,17295773,17295772,17295771,17295770,17295769,17295765,17295764) [ RunTime:0.022204s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295830 LIMIT 4 [ RunTime:0.030840s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295830 ORDER BY `minOrder` ASC [ RunTime:0.035982s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295830 ORDER BY `unit` DESC [ RunTime:0.011269s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295830 LIMIT 2 [ RunTime:0.041636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295830 ORDER BY `minOrder` ASC [ RunTime:0.003613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295823 LIMIT 4 [ RunTime:0.017998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295823 ORDER BY `minOrder` ASC [ RunTime:0.031590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295823 ORDER BY `unit` DESC [ RunTime:0.021826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295823 LIMIT 2 [ RunTime:0.027473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295823 ORDER BY `minOrder` ASC [ RunTime:0.019983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295822 LIMIT 4 [ RunTime:0.015196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295822 ORDER BY `minOrder` ASC [ RunTime:0.023439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295822 ORDER BY `unit` DESC [ RunTime:0.015894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295822 LIMIT 2 [ RunTime:0.022856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295822 ORDER BY `minOrder` ASC [ RunTime:0.015644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295821 LIMIT 4 [ RunTime:0.025783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295821 ORDER BY `minOrder` ASC [ RunTime:0.054413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295821 ORDER BY `unit` DESC [ RunTime:0.029640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295821 LIMIT 2 [ RunTime:0.052241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295821 ORDER BY `minOrder` ASC [ RunTime:0.021073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295819 LIMIT 4 [ RunTime:0.025986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295819 ORDER BY `minOrder` ASC [ RunTime:0.013795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295819 ORDER BY `unit` DESC [ RunTime:0.030740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295819 LIMIT 2 [ RunTime:0.025965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295819 ORDER BY `minOrder` ASC [ RunTime:0.011211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295818 LIMIT 4 [ RunTime:0.005499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295818 ORDER BY `minOrder` ASC [ RunTime:0.011340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295818 ORDER BY `unit` DESC [ RunTime:0.003148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295818 LIMIT 2 [ RunTime:0.015266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295818 ORDER BY `minOrder` ASC [ RunTime:0.015952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295815 LIMIT 4 [ RunTime:0.015403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295815 ORDER BY `minOrder` ASC [ RunTime:0.012313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295815 ORDER BY `unit` DESC [ RunTime:0.013907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295815 LIMIT 2 [ RunTime:0.009045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295815 ORDER BY `minOrder` ASC [ RunTime:0.004300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295814 LIMIT 4 [ RunTime:0.007320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295814 ORDER BY `minOrder` ASC [ RunTime:0.007969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295814 ORDER BY `unit` DESC [ RunTime:0.007150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295814 LIMIT 2 [ RunTime:0.005930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295814 ORDER BY `minOrder` ASC [ RunTime:0.004862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295813 LIMIT 4 [ RunTime:0.005738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295813 ORDER BY `minOrder` ASC [ RunTime:0.001558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295813 ORDER BY `unit` DESC [ RunTime:0.011774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295813 LIMIT 2 [ RunTime:0.006476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295813 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295812 LIMIT 4 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295812 ORDER BY `minOrder` ASC [ RunTime:0.003942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295812 ORDER BY `unit` DESC [ RunTime:0.005982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295812 LIMIT 2 [ RunTime:0.012865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295812 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295778 LIMIT 4 [ RunTime:0.006460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295778 ORDER BY `minOrder` ASC [ RunTime:0.001415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295778 ORDER BY `unit` DESC [ RunTime:0.000629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295778 LIMIT 2 [ RunTime:0.003963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295778 ORDER BY `minOrder` ASC [ RunTime:0.004016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295777 LIMIT 4 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295777 ORDER BY `minOrder` ASC [ RunTime:0.020710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295777 ORDER BY `unit` DESC [ RunTime:0.017506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295777 LIMIT 2 [ RunTime:0.020891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295777 ORDER BY `minOrder` ASC [ RunTime:0.043088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295776 LIMIT 4 [ RunTime:0.025126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295776 ORDER BY `minOrder` ASC [ RunTime:0.014570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295776 ORDER BY `unit` DESC [ RunTime:0.035900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295776 LIMIT 2 [ RunTime:0.068579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295776 ORDER BY `minOrder` ASC [ RunTime:0.020904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295773 LIMIT 4 [ RunTime:0.027241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295773 ORDER BY `minOrder` ASC [ RunTime:0.050579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295773 ORDER BY `unit` DESC [ RunTime:0.049737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295773 LIMIT 2 [ RunTime:0.078072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295773 ORDER BY `minOrder` ASC [ RunTime:0.031001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295772 LIMIT 4 [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295772 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295772 ORDER BY `unit` DESC [ RunTime:0.002275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295772 LIMIT 2 [ RunTime:0.004493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295772 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295771 LIMIT 4 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295771 ORDER BY `minOrder` ASC [ RunTime:0.002942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295771 ORDER BY `unit` DESC [ RunTime:0.011879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295771 LIMIT 2 [ RunTime:0.015584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295771 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295770 LIMIT 4 [ RunTime:0.001543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295770 ORDER BY `minOrder` ASC [ RunTime:0.005580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295770 ORDER BY `unit` DESC [ RunTime:0.004267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295770 LIMIT 2 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295770 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295769 LIMIT 4 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295769 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295769 ORDER BY `unit` DESC [ RunTime:0.002051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295769 LIMIT 2 [ RunTime:0.003661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295769 ORDER BY `minOrder` ASC [ RunTime:0.003218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295765 LIMIT 4 [ RunTime:0.009052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295765 ORDER BY `minOrder` ASC [ RunTime:0.001737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295765 ORDER BY `unit` DESC [ RunTime:0.002678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295765 LIMIT 2 [ RunTime:0.001821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295765 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295764 LIMIT 4 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295764 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295764 ORDER BY `unit` DESC [ RunTime:0.001987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295764 LIMIT 2 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295764 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
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.044539s ]