Query Metrics

10 Database Queries
8 Different statements
1.93 ms Query time
2 Invalid entities
32 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT t0.id AS id_1, t0.ipaddress AS ipaddress_2 FROM black_list_ip t0 WHERE t0.ipaddress = ? LIMIT 1
Parameters:
[
  "108.162.241.67"
]
2 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.title AS title_7, t0.description AS description_8, t0.image AS image_9, t0.is_blog AS is_blog_10, t0.blog_preview AS blog_preview_11, t0.is_visible AS is_visible_12, t0.blog_category_id AS blog_category_id_13 FROM page t0 WHERE t0.url = ? AND t0.is_blog = ? AND t0.is_visible = ? LIMIT 1
Parameters:
[
  "cim-a-jak-obelhavaji-nekteri-realitni-makleri-majitele-nemovitosti"
  1
  1
]
3 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5 FROM blog_category t0
Parameters:
[]
4 0.17 ms
SELECT COUNT(*) FROM page t0 WHERE t0.is_blog = ? AND t0.is_visible = ? AND t0.blog_category_id = ?
Parameters:
[
  1
  1
  1
]
5 0.12 ms
SELECT COUNT(*) FROM page t0 WHERE t0.is_blog = ? AND t0.is_visible = ? AND t0.blog_category_id = ?
Parameters:
[
  1
  1
  2
]
6 0.21 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.edited_at AS edited_at_5, p0_.title AS title_6, p0_.description AS description_7, p0_.image AS image_8, p0_.is_blog AS is_blog_9, p0_.blog_preview AS blog_preview_10, p0_.is_visible AS is_visible_11, p0_.blog_category_id AS blog_category_id_12 FROM page p0_ WHERE p0_.is_blog = 1 AND p0_.url <> ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[
  "cim-a-jak-obelhavaji-nekteri-realitni-makleri-majitele-nemovitosti"
]
7 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM advertisement_disposition t0
Parameters:
[]
8 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.seo_description AS seo_description_3, t0.seo_title AS seo_title_4, t0.description AS description_5 FROM property_type t0
Parameters:
[]
9 0.12 ms
SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.value AS value_4 FROM term t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "blog_page_seo_title"
]
10 0.11 ms
SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.value AS value_4 FROM term t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "blog_page_seo_description"
]

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\AdvertisementDisposition 13
App\Entity\PropertyType 11
App\Entity\Page 4
App\Entity\BlogCategory 2
App\Entity\Term 2

Entities Mapping

Class Mapping errors
App\Entity\BlackListIp No errors.
App\Entity\Page No errors.
App\Entity\BlogCategory No errors.
App\Entity\AdvertisementDisposition
  • The association App\Entity\AdvertisementDisposition#watchDogs refers to the owning side field App\Entity\WatchDog#advertisementDisposition which does not exist.
App\Entity\Advertisement No errors.
App\Entity\WatchDog No errors.
App\Entity\PropertyType
  • The association App\Entity\PropertyType#watchDogs refers to the owning side field App\Entity\WatchDog#propertyType which does not exist.
App\Entity\Term No errors.