Query Metrics

25 Database Queries
7 Different statements
26.03 ms Query time
4 Invalid entities
258 Managed entities

Queries

Group similar statements

# Time Info
1 3.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM pro_keyword t0 WHERE t0.type = ? ORDER BY t0.name ASC
Parameters:
[
  0
]
2 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM pro_invention_category t0 ORDER BY t0.name ASC
Parameters:
[]
3 7.44 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pro_inventions p0_ LEFT JOIN pro_invention_keyword p2_ ON p0_.id = p2_.invetion_id LEFT JOIN pro_keyword p1_ ON p1_.id = p2_.keyword_id WHERE p0_.published = 1
Parameters:
[]
4 3.13 ms
SELECT DISTINCT p0_.id AS id_0, p0_.datum AS datum_1 FROM pro_inventions p0_ LEFT JOIN pro_invention_keyword p2_ ON p0_.id = p2_.invetion_id LEFT JOIN pro_keyword p1_ ON p1_.id = p2_.keyword_id WHERE p0_.published = 1 ORDER BY p0_.datum DESC LIMIT 10
Parameters:
[]
5 1.28 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.newsletter AS newsletter_2, p0_.cislo_dokumentu AS cislo_dokumentu_3, p0_.vystup AS vystup_4, p0_.instituce AS instituce_5, p0_.datum AS datum_6, p0_.cislo AS cislo_7, p0_.vyzkumny_projekt AS vyzkumny_projekt_8, p0_.nazev AS nazev_9, p0_.resitel AS resitel_10, p0_.tel AS tel_11, p0_.email AS email_12, p0_.text AS text_13, p0_.link AS link_14, p0_.enabled AS enabled_15, p0_.published AS published_16, p0_.dateCreated AS dateCreated_17, p0_.dateChanged AS dateChanged_18, p0_.author_id AS author_id_19, p0_.category_id AS category_id_20 FROM pro_inventions p0_ LEFT JOIN pro_invention_keyword p2_ ON p0_.id = p2_.invetion_id LEFT JOIN pro_keyword p1_ ON p1_.id = p2_.keyword_id WHERE p0_.published = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.datum DESC
Parameters:
[
  208
  207
  206
  205
  203
  202
  201
  200
  199
  198
]
6 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.inventionThumbnail_id = ?
Parameters:
[
  208
]
7 0.45 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.inventionThumbnail_id = ?
Parameters:
[
  207
]
8 0.45 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.inventionThumbnail_id = ?
Parameters:
[
  206
]
9 0.46 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.inventionThumbnail_id = ?
Parameters:
[
  205
]
10 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.inventionThumbnail_id = ?
Parameters:
[
  203
]
11 0.48 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.inventionThumbnail_id = ?
Parameters:
[
  202
]
12 0.48 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.inventionThumbnail_id = ?
Parameters:
[
  201
]
13 0.48 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.inventionThumbnail_id = ?
Parameters:
[
  200
]
14 0.49 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.inventionThumbnail_id = ?
Parameters:
[
  199
]
15 0.48 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.inventionThumbnail_id = ?
Parameters:
[
  198
]
16 0.55 ms
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:
[
  208
]
17 0.53 ms
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:
[
  207
]
18 0.53 ms
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:
[
  206
]
19 0.46 ms
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:
[
  205
]
20 0.52 ms
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:
[
  203
]
21 0.51 ms
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:
[
  202
]
22 0.54 ms
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:
[
  201
]
23 0.51 ms
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:
[
  200
]
24 0.51 ms
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:
[
  199
]
25 0.52 ms
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:
[
  198
]

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 227
App\Entity\InventionCategory 11
App\Entity\Invention 10
App\Entity\File 10

Entities Mapping

Class Mapping 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\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\InventionCategory No errors.
App\Entity\User 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\Document No errors.
App\Entity\Aktivita No errors.
App\Entity\Krok No errors.