GET https://aphroditewintercashcup.atts-systems.com/photos/index

Query Metrics

8 Database Queries
5 Different statements
3.47 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.87 ms
(25.15%)
2
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
0.67 ms
(19.41%)
2
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
]
0.66 ms
(19.01%)
2
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.64 ms
(18.57%)
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.62 ms
(17.85%)
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
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.

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\Photos No errors.
App\Entity\PhotoLocations No errors.
App\Entity\User No errors.
App\Entity\Product No errors.