SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002031s ]
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` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=85&srecordnum=7365' [ RunTime:0.001818s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002416s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000580s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002825s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001959s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001906s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008419s ]
UPDATE `stock_search` SET `count` = 5539 , `updatetime` = '2026-06-08 22:54:45' WHERE `partno` = '210' [ RunTime:0.002892s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000274s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000232s ]
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.000471s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002327s ]
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.001330s ]
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 1680,20 [ RunTime:0.082453s ]
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 ('34322461','33618431','33453702','33432196','19578022','12871900','12159329','11764608','11048924','10900911','38519504','36760666','34411900','34411560','34401710','34399451','33837303','33474057','33411992','19573854') ORDER BY FIELD(s.id, 34322461,33618431,33453702,33432196,19578022,12871900,12159329,11764608,11048924,10900911,38519504,36760666,34411900,34411560,34401710,34399451,33837303,33474057,33411992,19573854) [ RunTime:0.013110s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322461 LIMIT 4 [ RunTime:0.001518s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322461 ORDER BY `minOrder` ASC [ RunTime:0.004834s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322461 ORDER BY `unit` DESC [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322461 LIMIT 2 [ RunTime:0.003159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322461 ORDER BY `minOrder` ASC [ RunTime:0.000176s ]
select * from pdf where partno='210-93-324-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-324-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618431 LIMIT 4 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618431 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618431 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618431 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618431 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='2102-5302' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-5302' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33453702 LIMIT 4 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453702 ORDER BY `minOrder` ASC [ RunTime:0.001791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33453702 ORDER BY `unit` DESC [ RunTime:0.006688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33453702 LIMIT 2 [ RunTime:0.007787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453702 ORDER BY `minOrder` ASC [ RunTime:0.005736s ]
select * from pdf where partno='21011009923' and brandshort='HARTING' limit 1 [ RunTime:0.001672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009923' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33432196 LIMIT 4 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432196 ORDER BY `minOrder` ASC [ RunTime:0.002304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33432196 ORDER BY `unit` DESC [ RunTime:0.001901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33432196 LIMIT 2 [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432196 ORDER BY `minOrder` ASC [ RunTime:0.004630s ]
select * from pdf where partno='21011009938' and brandshort='HARTING' limit 1 [ RunTime:0.007201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009938' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578022 LIMIT 4 [ RunTime:0.000903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578022 ORDER BY `minOrder` ASC [ RunTime:0.006399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578022 ORDER BY `unit` DESC [ RunTime:0.004236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578022 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578022 ORDER BY `minOrder` ASC [ RunTime:0.012291s ]
select * from pdf where partno='21011009933' and brandshort='HARTING' limit 1 [ RunTime:0.007623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12871900 LIMIT 4 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12871900 ORDER BY `minOrder` ASC [ RunTime:0.006031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12871900 ORDER BY `unit` DESC [ RunTime:0.007689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12871900 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12871900 ORDER BY `minOrder` ASC [ RunTime:0.003826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159329 LIMIT 4 [ RunTime:0.012562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159329 ORDER BY `minOrder` ASC [ RunTime:0.024104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159329 ORDER BY `unit` DESC [ RunTime:0.002975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159329 LIMIT 2 [ RunTime:0.001616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159329 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11764608 LIMIT 4 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11764608 ORDER BY `minOrder` ASC [ RunTime:0.019589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11764608 ORDER BY `unit` DESC [ RunTime:0.012195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11764608 LIMIT 2 [ RunTime:0.005887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11764608 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='21038612844' and brandshort='HARTING' limit 1 [ RunTime:0.002680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11048924 LIMIT 4 [ RunTime:0.005243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11048924 ORDER BY `minOrder` ASC [ RunTime:0.011381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11048924 ORDER BY `unit` DESC [ RunTime:0.003489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11048924 LIMIT 2 [ RunTime:0.008238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11048924 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
select * from pdf where partno='21021511405' and brandshort='HARTING' limit 1 [ RunTime:0.004336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10900911 LIMIT 4 [ RunTime:0.004350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10900911 ORDER BY `minOrder` ASC [ RunTime:0.002014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10900911 ORDER BY `unit` DESC [ RunTime:0.001538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10900911 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10900911 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='21033212831' and brandshort='HARTING' limit 1 [ RunTime:0.006701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38519504 LIMIT 4 [ RunTime:0.014440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38519504 ORDER BY `minOrder` ASC [ RunTime:0.008172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38519504 ORDER BY `unit` DESC [ RunTime:0.009370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38519504 LIMIT 2 [ RunTime:0.003643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38519504 ORDER BY `minOrder` ASC [ RunTime:0.006394s ]
select * from pdf where partno='2104949' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104949' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760666 LIMIT 4 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760666 ORDER BY `minOrder` ASC [ RunTime:0.004097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760666 ORDER BY `unit` DESC [ RunTime:0.005884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760666 LIMIT 2 [ RunTime:0.001967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760666 ORDER BY `minOrder` ASC [ RunTime:0.001565s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34411900 LIMIT 4 [ RunTime:0.006114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411900 ORDER BY `minOrder` ASC [ RunTime:0.009549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34411900 ORDER BY `unit` DESC [ RunTime:0.008334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34411900 LIMIT 2 [ RunTime:0.012197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411900 ORDER BY `minOrder` ASC [ RunTime:0.002131s ]
select * from pdf where partno='21038813415' and brandshort='HARTING' limit 1 [ RunTime:0.013936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21038813415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.011911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34411560 LIMIT 4 [ RunTime:0.002300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411560 ORDER BY `minOrder` ASC [ RunTime:0.015467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34411560 ORDER BY `unit` DESC [ RunTime:0.000848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34411560 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411560 ORDER BY `minOrder` ASC [ RunTime:0.003526s ]
select * from pdf where partno='21038813415' and brandshort='HARTING' limit 1 [ RunTime:0.008690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21038813415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.022970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401710 LIMIT 4 [ RunTime:0.006027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401710 ORDER BY `minOrder` ASC [ RunTime:0.030991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401710 ORDER BY `unit` DESC [ RunTime:0.013093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401710 LIMIT 2 [ RunTime:0.004056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401710 ORDER BY `minOrder` ASC [ RunTime:0.012117s ]
select * from pdf where partno='21033194801' and brandshort='HARTING' limit 1 [ RunTime:0.008953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033194801' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399451 LIMIT 4 [ RunTime:0.003065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399451 ORDER BY `minOrder` ASC [ RunTime:0.015540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399451 ORDER BY `unit` DESC [ RunTime:0.004117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399451 LIMIT 2 [ RunTime:0.003836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399451 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='21032721505' and brandshort='HARTING' limit 1 [ RunTime:0.006223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032721505' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33837303 LIMIT 4 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33837303 ORDER BY `minOrder` ASC [ RunTime:0.001945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33837303 ORDER BY `unit` DESC [ RunTime:0.008981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33837303 LIMIT 2 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33837303 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
select * from pdf where partno='21038211825' and brandshort='HARTING' limit 1 [ RunTime:0.006787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21038211825' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33474057 LIMIT 4 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33474057 ORDER BY `minOrder` ASC [ RunTime:0.001619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33474057 ORDER BY `unit` DESC [ RunTime:0.002620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33474057 LIMIT 2 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33474057 ORDER BY `minOrder` ASC [ RunTime:0.002443s ]
select * from pdf where partno='2101924-4' and brandshort='WEC' limit 1 [ RunTime:0.001714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101924-4' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.007434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33411992 LIMIT 4 [ RunTime:0.008683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33411992 ORDER BY `minOrder` ASC [ RunTime:0.015012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33411992 ORDER BY `unit` DESC [ RunTime:0.004489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33411992 LIMIT 2 [ RunTime:0.005890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33411992 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
select * from pdf where partno='21010000036' and brandshort='HARTING' limit 1 [ RunTime:0.000976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21010000036' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573854 LIMIT 4 [ RunTime:0.002681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573854 ORDER BY `minOrder` ASC [ RunTime:0.010722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573854 ORDER BY `unit` DESC [ RunTime:0.011053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573854 LIMIT 2 [ RunTime:0.003568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573854 ORDER BY `minOrder` ASC [ RunTime:0.006303s ]
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.003747s ]