Query Metrics
27
Database Queries
22
Different statements
37.07 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.61 ms (25.93%) |
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
]
|
|
2.89 ms (7.81%) |
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
]
|
|
2.85 ms (7.68%) |
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.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.35 ms (6.33%) |
1 |
SELECT DISTINCT id_0, MIN(sclr_65) 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_.collaboratorId AS collaboratorid_10, a0_.date AS date_11, a0_.status AS status_12, a0_.customerId AS customerid_13, a0_.dynamicFields AS dynamicfields_14, a0_.hours AS hours_15, a0_.type AS type_16, a0_.cost AS cost_17, a1_.id AS id_18, a1_.date_add AS date_add_19, a1_.date_upd AS date_upd_20, a1_.is_deleted AS is_deleted_21, a1_.is_locked AS is_locked_22, a1_.is_draft AS is_draft_23, a1_.can_be_deleted AS can_be_deleted_24, a1_.deleted_at AS deleted_at_25, a1_.owner_organization_id AS owner_organization_id_26, a1_.companies_ids AS companies_ids_27, a1_.name AS name_28, a1_.opening_hours AS opening_hours_29, a1_.closing_hours AS closing_hours_30, a1_.is_plateform_manager AS is_plateform_manager_31, a1_.thumbnail_id AS thumbnail_id_32, a2_.id AS id_33, a2_.date_add AS date_add_34, a2_.date_upd AS date_upd_35, a2_.is_deleted AS is_deleted_36, a2_.is_locked AS is_locked_37, a2_.is_draft AS is_draft_38, a2_.can_be_deleted AS can_be_deleted_39, a2_.deleted_at AS deleted_at_40, a2_.owner_organization_id AS owner_organization_id_41, a2_.companies_ids AS companies_ids_42, a2_.duration AS duration_43, a2_.cost AS cost_44, a2_.pictures AS pictures_45, a2_.position AS position_46, a2_.value AS value_47, a2_.isDynamic AS isdynamic_48, a2_.isCustomer AS iscustomer_49, a3_.id AS id_50, a3_.date_add AS date_add_51, a3_.date_upd AS date_upd_52, a3_.is_deleted AS is_deleted_53, a3_.is_locked AS is_locked_54, a3_.is_draft AS is_draft_55, a3_.can_be_deleted AS can_be_deleted_56, a3_.deleted_at AS deleted_at_57, a3_.owner_organization_id AS owner_organization_id_58, a3_.companies_ids AS companies_ids_59, a3_.name AS name_60, a3_.opening_hours AS opening_hours_61, a3_.closing_hours AS closing_hours_62, a3_.is_plateform_manager AS is_plateform_manager_63, a3_.thumbnail_id AS thumbnail_id_64, ROW_NUMBER() OVER(ORDER BY a0_.date_add DESC) AS sclr_65 FROM app_business_reservation a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id INNER JOIN app_business_service a2_ ON a0_.service_id = a2_.id INNER JOIN app_core_user_organization a3_ ON a2_.organization_id = a3_.id WHERE a0_.is_deleted = false AND (a1_.id = ? OR a3_.id = ? OR a0_.companies_ids LIKE ?)) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 1
Parameters:
[ 1 1 "%i:1;%" ] |
|
2.20 ms (5.95%) |
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.17 ms (5.84%) |
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
]
|
|
1.70 ms (4.59%) |
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.calling_code AS calling_code_11, t0.phone AS phone_12, t0.email AS email_13, t0.web_site AS web_site_14, t0.address AS address_15, t0.city AS city_16, t0.deleted_by_id AS deleted_by_id_17, t18.id AS id_19, t18.date_add AS date_add_20, t18.date_upd AS date_upd_21, t18.is_deleted AS is_deleted_22, t18.is_locked AS is_locked_23, t18.is_draft AS is_draft_24, t18.can_be_deleted AS can_be_deleted_25, t18.deleted_at AS deleted_at_26, t18.owner_organization_id AS owner_organization_id_27, t18.companies_ids AS companies_ids_28, t18.lastname AS lastname_29, t18.firstname AS firstname_30, t18.birth_place AS birth_place_31, t18.birth_date AS birth_date_32, t18.gender AS gender_33, t18.deleted_by_id AS deleted_by_id_34, t18.author_id AS author_id_35, t18.access_id AS access_id_36, t0.author_id AS author_id_37, t38.id AS id_39, t38.date_add AS date_add_40, t38.date_upd AS date_upd_41, t38.is_deleted AS is_deleted_42, t38.is_locked AS is_locked_43, t38.is_draft AS is_draft_44, t38.can_be_deleted AS can_be_deleted_45, t38.deleted_at AS deleted_at_46, t38.owner_organization_id AS owner_organization_id_47, t38.companies_ids AS companies_ids_48, t38.lastname AS lastname_49, t38.firstname AS firstname_50, t38.birth_place AS birth_place_51, t38.birth_date AS birth_date_52, t38.gender AS gender_53, t38.deleted_by_id AS deleted_by_id_54, t38.author_id AS author_id_55, t38.access_id AS access_id_56, t0.country_id AS country_id_57, t58.id AS id_59, t58.date_add AS date_add_60, t58.date_upd AS date_upd_61, t58.is_deleted AS is_deleted_62, t58.is_locked AS is_locked_63, t58.is_draft AS is_draft_64, t58.can_be_deleted AS can_be_deleted_65, t58.deleted_at AS deleted_at_66, t58.owner_organization_id AS owner_organization_id_67, t58.companies_ids AS companies_ids_68, t58.is_enabled AS is_enabled_69, t58.currency AS currency_70, t58.iso_code AS iso_code_71, t58.iso_code3 AS iso_code3_72, t58.latitude AS latitude_73, t58.longitude AS longitude_74, t58.geometry_type AS geometry_type_75, t58.calling_code AS calling_code_76, t58.deleted_by_id AS deleted_by_id_77, t58.author_id AS author_id_78, t58.continent_id AS continent_id_79, t0.state_id AS state_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.code AS code_92, t81.deleted_by_id AS deleted_by_id_93, t81.author_id AS author_id_94, t81.country_id AS country_id_95 FROM app_core_location_contact t0 LEFT JOIN app_core_user_actor t18 ON t0.deleted_by_id = t18.id LEFT JOIN app_core_user_actor t38 ON t0.author_id = t38.id LEFT JOIN app_core_location_country t58 ON t0.country_id = t58.id LEFT JOIN app_core_location_state t81 ON t0.state_id = t81.id WHERE t0.id IN (?)
Parameters:
[
4
]
|
|
1.69 ms (4.57%) |
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.30 ms (3.50%) |
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.iso_code AS iso_code_11, t0.deleted_by_id AS deleted_by_id_12, t13.id AS id_14, t13.date_add AS date_add_15, t13.date_upd AS date_upd_16, t13.is_deleted AS is_deleted_17, t13.is_locked AS is_locked_18, t13.is_draft AS is_draft_19, t13.can_be_deleted AS can_be_deleted_20, t13.deleted_at AS deleted_at_21, t13.owner_organization_id AS owner_organization_id_22, t13.companies_ids AS companies_ids_23, t13.lastname AS lastname_24, t13.firstname AS firstname_25, t13.birth_place AS birth_place_26, t13.birth_date AS birth_date_27, t13.gender AS gender_28, t13.deleted_by_id AS deleted_by_id_29, t13.author_id AS author_id_30, t13.access_id AS access_id_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.date_add AS date_add_35, t33.date_upd AS date_upd_36, t33.is_deleted AS is_deleted_37, t33.is_locked AS is_locked_38, t33.is_draft AS is_draft_39, t33.can_be_deleted AS can_be_deleted_40, t33.deleted_at AS deleted_at_41, t33.owner_organization_id AS owner_organization_id_42, t33.companies_ids AS companies_ids_43, t33.lastname AS lastname_44, t33.firstname AS firstname_45, t33.birth_place AS birth_place_46, t33.birth_date AS birth_date_47, t33.gender AS gender_48, t33.deleted_by_id AS deleted_by_id_49, t33.author_id AS author_id_50, t33.access_id AS access_id_51 FROM app_core_location_continent t0 LEFT JOIN app_core_user_actor t13 ON t0.deleted_by_id = t13.id LEFT JOIN app_core_user_actor t33 ON t0.author_id = t33.id WHERE t0.id IN (?)
Parameters:
[
1
]
|
|
1.26 ms (3.39%) |
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.filename AS filename_11, t0.original_name AS original_name_12, t0.hash AS hash_13, t0.extension AS extension_14, t0.size AS size_15, t0.is_temporary AS is_temporary_16, t0.deleted_by_id AS deleted_by_id_17, t18.id AS id_19, t18.date_add AS date_add_20, t18.date_upd AS date_upd_21, t18.is_deleted AS is_deleted_22, t18.is_locked AS is_locked_23, t18.is_draft AS is_draft_24, t18.can_be_deleted AS can_be_deleted_25, t18.deleted_at AS deleted_at_26, t18.owner_organization_id AS owner_organization_id_27, t18.companies_ids AS companies_ids_28, t18.lastname AS lastname_29, t18.firstname AS firstname_30, t18.birth_place AS birth_place_31, t18.birth_date AS birth_date_32, t18.gender AS gender_33, t18.deleted_by_id AS deleted_by_id_34, t18.author_id AS author_id_35, t18.access_id AS access_id_36, t0.author_id AS author_id_37, t38.id AS id_39, t38.date_add AS date_add_40, t38.date_upd AS date_upd_41, t38.is_deleted AS is_deleted_42, t38.is_locked AS is_locked_43, t38.is_draft AS is_draft_44, t38.can_be_deleted AS can_be_deleted_45, t38.deleted_at AS deleted_at_46, t38.owner_organization_id AS owner_organization_id_47, t38.companies_ids AS companies_ids_48, t38.lastname AS lastname_49, t38.firstname AS firstname_50, t38.birth_place AS birth_place_51, t38.birth_date AS birth_date_52, t38.gender AS gender_53, t38.deleted_by_id AS deleted_by_id_54, t38.author_id AS author_id_55, t38.access_id AS access_id_56 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t18 ON t0.deleted_by_id = t18.id LEFT JOIN app_core_user_actor t38 ON t0.author_id = t38.id INNER JOIN app_business_service_attachment ON t0.id = app_business_service_attachment.service_attachment_id WHERE app_business_service_attachment.service_id = ?
Parameters:
[
8
]
|
|
1.20 ms (3.24%) |
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
]
|
|
1.11 ms (2.99%) |
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_.collaboratorId AS collaboratorid_10, a0_.date AS date_11, a0_.status AS status_12, a0_.customerId AS customerid_13, a0_.dynamicFields AS dynamicfields_14, a0_.hours AS hours_15, a0_.type AS type_16, a0_.cost AS cost_17, a1_.id AS id_18, a1_.date_add AS date_add_19, a1_.date_upd AS date_upd_20, a1_.is_deleted AS is_deleted_21, a1_.is_locked AS is_locked_22, a1_.is_draft AS is_draft_23, a1_.can_be_deleted AS can_be_deleted_24, a1_.deleted_at AS deleted_at_25, a1_.owner_organization_id AS owner_organization_id_26, a1_.companies_ids AS companies_ids_27, a1_.name AS name_28, a1_.opening_hours AS opening_hours_29, a1_.closing_hours AS closing_hours_30, a1_.is_plateform_manager AS is_plateform_manager_31, a1_.thumbnail_id AS thumbnail_id_32, a2_.id AS id_33, a2_.date_add AS date_add_34, a2_.date_upd AS date_upd_35, a2_.is_deleted AS is_deleted_36, a2_.is_locked AS is_locked_37, a2_.is_draft AS is_draft_38, a2_.can_be_deleted AS can_be_deleted_39, a2_.deleted_at AS deleted_at_40, a2_.owner_organization_id AS owner_organization_id_41, a2_.companies_ids AS companies_ids_42, a2_.duration AS duration_43, a2_.cost AS cost_44, a2_.pictures AS pictures_45, a2_.position AS position_46, a2_.value AS value_47, a2_.isDynamic AS isdynamic_48, a2_.isCustomer AS iscustomer_49, a3_.id AS id_50, a3_.date_add AS date_add_51, a3_.date_upd AS date_upd_52, a3_.is_deleted AS is_deleted_53, a3_.is_locked AS is_locked_54, a3_.is_draft AS is_draft_55, a3_.can_be_deleted AS can_be_deleted_56, a3_.deleted_at AS deleted_at_57, a3_.owner_organization_id AS owner_organization_id_58, a3_.companies_ids AS companies_ids_59, a3_.name AS name_60, a3_.opening_hours AS opening_hours_61, a3_.closing_hours AS closing_hours_62, a3_.is_plateform_manager AS is_plateform_manager_63, a3_.thumbnail_id AS thumbnail_id_64, a0_.deleted_by_id AS deleted_by_id_65, a0_.author_id AS author_id_66, a0_.service_id AS service_id_67, a0_.organization_id AS organization_id_68, a0_.vehicle_type_id AS vehicle_type_id_69, a1_.deleted_by_id AS deleted_by_id_70, a1_.author_id AS author_id_71, a1_.actor_id AS actor_id_72, a1_.contact_id AS contact_id_73, a2_.deleted_by_id AS deleted_by_id_74, a2_.author_id AS author_id_75, a2_.organization_id AS organization_id_76, a2_.type_id AS type_id_77, a2_.state_id AS state_id_78, a2_.neighborhood_id AS neighborhood_id_79, a3_.deleted_by_id AS deleted_by_id_80, a3_.author_id AS author_id_81, a3_.actor_id AS actor_id_82, a3_.contact_id AS contact_id_83 FROM app_business_reservation a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id INNER JOIN app_business_service a2_ ON a0_.service_id = a2_.id INNER JOIN app_core_user_organization a3_ ON a2_.organization_id = a3_.id WHERE a0_.is_deleted = false AND (a1_.id = ? OR a3_.id = ? OR a0_.companies_ids LIKE ?) AND a0_.id IN (?) ORDER BY a0_.date_add DESC
Parameters:
[ 1 1 "%i:1;%" 7 ] |
|
1.07 ms (2.89%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.date_add AS date_add_1, a0_.date_upd AS date_upd_2, a0_.is_deleted AS is_deleted_3, a0_.is_locked AS is_locked_4, a0_.is_draft AS is_draft_5, a0_.can_be_deleted AS can_be_deleted_6, a0_.deleted_at AS deleted_at_7, a0_.owner_organization_id AS owner_organization_id_8, a0_.companies_ids AS companies_ids_9, a0_.collaboratorId AS collaboratorid_10, a0_.date AS date_11, a0_.status AS status_12, a0_.customerId AS customerid_13, a0_.dynamicFields AS dynamicfields_14, a0_.hours AS hours_15, a0_.type AS type_16, a0_.cost AS cost_17, a1_.id AS id_18, a1_.date_add AS date_add_19, a1_.date_upd AS date_upd_20, a1_.is_deleted AS is_deleted_21, a1_.is_locked AS is_locked_22, a1_.is_draft AS is_draft_23, a1_.can_be_deleted AS can_be_deleted_24, a1_.deleted_at AS deleted_at_25, a1_.owner_organization_id AS owner_organization_id_26, a1_.companies_ids AS companies_ids_27, a1_.name AS name_28, a1_.opening_hours AS opening_hours_29, a1_.closing_hours AS closing_hours_30, a1_.is_plateform_manager AS is_plateform_manager_31, a1_.thumbnail_id AS thumbnail_id_32, a2_.id AS id_33, a2_.date_add AS date_add_34, a2_.date_upd AS date_upd_35, a2_.is_deleted AS is_deleted_36, a2_.is_locked AS is_locked_37, a2_.is_draft AS is_draft_38, a2_.can_be_deleted AS can_be_deleted_39, a2_.deleted_at AS deleted_at_40, a2_.owner_organization_id AS owner_organization_id_41, a2_.companies_ids AS companies_ids_42, a2_.duration AS duration_43, a2_.cost AS cost_44, a2_.pictures AS pictures_45, a2_.position AS position_46, a2_.value AS value_47, a2_.isDynamic AS isdynamic_48, a2_.isCustomer AS iscustomer_49, a3_.id AS id_50, a3_.date_add AS date_add_51, a3_.date_upd AS date_upd_52, a3_.is_deleted AS is_deleted_53, a3_.is_locked AS is_locked_54, a3_.is_draft AS is_draft_55, a3_.can_be_deleted AS can_be_deleted_56, a3_.deleted_at AS deleted_at_57, a3_.owner_organization_id AS owner_organization_id_58, a3_.companies_ids AS companies_ids_59, a3_.name AS name_60, a3_.opening_hours AS opening_hours_61, a3_.closing_hours AS closing_hours_62, a3_.is_plateform_manager AS is_plateform_manager_63, a3_.thumbnail_id AS thumbnail_id_64 FROM app_business_reservation a0_ INNER JOIN app_core_user_organization a1_ ON a0_.organization_id = a1_.id INNER JOIN app_business_service a2_ ON a0_.service_id = a2_.id INNER JOIN app_core_user_organization a3_ ON a2_.organization_id = a3_.id WHERE a0_.is_deleted = false AND (a1_.id = ? OR a3_.id = ? OR a0_.companies_ids LIKE ?) ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table
Parameters:
[ 1 1 "%i:1;%" ] |
|
0.84 ms (2.26%) |
2 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6, t7.id AS id_8, t7.date_add AS date_add_9, t7.date_upd AS date_upd_10, t7.is_deleted AS is_deleted_11, t7.is_locked AS is_locked_12, t7.is_draft AS is_draft_13, t7.can_be_deleted AS can_be_deleted_14, t7.deleted_at AS deleted_at_15, t7.owner_organization_id AS owner_organization_id_16, t7.companies_ids AS companies_ids_17, t7.iso_code AS iso_code_18, t7.deleted_by_id AS deleted_by_id_19, t7.author_id AS author_id_20 FROM app_core_location_continent_i18n t0 INNER JOIN app_core_location_continent t7 ON t0.entity_id = t7.id WHERE t0.entity_id = ?
Parameters:
[
1
]
|
|
0.79 ms (2.13%) |
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.deleted_by_id AS deleted_by_id_11, t12.id AS id_13, t12.date_add AS date_add_14, t12.date_upd AS date_upd_15, t12.is_deleted AS is_deleted_16, t12.is_locked AS is_locked_17, t12.is_draft AS is_draft_18, t12.can_be_deleted AS can_be_deleted_19, t12.deleted_at AS deleted_at_20, t12.owner_organization_id AS owner_organization_id_21, t12.companies_ids AS companies_ids_22, t12.lastname AS lastname_23, t12.firstname AS firstname_24, t12.birth_place AS birth_place_25, t12.birth_date AS birth_date_26, t12.gender AS gender_27, t12.deleted_by_id AS deleted_by_id_28, t12.author_id AS author_id_29, t12.access_id AS access_id_30, t0.author_id AS author_id_31, t32.id AS id_33, t32.date_add AS date_add_34, t32.date_upd AS date_upd_35, t32.is_deleted AS is_deleted_36, t32.is_locked AS is_locked_37, t32.is_draft AS is_draft_38, t32.can_be_deleted AS can_be_deleted_39, t32.deleted_at AS deleted_at_40, t32.owner_organization_id AS owner_organization_id_41, t32.companies_ids AS companies_ids_42, t32.lastname AS lastname_43, t32.firstname AS firstname_44, t32.birth_place AS birth_place_45, t32.birth_date AS birth_date_46, t32.gender AS gender_47, t32.deleted_by_id AS deleted_by_id_48, t32.author_id AS author_id_49, t32.access_id AS access_id_50 FROM app_business_type t0 LEFT JOIN app_core_user_actor t12 ON t0.deleted_by_id = t12.id LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id WHERE t0.id IN (?)
Parameters:
[
2
]
|
|
0.76 ms (2.04%) |
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.deleted_by_id AS deleted_by_id_11, t12.id AS id_13, t12.date_add AS date_add_14, t12.date_upd AS date_upd_15, t12.is_deleted AS is_deleted_16, t12.is_locked AS is_locked_17, t12.is_draft AS is_draft_18, t12.can_be_deleted AS can_be_deleted_19, t12.deleted_at AS deleted_at_20, t12.owner_organization_id AS owner_organization_id_21, t12.companies_ids AS companies_ids_22, t12.lastname AS lastname_23, t12.firstname AS firstname_24, t12.birth_place AS birth_place_25, t12.birth_date AS birth_date_26, t12.gender AS gender_27, t12.deleted_by_id AS deleted_by_id_28, t12.author_id AS author_id_29, t12.access_id AS access_id_30, t0.author_id AS author_id_31, t32.id AS id_33, t32.date_add AS date_add_34, t32.date_upd AS date_upd_35, t32.is_deleted AS is_deleted_36, t32.is_locked AS is_locked_37, t32.is_draft AS is_draft_38, t32.can_be_deleted AS can_be_deleted_39, t32.deleted_at AS deleted_at_40, t32.owner_organization_id AS owner_organization_id_41, t32.companies_ids AS companies_ids_42, t32.lastname AS lastname_43, t32.firstname AS firstname_44, t32.birth_place AS birth_place_45, t32.birth_date AS birth_date_46, t32.gender AS gender_47, t32.deleted_by_id AS deleted_by_id_48, t32.author_id AS author_id_49, t32.access_id AS access_id_50 FROM app_business_vehicleType t0 LEFT JOIN app_core_user_actor t12 ON t0.deleted_by_id = t12.id LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id WHERE t0.id IN (?)
Parameters:
[
2
]
|
|
0.75 ms (2.03%) |
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.code AS code_11, t0.deleted_by_id AS deleted_by_id_12, t13.id AS id_14, t13.date_add AS date_add_15, t13.date_upd AS date_upd_16, t13.is_deleted AS is_deleted_17, t13.is_locked AS is_locked_18, t13.is_draft AS is_draft_19, t13.can_be_deleted AS can_be_deleted_20, t13.deleted_at AS deleted_at_21, t13.owner_organization_id AS owner_organization_id_22, t13.companies_ids AS companies_ids_23, t13.lastname AS lastname_24, t13.firstname AS firstname_25, t13.birth_place AS birth_place_26, t13.birth_date AS birth_date_27, t13.gender AS gender_28, t13.deleted_by_id AS deleted_by_id_29, t13.author_id AS author_id_30, t13.access_id AS access_id_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.date_add AS date_add_35, t33.date_upd AS date_upd_36, t33.is_deleted AS is_deleted_37, t33.is_locked AS is_locked_38, t33.is_draft AS is_draft_39, t33.can_be_deleted AS can_be_deleted_40, t33.deleted_at AS deleted_at_41, t33.owner_organization_id AS owner_organization_id_42, t33.companies_ids AS companies_ids_43, t33.lastname AS lastname_44, t33.firstname AS firstname_45, t33.birth_place AS birth_place_46, t33.birth_date AS birth_date_47, t33.gender AS gender_48, t33.deleted_by_id AS deleted_by_id_49, t33.author_id AS author_id_50, t33.access_id AS access_id_51, t0.country_id AS country_id_52, t53.id AS id_54, t53.date_add AS date_add_55, t53.date_upd AS date_upd_56, t53.is_deleted AS is_deleted_57, t53.is_locked AS is_locked_58, t53.is_draft AS is_draft_59, t53.can_be_deleted AS can_be_deleted_60, t53.deleted_at AS deleted_at_61, t53.owner_organization_id AS owner_organization_id_62, t53.companies_ids AS companies_ids_63, t53.is_enabled AS is_enabled_64, t53.currency AS currency_65, t53.iso_code AS iso_code_66, t53.iso_code3 AS iso_code3_67, t53.latitude AS latitude_68, t53.longitude AS longitude_69, t53.geometry_type AS geometry_type_70, t53.calling_code AS calling_code_71, t53.deleted_by_id AS deleted_by_id_72, t53.author_id AS author_id_73, t53.continent_id AS continent_id_74 FROM app_core_location_state t0 LEFT JOIN app_core_user_actor t13 ON t0.deleted_by_id = t13.id LEFT JOIN app_core_user_actor t33 ON t0.author_id = t33.id INNER JOIN app_core_location_country t53 ON t0.country_id = t53.id WHERE t0.id IN (?)
Parameters:
[
3
]
|
|
0.59 ms (1.58%) |
2 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.official_name AS official_name_6, t0.entity_id AS entity_id_7 FROM app_core_location_country_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
2
]
|
|
0.55 ms (1.49%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6 FROM app_business_type_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
2
]
|
|
0.51 ms (1.36%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6 FROM app_business_vehicleType_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
2
]
|
|
0.46 ms (1.25%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6 FROM app_core_location_state_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
3
]
|
|
0.42 ms (1.15%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.entity_id AS entity_id_6 FROM app_business_service_i18n t0 WHERE t0.entity_id = ?
Parameters:
[
8
]
|
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\Reservation | No errors. |
| App\Business\Entity\Services | No errors. |
| App\Business\Entity\VehicleType | No errors. |
| App\Core\Entity\Location\Neighborhood | No errors. |
| App\Core\Entity\Attachment | 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. |
| App\Business\Entity\ServicesI18n | No errors. |
| App\Business\Entity\TypeI18n | No errors. |
| App\Core\Entity\Location\StateI18n | No errors. |