SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003383s ]
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.008050s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002211s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010469s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002321s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.024317s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002714s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012740s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002411s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.056960s ]
UPDATE `stock_search` SET `count` = 2783 , `updatetime` = '2026-06-08 08:13:58' WHERE `partno` = '210' [ RunTime:0.028093s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.017079s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.014631s ]
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.009261s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002874s ]
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.003165s ]
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 6660,20 [ RunTime:0.090047s ]
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 ('12975661','12972822','12972821','12972218','12967291','12966110','12966035','12966034','12966033','12966032','12966031','12965956','12965955','12965954','12958466','12920316','12894431','12894274','12894070','12893371') ORDER BY FIELD(s.id, 12975661,12972822,12972821,12972218,12967291,12966110,12966035,12966034,12966033,12966032,12966031,12965956,12965955,12965954,12958466,12920316,12894431,12894274,12894070,12893371) [ RunTime:0.046905s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12975661 LIMIT 4 [ RunTime:0.045718s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12975661 ORDER BY `minOrder` ASC [ RunTime:0.065805s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12975661 ORDER BY `unit` DESC [ RunTime:0.047403s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12975661 LIMIT 2 [ RunTime:0.041887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12975661 ORDER BY `minOrder` ASC [ RunTime:0.032641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12972822 LIMIT 4 [ RunTime:0.047570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12972822 ORDER BY `minOrder` ASC [ RunTime:0.013733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12972822 ORDER BY `unit` DESC [ RunTime:0.050853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12972822 LIMIT 2 [ RunTime:0.062162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12972822 ORDER BY `minOrder` ASC [ RunTime:0.035470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12972821 LIMIT 4 [ RunTime:0.050440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12972821 ORDER BY `minOrder` ASC [ RunTime:0.065086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12972821 ORDER BY `unit` DESC [ RunTime:0.028478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12972821 LIMIT 2 [ RunTime:0.025169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12972821 ORDER BY `minOrder` ASC [ RunTime:0.002820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12972218 LIMIT 4 [ RunTime:0.034488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12972218 ORDER BY `minOrder` ASC [ RunTime:0.081804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12972218 ORDER BY `unit` DESC [ RunTime:0.048829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12972218 LIMIT 2 [ RunTime:0.271953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12972218 ORDER BY `minOrder` ASC [ RunTime:0.101849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12967291 LIMIT 4 [ RunTime:0.050962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12967291 ORDER BY `minOrder` ASC [ RunTime:0.133161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12967291 ORDER BY `unit` DESC [ RunTime:0.161309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12967291 LIMIT 2 [ RunTime:0.111184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12967291 ORDER BY `minOrder` ASC [ RunTime:0.028072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12966110 LIMIT 4 [ RunTime:0.092006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966110 ORDER BY `minOrder` ASC [ RunTime:0.068693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12966110 ORDER BY `unit` DESC [ RunTime:0.037159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12966110 LIMIT 2 [ RunTime:0.075566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966110 ORDER BY `minOrder` ASC [ RunTime:0.046176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12966035 LIMIT 4 [ RunTime:0.070856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966035 ORDER BY `minOrder` ASC [ RunTime:0.041278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12966035 ORDER BY `unit` DESC [ RunTime:0.076250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12966035 LIMIT 2 [ RunTime:0.175620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966035 ORDER BY `minOrder` ASC [ RunTime:0.117696s ]
select * from pdf where partno='21038821425' and brandshort='HARTING' limit 1 [ RunTime:0.068834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12966034 LIMIT 4 [ RunTime:0.021116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966034 ORDER BY `minOrder` ASC [ RunTime:0.117840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12966034 ORDER BY `unit` DESC [ RunTime:0.081029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12966034 LIMIT 2 [ RunTime:0.125305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966034 ORDER BY `minOrder` ASC [ RunTime:0.049083s ]
select * from pdf where partno='21038222525' and brandshort='HARTING' limit 1 [ RunTime:0.100143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12966033 LIMIT 4 [ RunTime:0.071160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966033 ORDER BY `minOrder` ASC [ RunTime:0.097129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12966033 ORDER BY `unit` DESC [ RunTime:0.058154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12966033 LIMIT 2 [ RunTime:0.079167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966033 ORDER BY `minOrder` ASC [ RunTime:0.024764s ]
select * from pdf where partno='21038221425' and brandshort='HARTING' limit 1 [ RunTime:0.015116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12966032 LIMIT 4 [ RunTime:0.042293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966032 ORDER BY `minOrder` ASC [ RunTime:0.056341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12966032 ORDER BY `unit` DESC [ RunTime:0.117822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12966032 LIMIT 2 [ RunTime:0.050835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966032 ORDER BY `minOrder` ASC [ RunTime:0.047722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12966031 LIMIT 4 [ RunTime:0.052074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966031 ORDER BY `minOrder` ASC [ RunTime:0.055819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12966031 ORDER BY `unit` DESC [ RunTime:0.090671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12966031 LIMIT 2 [ RunTime:0.087694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12966031 ORDER BY `minOrder` ASC [ RunTime:0.032122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12965956 LIMIT 4 [ RunTime:0.051908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12965956 ORDER BY `minOrder` ASC [ RunTime:0.051433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12965956 ORDER BY `unit` DESC [ RunTime:0.051305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12965956 LIMIT 2 [ RunTime:0.051436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12965956 ORDER BY `minOrder` ASC [ RunTime:0.051284s ]
select * from pdf where partno='21038822425' and brandshort='HARTING' limit 1 [ RunTime:0.051431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12965955 LIMIT 4 [ RunTime:0.193976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12965955 ORDER BY `minOrder` ASC [ RunTime:0.030231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12965955 ORDER BY `unit` DESC [ RunTime:0.057379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12965955 LIMIT 2 [ RunTime:0.082622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12965955 ORDER BY `minOrder` ASC [ RunTime:0.054304s ]
select * from pdf where partno='21038822405' and brandshort='HARTING' limit 1 [ RunTime:0.093958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12965954 LIMIT 4 [ RunTime:0.066828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12965954 ORDER BY `minOrder` ASC [ RunTime:0.179319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12965954 ORDER BY `unit` DESC [ RunTime:0.038063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12965954 LIMIT 2 [ RunTime:0.108594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12965954 ORDER BY `minOrder` ASC [ RunTime:0.061394s ]
select * from pdf where partno='21038122505' and brandshort='HARTING' limit 1 [ RunTime:0.021375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12958466 LIMIT 4 [ RunTime:0.061973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12958466 ORDER BY `minOrder` ASC [ RunTime:0.020255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12958466 ORDER BY `unit` DESC [ RunTime:0.026353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12958466 LIMIT 2 [ RunTime:0.023289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12958466 ORDER BY `minOrder` ASC [ RunTime:0.030880s ]
select * from pdf where partno='21033012000' and brandshort='HARTING' limit 1 [ RunTime:0.014721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12920316 LIMIT 4 [ RunTime:0.018123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12920316 ORDER BY `minOrder` ASC [ RunTime:0.006616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12920316 ORDER BY `unit` DESC [ RunTime:0.023543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12920316 LIMIT 2 [ RunTime:0.013854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12920316 ORDER BY `minOrder` ASC [ RunTime:0.001444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12894431 LIMIT 4 [ RunTime:0.004470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12894431 ORDER BY `minOrder` ASC [ RunTime:0.006324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12894431 ORDER BY `unit` DESC [ RunTime:0.010032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12894431 LIMIT 2 [ RunTime:0.012340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12894431 ORDER BY `minOrder` ASC [ RunTime:0.009290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12894274 LIMIT 4 [ RunTime:0.013786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12894274 ORDER BY `minOrder` ASC [ RunTime:0.026382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12894274 ORDER BY `unit` DESC [ RunTime:0.050900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12894274 LIMIT 2 [ RunTime:0.068075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12894274 ORDER BY `minOrder` ASC [ RunTime:0.044964s ]
select * from pdf where partno='21033116801' and brandshort='HARTING' limit 1 [ RunTime:0.059818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12894070 LIMIT 4 [ RunTime:0.034449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12894070 ORDER BY `minOrder` ASC [ RunTime:0.017256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12894070 ORDER BY `unit` DESC [ RunTime:0.015007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12894070 LIMIT 2 [ RunTime:0.022619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12894070 ORDER BY `minOrder` ASC [ RunTime:0.012735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12893371 LIMIT 4 [ RunTime:0.001994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12893371 ORDER BY `minOrder` ASC [ RunTime:0.006929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12893371 ORDER BY `unit` DESC [ RunTime:0.012120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12893371 LIMIT 2 [ RunTime:0.016030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12893371 ORDER BY `minOrder` ASC [ RunTime:0.004464s ]
select * from pdf where partno='21010100018' and brandshort='HARTING' limit 1 [ RunTime:0.001655s ]
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.088227s ]