Query Metrics
4
Database Queries
4
Different statements
2.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.07 ms (35.64%) |
1 |
SELECT a0_.id AS id_0, a0_.nazev AS nazev_1, a0_.popis AS popis_2, a0_.vychozi_cena AS vychozi_cena_3, a0_.aktualni_cena AS aktualni_cena_4, a0_.cas_zacatku AS cas_zacatku_5, a0_.cas_konce AS cas_konce_6, a0_.stav AS stav_7, a0_.hlavni_foto AS hlavni_foto_8, a0_.skryta AS skryta_9, a0_.vyuctovana AS vyuctovana_10, a0_.verejne_id AS verejne_id_11, a0_.uzivatel_id AS uzivatel_id_12, a0_.vitez_id AS vitez_id_13, a0_.typ_id AS typ_id_14 FROM aukce a0_ LEFT JOIN aukce_kategorie a1_ ON a0_.id = a1_.aukce_id LEFT JOIN kategorie k2_ ON a1_.kategorie_id = k2_.id WHERE a0_.stav = ? AND a0_.skryta = 0 ORDER BY a0_.cas_zacatku DESC LIMIT 6
Parameters:
[
"aktivni"
]
|
|
0.73 ms (24.40%) |
1 |
SELECT a0_.id AS id_0, a0_.nazev AS nazev_1, a0_.popis AS popis_2, a0_.vychozi_cena AS vychozi_cena_3, a0_.aktualni_cena AS aktualni_cena_4, a0_.cas_zacatku AS cas_zacatku_5, a0_.cas_konce AS cas_konce_6, a0_.stav AS stav_7, a0_.hlavni_foto AS hlavni_foto_8, a0_.skryta AS skryta_9, a0_.vyuctovana AS vyuctovana_10, a0_.verejne_id AS verejne_id_11, a0_.uzivatel_id AS uzivatel_id_12, a0_.vitez_id AS vitez_id_13, a0_.typ_id AS typ_id_14 FROM aukce a0_ LEFT JOIN aukce_kategorie a1_ ON a0_.id = a1_.aukce_id LEFT JOIN kategorie k2_ ON a1_.kategorie_id = k2_.id WHERE a0_.stav = ? AND a0_.cas_zacatku >= ? AND a0_.skryta = 0 ORDER BY a0_.cas_zacatku DESC LIMIT 6
Parameters:
[ "aktivni" "2026-03-24 00:00:00" ] |
|
0.63 ms (21.22%) |
1 |
SELECT a0_.id AS id_0, a0_.nazev AS nazev_1, a0_.popis AS popis_2, a0_.vychozi_cena AS vychozi_cena_3, a0_.aktualni_cena AS aktualni_cena_4, a0_.cas_zacatku AS cas_zacatku_5, a0_.cas_konce AS cas_konce_6, a0_.stav AS stav_7, a0_.hlavni_foto AS hlavni_foto_8, a0_.skryta AS skryta_9, a0_.vyuctovana AS vyuctovana_10, a0_.verejne_id AS verejne_id_11, a0_.uzivatel_id AS uzivatel_id_12, a0_.vitez_id AS vitez_id_13, a0_.typ_id AS typ_id_14 FROM aukce a0_ LEFT JOIN aukce_kategorie a1_ ON a0_.id = a1_.aukce_id LEFT JOIN kategorie k2_ ON a1_.kategorie_id = k2_.id WHERE a0_.stav = ? AND a0_.cas_konce > ? AND a0_.skryta = 0 ORDER BY a0_.cas_konce ASC LIMIT 6
Parameters:
[ "aktivni" "2026-03-24 08:53:13" ] |
|
0.56 ms (18.74%) |
1 |
SELECT k0_.id AS id_0, k0_.nazev AS nazev_1, k0_.popis AS popis_2 FROM kategorie k0_ ORDER BY k0_.nazev ASC
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Aukce | No errors. |
| App\Entity\AukceKategorie | No errors. |
| App\Entity\Kategorie | No errors. |
| App\Entity\Uzivatel | No errors. |