Query Metrics
17
Database Queries
4
Different statements
14.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4.30 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.lastname AS lastname_2, a0_.type_account AS type_account_3, a0_.phone AS phone_4, a0_.job AS job_5, a0_.entreprise AS entreprise_6, a0_.activite AS activite_7, a0_.logo AS logo_8, a0_.adresse AS adresse_9, a0_.mail_entreprise AS mail_entreprise_10, a0_.phone_entreprise AS phone_entreprise_11, a0_.presentation AS presentation_12, a0_.url_site AS url_site_13, a0_.url_linkedin AS url_linkedin_14, a0_.url_facebook AS url_facebook_15, a0_.picture AS picture_16, a0_.pseudo AS pseudo_17, a0_.pseudo_detail AS pseudo_detail_18, a0_.role AS role_19, a0_.is_shown_on_map AS is_shown_on_map_20, a0_.is_active AS is_active_21, a0_.video AS video_22, a0_.url_instagram AS url_instagram_23, a0_.url_twitter AS url_twitter_24, a0_.audio AS audio_25, a0_.postal_code AS postal_code_26, a0_.city AS city_27, CASE WHEN a0_.pseudo IS NOT NULL AND a0_.pseudo <> '' THEN a0_.pseudo ELSE CONCAT(a0_.name, ' ', a0_.lastname) END AS sclr_28, a0_.user_id AS user_id_29 FROM account a0_ INNER JOIN user u1_ ON a0_.user_id = u1_.id WHERE u1_.active IS NOT NULL AND u1_.active <> 0 AND u1_.active <> ? ORDER BY sclr_28 ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 2 | 0.86 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||
| 3 | 0.65 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||
| 4 | 0.66 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
15
]
|
||||||||||||||||||||||||||||
| 5 | 0.65 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
29
]
|
||||||||||||||||||||||||||||
| 6 | 0.55 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
26
]
|
||||||||||||||||||||||||||||
| 7 | 0.56 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||
| 8 | 0.56 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
21
]
|
||||||||||||||||||||||||||||
| 9 | 0.59 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||
| 10 | 0.62 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
25
]
|
||||||||||||||||||||||||||||
| 11 | 0.54 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
31
]
|
||||||||||||||||||||||||||||
| 12 | 0.55 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
37
]
|
||||||||||||||||||||||||||||
| 13 | 0.57 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
28
]
|
||||||||||||||||||||||||||||
| 14 | 0.58 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
36
]
|
||||||||||||||||||||||||||||
| 15 | 1.02 ms |
SELECT t0.id AS id_1, t0.title_key AS title_key_2, t0.title_value AS title_value_3 FROM title t0 WHERE t0.title_key = ? LIMIT 1
Parameters:
[
"membres"
]
|
||||||||||||||||||||||||||||
| 16 | 1.24 ms |
SELECT t0.id AS id_1, t0.description_key AS description_key_2, t0.description_value AS description_value_3 FROM description t0 WHERE t0.description_key = ? LIMIT 1
Parameters:
[
"membres"
]
|
||||||||||||||||||||||||||||
| 17 | 0.45 ms |
SELECT t0.id AS id_1, t0.title_key AS title_key_2, t0.title_value AS title_value_3 FROM title t0 WHERE t0.title_key = ? LIMIT 1
Parameters:
[
"list-membres"
]
|
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\Account | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Title | No errors. |
| App\Entity\ArticleCategory | No errors. |
| App\Entity\ArticleContent | No errors. |
| App\Entity\Member | No errors. |
| App\Entity\Description | No errors. |