GET https://lootopia-test.ordwen-dev.com/hunts?page=3

Query Metrics

43 Database Queries
8 Different statements
59.85 ms Query time
3 Invalid entities
40 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.76 ms
(17.98%)
8
SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = ?
Parameters:
[
  3
]
10.32 ms
(17.24%)
8
SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t1.discriminator FROM organizer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  1
]
10.26 ms
(17.14%)
8
SELECT t0.id AS id_1, t0.cost AS cost_2, t0.participants_limit AS participants_limit_3, t0.hunt_id AS hunt_id_4 FROM participation_condition t0 WHERE t0.hunt_id = ?
Parameters:
[
  3
]
8.99 ms
(15.03%)
8
SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = ?
Parameters:
[
  3
]
8.76 ms
(14.64%)
8
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = ?
Parameters:
[
  3
]
6.13 ms
(10.25%)
1
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM hunt h0_ WHERE h0_.public = 1
Parameters:
[]
2.60 ms
(4.35%)
1
SELECT h0_.id AS id_0, h0_.description AS description_1, h0_.public AS public_2, h0_.world AS world_3, h0_.title AS title_4, h0_.created_at AS created_at_5, h0_.organizer_id AS organizer_id_6 FROM hunt h0_ WHERE h0_.public = 1 AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.created_at DESC
Parameters:
[
  3
  55
  53
  32
  21
  60
  7
  57
]
2.03 ms
(3.38%)
1
SELECT DISTINCT h0_.id AS id_0, h0_.created_at AS created_at_1 FROM hunt h0_ WHERE h0_.public = 1 ORDER BY h0_.created_at DESC LIMIT 9 OFFSET 18
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\Hunt 8
App\Entity\ParticipationCondition 8
App\Entity\User 8
App\Entity\Landmark 8
App\Entity\Reward 8

Entities Mapping

Class Mapping errors
App\Entity\Hunt
  • The mappings App\Entity\Hunt#rewards and App\Entity\Reward#hunt are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Organizer No errors.
App\Entity\ParticipationCondition No errors.
App\Entity\Reward
  • If association App\Entity\Reward#hunt is many-to-one, then the inversed side App\Entity\Hunt#conditions has to be one-to-many.
App\Entity\Participant No errors.
App\Entity\Landmark
  • The field 'App\Entity\Landmark#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Landmark#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.