GET https://bibletimemaps.org/es/location/list

Response
200 OK
IP
216.73.216.24
Profiled on
Token
808ebf

Query Metrics

4 Database Queries
4 Different statements
3.69 ms Query time
3 Invalid entities
50 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.20 ms 
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.type AS type_2, l0_.lat AS lat_3, l0_.lon AS lon_4 FROM location l0_ WHERE l0_.approved > 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.75 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT l0_.id AS id_0, l0_.approved AS approved_1, l0_.name AS name_2, l0_.lat AS lat_3, l0_.lon AS lon_4, l0_.type AS type_5, l0_.description AS description_6, l0_.image AS image_7, l0_.today_known_as AS today_known_as_8, l0_.coordinate_source AS coordinate_source_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11 FROM location l0_ WHERE l0_.approved > 0) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.80 ms 
SELECT DISTINCT id_0 FROM (SELECT l0_.id AS id_0, l0_.approved AS approved_1, l0_.name AS name_2, l0_.lat AS lat_3, l0_.lon AS lon_4, l0_.type AS type_5, l0_.description AS description_6, l0_.image AS image_7, l0_.today_known_as AS today_known_as_8, l0_.coordinate_source AS coordinate_source_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11 FROM location l0_ WHERE l0_.approved > 0) dctrn_result LIMIT 50
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.93 ms 
SELECT l0_.id AS id_0, l0_.approved AS approved_1, l0_.name AS name_2, l0_.lat AS lat_3, l0_.lon AS lon_4, l0_.type AS type_5, l0_.description AS description_6, l0_.image AS image_7, l0_.today_known_as AS today_known_as_8, l0_.coordinate_source AS coordinate_source_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_12, l0_.owner_id AS owner_id_13, l0_.update_of_id AS update_of_id_14 FROM location l0_ WHERE l0_.approved > 0 AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  4
  5
  6
  8
  9
  10
  11
  12
  13
  14
  15
  18
  19
  21
  22
  23
  24
  25
  26
  27
  29
  30
  33
  34
  35
  36
  38
  41
  42
  45
  46
  48
  49
  50
  51
  53
  54
  55
  56
  57
  60
  61
  62
  65
  66
  67
  73
  74
  75
  76
]
View formatted query    View runnable query    Explain query

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\Location 50

Entities Mapping

Class Mapping errors
App\Entity\ChangeableEntity No errors.
App\Entity\Location No errors.
App\Entity\User
  • The mappings App\Entity\User#taggedEventsForDelete and App\Entity\Event#taggedForDeleteBy are inconsistent with each other.
App\Entity\Event 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\LocationReference
  • The mappings App\Entity\LocationReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\TravelPath No errors.
App\Entity\Translation\LocationTranslation No errors.