Redirect 303 redirect from GET @app_product_variant_show (2a5f4b)

GET https://officechoice.sn/product/televiseur-65bu8000

Query Metrics

7 Database Queries
7 Different statements
33.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.35 ms
(31.03%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sku AS sku_3, p0_.is_new_arrival AS is_new_arrival_4, p0_.is_special_offer AS is_special_offer_5, p0_.is_choice_of_month AS is_choice_of_month_6, p0_.sale_price AS sale_price_7, p0_.solde_price AS solde_price_8, p0_.discount AS discount_9, p0_.final_price AS final_price_10, p0_.stock_quantity AS stock_quantity_11, p0_.more_description AS more_description_12, p0_.is_active AS is_active_13, p0_.short_description AS short_description_14, p0_.is_main AS is_main_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.meta_keywords AS meta_keywords_18, p0_.main_image_path AS main_image_path_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.deleted_at AS deleted_at_22, p1_.id AS id_23, p1_.name AS name_24, p1_.slug AS slug_25, p1_.description AS description_26, p1_.is_active AS is_active_27, p1_.type AS type_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.deleted_at AS deleted_at_31, c2_.id AS id_32, c2_.name AS name_33, c2_.slug AS slug_34, c2_.description AS description_35, c2_.lft AS lft_36, c2_.lvl AS lvl_37, c2_.rgt AS rgt_38, c2_.image_path AS image_path_39, c2_.banner_image_path AS banner_image_path_40, c2_.is_active AS is_active_41, c2_.meta_title AS meta_title_42, c2_.meta_description AS meta_description_43, c2_.meta_keywords AS meta_keywords_44, c2_.created_at AS created_at_45, c2_.updated_at AS updated_at_46, c2_.deleted_at AS deleted_at_47, b3_.id AS id_48, b3_.name AS name_49, b3_.slug AS slug_50, b3_.description AS description_51, b3_.is_active AS is_active_52, b3_.image_path AS image_path_53, b3_.is_visible AS is_visible_54, b3_.created_at AS created_at_55, b3_.updated_at AS updated_at_56, b3_.deleted_at AS deleted_at_57, p0_.product_id AS product_id_58, p1_.brand_id AS brand_id_59, p1_.category_id AS category_id_60, c2_.tree_root AS tree_root_61, c2_.parent_id AS parent_id_62 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) INNER JOIN category c2_ ON p1_.category_id = c2_.id AND (c2_.deleted_at IS NULL) AND (c2_.is_active = 1) LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id AND (b3_.deleted_at IS NULL) AND (b3_.is_active = 1) WHERE (p0_.is_active = 1 AND p0_.slug = ?) AND (p0_.deleted_at IS NULL)
Parameters:
[
  "televiseur-65bu8000"
]
9.58 ms
(28.70%)
1
SELECT c0_.id AS id_0 FROM category c0_ WHERE (c0_.tree_root = ? AND ((c0_.lft <= ? AND c0_.rgt >= ?) OR (c0_.lft >= ? AND c0_.rgt <= ?))) AND (c0_.deleted_at IS NULL) ORDER BY c0_.lft ASC
Parameters:
[
  56
  5
  6
  5
  6
]
4.94 ms
(14.81%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sku AS sku_3, p0_.is_new_arrival AS is_new_arrival_4, p0_.is_special_offer AS is_special_offer_5, p0_.is_choice_of_month AS is_choice_of_month_6, p0_.sale_price AS sale_price_7, p0_.solde_price AS solde_price_8, p0_.discount AS discount_9, p0_.final_price AS final_price_10, p0_.stock_quantity AS stock_quantity_11, p0_.more_description AS more_description_12, p0_.is_active AS is_active_13, p0_.short_description AS short_description_14, p0_.is_main AS is_main_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.meta_keywords AS meta_keywords_18, p0_.main_image_path AS main_image_path_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.deleted_at AS deleted_at_22, p1_.id AS id_23, p1_.name AS name_24, p1_.slug AS slug_25, p1_.description AS description_26, p1_.is_active AS is_active_27, p1_.type AS type_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.deleted_at AS deleted_at_31, a2_.id AS id_32, a2_.name AS name_33, a2_.code AS code_34, a3_.id AS id_35, a3_.name AS name_36, a3_.selection_method AS selection_method_37 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1 AND p1_.id = ?) INNER JOIN product_variant_attribute_value p4_ ON p0_.id = p4_.product_variant_id INNER JOIN attribute_value a2_ ON a2_.id = p4_.attribute_value_id INNER JOIN attribute a3_ ON a2_.attribute_id = a3_.id WHERE (p1_.id = ? AND p0_.is_active = 1) AND (p0_.deleted_at IS NULL)
Parameters:
[
  150
  150
]
4.45 ms
(13.34%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.image_path AS image_path_7, c0_.banner_image_path AS banner_image_path_8, c0_.is_active AS is_active_9, c0_.meta_title AS meta_title_10, c0_.meta_description AS meta_description_11, c0_.meta_keywords AS meta_keywords_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15, c0_.tree_root AS tree_root_16, c0_.parent_id AS parent_id_17 FROM category c0_ WHERE (c0_.lft <= 5 AND c0_.rgt >= 6 AND c0_.tree_root = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.lft ASC
Parameters:
[
  56
]
2.00 ms
(6.00%)
1
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_image t0 WHERE t0.product_variant_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  155
]
1.54 ms
(4.61%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sku AS sku_3, p0_.is_new_arrival AS is_new_arrival_4, p0_.is_special_offer AS is_special_offer_5, p0_.is_choice_of_month AS is_choice_of_month_6, p0_.sale_price AS sale_price_7, p0_.solde_price AS solde_price_8, p0_.discount AS discount_9, p0_.final_price AS final_price_10, p0_.stock_quantity AS stock_quantity_11, p0_.more_description AS more_description_12, p0_.is_active AS is_active_13, p0_.short_description AS short_description_14, p0_.is_main AS is_main_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.meta_keywords AS meta_keywords_18, p0_.main_image_path AS main_image_path_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.deleted_at AS deleted_at_22, p1_.id AS id_23, p1_.name AS name_24, p1_.slug AS slug_25, p1_.description AS description_26, p1_.is_active AS is_active_27, p1_.type AS type_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.deleted_at AS deleted_at_31, c2_.id AS id_32, c2_.name AS name_33, c2_.slug AS slug_34, c2_.description AS description_35, c2_.lft AS lft_36, c2_.lvl AS lvl_37, c2_.rgt AS rgt_38, c2_.image_path AS image_path_39, c2_.banner_image_path AS banner_image_path_40, c2_.is_active AS is_active_41, c2_.meta_title AS meta_title_42, c2_.meta_description AS meta_description_43, c2_.meta_keywords AS meta_keywords_44, c2_.created_at AS created_at_45, c2_.updated_at AS updated_at_46, c2_.deleted_at AS deleted_at_47, p0_.product_id AS product_id_48, p1_.brand_id AS brand_id_49, p1_.category_id AS category_id_50, c2_.tree_root AS tree_root_51, c2_.parent_id AS parent_id_52 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) INNER JOIN category c2_ ON p1_.category_id = c2_.id AND (c2_.deleted_at IS NULL) AND (c2_.is_active = 1) WHERE (p0_.is_active = 1 AND p0_.id <> ? AND c2_.id IN (?, ?, ?)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC LIMIT 5
Parameters:
[
  155
  56
  62
  67
]
0.50 ms
(1.51%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.attribute_id AS attribute_id_4 FROM attribute_value t0 INNER JOIN product_variant_attribute_value ON t0.id = product_variant_attribute_value.attribute_value_id WHERE product_variant_attribute_value.product_variant_id = ?
Parameters:
[
  155
]

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\Category No errors.
App\Entity\ProductVariant No errors.
App\Entity\Product No errors.
App\Entity\Brand No errors.
App\Entity\AttributeValue No errors.
App\Entity\ProductVariantImage No errors.
App\Entity\Attribute No errors.