Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.64 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.64 ms	SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.is_deleted AS is_deleted_5, t0.axe AS axe_6, t0.secondary_source AS secondary_source_7, t0.is_valid AS is_valid_8, t0.is_avorte AS is_avorte_9, t0.comment AS comment_10, t0.date_avorte AS date_avorte_11, t0.is_idp AS is_idp_12, t0.deleted_date AS deleted_date_13, t0.access_risk_comment AS access_risk_comment_14, t0.displaced_eval AS displaced_eval_15, t0.returned_eval AS returned_eval_16, t0.affected_eval AS affected_eval_17, t0.household_eval AS household_eval_18, t0.severity_alert_rrm AS severity_alert_rrm_19, t0.displaced_eval_household AS displaced_eval_household_20, t0.returned_eval_household AS returned_eval_household_21, t0.cluster_id AS cluster_id_22, t0.event_reason_id AS event_reason_id_23, t0.primary_source_id AS primary_source_id_24, t0.user_create_id AS user_create_id_25, t0.user_avorte_id AS user_avorte_id_26, t0.access_risk_id AS access_risk_id_27, t0.statut_id AS statut_id_28, t0.severity_id AS severity_id_29, t0.alert_detail_id AS alert_detail_id_30, t0.crisis_id AS crisis_id_31, t0.country_id AS country_id_32, t0.severity_alert_id AS severity_alert_id_33, t0.event_sous_type_id AS event_sous_type_id_34, t0.accommodation_id AS accommodation_id_35, t0.movement_category_id AS movement_category_id_36 FROM alert t0 WHERE t0.id = ? Parameters: [`"3686"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.is_deleted AS is_deleted_5, t0.axe AS axe_6, t0.secondary_source AS secondary_source_7, t0.is_valid AS is_valid_8, t0.is_avorte AS is_avorte_9, t0.comment AS comment_10, t0.date_avorte AS date_avorte_11, t0.is_idp AS is_idp_12, t0.deleted_date AS deleted_date_13, t0.access_risk_comment AS access_risk_comment_14, t0.displaced_eval AS displaced_eval_15, t0.returned_eval AS returned_eval_16, t0.affected_eval AS affected_eval_17, t0.household_eval AS household_eval_18, t0.severity_alert_rrm AS severity_alert_rrm_19, t0.displaced_eval_household AS displaced_eval_household_20, t0.returned_eval_household AS returned_eval_household_21, t0.cluster_id AS cluster_id_22, t0.event_reason_id AS event_reason_id_23, t0.primary_source_id AS primary_source_id_24, t0.user_create_id AS user_create_id_25, t0.user_avorte_id AS user_avorte_id_26, t0.access_risk_id AS access_risk_id_27, t0.statut_id AS statut_id_28, t0.severity_id AS severity_id_29, t0.alert_detail_id AS alert_detail_id_30, t0.crisis_id AS crisis_id_31, t0.country_id AS country_id_32, t0.severity_alert_id AS severity_alert_id_33, t0.event_sous_type_id AS event_sous_type_id_34, t0.accommodation_id AS accommodation_id_35, t0.movement_category_id AS movement_category_id_36 FROM alert t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.is_deleted AS is_deleted_5, t0.axe AS axe_6, t0.secondary_source AS secondary_source_7, t0.is_valid AS is_valid_8, t0.is_avorte AS is_avorte_9, t0.comment AS comment_10, t0.date_avorte AS date_avorte_11, t0.is_idp AS is_idp_12, t0.deleted_date AS deleted_date_13, t0.access_risk_comment AS access_risk_comment_14, t0.displaced_eval AS displaced_eval_15, t0.returned_eval AS returned_eval_16, t0.affected_eval AS affected_eval_17, t0.household_eval AS household_eval_18, t0.severity_alert_rrm AS severity_alert_rrm_19, t0.displaced_eval_household AS displaced_eval_household_20, t0.returned_eval_household AS returned_eval_household_21, t0.cluster_id AS cluster_id_22, t0.event_reason_id AS event_reason_id_23, t0.primary_source_id AS primary_source_id_24, t0.user_create_id AS user_create_id_25, t0.user_avorte_id AS user_avorte_id_26, t0.access_risk_id AS access_risk_id_27, t0.statut_id AS statut_id_28, t0.severity_id AS severity_id_29, t0.alert_detail_id AS alert_detail_id_30, t0.crisis_id AS crisis_id_31, t0.country_id AS country_id_32, t0.severity_alert_id AS severity_alert_id_33, t0.event_sous_type_id AS event_sous_type_id_34, t0.accommodation_id AS accommodation_id_35, t0.movement_category_id AS movement_category_id_36 FROM alert t0 WHERE t0.id = '3686';

#▲

Time

Info

0.64 ms

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.is_deleted AS is_deleted_5, t0.axe AS axe_6, t0.secondary_source AS secondary_source_7, t0.is_valid AS is_valid_8, t0.is_avorte AS is_avorte_9, t0.comment AS comment_10, t0.date_avorte AS date_avorte_11, t0.is_idp AS is_idp_12, t0.deleted_date AS deleted_date_13, t0.access_risk_comment AS access_risk_comment_14, t0.displaced_eval AS displaced_eval_15, t0.returned_eval AS returned_eval_16, t0.affected_eval AS affected_eval_17, t0.household_eval AS household_eval_18, t0.severity_alert_rrm AS severity_alert_rrm_19, t0.displaced_eval_household AS displaced_eval_household_20, t0.returned_eval_household AS returned_eval_household_21, t0.cluster_id AS cluster_id_22, t0.event_reason_id AS event_reason_id_23, t0.primary_source_id AS primary_source_id_24, t0.user_create_id AS user_create_id_25, t0.user_avorte_id AS user_avorte_id_26, t0.access_risk_id AS access_risk_id_27, t0.statut_id AS statut_id_28, t0.severity_id AS severity_id_29, t0.alert_detail_id AS alert_detail_id_30, t0.crisis_id AS crisis_id_31, t0.country_id AS country_id_32, t0.severity_alert_id AS severity_alert_id_33, t0.event_sous_type_id AS event_sous_type_id_34, t0.accommodation_id AS accommodation_id_35, t0.movement_category_id AS movement_category_id_36 FROM alert t0 WHERE t0.id = ?

Parameters:

[
  "3686"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.description AS description_3,
  t0.creation_date AS creation_date_4,
  t0.is_deleted AS is_deleted_5,
  t0.axe AS axe_6,
  t0.secondary_source AS secondary_source_7,
  t0.is_valid AS is_valid_8,
  t0.is_avorte AS is_avorte_9,
  t0.comment AS comment_10,
  t0.date_avorte AS date_avorte_11,
  t0.is_idp AS is_idp_12,
  t0.deleted_date AS deleted_date_13,
  t0.access_risk_comment AS access_risk_comment_14,
  t0.displaced_eval AS displaced_eval_15,
  t0.returned_eval AS returned_eval_16,
  t0.affected_eval AS affected_eval_17,
  t0.household_eval AS household_eval_18,
  t0.severity_alert_rrm AS severity_alert_rrm_19,
  t0.displaced_eval_household AS displaced_eval_household_20,
  t0.returned_eval_household AS returned_eval_household_21,
  t0.cluster_id AS cluster_id_22,
  t0.event_reason_id AS event_reason_id_23,
  t0.primary_source_id AS primary_source_id_24,
  t0.user_create_id AS user_create_id_25,
  t0.user_avorte_id AS user_avorte_id_26,
  t0.access_risk_id AS access_risk_id_27,
  t0.statut_id AS statut_id_28,
  t0.severity_id AS severity_id_29,
  t0.alert_detail_id AS alert_detail_id_30,
  t0.crisis_id AS crisis_id_31,
  t0.country_id AS country_id_32,
  t0.severity_alert_id AS severity_alert_id_33,
  t0.event_sous_type_id AS event_sous_type_id_34,
  t0.accommodation_id AS accommodation_id_35,
  t0.movement_category_id AS movement_category_id_36
FROM
  alert t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.is_deleted AS is_deleted_5, t0.axe AS axe_6, t0.secondary_source AS secondary_source_7, t0.is_valid AS is_valid_8, t0.is_avorte AS is_avorte_9, t0.comment AS comment_10, t0.date_avorte AS date_avorte_11, t0.is_idp AS is_idp_12, t0.deleted_date AS deleted_date_13, t0.access_risk_comment AS access_risk_comment_14, t0.displaced_eval AS displaced_eval_15, t0.returned_eval AS returned_eval_16, t0.affected_eval AS affected_eval_17, t0.household_eval AS household_eval_18, t0.severity_alert_rrm AS severity_alert_rrm_19, t0.displaced_eval_household AS displaced_eval_household_20, t0.returned_eval_household AS returned_eval_household_21, t0.cluster_id AS cluster_id_22, t0.event_reason_id AS event_reason_id_23, t0.primary_source_id AS primary_source_id_24, t0.user_create_id AS user_create_id_25, t0.user_avorte_id AS user_avorte_id_26, t0.access_risk_id AS access_risk_id_27, t0.statut_id AS statut_id_28, t0.severity_id AS severity_id_29, t0.alert_detail_id AS alert_detail_id_30, t0.crisis_id AS crisis_id_31, t0.country_id AS country_id_32, t0.severity_alert_id AS severity_alert_id_33, t0.event_sous_type_id AS event_sous_type_id_34, t0.accommodation_id AS accommodation_id_35, t0.movement_category_id AS movement_category_id_36 FROM alert t0 WHERE t0.id = '3686';

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\Entity\Alert	No errors.
App\Entity\Cluster	No errors.
App\Entity\EventReason	No errors.
App\Entity\Actor	No errors.
App\Entity\User	The field App\Entity\User#projects is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Project#userAvort does not contain the required 'inversedBy="projects"' attribute.
App\Entity\AccessRisk	No errors.
App\Entity\Process	No errors.
App\Entity\Severity	No errors.
App\Entity\AlertDetail	No errors.
App\Entity\Crisis	No errors.
App\Entity\Pcode	No errors.
App\Entity\EventSousType	No errors.
App\Entity\AlertAccommodation	No errors.
App\Entity\MovementCategory	No errors.
App\Entity\AlertDocument	No errors.
App\Entity\Movement	The association App\Entity\Movement#alerts refers to the owning side field App\Entity\Alert#pdi which does not exist.
App\Entity\ActivityAme	The association App\Entity\ActivityAme#indicator refers to the inverse side field App\Entity\Indicator#activityEducation which does not exist.

Symfony Profiler

https://dev.ehtools.org/alert-next-process/3686

Configuration Settings

Theme