SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001537s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004057s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17276117 LIMIT 5 [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17276117 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17276117 ORDER BY `unit` DESC [ RunTime:0.003821s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17276117 LIMIT 2 [ RunTime:0.001724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17276117 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17276109 LIMIT 5 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17276109 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17276109 ORDER BY `unit` DESC [ RunTime:0.003226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17276109 LIMIT 2 [ RunTime:0.014623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17276109 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12423930 LIMIT 5 [ RunTime:0.001584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12423930 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12423930 ORDER BY `unit` DESC [ RunTime:0.009486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12423930 LIMIT 2 [ RunTime:0.004858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12423930 ORDER BY `minOrder` ASC [ RunTime:0.002733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12423902 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12423902 ORDER BY `minOrder` ASC [ RunTime:0.019081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12423902 ORDER BY `unit` DESC [ RunTime:0.011446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12423902 LIMIT 2 [ RunTime:0.012968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12423902 ORDER BY `minOrder` ASC [ RunTime:0.002615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11353102 LIMIT 5 [ RunTime:0.010792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11353102 ORDER BY `minOrder` ASC [ RunTime:0.004213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11353102 ORDER BY `unit` DESC [ RunTime:0.000799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11353102 LIMIT 2 [ RunTime:0.002868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11353102 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001859s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827924 LIMIT 5 [ RunTime:0.004413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827924 ORDER BY `minOrder` ASC [ RunTime:0.007770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827924 ORDER BY `unit` DESC [ RunTime:0.005300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827924 LIMIT 2 [ RunTime:0.015341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827924 ORDER BY `minOrder` ASC [ RunTime:0.010688s ]
select * from pdf where partno='M22MP-ASB02-G' and brandshort='Moujen' limit 1 [ RunTime:0.006683s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22MP-ASB02-G' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.007961s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827924 AND `partno` = 'M22MP-ASB02-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.007750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17276117 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827911 LIMIT 5 [ RunTime:0.001397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827911 ORDER BY `minOrder` ASC [ RunTime:0.003455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827911 ORDER BY `unit` DESC [ RunTime:0.004517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827911 LIMIT 2 [ RunTime:0.001354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827911 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='M22MP-ASB02-G-<START>' and brandshort='Moujen' limit 1 [ RunTime:0.002107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22MP-ASB02-G-<START>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.001754s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827911 AND `partno` = 'M22MP-ASB02-G-<START>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12423930 [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827892 LIMIT 5 [ RunTime:0.003130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827892 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827892 ORDER BY `unit` DESC [ RunTime:0.003853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827892 LIMIT 2 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827892 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='M22MP-ASB02-G-<STOP>' and brandshort='Moujen' limit 1 [ RunTime:0.004936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22MP-ASB02-G-<STOP>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.000923s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827892 AND `partno` = 'M22MP-ASB02-G-<STOP>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.003577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17276109 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827879 LIMIT 5 [ RunTime:0.004774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827879 ORDER BY `minOrder` ASC [ RunTime:0.002149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827879 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827879 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827879 ORDER BY `minOrder` ASC [ RunTime:0.001344s ]
select * from pdf where partno='M22MP-ASB02-G-<I>' and brandshort='Moujen' limit 1 [ RunTime:0.001768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22MP-ASB02-G-<I>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.002611s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827879 AND `partno` = 'M22MP-ASB02-G-<I>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.000745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11353102 [ RunTime:0.001468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827864 LIMIT 5 [ RunTime:0.003036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827864 ORDER BY `minOrder` ASC [ RunTime:0.005360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827864 ORDER BY `unit` DESC [ RunTime:0.003482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827864 LIMIT 2 [ RunTime:0.005023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827864 ORDER BY `minOrder` ASC [ RunTime:0.003438s ]
select * from pdf where partno='M22MP-ASB02-G-<O>' and brandshort='Moujen' limit 1 [ RunTime:0.001094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22MP-ASB02-G-<O>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.001785s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827864 AND `partno` = 'M22MP-ASB02-G-<O>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.000935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12423902 [ RunTime:0.000708s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003727s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003242s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001601s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007866s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009146s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006475s ]
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 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007984s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'M22MP-ASB02-G%' OR `brand` LIKE 'M22MP-ASB02-G%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001827s ]