SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002161s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013596s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20056011 LIMIT 5 [ RunTime:0.004509s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20056011 ORDER BY `minOrder` ASC [ RunTime:0.004116s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20056011 ORDER BY `unit` DESC [ RunTime:0.001650s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20056011 LIMIT 2 [ RunTime:0.003419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20056011 ORDER BY `minOrder` ASC [ RunTime:0.008810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16346182 LIMIT 5 [ RunTime:0.012213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16346182 ORDER BY `minOrder` ASC [ RunTime:0.015222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16346182 ORDER BY `unit` DESC [ RunTime:0.013692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16346182 LIMIT 2 [ RunTime:0.002733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16346182 ORDER BY `minOrder` ASC [ RunTime:0.002426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12850430 LIMIT 5 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12850430 ORDER BY `minOrder` ASC [ RunTime:0.008346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12850430 ORDER BY `unit` DESC [ RunTime:0.006401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12850430 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12850430 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11647713 LIMIT 5 [ RunTime:0.000921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11647713 ORDER BY `minOrder` ASC [ RunTime:0.002297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11647713 ORDER BY `unit` DESC [ RunTime:0.001339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11647713 LIMIT 2 [ RunTime:0.003671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11647713 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010836s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51933092 LIMIT 5 [ RunTime:0.002442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51933092 ORDER BY `minOrder` ASC [ RunTime:0.002979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51933092 ORDER BY `unit` DESC [ RunTime:0.019543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51933092 LIMIT 2 [ RunTime:0.005289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51933092 ORDER BY `minOrder` ASC [ RunTime:0.018635s ]
select * from pdf where partno='GEC26DRES-S93' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.003164s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEC26DRES-S93' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.001024s ]
SELECT `id` FROM `stock` WHERE `id` <> 51933092 AND `partno` = 'GEC26DRES-S93' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.006521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16346182 [ RunTime:0.003322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51930810 LIMIT 5 [ RunTime:0.009229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51930810 ORDER BY `minOrder` ASC [ RunTime:0.014786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51930810 ORDER BY `unit` DESC [ RunTime:0.009721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51930810 LIMIT 2 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51930810 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='GEC26DRES-S734' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.002192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEC26DRES-S734' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.000759s ]
SELECT `id` FROM `stock` WHERE `id` <> 51930810 AND `partno` = 'GEC26DRES-S734' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.000695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20056011 [ RunTime:0.007393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51893206 LIMIT 5 [ RunTime:0.007715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51893206 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51893206 ORDER BY `unit` DESC [ RunTime:0.004856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51893206 LIMIT 2 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51893206 ORDER BY `minOrder` ASC [ RunTime:0.001683s ]
select * from pdf where partno='GEC26DRES-S13' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.009489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEC26DRES-S13' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.012437s ]
SELECT `id` FROM `stock` WHERE `id` <> 51893206 AND `partno` = 'GEC26DRES-S13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.008203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12850430 [ RunTime:0.007387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51884956 LIMIT 5 [ RunTime:0.009526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51884956 ORDER BY `minOrder` ASC [ RunTime:0.009122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51884956 ORDER BY `unit` DESC [ RunTime:0.023821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51884956 LIMIT 2 [ RunTime:0.010606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51884956 ORDER BY `minOrder` ASC [ RunTime:0.024410s ]
select * from pdf where partno='GEC26DRES' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.018854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEC26DRES' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.011287s ]
SELECT `id` FROM `stock` WHERE `id` <> 51884956 AND `partno` = 'GEC26DRES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.018347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11647713 [ RunTime:0.011799s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017670s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020409s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004859s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006883s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015773s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019116s ]
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 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033763s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'GEC26DRES%' OR `brand` LIKE 'GEC26DRES%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034995s ]