GET http://app.facile-car.com/api/business/notifications/unread-count

Response
200 OK
Browse referrer URL
IP
172.18.0.1
Profiled on
Token
c0b121

Query Metrics

7 Database Queries
7 Different statements
13.67 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.42 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_.is_verified AS is_verified_21, a0_.otp_code_hash AS otp_code_hash_22, a0_.otp_expires_at AS otp_expires_at_23, a0_.otp_attempts AS otp_attempts_24, a0_.phone AS phone_25, a0_.deleted_by_id AS deleted_by_id_26, a0_.author_id AS author_id_27 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = true
Parameters: 
[
  "shalomyimga19@gmail.com"
]
View formatted query    View runnable query    Explain query
2 4.81 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.is_verified AS is_verified_79, t57.otp_code_hash AS otp_code_hash_80, t57.otp_expires_at AS otp_expires_at_81, t57.otp_attempts AS otp_attempts_82, t57.phone AS phone_83, t57.deleted_by_id AS deleted_by_id_84, t57.author_id AS author_id_85, t86.id AS id_87, t86.date_add AS date_add_88, t86.date_upd AS date_upd_89, t86.is_deleted AS is_deleted_90, t86.is_locked AS is_locked_91, t86.is_draft AS is_draft_92, t86.can_be_deleted AS can_be_deleted_93, t86.deleted_at AS deleted_at_94, t86.owner_organization_id AS owner_organization_id_95, t86.companies_ids AS companies_ids_96, t86.matricule AS matricule_97, t86.position AS position_98, t86.is_blocked AS is_blocked_99, t86.deleted_by_id AS deleted_by_id_100, t86.author_id AS author_id_101, t86.actor_id AS actor_id_102, t86.contact_id AS contact_id_103, t86.organization_id AS organization_id_104, t86.type_id AS type_id_105, t86.profession_id AS profession_id_106, t107.id AS id_108, t107.date_add AS date_add_109, t107.date_upd AS date_upd_110, t107.is_deleted AS is_deleted_111, t107.is_locked AS is_locked_112, t107.is_draft AS is_draft_113, t107.can_be_deleted AS can_be_deleted_114, t107.deleted_at AS deleted_at_115, t107.owner_organization_id AS owner_organization_id_116, t107.companies_ids AS companies_ids_117, t107.context_type AS context_type_118, t107.deleted_by_id AS deleted_by_id_119, t107.author_id AS author_id_120, t107.actor_id AS actor_id_121, t107.organization_id AS organization_id_122 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 t86 ON t86.actor_id = t0.id LEFT JOIN app_core_user_workspace t107 ON t107.actor_id = t0.id WHERE t0.access_id = ?
Parameters: 
[
  162
]
View formatted query    View runnable query    Explain query
3 2.62 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.latitude AS latitude_16, t0.longitude AS longitude_17, t0.cover_image_id AS cover_image_id_18, t0.opening_days AS opening_days_19, t0.deleted_by_id AS deleted_by_id_20, t21.id AS id_22, t21.date_add AS date_add_23, t21.date_upd AS date_upd_24, t21.is_deleted AS is_deleted_25, t21.is_locked AS is_locked_26, t21.is_draft AS is_draft_27, t21.can_be_deleted AS can_be_deleted_28, t21.deleted_at AS deleted_at_29, t21.owner_organization_id AS owner_organization_id_30, t21.companies_ids AS companies_ids_31, t21.lastname AS lastname_32, t21.firstname AS firstname_33, t21.birth_place AS birth_place_34, t21.birth_date AS birth_date_35, t21.gender AS gender_36, t21.deleted_by_id AS deleted_by_id_37, t21.author_id AS author_id_38, t21.access_id AS access_id_39, t0.author_id AS author_id_40, t41.id AS id_42, t41.date_add AS date_add_43, t41.date_upd AS date_upd_44, t41.is_deleted AS is_deleted_45, t41.is_locked AS is_locked_46, t41.is_draft AS is_draft_47, t41.can_be_deleted AS can_be_deleted_48, t41.deleted_at AS deleted_at_49, t41.owner_organization_id AS owner_organization_id_50, t41.companies_ids AS companies_ids_51, t41.lastname AS lastname_52, t41.firstname AS firstname_53, t41.birth_place AS birth_place_54, t41.birth_date AS birth_date_55, t41.gender AS gender_56, t41.deleted_by_id AS deleted_by_id_57, t41.author_id AS author_id_58, t41.access_id AS access_id_59, t0.actor_id AS actor_id_60, t61.id AS id_62, t61.date_add AS date_add_63, t61.date_upd AS date_upd_64, t61.is_deleted AS is_deleted_65, t61.is_locked AS is_locked_66, t61.is_draft AS is_draft_67, t61.can_be_deleted AS can_be_deleted_68, t61.deleted_at AS deleted_at_69, t61.owner_organization_id AS owner_organization_id_70, t61.companies_ids AS companies_ids_71, t61.lastname AS lastname_72, t61.firstname AS firstname_73, t61.birth_place AS birth_place_74, t61.birth_date AS birth_date_75, t61.gender AS gender_76, t61.deleted_by_id AS deleted_by_id_77, t61.author_id AS author_id_78, t61.access_id AS access_id_79, t0.contact_id AS contact_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.calling_code AS calling_code_92, t81.phone AS phone_93, t81.email AS email_94, t81.web_site AS web_site_95, t81.address AS address_96, t81.city AS city_97, t81.latitude AS latitude_98, t81.longitude AS longitude_99, t81.deleted_by_id AS deleted_by_id_100, t81.author_id AS author_id_101, t81.state_id AS state_id_102 FROM app_core_user_organization t0 LEFT JOIN app_core_user_actor t21 ON t0.deleted_by_id = t21.id LEFT JOIN app_core_user_actor t41 ON t0.author_id = t41.id LEFT JOIN app_core_user_actor t61 ON t0.actor_id = t61.id LEFT JOIN app_core_location_contact t81 ON t0.contact_id = t81.id WHERE t0.id IN (?)
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query
4 1.45 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.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_core_organization_attachment ON t0.id = app_core_organization_attachment.organization_attachment_id WHERE app_core_organization_attachment.organization_id = ?
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query
5 1.03 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, t52.profession_id AS profession_id_72 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: 
[
  162
]
View formatted query    View runnable query    Explain query
6 0.47 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 FROM app_core_user_organization_i18n t0 WHERE t0.entity_id IN (?)
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query
7 0.87 ms 
SELECT COUNT(a0_.id) AS sclr_0 FROM app_business_vehicle_notification a0_ WHERE a0_.organization_id = ? AND a0_.read_at IS NULL
Parameters: 
[
  110
]
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\Business\Entity\Profession No errors.
App\Core\Entity\User\Workspace No errors.
App\Business\Entity\BusinessMember No errors.
App\Core\Entity\Location\State No errors.
App\Core\Entity\AbstractEntityI18n No errors.
App\Core\Entity\User\OrganizationI18n No errors.
App\Core\Entity\Attachment No errors.
App\Business\Entity\VehicleNotification No errors.