SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002269s ]
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.011114s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001977s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.012611s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002114s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.001496s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001900s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001842s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000621s ]
UPDATE `stock_search` SET `count` = 1177 , `updatetime` = '2026-06-06 15:16:54' WHERE `partno` = '210' [ RunTime:0.008098s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001546s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003211s ]
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.005103s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002978s ]
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.005172s ]
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 3360,20 [ RunTime:0.052219s ]
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 ('18750925','18737992','18731984','18731983','18731972','18731969','18731350','18715104','18714951','18714888','18713036','18713035','18713006','18713005','18712220','18712108','18712107','18712076','18706207','18703147') ORDER BY FIELD(s.id, 18750925,18737992,18731984,18731983,18731972,18731969,18731350,18715104,18714951,18714888,18713036,18713035,18713006,18713005,18712220,18712108,18712107,18712076,18706207,18703147) [ RunTime:0.012666s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750925 LIMIT 4 [ RunTime:0.013137s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750925 ORDER BY `minOrder` ASC [ RunTime:0.009138s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.036430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750925 ORDER BY `unit` DESC [ RunTime:0.030866s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750925 LIMIT 2 [ RunTime:0.019024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750925 ORDER BY `minOrder` ASC [ RunTime:0.026724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18737992 LIMIT 4 [ RunTime:0.044418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18737992 ORDER BY `minOrder` ASC [ RunTime:0.023666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18737992 ORDER BY `unit` DESC [ RunTime:0.038322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18737992 LIMIT 2 [ RunTime:0.056128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18737992 ORDER BY `minOrder` ASC [ RunTime:0.042579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731984 LIMIT 4 [ RunTime:0.039674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731984 ORDER BY `minOrder` ASC [ RunTime:0.024692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731984 ORDER BY `unit` DESC [ RunTime:0.034944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731984 LIMIT 2 [ RunTime:0.096117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731984 ORDER BY `minOrder` ASC [ RunTime:0.026021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731983 LIMIT 4 [ RunTime:0.046220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731983 ORDER BY `minOrder` ASC [ RunTime:0.002984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731983 ORDER BY `unit` DESC [ RunTime:0.037747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731983 LIMIT 2 [ RunTime:0.197628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731983 ORDER BY `minOrder` ASC [ RunTime:0.096620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731972 LIMIT 4 [ RunTime:0.132271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731972 ORDER BY `minOrder` ASC [ RunTime:0.107532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731972 ORDER BY `unit` DESC [ RunTime:0.058975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731972 LIMIT 2 [ RunTime:0.046188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731972 ORDER BY `minOrder` ASC [ RunTime:0.089442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731969 LIMIT 4 [ RunTime:0.089850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731969 ORDER BY `minOrder` ASC [ RunTime:0.097374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731969 ORDER BY `unit` DESC [ RunTime:0.095085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731969 LIMIT 2 [ RunTime:0.070935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731969 ORDER BY `minOrder` ASC [ RunTime:0.034963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731350 LIMIT 4 [ RunTime:0.061670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731350 ORDER BY `minOrder` ASC [ RunTime:0.050090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731350 ORDER BY `unit` DESC [ RunTime:0.057050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731350 LIMIT 2 [ RunTime:0.108364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731350 ORDER BY `minOrder` ASC [ RunTime:0.065214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18715104 LIMIT 4 [ RunTime:0.079480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18715104 ORDER BY `minOrder` ASC [ RunTime:0.149976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18715104 ORDER BY `unit` DESC [ RunTime:0.059762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18715104 LIMIT 2 [ RunTime:0.096409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18715104 ORDER BY `minOrder` ASC [ RunTime:0.084703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18714951 LIMIT 4 [ RunTime:0.024852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714951 ORDER BY `minOrder` ASC [ RunTime:0.049943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18714951 ORDER BY `unit` DESC [ RunTime:0.038669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18714951 LIMIT 2 [ RunTime:0.162444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714951 ORDER BY `minOrder` ASC [ RunTime:0.093514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18714888 LIMIT 4 [ RunTime:0.042808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714888 ORDER BY `minOrder` ASC [ RunTime:0.170639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18714888 ORDER BY `unit` DESC [ RunTime:0.067938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18714888 LIMIT 2 [ RunTime:0.179521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714888 ORDER BY `minOrder` ASC [ RunTime:0.044534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18713036 LIMIT 4 [ RunTime:0.051449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713036 ORDER BY `minOrder` ASC [ RunTime:0.111430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18713036 ORDER BY `unit` DESC [ RunTime:0.102075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18713036 LIMIT 2 [ RunTime:0.074961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713036 ORDER BY `minOrder` ASC [ RunTime:0.045078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18713035 LIMIT 4 [ RunTime:0.025646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713035 ORDER BY `minOrder` ASC [ RunTime:0.047844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18713035 ORDER BY `unit` DESC [ RunTime:0.087055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18713035 LIMIT 2 [ RunTime:0.075213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713035 ORDER BY `minOrder` ASC [ RunTime:0.046783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18713006 LIMIT 4 [ RunTime:0.107703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713006 ORDER BY `minOrder` ASC [ RunTime:0.060162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18713006 ORDER BY `unit` DESC [ RunTime:0.117978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18713006 LIMIT 2 [ RunTime:0.092925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713006 ORDER BY `minOrder` ASC [ RunTime:0.103432s ]
select * from pdf where partno='21037' and brandshort='3M' limit 1 [ RunTime:0.080574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18713005 LIMIT 4 [ RunTime:0.049579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713005 ORDER BY `minOrder` ASC [ RunTime:0.142675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18713005 ORDER BY `unit` DESC [ RunTime:0.068097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18713005 LIMIT 2 [ RunTime:0.050682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713005 ORDER BY `minOrder` ASC [ RunTime:0.026954s ]
select * from pdf where partno='21040' and brandshort='3M' limit 1 [ RunTime:0.053268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712220 LIMIT 4 [ RunTime:0.120788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712220 ORDER BY `minOrder` ASC [ RunTime:0.079190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712220 ORDER BY `unit` DESC [ RunTime:0.137096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712220 LIMIT 2 [ RunTime:0.081896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712220 ORDER BY `minOrder` ASC [ RunTime:0.019905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712108 LIMIT 4 [ RunTime:0.040129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712108 ORDER BY `minOrder` ASC [ RunTime:0.059170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712108 ORDER BY `unit` DESC [ RunTime:0.044482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712108 LIMIT 2 [ RunTime:0.043489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712108 ORDER BY `minOrder` ASC [ RunTime:0.040628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712107 LIMIT 4 [ RunTime:0.025404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712107 ORDER BY `minOrder` ASC [ RunTime:0.035479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712107 ORDER BY `unit` DESC [ RunTime:0.092794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712107 LIMIT 2 [ RunTime:0.102719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712107 ORDER BY `minOrder` ASC [ RunTime:0.066709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712076 LIMIT 4 [ RunTime:0.031698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712076 ORDER BY `minOrder` ASC [ RunTime:0.065933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712076 ORDER BY `unit` DESC [ RunTime:0.045946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712076 LIMIT 2 [ RunTime:0.060620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712076 ORDER BY `minOrder` ASC [ RunTime:0.011459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18706207 LIMIT 4 [ RunTime:0.070368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706207 ORDER BY `minOrder` ASC [ RunTime:0.027950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18706207 ORDER BY `unit` DESC [ RunTime:0.060682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18706207 LIMIT 2 [ RunTime:0.068178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706207 ORDER BY `minOrder` ASC [ RunTime:0.025065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18703147 LIMIT 4 [ RunTime:0.048194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703147 ORDER BY `minOrder` ASC [ RunTime:0.078007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18703147 ORDER BY `unit` DESC [ RunTime:0.030958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18703147 LIMIT 2 [ RunTime:0.049573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703147 ORDER BY `minOrder` ASC [ RunTime:0.033475s ]
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.021044s ]