SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003176s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058216s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13032099 LIMIT 5 [ RunTime:0.052007s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13032099 ORDER BY `minOrder` ASC [ RunTime:0.050065s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13032099 ORDER BY `unit` DESC [ RunTime:0.058551s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13032099 LIMIT 2 [ RunTime:0.106517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13032099 ORDER BY `minOrder` ASC [ RunTime:0.021208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10836642 LIMIT 5 [ RunTime:0.043079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10836642 ORDER BY `minOrder` ASC [ RunTime:0.096419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10836642 ORDER BY `unit` DESC [ RunTime:0.073907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10836642 LIMIT 2 [ RunTime:0.056804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10836642 ORDER BY `minOrder` ASC [ RunTime:0.030693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10825874 LIMIT 5 [ RunTime:0.072257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825874 ORDER BY `minOrder` ASC [ RunTime:0.075640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10825874 ORDER BY `unit` DESC [ RunTime:0.096823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10825874 LIMIT 2 [ RunTime:0.055811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825874 ORDER BY `minOrder` ASC [ RunTime:0.068214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10825872 LIMIT 5 [ RunTime:0.108179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825872 ORDER BY `minOrder` ASC [ RunTime:0.138394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10825872 ORDER BY `unit` DESC [ RunTime:0.067138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10825872 LIMIT 2 [ RunTime:0.075711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825872 ORDER BY `minOrder` ASC [ RunTime:0.030469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10823273 LIMIT 5 [ RunTime:0.034725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10823273 ORDER BY `minOrder` ASC [ RunTime:0.110581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10823273 ORDER BY `unit` DESC [ RunTime:0.052255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10823273 LIMIT 2 [ RunTime:0.084294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10823273 ORDER BY `minOrder` ASC [ RunTime:0.014167s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041108s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61397304 LIMIT 5 [ RunTime:0.085686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61397304 ORDER BY `minOrder` ASC [ RunTime:0.090017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61397304 ORDER BY `unit` DESC [ RunTime:0.131395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61397304 LIMIT 2 [ RunTime:0.081468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61397304 ORDER BY `minOrder` ASC [ RunTime:0.053064s ]
select * from pdf where partno='97-3100A-24-12P(288)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.038963s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-24-12P(288)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.051198s ]
SELECT `id` FROM `stock` WHERE `id` <> 61397304 AND `partno` = '97-3100A-24-12P(288)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.118547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10836642 [ RunTime:0.047613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61383696 LIMIT 5 [ RunTime:0.042693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61383696 ORDER BY `minOrder` ASC [ RunTime:0.097925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61383696 ORDER BY `unit` DESC [ RunTime:0.036600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61383696 LIMIT 2 [ RunTime:0.050017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61383696 ORDER BY `minOrder` ASC [ RunTime:0.018875s ]
select * from pdf where partno='97-3100A-24-12P(621)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.072927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-24-12P(621)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.041115s ]
SELECT `id` FROM `stock` WHERE `id` <> 61383696 AND `partno` = '97-3100A-24-12P(621)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.053159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13032099 [ RunTime:0.028470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61372813 LIMIT 5 [ RunTime:0.026164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61372813 ORDER BY `minOrder` ASC [ RunTime:0.016619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61372813 ORDER BY `unit` DESC [ RunTime:0.011285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61372813 LIMIT 2 [ RunTime:0.021910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61372813 ORDER BY `minOrder` ASC [ RunTime:0.009703s ]
select * from pdf where partno='97-3100A-24-12P(639)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.000686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-24-12P(639)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.005144s ]
SELECT `id` FROM `stock` WHERE `id` <> 61372813 AND `partno` = '97-3100A-24-12P(639)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.009669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10825874 [ RunTime:0.022463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61372812 LIMIT 5 [ RunTime:0.011655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61372812 ORDER BY `minOrder` ASC [ RunTime:0.049480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61372812 ORDER BY `unit` DESC [ RunTime:0.002994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61372812 LIMIT 2 [ RunTime:0.029233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61372812 ORDER BY `minOrder` ASC [ RunTime:0.009861s ]
select * from pdf where partno='97-3100A-24-12P' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.040479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-24-12P' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.042947s ]
SELECT `id` FROM `stock` WHERE `id` <> 61372812 AND `partno` = '97-3100A-24-12P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.026091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10825872 [ RunTime:0.047376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61369573 LIMIT 5 [ RunTime:0.108415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61369573 ORDER BY `minOrder` ASC [ RunTime:0.051954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61369573 ORDER BY `unit` DESC [ RunTime:0.051929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61369573 LIMIT 2 [ RunTime:0.027512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61369573 ORDER BY `minOrder` ASC [ RunTime:0.073508s ]
select * from pdf where partno='97-3100A-24-12P(211)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.093144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-24-12P(211)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.046250s ]
SELECT `id` FROM `stock` WHERE `id` <> 61369573 AND `partno` = '97-3100A-24-12P(211)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.163750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10823273 [ RunTime:0.032551s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.201742s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.134979s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.169695s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103744s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.146713s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.355090s ]
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-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042581s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '97-3100A-24-12P%' OR `brand` LIKE '97-3100A-24-12P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.098223s ]