SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001748s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021943s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.033892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14225528 LIMIT 5 [ RunTime:0.025063s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.025210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14225528 ORDER BY `minOrder` ASC [ RunTime:0.041653s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14225528 ORDER BY `unit` DESC [ RunTime:0.045188s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.025028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14225528 LIMIT 2 [ RunTime:0.025938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14225528 ORDER BY `minOrder` ASC [ RunTime:0.043147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134351 LIMIT 5 [ RunTime:0.068855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134351 ORDER BY `minOrder` ASC [ RunTime:0.008731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19134351 ORDER BY `unit` DESC [ RunTime:0.038882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19134351 LIMIT 2 [ RunTime:0.024982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134351 ORDER BY `minOrder` ASC [ RunTime:0.007776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131881 LIMIT 5 [ RunTime:0.051350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131881 ORDER BY `minOrder` ASC [ RunTime:0.059688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19131881 ORDER BY `unit` DESC [ RunTime:0.099138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19131881 LIMIT 2 [ RunTime:0.046548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131881 ORDER BY `minOrder` ASC [ RunTime:0.051793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19130852 LIMIT 5 [ RunTime:0.035058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19130852 ORDER BY `minOrder` ASC [ RunTime:0.183685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19130852 ORDER BY `unit` DESC [ RunTime:0.040335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19130852 LIMIT 2 [ RunTime:0.046734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19130852 ORDER BY `minOrder` ASC [ RunTime:0.014688s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.088624s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63873354 LIMIT 5 [ RunTime:0.041204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63873354 ORDER BY `minOrder` ASC [ RunTime:0.046387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63873354 ORDER BY `unit` DESC [ RunTime:0.048177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63873354 LIMIT 2 [ RunTime:0.017054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63873354 ORDER BY `minOrder` ASC [ RunTime:0.040526s ]
select * from pdf where partno='LTC1261LIS8-4.5#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.020463s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4.5#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.049373s ]
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.034923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14225528 [ RunTime:0.030194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63875615 LIMIT 5 [ RunTime:0.022908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63875615 ORDER BY `minOrder` ASC [ RunTime:0.046161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63875615 ORDER BY `unit` DESC [ RunTime:0.022561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63875615 LIMIT 2 [ RunTime:0.007340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63875615 ORDER BY `minOrder` ASC [ RunTime:0.011527s ]
select * from pdf where partno='LTC1261LIS8-4#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.026818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.006263s ]
SELECT `id` FROM `stock` WHERE `id` <> 63875615 AND `partno` = 'LTC1261LIS8-4#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.012678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134351 [ RunTime:0.005355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63900374 LIMIT 5 [ RunTime:0.001454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900374 ORDER BY `minOrder` ASC [ RunTime:0.003693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63900374 ORDER BY `unit` DESC [ RunTime:0.014371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63900374 LIMIT 2 [ RunTime:0.002418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900374 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
select * from pdf where partno='LTC1261LIS8-4#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.002956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.014589s ]
SELECT `id` FROM `stock` WHERE `id` <> 63900374 AND `partno` = 'LTC1261LIS8-4#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.004881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19130852 [ RunTime:0.005158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63900371 LIMIT 5 [ RunTime:0.002121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900371 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63900371 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63900371 LIMIT 2 [ RunTime:0.007457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63900371 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
select * from pdf where partno='LTC1261LIS8-4.5#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.008412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC1261LIS8-4.5#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.000872s ]
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.000726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131881 [ RunTime:0.000613s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004594s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014343s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013929s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003141s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005449s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030605s ]
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-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017979s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LTC1261LIS8-4%' OR `brand` LIKE 'LTC1261LIS8-4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004291s ]