SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001241s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032493s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17273669 LIMIT 5 [ RunTime:0.036565s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17273669 ORDER BY `minOrder` ASC [ RunTime:0.067418s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17273669 ORDER BY `unit` DESC [ RunTime:0.029547s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17273669 LIMIT 2 [ RunTime:0.020313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17273669 ORDER BY `minOrder` ASC [ RunTime:0.007294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419309 LIMIT 5 [ RunTime:0.023908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419309 ORDER BY `minOrder` ASC [ RunTime:0.009115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12419309 ORDER BY `unit` DESC [ RunTime:0.020367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12419309 LIMIT 2 [ RunTime:0.050845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419309 ORDER BY `minOrder` ASC [ RunTime:0.023934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419301 LIMIT 5 [ RunTime:0.065362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419301 ORDER BY `minOrder` ASC [ RunTime:0.017935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12419301 ORDER BY `unit` DESC [ RunTime:0.039096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12419301 LIMIT 2 [ RunTime:0.028191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419301 ORDER BY `minOrder` ASC [ RunTime:0.024137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419282 LIMIT 5 [ RunTime:0.029842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419282 ORDER BY `minOrder` ASC [ RunTime:0.018299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12419282 ORDER BY `unit` DESC [ RunTime:0.023821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12419282 LIMIT 2 [ RunTime:0.019627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419282 ORDER BY `minOrder` ASC [ RunTime:0.024137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11351044 LIMIT 5 [ RunTime:0.019041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11351044 ORDER BY `minOrder` ASC [ RunTime:0.059380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11351044 ORDER BY `unit` DESC [ RunTime:0.065388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11351044 LIMIT 2 [ RunTime:0.044863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11351044 ORDER BY `minOrder` ASC [ RunTime:0.053186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11350877 LIMIT 5 [ RunTime:0.041392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350877 ORDER BY `minOrder` ASC [ RunTime:0.052080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11350877 ORDER BY `unit` DESC [ RunTime:0.090070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11350877 LIMIT 2 [ RunTime:0.079207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350877 ORDER BY `minOrder` ASC [ RunTime:0.036936s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042630s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826896 LIMIT 5 [ RunTime:0.021955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826896 ORDER BY `minOrder` ASC [ RunTime:0.010254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826896 ORDER BY `unit` DESC [ RunTime:0.017148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826896 LIMIT 2 [ RunTime:0.009163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826896 ORDER BY `minOrder` ASC [ RunTime:0.012916s ]
select * from pdf where partno='M22FP-MSF01-W-<I>' and brandshort='Moujen' limit 1 [ RunTime:0.011975s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.012919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-MSF01-W-<I>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.016654s ]
SELECT `id` FROM `stock` WHERE `id` <> 43826896 AND `partno` = 'M22FP-MSF01-W-<I>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.024213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419309 [ RunTime:0.010231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826881 LIMIT 5 [ RunTime:0.026285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826881 ORDER BY `minOrder` ASC [ RunTime:0.014205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826881 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826881 LIMIT 2 [ RunTime:0.005797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826881 ORDER BY `minOrder` ASC [ RunTime:0.033116s ]
select * from pdf where partno='M22FP-MSF01-W-<O>' and brandshort='Moujen' limit 1 [ RunTime:0.022458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-MSF01-W-<O>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.004938s ]
SELECT `id` FROM `stock` WHERE `id` <> 43826881 AND `partno` = 'M22FP-MSF01-W-<O>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.011276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419301 [ RunTime:0.003914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826847 LIMIT 5 [ RunTime:0.019323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826847 ORDER BY `minOrder` ASC [ RunTime:0.017163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826847 ORDER BY `unit` DESC [ RunTime:0.024052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826847 LIMIT 2 [ RunTime:0.018997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826847 ORDER BY `minOrder` ASC [ RunTime:0.006214s ]
select * from pdf where partno='M22FP-MSF01-WO-<I>' and brandshort='Moujen' limit 1 [ RunTime:0.024643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-MSF01-WO-<I>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.011863s ]
SELECT `id` FROM `stock` WHERE `id` <> 43826847 AND `partno` = 'M22FP-MSF01-WO-<I>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.014711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419282 [ RunTime:0.007556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826834 LIMIT 5 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826834 ORDER BY `minOrder` ASC [ RunTime:0.008440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826834 ORDER BY `unit` DESC [ RunTime:0.001295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826834 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826834 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='M22FP-MSF01-WO' and brandshort='Moujen' limit 1 [ RunTime:0.001822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-MSF01-WO' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.007007s ]
SELECT `id` FROM `stock` WHERE `id` <> 43826834 AND `partno` = 'M22FP-MSF01-WO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.012473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11351044 [ RunTime:0.018057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826829 LIMIT 5 [ RunTime:0.011259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826829 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826829 ORDER BY `unit` DESC [ RunTime:0.005321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826829 LIMIT 2 [ RunTime:0.013365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826829 ORDER BY `minOrder` ASC [ RunTime:0.005332s ]
select * from pdf where partno='M22FP-MSF01-W' and brandshort='Moujen' limit 1 [ RunTime:0.005108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-MSF01-W' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.018565s ]
SELECT `id` FROM `stock` WHERE `id` <> 43826829 AND `partno` = 'M22FP-MSF01-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.006823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17273669 [ RunTime:0.017516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826825 LIMIT 5 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826825 ORDER BY `minOrder` ASC [ RunTime:0.013720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826825 ORDER BY `unit` DESC [ RunTime:0.012732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826825 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826825 ORDER BY `minOrder` ASC [ RunTime:0.001741s ]
select * from pdf where partno='M22FP-MSF01-WO-<O>' and brandshort='Moujen' limit 1 [ RunTime:0.002231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M22FP-MSF01-WO-<O>' OR `brand` LIKE 'Moujen%' ) ) LIMIT 1 [ RunTime:0.001082s ]
SELECT `id` FROM `stock` WHERE `id` <> 43826825 AND `partno` = 'M22FP-MSF01-WO-<O>' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%moujen%' ) [ RunTime:0.002194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11350877 [ RunTime:0.013710s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012068s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011044s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011036s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011582s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006490s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004994s ]
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-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012127s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'M22FP-MSF01-W%' OR `brand` LIKE 'M22FP-MSF01-W%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001543s ]