GET https://www.rideshare.mcdope.org/events

Query Metrics

19 Database Queries
6 Different statements
5.67 ms Query time
4 Invalid entities
125 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.banner AS banner_3, e0_.starting_at AS starting_at_4, e0_.ending_at AS ending_at_5, e0_.link AS link_6, e0_.slug AS slug_7, e0_.owner_id AS owner_id_8, e0_.parent_event_id AS parent_event_id_9, e0_.location_id AS location_id_10 FROM event e0_ WHERE e0_.parent_event_id IS NULL ORDER BY e0_.starting_at ASC LIMIT 10
Parameters:
[]
2 0.24 ms
SELECT t0.id AS id_1, t0.preferred_contact_type AS preferred_contact_type_2, t0.email AS email_3, t0.phone AS phone_4, t0.locales AS locales_5, t0.user_id AS user_id_6 FROM profile t0 WHERE t0.user_id IS NULL LIMIT 1
Parameters:
[]
3 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.banner AS banner_4, t0.starting_at AS starting_at_5, t0.ending_at AS ending_at_6, t0.link AS link_7, t0.slug AS slug_8, t0.owner_id AS owner_id_9, t0.parent_event_id AS parent_event_id_10, t0.location_id AS location_id_11 FROM event t0 WHERE t0.parent_event_id = ? ORDER BY t0.starting_at ASC
Parameters:
[
  2
]
4 0.28 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.address AS address_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.owner_id AS owner_id_6 FROM location t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 0.33 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  10
]
6 0.31 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  10
]
7 0.30 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  11
]
8 0.23 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  11
]
9 0.26 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.address AS address_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.owner_id AS owner_id_6 FROM location t0 WHERE t0.id = ?
Parameters:
[
  7
]
10 0.26 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  7
]
11 0.29 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  7
]
12 0.30 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  5
]
13 0.29 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  5
]
14 0.23 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  6
]
15 0.23 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  6
]
16 0.26 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  12
]
17 0.28 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  12
]
18 0.25 ms
SELECT t0.id AS id_1, t0.car AS car_2, t0.is_luggage_possible AS is_luggage_possible_3, t0.luggage_description AS luggage_description_4, t0.seats_available AS seats_available_5, t0.max_detour_distance AS max_detour_distance_6, t0.start_datetime AS start_datetime_7, t0.return_datetime AS return_datetime_8, t0.user_id AS user_id_9, t0.event_id AS event_id_10, t0.start_location_id AS start_location_id_11, t0.return_location_id AS return_location_id_12 FROM driver t0 WHERE t0.event_id = ?
Parameters:
[
  13
]
19 0.25 ms
SELECT t0.id AS id_1, t0.has_luggage AS has_luggage_2, t0.luggage_description AS luggage_description_3, t0.start_datetime AS start_datetime_4, t0.return_datetime AS return_datetime_5, t0.user_id AS user_id_6, t0.event_id AS event_id_7, t0.start_location_id AS start_location_id_8, t0.return_location_id AS return_location_id_9 FROM passenger t0 WHERE t0.event_id = ?
Parameters:
[
  13
]

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 37
App\Entity\Location 37
App\Entity\Passenger 30
App\Entity\Driver 13
App\Entity\Event 8

Entities Mapping

Class Mapping errors
App\Entity\Event
  • If association App\Entity\Event#owner is many-to-one, then the inversed side App\Entity\User#events has to be one-to-many.
  • If association App\Entity\Event#location is many-to-one, then the inversed side App\Entity\Location#events has to be one-to-many.
App\Entity\User No errors.
App\Entity\Location
  • The field App\Entity\Location#passengers is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Passenger#startLocation does not contain the required 'mappedBy="passengers"' attribute.
  • If association App\Entity\Location#passengers is many-to-many, then the inversed side App\Entity\Passenger#startLocation has to be many-to-many as well.
App\Entity\Driver
  • If association App\Entity\Driver#startLocation is many-to-one, then the inversed side App\Entity\Location#drivers has to be one-to-many.
App\Entity\Passenger
  • If association App\Entity\Passenger#startLocation is many-to-one, then the inversed side App\Entity\Location#drivers has to be one-to-many.
App\Entity\EventMatch No errors.
App\Entity\Profile No errors.