Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_

[]

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  listini l0_

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_;

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1

[
  "/en-ot/shoponline/giacca-w-summer-recy-shiny.CN.GS222303WREL?color=RELPB"
]

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.old_url AS old_url_3,
  t0.new_url AS new_url_4
FROM
  redirects t0
WHERE
  t0.old_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = '/en-ot/shoponline/giacca-w-summer-recy-shiny.CN.GS222303WREL?color=RELPB' LIMIT 1;

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1

[
  "/en-ot/shoponline/giacca-w-summer-recy-shiny.CN.GS222303WREL?color=RELPB"
]

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.old_url AS old_url_3,
  t0.new_url AS new_url_4
FROM
  redirects t0
WHERE
  t0.old_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = '/en-ot/shoponline/giacca-w-summer-recy-shiny.CN.GS222303WREL?color=RELPB' LIMIT 1;

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_

[]

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  listini l0_

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_;

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.label AS label_3
FROM
  langs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.id = '2';

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.id = ?

[
  "3"
]

SELECT
  t0.id AS id_1,
  t0.listino AS listino_2,
  t0.currency_id AS currency_id_3
FROM
  listini t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.id = '3';

SELECT t0.id AS id_1, t0.product AS product_2, t0.ean13 AS ean13_3, t0.product_name AS product_name_4, t0.product_url AS product_url_5, t0.commodity_code AS commodity_code_6, t0.brand AS brand_7, t0.collection AS collection_8, t0.category AS category_9, t0.is_online AS is_online_10, t0.in_home AS in_home_11, t0.is_to_show AS is_to_show_12, t0.label AS label_13, t0.linea_id AS linea_id_14 FROM products t0 WHERE t0.product = ? LIMIT 1

[
  "CN.GS222303WREL"
]

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.ean13 AS ean13_3,
  t0.product_name AS product_name_4,
  t0.product_url AS product_url_5,
  t0.commodity_code AS commodity_code_6,
  t0.brand AS brand_7,
  t0.collection AS collection_8,
  t0.category AS category_9,
  t0.is_online AS is_online_10,
  t0.in_home AS in_home_11,
  t0.is_to_show AS is_to_show_12,
  t0.label AS label_13,
  t0.linea_id AS linea_id_14
FROM
  products t0
WHERE
  t0.product = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product AS product_2, t0.ean13 AS ean13_3, t0.product_name AS product_name_4, t0.product_url AS product_url_5, t0.commodity_code AS commodity_code_6, t0.brand AS brand_7, t0.collection AS collection_8, t0.category AS category_9, t0.is_online AS is_online_10, t0.in_home AS in_home_11, t0.is_to_show AS is_to_show_12, t0.label AS label_13, t0.linea_id AS linea_id_14 FROM products t0 WHERE t0.product = 'CN.GS222303WREL' LIMIT 1;

SELECT t0.id AS id_1, t0.region_name AS region_name_2, t0.region_code AS region_code_3, t0.ordine AS ordine_4, t0.lang_id AS lang_id_5, t0.currency_id AS currency_id_6, t0.listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0.region_code = ? LIMIT 1

[
  "uk"
]

SELECT
  t0.id AS id_1,
  t0.region_name AS region_name_2,
  t0.region_code AS region_code_3,
  t0.ordine AS ordine_4,
  t0.lang_id AS lang_id_5,
  t0.currency_id AS currency_id_6,
  t0.listino_id AS listino_id_7
FROM
  shipping_regions t0
WHERE
  t0.region_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.region_name AS region_name_2, t0.region_code AS region_code_3, t0.ordine AS ordine_4, t0.lang_id AS lang_id_5, t0.currency_id AS currency_id_6, t0.listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0.region_code = 'uk' LIMIT 1;

SELECT ps.*, c.color, s.size, sc.conversion, pr.price, pr.discounted_price, pr.lowest_price, pr.discount_percentage, pr.discounted_price_from, pr.discounted_price_to, pr.shipping_region_id,
                (
                    SELECT
                       CONVERT(GROUP_CONCAT(
                           CONCAT_WS(
                                '|',
                                phototype_id, phototype_name, photo_path, photo_path_reduced
                            )
                       ) USING utf8mb4)
                    FROM skews_photos sp
                    WHERE sp.product_id = ps.product_id
                    AND sp.color_id = ps.color_id
                    AND season_id IN (
                        SELECT MAX(season_id)
                            FROM skews_photos
                            WHERE product_id = ps.product_id
                            AND color_id = ps.color_id
                    )
                    ORDER BY phototype_id ASC
                ) AS path
                FROM products_skews AS ps
                INNER JOIN colors AS c ON c.id = ps.color_id
                INNER JOIN sizes AS s ON s.id = ps.size_id
                LEFT JOIN size_conversion AS sc ON sc.size = s.size AND linea_id = 14 /* AND listino = 'it'*/
                LEFT JOIN product_colors_order AS pco ON pco.product_id = ps.product_id ANd pco.color_id = ps.color_id
                INNER JOIN prices AS pr ON pr.skew_id = ps.id AND pr.shipping_region_id = 3

                WHERE ps.product_id = 15581
                AND ps.qty > 0
                AND ps.is_online = 1
                HAVING path != ''
                ORDER BY pco.sequence ASC, sc.sequence ASC

                /*ORDER BY ps.size_id ASC*/

[]

SELECT
  ps.*,
  c.color,
  s.size,
  sc.conversion,
  pr.price,
  pr.discounted_price,
  pr.lowest_price,
  pr.discount_percentage,
  pr.discounted_price_from,
  pr.discounted_price_to,
  pr.shipping_region_id,
  (
    SELECT
      CONVERT(
        GROUP_CONCAT(
          CONCAT_WS(
            '|', phototype_id, phototype_name,
            photo_path, photo_path_reduced
          )
        ) USING utf8mb4
      )
    FROM
      skews_photos sp
    WHERE
      sp.product_id = ps.product_id
      AND sp.color_id = ps.color_id
      AND season_id IN (
        SELECT
          MAX(season_id)
        FROM
          skews_photos
        WHERE
          product_id = ps.product_id
          AND color_id = ps.color_id
      )
    ORDER BY
      phototype_id ASC
  ) AS path
FROM
  products_skews AS ps
  INNER JOIN colors AS c ON c.id = ps.color_id
  INNER JOIN sizes AS s ON s.id = ps.size_id
  LEFT JOIN size_conversion AS sc ON sc.size = s.size
  AND linea_id = 14
  /* AND listino = 'it'*/
  LEFT JOIN product_colors_order AS pco ON pco.product_id = ps.product_id
  ANd pco.color_id = ps.color_id
  INNER JOIN prices AS pr ON pr.skew_id = ps.id
  AND pr.shipping_region_id = 3
WHERE
  ps.product_id = 15581
  AND ps.qty > 0
  AND ps.is_online = 1
HAVING
  path != ''
ORDER BY
  pco.sequence ASC,
  sc.sequence ASC
  /*ORDER BY ps.size_id ASC*/

SELECT ps.*, c.color, s.size, sc.conversion, pr.price, pr.discounted_price, pr.lowest_price, pr.discount_percentage, pr.discounted_price_from, pr.discounted_price_to, pr.shipping_region_id,
                (
                    SELECT
                       CONVERT(GROUP_CONCAT(
                           CONCAT_WS(
                                '|',
                                phototype_id, phototype_name, photo_path, photo_path_reduced
                            )
                       ) USING utf8mb4)
                    FROM skews_photos sp
                    WHERE sp.product_id = ps.product_id
                    AND sp.color_id = ps.color_id
                    AND season_id IN (
                        SELECT MAX(season_id)
                            FROM skews_photos
                            WHERE product_id = ps.product_id
                            AND color_id = ps.color_id
                    )
                    ORDER BY phototype_id ASC
                ) AS path
                FROM products_skews AS ps
                INNER JOIN colors AS c ON c.id = ps.color_id
                INNER JOIN sizes AS s ON s.id = ps.size_id
                LEFT JOIN size_conversion AS sc ON sc.size = s.size AND linea_id = 14 /* AND listino = 'it'*/
                LEFT JOIN product_colors_order AS pco ON pco.product_id = ps.product_id ANd pco.color_id = ps.color_id
                INNER JOIN prices AS pr ON pr.skew_id = ps.id AND pr.shipping_region_id = 3

                WHERE ps.product_id = 15581
                AND ps.qty > 0
                AND ps.is_online = 1
                HAVING path != ''
                ORDER BY pco.sequence ASC, sc.sequence ASC

                /*ORDER BY ps.size_id ASC*/
                ;