GET http://185.25.50.116:8080/magazines

Query Metrics

5 Database Queries
4 Different statements
159.04 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 100.53 ms
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM magazines m0_
Parameters:
[]
2 25.64 ms
SELECT DISTINCT m0_.id AS id_0, m0_.id AS id_1 FROM magazines m0_ ORDER BY m0_.id ASC LIMIT 20
Parameters:
[]
3 14.47 ms
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS slug_2, m0_.description AS description_3, m0_.year AS year_4, m0_.orientation AS orientation_5, m0_.dimensions AS dimensions_6, m0_.weight AS weight_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.created_by AS created_by_10, m0_.updated_by AS updated_by_11 FROM magazines m0_ WHERE m0_.id IN (?, ?) ORDER BY m0_.id ASC
Parameters:
[
  1
  2
]
4 17.50 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.month AS month_6, t0.year AS year_7, t0.pages AS pages_8, t0.price AS price_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.magazine_id AS magazine_id_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM magazine_issues t0 WHERE t0.magazine_id = ?
Parameters:
[
  1
]
5 0.90 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.month AS month_6, t0.year AS year_7, t0.pages AS pages_8, t0.price AS price_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.magazine_id AS magazine_id_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM magazine_issues t0 WHERE t0.magazine_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.

Entities Mapping