Query Metrics

7 Database Queries
4 Different statements
4.21 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.reset_token AS reset_token_9, t0.last_login AS last_login_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.id AS id_14, t13.reference AS reference_15, t13.membership_start AS membership_start_16, t13.membership_end AS membership_end_17, t13.membership_type AS membership_type_18, t13.membership_amount AS membership_amount_19, t13.is_manually_created AS is_manually_created_20, t13.created_at AS created_at_21, t13.updated_at AS updated_at_22, t13.user_id AS user_id_23 FROM user t0 LEFT JOIN membership t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
2 0.67 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.reset_token AS reset_token_9, t0.last_login AS last_login_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.id AS id_14, t13.reference AS reference_15, t13.membership_start AS membership_start_16, t13.membership_end AS membership_end_17, t13.membership_type AS membership_type_18, t13.membership_amount AS membership_amount_19, t13.is_manually_created AS is_manually_created_20, t13.created_at AS created_at_21, t13.updated_at AS updated_at_22, t13.user_id AS user_id_23 FROM user t0 LEFT JOIN membership t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "17"
]
3 0.65 ms
SELECT t0.id AS id_1, t0.is_manager AS is_manager_2, t0.notified_by_email AS notified_by_email_3, t0.notified_by_sms AS notified_by_sms_4, t0.garden_id AS garden_id_5, t0.user_id AS user_id_6 FROM user_garden t0 WHERE t0.user_id = ?
Parameters:
[
  17
]
4 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.project_start_date AS project_start_date_3, t0.address AS address_4, t0.post_code AS post_code_5, t0.coordinates_latitude AS coordinates_latitude_6, t0.coordinates_longitude AS coordinates_longitude_7, t0.position AS position_8, t0.qr_code AS qr_code_9, t0.qr_code_stat AS qr_code_stat_10, t0.app_id AS app_id_11, t0.image_upload AS image_upload_12, t0.city_id AS city_id_13, t0.garden_type_id AS garden_type_id_14 FROM garden t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.project_start_date AS project_start_date_3, t0.address AS address_4, t0.post_code AS post_code_5, t0.coordinates_latitude AS coordinates_latitude_6, t0.coordinates_longitude AS coordinates_longitude_7, t0.position AS position_8, t0.qr_code AS qr_code_9, t0.qr_code_stat AS qr_code_stat_10, t0.app_id AS app_id_11, t0.image_upload AS image_upload_12, t0.city_id AS city_id_13, t0.garden_type_id AS garden_type_id_14 FROM garden t0 WHERE t0.id = ?
Parameters:
[
  8
]
6 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.project_start_date AS project_start_date_3, t0.address AS address_4, t0.post_code AS post_code_5, t0.coordinates_latitude AS coordinates_latitude_6, t0.coordinates_longitude AS coordinates_longitude_7, t0.position AS position_8, t0.qr_code AS qr_code_9, t0.qr_code_stat AS qr_code_stat_10, t0.app_id AS app_id_11, t0.image_upload AS image_upload_12, t0.city_id AS city_id_13, t0.garden_type_id AS garden_type_id_14 FROM garden t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.48 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.project_start_date AS project_start_date_2, g0_.address AS address_3, g0_.post_code AS post_code_4, g0_.coordinates_latitude AS coordinates_latitude_5, g0_.coordinates_longitude AS coordinates_longitude_6, g0_.position AS position_7, g0_.qr_code AS qr_code_8, g0_.qr_code_stat AS qr_code_stat_9, g0_.app_id AS app_id_10, g0_.image_upload AS image_upload_11, g0_.city_id AS city_id_12, g0_.garden_type_id AS garden_type_id_13 FROM garden g0_
Parameters:
[]

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\User No errors.
App\Entity\Membership No errors.
App\Entity\UserGarden No errors.
App\Entity\Address No errors.
App\Entity\Order No errors.
App\Entity\Notification No errors.
App\Entity\DonationHistory No errors.
App\Entity\MembershipHistory No errors.
App\Entity\Garden No errors.
App\Entity\City No errors.
App\Entity\GardenType No errors.
App\Entity\Agribac No errors.
App\Entity\ZoneTaskByGarden No errors.