SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002089s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065314s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19065117 LIMIT 5 [ RunTime:0.075875s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19065117 ORDER BY `minOrder` ASC [ RunTime:0.036399s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19065117 ORDER BY `unit` DESC [ RunTime:0.033530s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19065117 LIMIT 2 [ RunTime:0.025432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19065117 ORDER BY `minOrder` ASC [ RunTime:0.002546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15288393 LIMIT 5 [ RunTime:0.046442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15288393 ORDER BY `minOrder` ASC [ RunTime:0.046467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15288393 ORDER BY `unit` DESC [ RunTime:0.052090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15288393 LIMIT 2 [ RunTime:0.018412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15288393 ORDER BY `minOrder` ASC [ RunTime:0.001994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064714 LIMIT 5 [ RunTime:0.008581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064714 ORDER BY `minOrder` ASC [ RunTime:0.072202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19064714 ORDER BY `unit` DESC [ RunTime:0.071028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19064714 LIMIT 2 [ RunTime:0.027787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064714 ORDER BY `minOrder` ASC [ RunTime:0.017097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16026672 LIMIT 5 [ RunTime:0.034677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16026672 ORDER BY `minOrder` ASC [ RunTime:0.017253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16026672 ORDER BY `unit` DESC [ RunTime:0.009253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16026672 LIMIT 2 [ RunTime:0.048664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16026672 ORDER BY `minOrder` ASC [ RunTime:0.009055s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051898s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63823463 LIMIT 5 [ RunTime:0.066919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63823463 ORDER BY `minOrder` ASC [ RunTime:0.047879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63823463 ORDER BY `unit` DESC [ RunTime:0.026458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63823463 LIMIT 2 [ RunTime:0.004191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63823463 ORDER BY `minOrder` ASC [ RunTime:0.026723s ]
select * from pdf where partno='LTC4162IUFD-L40M#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.071385s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC4162IUFD-L40M#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.046738s ]
SELECT `id` FROM `stock` WHERE `id` <> 63823463 AND `partno` = 'LTC4162IUFD-L40M#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.041352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15288393 [ RunTime:0.031288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63824203 LIMIT 5 [ RunTime:0.034805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63824203 ORDER BY `minOrder` ASC [ RunTime:0.016455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63824203 ORDER BY `unit` DESC [ RunTime:0.019957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63824203 LIMIT 2 [ RunTime:0.025143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63824203 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
select * from pdf where partno='LTC4162IUFD-L40#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.026679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC4162IUFD-L40#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.009644s ]
SELECT `id` FROM `stock` WHERE `id` <> 63824203 AND `partno` = 'LTC4162IUFD-L40#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.044793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19065117 [ RunTime:0.013295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63826670 LIMIT 5 [ RunTime:0.024070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63826670 ORDER BY `minOrder` ASC [ RunTime:0.052901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63826670 ORDER BY `unit` DESC [ RunTime:0.021736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63826670 LIMIT 2 [ RunTime:0.044460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63826670 ORDER BY `minOrder` ASC [ RunTime:0.018954s ]
select * from pdf where partno='LTC4162IUFD-L40M#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.009188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC4162IUFD-L40M#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.005651s ]
SELECT `id` FROM `stock` WHERE `id` <> 63826670 AND `partno` = 'LTC4162IUFD-L40M#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.005828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064714 [ RunTime:0.011812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63826669 LIMIT 5 [ RunTime:0.005732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63826669 ORDER BY `minOrder` ASC [ RunTime:0.003890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63826669 ORDER BY `unit` DESC [ RunTime:0.018948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63826669 LIMIT 2 [ RunTime:0.010783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63826669 ORDER BY `minOrder` ASC [ RunTime:0.012714s ]
select * from pdf where partno='LTC4162IUFD-L40#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.025060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC4162IUFD-L40#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.009572s ]
SELECT `id` FROM `stock` WHERE `id` <> 63826669 AND `partno` = 'LTC4162IUFD-L40#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.010411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16026672 [ RunTime:0.014299s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002048s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004859s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014051s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007572s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004856s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001561s ]
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 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002557s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LTC4162IUFD-L40%' OR `brand` LIKE 'LTC4162IUFD-L40%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013786s ]