SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001358s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010198s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16081452 LIMIT 5 [ RunTime:0.058763s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16081452 ORDER BY `minOrder` ASC [ RunTime:0.037071s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16081452 ORDER BY `unit` DESC [ RunTime:0.026461s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16081452 LIMIT 2 [ RunTime:0.031984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16081452 ORDER BY `minOrder` ASC [ RunTime:0.036284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19159547 LIMIT 5 [ RunTime:0.066868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19159547 ORDER BY `minOrder` ASC [ RunTime:0.080780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19159547 ORDER BY `unit` DESC [ RunTime:0.023968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19159547 LIMIT 2 [ RunTime:0.009229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19159547 ORDER BY `minOrder` ASC [ RunTime:0.072796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16082890 LIMIT 5 [ RunTime:0.046719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16082890 ORDER BY `minOrder` ASC [ RunTime:0.077553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16082890 ORDER BY `unit` DESC [ RunTime:0.037708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16082890 LIMIT 2 [ RunTime:0.053579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16082890 ORDER BY `minOrder` ASC [ RunTime:0.069546s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019132s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57115457 LIMIT 5 [ RunTime:0.049449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57115457 ORDER BY `minOrder` ASC [ RunTime:0.051174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57115457 ORDER BY `unit` DESC [ RunTime:0.016951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57115457 LIMIT 2 [ RunTime:0.039441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57115457 ORDER BY `minOrder` ASC [ RunTime:0.048606s ]
select * from pdf where partno='MAX4053AESE+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.083028s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4053AESE+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.061177s ]
SELECT `id` FROM `stock` WHERE `id` <> 57115457 AND `partno` = 'MAX4053AESE+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.064824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16081452 [ RunTime:0.125819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57114764 LIMIT 5 [ RunTime:0.142834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57114764 ORDER BY `minOrder` ASC [ RunTime:0.118558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57114764 ORDER BY `unit` DESC [ RunTime:0.214411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57114764 LIMIT 2 [ RunTime:0.106436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57114764 ORDER BY `minOrder` ASC [ RunTime:0.030589s ]
select * from pdf where partno='MAX4053AESE+T' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.117991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4053AESE+T' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.059456s ]
SELECT `id` FROM `stock` WHERE `id` <> 57114764 AND `partno` = 'MAX4053AESE+T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.119703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19159547 [ RunTime:0.045612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57119458 LIMIT 5 [ RunTime:0.052509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57119458 ORDER BY `minOrder` ASC [ RunTime:0.109844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57119458 ORDER BY `unit` DESC [ RunTime:0.069138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57119458 LIMIT 2 [ RunTime:0.031137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57119458 ORDER BY `minOrder` ASC [ RunTime:0.018289s ]
select * from pdf where partno='MAX4053AESE' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.083644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4053AESE' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.076139s ]
SELECT `id` FROM `stock` WHERE `id` <> 57119458 AND `partno` = 'MAX4053AESE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.078611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16082890 [ RunTime:0.108855s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047512s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077178s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.210850s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074030s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.092842s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.120121s ]
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 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075669s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MAX4053AESE%' OR `brand` LIKE 'MAX4053AESE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.049273s ]