SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002293s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044958s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13959124 LIMIT 5 [ RunTime:0.054950s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.039005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13959124 ORDER BY `minOrder` ASC [ RunTime:0.023409s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.045269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13959124 ORDER BY `unit` DESC [ RunTime:0.013517s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13959124 LIMIT 2 [ RunTime:0.032834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13959124 ORDER BY `minOrder` ASC [ RunTime:0.033824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17551606 LIMIT 5 [ RunTime:0.025860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17551606 ORDER BY `minOrder` ASC [ RunTime:0.080984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17551606 ORDER BY `unit` DESC [ RunTime:0.048069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17551606 LIMIT 2 [ RunTime:0.080257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17551606 ORDER BY `minOrder` ASC [ RunTime:0.075722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16715508 LIMIT 5 [ RunTime:0.072789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16715508 ORDER BY `minOrder` ASC [ RunTime:0.033709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16715508 ORDER BY `unit` DESC [ RunTime:0.037880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16715508 LIMIT 2 [ RunTime:0.069664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16715508 ORDER BY `minOrder` ASC [ RunTime:0.021135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14877309 LIMIT 5 [ RunTime:0.098429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14877309 ORDER BY `minOrder` ASC [ RunTime:0.105222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14877309 ORDER BY `unit` DESC [ RunTime:0.053322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14877309 LIMIT 2 [ RunTime:0.101634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14877309 ORDER BY `minOrder` ASC [ RunTime:0.012203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13963184 LIMIT 5 [ RunTime:0.039237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13963184 ORDER BY `minOrder` ASC [ RunTime:0.040195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13963184 ORDER BY `unit` DESC [ RunTime:0.059915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13963184 LIMIT 2 [ RunTime:0.030232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13963184 ORDER BY `minOrder` ASC [ RunTime:0.003669s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021885s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40309477 LIMIT 5 [ RunTime:0.028607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40309477 ORDER BY `minOrder` ASC [ RunTime:0.006493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40309477 ORDER BY `unit` DESC [ RunTime:0.035266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40309477 LIMIT 2 [ RunTime:0.006878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40309477 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='ECW-FA2J124J' and brandshort='Panasonic Industry' limit 1 [ RunTime:0.020557s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECW-FA2J124J' OR `brand` LIKE 'Panasonic Industry%' ) ) LIMIT 1 [ RunTime:0.022062s ]
SELECT `id` FROM `stock` WHERE `id` <> 40309477 AND `partno` = 'ECW-FA2J124J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industry%' ) [ RunTime:0.058085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40362783 LIMIT 5 [ RunTime:0.019674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40362783 ORDER BY `minOrder` ASC [ RunTime:0.022341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40362783 ORDER BY `unit` DESC [ RunTime:0.023283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40362783 LIMIT 2 [ RunTime:0.024882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40362783 ORDER BY `minOrder` ASC [ RunTime:0.069712s ]
select * from pdf where partno='ECW-FA2J124J4' and brandshort='Panasonic Industry' limit 1 [ RunTime:0.015042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECW-FA2J124J4' OR `brand` LIKE 'Panasonic Industry%' ) ) LIMIT 1 [ RunTime:0.015617s ]
SELECT `id` FROM `stock` WHERE `id` <> 40362783 AND `partno` = 'ECW-FA2J124J4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industry%' ) [ RunTime:0.027599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40362782 LIMIT 5 [ RunTime:0.058702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40362782 ORDER BY `minOrder` ASC [ RunTime:0.046162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40362782 ORDER BY `unit` DESC [ RunTime:0.027532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40362782 LIMIT 2 [ RunTime:0.016144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40362782 ORDER BY `minOrder` ASC [ RunTime:0.018411s ]
select * from pdf where partno='ECW-FA2J124J5' and brandshort='Panasonic Industry' limit 1 [ RunTime:0.022758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECW-FA2J124J5' OR `brand` LIKE 'Panasonic Industry%' ) ) LIMIT 1 [ RunTime:0.014122s ]
SELECT `id` FROM `stock` WHERE `id` <> 40362782 AND `partno` = 'ECW-FA2J124J5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industry%' ) [ RunTime:0.017064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40360518 LIMIT 5 [ RunTime:0.019288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40360518 ORDER BY `minOrder` ASC [ RunTime:0.024343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40360518 ORDER BY `unit` DESC [ RunTime:0.015071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40360518 LIMIT 2 [ RunTime:0.029013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40360518 ORDER BY `minOrder` ASC [ RunTime:0.010560s ]
select * from pdf where partno='ECW-FA2J124JQ' and brandshort='Panasonic Industry' limit 1 [ RunTime:0.003125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECW-FA2J124JQ' OR `brand` LIKE 'Panasonic Industry%' ) ) LIMIT 1 [ RunTime:0.016660s ]
SELECT `id` FROM `stock` WHERE `id` <> 40360518 AND `partno` = 'ECW-FA2J124JQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industry%' ) [ RunTime:0.026609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40360517 LIMIT 5 [ RunTime:0.012031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40360517 ORDER BY `minOrder` ASC [ RunTime:0.034812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40360517 ORDER BY `unit` DESC [ RunTime:0.046098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40360517 LIMIT 2 [ RunTime:0.038125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40360517 ORDER BY `minOrder` ASC [ RunTime:0.038379s ]
select * from pdf where partno='ECW-FA2J124JB' and brandshort='Panasonic Industry' limit 1 [ RunTime:0.014495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECW-FA2J124JB' OR `brand` LIKE 'Panasonic Industry%' ) ) LIMIT 1 [ RunTime:0.033365s ]
SELECT `id` FROM `stock` WHERE `id` <> 40360517 AND `partno` = 'ECW-FA2J124JB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industry%' ) [ RunTime:0.030269s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066583s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025539s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019575s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008300s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036042s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039313s ]
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 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019683s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ECW-FA2J124J%' OR `brand` LIKE 'ECW-FA2J124J%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013408s ]