SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001788s ]
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.001702s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003159s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002396s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.001470s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002020s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002538s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000861s ]
UPDATE `stock_search` SET `count` = 2779 , `updatetime` = '2026-06-08 08:13:57' WHERE `partno` = '210' [ RunTime:0.003280s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003119s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000272s ]
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.002478s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003311s ]
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.006901s ]
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 1540,20 [ RunTime:0.077494s ]
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 ('10901019','10900452','10832442','36760627','34404263','34403055','34399140','34281082','33884962','32165176','12618067','12490760','11125438','10833037','10822019','10822018','36875391','36761241','36761195','36761177') ORDER BY FIELD(s.id, 10901019,10900452,10832442,36760627,34404263,34403055,34399140,34281082,33884962,32165176,12618067,12490760,11125438,10833037,10822019,10822018,36875391,36761241,36761195,36761177) [ RunTime:0.050545s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10901019 LIMIT 4 [ RunTime:0.037184s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10901019 ORDER BY `minOrder` ASC [ RunTime:0.015990s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10901019 ORDER BY `unit` DESC [ RunTime:0.018552s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10901019 LIMIT 2 [ RunTime:0.020678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10901019 ORDER BY `minOrder` ASC [ RunTime:0.006809s ]
select * from pdf where partno='21033962402' and brandshort='HARTING' limit 1 [ RunTime:0.059528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10900452 LIMIT 4 [ RunTime:0.050118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10900452 ORDER BY `minOrder` ASC [ RunTime:0.077095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10900452 ORDER BY `unit` DESC [ RunTime:0.023661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10900452 LIMIT 2 [ RunTime:0.038439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10900452 ORDER BY `minOrder` ASC [ RunTime:0.005631s ]
select * from pdf where partno='21033962505' and brandshort='HARTING' limit 1 [ RunTime:0.007005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832442 LIMIT 4 [ RunTime:0.012232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832442 ORDER BY `minOrder` ASC [ RunTime:0.016957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832442 ORDER BY `unit` DESC [ RunTime:0.021138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832442 LIMIT 2 [ RunTime:0.047609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832442 ORDER BY `minOrder` ASC [ RunTime:0.006421s ]
select * from pdf where partno='21033962506' and brandshort='HARTING' limit 1 [ RunTime:0.078321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760627 LIMIT 4 [ RunTime:0.020294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760627 ORDER BY `minOrder` ASC [ RunTime:0.076206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760627 ORDER BY `unit` DESC [ RunTime:0.028947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760627 LIMIT 2 [ RunTime:0.065539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760627 ORDER BY `minOrder` ASC [ RunTime:0.040502s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.104597s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.021210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34404263 LIMIT 4 [ RunTime:0.038620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34404263 ORDER BY `minOrder` ASC [ RunTime:0.065805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34404263 ORDER BY `unit` DESC [ RunTime:0.029675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34404263 LIMIT 2 [ RunTime:0.062374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34404263 ORDER BY `minOrder` ASC [ RunTime:0.014116s ]
select * from pdf where partno='21031112305' and brandshort='HARTING' limit 1 [ RunTime:0.025020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21031112305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.054905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34403055 LIMIT 4 [ RunTime:0.088587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34403055 ORDER BY `minOrder` ASC [ RunTime:0.098276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34403055 ORDER BY `unit` DESC [ RunTime:0.164259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34403055 LIMIT 2 [ RunTime:0.145148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34403055 ORDER BY `minOrder` ASC [ RunTime:0.021119s ]
select * from pdf where partno='2101549-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.022208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101549-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.097788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399140 LIMIT 4 [ RunTime:0.098048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399140 ORDER BY `minOrder` ASC [ RunTime:0.095660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399140 ORDER BY `unit` DESC [ RunTime:0.021618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399140 LIMIT 2 [ RunTime:0.107197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399140 ORDER BY `minOrder` ASC [ RunTime:0.023148s ]
select * from pdf where partno='21033192401' and brandshort='HARTING' limit 1 [ RunTime:0.100150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033192401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.067290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281082 LIMIT 4 [ RunTime:0.145875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281082 ORDER BY `minOrder` ASC [ RunTime:0.129083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281082 ORDER BY `unit` DESC [ RunTime:0.092617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281082 LIMIT 2 [ RunTime:0.123476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281082 ORDER BY `minOrder` ASC [ RunTime:0.090251s ]
select * from pdf where partno='2102318-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.141154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102318-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.106153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884962 LIMIT 4 [ RunTime:0.048271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884962 ORDER BY `minOrder` ASC [ RunTime:0.058184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884962 ORDER BY `unit` DESC [ RunTime:0.102979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884962 LIMIT 2 [ RunTime:0.092988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884962 ORDER BY `minOrder` ASC [ RunTime:0.049135s ]
select * from pdf where partno='2102571-1' and brandshort='WEC' limit 1 [ RunTime:0.109564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102571-1' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.044231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32165176 LIMIT 4 [ RunTime:0.063143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32165176 ORDER BY `minOrder` ASC [ RunTime:0.050304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32165176 ORDER BY `unit` DESC [ RunTime:0.101240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32165176 LIMIT 2 [ RunTime:0.016177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32165176 ORDER BY `minOrder` ASC [ RunTime:0.054401s ]
select * from pdf where partno='21004-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.077781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21004-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.047298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618067 LIMIT 4 [ RunTime:0.056169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618067 ORDER BY `minOrder` ASC [ RunTime:0.085746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618067 ORDER BY `unit` DESC [ RunTime:0.048869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618067 LIMIT 2 [ RunTime:0.036690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618067 ORDER BY `minOrder` ASC [ RunTime:0.018407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12490760 LIMIT 4 [ RunTime:0.046423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12490760 ORDER BY `minOrder` ASC [ RunTime:0.066102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12490760 ORDER BY `unit` DESC [ RunTime:0.022073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12490760 LIMIT 2 [ RunTime:0.387501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12490760 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11125438 LIMIT 4 [ RunTime:0.035576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11125438 ORDER BY `minOrder` ASC [ RunTime:0.197288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11125438 ORDER BY `unit` DESC [ RunTime:0.077387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11125438 LIMIT 2 [ RunTime:0.055526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11125438 ORDER BY `minOrder` ASC [ RunTime:0.045390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10833037 LIMIT 4 [ RunTime:0.132638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10833037 ORDER BY `minOrder` ASC [ RunTime:0.067398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10833037 ORDER BY `unit` DESC [ RunTime:0.060050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10833037 LIMIT 2 [ RunTime:0.082120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10833037 ORDER BY `minOrder` ASC [ RunTime:0.058581s ]
select * from pdf where partno='21033891402' and brandshort='HARTING' limit 1 [ RunTime:0.083265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10822019 LIMIT 4 [ RunTime:0.079633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10822019 ORDER BY `minOrder` ASC [ RunTime:0.045159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10822019 ORDER BY `unit` DESC [ RunTime:0.010514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10822019 LIMIT 2 [ RunTime:0.052968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10822019 ORDER BY `minOrder` ASC [ RunTime:0.048203s ]
select * from pdf where partno='21032821405' and brandshort='HARTING' limit 1 [ RunTime:0.027543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10822018 LIMIT 4 [ RunTime:0.022686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10822018 ORDER BY `minOrder` ASC [ RunTime:0.000930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10822018 ORDER BY `unit` DESC [ RunTime:0.003596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10822018 LIMIT 2 [ RunTime:0.003360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10822018 ORDER BY `minOrder` ASC [ RunTime:0.016895s ]
select * from pdf where partno='21033816410' and brandshort='HARTING' limit 1 [ RunTime:0.004958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36875391 LIMIT 4 [ RunTime:0.013197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36875391 ORDER BY `minOrder` ASC [ RunTime:0.004067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36875391 ORDER BY `unit` DESC [ RunTime:0.008034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36875391 LIMIT 2 [ RunTime:0.011770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36875391 ORDER BY `minOrder` ASC [ RunTime:0.020793s ]
select * from pdf where partno='210-136' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.143884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-136' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.076340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761241 LIMIT 4 [ RunTime:0.018345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761241 ORDER BY `minOrder` ASC [ RunTime:0.016830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761241 ORDER BY `unit` DESC [ RunTime:0.012567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761241 LIMIT 2 [ RunTime:0.010338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761241 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761195 LIMIT 4 [ RunTime:0.010941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761195 ORDER BY `minOrder` ASC [ RunTime:0.002719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761195 ORDER BY `unit` DESC [ RunTime:0.008431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761195 LIMIT 2 [ RunTime:0.015307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761195 ORDER BY `minOrder` ASC [ RunTime:0.012227s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761177 LIMIT 4 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761177 ORDER BY `minOrder` ASC [ RunTime:0.002847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761177 ORDER BY `unit` DESC [ RunTime:0.003338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761177 LIMIT 2 [ RunTime:0.008607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761177 ORDER BY `minOrder` ASC [ RunTime:0.020769s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011575s ]
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.089676s ]