GET http://obcepro-dev.galosoft.cz/publikovane-dokumenty/prehled?page=55

Response
200 OK
IP
172.18.0.52
Profiled on
Token
04e0a7

Query Metrics

33 Database Queries
6 Different statements
62.04 ms Query time
3 Invalid entities
55 Managed entities

Queries

Group similar statements

#▲ Time Info
1 9.34 ms 
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pro_documents p0_ LEFT JOIN pro_obce p1_ ON p0_.obec_id = p1_.id LEFT JOIN pro_orp p2_ ON p1_.orp_id = p2_.id LEFT JOIN pro_kraje p3_ ON p1_.kraj_id = p3_.id WHERE p0_.published = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 4.35 ms 
SELECT DISTINCT p0_.id AS id_0, p0_.dateChanged AS dateChanged_1 FROM pro_documents p0_ LEFT JOIN pro_obce p1_ ON p0_.obec_id = p1_.id LEFT JOIN pro_orp p2_ ON p1_.orp_id = p2_.id LEFT JOIN pro_kraje p3_ ON p1_.kraj_id = p3_.id WHERE p0_.published = 1 ORDER BY p0_.dateChanged DESC LIMIT 10 OFFSET 540
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 36.57 ms 
SELECT p0_.id AS id_0, p0_.deleted AS deleted_1, p0_.typUzemi AS typUzemi_2, p0_.customApproved AS customApproved_3, p0_.enabled AS enabled_4, p0_.open_for_am AS open_for_am_5, p0_.published AS published_6, p0_.displayContent AS displayContent_7, p0_.content AS content_8, p0_.nazev AS nazev_9, p0_.popis AS popis_10, p0_.titulni_strana AS titulni_strana_11, p0_.uvod AS uvod_12, p0_.uzemi AS uzemi_13, p0_.obyvatelstvo AS obyvatelstvo_14, p0_.hospodarstvi AS hospodarstvi_15, p0_.infrastruktura AS infrastruktura_16, p0_.vybavenost_obce AS vybavenost_obce_17, p0_.zivotni_prostredi AS zivotni_prostredi_18, p0_.sprava_obce AS sprava_obce_19, p0_.vychodiska AS vychodiska_20, p0_.vize AS vize_21, p0_.number_cile AS number_cile_22, p0_.number_opatreni AS number_opatreni_23, p0_.number_aktivity AS number_aktivity_24, p0_.akcni_plan AS akcni_plan_25, p0_.podpora_realizace AS podpora_realizace_26, p0_.seznam_pouzitych_zkratek AS seznam_pouzitych_zkratek_27, p0_.dateCreated AS dateCreated_28, p0_.dateChanged AS dateChanged_29, p0_.ip AS ip_30, p0_.locked_at AS locked_at_31, p0_.lock_token AS lock_token_32, p0_.od AS od_33, p0_.do AS do_34, p0_.zacatek AS zacatek_35, p0_.uzemi_od AS uzemi_od_36, p0_.uzemi_do AS uzemi_do_37, p0_.obyvatelstvo_od AS obyvatelstvo_od_38, p0_.obyvatelstvo_do AS obyvatelstvo_do_39, p0_.hospodarstvi_od AS hospodarstvi_od_40, p0_.hospodarstvi_do AS hospodarstvi_do_41, p0_.infrastruktura_od AS infrastruktura_od_42, p0_.infrastruktura_do AS infrastruktura_do_43, p0_.vybavenost_obce_od AS vybavenost_obce_od_44, p0_.vybavenost_obce_do AS vybavenost_obce_do_45, p0_.zivotni_prostredi_od AS zivotni_prostredi_od_46, p0_.zivotni_prostredi_do AS zivotni_prostredi_do_47, p0_.sprava_obce_od AS sprava_obce_od_48, p0_.sprava_obce_do AS sprava_obce_do_49, p0_.uzemi_finished AS uzemi_finished_50, p0_.obyvatelstvo_finished AS obyvatelstvo_finished_51, p0_.hospodarstvi_finished AS hospodarstvi_finished_52, p0_.infrastruktura_finished AS infrastruktura_finished_53, p0_.vybavenost_obce_finished AS vybavenost_obce_finished_54, p0_.zivotni_prostredi_finished AS zivotni_prostredi_finished_55, p0_.sprava_obce_finished AS sprava_obce_finished_56, p0_.obec_id AS obec_id_57, p0_.author_id AS author_id_58, p0_.locked_by_id AS locked_by_id_59, p0_.uzemi_processed_by_id AS uzemi_processed_by_id_60, p0_.obyvatelstvo_processed_by_id AS obyvatelstvo_processed_by_id_61, p0_.hospodarstvi_processed_by_id AS hospodarstvi_processed_by_id_62, p0_.infrastruktura_processed_by_id AS infrastruktura_processed_by_id_63, p0_.vybavenost_obce_processed_by_id AS vybavenost_obce_processed_by_id_64, p0_.zivotni_prostredi_processed_by_id AS zivotni_prostredi_processed_by_id_65, p0_.sprava_obce_processed_by_id AS sprava_obce_processed_by_id_66 FROM pro_documents p0_ LEFT JOIN pro_obce p1_ ON p0_.obec_id = p1_.id LEFT JOIN pro_orp p2_ ON p1_.orp_id = p2_.id LEFT JOIN pro_kraje p3_ ON p1_.kraj_id = p3_.id WHERE p0_.published = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.dateChanged DESC
Parameters: 
[
  239
  247
  270
  220
  234
  63
  214
  219
  231
  208
]
View formatted query    View runnable query    Explain query
4 0.24 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  239
]
View formatted query    View runnable query    Explain query
5 0.25 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  239
]
View formatted query    View runnable query    Explain query
6 0.38 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  247
]
View formatted query    View runnable query    Explain query
7 0.36 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  247
]
View formatted query    View runnable query    Explain query
8 0.36 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  270
]
View formatted query    View runnable query    Explain query
9 0.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  270
]
View formatted query    View runnable query    Explain query
10 0.35 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  220
]
View formatted query    View runnable query    Explain query
11 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  220
]
View formatted query    View runnable query    Explain query
12 0.38 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  234
]
View formatted query    View runnable query    Explain query
13 0.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  234
]
View formatted query    View runnable query    Explain query
14 0.35 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  63
]
View formatted query    View runnable query    Explain query
15 0.33 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  63
]
View formatted query    View runnable query    Explain query
16 0.37 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  214
]
View formatted query    View runnable query    Explain query
17 0.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  214
]
View formatted query    View runnable query    Explain query
18 0.41 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  219
]
View formatted query    View runnable query    Explain query
19 0.37 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  219
]
View formatted query    View runnable query    Explain query
20 0.39 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  231
]
View formatted query    View runnable query    Explain query
21 0.36 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  231
]
View formatted query    View runnable query    Explain query
22 0.36 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.urlDel AS urlDel_3, t0.size AS size_4, t0.date AS date_5, t0.ip AS ip_6, t0.document_id AS document_id_7 FROM pro_znaky t0 WHERE t0.document_id = ?
Parameters: 
[
  208
]
View formatted query    View runnable query    Explain query
23 0.37 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.url AS url_4, t0.urlDel AS urlDel_5, t0.size AS size_6, t0.date AS date_7, t0.ip AS ip_8, t0.user_id AS user_id_9, t0.document_id AS document_id_10, t0.documentAttachment_id AS documentAttachment_id_11, t0.activityAttachment_id AS activityAttachment_id_12, t0.stepAttachment_id AS stepAttachment_id_13, t0.inventionAttachment_id AS inventionAttachment_id_14, t0.inventionThumbnail_id AS inventionThumbnail_id_15, t0.smartAttachment_id AS smartAttachment_id_16 FROM pro_files t0 WHERE t0.document_id = ?
Parameters: 
[
  208
]
View formatted query    View runnable query    Explain query
24 0.51 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  6449
]
View formatted query    View runnable query    Explain query
25 0.46 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  6478
]
View formatted query    View runnable query    Explain query
26 0.45 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  6371
]
View formatted query    View runnable query    Explain query
27 0.48 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  6282
]
View formatted query    View runnable query    Explain query
28 0.48 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  6233
]
View formatted query    View runnable query    Explain query
29 0.50 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  3984
]
View formatted query    View runnable query    Explain query
30 0.47 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  4254
]
View formatted query    View runnable query    Explain query
31 0.48 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  4221
]
View formatted query    View runnable query    Explain query
32 0.47 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  4061
]
View formatted query    View runnable query    Explain query
33 0.45 ms 
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.iduz AS iduz_3, t0.nazev AS nazev_4, t0.url AS url_5, t0.typ AS typ_6, t0.rokod AS rokod_7, t0.rokdo AS rokdo_8, t0.id_orp AS id_orp_9, t0.id_okres AS id_okres_10, t0.id_kraj AS id_kraj_11, t0.koduz_mos AS koduz_mos_12, t0.nuts_mos AS nuts_mos_13, t0.orp_mos AS orp_mos_14, t0.komentar AS komentar_15, t0.date AS date_16, t0.dateCreated AS dateCreated_17, t0.dateChanged AS dateChanged_18, t0.ip AS ip_19, t0.kraj_id AS kraj_id_20, t0.region_id AS region_id_21, t0.okres_id AS okres_id_22, t0.orp_id AS orp_id_23 FROM pro_obce t0 WHERE t0.id = ?
Parameters: 
[
  4311
]
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\Document 10
App\Entity\Obec 10
App\Entity\User 10
App\Entity\Znak 9
App\Entity\ORP 8
App\Entity\Okres 6
App\Entity\Kraj 2

Entities Mapping

Class Mapping errors
App\Entity\Document No errors.
App\Entity\Obec No errors.
App\Entity\ORP No errors.
App\Entity\Kraj No errors.
App\Entity\User No errors.
App\Entity\Znak No errors.
App\Entity\File
  • The association App\Entity\File#user refers to the inverse side field App\Entity\User#files which does not exist.
App\Entity\Aktivita No errors.
App\Entity\Krok No errors.
App\Entity\Invention
  • The association App\Entity\Invention#author refers to the inverse side field App\Entity\User#inventions which does not exist.
  • The association App\Entity\Invention#keyword refers to the inverse side field App\Entity\Keyword#Invention which does not exist.
  • The association App\Entity\Invention#category refers to the inverse side field App\Entity\InventionCategory#invention which does not exist.
App\Entity\Smart
  • The association App\Entity\Smart#keyword refers to the inverse side field App\Entity\Keyword#kroky which does not exist.
App\Entity\Harmonogram No errors.
App\Entity\SWOT No errors.
App\Entity\Cil No errors.
App\Entity\Opatreni No errors.
App\Entity\Hodnoceni No errors.
App\Entity\Region No errors.
App\Entity\Okres No errors.
App\Entity\ObceData No errors.
App\Entity\RT No errors.
App\Entity\PS No errors.