SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002118s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006611s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11128165 LIMIT 5 [ RunTime:0.039292s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11128165 ORDER BY `minOrder` ASC [ RunTime:0.017159s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11128165 ORDER BY `unit` DESC [ RunTime:0.018480s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11128165 LIMIT 2 [ RunTime:0.023688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11128165 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12084059 LIMIT 5 [ RunTime:0.015172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12084059 ORDER BY `minOrder` ASC [ RunTime:0.037384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12084059 ORDER BY `unit` DESC [ RunTime:0.028916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12084059 LIMIT 2 [ RunTime:0.053983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12084059 ORDER BY `minOrder` ASC [ RunTime:0.030033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083683 LIMIT 5 [ RunTime:0.027348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083683 ORDER BY `minOrder` ASC [ RunTime:0.018151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12083683 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12083683 LIMIT 2 [ RunTime:0.020945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083683 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083530 LIMIT 5 [ RunTime:0.038292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083530 ORDER BY `minOrder` ASC [ RunTime:0.017388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12083530 ORDER BY `unit` DESC [ RunTime:0.050752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12083530 LIMIT 2 [ RunTime:0.014965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083530 ORDER BY `minOrder` ASC [ RunTime:0.031776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083492 LIMIT 5 [ RunTime:0.016106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083492 ORDER BY `minOrder` ASC [ RunTime:0.018173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12083492 ORDER BY `unit` DESC [ RunTime:0.023129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12083492 LIMIT 2 [ RunTime:0.029546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083492 ORDER BY `minOrder` ASC [ RunTime:0.020875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083488 LIMIT 5 [ RunTime:0.025452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083488 ORDER BY `minOrder` ASC [ RunTime:0.013296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12083488 ORDER BY `unit` DESC [ RunTime:0.012104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12083488 LIMIT 2 [ RunTime:0.005873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12083488 ORDER BY `minOrder` ASC [ RunTime:0.015043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11128957 LIMIT 5 [ RunTime:0.031396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11128957 ORDER BY `minOrder` ASC [ RunTime:0.024327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11128957 ORDER BY `unit` DESC [ RunTime:0.001284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11128957 LIMIT 2 [ RunTime:0.002948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11128957 ORDER BY `minOrder` ASC [ RunTime:0.010104s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007549s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41601583 LIMIT 5 [ RunTime:0.020202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41601583 ORDER BY `minOrder` ASC [ RunTime:0.003660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41601583 ORDER BY `unit` DESC [ RunTime:0.014739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41601583 LIMIT 2 [ RunTime:0.006554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41601583 ORDER BY `minOrder` ASC [ RunTime:0.014144s ]
select * from pdf where partno='LHA75F-15' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.001882s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000575s ]
SELECT `id` FROM `stock` WHERE `id` <> 41601583 AND `partno` = 'LHA75F-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.002610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11128165 [ RunTime:0.004864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41623976 LIMIT 5 [ RunTime:0.004236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41623976 ORDER BY `minOrder` ASC [ RunTime:0.010819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41623976 ORDER BY `unit` DESC [ RunTime:0.018516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41623976 LIMIT 2 [ RunTime:0.018229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41623976 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='LHA75F-15-SNY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.031364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-SNY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.010587s ]
SELECT `id` FROM `stock` WHERE `id` <> 41623976 AND `partno` = 'LHA75F-15-SNY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.016622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12084059 [ RunTime:0.017369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41623220 LIMIT 5 [ RunTime:0.001496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41623220 ORDER BY `minOrder` ASC [ RunTime:0.001146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41623220 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41623220 LIMIT 2 [ RunTime:0.006258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41623220 ORDER BY `minOrder` ASC [ RunTime:0.007998s ]
select * from pdf where partno='LHA75F-15-SN' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.024734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-SN' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.047503s ]
SELECT `id` FROM `stock` WHERE `id` <> 41623220 AND `partno` = 'LHA75F-15-SN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.046213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41623030 LIMIT 5 [ RunTime:0.050151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41623030 ORDER BY `minOrder` ASC [ RunTime:0.069016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41623030 ORDER BY `unit` DESC [ RunTime:0.006911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41623030 LIMIT 2 [ RunTime:0.008632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41623030 ORDER BY `minOrder` ASC [ RunTime:0.028084s ]
select * from pdf where partno='LHA75F-15-S' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.019755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-S' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.032356s ]
SELECT `id` FROM `stock` WHERE `id` <> 41623030 AND `partno` = 'LHA75F-15-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.024838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11128957 [ RunTime:0.019090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41622050 LIMIT 5 [ RunTime:0.010185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41622050 ORDER BY `minOrder` ASC [ RunTime:0.008985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41622050 ORDER BY `unit` DESC [ RunTime:0.014121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41622050 LIMIT 2 [ RunTime:0.028999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41622050 ORDER BY `minOrder` ASC [ RunTime:0.002451s ]
select * from pdf where partno='LHA75F-15-C' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.002355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-C' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.020733s ]
SELECT `id` FROM `stock` WHERE `id` <> 41622050 AND `partno` = 'LHA75F-15-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.001853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083683 [ RunTime:0.005729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41621028 LIMIT 5 [ RunTime:0.013838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41621028 ORDER BY `minOrder` ASC [ RunTime:0.026483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41621028 ORDER BY `unit` DESC [ RunTime:0.012153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41621028 LIMIT 2 [ RunTime:0.016129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41621028 ORDER BY `minOrder` ASC [ RunTime:0.005399s ]
select * from pdf where partno='LHA75F-15-Y' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.027467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-Y' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.013716s ]
SELECT `id` FROM `stock` WHERE `id` <> 41621028 AND `partno` = 'LHA75F-15-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.037086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083530 [ RunTime:0.023780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41620819 LIMIT 5 [ RunTime:0.020369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41620819 ORDER BY `minOrder` ASC [ RunTime:0.022026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41620819 ORDER BY `unit` DESC [ RunTime:0.018562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41620819 LIMIT 2 [ RunTime:0.002762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41620819 ORDER BY `minOrder` ASC [ RunTime:0.011520s ]
select * from pdf where partno='LHA75F-15-J4' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.014407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-J4' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.005401s ]
SELECT `id` FROM `stock` WHERE `id` <> 41620819 AND `partno` = 'LHA75F-15-J4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.030665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083492 [ RunTime:0.041487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41620815 LIMIT 5 [ RunTime:0.017028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41620815 ORDER BY `minOrder` ASC [ RunTime:0.030751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41620815 ORDER BY `unit` DESC [ RunTime:0.014457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41620815 LIMIT 2 [ RunTime:0.004165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41620815 ORDER BY `minOrder` ASC [ RunTime:0.001631s ]
select * from pdf where partno='LHA75F-15-G' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.004149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LHA75F-15-G' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.003289s ]
SELECT `id` FROM `stock` WHERE `id` <> 41620815 AND `partno` = 'LHA75F-15-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.008373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12083488 [ RunTime:0.017084s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009382s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019024s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010282s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016903s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021986s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005162s ]
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 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023754s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LHA75F-15%' OR `brand` LIKE 'LHA75F-15%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020303s ]