Query Metrics
6
Database Queries
4
Different statements
1.82 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.32 ms |
SELECT t0.configs_id AS configs_id_1, t0.configs_clef AS configs_clef_2, t0.configs_valeur AS configs_valeur_3 FROM config t0 WHERE t0.configs_clef = ? LIMIT 1
Parameters:
[
"email-test"
]
|
| 2 | 0.21 ms |
SELECT t0.configs_id AS configs_id_1, t0.configs_clef AS configs_clef_2, t0.configs_valeur AS configs_valeur_3 FROM config t0 WHERE t0.configs_clef = ? LIMIT 1
Parameters:
[
"mobile-test"
]
|
| 3 | 0.33 ms |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.directory AS directory_6, t0.file_name AS file_name_7, t0.file_original_name AS file_original_name_8, t0.file_mime_type AS file_mime_type_9, t0.file_size AS file_size_10, t0.file_dimensions AS file_dimensions_11, t0.file_type_id AS file_type_id_12, t0.cgu_id AS cgu_id_13, t0.type FROM cgu_file t0 WHERE t0.file_type_id = ? AND t0.type IN ('cgu') ORDER BY t0.created_at DESC, t0.id DESC LIMIT 1
Parameters:
[
1
]
|
| 4 | 0.26 ms |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.directory AS directory_6, t0.file_name AS file_name_7, t0.file_original_name AS file_original_name_8, t0.file_mime_type AS file_mime_type_9, t0.file_size AS file_size_10, t0.file_dimensions AS file_dimensions_11, t0.file_type_id AS file_type_id_12, t0.cgu_id AS cgu_id_13, t0.type FROM cgu_file t0 WHERE t0.file_type_id = ? AND t0.type IN ('cgu') ORDER BY t0.created_at DESC, t0.id DESC LIMIT 1
Parameters:
[
2
]
|
| 5 | 0.35 ms |
SELECT u0_.email AS email_0, u0_.password AS password_1, u0_.first_name AS first_name_2, u0_.last_name AS last_name_3, u0_.company AS company_4, u0_.phone_number AS phone_number_5, u0_.mobile AS mobile_6, u0_.last_date_email_password AS last_date_email_password_7, u0_.is_active AS is_active_8, u0_.salesforce_account_id AS salesforce_account_id_9, u0_.email_notification AS email_notification_10, u0_.browser_notification AS browser_notification_11, u0_.zip_code AS zip_code_12, u0_.address AS address_13, u0_.city AS city_14, u0_.job AS job_15, u0_.birth_date AS birth_date_16, u0_.birth_place AS birth_place_17, u0_.check_last_date_email_password AS check_last_date_email_password_18, u0_.is_moral_person AS is_moral_person_19, u0_.sms_invitation AS sms_invitation_20, u0_.company_name AS company_name_21, u0_.company_legal_form AS company_legal_form_22, u0_.company_adress AS company_adress_23, u0_.company_rcs_number AS company_rcs_number_24, u0_.company_rcs_place AS company_rcs_place_25, u0_.company_president_first_name AS company_president_first_name_26, u0_.company_president_last_name AS company_president_last_name_27, u0_.converted_lead_id AS converted_lead_id_28, u0_.ios_banner AS ios_banner_29, u0_.id AS id_30, u0_.unique_id AS unique_id_31, u0_.created_at AS created_at_32, u0_.updated_at AS updated_at_33, u0_.user_civility_id AS user_civility_id_34, u0_.user_type_id AS user_type_id_35, u0_.animator_id AS animator_id_36, u0_.manager_id AS manager_id_37, u0_.referent_id AS referent_id_38, u0_.user_level_id AS user_level_id_39, u0_.structure_id AS structure_id_40, u0_.created_by AS created_by_41, u0_.updated_by AS updated_by_42 FROM user u0_ WHERE u0_.user_type_id IN (?) ORDER BY u0_.first_name ASC, u0_.last_name ASC
Parameters:
[
5
]
|
| 6 | 0.35 ms |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.directory AS directory_6, t0.file_name AS file_name_7, t0.file_original_name AS file_original_name_8, t0.file_mime_type AS file_mime_type_9, t0.file_size AS file_size_10, t0.file_dimensions AS file_dimensions_11, t0.file_type_id AS file_type_id_12, t0.user_id AS user_id_13, t0.type FROM user_avatar_file t0 WHERE t0.user_id = ? AND t0.type IN ('userAvatar')
Parameters:
[
6
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Config | 2 |
| App\Entity\User | 2 |
| App\Entity\UserCivility | 1 |
| App\Entity\UserType | 1 |
| App\Entity\Structure | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Config | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserCivility | No errors. |
| App\Entity\UserType | No errors. |
| App\Entity\UserLevel | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\AbstractCguFile | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\CguFile | No errors. |
| App\Entity\FileType | No errors. |
| App\Entity\Cgu | No errors. |
| App\Entity\AbstractUserAvatarFile | No errors. |
| App\Entity\UserAvatarFile | No errors. |
| App\Entity\AbstractUserFile | No errors. |
| App\Entity\UserFile | No errors. |