SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002010s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.006360s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001881s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000681s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002025s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.000931s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001928s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000561s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001767s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000786s ]
UPDATE `stock_search` SET `count` = 2343 , `updatetime` = '2026-06-07 01:08:19' WHERE `partno` = '210' [ RunTime:0.004559s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000276s ]
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.000595s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002248s ]
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.003518s ]
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 3920,20 [ RunTime:0.061951s ]
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 ('16614871','16614344','16614019','16613754','16613752','16613751','16500547','16500468','16499220','16440495','16440418','16440402','16440401','16440400','16433879','16433733','16433628','16410911','16410910','16238887') ORDER BY FIELD(s.id, 16614871,16614344,16614019,16613754,16613752,16613751,16500547,16500468,16499220,16440495,16440418,16440402,16440401,16440400,16433879,16433733,16433628,16410911,16410910,16238887) [ RunTime:0.026743s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16614871 LIMIT 4 [ RunTime:0.011080s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614871 ORDER BY `minOrder` ASC [ RunTime:0.005259s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16614871 ORDER BY `unit` DESC [ RunTime:0.014213s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16614871 LIMIT 2 [ RunTime:0.008529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614871 ORDER BY `minOrder` ASC [ RunTime:0.001695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16614344 LIMIT 4 [ RunTime:0.009240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614344 ORDER BY `minOrder` ASC [ RunTime:0.011567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16614344 ORDER BY `unit` DESC [ RunTime:0.005320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16614344 LIMIT 2 [ RunTime:0.032762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614344 ORDER BY `minOrder` ASC [ RunTime:0.013549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16614019 LIMIT 4 [ RunTime:0.023778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614019 ORDER BY `minOrder` ASC [ RunTime:0.021336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16614019 ORDER BY `unit` DESC [ RunTime:0.032112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16614019 LIMIT 2 [ RunTime:0.017102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614019 ORDER BY `minOrder` ASC [ RunTime:0.036744s ]
select * from pdf where partno='21033176410' and brandshort='HARTING' limit 1 [ RunTime:0.047392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16613754 LIMIT 4 [ RunTime:0.047679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16613754 ORDER BY `minOrder` ASC [ RunTime:0.021785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16613754 ORDER BY `unit` DESC [ RunTime:0.005912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16613754 LIMIT 2 [ RunTime:0.014497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16613754 ORDER BY `minOrder` ASC [ RunTime:0.003657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16613752 LIMIT 4 [ RunTime:0.029369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16613752 ORDER BY `minOrder` ASC [ RunTime:0.013404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16613752 ORDER BY `unit` DESC [ RunTime:0.027312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16613752 LIMIT 2 [ RunTime:0.018585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16613752 ORDER BY `minOrder` ASC [ RunTime:0.012123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16613751 LIMIT 4 [ RunTime:0.015676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16613751 ORDER BY `minOrder` ASC [ RunTime:0.013291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16613751 ORDER BY `unit` DESC [ RunTime:0.009166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16613751 LIMIT 2 [ RunTime:0.026274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16613751 ORDER BY `minOrder` ASC [ RunTime:0.011881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16500547 LIMIT 4 [ RunTime:0.014645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16500547 ORDER BY `minOrder` ASC [ RunTime:0.004812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16500547 ORDER BY `unit` DESC [ RunTime:0.016005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16500547 LIMIT 2 [ RunTime:0.016869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16500547 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
select * from pdf where partno='21046' and brandshort='Belden Inc.' limit 1 [ RunTime:0.020824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16500468 LIMIT 4 [ RunTime:0.010246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16500468 ORDER BY `minOrder` ASC [ RunTime:0.011190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16500468 ORDER BY `unit` DESC [ RunTime:0.021290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16500468 LIMIT 2 [ RunTime:0.006189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16500468 ORDER BY `minOrder` ASC [ RunTime:0.007627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16499220 LIMIT 4 [ RunTime:0.017013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16499220 ORDER BY `minOrder` ASC [ RunTime:0.024088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16499220 ORDER BY `unit` DESC [ RunTime:0.005802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16499220 LIMIT 2 [ RunTime:0.020066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16499220 ORDER BY `minOrder` ASC [ RunTime:0.015627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16440495 LIMIT 4 [ RunTime:0.038997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440495 ORDER BY `minOrder` ASC [ RunTime:0.037403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16440495 ORDER BY `unit` DESC [ RunTime:0.028048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16440495 LIMIT 2 [ RunTime:0.012226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440495 ORDER BY `minOrder` ASC [ RunTime:0.006791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16440418 LIMIT 4 [ RunTime:0.019555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440418 ORDER BY `minOrder` ASC [ RunTime:0.027183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16440418 ORDER BY `unit` DESC [ RunTime:0.008248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16440418 LIMIT 2 [ RunTime:0.005742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440418 ORDER BY `minOrder` ASC [ RunTime:0.007671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16440402 LIMIT 4 [ RunTime:0.016337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440402 ORDER BY `minOrder` ASC [ RunTime:0.030275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16440402 ORDER BY `unit` DESC [ RunTime:0.006704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16440402 LIMIT 2 [ RunTime:0.009092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440402 ORDER BY `minOrder` ASC [ RunTime:0.023875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16440401 LIMIT 4 [ RunTime:0.009807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440401 ORDER BY `minOrder` ASC [ RunTime:0.022901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16440401 ORDER BY `unit` DESC [ RunTime:0.028260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16440401 LIMIT 2 [ RunTime:0.024948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440401 ORDER BY `minOrder` ASC [ RunTime:0.013791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16440400 LIMIT 4 [ RunTime:0.017586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440400 ORDER BY `minOrder` ASC [ RunTime:0.026843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16440400 ORDER BY `unit` DESC [ RunTime:0.012498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16440400 LIMIT 2 [ RunTime:0.016439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440400 ORDER BY `minOrder` ASC [ RunTime:0.028834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433879 LIMIT 4 [ RunTime:0.009568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433879 ORDER BY `minOrder` ASC [ RunTime:0.022140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433879 ORDER BY `unit` DESC [ RunTime:0.019151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433879 LIMIT 2 [ RunTime:0.034871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433879 ORDER BY `minOrder` ASC [ RunTime:0.028242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433733 LIMIT 4 [ RunTime:0.047066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433733 ORDER BY `minOrder` ASC [ RunTime:0.073371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433733 ORDER BY `unit` DESC [ RunTime:0.049819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433733 LIMIT 2 [ RunTime:0.017354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433733 ORDER BY `minOrder` ASC [ RunTime:0.022798s ]
select * from pdf where partno='2104D' and brandshort='3M' limit 1 [ RunTime:0.040908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433628 LIMIT 4 [ RunTime:0.006529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433628 ORDER BY `minOrder` ASC [ RunTime:0.020970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433628 ORDER BY `unit` DESC [ RunTime:0.029314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433628 LIMIT 2 [ RunTime:0.013705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433628 ORDER BY `minOrder` ASC [ RunTime:0.008037s ]
select * from pdf where partno='2104E' and brandshort='3M' limit 1 [ RunTime:0.015289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410911 LIMIT 4 [ RunTime:0.023968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410911 ORDER BY `minOrder` ASC [ RunTime:0.007367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16410911 ORDER BY `unit` DESC [ RunTime:0.011578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16410911 LIMIT 2 [ RunTime:0.029906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410911 ORDER BY `minOrder` ASC [ RunTime:0.010020s ]
select * from pdf where partno='2101A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.032514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410910 LIMIT 4 [ RunTime:0.035662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410910 ORDER BY `minOrder` ASC [ RunTime:0.010978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16410910 ORDER BY `unit` DESC [ RunTime:0.068878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16410910 LIMIT 2 [ RunTime:0.005098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410910 ORDER BY `minOrder` ASC [ RunTime:0.012363s ]
select * from pdf where partno='2101A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.010949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16238887 LIMIT 4 [ RunTime:0.045014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16238887 ORDER BY `minOrder` ASC [ RunTime:0.032759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16238887 ORDER BY `unit` DESC [ RunTime:0.011420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16238887 LIMIT 2 [ RunTime:0.037328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16238887 ORDER BY `minOrder` ASC [ RunTime:0.002112s ]
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.017810s ]