SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003005s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043211s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14225528 LIMIT 5 [ RunTime:0.046075s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14225528 ORDER BY `minOrder` ASC [ RunTime:0.025057s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14225528 ORDER BY `unit` DESC [ RunTime:0.051592s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14225528 LIMIT 2 [ RunTime:0.031156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14225528 ORDER BY `minOrder` ASC [ RunTime:0.046669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19133393 LIMIT 5 [ RunTime:0.062211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19133393 ORDER BY `minOrder` ASC [ RunTime:0.044781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19133393 ORDER BY `unit` DESC [ RunTime:0.056588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19133393 LIMIT 2 [ RunTime:0.079769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19133393 ORDER BY `minOrder` ASC [ RunTime:0.049630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134351 LIMIT 5 [ RunTime:0.118285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134351 ORDER BY `minOrder` ASC [ RunTime:0.134646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19134351 ORDER BY `unit` DESC [ RunTime:0.064823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19134351 LIMIT 2 [ RunTime:0.131146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134351 ORDER BY `minOrder` ASC [ RunTime:0.042926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131881 LIMIT 5 [ RunTime:0.071899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131881 ORDER BY `minOrder` ASC [ RunTime:0.125777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19131881 ORDER BY `unit` DESC [ RunTime:0.048937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19131881 LIMIT 2 [ RunTime:0.033571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131881 ORDER BY `minOrder` ASC [ RunTime:0.013645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19130852 LIMIT 5 [ RunTime:0.044634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19130852 ORDER BY `minOrder` ASC [ RunTime:0.020260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19130852 ORDER BY `unit` DESC [ RunTime:0.185607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19130852 LIMIT 2 [ RunTime:0.082243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19130852 ORDER BY `minOrder` ASC [ RunTime:0.029401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314522 LIMIT 5 [ RunTime:0.073167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314522 ORDER BY `minOrder` ASC [ RunTime:0.015924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15314522 ORDER BY `unit` DESC [ RunTime:0.079916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15314522 LIMIT 2 [ RunTime:0.093347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314522 ORDER BY `minOrder` ASC [ RunTime:0.006541s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072668s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63873354 LIMIT 5 [ RunTime:0.107875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63873354 ORDER BY `minOrder` ASC [ RunTime:0.187628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63873354 ORDER BY `unit` DESC [ RunTime:0.126351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63873354 LIMIT 2 [ RunTime:0.100768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63873354 ORDER BY `minOrder` ASC [ RunTime:0.076072s ]
select * from pdf where partno='LTC1261LIS8-4.5#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.109072s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4.5#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.091540s ]
SELECT `id` FROM `stock` WHERE `id` <> 63873354 AND `partno` = 'LTC1261LIS8-4.5#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.131842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14225528 [ RunTime:0.058533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63873355 LIMIT 5 [ RunTime:0.069933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63873355 ORDER BY `minOrder` ASC [ RunTime:0.051054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63873355 ORDER BY `unit` DESC [ RunTime:0.227867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63873355 LIMIT 2 [ RunTime:0.052522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63873355 ORDER BY `minOrder` ASC [ RunTime:0.096356s ]
select * from pdf where partno='LTC1261LIS8#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.058551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.094028s ]
SELECT `id` FROM `stock` WHERE `id` <> 63873355 AND `partno` = 'LTC1261LIS8#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.086068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19133393 [ RunTime:0.076592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63875615 LIMIT 5 [ RunTime:0.051497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63875615 ORDER BY `minOrder` ASC [ RunTime:0.126021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63875615 ORDER BY `unit` DESC [ RunTime:0.080430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63875615 LIMIT 2 [ RunTime:0.248566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63875615 ORDER BY `minOrder` ASC [ RunTime:0.080606s ]
select * from pdf where partno='LTC1261LIS8-4#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.056805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.051202s ]
SELECT `id` FROM `stock` WHERE `id` <> 63875615 AND `partno` = 'LTC1261LIS8-4#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.188967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134351 [ RunTime:0.055558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63900374 LIMIT 5 [ RunTime:0.160496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900374 ORDER BY `minOrder` ASC [ RunTime:0.056138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63900374 ORDER BY `unit` DESC [ RunTime:0.068117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63900374 LIMIT 2 [ RunTime:0.127599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900374 ORDER BY `minOrder` ASC [ RunTime:0.051557s ]
select * from pdf where partno='LTC1261LIS8-4#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.088188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.040137s ]
SELECT `id` FROM `stock` WHERE `id` <> 63900374 AND `partno` = 'LTC1261LIS8-4#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.057605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19130852 [ RunTime:0.017638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63900373 LIMIT 5 [ RunTime:0.069323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900373 ORDER BY `minOrder` ASC [ RunTime:0.099853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63900373 ORDER BY `unit` DESC [ RunTime:0.003001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63900373 LIMIT 2 [ RunTime:0.233334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900373 ORDER BY `minOrder` ASC [ RunTime:0.082608s ]
select * from pdf where partno='LTC1261LIS8#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.074757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.057979s ]
SELECT `id` FROM `stock` WHERE `id` <> 63900373 AND `partno` = 'LTC1261LIS8#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.059171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314522 [ RunTime:0.122443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63900371 LIMIT 5 [ RunTime:0.116946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900371 ORDER BY `minOrder` ASC [ RunTime:0.077951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63900371 ORDER BY `unit` DESC [ RunTime:0.056376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63900371 LIMIT 2 [ RunTime:0.029200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900371 ORDER BY `minOrder` ASC [ RunTime:0.040457s ]
select * from pdf where partno='LTC1261LIS8-4.5#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.107796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4.5#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.121847s ]
SELECT `id` FROM `stock` WHERE `id` <> 63900371 AND `partno` = 'LTC1261LIS8-4.5#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.051268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131881 [ RunTime:0.046759s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.109989s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.122129s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078973s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093164s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.116727s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.169475s ]
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 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.095654s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LTC1261LIS8%' OR `brand` LIKE 'LTC1261LIS8%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.058110s ]