SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001463s ]
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.002838s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001360s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002071s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001945s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002201s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001615s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003849s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002296s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008266s ]
UPDATE `stock_search` SET `count` = 2098 , `updatetime` = '2026-06-07 00:02:46' WHERE `partno` = '210' [ RunTime:0.015478s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008132s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.014423s ]
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.002739s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002775s ]
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.017474s ]
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 1340,20 [ RunTime:0.112122s ]
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 ('12892225','11447288','10853832','10839590','10832333','114','34411219','34410698','34359929','34281982','33857011','33618642','32277908','32163406','19577999','12991125','12800412','12063166','11756077','34402379') ORDER BY FIELD(s.id, 12892225,11447288,10853832,10839590,10832333,114,34411219,34410698,34359929,34281982,33857011,33618642,32277908,32163406,19577999,12991125,12800412,12063166,11756077,34402379) [ RunTime:0.072653s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892225 LIMIT 4 [ RunTime:0.018167s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892225 ORDER BY `minOrder` ASC [ RunTime:0.063559s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892225 ORDER BY `unit` DESC [ RunTime:0.077110s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892225 LIMIT 2 [ RunTime:0.033849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892225 ORDER BY `minOrder` ASC [ RunTime:0.036101s ]
select * from pdf where partno='21010000018' and brandshort='HARTING' limit 1 [ RunTime:0.021833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447288 LIMIT 4 [ RunTime:0.030488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447288 ORDER BY `minOrder` ASC [ RunTime:0.014330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447288 ORDER BY `unit` DESC [ RunTime:0.026131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447288 LIMIT 2 [ RunTime:0.006166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447288 ORDER BY `minOrder` ASC [ RunTime:0.027488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10853832 LIMIT 4 [ RunTime:0.055071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10853832 ORDER BY `minOrder` ASC [ RunTime:0.048709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10853832 ORDER BY `unit` DESC [ RunTime:0.037877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10853832 LIMIT 2 [ RunTime:0.024804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10853832 ORDER BY `minOrder` ASC [ RunTime:0.013391s ]
select * from pdf where partno='21011301013' and brandshort='HARTING' limit 1 [ RunTime:0.032200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10839590 LIMIT 4 [ RunTime:0.026750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10839590 ORDER BY `minOrder` ASC [ RunTime:0.028002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10839590 ORDER BY `unit` DESC [ RunTime:0.055614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10839590 LIMIT 2 [ RunTime:0.035054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10839590 ORDER BY `minOrder` ASC [ RunTime:0.051608s ]
select * from pdf where partno='21033812824' and brandshort='HARTING' limit 1 [ RunTime:0.030270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832333 LIMIT 4 [ RunTime:0.035004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832333 ORDER BY `minOrder` ASC [ RunTime:0.054283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832333 ORDER BY `unit` DESC [ RunTime:0.047313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832333 LIMIT 2 [ RunTime:0.057460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832333 ORDER BY `minOrder` ASC [ RunTime:0.042770s ]
select * from pdf where partno='21023812431' and brandshort='HARTING' limit 1 [ RunTime:0.109134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 114 LIMIT 4 [ RunTime:0.064215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 114 ORDER BY `minOrder` ASC [ RunTime:0.049245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 114 ORDER BY `unit` DESC [ RunTime:0.043835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 114 LIMIT 2 [ RunTime:0.057883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 114 ORDER BY `minOrder` ASC [ RunTime:0.034077s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.012263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106KL-04W-B40-L00' OR `brand` LIKE 'NMB TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.045560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34411219 LIMIT 4 [ RunTime:0.112435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411219 ORDER BY `minOrder` ASC [ RunTime:0.088494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34411219 ORDER BY `unit` DESC [ RunTime:0.036964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34411219 LIMIT 2 [ RunTime:0.025637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411219 ORDER BY `minOrder` ASC [ RunTime:0.025590s ]
select * from pdf where partno='21033211530' and brandshort='HARTING' limit 1 [ RunTime:0.062270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033211530' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.080476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34410698 LIMIT 4 [ RunTime:0.056196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34410698 ORDER BY `minOrder` ASC [ RunTime:0.043369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34410698 ORDER BY `unit` DESC [ RunTime:0.103419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34410698 LIMIT 2 [ RunTime:0.025792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34410698 ORDER BY `minOrder` ASC [ RunTime:0.007730s ]
select * from pdf where partno='21033211530' and brandshort='HARTING' limit 1 [ RunTime:0.011351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033211530' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.021339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34359929 LIMIT 4 [ RunTime:0.048031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34359929 ORDER BY `minOrder` ASC [ RunTime:0.040407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34359929 ORDER BY `unit` DESC [ RunTime:0.031700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34359929 LIMIT 2 [ RunTime:0.026246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34359929 ORDER BY `minOrder` ASC [ RunTime:0.021954s ]
select * from pdf where partno='2102351-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.028608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102351-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.023545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281982 LIMIT 4 [ RunTime:0.026133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281982 ORDER BY `minOrder` ASC [ RunTime:0.035082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281982 ORDER BY `unit` DESC [ RunTime:0.087263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281982 LIMIT 2 [ RunTime:0.023421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281982 ORDER BY `minOrder` ASC [ RunTime:0.030984s ]
select * from pdf where partno='2102320-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.019444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102320-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.027470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857011 LIMIT 4 [ RunTime:0.027624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857011 ORDER BY `minOrder` ASC [ RunTime:0.025500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857011 ORDER BY `unit` DESC [ RunTime:0.011185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857011 LIMIT 2 [ RunTime:0.015054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857011 ORDER BY `minOrder` ASC [ RunTime:0.021502s ]
select * from pdf where partno='2108900000' and brandshort='Weidmüller' limit 1 [ RunTime:0.038498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108900000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.050116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618642 LIMIT 4 [ RunTime:0.042365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618642 ORDER BY `minOrder` ASC [ RunTime:0.055804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618642 ORDER BY `unit` DESC [ RunTime:0.036420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618642 LIMIT 2 [ RunTime:0.047184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618642 ORDER BY `minOrder` ASC [ RunTime:0.022576s ]
select * from pdf where partno='2104-1301' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.040697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1301' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.018751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277908 LIMIT 4 [ RunTime:0.040554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277908 ORDER BY `minOrder` ASC [ RunTime:0.090297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277908 ORDER BY `unit` DESC [ RunTime:0.034904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277908 LIMIT 2 [ RunTime:0.045248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277908 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='2106123-1 (loose piece)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.025218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1 (loose piece)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.032936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163406 LIMIT 4 [ RunTime:0.055191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163406 ORDER BY `minOrder` ASC [ RunTime:0.034823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163406 ORDER BY `unit` DESC [ RunTime:0.026459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163406 LIMIT 2 [ RunTime:0.017624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163406 ORDER BY `minOrder` ASC [ RunTime:0.022652s ]
select * from pdf where partno='2106123-1 (loose piece)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.010021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1 (loose piece)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.010976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577999 LIMIT 4 [ RunTime:0.019944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577999 ORDER BY `minOrder` ASC [ RunTime:0.034113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577999 ORDER BY `unit` DESC [ RunTime:0.054303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577999 LIMIT 2 [ RunTime:0.076772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577999 ORDER BY `minOrder` ASC [ RunTime:0.028890s ]
select * from pdf where partno='21011009025' and brandshort='HARTING' limit 1 [ RunTime:0.054983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12991125 LIMIT 4 [ RunTime:0.040433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12991125 ORDER BY `minOrder` ASC [ RunTime:0.027002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12991125 ORDER BY `unit` DESC [ RunTime:0.035161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12991125 LIMIT 2 [ RunTime:0.105808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12991125 ORDER BY `minOrder` ASC [ RunTime:0.006818s ]
select * from pdf where partno='21038814805' and brandshort='HARTING' limit 1 [ RunTime:0.028541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12800412 LIMIT 4 [ RunTime:0.038768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800412 ORDER BY `minOrder` ASC [ RunTime:0.066393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12800412 ORDER BY `unit` DESC [ RunTime:0.043177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12800412 LIMIT 2 [ RunTime:0.027941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800412 ORDER BY `minOrder` ASC [ RunTime:0.007406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063166 LIMIT 4 [ RunTime:0.014429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063166 ORDER BY `minOrder` ASC [ RunTime:0.025718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12063166 ORDER BY `unit` DESC [ RunTime:0.084349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12063166 LIMIT 2 [ RunTime:0.027075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063166 ORDER BY `minOrder` ASC [ RunTime:0.004416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11756077 LIMIT 4 [ RunTime:0.023841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756077 ORDER BY `minOrder` ASC [ RunTime:0.033736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11756077 ORDER BY `unit` DESC [ RunTime:0.071916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11756077 LIMIT 2 [ RunTime:0.022911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756077 ORDER BY `minOrder` ASC [ RunTime:0.005893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34402379 LIMIT 4 [ RunTime:0.008389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402379 ORDER BY `minOrder` ASC [ RunTime:0.010858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34402379 ORDER BY `unit` DESC [ RunTime:0.011737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34402379 LIMIT 2 [ RunTime:0.026075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402379 ORDER BY `minOrder` ASC [ RunTime:0.010784s ]
select * from pdf where partno='21033812824' and brandshort='HARTING' limit 1 [ RunTime:0.006246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033812824' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017599s ]
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.016322s ]