SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001263s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.222' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=21029&search=1' [ RunTime:0.056178s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002333s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.058268s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001440s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.222' ) [ RunTime:0.054328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001606s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.050022s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001778s ]
SELECT * FROM `stock_search` WHERE `partno` = '21029' LIMIT 1 [ RunTime:0.058850s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-31 00:11:18' WHERE `partno` = '21029' [ RunTime:0.018455s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002790s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.105867s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.083004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754594 LIMIT 5 [ RunTime:0.069589s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754594 ORDER BY `minOrder` ASC [ RunTime:0.042230s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754594 ORDER BY `unit` DESC [ RunTime:0.073208s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754594 LIMIT 2 [ RunTime:0.049670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754594 ORDER BY `minOrder` ASC [ RunTime:0.050705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753866 LIMIT 5 [ RunTime:0.025823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753866 ORDER BY `minOrder` ASC [ RunTime:0.037835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753866 ORDER BY `unit` DESC [ RunTime:0.096098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753866 LIMIT 2 [ RunTime:0.036913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753866 ORDER BY `minOrder` ASC [ RunTime:0.060730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753863 LIMIT 5 [ RunTime:0.057212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753863 ORDER BY `minOrder` ASC [ RunTime:0.029049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753863 ORDER BY `unit` DESC [ RunTime:0.036946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753863 LIMIT 2 [ RunTime:0.055769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753863 ORDER BY `minOrder` ASC [ RunTime:0.068209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753856 LIMIT 5 [ RunTime:0.092915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753856 ORDER BY `minOrder` ASC [ RunTime:0.041615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753856 ORDER BY `unit` DESC [ RunTime:0.094471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753856 LIMIT 2 [ RunTime:0.118650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753856 ORDER BY `minOrder` ASC [ RunTime:0.026481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17006216 LIMIT 5 [ RunTime:0.035844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006216 ORDER BY `minOrder` ASC [ RunTime:0.017845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17006216 ORDER BY `unit` DESC [ RunTime:0.021125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17006216 LIMIT 2 [ RunTime:0.040725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006216 ORDER BY `minOrder` ASC [ RunTime:0.017516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175356 LIMIT 5 [ RunTime:0.041374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.049107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175356 ORDER BY `unit` DESC [ RunTime:0.034226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175356 LIMIT 2 [ RunTime:0.069954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.034007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12262595 LIMIT 5 [ RunTime:0.091426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262595 ORDER BY `minOrder` ASC [ RunTime:0.031220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12262595 ORDER BY `unit` DESC [ RunTime:0.104800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12262595 LIMIT 2 [ RunTime:0.042454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262595 ORDER BY `minOrder` ASC [ RunTime:0.021569s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028775s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60309874 LIMIT 5 [ RunTime:0.010005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60309874 ORDER BY `minOrder` ASC [ RunTime:0.075546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60309874 ORDER BY `unit` DESC [ RunTime:0.057411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60309874 LIMIT 2 [ RunTime:0.064649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60309874 ORDER BY `minOrder` ASC [ RunTime:0.007374s ]
select * from pdf where partno='2102995-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020394s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102995-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.028281s ]
SELECT `id` FROM `stock` WHERE `id` <> 60309874 AND `partno` = '2102995-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.037399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175356 [ RunTime:0.011785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44010610 LIMIT 5 [ RunTime:0.025894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010610 ORDER BY `minOrder` ASC [ RunTime:0.025383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44010610 ORDER BY `unit` DESC [ RunTime:0.023401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44010610 LIMIT 2 [ RunTime:0.018036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010610 ORDER BY `minOrder` ASC [ RunTime:0.004194s ]
select * from pdf where partno='21029-9' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.016931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21029-9' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004544s ]
SELECT `id` FROM `stock` WHERE `id` <> 44010610 AND `partno` = '21029-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.009934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754594 [ RunTime:0.004038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32369933 LIMIT 5 [ RunTime:0.009515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32369933 ORDER BY `minOrder` ASC [ RunTime:0.029299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32369933 ORDER BY `unit` DESC [ RunTime:0.024120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32369933 LIMIT 2 [ RunTime:0.007275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32369933 ORDER BY `minOrder` ASC [ RunTime:0.003310s ]
select * from pdf where partno='21029' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.045595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21029' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.002680s ]
SELECT `id` FROM `stock` WHERE `id` <> 32369933 AND `partno` = '21029' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.018332s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041540s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006568s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008646s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013593s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044329s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038240s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035595s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21029%' OR `brand` LIKE '21029%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003886s ]