SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002763s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017745s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543178 LIMIT 5 [ RunTime:0.044662s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543178 ORDER BY `minOrder` ASC [ RunTime:0.045460s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543178 ORDER BY `unit` DESC [ RunTime:0.018871s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543178 LIMIT 2 [ RunTime:0.023187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543178 ORDER BY `minOrder` ASC [ RunTime:0.061878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543298 LIMIT 5 [ RunTime:0.039243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543298 ORDER BY `minOrder` ASC [ RunTime:0.044308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543298 ORDER BY `unit` DESC [ RunTime:0.099423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543298 LIMIT 2 [ RunTime:0.052023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543298 ORDER BY `minOrder` ASC [ RunTime:0.062415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427239 LIMIT 5 [ RunTime:0.136320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427239 ORDER BY `minOrder` ASC [ RunTime:0.053055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427239 ORDER BY `unit` DESC [ RunTime:0.089012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427239 LIMIT 2 [ RunTime:0.067614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427239 ORDER BY `minOrder` ASC [ RunTime:0.104868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427229 LIMIT 5 [ RunTime:0.085279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427229 ORDER BY `minOrder` ASC [ RunTime:0.121343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427229 ORDER BY `unit` DESC [ RunTime:0.052148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427229 LIMIT 2 [ RunTime:0.132765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427229 ORDER BY `minOrder` ASC [ RunTime:0.080369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543317 LIMIT 5 [ RunTime:0.162193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543317 ORDER BY `minOrder` ASC [ RunTime:0.091149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543317 ORDER BY `unit` DESC [ RunTime:0.077150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543317 LIMIT 2 [ RunTime:0.145005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543317 ORDER BY `minOrder` ASC [ RunTime:0.032297s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017568s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63172044 LIMIT 5 [ RunTime:0.026821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63172044 ORDER BY `minOrder` ASC [ RunTime:0.056411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63172044 ORDER BY `unit` DESC [ RunTime:0.055764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63172044 LIMIT 2 [ RunTime:0.030672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63172044 ORDER BY `minOrder` ASC [ RunTime:0.013156s ]
select * from pdf where partno='RAY-101-6.0(100)' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.022448s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAY-101-6.0(100)' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.047091s ]
SELECT `id` FROM `stock` WHERE `id` <> 63172044 AND `partno` = 'RAY-101-6.0(100)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.026229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543178 [ RunTime:0.069926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63172017 LIMIT 5 [ RunTime:0.070768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63172017 ORDER BY `minOrder` ASC [ RunTime:0.013260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63172017 ORDER BY `unit` DESC [ RunTime:0.061595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63172017 LIMIT 2 [ RunTime:0.031390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63172017 ORDER BY `minOrder` ASC [ RunTime:0.025981s ]
select * from pdf where partno='RAY-101-6.0(100)' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.043497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAY-101-6.0(100)' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005879s ]
SELECT `id` FROM `stock` WHERE `id` <> 63172017 AND `partno` = 'RAY-101-6.0(100)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.046602s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019079s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081309s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073418s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090548s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046812s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064281s ]
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 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056154s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RAY-101-6.0(100)%' OR `brand` LIKE 'RAY-101-6.0(100)%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.046156s ]