Query Metrics
25
Database Queries
8
Different statements
24.51 ms
Query time
3
Invalid entities
95
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.41 ms (42.47%) |
14 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.priority AS priority_3, t0.nazev AS nazev_4, t0.oblast AS oblast_5, t0.dulezitost AS dulezitost_6, t0.od AS od_7, t0.do AS do_8, t0.naklady AS naklady_9, t0.zdroj AS zdroj_10, t0.odpovednost AS odpovednost_11, t0.komentar AS komentar_12, t0.komentarHodnoceni AS komentarHodnoceni_13, t0.hodnoceni AS hodnoceni_14, t0.date AS date_15, t0.dateCreated AS dateCreated_16, t0.dateChanged AS dateChanged_17, t0.ip AS ip_18, t0.document_id AS document_id_19, t0.documentStack_id AS documentStack_id_20, t0.opatreni_id AS opatreni_id_21, t0.author_id AS author_id_22 FROM pro_aktivity t0 WHERE t0.opatreni_id = ? ORDER BY t0.priority ASC
Parameters:
[
346
]
|
|
4.90 ms (19.98%) |
1 |
SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.typUzemi AS typUzemi_3, t0.customApproved AS customApproved_4, t0.enabled AS enabled_5, t0.open_for_am AS open_for_am_6, t0.published AS published_7, t0.displayContent AS displayContent_8, t0.content AS content_9, t0.nazev AS nazev_10, t0.popis AS popis_11, t0.titulni_strana AS titulni_strana_12, t0.uvod AS uvod_13, t0.uzemi AS uzemi_14, t0.obyvatelstvo AS obyvatelstvo_15, t0.hospodarstvi AS hospodarstvi_16, t0.infrastruktura AS infrastruktura_17, t0.vybavenost_obce AS vybavenost_obce_18, t0.zivotni_prostredi AS zivotni_prostredi_19, t0.sprava_obce AS sprava_obce_20, t0.vychodiska AS vychodiska_21, t0.vize AS vize_22, t0.number_cile AS number_cile_23, t0.number_opatreni AS number_opatreni_24, t0.number_aktivity AS number_aktivity_25, t0.akcni_plan AS akcni_plan_26, t0.podpora_realizace AS podpora_realizace_27, t0.seznam_pouzitych_zkratek AS seznam_pouzitych_zkratek_28, t0.dateCreated AS dateCreated_29, t0.dateChanged AS dateChanged_30, t0.ip AS ip_31, t0.locked_at AS locked_at_32, t0.lock_token AS lock_token_33, t0.od AS od_34, t0.do AS do_35, t0.zacatek AS zacatek_36, t0.uzemi_od AS uzemi_od_37, t0.uzemi_do AS uzemi_do_38, t0.obyvatelstvo_od AS obyvatelstvo_od_39, t0.obyvatelstvo_do AS obyvatelstvo_do_40, t0.hospodarstvi_od AS hospodarstvi_od_41, t0.hospodarstvi_do AS hospodarstvi_do_42, t0.infrastruktura_od AS infrastruktura_od_43, t0.infrastruktura_do AS infrastruktura_do_44, t0.vybavenost_obce_od AS vybavenost_obce_od_45, t0.vybavenost_obce_do AS vybavenost_obce_do_46, t0.zivotni_prostredi_od AS zivotni_prostredi_od_47, t0.zivotni_prostredi_do AS zivotni_prostredi_do_48, t0.sprava_obce_od AS sprava_obce_od_49, t0.sprava_obce_do AS sprava_obce_do_50, t0.uzemi_finished AS uzemi_finished_51, t0.obyvatelstvo_finished AS obyvatelstvo_finished_52, t0.hospodarstvi_finished AS hospodarstvi_finished_53, t0.infrastruktura_finished AS infrastruktura_finished_54, t0.vybavenost_obce_finished AS vybavenost_obce_finished_55, t0.zivotni_prostredi_finished AS zivotni_prostredi_finished_56, t0.sprava_obce_finished AS sprava_obce_finished_57, t0.obec_id AS obec_id_58, t59.id AS id_60, t59.url AS url_61, t59.urlDel AS urlDel_62, t59.size AS size_63, t59.date AS date_64, t59.ip AS ip_65, t59.document_id AS document_id_66, t67.id AS id_68, t67.name AS name_69, t67.mime AS mime_70, t67.url AS url_71, t67.urlDel AS urlDel_72, t67.size AS size_73, t67.date AS date_74, t67.ip AS ip_75, t67.user_id AS user_id_76, t67.document_id AS document_id_77, t67.documentAttachment_id AS documentAttachment_id_78, t67.activityAttachment_id AS activityAttachment_id_79, t67.stepAttachment_id AS stepAttachment_id_80, t67.inventionAttachment_id AS inventionAttachment_id_81, t67.inventionThumbnail_id AS inventionThumbnail_id_82, t67.smartAttachment_id AS smartAttachment_id_83, t0.author_id AS author_id_84, t0.locked_by_id AS locked_by_id_85, t0.uzemi_processed_by_id AS uzemi_processed_by_id_86, t0.obyvatelstvo_processed_by_id AS obyvatelstvo_processed_by_id_87, t0.hospodarstvi_processed_by_id AS hospodarstvi_processed_by_id_88, t0.infrastruktura_processed_by_id AS infrastruktura_processed_by_id_89, t0.vybavenost_obce_processed_by_id AS vybavenost_obce_processed_by_id_90, t0.zivotni_prostredi_processed_by_id AS zivotni_prostredi_processed_by_id_91, t0.sprava_obce_processed_by_id AS sprava_obce_processed_by_id_92 FROM pro_documents t0 LEFT JOIN pro_znaky t59 ON t59.document_id = t0.id LEFT JOIN pro_files t67 ON t67.document_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"256"
]
|
|
3.88 ms (15.81%) |
5 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.pagebreak AS pagebreak_3, t0.priority AS priority_4, t0.part AS part_5, t0.nazev AS nazev_6, t0.text AS text_7, t0.hodnoceni AS hodnoceni_8, t0.date AS date_9, t0.dateCreated AS dateCreated_10, t0.dateChanged AS dateChanged_11, t0.ip AS ip_12, t0.document_id AS document_id_13, t0.cil_id AS cil_id_14, t0.author_id AS author_id_15 FROM pro_opatreni t0 WHERE t0.cil_id = ? ORDER BY t0.priority ASC
Parameters:
[
202
]
|
|
1.87 ms (7.61%) |
1 |
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.enabled AS enabled_3, t0.publishable AS publishable_4, t0.type AS type_5, t0.part AS part_6, t0.nazev AS nazev_7, t0.text AS text_8, t0.date AS date_9, t0.dateCreated AS dateCreated_10, t0.dateChanged AS dateChanged_11, t0.ip AS ip_12, t0.document_id AS document_id_13, t0.author_id AS author_id_14 FROM pro_swot t0 WHERE t0.document_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
256
]
|
|
1.37 ms (5.61%) |
1 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.pagebreak AS pagebreak_3, t0.priority AS priority_4, t0.nazev AS nazev_5, t0.text AS text_6, t0.hodnoceni AS hodnoceni_7, t0.date AS date_8, t0.dateCreated AS dateCreated_9, t0.dateChanged AS dateChanged_10, t0.ip AS ip_11, t0.document_id AS document_id_12, t0.author_id AS author_id_13 FROM pro_cile t0 WHERE t0.document_id = ? ORDER BY t0.priority ASC
Parameters:
[
256
]
|
|
0.81 ms (3.29%) |
1 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.priority AS priority_3, t0.nazev AS nazev_4, t0.oblast AS oblast_5, t0.dulezitost AS dulezitost_6, t0.od AS od_7, t0.do AS do_8, t0.naklady AS naklady_9, t0.zdroj AS zdroj_10, t0.odpovednost AS odpovednost_11, t0.komentar AS komentar_12, t0.komentarHodnoceni AS komentarHodnoceni_13, t0.hodnoceni AS hodnoceni_14, t0.date AS date_15, t0.dateCreated AS dateCreated_16, t0.dateChanged AS dateChanged_17, t0.ip AS ip_18, t0.document_id AS document_id_19, t0.documentStack_id AS documentStack_id_20, t0.opatreni_id AS opatreni_id_21, t0.author_id AS author_id_22 FROM pro_aktivity t0 WHERE t0.documentStack_id = ?
Parameters:
[
256
]
|
|
0.75 ms (3.06%) |
1 |
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:
[
3243
]
|
|
0.53 ms (2.17%) |
1 |
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.documentAttachment_id = ?
Parameters:
[
256
]
|
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\SWOT | 42 |
| App\Entity\Aktivita | 27 |
| App\Entity\Opatreni | 14 |
| App\Entity\Cil | 5 |
| App\Entity\Document | 1 |
| App\Entity\Obec | 1 |
| App\Entity\User | 1 |
| App\Entity\Znak | 1 |
| App\Entity\Kraj | 1 |
| App\Entity\Okres | 1 |
| App\Entity\ORP | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Document | No errors. |
| App\Entity\Obec | No errors. |
| App\Entity\Znak | No errors. |
| App\Entity\File |
|
| App\Entity\User | No errors. |
| App\Entity\Aktivita | No errors. |
| App\Entity\Krok | No errors. |
| App\Entity\Invention |
|
| App\Entity\Smart |
|
| 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\Kraj | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Okres | No errors. |
| App\Entity\ORP | No errors. |
| App\Entity\ObceData | No errors. |
| App\Entity\RT | No errors. |
| App\Entity\PS | No errors. |
| App\Entity\Indicator | No errors. |
| App\Entity\Naklad | No errors. |