SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003681s ]
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=7200-10&search=1' [ RunTime:0.001934s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002292s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002488s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.005793s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002231s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002197s ]
SELECT * FROM `stock_search` WHERE `partno` = '7200-10' LIMIT 1 [ RunTime:0.004391s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-22 21:50:33' WHERE `partno` = '7200-10' [ RunTime:0.005076s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003525s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015084s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237289 LIMIT 5 [ RunTime:0.009188s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237289 ORDER BY `minOrder` ASC [ RunTime:0.022246s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237289 ORDER BY `unit` DESC [ RunTime:0.005085s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237289 LIMIT 2 [ RunTime:0.010218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237289 ORDER BY `minOrder` ASC [ RunTime:0.006255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237208 LIMIT 5 [ RunTime:0.006419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237208 ORDER BY `minOrder` ASC [ RunTime:0.008538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237208 ORDER BY `unit` DESC [ RunTime:0.008991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237208 LIMIT 2 [ RunTime:0.002828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237208 ORDER BY `minOrder` ASC [ RunTime:0.024300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237067 LIMIT 5 [ RunTime:0.017993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237067 ORDER BY `minOrder` ASC [ RunTime:0.031382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237067 ORDER BY `unit` DESC [ RunTime:0.022368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237067 LIMIT 2 [ RunTime:0.042702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237067 ORDER BY `minOrder` ASC [ RunTime:0.033124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12187008 LIMIT 5 [ RunTime:0.012735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12187008 ORDER BY `minOrder` ASC [ RunTime:0.009285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12187008 ORDER BY `unit` DESC [ RunTime:0.016764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12187008 LIMIT 2 [ RunTime:0.015287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12187008 ORDER BY `minOrder` ASC [ RunTime:0.014484s ]
select * from pdf where partno='7200-10' and brandshort='3M' limit 1 [ RunTime:0.016738s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049236s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63223802 LIMIT 5 [ RunTime:0.020671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223802 ORDER BY `minOrder` ASC [ RunTime:0.002705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63223802 ORDER BY `unit` DESC [ RunTime:0.013351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63223802 LIMIT 2 [ RunTime:0.007449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223802 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='7200-106-25' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.003298s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-25' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.011413s ]
SELECT `id` FROM `stock` WHERE `id` <> 63223802 AND `partno` = '7200-106-25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.002949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63223753 LIMIT 5 [ RunTime:0.017955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223753 ORDER BY `minOrder` ASC [ RunTime:0.019730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63223753 ORDER BY `unit` DESC [ RunTime:0.018476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63223753 LIMIT 2 [ RunTime:0.021185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223753 ORDER BY `minOrder` ASC [ RunTime:0.007160s ]
select * from pdf where partno='7200-106-30' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.003760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-30' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.006889s ]
SELECT `id` FROM `stock` WHERE `id` <> 63223753 AND `partno` = '7200-106-30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.037842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63223522 LIMIT 5 [ RunTime:0.037160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223522 ORDER BY `minOrder` ASC [ RunTime:0.042349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63223522 ORDER BY `unit` DESC [ RunTime:0.037888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63223522 LIMIT 2 [ RunTime:0.041143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223522 ORDER BY `minOrder` ASC [ RunTime:0.005846s ]
select * from pdf where partno='7200-106-20' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.042469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-20' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.004266s ]
SELECT `id` FROM `stock` WHERE `id` <> 63223522 AND `partno` = '7200-106-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.024396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63223521 LIMIT 5 [ RunTime:0.027215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223521 ORDER BY `minOrder` ASC [ RunTime:0.015249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63223521 ORDER BY `unit` DESC [ RunTime:0.011331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63223521 LIMIT 2 [ RunTime:0.005589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223521 ORDER BY `minOrder` ASC [ RunTime:0.004220s ]
select * from pdf where partno='7200-106-70' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.015965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-70' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.019343s ]
SELECT `id` FROM `stock` WHERE `id` <> 63223521 AND `partno` = '7200-106-70' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63223447 LIMIT 5 [ RunTime:0.012301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223447 ORDER BY `minOrder` ASC [ RunTime:0.023724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63223447 ORDER BY `unit` DESC [ RunTime:0.025800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63223447 LIMIT 2 [ RunTime:0.005377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63223447 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='7200-106-10M' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.017823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-10M' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.023602s ]
SELECT `id` FROM `stock` WHERE `id` <> 63223447 AND `partno` = '7200-106-10M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.043620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63213047 LIMIT 5 [ RunTime:0.027644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213047 ORDER BY `minOrder` ASC [ RunTime:0.013800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63213047 ORDER BY `unit` DESC [ RunTime:0.034749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63213047 LIMIT 2 [ RunTime:0.030931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213047 ORDER BY `minOrder` ASC [ RunTime:0.031592s ]
select * from pdf where partno='7200-106-100' and brandshort='Honeywell Sensing and Productivity Solutions T&M' limit 1 [ RunTime:0.013581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-100' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions T&M%' ) ) LIMIT 1 [ RunTime:0.029039s ]
SELECT `id` FROM `stock` WHERE `id` <> 63213047 AND `partno` = '7200-106-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions t&m%' ) [ RunTime:0.053585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237289 [ RunTime:0.024790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63211810 LIMIT 5 [ RunTime:0.012231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63211810 ORDER BY `minOrder` ASC [ RunTime:0.016548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63211810 ORDER BY `unit` DESC [ RunTime:0.020746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63211810 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63211810 ORDER BY `minOrder` ASC [ RunTime:0.025812s ]
select * from pdf where partno='7200-106-50' and brandshort='Honeywell Sensing and Productivity Solutions T&M' limit 1 [ RunTime:0.005712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-50' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions T&M%' ) ) LIMIT 1 [ RunTime:0.017744s ]
SELECT `id` FROM `stock` WHERE `id` <> 63211810 AND `partno` = '7200-106-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions t&m%' ) [ RunTime:0.016911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237208 [ RunTime:0.010475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63211801 LIMIT 5 [ RunTime:0.010535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63211801 ORDER BY `minOrder` ASC [ RunTime:0.036566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63211801 ORDER BY `unit` DESC [ RunTime:0.026766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63211801 LIMIT 2 [ RunTime:0.030562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63211801 ORDER BY `minOrder` ASC [ RunTime:0.014531s ]
select * from pdf where partno='7200-106-15' and brandshort='Honeywell Sensing and Productivity Solutions T&M' limit 1 [ RunTime:0.018194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7200-106-15' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions T&M%' ) ) LIMIT 1 [ RunTime:0.029173s ]
SELECT `id` FROM `stock` WHERE `id` <> 63211801 AND `partno` = '7200-106-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions t&m%' ) [ RunTime:0.023414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237067 [ RunTime:0.020511s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041785s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013516s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037669s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020981s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009991s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068709s ]
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 '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064783s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7200-10%' OR `brand` LIKE '7200-10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.047400s ]