GET https://bibletimemaps.org/es/persons

Query Metrics

54 Database Queries
5 Different statements
23.34 ms Query time
3 Invalid entities
139 Managed entities

Queries

Group similar statements

# Time Info
1 2.58 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.approved AS approved_1, p0_.name AS name_2, p0_.born AS born_3, p0_.died AS died_4, p0_.born_estimated AS born_estimated_5, p0_.died_estimated AS died_estimated_6, p0_.gender AS gender_7, p0_.alternate_names AS alternate_names_8, p0_.url AS url_9, p0_.image AS image_10, p0_.is_abstract AS is_abstract_11, p0_.leaf_start AS leaf_start_12, p0_.leaf_out AS leaf_out_13, p0_.leaf_level AS leaf_level_14, p0_.born_calculated AS born_calculated_15, p0_.died_calculated AS died_calculated_16, p0_.born_at_father_age AS born_at_father_age_17, p0_.description AS description_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20 FROM person p0_ WHERE p0_.approved > 0) dctrn_result) dctrn_table
Parameters:
[]
2 0.96 ms
SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.approved AS approved_1, p0_.name AS name_2, p0_.born AS born_3, p0_.died AS died_4, p0_.born_estimated AS born_estimated_5, p0_.died_estimated AS died_estimated_6, p0_.gender AS gender_7, p0_.alternate_names AS alternate_names_8, p0_.url AS url_9, p0_.image AS image_10, p0_.is_abstract AS is_abstract_11, p0_.leaf_start AS leaf_start_12, p0_.leaf_out AS leaf_out_13, p0_.leaf_level AS leaf_level_14, p0_.born_calculated AS born_calculated_15, p0_.died_calculated AS died_calculated_16, p0_.born_at_father_age AS born_at_father_age_17, p0_.description AS description_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20 FROM person p0_ WHERE p0_.approved > 0) dctrn_result LIMIT 50
Parameters:
[]
3 1.14 ms
SELECT p0_.id AS id_0, p0_.approved AS approved_1, p0_.name AS name_2, p0_.born AS born_3, p0_.died AS died_4, p0_.born_estimated AS born_estimated_5, p0_.died_estimated AS died_estimated_6, p0_.gender AS gender_7, p0_.alternate_names AS alternate_names_8, p0_.url AS url_9, p0_.image AS image_10, p0_.is_abstract AS is_abstract_11, p0_.leaf_start AS leaf_start_12, p0_.leaf_out AS leaf_out_13, p0_.leaf_level AS leaf_level_14, p0_.born_calculated AS born_calculated_15, p0_.died_calculated AS died_calculated_16, p0_.born_at_father_age AS born_at_father_age_17, p0_.description AS description_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_21, p0_.folk_id AS folk_id_22, p0_.owner_id AS owner_id_23, p0_.lived_at_time_of_person_id AS lived_at_time_of_person_id_24, p0_.update_of_id AS update_of_id_25 FROM person p0_ WHERE p0_.approved > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  967
  968
  969
  970
  971
  972
  973
  974
  975
  976
  977
  978
  979
  980
  981
  982
  983
  985
  986
  987
  988
  989
  990
  991
  992
  993
  994
  995
  996
  997
  998
  999
  1000
  1001
  1002
  1003
  1004
  1005
  1006
  1007
  1008
  1009
  1010
  1011
  1012
  1013
  1014
  1015
  1016
  1017
]
4 0.77 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  967
]
5 0.41 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  968
]
6 0.33 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  969
]
7 0.37 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  970
]
8 0.36 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  971
]
9 0.32 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  972
]
10 0.32 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  973
]
11 0.31 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  974
]
12 0.32 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  975
]
13 0.33 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  976
]
14 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  977
]
15 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  978
]
16 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  979
]
17 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  980
]
18 0.37 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.name AS name_3, t0.born AS born_4, t0.died AS died_5, t0.born_estimated AS born_estimated_6, t0.died_estimated AS died_estimated_7, t0.gender AS gender_8, t0.alternate_names AS alternate_names_9, t0.url AS url_10, t0.image AS image_11, t0.is_abstract AS is_abstract_12, t0.leaf_start AS leaf_start_13, t0.leaf_out AS leaf_out_14, t0.leaf_level AS leaf_level_15, t0.born_calculated AS born_calculated_16, t0.died_calculated AS died_calculated_17, t0.born_at_father_age AS born_at_father_age_18, t0.description AS description_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_22, t0.folk_id AS folk_id_23, t0.owner_id AS owner_id_24, t0.lived_at_time_of_person_id AS lived_at_time_of_person_id_25, t0.update_of_id AS update_of_id_26 FROM person t0 WHERE t0.id = ?
Parameters:
[
  1591
]
19 3.30 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  981
]
20 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  982
]
21 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  983
]
22 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  985
]
23 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  986
]
24 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  987
]
25 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  988
]
26 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  989
]
27 0.29 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  990
]
28 0.45 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  991
]
29 0.29 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  992
]
30 0.30 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  993
]
31 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  994
]
32 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  995
]
33 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  996
]
34 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  997
]
35 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  998
]
36 0.29 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  999
]
37 0.31 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1000
]
38 0.29 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1001
]
39 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1002
]
40 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1003
]
41 0.25 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1004
]
42 0.28 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1005
]
43 0.27 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1006
]
44 0.30 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1007
]
45 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1008
]
46 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1009
]
47 0.33 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1010
]
48 0.29 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1011
]
49 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1012
]
50 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1013
]
51 0.26 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1014
]
52 0.30 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1015
]
53 0.32 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1016
]
54 0.33 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  1017
]

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\Person 94
App\Entity\PersonLink 45

Entities Mapping

Class Mapping errors
App\Entity\ChangeableEntity No errors.
App\Entity\Person No errors.
App\Entity\User
  • The mappings App\Entity\User#taggedEventsForDelete and App\Entity\Event#taggedForDeleteBy are inconsistent with each other.
App\Entity\Folk No errors.
App\Entity\EventPerson No errors.
App\Entity\Traits\BaseReference
  • The mappings App\Entity\Traits\BaseReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\PersonReference
  • The mappings App\Entity\PersonReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\Job No errors.
App\Entity\PersonLink No errors.
App\Entity\PersonVersion No errors.
App\Entity\Translation\PersonTranslation No errors.