Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.summary AS summary_6,
  t0.description AS description_7,
  t0.status AS status_8,
  t0.keywords AS keywords_9,
  t0.general_comments AS general_comments_10,
  t0.published AS published_11,
  t0.featured AS featured_12,
  t0.sku AS sku_13,
  t0.mfr_code AS mfr_code_14,
  t0.blk_code AS blk_code_15,
  t0.ean_code AS ean_code_16,
  t0.supplier_code AS supplier_code_17,
  t0.volumetric_weight AS volumetric_weight_18,
  t0.views AS views_19,
  t0.sales AS sales_20,
  t0.created_at AS created_at_21,
  t0.supplier_url AS supplier_url_22,
  t0.in_the_box_text AS in_the_box_text_23,
  t0.discount_percent AS discount_percent_24,
  t0.available_at AS available_at_25,
  t0.offer AS offer_26,
  t0.cash_back AS cash_back_27,
  t0.ask_for_price AS ask_for_price_28,
  t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29,
  t0.warehouse_stock_quantity AS warehouse_stock_quantity_30,
  t0.warehouse_stock_reserved AS warehouse_stock_reserved_31,
  t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32,
  t0.warehouse_stock_immutable AS warehouse_stock_immutable_33,
  t0.price_gross_amount AS price_gross_amount_34,
  t0.price_gross_currency AS price_gross_currency_35,
  t0.price_with_discount_amount AS price_with_discount_amount_36,
  t0.price_with_discount_currency AS price_with_discount_currency_37,
  t0.type_id AS type_id_38,
  t0.main_image_id AS main_image_id_39,
  t0.manufacturer_id AS manufacturer_id_40,
  t0.discr,
  t0.price_url AS price_url_41,
  t0.price_comments AS price_comments_42,
  t0.supplier_discount AS supplier_discount_43,
  t0.special_discount AS special_discount_44,
  t0.customs_charges AS customs_charges_45,
  t0.expected_profit AS expected_profit_46,
  t0.accessories AS accessories_47,
  t0.original_price_amount AS original_price_amount_48,
  t0.original_price_currency AS original_price_currency_49,
  t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_50,
  t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_51,
  t0.dimensions_measurement_unit AS dimensions_measurement_unit_52,
  t0.dimensions_length AS dimensions_length_53,
  t0.dimensions_width AS dimensions_width_54,
  t0.dimensions_height AS dimensions_height_55,
  t0.dimensions_weight_unit AS dimensions_weight_unit_56,
  t0.dimensions_weight AS dimensions_weight_57,
  t0.dimensions_volume AS dimensions_volume_58
FROM
  products t0
WHERE
  t0.id = ?
  AND t0.discr IN ('product', 'product_kit')

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.type_id AS type_id_38, t0.main_image_id AS main_image_id_39, t0.manufacturer_id AS manufacturer_id_40, t0.discr, t0.price_url AS price_url_41, t0.price_comments AS price_comments_42, t0.supplier_discount AS supplier_discount_43, t0.special_discount AS special_discount_44, t0.customs_charges AS customs_charges_45, t0.expected_profit AS expected_profit_46, t0.accessories AS accessories_47, t0.original_price_amount AS original_price_amount_48, t0.original_price_currency AS original_price_currency_49, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_50, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_51, t0.dimensions_measurement_unit AS dimensions_measurement_unit_52, t0.dimensions_length AS dimensions_length_53, t0.dimensions_width AS dimensions_width_54, t0.dimensions_height AS dimensions_height_55, t0.dimensions_weight_unit AS dimensions_weight_unit_56, t0.dimensions_weight AS dimensions_weight_57, t0.dimensions_volume AS dimensions_volume_58 FROM products t0 WHERE t0.id = 9332 AND t0.discr IN ('product', 'product_kit');

SELECT
  p0_.content AS content_0,
  p0_.field AS field_1
FROM
  product_translations p0_
WHERE
  p0_.foreign_key = ?
  AND p0_.locale = ?
  AND p0_.object_class = ?

SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = '9332' AND p0_.locale = 'en' AND p0_.object_class = 'App\\Entity\\Product\\Object\\BaseProduct';

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 4 ORDER BY t0.lft ASC;

SELECT
  p0_.id AS id_0,
  p0_.migration_id AS migration_id_1,
  p0_.softone_id AS softone_id_2,
  p0_.name AS name_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.lft AS lft_6,
  p0_.lvl AS lvl_7,
  p0_.rgt AS rgt_8,
  p0_.published AS published_9,
  p0_.sort_index AS sort_index_10
FROM
  product_category p0_
WHERE
  p0_.rgt < 924
  AND p0_.lft > 1
  AND p0_.tree_root = ?
ORDER BY
  p0_.tree_root ASC,
  p0_.lft ASC

SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = 1 ORDER BY p0_.tree_root ASC, p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5
FROM
  cart t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = 'cart_69890a0fdda5f7.54740806' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.lvl = ?

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.wishlist AS wishlist_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.price_amount AS price_amount_6,
  t0.price_currency AS price_currency_7,
  t0.cart_id AS cart_id_8,
  t0.product_id AS product_id_9
FROM
  cart_item t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = 0x1F1053B1D5E9694498DC87B9FF883E12;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.tree_root = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = 1 LIMIT 1;