Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.72 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	1.72 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.description AS description_5, t0.date_entered AS date_entered_6, t0.status AS status_7, t0.planned_time_send AS planned_time_send_8, t0.type AS type_9, t0.user_created_id AS user_created_id_10 FROM massive_notification t0 WHERE t0.status = ? LIMIT 1 Parameters: [`"new"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.description AS description_5, t0.date_entered AS date_entered_6, t0.status AS status_7, t0.planned_time_send AS planned_time_send_8, t0.type AS type_9, t0.user_created_id AS user_created_id_10 FROM massive_notification t0 WHERE t0.status = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.description AS description_5, t0.date_entered AS date_entered_6, t0.status AS status_7, t0.planned_time_send AS planned_time_send_8, t0.type AS type_9, t0.user_created_id AS user_created_id_10 FROM massive_notification t0 WHERE t0.status = 'new' LIMIT 1;

#▲

Time

Info

1.72 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.description AS description_5, t0.date_entered AS date_entered_6, t0.status AS status_7, t0.planned_time_send AS planned_time_send_8, t0.type AS type_9, t0.user_created_id AS user_created_id_10 FROM massive_notification t0 WHERE t0.status = ? LIMIT 1

Parameters:

[
  "new"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.body AS body_4,
  t0.description AS description_5,
  t0.date_entered AS date_entered_6,
  t0.status AS status_7,
  t0.planned_time_send AS planned_time_send_8,
  t0.type AS type_9,
  t0.user_created_id AS user_created_id_10
FROM
  massive_notification t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.description AS description_5, t0.date_entered AS date_entered_6, t0.status AS status_7, t0.planned_time_send AS planned_time_send_8, t0.type AS type_9, t0.user_created_id AS user_created_id_10 FROM massive_notification t0 WHERE t0.status = 'new' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
loe	doctrine.dbal.loe_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
loe	doctrine.orm.loe_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\MassiveNotification	No errors.
App\Entity\User	The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which is not defined as association. The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which does not exist.

loe entity manager

No loaded entities.