Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.11 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.82 ms

SELECT e0_.id AS id_0, e0_.user_id AS user_id_1, e0_.manager_id AS manager_id_2, e0_.org_id AS org_id_3, o1_.name AS name_4, o1_.avatar AS avatar_5, u2_.user_name AS user_name_6, u2_.user_last_name AS user_last_name_7, u2_.user_father_name AS user_father_name_8, u2_.avatar AS avatar_9, u3_.user_name AS user_name_10, u3_.user_last_name AS user_last_name_11, u3_.user_father_name AS user_father_name_12, u3_.avatar AS avatar_13, e0_.added AS added_14, e0_.changed AS changed_15, e0_.title AS title_16, e0_.poster AS poster_17, e0_.main_vol_type AS main_vol_type_18, v4_.name AS name_19, e0_.begin AS begin_20, e0_.end AS end_21, e0_.recruitment_end AS recruitment_end_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.address AS address_25, e0_.online AS online_26, e0_.difficulty AS difficulty_27 FROM events e0_ LEFT JOIN users u2_ ON (e0_.user_id = u2_.id) LEFT JOIN users u3_ ON (e0_.manager_id = u3_.id) LEFT JOIN volunteering_types_list v4_ ON (e0_.main_vol_type = v4_.id) LEFT JOIN events_descriptions e5_ ON (e0_.id = e5_.event_id) LEFT JOIN organizations o1_ ON (e0_.org_id = o1_.id) WHERE e0_.enabled = 1 AND e0_.draft = 0 AND NOW() < e0_.begin GROUP BY e0_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.user_id AS user_id_1,
  e0_.manager_id AS manager_id_2,
  e0_.org_id AS org_id_3,
  o1_.name AS name_4,
  o1_.avatar AS avatar_5,
  u2_.user_name AS user_name_6,
  u2_.user_last_name AS user_last_name_7,
  u2_.user_father_name AS user_father_name_8,
  u2_.avatar AS avatar_9,
  u3_.user_name AS user_name_10,
  u3_.user_last_name AS user_last_name_11,
  u3_.user_father_name AS user_father_name_12,
  u3_.avatar AS avatar_13,
  e0_.added AS added_14,
  e0_.changed AS changed_15,
  e0_.title AS title_16,
  e0_.poster AS poster_17,
  e0_.main_vol_type AS main_vol_type_18,
  v4_.name AS name_19,
  e0_.begin AS begin_20,
  e0_.end AS end_21,
  e0_.recruitment_end AS recruitment_end_22,
  e0_.latitude AS latitude_23,
  e0_.longitude AS longitude_24,
  e0_.address AS address_25,
  e0_.online AS online_26,
  e0_.difficulty AS difficulty_27
FROM
  events e0_
  LEFT JOIN users u2_ ON (e0_.user_id = u2_.id)
  LEFT JOIN users u3_ ON (e0_.manager_id = u3_.id)
  LEFT JOIN volunteering_types_list v4_ ON (e0_.main_vol_type = v4_.id)
  LEFT JOIN events_descriptions e5_ ON (e0_.id = e5_.event_id)
  LEFT JOIN organizations o1_ ON (e0_.org_id = o1_.id)
WHERE
  e0_.enabled = 1
  AND e0_.draft = 0
  AND NOW() < e0_.begin
GROUP BY
  e0_.id

SELECT e0_.id AS id_0, e0_.user_id AS user_id_1, e0_.manager_id AS manager_id_2, e0_.org_id AS org_id_3, o1_.name AS name_4, o1_.avatar AS avatar_5, u2_.user_name AS user_name_6, u2_.user_last_name AS user_last_name_7, u2_.user_father_name AS user_father_name_8, u2_.avatar AS avatar_9, u3_.user_name AS user_name_10, u3_.user_last_name AS user_last_name_11, u3_.user_father_name AS user_father_name_12, u3_.avatar AS avatar_13, e0_.added AS added_14, e0_.changed AS changed_15, e0_.title AS title_16, e0_.poster AS poster_17, e0_.main_vol_type AS main_vol_type_18, v4_.name AS name_19, e0_.begin AS begin_20, e0_.end AS end_21, e0_.recruitment_end AS recruitment_end_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.address AS address_25, e0_.online AS online_26, e0_.difficulty AS difficulty_27 FROM events e0_ LEFT JOIN users u2_ ON (e0_.user_id = u2_.id) LEFT JOIN users u3_ ON (e0_.manager_id = u3_.id) LEFT JOIN volunteering_types_list v4_ ON (e0_.main_vol_type = v4_.id) LEFT JOIN events_descriptions e5_ ON (e0_.id = e5_.event_id) LEFT JOIN organizations o1_ ON (e0_.org_id = o1_.id) WHERE e0_.enabled = 1 AND e0_.draft = 0 AND NOW() < e0_.begin GROUP BY e0_.id;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->Sentry\SentryBundle\Tracing\Doctrine\DBAL\{closure} (line 235)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 108)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1101)
5	Doctrine\DBAL\Connection->executeQuery (line 29)
6	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
7	Doctrine\ORM\Query->_doExecute (line 935)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
9	Doctrine\ORM\AbstractQuery->execute (line 689)
10	Doctrine\ORM\AbstractQuery->getResult (line 110)
11	App\Repository\EventsRepository->findEventsSearch (line 54)
12	App\Controller\EventsController->index (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.29 ms

SELECT v0_.id AS id_0, v0_.name AS name_1 FROM volunteering_types_list v0_ INNER JOIN events e1_ ON (v0_.id = e1_.main_vol_type) WHERE e1_.enabled = 1 AND e1_.draft = 0 GROUP BY v0_.id ORDER BY v0_.type_id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1
FROM
  volunteering_types_list v0_
  INNER JOIN events e1_ ON (v0_.id = e1_.main_vol_type)
WHERE
  e1_.enabled = 1
  AND e1_.draft = 0
GROUP BY
  v0_.id
ORDER BY
  v0_.type_id ASC

SELECT v0_.id AS id_0, v0_.name AS name_1 FROM volunteering_types_list v0_ INNER JOIN events e1_ ON (v0_.id = e1_.main_vol_type) WHERE e1_.enabled = 1 AND e1_.draft = 0 GROUP BY v0_.id ORDER BY v0_.type_id ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->Sentry\SentryBundle\Tracing\Doctrine\DBAL\{closure} (line 235)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 108)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1101)
5	Doctrine\DBAL\Connection->executeQuery (line 29)
6	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
7	Doctrine\ORM\Query->_doExecute (line 935)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
9	Doctrine\ORM\AbstractQuery->execute (line 689)
10	Doctrine\ORM\AbstractQuery->getResult (line 42)
11	App\Repository\VolunteeringTypesListRepository->findActive (line 58)
12	App\Controller\EventsController->index (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

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\Events	No errors.
App\Entity\Users	No errors.
App\Entity\VolunteeringTypesList	No errors.
App\Entity\EventsDescriptions	No errors.
App\Entity\Organizations	No errors.

Symfony Profiler

GET http://80.76.228.122/events

Configuration Settings

Theme