SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002069s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002006s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077584 LIMIT 5 [ RunTime:0.007696s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17077584 ORDER BY `minOrder` ASC [ RunTime:0.009633s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17077584 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17077584 LIMIT 2 [ RunTime:0.027962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17077584 ORDER BY `minOrder` ASC [ RunTime:0.005287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19091083 LIMIT 5 [ RunTime:0.025027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19091083 ORDER BY `minOrder` ASC [ RunTime:0.027613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19091083 ORDER BY `unit` DESC [ RunTime:0.034514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19091083 LIMIT 2 [ RunTime:0.022512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19091083 ORDER BY `minOrder` ASC [ RunTime:0.025618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19090778 LIMIT 5 [ RunTime:0.014635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19090778 ORDER BY `minOrder` ASC [ RunTime:0.019070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19090778 ORDER BY `unit` DESC [ RunTime:0.019986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19090778 LIMIT 2 [ RunTime:0.008451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19090778 ORDER BY `minOrder` ASC [ RunTime:0.012998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16039634 LIMIT 5 [ RunTime:0.032445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16039634 ORDER BY `minOrder` ASC [ RunTime:0.013340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16039634 ORDER BY `unit` DESC [ RunTime:0.019141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16039634 LIMIT 2 [ RunTime:0.005768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16039634 ORDER BY `minOrder` ASC [ RunTime:0.016760s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51043516 LIMIT 5 [ RunTime:0.036701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51043516 ORDER BY `minOrder` ASC [ RunTime:0.012074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51043516 ORDER BY `unit` DESC [ RunTime:0.011545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51043516 LIMIT 2 [ RunTime:0.009765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51043516 ORDER BY `minOrder` ASC [ RunTime:0.006538s ]
select * from pdf where partno='mic2544a-2ym' and brandshort='microchip technology' limit 1 [ RunTime:0.005792s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mic2544a-2ym' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.006111s ]
SELECT `id` FROM `stock` WHERE `id` <> 51043516 AND `partno` = 'mic2544a-2ym' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077584 [ RunTime:0.006052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51043632 LIMIT 5 [ RunTime:0.009454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51043632 ORDER BY `minOrder` ASC [ RunTime:0.008499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51043632 ORDER BY `unit` DESC [ RunTime:0.013364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51043632 LIMIT 2 [ RunTime:0.008524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51043632 ORDER BY `minOrder` ASC [ RunTime:0.004923s ]
select * from pdf where partno='mic2544a-2ymm' and brandshort='microchip technology' limit 1 [ RunTime:0.018470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mic2544a-2ymm' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.007157s ]
SELECT `id` FROM `stock` WHERE `id` <> 51043632 AND `partno` = 'mic2544a-2ymm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.040138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19090778 [ RunTime:0.001182s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57037030 LIMIT 5 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57037030 ORDER BY `minOrder` ASC [ RunTime:0.007754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57037030 ORDER BY `unit` DESC [ RunTime:0.001769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57037030 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57037030 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
select * from pdf where partno='MIC2544A-2YM' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC2544A-2YM' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000451s ]
SELECT `id` FROM `stock` WHERE `id` <> 57037030 AND `partno` = 'MIC2544A-2YM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.003740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077584 [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57039665 LIMIT 5 [ RunTime:0.011551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57039665 ORDER BY `minOrder` ASC [ RunTime:0.010422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57039665 ORDER BY `unit` DESC [ RunTime:0.004059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57039665 LIMIT 2 [ RunTime:0.010130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57039665 ORDER BY `minOrder` ASC [ RunTime:0.002869s ]
select * from pdf where partno='MIC2544A-2YMM' and brandshort='Microchip Technology' limit 1 [ RunTime:0.009428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC2544A-2YMM' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008996s ]
SELECT `id` FROM `stock` WHERE `id` <> 57039665 AND `partno` = 'MIC2544A-2YMM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.003650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19090778 [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57039614 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57039614 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57039614 ORDER BY `unit` DESC [ RunTime:0.007141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57039614 LIMIT 2 [ RunTime:0.002053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57039614 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='MIC2544A-2YM-TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.003388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC2544A-2YM-TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.006119s ]
SELECT `id` FROM `stock` WHERE `id` <> 57039614 AND `partno` = 'MIC2544A-2YM-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19091083 [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57039042 LIMIT 5 [ RunTime:0.004072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57039042 ORDER BY `minOrder` ASC [ RunTime:0.002436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57039042 ORDER BY `unit` DESC [ RunTime:0.007049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57039042 LIMIT 2 [ RunTime:0.005618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57039042 ORDER BY `minOrder` ASC [ RunTime:0.001897s ]
select * from pdf where partno='MIC2544A-2YMM-TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.001288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC2544A-2YMM-TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 57039042 AND `partno` = 'MIC2544A-2YMM-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16039634 [ RunTime:0.000920s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002577s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001137s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002425s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017637s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008415s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003327s ]
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 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001339s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MIC2544A-2YM%' OR `brand` LIKE 'MIC2544A-2YM%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004753s ]