pastebin - collaborative debugging tool
hn.kpaste.net RSS


Untitled
Posted by NotLim on Sun 9th Feb 2014 20:01
raw | new post

  1. | 954196 | gruposan_ronalix | localhost | gruposan_tienda  | Query   |    54 | Copying to tmp table | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
  2.                                         pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
  3.                                         il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
  4.                                         DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
  5.                                         INTERVAL 20
  6.                                                 DAY)) > 0 AS new, product_shop.price AS orderprice
  7.                                 FROM `ps_category_product` cp
  8.                                 LEFT JOIN `ps_product` p
  9.                                         ON p.`id_product` = cp.`id_product`
  10.                                  INNER JOIN ps_product_shop product_shop
  11.                 ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
  12.                                 LEFT JOIN `ps_product_attribute` pa
  13.                                 ON (p.`id_product` = pa.`id_product`)
  14.                                  LEFT JOIN ps_product_attribute_shop product_attribute_shop
  15.                 ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
  16.                                  LEFT
  17.                         JOIN ps_stock_available stock
  18.                         ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  )
  19.                                 LEFT JOIN `ps_category_lang` cl
  20.                                         ON (product_shop.`id_category_default` = cl.`id_category`
  21.                                         AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
  22.                                 LEFT JOIN `ps_product_lang` pl
  23.                                         ON (p.`id_product` = pl.`id_product`
  24.                                         AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
  25.                                 LEFT JOIN `ps_image` i
  26.                                         ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
  27.                 ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
  28.                                 LEFT JOIN `ps_image_lang` il
  29.                                         ON (image_shop.`id_image` = il.`id_image`
  30.                                         AND il.`id_lang` = 1)
  31.                                 LEFT JOIN `ps_manufacturer` m
  32.                                         ON m.`id_manufacturer` = p.`id_manufacturer`
  33.                                 WHERE product_shop.`id_shop` = 1
  34.                                         AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
  35.                         LIMIT 0,100 |
  36. | 954224 | gruposan_ronalix | localhost | gruposan_tienda  | Query   |    43 | Copying to tmp table | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
  37.                                         pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
  38.                                         il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
  39.                                         DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
  40.                                         INTERVAL 20
  41.                                                 DAY)) > 0 AS new, product_shop.price AS orderprice
  42.                                 FROM `ps_category_product` cp
  43.                                 LEFT JOIN `ps_product` p
  44.                                         ON p.`id_product` = cp.`id_product`
  45.                                  INNER JOIN ps_product_shop product_shop
  46.                 ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
  47.                                 LEFT JOIN `ps_product_attribute` pa
  48.                                 ON (p.`id_product` = pa.`id_product`)
  49.                                  LEFT JOIN ps_product_attribute_shop product_attribute_shop
  50.                 ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
  51.                                  LEFT
  52.                         JOIN ps_stock_available stock
  53.                         ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  )
  54.                                 LEFT JOIN `ps_category_lang` cl
  55.                                         ON (product_shop.`id_category_default` = cl.`id_category`
  56.                                         AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
  57.                                 LEFT JOIN `ps_product_lang` pl
  58.                                         ON (p.`id_product` = pl.`id_product`
  59.                                         AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
  60.                                 LEFT JOIN `ps_image` i
  61.                                         ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
  62.                 ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
  63.                                 LEFT JOIN `ps_image_lang` il
  64.                                         ON (image_shop.`id_image` = il.`id_image`
  65.                                         AND il.`id_lang` = 1)
  66.                                 LEFT JOIN `ps_manufacturer` m
  67.                                         ON m.`id_manufacturer` = p.`id_manufacturer`
  68.                                 WHERE product_shop.`id_shop` = 1
  69.                                         AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
  70.                         LIMIT 0,100 |
  71. | 954247 | gruposan_ronalix | localhost | gruposan_tienda  | Query   |    33 | Copying to tmp table | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
  72.                                         pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
  73.                                         il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
  74.                                         DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
  75.                                         INTERVAL 20
  76.                                                 DAY)) > 0 AS new, product_shop.price AS orderprice
  77.                                 FROM `ps_category_product` cp
  78.                                 LEFT JOIN `ps_product` p
  79.                                         ON p.`id_product` = cp.`id_product`
  80.                                  INNER JOIN ps_product_shop product_shop
  81.                 ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
  82.                                 LEFT JOIN `ps_product_attribute` pa
  83.                                 ON (p.`id_product` = pa.`id_product`)
  84.                                  LEFT JOIN ps_product_attribute_shop product_attribute_shop
  85.                 ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
  86.                                  LEFT
  87.                         JOIN ps_stock_available stock
  88.                         ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  )
  89.                                 LEFT JOIN `ps_category_lang` cl
  90.                                         ON (product_shop.`id_category_default` = cl.`id_category`
  91.                                         AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
  92.                                 LEFT JOIN `ps_product_lang` pl
  93.                                         ON (p.`id_product` = pl.`id_product`
  94.                                         AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
  95.                                 LEFT JOIN `ps_image` i
  96.                                         ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
  97.                 ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
  98.                                 LEFT JOIN `ps_image_lang` il
  99.                                         ON (image_shop.`id_image` = il.`id_image`
  100.                                         AND il.`id_lang` = 1)
  101.                                 LEFT JOIN `ps_manufacturer` m
  102.                                         ON m.`id_manufacturer` = p.`id_manufacturer`
  103.                                 WHERE product_shop.`id_shop` = 1
  104.                                         AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
  105.                         LIMIT 0,100 |
  106. | 954280 | gruposan_ronalix | localhost | gruposan_tienda  | Query   |    17 | Copying to tmp table | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
  107.                                         pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
  108.                                         il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
  109.                                         DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
  110.                                         INTERVAL 20
  111.                                                 DAY)) > 0 AS new, product_shop.price AS orderprice
  112.                                 FROM `ps_category_product` cp
  113.                                 LEFT JOIN `ps_product` p
  114.                                         ON p.`id_product` = cp.`id_product`
  115.                                  INNER JOIN ps_product_shop product_shop
  116.                 ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
  117.                                 LEFT JOIN `ps_product_attribute` pa
  118.                                 ON (p.`id_product` = pa.`id_product`)
  119.                                  LEFT JOIN ps_product_attribute_shop product_attribute_shop
  120.                 ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
  121.                                  LEFT
  122.                         JOIN ps_stock_available stock
  123.                         ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  )
  124.                                 LEFT JOIN `ps_category_lang` cl
  125.                                         ON (product_shop.`id_category_default` = cl.`id_category`
  126.                                         AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
  127.                                 LEFT JOIN `ps_product_lang` pl
  128.                                         ON (p.`id_product` = pl.`id_product`
  129.                                         AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
  130.                                 LEFT JOIN `ps_image` i
  131.                                         ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
  132.                 ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
  133.                                 LEFT JOIN `ps_image_lang` il
  134.                                         ON (image_shop.`id_image` = il.`id_image`
  135.                                         AND il.`id_lang` = 1)
  136.                                 LEFT JOIN `ps_manufacturer` m
  137.                                         ON m.`id_manufacturer` = p.`id_manufacturer`
  138.                                 WHERE product_shop.`id_shop` = 1
  139.                                         AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC
  140.                         LIMIT 0,100 |

Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.

Syntax highlighting:

To highlight particular lines, prefix each line with {%HIGHLIGHT}




All content is user-submitted.
The administrators of this site (kpaste.net) are not responsible for their content.
Abuse reports should be emailed to us at