GET https://doli.serv-kompixel.fr/contest/all

Query Metrics

2 Database Queries
2 Different statements
8.12 ms Query time
1 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 3.41 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.image_url AS image_url_4, c0_.start_date AS start_date_5, c0_.end_date AS end_date_6, c0_.winner_count AS winner_count_7, c0_.status AS status_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.commerce_id AS commerce_id_11, c0_.category_id AS category_id_12 FROM contest c0_ WHERE c0_.status = ? AND c0_.start_date <= ? AND c0_.end_date >= ? ORDER BY c0_.start_date ASC
Parameters:
[
  "active"
  "2025-12-16 01:42:28"
  "2025-12-16 01:42:28"
]
2 4.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.color AS color_5, t0.created_at AS created_at_6 FROM category 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\Category 8

Entities Mapping

Class Mapping errors
App\Entity\Contest No errors.
App\Entity\CommerceProfile No errors.
App\Entity\Category
  • The field App\Entity\Category#contests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contest#category does not contain the required 'inversedBy="contests"' attribute.