Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.company AS company_6, t0.phone AS phone_7, t0.address AS address_8, t0.city AS city_9, t0.postal_code AS postal_code_10, t0.country AS country_11, t0.roles AS roles_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.last_login_at AS last_login_at_15, t0.job_title AS job_title_16, t0.legal_form AS legal_form_17, t0.company_street AS company_street_18, t0.company_street_number AS company_street_number_19, t0.company_city AS company_city_20, t0.company_postal_code AS company_postal_code_21, t0.rcs_number AS rcs_number_22, t0.vat_number AS vat_number_23, t0.email_verified_at AS email_verified_at_24, t0.cgu_accepted_at AS cgu_accepted_at_25, t0.cgu_version AS cgu_version_26, t0.suspended AS suspended_27, t0.suspended_reason AS suspended_reason_28 FROM user_annonceur t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.company AS company_6,
  t0.phone AS phone_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.postal_code AS postal_code_10,
  t0.country AS country_11,
  t0.roles AS roles_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.last_login_at AS last_login_at_15,
  t0.job_title AS job_title_16,
  t0.legal_form AS legal_form_17,
  t0.company_street AS company_street_18,
  t0.company_street_number AS company_street_number_19,
  t0.company_city AS company_city_20,
  t0.company_postal_code AS company_postal_code_21,
  t0.rcs_number AS rcs_number_22,
  t0.vat_number AS vat_number_23,
  t0.email_verified_at AS email_verified_at_24,
  t0.cgu_accepted_at AS cgu_accepted_at_25,
  t0.cgu_version AS cgu_version_26,
  t0.suspended AS suspended_27,
  t0.suspended_reason AS suspended_reason_28
FROM
  user_annonceur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.company AS company_6, t0.phone AS phone_7, t0.address AS address_8, t0.city AS city_9, t0.postal_code AS postal_code_10, t0.country AS country_11, t0.roles AS roles_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.last_login_at AS last_login_at_15, t0.job_title AS job_title_16, t0.legal_form AS legal_form_17, t0.company_street AS company_street_18, t0.company_street_number AS company_street_number_19, t0.company_city AS company_city_20, t0.company_postal_code AS company_postal_code_21, t0.rcs_number AS rcs_number_22, t0.vat_number AS vat_number_23, t0.email_verified_at AS email_verified_at_24, t0.cgu_accepted_at AS cgu_accepted_at_25, t0.cgu_version AS cgu_version_26, t0.suspended AS suspended_27, t0.suspended_reason AS suspended_reason_28 FROM user_annonceur t0 WHERE t0.id = 1;

SELECT 
                    COUNT(*) as total,
                    SUM(CASE WHEN status = 'active' THEN 1 ELSE 0 END) as active,
                    SUM(CASE WHEN status = 'pending_validation' THEN 1 ELSE 0 END) as pending,
                    SUM(CASE WHEN status = 'draft' THEN 1 ELSE 0 END) as draft,
                    SUM(CASE WHEN status = 'blocked_by_admin' THEN 1 ELSE 0 END) as blocked,
                    SUM(CASE WHEN status = 'hidden_by_owner' THEN 1 ELSE 0 END) as hidden,
                    SUM(view_count) as total_views,
                    SUM(click_count) as total_clicks
                FROM event_annonce 
                WHERE iduserpub = ?

[
  1
]

SELECT
  COUNT(*) as total,
  SUM(
    CASE WHEN status = 'active' THEN
      1
    ELSE
      0
    END
  ) as active,
  SUM(
    CASE WHEN status = 'pending_validation' THEN
      1
    ELSE
      0
    END
  ) as pending,
  SUM(
    CASE WHEN status = 'draft' THEN
      1
    ELSE
      0
    END
  ) as draft,
  SUM(
    CASE WHEN status = 'blocked_by_admin' THEN
      1
    ELSE
      0
    END
  ) as blocked,
  SUM(
    CASE WHEN status = 'hidden_by_owner' THEN
      1
    ELSE
      0
    END
  ) as hidden,
  SUM(view_count) as total_views,
  SUM(click_count) as total_clicks
FROM
  event_annonce
WHERE
  iduserpub = ?

SELECT 
                    COUNT(*) as total,
                    SUM(CASE WHEN status = 'active' THEN 1 ELSE 0 END) as active,
                    SUM(CASE WHEN status = 'pending_validation' THEN 1 ELSE 0 END) as pending,
                    SUM(CASE WHEN status = 'draft' THEN 1 ELSE 0 END) as draft,
                    SUM(CASE WHEN status = 'blocked_by_admin' THEN 1 ELSE 0 END) as blocked,
                    SUM(CASE WHEN status = 'hidden_by_owner' THEN 1 ELSE 0 END) as hidden,
                    SUM(view_count) as total_views,
                    SUM(click_count) as total_clicks
                FROM event_annonce 
                WHERE iduserpub = 1;

SELECT e0_.ideventpub AS ideventpub_0, e0_.title AS title_1, e0_.takeplace AS takeplace_2, e0_.latitude AS latitude_3, e0_.longitude AS longitude_4, e0_.titledescription AS titledescription_5, e0_.descriptionshow AS descriptionshow_6, e0_.photourl AS photourl_7, e0_.urlpurchase AS urlpurchase_8, e0_.exactaddress AS exactaddress_9, e0_.commentaire AS commentaire_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.status AS status_13, e0_.price_range AS price_range_14, e0_.show_opening_hours AS show_opening_hours_15, e0_.admin_block_reason AS admin_block_reason_16, e0_.published_at AS published_at_17, e0_.view_count AS view_count_18, e0_.click_count AS click_count_19, e0_.boosted AS boosted_20, e0_.boost_until AS boost_until_21, e0_.iduserpub AS iduserpub_22, e0_.idservicecategory AS idservicecategory_23 FROM event_annonce e0_ WHERE e0_.iduserpub = ? ORDER BY e0_.created_at DESC LIMIT 10

[
  1
]

SELECT
  e0_.ideventpub AS ideventpub_0,
  e0_.title AS title_1,
  e0_.takeplace AS takeplace_2,
  e0_.latitude AS latitude_3,
  e0_.longitude AS longitude_4,
  e0_.titledescription AS titledescription_5,
  e0_.descriptionshow AS descriptionshow_6,
  e0_.photourl AS photourl_7,
  e0_.urlpurchase AS urlpurchase_8,
  e0_.exactaddress AS exactaddress_9,
  e0_.commentaire AS commentaire_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.status AS status_13,
  e0_.price_range AS price_range_14,
  e0_.show_opening_hours AS show_opening_hours_15,
  e0_.admin_block_reason AS admin_block_reason_16,
  e0_.published_at AS published_at_17,
  e0_.view_count AS view_count_18,
  e0_.click_count AS click_count_19,
  e0_.boosted AS boosted_20,
  e0_.boost_until AS boost_until_21,
  e0_.iduserpub AS iduserpub_22,
  e0_.idservicecategory AS idservicecategory_23
FROM
  event_annonce e0_
WHERE
  e0_.iduserpub = ?
ORDER BY
  e0_.created_at DESC
LIMIT
  10

SELECT e0_.ideventpub AS ideventpub_0, e0_.title AS title_1, e0_.takeplace AS takeplace_2, e0_.latitude AS latitude_3, e0_.longitude AS longitude_4, e0_.titledescription AS titledescription_5, e0_.descriptionshow AS descriptionshow_6, e0_.photourl AS photourl_7, e0_.urlpurchase AS urlpurchase_8, e0_.exactaddress AS exactaddress_9, e0_.commentaire AS commentaire_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.status AS status_13, e0_.price_range AS price_range_14, e0_.show_opening_hours AS show_opening_hours_15, e0_.admin_block_reason AS admin_block_reason_16, e0_.published_at AS published_at_17, e0_.view_count AS view_count_18, e0_.click_count AS click_count_19, e0_.boosted AS boosted_20, e0_.boost_until AS boost_until_21, e0_.iduserpub AS iduserpub_22, e0_.idservicecategory AS idservicecategory_23 FROM event_annonce e0_ WHERE e0_.iduserpub = 1 ORDER BY e0_.created_at DESC LIMIT 10;