Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.image AS image_3, t0.title AS title_4, t0.description AS description_5 FROM study_details_page t0 WHERE t0.lang = ? LIMIT 1

[
  "en"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.image AS image_3,
  t0.title AS title_4,
  t0.description AS description_5
FROM
  study_details_page t0
WHERE
  t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.image AS image_3, t0.title AS title_4, t0.description AS description_5 FROM study_details_page t0 WHERE t0.lang = 'en' LIMIT 1;

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.draft AS draft_2, s0_.lang AS lang_3, s0_.title AS title_4, s0_.full_name AS full_name_5, s0_.date AS date_6, s0_.tools_status AS tools_status_7, s0_.other_methodologies AS other_methodologies_8, s0_.excel_file AS excel_file_9, s0_.accept_upload_conditions AS accept_upload_conditions_10, s0_.study_type AS study_type_11, s0_.other_sector AS other_sector_12, s0_.country AS country_13, s0_.partner AS partner_14, s0_.study_file AS study_file_15, s0_.tools_file AS tools_file_16, s0_.summary AS summary_17, s0_.sdg AS sdg_18, s0_.image AS image_19, s0_.summary_data AS summary_data_20, s0_.link AS link_21, s0_.other_keywords AS other_keywords_22, s0_.created_at AS created_at_23, u1_.id AS id_24, u1_.email AS email_25, u1_.roles AS roles_26, u1_.password AS password_27, u1_.user_type AS user_type_28, u1_.fullname AS fullname_29, u1_.firstname AS firstname_30, u1_.lastname AS lastname_31, u1_.gender AS gender_32, u1_.country AS country_33, u1_.organisation AS organisation_34, u1_.website AS website_35, u1_.job AS job_36, u1_.phonenumber AS phonenumber_37, u1_.photo AS photo_38, u1_.status AS status_39, u1_.is_verified AS is_verified_40, u1_.setup_profile AS setup_profile_41, u1_.is_archived AS is_archived_42, s0_.user_id AS user_id_43 FROM study s0_ LEFT JOIN user u1_ ON s0_.user_id = u1_.id WHERE s0_.id = ?

[
  "219"
]

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1,
  s0_.draft AS draft_2,
  s0_.lang AS lang_3,
  s0_.title AS title_4,
  s0_.full_name AS full_name_5,
  s0_.date AS date_6,
  s0_.tools_status AS tools_status_7,
  s0_.other_methodologies AS other_methodologies_8,
  s0_.excel_file AS excel_file_9,
  s0_.accept_upload_conditions AS accept_upload_conditions_10,
  s0_.study_type AS study_type_11,
  s0_.other_sector AS other_sector_12,
  s0_.country AS country_13,
  s0_.partner AS partner_14,
  s0_.study_file AS study_file_15,
  s0_.tools_file AS tools_file_16,
  s0_.summary AS summary_17,
  s0_.sdg AS sdg_18,
  s0_.image AS image_19,
  s0_.summary_data AS summary_data_20,
  s0_.link AS link_21,
  s0_.other_keywords AS other_keywords_22,
  s0_.created_at AS created_at_23,
  u1_.id AS id_24,
  u1_.email AS email_25,
  u1_.roles AS roles_26,
  u1_.password AS password_27,
  u1_.user_type AS user_type_28,
  u1_.fullname AS fullname_29,
  u1_.firstname AS firstname_30,
  u1_.lastname AS lastname_31,
  u1_.gender AS gender_32,
  u1_.country AS country_33,
  u1_.organisation AS organisation_34,
  u1_.website AS website_35,
  u1_.job AS job_36,
  u1_.phonenumber AS phonenumber_37,
  u1_.photo AS photo_38,
  u1_.status AS status_39,
  u1_.is_verified AS is_verified_40,
  u1_.setup_profile AS setup_profile_41,
  u1_.is_archived AS is_archived_42,
  s0_.user_id AS user_id_43
FROM
  study s0_
  LEFT JOIN user u1_ ON s0_.user_id = u1_.id
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.draft AS draft_2, s0_.lang AS lang_3, s0_.title AS title_4, s0_.full_name AS full_name_5, s0_.date AS date_6, s0_.tools_status AS tools_status_7, s0_.other_methodologies AS other_methodologies_8, s0_.excel_file AS excel_file_9, s0_.accept_upload_conditions AS accept_upload_conditions_10, s0_.study_type AS study_type_11, s0_.other_sector AS other_sector_12, s0_.country AS country_13, s0_.partner AS partner_14, s0_.study_file AS study_file_15, s0_.tools_file AS tools_file_16, s0_.summary AS summary_17, s0_.sdg AS sdg_18, s0_.image AS image_19, s0_.summary_data AS summary_data_20, s0_.link AS link_21, s0_.other_keywords AS other_keywords_22, s0_.created_at AS created_at_23, u1_.id AS id_24, u1_.email AS email_25, u1_.roles AS roles_26, u1_.password AS password_27, u1_.user_type AS user_type_28, u1_.fullname AS fullname_29, u1_.firstname AS firstname_30, u1_.lastname AS lastname_31, u1_.gender AS gender_32, u1_.country AS country_33, u1_.organisation AS organisation_34, u1_.website AS website_35, u1_.job AS job_36, u1_.phonenumber AS phonenumber_37, u1_.photo AS photo_38, u1_.status AS status_39, u1_.is_verified AS is_verified_40, u1_.setup_profile AS setup_profile_41, u1_.is_archived AS is_archived_42, s0_.user_id AS user_id_43 FROM study s0_ LEFT JOIN user u1_ ON s0_.user_id = u1_.id WHERE s0_.id = '219';

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4 FROM sector t0 INNER JOIN study_sector ON t0.id = study_sector.sector_id WHERE study_sector.study_id = ?

[
  219
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.name AS name_4
FROM
  sector t0
  INNER JOIN study_sector ON t0.id = study_sector.sector_id
WHERE
  study_sector.study_id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4 FROM sector t0 INNER JOIN study_sector ON t0.id = study_sector.sector_id WHERE study_sector.study_id = 219;

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4, t0.groupe_id AS groupe_id_5 FROM methodology t0 INNER JOIN study_methodology ON t0.id = study_methodology.methodology_id WHERE study_methodology.study_id = ?

[
  219
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.name AS name_4,
  t0.groupe_id AS groupe_id_5
FROM
  methodology t0
  INNER JOIN study_methodology ON t0.id = study_methodology.methodology_id
WHERE
  study_methodology.study_id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4, t0.groupe_id AS groupe_id_5 FROM methodology t0 INNER JOIN study_methodology ON t0.id = study_methodology.methodology_id WHERE study_methodology.study_id = 219;

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4 FROM keywords t0 INNER JOIN study_keywords ON t0.id = study_keywords.keywords_id WHERE study_keywords.study_id = ?

[
  219
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.title AS title_4
FROM
  keywords t0
  INNER JOIN study_keywords ON t0.id = study_keywords.keywords_id
WHERE
  study_keywords.study_id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4 FROM keywords t0 INNER JOIN study_keywords ON t0.id = study_keywords.keywords_id WHERE study_keywords.study_id = 219;

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4, t0.email AS email_5, t0.phonenumber AS phonenumber_6, t0.instagram_link AS instagram_link_7, t0.facebook_link AS facebook_link_8, t0.linkedin_link AS linkedin_link_9, t0.twitter_link AS twitter_link_10 FROM footer_contact t0 WHERE t0.lang = ? LIMIT 1

[
  "en"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.title AS title_4,
  t0.email AS email_5,
  t0.phonenumber AS phonenumber_6,
  t0.instagram_link AS instagram_link_7,
  t0.facebook_link AS facebook_link_8,
  t0.linkedin_link AS linkedin_link_9,
  t0.twitter_link AS twitter_link_10
FROM
  footer_contact t0
WHERE
  t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4, t0.email AS email_5, t0.phonenumber AS phonenumber_6, t0.instagram_link AS instagram_link_7, t0.facebook_link AS facebook_link_8, t0.linkedin_link AS linkedin_link_9, t0.twitter_link AS twitter_link_10 FROM footer_contact t0 WHERE t0.lang = 'en' LIMIT 1;