Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.product_id AND (i1_.is_main = 1)

[]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN image i1_ ON p0_.id = i1_.product_id
  AND (i1_.is_main = 1)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.product_id AND (i1_.is_main = 1);

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.product_id AND (i1_.is_main = 1) ORDER BY p0_.id DESC LIMIT 8 OFFSET 8

[]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
  LEFT JOIN image i1_ ON p0_.id = i1_.product_id
  AND (i1_.is_main = 1)
ORDER BY
  p0_.id DESC
LIMIT
  8
OFFSET
  8

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.product_id AND (i1_.is_main = 1) ORDER BY p0_.id DESC LIMIT 8 OFFSET 8;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.image AS image_3, p0_.qty AS qty_4, p0_.sku AS sku_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.rating AS rating_9, p0_.weight AS weight_10, p0_.status AS status_11, p0_.promotion AS promotion_12, p0_.promotion_price AS promotion_price_13, p0_.promotion_start_date AS promotion_start_date_14, p0_.promotion_end_date AS promotion_end_date_15, p0_.to_be_exposed AS to_be_exposed_16, p0_.has_variants AS has_variants_17, i1_.id AS id_18, i1_.filename AS filename_19, i1_.is_main AS is_main_20, p0_.category_id AS category_id_21, p0_.user_id AS user_id_22, p0_.taxt_id AS taxt_id_23, i1_.product_id AS product_id_24 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.product_id AND (i1_.is_main = 1) WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC

[
  33
  32
  31
  30
  29
  28
  27
  26
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.image AS image_3,
  p0_.qty AS qty_4,
  p0_.sku AS sku_5,
  p0_.description AS description_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.rating AS rating_9,
  p0_.weight AS weight_10,
  p0_.status AS status_11,
  p0_.promotion AS promotion_12,
  p0_.promotion_price AS promotion_price_13,
  p0_.promotion_start_date AS promotion_start_date_14,
  p0_.promotion_end_date AS promotion_end_date_15,
  p0_.to_be_exposed AS to_be_exposed_16,
  p0_.has_variants AS has_variants_17,
  i1_.id AS id_18,
  i1_.filename AS filename_19,
  i1_.is_main AS is_main_20,
  p0_.category_id AS category_id_21,
  p0_.user_id AS user_id_22,
  p0_.taxt_id AS taxt_id_23,
  i1_.product_id AS product_id_24
FROM
  product p0_
  LEFT JOIN image i1_ ON p0_.id = i1_.product_id
  AND (i1_.is_main = 1)
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.image AS image_3, p0_.qty AS qty_4, p0_.sku AS sku_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.rating AS rating_9, p0_.weight AS weight_10, p0_.status AS status_11, p0_.promotion AS promotion_12, p0_.promotion_price AS promotion_price_13, p0_.promotion_start_date AS promotion_start_date_14, p0_.promotion_end_date AS promotion_end_date_15, p0_.to_be_exposed AS to_be_exposed_16, p0_.has_variants AS has_variants_17, i1_.id AS id_18, i1_.filename AS filename_19, i1_.is_main AS is_main_20, p0_.category_id AS category_id_21, p0_.user_id AS user_id_22, p0_.taxt_id AS taxt_id_23, i1_.product_id AS product_id_24 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.product_id AND (i1_.is_main = 1) WHERE p0_.id IN (33, 32, 31, 30, 29, 28, 27, 26) ORDER BY p0_.id DESC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.parent_id AS parent_id_7, t0.category_id AS category_id_8 FROM category t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.user_id AS user_id_6,
  t0.parent_id AS parent_id_7,
  t0.category_id AS category_id_8
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.parent_id AS parent_id_7, t0.category_id AS category_id_8 FROM category t0;

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_active AS is_active_6, t0.slug AS slug_7 FROM policy t0

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.is_active AS is_active_6,
  t0.slug AS slug_7
FROM
  policy t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_active AS is_active_6, t0.slug AS slug_7 FROM policy t0;