Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

85.17 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	84.82 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"_fragment"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = '_fragment' LIMIT 1;
2	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client 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.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.id = 1 LIMIT 1;

#▲

Time

Info

84.82 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "_fragment"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.rgpd_file AS rgpd_file_4,
  t0.description AS description_5,
  t0.baseline AS baseline_6,
  t0.background AS background_7,
  t0.alt_logo AS alt_logo_8,
  t0.is_active AS is_active_9,
  t0.created_at AS created_at_10,
  t0.modified_at AS modified_at_11,
  t0.slug AS slug_12,
  t0.salt AS salt_13,
  t0.main_color AS main_color_14,
  t0.secondary_color AS secondary_color_15,
  t0.is_secure AS is_secure_16,
  t0.is_hidden_job_title AS is_hidden_job_title_17,
  t0.is_hidden_user_job AS is_hidden_user_job_18,
  t0.label_location AS label_location_19,
  t0.label_sub_location AS label_sub_location_20,
  t0.has_microsoft AS has_microsoft_21,
  t0.has_zoom AS has_zoom_22
FROM
  client t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = '_fragment' LIMIT 1;

0.35 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client 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.logo AS logo_3,
  t0.rgpd_file AS rgpd_file_4,
  t0.description AS description_5,
  t0.baseline AS baseline_6,
  t0.background AS background_7,
  t0.alt_logo AS alt_logo_8,
  t0.is_active AS is_active_9,
  t0.created_at AS created_at_10,
  t0.modified_at AS modified_at_11,
  t0.slug AS slug_12,
  t0.salt AS salt_13,
  t0.main_color AS main_color_14,
  t0.secondary_color AS secondary_color_15,
  t0.is_secure AS is_secure_16,
  t0.is_hidden_job_title AS is_hidden_job_title_17,
  t0.is_hidden_user_job AS is_hidden_user_job_18,
  t0.label_location AS label_location_19,
  t0.label_sub_location AS label_sub_location_20,
  t0.has_microsoft AS has_microsoft_21,
  t0.has_zoom AS has_zoom_22
FROM
  client t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.id = 1 LIMIT 1;

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\Client	No errors.
App\Entity\ClientProduct	The association App\Entity\ClientProduct#diagQuestions refers to the owning side field App\Entity\DiagQuestion#clientProduct which does not exist.
App\Entity\FlashWorkshop	No errors.
App\Entity\FlashUserWorkshop	No errors.
App\Entity\UserProduct	No errors.
App\Entity\User	No errors.
App\Entity\Location	No errors.
App\Entity\SubLocation	The association App\Entity\SubLocation#defiQuestions refers to the owning side field App\Entity\DefiQuestion#deniedSubLocation which does not exist.
App\Entity\Domain	No errors.
App\Entity\Job	No errors.
App\Entity\Contact	No errors.

Symfony Profiler

https://demo.plateform.jobinlive.fr/_fragment

Configuration Settings

Theme