Query Metrics
16
Database Queries
13
Different statements
24.44 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.02 ms (20.56%) |
1 |
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_upd AS date_upd_3, t0.is_deleted AS is_deleted_4, t0.is_locked AS is_locked_5, t0.is_draft AS is_draft_6, t0.can_be_deleted AS can_be_deleted_7, t0.deleted_at AS deleted_at_8, t0.owner_organization_id AS owner_organization_id_9, t0.companies_ids AS companies_ids_10, t0.lastname AS lastname_11, t0.firstname AS firstname_12, t0.birth_place AS birth_place_13, t0.birth_date AS birth_date_14, t0.gender AS gender_15, t0.deleted_by_id AS deleted_by_id_16, t17.id AS id_18, t17.date_add AS date_add_19, t17.date_upd AS date_upd_20, t17.is_deleted AS is_deleted_21, t17.is_locked AS is_locked_22, t17.is_draft AS is_draft_23, t17.can_be_deleted AS can_be_deleted_24, t17.deleted_at AS deleted_at_25, t17.owner_organization_id AS owner_organization_id_26, t17.companies_ids AS companies_ids_27, t17.lastname AS lastname_28, t17.firstname AS firstname_29, t17.birth_place AS birth_place_30, t17.birth_date AS birth_date_31, t17.gender AS gender_32, t17.deleted_by_id AS deleted_by_id_33, t17.author_id AS author_id_34, t17.access_id AS access_id_35, t0.author_id AS author_id_36, t37.id AS id_38, t37.date_add AS date_add_39, t37.date_upd AS date_upd_40, t37.is_deleted AS is_deleted_41, t37.is_locked AS is_locked_42, t37.is_draft AS is_draft_43, t37.can_be_deleted AS can_be_deleted_44, t37.deleted_at AS deleted_at_45, t37.owner_organization_id AS owner_organization_id_46, t37.companies_ids AS companies_ids_47, t37.lastname AS lastname_48, t37.firstname AS firstname_49, t37.birth_place AS birth_place_50, t37.birth_date AS birth_date_51, t37.gender AS gender_52, t37.deleted_by_id AS deleted_by_id_53, t37.author_id AS author_id_54, t37.access_id AS access_id_55, t0.access_id AS access_id_56, t57.id AS id_58, t57.date_add AS date_add_59, t57.date_upd AS date_upd_60, t57.is_deleted AS is_deleted_61, t57.is_locked AS is_locked_62, t57.is_draft AS is_draft_63, t57.can_be_deleted AS can_be_deleted_64, t57.deleted_at AS deleted_at_65, t57.owner_organization_id AS owner_organization_id_66, t57.companies_ids AS companies_ids_67, t57.email AS email_68, t57.last_connection_date AS last_connection_date_69, t57.token AS token_70, t57.confirmation_token AS confirmation_token_71, t57.context_type AS context_type_72, t57.password AS password_73, t57.is_active AS is_active_74, t57.is_blocked AS is_blocked_75, t57.roles AS roles_76, t57.reset_token_expires_at AS reset_token_expires_at_77, t57.reset_token AS reset_token_78, t57.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_id_80, t81.id AS id_82, t81.date_add AS date_add_83, t81.date_upd AS date_upd_84, t81.is_deleted AS is_deleted_85, t81.is_locked AS is_locked_86, t81.is_draft AS is_draft_87, t81.can_be_deleted AS can_be_deleted_88, t81.deleted_at AS deleted_at_89, t81.owner_organization_id AS owner_organization_id_90, t81.companies_ids AS companies_ids_91, t81.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 FROM app_core_user_actor t0 LEFT JOIN app_core_user_actor t17 ON t0.deleted_by_id = t17.id LEFT JOIN app_core_user_actor t37 ON t0.author_id = t37.id INNER JOIN app_core_user_access t57 ON t0.access_id = t57.id LEFT JOIN app_core_user_collaborator t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.access_id = ?
Parameters:
[
1
]
|
|
3.88 ms (15.87%) |
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
]
|
|
2.18 ms (8.91%) |
1 |
SELECT a0_.id AS id_0, a0_.date_add AS date_add_1, a0_.date_upd AS date_upd_2, a0_.is_deleted AS is_deleted_3, a0_.is_locked AS is_locked_4, a0_.is_draft AS is_draft_5, a0_.can_be_deleted AS can_be_deleted_6, a0_.deleted_at AS deleted_at_7, a0_.owner_organization_id AS owner_organization_id_8, a0_.companies_ids AS companies_ids_9, a0_.email AS email_10, a0_.last_connection_date AS last_connection_date_11, a0_.token AS token_12, a0_.confirmation_token AS confirmation_token_13, a0_.context_type AS context_type_14, a0_.password AS password_15, a0_.is_active AS is_active_16, a0_.is_blocked AS is_blocked_17, a0_.roles AS roles_18, a0_.reset_token_expires_at AS reset_token_expires_at_19, a0_.reset_token AS reset_token_20, a0_.deleted_by_id AS deleted_by_id_21, a0_.author_id AS author_id_22 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = true
Parameters:
[
"nachbi@gmail.com"
]
|
|
2.12 ms (8.69%) |
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
]
|
|
2.02 ms (8.27%) |
1 |
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_upd AS date_upd_3, t0.is_deleted AS is_deleted_4, t0.is_locked AS is_locked_5, t0.is_draft AS is_draft_6, t0.can_be_deleted AS can_be_deleted_7, t0.deleted_at AS deleted_at_8, t0.owner_organization_id AS owner_organization_id_9, t0.companies_ids AS companies_ids_10, t0.lastname AS lastname_11, t0.firstname AS firstname_12, t0.birth_place AS birth_place_13, t0.birth_date AS birth_date_14, t0.gender AS gender_15, t0.deleted_by_id AS deleted_by_id_16, t17.id AS id_18, t17.date_add AS date_add_19, t17.date_upd AS date_upd_20, t17.is_deleted AS is_deleted_21, t17.is_locked AS is_locked_22, t17.is_draft AS is_draft_23, t17.can_be_deleted AS can_be_deleted_24, t17.deleted_at AS deleted_at_25, t17.owner_organization_id AS owner_organization_id_26, t17.companies_ids AS companies_ids_27, t17.lastname AS lastname_28, t17.firstname AS firstname_29, t17.birth_place AS birth_place_30, t17.birth_date AS birth_date_31, t17.gender AS gender_32, t17.deleted_by_id AS deleted_by_id_33, t17.author_id AS author_id_34, t17.access_id AS access_id_35, t0.author_id AS author_id_36, t37.id AS id_38, t37.date_add AS date_add_39, t37.date_upd AS date_upd_40, t37.is_deleted AS is_deleted_41, t37.is_locked AS is_locked_42, t37.is_draft AS is_draft_43, t37.can_be_deleted AS can_be_deleted_44, t37.deleted_at AS deleted_at_45, t37.owner_organization_id AS owner_organization_id_46, t37.companies_ids AS companies_ids_47, t37.lastname AS lastname_48, t37.firstname AS firstname_49, t37.birth_place AS birth_place_50, t37.birth_date AS birth_date_51, t37.gender AS gender_52, t37.deleted_by_id AS deleted_by_id_53, t37.author_id AS author_id_54, t37.access_id AS access_id_55, t0.access_id AS access_id_56, t57.id AS id_58, t57.date_add AS date_add_59, t57.date_upd AS date_upd_60, t57.is_deleted AS is_deleted_61, t57.is_locked AS is_locked_62, t57.is_draft AS is_draft_63, t57.can_be_deleted AS can_be_deleted_64, t57.deleted_at AS deleted_at_65, t57.owner_organization_id AS owner_organization_id_66, t57.companies_ids AS companies_ids_67, t57.email AS email_68, t57.last_connection_date AS last_connection_date_69, t57.token AS token_70, t57.confirmation_token AS confirmation_token_71, t57.context_type AS context_type_72, t57.password AS password_73, t57.is_active AS is_active_74, t57.is_blocked AS is_blocked_75, t57.roles AS roles_76, t57.reset_token_expires_at AS reset_token_expires_at_77, t57.reset_token AS reset_token_78, t57.deleted_by_id AS deleted_by_id_79, t57.author_id AS author_id_80, t81.id AS id_82, t81.date_add AS date_add_83, t81.date_upd AS date_upd_84, t81.is_deleted AS is_deleted_85, t81.is_locked AS is_locked_86, t81.is_draft AS is_draft_87, t81.can_be_deleted AS can_be_deleted_88, t81.deleted_at AS deleted_at_89, t81.owner_organization_id AS owner_organization_id_90, t81.companies_ids AS companies_ids_91, t81.matricule AS matricule_92, t81.position AS position_93, t81.is_blocked AS is_blocked_94, t81.deleted_by_id AS deleted_by_id_95, t81.author_id AS author_id_96, t81.actor_id AS actor_id_97, t81.contact_id AS contact_id_98, t81.organization_id AS organization_id_99, t81.type_id AS type_id_100, t101.id AS id_102, t101.date_add AS date_add_103, t101.date_upd AS date_upd_104, t101.is_deleted AS is_deleted_105, t101.is_locked AS is_locked_106, t101.is_draft AS is_draft_107, t101.can_be_deleted AS can_be_deleted_108, t101.deleted_at AS deleted_at_109, t101.owner_organization_id AS owner_organization_id_110, t101.companies_ids AS companies_ids_111, t101.context_type AS context_type_112, t101.deleted_by_id AS deleted_by_id_113, t101.author_id AS author_id_114, t101.actor_id AS actor_id_115, t101.organization_id AS organization_id_116 FROM app_core_user_actor t0 LEFT JOIN app_core_user_actor t17 ON t0.deleted_by_id = t17.id LEFT JOIN app_core_user_actor t37 ON t0.author_id = t37.id INNER JOIN app_core_user_access t57 ON t0.access_id = t57.id LEFT JOIN app_core_user_collaborator t81 ON t81.actor_id = t0.id LEFT JOIN app_core_user_workspace t101 ON t101.actor_id = t0.id WHERE t0.id IN (?)
Parameters:
[
3
]
|
|
1.93 ms (7.89%) |
1 |
SELECT a0_.id AS id_0, a0_.date_add AS date_add_1, a0_.date_upd AS date_upd_2, a0_.is_deleted AS is_deleted_3, a0_.is_locked AS is_locked_4, a0_.is_draft AS is_draft_5, a0_.can_be_deleted AS can_be_deleted_6, a0_.deleted_at AS deleted_at_7, a0_.owner_organization_id AS owner_organization_id_8, a0_.companies_ids AS companies_ids_9, a1_.id AS id_10, a1_.date_add AS date_add_11, a1_.date_upd AS date_upd_12, a1_.is_deleted AS is_deleted_13, a1_.is_locked AS is_locked_14, a1_.is_draft AS is_draft_15, a1_.can_be_deleted AS can_be_deleted_16, a1_.deleted_at AS deleted_at_17, a1_.owner_organization_id AS owner_organization_id_18, a1_.companies_ids AS companies_ids_19, a1_.name AS name_20, a1_.description AS description_21, a1_.is_default AS is_default_22, a1_.code AS code_23, a2_.id AS id_24, a2_.date_add AS date_add_25, a2_.date_upd AS date_upd_26, a2_.is_deleted AS is_deleted_27, a2_.is_locked AS is_locked_28, a2_.is_draft AS is_draft_29, a2_.can_be_deleted AS can_be_deleted_30, a2_.deleted_at AS deleted_at_31, a2_.owner_organization_id AS owner_organization_id_32, a2_.companies_ids AS companies_ids_33, a2_.key_rule AS key_rule_34, a2_.key_group AS key_group_35, a0_.deleted_by_id AS deleted_by_id_36, a0_.author_id AS author_id_37, a0_.collaborator_id AS collaborator_id_38, a1_.deleted_by_id AS deleted_by_id_39, a1_.author_id AS author_id_40, a1_.organization_id AS organization_id_41, a2_.deleted_by_id AS deleted_by_id_42, a2_.author_id AS author_id_43, a2_.role_id AS role_id_44 FROM app_business_all_member a0_ INNER JOIN app_business_member_role a3_ ON a0_.id = a3_.member_id INNER JOIN app_business_all_role a1_ ON a1_.id = a3_.role_id LEFT JOIN app_business_roles_authorization a2_ ON a1_.id = a2_.role_id WHERE a0_.collaborator_id = ?
Parameters:
[
1
]
|
|
1.92 ms (7.84%) |
1 |
SELECT DISTINCT id_0, MIN(sclr_15) 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, a1_.id AS id_10, a1_.locale AS locale_11, a1_.name AS name_12, a1_.description AS description_13, a1_.slug AS slug_14, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_15 FROM app_business_vehicleType a0_ INNER JOIN app_business_vehicleType_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 100
Parameters:
[] |
|
1.55 ms (6.33%) |
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
]
|
|
1.32 ms (5.41%) |
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:
[
1
]
|
|
0.72 ms (2.96%) |
1 |
SELECT a0_.id AS id_0, a0_.date_add AS date_add_1, a0_.date_upd AS date_upd_2, a0_.is_deleted AS is_deleted_3, a0_.is_locked AS is_locked_4, a0_.is_draft AS is_draft_5, a0_.can_be_deleted AS can_be_deleted_6, a0_.deleted_at AS deleted_at_7, a0_.owner_organization_id AS owner_organization_id_8, a0_.companies_ids AS companies_ids_9, a1_.id AS id_10, a1_.locale AS locale_11, a1_.name AS name_12, a1_.description AS description_13, a1_.slug AS slug_14, a0_.deleted_by_id AS deleted_by_id_15, a0_.author_id AS author_id_16, a1_.entity_id AS entity_id_17 FROM app_business_vehicleType a0_ INNER JOIN app_business_vehicleType_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false AND a0_.id IN (?, ?) ORDER BY a0_.date_add DESC
Parameters:
[ 2 1 ] |
|
0.66 ms (2.70%) |
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, a1_.id AS id_10, a1_.locale AS locale_11, a1_.name AS name_12, a1_.description AS description_13, a1_.slug AS slug_14 FROM app_business_vehicleType a0_ INNER JOIN app_business_vehicleType_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.is_deleted = false ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.57 ms (2.32%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6, t7.id AS id_8, t7.date_add AS date_add_9, t7.date_upd AS date_upd_10, t7.is_deleted AS is_deleted_11, t7.is_locked AS is_locked_12, t7.is_draft AS is_draft_13, t7.can_be_deleted AS can_be_deleted_14, t7.deleted_at AS deleted_at_15, t7.owner_organization_id AS owner_organization_id_16, t7.companies_ids AS companies_ids_17, t7.iso_code AS iso_code_18, t7.deleted_by_id AS deleted_by_id_19, t7.author_id AS author_id_20 FROM app_core_location_continent_i18n t0 INNER JOIN app_core_location_continent t7 ON t0.entity_id = t7.id WHERE t0.entity_id = ?
Parameters:
[
1
]
|
|
0.55 ms (2.26%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.official_name AS official_name_6, t0.entity_id AS entity_id_7 FROM app_core_location_country_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
2
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Core\Entity\AbstractEntity | No errors. |
| App\Core\Entity\User\Access | No errors. |
| App\Core\Entity\User\Actor |
|
| App\Core\Entity\User\Collaborator |
|
| App\Core\Entity\Location\Contact | No errors. |
| App\Core\Entity\User\Organization | No errors. |
| App\Business\Entity\Type | No errors. |
| App\Core\Entity\User\Workspace | No errors. |
| App\Business\Entity\BusinessMember | No errors. |
| App\Core\Entity\Location\Country | No errors. |
| App\Core\Entity\Location\State | No errors. |
| App\Business\Entity\BusinessRole | No errors. |
| App\Business\Entity\BusinessRoleAuthorization | No errors. |
| App\Business\Entity\VehicleType | No errors. |
| App\Core\Entity\AbstractEntityI18n | No errors. |
| App\Business\Entity\VehicleTypeI18n | No errors. |
| App\Core\Entity\Location\Continent | No errors. |
| App\Core\Entity\Location\CountryI18n | No errors. |
| App\Core\Entity\Location\ContinentI18n | No errors. |