GET https://digitalmagazine.mavis.co.id/

Query Metrics

11 Database Queries
3 Different statements
64.33 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 26.73 ms
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 ORDER BY t0.created_at DESC LIMIT 8
Parameters:
[]
2 16.08 ms
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.id = ?
Parameters:
[
  9
]
3 13.44 ms
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:
[
  8
]
4 1.28 ms
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.id = ?
Parameters:
[
  27
]
5 1.00 ms
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:
[
  19
]
6 1.14 ms
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.id = ?
Parameters:
[
  23
]
7 1.02 ms
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
]
8 0.93 ms
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.id = ?
Parameters:
[
  37
]
9 0.79 ms
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:
[
  35
]
10 0.97 ms
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.id = ?
Parameters:
[
  31
]
11 0.95 ms
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:
[
  30
]

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 8
App\Entity\Magazine 5
App\Entity\School 5
App\Entity\Area 3

Entities Mapping

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