SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001391s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009431s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12941330 LIMIT 5 [ RunTime:0.004771s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941330 ORDER BY `minOrder` ASC [ RunTime:0.008580s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12941330 ORDER BY `unit` DESC [ RunTime:0.017038s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12941330 LIMIT 2 [ RunTime:0.037361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941330 ORDER BY `minOrder` ASC [ RunTime:0.020179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12941307 LIMIT 5 [ RunTime:0.010532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941307 ORDER BY `minOrder` ASC [ RunTime:0.003969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12941307 ORDER BY `unit` DESC [ RunTime:0.020030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12941307 LIMIT 2 [ RunTime:0.029061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941307 ORDER BY `minOrder` ASC [ RunTime:0.004029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726102 LIMIT 5 [ RunTime:0.013459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726102 ORDER BY `minOrder` ASC [ RunTime:0.012020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726102 ORDER BY `unit` DESC [ RunTime:0.037213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726102 LIMIT 2 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726102 ORDER BY `minOrder` ASC [ RunTime:0.003998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726093 LIMIT 5 [ RunTime:0.014169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726093 ORDER BY `minOrder` ASC [ RunTime:0.025367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726093 ORDER BY `unit` DESC [ RunTime:0.049625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726093 LIMIT 2 [ RunTime:0.010319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726093 ORDER BY `minOrder` ASC [ RunTime:0.017443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726082 LIMIT 5 [ RunTime:0.022272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726082 ORDER BY `minOrder` ASC [ RunTime:0.051619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726082 ORDER BY `unit` DESC [ RunTime:0.045828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726082 LIMIT 2 [ RunTime:0.058814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726082 ORDER BY `minOrder` ASC [ RunTime:0.017296s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017253s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61405237 LIMIT 5 [ RunTime:0.031243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61405237 ORDER BY `minOrder` ASC [ RunTime:0.059943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61405237 ORDER BY `unit` DESC [ RunTime:0.035939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61405237 LIMIT 2 [ RunTime:0.010819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61405237 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
select * from pdf where partno='MS27496E17A99SD' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015608s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.005191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SD' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.020442s ]
SELECT `id` FROM `stock` WHERE `id` <> 61405237 AND `partno` = 'MS27496E17A99SD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.015227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61403649 LIMIT 5 [ RunTime:0.018411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61403649 ORDER BY `minOrder` ASC [ RunTime:0.013835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61403649 ORDER BY `unit` DESC [ RunTime:0.030319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61403649 LIMIT 2 [ RunTime:0.010258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61403649 ORDER BY `minOrder` ASC [ RunTime:0.021605s ]
select * from pdf where partno='MS27496E17A99SC' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SC' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.020417s ]
SELECT `id` FROM `stock` WHERE `id` <> 61403649 AND `partno` = 'MS27496E17A99SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61401827 LIMIT 5 [ RunTime:0.006280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61401827 ORDER BY `minOrder` ASC [ RunTime:0.012615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61401827 ORDER BY `unit` DESC [ RunTime:0.004627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61401827 LIMIT 2 [ RunTime:0.005507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61401827 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
select * from pdf where partno='MS27496E17A99SB' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SB' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003908s ]
SELECT `id` FROM `stock` WHERE `id` <> 61401827 AND `partno` = 'MS27496E17A99SB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61398336 LIMIT 5 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61398336 ORDER BY `minOrder` ASC [ RunTime:0.001219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61398336 ORDER BY `unit` DESC [ RunTime:0.007001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61398336 LIMIT 2 [ RunTime:0.000822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61398336 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='MS27496E17A99SA' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SA' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000768s ]
SELECT `id` FROM `stock` WHERE `id` <> 61398336 AND `partno` = 'MS27496E17A99SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61396413 LIMIT 5 [ RunTime:0.002932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61396413 ORDER BY `minOrder` ASC [ RunTime:0.005260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61396413 ORDER BY `unit` DESC [ RunTime:0.001404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61396413 LIMIT 2 [ RunTime:0.001045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61396413 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
select * from pdf where partno='MS27496E17A99S' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99S' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000334s ]
SELECT `id` FROM `stock` WHERE `id` <> 61396413 AND `partno` = 'MS27496E17A99S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60072468 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60072468 ORDER BY `minOrder` ASC [ RunTime:0.005842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60072468 ORDER BY `unit` DESC [ RunTime:0.007675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60072468 LIMIT 2 [ RunTime:0.002748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60072468 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='MS27496E17A99SD(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SD(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000460s ]
SELECT `id` FROM `stock` WHERE `id` <> 60072468 AND `partno` = 'MS27496E17A99SD(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726093 [ RunTime:0.003555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60071534 LIMIT 5 [ RunTime:0.007447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60071534 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60071534 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60071534 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60071534 ORDER BY `minOrder` ASC [ RunTime:0.002693s ]
select * from pdf where partno='MS27496E17A99SC(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SC(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005628s ]
SELECT `id` FROM `stock` WHERE `id` <> 60071534 AND `partno` = 'MS27496E17A99SC(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726082 [ RunTime:0.007009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60070567 LIMIT 5 [ RunTime:0.006330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60070567 ORDER BY `minOrder` ASC [ RunTime:0.020426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60070567 ORDER BY `unit` DESC [ RunTime:0.008009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60070567 LIMIT 2 [ RunTime:0.021502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60070567 ORDER BY `minOrder` ASC [ RunTime:0.008385s ]
select * from pdf where partno='MS27496E17A99SB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010975s ]
SELECT `id` FROM `stock` WHERE `id` <> 60070567 AND `partno` = 'MS27496E17A99SB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726102 [ RunTime:0.011700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60068442 LIMIT 5 [ RunTime:0.019342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60068442 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60068442 ORDER BY `unit` DESC [ RunTime:0.005900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60068442 LIMIT 2 [ RunTime:0.009214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60068442 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
select * from pdf where partno='MS27496E17A99SA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99SA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.020432s ]
SELECT `id` FROM `stock` WHERE `id` <> 60068442 AND `partno` = 'MS27496E17A99SA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12941307 [ RunTime:0.023023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60067306 LIMIT 5 [ RunTime:0.024665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60067306 ORDER BY `minOrder` ASC [ RunTime:0.027749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60067306 ORDER BY `unit` DESC [ RunTime:0.022420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60067306 LIMIT 2 [ RunTime:0.004196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60067306 ORDER BY `minOrder` ASC [ RunTime:0.008326s ]
select * from pdf where partno='MS27496E17A99S(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MS27496E17A99S(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018632s ]
SELECT `id` FROM `stock` WHERE `id` <> 60067306 AND `partno` = 'MS27496E17A99S(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12941330 [ RunTime:0.021609s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003600s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001010s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007372s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001954s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013037s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004090s ]
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 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016232s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MS27496E17A99S%' OR `brand` LIKE 'MS27496E17A99S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004278s ]