SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001554s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037778s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17551532 LIMIT 5 [ RunTime:0.081631s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17551532 ORDER BY `minOrder` ASC [ RunTime:0.062678s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.025936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17551532 ORDER BY `unit` DESC [ RunTime:0.006620s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.090112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17551532 LIMIT 2 [ RunTime:0.077637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17551532 ORDER BY `minOrder` ASC [ RunTime:0.038893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16721172 LIMIT 5 [ RunTime:0.058470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16721172 ORDER BY `minOrder` ASC [ RunTime:0.090353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16721172 ORDER BY `unit` DESC [ RunTime:0.035820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16721172 LIMIT 2 [ RunTime:0.092092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16721172 ORDER BY `minOrder` ASC [ RunTime:0.055822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15579215 LIMIT 5 [ RunTime:0.126731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15579215 ORDER BY `minOrder` ASC [ RunTime:0.134354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15579215 ORDER BY `unit` DESC [ RunTime:0.059015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15579215 LIMIT 2 [ RunTime:0.061679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15579215 ORDER BY `minOrder` ASC [ RunTime:0.042937s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045221s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40400510 LIMIT 5 [ RunTime:0.064268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40400510 ORDER BY `minOrder` ASC [ RunTime:0.077719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40400510 ORDER BY `unit` DESC [ RunTime:0.060051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40400510 LIMIT 2 [ RunTime:0.075066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40400510 ORDER BY `minOrder` ASC [ RunTime:0.070080s ]
select * from pdf where partno='MKP1840310635W' and brandshort='Vishay Beyschlag/Draloric/BC Components' limit 1 [ RunTime:0.052521s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MKP1840310635W' OR `brand` LIKE 'Vishay Beyschlag/Draloric/BC Components%' ) ) LIMIT 1 [ RunTime:0.076816s ]
SELECT `id` FROM `stock` WHERE `id` <> 40400510 AND `partno` = 'MKP1840310635W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay beyschlag/draloric/bc components%' ) [ RunTime:0.080366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15579215 [ RunTime:0.067191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40392512 LIMIT 5 [ RunTime:0.036534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40392512 ORDER BY `minOrder` ASC [ RunTime:0.055779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40392512 ORDER BY `unit` DESC [ RunTime:0.035569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40392512 LIMIT 2 [ RunTime:0.149836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40392512 ORDER BY `minOrder` ASC [ RunTime:0.028595s ]
select * from pdf where partno='MKP1840310635' and brandshort='Vishay Beyschlag/Draloric/BC Components' limit 1 [ RunTime:0.045084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MKP1840310635' OR `brand` LIKE 'Vishay Beyschlag/Draloric/BC Components%' ) ) LIMIT 1 [ RunTime:0.059944s ]
SELECT `id` FROM `stock` WHERE `id` <> 40392512 AND `partno` = 'MKP1840310635' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay beyschlag/draloric/bc components%' ) [ RunTime:0.098504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16721172 [ RunTime:0.120646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40360207 LIMIT 5 [ RunTime:0.147723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40360207 ORDER BY `minOrder` ASC [ RunTime:0.129476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40360207 ORDER BY `unit` DESC [ RunTime:0.045749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40360207 LIMIT 2 [ RunTime:0.161423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40360207 ORDER BY `minOrder` ASC [ RunTime:0.033204s ]
select * from pdf where partno='MKP1840310635M' and brandshort='Vishay Beyschlag/Draloric/BC Components' limit 1 [ RunTime:0.237632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MKP1840310635M' OR `brand` LIKE 'Vishay Beyschlag/Draloric/BC Components%' ) ) LIMIT 1 [ RunTime:0.108259s ]
SELECT `id` FROM `stock` WHERE `id` <> 40360207 AND `partno` = 'MKP1840310635M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay beyschlag/draloric/bc components%' ) [ RunTime:0.052763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17551532 [ RunTime:0.080363s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074047s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087564s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.198907s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.120329s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.183803s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086352s ]
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 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103968s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MKP1840310635%' OR `brand` LIKE 'MKP1840310635%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.108212s ]