Query Metrics
7
Database Queries
4
Different statements
4.21 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.69 ms (40.23%) |
3 |
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
]
|
1.39 ms (32.98%) |
2 |
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
]
|
0.65 ms (15.49%) |
1 |
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
]
|
0.48 ms (11.29%) |
1 |
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. |