GET http://app.facile-car.com/api/business/vehicle-types/?currentPage=1&fromDate=&numberPerPage=100&query=&toDate=

Response
200 OK
Browse referrer URL
IP
172.17.0.1
Profiled on
Token
b90570

Query Metrics

16 Database Queries
13 Different statements
24.44 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.18 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_.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"
]
View formatted query    View runnable query    Explain query
2 5.02 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.access_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 2.56 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
]
View formatted query    View runnable query    Explain query
4 1.14 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
]
View formatted query    View runnable query    Explain query
5 0.57 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: 
[
  1
]
View formatted query    View runnable query    Explain query
6 0.76 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: 
[
  1
]
View formatted query    View runnable query    Explain query
7 1.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, 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
]
View formatted query    View runnable query    Explain query
8 1.92 ms 
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: 
[]
View formatted query    View runnable query    Explain query
9 0.72 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, 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
]
View formatted query    View runnable query    Explain query
10 2.02 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
]
View formatted query    View runnable query    Explain query
11 1.32 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: 
[
  2
]
View formatted query    View runnable query    Explain query
12 1.55 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
13 0.55 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
14 0.99 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: 
[
  3
]
View formatted query    View runnable query    Explain query
15 0.57 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
16 0.66 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, 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: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Core\Entity\AbstractEntity No errors.
App\Core\Entity\User\Access No errors.
App\Core\Entity\User\Actor
  • The field App\Core\Entity\User\Actor#workspace is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Core\Entity\User\Workspace#actor does not contain the required 'inversedBy: "workspace"' attribute.
App\Core\Entity\User\Collaborator
  • The field App\Core\Entity\User\Collaborator#businessRoles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Business\Entity\BusinessMember#collaborator does not contain the required 'inversedBy: "businessRoles"' attribute.
App\Core\Entity\Location\Contact No errors.
App\Core\Entity\User\Organization No errors.
App\Business\Entity\Type No errors.
App\Core\Entity\User\Workspace No errors.
App\Business\Entity\BusinessMember No errors.
App\Core\Entity\Location\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.