Query Metrics

13 Database Queries
8 Different statements
4.29 ms Query time
0 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.81 ms
(42.26%)
6
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"
]
0.48 ms
(11.16%)
1
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:
[
  2
]
0.43 ms
(9.90%)
1
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 (10, 12, 14) AND p0_.draft = ? AND p0_.active = ?) dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 10
Parameters:
[
  0
  1
]
0.41 ms
(9.60%)
1
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
  2
]
0.35 ms
(8.22%)
1
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:
[
  2
]
0.32 ms
(7.53%)
1
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 (10, 12, 14) AND p0_.draft = ? AND p0_.active = ? AND p0_.id IN (?, ?, ?) ORDER BY p0_.id ASC
Parameters:
[
  0
  1
  10
  12
  14
]
0.28 ms
(6.54%)
1
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 (10, 12, 14) AND p0_.draft = ? AND p0_.active = ? ORDER BY p0_.id ASC) dctrn_result) dctrn_table
Parameters:
[
  0
  1
]
0.21 ms
(4.80%)
1
SELECT t0.id AS id_1, t0.url AS url_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  1
]

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