Symfony Profiler

Query Metrics

45 Database Queries

13 Different statements

79.07 ms Query time

4 Invalid entities

57 Managed entities

Queries


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
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
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'obcepro_cz_dev' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	31.37 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 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 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;
2	5.55 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 Parameters: [] View formatted query View runnable query Explain query 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 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;
3	14.10 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: [`2409 3100 3090 1967 3075 3071 3062 2760 2861 3048`] View formatted query View runnable query Explain query 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 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 (2409, 3100, 3090, 1967, 3075, 3071, 3062, 2760, 2861, 3048) ORDER BY p0_.dateChanged DESC;
4	0.34 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: [`2409`] View formatted query View runnable query Explain query 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 = ? 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 = 2409;
5	0.44 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: [`2409`] View formatted query View runnable query Explain query 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 = ? 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 = 2409;
6	0.43 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: [`3100`] View formatted query View runnable query Explain query 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 = ? 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 = 3100;
7	0.44 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: [`3100`] View formatted query View runnable query Explain query 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 = ? 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 = 3100;
8	0.40 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: [`3090`] View formatted query View runnable query Explain query 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 = ? 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 = 3090;
9	0.43 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: [`3090`] View formatted query View runnable query Explain query 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 = ? 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 = 3090;
10	0.40 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: [`1967`] View formatted query View runnable query Explain query 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 = ? 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 = 1967;
11	0.41 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: [`1967`] View formatted query View runnable query Explain query 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 = ? 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 = 1967;
12	0.40 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: [`3075`] View formatted query View runnable query Explain query 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 = ? 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 = 3075;
13	0.44 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: [`3075`] View formatted query View runnable query Explain query 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 = ? 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 = 3075;
14	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: [`3071`] View formatted query View runnable query Explain query 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 = ? 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 = 3071;
15	0.44 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: [`3071`] View formatted query View runnable query Explain query 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 = ? 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 = 3071;
16	0.42 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: [`3062`] View formatted query View runnable query Explain query 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 = ? 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 = 3062;
17	0.38 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: [`3062`] View formatted query View runnable query Explain query 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 = ? 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 = 3062;
18	0.42 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: [`2760`] View formatted query View runnable query Explain query 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 = ? 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 = 2760;
19	0.41 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: [`2760`] View formatted query View runnable query Explain query 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 = ? 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 = 2760;
20	0.42 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: [`2861`] View formatted query View runnable query Explain query 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 = ? 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 = 2861;
21	0.47 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: [`2861`] View formatted query View runnable query Explain query 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 = ? 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 = 2861;
22	0.42 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: [`3048`] View formatted query View runnable query Explain query 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 = ? 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 = 3048;
23	0.43 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: [`3048`] View formatted query View runnable query Explain query 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 = ? 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 = 3048;
24	0.39 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: [`2118`] View formatted query View runnable query Explain query 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 = ? 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 = 2118;
25	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: [`1381`] View formatted query View runnable query Explain query 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 = ? 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 = 1381;
26	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: [`3509`] View formatted query View runnable query Explain query 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 = ? 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 = 3509;
27	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: [`5530`] View formatted query View runnable query Explain query 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 = ? 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 = 5530;
28	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: [`1337`] View formatted query View runnable query Explain query 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 = ? 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 = 1337;
29	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: [`2131`] View formatted query View runnable query Explain query 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 = ? 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 = 2131;
30	0.49 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: [`5573`] View formatted query View runnable query Explain query 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 = ? 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 = 5573;
31	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: [`3615`] View formatted query View runnable query Explain query 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 = ? 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 = 3615;
32	0.52 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: [`5093`] View formatted query View runnable query Explain query 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 = ? 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 = 5093;
33	0.23 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
34	2.57 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"obcepro_cz_dev"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'obcepro_cz_dev' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
35	0.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
36	2.38 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"obcepro_cz_dev"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'obcepro_cz_dev' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
37	0.24 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
38	1.89 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"obcepro_cz_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'obcepro_cz_dev' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
39	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
40	2.52 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'obcepro_cz_dev' / ORDER BY k.ORDINAL_POSITION Parameters: [`"obcepro_cz_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'obcepro_cz_dev' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'obcepro_cz_dev' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'obcepro_cz_dev' / ORDER BY k.ORDINAL_POSITION;
41	3.28 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"obcepro_cz_dev" "obcepro_cz_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'obcepro_cz_dev' AND t.TABLE_SCHEMA = 'obcepro_cz_dev' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
42	0.25 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
43	1.32 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"obcepro_cz_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'obcepro_cz_dev' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
44	0.25 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
45	0.18 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

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\ORP	8
App\Entity\Okres	7
App\Entity\Znak	5
App\Entity\Kraj	4
App\Entity\File	3

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.
App\Entity\ORPData	No errors.
App\Entity\KrajData	No errors.
App\Entity\Audit	No errors.
App\Entity\Notepad	No errors.
App\Entity\Naklad	No errors.
App\Entity\Keyword	The association App\Entity\Keyword#invention refers to the owning side field App\Entity\Invention#Keyword which does not exist. The mappings App\Entity\Keyword#smarty and App\Entity\Smart#keyword are inconsistent with each other.
App\Entity\InventionCategory	No errors.
App\Entity\Indicator	No errors.
App\Entity\OkresData	No errors.
App\Entity\Identificator	No errors.

Symfony Profiler

GET http://obcepro-dev.galosoft.cz/publikovane-dokumenty

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping