SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002738s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017643s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13008732 LIMIT 5 [ RunTime:0.010333s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13008732 ORDER BY `minOrder` ASC [ RunTime:0.025416s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13008732 ORDER BY `unit` DESC [ RunTime:0.007887s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13008732 LIMIT 2 [ RunTime:0.062531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13008732 ORDER BY `minOrder` ASC [ RunTime:0.027937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13005773 LIMIT 5 [ RunTime:0.036660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13005773 ORDER BY `minOrder` ASC [ RunTime:0.058458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13005773 ORDER BY `unit` DESC [ RunTime:0.062700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13005773 LIMIT 2 [ RunTime:0.051896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13005773 ORDER BY `minOrder` ASC [ RunTime:0.006286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11783387 LIMIT 5 [ RunTime:0.034412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11783387 ORDER BY `minOrder` ASC [ RunTime:0.034754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11783387 ORDER BY `unit` DESC [ RunTime:0.049632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11783387 LIMIT 2 [ RunTime:0.100077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11783387 ORDER BY `minOrder` ASC [ RunTime:0.034400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10895735 LIMIT 5 [ RunTime:0.046881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10895735 ORDER BY `minOrder` ASC [ RunTime:0.013449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10895735 ORDER BY `unit` DESC [ RunTime:0.074993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10895735 LIMIT 2 [ RunTime:0.012557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10895735 ORDER BY `minOrder` ASC [ RunTime:0.065941s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047578s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61147930 LIMIT 5 [ RunTime:0.098168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61147930 ORDER BY `minOrder` ASC [ RunTime:0.079831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61147930 ORDER BY `unit` DESC [ RunTime:0.036336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61147930 LIMIT 2 [ RunTime:0.021553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61147930 ORDER BY `minOrder` ASC [ RunTime:0.005581s ]
select * from pdf where partno='97-3100A-18-10S(639)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.038015s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-18-10S(639)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.032511s ]
SELECT `id` FROM `stock` WHERE `id` <> 61147930 AND `partno` = '97-3100A-18-10S(639)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.083559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10895735 [ RunTime:0.021498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61194283 LIMIT 5 [ RunTime:0.005949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61194283 ORDER BY `minOrder` ASC [ RunTime:0.051051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61194283 ORDER BY `unit` DESC [ RunTime:0.040631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61194283 LIMIT 2 [ RunTime:0.009409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61194283 ORDER BY `minOrder` ASC [ RunTime:0.023553s ]
select * from pdf where partno='97-3100A-18-10S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.027356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-18-10S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.022745s ]
SELECT `id` FROM `stock` WHERE `id` <> 61194283 AND `partno` = '97-3100A-18-10S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.007499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61251542 LIMIT 5 [ RunTime:0.017198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61251542 ORDER BY `minOrder` ASC [ RunTime:0.011494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61251542 ORDER BY `unit` DESC [ RunTime:0.009044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61251542 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61251542 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
select * from pdf where partno='97-3100A-18-10S(288)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.002211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-18-10S(288)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.009783s ]
SELECT `id` FROM `stock` WHERE `id` <> 61251542 AND `partno` = '97-3100A-18-10S(288)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.003483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11783387 [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61232330 LIMIT 5 [ RunTime:0.002827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61232330 ORDER BY `minOrder` ASC [ RunTime:0.031395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61232330 ORDER BY `unit` DESC [ RunTime:0.011554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61232330 LIMIT 2 [ RunTime:0.001626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61232330 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='97-3100A-18-10S(946)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.006053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-18-10S(946)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000614s ]
SELECT `id` FROM `stock` WHERE `id` <> 61232330 AND `partno` = '97-3100A-18-10S(946)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.002509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61230151 LIMIT 5 [ RunTime:0.011891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61230151 ORDER BY `minOrder` ASC [ RunTime:0.010568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61230151 ORDER BY `unit` DESC [ RunTime:0.043516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61230151 LIMIT 2 [ RunTime:0.009348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61230151 ORDER BY `minOrder` ASC [ RunTime:0.018953s ]
select * from pdf where partno='97-3100A-18-10S(621)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.025465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-18-10S(621)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.006254s ]
SELECT `id` FROM `stock` WHERE `id` <> 61230151 AND `partno` = '97-3100A-18-10S(621)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.019394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13008732 [ RunTime:0.006978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61224331 LIMIT 5 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61224331 ORDER BY `minOrder` ASC [ RunTime:0.006508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61224331 ORDER BY `unit` DESC [ RunTime:0.007588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61224331 LIMIT 2 [ RunTime:0.005282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61224331 ORDER BY `minOrder` ASC [ RunTime:0.001913s ]
select * from pdf where partno='97-3100A-18-10S(211)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.002843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97-3100A-18-10S(211)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.012260s ]
SELECT `id` FROM `stock` WHERE `id` <> 61224331 AND `partno` = '97-3100A-18-10S(211)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.006833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13005773 [ RunTime:0.000713s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018260s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008905s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015825s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015661s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008587s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008447s ]
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-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015400s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '97-3100A-18-10S%' OR `brand` LIKE '97-3100A-18-10S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027058s ]