SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002445s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=1905036&search=1' [ RunTime:0.006657s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001067s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009283s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001449s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.015184s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002385s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012903s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002984s ]
SELECT * FROM `stock_search` WHERE `partno` = '1905036' LIMIT 1 [ RunTime:0.050974s ]
UPDATE `stock_search` SET `count` = 11 , `updatetime` = '2026-08-28 19:06:35' WHERE `partno` = '1905036' [ RunTime:0.005068s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002667s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042407s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15254041 LIMIT 5 [ RunTime:0.014554s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15254041 ORDER BY `minOrder` ASC [ RunTime:0.047799s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15254041 ORDER BY `unit` DESC [ RunTime:0.023305s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15254041 LIMIT 2 [ RunTime:0.035317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15254041 ORDER BY `minOrder` ASC [ RunTime:0.006313s ]
select * from pdf where partno='19050361' and brandshort='EAO' limit 1 [ RunTime:0.029224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15254040 LIMIT 5 [ RunTime:0.019820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15254040 ORDER BY `minOrder` ASC [ RunTime:0.100502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15254040 ORDER BY `unit` DESC [ RunTime:0.055477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15254040 LIMIT 2 [ RunTime:0.128969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15254040 ORDER BY `minOrder` ASC [ RunTime:0.018715s ]
select * from pdf where partno='19050362' and brandshort='EAO' limit 1 [ RunTime:0.090963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15254042 LIMIT 5 [ RunTime:0.017659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15254042 ORDER BY `minOrder` ASC [ RunTime:0.027990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15254042 ORDER BY `unit` DESC [ RunTime:0.036283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15254042 LIMIT 2 [ RunTime:0.071415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15254042 ORDER BY `minOrder` ASC [ RunTime:0.042632s ]
select * from pdf where partno='19050360' and brandshort='EAO' limit 1 [ RunTime:0.025436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16015283 LIMIT 5 [ RunTime:0.066662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16015283 ORDER BY `minOrder` ASC [ RunTime:0.098712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16015283 ORDER BY `unit` DESC [ RunTime:0.062961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16015283 LIMIT 2 [ RunTime:0.108693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16015283 ORDER BY `minOrder` ASC [ RunTime:0.054151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12555426 LIMIT 5 [ RunTime:0.053029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555426 ORDER BY `minOrder` ASC [ RunTime:0.065227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12555426 ORDER BY `unit` DESC [ RunTime:0.028617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12555426 LIMIT 2 [ RunTime:0.110998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555426 ORDER BY `minOrder` ASC [ RunTime:0.137699s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060128s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.208121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41373898 LIMIT 5 [ RunTime:0.084188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41373898 ORDER BY `minOrder` ASC [ RunTime:0.076131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41373898 ORDER BY `unit` DESC [ RunTime:0.065644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41373898 LIMIT 2 [ RunTime:0.177637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41373898 ORDER BY `minOrder` ASC [ RunTime:0.061380s ]
select * from pdf where partno='19050362' and brandshort='EAO' limit 1 [ RunTime:0.038426s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19050362' OR `brand` LIKE 'EAO%' ) ) LIMIT 1 [ RunTime:0.078432s ]
SELECT `id` FROM `stock` WHERE `id` <> 41373898 AND `partno` = '19050362' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eao%' ) [ RunTime:0.102066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15254040 [ RunTime:0.040787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41372875 LIMIT 5 [ RunTime:0.100845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41372875 ORDER BY `minOrder` ASC [ RunTime:0.053187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41372875 ORDER BY `unit` DESC [ RunTime:0.049682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41372875 LIMIT 2 [ RunTime:0.047366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41372875 ORDER BY `minOrder` ASC [ RunTime:0.020484s ]
select * from pdf where partno='19050361' and brandshort='EAO' limit 1 [ RunTime:0.018576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19050361' OR `brand` LIKE 'EAO%' ) ) LIMIT 1 [ RunTime:0.043945s ]
SELECT `id` FROM `stock` WHERE `id` <> 41372875 AND `partno` = '19050361' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eao%' ) [ RunTime:0.023667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15254041 [ RunTime:0.027949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41373905 LIMIT 5 [ RunTime:0.017035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41373905 ORDER BY `minOrder` ASC [ RunTime:0.049162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41373905 ORDER BY `unit` DESC [ RunTime:0.018524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41373905 LIMIT 2 [ RunTime:0.011540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41373905 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='19050360' and brandshort='EAO' limit 1 [ RunTime:0.021444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19050360' OR `brand` LIKE 'EAO%' ) ) LIMIT 1 [ RunTime:0.003797s ]
SELECT `id` FROM `stock` WHERE `id` <> 41373905 AND `partno` = '19050360' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eao%' ) [ RunTime:0.012423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15254042 [ RunTime:0.016215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41392798 LIMIT 5 [ RunTime:0.079533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41392798 ORDER BY `minOrder` ASC [ RunTime:0.006185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41392798 ORDER BY `unit` DESC [ RunTime:0.012993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41392798 LIMIT 2 [ RunTime:0.035267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41392798 ORDER BY `minOrder` ASC [ RunTime:0.004395s ]
select * from pdf where partno='19050367' and brandshort='EAO' limit 1 [ RunTime:0.016095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19050367' OR `brand` LIKE 'EAO%' ) ) LIMIT 1 [ RunTime:0.013152s ]
SELECT `id` FROM `stock` WHERE `id` <> 41392798 AND `partno` = '19050367' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eao%' ) [ RunTime:0.012415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16015283 [ RunTime:0.073935s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058688s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066237s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065233s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061075s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118436s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027326s ]
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 '1905036%' OR `brand` LIKE '1905036%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053328s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1905036%' OR `brand` LIKE '1905036%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.116533s ]