Query Metrics

13 Database Queries
8 Different statements
6.40 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.url_rewrite AS url_rewrite_6, t0.nbr_posts AS nbr_posts_7, t0.parent AS parent_8, t0.active AS active_9, t0.visibility AS visibility_10, t0.blr AS blr_11, t0.bll AS bll_12, t0.blf AS blf_13, t0.bh AS bh_14, t0.image_id AS image_id_15 FROM categories t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.99 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.content AS content_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.url_rewrite AS url_rewrite_5, c0_.nbr_posts AS nbr_posts_6, c0_.parent AS parent_7, c0_.active AS active_8, c0_.visibility AS visibility_9, c0_.blr AS blr_10, c0_.bll AS bll_11, c0_.blf AS blf_12, c0_.bh AS bh_13, c0_.image_id AS image_id_14 FROM categories c0_ WHERE c0_.active = ? AND c0_.visibility = ? AND c0_.nbr_posts > ? AND c0_.parent = ?
Parameters:
[
  1
  0
  0
  4
]
3 0.71 ms
SELECT t0.id AS id_1, t0.draft AS draft_2, t0.comments AS comments_3, t0.visibility AS visibility_4, t0.sharing AS sharing_5, t0.home AS home_6, t0.active AS active_7, t0.blr AS blr_8, t0.bll AS bll_9, t0.blf AS blf_10, t0.date_start AS date_start_11, t0.content_id AS content_id_12, t0.image_id AS image_id_13 FROM posts t0 INNER JOIN categories_posts ON t0.id = categories_posts.posts_id WHERE categories_posts.categories_id = ?
Parameters:
[
  4
]
4 0.63 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.draft AS draft_1, p0_.comments AS comments_2, p0_.visibility AS visibility_3, p0_.sharing AS sharing_4, p0_.home AS home_5, p0_.active AS active_6, p0_.blr AS blr_7, p0_.bll AS bll_8, p0_.blf AS blf_9, p0_.date_start AS date_start_10 FROM posts p0_ WHERE p0_.id IN (6, 7, 8, 9, 16) AND p0_.draft = ? AND p0_.active = ?) dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 10
Parameters:
[
  0
  1
]
5 0.53 ms
SELECT p0_.id AS id_0, p0_.draft AS draft_1, p0_.comments AS comments_2, p0_.visibility AS visibility_3, p0_.sharing AS sharing_4, p0_.home AS home_5, p0_.active AS active_6, p0_.blr AS blr_7, p0_.bll AS bll_8, p0_.blf AS blf_9, p0_.date_start AS date_start_10, p0_.content_id AS content_id_11, p0_.image_id AS image_id_12 FROM posts p0_ WHERE p0_.id IN (6, 7, 8, 9, 16) AND p0_.draft = ? AND p0_.active = ? AND p0_.id IN (?, ?, ?, ?, ?) ORDER BY p0_.id ASC
Parameters:
[
  0
  1
  6
  7
  8
  9
  16
]
6 0.42 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.draft AS draft_1, p0_.comments AS comments_2, p0_.visibility AS visibility_3, p0_.sharing AS sharing_4, p0_.home AS home_5, p0_.active AS active_6, p0_.blr AS blr_7, p0_.bll AS bll_8, p0_.blf AS blf_9, p0_.date_start AS date_start_10 FROM posts p0_ WHERE p0_.id IN (6, 7, 8, 9, 16) AND p0_.draft = ? AND p0_.active = ? ORDER BY p0_.id ASC) dctrn_result) dctrn_table
Parameters:
[
  0
  1
]
7 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "F_LOGO"
]
8 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "F_LOGO"
]
9 0.26 ms
SELECT t0.id AS id_1, t0.url AS url_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "F_TEXT_TOP"
]
11 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "F_TEXT_TOP"
]
12 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "F_SITENAME"
]
13 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "F_SITENAME"
]

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
AR\AdminBundle\Entity\Image 7
AR\BlogBundle\Entity\Posts 5
AR\BlogBundle\Entity\PostContent 5
AR\AdminBundle\Entity\Configuration 3
AR\BlogBundle\Entity\Categories 1