SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002171s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.027184s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002508s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010454s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002626s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000793s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000980s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.026916s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001275s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.020406s ]
UPDATE `stock_search` SET `count` = 4127 , `updatetime` = '2026-06-08 16:47:37' WHERE `partno` = '210' [ RunTime:0.010494s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012133s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000405s ]
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.021853s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002735s ]
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.005832s ]
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 5700,20 [ RunTime:0.119525s ]
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 ('18753926','18753910','18753909','18753903','18753892','18753880','18753866','18753863','18753856','18753855','18753850','18753842','18750927','18750925','18737992','18731984','18731983','18731972','18731969','18731350') ORDER BY FIELD(s.id, 18753926,18753910,18753909,18753903,18753892,18753880,18753866,18753863,18753856,18753855,18753850,18753842,18750927,18750925,18737992,18731984,18731983,18731972,18731969,18731350) [ RunTime:0.077046s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.036368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753926 LIMIT 4 [ RunTime:0.033433s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753926 ORDER BY `minOrder` ASC [ RunTime:0.061539s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753926 ORDER BY `unit` DESC [ RunTime:0.010438s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753926 LIMIT 2 [ RunTime:0.006216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753926 ORDER BY `minOrder` ASC [ RunTime:0.031501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753910 LIMIT 4 [ RunTime:0.013758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753910 ORDER BY `minOrder` ASC [ RunTime:0.060748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753910 ORDER BY `unit` DESC [ RunTime:0.011644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753910 LIMIT 2 [ RunTime:0.005372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753910 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753909 LIMIT 4 [ RunTime:0.008668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753909 ORDER BY `minOrder` ASC [ RunTime:0.023360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753909 ORDER BY `unit` DESC [ RunTime:0.018020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753909 LIMIT 2 [ RunTime:0.001673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753909 ORDER BY `minOrder` ASC [ RunTime:0.003473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753903 LIMIT 4 [ RunTime:0.033989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753903 ORDER BY `minOrder` ASC [ RunTime:0.022038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753903 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753903 LIMIT 2 [ RunTime:0.005859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753903 ORDER BY `minOrder` ASC [ RunTime:0.013256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753892 LIMIT 4 [ RunTime:0.004635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753892 ORDER BY `minOrder` ASC [ RunTime:0.012246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753892 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753892 LIMIT 2 [ RunTime:0.009734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753892 ORDER BY `minOrder` ASC [ RunTime:0.023502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753880 LIMIT 4 [ RunTime:0.007672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753880 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753880 ORDER BY `unit` DESC [ RunTime:0.023933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753880 LIMIT 2 [ RunTime:0.014883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753880 ORDER BY `minOrder` ASC [ RunTime:0.001753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753866 LIMIT 4 [ RunTime:0.002062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753866 ORDER BY `minOrder` ASC [ RunTime:0.033201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753866 ORDER BY `unit` DESC [ RunTime:0.038297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753866 LIMIT 2 [ RunTime:0.019676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753866 ORDER BY `minOrder` ASC [ RunTime:0.010184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753863 LIMIT 4 [ RunTime:0.020858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753863 ORDER BY `minOrder` ASC [ RunTime:0.029781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753863 ORDER BY `unit` DESC [ RunTime:0.005522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753863 LIMIT 2 [ RunTime:0.002975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753863 ORDER BY `minOrder` ASC [ RunTime:0.003217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753856 LIMIT 4 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753856 ORDER BY `minOrder` ASC [ RunTime:0.019014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753856 ORDER BY `unit` DESC [ RunTime:0.008874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753856 LIMIT 2 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753856 ORDER BY `minOrder` ASC [ RunTime:0.026332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753855 LIMIT 4 [ RunTime:0.009653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753855 ORDER BY `minOrder` ASC [ RunTime:0.099439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753855 ORDER BY `unit` DESC [ RunTime:0.013544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753855 LIMIT 2 [ RunTime:0.006668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753855 ORDER BY `minOrder` ASC [ RunTime:0.044410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753850 LIMIT 4 [ RunTime:0.029941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753850 ORDER BY `minOrder` ASC [ RunTime:0.064822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753850 ORDER BY `unit` DESC [ RunTime:0.016095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753850 LIMIT 2 [ RunTime:0.012292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753850 ORDER BY `minOrder` ASC [ RunTime:0.018294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753842 LIMIT 4 [ RunTime:0.027272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753842 ORDER BY `minOrder` ASC [ RunTime:0.027895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753842 ORDER BY `unit` DESC [ RunTime:0.029567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753842 LIMIT 2 [ RunTime:0.024985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753842 ORDER BY `minOrder` ASC [ RunTime:0.053672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750927 LIMIT 4 [ RunTime:0.033717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750927 ORDER BY `minOrder` ASC [ RunTime:0.044990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750927 ORDER BY `unit` DESC [ RunTime:0.018567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750927 LIMIT 2 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750927 ORDER BY `minOrder` ASC [ RunTime:0.016037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750925 LIMIT 4 [ RunTime:0.008555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750925 ORDER BY `minOrder` ASC [ RunTime:0.072164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750925 ORDER BY `unit` DESC [ RunTime:0.026455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750925 LIMIT 2 [ RunTime:0.014030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750925 ORDER BY `minOrder` ASC [ RunTime:0.072749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18737992 LIMIT 4 [ RunTime:0.031455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18737992 ORDER BY `minOrder` ASC [ RunTime:0.112043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18737992 ORDER BY `unit` DESC [ RunTime:0.008769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18737992 LIMIT 2 [ RunTime:0.051017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18737992 ORDER BY `minOrder` ASC [ RunTime:0.029576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731984 LIMIT 4 [ RunTime:0.014876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731984 ORDER BY `minOrder` ASC [ RunTime:0.035836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731984 ORDER BY `unit` DESC [ RunTime:0.125373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731984 LIMIT 2 [ RunTime:0.053579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731984 ORDER BY `minOrder` ASC [ RunTime:0.022604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731983 LIMIT 4 [ RunTime:0.010702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731983 ORDER BY `minOrder` ASC [ RunTime:0.057425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731983 ORDER BY `unit` DESC [ RunTime:0.034491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731983 LIMIT 2 [ RunTime:0.022132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731983 ORDER BY `minOrder` ASC [ RunTime:0.050715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731972 LIMIT 4 [ RunTime:0.039470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731972 ORDER BY `minOrder` ASC [ RunTime:0.083679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731972 ORDER BY `unit` DESC [ RunTime:0.016618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731972 LIMIT 2 [ RunTime:0.048640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731972 ORDER BY `minOrder` ASC [ RunTime:0.032160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731969 LIMIT 4 [ RunTime:0.065420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731969 ORDER BY `minOrder` ASC [ RunTime:0.132006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731969 ORDER BY `unit` DESC [ RunTime:0.044030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731969 LIMIT 2 [ RunTime:0.023840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731969 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731350 LIMIT 4 [ RunTime:0.021973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731350 ORDER BY `minOrder` ASC [ RunTime:0.053739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731350 ORDER BY `unit` DESC [ RunTime:0.019100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731350 LIMIT 2 [ RunTime:0.072565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731350 ORDER BY `minOrder` ASC [ RunTime:0.035926s ]
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.031289s ]