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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.45 ms
(29.58%)
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
]
0.94 ms
(19.07%)
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.83 ms
(16.89%)
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.73 ms
(14.79%)
2
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
0.70 ms
(14.24%)
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.27 ms
(5.44%)
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.