SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002078s ]
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.004660s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001467s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003109s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002442s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004846s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002862s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002268s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006585s ]
UPDATE `stock_search` SET `count` = 2947 , `updatetime` = '2026-06-08 10:34:34' WHERE `partno` = '210' [ RunTime:0.005954s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000327s ]
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.000383s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002242s ]
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.389701s ]
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.113899s ]
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 ('12980264','12980243','12979293','12979292','12979279','12979201','12979190','12979159','12978999','12978998','12978885','12978805','12978804','12978803','12978692','12978691','12978548','12978518','12978421','12978359') ORDER BY FIELD(s.id, 12980264,12980243,12979293,12979292,12979279,12979201,12979190,12979159,12978999,12978998,12978885,12978805,12978804,12978803,12978692,12978691,12978548,12978518,12978421,12978359) [ RunTime:0.017707s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12980264 LIMIT 4 [ RunTime:0.001454s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12980264 ORDER BY `minOrder` ASC [ RunTime:0.018749s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12980264 ORDER BY `unit` DESC [ RunTime:0.019834s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12980264 LIMIT 2 [ RunTime:0.008866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12980264 ORDER BY `minOrder` ASC [ RunTime:0.007691s ]
select * from pdf where partno='21038212830' and brandshort='HARTING' limit 1 [ RunTime:0.030170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12980243 LIMIT 4 [ RunTime:0.010075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12980243 ORDER BY `minOrder` ASC [ RunTime:0.012282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12980243 ORDER BY `unit` DESC [ RunTime:0.009682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12980243 LIMIT 2 [ RunTime:0.004776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12980243 ORDER BY `minOrder` ASC [ RunTime:0.001432s ]
select * from pdf where partno='21038812825' and brandshort='HARTING' limit 1 [ RunTime:0.008733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12979293 LIMIT 4 [ RunTime:0.022753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979293 ORDER BY `minOrder` ASC [ RunTime:0.013098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12979293 ORDER BY `unit` DESC [ RunTime:0.010667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12979293 LIMIT 2 [ RunTime:0.019952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979293 ORDER BY `minOrder` ASC [ RunTime:0.005541s ]
select * from pdf where partno='21038211512' and brandshort='HARTING' limit 1 [ RunTime:0.003735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12979292 LIMIT 4 [ RunTime:0.021876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979292 ORDER BY `minOrder` ASC [ RunTime:0.010948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12979292 ORDER BY `unit` DESC [ RunTime:0.019130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12979292 LIMIT 2 [ RunTime:0.006554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979292 ORDER BY `minOrder` ASC [ RunTime:0.005294s ]
select * from pdf where partno='21038811412' and brandshort='HARTING' limit 1 [ RunTime:0.010221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12979279 LIMIT 4 [ RunTime:0.013068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979279 ORDER BY `minOrder` ASC [ RunTime:0.026675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12979279 ORDER BY `unit` DESC [ RunTime:0.022522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12979279 LIMIT 2 [ RunTime:0.009351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979279 ORDER BY `minOrder` ASC [ RunTime:0.011417s ]
select * from pdf where partno='21038813833' and brandshort='HARTING' limit 1 [ RunTime:0.009400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12979201 LIMIT 4 [ RunTime:0.016256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979201 ORDER BY `minOrder` ASC [ RunTime:0.033410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12979201 ORDER BY `unit` DESC [ RunTime:0.002865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12979201 LIMIT 2 [ RunTime:0.006448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979201 ORDER BY `minOrder` ASC [ RunTime:0.008674s ]
select * from pdf where partno='21038812411' and brandshort='HARTING' limit 1 [ RunTime:0.003147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12979190 LIMIT 4 [ RunTime:0.016794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979190 ORDER BY `minOrder` ASC [ RunTime:0.008298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12979190 ORDER BY `unit` DESC [ RunTime:0.004971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12979190 LIMIT 2 [ RunTime:0.010852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979190 ORDER BY `minOrder` ASC [ RunTime:0.011334s ]
select * from pdf where partno='21038812821' and brandshort='HARTING' limit 1 [ RunTime:0.021105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12979159 LIMIT 4 [ RunTime:0.007491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979159 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12979159 ORDER BY `unit` DESC [ RunTime:0.013437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12979159 LIMIT 2 [ RunTime:0.019149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12979159 ORDER BY `minOrder` ASC [ RunTime:0.002401s ]
select * from pdf where partno='21038213530' and brandshort='HARTING' limit 1 [ RunTime:0.010592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978999 LIMIT 4 [ RunTime:0.013561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978999 ORDER BY `minOrder` ASC [ RunTime:0.009114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978999 ORDER BY `unit` DESC [ RunTime:0.014001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978999 LIMIT 2 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978999 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
select * from pdf where partno='21038962425' and brandshort='HARTING' limit 1 [ RunTime:0.014621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978998 LIMIT 4 [ RunTime:0.002271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978998 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978998 ORDER BY `unit` DESC [ RunTime:0.011049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978998 LIMIT 2 [ RunTime:0.027245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978998 ORDER BY `minOrder` ASC [ RunTime:0.003296s ]
select * from pdf where partno='21038962520' and brandshort='HARTING' limit 1 [ RunTime:0.010017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978885 LIMIT 4 [ RunTime:0.043110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978885 ORDER BY `minOrder` ASC [ RunTime:0.012817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978885 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978885 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978885 ORDER BY `minOrder` ASC [ RunTime:0.007935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978805 LIMIT 4 [ RunTime:0.005063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978805 ORDER BY `minOrder` ASC [ RunTime:0.015880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978805 ORDER BY `unit` DESC [ RunTime:0.010637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978805 LIMIT 2 [ RunTime:0.024541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978805 ORDER BY `minOrder` ASC [ RunTime:0.018674s ]
select * from pdf where partno='21038961520' and brandshort='HARTING' limit 1 [ RunTime:0.002858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978804 LIMIT 4 [ RunTime:0.027223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978804 ORDER BY `minOrder` ASC [ RunTime:0.007153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978804 ORDER BY `unit` DESC [ RunTime:0.006311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978804 LIMIT 2 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978804 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='21038961420' and brandshort='HARTING' limit 1 [ RunTime:0.008403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978803 LIMIT 4 [ RunTime:0.023729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978803 ORDER BY `minOrder` ASC [ RunTime:0.004179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978803 ORDER BY `unit` DESC [ RunTime:0.002981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978803 LIMIT 2 [ RunTime:0.002821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978803 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='21038961425' and brandshort='HARTING' limit 1 [ RunTime:0.007695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978692 LIMIT 4 [ RunTime:0.010541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978692 ORDER BY `minOrder` ASC [ RunTime:0.009544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978692 ORDER BY `unit` DESC [ RunTime:0.012684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978692 LIMIT 2 [ RunTime:0.010130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978692 ORDER BY `minOrder` ASC [ RunTime:0.003446s ]
select * from pdf where partno='21038814807' and brandshort='HARTING' limit 1 [ RunTime:0.008185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978691 LIMIT 4 [ RunTime:0.008270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978691 ORDER BY `minOrder` ASC [ RunTime:0.006537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978691 ORDER BY `unit` DESC [ RunTime:0.012699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978691 LIMIT 2 [ RunTime:0.004434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978691 ORDER BY `minOrder` ASC [ RunTime:0.009696s ]
select * from pdf where partno='21038813807' and brandshort='HARTING' limit 1 [ RunTime:0.066062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978548 LIMIT 4 [ RunTime:0.022736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978548 ORDER BY `minOrder` ASC [ RunTime:0.006054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978548 ORDER BY `unit` DESC [ RunTime:0.018126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978548 LIMIT 2 [ RunTime:0.047899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978548 ORDER BY `minOrder` ASC [ RunTime:0.006265s ]
select * from pdf where partno='21038821405' and brandshort='HARTING' limit 1 [ RunTime:0.040275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978518 LIMIT 4 [ RunTime:0.012443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978518 ORDER BY `minOrder` ASC [ RunTime:0.044942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978518 ORDER BY `unit` DESC [ RunTime:0.034955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978518 LIMIT 2 [ RunTime:0.014111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978518 ORDER BY `minOrder` ASC [ RunTime:0.005915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978421 LIMIT 4 [ RunTime:0.013112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978421 ORDER BY `minOrder` ASC [ RunTime:0.018365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978421 ORDER BY `unit` DESC [ RunTime:0.039329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978421 LIMIT 2 [ RunTime:0.036932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978421 ORDER BY `minOrder` ASC [ RunTime:0.014826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978359 LIMIT 4 [ RunTime:0.006578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978359 ORDER BY `minOrder` ASC [ RunTime:0.018169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978359 ORDER BY `unit` DESC [ RunTime:0.007170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978359 LIMIT 2 [ RunTime:0.005830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978359 ORDER BY `minOrder` ASC [ RunTime:0.002243s ]
select * from pdf where partno='21038211833' and brandshort='HARTING' limit 1 [ RunTime:0.016371s ]
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.150344s ]