Symfony Profiler

Query Metrics

44 Database Queries

28 Different statements

52.66 ms Query time

3 Invalid entities

Grouped Statements

Time▼	Count	Info
5.40 ms (10.25%)	1	SELECT DISTINCT id_0, MIN(sclr_57) AS dctrn_minrownum FROM (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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_57 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100 Parameters: [`13`] View formatted query View runnable query Explain query SELECT DISTINCT id_0, MIN(sclr_57) AS dctrn_minrownum FROM ( 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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56, ROW_NUMBER() OVER( ORDER BY a0_.date_add DESC ) AS sclr_57 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = ? ) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100 SELECT DISTINCT id_0, MIN(sclr_57) AS dctrn_minrownum FROM (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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_57 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = 13) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100;
3.80 ms (7.22%)	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.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_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.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 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 t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.access_id = ? Parameters: [`30`] View formatted query View runnable query Explain query 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.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_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.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 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 t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.access_id = ? 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.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_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.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 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 t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.access_id = 30;
3.69 ms (7.01%)	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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56, a0_.deleted_by_id AS deleted_by_id_57, a0_.author_id AS author_id_58, a0_.organization_id AS organization_id_59, a0_.service_id AS service_id_60, a1_.deleted_by_id AS deleted_by_id_61, a1_.author_id AS author_id_62, a1_.actor_id AS actor_id_63, a1_.contact_id AS contact_id_64, a2_.entity_id AS entity_id_65, a3_.deleted_by_id AS deleted_by_id_66, a3_.author_id AS author_id_67, a3_.organization_id AS organization_id_68, a3_.state_id AS state_id_69, a3_.neighborhood_id AS neighborhood_id_70, a3_.loyalty_program_id AS loyalty_program_id_71 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = ? AND a0_.id IN (?) ORDER BY a0_.date_add DESC Parameters: [`13 27`] View formatted query View runnable query Explain query 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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56, a0_.deleted_by_id AS deleted_by_id_57, a0_.author_id AS author_id_58, a0_.organization_id AS organization_id_59, a0_.service_id AS service_id_60, a1_.deleted_by_id AS deleted_by_id_61, a1_.author_id AS author_id_62, a1_.actor_id AS actor_id_63, a1_.contact_id AS contact_id_64, a2_.entity_id AS entity_id_65, a3_.deleted_by_id AS deleted_by_id_66, a3_.author_id AS author_id_67, a3_.organization_id AS organization_id_68, a3_.state_id AS state_id_69, a3_.neighborhood_id AS neighborhood_id_70, a3_.loyalty_program_id AS loyalty_program_id_71 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = ? AND a0_.id IN (?) ORDER BY a0_.date_add DESC 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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56, a0_.deleted_by_id AS deleted_by_id_57, a0_.author_id AS author_id_58, a0_.organization_id AS organization_id_59, a0_.service_id AS service_id_60, a1_.deleted_by_id AS deleted_by_id_61, a1_.author_id AS author_id_62, a1_.actor_id AS actor_id_63, a1_.contact_id AS contact_id_64, a2_.entity_id AS entity_id_65, a3_.deleted_by_id AS deleted_by_id_66, a3_.author_id AS author_id_67, a3_.organization_id AS organization_id_68, a3_.state_id AS state_id_69, a3_.neighborhood_id AS neighborhood_id_70, a3_.loyalty_program_id AS loyalty_program_id_71 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = 13 AND a0_.id IN (27) ORDER BY a0_.date_add DESC;
3.68 ms (6.98%)	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.duration AS duration_11, t0.cost AS cost_12, t0.pictures AS pictures_13, t0.position AS position_14, t0.value AS value_15, t0.isDynamic AS isdynamic_16, t0.isCustomer AS iscustomer_17, t0.points AS points_18, t0.commission_type AS commission_type_19, t0.commission_value AS commission_value_20, t0.deleted_by_id AS deleted_by_id_21, t22.id AS id_23, t22.date_add AS date_add_24, t22.date_upd AS date_upd_25, t22.is_deleted AS is_deleted_26, t22.is_locked AS is_locked_27, t22.is_draft AS is_draft_28, t22.can_be_deleted AS can_be_deleted_29, t22.deleted_at AS deleted_at_30, t22.owner_organization_id AS owner_organization_id_31, t22.companies_ids AS companies_ids_32, t22.lastname AS lastname_33, t22.firstname AS firstname_34, t22.birth_place AS birth_place_35, t22.birth_date AS birth_date_36, t22.gender AS gender_37, t22.deleted_by_id AS deleted_by_id_38, t22.author_id AS author_id_39, t22.access_id AS access_id_40, t0.author_id AS author_id_41, t42.id AS id_43, t42.date_add AS date_add_44, t42.date_upd AS date_upd_45, t42.is_deleted AS is_deleted_46, t42.is_locked AS is_locked_47, t42.is_draft AS is_draft_48, t42.can_be_deleted AS can_be_deleted_49, t42.deleted_at AS deleted_at_50, t42.owner_organization_id AS owner_organization_id_51, t42.companies_ids AS companies_ids_52, t42.lastname AS lastname_53, t42.firstname AS firstname_54, t42.birth_place AS birth_place_55, t42.birth_date AS birth_date_56, t42.gender AS gender_57, t42.deleted_by_id AS deleted_by_id_58, t42.author_id AS author_id_59, t42.access_id AS access_id_60, t0.organization_id AS organization_id_61, t62.id AS id_63, t62.date_add AS date_add_64, t62.date_upd AS date_upd_65, t62.is_deleted AS is_deleted_66, t62.is_locked AS is_locked_67, t62.is_draft AS is_draft_68, t62.can_be_deleted AS can_be_deleted_69, t62.deleted_at AS deleted_at_70, t62.owner_organization_id AS owner_organization_id_71, t62.companies_ids AS companies_ids_72, t62.name AS name_73, t62.opening_hours AS opening_hours_74, t62.closing_hours AS closing_hours_75, t62.is_plateform_manager AS is_plateform_manager_76, t62.thumbnail_id AS thumbnail_id_77, t62.latitude AS latitude_78, t62.longitude AS longitude_79, t62.cover_image_id AS cover_image_id_80, t62.opening_days AS opening_days_81, t62.deleted_by_id AS deleted_by_id_82, t62.author_id AS author_id_83, t62.actor_id AS actor_id_84, t62.contact_id AS contact_id_85, t0.state_id AS state_id_86, t87.id AS id_88, t87.date_add AS date_add_89, t87.date_upd AS date_upd_90, t87.is_deleted AS is_deleted_91, t87.is_locked AS is_locked_92, t87.is_draft AS is_draft_93, t87.can_be_deleted AS can_be_deleted_94, t87.deleted_at AS deleted_at_95, t87.owner_organization_id AS owner_organization_id_96, t87.companies_ids AS companies_ids_97, t87.code AS code_98, t87.deleted_by_id AS deleted_by_id_99, t87.author_id AS author_id_100, t87.country_id AS country_id_101, t0.neighborhood_id AS neighborhood_id_102, t103.id AS id_104, t103.date_add AS date_add_105, t103.date_upd AS date_upd_106, t103.is_deleted AS is_deleted_107, t103.is_locked AS is_locked_108, t103.is_draft AS is_draft_109, t103.can_be_deleted AS can_be_deleted_110, t103.deleted_at AS deleted_at_111, t103.owner_organization_id AS owner_organization_id_112, t103.companies_ids AS companies_ids_113, t103.latitude AS latitude_114, t103.longitude AS longitude_115, t103.deleted_by_id AS deleted_by_id_116, t103.author_id AS author_id_117, t103.state_id AS state_id_118, t0.loyalty_program_id AS loyalty_program_id_119, t120.id AS id_121, t120.date_add AS date_add_122, t120.date_upd AS date_upd_123, t120.is_deleted AS is_deleted_124, t120.is_locked AS is_locked_125, t120.is_draft AS is_draft_126, t120.can_be_deleted AS can_be_deleted_127, t120.deleted_at AS deleted_at_128, t120.owner_organization_id AS owner_organization_id_129, t120.companies_ids AS companies_ids_130, t120.points AS points_131, t120.threshold AS threshold_132, t120.value AS value_133, t120.deleted_by_id AS deleted_by_id_134, t120.author_id AS author_id_135, t120.organization_id AS organization_id_136, t120.service_id AS service_id_137 FROM app_business_service t0 LEFT JOIN app_core_user_actor t22 ON t0.deleted_by_id = t22.id LEFT JOIN app_core_user_actor t42 ON t0.author_id = t42.id LEFT JOIN app_core_user_organization t62 ON t0.organization_id = t62.id LEFT JOIN app_core_location_state t87 ON t0.state_id = t87.id LEFT JOIN app_core_location_neighborhood t103 ON t0.neighborhood_id = t103.id LEFT JOIN app_business_loyalty t120 ON t0.loyalty_program_id = t120.id WHERE t0.loyalty_program_id IN (?) Parameters: [`27`] View formatted query View runnable query Explain query 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.duration AS duration_11, t0.cost AS cost_12, t0.pictures AS pictures_13, t0.position AS position_14, t0.value AS value_15, t0.isDynamic AS isdynamic_16, t0.isCustomer AS iscustomer_17, t0.points AS points_18, t0.commission_type AS commission_type_19, t0.commission_value AS commission_value_20, t0.deleted_by_id AS deleted_by_id_21, t22.id AS id_23, t22.date_add AS date_add_24, t22.date_upd AS date_upd_25, t22.is_deleted AS is_deleted_26, t22.is_locked AS is_locked_27, t22.is_draft AS is_draft_28, t22.can_be_deleted AS can_be_deleted_29, t22.deleted_at AS deleted_at_30, t22.owner_organization_id AS owner_organization_id_31, t22.companies_ids AS companies_ids_32, t22.lastname AS lastname_33, t22.firstname AS firstname_34, t22.birth_place AS birth_place_35, t22.birth_date AS birth_date_36, t22.gender AS gender_37, t22.deleted_by_id AS deleted_by_id_38, t22.author_id AS author_id_39, t22.access_id AS access_id_40, t0.author_id AS author_id_41, t42.id AS id_43, t42.date_add AS date_add_44, t42.date_upd AS date_upd_45, t42.is_deleted AS is_deleted_46, t42.is_locked AS is_locked_47, t42.is_draft AS is_draft_48, t42.can_be_deleted AS can_be_deleted_49, t42.deleted_at AS deleted_at_50, t42.owner_organization_id AS owner_organization_id_51, t42.companies_ids AS companies_ids_52, t42.lastname AS lastname_53, t42.firstname AS firstname_54, t42.birth_place AS birth_place_55, t42.birth_date AS birth_date_56, t42.gender AS gender_57, t42.deleted_by_id AS deleted_by_id_58, t42.author_id AS author_id_59, t42.access_id AS access_id_60, t0.organization_id AS organization_id_61, t62.id AS id_63, t62.date_add AS date_add_64, t62.date_upd AS date_upd_65, t62.is_deleted AS is_deleted_66, t62.is_locked AS is_locked_67, t62.is_draft AS is_draft_68, t62.can_be_deleted AS can_be_deleted_69, t62.deleted_at AS deleted_at_70, t62.owner_organization_id AS owner_organization_id_71, t62.companies_ids AS companies_ids_72, t62.name AS name_73, t62.opening_hours AS opening_hours_74, t62.closing_hours AS closing_hours_75, t62.is_plateform_manager AS is_plateform_manager_76, t62.thumbnail_id AS thumbnail_id_77, t62.latitude AS latitude_78, t62.longitude AS longitude_79, t62.cover_image_id AS cover_image_id_80, t62.opening_days AS opening_days_81, t62.deleted_by_id AS deleted_by_id_82, t62.author_id AS author_id_83, t62.actor_id AS actor_id_84, t62.contact_id AS contact_id_85, t0.state_id AS state_id_86, t87.id AS id_88, t87.date_add AS date_add_89, t87.date_upd AS date_upd_90, t87.is_deleted AS is_deleted_91, t87.is_locked AS is_locked_92, t87.is_draft AS is_draft_93, t87.can_be_deleted AS can_be_deleted_94, t87.deleted_at AS deleted_at_95, t87.owner_organization_id AS owner_organization_id_96, t87.companies_ids AS companies_ids_97, t87.code AS code_98, t87.deleted_by_id AS deleted_by_id_99, t87.author_id AS author_id_100, t87.country_id AS country_id_101, t0.neighborhood_id AS neighborhood_id_102, t103.id AS id_104, t103.date_add AS date_add_105, t103.date_upd AS date_upd_106, t103.is_deleted AS is_deleted_107, t103.is_locked AS is_locked_108, t103.is_draft AS is_draft_109, t103.can_be_deleted AS can_be_deleted_110, t103.deleted_at AS deleted_at_111, t103.owner_organization_id AS owner_organization_id_112, t103.companies_ids AS companies_ids_113, t103.latitude AS latitude_114, t103.longitude AS longitude_115, t103.deleted_by_id AS deleted_by_id_116, t103.author_id AS author_id_117, t103.state_id AS state_id_118, t0.loyalty_program_id AS loyalty_program_id_119, t120.id AS id_121, t120.date_add AS date_add_122, t120.date_upd AS date_upd_123, t120.is_deleted AS is_deleted_124, t120.is_locked AS is_locked_125, t120.is_draft AS is_draft_126, t120.can_be_deleted AS can_be_deleted_127, t120.deleted_at AS deleted_at_128, t120.owner_organization_id AS owner_organization_id_129, t120.companies_ids AS companies_ids_130, t120.points AS points_131, t120.threshold AS threshold_132, t120.value AS value_133, t120.deleted_by_id AS deleted_by_id_134, t120.author_id AS author_id_135, t120.organization_id AS organization_id_136, t120.service_id AS service_id_137 FROM app_business_service t0 LEFT JOIN app_core_user_actor t22 ON t0.deleted_by_id = t22.id LEFT JOIN app_core_user_actor t42 ON t0.author_id = t42.id LEFT JOIN app_core_user_organization t62 ON t0.organization_id = t62.id LEFT JOIN app_core_location_state t87 ON t0.state_id = t87.id LEFT JOIN app_core_location_neighborhood t103 ON t0.neighborhood_id = t103.id LEFT JOIN app_business_loyalty t120 ON t0.loyalty_program_id = t120.id WHERE t0.loyalty_program_id IN (?) 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.duration AS duration_11, t0.cost AS cost_12, t0.pictures AS pictures_13, t0.position AS position_14, t0.value AS value_15, t0.isDynamic AS isdynamic_16, t0.isCustomer AS iscustomer_17, t0.points AS points_18, t0.commission_type AS commission_type_19, t0.commission_value AS commission_value_20, t0.deleted_by_id AS deleted_by_id_21, t22.id AS id_23, t22.date_add AS date_add_24, t22.date_upd AS date_upd_25, t22.is_deleted AS is_deleted_26, t22.is_locked AS is_locked_27, t22.is_draft AS is_draft_28, t22.can_be_deleted AS can_be_deleted_29, t22.deleted_at AS deleted_at_30, t22.owner_organization_id AS owner_organization_id_31, t22.companies_ids AS companies_ids_32, t22.lastname AS lastname_33, t22.firstname AS firstname_34, t22.birth_place AS birth_place_35, t22.birth_date AS birth_date_36, t22.gender AS gender_37, t22.deleted_by_id AS deleted_by_id_38, t22.author_id AS author_id_39, t22.access_id AS access_id_40, t0.author_id AS author_id_41, t42.id AS id_43, t42.date_add AS date_add_44, t42.date_upd AS date_upd_45, t42.is_deleted AS is_deleted_46, t42.is_locked AS is_locked_47, t42.is_draft AS is_draft_48, t42.can_be_deleted AS can_be_deleted_49, t42.deleted_at AS deleted_at_50, t42.owner_organization_id AS owner_organization_id_51, t42.companies_ids AS companies_ids_52, t42.lastname AS lastname_53, t42.firstname AS firstname_54, t42.birth_place AS birth_place_55, t42.birth_date AS birth_date_56, t42.gender AS gender_57, t42.deleted_by_id AS deleted_by_id_58, t42.author_id AS author_id_59, t42.access_id AS access_id_60, t0.organization_id AS organization_id_61, t62.id AS id_63, t62.date_add AS date_add_64, t62.date_upd AS date_upd_65, t62.is_deleted AS is_deleted_66, t62.is_locked AS is_locked_67, t62.is_draft AS is_draft_68, t62.can_be_deleted AS can_be_deleted_69, t62.deleted_at AS deleted_at_70, t62.owner_organization_id AS owner_organization_id_71, t62.companies_ids AS companies_ids_72, t62.name AS name_73, t62.opening_hours AS opening_hours_74, t62.closing_hours AS closing_hours_75, t62.is_plateform_manager AS is_plateform_manager_76, t62.thumbnail_id AS thumbnail_id_77, t62.latitude AS latitude_78, t62.longitude AS longitude_79, t62.cover_image_id AS cover_image_id_80, t62.opening_days AS opening_days_81, t62.deleted_by_id AS deleted_by_id_82, t62.author_id AS author_id_83, t62.actor_id AS actor_id_84, t62.contact_id AS contact_id_85, t0.state_id AS state_id_86, t87.id AS id_88, t87.date_add AS date_add_89, t87.date_upd AS date_upd_90, t87.is_deleted AS is_deleted_91, t87.is_locked AS is_locked_92, t87.is_draft AS is_draft_93, t87.can_be_deleted AS can_be_deleted_94, t87.deleted_at AS deleted_at_95, t87.owner_organization_id AS owner_organization_id_96, t87.companies_ids AS companies_ids_97, t87.code AS code_98, t87.deleted_by_id AS deleted_by_id_99, t87.author_id AS author_id_100, t87.country_id AS country_id_101, t0.neighborhood_id AS neighborhood_id_102, t103.id AS id_104, t103.date_add AS date_add_105, t103.date_upd AS date_upd_106, t103.is_deleted AS is_deleted_107, t103.is_locked AS is_locked_108, t103.is_draft AS is_draft_109, t103.can_be_deleted AS can_be_deleted_110, t103.deleted_at AS deleted_at_111, t103.owner_organization_id AS owner_organization_id_112, t103.companies_ids AS companies_ids_113, t103.latitude AS latitude_114, t103.longitude AS longitude_115, t103.deleted_by_id AS deleted_by_id_116, t103.author_id AS author_id_117, t103.state_id AS state_id_118, t0.loyalty_program_id AS loyalty_program_id_119, t120.id AS id_121, t120.date_add AS date_add_122, t120.date_upd AS date_upd_123, t120.is_deleted AS is_deleted_124, t120.is_locked AS is_locked_125, t120.is_draft AS is_draft_126, t120.can_be_deleted AS can_be_deleted_127, t120.deleted_at AS deleted_at_128, t120.owner_organization_id AS owner_organization_id_129, t120.companies_ids AS companies_ids_130, t120.points AS points_131, t120.threshold AS threshold_132, t120.value AS value_133, t120.deleted_by_id AS deleted_by_id_134, t120.author_id AS author_id_135, t120.organization_id AS organization_id_136, t120.service_id AS service_id_137 FROM app_business_service t0 LEFT JOIN app_core_user_actor t22 ON t0.deleted_by_id = t22.id LEFT JOIN app_core_user_actor t42 ON t0.author_id = t42.id LEFT JOIN app_core_user_organization t62 ON t0.organization_id = t62.id LEFT JOIN app_core_location_state t87 ON t0.state_id = t87.id LEFT JOIN app_core_location_neighborhood t103 ON t0.neighborhood_id = t103.id LEFT JOIN app_business_loyalty t120 ON t0.loyalty_program_id = t120.id WHERE t0.loyalty_program_id IN (27);
3.63 ms (6.90%)	4	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: [`19`] View formatted query View runnable query Explain query 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 = ? 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 = 19;
3.39 ms (6.43%)	2	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: [`19`] View formatted query View runnable query Explain query 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 (?) 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 (19);
3.20 ms (6.08%)	2	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.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_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.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 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 t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.id IN (?) Parameters: [`16`] View formatted query View runnable query Explain query 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.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_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.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 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 t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.id IN (?) 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.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_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.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 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 t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.id IN (16);
3.12 ms (5.93%)	4	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 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: [`30`] View formatted query View runnable query Explain query 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 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 (?) 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 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 (30);
3.00 ms (5.69%)	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.matricule AS matricule_11, t0.position AS position_12, t0.is_blocked AS is_blocked_13, t0.deleted_by_id AS deleted_by_id_14, t15.id AS id_16, t15.date_add AS date_add_17, t15.date_upd AS date_upd_18, t15.is_deleted AS is_deleted_19, t15.is_locked AS is_locked_20, t15.is_draft AS is_draft_21, t15.can_be_deleted AS can_be_deleted_22, t15.deleted_at AS deleted_at_23, t15.owner_organization_id AS owner_organization_id_24, t15.companies_ids AS companies_ids_25, t15.lastname AS lastname_26, t15.firstname AS firstname_27, t15.birth_place AS birth_place_28, t15.birth_date AS birth_date_29, t15.gender AS gender_30, t15.deleted_by_id AS deleted_by_id_31, t15.author_id AS author_id_32, t15.access_id AS access_id_33, t0.author_id AS author_id_34, t35.id AS id_36, t35.date_add AS date_add_37, t35.date_upd AS date_upd_38, t35.is_deleted AS is_deleted_39, t35.is_locked AS is_locked_40, t35.is_draft AS is_draft_41, t35.can_be_deleted AS can_be_deleted_42, t35.deleted_at AS deleted_at_43, t35.owner_organization_id AS owner_organization_id_44, t35.companies_ids AS companies_ids_45, t35.lastname AS lastname_46, t35.firstname AS firstname_47, t35.birth_place AS birth_place_48, t35.birth_date AS birth_date_49, t35.gender AS gender_50, t35.deleted_by_id AS deleted_by_id_51, t35.author_id AS author_id_52, t35.access_id AS access_id_53, t0.actor_id AS actor_id_54, t55.id AS id_56, t55.date_add AS date_add_57, t55.date_upd AS date_upd_58, t55.is_deleted AS is_deleted_59, t55.is_locked AS is_locked_60, t55.is_draft AS is_draft_61, t55.can_be_deleted AS can_be_deleted_62, t55.deleted_at AS deleted_at_63, t55.owner_organization_id AS owner_organization_id_64, t55.companies_ids AS companies_ids_65, t55.lastname AS lastname_66, t55.firstname AS firstname_67, t55.birth_place AS birth_place_68, t55.birth_date AS birth_date_69, t55.gender AS gender_70, t55.deleted_by_id AS deleted_by_id_71, t55.author_id AS author_id_72, t55.access_id AS access_id_73, t0.contact_id AS contact_id_74, t75.id AS id_76, t75.date_add AS date_add_77, t75.date_upd AS date_upd_78, t75.is_deleted AS is_deleted_79, t75.is_locked AS is_locked_80, t75.is_draft AS is_draft_81, t75.can_be_deleted AS can_be_deleted_82, t75.deleted_at AS deleted_at_83, t75.owner_organization_id AS owner_organization_id_84, t75.companies_ids AS companies_ids_85, t75.calling_code AS calling_code_86, t75.phone AS phone_87, t75.email AS email_88, t75.web_site AS web_site_89, t75.address AS address_90, t75.city AS city_91, t75.latitude AS latitude_92, t75.longitude AS longitude_93, t75.deleted_by_id AS deleted_by_id_94, t75.author_id AS author_id_95, t75.state_id AS state_id_96, t0.organization_id AS organization_id_97, t98.id AS id_99, t98.date_add AS date_add_100, t98.date_upd AS date_upd_101, t98.is_deleted AS is_deleted_102, t98.is_locked AS is_locked_103, t98.is_draft AS is_draft_104, t98.can_be_deleted AS can_be_deleted_105, t98.deleted_at AS deleted_at_106, t98.owner_organization_id AS owner_organization_id_107, t98.companies_ids AS companies_ids_108, t98.name AS name_109, t98.opening_hours AS opening_hours_110, t98.closing_hours AS closing_hours_111, t98.is_plateform_manager AS is_plateform_manager_112, t98.thumbnail_id AS thumbnail_id_113, t98.latitude AS latitude_114, t98.longitude AS longitude_115, t98.cover_image_id AS cover_image_id_116, t98.opening_days AS opening_days_117, t98.deleted_by_id AS deleted_by_id_118, t98.author_id AS author_id_119, t98.actor_id AS actor_id_120, t98.contact_id AS contact_id_121, t0.type_id AS type_id_122, t123.id AS id_124, t123.date_add AS date_add_125, t123.date_upd AS date_upd_126, t123.is_deleted AS is_deleted_127, t123.is_locked AS is_locked_128, t123.is_draft AS is_draft_129, t123.can_be_deleted AS can_be_deleted_130, t123.deleted_at AS deleted_at_131, t123.owner_organization_id AS owner_organization_id_132, t123.companies_ids AS companies_ids_133, t123.deleted_by_id AS deleted_by_id_134, t123.author_id AS author_id_135 FROM app_core_user_collaborator t0 LEFT JOIN app_core_user_actor t15 ON t0.deleted_by_id = t15.id LEFT JOIN app_core_user_actor t35 ON t0.author_id = t35.id LEFT JOIN app_core_user_actor t55 ON t0.actor_id = t55.id LEFT JOIN app_core_location_contact t75 ON t0.contact_id = t75.id INNER JOIN app_core_user_organization t98 ON t0.organization_id = t98.id LEFT JOIN app_business_type t123 ON t0.type_id = t123.id WHERE t0.actor_id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.matricule AS matricule_11, t0.position AS position_12, t0.is_blocked AS is_blocked_13, t0.deleted_by_id AS deleted_by_id_14, t15.id AS id_16, t15.date_add AS date_add_17, t15.date_upd AS date_upd_18, t15.is_deleted AS is_deleted_19, t15.is_locked AS is_locked_20, t15.is_draft AS is_draft_21, t15.can_be_deleted AS can_be_deleted_22, t15.deleted_at AS deleted_at_23, t15.owner_organization_id AS owner_organization_id_24, t15.companies_ids AS companies_ids_25, t15.lastname AS lastname_26, t15.firstname AS firstname_27, t15.birth_place AS birth_place_28, t15.birth_date AS birth_date_29, t15.gender AS gender_30, t15.deleted_by_id AS deleted_by_id_31, t15.author_id AS author_id_32, t15.access_id AS access_id_33, t0.author_id AS author_id_34, t35.id AS id_36, t35.date_add AS date_add_37, t35.date_upd AS date_upd_38, t35.is_deleted AS is_deleted_39, t35.is_locked AS is_locked_40, t35.is_draft AS is_draft_41, t35.can_be_deleted AS can_be_deleted_42, t35.deleted_at AS deleted_at_43, t35.owner_organization_id AS owner_organization_id_44, t35.companies_ids AS companies_ids_45, t35.lastname AS lastname_46, t35.firstname AS firstname_47, t35.birth_place AS birth_place_48, t35.birth_date AS birth_date_49, t35.gender AS gender_50, t35.deleted_by_id AS deleted_by_id_51, t35.author_id AS author_id_52, t35.access_id AS access_id_53, t0.actor_id AS actor_id_54, t55.id AS id_56, t55.date_add AS date_add_57, t55.date_upd AS date_upd_58, t55.is_deleted AS is_deleted_59, t55.is_locked AS is_locked_60, t55.is_draft AS is_draft_61, t55.can_be_deleted AS can_be_deleted_62, t55.deleted_at AS deleted_at_63, t55.owner_organization_id AS owner_organization_id_64, t55.companies_ids AS companies_ids_65, t55.lastname AS lastname_66, t55.firstname AS firstname_67, t55.birth_place AS birth_place_68, t55.birth_date AS birth_date_69, t55.gender AS gender_70, t55.deleted_by_id AS deleted_by_id_71, t55.author_id AS author_id_72, t55.access_id AS access_id_73, t0.contact_id AS contact_id_74, t75.id AS id_76, t75.date_add AS date_add_77, t75.date_upd AS date_upd_78, t75.is_deleted AS is_deleted_79, t75.is_locked AS is_locked_80, t75.is_draft AS is_draft_81, t75.can_be_deleted AS can_be_deleted_82, t75.deleted_at AS deleted_at_83, t75.owner_organization_id AS owner_organization_id_84, t75.companies_ids AS companies_ids_85, t75.calling_code AS calling_code_86, t75.phone AS phone_87, t75.email AS email_88, t75.web_site AS web_site_89, t75.address AS address_90, t75.city AS city_91, t75.latitude AS latitude_92, t75.longitude AS longitude_93, t75.deleted_by_id AS deleted_by_id_94, t75.author_id AS author_id_95, t75.state_id AS state_id_96, t0.organization_id AS organization_id_97, t98.id AS id_99, t98.date_add AS date_add_100, t98.date_upd AS date_upd_101, t98.is_deleted AS is_deleted_102, t98.is_locked AS is_locked_103, t98.is_draft AS is_draft_104, t98.can_be_deleted AS can_be_deleted_105, t98.deleted_at AS deleted_at_106, t98.owner_organization_id AS owner_organization_id_107, t98.companies_ids AS companies_ids_108, t98.name AS name_109, t98.opening_hours AS opening_hours_110, t98.closing_hours AS closing_hours_111, t98.is_plateform_manager AS is_plateform_manager_112, t98.thumbnail_id AS thumbnail_id_113, t98.latitude AS latitude_114, t98.longitude AS longitude_115, t98.cover_image_id AS cover_image_id_116, t98.opening_days AS opening_days_117, t98.deleted_by_id AS deleted_by_id_118, t98.author_id AS author_id_119, t98.actor_id AS actor_id_120, t98.contact_id AS contact_id_121, t0.type_id AS type_id_122, t123.id AS id_124, t123.date_add AS date_add_125, t123.date_upd AS date_upd_126, t123.is_deleted AS is_deleted_127, t123.is_locked AS is_locked_128, t123.is_draft AS is_draft_129, t123.can_be_deleted AS can_be_deleted_130, t123.deleted_at AS deleted_at_131, t123.owner_organization_id AS owner_organization_id_132, t123.companies_ids AS companies_ids_133, t123.deleted_by_id AS deleted_by_id_134, t123.author_id AS author_id_135 FROM app_core_user_collaborator t0 LEFT JOIN app_core_user_actor t15 ON t0.deleted_by_id = t15.id LEFT JOIN app_core_user_actor t35 ON t0.author_id = t35.id LEFT JOIN app_core_user_actor t55 ON t0.actor_id = t55.id LEFT JOIN app_core_location_contact t75 ON t0.contact_id = t75.id INNER JOIN app_core_user_organization t98 ON t0.organization_id = t98.id LEFT JOIN app_business_type t123 ON t0.type_id = t123.id WHERE t0.actor_id = ? 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.matricule AS matricule_11, t0.position AS position_12, t0.is_blocked AS is_blocked_13, t0.deleted_by_id AS deleted_by_id_14, t15.id AS id_16, t15.date_add AS date_add_17, t15.date_upd AS date_upd_18, t15.is_deleted AS is_deleted_19, t15.is_locked AS is_locked_20, t15.is_draft AS is_draft_21, t15.can_be_deleted AS can_be_deleted_22, t15.deleted_at AS deleted_at_23, t15.owner_organization_id AS owner_organization_id_24, t15.companies_ids AS companies_ids_25, t15.lastname AS lastname_26, t15.firstname AS firstname_27, t15.birth_place AS birth_place_28, t15.birth_date AS birth_date_29, t15.gender AS gender_30, t15.deleted_by_id AS deleted_by_id_31, t15.author_id AS author_id_32, t15.access_id AS access_id_33, t0.author_id AS author_id_34, t35.id AS id_36, t35.date_add AS date_add_37, t35.date_upd AS date_upd_38, t35.is_deleted AS is_deleted_39, t35.is_locked AS is_locked_40, t35.is_draft AS is_draft_41, t35.can_be_deleted AS can_be_deleted_42, t35.deleted_at AS deleted_at_43, t35.owner_organization_id AS owner_organization_id_44, t35.companies_ids AS companies_ids_45, t35.lastname AS lastname_46, t35.firstname AS firstname_47, t35.birth_place AS birth_place_48, t35.birth_date AS birth_date_49, t35.gender AS gender_50, t35.deleted_by_id AS deleted_by_id_51, t35.author_id AS author_id_52, t35.access_id AS access_id_53, t0.actor_id AS actor_id_54, t55.id AS id_56, t55.date_add AS date_add_57, t55.date_upd AS date_upd_58, t55.is_deleted AS is_deleted_59, t55.is_locked AS is_locked_60, t55.is_draft AS is_draft_61, t55.can_be_deleted AS can_be_deleted_62, t55.deleted_at AS deleted_at_63, t55.owner_organization_id AS owner_organization_id_64, t55.companies_ids AS companies_ids_65, t55.lastname AS lastname_66, t55.firstname AS firstname_67, t55.birth_place AS birth_place_68, t55.birth_date AS birth_date_69, t55.gender AS gender_70, t55.deleted_by_id AS deleted_by_id_71, t55.author_id AS author_id_72, t55.access_id AS access_id_73, t0.contact_id AS contact_id_74, t75.id AS id_76, t75.date_add AS date_add_77, t75.date_upd AS date_upd_78, t75.is_deleted AS is_deleted_79, t75.is_locked AS is_locked_80, t75.is_draft AS is_draft_81, t75.can_be_deleted AS can_be_deleted_82, t75.deleted_at AS deleted_at_83, t75.owner_organization_id AS owner_organization_id_84, t75.companies_ids AS companies_ids_85, t75.calling_code AS calling_code_86, t75.phone AS phone_87, t75.email AS email_88, t75.web_site AS web_site_89, t75.address AS address_90, t75.city AS city_91, t75.latitude AS latitude_92, t75.longitude AS longitude_93, t75.deleted_by_id AS deleted_by_id_94, t75.author_id AS author_id_95, t75.state_id AS state_id_96, t0.organization_id AS organization_id_97, t98.id AS id_99, t98.date_add AS date_add_100, t98.date_upd AS date_upd_101, t98.is_deleted AS is_deleted_102, t98.is_locked AS is_locked_103, t98.is_draft AS is_draft_104, t98.can_be_deleted AS can_be_deleted_105, t98.deleted_at AS deleted_at_106, t98.owner_organization_id AS owner_organization_id_107, t98.companies_ids AS companies_ids_108, t98.name AS name_109, t98.opening_hours AS opening_hours_110, t98.closing_hours AS closing_hours_111, t98.is_plateform_manager AS is_plateform_manager_112, t98.thumbnail_id AS thumbnail_id_113, t98.latitude AS latitude_114, t98.longitude AS longitude_115, t98.cover_image_id AS cover_image_id_116, t98.opening_days AS opening_days_117, t98.deleted_by_id AS deleted_by_id_118, t98.author_id AS author_id_119, t98.actor_id AS actor_id_120, t98.contact_id AS contact_id_121, t0.type_id AS type_id_122, t123.id AS id_124, t123.date_add AS date_add_125, t123.date_upd AS date_upd_126, t123.is_deleted AS is_deleted_127, t123.is_locked AS is_locked_128, t123.is_draft AS is_draft_129, t123.can_be_deleted AS can_be_deleted_130, t123.deleted_at AS deleted_at_131, t123.owner_organization_id AS owner_organization_id_132, t123.companies_ids AS companies_ids_133, t123.deleted_by_id AS deleted_by_id_134, t123.author_id AS author_id_135 FROM app_core_user_collaborator t0 LEFT JOIN app_core_user_actor t15 ON t0.deleted_by_id = t15.id LEFT JOIN app_core_user_actor t35 ON t0.author_id = t35.id LEFT JOIN app_core_user_actor t55 ON t0.actor_id = t55.id LEFT JOIN app_core_location_contact t75 ON t0.contact_id = t75.id INNER JOIN app_core_user_organization t98 ON t0.organization_id = t98.id LEFT JOIN app_business_type t123 ON t0.type_id = t123.id WHERE t0.actor_id = 1;
2.05 ms (3.89%)	2	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.description AS description_12, t0.is_default AS is_default_13, t0.code AS code_14, t0.deleted_by_id AS deleted_by_id_15, t16.id AS id_17, t16.date_add AS date_add_18, t16.date_upd AS date_upd_19, t16.is_deleted AS is_deleted_20, t16.is_locked AS is_locked_21, t16.is_draft AS is_draft_22, t16.can_be_deleted AS can_be_deleted_23, t16.deleted_at AS deleted_at_24, t16.owner_organization_id AS owner_organization_id_25, t16.companies_ids AS companies_ids_26, t16.lastname AS lastname_27, t16.firstname AS firstname_28, t16.birth_place AS birth_place_29, t16.birth_date AS birth_date_30, t16.gender AS gender_31, t16.deleted_by_id AS deleted_by_id_32, t16.author_id AS author_id_33, t16.access_id AS access_id_34, t0.author_id AS author_id_35, t36.id AS id_37, t36.date_add AS date_add_38, t36.date_upd AS date_upd_39, t36.is_deleted AS is_deleted_40, t36.is_locked AS is_locked_41, t36.is_draft AS is_draft_42, t36.can_be_deleted AS can_be_deleted_43, t36.deleted_at AS deleted_at_44, t36.owner_organization_id AS owner_organization_id_45, t36.companies_ids AS companies_ids_46, t36.lastname AS lastname_47, t36.firstname AS firstname_48, t36.birth_place AS birth_place_49, t36.birth_date AS birth_date_50, t36.gender AS gender_51, t36.deleted_by_id AS deleted_by_id_52, t36.author_id AS author_id_53, t36.access_id AS access_id_54, t0.organization_id AS organization_id_55, t56.id AS id_57, t56.date_add AS date_add_58, t56.date_upd AS date_upd_59, t56.is_deleted AS is_deleted_60, t56.is_locked AS is_locked_61, t56.is_draft AS is_draft_62, t56.can_be_deleted AS can_be_deleted_63, t56.deleted_at AS deleted_at_64, t56.owner_organization_id AS owner_organization_id_65, t56.companies_ids AS companies_ids_66, t56.name AS name_67, t56.opening_hours AS opening_hours_68, t56.closing_hours AS closing_hours_69, t56.is_plateform_manager AS is_plateform_manager_70, t56.thumbnail_id AS thumbnail_id_71, t56.latitude AS latitude_72, t56.longitude AS longitude_73, t56.cover_image_id AS cover_image_id_74, t56.opening_days AS opening_days_75, t56.deleted_by_id AS deleted_by_id_76, t56.author_id AS author_id_77, t56.actor_id AS actor_id_78, t56.contact_id AS contact_id_79 FROM app_business_all_role t0 LEFT JOIN app_core_user_actor t16 ON t0.deleted_by_id = t16.id LEFT JOIN app_core_user_actor t36 ON t0.author_id = t36.id INNER JOIN app_core_user_organization t56 ON t0.organization_id = t56.id INNER JOIN app_business_member_role ON t0.id = app_business_member_role.role_id WHERE app_business_member_role.member_id = ? Parameters: [`15`] View formatted query View runnable query Explain query 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.description AS description_12, t0.is_default AS is_default_13, t0.code AS code_14, t0.deleted_by_id AS deleted_by_id_15, t16.id AS id_17, t16.date_add AS date_add_18, t16.date_upd AS date_upd_19, t16.is_deleted AS is_deleted_20, t16.is_locked AS is_locked_21, t16.is_draft AS is_draft_22, t16.can_be_deleted AS can_be_deleted_23, t16.deleted_at AS deleted_at_24, t16.owner_organization_id AS owner_organization_id_25, t16.companies_ids AS companies_ids_26, t16.lastname AS lastname_27, t16.firstname AS firstname_28, t16.birth_place AS birth_place_29, t16.birth_date AS birth_date_30, t16.gender AS gender_31, t16.deleted_by_id AS deleted_by_id_32, t16.author_id AS author_id_33, t16.access_id AS access_id_34, t0.author_id AS author_id_35, t36.id AS id_37, t36.date_add AS date_add_38, t36.date_upd AS date_upd_39, t36.is_deleted AS is_deleted_40, t36.is_locked AS is_locked_41, t36.is_draft AS is_draft_42, t36.can_be_deleted AS can_be_deleted_43, t36.deleted_at AS deleted_at_44, t36.owner_organization_id AS owner_organization_id_45, t36.companies_ids AS companies_ids_46, t36.lastname AS lastname_47, t36.firstname AS firstname_48, t36.birth_place AS birth_place_49, t36.birth_date AS birth_date_50, t36.gender AS gender_51, t36.deleted_by_id AS deleted_by_id_52, t36.author_id AS author_id_53, t36.access_id AS access_id_54, t0.organization_id AS organization_id_55, t56.id AS id_57, t56.date_add AS date_add_58, t56.date_upd AS date_upd_59, t56.is_deleted AS is_deleted_60, t56.is_locked AS is_locked_61, t56.is_draft AS is_draft_62, t56.can_be_deleted AS can_be_deleted_63, t56.deleted_at AS deleted_at_64, t56.owner_organization_id AS owner_organization_id_65, t56.companies_ids AS companies_ids_66, t56.name AS name_67, t56.opening_hours AS opening_hours_68, t56.closing_hours AS closing_hours_69, t56.is_plateform_manager AS is_plateform_manager_70, t56.thumbnail_id AS thumbnail_id_71, t56.latitude AS latitude_72, t56.longitude AS longitude_73, t56.cover_image_id AS cover_image_id_74, t56.opening_days AS opening_days_75, t56.deleted_by_id AS deleted_by_id_76, t56.author_id AS author_id_77, t56.actor_id AS actor_id_78, t56.contact_id AS contact_id_79 FROM app_business_all_role t0 LEFT JOIN app_core_user_actor t16 ON t0.deleted_by_id = t16.id LEFT JOIN app_core_user_actor t36 ON t0.author_id = t36.id INNER JOIN app_core_user_organization t56 ON t0.organization_id = t56.id INNER JOIN app_business_member_role ON t0.id = app_business_member_role.role_id WHERE app_business_member_role.member_id = ? 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.description AS description_12, t0.is_default AS is_default_13, t0.code AS code_14, t0.deleted_by_id AS deleted_by_id_15, t16.id AS id_17, t16.date_add AS date_add_18, t16.date_upd AS date_upd_19, t16.is_deleted AS is_deleted_20, t16.is_locked AS is_locked_21, t16.is_draft AS is_draft_22, t16.can_be_deleted AS can_be_deleted_23, t16.deleted_at AS deleted_at_24, t16.owner_organization_id AS owner_organization_id_25, t16.companies_ids AS companies_ids_26, t16.lastname AS lastname_27, t16.firstname AS firstname_28, t16.birth_place AS birth_place_29, t16.birth_date AS birth_date_30, t16.gender AS gender_31, t16.deleted_by_id AS deleted_by_id_32, t16.author_id AS author_id_33, t16.access_id AS access_id_34, t0.author_id AS author_id_35, t36.id AS id_37, t36.date_add AS date_add_38, t36.date_upd AS date_upd_39, t36.is_deleted AS is_deleted_40, t36.is_locked AS is_locked_41, t36.is_draft AS is_draft_42, t36.can_be_deleted AS can_be_deleted_43, t36.deleted_at AS deleted_at_44, t36.owner_organization_id AS owner_organization_id_45, t36.companies_ids AS companies_ids_46, t36.lastname AS lastname_47, t36.firstname AS firstname_48, t36.birth_place AS birth_place_49, t36.birth_date AS birth_date_50, t36.gender AS gender_51, t36.deleted_by_id AS deleted_by_id_52, t36.author_id AS author_id_53, t36.access_id AS access_id_54, t0.organization_id AS organization_id_55, t56.id AS id_57, t56.date_add AS date_add_58, t56.date_upd AS date_upd_59, t56.is_deleted AS is_deleted_60, t56.is_locked AS is_locked_61, t56.is_draft AS is_draft_62, t56.can_be_deleted AS can_be_deleted_63, t56.deleted_at AS deleted_at_64, t56.owner_organization_id AS owner_organization_id_65, t56.companies_ids AS companies_ids_66, t56.name AS name_67, t56.opening_hours AS opening_hours_68, t56.closing_hours AS closing_hours_69, t56.is_plateform_manager AS is_plateform_manager_70, t56.thumbnail_id AS thumbnail_id_71, t56.latitude AS latitude_72, t56.longitude AS longitude_73, t56.cover_image_id AS cover_image_id_74, t56.opening_days AS opening_days_75, t56.deleted_by_id AS deleted_by_id_76, t56.author_id AS author_id_77, t56.actor_id AS actor_id_78, t56.contact_id AS contact_id_79 FROM app_business_all_role t0 LEFT JOIN app_core_user_actor t16 ON t0.deleted_by_id = t16.id LEFT JOIN app_core_user_actor t36 ON t0.author_id = t36.id INNER JOIN app_core_user_organization t56 ON t0.organization_id = t56.id INNER JOIN app_business_member_role ON t0.id = app_business_member_role.role_id WHERE app_business_member_role.member_id = 15;
1.85 ms (3.51%)	2	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_business_service_attachment ON t0.id = app_business_service_attachment.service_attachment_id WHERE app_business_service_attachment.service_id = ? Parameters: [`40`] View formatted query View runnable query Explain query 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_business_service_attachment ON t0.id = app_business_service_attachment.service_attachment_id WHERE app_business_service_attachment.service_id = ? 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_business_service_attachment ON t0.id = app_business_service_attachment.service_attachment_id WHERE app_business_service_attachment.service_id = 40;
1.62 ms (3.08%)	2	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.calling_code AS calling_code_11, t0.phone AS phone_12, t0.email AS email_13, t0.web_site AS web_site_14, t0.address AS address_15, t0.city AS city_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.deleted_by_id AS deleted_by_id_19, t20.id AS id_21, t20.date_add AS date_add_22, t20.date_upd AS date_upd_23, t20.is_deleted AS is_deleted_24, t20.is_locked AS is_locked_25, t20.is_draft AS is_draft_26, t20.can_be_deleted AS can_be_deleted_27, t20.deleted_at AS deleted_at_28, t20.owner_organization_id AS owner_organization_id_29, t20.companies_ids AS companies_ids_30, t20.lastname AS lastname_31, t20.firstname AS firstname_32, t20.birth_place AS birth_place_33, t20.birth_date AS birth_date_34, t20.gender AS gender_35, t20.deleted_by_id AS deleted_by_id_36, t20.author_id AS author_id_37, t20.access_id AS access_id_38, t0.author_id AS author_id_39, t40.id AS id_41, t40.date_add AS date_add_42, t40.date_upd AS date_upd_43, t40.is_deleted AS is_deleted_44, t40.is_locked AS is_locked_45, t40.is_draft AS is_draft_46, t40.can_be_deleted AS can_be_deleted_47, t40.deleted_at AS deleted_at_48, t40.owner_organization_id AS owner_organization_id_49, t40.companies_ids AS companies_ids_50, t40.lastname AS lastname_51, t40.firstname AS firstname_52, t40.birth_place AS birth_place_53, t40.birth_date AS birth_date_54, t40.gender AS gender_55, t40.deleted_by_id AS deleted_by_id_56, t40.author_id AS author_id_57, t40.access_id AS access_id_58, t0.state_id AS state_id_59, t60.id AS id_61, t60.date_add AS date_add_62, t60.date_upd AS date_upd_63, t60.is_deleted AS is_deleted_64, t60.is_locked AS is_locked_65, t60.is_draft AS is_draft_66, t60.can_be_deleted AS can_be_deleted_67, t60.deleted_at AS deleted_at_68, t60.owner_organization_id AS owner_organization_id_69, t60.companies_ids AS companies_ids_70, t60.code AS code_71, t60.deleted_by_id AS deleted_by_id_72, t60.author_id AS author_id_73, t60.country_id AS country_id_74 FROM app_core_location_contact t0 LEFT JOIN app_core_user_actor t20 ON t0.deleted_by_id = t20.id LEFT JOIN app_core_user_actor t40 ON t0.author_id = t40.id LEFT JOIN app_core_location_state t60 ON t0.state_id = t60.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query 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.calling_code AS calling_code_11, t0.phone AS phone_12, t0.email AS email_13, t0.web_site AS web_site_14, t0.address AS address_15, t0.city AS city_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.deleted_by_id AS deleted_by_id_19, t20.id AS id_21, t20.date_add AS date_add_22, t20.date_upd AS date_upd_23, t20.is_deleted AS is_deleted_24, t20.is_locked AS is_locked_25, t20.is_draft AS is_draft_26, t20.can_be_deleted AS can_be_deleted_27, t20.deleted_at AS deleted_at_28, t20.owner_organization_id AS owner_organization_id_29, t20.companies_ids AS companies_ids_30, t20.lastname AS lastname_31, t20.firstname AS firstname_32, t20.birth_place AS birth_place_33, t20.birth_date AS birth_date_34, t20.gender AS gender_35, t20.deleted_by_id AS deleted_by_id_36, t20.author_id AS author_id_37, t20.access_id AS access_id_38, t0.author_id AS author_id_39, t40.id AS id_41, t40.date_add AS date_add_42, t40.date_upd AS date_upd_43, t40.is_deleted AS is_deleted_44, t40.is_locked AS is_locked_45, t40.is_draft AS is_draft_46, t40.can_be_deleted AS can_be_deleted_47, t40.deleted_at AS deleted_at_48, t40.owner_organization_id AS owner_organization_id_49, t40.companies_ids AS companies_ids_50, t40.lastname AS lastname_51, t40.firstname AS firstname_52, t40.birth_place AS birth_place_53, t40.birth_date AS birth_date_54, t40.gender AS gender_55, t40.deleted_by_id AS deleted_by_id_56, t40.author_id AS author_id_57, t40.access_id AS access_id_58, t0.state_id AS state_id_59, t60.id AS id_61, t60.date_add AS date_add_62, t60.date_upd AS date_upd_63, t60.is_deleted AS is_deleted_64, t60.is_locked AS is_locked_65, t60.is_draft AS is_draft_66, t60.can_be_deleted AS can_be_deleted_67, t60.deleted_at AS deleted_at_68, t60.owner_organization_id AS owner_organization_id_69, t60.companies_ids AS companies_ids_70, t60.code AS code_71, t60.deleted_by_id AS deleted_by_id_72, t60.author_id AS author_id_73, t60.country_id AS country_id_74 FROM app_core_location_contact t0 LEFT JOIN app_core_user_actor t20 ON t0.deleted_by_id = t20.id LEFT JOIN app_core_user_actor t40 ON t0.author_id = t40.id LEFT JOIN app_core_location_state t60 ON t0.state_id = t60.id WHERE t0.id IN (?) 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.calling_code AS calling_code_11, t0.phone AS phone_12, t0.email AS email_13, t0.web_site AS web_site_14, t0.address AS address_15, t0.city AS city_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.deleted_by_id AS deleted_by_id_19, t20.id AS id_21, t20.date_add AS date_add_22, t20.date_upd AS date_upd_23, t20.is_deleted AS is_deleted_24, t20.is_locked AS is_locked_25, t20.is_draft AS is_draft_26, t20.can_be_deleted AS can_be_deleted_27, t20.deleted_at AS deleted_at_28, t20.owner_organization_id AS owner_organization_id_29, t20.companies_ids AS companies_ids_30, t20.lastname AS lastname_31, t20.firstname AS firstname_32, t20.birth_place AS birth_place_33, t20.birth_date AS birth_date_34, t20.gender AS gender_35, t20.deleted_by_id AS deleted_by_id_36, t20.author_id AS author_id_37, t20.access_id AS access_id_38, t0.author_id AS author_id_39, t40.id AS id_41, t40.date_add AS date_add_42, t40.date_upd AS date_upd_43, t40.is_deleted AS is_deleted_44, t40.is_locked AS is_locked_45, t40.is_draft AS is_draft_46, t40.can_be_deleted AS can_be_deleted_47, t40.deleted_at AS deleted_at_48, t40.owner_organization_id AS owner_organization_id_49, t40.companies_ids AS companies_ids_50, t40.lastname AS lastname_51, t40.firstname AS firstname_52, t40.birth_place AS birth_place_53, t40.birth_date AS birth_date_54, t40.gender AS gender_55, t40.deleted_by_id AS deleted_by_id_56, t40.author_id AS author_id_57, t40.access_id AS access_id_58, t0.state_id AS state_id_59, t60.id AS id_61, t60.date_add AS date_add_62, t60.date_upd AS date_upd_63, t60.is_deleted AS is_deleted_64, t60.is_locked AS is_locked_65, t60.is_draft AS is_draft_66, t60.can_be_deleted AS can_be_deleted_67, t60.deleted_at AS deleted_at_68, t60.owner_organization_id AS owner_organization_id_69, t60.companies_ids AS companies_ids_70, t60.code AS code_71, t60.deleted_by_id AS deleted_by_id_72, t60.author_id AS author_id_73, t60.country_id AS country_id_74 FROM app_core_location_contact t0 LEFT JOIN app_core_user_actor t20 ON t0.deleted_by_id = t20.id LEFT JOIN app_core_user_actor t40 ON t0.author_id = t40.id LEFT JOIN app_core_location_state t60 ON t0.state_id = t60.id WHERE t0.id IN (1);
1.62 ms (3.07%)	2	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 FROM app_business_type 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_business_service_types ON t0.id = app_business_service_types.type_id WHERE app_business_service_types.services_id = ? Parameters: [`40`] View formatted query View runnable query Explain query 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 FROM app_business_type 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_business_service_types ON t0.id = app_business_service_types.type_id WHERE app_business_service_types.services_id = ? 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 FROM app_business_type 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_business_service_types ON t0.id = app_business_service_types.type_id WHERE app_business_service_types.services_id = 40;
1.57 ms (2.98%)	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_.deleted_by_id AS deleted_by_id_21, a0_.author_id AS author_id_22 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = true Parameters: [`"pb@mk-wbc.com"`] View formatted query View runnable query Explain query 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_.deleted_by_id AS deleted_by_id_21, a0_.author_id AS author_id_22 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = true 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_.deleted_by_id AS deleted_by_id_21, a0_.author_id AS author_id_22 FROM app_core_user_access a0_ WHERE a0_.email = 'pb@mk-wbc.com' AND a0_.is_active = true;
1.47 ms (2.79%)	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, a1_.id AS id_10, a1_.date_add AS date_add_11, a1_.date_upd AS date_upd_12, a1_.is_deleted AS is_deleted_13, a1_.is_locked AS is_locked_14, a1_.is_draft AS is_draft_15, a1_.can_be_deleted AS can_be_deleted_16, a1_.deleted_at AS deleted_at_17, a1_.owner_organization_id AS owner_organization_id_18, a1_.companies_ids AS companies_ids_19, a1_.name AS name_20, a1_.description AS description_21, a1_.is_default AS is_default_22, a1_.code AS code_23, a2_.id AS id_24, a2_.date_add AS date_add_25, a2_.date_upd AS date_upd_26, a2_.is_deleted AS is_deleted_27, a2_.is_locked AS is_locked_28, a2_.is_draft AS is_draft_29, a2_.can_be_deleted AS can_be_deleted_30, a2_.deleted_at AS deleted_at_31, a2_.owner_organization_id AS owner_organization_id_32, a2_.companies_ids AS companies_ids_33, a2_.key_rule AS key_rule_34, a2_.key_group AS key_group_35, a0_.deleted_by_id AS deleted_by_id_36, a0_.author_id AS author_id_37, a0_.collaborator_id AS collaborator_id_38, a1_.deleted_by_id AS deleted_by_id_39, a1_.author_id AS author_id_40, a1_.organization_id AS organization_id_41, a2_.deleted_by_id AS deleted_by_id_42, a2_.author_id AS author_id_43, a2_.role_id AS role_id_44 FROM app_business_all_member a0_ INNER JOIN app_business_member_role a3_ ON a0_.id = a3_.member_id INNER JOIN app_business_all_role a1_ ON a1_.id = a3_.role_id LEFT JOIN app_business_roles_authorization a2_ ON a1_.id = a2_.role_id WHERE a0_.collaborator_id = ? Parameters: [`30`] View formatted query View runnable query Explain query 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, a1_.id AS id_10, a1_.date_add AS date_add_11, a1_.date_upd AS date_upd_12, a1_.is_deleted AS is_deleted_13, a1_.is_locked AS is_locked_14, a1_.is_draft AS is_draft_15, a1_.can_be_deleted AS can_be_deleted_16, a1_.deleted_at AS deleted_at_17, a1_.owner_organization_id AS owner_organization_id_18, a1_.companies_ids AS companies_ids_19, a1_.name AS name_20, a1_.description AS description_21, a1_.is_default AS is_default_22, a1_.code AS code_23, a2_.id AS id_24, a2_.date_add AS date_add_25, a2_.date_upd AS date_upd_26, a2_.is_deleted AS is_deleted_27, a2_.is_locked AS is_locked_28, a2_.is_draft AS is_draft_29, a2_.can_be_deleted AS can_be_deleted_30, a2_.deleted_at AS deleted_at_31, a2_.owner_organization_id AS owner_organization_id_32, a2_.companies_ids AS companies_ids_33, a2_.key_rule AS key_rule_34, a2_.key_group AS key_group_35, a0_.deleted_by_id AS deleted_by_id_36, a0_.author_id AS author_id_37, a0_.collaborator_id AS collaborator_id_38, a1_.deleted_by_id AS deleted_by_id_39, a1_.author_id AS author_id_40, a1_.organization_id AS organization_id_41, a2_.deleted_by_id AS deleted_by_id_42, a2_.author_id AS author_id_43, a2_.role_id AS role_id_44 FROM app_business_all_member a0_ INNER JOIN app_business_member_role a3_ ON a0_.id = a3_.member_id INNER JOIN app_business_all_role a1_ ON a1_.id = a3_.role_id LEFT JOIN app_business_roles_authorization a2_ ON a1_.id = a2_.role_id WHERE a0_.collaborator_id = ? 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, a1_.id AS id_10, a1_.date_add AS date_add_11, a1_.date_upd AS date_upd_12, a1_.is_deleted AS is_deleted_13, a1_.is_locked AS is_locked_14, a1_.is_draft AS is_draft_15, a1_.can_be_deleted AS can_be_deleted_16, a1_.deleted_at AS deleted_at_17, a1_.owner_organization_id AS owner_organization_id_18, a1_.companies_ids AS companies_ids_19, a1_.name AS name_20, a1_.description AS description_21, a1_.is_default AS is_default_22, a1_.code AS code_23, a2_.id AS id_24, a2_.date_add AS date_add_25, a2_.date_upd AS date_upd_26, a2_.is_deleted AS is_deleted_27, a2_.is_locked AS is_locked_28, a2_.is_draft AS is_draft_29, a2_.can_be_deleted AS can_be_deleted_30, a2_.deleted_at AS deleted_at_31, a2_.owner_organization_id AS owner_organization_id_32, a2_.companies_ids AS companies_ids_33, a2_.key_rule AS key_rule_34, a2_.key_group AS key_group_35, a0_.deleted_by_id AS deleted_by_id_36, a0_.author_id AS author_id_37, a0_.collaborator_id AS collaborator_id_38, a1_.deleted_by_id AS deleted_by_id_39, a1_.author_id AS author_id_40, a1_.organization_id AS organization_id_41, a2_.deleted_by_id AS deleted_by_id_42, a2_.author_id AS author_id_43, a2_.role_id AS role_id_44 FROM app_business_all_member a0_ INNER JOIN app_business_member_role a3_ ON a0_.id = a3_.member_id INNER JOIN app_business_all_role a1_ ON a1_.id = a3_.role_id LEFT JOIN app_business_roles_authorization a2_ ON a1_.id = a2_.role_id WHERE a0_.collaborator_id = 30;
1.46 ms (2.77%)	2	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.key_rule AS key_rule_11, t0.key_group AS key_group_12, t0.deleted_by_id AS deleted_by_id_13, t14.id AS id_15, t14.date_add AS date_add_16, t14.date_upd AS date_upd_17, t14.is_deleted AS is_deleted_18, t14.is_locked AS is_locked_19, t14.is_draft AS is_draft_20, t14.can_be_deleted AS can_be_deleted_21, t14.deleted_at AS deleted_at_22, t14.owner_organization_id AS owner_organization_id_23, t14.companies_ids AS companies_ids_24, t14.lastname AS lastname_25, t14.firstname AS firstname_26, t14.birth_place AS birth_place_27, t14.birth_date AS birth_date_28, t14.gender AS gender_29, t14.deleted_by_id AS deleted_by_id_30, t14.author_id AS author_id_31, t14.access_id AS access_id_32, t0.author_id AS author_id_33, t34.id AS id_35, t34.date_add AS date_add_36, t34.date_upd AS date_upd_37, t34.is_deleted AS is_deleted_38, t34.is_locked AS is_locked_39, t34.is_draft AS is_draft_40, t34.can_be_deleted AS can_be_deleted_41, t34.deleted_at AS deleted_at_42, t34.owner_organization_id AS owner_organization_id_43, t34.companies_ids AS companies_ids_44, t34.lastname AS lastname_45, t34.firstname AS firstname_46, t34.birth_place AS birth_place_47, t34.birth_date AS birth_date_48, t34.gender AS gender_49, t34.deleted_by_id AS deleted_by_id_50, t34.author_id AS author_id_51, t34.access_id AS access_id_52, t0.role_id AS role_id_53, t54.id AS id_55, t54.date_add AS date_add_56, t54.date_upd AS date_upd_57, t54.is_deleted AS is_deleted_58, t54.is_locked AS is_locked_59, t54.is_draft AS is_draft_60, t54.can_be_deleted AS can_be_deleted_61, t54.deleted_at AS deleted_at_62, t54.owner_organization_id AS owner_organization_id_63, t54.companies_ids AS companies_ids_64, t54.name AS name_65, t54.description AS description_66, t54.is_default AS is_default_67, t54.code AS code_68, t54.deleted_by_id AS deleted_by_id_69, t54.author_id AS author_id_70, t54.organization_id AS organization_id_71 FROM app_business_roles_authorization t0 LEFT JOIN app_core_user_actor t14 ON t0.deleted_by_id = t14.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id INNER JOIN app_business_all_role t54 ON t0.role_id = t54.id WHERE t0.role_id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query 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.key_rule AS key_rule_11, t0.key_group AS key_group_12, t0.deleted_by_id AS deleted_by_id_13, t14.id AS id_15, t14.date_add AS date_add_16, t14.date_upd AS date_upd_17, t14.is_deleted AS is_deleted_18, t14.is_locked AS is_locked_19, t14.is_draft AS is_draft_20, t14.can_be_deleted AS can_be_deleted_21, t14.deleted_at AS deleted_at_22, t14.owner_organization_id AS owner_organization_id_23, t14.companies_ids AS companies_ids_24, t14.lastname AS lastname_25, t14.firstname AS firstname_26, t14.birth_place AS birth_place_27, t14.birth_date AS birth_date_28, t14.gender AS gender_29, t14.deleted_by_id AS deleted_by_id_30, t14.author_id AS author_id_31, t14.access_id AS access_id_32, t0.author_id AS author_id_33, t34.id AS id_35, t34.date_add AS date_add_36, t34.date_upd AS date_upd_37, t34.is_deleted AS is_deleted_38, t34.is_locked AS is_locked_39, t34.is_draft AS is_draft_40, t34.can_be_deleted AS can_be_deleted_41, t34.deleted_at AS deleted_at_42, t34.owner_organization_id AS owner_organization_id_43, t34.companies_ids AS companies_ids_44, t34.lastname AS lastname_45, t34.firstname AS firstname_46, t34.birth_place AS birth_place_47, t34.birth_date AS birth_date_48, t34.gender AS gender_49, t34.deleted_by_id AS deleted_by_id_50, t34.author_id AS author_id_51, t34.access_id AS access_id_52, t0.role_id AS role_id_53, t54.id AS id_55, t54.date_add AS date_add_56, t54.date_upd AS date_upd_57, t54.is_deleted AS is_deleted_58, t54.is_locked AS is_locked_59, t54.is_draft AS is_draft_60, t54.can_be_deleted AS can_be_deleted_61, t54.deleted_at AS deleted_at_62, t54.owner_organization_id AS owner_organization_id_63, t54.companies_ids AS companies_ids_64, t54.name AS name_65, t54.description AS description_66, t54.is_default AS is_default_67, t54.code AS code_68, t54.deleted_by_id AS deleted_by_id_69, t54.author_id AS author_id_70, t54.organization_id AS organization_id_71 FROM app_business_roles_authorization t0 LEFT JOIN app_core_user_actor t14 ON t0.deleted_by_id = t14.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id INNER JOIN app_business_all_role t54 ON t0.role_id = t54.id WHERE t0.role_id IN (?) 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.key_rule AS key_rule_11, t0.key_group AS key_group_12, t0.deleted_by_id AS deleted_by_id_13, t14.id AS id_15, t14.date_add AS date_add_16, t14.date_upd AS date_upd_17, t14.is_deleted AS is_deleted_18, t14.is_locked AS is_locked_19, t14.is_draft AS is_draft_20, t14.can_be_deleted AS can_be_deleted_21, t14.deleted_at AS deleted_at_22, t14.owner_organization_id AS owner_organization_id_23, t14.companies_ids AS companies_ids_24, t14.lastname AS lastname_25, t14.firstname AS firstname_26, t14.birth_place AS birth_place_27, t14.birth_date AS birth_date_28, t14.gender AS gender_29, t14.deleted_by_id AS deleted_by_id_30, t14.author_id AS author_id_31, t14.access_id AS access_id_32, t0.author_id AS author_id_33, t34.id AS id_35, t34.date_add AS date_add_36, t34.date_upd AS date_upd_37, t34.is_deleted AS is_deleted_38, t34.is_locked AS is_locked_39, t34.is_draft AS is_draft_40, t34.can_be_deleted AS can_be_deleted_41, t34.deleted_at AS deleted_at_42, t34.owner_organization_id AS owner_organization_id_43, t34.companies_ids AS companies_ids_44, t34.lastname AS lastname_45, t34.firstname AS firstname_46, t34.birth_place AS birth_place_47, t34.birth_date AS birth_date_48, t34.gender AS gender_49, t34.deleted_by_id AS deleted_by_id_50, t34.author_id AS author_id_51, t34.access_id AS access_id_52, t0.role_id AS role_id_53, t54.id AS id_55, t54.date_add AS date_add_56, t54.date_upd AS date_upd_57, t54.is_deleted AS is_deleted_58, t54.is_locked AS is_locked_59, t54.is_draft AS is_draft_60, t54.can_be_deleted AS can_be_deleted_61, t54.deleted_at AS deleted_at_62, t54.owner_organization_id AS owner_organization_id_63, t54.companies_ids AS companies_ids_64, t54.name AS name_65, t54.description AS description_66, t54.is_default AS is_default_67, t54.code AS code_68, t54.deleted_by_id AS deleted_by_id_69, t54.author_id AS author_id_70, t54.organization_id AS organization_id_71 FROM app_business_roles_authorization t0 LEFT JOIN app_core_user_actor t14 ON t0.deleted_by_id = t14.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id INNER JOIN app_business_all_role t54 ON t0.role_id = t54.id WHERE t0.role_id IN (1);
1.20 ms (2.28%)	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.is_enabled AS is_enabled_11, t0.currency AS currency_12, t0.iso_code AS iso_code_13, t0.iso_code3 AS iso_code3_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.geometry_type AS geometry_type_17, t0.calling_code AS calling_code_18, t0.deleted_by_id AS deleted_by_id_19, t20.id AS id_21, t20.date_add AS date_add_22, t20.date_upd AS date_upd_23, t20.is_deleted AS is_deleted_24, t20.is_locked AS is_locked_25, t20.is_draft AS is_draft_26, t20.can_be_deleted AS can_be_deleted_27, t20.deleted_at AS deleted_at_28, t20.owner_organization_id AS owner_organization_id_29, t20.companies_ids AS companies_ids_30, t20.lastname AS lastname_31, t20.firstname AS firstname_32, t20.birth_place AS birth_place_33, t20.birth_date AS birth_date_34, t20.gender AS gender_35, t20.deleted_by_id AS deleted_by_id_36, t20.author_id AS author_id_37, t20.access_id AS access_id_38, t0.author_id AS author_id_39, t40.id AS id_41, t40.date_add AS date_add_42, t40.date_upd AS date_upd_43, t40.is_deleted AS is_deleted_44, t40.is_locked AS is_locked_45, t40.is_draft AS is_draft_46, t40.can_be_deleted AS can_be_deleted_47, t40.deleted_at AS deleted_at_48, t40.owner_organization_id AS owner_organization_id_49, t40.companies_ids AS companies_ids_50, t40.lastname AS lastname_51, t40.firstname AS firstname_52, t40.birth_place AS birth_place_53, t40.birth_date AS birth_date_54, t40.gender AS gender_55, t40.deleted_by_id AS deleted_by_id_56, t40.author_id AS author_id_57, t40.access_id AS access_id_58, t0.continent_id AS continent_id_59, t60.id AS id_61, t60.date_add AS date_add_62, t60.date_upd AS date_upd_63, t60.is_deleted AS is_deleted_64, t60.is_locked AS is_locked_65, t60.is_draft AS is_draft_66, t60.can_be_deleted AS can_be_deleted_67, t60.deleted_at AS deleted_at_68, t60.owner_organization_id AS owner_organization_id_69, t60.companies_ids AS companies_ids_70, t60.iso_code AS iso_code_71, t60.deleted_by_id AS deleted_by_id_72, t60.author_id AS author_id_73 FROM app_core_location_country t0 LEFT JOIN app_core_user_actor t20 ON t0.deleted_by_id = t20.id LEFT JOIN app_core_user_actor t40 ON t0.author_id = t40.id INNER JOIN app_core_location_continent t60 ON t0.continent_id = t60.id WHERE t0.id IN (?) Parameters: [`4`] View formatted query View runnable query Explain query 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.is_enabled AS is_enabled_11, t0.currency AS currency_12, t0.iso_code AS iso_code_13, t0.iso_code3 AS iso_code3_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.geometry_type AS geometry_type_17, t0.calling_code AS calling_code_18, t0.deleted_by_id AS deleted_by_id_19, t20.id AS id_21, t20.date_add AS date_add_22, t20.date_upd AS date_upd_23, t20.is_deleted AS is_deleted_24, t20.is_locked AS is_locked_25, t20.is_draft AS is_draft_26, t20.can_be_deleted AS can_be_deleted_27, t20.deleted_at AS deleted_at_28, t20.owner_organization_id AS owner_organization_id_29, t20.companies_ids AS companies_ids_30, t20.lastname AS lastname_31, t20.firstname AS firstname_32, t20.birth_place AS birth_place_33, t20.birth_date AS birth_date_34, t20.gender AS gender_35, t20.deleted_by_id AS deleted_by_id_36, t20.author_id AS author_id_37, t20.access_id AS access_id_38, t0.author_id AS author_id_39, t40.id AS id_41, t40.date_add AS date_add_42, t40.date_upd AS date_upd_43, t40.is_deleted AS is_deleted_44, t40.is_locked AS is_locked_45, t40.is_draft AS is_draft_46, t40.can_be_deleted AS can_be_deleted_47, t40.deleted_at AS deleted_at_48, t40.owner_organization_id AS owner_organization_id_49, t40.companies_ids AS companies_ids_50, t40.lastname AS lastname_51, t40.firstname AS firstname_52, t40.birth_place AS birth_place_53, t40.birth_date AS birth_date_54, t40.gender AS gender_55, t40.deleted_by_id AS deleted_by_id_56, t40.author_id AS author_id_57, t40.access_id AS access_id_58, t0.continent_id AS continent_id_59, t60.id AS id_61, t60.date_add AS date_add_62, t60.date_upd AS date_upd_63, t60.is_deleted AS is_deleted_64, t60.is_locked AS is_locked_65, t60.is_draft AS is_draft_66, t60.can_be_deleted AS can_be_deleted_67, t60.deleted_at AS deleted_at_68, t60.owner_organization_id AS owner_organization_id_69, t60.companies_ids AS companies_ids_70, t60.iso_code AS iso_code_71, t60.deleted_by_id AS deleted_by_id_72, t60.author_id AS author_id_73 FROM app_core_location_country t0 LEFT JOIN app_core_user_actor t20 ON t0.deleted_by_id = t20.id LEFT JOIN app_core_user_actor t40 ON t0.author_id = t40.id INNER JOIN app_core_location_continent t60 ON t0.continent_id = t60.id WHERE t0.id IN (?) 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.is_enabled AS is_enabled_11, t0.currency AS currency_12, t0.iso_code AS iso_code_13, t0.iso_code3 AS iso_code3_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.geometry_type AS geometry_type_17, t0.calling_code AS calling_code_18, t0.deleted_by_id AS deleted_by_id_19, t20.id AS id_21, t20.date_add AS date_add_22, t20.date_upd AS date_upd_23, t20.is_deleted AS is_deleted_24, t20.is_locked AS is_locked_25, t20.is_draft AS is_draft_26, t20.can_be_deleted AS can_be_deleted_27, t20.deleted_at AS deleted_at_28, t20.owner_organization_id AS owner_organization_id_29, t20.companies_ids AS companies_ids_30, t20.lastname AS lastname_31, t20.firstname AS firstname_32, t20.birth_place AS birth_place_33, t20.birth_date AS birth_date_34, t20.gender AS gender_35, t20.deleted_by_id AS deleted_by_id_36, t20.author_id AS author_id_37, t20.access_id AS access_id_38, t0.author_id AS author_id_39, t40.id AS id_41, t40.date_add AS date_add_42, t40.date_upd AS date_upd_43, t40.is_deleted AS is_deleted_44, t40.is_locked AS is_locked_45, t40.is_draft AS is_draft_46, t40.can_be_deleted AS can_be_deleted_47, t40.deleted_at AS deleted_at_48, t40.owner_organization_id AS owner_organization_id_49, t40.companies_ids AS companies_ids_50, t40.lastname AS lastname_51, t40.firstname AS firstname_52, t40.birth_place AS birth_place_53, t40.birth_date AS birth_date_54, t40.gender AS gender_55, t40.deleted_by_id AS deleted_by_id_56, t40.author_id AS author_id_57, t40.access_id AS access_id_58, t0.continent_id AS continent_id_59, t60.id AS id_61, t60.date_add AS date_add_62, t60.date_upd AS date_upd_63, t60.is_deleted AS is_deleted_64, t60.is_locked AS is_locked_65, t60.is_draft AS is_draft_66, t60.can_be_deleted AS can_be_deleted_67, t60.deleted_at AS deleted_at_68, t60.owner_organization_id AS owner_organization_id_69, t60.companies_ids AS companies_ids_70, t60.iso_code AS iso_code_71, t60.deleted_by_id AS deleted_by_id_72, t60.author_id AS author_id_73 FROM app_core_location_country t0 LEFT JOIN app_core_user_actor t20 ON t0.deleted_by_id = t20.id LEFT JOIN app_core_user_actor t40 ON t0.author_id = t40.id INNER JOIN app_core_location_continent t60 ON t0.continent_id = t60.id WHERE t0.id IN (4);
0.97 ms (1.84%)	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.context_type AS context_type_11, t0.deleted_by_id AS deleted_by_id_12, t13.id AS id_14, t13.date_add AS date_add_15, t13.date_upd AS date_upd_16, t13.is_deleted AS is_deleted_17, t13.is_locked AS is_locked_18, t13.is_draft AS is_draft_19, t13.can_be_deleted AS can_be_deleted_20, t13.deleted_at AS deleted_at_21, t13.owner_organization_id AS owner_organization_id_22, t13.companies_ids AS companies_ids_23, t13.lastname AS lastname_24, t13.firstname AS firstname_25, t13.birth_place AS birth_place_26, t13.birth_date AS birth_date_27, t13.gender AS gender_28, t13.deleted_by_id AS deleted_by_id_29, t13.author_id AS author_id_30, t13.access_id AS access_id_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.date_add AS date_add_35, t33.date_upd AS date_upd_36, t33.is_deleted AS is_deleted_37, t33.is_locked AS is_locked_38, t33.is_draft AS is_draft_39, t33.can_be_deleted AS can_be_deleted_40, t33.deleted_at AS deleted_at_41, t33.owner_organization_id AS owner_organization_id_42, t33.companies_ids AS companies_ids_43, t33.lastname AS lastname_44, t33.firstname AS firstname_45, t33.birth_place AS birth_place_46, t33.birth_date AS birth_date_47, t33.gender AS gender_48, t33.deleted_by_id AS deleted_by_id_49, t33.author_id AS author_id_50, t33.access_id AS access_id_51, t0.actor_id AS actor_id_52, t53.id AS id_54, t53.date_add AS date_add_55, t53.date_upd AS date_upd_56, t53.is_deleted AS is_deleted_57, t53.is_locked AS is_locked_58, t53.is_draft AS is_draft_59, t53.can_be_deleted AS can_be_deleted_60, t53.deleted_at AS deleted_at_61, t53.owner_organization_id AS owner_organization_id_62, t53.companies_ids AS companies_ids_63, t53.lastname AS lastname_64, t53.firstname AS firstname_65, t53.birth_place AS birth_place_66, t53.birth_date AS birth_date_67, t53.gender AS gender_68, t53.deleted_by_id AS deleted_by_id_69, t53.author_id AS author_id_70, t53.access_id AS access_id_71, t0.organization_id AS organization_id_72, t73.id AS id_74, t73.date_add AS date_add_75, t73.date_upd AS date_upd_76, t73.is_deleted AS is_deleted_77, t73.is_locked AS is_locked_78, t73.is_draft AS is_draft_79, t73.can_be_deleted AS can_be_deleted_80, t73.deleted_at AS deleted_at_81, t73.owner_organization_id AS owner_organization_id_82, t73.companies_ids AS companies_ids_83, t73.name AS name_84, t73.opening_hours AS opening_hours_85, t73.closing_hours AS closing_hours_86, t73.is_plateform_manager AS is_plateform_manager_87, t73.thumbnail_id AS thumbnail_id_88, t73.latitude AS latitude_89, t73.longitude AS longitude_90, t73.cover_image_id AS cover_image_id_91, t73.opening_days AS opening_days_92, t73.deleted_by_id AS deleted_by_id_93, t73.author_id AS author_id_94, t73.actor_id AS actor_id_95, t73.contact_id AS contact_id_96 FROM app_core_user_workspace t0 LEFT JOIN app_core_user_actor t13 ON t0.deleted_by_id = t13.id LEFT JOIN app_core_user_actor t33 ON t0.author_id = t33.id INNER JOIN app_core_user_actor t53 ON t0.actor_id = t53.id INNER JOIN app_core_user_organization t73 ON t0.organization_id = t73.id WHERE t0.actor_id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.context_type AS context_type_11, t0.deleted_by_id AS deleted_by_id_12, t13.id AS id_14, t13.date_add AS date_add_15, t13.date_upd AS date_upd_16, t13.is_deleted AS is_deleted_17, t13.is_locked AS is_locked_18, t13.is_draft AS is_draft_19, t13.can_be_deleted AS can_be_deleted_20, t13.deleted_at AS deleted_at_21, t13.owner_organization_id AS owner_organization_id_22, t13.companies_ids AS companies_ids_23, t13.lastname AS lastname_24, t13.firstname AS firstname_25, t13.birth_place AS birth_place_26, t13.birth_date AS birth_date_27, t13.gender AS gender_28, t13.deleted_by_id AS deleted_by_id_29, t13.author_id AS author_id_30, t13.access_id AS access_id_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.date_add AS date_add_35, t33.date_upd AS date_upd_36, t33.is_deleted AS is_deleted_37, t33.is_locked AS is_locked_38, t33.is_draft AS is_draft_39, t33.can_be_deleted AS can_be_deleted_40, t33.deleted_at AS deleted_at_41, t33.owner_organization_id AS owner_organization_id_42, t33.companies_ids AS companies_ids_43, t33.lastname AS lastname_44, t33.firstname AS firstname_45, t33.birth_place AS birth_place_46, t33.birth_date AS birth_date_47, t33.gender AS gender_48, t33.deleted_by_id AS deleted_by_id_49, t33.author_id AS author_id_50, t33.access_id AS access_id_51, t0.actor_id AS actor_id_52, t53.id AS id_54, t53.date_add AS date_add_55, t53.date_upd AS date_upd_56, t53.is_deleted AS is_deleted_57, t53.is_locked AS is_locked_58, t53.is_draft AS is_draft_59, t53.can_be_deleted AS can_be_deleted_60, t53.deleted_at AS deleted_at_61, t53.owner_organization_id AS owner_organization_id_62, t53.companies_ids AS companies_ids_63, t53.lastname AS lastname_64, t53.firstname AS firstname_65, t53.birth_place AS birth_place_66, t53.birth_date AS birth_date_67, t53.gender AS gender_68, t53.deleted_by_id AS deleted_by_id_69, t53.author_id AS author_id_70, t53.access_id AS access_id_71, t0.organization_id AS organization_id_72, t73.id AS id_74, t73.date_add AS date_add_75, t73.date_upd AS date_upd_76, t73.is_deleted AS is_deleted_77, t73.is_locked AS is_locked_78, t73.is_draft AS is_draft_79, t73.can_be_deleted AS can_be_deleted_80, t73.deleted_at AS deleted_at_81, t73.owner_organization_id AS owner_organization_id_82, t73.companies_ids AS companies_ids_83, t73.name AS name_84, t73.opening_hours AS opening_hours_85, t73.closing_hours AS closing_hours_86, t73.is_plateform_manager AS is_plateform_manager_87, t73.thumbnail_id AS thumbnail_id_88, t73.latitude AS latitude_89, t73.longitude AS longitude_90, t73.cover_image_id AS cover_image_id_91, t73.opening_days AS opening_days_92, t73.deleted_by_id AS deleted_by_id_93, t73.author_id AS author_id_94, t73.actor_id AS actor_id_95, t73.contact_id AS contact_id_96 FROM app_core_user_workspace t0 LEFT JOIN app_core_user_actor t13 ON t0.deleted_by_id = t13.id LEFT JOIN app_core_user_actor t33 ON t0.author_id = t33.id INNER JOIN app_core_user_actor t53 ON t0.actor_id = t53.id INNER JOIN app_core_user_organization t73 ON t0.organization_id = t73.id WHERE t0.actor_id = ? 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.context_type AS context_type_11, t0.deleted_by_id AS deleted_by_id_12, t13.id AS id_14, t13.date_add AS date_add_15, t13.date_upd AS date_upd_16, t13.is_deleted AS is_deleted_17, t13.is_locked AS is_locked_18, t13.is_draft AS is_draft_19, t13.can_be_deleted AS can_be_deleted_20, t13.deleted_at AS deleted_at_21, t13.owner_organization_id AS owner_organization_id_22, t13.companies_ids AS companies_ids_23, t13.lastname AS lastname_24, t13.firstname AS firstname_25, t13.birth_place AS birth_place_26, t13.birth_date AS birth_date_27, t13.gender AS gender_28, t13.deleted_by_id AS deleted_by_id_29, t13.author_id AS author_id_30, t13.access_id AS access_id_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.date_add AS date_add_35, t33.date_upd AS date_upd_36, t33.is_deleted AS is_deleted_37, t33.is_locked AS is_locked_38, t33.is_draft AS is_draft_39, t33.can_be_deleted AS can_be_deleted_40, t33.deleted_at AS deleted_at_41, t33.owner_organization_id AS owner_organization_id_42, t33.companies_ids AS companies_ids_43, t33.lastname AS lastname_44, t33.firstname AS firstname_45, t33.birth_place AS birth_place_46, t33.birth_date AS birth_date_47, t33.gender AS gender_48, t33.deleted_by_id AS deleted_by_id_49, t33.author_id AS author_id_50, t33.access_id AS access_id_51, t0.actor_id AS actor_id_52, t53.id AS id_54, t53.date_add AS date_add_55, t53.date_upd AS date_upd_56, t53.is_deleted AS is_deleted_57, t53.is_locked AS is_locked_58, t53.is_draft AS is_draft_59, t53.can_be_deleted AS can_be_deleted_60, t53.deleted_at AS deleted_at_61, t53.owner_organization_id AS owner_organization_id_62, t53.companies_ids AS companies_ids_63, t53.lastname AS lastname_64, t53.firstname AS firstname_65, t53.birth_place AS birth_place_66, t53.birth_date AS birth_date_67, t53.gender AS gender_68, t53.deleted_by_id AS deleted_by_id_69, t53.author_id AS author_id_70, t53.access_id AS access_id_71, t0.organization_id AS organization_id_72, t73.id AS id_74, t73.date_add AS date_add_75, t73.date_upd AS date_upd_76, t73.is_deleted AS is_deleted_77, t73.is_locked AS is_locked_78, t73.is_draft AS is_draft_79, t73.can_be_deleted AS can_be_deleted_80, t73.deleted_at AS deleted_at_81, t73.owner_organization_id AS owner_organization_id_82, t73.companies_ids AS companies_ids_83, t73.name AS name_84, t73.opening_hours AS opening_hours_85, t73.closing_hours AS closing_hours_86, t73.is_plateform_manager AS is_plateform_manager_87, t73.thumbnail_id AS thumbnail_id_88, t73.latitude AS latitude_89, t73.longitude AS longitude_90, t73.cover_image_id AS cover_image_id_91, t73.opening_days AS opening_days_92, t73.deleted_by_id AS deleted_by_id_93, t73.author_id AS author_id_94, t73.actor_id AS actor_id_95, t73.contact_id AS contact_id_96 FROM app_core_user_workspace t0 LEFT JOIN app_core_user_actor t13 ON t0.deleted_by_id = t13.id LEFT JOIN app_core_user_actor t33 ON t0.author_id = t33.id INNER JOIN app_core_user_actor t53 ON t0.actor_id = t53.id INNER JOIN app_core_user_organization t73 ON t0.organization_id = t73.id WHERE t0.actor_id = 1;
0.96 ms (1.82%)	2	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_.context_type AS context_type_10, a1_.id AS id_11, a1_.date_add AS date_add_12, a1_.date_upd AS date_upd_13, a1_.is_deleted AS is_deleted_14, a1_.is_locked AS is_locked_15, a1_.is_draft AS is_draft_16, a1_.can_be_deleted AS can_be_deleted_17, a1_.deleted_at AS deleted_at_18, a1_.owner_organization_id AS owner_organization_id_19, a1_.companies_ids AS companies_ids_20, a1_.lastname AS lastname_21, a1_.firstname AS firstname_22, a1_.birth_place AS birth_place_23, a1_.birth_date AS birth_date_24, a1_.gender AS gender_25, a0_.deleted_by_id AS deleted_by_id_26, a0_.author_id AS author_id_27, a0_.actor_id AS actor_id_28, a0_.organization_id AS organization_id_29, a1_.deleted_by_id AS deleted_by_id_30, a1_.author_id AS author_id_31, a1_.access_id AS access_id_32 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = ? Parameters: [`30`] View formatted query View runnable query Explain query 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_.context_type AS context_type_10, a1_.id AS id_11, a1_.date_add AS date_add_12, a1_.date_upd AS date_upd_13, a1_.is_deleted AS is_deleted_14, a1_.is_locked AS is_locked_15, a1_.is_draft AS is_draft_16, a1_.can_be_deleted AS can_be_deleted_17, a1_.deleted_at AS deleted_at_18, a1_.owner_organization_id AS owner_organization_id_19, a1_.companies_ids AS companies_ids_20, a1_.lastname AS lastname_21, a1_.firstname AS firstname_22, a1_.birth_place AS birth_place_23, a1_.birth_date AS birth_date_24, a1_.gender AS gender_25, a0_.deleted_by_id AS deleted_by_id_26, a0_.author_id AS author_id_27, a0_.actor_id AS actor_id_28, a0_.organization_id AS organization_id_29, a1_.deleted_by_id AS deleted_by_id_30, a1_.author_id AS author_id_31, a1_.access_id AS access_id_32 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = ? 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_.context_type AS context_type_10, a1_.id AS id_11, a1_.date_add AS date_add_12, a1_.date_upd AS date_upd_13, a1_.is_deleted AS is_deleted_14, a1_.is_locked AS is_locked_15, a1_.is_draft AS is_draft_16, a1_.can_be_deleted AS can_be_deleted_17, a1_.deleted_at AS deleted_at_18, a1_.owner_organization_id AS owner_organization_id_19, a1_.companies_ids AS companies_ids_20, a1_.lastname AS lastname_21, a1_.firstname AS firstname_22, a1_.birth_place AS birth_place_23, a1_.birth_date AS birth_date_24, a1_.gender AS gender_25, a0_.deleted_by_id AS deleted_by_id_26, a0_.author_id AS author_id_27, a0_.actor_id AS actor_id_28, a0_.organization_id AS organization_id_29, a1_.deleted_by_id AS deleted_by_id_30, a1_.author_id AS author_id_31, a1_.access_id AS access_id_32 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = 30;
0.80 ms (1.51%)	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.email AS email_11, t0.last_connection_date AS last_connection_date_12, t0.token AS token_13, t0.confirmation_token AS confirmation_token_14, t0.context_type AS context_type_15, t0.password AS password_16, t0.is_active AS is_active_17, t0.is_blocked AS is_blocked_18, t0.roles AS roles_19, t0.reset_token_expires_at AS reset_token_expires_at_20, t0.reset_token AS reset_token_21, t0.deleted_by_id AS deleted_by_id_22, t23.id AS id_24, t23.date_add AS date_add_25, t23.date_upd AS date_upd_26, t23.is_deleted AS is_deleted_27, t23.is_locked AS is_locked_28, t23.is_draft AS is_draft_29, t23.can_be_deleted AS can_be_deleted_30, t23.deleted_at AS deleted_at_31, t23.owner_organization_id AS owner_organization_id_32, t23.companies_ids AS companies_ids_33, t23.lastname AS lastname_34, t23.firstname AS firstname_35, t23.birth_place AS birth_place_36, t23.birth_date AS birth_date_37, t23.gender AS gender_38, t23.deleted_by_id AS deleted_by_id_39, t23.author_id AS author_id_40, t23.access_id AS access_id_41, t0.author_id AS author_id_42, t43.id AS id_44, t43.date_add AS date_add_45, t43.date_upd AS date_upd_46, t43.is_deleted AS is_deleted_47, t43.is_locked AS is_locked_48, t43.is_draft AS is_draft_49, t43.can_be_deleted AS can_be_deleted_50, t43.deleted_at AS deleted_at_51, t43.owner_organization_id AS owner_organization_id_52, t43.companies_ids AS companies_ids_53, t43.lastname AS lastname_54, t43.firstname AS firstname_55, t43.birth_place AS birth_place_56, t43.birth_date AS birth_date_57, t43.gender AS gender_58, t43.deleted_by_id AS deleted_by_id_59, t43.author_id AS author_id_60, t43.access_id AS access_id_61, t62.id AS id_63, t62.date_add AS date_add_64, t62.date_upd AS date_upd_65, t62.is_deleted AS is_deleted_66, t62.is_locked AS is_locked_67, t62.is_draft AS is_draft_68, t62.can_be_deleted AS can_be_deleted_69, t62.deleted_at AS deleted_at_70, t62.owner_organization_id AS owner_organization_id_71, t62.companies_ids AS companies_ids_72, t62.lastname AS lastname_73, t62.firstname AS firstname_74, t62.birth_place AS birth_place_75, t62.birth_date AS birth_date_76, t62.gender AS gender_77, t62.deleted_by_id AS deleted_by_id_78, t62.author_id AS author_id_79, t62.access_id AS access_id_80 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t23 ON t0.deleted_by_id = t23.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id LEFT JOIN app_core_user_actor t62 ON t62.access_id = t0.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query 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.email AS email_11, t0.last_connection_date AS last_connection_date_12, t0.token AS token_13, t0.confirmation_token AS confirmation_token_14, t0.context_type AS context_type_15, t0.password AS password_16, t0.is_active AS is_active_17, t0.is_blocked AS is_blocked_18, t0.roles AS roles_19, t0.reset_token_expires_at AS reset_token_expires_at_20, t0.reset_token AS reset_token_21, t0.deleted_by_id AS deleted_by_id_22, t23.id AS id_24, t23.date_add AS date_add_25, t23.date_upd AS date_upd_26, t23.is_deleted AS is_deleted_27, t23.is_locked AS is_locked_28, t23.is_draft AS is_draft_29, t23.can_be_deleted AS can_be_deleted_30, t23.deleted_at AS deleted_at_31, t23.owner_organization_id AS owner_organization_id_32, t23.companies_ids AS companies_ids_33, t23.lastname AS lastname_34, t23.firstname AS firstname_35, t23.birth_place AS birth_place_36, t23.birth_date AS birth_date_37, t23.gender AS gender_38, t23.deleted_by_id AS deleted_by_id_39, t23.author_id AS author_id_40, t23.access_id AS access_id_41, t0.author_id AS author_id_42, t43.id AS id_44, t43.date_add AS date_add_45, t43.date_upd AS date_upd_46, t43.is_deleted AS is_deleted_47, t43.is_locked AS is_locked_48, t43.is_draft AS is_draft_49, t43.can_be_deleted AS can_be_deleted_50, t43.deleted_at AS deleted_at_51, t43.owner_organization_id AS owner_organization_id_52, t43.companies_ids AS companies_ids_53, t43.lastname AS lastname_54, t43.firstname AS firstname_55, t43.birth_place AS birth_place_56, t43.birth_date AS birth_date_57, t43.gender AS gender_58, t43.deleted_by_id AS deleted_by_id_59, t43.author_id AS author_id_60, t43.access_id AS access_id_61, t62.id AS id_63, t62.date_add AS date_add_64, t62.date_upd AS date_upd_65, t62.is_deleted AS is_deleted_66, t62.is_locked AS is_locked_67, t62.is_draft AS is_draft_68, t62.can_be_deleted AS can_be_deleted_69, t62.deleted_at AS deleted_at_70, t62.owner_organization_id AS owner_organization_id_71, t62.companies_ids AS companies_ids_72, t62.lastname AS lastname_73, t62.firstname AS firstname_74, t62.birth_place AS birth_place_75, t62.birth_date AS birth_date_76, t62.gender AS gender_77, t62.deleted_by_id AS deleted_by_id_78, t62.author_id AS author_id_79, t62.access_id AS access_id_80 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t23 ON t0.deleted_by_id = t23.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id LEFT JOIN app_core_user_actor t62 ON t62.access_id = t0.id WHERE t0.id IN (?) 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.email AS email_11, t0.last_connection_date AS last_connection_date_12, t0.token AS token_13, t0.confirmation_token AS confirmation_token_14, t0.context_type AS context_type_15, t0.password AS password_16, t0.is_active AS is_active_17, t0.is_blocked AS is_blocked_18, t0.roles AS roles_19, t0.reset_token_expires_at AS reset_token_expires_at_20, t0.reset_token AS reset_token_21, t0.deleted_by_id AS deleted_by_id_22, t23.id AS id_24, t23.date_add AS date_add_25, t23.date_upd AS date_upd_26, t23.is_deleted AS is_deleted_27, t23.is_locked AS is_locked_28, t23.is_draft AS is_draft_29, t23.can_be_deleted AS can_be_deleted_30, t23.deleted_at AS deleted_at_31, t23.owner_organization_id AS owner_organization_id_32, t23.companies_ids AS companies_ids_33, t23.lastname AS lastname_34, t23.firstname AS firstname_35, t23.birth_place AS birth_place_36, t23.birth_date AS birth_date_37, t23.gender AS gender_38, t23.deleted_by_id AS deleted_by_id_39, t23.author_id AS author_id_40, t23.access_id AS access_id_41, t0.author_id AS author_id_42, t43.id AS id_44, t43.date_add AS date_add_45, t43.date_upd AS date_upd_46, t43.is_deleted AS is_deleted_47, t43.is_locked AS is_locked_48, t43.is_draft AS is_draft_49, t43.can_be_deleted AS can_be_deleted_50, t43.deleted_at AS deleted_at_51, t43.owner_organization_id AS owner_organization_id_52, t43.companies_ids AS companies_ids_53, t43.lastname AS lastname_54, t43.firstname AS firstname_55, t43.birth_place AS birth_place_56, t43.birth_date AS birth_date_57, t43.gender AS gender_58, t43.deleted_by_id AS deleted_by_id_59, t43.author_id AS author_id_60, t43.access_id AS access_id_61, t62.id AS id_63, t62.date_add AS date_add_64, t62.date_upd AS date_upd_65, t62.is_deleted AS is_deleted_66, t62.is_locked AS is_locked_67, t62.is_draft AS is_draft_68, t62.can_be_deleted AS can_be_deleted_69, t62.deleted_at AS deleted_at_70, t62.owner_organization_id AS owner_organization_id_71, t62.companies_ids AS companies_ids_72, t62.lastname AS lastname_73, t62.firstname AS firstname_74, t62.birth_place AS birth_place_75, t62.birth_date AS birth_date_76, t62.gender AS gender_77, t62.deleted_by_id AS deleted_by_id_78, t62.author_id AS author_id_79, t62.access_id AS access_id_80 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t23 ON t0.deleted_by_id = t23.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id LEFT JOIN app_core_user_actor t62 ON t62.access_id = t0.id WHERE t0.id IN (1);
0.75 ms (1.43%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = ? ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table Parameters: [`13`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( 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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = ? ORDER BY a0_.date_add DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_.points AS points_10, a0_.threshold AS threshold_11, a0_.value AS value_12, a1_.id AS id_13, a1_.date_add AS date_add_14, a1_.date_upd AS date_upd_15, a1_.is_deleted AS is_deleted_16, a1_.is_locked AS is_locked_17, a1_.is_draft AS is_draft_18, a1_.can_be_deleted AS can_be_deleted_19, a1_.deleted_at AS deleted_at_20, a1_.owner_organization_id AS owner_organization_id_21, a1_.companies_ids AS companies_ids_22, a1_.name AS name_23, a1_.opening_hours AS opening_hours_24, a1_.closing_hours AS closing_hours_25, a1_.is_plateform_manager AS is_plateform_manager_26, a1_.thumbnail_id AS thumbnail_id_27, a1_.latitude AS latitude_28, a1_.longitude AS longitude_29, a1_.cover_image_id AS cover_image_id_30, a1_.opening_days AS opening_days_31, a2_.id AS id_32, a2_.locale AS locale_33, a2_.name AS name_34, a2_.description AS description_35, a2_.slug AS slug_36, a3_.id AS id_37, a3_.date_add AS date_add_38, a3_.date_upd AS date_upd_39, a3_.is_deleted AS is_deleted_40, a3_.is_locked AS is_locked_41, a3_.is_draft AS is_draft_42, a3_.can_be_deleted AS can_be_deleted_43, a3_.deleted_at AS deleted_at_44, a3_.owner_organization_id AS owner_organization_id_45, a3_.companies_ids AS companies_ids_46, a3_.duration AS duration_47, a3_.cost AS cost_48, a3_.pictures AS pictures_49, a3_.position AS position_50, a3_.value AS value_51, a3_.isDynamic AS isdynamic_52, a3_.isCustomer AS iscustomer_53, a3_.points AS points_54, a3_.commission_type AS commission_type_55, a3_.commission_value AS commission_value_56 FROM app_business_loyalty a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id LEFT JOIN app_business_loyalty_i18n a2_ ON a0_.id = a2_.entity_id LEFT JOIN app_business_service a3_ ON a0_.service_id = a3_.id WHERE a0_.is_deleted = false AND a1_.id = 13 ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table;
0.72 ms (1.37%)	2	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_business_service_i18n t0 WHERE t0.entity_id IN (?) Parameters: [`40`] View formatted query View runnable query Explain query 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_business_service_i18n t0 WHERE t0.entity_id IN (?) 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_business_service_i18n t0 WHERE t0.entity_id IN (40);
0.56 ms (1.07%)	2	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_business_type_i18n t0 WHERE t0.entity_id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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_business_type_i18n t0 WHERE t0.entity_id = ? 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_business_type_i18n t0 WHERE t0.entity_id = 1;
0.50 ms (0.96%)	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, t7.id AS id_8, t7.date_add AS date_add_9, t7.date_upd AS date_upd_10, t7.is_deleted AS is_deleted_11, t7.is_locked AS is_locked_12, t7.is_draft AS is_draft_13, t7.can_be_deleted AS can_be_deleted_14, t7.deleted_at AS deleted_at_15, t7.owner_organization_id AS owner_organization_id_16, t7.companies_ids AS companies_ids_17, t7.iso_code AS iso_code_18, t7.deleted_by_id AS deleted_by_id_19, t7.author_id AS author_id_20 FROM app_core_location_continent_i18n t0 INNER JOIN app_core_location_continent t7 ON t0.entity_id = t7.id WHERE t0.entity_id = ? Parameters: [`3`] View formatted query View runnable query Explain query 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, t7.id AS id_8, t7.date_add AS date_add_9, t7.date_upd AS date_upd_10, t7.is_deleted AS is_deleted_11, t7.is_locked AS is_locked_12, t7.is_draft AS is_draft_13, t7.can_be_deleted AS can_be_deleted_14, t7.deleted_at AS deleted_at_15, t7.owner_organization_id AS owner_organization_id_16, t7.companies_ids AS companies_ids_17, t7.iso_code AS iso_code_18, t7.deleted_by_id AS deleted_by_id_19, t7.author_id AS author_id_20 FROM app_core_location_continent_i18n t0 INNER JOIN app_core_location_continent t7 ON t0.entity_id = t7.id WHERE t0.entity_id = ? 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, t7.id AS id_8, t7.date_add AS date_add_9, t7.date_upd AS date_upd_10, t7.is_deleted AS is_deleted_11, t7.is_locked AS is_locked_12, t7.is_draft AS is_draft_13, t7.can_be_deleted AS can_be_deleted_14, t7.deleted_at AS deleted_at_15, t7.owner_organization_id AS owner_organization_id_16, t7.companies_ids AS companies_ids_17, t7.iso_code AS iso_code_18, t7.deleted_by_id AS deleted_by_id_19, t7.author_id AS author_id_20 FROM app_core_location_continent_i18n t0 INNER JOIN app_core_location_continent t7 ON t0.entity_id = t7.id WHERE t0.entity_id = 3;
0.43 ms (0.81%)	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_location_neighborhood_i18n t0 WHERE t0.entity_id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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_location_neighborhood_i18n t0 WHERE t0.entity_id = ? 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_location_neighborhood_i18n t0 WHERE t0.entity_id = 1;
0.43 ms (0.81%)	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_location_state_i18n t0 WHERE t0.entity_id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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_location_state_i18n t0 WHERE t0.entity_id = ? 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_location_state_i18n t0 WHERE t0.entity_id = 2;
0.39 ms (0.75%)	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 = ? Parameters: [`13`] View formatted query View runnable query Explain query 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 = ? 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 = 13;
0.39 ms (0.74%)	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.official_name AS official_name_6, t0.entity_id AS entity_id_7 FROM app_core_location_country_i18n t0 WHERE t0.entity_id = ? Parameters: [`4`] View formatted query View runnable query Explain query 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.official_name AS official_name_6, t0.entity_id AS entity_id_7 FROM app_core_location_country_i18n t0 WHERE t0.entity_id = ? 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.official_name AS official_name_6, t0.entity_id AS entity_id_7 FROM app_core_location_country_i18n t0 WHERE t0.entity_id = 4;

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	The field App\Core\Entity\User\Actor#workspace is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Core\Entity\User\Workspace#actor does not contain the required 'inversedBy: "workspace"' attribute.
App\Core\Entity\User\Collaborator	The field App\Core\Entity\User\Collaborator#businessRoles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Business\Entity\BusinessMember#collaborator does not contain the required 'inversedBy: "businessRoles"' attribute.
App\Core\Entity\Location\Contact	No errors.
App\Core\Entity\User\Organization	No errors.
App\Business\Entity\Type	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\BusinessRole	No errors.
App\Business\Entity\BusinessRoleAuthorization	No errors.
App\Business\Entity\Loyalty	The field App\Business\Entity\Loyalty#services is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Business\Entity\Services#loyaltyProgram does not contain the required 'inversedBy: "services"' attribute.
App\Business\Entity\LoyaltyI18n	No errors.
App\Business\Entity\Services	No errors.
App\Core\Entity\Location\Neighborhood	No errors.
App\Core\Entity\Location\Country	No errors.
App\Business\Entity\ServicesI18n	No errors.
App\Business\Entity\TypeI18n	No errors.
App\Core\Entity\Location\StateI18n	No errors.
App\Core\Entity\Location\NeighborhoodI18n	No errors.
App\Core\Entity\Location\Continent	No errors.
App\Core\Entity\Location\CountryI18n	No errors.
App\Core\Entity\Location\ContinentI18n	No errors.

Symfony Profiler

GET http://app.facile-car.com/api/business/loyaltys/?currentPage=1&numberPerPage=100&organizationId=13

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping