Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 29
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• VichUploader
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' ORDER BY c0_.root ASC, c0_.lft ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.lvl AS lvl_1,
  c0_.lft AS lft_2,
  c0_.rgt AS rgt_3,
  c0_.root AS root_4,
  c0_.name AS name_5,
  c0_.role AS role_6,
  c0_.parent_id AS parent_id_7
FROM
  cms_roles c0_
WHERE
  c0_.lvl IN (0, 1)
  AND c0_.role NOT LIKE 'ROLE_ADMIN_%'
ORDER BY
  c0_.root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' ORDER BY c0_.root ASC, c0_.lft ASC;

SELECT t0.id AS id_1, t0.package AS package_2, t0.name AS name_3, t0.description AS description_4, t0.display_name AS display_name_5, t0.list_name AS list_name_6, t0.is_internal AS is_internal_7, t0.is_categorizable AS is_categorizable_8, t0.is_fileable AS is_fileable_9, t0.is_printable AS is_printable_10, t0.is_embeddable AS is_embeddable_11, t0.is_searchable AS is_searchable_12, t0.is_queryable AS is_queryable_13, t0.accepts_comments AS accepts_comments_14, t0.has_authors AS has_authors_15, t0.has_attachments AS has_attachments_16, t0.has_source AS has_source_17, t0.has_tags AS has_tags_18, t0.has_summary AS has_summary_19, t0.has_aggregates AS has_aggregates_20 FROM content_type t0

[]

SELECT
  t0.id AS id_1,
  t0.package AS package_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.display_name AS display_name_5,
  t0.list_name AS list_name_6,
  t0.is_internal AS is_internal_7,
  t0.is_categorizable AS is_categorizable_8,
  t0.is_fileable AS is_fileable_9,
  t0.is_printable AS is_printable_10,
  t0.is_embeddable AS is_embeddable_11,
  t0.is_searchable AS is_searchable_12,
  t0.is_queryable AS is_queryable_13,
  t0.accepts_comments AS accepts_comments_14,
  t0.has_authors AS has_authors_15,
  t0.has_attachments AS has_attachments_16,
  t0.has_source AS has_source_17,
  t0.has_tags AS has_tags_18,
  t0.has_summary AS has_summary_19,
  t0.has_aggregates AS has_aggregates_20
FROM
  content_type t0

SELECT t0.id AS id_1, t0.package AS package_2, t0.name AS name_3, t0.description AS description_4, t0.display_name AS display_name_5, t0.list_name AS list_name_6, t0.is_internal AS is_internal_7, t0.is_categorizable AS is_categorizable_8, t0.is_fileable AS is_fileable_9, t0.is_printable AS is_printable_10, t0.is_embeddable AS is_embeddable_11, t0.is_searchable AS is_searchable_12, t0.is_queryable AS is_queryable_13, t0.accepts_comments AS accepts_comments_14, t0.has_authors AS has_authors_15, t0.has_attachments AS has_attachments_16, t0.has_source AS has_source_17, t0.has_tags AS has_tags_18, t0.has_summary AS has_summary_19, t0.has_aggregates AS has_aggregates_20 FROM content_type t0;

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_

[]

SELECT
  r0_.name AS name_0,
  r0_.value AS value_1
FROM
  runtime_parameter r0_

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_;

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_name AS banner_name_7 FROM ads_banner t0 WHERE t0.id = ?

[
  "5"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.banner_name AS banner_name_7
FROM
  ads_banner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_name AS banner_name_7 FROM ads_banner t0 WHERE t0.id = '5';

SELECT t0.id AS id_1, t0.date_time AS date_time_2, t0.banner_id AS banner_id_3, t0.zone_id AS zone_id_4, t0.campaign_id AS campaign_id_5 FROM ads_banner_state t0 WHERE t0.banner_id = ? ORDER BY t0.id ASC

[
  5
]

SELECT
  t0.id AS id_1,
  t0.date_time AS date_time_2,
  t0.banner_id AS banner_id_3,
  t0.zone_id AS zone_id_4,
  t0.campaign_id AS campaign_id_5
FROM
  ads_banner_state t0
WHERE
  t0.banner_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.date_time AS date_time_2, t0.banner_id AS banner_id_3, t0.zone_id AS zone_id_4, t0.campaign_id AS campaign_id_5 FROM ads_banner_state t0 WHERE t0.banner_id = 5 ORDER BY t0.id ASC;

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.clicks AS clicks_3, t0.imps AS imps_4, t0.bannerstate_id AS bannerstate_id_5 FROM ads_impression t0 WHERE t0.bannerstate_id = ? AND t0.start_date = ? LIMIT 1

[
  5
  "2025-07-01 02:00:00"
]

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.clicks AS clicks_3,
  t0.imps AS imps_4,
  t0.bannerstate_id AS bannerstate_id_5
FROM
  ads_impression t0
WHERE
  t0.bannerstate_id = ?
  AND t0.start_date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.clicks AS clicks_3, t0.imps AS imps_4, t0.bannerstate_id AS bannerstate_id_5 FROM ads_impression t0 WHERE t0.bannerstate_id = 5 AND t0.start_date = '2025-07-01 02:00:00' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE ads_impression SET clicks = ? WHERE id = ?

[
  2
  8914
]

UPDATE
  ads_impression
SET
  clicks = ?
WHERE
  id = ?

UPDATE ads_impression SET clicks = 2 WHERE id = 8914;

"COMMIT"

[]

"COMMIT"

"COMMIT";