https://test.vivog.fr/en/p/15770/black-leather-collar-special-bulldog-and-stones

Query Metrics

6 Database Queries
5 Different statements
3.07 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_parent_id AS products_parent_id_66, t0.manufacturers_id AS manufacturers_id_67, t0.products_tax_class_id AS products_tax_class_id_68 FROM products t0 WHERE t0.products_id = ?
Parameters:
[
  "15770"
]
2 0.22 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  632
]
3 0.27 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  15770
]
4 1.65 ms
SELECT r0_.id AS id_0, r0_.redirect_url AS redirect_url_1, r0_.target_path AS target_path_2, r0_.target_url AS target_url_3, r0_.redirect_product_id AS redirect_product_id_4, r0_.redirect_category_id AS redirect_category_id_5, r0_.target_product_id AS target_product_id_6, r0_.target_category_id AS target_category_id_7 FROM redirections r0_ WHERE r0_.redirect_product_id = ? OR r0_.redirect_url LIKE ? LIMIT 1
Parameters:
[
  15770
  "%product_info.php?products_id=15770&%"
]
5 0.16 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  628
]
6 0.23 ms
SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = ?
Parameters:
[
  628
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Manufacturer No errors.
App\Entity\TaxClass No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ProductDescription No errors.
App\Entity\Picture No errors.
App\Entity\PictureProduct No errors.
App\Entity\ProductCountryRestriction No errors.
App\Entity\ProductToProductExtraField No errors.
App\Entity\ProductPrice No errors.
App\Entity\Category No errors.
App\Entity\CategoryDescription No errors.
App\Entity\CategoryToExtraField No errors.
App\Entity\PictureCategory No errors.
App\Entity\Language No errors.
App\Entity\Redirection No errors.