SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001628s ]
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.007399s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001577s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003762s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001574s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.002067s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001173s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016562s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002243s ]
SELECT * FROM `stock_search` WHERE `partno` = '980' LIMIT 1 [ RunTime:0.010764s ]
UPDATE `stock_search` SET `count` = 1242 , `updatetime` = '2026-06-07 01:08:20' WHERE `partno` = '980' [ RunTime:0.010025s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008948s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.008953s ]
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.029834s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003770s ]
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.057177s ]
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 380,20 [ RunTime:0.025309s ]
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 ('32314265','32314264','32314236','32314235','32312270','20093928','19597128','19596936','19596741','19596548','19596280','19596279','19596230','19595971','19595387','19595386','19595237','19595236','19594707','19537338') ORDER BY FIELD(s.id, 32314265,32314264,32314236,32314235,32312270,20093928,19597128,19596936,19596741,19596548,19596280,19596279,19596230,19595971,19595387,19595386,19595237,19595236,19594707,19537338) [ RunTime:0.058361s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314265 LIMIT 4 [ RunTime:0.013625s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314265 ORDER BY `minOrder` ASC [ RunTime:0.019878s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314265 ORDER BY `unit` DESC [ RunTime:0.011708s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314265 LIMIT 2 [ RunTime:0.026590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314265 ORDER BY `minOrder` ASC [ RunTime:0.002001s ]
select * from pdf where partno='9808667071' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.037560s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808667071' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.020255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314264 LIMIT 4 [ RunTime:0.018556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314264 ORDER BY `minOrder` ASC [ RunTime:0.022145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314264 ORDER BY `unit` DESC [ RunTime:0.035894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314264 LIMIT 2 [ RunTime:0.017646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314264 ORDER BY `minOrder` ASC [ RunTime:0.002428s ]
select * from pdf where partno='980-8666-002' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.027316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-002' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314236 LIMIT 4 [ RunTime:0.008281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314236 ORDER BY `minOrder` ASC [ RunTime:0.022774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314236 ORDER BY `unit` DESC [ RunTime:0.010986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314236 LIMIT 2 [ RunTime:0.018334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314236 ORDER BY `minOrder` ASC [ RunTime:0.004916s ]
select * from pdf where partno='9808667072' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.019170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808667072' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.029829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314235 LIMIT 4 [ RunTime:0.023618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314235 ORDER BY `minOrder` ASC [ RunTime:0.009480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314235 ORDER BY `unit` DESC [ RunTime:0.045238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314235 LIMIT 2 [ RunTime:0.018042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314235 ORDER BY `minOrder` ASC [ RunTime:0.019010s ]
select * from pdf where partno='980-8552-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.053606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8552-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.007425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32312270 LIMIT 4 [ RunTime:0.011516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32312270 ORDER BY `minOrder` ASC [ RunTime:0.003972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32312270 ORDER BY `unit` DESC [ RunTime:0.021973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32312270 LIMIT 2 [ RunTime:0.019408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32312270 ORDER BY `minOrder` ASC [ RunTime:0.021533s ]
select * from pdf where partno='9808637003' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.022972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808637003' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.015064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20093928 LIMIT 4 [ RunTime:0.006498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20093928 ORDER BY `minOrder` ASC [ RunTime:0.028688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20093928 ORDER BY `unit` DESC [ RunTime:0.052617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20093928 LIMIT 2 [ RunTime:0.016532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20093928 ORDER BY `minOrder` ASC [ RunTime:0.008191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19597128 LIMIT 4 [ RunTime:0.026573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597128 ORDER BY `minOrder` ASC [ RunTime:0.025957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19597128 ORDER BY `unit` DESC [ RunTime:0.023767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19597128 LIMIT 2 [ RunTime:0.029996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597128 ORDER BY `minOrder` ASC [ RunTime:0.017651s ]
select * from pdf where partno='9801-0-15-21-23-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.009472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596936 LIMIT 4 [ RunTime:0.021818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596936 ORDER BY `minOrder` ASC [ RunTime:0.013923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596936 ORDER BY `unit` DESC [ RunTime:0.033908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596936 LIMIT 2 [ RunTime:0.080681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596936 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='9801-0-15-15-23-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.056491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596741 LIMIT 4 [ RunTime:0.036678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596741 ORDER BY `minOrder` ASC [ RunTime:0.043549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596741 ORDER BY `unit` DESC [ RunTime:0.028317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596741 LIMIT 2 [ RunTime:0.012135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596741 ORDER BY `minOrder` ASC [ RunTime:0.001576s ]
select * from pdf where partno='9801-0-15-01-23-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.007497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596548 LIMIT 4 [ RunTime:0.024999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596548 ORDER BY `minOrder` ASC [ RunTime:0.004185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596548 ORDER BY `unit` DESC [ RunTime:0.030831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596548 LIMIT 2 [ RunTime:0.017634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596548 ORDER BY `minOrder` ASC [ RunTime:0.015141s ]
select * from pdf where partno='9808-0-15-15-16-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.038076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596280 LIMIT 4 [ RunTime:0.010999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596280 ORDER BY `minOrder` ASC [ RunTime:0.010036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596280 ORDER BY `unit` DESC [ RunTime:0.033313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596280 LIMIT 2 [ RunTime:0.024800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596280 ORDER BY `minOrder` ASC [ RunTime:0.020331s ]
select * from pdf where partno='9801-0-15-80-23-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596279 LIMIT 4 [ RunTime:0.032210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596279 ORDER BY `minOrder` ASC [ RunTime:0.009010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596279 ORDER BY `unit` DESC [ RunTime:0.040609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596279 LIMIT 2 [ RunTime:0.027978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596279 ORDER BY `minOrder` ASC [ RunTime:0.012537s ]
select * from pdf where partno='9801-0-15-01-23-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.014236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596230 LIMIT 4 [ RunTime:0.023875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596230 ORDER BY `minOrder` ASC [ RunTime:0.042149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596230 ORDER BY `unit` DESC [ RunTime:0.011329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596230 LIMIT 2 [ RunTime:0.013419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596230 ORDER BY `minOrder` ASC [ RunTime:0.031145s ]
select * from pdf where partno='9808-0-15-15-16-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.006935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595971 LIMIT 4 [ RunTime:0.017572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595971 ORDER BY `minOrder` ASC [ RunTime:0.031433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595971 ORDER BY `unit` DESC [ RunTime:0.033890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595971 LIMIT 2 [ RunTime:0.025776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595971 ORDER BY `minOrder` ASC [ RunTime:0.011115s ]
select * from pdf where partno='9808-0-15-80-16-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.032523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595387 LIMIT 4 [ RunTime:0.032405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595387 ORDER BY `minOrder` ASC [ RunTime:0.018766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595387 ORDER BY `unit` DESC [ RunTime:0.019262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595387 LIMIT 2 [ RunTime:0.021828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595387 ORDER BY `minOrder` ASC [ RunTime:0.009350s ]
select * from pdf where partno='9808-0-15-80-16-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595386 LIMIT 4 [ RunTime:0.011797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595386 ORDER BY `minOrder` ASC [ RunTime:0.019468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595386 ORDER BY `unit` DESC [ RunTime:0.013729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595386 LIMIT 2 [ RunTime:0.006566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595386 ORDER BY `minOrder` ASC [ RunTime:0.025528s ]
select * from pdf where partno='9808-0-15-01-16-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.008413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595237 LIMIT 4 [ RunTime:0.052379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595237 ORDER BY `minOrder` ASC [ RunTime:0.012732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595237 ORDER BY `unit` DESC [ RunTime:0.014948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595237 LIMIT 2 [ RunTime:0.031265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595237 ORDER BY `minOrder` ASC [ RunTime:0.017443s ]
select * from pdf where partno='9801-0-15-80-23-80-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.048087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595236 LIMIT 4 [ RunTime:0.023900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595236 ORDER BY `minOrder` ASC [ RunTime:0.018810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595236 ORDER BY `unit` DESC [ RunTime:0.020213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595236 LIMIT 2 [ RunTime:0.024849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595236 ORDER BY `minOrder` ASC [ RunTime:0.024749s ]
select * from pdf where partno='9801-0-15-01-23-01-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.035324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594707 LIMIT 4 [ RunTime:0.030500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594707 ORDER BY `minOrder` ASC [ RunTime:0.034564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594707 ORDER BY `unit` DESC [ RunTime:0.009019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594707 LIMIT 2 [ RunTime:0.043162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594707 ORDER BY `minOrder` ASC [ RunTime:0.016164s ]
select * from pdf where partno='9808-0-15-80-16-80-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19537338 LIMIT 4 [ RunTime:0.019522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19537338 ORDER BY `minOrder` ASC [ RunTime:0.006408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19537338 ORDER BY `unit` DESC [ RunTime:0.017969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19537338 LIMIT 2 [ RunTime:0.013244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19537338 ORDER BY `minOrder` ASC [ RunTime:0.008989s ]
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.015782s ]