Query Metrics
7
Database Queries
7
Different statements
13.67 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.81 ms (35.20%) |
1 |
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_upd AS date_upd_3, t0.is_deleted AS is_deleted_4, t0.is_locked AS is_locked_5, t0.is_draft AS is_draft_6, t0.can_be_deleted AS can_be_deleted_7, t0.deleted_at AS deleted_at_8, t0.owner_organization_id AS owner_organization_id_9, t0.companies_ids AS companies_ids_10, t0.lastname AS lastname_11, t0.firstname AS firstname_12, t0.birth_place AS birth_place_13, t0.birth_date AS birth_date_14, t0.gender AS gender_15, t0.deleted_by_id AS deleted_by_id_16, t17.id AS id_18, t17.date_add AS date_add_19, t17.date_upd AS date_upd_20, t17.is_deleted AS is_deleted_21, t17.is_locked AS is_locked_22, t17.is_draft AS is_draft_23, t17.can_be_deleted AS can_be_deleted_24, t17.deleted_at AS deleted_at_25, t17.owner_organization_id AS owner_organization_id_26, t17.companies_ids AS companies_ids_27, t17.lastname AS lastname_28, t17.firstname AS firstname_29, t17.birth_place AS birth_place_30, t17.birth_date AS birth_date_31, t17.gender AS gender_32, t17.deleted_by_id AS deleted_by_id_33, t17.author_id AS author_id_34, t17.access_id AS access_id_35, t0.author_id AS author_id_36, t37.id AS id_38, t37.date_add AS date_add_39, t37.date_upd AS date_upd_40, t37.is_deleted AS is_deleted_41, t37.is_locked AS is_locked_42, t37.is_draft AS is_draft_43, t37.can_be_deleted AS can_be_deleted_44, t37.deleted_at AS deleted_at_45, t37.owner_organization_id AS owner_organization_id_46, t37.companies_ids AS companies_ids_47, t37.lastname AS lastname_48, t37.firstname AS firstname_49, t37.birth_place AS birth_place_50, t37.birth_date AS birth_date_51, t37.gender AS gender_52, t37.deleted_by_id AS deleted_by_id_53, t37.author_id AS author_id_54, t37.access_id AS access_id_55, t0.access_id AS access_id_56, t57.id AS id_58, t57.date_add AS date_add_59, t57.date_upd AS date_upd_60, t57.is_deleted AS is_deleted_61, t57.is_locked AS is_locked_62, t57.is_draft AS is_draft_63, t57.can_be_deleted AS can_be_deleted_64, t57.deleted_at AS deleted_at_65, t57.owner_organization_id AS owner_organization_id_66, t57.companies_ids AS companies_ids_67, t57.email AS email_68, t57.last_connection_date AS last_connection_date_69, t57.token AS token_70, t57.confirmation_token AS confirmation_token_71, t57.context_type AS context_type_72, t57.password AS password_73, t57.is_active AS is_active_74, t57.is_blocked AS is_blocked_75, t57.roles AS roles_76, t57.reset_token_expires_at AS reset_token_expires_at_77, t57.reset_token AS reset_token_78, t57.is_verified AS is_verified_79, t57.otp_code_hash AS otp_code_hash_80, t57.otp_expires_at AS otp_expires_at_81, t57.otp_attempts AS otp_attempts_82, t57.phone AS phone_83, t57.deleted_by_id AS deleted_by_id_84, t57.author_id AS author_id_85, t86.id AS id_87, t86.date_add AS date_add_88, t86.date_upd AS date_upd_89, t86.is_deleted AS is_deleted_90, t86.is_locked AS is_locked_91, t86.is_draft AS is_draft_92, t86.can_be_deleted AS can_be_deleted_93, t86.deleted_at AS deleted_at_94, t86.owner_organization_id AS owner_organization_id_95, t86.companies_ids AS companies_ids_96, t86.matricule AS matricule_97, t86.position AS position_98, t86.is_blocked AS is_blocked_99, t86.deleted_by_id AS deleted_by_id_100, t86.author_id AS author_id_101, t86.actor_id AS actor_id_102, t86.contact_id AS contact_id_103, t86.organization_id AS organization_id_104, t86.type_id AS type_id_105, t86.profession_id AS profession_id_106, t107.id AS id_108, t107.date_add AS date_add_109, t107.date_upd AS date_upd_110, t107.is_deleted AS is_deleted_111, t107.is_locked AS is_locked_112, t107.is_draft AS is_draft_113, t107.can_be_deleted AS can_be_deleted_114, t107.deleted_at AS deleted_at_115, t107.owner_organization_id AS owner_organization_id_116, t107.companies_ids AS companies_ids_117, t107.context_type AS context_type_118, t107.deleted_by_id AS deleted_by_id_119, t107.author_id AS author_id_120, t107.actor_id AS actor_id_121, t107.organization_id AS organization_id_122 FROM app_core_user_actor t0 LEFT JOIN app_core_user_actor t17 ON t0.deleted_by_id = t17.id LEFT JOIN app_core_user_actor t37 ON t0.author_id = t37.id INNER JOIN app_core_user_access t57 ON t0.access_id = t57.id LEFT JOIN app_core_user_collaborator t86 ON t86.actor_id = t0.id LEFT JOIN app_core_user_workspace t107 ON t107.actor_id = t0.id WHERE t0.access_id = ?
Parameters:
[
162
]
|
|
2.62 ms (19.17%) |
1 |
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_upd AS date_upd_3, t0.is_deleted AS is_deleted_4, t0.is_locked AS is_locked_5, t0.is_draft AS is_draft_6, t0.can_be_deleted AS can_be_deleted_7, t0.deleted_at AS deleted_at_8, t0.owner_organization_id AS owner_organization_id_9, t0.companies_ids AS companies_ids_10, t0.name AS name_11, t0.opening_hours AS opening_hours_12, t0.closing_hours AS closing_hours_13, t0.is_plateform_manager AS is_plateform_manager_14, t0.thumbnail_id AS thumbnail_id_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.cover_image_id AS cover_image_id_18, t0.opening_days AS opening_days_19, t0.deleted_by_id AS deleted_by_id_20, t21.id AS id_22, t21.date_add AS date_add_23, t21.date_upd AS date_upd_24, t21.is_deleted AS is_deleted_25, t21.is_locked AS is_locked_26, t21.is_draft AS is_draft_27, t21.can_be_deleted AS can_be_deleted_28, t21.deleted_at AS deleted_at_29, t21.owner_organization_id AS owner_organization_id_30, t21.companies_ids AS companies_ids_31, t21.lastname AS lastname_32, t21.firstname AS firstname_33, t21.birth_place AS birth_place_34, t21.birth_date AS birth_date_35, t21.gender AS gender_36, t21.deleted_by_id AS deleted_by_id_37, t21.author_id AS author_id_38, t21.access_id AS access_id_39, t0.author_id AS author_id_40, t41.id AS id_42, t41.date_add AS date_add_43, t41.date_upd AS date_upd_44, t41.is_deleted AS is_deleted_45, t41.is_locked AS is_locked_46, t41.is_draft AS is_draft_47, t41.can_be_deleted AS can_be_deleted_48, t41.deleted_at AS deleted_at_49, t41.owner_organization_id AS owner_organization_id_50, t41.companies_ids AS companies_ids_51, t41.lastname AS lastname_52, t41.firstname AS firstname_53, t41.birth_place AS birth_place_54, t41.birth_date AS birth_date_55, t41.gender AS gender_56, t41.deleted_by_id AS deleted_by_id_57, t41.author_id AS author_id_58, t41.access_id AS access_id_59, t0.actor_id AS actor_id_60, t61.id AS id_62, t61.date_add AS date_add_63, t61.date_upd AS date_upd_64, t61.is_deleted AS is_deleted_65, t61.is_locked AS is_locked_66, t61.is_draft AS is_draft_67, t61.can_be_deleted AS can_be_deleted_68, t61.deleted_at AS deleted_at_69, t61.owner_organization_id AS owner_organization_id_70, t61.companies_ids AS companies_ids_71, t61.lastname AS lastname_72, t61.firstname AS firstname_73, t61.birth_place AS birth_place_74, t61.birth_date AS birth_date_75, t61.gender AS gender_76, t61.deleted_by_id AS deleted_by_id_77, t61.author_id AS author_id_78, t61.access_id AS access_id_79, t0.contact_id AS contact_id_80, t81.id AS id_82, t81.date_add AS date_add_83, t81.date_upd AS date_upd_84, t81.is_deleted AS is_deleted_85, t81.is_locked AS is_locked_86, t81.is_draft AS is_draft_87, t81.can_be_deleted AS can_be_deleted_88, t81.deleted_at AS deleted_at_89, t81.owner_organization_id AS owner_organization_id_90, t81.companies_ids AS companies_ids_91, t81.calling_code AS calling_code_92, t81.phone AS phone_93, t81.email AS email_94, t81.web_site AS web_site_95, t81.address AS address_96, t81.city AS city_97, t81.latitude AS latitude_98, t81.longitude AS longitude_99, t81.deleted_by_id AS deleted_by_id_100, t81.author_id AS author_id_101, t81.state_id AS state_id_102 FROM app_core_user_organization t0 LEFT JOIN app_core_user_actor t21 ON t0.deleted_by_id = t21.id LEFT JOIN app_core_user_actor t41 ON t0.author_id = t41.id LEFT JOIN app_core_user_actor t61 ON t0.actor_id = t61.id LEFT JOIN app_core_location_contact t81 ON t0.contact_id = t81.id WHERE t0.id IN (?)
Parameters:
[
110
]
|
|
2.42 ms (17.72%) |
1 |
SELECT a0_.id AS id_0, a0_.date_add AS date_add_1, a0_.date_upd AS date_upd_2, a0_.is_deleted AS is_deleted_3, a0_.is_locked AS is_locked_4, a0_.is_draft AS is_draft_5, a0_.can_be_deleted AS can_be_deleted_6, a0_.deleted_at AS deleted_at_7, a0_.owner_organization_id AS owner_organization_id_8, a0_.companies_ids AS companies_ids_9, a0_.email AS email_10, a0_.last_connection_date AS last_connection_date_11, a0_.token AS token_12, a0_.confirmation_token AS confirmation_token_13, a0_.context_type AS context_type_14, a0_.password AS password_15, a0_.is_active AS is_active_16, a0_.is_blocked AS is_blocked_17, a0_.roles AS roles_18, a0_.reset_token_expires_at AS reset_token_expires_at_19, a0_.reset_token AS reset_token_20, a0_.is_verified AS is_verified_21, a0_.otp_code_hash AS otp_code_hash_22, a0_.otp_expires_at AS otp_expires_at_23, a0_.otp_attempts AS otp_attempts_24, a0_.phone AS phone_25, a0_.deleted_by_id AS deleted_by_id_26, a0_.author_id AS author_id_27 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = true
Parameters:
[
"shalomyimga19@gmail.com"
]
|
|
1.45 ms (10.57%) |
1 |
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_upd AS date_upd_3, t0.is_deleted AS is_deleted_4, t0.is_locked AS is_locked_5, t0.is_draft AS is_draft_6, t0.can_be_deleted AS can_be_deleted_7, t0.deleted_at AS deleted_at_8, t0.owner_organization_id AS owner_organization_id_9, t0.companies_ids AS companies_ids_10, t0.filename AS filename_11, t0.original_name AS original_name_12, t0.hash AS hash_13, t0.extension AS extension_14, t0.size AS size_15, t0.is_temporary AS is_temporary_16, t0.deleted_by_id AS deleted_by_id_17, t18.id AS id_19, t18.date_add AS date_add_20, t18.date_upd AS date_upd_21, t18.is_deleted AS is_deleted_22, t18.is_locked AS is_locked_23, t18.is_draft AS is_draft_24, t18.can_be_deleted AS can_be_deleted_25, t18.deleted_at AS deleted_at_26, t18.owner_organization_id AS owner_organization_id_27, t18.companies_ids AS companies_ids_28, t18.lastname AS lastname_29, t18.firstname AS firstname_30, t18.birth_place AS birth_place_31, t18.birth_date AS birth_date_32, t18.gender AS gender_33, t18.deleted_by_id AS deleted_by_id_34, t18.author_id AS author_id_35, t18.access_id AS access_id_36, t0.author_id AS author_id_37, t38.id AS id_39, t38.date_add AS date_add_40, t38.date_upd AS date_upd_41, t38.is_deleted AS is_deleted_42, t38.is_locked AS is_locked_43, t38.is_draft AS is_draft_44, t38.can_be_deleted AS can_be_deleted_45, t38.deleted_at AS deleted_at_46, t38.owner_organization_id AS owner_organization_id_47, t38.companies_ids AS companies_ids_48, t38.lastname AS lastname_49, t38.firstname AS firstname_50, t38.birth_place AS birth_place_51, t38.birth_date AS birth_date_52, t38.gender AS gender_53, t38.deleted_by_id AS deleted_by_id_54, t38.author_id AS author_id_55, t38.access_id AS access_id_56 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t18 ON t0.deleted_by_id = t18.id LEFT JOIN app_core_user_actor t38 ON t0.author_id = t38.id INNER JOIN app_core_organization_attachment ON t0.id = app_core_organization_attachment.organization_attachment_id WHERE app_core_organization_attachment.organization_id = ?
Parameters:
[
110
]
|
|
1.03 ms (7.52%) |
1 |
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_upd AS date_upd_3, t0.is_deleted AS is_deleted_4, t0.is_locked AS is_locked_5, t0.is_draft AS is_draft_6, t0.can_be_deleted AS can_be_deleted_7, t0.deleted_at AS deleted_at_8, t0.owner_organization_id AS owner_organization_id_9, t0.companies_ids AS companies_ids_10, t0.deleted_by_id AS deleted_by_id_11, t12.id AS id_13, t12.date_add AS date_add_14, t12.date_upd AS date_upd_15, t12.is_deleted AS is_deleted_16, t12.is_locked AS is_locked_17, t12.is_draft AS is_draft_18, t12.can_be_deleted AS can_be_deleted_19, t12.deleted_at AS deleted_at_20, t12.owner_organization_id AS owner_organization_id_21, t12.companies_ids AS companies_ids_22, t12.lastname AS lastname_23, t12.firstname AS firstname_24, t12.birth_place AS birth_place_25, t12.birth_date AS birth_date_26, t12.gender AS gender_27, t12.deleted_by_id AS deleted_by_id_28, t12.author_id AS author_id_29, t12.access_id AS access_id_30, t0.author_id AS author_id_31, t32.id AS id_33, t32.date_add AS date_add_34, t32.date_upd AS date_upd_35, t32.is_deleted AS is_deleted_36, t32.is_locked AS is_locked_37, t32.is_draft AS is_draft_38, t32.can_be_deleted AS can_be_deleted_39, t32.deleted_at AS deleted_at_40, t32.owner_organization_id AS owner_organization_id_41, t32.companies_ids AS companies_ids_42, t32.lastname AS lastname_43, t32.firstname AS firstname_44, t32.birth_place AS birth_place_45, t32.birth_date AS birth_date_46, t32.gender AS gender_47, t32.deleted_by_id AS deleted_by_id_48, t32.author_id AS author_id_49, t32.access_id AS access_id_50, t0.collaborator_id AS collaborator_id_51, t52.id AS id_53, t52.date_add AS date_add_54, t52.date_upd AS date_upd_55, t52.is_deleted AS is_deleted_56, t52.is_locked AS is_locked_57, t52.is_draft AS is_draft_58, t52.can_be_deleted AS can_be_deleted_59, t52.deleted_at AS deleted_at_60, t52.owner_organization_id AS owner_organization_id_61, t52.companies_ids AS companies_ids_62, t52.matricule AS matricule_63, t52.position AS position_64, t52.is_blocked AS is_blocked_65, t52.deleted_by_id AS deleted_by_id_66, t52.author_id AS author_id_67, t52.actor_id AS actor_id_68, t52.contact_id AS contact_id_69, t52.organization_id AS organization_id_70, t52.type_id AS type_id_71, t52.profession_id AS profession_id_72 FROM app_business_all_member t0 LEFT JOIN app_core_user_actor t12 ON t0.deleted_by_id = t12.id LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id INNER JOIN app_core_user_collaborator t52 ON t0.collaborator_id = t52.id WHERE t0.collaborator_id IN (?)
Parameters:
[
162
]
|
|
0.87 ms (6.39%) |
1 |
SELECT COUNT(a0_.id) AS sclr_0 FROM app_business_vehicle_notification a0_ WHERE a0_.organization_id = ? AND a0_.read_at IS NULL
Parameters:
[
110
]
|
|
0.47 ms (3.43%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6 FROM app_core_user_organization_i18n t0 WHERE t0.entity_id IN (?)
Parameters:
[
110
]
|
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\Core\Entity\AbstractEntity | No errors. |
| App\Core\Entity\User\Access | No errors. |
| App\Core\Entity\User\Actor |
|
| App\Core\Entity\User\Collaborator |
|
| App\Core\Entity\Location\Contact | No errors. |
| App\Core\Entity\User\Organization | No errors. |
| App\Business\Entity\Type | No errors. |
| App\Business\Entity\Profession | No errors. |
| App\Core\Entity\User\Workspace | No errors. |
| App\Business\Entity\BusinessMember | No errors. |
| App\Core\Entity\Location\State | No errors. |
| App\Core\Entity\AbstractEntityI18n | No errors. |
| App\Core\Entity\User\OrganizationI18n | No errors. |
| App\Core\Entity\Attachment | No errors. |
| App\Business\Entity\VehicleNotification | No errors. |