Query Metrics

7 Database Queries
5 Different statements
5.41 ms Query time
0 Invalid entities
32 Managed entities

Queries

Group similar statements

# Time Info
1 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.linkmap AS linkmap_6 FROM shop t0
Parameters:
[]
2 1.98 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e0_.image AS image_4, e0_.alt_image AS alt_image_5, e0_.link AS link_6 FROM event e0_ ORDER BY e0_.start_date DESC LIMIT 12
Parameters:
[]
3 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Collection MER"
]
4 0.38 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.alt AS alt_4, c0_.min_price AS min_price_5, c0_.update_at AS update_at_6, c0_.title_page AS title_page_7, c0_.sub_title_page AS sub_title_page_8, c0_.cite_page AS cite_page_9, c0_.main_image AS main_image_10, c0_.main_alt AS main_alt_11, c0_.second_image AS second_image_12, c0_.second_alt AS second_alt_13, c0_.third_image AS third_image_14, c0_.third_alt AS third_alt_15, c0_.fourth_image AS fourth_image_16, c0_.fourth_alt AS fourth_alt_17, c0_.nb_display AS nb_display_18, c0_.sort AS sort_19, c0_.show_sub_categories AS show_sub_categories_20, c0_.description AS description_21, c0_.meta_title AS meta_title_22, c0_.parent_id AS parent_id_23 FROM category c0_ WHERE c0_.parent_id = ? ORDER BY c0_.nb_display ASC
Parameters:
[
  17
]
5 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
  23
]
6 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
  31
]
7 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
  25
]

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\Category 22
App\Entity\Shop 5
App\Entity\Event 5

Entities Mapping

Class Mapping errors
App\Entity\Shop No errors.
App\Entity\Event No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.