SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001349s ]
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` = '' [ RunTime:0.013697s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000899s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003320s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004664s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001969s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016260s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001975s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.014535s ]
UPDATE `stock_search` SET `count` = 2781 , `updatetime` = '2026-06-08 08:13:57' WHERE `partno` = '210' [ RunTime:0.017540s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003580s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.020409s ]
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.000692s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002439s ]
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.004771s ]
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 240,20 [ RunTime:0.122864s ]
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 ('32296085','11985750','37613933','37612479','32304254','32304253','32304212','32296125','32296124','32296086','16353872','13256015','11985738','13256228','37613895','37613896','36766287','32874990','32304159','32296036') ORDER BY FIELD(s.id, 32296085,11985750,37613933,37612479,32304254,32304253,32304212,32296125,32296124,32296086,16353872,13256015,11985738,13256228,37613895,37613896,36766287,32874990,32304159,32296036) [ RunTime:0.080606s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.042414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296085 LIMIT 4 [ RunTime:0.027083s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296085 ORDER BY `minOrder` ASC [ RunTime:0.020213s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296085 ORDER BY `unit` DESC [ RunTime:0.010351s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296085 LIMIT 2 [ RunTime:0.005578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296085 ORDER BY `minOrder` ASC [ RunTime:0.018262s ]
select * from pdf where partno='2108965-8' and brandshort='te connectivity' limit 1 [ RunTime:0.026931s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-8' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.107904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985750 LIMIT 4 [ RunTime:0.073534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985750 ORDER BY `minOrder` ASC [ RunTime:0.023997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985750 ORDER BY `unit` DESC [ RunTime:0.080848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985750 LIMIT 2 [ RunTime:0.049308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985750 ORDER BY `minOrder` ASC [ RunTime:0.016349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37613933 LIMIT 4 [ RunTime:0.022712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613933 ORDER BY `minOrder` ASC [ RunTime:0.014323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37613933 ORDER BY `unit` DESC [ RunTime:0.049561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37613933 LIMIT 2 [ RunTime:0.068979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613933 ORDER BY `minOrder` ASC [ RunTime:0.023407s ]
select * from pdf where partno='2108971-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.041319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.084980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37612479 LIMIT 4 [ RunTime:0.024395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37612479 ORDER BY `minOrder` ASC [ RunTime:0.044441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37612479 ORDER BY `unit` DESC [ RunTime:0.020920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37612479 LIMIT 2 [ RunTime:0.045483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37612479 ORDER BY `minOrder` ASC [ RunTime:0.019056s ]
select * from pdf where partno='2108857-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108857-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.078397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304254 LIMIT 4 [ RunTime:0.175644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304254 ORDER BY `minOrder` ASC [ RunTime:0.077868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304254 ORDER BY `unit` DESC [ RunTime:0.093006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304254 LIMIT 2 [ RunTime:0.160144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304254 ORDER BY `minOrder` ASC [ RunTime:0.100620s ]
select * from pdf where partno='2108971-8' and brandshort='te connectivity' limit 1 [ RunTime:0.126894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-8' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.070399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304253 LIMIT 4 [ RunTime:0.035656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304253 ORDER BY `minOrder` ASC [ RunTime:0.130077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304253 ORDER BY `unit` DESC [ RunTime:0.206174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304253 LIMIT 2 [ RunTime:0.170764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304253 ORDER BY `minOrder` ASC [ RunTime:0.027235s ]
select * from pdf where partno='2108965-4' and brandshort='te connectivity' limit 1 [ RunTime:0.076414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.119852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304212 LIMIT 4 [ RunTime:0.148242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304212 ORDER BY `minOrder` ASC [ RunTime:0.107416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304212 ORDER BY `unit` DESC [ RunTime:0.150718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304212 LIMIT 2 [ RunTime:0.008893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304212 ORDER BY `minOrder` ASC [ RunTime:0.074196s ]
select * from pdf where partno='2108971-6' and brandshort='te connectivity' limit 1 [ RunTime:0.068117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.074832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296125 LIMIT 4 [ RunTime:0.072158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296125 ORDER BY `minOrder` ASC [ RunTime:0.118819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296125 ORDER BY `unit` DESC [ RunTime:0.097755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296125 LIMIT 2 [ RunTime:0.068904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296125 ORDER BY `minOrder` ASC [ RunTime:0.031535s ]
select * from pdf where partno='2108971-8' and brandshort='te connectivity' limit 1 [ RunTime:0.102847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-8' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.088035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296124 LIMIT 4 [ RunTime:0.019142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296124 ORDER BY `minOrder` ASC [ RunTime:0.055264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296124 ORDER BY `unit` DESC [ RunTime:0.050331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296124 LIMIT 2 [ RunTime:0.051292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296124 ORDER BY `minOrder` ASC [ RunTime:0.016059s ]
select * from pdf where partno='2108965-4' and brandshort='te connectivity' limit 1 [ RunTime:0.018065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.116009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296086 LIMIT 4 [ RunTime:0.037555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296086 ORDER BY `minOrder` ASC [ RunTime:0.080863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296086 ORDER BY `unit` DESC [ RunTime:0.050887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296086 LIMIT 2 [ RunTime:0.051421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296086 ORDER BY `minOrder` ASC [ RunTime:0.051158s ]
select * from pdf where partno='2108971-6' and brandshort='te connectivity' limit 1 [ RunTime:0.051232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.070394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353872 LIMIT 4 [ RunTime:0.041541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353872 ORDER BY `minOrder` ASC [ RunTime:0.130994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353872 ORDER BY `unit` DESC [ RunTime:0.072853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353872 LIMIT 2 [ RunTime:0.044896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353872 ORDER BY `minOrder` ASC [ RunTime:0.046152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13256015 LIMIT 4 [ RunTime:0.138653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13256015 ORDER BY `minOrder` ASC [ RunTime:0.112336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13256015 ORDER BY `unit` DESC [ RunTime:0.078703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13256015 LIMIT 2 [ RunTime:0.127116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13256015 ORDER BY `minOrder` ASC [ RunTime:0.110524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985738 LIMIT 4 [ RunTime:0.082874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985738 ORDER BY `minOrder` ASC [ RunTime:0.044873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985738 ORDER BY `unit` DESC [ RunTime:0.051602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985738 LIMIT 2 [ RunTime:0.026890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985738 ORDER BY `minOrder` ASC [ RunTime:0.022221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13256228 LIMIT 4 [ RunTime:0.018275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13256228 ORDER BY `minOrder` ASC [ RunTime:0.022725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13256228 ORDER BY `unit` DESC [ RunTime:0.010284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13256228 LIMIT 2 [ RunTime:0.004209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13256228 ORDER BY `minOrder` ASC [ RunTime:0.004185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37613895 LIMIT 4 [ RunTime:0.003369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613895 ORDER BY `minOrder` ASC [ RunTime:0.014038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37613895 ORDER BY `unit` DESC [ RunTime:0.020239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37613895 LIMIT 2 [ RunTime:0.006876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613895 ORDER BY `minOrder` ASC [ RunTime:0.007755s ]
select * from pdf where partno='2108965-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.059461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37613896 LIMIT 4 [ RunTime:0.048284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613896 ORDER BY `minOrder` ASC [ RunTime:0.039042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37613896 ORDER BY `unit` DESC [ RunTime:0.036921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37613896 LIMIT 2 [ RunTime:0.033526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613896 ORDER BY `minOrder` ASC [ RunTime:0.017758s ]
select * from pdf where partno='2108965-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36766287 LIMIT 4 [ RunTime:0.009873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766287 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36766287 ORDER BY `unit` DESC [ RunTime:0.013112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36766287 LIMIT 2 [ RunTime:0.005011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766287 ORDER BY `minOrder` ASC [ RunTime:0.012837s ]
select * from pdf where partno='2108-632-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.008342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108-632-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.014661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32874990 LIMIT 4 [ RunTime:0.010496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32874990 ORDER BY `minOrder` ASC [ RunTime:0.005658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32874990 ORDER BY `unit` DESC [ RunTime:0.002556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32874990 LIMIT 2 [ RunTime:0.004326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32874990 ORDER BY `minOrder` ASC [ RunTime:0.004505s ]
select * from pdf where partno='210-4ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-4ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304159 LIMIT 4 [ RunTime:0.019244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304159 ORDER BY `minOrder` ASC [ RunTime:0.007065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304159 ORDER BY `unit` DESC [ RunTime:0.002231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304159 LIMIT 2 [ RunTime:0.001229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304159 ORDER BY `minOrder` ASC [ RunTime:0.008400s ]
select * from pdf where partno='2108971-3' and brandshort='te connectivity' limit 1 [ RunTime:0.008355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.021457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296036 LIMIT 4 [ RunTime:0.019149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296036 ORDER BY `minOrder` ASC [ RunTime:0.004767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296036 ORDER BY `unit` DESC [ RunTime:0.002547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296036 LIMIT 2 [ RunTime:0.007466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296036 ORDER BY `minOrder` ASC [ RunTime:0.003527s ]
select * from pdf where partno='2108971-3' and brandshort='te connectivity' limit 1 [ RunTime:0.001245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000493s ]
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.065832s ]