GET https://www.teambenevoles.fr/events

Query Metrics

8 Database Queries
3 Different statements
3.34 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.78 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.start_date AS start_date_3, e0_.end_date AS end_date_4, e0_.status AS status_5, e0_.is_public AS is_public_6, e0_.created_at AS created_at_7, e0_.updated_at AS updated_at_8, e0_.association_id AS association_id_9 FROM events e0_ WHERE e0_.is_public = 1 AND e0_.status IN (?, ?) ORDER BY e0_.start_date ASC
Parameters:
[
  "published"
  "registration_open"
]
2 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.email AS email_4, t0.phone AS phone_5, t0.website AS website_6, t0.address AS address_7, t0.subscription_plan AS subscription_plan_8, t0.subscription_expires_at AS subscription_expires_at_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13 FROM associations t0 WHERE t0.id = ?
Parameters:
[
  3
]
3 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.created_at AS created_at_7, t0.event_id AS event_id_8 FROM zones t0 WHERE t0.event_id = ?
Parameters:
[
  5
]
4 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.email AS email_4, t0.phone AS phone_5, t0.website AS website_6, t0.address AS address_7, t0.subscription_plan AS subscription_plan_8, t0.subscription_expires_at AS subscription_expires_at_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13 FROM associations t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.created_at AS created_at_7, t0.event_id AS event_id_8 FROM zones t0 WHERE t0.event_id = ?
Parameters:
[
  3
]
6 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.email AS email_4, t0.phone AS phone_5, t0.website AS website_6, t0.address AS address_7, t0.subscription_plan AS subscription_plan_8, t0.subscription_expires_at AS subscription_expires_at_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13 FROM associations t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.created_at AS created_at_7, t0.event_id AS event_id_8 FROM zones t0 WHERE t0.event_id = ?
Parameters:
[
  1
]
8 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.created_at AS created_at_7, t0.event_id AS event_id_8 FROM zones t0 WHERE t0.event_id = ?
Parameters:
[
  2
]

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\Event 4
App\Entity\Association 3
App\Entity\Zone 3

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\Association No errors.
App\Entity\Planning No errors.
App\Entity\Zone No errors.
App\Entity\User No errors.
App\Entity\Job No errors.
App\Entity\Task No errors.