SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002044s ]
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=487&srecordnum=10000' [ RunTime:0.001963s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001967s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002611s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003043s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002229s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.007965s ]
UPDATE `stock_search` SET `count` = 1139 , `updatetime` = '2026-06-11 19:30:53' WHERE `partno` = '228' [ RunTime:0.003402s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000265s ]
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.000543s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001545s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.247590s ]
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 9720,20 [ RunTime:0.217780s ]
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 ('12451591','12451590','12451589','12451588','12451587','12451586','12451585','12451584','12451583','12451582','12451581','12451580','12451579','12451578','12451577','12451576','12451575','12451574','12451573','12451572') ORDER BY FIELD(s.id, 12451591,12451590,12451589,12451588,12451587,12451586,12451585,12451584,12451583,12451582,12451581,12451580,12451579,12451578,12451577,12451576,12451575,12451574,12451573,12451572) [ RunTime:0.067555s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451591 LIMIT 4 [ RunTime:0.016652s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451591 ORDER BY `minOrder` ASC [ RunTime:0.041139s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451591 ORDER BY `unit` DESC [ RunTime:0.006526s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451591 LIMIT 2 [ RunTime:0.023178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451591 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451590 LIMIT 4 [ RunTime:0.026649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451590 ORDER BY `minOrder` ASC [ RunTime:0.046634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451590 ORDER BY `unit` DESC [ RunTime:0.046519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451590 LIMIT 2 [ RunTime:0.013739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451590 ORDER BY `minOrder` ASC [ RunTime:0.008968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451589 LIMIT 4 [ RunTime:0.046023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451589 ORDER BY `minOrder` ASC [ RunTime:0.029426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451589 ORDER BY `unit` DESC [ RunTime:0.055669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451589 LIMIT 2 [ RunTime:0.073998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451589 ORDER BY `minOrder` ASC [ RunTime:0.034492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451588 LIMIT 4 [ RunTime:0.032778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451588 ORDER BY `minOrder` ASC [ RunTime:0.018392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451588 ORDER BY `unit` DESC [ RunTime:0.027357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451588 LIMIT 2 [ RunTime:0.026194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451588 ORDER BY `minOrder` ASC [ RunTime:0.009237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451587 LIMIT 4 [ RunTime:0.007973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451587 ORDER BY `minOrder` ASC [ RunTime:0.030169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451587 ORDER BY `unit` DESC [ RunTime:0.018530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451587 LIMIT 2 [ RunTime:0.041537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451587 ORDER BY `minOrder` ASC [ RunTime:0.006162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451586 LIMIT 4 [ RunTime:0.027465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451586 ORDER BY `minOrder` ASC [ RunTime:0.045251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451586 ORDER BY `unit` DESC [ RunTime:0.040074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451586 LIMIT 2 [ RunTime:0.031222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451586 ORDER BY `minOrder` ASC [ RunTime:0.001826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451585 LIMIT 4 [ RunTime:0.020241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451585 ORDER BY `minOrder` ASC [ RunTime:0.026644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451585 ORDER BY `unit` DESC [ RunTime:0.024687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451585 LIMIT 2 [ RunTime:0.018778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451585 ORDER BY `minOrder` ASC [ RunTime:0.030693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451584 LIMIT 4 [ RunTime:0.028548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451584 ORDER BY `minOrder` ASC [ RunTime:0.022223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451584 ORDER BY `unit` DESC [ RunTime:0.022825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451584 LIMIT 2 [ RunTime:0.006788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451584 ORDER BY `minOrder` ASC [ RunTime:0.009971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451583 LIMIT 4 [ RunTime:0.018555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451583 ORDER BY `minOrder` ASC [ RunTime:0.016754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451583 ORDER BY `unit` DESC [ RunTime:0.043793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451583 LIMIT 2 [ RunTime:0.048541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451583 ORDER BY `minOrder` ASC [ RunTime:0.020711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451582 LIMIT 4 [ RunTime:0.026487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451582 ORDER BY `minOrder` ASC [ RunTime:0.034192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451582 ORDER BY `unit` DESC [ RunTime:0.021595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451582 LIMIT 2 [ RunTime:0.015334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451582 ORDER BY `minOrder` ASC [ RunTime:0.023845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451581 LIMIT 4 [ RunTime:0.044146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451581 ORDER BY `minOrder` ASC [ RunTime:0.038502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451581 ORDER BY `unit` DESC [ RunTime:0.016839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451581 LIMIT 2 [ RunTime:0.027210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451581 ORDER BY `minOrder` ASC [ RunTime:0.022297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451580 LIMIT 4 [ RunTime:0.024107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451580 ORDER BY `minOrder` ASC [ RunTime:0.026566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451580 ORDER BY `unit` DESC [ RunTime:0.035501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451580 LIMIT 2 [ RunTime:0.027029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451580 ORDER BY `minOrder` ASC [ RunTime:0.008694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451579 LIMIT 4 [ RunTime:0.023443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451579 ORDER BY `minOrder` ASC [ RunTime:0.019900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451579 ORDER BY `unit` DESC [ RunTime:0.051614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451579 LIMIT 2 [ RunTime:0.039355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451579 ORDER BY `minOrder` ASC [ RunTime:0.021960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451578 LIMIT 4 [ RunTime:0.046062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451578 ORDER BY `minOrder` ASC [ RunTime:0.027234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451578 ORDER BY `unit` DESC [ RunTime:0.029467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451578 LIMIT 2 [ RunTime:0.064054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451578 ORDER BY `minOrder` ASC [ RunTime:0.027006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451577 LIMIT 4 [ RunTime:0.057195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451577 ORDER BY `minOrder` ASC [ RunTime:0.014271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451577 ORDER BY `unit` DESC [ RunTime:0.054652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451577 LIMIT 2 [ RunTime:0.046643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451577 ORDER BY `minOrder` ASC [ RunTime:0.029173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451576 LIMIT 4 [ RunTime:0.028041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451576 ORDER BY `minOrder` ASC [ RunTime:0.025736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451576 ORDER BY `unit` DESC [ RunTime:0.031738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451576 LIMIT 2 [ RunTime:0.040274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451576 ORDER BY `minOrder` ASC [ RunTime:0.019453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451575 LIMIT 4 [ RunTime:0.033725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451575 ORDER BY `minOrder` ASC [ RunTime:0.044024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451575 ORDER BY `unit` DESC [ RunTime:0.006441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451575 LIMIT 2 [ RunTime:0.014132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451575 ORDER BY `minOrder` ASC [ RunTime:0.021799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451574 LIMIT 4 [ RunTime:0.022864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451574 ORDER BY `minOrder` ASC [ RunTime:0.049918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451574 ORDER BY `unit` DESC [ RunTime:0.047792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451574 LIMIT 2 [ RunTime:0.042883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451574 ORDER BY `minOrder` ASC [ RunTime:0.045583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451573 LIMIT 4 [ RunTime:0.049649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451573 ORDER BY `minOrder` ASC [ RunTime:0.082791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451573 ORDER BY `unit` DESC [ RunTime:0.030558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451573 LIMIT 2 [ RunTime:0.027305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451573 ORDER BY `minOrder` ASC [ RunTime:0.011187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451572 LIMIT 4 [ RunTime:0.072432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451572 ORDER BY `minOrder` ASC [ RunTime:0.022282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451572 ORDER BY `unit` DESC [ RunTime:0.008999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451572 LIMIT 2 [ RunTime:0.020821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451572 ORDER BY `minOrder` ASC [ RunTime:0.012923s ]
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.160347s ]