Symfony Profiler

Query Metrics

36 Database Queries

17 Different statements

69.39 ms Query time

2 Invalid entities

Grouped Statements

Time▼	Count	Info
19.35 ms (27.88%)	8	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: [`22`] 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 = 22;
8.16 ms (11.76%)	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.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.actor_id AS actor_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.lastname AS lastname_68, t57.firstname AS firstname_69, t57.birth_place AS birth_place_70, t57.birth_date AS birth_date_71, t57.gender AS gender_72, t57.deleted_by_id AS deleted_by_id_73, t57.author_id AS author_id_74, t57.access_id AS access_id_75, t0.contact_id AS contact_id_76, t77.id AS id_78, t77.date_add AS date_add_79, t77.date_upd AS date_upd_80, t77.is_deleted AS is_deleted_81, t77.is_locked AS is_locked_82, t77.is_draft AS is_draft_83, t77.can_be_deleted AS can_be_deleted_84, t77.deleted_at AS deleted_at_85, t77.owner_organization_id AS owner_organization_id_86, t77.companies_ids AS companies_ids_87, t77.calling_code AS calling_code_88, t77.phone AS phone_89, t77.email AS email_90, t77.web_site AS web_site_91, t77.address AS address_92, t77.city AS city_93, t77.deleted_by_id AS deleted_by_id_94, t77.author_id AS author_id_95, t77.country_id AS country_id_96, t77.state_id AS state_id_97 FROM app_core_user_organization 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 LEFT JOIN app_core_user_actor t57 ON t0.actor_id = t57.id LEFT JOIN app_core_location_contact t77 ON t0.contact_id = t77.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.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.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.actor_id AS actor_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.lastname AS lastname_68, t57.firstname AS firstname_69, t57.birth_place AS birth_place_70, t57.birth_date AS birth_date_71, t57.gender AS gender_72, t57.deleted_by_id AS deleted_by_id_73, t57.author_id AS author_id_74, t57.access_id AS access_id_75, t0.contact_id AS contact_id_76, t77.id AS id_78, t77.date_add AS date_add_79, t77.date_upd AS date_upd_80, t77.is_deleted AS is_deleted_81, t77.is_locked AS is_locked_82, t77.is_draft AS is_draft_83, t77.can_be_deleted AS can_be_deleted_84, t77.deleted_at AS deleted_at_85, t77.owner_organization_id AS owner_organization_id_86, t77.companies_ids AS companies_ids_87, t77.calling_code AS calling_code_88, t77.phone AS phone_89, t77.email AS email_90, t77.web_site AS web_site_91, t77.address AS address_92, t77.city AS city_93, t77.deleted_by_id AS deleted_by_id_94, t77.author_id AS author_id_95, t77.country_id AS country_id_96, t77.state_id AS state_id_97 FROM app_core_user_organization 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 LEFT JOIN app_core_user_actor t57 ON t0.actor_id = t57.id LEFT JOIN app_core_location_contact t77 ON t0.contact_id = t77.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.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.actor_id AS actor_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.lastname AS lastname_68, t57.firstname AS firstname_69, t57.birth_place AS birth_place_70, t57.birth_date AS birth_date_71, t57.gender AS gender_72, t57.deleted_by_id AS deleted_by_id_73, t57.author_id AS author_id_74, t57.access_id AS access_id_75, t0.contact_id AS contact_id_76, t77.id AS id_78, t77.date_add AS date_add_79, t77.date_upd AS date_upd_80, t77.is_deleted AS is_deleted_81, t77.is_locked AS is_locked_82, t77.is_draft AS is_draft_83, t77.can_be_deleted AS can_be_deleted_84, t77.deleted_at AS deleted_at_85, t77.owner_organization_id AS owner_organization_id_86, t77.companies_ids AS companies_ids_87, t77.calling_code AS calling_code_88, t77.phone AS phone_89, t77.email AS email_90, t77.web_site AS web_site_91, t77.address AS address_92, t77.city AS city_93, t77.deleted_by_id AS deleted_by_id_94, t77.author_id AS author_id_95, t77.country_id AS country_id_96, t77.state_id AS state_id_97 FROM app_core_user_organization 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 LEFT JOIN app_core_user_actor t57 ON t0.actor_id = t57.id LEFT JOIN app_core_location_contact t77 ON t0.contact_id = t77.id WHERE t0.id IN (1);
5.72 ms (8.24%)	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: [`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.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 (1);
4.89 ms (7.05%)	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.code AS code_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.country_id AS country_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.is_enabled AS is_enabled_64, t53.currency AS currency_65, t53.iso_code AS iso_code_66, t53.iso_code3 AS iso_code3_67, t53.latitude AS latitude_68, t53.longitude AS longitude_69, t53.geometry_type AS geometry_type_70, t53.calling_code AS calling_code_71, t53.deleted_by_id AS deleted_by_id_72, t53.author_id AS author_id_73, t53.continent_id AS continent_id_74 FROM app_core_location_state 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_location_country t53 ON t0.country_id = t53.id WHERE t0.id IN (?) Parameters: [`3`] 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.code AS code_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.country_id AS country_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.is_enabled AS is_enabled_64, t53.currency AS currency_65, t53.iso_code AS iso_code_66, t53.iso_code3 AS iso_code3_67, t53.latitude AS latitude_68, t53.longitude AS longitude_69, t53.geometry_type AS geometry_type_70, t53.calling_code AS calling_code_71, t53.deleted_by_id AS deleted_by_id_72, t53.author_id AS author_id_73, t53.continent_id AS continent_id_74 FROM app_core_location_state 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_location_country t53 ON t0.country_id = t53.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.code AS code_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.country_id AS country_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.is_enabled AS is_enabled_64, t53.currency AS currency_65, t53.iso_code AS iso_code_66, t53.iso_code3 AS iso_code3_67, t53.latitude AS latitude_68, t53.longitude AS longitude_69, t53.geometry_type AS geometry_type_70, t53.calling_code AS calling_code_71, t53.deleted_by_id AS deleted_by_id_72, t53.author_id AS author_id_73, t53.continent_id AS continent_id_74 FROM app_core_location_state 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_location_country t53 ON t0.country_id = t53.id WHERE t0.id IN (3);
4.31 ms (6.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.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: [`2`] 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 (2);
4.22 ms (6.09%)	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_.duration AS duration_10, a0_.cost AS cost_11, a0_.pictures AS pictures_12, a0_.position AS position_13, a0_.value AS value_14, a0_.isDynamic AS isdynamic_15, a0_.isCustomer AS iscustomer_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.slug AS slug_21, a2_.id AS id_22, a2_.date_add AS date_add_23, a2_.date_upd AS date_upd_24, a2_.is_deleted AS is_deleted_25, a2_.is_locked AS is_locked_26, a2_.is_draft AS is_draft_27, a2_.can_be_deleted AS can_be_deleted_28, a2_.deleted_at AS deleted_at_29, a2_.owner_organization_id AS owner_organization_id_30, a2_.companies_ids AS companies_ids_31, a2_.name AS name_32, a2_.opening_hours AS opening_hours_33, a2_.closing_hours AS closing_hours_34, a2_.is_plateform_manager AS is_plateform_manager_35, a2_.thumbnail_id AS thumbnail_id_36 FROM app_business_service a0_ INNER JOIN app_business_service_i18n a1_ ON a0_.id = a1_.entity_id INNER JOIN app_core_user_organization a2_ ON a0_.organization_id = a2_.id WHERE a0_.is_deleted = false AND a0_.isCustomer = ? ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table Parameters: [`0`] 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_.duration AS duration_10, a0_.cost AS cost_11, a0_.pictures AS pictures_12, a0_.position AS position_13, a0_.value AS value_14, a0_.isDynamic AS isdynamic_15, a0_.isCustomer AS iscustomer_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.slug AS slug_21, a2_.id AS id_22, a2_.date_add AS date_add_23, a2_.date_upd AS date_upd_24, a2_.is_deleted AS is_deleted_25, a2_.is_locked AS is_locked_26, a2_.is_draft AS is_draft_27, a2_.can_be_deleted AS can_be_deleted_28, a2_.deleted_at AS deleted_at_29, a2_.owner_organization_id AS owner_organization_id_30, a2_.companies_ids AS companies_ids_31, a2_.name AS name_32, a2_.opening_hours AS opening_hours_33, a2_.closing_hours AS closing_hours_34, a2_.is_plateform_manager AS is_plateform_manager_35, a2_.thumbnail_id AS thumbnail_id_36 FROM app_business_service a0_ INNER JOIN app_business_service_i18n a1_ ON a0_.id = a1_.entity_id INNER JOIN app_core_user_organization a2_ ON a0_.organization_id = a2_.id WHERE a0_.is_deleted = false AND a0_.isCustomer = ? 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_.duration AS duration_10, a0_.cost AS cost_11, a0_.pictures AS pictures_12, a0_.position AS position_13, a0_.value AS value_14, a0_.isDynamic AS isdynamic_15, a0_.isCustomer AS iscustomer_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.slug AS slug_21, a2_.id AS id_22, a2_.date_add AS date_add_23, a2_.date_upd AS date_upd_24, a2_.is_deleted AS is_deleted_25, a2_.is_locked AS is_locked_26, a2_.is_draft AS is_draft_27, a2_.can_be_deleted AS can_be_deleted_28, a2_.deleted_at AS deleted_at_29, a2_.owner_organization_id AS owner_organization_id_30, a2_.companies_ids AS companies_ids_31, a2_.name AS name_32, a2_.opening_hours AS opening_hours_33, a2_.closing_hours AS closing_hours_34, a2_.is_plateform_manager AS is_plateform_manager_35, a2_.thumbnail_id AS thumbnail_id_36 FROM app_business_service a0_ INNER JOIN app_business_service_i18n a1_ ON a0_.id = a1_.entity_id INNER JOIN app_core_user_organization a2_ ON a0_.organization_id = a2_.id WHERE a0_.is_deleted = false AND a0_.isCustomer = 0 ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table;
3.92 ms (5.65%)	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_core_location_neighborhood_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_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 = 2;
3.73 ms (5.37%)	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.latitude AS latitude_11, t0.longitude AS longitude_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.state_id AS state_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.code AS code_65, t54.deleted_by_id AS deleted_by_id_66, t54.author_id AS author_id_67, t54.country_id AS country_id_68 FROM app_core_location_neighborhood 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_core_location_state t54 ON t0.state_id = t54.id WHERE t0.id IN (?) Parameters: [`2`] 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.latitude AS latitude_11, t0.longitude AS longitude_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.state_id AS state_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.code AS code_65, t54.deleted_by_id AS deleted_by_id_66, t54.author_id AS author_id_67, t54.country_id AS country_id_68 FROM app_core_location_neighborhood 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_core_location_state t54 ON t0.state_id = t54.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.latitude AS latitude_11, t0.longitude AS longitude_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.state_id AS state_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.code AS code_65, t54.deleted_by_id AS deleted_by_id_66, t54.author_id AS author_id_67, t54.country_id AS country_id_68 FROM app_core_location_neighborhood 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_core_location_state t54 ON t0.state_id = t54.id WHERE t0.id IN (2);
3.05 ms (4.40%)	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: [`null`] 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 = NULL;
2.80 ms (4.03%)	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_core_location_state_i18n t0 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 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 = 3;
2.46 ms (3.54%)	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_.duration AS duration_10, a0_.cost AS cost_11, a0_.pictures AS pictures_12, a0_.position AS position_13, a0_.value AS value_14, a0_.isDynamic AS isdynamic_15, a0_.isCustomer AS iscustomer_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.slug AS slug_21, a2_.id AS id_22, a2_.date_add AS date_add_23, a2_.date_upd AS date_upd_24, a2_.is_deleted AS is_deleted_25, a2_.is_locked AS is_locked_26, a2_.is_draft AS is_draft_27, a2_.can_be_deleted AS can_be_deleted_28, a2_.deleted_at AS deleted_at_29, a2_.owner_organization_id AS owner_organization_id_30, a2_.companies_ids AS companies_ids_31, a2_.name AS name_32, a2_.opening_hours AS opening_hours_33, a2_.closing_hours AS closing_hours_34, a2_.is_plateform_manager AS is_plateform_manager_35, a2_.thumbnail_id AS thumbnail_id_36, a0_.deleted_by_id AS deleted_by_id_37, a0_.author_id AS author_id_38, a0_.organization_id AS organization_id_39, a0_.type_id AS type_id_40, a0_.state_id AS state_id_41, a0_.neighborhood_id AS neighborhood_id_42, a1_.entity_id AS entity_id_43, a2_.deleted_by_id AS deleted_by_id_44, a2_.author_id AS author_id_45, a2_.actor_id AS actor_id_46, a2_.contact_id AS contact_id_47 FROM app_business_service a0_ INNER JOIN app_business_service_i18n a1_ ON a0_.id = a1_.entity_id INNER JOIN app_core_user_organization a2_ ON a0_.organization_id = a2_.id WHERE a0_.is_deleted = false AND a0_.isCustomer = ? ORDER BY a0_.date_add DESC Parameters: [`0`] 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_.duration AS duration_10, a0_.cost AS cost_11, a0_.pictures AS pictures_12, a0_.position AS position_13, a0_.value AS value_14, a0_.isDynamic AS isdynamic_15, a0_.isCustomer AS iscustomer_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.slug AS slug_21, a2_.id AS id_22, a2_.date_add AS date_add_23, a2_.date_upd AS date_upd_24, a2_.is_deleted AS is_deleted_25, a2_.is_locked AS is_locked_26, a2_.is_draft AS is_draft_27, a2_.can_be_deleted AS can_be_deleted_28, a2_.deleted_at AS deleted_at_29, a2_.owner_organization_id AS owner_organization_id_30, a2_.companies_ids AS companies_ids_31, a2_.name AS name_32, a2_.opening_hours AS opening_hours_33, a2_.closing_hours AS closing_hours_34, a2_.is_plateform_manager AS is_plateform_manager_35, a2_.thumbnail_id AS thumbnail_id_36, a0_.deleted_by_id AS deleted_by_id_37, a0_.author_id AS author_id_38, a0_.organization_id AS organization_id_39, a0_.type_id AS type_id_40, a0_.state_id AS state_id_41, a0_.neighborhood_id AS neighborhood_id_42, a1_.entity_id AS entity_id_43, a2_.deleted_by_id AS deleted_by_id_44, a2_.author_id AS author_id_45, a2_.actor_id AS actor_id_46, a2_.contact_id AS contact_id_47 FROM app_business_service a0_ INNER JOIN app_business_service_i18n a1_ ON a0_.id = a1_.entity_id INNER JOIN app_core_user_organization a2_ ON a0_.organization_id = a2_.id WHERE a0_.is_deleted = false AND a0_.isCustomer = ? 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_.duration AS duration_10, a0_.cost AS cost_11, a0_.pictures AS pictures_12, a0_.position AS position_13, a0_.value AS value_14, a0_.isDynamic AS isdynamic_15, a0_.isCustomer AS iscustomer_16, a1_.id AS id_17, a1_.locale AS locale_18, a1_.name AS name_19, a1_.description AS description_20, a1_.slug AS slug_21, a2_.id AS id_22, a2_.date_add AS date_add_23, a2_.date_upd AS date_upd_24, a2_.is_deleted AS is_deleted_25, a2_.is_locked AS is_locked_26, a2_.is_draft AS is_draft_27, a2_.can_be_deleted AS can_be_deleted_28, a2_.deleted_at AS deleted_at_29, a2_.owner_organization_id AS owner_organization_id_30, a2_.companies_ids AS companies_ids_31, a2_.name AS name_32, a2_.opening_hours AS opening_hours_33, a2_.closing_hours AS closing_hours_34, a2_.is_plateform_manager AS is_plateform_manager_35, a2_.thumbnail_id AS thumbnail_id_36, a0_.deleted_by_id AS deleted_by_id_37, a0_.author_id AS author_id_38, a0_.organization_id AS organization_id_39, a0_.type_id AS type_id_40, a0_.state_id AS state_id_41, a0_.neighborhood_id AS neighborhood_id_42, a1_.entity_id AS entity_id_43, a2_.deleted_by_id AS deleted_by_id_44, a2_.author_id AS author_id_45, a2_.actor_id AS actor_id_46, a2_.contact_id AS contact_id_47 FROM app_business_service a0_ INNER JOIN app_business_service_i18n a1_ ON a0_.id = a1_.entity_id INNER JOIN app_core_user_organization a2_ ON a0_.organization_id = a2_.id WHERE a0_.is_deleted = false AND a0_.isCustomer = 0 ORDER BY a0_.date_add DESC;
1.92 ms (2.76%)	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, 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: [`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.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 (1);
1.32 ms (1.91%)	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 WHERE t0.id IN (?) Parameters: [`2`] 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 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.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 WHERE t0.id IN (2);
1.09 ms (1.58%)	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.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;
0.93 ms (1.34%)	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, 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: [`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, 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 = 1;
0.89 ms (1.28%)	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: [`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_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 = 2;
0.63 ms (0.91%)	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.iso_code AS iso_code_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 FROM app_core_location_continent 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 WHERE t0.id IN (?) Parameters: [`3`] 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.iso_code AS iso_code_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 FROM app_core_location_continent 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 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.iso_code AS iso_code_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 FROM app_core_location_continent 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 WHERE t0.id IN (3);

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\Workspace	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\Organization	No errors.
App\Core\Entity\User\Access	No errors.
App\Business\Entity\Services	No errors.
App\Core\Entity\AbstractEntityI18n	No errors.
App\Business\Entity\ServicesI18n	No errors.
App\Business\Entity\Type	No errors.
App\Core\Entity\Location\State	No errors.
App\Core\Entity\Location\Neighborhood	No errors.
App\Core\Entity\Location\Contact	No errors.
App\Core\Entity\Attachment	No errors.
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\Business\Entity\BusinessMember	No errors.
App\Core\Entity\Location\Country	No errors.
App\Business\Entity\TypeI18n	No errors.
App\Core\Entity\Location\Continent	No errors.
App\Core\Entity\Location\StateI18n	No errors.
App\Core\Entity\Location\CountryI18n	No errors.
App\Core\Entity\Location\ContinentI18n	No errors.
App\Core\Entity\Location\NeighborhoodI18n	No errors.

Symfony Profiler

GET http://app.facile-car.com/front/services/?currentPage=1&fromDate=&include=type%2Cstate%2Cneighborhood%2Corganization%2Corganization.contact%2Cattachments&number…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping