SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001649s ]
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=HW4F-3&search=1' [ RunTime:0.010550s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001530s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010005s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001670s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.005742s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002532s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008393s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001521s ]
SELECT * FROM `stock_search` WHERE `partno` = 'HW4F-3' LIMIT 1 [ RunTime:0.029625s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-20 08:27:29' WHERE `partno` = 'HW4F-3' [ RunTime:0.021520s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001441s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034361s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479068 LIMIT 5 [ RunTime:0.016206s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479068 ORDER BY `minOrder` ASC [ RunTime:0.031026s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479068 ORDER BY `unit` DESC [ RunTime:0.062994s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479068 LIMIT 2 [ RunTime:0.010334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479068 ORDER BY `minOrder` ASC [ RunTime:0.009943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479067 LIMIT 5 [ RunTime:0.017375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479067 ORDER BY `minOrder` ASC [ RunTime:0.006969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479067 ORDER BY `unit` DESC [ RunTime:0.025686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479067 LIMIT 2 [ RunTime:0.011611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479067 ORDER BY `minOrder` ASC [ RunTime:0.013833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479063 LIMIT 5 [ RunTime:0.016969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479063 ORDER BY `minOrder` ASC [ RunTime:0.041793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479063 ORDER BY `unit` DESC [ RunTime:0.055925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479063 LIMIT 2 [ RunTime:0.021013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479063 ORDER BY `minOrder` ASC [ RunTime:0.035172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479062 LIMIT 5 [ RunTime:0.077625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479062 ORDER BY `minOrder` ASC [ RunTime:0.089816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479062 ORDER BY `unit` DESC [ RunTime:0.057883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479062 LIMIT 2 [ RunTime:0.049292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479062 ORDER BY `minOrder` ASC [ RunTime:0.025362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479061 LIMIT 5 [ RunTime:0.064390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479061 ORDER BY `minOrder` ASC [ RunTime:0.082316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479061 ORDER BY `unit` DESC [ RunTime:0.046778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479061 LIMIT 2 [ RunTime:0.011163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479061 ORDER BY `minOrder` ASC [ RunTime:0.031095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479056 LIMIT 5 [ RunTime:0.012330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479056 ORDER BY `minOrder` ASC [ RunTime:0.023200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479056 ORDER BY `unit` DESC [ RunTime:0.055414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479056 LIMIT 2 [ RunTime:0.036110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479056 ORDER BY `minOrder` ASC [ RunTime:0.004899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479052 LIMIT 5 [ RunTime:0.025769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479052 ORDER BY `minOrder` ASC [ RunTime:0.031704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479052 ORDER BY `unit` DESC [ RunTime:0.004019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479052 LIMIT 2 [ RunTime:0.029955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479052 ORDER BY `minOrder` ASC [ RunTime:0.005238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479049 LIMIT 5 [ RunTime:0.011822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479049 ORDER BY `minOrder` ASC [ RunTime:0.005928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479049 ORDER BY `unit` DESC [ RunTime:0.004929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479049 LIMIT 2 [ RunTime:0.030934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479049 ORDER BY `minOrder` ASC [ RunTime:0.015772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479048 LIMIT 5 [ RunTime:0.007421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479048 ORDER BY `minOrder` ASC [ RunTime:0.021314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479048 ORDER BY `unit` DESC [ RunTime:0.023295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479048 LIMIT 2 [ RunTime:0.030125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479048 ORDER BY `minOrder` ASC [ RunTime:0.014794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479047 LIMIT 5 [ RunTime:0.012112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479047 ORDER BY `minOrder` ASC [ RunTime:0.012277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479047 ORDER BY `unit` DESC [ RunTime:0.007598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479047 LIMIT 2 [ RunTime:0.009859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479047 ORDER BY `minOrder` ASC [ RunTime:0.012376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479045 LIMIT 5 [ RunTime:0.007720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479045 ORDER BY `minOrder` ASC [ RunTime:0.022868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479045 ORDER BY `unit` DESC [ RunTime:0.030285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479045 LIMIT 2 [ RunTime:0.002680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479045 ORDER BY `minOrder` ASC [ RunTime:0.006307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479043 LIMIT 5 [ RunTime:0.008280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479043 ORDER BY `minOrder` ASC [ RunTime:0.005399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479043 ORDER BY `unit` DESC [ RunTime:0.019024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479043 LIMIT 2 [ RunTime:0.004936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479043 ORDER BY `minOrder` ASC [ RunTime:0.008225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479039 LIMIT 5 [ RunTime:0.019457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479039 ORDER BY `minOrder` ASC [ RunTime:0.008822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479039 ORDER BY `unit` DESC [ RunTime:0.011989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479039 LIMIT 2 [ RunTime:0.007858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479039 ORDER BY `minOrder` ASC [ RunTime:0.005723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479035 LIMIT 5 [ RunTime:0.001749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479035 ORDER BY `minOrder` ASC [ RunTime:0.012677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479035 ORDER BY `unit` DESC [ RunTime:0.042591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479035 LIMIT 2 [ RunTime:0.008279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479035 ORDER BY `minOrder` ASC [ RunTime:0.008645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479034 LIMIT 5 [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479034 ORDER BY `minOrder` ASC [ RunTime:0.033015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479034 ORDER BY `unit` DESC [ RunTime:0.039158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479034 LIMIT 2 [ RunTime:0.031414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479034 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479032 LIMIT 5 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479032 ORDER BY `minOrder` ASC [ RunTime:0.014721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479032 ORDER BY `unit` DESC [ RunTime:0.034315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479032 LIMIT 2 [ RunTime:0.032327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479032 ORDER BY `minOrder` ASC [ RunTime:0.018605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479031 LIMIT 5 [ RunTime:0.049047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479031 ORDER BY `minOrder` ASC [ RunTime:0.034786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479031 ORDER BY `unit` DESC [ RunTime:0.017255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479031 LIMIT 2 [ RunTime:0.004178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479031 ORDER BY `minOrder` ASC [ RunTime:0.020671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479030 LIMIT 5 [ RunTime:0.008397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479030 ORDER BY `minOrder` ASC [ RunTime:0.047767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479030 ORDER BY `unit` DESC [ RunTime:0.023505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479030 LIMIT 2 [ RunTime:0.020213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479030 ORDER BY `minOrder` ASC [ RunTime:0.008926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479029 LIMIT 5 [ RunTime:0.035275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479029 ORDER BY `minOrder` ASC [ RunTime:0.067215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479029 ORDER BY `unit` DESC [ RunTime:0.018868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479029 LIMIT 2 [ RunTime:0.027640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479029 ORDER BY `minOrder` ASC [ RunTime:0.015698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12479028 LIMIT 5 [ RunTime:0.014140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479028 ORDER BY `minOrder` ASC [ RunTime:0.021477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12479028 ORDER BY `unit` DESC [ RunTime:0.120624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12479028 LIMIT 2 [ RunTime:0.031421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12479028 ORDER BY `minOrder` ASC [ RunTime:0.020660s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060105s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449706 LIMIT 5 [ RunTime:0.030588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449706 ORDER BY `minOrder` ASC [ RunTime:0.009489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449706 ORDER BY `unit` DESC [ RunTime:0.008534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449706 LIMIT 2 [ RunTime:0.002401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449706 ORDER BY `minOrder` ASC [ RunTime:0.002055s ]
select * from pdf where partno='HW4F-31A-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-31A-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.010146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449705 LIMIT 5 [ RunTime:0.031661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449705 ORDER BY `minOrder` ASC [ RunTime:0.014014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449705 ORDER BY `unit` DESC [ RunTime:0.025274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449705 LIMIT 2 [ RunTime:0.019824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449705 ORDER BY `minOrder` ASC [ RunTime:0.013610s ]
select * from pdf where partno='HW4F-33S-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.015471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-33S-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.016335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449704 LIMIT 5 [ RunTime:0.030574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449704 ORDER BY `minOrder` ASC [ RunTime:0.027088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449704 ORDER BY `unit` DESC [ RunTime:0.020548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449704 LIMIT 2 [ RunTime:0.011519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449704 ORDER BY `minOrder` ASC [ RunTime:0.011020s ]
select * from pdf where partno='HW4F-33G-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.026972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-33G-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.018134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449702 LIMIT 5 [ RunTime:0.047880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449702 ORDER BY `minOrder` ASC [ RunTime:0.028926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449702 ORDER BY `unit` DESC [ RunTime:0.027505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449702 LIMIT 2 [ RunTime:0.090209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449702 ORDER BY `minOrder` ASC [ RunTime:0.050263s ]
select * from pdf where partno='HW4F-33Y-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.022261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-33Y-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.049274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449701 LIMIT 5 [ RunTime:0.088514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449701 ORDER BY `minOrder` ASC [ RunTime:0.061954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449701 ORDER BY `unit` DESC [ RunTime:0.074269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449701 LIMIT 2 [ RunTime:0.048131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449701 ORDER BY `minOrder` ASC [ RunTime:0.014634s ]
select * from pdf where partno='HW4F-33PW-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.049815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-33PW-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.051526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449700 LIMIT 5 [ RunTime:0.014277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449700 ORDER BY `minOrder` ASC [ RunTime:0.033420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449700 ORDER BY `unit` DESC [ RunTime:0.090125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449700 LIMIT 2 [ RunTime:0.030084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449700 ORDER BY `minOrder` ASC [ RunTime:0.045108s ]
select * from pdf where partno='HW4F-33R-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.052642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-33R-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.047531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449696 LIMIT 5 [ RunTime:0.030094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449696 ORDER BY `minOrder` ASC [ RunTime:0.031538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449696 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449696 LIMIT 2 [ RunTime:0.059228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449696 ORDER BY `minOrder` ASC [ RunTime:0.013502s ]
select * from pdf where partno='HW4F-32R-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.062489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-32R-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.008505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449695 LIMIT 5 [ RunTime:0.021167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449695 ORDER BY `minOrder` ASC [ RunTime:0.050203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449695 ORDER BY `unit` DESC [ RunTime:0.009617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449695 LIMIT 2 [ RunTime:0.013994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449695 ORDER BY `minOrder` ASC [ RunTime:0.002628s ]
select * from pdf where partno='HW4F-33A-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.042369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-33A-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.032387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449694 LIMIT 5 [ RunTime:0.025032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449694 ORDER BY `minOrder` ASC [ RunTime:0.048496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449694 ORDER BY `unit` DESC [ RunTime:0.018757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449694 LIMIT 2 [ RunTime:0.024624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449694 ORDER BY `minOrder` ASC [ RunTime:0.011473s ]
select * from pdf where partno='HW4F-32Y-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.013934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-32Y-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.017004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449691 LIMIT 5 [ RunTime:0.030184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449691 ORDER BY `minOrder` ASC [ RunTime:0.037384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449691 ORDER BY `unit` DESC [ RunTime:0.054758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449691 LIMIT 2 [ RunTime:0.016343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449691 ORDER BY `minOrder` ASC [ RunTime:0.022299s ]
select * from pdf where partno='HW4F-32G-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.038037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-32G-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.021499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449690 LIMIT 5 [ RunTime:0.029451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449690 ORDER BY `minOrder` ASC [ RunTime:0.023661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449690 ORDER BY `unit` DESC [ RunTime:0.047967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449690 LIMIT 2 [ RunTime:0.014772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449690 ORDER BY `minOrder` ASC [ RunTime:0.007472s ]
select * from pdf where partno='HW4F-32S-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.018603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-32S-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.010782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449689 LIMIT 5 [ RunTime:0.041782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449689 ORDER BY `minOrder` ASC [ RunTime:0.008790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449689 ORDER BY `unit` DESC [ RunTime:0.009677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449689 LIMIT 2 [ RunTime:0.017683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449689 ORDER BY `minOrder` ASC [ RunTime:0.004749s ]
select * from pdf where partno='HW4F-32PW-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.025331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-32PW-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.004670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449688 LIMIT 5 [ RunTime:0.016949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449688 ORDER BY `minOrder` ASC [ RunTime:0.013876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449688 ORDER BY `unit` DESC [ RunTime:0.004803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449688 LIMIT 2 [ RunTime:0.007151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449688 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='HW4F-32A-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.031925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-32A-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.016081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449687 LIMIT 5 [ RunTime:0.010296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449687 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449687 ORDER BY `unit` DESC [ RunTime:0.003790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449687 LIMIT 2 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449687 ORDER BY `minOrder` ASC [ RunTime:0.006237s ]
select * from pdf where partno='HW4F-31PW-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.003039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-31PW-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.003433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449686 LIMIT 5 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449686 ORDER BY `minOrder` ASC [ RunTime:0.019190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449686 ORDER BY `unit` DESC [ RunTime:0.009789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449686 LIMIT 2 [ RunTime:0.006335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449686 ORDER BY `minOrder` ASC [ RunTime:0.000892s ]
select * from pdf where partno='HW4F-31Y-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.005272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-31Y-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449685 LIMIT 5 [ RunTime:0.009728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449685 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449685 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449685 LIMIT 2 [ RunTime:0.007270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449685 ORDER BY `minOrder` ASC [ RunTime:0.004859s ]
select * from pdf where partno='HW4F-31G-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.008622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-31G-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.007226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449684 LIMIT 5 [ RunTime:0.028059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449684 ORDER BY `minOrder` ASC [ RunTime:0.012343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449684 ORDER BY `unit` DESC [ RunTime:0.006966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449684 LIMIT 2 [ RunTime:0.015275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449684 ORDER BY `minOrder` ASC [ RunTime:0.012529s ]
select * from pdf where partno='HW4F-31S-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.012948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-31S-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.004774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449683 LIMIT 5 [ RunTime:0.008574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449683 ORDER BY `minOrder` ASC [ RunTime:0.012608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449683 ORDER BY `unit` DESC [ RunTime:0.008501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449683 LIMIT 2 [ RunTime:0.001520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449683 ORDER BY `minOrder` ASC [ RunTime:0.009380s ]
select * from pdf where partno='HW4F-31R-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.001130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-31R-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.006612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449123 LIMIT 5 [ RunTime:0.023299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449123 ORDER BY `minOrder` ASC [ RunTime:0.057851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449123 ORDER BY `unit` DESC [ RunTime:0.036537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449123 LIMIT 2 [ RunTime:0.069737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449123 ORDER BY `minOrder` ASC [ RunTime:0.036381s ]
select * from pdf where partno='HW4F-3A-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.044931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-3A-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.010899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58449121 LIMIT 5 [ RunTime:0.023470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449121 ORDER BY `minOrder` ASC [ RunTime:0.095404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58449121 ORDER BY `unit` DESC [ RunTime:0.008926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58449121 LIMIT 2 [ RunTime:0.022056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58449121 ORDER BY `minOrder` ASC [ RunTime:0.013623s ]
select * from pdf where partno='HW4F-3S-PI-USA' and brandshort='IDEC' limit 1 [ RunTime:0.020505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HW4F-3S-PI-USA' OR `brand` LIKE 'IDEC%' ) ) LIMIT 1 [ RunTime:0.040052s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014567s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012688s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022202s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003499s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025875s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013714s ]
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 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006251s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HW4F-3%' OR `brand` LIKE 'HW4F-3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031499s ]