Query Metrics

16 Database Queries
4 Different statements
912.18 ms Query time
0 Invalid entities
28 Cache hits
2 Cache misses
3 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 112.98 ms
SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.rate AS rate_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.synced_at AS synced_at_5, c0_.index_at AS index_at_6 FROM currency c0_ WHERE c0_.code = ?
Parameters:
[
  "RSD"
]
2 115.19 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.page_top AS page_top_4, p0_.page_bottom AS page_bottom_5, p0_.locale AS locale_6, p0_.translatable_id AS translatable_id_7 FROM page_translation p0_ WHERE p0_.slug = ? AND p0_.locale = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  "naslovna"
  "sr"
]
3 55.80 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.page_top AS page_top_5, t0.page_bottom AS page_bottom_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM page_translation t0 WHERE t0.slug = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  "naslovna"
]
4 70.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  22
]
5 45.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  21
]
6 45.73 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  18
]
7 45.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  17
]
8 45.91 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  14
]
9 47.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  11
]
10 45.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  10
]
11 45.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  9
]
12 45.80 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  8
]
13 49.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  3
]
14 46.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  13
]
15 49.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  4
]
16 45.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection
client_rel_management doctrine.dbal.client_rel_management_connection
client_rel_web_management doctrine.dbal.client_rel_web_management_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
client_rel_management doctrine.orm.client_rel_management_entity_manager
client_rel_web_management doctrine.orm.client_rel_web_management_entity_manager

Second Level Cache

28 Hits
2 Misses
3 Puts

Number of cache hits

Region Hits
public 28

Number of cache misses

Region Misses
public 2

Number of cache puts

Region Puts
public 3

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\ECommerce\Currency No errors.
App\Entity\ECommerce\Depot No errors.
App\Entity\ECommerce\Client No errors.
App\Entity\ECommerce\Shipping No errors.
App\Entity\Content\PageTranslation No errors.
App\Entity\SEO\Seo No errors.
App\Entity\Media\Media No errors.
App\Entity\Content\Page No errors.
App\Entity\Content\Blog No errors.
App\Entity\Content\BlogTranslation No errors.
App\Entity\Content\Tag No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.