SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003243s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081119s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13028350 LIMIT 5 [ RunTime:0.020239s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028350 ORDER BY `minOrder` ASC [ RunTime:0.004297s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13028350 ORDER BY `unit` DESC [ RunTime:0.047082s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13028350 LIMIT 2 [ RunTime:0.012665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028350 ORDER BY `minOrder` ASC [ RunTime:0.060198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13025061 LIMIT 5 [ RunTime:0.060018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13025061 ORDER BY `minOrder` ASC [ RunTime:0.066364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13025061 ORDER BY `unit` DESC [ RunTime:0.087608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13025061 LIMIT 2 [ RunTime:0.054362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13025061 ORDER BY `minOrder` ASC [ RunTime:0.013167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13025057 LIMIT 5 [ RunTime:0.021208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13025057 ORDER BY `minOrder` ASC [ RunTime:0.036996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13025057 ORDER BY `unit` DESC [ RunTime:0.022014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13025057 LIMIT 2 [ RunTime:0.050331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13025057 ORDER BY `minOrder` ASC [ RunTime:0.043567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10793776 LIMIT 5 [ RunTime:0.074858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10793776 ORDER BY `minOrder` ASC [ RunTime:0.036196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10793776 ORDER BY `unit` DESC [ RunTime:0.017401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10793776 LIMIT 2 [ RunTime:0.042909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10793776 ORDER BY `minOrder` ASC [ RunTime:0.033513s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076951s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61336073 LIMIT 5 [ RunTime:0.084947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61336073 ORDER BY `minOrder` ASC [ RunTime:0.017988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61336073 ORDER BY `unit` DESC [ RunTime:0.011654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61336073 LIMIT 2 [ RunTime:0.031386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61336073 ORDER BY `minOrder` ASC [ RunTime:0.033309s ]
select * from pdf where partno='97-3100A-16-9P(288)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.033254s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-16-9P(288)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000566s ]
SELECT `id` FROM `stock` WHERE `id` <> 61336073 AND `partno` = '97-3100A-16-9P(288)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.036457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10793776 [ RunTime:0.022789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61287546 LIMIT 5 [ RunTime:0.047141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61287546 ORDER BY `minOrder` ASC [ RunTime:0.064900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61287546 ORDER BY `unit` DESC [ RunTime:0.014839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61287546 LIMIT 2 [ RunTime:0.007124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61287546 ORDER BY `minOrder` ASC [ RunTime:0.021224s ]
select * from pdf where partno='97-3100A-16-9P(621)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.025208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-16-9P(621)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.004648s ]
SELECT `id` FROM `stock` WHERE `id` <> 61287546 AND `partno` = '97-3100A-16-9P(621)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13028350 [ RunTime:0.015390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61280943 LIMIT 5 [ RunTime:0.015008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61280943 ORDER BY `minOrder` ASC [ RunTime:0.011429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61280943 ORDER BY `unit` DESC [ RunTime:0.017338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61280943 LIMIT 2 [ RunTime:0.004411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61280943 ORDER BY `minOrder` ASC [ RunTime:0.021717s ]
select * from pdf where partno='97-3100A-16-9P(639)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.014224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-16-9P(639)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.005080s ]
SELECT `id` FROM `stock` WHERE `id` <> 61280943 AND `partno` = '97-3100A-16-9P(639)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.016212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13025061 [ RunTime:0.013021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61274952 LIMIT 5 [ RunTime:0.008603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61274952 ORDER BY `minOrder` ASC [ RunTime:0.006457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61274952 ORDER BY `unit` DESC [ RunTime:0.005823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61274952 LIMIT 2 [ RunTime:0.013405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61274952 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
select * from pdf where partno='97-3100A-16-9P(211)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.008039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-16-9P(211)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000389s ]
SELECT `id` FROM `stock` WHERE `id` <> 61274952 AND `partno` = '97-3100A-16-9P(211)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54204701 LIMIT 5 [ RunTime:0.008467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54204701 ORDER BY `minOrder` ASC [ RunTime:0.017487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54204701 ORDER BY `unit` DESC [ RunTime:0.011875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54204701 LIMIT 2 [ RunTime:0.010764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54204701 ORDER BY `minOrder` ASC [ RunTime:0.001539s ]
select * from pdf where partno='97-3100A-16-9P' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-16-9P' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.004102s ]
SELECT `id` FROM `stock` WHERE `id` <> 54204701 AND `partno` = '97-3100A-16-9P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.005292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13025057 [ RunTime:0.019352s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022035s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005663s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006872s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013679s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025493s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014359s ]
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 '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021117s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '97-3100A-16-9P%' OR `brand` LIKE '97-3100A-16-9P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029339s ]