Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_art AS type_art_8, t0.professionel_id AS professionel_id_9, t0.admin_id AS admin_id_10 FROM article t0 WHERE t0.admin_id = ? AND t0.type_art IS NULL ORDER BY t0.updated_at DESC, t0.created_at DESC

[
  4
]

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.image_size AS image_size_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type_art AS type_art_8,
  t0.professionel_id AS professionel_id_9,
  t0.admin_id AS admin_id_10
FROM
  article t0
WHERE
  t0.admin_id = ?
  AND t0.type_art IS NULL
ORDER BY
  t0.updated_at DESC,
  t0.created_at DESC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_art AS type_art_8, t0.professionel_id AS professionel_id_9, t0.admin_id AS admin_id_10 FROM article t0 WHERE t0.admin_id = 4 AND t0.type_art IS NULL ORDER BY t0.updated_at DESC, t0.created_at DESC;

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

[
  "4"
  "en"
  "App\Entity\User"
]

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\User';

SELECT COUNT(*) FROM comment t0 WHERE t0.article_id = ?

[
  58
]

SELECT
  COUNT(*)
FROM
  comment t0
WHERE
  t0.article_id = ?

SELECT COUNT(*) FROM comment t0 WHERE t0.article_id = 58;

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.commenter_id AS commenter_id_3 FROM comment t0 WHERE t0.article_id = ?

[
  58
]

SELECT
  t0.id AS id_1,
  t0.article_id AS article_id_2,
  t0.commenter_id AS commenter_id_3
FROM
  comment t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.commenter_id AS commenter_id_3 FROM comment t0 WHERE t0.article_id = 58;

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.type_compte AS type_compte_8, t0.is_verified AS is_verified_9, t0.tel AS tel_10, t0.approve AS approve_11, t0.facebook_id AS facebook_id_12, t0.is_super_admin AS is_super_admin_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.instagram AS instagram_16, t0.linkedin AS linkedin_17, t0.youtube AS youtube_18, t0.whatsapp AS whatsapp_19, t0.pinterest AS pinterest_20, t0.facebook_access_token AS facebook_access_token_21, t0.twitter_id AS twitter_id_22, t0.twitter_access_token AS twitter_access_token_23, t0.google_id AS google_id_24, t0.google_access_token AS google_access_token_25, t0.total_credits AS total_credits_26, t0.compte, t1.logo AS logo_27, t1.nom_professionel AS nom_professionel_28, t1.addresse AS addresse_29, t1.marques AS marques_30, t1.website AS website_31, t1.image_size AS image_size_32, t1.updated_at AS updated_at_33, t1.description AS description_34, t2.prenom AS prenom_35, t2.nom AS nom_36, t2.civility AS civility_37, t2.photo AS photo_38, t2.image_size AS image_size_39, t2.updated_at AS updated_at_40, t3.photo AS photo_41, t3.image_size AS image_size_42, t3.updated_at AS updated_at_43 FROM user t0 LEFT JOIN professionel t1 ON t0.id = t1.id LEFT JOIN particulier t2 ON t0.id = t2.id LEFT JOIN admin t3 ON t0.id = t3.id WHERE t0.is_super_admin = ?

[
  1
]

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.type_compte AS type_compte_8,
  t0.is_verified AS is_verified_9,
  t0.tel AS tel_10,
  t0.approve AS approve_11,
  t0.facebook_id AS facebook_id_12,
  t0.is_super_admin AS is_super_admin_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.instagram AS instagram_16,
  t0.linkedin AS linkedin_17,
  t0.youtube AS youtube_18,
  t0.whatsapp AS whatsapp_19,
  t0.pinterest AS pinterest_20,
  t0.facebook_access_token AS facebook_access_token_21,
  t0.twitter_id AS twitter_id_22,
  t0.twitter_access_token AS twitter_access_token_23,
  t0.google_id AS google_id_24,
  t0.google_access_token AS google_access_token_25,
  t0.total_credits AS total_credits_26,
  t0.compte,
  t1.logo AS logo_27,
  t1.nom_professionel AS nom_professionel_28,
  t1.addresse AS addresse_29,
  t1.marques AS marques_30,
  t1.website AS website_31,
  t1.image_size AS image_size_32,
  t1.updated_at AS updated_at_33,
  t1.description AS description_34,
  t2.prenom AS prenom_35,
  t2.nom AS nom_36,
  t2.civility AS civility_37,
  t2.photo AS photo_38,
  t2.image_size AS image_size_39,
  t2.updated_at AS updated_at_40,
  t3.photo AS photo_41,
  t3.image_size AS image_size_42,
  t3.updated_at AS updated_at_43
FROM
  user t0
  LEFT JOIN professionel t1 ON t0.id = t1.id
  LEFT JOIN particulier t2 ON t0.id = t2.id
  LEFT JOIN admin t3 ON t0.id = t3.id
WHERE
  t0.is_super_admin = ?

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.type_compte AS type_compte_8, t0.is_verified AS is_verified_9, t0.tel AS tel_10, t0.approve AS approve_11, t0.facebook_id AS facebook_id_12, t0.is_super_admin AS is_super_admin_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.instagram AS instagram_16, t0.linkedin AS linkedin_17, t0.youtube AS youtube_18, t0.whatsapp AS whatsapp_19, t0.pinterest AS pinterest_20, t0.facebook_access_token AS facebook_access_token_21, t0.twitter_id AS twitter_id_22, t0.twitter_access_token AS twitter_access_token_23, t0.google_id AS google_id_24, t0.google_access_token AS google_access_token_25, t0.total_credits AS total_credits_26, t0.compte, t1.logo AS logo_27, t1.nom_professionel AS nom_professionel_28, t1.addresse AS addresse_29, t1.marques AS marques_30, t1.website AS website_31, t1.image_size AS image_size_32, t1.updated_at AS updated_at_33, t1.description AS description_34, t2.prenom AS prenom_35, t2.nom AS nom_36, t2.civility AS civility_37, t2.photo AS photo_38, t2.image_size AS image_size_39, t2.updated_at AS updated_at_40, t3.photo AS photo_41, t3.image_size AS image_size_42, t3.updated_at AS updated_at_43 FROM user t0 LEFT JOIN professionel t1 ON t0.id = t1.id LEFT JOIN particulier t2 ON t0.id = t2.id LEFT JOIN admin t3 ON t0.id = t3.id WHERE t0.is_super_admin = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.validity AS validity_3, t0.location AS location_4, t0.category AS category_5, t0.link AS link_6, t0.file_pub AS file_pub_7, t0.file_size AS file_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expireted_at AS expireted_at_11, t0.back_link AS back_link_12 FROM pub t0 WHERE t0.location = ?

[
  "Entéte du site"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.validity AS validity_3,
  t0.location AS location_4,
  t0.category AS category_5,
  t0.link AS link_6,
  t0.file_pub AS file_pub_7,
  t0.file_size AS file_size_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.expireted_at AS expireted_at_11,
  t0.back_link AS back_link_12
FROM
  pub t0
WHERE
  t0.location = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.validity AS validity_3, t0.location AS location_4, t0.category AS category_5, t0.link AS link_6, t0.file_pub AS file_pub_7, t0.file_size AS file_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expireted_at AS expireted_at_11, t0.back_link AS back_link_12 FROM pub t0 WHERE t0.location = 'Entéte du site';

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image_pub AS image_pub_2, p0_.created_at AS created_at_3, p0_.image_size AS image_size_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_.id DESC LIMIT 3

[]

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.image_pub AS image_pub_2,
  p0_.created_at AS created_at_3,
  p0_.image_size AS image_size_4,
  p0_.updated_at AS updated_at_5,
  p0_.description AS description_6,
  p0_.admin_id AS admin_id_7
FROM
  pub_infos p0_
ORDER BY
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image_pub AS image_pub_2, p0_.created_at AS created_at_3, p0_.image_size AS image_size_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_.id DESC LIMIT 3;