SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001312s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=228&page=475&srecordnum=10000' [ RunTime:0.001593s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000999s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001536s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001403s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.010191s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001896s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.003648s ]
UPDATE `stock_search` SET `count` = 1162 , `updatetime` = '2026-06-11 21:57:54' WHERE `partno` = '228' [ RunTime:0.001900s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000272s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000246s ]
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.000410s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002449s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.106121s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 9480,20 [ RunTime:0.144835s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('12451862','12451861','12451860','12451859','12451858','12451857','12451856','12451855','12451854','12451853','12451852','12451851','12451850','12451849','12451848','12451847','12451846','12451845','12451844','12451843') ORDER BY FIELD(s.id, 12451862,12451861,12451860,12451859,12451858,12451857,12451856,12451855,12451854,12451853,12451852,12451851,12451850,12451849,12451848,12451847,12451846,12451845,12451844,12451843) [ RunTime:0.055563s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451862 LIMIT 4 [ RunTime:0.035508s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451862 ORDER BY `minOrder` ASC [ RunTime:0.009119s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.023049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451862 ORDER BY `unit` DESC [ RunTime:0.005224s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451862 LIMIT 2 [ RunTime:0.019664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451862 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451861 LIMIT 4 [ RunTime:0.040097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451861 ORDER BY `minOrder` ASC [ RunTime:0.026934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451861 ORDER BY `unit` DESC [ RunTime:0.063950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451861 LIMIT 2 [ RunTime:0.008668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451861 ORDER BY `minOrder` ASC [ RunTime:0.021120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451860 LIMIT 4 [ RunTime:0.024627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451860 ORDER BY `minOrder` ASC [ RunTime:0.040369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451860 ORDER BY `unit` DESC [ RunTime:0.021811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451860 LIMIT 2 [ RunTime:0.016455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451860 ORDER BY `minOrder` ASC [ RunTime:0.003986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451859 LIMIT 4 [ RunTime:0.017962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451859 ORDER BY `minOrder` ASC [ RunTime:0.048462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451859 ORDER BY `unit` DESC [ RunTime:0.068071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451859 LIMIT 2 [ RunTime:0.037449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451859 ORDER BY `minOrder` ASC [ RunTime:0.044875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451858 LIMIT 4 [ RunTime:0.036051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451858 ORDER BY `minOrder` ASC [ RunTime:0.049019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451858 ORDER BY `unit` DESC [ RunTime:0.033563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451858 LIMIT 2 [ RunTime:0.039904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451858 ORDER BY `minOrder` ASC [ RunTime:0.032960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451857 LIMIT 4 [ RunTime:0.037954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451857 ORDER BY `minOrder` ASC [ RunTime:0.029011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451857 ORDER BY `unit` DESC [ RunTime:0.030756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451857 LIMIT 2 [ RunTime:0.050455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451857 ORDER BY `minOrder` ASC [ RunTime:0.065810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451856 LIMIT 4 [ RunTime:0.039054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451856 ORDER BY `minOrder` ASC [ RunTime:0.064583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451856 ORDER BY `unit` DESC [ RunTime:0.027239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451856 LIMIT 2 [ RunTime:0.012881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451856 ORDER BY `minOrder` ASC [ RunTime:0.025632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451855 LIMIT 4 [ RunTime:0.026100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451855 ORDER BY `minOrder` ASC [ RunTime:0.055737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451855 ORDER BY `unit` DESC [ RunTime:0.020732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451855 LIMIT 2 [ RunTime:0.024135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451855 ORDER BY `minOrder` ASC [ RunTime:0.008766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451854 LIMIT 4 [ RunTime:0.020375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451854 ORDER BY `minOrder` ASC [ RunTime:0.005138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451854 ORDER BY `unit` DESC [ RunTime:0.013025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451854 LIMIT 2 [ RunTime:0.037710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451854 ORDER BY `minOrder` ASC [ RunTime:0.042893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451853 LIMIT 4 [ RunTime:0.011206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451853 ORDER BY `minOrder` ASC [ RunTime:0.034957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451853 ORDER BY `unit` DESC [ RunTime:0.029270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451853 LIMIT 2 [ RunTime:0.028394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451853 ORDER BY `minOrder` ASC [ RunTime:0.023214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451852 LIMIT 4 [ RunTime:0.023307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451852 ORDER BY `minOrder` ASC [ RunTime:0.037588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451852 ORDER BY `unit` DESC [ RunTime:0.020333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451852 LIMIT 2 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451852 ORDER BY `minOrder` ASC [ RunTime:0.012974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451851 LIMIT 4 [ RunTime:0.022418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451851 ORDER BY `minOrder` ASC [ RunTime:0.025650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451851 ORDER BY `unit` DESC [ RunTime:0.025672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451851 LIMIT 2 [ RunTime:0.032429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451851 ORDER BY `minOrder` ASC [ RunTime:0.012358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451850 LIMIT 4 [ RunTime:0.039085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451850 ORDER BY `minOrder` ASC [ RunTime:0.031178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451850 ORDER BY `unit` DESC [ RunTime:0.061995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451850 LIMIT 2 [ RunTime:0.017397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451850 ORDER BY `minOrder` ASC [ RunTime:0.017046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451849 LIMIT 4 [ RunTime:0.027290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451849 ORDER BY `minOrder` ASC [ RunTime:0.039619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451849 ORDER BY `unit` DESC [ RunTime:0.075055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451849 LIMIT 2 [ RunTime:0.026630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451849 ORDER BY `minOrder` ASC [ RunTime:0.008262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451848 LIMIT 4 [ RunTime:0.010783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451848 ORDER BY `minOrder` ASC [ RunTime:0.030469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451848 ORDER BY `unit` DESC [ RunTime:0.019838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451848 LIMIT 2 [ RunTime:0.010689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451848 ORDER BY `minOrder` ASC [ RunTime:0.045013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451847 LIMIT 4 [ RunTime:0.048801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451847 ORDER BY `minOrder` ASC [ RunTime:0.020293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451847 ORDER BY `unit` DESC [ RunTime:0.076919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451847 LIMIT 2 [ RunTime:0.037378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451847 ORDER BY `minOrder` ASC [ RunTime:0.025502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451846 LIMIT 4 [ RunTime:0.014333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451846 ORDER BY `minOrder` ASC [ RunTime:0.038253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451846 ORDER BY `unit` DESC [ RunTime:0.017782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451846 LIMIT 2 [ RunTime:0.023045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451846 ORDER BY `minOrder` ASC [ RunTime:0.007056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451845 LIMIT 4 [ RunTime:0.023037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451845 ORDER BY `minOrder` ASC [ RunTime:0.023771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451845 ORDER BY `unit` DESC [ RunTime:0.031222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451845 LIMIT 2 [ RunTime:0.081523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451845 ORDER BY `minOrder` ASC [ RunTime:0.027567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451844 LIMIT 4 [ RunTime:0.035022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451844 ORDER BY `minOrder` ASC [ RunTime:0.041741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451844 ORDER BY `unit` DESC [ RunTime:0.029529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451844 LIMIT 2 [ RunTime:0.011789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451844 ORDER BY `minOrder` ASC [ RunTime:0.069794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451843 LIMIT 4 [ RunTime:0.045722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451843 ORDER BY `minOrder` ASC [ RunTime:0.021735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451843 ORDER BY `unit` DESC [ RunTime:0.013174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451843 LIMIT 2 [ RunTime:0.033736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451843 ORDER BY `minOrder` ASC [ RunTime:0.071401s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.017524s ]