SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001197s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=LJT00RE-19-68P&search=1' [ RunTime:0.009989s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002270s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005895s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.005360s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.002955s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004295s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003995s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002471s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-19-68P' LIMIT 1 [ RunTime:0.009810s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-05 20:15:10' WHERE `partno` = 'LJT00RE-19-68P' [ RunTime:0.008940s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.005219s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023272s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119753 LIMIT 5 [ RunTime:0.003865s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119753 ORDER BY `minOrder` ASC [ RunTime:0.002125s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119753 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119753 LIMIT 2 [ RunTime:0.013060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119753 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119752 LIMIT 5 [ RunTime:0.007657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119752 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119752 ORDER BY `unit` DESC [ RunTime:0.002964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119752 LIMIT 2 [ RunTime:0.012171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119752 ORDER BY `minOrder` ASC [ RunTime:0.003102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119751 LIMIT 5 [ RunTime:0.005443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119751 ORDER BY `minOrder` ASC [ RunTime:0.010877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119751 ORDER BY `unit` DESC [ RunTime:0.005962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119751 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119751 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119750 LIMIT 5 [ RunTime:0.000317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119750 ORDER BY `minOrder` ASC [ RunTime:0.002091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119750 ORDER BY `unit` DESC [ RunTime:0.016878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119750 LIMIT 2 [ RunTime:0.014496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119750 ORDER BY `minOrder` ASC [ RunTime:0.004488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119749 LIMIT 5 [ RunTime:0.008443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119749 ORDER BY `minOrder` ASC [ RunTime:0.006612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119749 ORDER BY `unit` DESC [ RunTime:0.005802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119749 LIMIT 2 [ RunTime:0.002069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119749 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119748 LIMIT 5 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119748 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119748 ORDER BY `unit` DESC [ RunTime:0.010881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119748 LIMIT 2 [ RunTime:0.013844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119748 ORDER BY `minOrder` ASC [ RunTime:0.003604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119747 LIMIT 5 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119747 ORDER BY `minOrder` ASC [ RunTime:0.003624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119747 ORDER BY `unit` DESC [ RunTime:0.000764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119747 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119747 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119726 LIMIT 5 [ RunTime:0.006972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119726 ORDER BY `minOrder` ASC [ RunTime:0.024376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119726 ORDER BY `unit` DESC [ RunTime:0.006959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119726 LIMIT 2 [ RunTime:0.022317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119726 ORDER BY `minOrder` ASC [ RunTime:0.002596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119725 LIMIT 5 [ RunTime:0.003414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119725 ORDER BY `minOrder` ASC [ RunTime:0.030538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119725 ORDER BY `unit` DESC [ RunTime:0.033303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119725 LIMIT 2 [ RunTime:0.007425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119725 ORDER BY `minOrder` ASC [ RunTime:0.002869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119724 LIMIT 5 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119724 ORDER BY `minOrder` ASC [ RunTime:0.020075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20119724 ORDER BY `unit` DESC [ RunTime:0.032384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20119724 LIMIT 2 [ RunTime:0.018206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20119724 ORDER BY `minOrder` ASC [ RunTime:0.016399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16378175 LIMIT 5 [ RunTime:0.020056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16378175 ORDER BY `minOrder` ASC [ RunTime:0.008726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16378175 ORDER BY `unit` DESC [ RunTime:0.011999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16378175 LIMIT 2 [ RunTime:0.026300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16378175 ORDER BY `minOrder` ASC [ RunTime:0.010356s ]
select * from pdf where partno='LJT00RE-19-68PC(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.018262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16378161 LIMIT 5 [ RunTime:0.017082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16378161 ORDER BY `minOrder` ASC [ RunTime:0.008077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16378161 ORDER BY `unit` DESC [ RunTime:0.008994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16378161 LIMIT 2 [ RunTime:0.019523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16378161 ORDER BY `minOrder` ASC [ RunTime:0.006122s ]
select * from pdf where partno='LJT00RE-19-68P(014LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15559622 LIMIT 5 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559622 ORDER BY `minOrder` ASC [ RunTime:0.011869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15559622 ORDER BY `unit` DESC [ RunTime:0.023150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15559622 LIMIT 2 [ RunTime:0.003661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559622 ORDER BY `minOrder` ASC [ RunTime:0.014446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15559621 LIMIT 5 [ RunTime:0.003225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559621 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15559621 ORDER BY `unit` DESC [ RunTime:0.005353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15559621 LIMIT 2 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559621 ORDER BY `minOrder` ASC [ RunTime:0.004567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15559620 LIMIT 5 [ RunTime:0.006954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559620 ORDER BY `minOrder` ASC [ RunTime:0.009660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15559620 ORDER BY `unit` DESC [ RunTime:0.006058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15559620 LIMIT 2 [ RunTime:0.012993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559620 ORDER BY `minOrder` ASC [ RunTime:0.016503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15559619 LIMIT 5 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559619 ORDER BY `minOrder` ASC [ RunTime:0.016957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15559619 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15559619 LIMIT 2 [ RunTime:0.006248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15559619 ORDER BY `minOrder` ASC [ RunTime:0.025009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059647 LIMIT 5 [ RunTime:0.003992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059647 ORDER BY `minOrder` ASC [ RunTime:0.016378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11059647 ORDER BY `unit` DESC [ RunTime:0.004893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11059647 LIMIT 2 [ RunTime:0.023642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059647 ORDER BY `minOrder` ASC [ RunTime:0.020363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059645 LIMIT 5 [ RunTime:0.022204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059645 ORDER BY `minOrder` ASC [ RunTime:0.011030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11059645 ORDER BY `unit` DESC [ RunTime:0.012889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11059645 LIMIT 2 [ RunTime:0.016793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059645 ORDER BY `minOrder` ASC [ RunTime:0.004002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059643 LIMIT 5 [ RunTime:0.013438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059643 ORDER BY `minOrder` ASC [ RunTime:0.007280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11059643 ORDER BY `unit` DESC [ RunTime:0.007291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11059643 LIMIT 2 [ RunTime:0.004229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059643 ORDER BY `minOrder` ASC [ RunTime:0.005689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059642 LIMIT 5 [ RunTime:0.004291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059642 ORDER BY `minOrder` ASC [ RunTime:0.012438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11059642 ORDER BY `unit` DESC [ RunTime:0.020343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11059642 LIMIT 2 [ RunTime:0.013962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11059642 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007104s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61727618 LIMIT 5 [ RunTime:0.001181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61727618 ORDER BY `minOrder` ASC [ RunTime:0.012004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61727618 ORDER BY `unit` DESC [ RunTime:0.004378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61727618 LIMIT 2 [ RunTime:0.001428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61727618 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='LJT00RE-19-68P(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001366s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002597s ]
SELECT `id` FROM `stock` WHERE `id` <> 61727618 AND `partno` = 'LJT00RE-19-68P(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059645 [ RunTime:0.013878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61727616 LIMIT 5 [ RunTime:0.013495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61727616 ORDER BY `minOrder` ASC [ RunTime:0.013220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61727616 ORDER BY `unit` DESC [ RunTime:0.028115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61727616 LIMIT 2 [ RunTime:0.010565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61727616 ORDER BY `minOrder` ASC [ RunTime:0.005765s ]
select * from pdf where partno='LJT00RE-19-68P(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001496s ]
SELECT `id` FROM `stock` WHERE `id` <> 61727616 AND `partno` = 'LJT00RE-19-68P(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059643 [ RunTime:0.014437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61727615 LIMIT 5 [ RunTime:0.015947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61727615 ORDER BY `minOrder` ASC [ RunTime:0.017135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61727615 ORDER BY `unit` DESC [ RunTime:0.013367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61727615 LIMIT 2 [ RunTime:0.011384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61727615 ORDER BY `minOrder` ASC [ RunTime:0.001649s ]
select * from pdf where partno='LJT00RE-19-68P(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.019576s ]
SELECT `id` FROM `stock` WHERE `id` <> 61727615 AND `partno` = 'LJT00RE-19-68P(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059642 [ RunTime:0.008839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61676030 LIMIT 5 [ RunTime:0.003762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676030 ORDER BY `minOrder` ASC [ RunTime:0.010817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61676030 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61676030 LIMIT 2 [ RunTime:0.012143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676030 ORDER BY `minOrder` ASC [ RunTime:0.010917s ]
select * from pdf where partno='LJT00RE-19-68P(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.029647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.015687s ]
SELECT `id` FROM `stock` WHERE `id` <> 61676030 AND `partno` = 'LJT00RE-19-68P(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11009099 [ RunTime:0.037350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61676026 LIMIT 5 [ RunTime:0.011601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676026 ORDER BY `minOrder` ASC [ RunTime:0.056796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61676026 ORDER BY `unit` DESC [ RunTime:0.012738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61676026 LIMIT 2 [ RunTime:0.006953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676026 ORDER BY `minOrder` ASC [ RunTime:0.002094s ]
select * from pdf where partno='LJT00RE-19-68P(408)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(408)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006457s ]
SELECT `id` FROM `stock` WHERE `id` <> 61676026 AND `partno` = 'LJT00RE-19-68P(408)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.017262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11009095 [ RunTime:0.001971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61676024 LIMIT 5 [ RunTime:0.019263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676024 ORDER BY `minOrder` ASC [ RunTime:0.046956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61676024 ORDER BY `unit` DESC [ RunTime:0.025235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61676024 LIMIT 2 [ RunTime:0.010595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676024 ORDER BY `minOrder` ASC [ RunTime:0.008487s ]
select * from pdf where partno='LJT00RE-19-68P(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005923s ]
SELECT `id` FROM `stock` WHERE `id` <> 61676024 AND `partno` = 'LJT00RE-19-68P(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11009093 [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61676015 LIMIT 5 [ RunTime:0.008337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676015 ORDER BY `minOrder` ASC [ RunTime:0.011895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61676015 ORDER BY `unit` DESC [ RunTime:0.001228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61676015 LIMIT 2 [ RunTime:0.006033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61676015 ORDER BY `minOrder` ASC [ RunTime:0.009450s ]
select * from pdf where partno='LJT00RE-19-68P(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000914s ]
SELECT `id` FROM `stock` WHERE `id` <> 61676015 AND `partno` = 'LJT00RE-19-68P(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11009083 [ RunTime:0.008882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61658379 LIMIT 5 [ RunTime:0.004761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61658379 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61658379 ORDER BY `unit` DESC [ RunTime:0.006971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61658379 LIMIT 2 [ RunTime:0.007659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61658379 ORDER BY `minOrder` ASC [ RunTime:0.005456s ]
select * from pdf where partno='LJT00RE-19-68P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008728s ]
SELECT `id` FROM `stock` WHERE `id` <> 61658379 AND `partno` = 'LJT00RE-19-68P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61658375 LIMIT 5 [ RunTime:0.009884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61658375 ORDER BY `minOrder` ASC [ RunTime:0.012147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61658375 ORDER BY `unit` DESC [ RunTime:0.015982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61658375 LIMIT 2 [ RunTime:0.008050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61658375 ORDER BY `minOrder` ASC [ RunTime:0.007395s ]
select * from pdf where partno='LJT00RE-19-68P(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006578s ]
SELECT `id` FROM `stock` WHERE `id` <> 61658375 AND `partno` = 'LJT00RE-19-68P(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61658374 LIMIT 5 [ RunTime:0.004983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61658374 ORDER BY `minOrder` ASC [ RunTime:0.015563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61658374 ORDER BY `unit` DESC [ RunTime:0.023601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61658374 LIMIT 2 [ RunTime:0.019576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61658374 ORDER BY `minOrder` ASC [ RunTime:0.017092s ]
select * from pdf where partno='LJT00RE-19-68P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000748s ]
SELECT `id` FROM `stock` WHERE `id` <> 61658374 AND `partno` = 'LJT00RE-19-68P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10991059 [ RunTime:0.017374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61166662 LIMIT 5 [ RunTime:0.015445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166662 ORDER BY `minOrder` ASC [ RunTime:0.024220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61166662 ORDER BY `unit` DESC [ RunTime:0.014345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61166662 LIMIT 2 [ RunTime:0.014300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166662 ORDER BY `minOrder` ASC [ RunTime:0.006308s ]
select * from pdf where partno='LJT00RE-19-68P(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002260s ]
SELECT `id` FROM `stock` WHERE `id` <> 61166662 AND `partno` = 'LJT00RE-19-68P(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11059647 [ RunTime:0.027259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61164734 LIMIT 5 [ RunTime:0.036039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61164734 ORDER BY `minOrder` ASC [ RunTime:0.021749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61164734 ORDER BY `unit` DESC [ RunTime:0.004704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61164734 LIMIT 2 [ RunTime:0.001525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61164734 ORDER BY `minOrder` ASC [ RunTime:0.001032s ]
select * from pdf where partno='LJT00RE-19-68P(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68P(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008576s ]
SELECT `id` FROM `stock` WHERE `id` <> 61164734 AND `partno` = 'LJT00RE-19-68P(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212053 LIMIT 5 [ RunTime:0.012594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212053 ORDER BY `minOrder` ASC [ RunTime:0.015814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212053 ORDER BY `unit` DESC [ RunTime:0.002832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212053 LIMIT 2 [ RunTime:0.011532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212053 ORDER BY `minOrder` ASC [ RunTime:0.003610s ]
select * from pdf where partno='LJT00RE-19-68PB(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PB(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005136s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212053 AND `partno` = 'LJT00RE-19-68PB(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212052 LIMIT 5 [ RunTime:0.005514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212052 ORDER BY `minOrder` ASC [ RunTime:0.003908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212052 ORDER BY `unit` DESC [ RunTime:0.018229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212052 LIMIT 2 [ RunTime:0.008342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212052 ORDER BY `minOrder` ASC [ RunTime:0.008410s ]
select * from pdf where partno='LJT00RE-19-68PB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.028838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006348s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212052 AND `partno` = 'LJT00RE-19-68PB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212051 LIMIT 5 [ RunTime:0.028444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212051 ORDER BY `minOrder` ASC [ RunTime:0.032566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212051 ORDER BY `unit` DESC [ RunTime:0.017546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212051 LIMIT 2 [ RunTime:0.010419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212051 ORDER BY `minOrder` ASC [ RunTime:0.008986s ]
select * from pdf where partno='LJT00RE-19-68PB(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PB(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001193s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212051 AND `partno` = 'LJT00RE-19-68PB(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212039 LIMIT 5 [ RunTime:0.003703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212039 ORDER BY `minOrder` ASC [ RunTime:0.009951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212039 ORDER BY `unit` DESC [ RunTime:0.000963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212039 LIMIT 2 [ RunTime:0.041042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212039 ORDER BY `minOrder` ASC [ RunTime:0.003157s ]
select * from pdf where partno='LJT00RE-19-68PA(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PA(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001124s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212039 AND `partno` = 'LJT00RE-19-68PA(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119753 [ RunTime:0.008869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212038 LIMIT 5 [ RunTime:0.049919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212038 ORDER BY `minOrder` ASC [ RunTime:0.023974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212038 ORDER BY `unit` DESC [ RunTime:0.012630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212038 LIMIT 2 [ RunTime:0.017008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212038 ORDER BY `minOrder` ASC [ RunTime:0.004290s ]
select * from pdf where partno='LJT00RE-19-68PC(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PC(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006341s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212038 AND `partno` = 'LJT00RE-19-68PC(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.040757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16378175 [ RunTime:0.015676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212037 LIMIT 5 [ RunTime:0.008381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212037 ORDER BY `minOrder` ASC [ RunTime:0.005667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212037 ORDER BY `unit` DESC [ RunTime:0.026688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212037 LIMIT 2 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212037 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='LJT00RE-19-68PC(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PC(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.013741s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212037 AND `partno` = 'LJT00RE-19-68PC(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.016521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20119750 [ RunTime:0.016516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212036 LIMIT 5 [ RunTime:0.009598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212036 ORDER BY `minOrder` ASC [ RunTime:0.003419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212036 ORDER BY `unit` DESC [ RunTime:0.000780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212036 LIMIT 2 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212036 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='LJT00RE-19-68PA(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PA(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012253s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212036 AND `partno` = 'LJT00RE-19-68PA(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15559622 [ RunTime:0.010572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60212035 LIMIT 5 [ RunTime:0.008995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212035 ORDER BY `minOrder` ASC [ RunTime:0.048477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60212035 ORDER BY `unit` DESC [ RunTime:0.016199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60212035 LIMIT 2 [ RunTime:0.057086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60212035 ORDER BY `minOrder` ASC [ RunTime:0.010521s ]
select * from pdf where partno='LJT00RE-19-68PD(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-68PD(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002941s ]
SELECT `id` FROM `stock` WHERE `id` <> 60212035 AND `partno` = 'LJT00RE-19-68PD(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15559621 [ RunTime:0.001362s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001283s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002343s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003929s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000742s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000637s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002273s ]
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 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016067s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-19-68P%' OR `brand` LIKE 'LJT00RE-19-68P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000984s ]