SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001379s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025045s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15322430 LIMIT 5 [ RunTime:0.036806s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15322430 ORDER BY `minOrder` ASC [ RunTime:0.015994s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15322430 ORDER BY `unit` DESC [ RunTime:0.032135s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15322430 LIMIT 2 [ RunTime:0.024701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15322430 ORDER BY `minOrder` ASC [ RunTime:0.010108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19167090 LIMIT 5 [ RunTime:0.042488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19167090 ORDER BY `minOrder` ASC [ RunTime:0.009819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19167090 ORDER BY `unit` DESC [ RunTime:0.002129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19167090 LIMIT 2 [ RunTime:0.002961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19167090 ORDER BY `minOrder` ASC [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17101851 LIMIT 5 [ RunTime:0.036368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17101851 ORDER BY `minOrder` ASC [ RunTime:0.022091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17101851 ORDER BY `unit` DESC [ RunTime:0.024873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17101851 LIMIT 2 [ RunTime:0.011499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17101851 ORDER BY `minOrder` ASC [ RunTime:0.010642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16084747 LIMIT 5 [ RunTime:0.034253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16084747 ORDER BY `minOrder` ASC [ RunTime:0.058806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16084747 ORDER BY `unit` DESC [ RunTime:0.020440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16084747 LIMIT 2 [ RunTime:0.034767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16084747 ORDER BY `minOrder` ASC [ RunTime:0.022511s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017250s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63810564 LIMIT 5 [ RunTime:0.021427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63810564 ORDER BY `minOrder` ASC [ RunTime:0.034415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63810564 ORDER BY `unit` DESC [ RunTime:0.010490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63810564 LIMIT 2 [ RunTime:0.034379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63810564 ORDER BY `minOrder` ASC [ RunTime:0.010848s ]
select * from pdf where partno='MAX242CWN+T' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.059989s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX242CWN+T' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.026465s ]
SELECT `id` FROM `stock` WHERE `id` <> 63810564 AND `partno` = 'MAX242CWN+T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.012331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15322430 [ RunTime:0.014088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63810565 LIMIT 5 [ RunTime:0.017864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63810565 ORDER BY `minOrder` ASC [ RunTime:0.015263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63810565 ORDER BY `unit` DESC [ RunTime:0.008119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63810565 LIMIT 2 [ RunTime:0.015120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63810565 ORDER BY `minOrder` ASC [ RunTime:0.007491s ]
select * from pdf where partno='MAX242CWN+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.018264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX242CWN+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.008073s ]
SELECT `id` FROM `stock` WHERE `id` <> 63810565 AND `partno` = 'MAX242CWN+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.015602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19167090 [ RunTime:0.008966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63818437 LIMIT 5 [ RunTime:0.013013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63818437 ORDER BY `minOrder` ASC [ RunTime:0.020168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63818437 ORDER BY `unit` DESC [ RunTime:0.001777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63818437 LIMIT 2 [ RunTime:0.002983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63818437 ORDER BY `minOrder` ASC [ RunTime:0.012296s ]
select * from pdf where partno='MAX242CWN' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.007153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX242CWN' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.016438s ]
SELECT `id` FROM `stock` WHERE `id` <> 63818437 AND `partno` = 'MAX242CWN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.012099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17101851 [ RunTime:0.001982s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024920s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013776s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014027s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008312s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010490s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008644s ]
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 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026105s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MAX242CWN%' OR `brand` LIKE 'MAX242CWN%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005545s ]