SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001688s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013369s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422785 LIMIT 5 [ RunTime:0.040998s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422785 ORDER BY `minOrder` ASC [ RunTime:0.075953s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12422785 ORDER BY `unit` DESC [ RunTime:0.009821s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12422785 LIMIT 2 [ RunTime:0.015044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422785 ORDER BY `minOrder` ASC [ RunTime:0.048314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422739 LIMIT 5 [ RunTime:0.040004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422739 ORDER BY `minOrder` ASC [ RunTime:0.070956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12422739 ORDER BY `unit` DESC [ RunTime:0.095202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12422739 LIMIT 2 [ RunTime:0.032048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422739 ORDER BY `minOrder` ASC [ RunTime:0.011331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422186 LIMIT 5 [ RunTime:0.018737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422186 ORDER BY `minOrder` ASC [ RunTime:0.032380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12422186 ORDER BY `unit` DESC [ RunTime:0.006112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12422186 LIMIT 2 [ RunTime:0.034456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422186 ORDER BY `minOrder` ASC [ RunTime:0.016027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422181 LIMIT 5 [ RunTime:0.001337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422181 ORDER BY `minOrder` ASC [ RunTime:0.047651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12422181 ORDER BY `unit` DESC [ RunTime:0.015526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12422181 LIMIT 2 [ RunTime:0.010525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422181 ORDER BY `minOrder` ASC [ RunTime:0.005819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422172 LIMIT 5 [ RunTime:0.010913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422172 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12422172 ORDER BY `unit` DESC [ RunTime:0.014919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12422172 LIMIT 2 [ RunTime:0.001738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422172 ORDER BY `minOrder` ASC [ RunTime:0.002032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422164 LIMIT 5 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422164 ORDER BY `minOrder` ASC [ RunTime:0.005214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12422164 ORDER BY `unit` DESC [ RunTime:0.009156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12422164 LIMIT 2 [ RunTime:0.001356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12422164 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001734s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827737 LIMIT 5 [ RunTime:0.001884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827737 ORDER BY `minOrder` ASC [ RunTime:0.014162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827737 ORDER BY `unit` DESC [ RunTime:0.009518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827737 LIMIT 2 [ RunTime:0.022960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827737 ORDER BY `minOrder` ASC [ RunTime:0.012046s ]
select * from pdf where partno='M22FP-ASF20-R' and brandshort='Moujen' limit 1 [ RunTime:0.005084s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-ASF20-R' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.004064s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827737 AND `partno` = 'M22FP-ASF20-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.008798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422785 [ RunTime:0.019413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827659 LIMIT 5 [ RunTime:0.009221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827659 ORDER BY `minOrder` ASC [ RunTime:0.010824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827659 ORDER BY `unit` DESC [ RunTime:0.002943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827659 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827659 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='M22FP-ASF20-R-<I>' and brandshort='Moujen' limit 1 [ RunTime:0.001428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-ASF20-R-<I>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.006702s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827659 AND `partno` = 'M22FP-ASF20-R-<I>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.003031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422739 [ RunTime:0.001989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827605 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827605 ORDER BY `minOrder` ASC [ RunTime:0.005514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827605 ORDER BY `unit` DESC [ RunTime:0.003254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827605 LIMIT 2 [ RunTime:0.003606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827605 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='M22FP-ASF20-RO-<I>' and brandshort='Moujen' limit 1 [ RunTime:0.002982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-ASF20-RO-<I>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.000866s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827605 AND `partno` = 'M22FP-ASF20-RO-<I>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.004241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422186 [ RunTime:0.007140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827598 LIMIT 5 [ RunTime:0.007838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827598 ORDER BY `minOrder` ASC [ RunTime:0.004243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827598 ORDER BY `unit` DESC [ RunTime:0.008472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827598 LIMIT 2 [ RunTime:0.012628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827598 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
select * from pdf where partno='M22FP-ASF20-RO-<O>' and brandshort='Moujen' limit 1 [ RunTime:0.001093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-ASF20-RO-<O>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.004912s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827598 AND `partno` = 'M22FP-ASF20-RO-<O>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.002697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422181 [ RunTime:0.002218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827582 LIMIT 5 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827582 ORDER BY `minOrder` ASC [ RunTime:0.001025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827582 ORDER BY `unit` DESC [ RunTime:0.005365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827582 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827582 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='M22FP-ASF20-R-<O>' and brandshort='Moujen' limit 1 [ RunTime:0.001015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-ASF20-R-<O>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.005774s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827582 AND `partno` = 'M22FP-ASF20-R-<O>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.010589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422172 [ RunTime:0.011000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43827573 LIMIT 5 [ RunTime:0.008685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827573 ORDER BY `minOrder` ASC [ RunTime:0.004183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43827573 ORDER BY `unit` DESC [ RunTime:0.008024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43827573 LIMIT 2 [ RunTime:0.014103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43827573 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
select * from pdf where partno='M22FP-ASF20-RO' and brandshort='Moujen' limit 1 [ RunTime:0.011278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-ASF20-RO' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.013790s ]
SELECT `id` FROM `stock` WHERE `id` <> 43827573 AND `partno` = 'M22FP-ASF20-RO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.044641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12422164 [ RunTime:0.044980s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014088s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008167s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016923s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023408s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002736s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007556s ]
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 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003664s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'M22FP-ASF20-R%' OR `brand` LIKE 'M22FP-ASF20-R%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010770s ]