Symfony Profiler

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

Query Metrics

SELECT p.id, p.city, p.slug, p.image_name as imageName, json_group_array(json_object('id', lp.id, 'name', lp.name, 'seoTitle', lp.seo_title, 'slug', lp.slug, 'type', 'listing')) as pages
    FROM place p
    INNER JOIN listing_page lp ON p.id = lp.place_id
    GROUP BY p.id

[]

SELECT
  p.id,
  p.city,
  p.slug,
  p.image_name as imageName,
  json_group_array(
    json_object(
      'id', lp.id, 'name', lp.name, 'seoTitle',
      lp.seo_title, 'slug', lp.slug, 'type',
      'listing'
    )
  ) as pages
FROM
  place p
  INNER JOIN listing_page lp ON p.id = lp.place_id
GROUP BY
  p.id

SELECT p.id, p.city, p.slug, p.image_name as imageName, json_group_array(json_object('id', lp.id, 'name', lp.name, 'seoTitle', lp.seo_title, 'slug', lp.slug, 'type', 'listing')) as pages
    FROM place p
    INNER JOIN listing_page lp ON p.id = lp.place_id
    GROUP BY p.id;

SELECT p.id, p.city, p.slug, p.image_name as imageName, json_group_array(json_object('id', tcc.id, 'seoTitle', tcc.seo_title, 'slug', t.slug, 'type', 'training')) as pages
    FROM place p
    INNER JOIN training_city_child tcc ON p.id = tcc.place_id
    INNER JOIN training t ON t.id = tcc.training_id
    GROUP BY p.id

[]

SELECT
  p.id,
  p.city,
  p.slug,
  p.image_name as imageName,
  json_group_array(
    json_object(
      'id', tcc.id, 'seoTitle', tcc.seo_title,
      'slug', t.slug, 'type', 'training'
    )
  ) as pages
FROM
  place p
  INNER JOIN training_city_child tcc ON p.id = tcc.place_id
  INNER JOIN training t ON t.id = tcc.training_id
GROUP BY
  p.id

SELECT p.id, p.city, p.slug, p.image_name as imageName, json_group_array(json_object('id', tcc.id, 'seoTitle', tcc.seo_title, 'slug', t.slug, 'type', 'training')) as pages
    FROM place p
    INNER JOIN training_city_child tcc ON p.id = tcc.place_id
    INNER JOIN training t ON t.id = tcc.training_id
    GROUP BY p.id;

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.show_on_home_page AS show_on_home_page_5, t0.total_trainings AS total_trainings_6, t0.slug AS slug_7, t0.content AS content_8, t0.content2 AS content2_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_canonical AS seo_canonical_12, t0.seo_indexed AS seo_indexed_13, t0.place_id AS place_id_14 FROM listing_page t0 WHERE t0.place_id IS NULL

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.show_on_home_page AS show_on_home_page_5,
  t0.total_trainings AS total_trainings_6,
  t0.slug AS slug_7,
  t0.content AS content_8,
  t0.content2 AS content2_9,
  t0.seo_title AS seo_title_10,
  t0.seo_description AS seo_description_11,
  t0.seo_canonical AS seo_canonical_12,
  t0.seo_indexed AS seo_indexed_13,
  t0.place_id AS place_id_14
FROM
  listing_page t0
WHERE
  t0.place_id IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.show_on_home_page AS show_on_home_page_5, t0.total_trainings AS total_trainings_6, t0.slug AS slug_7, t0.content AS content_8, t0.content2 AS content2_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_canonical AS seo_canonical_12, t0.seo_indexed AS seo_indexed_13, t0.place_id AS place_id_14 FROM listing_page t0 WHERE t0.place_id IS NULL;

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;