GET https://digitalmagazine.mavis.co.id/magazine/perspektif/15

Query Metrics

4 Database Queries
4 Different statements
9.88 ms Query time
0 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.12 ms
(41.69%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.edition AS edition_4, t0.period AS period_5, t0.uuid AS uuid_6, t0.convert_status AS convert_status_7, t0.page_count AS page_count_8, t0.width AS width_9, t0.height AS height_10, t0.image AS image_11, t0.pdf AS pdf_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.magazine_id AS magazine_id_15 FROM edition t0 WHERE t0.magazine_id = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[
  23
]
2.02 ms
(20.48%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.edition AS edition_4, t0.period AS period_5, t0.uuid AS uuid_6, t0.convert_status AS convert_status_7, t0.page_count AS page_count_8, t0.width AS width_9, t0.height AS height_10, t0.image AS image_11, t0.pdf AS pdf_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.magazine_id AS magazine_id_15 FROM edition t0 WHERE t0.magazine_id = ? AND t0.edition = ? LIMIT 1
Parameters:
[
  23
  "15"
]
1.93 ms
(19.55%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "perspektif"
]
1.81 ms
(18.28%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = ?
Parameters:
[
  24
]

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\Edition 5
App\Entity\Magazine 1
App\Entity\School 1
App\Entity\Area 1

Entities Mapping

Class Mapping errors
App\Entity\Magazine No errors.
App\Entity\School No errors.
App\Entity\Edition No errors.
App\Entity\Area No errors.