https://lod-backend.dev.lightbulb.lu/api/nl/word-of-the-day?_app_name=LOD_NL

Query Metrics

2 Database Queries
2 Different statements
12.90 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.26 ms
(56.25%)
1
SELECT h0_.id AS id_0, h0_.start_at AS start_at_1, h0_.entry_id AS entry_id_2 FROM highlighted_entries h0_ WHERE h0_.start_at <= ? AND h0_.start_at <= ? ORDER BY h0_.start_at DESC LIMIT 1
Parameters:
[
  "2026-04-09 00:00:00"
  "2026-04-09 00:00:00"
]
5.65 ms
(43.75%)
1
SELECT t0.id AS id_1, t0.number AS number_2, t0.lod_id AS lod_id_3, t0.pos AS pos_4, t0.pos_label AS pos_label_5, t0.lemma AS lemma_6, t0.n_rule_form AS n_rule_form_7, t0.trademark AS trademark_8, t0.ipa AS ipa_9, t0.coordinates_center AS coordinates_center_10, t0.coordinates_geo_json AS coordinates_geo_json_11, t0.added_at AS added_at_12, t0.tables AS tables_13, t0.micro_structures AS micro_structures_14, t0.audio_string AS audio_string_15, t0.audio_files AS audio_files_16, t0.synonyms AS synonyms_17, t0.videos AS videos_18, t0.infoboxes AS infoboxes_19, t0.is_sensitive AS is_sensitive_20, t0.is_visible_in_new_entries AS is_visible_in_new_entries_21 FROM entries t0 WHERE t0.id = ?
Parameters:
[
  26032
]

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.

Entities Mapping

Class Mapping errors
App\Entity\HighlightedEntry No errors.
App\Entity\Entry
  • The referenced column name 'lod_id' has to be a primary key column on the target entity class 'App\Entity\Entry'.
  • The referenced column name 'code' has to be a primary key column on the target entity class 'App\Entity\Category'.
App\Entity\Category No errors.