GET https://dev.talkinbroadway.com/new-jersey

Query Metrics

6 Database Queries
4 Different statements
4.17 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.regionUrl AS regionUrl_4, t0.not_show AS not_show_5 FROM location_dictionary t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "new-jersey"
]
2 0.84 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.date AS date_4, t0.displayLocation AS displayLocation_5, t0.location_id AS location_id_6, t0.type_id AS type_id_7 FROM news t0 WHERE t0.location_id = ?
Parameters:
[
  15
]
3 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.regionUrl AS regionUrl_4, t0.not_show AS not_show_5 FROM location_dictionary t0
Parameters:
[]
4 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.regionUrl AS regionUrl_4, t0.not_show AS not_show_5 FROM location_dictionary t0
Parameters:
[]
5 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM type_dictionary t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM type_dictionary t0 WHERE t0.id = ?
Parameters:
[
  3
]

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.

Entities Mapping

Class Mapping errors
App\Entity\News No errors.
App\Entity\LocationDictionary No errors.
App\Entity\TypeDictionary No errors.