Symfony Profiler

Query Metrics

14 Database Queries

10 Different statements

23.36 ms Query time

2 Invalid entities

Queries


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 = ?
SELECT DISTINCT id_0, MIN(sclr_16) 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_16 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10
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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, a0_.deleted_by_id AS deleted_by_id_16, a0_.author_id AS author_id_17, a0_.country_id AS country_id_18, a1_.entity_id AS entity_id_19 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false AND a0_.id IN (?, ?, ?) ORDER BY a0_.date_add DESC
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.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.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.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.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.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.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.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.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 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table

#▲	Time	Info
1	3.66 ms	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	0.69 ms	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;
3	2.42 ms	SELECT DISTINCT id_0, MIN(sclr_16) 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_16 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_0, MIN(sclr_16) 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, ROW_NUMBER() OVER( ORDER BY a0_.date_add DESC ) AS sclr_16 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false ) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10 SELECT DISTINCT id_0, MIN(sclr_16) 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_16 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10;
4	0.93 ms	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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, a0_.deleted_by_id AS deleted_by_id_16, a0_.author_id AS author_id_17, a0_.country_id AS country_id_18, a1_.entity_id AS entity_id_19 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false AND a0_.id IN (?, ?, ?) ORDER BY a0_.date_add DESC Parameters: [`4 3 2`] 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, a0_.deleted_by_id AS deleted_by_id_16, a0_.author_id AS author_id_17, a0_.country_id AS country_id_18, a1_.entity_id AS entity_id_19 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, a0_.deleted_by_id AS deleted_by_id_16, a0_.author_id AS author_id_17, a0_.country_id AS country_id_18, a1_.entity_id AS entity_id_19 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false AND a0_.id IN (4, 3, 2) ORDER BY a0_.date_add DESC;
5	4.89 ms	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: [`3 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 (3, 1);
6	3.36 ms	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 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.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, 2);
7	2.10 ms	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);
8	0.56 ms	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: [`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.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 = 2;
9	1.66 ms	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 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.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, 3);
10	0.72 ms	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;
11	0.76 ms	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);
12	0.28 ms	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;
13	0.42 ms	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;
14	0.90 ms	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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table Parameters: [] 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false 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_.code AS code_10, a1_.id AS id_11, a1_.locale AS locale_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15 FROM app_core_location_state a0_ INNER JOIN app_core_location_state_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table;

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\Core\Entity\Location\State	No errors.
App\Core\Entity\AbstractEntityI18n	No errors.
App\Core\Entity\Location\StateI18n	No errors.
App\Core\Entity\Location\Country	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\Core\Entity\Location\Contact	No errors.
App\Business\Entity\Type	No errors.
App\Business\Entity\BusinessMember	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/front/location/states/?pagination=false

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping