SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003397s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.142' , `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=JTS08RE-24-19P&search=1' [ RunTime:0.002930s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002453s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000748s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001337s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.005549s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001542s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002544s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001251s ]
SELECT * FROM `stock_search` WHERE `partno` = 'JTS08RE-24-19P' LIMIT 1 [ RunTime:0.007233s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-02 04:30:15' WHERE `partno` = 'JTS08RE-24-19P' [ RunTime:0.003252s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001202s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011971s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015899s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017619s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55048768 LIMIT 5 [ RunTime:0.002524s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55048768 ORDER BY `minOrder` ASC [ RunTime:0.030395s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55048768 ORDER BY `unit` DESC [ RunTime:0.003211s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55048768 LIMIT 2 [ RunTime:0.012829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55048768 ORDER BY `minOrder` ASC [ RunTime:0.001500s ]
select * from pdf where partno='JTS08RE-24-19P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015852s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.014919s ]
SELECT `id` FROM `stock` WHERE `id` <> 55048768 AND `partno` = 'JTS08RE-24-19P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.052258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55048764 LIMIT 5 [ RunTime:0.027666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55048764 ORDER BY `minOrder` ASC [ RunTime:0.018371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55048764 ORDER BY `unit` DESC [ RunTime:0.042760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55048764 LIMIT 2 [ RunTime:0.008181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55048764 ORDER BY `minOrder` ASC [ RunTime:0.009471s ]
select * from pdf where partno='JTS08RE-24-19PB(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PB(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.048761s ]
SELECT `id` FROM `stock` WHERE `id` <> 55048764 AND `partno` = 'JTS08RE-24-19PB(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.087906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55048763 LIMIT 5 [ RunTime:0.037345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55048763 ORDER BY `minOrder` ASC [ RunTime:0.053068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55048763 ORDER BY `unit` DESC [ RunTime:0.027930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55048763 LIMIT 2 [ RunTime:0.037102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55048763 ORDER BY `minOrder` ASC [ RunTime:0.018032s ]
select * from pdf where partno='JTS08RE-24-19PB' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.034895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PB' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.037267s ]
SELECT `id` FROM `stock` WHERE `id` <> 55048763 AND `partno` = 'JTS08RE-24-19PB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.031953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039610 LIMIT 5 [ RunTime:0.015219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039610 ORDER BY `minOrder` ASC [ RunTime:0.059989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039610 ORDER BY `unit` DESC [ RunTime:0.016579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039610 LIMIT 2 [ RunTime:0.053917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039610 ORDER BY `minOrder` ASC [ RunTime:0.004681s ]
select * from pdf where partno='JTS08RE-24-19P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.036493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.024649s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039610 AND `partno` = 'JTS08RE-24-19P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.053521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232999 [ RunTime:0.044020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039584 LIMIT 5 [ RunTime:0.033858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039584 ORDER BY `minOrder` ASC [ RunTime:0.055180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039584 ORDER BY `unit` DESC [ RunTime:0.032293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039584 LIMIT 2 [ RunTime:0.027335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039584 ORDER BY `minOrder` ASC [ RunTime:0.048401s ]
select * from pdf where partno='JTS08RE-24-19PC' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.021269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PC' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.052886s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039584 AND `partno` = 'JTS08RE-24-19PC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232966 [ RunTime:0.082107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039583 LIMIT 5 [ RunTime:0.045015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039583 ORDER BY `minOrder` ASC [ RunTime:0.076282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039583 ORDER BY `unit` DESC [ RunTime:0.035481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039583 LIMIT 2 [ RunTime:0.013256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039583 ORDER BY `minOrder` ASC [ RunTime:0.045358s ]
select * from pdf where partno='JTS08RE-24-19PC(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PC(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.098177s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039583 AND `partno` = 'JTS08RE-24-19PC(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.048712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232965 [ RunTime:0.064512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039582 LIMIT 5 [ RunTime:0.041151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039582 ORDER BY `minOrder` ASC [ RunTime:0.010091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039582 ORDER BY `unit` DESC [ RunTime:0.031395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039582 LIMIT 2 [ RunTime:0.019544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039582 ORDER BY `minOrder` ASC [ RunTime:0.007991s ]
select * from pdf where partno='JTS08RE-24-19PD(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.038262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PD(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.040170s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039582 AND `partno` = 'JTS08RE-24-19PD(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.039069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232964 [ RunTime:0.010282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039581 LIMIT 5 [ RunTime:0.037833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039581 ORDER BY `minOrder` ASC [ RunTime:0.004173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039581 ORDER BY `unit` DESC [ RunTime:0.038265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039581 LIMIT 2 [ RunTime:0.024075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039581 ORDER BY `minOrder` ASC [ RunTime:0.010705s ]
select * from pdf where partno='JTS08RE-24-19PD' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.032502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PD' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.031262s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039581 AND `partno` = 'JTS08RE-24-19PD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.032831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35179157 [ RunTime:0.024564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039529 LIMIT 5 [ RunTime:0.026428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039529 ORDER BY `minOrder` ASC [ RunTime:0.036054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039529 ORDER BY `unit` DESC [ RunTime:0.026121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039529 LIMIT 2 [ RunTime:0.011735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039529 ORDER BY `minOrder` ASC [ RunTime:0.010538s ]
select * from pdf where partno='JTS08RE-24-19PA(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.029677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PA(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.027788s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039529 AND `partno` = 'JTS08RE-24-19PA(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.020898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232921 [ RunTime:0.019539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039528 LIMIT 5 [ RunTime:0.011589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039528 ORDER BY `minOrder` ASC [ RunTime:0.016726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48039528 ORDER BY `unit` DESC [ RunTime:0.028895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48039528 LIMIT 2 [ RunTime:0.017286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48039528 ORDER BY `minOrder` ASC [ RunTime:0.008650s ]
select * from pdf where partno='JTS08RE-24-19PA' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.034838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PA' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.049315s ]
SELECT `id` FROM `stock` WHERE `id` <> 48039528 AND `partno` = 'JTS08RE-24-19PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.017850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232920 [ RunTime:0.030484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232999 LIMIT 5 [ RunTime:0.016265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232999 ORDER BY `minOrder` ASC [ RunTime:0.027074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35232999 ORDER BY `unit` DESC [ RunTime:0.041528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35232999 LIMIT 2 [ RunTime:0.024741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232999 ORDER BY `minOrder` ASC [ RunTime:0.022336s ]
select * from pdf where partno='JTS08RE-24-19P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002393s ]
SELECT `id` FROM `stock` WHERE `id` <> 35232999 AND `partno` = 'JTS08RE-24-19P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.020713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039610 [ RunTime:0.027485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232966 LIMIT 5 [ RunTime:0.043723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232966 ORDER BY `minOrder` ASC [ RunTime:0.014746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35232966 ORDER BY `unit` DESC [ RunTime:0.022787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35232966 LIMIT 2 [ RunTime:0.014964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232966 ORDER BY `minOrder` ASC [ RunTime:0.023079s ]
select * from pdf where partno='JTS08RE-24-19PC' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PC' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003182s ]
SELECT `id` FROM `stock` WHERE `id` <> 35232966 AND `partno` = 'JTS08RE-24-19PC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039584 [ RunTime:0.013867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232965 LIMIT 5 [ RunTime:0.022516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232965 ORDER BY `minOrder` ASC [ RunTime:0.010523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35232965 ORDER BY `unit` DESC [ RunTime:0.023296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35232965 LIMIT 2 [ RunTime:0.030331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232965 ORDER BY `minOrder` ASC [ RunTime:0.020779s ]
select * from pdf where partno='JTS08RE-24-19PC(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.021277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PC(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.013486s ]
SELECT `id` FROM `stock` WHERE `id` <> 35232965 AND `partno` = 'JTS08RE-24-19PC(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.064673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039583 [ RunTime:0.043028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232964 LIMIT 5 [ RunTime:0.104387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232964 ORDER BY `minOrder` ASC [ RunTime:0.032563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35232964 ORDER BY `unit` DESC [ RunTime:0.029191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35232964 LIMIT 2 [ RunTime:0.083433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232964 ORDER BY `minOrder` ASC [ RunTime:0.009429s ]
select * from pdf where partno='JTS08RE-24-19PD(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PD(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.014691s ]
SELECT `id` FROM `stock` WHERE `id` <> 35232964 AND `partno` = 'JTS08RE-24-19PD(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.016981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039582 [ RunTime:0.019936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232921 LIMIT 5 [ RunTime:0.057388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232921 ORDER BY `minOrder` ASC [ RunTime:0.031525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35232921 ORDER BY `unit` DESC [ RunTime:0.093576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35232921 LIMIT 2 [ RunTime:0.035328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232921 ORDER BY `minOrder` ASC [ RunTime:0.069583s ]
select * from pdf where partno='JTS08RE-24-19PA(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PA(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004873s ]
SELECT `id` FROM `stock` WHERE `id` <> 35232921 AND `partno` = 'JTS08RE-24-19PA(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039529 [ RunTime:0.069670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35232920 LIMIT 5 [ RunTime:0.054954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232920 ORDER BY `minOrder` ASC [ RunTime:0.012257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35232920 ORDER BY `unit` DESC [ RunTime:0.041559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35232920 LIMIT 2 [ RunTime:0.013441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35232920 ORDER BY `minOrder` ASC [ RunTime:0.015365s ]
select * from pdf where partno='JTS08RE-24-19PA' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PA' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010449s ]
SELECT `id` FROM `stock` WHERE `id` <> 35232920 AND `partno` = 'JTS08RE-24-19PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.044910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039528 [ RunTime:0.017321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35179157 LIMIT 5 [ RunTime:0.033554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35179157 ORDER BY `minOrder` ASC [ RunTime:0.038600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35179157 ORDER BY `unit` DESC [ RunTime:0.054803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35179157 LIMIT 2 [ RunTime:0.050341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35179157 ORDER BY `minOrder` ASC [ RunTime:0.020312s ]
select * from pdf where partno='JTS08RE-24-19PD' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.021804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JTS08RE-24-19PD' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009673s ]
SELECT `id` FROM `stock` WHERE `id` <> 35179157 AND `partno` = 'JTS08RE-24-19PD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.057230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48039581 [ RunTime:0.016579s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025081s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052942s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044983s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032919s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068642s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020580s ]
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 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052195s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JTS08RE-24-19P%' OR `brand` LIKE 'JTS08RE-24-19P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026120s ]