GET http://v2.tussor.net/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CDefaultController%253A%253Anavbar

Response
200 OK
IP
216.73.217.33
Profiled on
Token
6362ee

Query Metrics

12 Database Queries
9 Different statements
15.55 ms Query time
0 Invalid entities
24 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
5.28 ms
(33.94%) 		1 
SELECT t0.id AS id_1, t0.images AS images_2, t0.alt AS alt_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.product_id AS product_id_6 FROM attachment t0 WHERE t0.product_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
2.41 ms
(15.52%) 		3 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
2.06 ms
(13.27%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ref AS ref_4, t0.alt AS alt_5, t0.position AS position_6, t0.price AS price_7, t0.promo AS promo_8, t0.image AS image_9, t0.stock AS stock_10, t0.create_at AS create_at_11, t0.update_at AS update_at_12, t0.active AS active_13, t0.default_name AS default_name_14, t0.long_description AS long_description_15, t0.short_description AS short_description_16, t0.care AS care_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.name AS name_21, t19.slug AS slug_22, t19.image AS image_23, t19.alt AS alt_24, t19.min_price AS min_price_25, t19.update_at AS update_at_26, t19.title_page AS title_page_27, t19.sub_title_page AS sub_title_page_28, t19.cite_page AS cite_page_29, t19.main_image AS main_image_30, t19.main_alt AS main_alt_31, t19.second_image AS second_image_32, t19.second_alt AS second_alt_33, t19.third_image AS third_image_34, t19.third_alt AS third_alt_35, t19.fourth_image AS fourth_image_36, t19.fourth_alt AS fourth_alt_37, t19.nb_display AS nb_display_38, t19.sort AS sort_39, t19.show_sub_categories AS show_sub_categories_40, t19.description AS description_41, t19.meta_title AS meta_title_42, t19.parent_id AS parent_id_43, t0.field_id AS field_id_44, t0.product_option_id AS product_option_id_45 FROM product t0 LEFT JOIN category t19 ON t0.category_id = t19.id WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "mousqueton"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.57 ms
(10.06%) 		2 
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.id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(6.15%) 		1 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.ref AS ref_3, p0_.alt AS alt_4, p0_.position AS position_5, p0_.price AS price_6, p0_.promo AS promo_7, p0_.image AS image_8, p0_.stock AS stock_9, p0_.create_at AS create_at_10, p0_.update_at AS update_at_11, p0_.active AS active_12, p0_.default_name AS default_name_13, p0_.long_description AS long_description_14, p0_.short_description AS short_description_15, p0_.care AS care_16, p0_.category_id AS category_id_17, p0_.field_id AS field_id_18, p0_.product_option_id AS product_option_id_19 FROM product p0_ WHERE p0_.active = 1 AND p0_.id <> ? AND p0_.default_name = ?
Parameters: 
[
  15
  "Mousquetons"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.93 ms
(6.00%) 		1 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.93 ms
(5.97%) 		1 
SELECT t0.id AS id_1, t0.custom_value AS custom_value_2, t0.product_id AS product_id_3, t0.feature_id AS feature_id_4, t0.feature_value_id AS feature_value_id_5 FROM product_feature t0 WHERE t0.product_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(4.74%) 		1 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(4.35%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_group_id AS product_attribute_group_id_6 FROM product_attribute t0 INNER JOIN product_product_attribute ON t0.id = product_product_attribute.product_attribute_id WHERE product_product_attribute.product_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Product 1
App\Entity\Field 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Field No errors.
App\Entity\ProductOption No errors.
App\Entity\Attachment No errors.
App\Entity\ProductFeature No errors.
App\Entity\ProductAttributeGroup No errors.
App\Entity\ProductAttribute No errors.
App\Entity\Feature No errors.
App\Entity\FeatureValue No errors.