Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

4 Database Queries

2 Different statements

12.59 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.95 ms
(71.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.content AS content_6, t0.private_content AS private_content_7, t0.infos AS infos_8, t0.image AS image_9, t0.address AS address_10, t0.event_id AS event_id_11, t0.album_id AS album_id_12, t0.youtube_id AS youtube_id_13, t0.visible AS visible_14, t0.type AS type_15, t0.drive AS drive_16, t0.booth AS booth_17, t0.staffs AS staffs_18, t0.manager_id AS manager_id_19, t0.contact_id AS contact_id_20 FROM event t0 WHERE t0.type = ? AND t0.visible = ? ORDER BY t0.start_date DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.content AS content_6,
  t0.private_content AS private_content_7,
  t0.infos AS infos_8,
  t0.image AS image_9,
  t0.address AS address_10,
  t0.event_id AS event_id_11,
  t0.album_id AS album_id_12,
  t0.youtube_id AS youtube_id_13,
  t0.visible AS visible_14,
  t0.type AS type_15,
  t0.drive AS drive_16,
  t0.booth AS booth_17,
  t0.staffs AS staffs_18,
  t0.manager_id AS manager_id_19,
  t0.contact_id AS contact_id_20
FROM
  event t0
WHERE
  t0.type = ?
  AND t0.visible = ?
ORDER BY
  t0.start_date DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.content AS content_6, t0.private_content AS private_content_7, t0.infos AS infos_8, t0.image AS image_9, t0.address AS address_10, t0.event_id AS event_id_11, t0.album_id AS album_id_12, t0.youtube_id AS youtube_id_13, t0.visible AS visible_14, t0.type AS type_15, t0.drive AS drive_16, t0.booth AS booth_17, t0.staffs AS staffs_18, t0.manager_id AS manager_id_19, t0.contact_id AS contact_id_20 FROM event t0 WHERE t0.type = 0 AND t0.visible = 1 ORDER BY t0.start_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 36)
4	App\Controller\DefaultController->index (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.64 ms
(28.91%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.menu_display AS menu_display_5, t0.sorting AS sorting_6 FROM page t0 ORDER BY t0.sorting ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.menu_display AS menu_display_5,
  t0.sorting AS sorting_6
FROM
  page t0
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.menu_display AS menu_display_5, t0.sorting AS sorting_6 FROM page t0 ORDER BY t0.sorting ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 23)
4	App\Service\MyApp->pages (line 1637)
5	twig_get_attribute (line 116)
6	__TwigTemplate_16422628a4c3759aab9bd6df10ed9430->block_body (line 171)
7	Twig\Template->displayBlock (line 78)
8	__TwigTemplate_3ded6323ceceae5d445cc8cc9ca1418a->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 51)
11	__TwigTemplate_16422628a4c3759aab9bd6df10ed9430->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 48)
14	__TwigTemplate_4f47d515f276d9fa17985ab7e89ed229->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
22	App\Controller\DefaultController->index (line 182)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\Event	The association App\Entity\Event#contact refers to the inverse side field App\Entity\Contact#events which does not exist. The field App\Entity\Event#presences is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Presence#event does not contain the required 'inversedBy="presences"' attribute. The field App\Entity\Event#setups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Setup#event does not contain the required 'inversedBy="setups"' attribute. The field App\Entity\Event#todos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Todo#event does not contain the required 'inversedBy="todos"' attribute. The mappings App\Entity\Event#purchases and App\Entity\Purchase#event are inconsistent with each other.
App\Entity\User	The field App\Entity\User#masterActivities is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Activity#master does not contain the required 'inversedBy="masterActivities"' attribute.
App\Entity\Contact	The mappings App\Entity\Contact#event and App\Entity\Event#contact are inconsistent with each other.
App\Entity\Guest	No errors.
App\Entity\Activity	No errors.
App\Entity\Presence	No errors.
App\Entity\Setup	No errors.
App\Entity\Todo	No errors.
App\Entity\Quotation	No errors.
App\Entity\Purchase	The association App\Entity\Purchase#event refers to the inverse side field App\Entity\Event#puchases which does not exist.
App\Entity\Checklist	The association App\Entity\Checklist#item refers to the inverse side field App\Entity\Item#checklist which does not exist.
App\Entity\Page	No errors.

Symfony Profiler

GET https://g2l2corp.com/p/star-geek-universe-3-apocalypse-edition-par-g2l2-corp

Configuration Settings

Theme