Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

36.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

34.72 ms
(96.31%)

SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.is_read AS is_read_2, n0_.content AS content_3, n0_.to_admin AS to_admin_4, n0_.user_id AS user_id_5 FROM notifications n0_ WHERE (n0_.user_id = ? OR n0_.to_admin = 1) AND n0_.is_read = ? ORDER BY n0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.created_at AS created_at_1,
  n0_.is_read AS is_read_2,
  n0_.content AS content_3,
  n0_.to_admin AS to_admin_4,
  n0_.user_id AS user_id_5
FROM
  notifications n0_
WHERE
  (
    n0_.user_id = ?
    OR n0_.to_admin = 1
  )
  AND n0_.is_read = ?
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.is_read AS is_read_2, n0_.content AS content_3, n0_.to_admin AS to_admin_4, n0_.user_id AS user_id_5 FROM notifications n0_ WHERE (n0_.user_id = 48 OR n0_.to_admin = 1) AND n0_.is_read = 0 ORDER BY n0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\NotificationsRepository->findByParameters (line 53)
8	App\Controller\AdminNotificationsController->getNotifsUser (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 31)

1.33 ms
(3.69%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.enabled AS enabled_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.lastname AS lastname_9, t0.firstname AS firstname_10, t0.password_reset_at AS password_reset_at_11, t0.password_reset_token AS password_reset_token_12, t0.civility AS civility_13, t0.created_at AS created_at_14, t0.address AS address_15, t0.postal_code AS postal_code_16, t0.city AS city_17, t0.phone AS phone_18, t0.divers AS divers_19, t0.note AS note_20, t0.calendar_default_view AS calendar_default_view_21, t0.calendar_slot_duration AS calendar_slot_duration_22, t0.calendar_min_time AS calendar_min_time_23, t0.calendar_max_time AS calendar_max_time_24, t0.has_online AS has_online_25, t0.customer_type AS customer_type_26, t0.notif_sms_rdv AS notif_sms_rdv_27, t0.notif_sms_before AS notif_sms_before_28, t0.notif_email_rdv AS notif_email_rdv_29, t0.notif_email_before AS notif_email_before_30, t0.show_weekend AS show_weekend_31, t0.notif_push_new_mess AS notif_push_new_mess_32, t0.notif_mail_new_mess AS notif_mail_new_mess_33, t0.notif_push_wait_mess AS notif_push_wait_mess_34, t0.notif_mail_wait_mess AS notif_mail_wait_mess_35, t0.mobile AS mobile_36, t0.new_customer_online AS new_customer_online_37, t0.office_id AS office_id_38 FROM user t0 WHERE t0.id = ?

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.enabled AS enabled_6,
  t0.last_login AS last_login_7,
  t0.confirmation_token AS confirmation_token_8,
  t0.lastname AS lastname_9,
  t0.firstname AS firstname_10,
  t0.password_reset_at AS password_reset_at_11,
  t0.password_reset_token AS password_reset_token_12,
  t0.civility AS civility_13,
  t0.created_at AS created_at_14,
  t0.address AS address_15,
  t0.postal_code AS postal_code_16,
  t0.city AS city_17,
  t0.phone AS phone_18,
  t0.divers AS divers_19,
  t0.note AS note_20,
  t0.calendar_default_view AS calendar_default_view_21,
  t0.calendar_slot_duration AS calendar_slot_duration_22,
  t0.calendar_min_time AS calendar_min_time_23,
  t0.calendar_max_time AS calendar_max_time_24,
  t0.has_online AS has_online_25,
  t0.customer_type AS customer_type_26,
  t0.notif_sms_rdv AS notif_sms_rdv_27,
  t0.notif_sms_before AS notif_sms_before_28,
  t0.notif_email_rdv AS notif_email_rdv_29,
  t0.notif_email_before AS notif_email_before_30,
  t0.show_weekend AS show_weekend_31,
  t0.notif_push_new_mess AS notif_push_new_mess_32,
  t0.notif_mail_new_mess AS notif_mail_new_mess_33,
  t0.notif_push_wait_mess AS notif_push_wait_mess_34,
  t0.notif_mail_wait_mess AS notif_mail_wait_mess_35,
  t0.mobile AS mobile_36,
  t0.new_customer_online AS new_customer_online_37,
  t0.office_id AS office_id_38
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.enabled AS enabled_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.lastname AS lastname_9, t0.firstname AS firstname_10, t0.password_reset_at AS password_reset_at_11, t0.password_reset_token AS password_reset_token_12, t0.civility AS civility_13, t0.created_at AS created_at_14, t0.address AS address_15, t0.postal_code AS postal_code_16, t0.city AS city_17, t0.phone AS phone_18, t0.divers AS divers_19, t0.note AS note_20, t0.calendar_default_view AS calendar_default_view_21, t0.calendar_slot_duration AS calendar_slot_duration_22, t0.calendar_min_time AS calendar_min_time_23, t0.calendar_max_time AS calendar_max_time_24, t0.has_online AS has_online_25, t0.customer_type AS customer_type_26, t0.notif_sms_rdv AS notif_sms_rdv_27, t0.notif_sms_before AS notif_sms_before_28, t0.notif_email_rdv AS notif_email_rdv_29, t0.notif_email_before AS notif_email_before_30, t0.show_weekend AS show_weekend_31, t0.notif_push_new_mess AS notif_push_new_mess_32, t0.notif_mail_new_mess AS notif_mail_new_mess_33, t0.notif_push_wait_mess AS notif_push_wait_mess_34, t0.notif_mail_wait_mess AS notif_mail_wait_mess_35, t0.mobile AS mobile_36, t0.new_customer_online AS new_customer_online_37, t0.office_id AS office_id_38 FROM user t0 WHERE t0.id = 48;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 31)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
oldb	doctrine.dbal.oldb_connection
logging	doctrine.dbal.logging_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\User	No errors.
App\Entity\Office	No errors.
App\Entity\Specialties	No errors.
App\Entity\UserCategories	No errors.
App\Entity\Notifications	No errors.

Symfony Profiler

GET https://preprod.sti.cyberscope.fr/stiadmin20/notifications/?read=false

Configuration Settings

Theme

Page Width