Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.company AS company_2, t0.category AS category_3, t0.adress AS adress_4, t0.box AS box_5, t0.zip AS zip_6, t0.city AS city_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.date AS date_11, t0.phones AS phones_12, t0.slug AS slug_13, t0.logobig_id AS logobig_id_14, t0.logosmall_id AS logosmall_id_15, t0.loyalty_id AS loyalty_id_16 FROM advertiser t0 WHERE t0.id = ?

[
  "169"
]

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.category AS category_3,
  t0.adress AS adress_4,
  t0.box AS box_5,
  t0.zip AS zip_6,
  t0.city AS city_7,
  t0.facebook AS facebook_8,
  t0.twitter AS twitter_9,
  t0.linkedin AS linkedin_10,
  t0.date AS date_11,
  t0.phones AS phones_12,
  t0.slug AS slug_13,
  t0.logobig_id AS logobig_id_14,
  t0.logosmall_id AS logosmall_id_15,
  t0.loyalty_id AS loyalty_id_16
FROM
  advertiser t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company AS company_2, t0.category AS category_3, t0.adress AS adress_4, t0.box AS box_5, t0.zip AS zip_6, t0.city AS city_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.date AS date_11, t0.phones AS phones_12, t0.slug AS slug_13, t0.logobig_id AS logobig_id_14, t0.logosmall_id AS logosmall_id_15, t0.loyalty_id AS loyalty_id_16 FROM advertiser t0 WHERE t0.id = '169';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO visit_catalog (addressip, datetime, userid, username, count, catalogid) VALUES (?, ?, ?, ?, ?, ?)

[
  "216.73.216.44"
  "2025-12-09 19:16:54"
  1
  "ADVERTISER"
  1
  169
]

INSERT INTO visit_catalog (
  addressip, datetime, userid, username,
  count, catalogid
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO visit_catalog (addressip, datetime, userid, username, count, catalogid) VALUES ('216.73.216.44', '2025-12-09 19:16:54', 1, 'ADVERTISER', 1, 169);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = ? AND (? BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.id DESC

[
  "169"
  "2025-12-09 19:16:54"
]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = '169' AND ('2025-12-09 19:16:54' BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.id DESC;

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE ? BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 3

[
  "2025-12-09 19:16:54"
]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  ? BETWEEN c0_.dtfrom
  AND c0_.dtto
ORDER BY
  c0_.id DESC
LIMIT
  3

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE '2025-12-09 19:16:54' BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 3;

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.comment AS comment_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.phone AS phone_6, t0.advertiser_id AS advertiser_id_7 FROM googlemap t0 WHERE t0.advertiser_id = ?

[
  169
]

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.comment AS comment_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.phone AS phone_6,
  t0.advertiser_id AS advertiser_id_7
FROM
  googlemap t0
WHERE
  t0.advertiser_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.comment AS comment_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.phone AS phone_6, t0.advertiser_id AS advertiser_id_7 FROM googlemap t0 WHERE t0.advertiser_id = 169;

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE ? BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption ASC

[
  "2025-12-09 19:16:54"
]

SELECT
  c0_.id AS id_0,
  c0_.caption AS caption_1,
  c0_.font AS font_2,
  c0_.picture AS picture_3,
  c0_.slug AS slug_4,
  c0_.icon_id AS icon_id_5,
  c0_.icon2_id AS icon2_id_6,
  c0_.categorygroup_id AS categorygroup_id_7
FROM
  category c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id
  INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id
WHERE
  ? BETWEEN c1_.dtfrom
  AND c1_.dtto
ORDER BY
  c0_.caption ASC

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE '2025-12-09 19:16:54' BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption ASC;