SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002932s ]
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=96&srecordnum=7503' [ RunTime:0.012729s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001293s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002422s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001322s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.001809s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002637s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010059s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001924s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008636s ]
UPDATE `stock_search` SET `count` = 5672 , `updatetime` = '2026-06-08 22:56:15' WHERE `partno` = '210' [ RunTime:0.001226s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005807s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001611s ]
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.000801s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001504s ]
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.190092s ]
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 1900,20 [ RunTime:0.103855s ]
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 ('12183719','12004049','11756069','11692606','11446668','11048859','10852796','10832093','38519473','37958801','36910782','36874533','36874532','36874531','35500481','35500480','35500427','35498347','35498158','35495700') ORDER BY FIELD(s.id, 12183719,12004049,11756069,11692606,11446668,11048859,10852796,10832093,38519473,37958801,36910782,36874533,36874532,36874531,35500481,35500480,35500427,35498347,35498158,35495700) [ RunTime:0.008254s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183719 LIMIT 4 [ RunTime:0.002151s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183719 ORDER BY `minOrder` ASC [ RunTime:0.001572s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12183719 ORDER BY `unit` DESC [ RunTime:0.001050s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12183719 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183719 ORDER BY `minOrder` ASC [ RunTime:0.002584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12004049 LIMIT 4 [ RunTime:0.002312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12004049 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12004049 ORDER BY `unit` DESC [ RunTime:0.004403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12004049 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12004049 ORDER BY `minOrder` ASC [ RunTime:0.000196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11756069 LIMIT 4 [ RunTime:0.000209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756069 ORDER BY `minOrder` ASC [ RunTime:0.003298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11756069 ORDER BY `unit` DESC [ RunTime:0.001830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11756069 LIMIT 2 [ RunTime:0.007130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756069 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
select * from pdf where partno='21038211530' and brandshort='HARTING' limit 1 [ RunTime:0.002551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692606 LIMIT 4 [ RunTime:0.005025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692606 ORDER BY `minOrder` ASC [ RunTime:0.002335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11692606 ORDER BY `unit` DESC [ RunTime:0.005208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11692606 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692606 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
select * from pdf where partno='21033301300' and brandshort='HARTING' limit 1 [ RunTime:0.003593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446668 LIMIT 4 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446668 ORDER BY `minOrder` ASC [ RunTime:0.014865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446668 ORDER BY `unit` DESC [ RunTime:0.004730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446668 LIMIT 2 [ RunTime:0.006121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446668 ORDER BY `minOrder` ASC [ RunTime:0.007376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11048859 LIMIT 4 [ RunTime:0.009942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11048859 ORDER BY `minOrder` ASC [ RunTime:0.018781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11048859 ORDER BY `unit` DESC [ RunTime:0.002936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11048859 LIMIT 2 [ RunTime:0.001804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11048859 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='21033191401' and brandshort='HARTING' limit 1 [ RunTime:0.003534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10852796 LIMIT 4 [ RunTime:0.005481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10852796 ORDER BY `minOrder` ASC [ RunTime:0.012670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10852796 ORDER BY `unit` DESC [ RunTime:0.004553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10852796 LIMIT 2 [ RunTime:0.006299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10852796 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='21033812404' and brandshort='HARTING' limit 1 [ RunTime:0.005604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832093 LIMIT 4 [ RunTime:0.000808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832093 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832093 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832093 LIMIT 2 [ RunTime:0.003699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832093 ORDER BY `minOrder` ASC [ RunTime:0.002670s ]
select * from pdf where partno='21021591305' and brandshort='HARTING' limit 1 [ RunTime:0.003279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38519473 LIMIT 4 [ RunTime:0.004187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38519473 ORDER BY `minOrder` ASC [ RunTime:0.025235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38519473 ORDER BY `unit` DESC [ RunTime:0.025559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38519473 LIMIT 2 [ RunTime:0.003441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38519473 ORDER BY `minOrder` ASC [ RunTime:0.006236s ]
select * from pdf where partno='2106455' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005922s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106455' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37958801 LIMIT 4 [ RunTime:0.004103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37958801 ORDER BY `minOrder` ASC [ RunTime:0.016094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37958801 ORDER BY `unit` DESC [ RunTime:0.001602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37958801 LIMIT 2 [ RunTime:0.005816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37958801 ORDER BY `minOrder` ASC [ RunTime:0.003435s ]
select * from pdf where partno='2105108' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105108' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36910782 LIMIT 4 [ RunTime:0.004305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36910782 ORDER BY `minOrder` ASC [ RunTime:0.002296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36910782 ORDER BY `unit` DESC [ RunTime:0.004601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36910782 LIMIT 2 [ RunTime:0.005091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36910782 ORDER BY `minOrder` ASC [ RunTime:0.006564s ]
select * from pdf where partno='2104-1001-KIT' and brandshort='DB Unlimited' limit 1 [ RunTime:0.001100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1001-KIT' OR `brand` LIKE 'DB Unlimited%' ) ) LIMIT 1 [ RunTime:0.006046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874533 LIMIT 4 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874533 ORDER BY `minOrder` ASC [ RunTime:0.007538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874533 ORDER BY `unit` DESC [ RunTime:0.001061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874533 LIMIT 2 [ RunTime:0.003786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874533 ORDER BY `minOrder` ASC [ RunTime:0.004302s ]
select * from pdf where partno='210B-H' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.002416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210B-H' OR `brand` LIKE 'Excelta Corporation%' ) ) LIMIT 1 [ RunTime:0.002130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874532 LIMIT 4 [ RunTime:0.004028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874532 ORDER BY `minOrder` ASC [ RunTime:0.006471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874532 ORDER BY `unit` DESC [ RunTime:0.009157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874532 LIMIT 2 [ RunTime:0.004031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874532 ORDER BY `minOrder` ASC [ RunTime:0.008118s ]
select * from pdf where partno='210B-P' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.008896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210B-P' OR `brand` LIKE 'Excelta Corporation%' ) ) LIMIT 1 [ RunTime:0.006913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874531 LIMIT 4 [ RunTime:0.004276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874531 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874531 ORDER BY `unit` DESC [ RunTime:0.010886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874531 LIMIT 2 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874531 ORDER BY `minOrder` ASC [ RunTime:0.004512s ]
select * from pdf where partno='210S-P' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.009530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210S-P' OR `brand` LIKE 'Excelta Corporation%' ) ) LIMIT 1 [ RunTime:0.011167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35500481 LIMIT 4 [ RunTime:0.010448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500481 ORDER BY `minOrder` ASC [ RunTime:0.016765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35500481 ORDER BY `unit` DESC [ RunTime:0.014835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35500481 LIMIT 2 [ RunTime:0.004633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500481 ORDER BY `minOrder` ASC [ RunTime:0.009362s ]
select * from pdf where partno='2107506' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107506' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35500480 LIMIT 4 [ RunTime:0.018244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500480 ORDER BY `minOrder` ASC [ RunTime:0.023343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35500480 ORDER BY `unit` DESC [ RunTime:0.014542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35500480 LIMIT 2 [ RunTime:0.022286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500480 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
select * from pdf where partno='2107780' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107780' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35500427 LIMIT 4 [ RunTime:0.004004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500427 ORDER BY `minOrder` ASC [ RunTime:0.005650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35500427 ORDER BY `unit` DESC [ RunTime:0.015158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35500427 LIMIT 2 [ RunTime:0.005248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500427 ORDER BY `minOrder` ASC [ RunTime:0.004487s ]
select * from pdf where partno='2107778' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107778' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35498347 LIMIT 4 [ RunTime:0.007898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498347 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35498347 ORDER BY `unit` DESC [ RunTime:0.012809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35498347 LIMIT 2 [ RunTime:0.009692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498347 ORDER BY `minOrder` ASC [ RunTime:0.002232s ]
select * from pdf where partno='21033711403' and brandshort='HARTING' limit 1 [ RunTime:0.005253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033711403' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35498158 LIMIT 4 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498158 ORDER BY `minOrder` ASC [ RunTime:0.013029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35498158 ORDER BY `unit` DESC [ RunTime:0.003779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35498158 LIMIT 2 [ RunTime:0.002458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498158 ORDER BY `minOrder` ASC [ RunTime:0.004797s ]
select * from pdf where partno='2109405' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109405' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35495700 LIMIT 4 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35495700 ORDER BY `minOrder` ASC [ RunTime:0.009183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35495700 ORDER BY `unit` DESC [ RunTime:0.013757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35495700 LIMIT 2 [ RunTime:0.006068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35495700 ORDER BY `minOrder` ASC [ RunTime:0.016760s ]
select * from pdf where partno='2107717' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107717' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001415s ]
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.092615s ]