SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001772s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048115s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10962537 LIMIT 5 [ RunTime:0.054313s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10962537 ORDER BY `minOrder` ASC [ RunTime:0.086381s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10962537 ORDER BY `unit` DESC [ RunTime:0.071443s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10962537 LIMIT 2 [ RunTime:0.050768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10962537 ORDER BY `minOrder` ASC [ RunTime:0.024186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11699929 LIMIT 5 [ RunTime:0.055657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11699929 ORDER BY `minOrder` ASC [ RunTime:0.077725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11699929 ORDER BY `unit` DESC [ RunTime:0.010179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11699929 LIMIT 2 [ RunTime:0.156562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11699929 ORDER BY `minOrder` ASC [ RunTime:0.051115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10755640 LIMIT 5 [ RunTime:0.140156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755640 ORDER BY `minOrder` ASC [ RunTime:0.027426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10755640 ORDER BY `unit` DESC [ RunTime:0.083961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10755640 LIMIT 2 [ RunTime:0.051075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755640 ORDER BY `minOrder` ASC [ RunTime:0.050942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10881497 LIMIT 5 [ RunTime:0.103764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10881497 ORDER BY `minOrder` ASC [ RunTime:0.042027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10881497 ORDER BY `unit` DESC [ RunTime:0.107466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10881497 LIMIT 2 [ RunTime:0.105813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10881497 ORDER BY `minOrder` ASC [ RunTime:0.095973s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.221900s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.131587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54291174 LIMIT 5 [ RunTime:0.086102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54291174 ORDER BY `minOrder` ASC [ RunTime:0.103904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54291174 ORDER BY `unit` DESC [ RunTime:0.103789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54291174 LIMIT 2 [ RunTime:0.065896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54291174 ORDER BY `minOrder` ASC [ RunTime:0.001563s ]
select * from pdf where partno='D38999/20WD5SA' and brandshort='Souriau-Sunbank by Eaton' limit 1 [ RunTime:0.068735s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WD5SA' OR `brand` LIKE 'Souriau-Sunbank by Eaton%' ) ) LIMIT 1 [ RunTime:0.103313s ]
SELECT `id` FROM `stock` WHERE `id` <> 54291174 AND `partno` = 'D38999/20WD5SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%souriau-sunbank by eaton%' ) [ RunTime:0.061625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10962537 [ RunTime:0.097596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53120399 LIMIT 5 [ RunTime:0.065111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53120399 ORDER BY `minOrder` ASC [ RunTime:0.115970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53120399 ORDER BY `unit` DESC [ RunTime:0.046187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53120399 LIMIT 2 [ RunTime:0.224555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53120399 ORDER BY `minOrder` ASC [ RunTime:0.053821s ]
select * from pdf where partno='D38999/20WD5SAL' and brandshort='Souriau-Sunbank by Eaton' limit 1 [ RunTime:0.076496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WD5SAL' OR `brand` LIKE 'Souriau-Sunbank by Eaton%' ) ) LIMIT 1 [ RunTime:0.062247s ]
SELECT `id` FROM `stock` WHERE `id` <> 53120399 AND `partno` = 'D38999/20WD5SAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%souriau-sunbank by eaton%' ) [ RunTime:0.141760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61099289 LIMIT 5 [ RunTime:0.084083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61099289 ORDER BY `minOrder` ASC [ RunTime:0.051530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61099289 ORDER BY `unit` DESC [ RunTime:0.073729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61099289 LIMIT 2 [ RunTime:0.099645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61099289 ORDER BY `minOrder` ASC [ RunTime:0.035741s ]
select * from pdf where partno='D38999/20WD5SA' and brandshort='Corsair' limit 1 [ RunTime:0.075451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WD5SA' OR `brand` LIKE 'Corsair%' ) ) LIMIT 1 [ RunTime:0.051402s ]
SELECT `id` FROM `stock` WHERE `id` <> 61099289 AND `partno` = 'D38999/20WD5SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%corsair%' ) [ RunTime:0.067332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10755640 [ RunTime:0.172438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53120114 LIMIT 5 [ RunTime:0.050618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53120114 ORDER BY `minOrder` ASC [ RunTime:0.099453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53120114 ORDER BY `unit` DESC [ RunTime:0.043337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53120114 LIMIT 2 [ RunTime:0.077923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53120114 ORDER BY `minOrder` ASC [ RunTime:0.065481s ]
select * from pdf where partno='D38999/20WD5SAL' and brandshort='Corsair' limit 1 [ RunTime:0.159188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WD5SAL' OR `brand` LIKE 'Corsair%' ) ) LIMIT 1 [ RunTime:0.051106s ]
SELECT `id` FROM `stock` WHERE `id` <> 53120114 AND `partno` = 'D38999/20WD5SAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%corsair%' ) [ RunTime:0.147604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11699929 [ RunTime:0.044240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61149318 LIMIT 5 [ RunTime:0.051186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61149318 ORDER BY `minOrder` ASC [ RunTime:0.051380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61149318 ORDER BY `unit` DESC [ RunTime:0.051258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61149318 LIMIT 2 [ RunTime:0.155355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61149318 ORDER BY `minOrder` ASC [ RunTime:0.098465s ]
select * from pdf where partno='D38999/20WD5SA' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.088262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WD5SA' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.135852s ]
SELECT `id` FROM `stock` WHERE `id` <> 61149318 AND `partno` = 'D38999/20WD5SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.145030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10881497 [ RunTime:0.130683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60029985 LIMIT 5 [ RunTime:0.063840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60029985 ORDER BY `minOrder` ASC [ RunTime:0.141032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60029985 ORDER BY `unit` DESC [ RunTime:0.111087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60029985 LIMIT 2 [ RunTime:0.054682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60029985 ORDER BY `minOrder` ASC [ RunTime:0.089030s ]
select * from pdf where partno='D38999/20WD5SA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.141796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WD5SA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.148252s ]
SELECT `id` FROM `stock` WHERE `id` <> 60029985 AND `partno` = 'D38999/20WD5SA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.054069s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.134185s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.191563s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.180371s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.183836s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112966s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094649s ]
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 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.212599s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'D38999/20WD5SA%' OR `brand` LIKE 'D38999/20WD5SA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.100216s ]