GET https://aphroditewintercashcup.atts-systems.com/photos/location/2/All/Thumbnail

Query Metrics

12 Database Queries
6 Different statements
7.03 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.03 ms
(28.95%)
4
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:
[
  2
]
1.58 ms
(22.46%)
3
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"
]
1.27 ms
(18.00%)
2
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
1.01 ms
(14.35%)
1
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:
[
  2
]
0.69 ms
(9.77%)
1
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"
]
0.45 ms
(6.47%)
1
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:
[
  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\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.