Symfony Profiler

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

Query Metrics

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.published_at AS published_at_4, c0_.is_homepage AS is_homepage_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.og_image_url AS og_image_url_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11, c1_.id AS id_12, c1_.locale AS locale_13, c1_.status AS status_14, c1_.title AS title_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.blocks_content AS blocks_content_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c0_.organization_id AS organization_id_21, c0_.created_by_id AS created_by_id_22, c0_.updated_by_id AS updated_by_id_23, c1_.page_id AS page_id_24 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.page_id WHERE (c0_.status = ? AND c0_.deleted_at IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.created_at ASC

[
  "published"
]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.status AS status_3,
  c0_.published_at AS published_at_4,
  c0_.is_homepage AS is_homepage_5,
  c0_.meta_title AS meta_title_6,
  c0_.meta_description AS meta_description_7,
  c0_.og_image_url AS og_image_url_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.deleted_at AS deleted_at_11,
  c1_.id AS id_12,
  c1_.locale AS locale_13,
  c1_.status AS status_14,
  c1_.title AS title_15,
  c1_.meta_title AS meta_title_16,
  c1_.meta_description AS meta_description_17,
  c1_.blocks_content AS blocks_content_18,
  c1_.created_at AS created_at_19,
  c1_.updated_at AS updated_at_20,
  c0_.organization_id AS organization_id_21,
  c0_.created_by_id AS created_by_id_22,
  c0_.updated_by_id AS updated_by_id_23,
  c1_.page_id AS page_id_24
FROM
  cms_page c0_
  LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.page_id
WHERE
  (
    c0_.status = ?
    AND c0_.deleted_at IS NULL
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.created_at ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.published_at AS published_at_4, c0_.is_homepage AS is_homepage_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.og_image_url AS og_image_url_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11, c1_.id AS id_12, c1_.locale AS locale_13, c1_.status AS status_14, c1_.title AS title_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.blocks_content AS blocks_content_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c0_.organization_id AS organization_id_21, c0_.created_by_id AS created_by_id_22, c0_.updated_by_id AS updated_by_id_23, c1_.page_id AS page_id_24 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.page_id WHERE (c0_.status = 'published' AND c0_.deleted_at IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.created_at ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.is_active AS is_active_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM organization t0 WHERE t0.domain = ? AND t0.is_active = ? LIMIT 1

[
  "vendordesk-dev.marello.com"
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.domain AS domain_4,
  t0.is_active AS is_active_5,
  t0.api_token AS api_token_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  organization t0
WHERE
  t0.domain = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.is_active AS is_active_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM organization t0 WHERE t0.domain = 'vendordesk-dev.marello.com' AND t0.is_active = 1 LIMIT 1;

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.status AS status_2, m0_.title AS title_3, m0_.tags AS tags_4, m0_.excerpt AS excerpt_5, m0_.body AS body_6, m0_.meta_title AS meta_title_7, m0_.meta_description AS meta_description_8, m0_.ai_provider AS ai_provider_9, m0_.failure_reason AS failure_reason_10, m0_.image_brief AS image_brief_11, m0_.image_url AS image_url_12, m0_.image_attribution AS image_attribution_13, m0_.image_candidates AS image_candidates_14, m0_.image_provider AS image_provider_15, m0_.slug AS slug_16, m0_.scheduled_for AS scheduled_for_17, m0_.published_at AS published_at_18, m0_.linkedin_post_urn AS linkedin_post_urn_19, m0_.linkedin_posted_at AS linkedin_posted_at_20, m0_.created_at AS created_at_21, m0_.updated_at AS updated_at_22, m1_.id AS id_23, m1_.locale AS locale_24, m1_.status AS status_25, m1_.title AS title_26, m1_.excerpt AS excerpt_27, m1_.body AS body_28, m1_.meta_title AS meta_title_29, m1_.meta_description AS meta_description_30, m1_.created_at AS created_at_31, m1_.updated_at AS updated_at_32, m0_.topic_id AS topic_id_33, m0_.organization_id AS organization_id_34, m0_.created_by_id AS created_by_id_35, m0_.updated_by_id AS updated_by_id_36, m1_.content_piece_id AS content_piece_id_37 FROM marketing_content_piece m0_ LEFT JOIN marketing_content_piece_translation m1_ ON m0_.id = m1_.content_piece_id WHERE m0_.status = ? AND m0_.type = ? AND m0_.slug IS NOT NULL ORDER BY m0_.published_at DESC

[
  "published"
  "blog_post"
]

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.status AS status_2,
  m0_.title AS title_3,
  m0_.tags AS tags_4,
  m0_.excerpt AS excerpt_5,
  m0_.body AS body_6,
  m0_.meta_title AS meta_title_7,
  m0_.meta_description AS meta_description_8,
  m0_.ai_provider AS ai_provider_9,
  m0_.failure_reason AS failure_reason_10,
  m0_.image_brief AS image_brief_11,
  m0_.image_url AS image_url_12,
  m0_.image_attribution AS image_attribution_13,
  m0_.image_candidates AS image_candidates_14,
  m0_.image_provider AS image_provider_15,
  m0_.slug AS slug_16,
  m0_.scheduled_for AS scheduled_for_17,
  m0_.published_at AS published_at_18,
  m0_.linkedin_post_urn AS linkedin_post_urn_19,
  m0_.linkedin_posted_at AS linkedin_posted_at_20,
  m0_.created_at AS created_at_21,
  m0_.updated_at AS updated_at_22,
  m1_.id AS id_23,
  m1_.locale AS locale_24,
  m1_.status AS status_25,
  m1_.title AS title_26,
  m1_.excerpt AS excerpt_27,
  m1_.body AS body_28,
  m1_.meta_title AS meta_title_29,
  m1_.meta_description AS meta_description_30,
  m1_.created_at AS created_at_31,
  m1_.updated_at AS updated_at_32,
  m0_.topic_id AS topic_id_33,
  m0_.organization_id AS organization_id_34,
  m0_.created_by_id AS created_by_id_35,
  m0_.updated_by_id AS updated_by_id_36,
  m1_.content_piece_id AS content_piece_id_37
FROM
  marketing_content_piece m0_
  LEFT JOIN marketing_content_piece_translation m1_ ON m0_.id = m1_.content_piece_id
WHERE
  m0_.status = ?
  AND m0_.type = ?
  AND m0_.slug IS NOT NULL
ORDER BY
  m0_.published_at DESC

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.status AS status_2, m0_.title AS title_3, m0_.tags AS tags_4, m0_.excerpt AS excerpt_5, m0_.body AS body_6, m0_.meta_title AS meta_title_7, m0_.meta_description AS meta_description_8, m0_.ai_provider AS ai_provider_9, m0_.failure_reason AS failure_reason_10, m0_.image_brief AS image_brief_11, m0_.image_url AS image_url_12, m0_.image_attribution AS image_attribution_13, m0_.image_candidates AS image_candidates_14, m0_.image_provider AS image_provider_15, m0_.slug AS slug_16, m0_.scheduled_for AS scheduled_for_17, m0_.published_at AS published_at_18, m0_.linkedin_post_urn AS linkedin_post_urn_19, m0_.linkedin_posted_at AS linkedin_posted_at_20, m0_.created_at AS created_at_21, m0_.updated_at AS updated_at_22, m1_.id AS id_23, m1_.locale AS locale_24, m1_.status AS status_25, m1_.title AS title_26, m1_.excerpt AS excerpt_27, m1_.body AS body_28, m1_.meta_title AS meta_title_29, m1_.meta_description AS meta_description_30, m1_.created_at AS created_at_31, m1_.updated_at AS updated_at_32, m0_.topic_id AS topic_id_33, m0_.organization_id AS organization_id_34, m0_.created_by_id AS created_by_id_35, m0_.updated_by_id AS updated_by_id_36, m1_.content_piece_id AS content_piece_id_37 FROM marketing_content_piece m0_ LEFT JOIN marketing_content_piece_translation m1_ ON m0_.id = m1_.content_piece_id WHERE m0_.status = 'published' AND m0_.type = 'blog_post' AND m0_.slug IS NOT NULL ORDER BY m0_.published_at DESC;