SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002240s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.163367s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19895806 LIMIT 5 [ RunTime:0.090446s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19895806 ORDER BY `minOrder` ASC [ RunTime:0.055290s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19895806 ORDER BY `unit` DESC [ RunTime:0.100088s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19895806 LIMIT 2 [ RunTime:0.045614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19895806 ORDER BY `minOrder` ASC [ RunTime:0.057729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11630075 LIMIT 5 [ RunTime:0.043302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11630075 ORDER BY `minOrder` ASC [ RunTime:0.164526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11630075 ORDER BY `unit` DESC [ RunTime:0.078013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11630075 LIMIT 2 [ RunTime:0.081778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11630075 ORDER BY `minOrder` ASC [ RunTime:0.056521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11621860 LIMIT 5 [ RunTime:0.093798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11621860 ORDER BY `minOrder` ASC [ RunTime:0.107380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11621860 ORDER BY `unit` DESC [ RunTime:0.079995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11621860 LIMIT 2 [ RunTime:0.034213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11621860 ORDER BY `minOrder` ASC [ RunTime:0.101799s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070653s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.092148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58940688 LIMIT 5 [ RunTime:0.138090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58940688 ORDER BY `minOrder` ASC [ RunTime:0.075345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58940688 ORDER BY `unit` DESC [ RunTime:0.061439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58940688 LIMIT 2 [ RunTime:0.040860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58940688 ORDER BY `minOrder` ASC [ RunTime:0.089953s ]
select * from pdf where partno='AGM08DRMN-S664' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.110713s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AGM08DRMN-S664' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.066073s ]
SELECT `id` FROM `stock` WHERE `id` <> 58940688 AND `partno` = 'AGM08DRMN-S664' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.044712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19895806 [ RunTime:0.081524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58852101 LIMIT 5 [ RunTime:0.171876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58852101 ORDER BY `minOrder` ASC [ RunTime:0.218744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58852101 ORDER BY `unit` DESC [ RunTime:0.158216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58852101 LIMIT 2 [ RunTime:0.153612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58852101 ORDER BY `minOrder` ASC [ RunTime:0.097324s ]
select * from pdf where partno='AGM08DRMN-S288' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.108574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AGM08DRMN-S288' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.059735s ]
SELECT `id` FROM `stock` WHERE `id` <> 58852101 AND `partno` = 'AGM08DRMN-S288' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.231926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11630075 [ RunTime:0.060272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58831649 LIMIT 5 [ RunTime:0.088233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58831649 ORDER BY `minOrder` ASC [ RunTime:0.069962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58831649 ORDER BY `unit` DESC [ RunTime:0.044841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58831649 LIMIT 2 [ RunTime:0.085733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58831649 ORDER BY `minOrder` ASC [ RunTime:0.120052s ]
select * from pdf where partno='AGM08DRMN' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.151104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AGM08DRMN' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.067264s ]
SELECT `id` FROM `stock` WHERE `id` <> 58831649 AND `partno` = 'AGM08DRMN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.059014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11621860 [ RunTime:0.123221s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117814s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061399s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.201615s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061732s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046553s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050920s ]
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 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058325s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'AGM08DRMN%' OR `brand` LIKE 'AGM08DRMN%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.067130s ]