Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.03 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.34 ms (66.08%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.clover_analytics_code AS clover_analytics_code_6, t0.contact_email AS contact_email_7, t0.admin_email AS admin_email_8, t0.number AS number_9, t0.privacy_policy AS privacy_policy_10, t0.legal_notice AS legal_notice_11, t0.cookies_policy AS cookies_policy_12, t0.url AS url_13, t0.domain AS domain_14, t0.author AS author_15, t0.google_analytics_codes AS google_analytics_codes_16, t0.favicon AS favicon_17 FROM settings t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.clover_analytics_code AS clover_analytics_code_6, t0.contact_email AS contact_email_7, t0.admin_email AS admin_email_8, t0.number AS number_9, t0.privacy_policy AS privacy_policy_10, t0.legal_notice AS legal_notice_11, t0.cookies_policy AS cookies_policy_12, t0.url AS url_13, t0.domain AS domain_14, t0.author AS author_15, t0.google_analytics_codes AS google_analytics_codes_16, t0.favicon AS favicon_17 FROM settings t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.clover_analytics_code AS clover_analytics_code_6, t0.contact_email AS contact_email_7, t0.admin_email AS admin_email_8, t0.number AS number_9, t0.privacy_policy AS privacy_policy_10, t0.legal_notice AS legal_notice_11, t0.cookies_policy AS cookies_policy_12, t0.url AS url_13, t0.domain AS domain_14, t0.author AS author_15, t0.google_analytics_codes AS google_analytics_codes_16, t0.favicon AS favicon_17 FROM settings t0 WHERE t0.id = 1 LIMIT 1;
0.69 ms (33.92%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.show_on_home AS show_on_home_4, t0.is_new AS is_new_5, t0.number AS number_6, t0.favicon AS favicon_7, t0.logo AS logo_8, t0.video_image AS video_image_9, t0.schedule AS schedule_10, t0.cover_image AS cover_image_11, t0.streaming_iframe AS streaming_iframe_12, t0.streaming_date AS streaming_date_13, t0.streaming_time AS streaming_time_14, t0.is_timer_shown AS is_timer_shown_15, t0.is_questions_button_shown AS is_questions_button_shown_16, t0.clover_project_number AS clover_project_number_17, t0.external_link AS external_link_18, t0.welcome_image AS welcome_image_19, t0.welcome_video_code AS welcome_video_code_20, t0.show_welcome_video AS show_welcome_video_21, t0.show_welcome_image AS show_welcome_image_22, t0.flip_iframe AS flip_iframe_23, t0.flip_doc AS flip_doc_24, t0.keywords AS keywords_25, t0.clover_analytics_code AS clover_analytics_code_26, t0.google_analytics_codes AS google_analytics_codes_27, t0.year_id AS year_id_28, t0.project_id AS project_id_29 FROM edition t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.show_on_home AS show_on_home_4, t0.is_new AS is_new_5, t0.number AS number_6, t0.favicon AS favicon_7, t0.logo AS logo_8, t0.video_image AS video_image_9, t0.schedule AS schedule_10, t0.cover_image AS cover_image_11, t0.streaming_iframe AS streaming_iframe_12, t0.streaming_date AS streaming_date_13, t0.streaming_time AS streaming_time_14, t0.is_timer_shown AS is_timer_shown_15, t0.is_questions_button_shown AS is_questions_button_shown_16, t0.clover_project_number AS clover_project_number_17, t0.external_link AS external_link_18, t0.welcome_image AS welcome_image_19, t0.welcome_video_code AS welcome_video_code_20, t0.show_welcome_video AS show_welcome_video_21, t0.show_welcome_image AS show_welcome_image_22, t0.flip_iframe AS flip_iframe_23, t0.flip_doc AS flip_doc_24, t0.keywords AS keywords_25, t0.clover_analytics_code AS clover_analytics_code_26, t0.google_analytics_codes AS google_analytics_codes_27, t0.year_id AS year_id_28, t0.project_id AS project_id_29 FROM edition t0 SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.show_on_home AS show_on_home_4, t0.is_new AS is_new_5, t0.number AS number_6, t0.favicon AS favicon_7, t0.logo AS logo_8, t0.video_image AS video_image_9, t0.schedule AS schedule_10, t0.cover_image AS cover_image_11, t0.streaming_iframe AS streaming_iframe_12, t0.streaming_date AS streaming_date_13, t0.streaming_time AS streaming_time_14, t0.is_timer_shown AS is_timer_shown_15, t0.is_questions_button_shown AS is_questions_button_shown_16, t0.clover_project_number AS clover_project_number_17, t0.external_link AS external_link_18, t0.welcome_image AS welcome_image_19, t0.welcome_video_code AS welcome_video_code_20, t0.show_welcome_video AS show_welcome_video_21, t0.show_welcome_image AS show_welcome_image_22, t0.flip_iframe AS flip_iframe_23, t0.flip_doc AS flip_doc_24, t0.keywords AS keywords_25, t0.clover_analytics_code AS clover_analytics_code_26, t0.google_analytics_codes AS google_analytics_codes_27, t0.year_id AS year_id_28, t0.project_id AS project_id_29 FROM edition t0;

Time▼

Count

Info

1.34 ms
(66.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.clover_analytics_code AS clover_analytics_code_6, t0.contact_email AS contact_email_7, t0.admin_email AS admin_email_8, t0.number AS number_9, t0.privacy_policy AS privacy_policy_10, t0.legal_notice AS legal_notice_11, t0.cookies_policy AS cookies_policy_12, t0.url AS url_13, t0.domain AS domain_14, t0.author AS author_15, t0.google_analytics_codes AS google_analytics_codes_16, t0.favicon AS favicon_17 FROM settings t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5,
  t0.clover_analytics_code AS clover_analytics_code_6,
  t0.contact_email AS contact_email_7,
  t0.admin_email AS admin_email_8,
  t0.number AS number_9,
  t0.privacy_policy AS privacy_policy_10,
  t0.legal_notice AS legal_notice_11,
  t0.cookies_policy AS cookies_policy_12,
  t0.url AS url_13,
  t0.domain AS domain_14,
  t0.author AS author_15,
  t0.google_analytics_codes AS google_analytics_codes_16,
  t0.favicon AS favicon_17
FROM
  settings t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.clover_analytics_code AS clover_analytics_code_6, t0.contact_email AS contact_email_7, t0.admin_email AS admin_email_8, t0.number AS number_9, t0.privacy_policy AS privacy_policy_10, t0.legal_notice AS legal_notice_11, t0.cookies_policy AS cookies_policy_12, t0.url AS url_13, t0.domain AS domain_14, t0.author AS author_15, t0.google_analytics_codes AS google_analytics_codes_16, t0.favicon AS favicon_17 FROM settings t0 WHERE t0.id = 1 LIMIT 1;

0.69 ms
(33.92%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.show_on_home AS show_on_home_4, t0.is_new AS is_new_5, t0.number AS number_6, t0.favicon AS favicon_7, t0.logo AS logo_8, t0.video_image AS video_image_9, t0.schedule AS schedule_10, t0.cover_image AS cover_image_11, t0.streaming_iframe AS streaming_iframe_12, t0.streaming_date AS streaming_date_13, t0.streaming_time AS streaming_time_14, t0.is_timer_shown AS is_timer_shown_15, t0.is_questions_button_shown AS is_questions_button_shown_16, t0.clover_project_number AS clover_project_number_17, t0.external_link AS external_link_18, t0.welcome_image AS welcome_image_19, t0.welcome_video_code AS welcome_video_code_20, t0.show_welcome_video AS show_welcome_video_21, t0.show_welcome_image AS show_welcome_image_22, t0.flip_iframe AS flip_iframe_23, t0.flip_doc AS flip_doc_24, t0.keywords AS keywords_25, t0.clover_analytics_code AS clover_analytics_code_26, t0.google_analytics_codes AS google_analytics_codes_27, t0.year_id AS year_id_28, t0.project_id AS project_id_29 FROM edition t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.show_on_home AS show_on_home_4,
  t0.is_new AS is_new_5,
  t0.number AS number_6,
  t0.favicon AS favicon_7,
  t0.logo AS logo_8,
  t0.video_image AS video_image_9,
  t0.schedule AS schedule_10,
  t0.cover_image AS cover_image_11,
  t0.streaming_iframe AS streaming_iframe_12,
  t0.streaming_date AS streaming_date_13,
  t0.streaming_time AS streaming_time_14,
  t0.is_timer_shown AS is_timer_shown_15,
  t0.is_questions_button_shown AS is_questions_button_shown_16,
  t0.clover_project_number AS clover_project_number_17,
  t0.external_link AS external_link_18,
  t0.welcome_image AS welcome_image_19,
  t0.welcome_video_code AS welcome_video_code_20,
  t0.show_welcome_video AS show_welcome_video_21,
  t0.show_welcome_image AS show_welcome_image_22,
  t0.flip_iframe AS flip_iframe_23,
  t0.flip_doc AS flip_doc_24,
  t0.keywords AS keywords_25,
  t0.clover_analytics_code AS clover_analytics_code_26,
  t0.google_analytics_codes AS google_analytics_codes_27,
  t0.year_id AS year_id_28,
  t0.project_id AS project_id_29
FROM
  edition t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.show_on_home AS show_on_home_4, t0.is_new AS is_new_5, t0.number AS number_6, t0.favicon AS favicon_7, t0.logo AS logo_8, t0.video_image AS video_image_9, t0.schedule AS schedule_10, t0.cover_image AS cover_image_11, t0.streaming_iframe AS streaming_iframe_12, t0.streaming_date AS streaming_date_13, t0.streaming_time AS streaming_time_14, t0.is_timer_shown AS is_timer_shown_15, t0.is_questions_button_shown AS is_questions_button_shown_16, t0.clover_project_number AS clover_project_number_17, t0.external_link AS external_link_18, t0.welcome_image AS welcome_image_19, t0.welcome_video_code AS welcome_video_code_20, t0.show_welcome_video AS show_welcome_video_21, t0.show_welcome_image AS show_welcome_image_22, t0.flip_iframe AS flip_iframe_23, t0.flip_doc AS flip_doc_24, t0.keywords AS keywords_25, t0.clover_analytics_code AS clover_analytics_code_26, t0.google_analytics_codes AS google_analytics_codes_27, t0.year_id AS year_id_28, t0.project_id AS project_id_29 FROM edition t0;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\User	No errors.
App\Entity\Edition	The association App\Entity\Edition#project refers to the inverse side field App\Entity\Project#years which does not exist.
App\Entity\Project	The mappings App\Entity\Project#editions and App\Entity\Edition#project are inconsistent with each other.
App\Entity\Video	No errors.
App\Entity\Year	No errors.
App\Entity\PageSection	No errors.
App\Entity\EditionBrand	No errors.

Symfony Profiler

GET https://2440.desarrollo-clover-sgm.es/politica-cookies

Configuration Settings

Theme