GET https://bangebj.thebest-group.com/api/app/collaborators/5

Query Metrics

9 Database Queries
8 Different statements
8.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.74 ms
SELECT a0_.email AS email_0, a0_.token AS token_1, a0_.confirmation_token AS confirmation_token_2, a0_.context_type AS context_type_3, a0_.password AS password_4, a0_.is_active AS is_active_5, a0_.is_blocked AS is_blocked_6, a0_.roles AS roles_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a0_.author_id AS author_id_16 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = 1
Parameters:
[
  "admin@technique.loc"
]
2 0.45 ms
SELECT t0.lastname AS lastname_1, t0.firstname AS firstname_2, t0.birth_place AS birth_place_3, t0.birth_date AS birth_date_4, t0.gender AS gender_5, t0.id AS id_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.deleted AS deleted_9, t0.locked AS locked_10, t0.is_draft AS is_draft_11, t0.can_be_deleted AS can_be_deleted_12, t0.owner_organization_id AS owner_organization_id_13, t0.access_id AS access_id_14, t15.email AS email_16, t15.token AS token_17, t15.confirmation_token AS confirmation_token_18, t15.context_type AS context_type_19, t15.password AS password_20, t15.is_active AS is_active_21, t15.is_blocked AS is_blocked_22, t15.roles AS roles_23, t15.id AS id_24, t15.date_add AS date_add_25, t15.date_upd AS date_upd_26, t15.deleted AS deleted_27, t15.locked AS locked_28, t15.is_draft AS is_draft_29, t15.can_be_deleted AS can_be_deleted_30, t15.owner_organization_id AS owner_organization_id_31, t15.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_actor t0 INNER JOIN app_core_user_access t15 ON t0.access_id = t15.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.access_id = ?
Parameters:
[
  1
]
3 0.45 ms
SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = ?
Parameters:
[
  1
]
4 0.88 ms
SELECT t0.name AS name_1, t0.is_plateform_manager AS is_plateform_manager_2, t0.id AS id_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.deleted AS deleted_6, t0.locked AS locked_7, t0.is_draft AS is_draft_8, t0.can_be_deleted AS can_be_deleted_9, t0.owner_organization_id AS owner_organization_id_10, t0.actor_id AS actor_id_11, t12.lastname AS lastname_13, t12.firstname AS firstname_14, t12.birth_place AS birth_place_15, t12.birth_date AS birth_date_16, t12.gender AS gender_17, t12.id AS id_18, t12.date_add AS date_add_19, t12.date_upd AS date_upd_20, t12.deleted AS deleted_21, t12.locked AS locked_22, t12.is_draft AS is_draft_23, t12.can_be_deleted AS can_be_deleted_24, t12.owner_organization_id AS owner_organization_id_25, t12.access_id AS access_id_26, t12.author_id AS author_id_27, t0.thumbnail_id AS thumbnail_id_28, t29.filename AS filename_30, t29.original_name AS original_name_31, t29.mime_type AS mime_type_32, t29.extension AS extension_33, t29.size AS size_34, t29.url AS url_35, t29.id AS id_36, t29.date_add AS date_add_37, t29.date_upd AS date_upd_38, t29.deleted AS deleted_39, t29.locked AS locked_40, t29.is_draft AS is_draft_41, t29.can_be_deleted AS can_be_deleted_42, t29.owner_organization_id AS owner_organization_id_43, t29.author_id AS author_id_44, t0.author_id AS author_id_45, t46.lastname AS lastname_47, t46.firstname AS firstname_48, t46.birth_place AS birth_place_49, t46.birth_date AS birth_date_50, t46.gender AS gender_51, t46.id AS id_52, t46.date_add AS date_add_53, t46.date_upd AS date_upd_54, t46.deleted AS deleted_55, t46.locked AS locked_56, t46.is_draft AS is_draft_57, t46.can_be_deleted AS can_be_deleted_58, t46.owner_organization_id AS owner_organization_id_59, t46.access_id AS access_id_60, t46.author_id AS author_id_61 FROM app_core_user_organization t0 INNER JOIN app_core_user_actor t12 ON t0.actor_id = t12.id LEFT JOIN app_core_attachment t29 ON t0.thumbnail_id = t29.id LEFT JOIN app_core_user_actor t46 ON t0.author_id = t46.id WHERE t0.id IN (?)
Parameters:
[
  1
]
5 1.32 ms
SELECT t0.matricule AS matricule_1, t0.position AS position_2, t0.is_blocked AS is_blocked_3, t0.blog_roles AS blog_roles_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.actor_id AS actor_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29, t0.contact_id AS contact_id_30, t31.phone AS phone_32, t31.email AS email_33, t31.web_site AS web_site_34, t31.address AS address_35, t31.city AS city_36, t31.id AS id_37, t31.date_add AS date_add_38, t31.date_upd AS date_upd_39, t31.deleted AS deleted_40, t31.locked AS locked_41, t31.is_draft AS is_draft_42, t31.can_be_deleted AS can_be_deleted_43, t31.owner_organization_id AS owner_organization_id_44, t31.country_id AS country_id_45, t31.state_id AS state_id_46, t31.author_id AS author_id_47, t0.organization_id AS organization_id_48, t49.name AS name_50, t49.is_plateform_manager AS is_plateform_manager_51, t49.id AS id_52, t49.date_add AS date_add_53, t49.date_upd AS date_upd_54, t49.deleted AS deleted_55, t49.locked AS locked_56, t49.is_draft AS is_draft_57, t49.can_be_deleted AS can_be_deleted_58, t49.owner_organization_id AS owner_organization_id_59, t49.actor_id AS actor_id_60, t49.thumbnail_id AS thumbnail_id_61, t49.author_id AS author_id_62, t0.author_id AS author_id_63, t64.lastname AS lastname_65, t64.firstname AS firstname_66, t64.birth_place AS birth_place_67, t64.birth_date AS birth_date_68, t64.gender AS gender_69, t64.id AS id_70, t64.date_add AS date_add_71, t64.date_upd AS date_upd_72, t64.deleted AS deleted_73, t64.locked AS locked_74, t64.is_draft AS is_draft_75, t64.can_be_deleted AS can_be_deleted_76, t64.owner_organization_id AS owner_organization_id_77, t64.access_id AS access_id_78, t64.author_id AS author_id_79 FROM app_core_user_collaborator t0 INNER JOIN app_core_user_actor t14 ON t0.actor_id = t14.id LEFT JOIN app_core_location_contact t31 ON t0.contact_id = t31.id INNER JOIN app_core_user_organization t49 ON t0.organization_id = t49.id LEFT JOIN app_core_user_actor t64 ON t0.author_id = t64.id WHERE t0.id = ?
Parameters:
[
  5
]
6 0.73 ms
SELECT t0.email AS email_1, t0.token AS token_2, t0.confirmation_token AS confirmation_token_3, t0.context_type AS context_type_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.is_blocked AS is_blocked_7, t0.roles AS roles_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t17.lastname AS lastname_18, t17.firstname AS firstname_19, t17.birth_place AS birth_place_20, t17.birth_date AS birth_date_21, t17.gender AS gender_22, t17.id AS id_23, t17.date_add AS date_add_24, t17.date_upd AS date_upd_25, t17.deleted AS deleted_26, t17.locked AS locked_27, t17.is_draft AS is_draft_28, t17.can_be_deleted AS can_be_deleted_29, t17.owner_organization_id AS owner_organization_id_30, t17.access_id AS access_id_31, t17.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.id IN (?)
Parameters:
[
  5
]
7 1.67 ms
SELECT t0.is_enabled AS is_enabled_1, t0.currency AS currency_2, t0.iso_code AS iso_code_3, t0.iso_code3 AS iso_code3_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.geometry_type AS geometry_type_7, t0.calling_code AS calling_code_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t0.author_id AS author_id_17, t18.lastname AS lastname_19, t18.firstname AS firstname_20, t18.birth_place AS birth_place_21, t18.birth_date AS birth_date_22, t18.gender AS gender_23, t18.id AS id_24, t18.date_add AS date_add_25, t18.date_upd AS date_upd_26, t18.deleted AS deleted_27, t18.locked AS locked_28, t18.is_draft AS is_draft_29, t18.can_be_deleted AS can_be_deleted_30, t18.owner_organization_id AS owner_organization_id_31, t18.access_id AS access_id_32, t18.author_id AS author_id_33 FROM app_core_location_country t0 LEFT JOIN app_core_user_actor t18 ON t0.author_id = t18.id WHERE t0.id IN (?)
Parameters:
[
  1
]
8 1.83 ms
SELECT t0.official_name AS official_name_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8 FROM app_core_location_country_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
  1
]
9 0.60 ms
SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = ?
Parameters:
[
  1
]

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.