Query Metrics

50 Database Queries
13 Different statements
8.65 ms Query time
0 Invalid entities
159 Managed entities

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url_rewrite AS url_rewrite_5, t0.nbr_articles AS nbr_articles_6, t0.content AS content_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.blh AS blh_12, t0.image_id AS image_id_13 FROM instant_category t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.33 ms
SELECT t0.id AS id_1, t0.draft AS draft_2, t0.active AS active_3, t0.home AS home_4, t0.blr AS blr_5, t0.bll AS bll_6, t0.date_add AS date_add_7, t0.generated_img AS generated_img_8, t0.date_update AS date_update_9, t0.content_id AS content_id_10, t0.image_id AS image_id_11, t0.category_id AS category_id_12 FROM instant_article t0 WHERE t0.category_id = ?
Parameters:
[
  4
]
3 0.40 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.draft AS draft_1, i0_.active AS active_2, i0_.home AS home_3, i0_.blr AS blr_4, i0_.bll AS bll_5, i0_.date_add AS date_add_6, i0_.generated_img AS generated_img_7, i0_.date_update AS date_update_8 FROM instant_article i0_ WHERE i0_.id IN (3, 9, 10, 11, 14, 16, 36, 41, 44, 45, 46, 47, 49, 51, 55, 56, 57, 58, 59, 60, 61, 62)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 10
Parameters:
[]
4 0.29 ms
SELECT i0_.id AS id_0, i0_.draft AS draft_1, i0_.active AS active_2, i0_.home AS home_3, i0_.blr AS blr_4, i0_.bll AS bll_5, i0_.date_add AS date_add_6, i0_.generated_img AS generated_img_7, i0_.date_update AS date_update_8, i0_.content_id AS content_id_9, i0_.image_id AS image_id_10, i0_.category_id AS category_id_11 FROM instant_article i0_ WHERE i0_.id IN (3, 9, 10, 11, 14, 16, 36, 41, 44, 45, 46, 47, 49, 51, 55, 56, 57, 58, 59, 60, 61, 62) AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.id DESC
Parameters:
[
  62
  61
  60
  59
  58
  57
  56
  55
  51
  49
]
5 0.28 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.draft AS draft_1, i0_.active AS active_2, i0_.home AS home_3, i0_.blr AS blr_4, i0_.bll AS bll_5, i0_.date_add AS date_add_6, i0_.generated_img AS generated_img_7, i0_.date_update AS date_update_8 FROM instant_article i0_ WHERE i0_.id IN (3, 9, 10, 11, 14, 16, 36, 41, 44, 45, 46, 47, 49, 51, 55, 56, 57, 58, 59, 60, 61, 62) ORDER BY i0_.id DESC) dctrn_result) dctrn_table
Parameters:
[]
6 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_LOGO"
]
7 0.15 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.10 ms
SELECT t0.id AS id_1, t0.url AS url_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.10 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"
]
10 0.15 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.12 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"
]
12 0.15 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.25 ms
SELECT t0.id AS id_1, t0.i_type AS i_type_2, t0.active AS active_3, t0.title AS title_4, t0.position AS position_5, t0.target_blank AS target_blank_6, t0.choice_type AS choice_type_7, t0.image_id AS image_id_8 FROM items_menu t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
14 0.26 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  2
]
15 0.21 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:
[
  1
]
16 0.28 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:
[
  1
]
17 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.excerpt AS excerpt_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.url_rewrite AS url_rewrite_7 FROM post_content t0 WHERE t0.id = ?
Parameters:
[
  2
]
18 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.excerpt AS excerpt_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.url_rewrite AS url_rewrite_7 FROM post_content t0 WHERE t0.id = ?
Parameters:
[
  3
]
19 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.excerpt AS excerpt_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.url_rewrite AS url_rewrite_7 FROM post_content t0 WHERE t0.id = ?
Parameters:
[
  11
]
20 0.20 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  3
]
21 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url_rewrite AS url_rewrite_5, t0.nbr_articles AS nbr_articles_6, t0.content AS content_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.blh AS blh_12, t0.image_id AS image_id_13 FROM instant_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
22 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url_rewrite AS url_rewrite_5, t0.nbr_articles AS nbr_articles_6, t0.content AS content_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.blh AS blh_12, t0.image_id AS image_id_13 FROM instant_category t0 WHERE t0.id = ?
Parameters:
[
  2
]
23 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url_rewrite AS url_rewrite_5, t0.nbr_articles AS nbr_articles_6, t0.content AS content_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.blh AS blh_12, t0.image_id AS image_id_13 FROM instant_category t0 WHERE t0.id = ?
Parameters:
[
  3
]
24 0.15 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  4
]
25 0.15 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:
[
  "M_URL_Q"
]
26 0.13 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:
[
  "M_URL_Q"
]
27 0.14 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  5
]
28 0.21 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  1
]
29 0.20 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  2
]
30 0.17 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  4
]
31 0.19 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  6
]
32 0.13 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  7
]
33 0.17 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  8
]
34 0.14 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  9
]
35 0.14 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  10
]
36 0.11 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  13
]
37 0.10 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  14
]
38 0.08 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  15
]
39 0.08 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  16
]
40 0.08 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  17
]
41 0.09 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  18
]
42 0.08 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_bulles AS nbr_bulles_7, t0.active AS active_8, t0.blr AS blr_9, t0.bll AS bll_10, t0.blf AS blf_11, t0.bh AS bh_12, t0.image_id AS image_id_13 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
  19
]
43 0.10 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  6
]
44 0.16 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
]
45 0.14 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  7
]
46 0.10 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:
[
  2
]
47 0.14 ms
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.string_item AS string_item_3, t0.item_menu_id AS item_menu_id_4, t0.image_id AS image_id_5 FROM items_choice t0 WHERE t0.item_menu_id = ?
Parameters:
[
  8
]
48 0.13 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:
[
  3
]
49 0.14 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"
]
50 0.13 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 48
AR\AdminBundle\Entity\ItemsChoice 25
AR\BlogBundle\Entity\InstantArticle 22
AR\BlogBundle\Entity\InstantArticleContent 22
AR\ProductsBundle\Entity\ProductsCategories 15
AR\AdminBundle\Entity\ItemsMenu 7
AR\BlogBundle\Entity\InstantCategory 4
AR\AdminBundle\Entity\Configuration 4
AR\BlogBundle\Entity\Categories 4
AR\BlogBundle\Entity\Posts 4
AR\BlogBundle\Entity\PostContent 4