SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002216s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001882s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002022s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000761s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002261s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002588s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001867s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002988s ]
UPDATE `stock_search` SET `count` = 1910 , `updatetime` = '2026-06-06 21:01:03' WHERE `partno` = '210' [ RunTime:0.005544s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000278s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000239s ]
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.000398s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002424s ]
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.119695s ]
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 960,20 [ RunTime:0.050097s ]
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 ('12561900','34322135','32716881','14172479','11763959','13163629','33476980','11866390','11757460','11446416','33303083','18752328','14315185','12891009','11041363','32468673','17297979','17035572','12996074','12891479') ORDER BY FIELD(s.id, 12561900,34322135,32716881,14172479,11763959,13163629,33476980,11866390,11757460,11446416,33303083,18752328,14315185,12891009,11041363,32468673,17297979,17035572,12996074,12891479) [ RunTime:0.012407s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561900 LIMIT 4 [ RunTime:0.013944s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561900 ORDER BY `minOrder` ASC [ RunTime:0.012473s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561900 ORDER BY `unit` DESC [ RunTime:0.020593s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561900 LIMIT 2 [ RunTime:0.030284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561900 ORDER BY `minOrder` ASC [ RunTime:0.003863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322135 LIMIT 4 [ RunTime:0.023990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322135 ORDER BY `minOrder` ASC [ RunTime:0.020657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322135 ORDER BY `unit` DESC [ RunTime:0.020050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322135 LIMIT 2 [ RunTime:0.034651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322135 ORDER BY `minOrder` ASC [ RunTime:0.033805s ]
select * from pdf where partno='210-93-624-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018450s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-624-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.020785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32716881 LIMIT 4 [ RunTime:0.023692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32716881 ORDER BY `minOrder` ASC [ RunTime:0.004611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32716881 ORDER BY `unit` DESC [ RunTime:0.031392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32716881 LIMIT 2 [ RunTime:0.025078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32716881 ORDER BY `minOrder` ASC [ RunTime:0.010764s ]
select * from pdf where partno='21033012006' and brandshort='HARTING' limit 1 [ RunTime:0.010572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033012006' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14172479 LIMIT 4 [ RunTime:0.028914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14172479 ORDER BY `minOrder` ASC [ RunTime:0.023520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14172479 ORDER BY `unit` DESC [ RunTime:0.007137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14172479 LIMIT 2 [ RunTime:0.022680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14172479 ORDER BY `minOrder` ASC [ RunTime:0.016064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11763959 LIMIT 4 [ RunTime:0.026440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11763959 ORDER BY `minOrder` ASC [ RunTime:0.021660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11763959 ORDER BY `unit` DESC [ RunTime:0.015209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11763959 LIMIT 2 [ RunTime:0.014622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11763959 ORDER BY `minOrder` ASC [ RunTime:0.019789s ]
select * from pdf where partno='21033022001407' and brandshort='HARTING' limit 1 [ RunTime:0.010377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13163629 LIMIT 4 [ RunTime:0.013141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13163629 ORDER BY `minOrder` ASC [ RunTime:0.021017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13163629 ORDER BY `unit` DESC [ RunTime:0.011108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13163629 LIMIT 2 [ RunTime:0.013350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13163629 ORDER BY `minOrder` ASC [ RunTime:0.015343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33476980 LIMIT 4 [ RunTime:0.009002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33476980 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33476980 ORDER BY `unit` DESC [ RunTime:0.012810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33476980 LIMIT 2 [ RunTime:0.007809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33476980 ORDER BY `minOrder` ASC [ RunTime:0.009389s ]
select * from pdf where partno='2102866-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102866-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11866390 LIMIT 4 [ RunTime:0.004222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11866390 ORDER BY `minOrder` ASC [ RunTime:0.006474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11866390 ORDER BY `unit` DESC [ RunTime:0.002549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11866390 LIMIT 2 [ RunTime:0.007586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11866390 ORDER BY `minOrder` ASC [ RunTime:0.005724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11757460 LIMIT 4 [ RunTime:0.008112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11757460 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11757460 ORDER BY `unit` DESC [ RunTime:0.002045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11757460 LIMIT 2 [ RunTime:0.001916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11757460 ORDER BY `minOrder` ASC [ RunTime:0.001322s ]
select * from pdf where partno='21038812425' and brandshort='HARTING' limit 1 [ RunTime:0.005582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446416 LIMIT 4 [ RunTime:0.009401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446416 ORDER BY `minOrder` ASC [ RunTime:0.004869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446416 ORDER BY `unit` DESC [ RunTime:0.004128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446416 LIMIT 2 [ RunTime:0.001300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446416 ORDER BY `minOrder` ASC [ RunTime:0.001405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33303083 LIMIT 4 [ RunTime:0.001236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303083 ORDER BY `minOrder` ASC [ RunTime:0.001307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33303083 ORDER BY `unit` DESC [ RunTime:0.004139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33303083 LIMIT 2 [ RunTime:0.004833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303083 ORDER BY `minOrder` ASC [ RunTime:0.001876s ]
select * from pdf where partno='2106-1291' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-1291' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.016622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752328 LIMIT 4 [ RunTime:0.056787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752328 ORDER BY `minOrder` ASC [ RunTime:0.021481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752328 ORDER BY `unit` DESC [ RunTime:0.039099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752328 LIMIT 2 [ RunTime:0.038983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752328 ORDER BY `minOrder` ASC [ RunTime:0.044523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14315185 LIMIT 4 [ RunTime:0.031466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14315185 ORDER BY `minOrder` ASC [ RunTime:0.056336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14315185 ORDER BY `unit` DESC [ RunTime:0.037929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14315185 LIMIT 2 [ RunTime:0.024001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14315185 ORDER BY `minOrder` ASC [ RunTime:0.003697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12891009 LIMIT 4 [ RunTime:0.004835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891009 ORDER BY `minOrder` ASC [ RunTime:0.003552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12891009 ORDER BY `unit` DESC [ RunTime:0.001745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12891009 LIMIT 2 [ RunTime:0.003862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891009 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
select * from pdf where partno='21010000020' and brandshort='HARTING' limit 1 [ RunTime:0.001865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11041363 LIMIT 4 [ RunTime:0.008497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11041363 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11041363 ORDER BY `unit` DESC [ RunTime:0.005528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11041363 LIMIT 2 [ RunTime:0.002824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11041363 ORDER BY `minOrder` ASC [ RunTime:0.006230s ]
select * from pdf where partno='21023591401' and brandshort='HARTING' limit 1 [ RunTime:0.003035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32468673 LIMIT 4 [ RunTime:0.001299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468673 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32468673 ORDER BY `unit` DESC [ RunTime:0.004252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32468673 LIMIT 2 [ RunTime:0.005955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468673 ORDER BY `minOrder` ASC [ RunTime:0.003830s ]
select * from pdf where partno='2106946-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106946-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297979 LIMIT 4 [ RunTime:0.006006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297979 ORDER BY `minOrder` ASC [ RunTime:0.005433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297979 ORDER BY `unit` DESC [ RunTime:0.004178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297979 LIMIT 2 [ RunTime:0.002552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297979 ORDER BY `minOrder` ASC [ RunTime:0.001230s ]
select * from pdf where partno='21011009923' and brandshort='HARTING' limit 1 [ RunTime:0.008143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17035572 LIMIT 4 [ RunTime:0.006412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17035572 ORDER BY `minOrder` ASC [ RunTime:0.004412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17035572 ORDER BY `unit` DESC [ RunTime:0.007751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17035572 LIMIT 2 [ RunTime:0.006040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17035572 ORDER BY `minOrder` ASC [ RunTime:0.005794s ]
select * from pdf where partno='2106946-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12996074 LIMIT 4 [ RunTime:0.020407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12996074 ORDER BY `minOrder` ASC [ RunTime:0.009807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12996074 ORDER BY `unit` DESC [ RunTime:0.007348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12996074 LIMIT 2 [ RunTime:0.012554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12996074 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
select * from pdf where partno='21023012002' and brandshort='HARTING' limit 1 [ RunTime:0.015211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12891479 LIMIT 4 [ RunTime:0.008843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891479 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12891479 ORDER BY `unit` DESC [ RunTime:0.005176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12891479 LIMIT 2 [ RunTime:0.004167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891479 ORDER BY `minOrder` ASC [ RunTime:0.005048s ]
select * from pdf where partno='21010102038' and brandshort='HARTING' limit 1 [ RunTime:0.013676s ]
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.075652s ]