GET https://aphroditewintercashcup.atts-systems.com/photos/location/1/All/Full

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.20 ms
(28.82%)
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:
[
  1
]
0.88 ms
(21.11%)
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"
]
0.67 ms
(16.08%)
2
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
0.66 ms
(15.81%)
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.53 ms
(12.81%)
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:
[
  1
]
0.22 ms
(5.37%)
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:
[
  1
]

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.