Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.78 ms Query time

4 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.69 ms (38.72%)	1	SELECT t0.id AS id_1, t0.type AS type_2, t0.newsletter AS newsletter_3, t0.cislo_dokumentu AS cislo_dokumentu_4, t0.vystup AS vystup_5, t0.instituce AS instituce_6, t0.datum AS datum_7, t0.cislo AS cislo_8, t0.vyzkumny_projekt AS vyzkumny_projekt_9, t0.nazev AS nazev_10, t0.resitel AS resitel_11, t0.tel AS tel_12, t0.email AS email_13, t0.text AS text_14, t0.link AS link_15, t0.enabled AS enabled_16, t0.published AS published_17, t0.dateCreated AS dateCreated_18, t0.dateChanged AS dateChanged_19, t20.id AS id_21, t20.name AS name_22, t20.mime AS mime_23, t20.url AS url_24, t20.urlDel AS urlDel_25, t20.size AS size_26, t20.date AS date_27, t20.ip AS ip_28, t20.user_id AS user_id_29, t20.document_id AS document_id_30, t20.documentAttachment_id AS documentAttachment_id_31, t20.activityAttachment_id AS activityAttachment_id_32, t20.stepAttachment_id AS stepAttachment_id_33, t20.inventionAttachment_id AS inventionAttachment_id_34, t20.inventionThumbnail_id AS inventionThumbnail_id_35, t20.smartAttachment_id AS smartAttachment_id_36, t0.author_id AS author_id_37, t0.category_id AS category_id_38 FROM pro_inventions t0 LEFT JOIN pro_files t20 ON t20.inventionThumbnail_id = t0.id WHERE t0.id = ? LIMIT 1 Parameters: [`"257"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.newsletter AS newsletter_3, t0.cislo_dokumentu AS cislo_dokumentu_4, t0.vystup AS vystup_5, t0.instituce AS instituce_6, t0.datum AS datum_7, t0.cislo AS cislo_8, t0.vyzkumny_projekt AS vyzkumny_projekt_9, t0.nazev AS nazev_10, t0.resitel AS resitel_11, t0.tel AS tel_12, t0.email AS email_13, t0.text AS text_14, t0.link AS link_15, t0.enabled AS enabled_16, t0.published AS published_17, t0.dateCreated AS dateCreated_18, t0.dateChanged AS dateChanged_19, t20.id AS id_21, t20.name AS name_22, t20.mime AS mime_23, t20.url AS url_24, t20.urlDel AS urlDel_25, t20.size AS size_26, t20.date AS date_27, t20.ip AS ip_28, t20.user_id AS user_id_29, t20.document_id AS document_id_30, t20.documentAttachment_id AS documentAttachment_id_31, t20.activityAttachment_id AS activityAttachment_id_32, t20.stepAttachment_id AS stepAttachment_id_33, t20.inventionAttachment_id AS inventionAttachment_id_34, t20.inventionThumbnail_id AS inventionThumbnail_id_35, t20.smartAttachment_id AS smartAttachment_id_36, t0.author_id AS author_id_37, t0.category_id AS category_id_38 FROM pro_inventions t0 LEFT JOIN pro_files t20 ON t20.inventionThumbnail_id = t0.id WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.newsletter AS newsletter_3, t0.cislo_dokumentu AS cislo_dokumentu_4, t0.vystup AS vystup_5, t0.instituce AS instituce_6, t0.datum AS datum_7, t0.cislo AS cislo_8, t0.vyzkumny_projekt AS vyzkumny_projekt_9, t0.nazev AS nazev_10, t0.resitel AS resitel_11, t0.tel AS tel_12, t0.email AS email_13, t0.text AS text_14, t0.link AS link_15, t0.enabled AS enabled_16, t0.published AS published_17, t0.dateCreated AS dateCreated_18, t0.dateChanged AS dateChanged_19, t20.id AS id_21, t20.name AS name_22, t20.mime AS mime_23, t20.url AS url_24, t20.urlDel AS urlDel_25, t20.size AS size_26, t20.date AS date_27, t20.ip AS ip_28, t20.user_id AS user_id_29, t20.document_id AS document_id_30, t20.documentAttachment_id AS documentAttachment_id_31, t20.activityAttachment_id AS activityAttachment_id_32, t20.stepAttachment_id AS stepAttachment_id_33, t20.inventionAttachment_id AS inventionAttachment_id_34, t20.inventionThumbnail_id AS inventionThumbnail_id_35, t20.smartAttachment_id AS smartAttachment_id_36, t0.author_id AS author_id_37, t0.category_id AS category_id_38 FROM pro_inventions t0 LEFT JOIN pro_files t20 ON t20.inventionThumbnail_id = t0.id WHERE t0.id = '257' LIMIT 1;
0.61 ms (34.35%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM pro_keyword t0 INNER JOIN pro_invention_keyword ON t0.id = pro_invention_keyword.keyword_id WHERE pro_invention_keyword.invetion_id = ? Parameters: [`257`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM pro_keyword t0 INNER JOIN pro_invention_keyword ON t0.id = pro_invention_keyword.keyword_id WHERE pro_invention_keyword.invetion_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM pro_keyword t0 INNER JOIN pro_invention_keyword ON t0.id = pro_invention_keyword.keyword_id WHERE pro_invention_keyword.invetion_id = 257;
0.48 ms (26.93%)	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.inventionAttachment_id = ? Parameters: [`257`] 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.inventionAttachment_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.inventionAttachment_id = 257;

Time▼

Count

Info

0.69 ms
(38.72%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.newsletter AS newsletter_3, t0.cislo_dokumentu AS cislo_dokumentu_4, t0.vystup AS vystup_5, t0.instituce AS instituce_6, t0.datum AS datum_7, t0.cislo AS cislo_8, t0.vyzkumny_projekt AS vyzkumny_projekt_9, t0.nazev AS nazev_10, t0.resitel AS resitel_11, t0.tel AS tel_12, t0.email AS email_13, t0.text AS text_14, t0.link AS link_15, t0.enabled AS enabled_16, t0.published AS published_17, t0.dateCreated AS dateCreated_18, t0.dateChanged AS dateChanged_19, t20.id AS id_21, t20.name AS name_22, t20.mime AS mime_23, t20.url AS url_24, t20.urlDel AS urlDel_25, t20.size AS size_26, t20.date AS date_27, t20.ip AS ip_28, t20.user_id AS user_id_29, t20.document_id AS document_id_30, t20.documentAttachment_id AS documentAttachment_id_31, t20.activityAttachment_id AS activityAttachment_id_32, t20.stepAttachment_id AS stepAttachment_id_33, t20.inventionAttachment_id AS inventionAttachment_id_34, t20.inventionThumbnail_id AS inventionThumbnail_id_35, t20.smartAttachment_id AS smartAttachment_id_36, t0.author_id AS author_id_37, t0.category_id AS category_id_38 FROM pro_inventions t0 LEFT JOIN pro_files t20 ON t20.inventionThumbnail_id = t0.id WHERE t0.id = ? LIMIT 1

Parameters:

[
  "257"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.newsletter AS newsletter_3,
  t0.cislo_dokumentu AS cislo_dokumentu_4,
  t0.vystup AS vystup_5,
  t0.instituce AS instituce_6,
  t0.datum AS datum_7,
  t0.cislo AS cislo_8,
  t0.vyzkumny_projekt AS vyzkumny_projekt_9,
  t0.nazev AS nazev_10,
  t0.resitel AS resitel_11,
  t0.tel AS tel_12,
  t0.email AS email_13,
  t0.text AS text_14,
  t0.link AS link_15,
  t0.enabled AS enabled_16,
  t0.published AS published_17,
  t0.dateCreated AS dateCreated_18,
  t0.dateChanged AS dateChanged_19,
  t20.id AS id_21,
  t20.name AS name_22,
  t20.mime AS mime_23,
  t20.url AS url_24,
  t20.urlDel AS urlDel_25,
  t20.size AS size_26,
  t20.date AS date_27,
  t20.ip AS ip_28,
  t20.user_id AS user_id_29,
  t20.document_id AS document_id_30,
  t20.documentAttachment_id AS documentAttachment_id_31,
  t20.activityAttachment_id AS activityAttachment_id_32,
  t20.stepAttachment_id AS stepAttachment_id_33,
  t20.inventionAttachment_id AS inventionAttachment_id_34,
  t20.inventionThumbnail_id AS inventionThumbnail_id_35,
  t20.smartAttachment_id AS smartAttachment_id_36,
  t0.author_id AS author_id_37,
  t0.category_id AS category_id_38
FROM
  pro_inventions t0
  LEFT JOIN pro_files t20 ON t20.inventionThumbnail_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.newsletter AS newsletter_3, t0.cislo_dokumentu AS cislo_dokumentu_4, t0.vystup AS vystup_5, t0.instituce AS instituce_6, t0.datum AS datum_7, t0.cislo AS cislo_8, t0.vyzkumny_projekt AS vyzkumny_projekt_9, t0.nazev AS nazev_10, t0.resitel AS resitel_11, t0.tel AS tel_12, t0.email AS email_13, t0.text AS text_14, t0.link AS link_15, t0.enabled AS enabled_16, t0.published AS published_17, t0.dateCreated AS dateCreated_18, t0.dateChanged AS dateChanged_19, t20.id AS id_21, t20.name AS name_22, t20.mime AS mime_23, t20.url AS url_24, t20.urlDel AS urlDel_25, t20.size AS size_26, t20.date AS date_27, t20.ip AS ip_28, t20.user_id AS user_id_29, t20.document_id AS document_id_30, t20.documentAttachment_id AS documentAttachment_id_31, t20.activityAttachment_id AS activityAttachment_id_32, t20.stepAttachment_id AS stepAttachment_id_33, t20.inventionAttachment_id AS inventionAttachment_id_34, t20.inventionThumbnail_id AS inventionThumbnail_id_35, t20.smartAttachment_id AS smartAttachment_id_36, t0.author_id AS author_id_37, t0.category_id AS category_id_38 FROM pro_inventions t0 LEFT JOIN pro_files t20 ON t20.inventionThumbnail_id = t0.id WHERE t0.id = '257' LIMIT 1;

0.61 ms
(34.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM pro_keyword t0 INNER JOIN pro_invention_keyword ON t0.id = pro_invention_keyword.keyword_id WHERE pro_invention_keyword.invetion_id = ?

Parameters:

[
  257
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  pro_keyword t0
  INNER JOIN pro_invention_keyword ON t0.id = pro_invention_keyword.keyword_id
WHERE
  pro_invention_keyword.invetion_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM pro_keyword t0 INNER JOIN pro_invention_keyword ON t0.id = pro_invention_keyword.keyword_id WHERE pro_invention_keyword.invetion_id = 257;

0.48 ms
(26.93%)

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.inventionAttachment_id = ?

Parameters:

[
  257
]

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.inventionAttachment_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.inventionAttachment_id = 257;

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\Keyword	2
App\Entity\Invention	1
App\Entity\User	1
App\Entity\InventionCategory	1
App\Entity\File	1

Entities Mapping

Class	Mapping 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\File	The association App\Entity\File#user refers to the inverse side field App\Entity\User#files which does not exist.
App\Entity\User	No errors.
App\Entity\Document	No errors.
App\Entity\Aktivita	No errors.
App\Entity\Krok	No errors.
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\InventionCategory	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.

Symfony Profiler

GET http://obcepro-dev.galosoft.cz/invence-pro-regiony-a-obce-257.pdf

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping