SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001387s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.43' , `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=943434999-43&search=1' [ RunTime:0.029007s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001295s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003551s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002696s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.011118s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002401s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.018841s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001443s ]
SELECT * FROM `stock_search` WHERE `partno` = '943434999-43' LIMIT 1 [ RunTime:0.014506s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-28 21:43:29' WHERE `partno` = '943434999-43' [ RunTime:0.011681s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.006583s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032066s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076608s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028740s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387349 LIMIT 5 [ RunTime:0.029302s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387349 ORDER BY `minOrder` ASC [ RunTime:0.057220s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387349 ORDER BY `unit` DESC [ RunTime:0.039303s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.041602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387349 LIMIT 2 [ RunTime:0.018963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387349 ORDER BY `minOrder` ASC [ RunTime:0.039942s ]
select * from pdf where partno='943434999-43' and brandshort='Hirschmann' limit 1 [ RunTime:0.014842s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-43' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.073543s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387349 AND `partno` = '943434999-43' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.042060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32770847 LIMIT 5 [ RunTime:0.043759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770847 ORDER BY `minOrder` ASC [ RunTime:0.106074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32770847 ORDER BY `unit` DESC [ RunTime:0.065690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32770847 LIMIT 2 [ RunTime:0.018910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770847 ORDER BY `minOrder` ASC [ RunTime:0.075531s ]
select * from pdf where partno='943434999-431' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.047070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-431' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.039802s ]
SELECT `id` FROM `stock` WHERE `id` <> 32770847 AND `partno` = '943434999-431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.034067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32768104 LIMIT 5 [ RunTime:0.075890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768104 ORDER BY `minOrder` ASC [ RunTime:0.104166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32768104 ORDER BY `unit` DESC [ RunTime:0.088280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32768104 LIMIT 2 [ RunTime:0.069229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768104 ORDER BY `minOrder` ASC [ RunTime:0.015284s ]
select * from pdf where partno='943434999-433' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.023593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-433' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.058911s ]
SELECT `id` FROM `stock` WHERE `id` <> 32768104 AND `partno` = '943434999-433' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.081807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32764604 LIMIT 5 [ RunTime:0.016432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32764604 ORDER BY `minOrder` ASC [ RunTime:0.108984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32764604 ORDER BY `unit` DESC [ RunTime:0.038970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32764604 LIMIT 2 [ RunTime:0.059831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32764604 ORDER BY `minOrder` ASC [ RunTime:0.004475s ]
select * from pdf where partno='943434999-438' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.056255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-438' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.035624s ]
SELECT `id` FROM `stock` WHERE `id` <> 32764604 AND `partno` = '943434999-438' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.030007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32763732 LIMIT 5 [ RunTime:0.033201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32763732 ORDER BY `minOrder` ASC [ RunTime:0.130255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32763732 ORDER BY `unit` DESC [ RunTime:0.015511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32763732 LIMIT 2 [ RunTime:0.019266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32763732 ORDER BY `minOrder` ASC [ RunTime:0.035855s ]
select * from pdf where partno='943434999-436' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.027837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-436' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.024590s ]
SELECT `id` FROM `stock` WHERE `id` <> 32763732 AND `partno` = '943434999-436' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.073765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32758418 LIMIT 5 [ RunTime:0.039573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758418 ORDER BY `minOrder` ASC [ RunTime:0.058062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32758418 ORDER BY `unit` DESC [ RunTime:0.017138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32758418 LIMIT 2 [ RunTime:0.026633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758418 ORDER BY `minOrder` ASC [ RunTime:0.027803s ]
select * from pdf where partno='943434999-437' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.030817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-437' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.015119s ]
SELECT `id` FROM `stock` WHERE `id` <> 32758418 AND `partno` = '943434999-437' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.104776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32758417 LIMIT 5 [ RunTime:0.105496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758417 ORDER BY `minOrder` ASC [ RunTime:0.087938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32758417 ORDER BY `unit` DESC [ RunTime:0.035632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32758417 LIMIT 2 [ RunTime:0.128719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758417 ORDER BY `minOrder` ASC [ RunTime:0.021559s ]
select * from pdf where partno='943434999-434' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.106810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-434' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.052602s ]
SELECT `id` FROM `stock` WHERE `id` <> 32758417 AND `partno` = '943434999-434' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.046872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32757749 LIMIT 5 [ RunTime:0.035525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32757749 ORDER BY `minOrder` ASC [ RunTime:0.028847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32757749 ORDER BY `unit` DESC [ RunTime:0.051551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32757749 LIMIT 2 [ RunTime:0.043470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32757749 ORDER BY `minOrder` ASC [ RunTime:0.013016s ]
select * from pdf where partno='943434999-435' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.066423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-435' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.031650s ]
SELECT `id` FROM `stock` WHERE `id` <> 32757749 AND `partno` = '943434999-435' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.017573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32755295 LIMIT 5 [ RunTime:0.035499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32755295 ORDER BY `minOrder` ASC [ RunTime:0.035463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32755295 ORDER BY `unit` DESC [ RunTime:0.029613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32755295 LIMIT 2 [ RunTime:0.051129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32755295 ORDER BY `minOrder` ASC [ RunTime:0.007404s ]
select * from pdf where partno='943434999-432' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.028853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-432' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.004274s ]
SELECT `id` FROM `stock` WHERE `id` <> 32755295 AND `partno` = '943434999-432' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.043079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32753881 LIMIT 5 [ RunTime:0.018942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32753881 ORDER BY `minOrder` ASC [ RunTime:0.023103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32753881 ORDER BY `unit` DESC [ RunTime:0.039915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32753881 LIMIT 2 [ RunTime:0.094761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32753881 ORDER BY `minOrder` ASC [ RunTime:0.018934s ]
select * from pdf where partno='943434999-430' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.028034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943434999-430' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.034780s ]
SELECT `id` FROM `stock` WHERE `id` <> 32753881 AND `partno` = '943434999-430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.030266s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018061s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032093s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037422s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018425s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005237s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002887s ]
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 '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016389s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '943434999-43%' OR `brand` LIKE '943434999-43%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031752s ]