Query Metrics
12
Database Queries
6
Different statements
5.69 ms
Query time
0
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = ? LIMIT 1
Parameters:
[
"en"
]
|
| 2 | 0.63 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 0.66 ms |
SELECT p0_.id AS id_0, p0_.photo_file AS photo_file_1, p0_.rotate AS rotate_2, p0_.location_id AS location_id_3, p0_.uploaded_by_id AS uploaded_by_id_4 FROM photos p0_ WHERE p0_.location_id = ?
Parameters:
[
1
]
|
| 4 | 0.39 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 5 | 0.40 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
1
]
|
| 6 | 0.30 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 7 | 0.31 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 8 | 0.53 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
| 9 | 0.65 ms |
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
"Useful Guide"
]
|
| 10 | 0.46 ms |
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
"Useful Guide"
]
|
| 11 | 0.40 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
| 12 | 0.30 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
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\PhotoLocations | 2 |
| App\Entity\Languages | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Languages | No errors. |
| App\Entity\PhotoLocations | No errors. |
| App\Entity\Photos | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Product | No errors. |