SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002561s ]
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.073111s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001901s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.032759s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001420s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.051213s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001400s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014376s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003446s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.022221s ]
UPDATE `stock_search` SET `count` = 2347 , `updatetime` = '2026-06-07 01:09:56' WHERE `partno` = '210' [ RunTime:0.089842s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.065277s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000494s ]
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.028035s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002929s ]
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.132682s ]
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 3760,20 [ RunTime:0.101600s ]
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 ('17491347','17491009','17490919','17490505','17490227','17490226','17490145','17490144','17490009','17489668','17489666','17489339','17489335','17488927','17488889','17488086','17487553','17487170','17487103','17486550') ORDER BY FIELD(s.id, 17491347,17491009,17490919,17490505,17490227,17490226,17490145,17490144,17490009,17489668,17489666,17489339,17489335,17488927,17488889,17488086,17487553,17487170,17487103,17486550) [ RunTime:0.052946s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491347 LIMIT 4 [ RunTime:0.096423s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491347 ORDER BY `minOrder` ASC [ RunTime:0.051466s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17491347 ORDER BY `unit` DESC [ RunTime:0.051055s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17491347 LIMIT 2 [ RunTime:0.050946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491347 ORDER BY `minOrder` ASC [ RunTime:0.025268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491009 LIMIT 4 [ RunTime:0.024376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491009 ORDER BY `minOrder` ASC [ RunTime:0.086260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17491009 ORDER BY `unit` DESC [ RunTime:0.051130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17491009 LIMIT 2 [ RunTime:0.142471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491009 ORDER BY `minOrder` ASC [ RunTime:0.102970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490919 LIMIT 4 [ RunTime:0.052142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490919 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490919 ORDER BY `unit` DESC [ RunTime:0.096421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490919 LIMIT 2 [ RunTime:0.027638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490919 ORDER BY `minOrder` ASC [ RunTime:0.008128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490505 LIMIT 4 [ RunTime:0.011214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490505 ORDER BY `minOrder` ASC [ RunTime:0.020971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490505 ORDER BY `unit` DESC [ RunTime:0.050978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490505 LIMIT 2 [ RunTime:0.050816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490505 ORDER BY `minOrder` ASC [ RunTime:0.035857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490227 LIMIT 4 [ RunTime:0.102905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490227 ORDER BY `minOrder` ASC [ RunTime:0.069161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490227 ORDER BY `unit` DESC [ RunTime:0.045143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490227 LIMIT 2 [ RunTime:0.051363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490227 ORDER BY `minOrder` ASC [ RunTime:0.017218s ]
select * from pdf where partno='21023531800' and brandshort='HARTING' limit 1 [ RunTime:0.051149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490226 LIMIT 4 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490226 ORDER BY `minOrder` ASC [ RunTime:0.050925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490226 ORDER BY `unit` DESC [ RunTime:0.038381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490226 LIMIT 2 [ RunTime:0.060085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490226 ORDER BY `minOrder` ASC [ RunTime:0.066071s ]
select * from pdf where partno='21023532800' and brandshort='HARTING' limit 1 [ RunTime:0.051076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490145 LIMIT 4 [ RunTime:0.031473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490145 ORDER BY `minOrder` ASC [ RunTime:0.050873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490145 ORDER BY `unit` DESC [ RunTime:0.119354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490145 LIMIT 2 [ RunTime:0.054306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490145 ORDER BY `minOrder` ASC [ RunTime:0.051108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490144 LIMIT 4 [ RunTime:0.051059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490144 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490144 ORDER BY `unit` DESC [ RunTime:0.085665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490144 LIMIT 2 [ RunTime:0.155684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490144 ORDER BY `minOrder` ASC [ RunTime:0.100202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490009 LIMIT 4 [ RunTime:0.050898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490009 ORDER BY `minOrder` ASC [ RunTime:0.074061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490009 ORDER BY `unit` DESC [ RunTime:0.051006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490009 LIMIT 2 [ RunTime:0.044851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490009 ORDER BY `minOrder` ASC [ RunTime:0.014251s ]
select * from pdf where partno='21033176810' and brandshort='HARTING' limit 1 [ RunTime:0.051280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17489668 LIMIT 4 [ RunTime:0.051295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489668 ORDER BY `minOrder` ASC [ RunTime:0.073514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17489668 ORDER BY `unit` DESC [ RunTime:0.053149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17489668 LIMIT 2 [ RunTime:0.050899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489668 ORDER BY `minOrder` ASC [ RunTime:0.050842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17489666 LIMIT 4 [ RunTime:0.123232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489666 ORDER BY `minOrder` ASC [ RunTime:0.050870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17489666 ORDER BY `unit` DESC [ RunTime:0.038106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17489666 LIMIT 2 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489666 ORDER BY `minOrder` ASC [ RunTime:0.024699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17489339 LIMIT 4 [ RunTime:0.050596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489339 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17489339 ORDER BY `unit` DESC [ RunTime:0.034055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17489339 LIMIT 2 [ RunTime:0.049258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489339 ORDER BY `minOrder` ASC [ RunTime:0.039605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17489335 LIMIT 4 [ RunTime:0.038580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489335 ORDER BY `minOrder` ASC [ RunTime:0.006639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17489335 ORDER BY `unit` DESC [ RunTime:0.051077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17489335 LIMIT 2 [ RunTime:0.050970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17489335 ORDER BY `minOrder` ASC [ RunTime:0.034168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17488927 LIMIT 4 [ RunTime:0.075161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488927 ORDER BY `minOrder` ASC [ RunTime:0.032358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17488927 ORDER BY `unit` DESC [ RunTime:0.166544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17488927 LIMIT 2 [ RunTime:0.101015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488927 ORDER BY `minOrder` ASC [ RunTime:0.050983s ]
select * from pdf where partno='21035853451' and brandshort='HARTING' limit 1 [ RunTime:0.043453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17488889 LIMIT 4 [ RunTime:0.055197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488889 ORDER BY `minOrder` ASC [ RunTime:0.050263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17488889 ORDER BY `unit` DESC [ RunTime:0.097192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17488889 LIMIT 2 [ RunTime:0.075939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488889 ORDER BY `minOrder` ASC [ RunTime:0.087374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17488086 LIMIT 4 [ RunTime:0.067653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488086 ORDER BY `minOrder` ASC [ RunTime:0.039724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17488086 ORDER BY `unit` DESC [ RunTime:0.037644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17488086 LIMIT 2 [ RunTime:0.024706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488086 ORDER BY `minOrder` ASC [ RunTime:0.033491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17487553 LIMIT 4 [ RunTime:0.012538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487553 ORDER BY `minOrder` ASC [ RunTime:0.066883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17487553 ORDER BY `unit` DESC [ RunTime:0.082759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17487553 LIMIT 2 [ RunTime:0.067105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487553 ORDER BY `minOrder` ASC [ RunTime:0.045866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17487170 LIMIT 4 [ RunTime:0.027911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487170 ORDER BY `minOrder` ASC [ RunTime:0.157510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17487170 ORDER BY `unit` DESC [ RunTime:0.085159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17487170 LIMIT 2 [ RunTime:0.132940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487170 ORDER BY `minOrder` ASC [ RunTime:0.061660s ]
select * from pdf where partno='21035853401' and brandshort='HARTING' limit 1 [ RunTime:0.051851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17487103 LIMIT 4 [ RunTime:0.029756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487103 ORDER BY `minOrder` ASC [ RunTime:0.086719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17487103 ORDER BY `unit` DESC [ RunTime:0.086578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17487103 LIMIT 2 [ RunTime:0.088954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487103 ORDER BY `minOrder` ASC [ RunTime:0.051316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17486550 LIMIT 4 [ RunTime:0.122988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17486550 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17486550 ORDER BY `unit` DESC [ RunTime:0.088241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17486550 LIMIT 2 [ RunTime:0.121984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17486550 ORDER BY `minOrder` ASC [ RunTime:0.050969s ]
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.032675s ]