Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

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)

[
  "machine-a-laver-samsung-top-loader-wa11cg5441bynq"
]

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)

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 = 'machine-a-laver-samsung-top-loader-wa11cg5441bynq') AND (p0_.deleted_at IS NULL);