SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002374s ]
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.007358s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002239s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003482s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002013s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.002945s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002514s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001455s ]
SELECT * FROM `stock_search` WHERE `partno` = '980' LIMIT 1 [ RunTime:0.008380s ]
UPDATE `stock_search` SET `count` = 1232 , `updatetime` = '2026-06-07 01:07:47' WHERE `partno` = '980' [ RunTime:0.010572s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000296s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000253s ]
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.005994s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001142s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '980%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.081110s ]
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 '980%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 140,20 [ RunTime:0.016590s ]
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 ('32531856','32531262','16487809','33395460','14386177','33483847','32280672','12221334','32532143','14375348','12628962','32532193','32530887','32532149','32532202','33483540','33408493','11911357','33408334','16487081') ORDER BY FIELD(s.id, 32531856,32531262,16487809,33395460,14386177,33483847,32280672,12221334,32532143,14375348,12628962,32532193,32530887,32532149,32532202,33483540,33408493,11911357,33408334,16487081) [ RunTime:0.035277s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32531856 LIMIT 4 [ RunTime:0.016397s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32531856 ORDER BY `minOrder` ASC [ RunTime:0.007569s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32531856 ORDER BY `unit` DESC [ RunTime:0.014428s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32531856 LIMIT 2 [ RunTime:0.042450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32531856 ORDER BY `minOrder` ASC [ RunTime:0.020372s ]
select * from pdf where partno='980-9I160-00W000-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.012234s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I160-00W000-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.022795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32531262 LIMIT 4 [ RunTime:0.038894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32531262 ORDER BY `minOrder` ASC [ RunTime:0.035245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32531262 ORDER BY `unit` DESC [ RunTime:0.010174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32531262 LIMIT 2 [ RunTime:0.099028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32531262 ORDER BY `minOrder` ASC [ RunTime:0.007581s ]
select * from pdf where partno='980-9I530-00W000-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.023756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I530-00W000-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.035109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16487809 LIMIT 4 [ RunTime:0.143554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487809 ORDER BY `minOrder` ASC [ RunTime:0.077197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16487809 ORDER BY `unit` DESC [ RunTime:0.098396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16487809 LIMIT 2 [ RunTime:0.072233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487809 ORDER BY `minOrder` ASC [ RunTime:0.044513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33395460 LIMIT 4 [ RunTime:0.067417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33395460 ORDER BY `minOrder` ASC [ RunTime:0.089522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33395460 ORDER BY `unit` DESC [ RunTime:0.040744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33395460 LIMIT 2 [ RunTime:0.055168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33395460 ORDER BY `minOrder` ASC [ RunTime:0.003477s ]
select * from pdf where partno='9808-0-15-01-16-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.046766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808-0-15-01-16-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.048165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386177 LIMIT 4 [ RunTime:0.026747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386177 ORDER BY `minOrder` ASC [ RunTime:0.078966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386177 ORDER BY `unit` DESC [ RunTime:0.033665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386177 LIMIT 2 [ RunTime:0.030123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386177 ORDER BY `minOrder` ASC [ RunTime:0.012640s ]
select * from pdf where partno='9806 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.037881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33483847 LIMIT 4 [ RunTime:0.040868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483847 ORDER BY `minOrder` ASC [ RunTime:0.016306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33483847 ORDER BY `unit` DESC [ RunTime:0.019203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33483847 LIMIT 2 [ RunTime:0.038366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483847 ORDER BY `minOrder` ASC [ RunTime:0.041214s ]
select * from pdf where partno='980-2000-354' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.008199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-2000-354' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.041991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280672 LIMIT 4 [ RunTime:0.051457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280672 ORDER BY `minOrder` ASC [ RunTime:0.067302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280672 ORDER BY `unit` DESC [ RunTime:0.052948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280672 LIMIT 2 [ RunTime:0.082702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280672 ORDER BY `minOrder` ASC [ RunTime:0.026235s ]
select * from pdf where partno='9801-0-15-80-23-80-10-0' and brandshort='mill-max' limit 1 [ RunTime:0.054545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9801-0-15-80-23-80-10-0' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.032872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221334 LIMIT 4 [ RunTime:0.053419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221334 ORDER BY `minOrder` ASC [ RunTime:0.049583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12221334 ORDER BY `unit` DESC [ RunTime:0.173566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12221334 LIMIT 2 [ RunTime:0.129005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221334 ORDER BY `minOrder` ASC [ RunTime:0.076817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532143 LIMIT 4 [ RunTime:0.053103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532143 ORDER BY `minOrder` ASC [ RunTime:0.079509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532143 ORDER BY `unit` DESC [ RunTime:0.048606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532143 LIMIT 2 [ RunTime:0.079948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532143 ORDER BY `minOrder` ASC [ RunTime:0.008510s ]
select * from pdf where partno='980-9I51A-00NS00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.075257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I51A-00NS00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.063031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375348 LIMIT 4 [ RunTime:0.077039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375348 ORDER BY `minOrder` ASC [ RunTime:0.150046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14375348 ORDER BY `unit` DESC [ RunTime:0.050147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14375348 LIMIT 2 [ RunTime:0.104843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375348 ORDER BY `minOrder` ASC [ RunTime:0.061765s ]
select * from pdf where partno='9804 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.074797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628962 LIMIT 4 [ RunTime:0.119889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628962 ORDER BY `minOrder` ASC [ RunTime:0.128861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628962 ORDER BY `unit` DESC [ RunTime:0.037881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628962 LIMIT 2 [ RunTime:0.052277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628962 ORDER BY `minOrder` ASC [ RunTime:0.033421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532193 LIMIT 4 [ RunTime:0.053003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532193 ORDER BY `minOrder` ASC [ RunTime:0.074029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532193 ORDER BY `unit` DESC [ RunTime:0.105854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532193 LIMIT 2 [ RunTime:0.028329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532193 ORDER BY `minOrder` ASC [ RunTime:0.055890s ]
select * from pdf where partno='980-9I30I-00NM00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.136842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I30I-00NM00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.058714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32530887 LIMIT 4 [ RunTime:0.044939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32530887 ORDER BY `minOrder` ASC [ RunTime:0.037515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32530887 ORDER BY `unit` DESC [ RunTime:0.033298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32530887 LIMIT 2 [ RunTime:0.020405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32530887 ORDER BY `minOrder` ASC [ RunTime:0.031171s ]
select * from pdf where partno='980-9I042-00C000-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.060432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I042-00C000-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.044977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532149 LIMIT 4 [ RunTime:0.119752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532149 ORDER BY `minOrder` ASC [ RunTime:0.117608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532149 ORDER BY `unit` DESC [ RunTime:0.141341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532149 LIMIT 2 [ RunTime:0.142385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532149 ORDER BY `minOrder` ASC [ RunTime:0.058556s ]
select * from pdf where partno='980-9I510-00NS00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.050468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I510-00NS00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.099539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532202 LIMIT 4 [ RunTime:0.098281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532202 ORDER BY `minOrder` ASC [ RunTime:0.111697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532202 ORDER BY `unit` DESC [ RunTime:0.037173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532202 LIMIT 2 [ RunTime:0.086340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532202 ORDER BY `minOrder` ASC [ RunTime:0.048198s ]
select * from pdf where partno='980-9I30H-00NM00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.039020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I30H-00NM00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.093082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33483540 LIMIT 4 [ RunTime:0.037164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483540 ORDER BY `minOrder` ASC [ RunTime:0.068866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33483540 ORDER BY `unit` DESC [ RunTime:0.070129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33483540 LIMIT 2 [ RunTime:0.052366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483540 ORDER BY `minOrder` ASC [ RunTime:0.075154s ]
select * from pdf where partno='980-2000-345' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.131090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-2000-345' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.107278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33408493 LIMIT 4 [ RunTime:0.133698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408493 ORDER BY `minOrder` ASC [ RunTime:0.052652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33408493 ORDER BY `unit` DESC [ RunTime:0.015251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33408493 LIMIT 2 [ RunTime:0.022060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408493 ORDER BY `minOrder` ASC [ RunTime:0.004712s ]
select * from pdf where partno='980-8558-001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.029411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8558-001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.034098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11911357 LIMIT 4 [ RunTime:0.062399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11911357 ORDER BY `minOrder` ASC [ RunTime:0.038862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11911357 ORDER BY `unit` DESC [ RunTime:0.015378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11911357 LIMIT 2 [ RunTime:0.016980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11911357 ORDER BY `minOrder` ASC [ RunTime:0.030561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33408334 LIMIT 4 [ RunTime:0.032866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408334 ORDER BY `minOrder` ASC [ RunTime:0.043241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33408334 ORDER BY `unit` DESC [ RunTime:0.014199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33408334 LIMIT 2 [ RunTime:0.039694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408334 ORDER BY `minOrder` ASC [ RunTime:0.039839s ]
select * from pdf where partno='980-8557-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.026996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8557-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.026940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16487081 LIMIT 4 [ RunTime:0.008890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487081 ORDER BY `minOrder` ASC [ RunTime:0.012447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16487081 ORDER BY `unit` DESC [ RunTime:0.018038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16487081 LIMIT 2 [ RunTime:0.027238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487081 ORDER BY `minOrder` ASC [ RunTime:0.004908s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '980%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.009976s ]