SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001064s ]
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.005819s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001673s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002970s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001972s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.009526s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001791s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005465s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001434s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.022595s ]
UPDATE `stock_search` SET `count` = 1179 , `updatetime` = '2026-06-06 15:16:54' WHERE `partno` = '210' [ RunTime:0.029210s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008553s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.011154s ]
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.009381s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003768s ]
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.016155s ]
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 4820,20 [ RunTime:0.098685s ]
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 ('12014334','12014333','12013998','12013832','12013831','11996032','11989209','11989208','11988052','11987568','11987334','11987289','11987280','11987269','11987228','11987221','11987121','11987035','11986005','11985713') ORDER BY FIELD(s.id, 12014334,12014333,12013998,12013832,12013831,11996032,11989209,11989208,11988052,11987568,11987334,11987289,11987280,11987269,11987228,11987221,11987121,11987035,11986005,11985713) [ RunTime:0.095561s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014334 LIMIT 4 [ RunTime:0.091942s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014334 ORDER BY `minOrder` ASC [ RunTime:0.053186s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014334 ORDER BY `unit` DESC [ RunTime:0.035013s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014334 LIMIT 2 [ RunTime:0.045511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014334 ORDER BY `minOrder` ASC [ RunTime:0.138472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014333 LIMIT 4 [ RunTime:0.119895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014333 ORDER BY `minOrder` ASC [ RunTime:0.002457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014333 ORDER BY `unit` DESC [ RunTime:0.113270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014333 LIMIT 2 [ RunTime:0.102331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014333 ORDER BY `minOrder` ASC [ RunTime:0.044432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013998 LIMIT 4 [ RunTime:0.031881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013998 ORDER BY `minOrder` ASC [ RunTime:0.056886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12013998 ORDER BY `unit` DESC [ RunTime:0.099091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12013998 LIMIT 2 [ RunTime:0.025233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013998 ORDER BY `minOrder` ASC [ RunTime:0.031109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013832 LIMIT 4 [ RunTime:0.051935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013832 ORDER BY `minOrder` ASC [ RunTime:0.029312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12013832 ORDER BY `unit` DESC [ RunTime:0.059880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12013832 LIMIT 2 [ RunTime:0.049701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013832 ORDER BY `minOrder` ASC [ RunTime:0.080584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013831 LIMIT 4 [ RunTime:0.123559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013831 ORDER BY `minOrder` ASC [ RunTime:0.039339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12013831 ORDER BY `unit` DESC [ RunTime:0.029503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12013831 LIMIT 2 [ RunTime:0.095372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013831 ORDER BY `minOrder` ASC [ RunTime:0.039186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996032 LIMIT 4 [ RunTime:0.041361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996032 ORDER BY `minOrder` ASC [ RunTime:0.067268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996032 ORDER BY `unit` DESC [ RunTime:0.081416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996032 LIMIT 2 [ RunTime:0.131684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996032 ORDER BY `minOrder` ASC [ RunTime:0.008638s ]
select * from pdf where partno='2109972' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.066234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989209 LIMIT 4 [ RunTime:0.174215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989209 ORDER BY `minOrder` ASC [ RunTime:0.097595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989209 ORDER BY `unit` DESC [ RunTime:0.097625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989209 LIMIT 2 [ RunTime:0.049261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989209 ORDER BY `minOrder` ASC [ RunTime:0.117854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989208 LIMIT 4 [ RunTime:0.080629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989208 ORDER BY `minOrder` ASC [ RunTime:0.085969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989208 ORDER BY `unit` DESC [ RunTime:0.104012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989208 LIMIT 2 [ RunTime:0.054496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989208 ORDER BY `minOrder` ASC [ RunTime:0.159955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11988052 LIMIT 4 [ RunTime:0.117588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11988052 ORDER BY `minOrder` ASC [ RunTime:0.147296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11988052 ORDER BY `unit` DESC [ RunTime:0.056196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11988052 LIMIT 2 [ RunTime:0.095374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11988052 ORDER BY `minOrder` ASC [ RunTime:0.065431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987568 LIMIT 4 [ RunTime:0.126933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987568 ORDER BY `minOrder` ASC [ RunTime:0.166989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987568 ORDER BY `unit` DESC [ RunTime:0.151953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987568 LIMIT 2 [ RunTime:0.132989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987568 ORDER BY `minOrder` ASC [ RunTime:0.017813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987334 LIMIT 4 [ RunTime:0.130274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987334 ORDER BY `minOrder` ASC [ RunTime:0.054286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987334 ORDER BY `unit` DESC [ RunTime:0.088853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987334 LIMIT 2 [ RunTime:0.047638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987334 ORDER BY `minOrder` ASC [ RunTime:0.043598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987289 LIMIT 4 [ RunTime:0.162620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987289 ORDER BY `minOrder` ASC [ RunTime:0.090028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987289 ORDER BY `unit` DESC [ RunTime:0.059224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987289 LIMIT 2 [ RunTime:0.076618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987289 ORDER BY `minOrder` ASC [ RunTime:0.046775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987280 LIMIT 4 [ RunTime:0.094915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987280 ORDER BY `minOrder` ASC [ RunTime:0.135596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987280 ORDER BY `unit` DESC [ RunTime:0.082441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987280 LIMIT 2 [ RunTime:0.082589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987280 ORDER BY `minOrder` ASC [ RunTime:0.040315s ]
select * from pdf where partno='2108921-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987269 LIMIT 4 [ RunTime:0.022963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987269 ORDER BY `minOrder` ASC [ RunTime:0.017738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987269 ORDER BY `unit` DESC [ RunTime:0.054452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987269 LIMIT 2 [ RunTime:0.030104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987269 ORDER BY `minOrder` ASC [ RunTime:0.031729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987228 LIMIT 4 [ RunTime:0.060489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987228 ORDER BY `minOrder` ASC [ RunTime:0.085459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987228 ORDER BY `unit` DESC [ RunTime:0.028622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987228 LIMIT 2 [ RunTime:0.053601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987228 ORDER BY `minOrder` ASC [ RunTime:0.029468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987221 LIMIT 4 [ RunTime:0.057911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987221 ORDER BY `minOrder` ASC [ RunTime:0.084862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987221 ORDER BY `unit` DESC [ RunTime:0.067848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987221 LIMIT 2 [ RunTime:0.075107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987221 ORDER BY `minOrder` ASC [ RunTime:0.062199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987121 LIMIT 4 [ RunTime:0.041436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987121 ORDER BY `minOrder` ASC [ RunTime:0.059345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987121 ORDER BY `unit` DESC [ RunTime:0.060551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987121 LIMIT 2 [ RunTime:0.046429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987121 ORDER BY `minOrder` ASC [ RunTime:0.005936s ]
select * from pdf where partno='2108923-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.051176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987035 LIMIT 4 [ RunTime:0.033978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987035 ORDER BY `minOrder` ASC [ RunTime:0.030640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987035 ORDER BY `unit` DESC [ RunTime:0.087493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987035 LIMIT 2 [ RunTime:0.097303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987035 ORDER BY `minOrder` ASC [ RunTime:0.020003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11986005 LIMIT 4 [ RunTime:0.020799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986005 ORDER BY `minOrder` ASC [ RunTime:0.057022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11986005 ORDER BY `unit` DESC [ RunTime:0.115205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11986005 LIMIT 2 [ RunTime:0.058636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986005 ORDER BY `minOrder` ASC [ RunTime:0.020830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985713 LIMIT 4 [ RunTime:0.080127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985713 ORDER BY `minOrder` ASC [ RunTime:0.071595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985713 ORDER BY `unit` DESC [ RunTime:0.037442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985713 LIMIT 2 [ RunTime:0.039194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985713 ORDER BY `minOrder` ASC [ RunTime:0.030048s ]
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.008251s ]