Query Metrics
45
Database Queries
12
Different statements
4.72 ms
Query time
0
Invalid entities
Grouped Statements
mysql_master connection
| Time▼ | Count | Info |
|---|---|---|
|
2.48 ms (52.60%) |
34 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.info AS info_4, t0.translation AS translation_5, t0.master_module_id AS master_module_id_6 FROM common_module t0 WHERE t0.id = ?
Parameters:
[
21
]
|
|
0.59 ms (12.41%) |
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:
[
18
]
|
|
0.27 ms (5.75%) |
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:
[
17
]
|
|
0.21 ms (4.45%) |
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.21 ms (4.45%) |
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.21 ms (4.35%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.title AS title_3, t0.body AS body_4, t0.id_rekto AS id_rekto_5, t0.client_platform AS client_platform_6, t0.author_access_id AS author_access_id_7 FROM term_cond t0 WHERE t0.client_platform = ? ORDER BY t0.creationDate DESC LIMIT 1
Parameters:
[
0
]
|
|
0.20 ms (4.33%) |
1 |
SELECT t0.id AS id_1, t0.creationDate AS creationDate_2, t0.ref AS ref_3, t0.name AS name_4, t0.email AS email_5, t0.phoneNumber AS phoneNumber_6, t0.siren AS siren_7, t0.vatNumber AS vatNumber_8, t0.termsDevis AS termsDevis_9, t0.footer AS footer_10, t0.footer_webapp AS footer_webapp_11, t0.defaultSociety AS defaultSociety_12, t0.id_rekto_migration AS id_rekto_migration_13, t0.intervention_cost_type AS intervention_cost_type_14, t0.intervention_cost AS intervention_cost_15, t0.intervention_cost_percent AS intervention_cost_percent_16, t0.planning_position AS planning_position_17, t0.id_rekto AS id_rekto_18, t0.ikea_bp AS ikea_bp_19, t0.society_group_id AS society_group_id_20, t0.default_manager_access_id AS default_manager_access_id_21, t0.default_emitter_store_id AS default_emitter_store_id_22, t0.author_access_id AS author_access_id_23, t0.logo_image_id AS logo_image_id_24, t25.id AS id_26, t25.workDays AS workDays_27, t25.dayStart AS dayStart_28, t25.dayEnd AS dayEnd_29, t25.halfDayPoint AS halfDayPoint_30, t25.hours AS hours_31, t25.defaultValue AS defaultValue_32, t25.id_rekto AS id_rekto_33, t25.society_id AS society_id_34, t25.society_group_id AS society_group_id_35, t0.address_id AS address_id_36, t0.contact_smtp_config_id AS contact_smtp_config_id_37, t0.noreply_smtp_config_id AS noreply_smtp_config_id_38 FROM society t0 LEFT JOIN schedule t25 ON t25.society_id = t0.id INNER JOIN access_society_asso ON t0.id = access_society_asso.society_id WHERE access_society_asso.access_id = ? ORDER BY t0.ref ASC
Parameters:
[
18
]
|
|
0.14 ms (2.99%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.info AS info_4, t0.translation AS translation_5, t0.master_module_id AS master_module_id_6 FROM common_module t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
39
]
|
|
0.14 ms (2.91%) |
1 |
SELECT COUNT(DISTINCT notification.id) AS counter FROM ding_notification as notification INNER JOIN access ON notification.access_id = access.id WHERE access_id = :id_access and notification.seen = 0
Parameters:
[ "id_access" => 18 ] |
|
0.10 ms (2.12%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.name AS name_3, t0.translation AS translation_4, t0.module_id AS module_id_5, t0.society_group_id AS society_group_id_6 FROM common_module_config t0 WHERE t0.society_group_id = ?
Parameters:
[
1
]
|
|
0.09 ms (1.93%) |
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:
[
17
]
|
|
0.08 ms (1.72%) |
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:
[
17
]
|
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\Access | No errors. |
| App\Entity\SocietyGroup | 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\Platform\Society | 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\APIRest\AccessAPI | 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\Config\Config | No errors. |
| App\Entity\Client\Store | No errors. |
| App\Entity\Platform\Schedule | No errors. |
| App\Entity\Security\SmtpConfig | No errors. |
| App\Entity\HR\RHForm\HoursTemplate | No errors. |
| App\Entity\Location\Department | No errors. |
| App\Entity\Location\Town | No errors. |
| App\Entity\Security\Acl | No errors. |
| App\Entity\Security\AclPermission | No errors. |
| App\Entity\Config\Module | No errors. |
| App\Entity\Config\ModuleTemplate | No errors. |
| App\Entity\HR\Application\Application | No errors. |
| App\Entity\Config\ModuleConfig | No errors. |
| App\Entity\Platform\Activity | No errors. |
| App\Entity\Config\CustomModule | No errors. |
| App\Entity\TOS\TermCond | No errors. |
direct_mysql1 entity manager
No loaded entities.