Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.73 ms Query time

1 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.85 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "strasbourg"
]

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.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.is_created AS is_created_8,
  t0.is_activated AS is_activated_9,
  t0.created_at AS created_at_10,
  t0.data AS data_11,
  t0.legal AS legal_12,
  t0.wallpaper AS wallpaper_13,
  t0.statistical AS statistical_14,
  t0.manager_id AS manager_id_15,
  t0.main_borough_id AS main_borough_id_16
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 WHERE t0.slug = 'strasbourg' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\EventSubscriber\InvalidSubdomainRedirectSubscriber->onKernelRequest (line 49)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.88 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.price AS price_4, t0.precision_price AS precision_price_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.time_start AS time_start_8, t0.time_end AS time_end_9, t0.precision_date AS precision_date_10, t0.choice_of_days AS choice_of_days_11, t0.description AS description_12, t0.cover_image AS cover_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.place_temporary AS place_temporary_16, t0.is_validated AS is_validated_17, t0.is_canceled AS is_canceled_18, t0.is_published AS is_published_19, t0.is_spam AS is_spam_20, t0.is_mistake AS is_mistake_21, t0.is_duplicated AS is_duplicated_22, t0.is_full AS is_full_23, t0.is_postponed AS is_postponed_24, t0.links AS links_25, t0.oldserial AS oldserial_26, t0.mail_anonymous AS mail_anonymous_27, t0.ip_anonymous AS ip_anonymous_28, t0.secret_anonymous AS secret_anonymous_29, t0.date_multiple AS date_multiple_30, t0.time_open AS time_open_31, t0.city_id AS city_id_32, t0.place_id AS place_id_33, t0.rubric_id AS rubric_id_34, t0.organizer_id AS organizer_id_35, t0.festival_id AS festival_id_36, t0.author_id AS author_id_37, t0.verified_by_id AS verified_by_id_38 FROM event t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "concert-de-l-orchestre-de-l-ama-en-collaboration-avec-le-choeur-polyphonique-de-strasbourg"
]

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.price AS price_4,
  t0.precision_price AS precision_price_5,
  t0.date_start AS date_start_6,
  t0.date_end AS date_end_7,
  t0.time_start AS time_start_8,
  t0.time_end AS time_end_9,
  t0.precision_date AS precision_date_10,
  t0.choice_of_days AS choice_of_days_11,
  t0.description AS description_12,
  t0.cover_image AS cover_image_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.place_temporary AS place_temporary_16,
  t0.is_validated AS is_validated_17,
  t0.is_canceled AS is_canceled_18,
  t0.is_published AS is_published_19,
  t0.is_spam AS is_spam_20,
  t0.is_mistake AS is_mistake_21,
  t0.is_duplicated AS is_duplicated_22,
  t0.is_full AS is_full_23,
  t0.is_postponed AS is_postponed_24,
  t0.links AS links_25,
  t0.oldserial AS oldserial_26,
  t0.mail_anonymous AS mail_anonymous_27,
  t0.ip_anonymous AS ip_anonymous_28,
  t0.secret_anonymous AS secret_anonymous_29,
  t0.date_multiple AS date_multiple_30,
  t0.time_open AS time_open_31,
  t0.city_id AS city_id_32,
  t0.place_id AS place_id_33,
  t0.rubric_id AS rubric_id_34,
  t0.organizer_id AS organizer_id_35,
  t0.festival_id AS festival_id_36,
  t0.author_id AS author_id_37,
  t0.verified_by_id AS verified_by_id_38
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.price AS price_4, t0.precision_price AS precision_price_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.time_start AS time_start_8, t0.time_end AS time_end_9, t0.precision_date AS precision_date_10, t0.choice_of_days AS choice_of_days_11, t0.description AS description_12, t0.cover_image AS cover_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.place_temporary AS place_temporary_16, t0.is_validated AS is_validated_17, t0.is_canceled AS is_canceled_18, t0.is_published AS is_published_19, t0.is_spam AS is_spam_20, t0.is_mistake AS is_mistake_21, t0.is_duplicated AS is_duplicated_22, t0.is_full AS is_full_23, t0.is_postponed AS is_postponed_24, t0.links AS links_25, t0.oldserial AS oldserial_26, t0.mail_anonymous AS mail_anonymous_27, t0.ip_anonymous AS ip_anonymous_28, t0.secret_anonymous AS secret_anonymous_29, t0.date_multiple AS date_multiple_30, t0.time_open AS time_open_31, t0.city_id AS city_id_32, t0.place_id AS place_id_33, t0.rubric_id AS rubric_id_34, t0.organizer_id AS organizer_id_35, t0.festival_id AS festival_id_36, t0.author_id AS author_id_37, t0.verified_by_id AS verified_by_id_38 FROM event t0 WHERE t0.slug = 'concert-de-l-orchestre-de-l-ama-en-collaboration-avec-le-choeur-polyphonique-de-strasbourg' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	2
App\Entity\Subdomain	1
App\Entity\Borough	1
App\Entity\Event	1
App\Entity\City	1
App\Entity\Rubric	1
App\Entity\Organizer	1

Entities Mapping

Class	Mapping errors
App\Entity\Subdomain	No errors.
App\Entity\User	No errors.
App\Entity\Borough	No errors.
App\Entity\Reduction	No errors.
App\Entity\Event	No errors.
App\Entity\City	The field App\Entity\City#resources is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketResource#city does not contain the required 'inversedBy: "resources"' attribute.
App\Entity\Place	No errors.
App\Entity\Rubric	No errors.
App\Entity\Organizer	No errors.
App\Entity\Festival	No errors.
App\Entity\Category	No errors.
App\Entity\Ticket	No errors.
App\Entity\Video	No errors.
App\Entity\Image	No errors.
App\Entity\Comment	No errors.
App\Entity\Claim	No errors.
App\Entity\EventLike	No errors.
App\Entity\Prices	No errors.
App\Entity\Artist	No errors.

Symfony Profiler

GET https://strasbourg.curieux.app/agenda/evenement/concert-de-l-orchestre-de-l-ama-en-collaboration-avec-le-choeur-polyphonique-de-strasbourg/modifier

Configuration Settings

Theme

Page Width