GET https://bibletimemaps.org/en/checklist

Query Metrics

154 Database Queries
4 Different statements
47.24 ms Query time
1 Invalid entities
1467 Managed entities

Grouped Statements

Show all queries

Time Count Info
26.96 ms
(57.08%)
86
SELECT t0.id AS id_1, t0.type AS type_2, t0.verse_id AS verse_id_3, t0.user_id AS user_id_4 FROM check2_user t0 WHERE t0.verse_id = ?
Parameters:
[
  129
]
18.86 ms
(39.92%)
66
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.chapters AS chapters_4, t0.full_name AS full_name_5, t0.from_year AS from_year_6, t0.to_year AS to_year_7 FROM bible_books t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.85 ms
(1.80%)
1
SELECT t0.id AS id_1, t0.chapter AS chapter_2, t0.verses AS verses_3, t0.book_id AS book_id_4 FROM chapter_verses t0
Parameters:
[]
0.56 ms
(1.19%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.verse_id AS verse_id_3, t0.user_id AS user_id_4 FROM check2_user 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\ChapterVerses 1189
App\Entity\Check2User 210
App\Entity\BibleBooks 66
App\Entity\User 2

Entities Mapping

Class Mapping errors
App\Entity\ChapterVerses No errors.
App\Entity\BibleBooks No errors.
App\Entity\Check2User No errors.
App\Entity\User
  • The mappings App\Entity\User#taggedEventsForDelete and App\Entity\Event#taggedForDeleteBy are inconsistent with each other.
App\Entity\Reference No errors.