Symfony Profiler

Query Metrics

36 Database Queries

4 Different statements

38.77 ms Query time

0 Invalid entities

35 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.41 ms
(29.43%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.date_of_birth AS date_of_birth_8, t0.gender AS gender_9, t0.bio AS bio_10, t0.profile_picture AS profile_picture_11, t0.preferences AS preferences_12, t0.is_driver AS is_driver_13, t0.is_passenger AS is_passenger_14, t0.is_verified AS is_verified_15, t0.rating AS rating_16, t0.total_trips AS total_trips_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.date_of_birth AS date_of_birth_8,
  t0.gender AS gender_9,
  t0.bio AS bio_10,
  t0.profile_picture AS profile_picture_11,
  t0.preferences AS preferences_12,
  t0.is_driver AS is_driver_13,
  t0.is_passenger AS is_passenger_14,
  t0.is_verified AS is_verified_15,
  t0.rating AS rating_16,
  t0.total_trips AS total_trips_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.date_of_birth AS date_of_birth_8, t0.gender AS gender_9, t0.bio AS bio_10, t0.profile_picture AS profile_picture_11, t0.preferences AS preferences_12, t0.is_driver AS is_driver_13, t0.is_passenger AS is_passenger_14, t0.is_verified AS is_verified_15, t0.rating AS rating_16, t0.total_trips AS total_trips_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Twig\Extension\CoreExtension::getAttribute (line 1789)
5	__TwigTemplate_9f71d4e19963cb10eedf7eb0ffb7fee4::block_body (line 140)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_450eac7393e8d8616b2ee8ac9163c0ca->doDisplay (line 284)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_9f71d4e19963cb10eedf7eb0ffb7fee4->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
18	App\Controller\TripController->index (line 21)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

9.83 ms
(25.35%)

SELECT t0.id AS id_1, t0.pickup_address AS pickup_address_2, t0.pickup_latitude AS pickup_latitude_3, t0.pickup_longitude AS pickup_longitude_4, t0.status AS status_5, t0.number_of_seats AS number_of_seats_6, t0.total_price AS total_price_7, t0.payment_method AS payment_method_8, t0.payment_status AS payment_status_9, t0.passenger_note AS passenger_note_10, t0.driver_note AS driver_note_11, t0.created_at AS created_at_12, t0.confirmed_at AS confirmed_at_13, t0.cancelled_at AS cancelled_at_14, t0.cancellation_reason AS cancellation_reason_15, t0.trip_id AS trip_id_16, t0.passenger_id AS passenger_id_17 FROM booking t0 WHERE t0.trip_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pickup_address AS pickup_address_2,
  t0.pickup_latitude AS pickup_latitude_3,
  t0.pickup_longitude AS pickup_longitude_4,
  t0.status AS status_5,
  t0.number_of_seats AS number_of_seats_6,
  t0.total_price AS total_price_7,
  t0.payment_method AS payment_method_8,
  t0.payment_status AS payment_status_9,
  t0.passenger_note AS passenger_note_10,
  t0.driver_note AS driver_note_11,
  t0.created_at AS created_at_12,
  t0.confirmed_at AS confirmed_at_13,
  t0.cancelled_at AS cancelled_at_14,
  t0.cancellation_reason AS cancellation_reason_15,
  t0.trip_id AS trip_id_16,
  t0.passenger_id AS passenger_id_17
FROM
  booking t0
WHERE
  t0.trip_id = ?

SELECT t0.id AS id_1, t0.pickup_address AS pickup_address_2, t0.pickup_latitude AS pickup_latitude_3, t0.pickup_longitude AS pickup_longitude_4, t0.status AS status_5, t0.number_of_seats AS number_of_seats_6, t0.total_price AS total_price_7, t0.payment_method AS payment_method_8, t0.payment_status AS payment_status_9, t0.passenger_note AS passenger_note_10, t0.driver_note AS driver_note_11, t0.created_at AS created_at_12, t0.confirmed_at AS confirmed_at_13, t0.cancelled_at AS cancelled_at_14, t0.cancellation_reason AS cancellation_reason_15, t0.trip_id AS trip_id_16, t0.passenger_id AS passenger_id_17 FROM booking t0 WHERE t0.trip_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	App\Entity\Trip->getConfirmedBookingsCount (line 450)
8	App\Entity\Trip->getRemainingSeats (line 457)
9	Twig\Extension\CoreExtension->getAttribute (line 1913)
10	__TwigTemplate_9f71d4e19963cb10eedf7eb0ffb7fee4::block_body (line 221)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_450eac7393e8d8616b2ee8ac9163c0ca->doDisplay (line 284)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_9f71d4e19963cb10eedf7eb0ffb7fee4->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\TripController->index (line 21)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

9.52 ms
(24.55%)

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.color AS color_5, t0.license_plate AS license_plate_6, t0.seats AS seats_7, t0.features AS features_8, t0.insurance_document AS insurance_document_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11 FROM vehicle t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.model AS model_3,
  t0.year AS year_4,
  t0.color AS color_5,
  t0.license_plate AS license_plate_6,
  t0.seats AS seats_7,
  t0.features AS features_8,
  t0.insurance_document AS insurance_document_9,
  t0.created_at AS created_at_10,
  t0.owner_id AS owner_id_11
FROM
  vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.color AS color_5, t0.license_plate AS license_plate_6, t0.seats AS seats_7, t0.features AS features_8, t0.insurance_document AS insurance_document_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11 FROM vehicle t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Twig\Extension\CoreExtension::getAttribute (line 1789)
5	__TwigTemplate_9f71d4e19963cb10eedf7eb0ffb7fee4::block_body (line 246)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_450eac7393e8d8616b2ee8ac9163c0ca->doDisplay (line 284)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_9f71d4e19963cb10eedf7eb0ffb7fee4->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
18	App\Controller\TripController->index (line 21)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

8.02 ms
(20.67%)

SELECT t0.id AS id_1, t0.departure_address AS departure_address_2, t0.departure_latitude AS departure_latitude_3, t0.departure_longitude AS departure_longitude_4, t0.arrival_address AS arrival_address_5, t0.arrival_latitude AS arrival_latitude_6, t0.arrival_longitude AS arrival_longitude_7, t0.departure_time AS departure_time_8, t0.estimated_arrival_time AS estimated_arrival_time_9, t0.available_seats AS available_seats_10, t0.price_per_seat AS price_per_seat_11, t0.status AS status_12, t0.is_recurring AS is_recurring_13, t0.recurrence_pattern AS recurrence_pattern_14, t0.preferences AS preferences_15, t0.women_only AS women_only_16, t0.instant_booking AS instant_booking_17, t0.distance AS distance_18, t0.notes AS notes_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.driver_id AS driver_id_22, t0.vehicle_id AS vehicle_id_23 FROM trip t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.departure_address AS departure_address_2,
  t0.departure_latitude AS departure_latitude_3,
  t0.departure_longitude AS departure_longitude_4,
  t0.arrival_address AS arrival_address_5,
  t0.arrival_latitude AS arrival_latitude_6,
  t0.arrival_longitude AS arrival_longitude_7,
  t0.departure_time AS departure_time_8,
  t0.estimated_arrival_time AS estimated_arrival_time_9,
  t0.available_seats AS available_seats_10,
  t0.price_per_seat AS price_per_seat_11,
  t0.status AS status_12,
  t0.is_recurring AS is_recurring_13,
  t0.recurrence_pattern AS recurrence_pattern_14,
  t0.preferences AS preferences_15,
  t0.women_only AS women_only_16,
  t0.instant_booking AS instant_booking_17,
  t0.distance AS distance_18,
  t0.notes AS notes_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.driver_id AS driver_id_22,
  t0.vehicle_id AS vehicle_id_23
FROM
  trip t0

SELECT t0.id AS id_1, t0.departure_address AS departure_address_2, t0.departure_latitude AS departure_latitude_3, t0.departure_longitude AS departure_longitude_4, t0.arrival_address AS arrival_address_5, t0.arrival_latitude AS arrival_latitude_6, t0.arrival_longitude AS arrival_longitude_7, t0.departure_time AS departure_time_8, t0.estimated_arrival_time AS estimated_arrival_time_9, t0.available_seats AS available_seats_10, t0.price_per_seat AS price_per_seat_11, t0.status AS status_12, t0.is_recurring AS is_recurring_13, t0.recurrence_pattern AS recurrence_pattern_14, t0.preferences AS preferences_15, t0.women_only AS women_only_16, t0.instant_booking AS instant_booking_17, t0.distance AS distance_18, t0.notes AS notes_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.driver_id AS driver_id_22, t0.vehicle_id AS vehicle_id_23 FROM trip t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\TripController->index (line 22)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\Trip	15
App\Entity\User	10
App\Entity\Vehicle	10

Entities Mapping

Class	Mapping errors
App\Entity\Trip	No errors.
App\Entity\User	No errors.
App\Entity\Vehicle	No errors.
App\Entity\Booking	No errors.
App\Entity\Review	No errors.

Symfony Profiler

GET https://covoiturage.webmasi.cloud/trip/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping