SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002149s ]
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.013107s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003289s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.028088s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002519s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.002763s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002336s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009192s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002299s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.057907s ]
UPDATE `stock_search` SET `count` = 4102 , `updatetime` = '2026-06-08 16:34:25' WHERE `partno` = '210' [ RunTime:0.013756s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.016327s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.011828s ]
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.018508s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003525s ]
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.022680s ]
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 7300,20 [ RunTime:0.147591s ]
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 ('11781418','11781023','11780837','11779753','11775287','11774463','11772610','11772609','11756433','11755689','11752969','11752968','11752421','11752417','11752352','11752296','11752135','11751814','11751705','11751680') ORDER BY FIELD(s.id, 11781418,11781023,11780837,11779753,11775287,11774463,11772610,11772609,11756433,11755689,11752969,11752968,11752421,11752417,11752352,11752296,11752135,11751814,11751705,11751680) [ RunTime:0.109994s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11781418 LIMIT 4 [ RunTime:0.058666s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11781418 ORDER BY `minOrder` ASC [ RunTime:0.065682s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.033390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11781418 ORDER BY `unit` DESC [ RunTime:0.125240s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11781418 LIMIT 2 [ RunTime:0.021592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11781418 ORDER BY `minOrder` ASC [ RunTime:0.022103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11781023 LIMIT 4 [ RunTime:0.087697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11781023 ORDER BY `minOrder` ASC [ RunTime:0.070712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11781023 ORDER BY `unit` DESC [ RunTime:0.093691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11781023 LIMIT 2 [ RunTime:0.090175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11781023 ORDER BY `minOrder` ASC [ RunTime:0.053228s ]
select * from pdf where partno='21032412300' and brandshort='HARTING' limit 1 [ RunTime:0.134001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11780837 LIMIT 4 [ RunTime:0.063308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11780837 ORDER BY `minOrder` ASC [ RunTime:0.057188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11780837 ORDER BY `unit` DESC [ RunTime:0.045697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11780837 LIMIT 2 [ RunTime:0.054803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11780837 ORDER BY `minOrder` ASC [ RunTime:0.041120s ]
select * from pdf where partno='21033962531' and brandshort='HARTING' limit 1 [ RunTime:0.027375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11779753 LIMIT 4 [ RunTime:0.044627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11779753 ORDER BY `minOrder` ASC [ RunTime:0.090949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11779753 ORDER BY `unit` DESC [ RunTime:0.091526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11779753 LIMIT 2 [ RunTime:0.008556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11779753 ORDER BY `minOrder` ASC [ RunTime:0.045488s ]
select * from pdf where partno='21033212431' and brandshort='HARTING' limit 1 [ RunTime:0.034514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11775287 LIMIT 4 [ RunTime:0.057548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11775287 ORDER BY `minOrder` ASC [ RunTime:0.069342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11775287 ORDER BY `unit` DESC [ RunTime:0.091965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11775287 LIMIT 2 [ RunTime:0.023686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11775287 ORDER BY `minOrder` ASC [ RunTime:0.061074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11774463 LIMIT 4 [ RunTime:0.055553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11774463 ORDER BY `minOrder` ASC [ RunTime:0.054231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11774463 ORDER BY `unit` DESC [ RunTime:0.014235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11774463 LIMIT 2 [ RunTime:0.082543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11774463 ORDER BY `minOrder` ASC [ RunTime:0.028665s ]
select * from pdf where partno='21033814436' and brandshort='HARTING' limit 1 [ RunTime:0.040276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11772610 LIMIT 4 [ RunTime:0.090026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11772610 ORDER BY `minOrder` ASC [ RunTime:0.014025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11772610 ORDER BY `unit` DESC [ RunTime:0.062302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11772610 LIMIT 2 [ RunTime:0.082259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11772610 ORDER BY `minOrder` ASC [ RunTime:0.017344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11772609 LIMIT 4 [ RunTime:0.029233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11772609 ORDER BY `minOrder` ASC [ RunTime:0.052102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11772609 ORDER BY `unit` DESC [ RunTime:0.059740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11772609 LIMIT 2 [ RunTime:0.075932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11772609 ORDER BY `minOrder` ASC [ RunTime:0.059679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11756433 LIMIT 4 [ RunTime:0.079421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756433 ORDER BY `minOrder` ASC [ RunTime:0.068011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11756433 ORDER BY `unit` DESC [ RunTime:0.054681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11756433 LIMIT 2 [ RunTime:0.049665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756433 ORDER BY `minOrder` ASC [ RunTime:0.063184s ]
select * from pdf where partno='21038411505' and brandshort='HARTING' limit 1 [ RunTime:0.020646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11755689 LIMIT 4 [ RunTime:0.055726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11755689 ORDER BY `minOrder` ASC [ RunTime:0.096077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11755689 ORDER BY `unit` DESC [ RunTime:0.007239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11755689 LIMIT 2 [ RunTime:0.064419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11755689 ORDER BY `minOrder` ASC [ RunTime:0.048243s ]
select * from pdf where partno='21038223505' and brandshort='HARTING' limit 1 [ RunTime:0.017858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752969 LIMIT 4 [ RunTime:0.078150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752969 ORDER BY `minOrder` ASC [ RunTime:0.057767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752969 ORDER BY `unit` DESC [ RunTime:0.023281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752969 LIMIT 2 [ RunTime:0.128818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752969 ORDER BY `minOrder` ASC [ RunTime:0.014451s ]
select * from pdf where partno='21038213511' and brandshort='HARTING' limit 1 [ RunTime:0.009155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752968 LIMIT 4 [ RunTime:0.005247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752968 ORDER BY `minOrder` ASC [ RunTime:0.012592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752968 ORDER BY `unit` DESC [ RunTime:0.011567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752968 LIMIT 2 [ RunTime:0.010909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752968 ORDER BY `minOrder` ASC [ RunTime:0.002913s ]
select * from pdf where partno='21038814411' and brandshort='HARTING' limit 1 [ RunTime:0.015942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752421 LIMIT 4 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752421 ORDER BY `minOrder` ASC [ RunTime:0.004483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752421 ORDER BY `unit` DESC [ RunTime:0.025713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752421 LIMIT 2 [ RunTime:0.013063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752421 ORDER BY `minOrder` ASC [ RunTime:0.004154s ]
select * from pdf where partno='21038811813' and brandshort='HARTING' limit 1 [ RunTime:0.001276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752417 LIMIT 4 [ RunTime:0.007291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752417 ORDER BY `minOrder` ASC [ RunTime:0.018894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752417 ORDER BY `unit` DESC [ RunTime:0.031827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752417 LIMIT 2 [ RunTime:0.050701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752417 ORDER BY `minOrder` ASC [ RunTime:0.034794s ]
select * from pdf where partno='21038812841' and brandshort='HARTING' limit 1 [ RunTime:0.042458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752352 LIMIT 4 [ RunTime:0.012225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752352 ORDER BY `minOrder` ASC [ RunTime:0.036646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752352 ORDER BY `unit` DESC [ RunTime:0.004045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752352 LIMIT 2 [ RunTime:0.005009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752352 ORDER BY `minOrder` ASC [ RunTime:0.003160s ]
select * from pdf where partno='21038211511' and brandshort='HARTING' limit 1 [ RunTime:0.011732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752296 LIMIT 4 [ RunTime:0.010057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752296 ORDER BY `minOrder` ASC [ RunTime:0.018239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752296 ORDER BY `unit` DESC [ RunTime:0.042681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752296 LIMIT 2 [ RunTime:0.033881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752296 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
select * from pdf where partno='21038812412' and brandshort='HARTING' limit 1 [ RunTime:0.044252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11752135 LIMIT 4 [ RunTime:0.042891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752135 ORDER BY `minOrder` ASC [ RunTime:0.037994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11752135 ORDER BY `unit` DESC [ RunTime:0.063521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11752135 LIMIT 2 [ RunTime:0.015855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11752135 ORDER BY `minOrder` ASC [ RunTime:0.012705s ]
select * from pdf where partno='21038962420' and brandshort='HARTING' limit 1 [ RunTime:0.001685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11751814 LIMIT 4 [ RunTime:0.009800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11751814 ORDER BY `minOrder` ASC [ RunTime:0.014011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11751814 ORDER BY `unit` DESC [ RunTime:0.032397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11751814 LIMIT 2 [ RunTime:0.011680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11751814 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
select * from pdf where partno='21038962510' and brandshort='HARTING' limit 1 [ RunTime:0.005947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11751705 LIMIT 4 [ RunTime:0.010156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11751705 ORDER BY `minOrder` ASC [ RunTime:0.004336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11751705 ORDER BY `unit` DESC [ RunTime:0.000763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11751705 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11751705 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11751680 LIMIT 4 [ RunTime:0.004130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11751680 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11751680 ORDER BY `unit` DESC [ RunTime:0.000735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11751680 LIMIT 2 [ RunTime:0.005172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11751680 ORDER BY `minOrder` ASC [ RunTime:0.007604s ]
select * from pdf where partno='21038211533' and brandshort='HARTING' limit 1 [ RunTime:0.002605s ]
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.000655s ]