Query Metrics
8
Database Queries
8
Different statements
1.54 ms
Query time
0
Invalid entities
Grouped Statements
mysql_master connection
| Time▼ | Count | Info |
|---|---|---|
|
0.39 ms (25.02%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.username AS username_3, t0.password AS password_4, t0.accessToken AS accessToken_5, t0.fcmToken AS fcmToken_6, t0.tokenExpirationDate AS tokenExpirationDate_7, t0.isActive AS isActive_8, t0.isApiKey AS isApiKey_9, t0.scope AS scope_10, t0.society_group_id AS society_group_id_11, t0.society_id AS society_id_12, t0.access_id AS access_id_13 FROM api_rest_access_api t0 WHERE t0.accessToken = ? LIMIT 1
Parameters:
[
"90fd7170b4943eebee3e7a29f2f16528f6abf5d792025a8f384ed2925e3285bb"
]
|
|
0.25 ms (16.51%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.internalRef AS internalRef_3, t0.ref AS ref_4, t0.name AS name_5, t0.isActive AS isActive_6, t0.isAnonymized AS isAnonymized_7, t0.termsDevis AS termsDevis_8, t0.termsSimulation AS termsSimulation_9, t0.mentionDevis AS mentionDevis_10, t0.mentionSimulation AS mentionSimulation_11, t0.termsInvoice AS termsInvoice_12, t0.mentionInvoice AS mentionInvoice_13, t0.clientResponsibility AS clientResponsibility_14, t0.siret AS siret_15, t0.toAnno AS toAnno_16, t0.moduleTemplateName AS moduleTemplateName_17, t0.moduleTemplateInfo AS moduleTemplateInfo_18, t0.rekto AS rekto_19, t0.jcaf AS jcaf_20, t0.bazaar AS bazaar_21, t0.activationEmailSent AS activationEmailSent_22, t0.snowEffectEnabled AS snowEffectEnabled_23, t0.info AS info_24, t0.departmentsDisplay AS departmentsDisplay_25, t0.guard_log AS guard_log_26, t0.author_access_id AS author_access_id_27, t0.admin_access_id AS admin_access_id_28, t0.logo_image_id AS logo_image_id_29, t0.default_manager_access_id AS default_manager_access_id_30, t0.contact_smtp_config_id AS contact_smtp_config_id_31, t0.noreply_smtp_config_id AS noreply_smtp_config_id_32, t0.application_id AS application_id_33, t0.address_id AS address_id_34, t0.billing_address_id AS billing_address_id_35, t0.society_group_request_id AS society_group_request_id_36, t0.access_api_id AS access_api_id_37, t38.id AS id_39, t38.creationDate AS creationDate_40, t38.email AS email_41, t38.name AS name_42, t38.roles AS roles_43, t38.password AS password_44, t38.isActive AS isActive_45, t38.isSystem AS isSystem_46, t38.isSuperadmin AS isSuperadmin_47, t38.lost_pwd_code AS lost_pwd_code_48, t38.activation_code AS activation_code_49, t38.activationDate AS activationDate_50, t38.session AS session_51, t38.referer AS referer_52, t38.language AS language_53, t38.id_rekto AS id_rekto_54, t38.society_group_id AS society_group_id_55, t38.author_access_id AS author_access_id_56, t38.access_function_id AS access_function_id_57, t38.society_group_request_id AS society_group_request_id_58, t38.society_group_author_id AS society_group_author_id_59, t38.access_settings_id AS access_settings_id_60 FROM society_group t0 LEFT JOIN access t38 ON t38.society_group_author_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.24 ms (15.86%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.email AS email_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.isActive AS isActive_7, t0.isSystem AS isSystem_8, t0.isSuperadmin AS isSuperadmin_9, t0.lost_pwd_code AS lost_pwd_code_10, t0.activation_code AS activation_code_11, t0.activationDate AS activationDate_12, t0.session AS session_13, t0.referer AS referer_14, t0.language AS language_15, t0.id_rekto AS id_rekto_16, t0.society_group_id AS society_group_id_17, t0.author_access_id AS author_access_id_18, t19.id AS id_20, t19.creationDate AS creationDate_21, t19.startDate AS startDate_22, t19.endDate AS endDate_23, t19.lastname AS lastname_24, t19.firstname AS firstname_25, t19.birthday AS birthday_26, t19.birthPlace AS birthPlace_27, t19.account AS account_28, t19.email AS email_29, t19.email_perso AS email_perso_30, t19.company AS company_31, t19.info AS info_32, t19.phone AS phone_33, t19.phone_perso AS phone_perso_34, t19.net_salary AS net_salary_35, t19.charges AS charges_36, t19.charged_salary AS charged_salary_37, t19.charges_coeff AS charges_coeff_38, t19.cost AS cost_39, t19.hourly_rate AS hourly_rate_40, t19.anonymized AS anonymized_41, t19.id_rekto_human_resource AS id_rekto_human_resource_42, t19.id_rekto_external_resource AS id_rekto_external_resource_43, t19.employee_number AS employee_number_44, t19.status_id AS status_id_45, t19.type_id AS type_id_46, t19.job_category_id AS job_category_id_47, t19.job_contract_id AS job_contract_id_48, t19.job_position_id AS job_position_id_49, t19.society_id AS society_id_50, t19.author_access_id AS author_access_id_51, t19.access_id AS access_id_52, t19.profile_image_id AS profile_image_id_53, t19.address_id AS address_id_54, t19.supplier_id AS supplier_id_55, t19.sector_id AS sector_id_56, t0.access_function_id AS access_function_id_57, t58.id AS id_59, t58.creationDate AS creationDate_60, t58.username AS username_61, t58.password AS password_62, t58.accessToken AS accessToken_63, t58.fcmToken AS fcmToken_64, t58.tokenExpirationDate AS tokenExpirationDate_65, t58.isActive AS isActive_66, t58.isApiKey AS isApiKey_67, t58.scope AS scope_68, t58.society_group_id AS society_group_id_69, t58.society_id AS society_id_70, t58.access_id AS access_id_71, t0.society_group_request_id AS society_group_request_id_72, t73.id AS id_74, t73.periodStart AS periodStart_75, t73.periodEnd AS periodEnd_76, t73.lastSave AS lastSave_77, t73.access_id AS access_id_78, t0.society_group_author_id AS society_group_author_id_79, t0.access_settings_id AS access_settings_id_80 FROM access t0 LEFT JOIN human_resource t19 ON t19.access_id = t0.id LEFT JOIN api_rest_access_api t58 ON t58.access_id = t0.id LEFT JOIN dashboard_config t73 ON t73.access_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.16 ms (10.72%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.email AS email_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.isActive AS isActive_7, t0.isSystem AS isSystem_8, t0.isSuperadmin AS isSuperadmin_9, t0.lost_pwd_code AS lost_pwd_code_10, t0.activation_code AS activation_code_11, t0.activationDate AS activationDate_12, t0.session AS session_13, t0.referer AS referer_14, t0.language AS language_15, t0.id_rekto AS id_rekto_16, t0.society_group_id AS society_group_id_17, t0.author_access_id AS author_access_id_18, t19.id AS id_20, t19.creationDate AS creationDate_21, t19.startDate AS startDate_22, t19.endDate AS endDate_23, t19.lastname AS lastname_24, t19.firstname AS firstname_25, t19.birthday AS birthday_26, t19.birthPlace AS birthPlace_27, t19.account AS account_28, t19.email AS email_29, t19.email_perso AS email_perso_30, t19.company AS company_31, t19.info AS info_32, t19.phone AS phone_33, t19.phone_perso AS phone_perso_34, t19.net_salary AS net_salary_35, t19.charges AS charges_36, t19.charged_salary AS charged_salary_37, t19.charges_coeff AS charges_coeff_38, t19.cost AS cost_39, t19.hourly_rate AS hourly_rate_40, t19.anonymized AS anonymized_41, t19.id_rekto_human_resource AS id_rekto_human_resource_42, t19.id_rekto_external_resource AS id_rekto_external_resource_43, t19.employee_number AS employee_number_44, t19.status_id AS status_id_45, t19.type_id AS type_id_46, t19.job_category_id AS job_category_id_47, t19.job_contract_id AS job_contract_id_48, t19.job_position_id AS job_position_id_49, t19.society_id AS society_id_50, t19.author_access_id AS author_access_id_51, t19.access_id AS access_id_52, t19.profile_image_id AS profile_image_id_53, t19.address_id AS address_id_54, t19.supplier_id AS supplier_id_55, t19.sector_id AS sector_id_56, t0.access_function_id AS access_function_id_57, t58.id AS id_59, t58.creationDate AS creationDate_60, t58.username AS username_61, t58.password AS password_62, t58.accessToken AS accessToken_63, t58.fcmToken AS fcmToken_64, t58.tokenExpirationDate AS tokenExpirationDate_65, t58.isActive AS isActive_66, t58.isApiKey AS isApiKey_67, t58.scope AS scope_68, t58.society_group_id AS society_group_id_69, t58.society_id AS society_id_70, t58.access_id AS access_id_71, t0.society_group_request_id AS society_group_request_id_72, t73.id AS id_74, t73.periodStart AS periodStart_75, t73.periodEnd AS periodEnd_76, t73.lastSave AS lastSave_77, t73.access_id AS access_id_78, t0.society_group_author_id AS society_group_author_id_79, t0.access_settings_id AS access_settings_id_80 FROM access t0 LEFT JOIN human_resource t19 ON t19.access_id = t0.id LEFT JOIN api_rest_access_api t58 ON t58.access_id = t0.id LEFT JOIN dashboard_config t73 ON t73.access_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
19
]
|
|
0.16 ms (10.58%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.startDate AS startDate_3, t0.endDate AS endDate_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.birthday AS birthday_7, t0.birthPlace AS birthPlace_8, t0.account AS account_9, t0.email AS email_10, t0.email_perso AS email_perso_11, t0.company AS company_12, t0.info AS info_13, t0.phone AS phone_14, t0.phone_perso AS phone_perso_15, t0.net_salary AS net_salary_16, t0.charges AS charges_17, t0.charged_salary AS charged_salary_18, t0.charges_coeff AS charges_coeff_19, t0.cost AS cost_20, t0.hourly_rate AS hourly_rate_21, t0.anonymized AS anonymized_22, t0.id_rekto_human_resource AS id_rekto_human_resource_23, t0.id_rekto_external_resource AS id_rekto_external_resource_24, t0.employee_number AS employee_number_25, t0.status_id AS status_id_26, t0.type_id AS type_id_27, t0.job_category_id AS job_category_id_28, t0.job_contract_id AS job_contract_id_29, t0.job_position_id AS job_position_id_30, t0.society_id AS society_id_31, t0.author_access_id AS author_access_id_32, t0.access_id AS access_id_33, t0.profile_image_id AS profile_image_id_34, t0.address_id AS address_id_35, t0.supplier_id AS supplier_id_36, t0.sector_id AS sector_id_37 FROM human_resource t0 WHERE t0.access_id = ?
Parameters:
[
18
]
|
|
0.13 ms (8.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.info AS info_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"maintenance"
]
|
|
0.11 ms (7.14%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.username AS username_3, t0.password AS password_4, t0.accessToken AS accessToken_5, t0.fcmToken AS fcmToken_6, t0.tokenExpirationDate AS tokenExpirationDate_7, t0.isActive AS isActive_8, t0.isApiKey AS isApiKey_9, t0.scope AS scope_10, t0.society_group_id AS society_group_id_11, t0.society_id AS society_id_12, t0.access_id AS access_id_13 FROM api_rest_access_api t0 WHERE t0.access_id = ?
Parameters:
[
18
]
|
|
0.08 ms (5.45%) |
1 |
SELECT t0.id AS id_1, t0.periodStart AS periodStart_2, t0.periodEnd AS periodEnd_3, t0.lastSave AS lastSave_4, t0.access_id AS access_id_5 FROM dashboard_config t0 WHERE t0.access_id = ?
Parameters:
[
18
]
|
Database Connections
| Name | Service |
|---|---|
| mysql_master | doctrine.dbal.mysql_master_connection |
| mysql_direct_mysql1 | doctrine.dbal.mysql_direct_mysql1_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| direct_mysql1 | doctrine.orm.direct_mysql1_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\APIRest\AccessAPI | No errors. |
| App\Entity\SocietyGroup | No errors. |
| App\Entity\Platform\Society | No errors. |
| App\Entity\Access | No errors. |
| App\Entity\Config\Config | No errors. |
| App\Entity\HR\HumanResource | No errors. |
| App\Entity\HR\HumanResourceStatus | No errors. |
| App\Entity\HR\HumanResourceType | No errors. |
| App\Entity\HR\HumanResourceJobCategory | No errors. |
| App\Entity\HR\HumanResourceJobContract | No errors. |
| App\Entity\HR\HumanResourceJobPosition | No errors. |
| App\Entity\Common\Image | No errors. |
| App\Entity\Location\Address | No errors. |
| App\Entity\Platform\Supplier | No errors. |
| App\Entity\Platform\Sector | No errors. |
| App\Entity\HR\AccessFunction | No errors. |
| App\Entity\Platform\SocietyGroup\SocietyGroupRequest | No errors. |
| App\Entity\Dashboard\DashboardConfig | No errors. |
| App\Entity\Access\AccessSettings | No errors. |
| App\Entity\Security\AclPlanning | No errors. |
| App\Entity\Menu\Menu | No errors. |
| App\Entity\Planning\PlanningResource | No errors. |
| App\Entity\Common\Attachment | No errors. |
| App\Entity\Platform\Skill | No errors. |
| App\Entity\Security\SmtpConfig | No errors. |
| App\Entity\HR\Application\Application | No errors. |
| App\Entity\Config\ModuleConfig | No errors. |
| App\Entity\Location\Department | No errors. |
| App\Entity\Platform\Activity | No errors. |
| App\Entity\Config\CustomModule | No errors. |
| App\Entity\Security\Acl | No errors. |
| App\Entity\Security\AclPermission | No errors. |
direct_mysql1 entity manager
No loaded entities.