Symfony Profiler

SELECT
  text_value
FROM
  oro_config_value
WHERE
  name = ?
  AND section = ?

SELECT text_value FROM oro_config_value WHERE name = 'is_installed' AND section = 'oro_distribution';

SET
  application_name TO '06a9f4afd73298c9571bf060902bd731'

SET application_name TO '06a9f4afd73298c9571bf060902bd731';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_default AS is_default_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.serialized_data AS serialized_data_6,
  t0.business_unit_owner_id AS business_unit_owner_id_7,
  t0.organization_id AS organization_id_8,
  t0.guest_role_id AS guest_role_id_9,
  t0.default_role_id AS default_role_id_10
FROM
  oro_website t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8, t0.guest_role_id AS guest_role_id_9, t0.default_role_id AS default_role_id_10 FROM oro_website t0 WHERE t0.is_default = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.last_visit AS last_visit_2,
  t0.session_id AS session_id_3,
  t0.serialized_data AS serialized_data_4,
  t0.cookies_accepted AS cookies_accepted_5,
  t0.customer_user_id AS customer_user_id_6
FROM
  oro_customer_visitor t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_visit AS last_visit_2, t0.session_id AS session_id_3, t0.serialized_data AS serialized_data_4, t0.cookies_accepted AS cookies_accepted_5, t0.customer_user_id AS customer_user_id_6 FROM oro_customer_visitor t0 WHERE t0.session_id = 'a545ef48388fcfd5863b' LIMIT 1;

SELECT
  o0_.role AS role_0
FROM
  oro_customer_user_role o0_
WHERE
  o0_.id = ?

SELECT o0_.role AS role_0 FROM oro_customer_user_role o0_ WHERE o0_.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.serialized_data AS serialized_data_6,
  t0.business_unit_owner_id AS business_unit_owner_id_7,
  t0.organization_id AS organization_id_8
FROM
  oro_web_catalog t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8 FROM oro_web_catalog t0 WHERE t0.id = 1;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.formatting_code AS formatting_code_2,
  o0_.rtl_mode AS rtl_mode_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.serialized_data AS serialized_data_6,
  o0_.language_id AS language_id_7,
  o0_.parent_id AS parent_id_8
FROM
  oro_localization o0_
ORDER BY
  o0_.name ASC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.formatting_code AS formatting_code_2, o0_.rtl_mode AS rtl_mode_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.serialized_data AS serialized_data_6, o0_.language_id AS language_id_7, o0_.parent_id AS parent_id_8 FROM oro_localization o0_ ORDER BY o0_.name ASC;

SELECT
  o0_.id AS id_0,
  o0_.url AS url_1,
  o0_.slug_prototype AS slug_prototype_2,
  o0_.url_hash AS url_hash_3,
  o0_.route_name AS route_name_4,
  o0_.route_parameters AS route_parameters_5,
  o0_.scopes_hash AS scopes_hash_6,
  o0_.parameters_hash AS parameters_hash_7,
  o1_.id AS id_8
FROM
  oro_redirect_slug o0_
  LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id
  LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id
  AND (
    (
      o1_.webCatalog_id = ?
      OR o1_.webCatalog_id IS NULL
    )
    AND (o1_.customer_id IS NULL)
    AND (
      o1_.customerGroup_id = ?
      OR o1_.customerGroup_id IS NULL
    )
    AND (o1_.organization_id IS NULL)
    AND (o1_.user_id IS NULL)
    AND (o1_.website_id IS NULL)
  )
  LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id
WHERE
  o0_.url_hash = ?
  AND o0_.url = ?
  AND (
    o1_.localization_id IS NULL
    OR o1_.localization_id = COALESCE(o3_.id, ?)
  )
ORDER BY
  o1_.localization_id DESC NULLS LAST,
  o1_.webCatalog_id DESC NULLS LAST,
  o1_.customerGroup_id DESC NULLS LAST,
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.url AS url_1, o0_.slug_prototype AS slug_prototype_2, o0_.url_hash AS url_hash_3, o0_.route_name AS route_name_4, o0_.route_parameters AS route_parameters_5, o0_.scopes_hash AS scopes_hash_6, o0_.parameters_hash AS parameters_hash_7, o1_.id AS id_8 FROM oro_redirect_slug o0_ LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id AND ((o1_.webCatalog_id = 1 OR o1_.webCatalog_id IS NULL) AND (o1_.customer_id IS NULL) AND (o1_.customerGroup_id = 1 OR o1_.customerGroup_id IS NULL) AND (o1_.organization_id IS NULL) AND (o1_.user_id IS NULL) AND (o1_.website_id IS NULL)) LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id WHERE o0_.url_hash = '0664f043ea7c68fa2865dd89e2454fdc' AND o0_.url = '/navigation-root/products/clearance/office-furniture' AND (o1_.localization_id IS NULL OR o1_.localization_id = COALESCE(o3_.id, 1)) ORDER BY o1_.localization_id DESC NULLS LAST, o1_.webCatalog_id DESC NULLS LAST, o1_.customerGroup_id DESC NULLS LAST, o0_.id ASC;

SELECT
  o0_.id AS id_0,
  o0_.url AS url_1,
  o0_.slug_prototype AS slug_prototype_2,
  o0_.url_hash AS url_hash_3,
  o0_.route_name AS route_name_4,
  o0_.route_parameters AS route_parameters_5,
  o0_.scopes_hash AS scopes_hash_6,
  o0_.parameters_hash AS parameters_hash_7,
  o1_.id AS id_8
FROM
  oro_redirect_slug o0_
  LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id
  LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id
  AND (
    (
      o1_.webCatalog_id = ?
      OR o1_.webCatalog_id IS NULL
    )
    AND (o1_.customer_id IS NULL)
    AND (
      o1_.customerGroup_id = ?
      OR o1_.customerGroup_id IS NULL
    )
    AND (o1_.organization_id IS NULL)
    AND (o1_.user_id IS NULL)
    AND (o1_.website_id IS NULL)
  )
  LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id
WHERE
  o1_.id IS NULL
  AND o0_.slug_prototype = ?
  AND (
    o1_.localization_id IS NULL
    OR o1_.localization_id = COALESCE(o3_.id, ?)
  )
ORDER BY
  o1_.localization_id DESC NULLS LAST,
  o1_.webCatalog_id DESC NULLS LAST,
  o1_.customerGroup_id DESC NULLS LAST,
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.url AS url_1, o0_.slug_prototype AS slug_prototype_2, o0_.url_hash AS url_hash_3, o0_.route_name AS route_name_4, o0_.route_parameters AS route_parameters_5, o0_.scopes_hash AS scopes_hash_6, o0_.parameters_hash AS parameters_hash_7, o1_.id AS id_8 FROM oro_redirect_slug o0_ LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id AND ((o1_.webCatalog_id = 1 OR o1_.webCatalog_id IS NULL) AND (o1_.customer_id IS NULL) AND (o1_.customerGroup_id = 1 OR o1_.customerGroup_id IS NULL) AND (o1_.organization_id IS NULL) AND (o1_.user_id IS NULL) AND (o1_.website_id IS NULL)) LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id WHERE o1_.id IS NULL AND o0_.slug_prototype = 'green-beige-sofa' AND (o1_.localization_id IS NULL OR o1_.localization_id = COALESCE(o3_.id, 1)) ORDER BY o1_.localization_id DESC NULLS LAST, o1_.webCatalog_id DESC NULLS LAST, o1_.customerGroup_id DESC NULLS LAST, o0_.id ASC;

SELECT
  1
FROM
  oro_slug_scope
WHERE
  slug_id = ?
LIMIT
  1

SELECT 1 FROM oro_slug_scope WHERE slug_id = 58 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.slug_prototype AS slug_prototype_3,
  t0.url_hash AS url_hash_4,
  t0.route_name AS route_name_5,
  t0.route_parameters AS route_parameters_6,
  t0.scopes_hash AS scopes_hash_7,
  t0.parameters_hash AS parameters_hash_8,
  t0.localization_id AS localization_id_9,
  t0.organization_id AS organization_id_10
FROM
  oro_redirect_slug t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.slug_prototype AS slug_prototype_3, t0.url_hash AS url_hash_4, t0.route_name AS route_name_5, t0.route_parameters AS route_parameters_6, t0.scopes_hash AS scopes_hash_7, t0.parameters_hash AS parameters_hash_8, t0.localization_id AS localization_id_9, t0.organization_id AS organization_id_10 FROM oro_redirect_slug t0 WHERE t0.id = 58;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.enabled AS enabled_3,
  t0.installed_build_date AS installed_build_date_4,
  t0.local_files_language AS local_files_language_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.organization_id AS organization_id_8
FROM
  oro_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.installed_build_date AS installed_build_date_4, t0.local_files_language AS local_files_language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.organization_id AS organization_id_8 FROM oro_language t0 WHERE t0.id = 1;

SELECT
  o0_.theme AS theme_0
FROM
  oro_theme_configuration o0_
WHERE
  o0_.id = ?

SELECT o0_.theme AS theme_0 FROM oro_theme_configuration o0_ WHERE o0_.id = 1;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.sku_uppercase AS sku_uppercase_3,
  t0.status AS status_4,
  t0.variant_fields AS variant_fields_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type AS type_8,
  t0.is_featured AS is_featured_9,
  t0.is_new_arrival AS is_new_arrival_10,
  t0.name AS name_11,
  t0.name_uppercase AS name_uppercase_12,
  t0.kit_shipping_calculation_method AS kit_shipping_calculation_method_13,
  t0.category_sort_order AS category_sort_order_14,
  t0.availability_date AS availability_date_15,
  t0.serialized_data AS serialized_data_16,
  t0.business_unit_owner_id AS business_unit_owner_id_17,
  t0.organization_id AS organization_id_18,
  t0.primary_unit_precision_id AS primary_unit_precision_id_19,
  t0.default_variant_id AS default_variant_id_20,
  t0.attribute_family_id AS attribute_family_id_21,
  t0.brand_id AS brand_id_22,
  t0.category_id AS category_id_23,
  t0.taxCode_id AS taxcode_id_24,
  t0.pageTemplate_id AS pagetemplate_id_25,
  t0.manageInventory_id AS manageinventory_id_26,
  t0.highlightLowInventory_id AS highlightlowinventory_id_27,
  t0.inventoryThreshold_id AS inventorythreshold_id_28,
  t0.lowInventoryThreshold_id AS lowinventorythreshold_id_29,
  t0.minimumQuantityToOrder_id AS minimumquantitytoorder_id_30,
  t0.maximumQuantityToOrder_id AS maximumquantitytoorder_id_31,
  t0.decrementQuantity_id AS decrementquantity_id_32,
  t0.backOrder_id AS backorder_id_33,
  t0.isUpcoming_id AS isupcoming_id_34
FROM
  oro_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.sku_uppercase AS sku_uppercase_3, t0.status AS status_4, t0.variant_fields AS variant_fields_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type AS type_8, t0.is_featured AS is_featured_9, t0.is_new_arrival AS is_new_arrival_10, t0.name AS name_11, t0.name_uppercase AS name_uppercase_12, t0.kit_shipping_calculation_method AS kit_shipping_calculation_method_13, t0.category_sort_order AS category_sort_order_14, t0.availability_date AS availability_date_15, t0.serialized_data AS serialized_data_16, t0.business_unit_owner_id AS business_unit_owner_id_17, t0.organization_id AS organization_id_18, t0.primary_unit_precision_id AS primary_unit_precision_id_19, t0.default_variant_id AS default_variant_id_20, t0.attribute_family_id AS attribute_family_id_21, t0.brand_id AS brand_id_22, t0.category_id AS category_id_23, t0.taxCode_id AS taxcode_id_24, t0.pageTemplate_id AS pagetemplate_id_25, t0.manageInventory_id AS manageinventory_id_26, t0.highlightLowInventory_id AS highlightlowinventory_id_27, t0.inventoryThreshold_id AS inventorythreshold_id_28, t0.lowInventoryThreshold_id AS lowinventorythreshold_id_29, t0.minimumQuantityToOrder_id AS minimumquantitytoorder_id_30, t0.maximumQuantityToOrder_id AS maximumquantitytoorder_id_31, t0.decrementQuantity_id AS decrementquantity_id_32, t0.backOrder_id AS backorder_id_33, t0.isUpcoming_id AS isupcoming_id_34 FROM oro_product t0 WHERE t0.id = 34;

SELECT
  COUNT(*)
FROM
  oro_product_variant_link t0
WHERE
  t0.product_id = ?

SELECT COUNT(*) FROM oro_product_variant_link t0 WHERE t0.product_id = 34;

SELECT
  o0_.id AS id_0
FROM
  oro_product o0_
  LEFT JOIN oro_prod_vsb_resolv o1_ ON (
    o0_.id = o1_.product_id
    AND o1_.scope_id = ?
  )
  LEFT JOIN oro_cus_grp_prod_vsb_resolv o2_ ON (
    o0_.id = o2_.product_id
    AND o2_.scope_id = ?
  )
  LEFT JOIN oro_cus_prod_vsb_resolv o3_ ON (
    o0_.id = o3_.product_id
    AND o3_.scope_id = ?
  )
WHERE
  o0_.id IN (?)
  AND COALESCE(
    CASE WHEN o1_.visibility = 0 THEN
      1
    ELSE
      o1_.visibility
    END,
    1
  ) + COALESCE(
    CASE WHEN o2_.visibility = 0 THEN
      1
    ELSE
      o2_.visibility
    END,
    0
  ) * 10 + CASE WHEN o3_.visibility = 2 THEN
    (
      COALESCE(
        CASE WHEN o1_.visibility = 0 THEN
          1
        ELSE
          o1_.visibility
        END,
        1
      ) * 100
    )
  ELSE
    (
      COALESCE(
        CASE WHEN o3_.visibility = 0 THEN
          1
        ELSE
          o3_.visibility
        END,
        0
      ) * 100
    )
  END > 0

SELECT o0_.id AS id_0 FROM oro_product o0_ LEFT JOIN oro_prod_vsb_resolv o1_ ON (o0_.id = o1_.product_id AND o1_.scope_id = 1) LEFT JOIN oro_cus_grp_prod_vsb_resolv o2_ ON (o0_.id = o2_.product_id AND o2_.scope_id = 3) LEFT JOIN oro_cus_prod_vsb_resolv o3_ ON (o0_.id = o3_.product_id AND o3_.scope_id = 1) WHERE o0_.id IN (34) AND COALESCE(CASE WHEN o1_.visibility = 0 THEN 1 ELSE o1_.visibility END, 1) + COALESCE(CASE WHEN o2_.visibility = 0 THEN 1 ELSE o2_.visibility END, 0) * 10 + CASE WHEN o3_.visibility = 2 THEN (COALESCE(CASE WHEN o1_.visibility = 0 THEN 1 ELSE o1_.visibility END, 1) * 100) ELSE (COALESCE(CASE WHEN o3_.visibility = 0 THEN 1 ELSE o3_.visibility END, 0) * 100) END > 0;

SELECT
  t0.id AS id_1,
  t0.fallback AS fallback_2,
  t0.scalar_value AS scalar_value_3,
  t0.array_value AS array_value_4
FROM
  oro_entity_fallback_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fallback AS fallback_2, t0.scalar_value AS scalar_value_3, t0.array_value AS array_value_4 FROM oro_entity_fallback_value t0 WHERE t0.id = 331;

SELECT
  o0_.configuration AS configuration_0
FROM
  oro_theme_configuration o0_
WHERE
  o0_.id = ?

SELECT o0_.configuration AS configuration_0 FROM oro_theme_configuration o0_ WHERE o0_.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.entity_class AS entity_class_3,
  t0.is_enabled AS is_enabled_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.serialized_data AS serialized_data_7,
  t0.organization_id AS organization_id_8,
  t0.image_id AS image_id_9
FROM
  oro_attribute_family t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.entity_class AS entity_class_3, t0.is_enabled AS is_enabled_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.serialized_data AS serialized_data_7, t0.organization_id AS organization_id_8, t0.image_id AS image_id_9 FROM oro_attribute_family t0 WHERE t0.id = 1;

SELECT
  o0_.id AS id_0,
  o0_.materialized_path AS materialized_path_1,
  o0_.title AS title_2,
  o0_.tree_left AS tree_left_3,
  o0_.tree_level AS tree_level_4,
  o0_.tree_right AS tree_right_5,
  o0_.tree_root AS tree_root_6,
  o0_.created_at AS created_at_7,
  o0_.updated_at AS updated_at_8,
  o0_.availability_date AS availability_date_9,
  o0_.serialized_data AS serialized_data_10,
  o0_.parent_id AS parent_id_11,
  o0_.default_product_options_id AS default_product_options_id_12,
  o0_.organization_id AS organization_id_13,
  o0_.manageInventory_id AS manageinventory_id_14,
  o0_.highlightLowInventory_id AS highlightlowinventory_id_15,
  o0_.inventoryThreshold_id AS inventorythreshold_id_16,
  o0_.lowInventoryThreshold_id AS lowinventorythreshold_id_17,
  o0_.minimumQuantityToOrder_id AS minimumquantitytoorder_id_18,
  o0_.maximumQuantityToOrder_id AS maximumquantitytoorder_id_19,
  o0_.decrementQuantity_id AS decrementquantity_id_20,
  o0_.backOrder_id AS backorder_id_21,
  o0_.isUpcoming_id AS isupcoming_id_22,
  o0_.largeImage_id AS largeimage_id_23,
  o0_.smallImage_id AS smallimage_id_24
FROM
  oro_product o1_
  INNER JOIN oro_catalog_category o0_ ON (o0_.id = o1_.category_id)
WHERE
  o1_.id = ?
LIMIT
  1

SELECT o0_.id AS id_0, o0_.materialized_path AS materialized_path_1, o0_.title AS title_2, o0_.tree_left AS tree_left_3, o0_.tree_level AS tree_level_4, o0_.tree_right AS tree_right_5, o0_.tree_root AS tree_root_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.availability_date AS availability_date_9, o0_.serialized_data AS serialized_data_10, o0_.parent_id AS parent_id_11, o0_.default_product_options_id AS default_product_options_id_12, o0_.organization_id AS organization_id_13, o0_.manageInventory_id AS manageinventory_id_14, o0_.highlightLowInventory_id AS highlightlowinventory_id_15, o0_.inventoryThreshold_id AS inventorythreshold_id_16, o0_.lowInventoryThreshold_id AS lowinventorythreshold_id_17, o0_.minimumQuantityToOrder_id AS minimumquantitytoorder_id_18, o0_.maximumQuantityToOrder_id AS maximumquantitytoorder_id_19, o0_.decrementQuantity_id AS decrementquantity_id_20, o0_.backOrder_id AS backorder_id_21, o0_.isUpcoming_id AS isupcoming_id_22, o0_.largeImage_id AS largeimage_id_23, o0_.smallImage_id AS smallimage_id_24 FROM oro_product o1_ INNER JOIN oro_catalog_category o0_ ON (o0_.id = o1_.category_id) WHERE o1_.id = 34 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.materialized_path AS materialized_path_2,
  t0.title AS title_3,
  t0.tree_left AS tree_left_4,
  t0.tree_level AS tree_level_5,
  t0.tree_right AS tree_right_6,
  t0.tree_root AS tree_root_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.availability_date AS availability_date_10,
  t0.serialized_data AS serialized_data_11,
  t0.parent_id AS parent_id_12,
  t0.default_product_options_id AS default_product_options_id_13,
  t0.organization_id AS organization_id_14,
  t0.manageInventory_id AS manageinventory_id_15,
  t0.highlightLowInventory_id AS highlightlowinventory_id_16,
  t0.inventoryThreshold_id AS inventorythreshold_id_17,
  t0.lowInventoryThreshold_id AS lowinventorythreshold_id_18,
  t0.minimumQuantityToOrder_id AS minimumquantitytoorder_id_19,
  t0.maximumQuantityToOrder_id AS maximumquantitytoorder_id_20,
  t0.decrementQuantity_id AS decrementquantity_id_21,
  t0.backOrder_id AS backorder_id_22,
  t0.isUpcoming_id AS isupcoming_id_23,
  t0.largeImage_id AS largeimage_id_24,
  t0.smallImage_id AS smallimage_id_25
FROM
  oro_catalog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.materialized_path AS materialized_path_2, t0.title AS title_3, t0.tree_left AS tree_left_4, t0.tree_level AS tree_level_5, t0.tree_right AS tree_right_6, t0.tree_root AS tree_root_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.availability_date AS availability_date_10, t0.serialized_data AS serialized_data_11, t0.parent_id AS parent_id_12, t0.default_product_options_id AS default_product_options_id_13, t0.organization_id AS organization_id_14, t0.manageInventory_id AS manageinventory_id_15, t0.highlightLowInventory_id AS highlightlowinventory_id_16, t0.inventoryThreshold_id AS inventorythreshold_id_17, t0.lowInventoryThreshold_id AS lowinventorythreshold_id_18, t0.minimumQuantityToOrder_id AS minimumquantitytoorder_id_19, t0.maximumQuantityToOrder_id AS maximumquantitytoorder_id_20, t0.decrementQuantity_id AS decrementquantity_id_21, t0.backOrder_id AS backorder_id_22, t0.isUpcoming_id AS isupcoming_id_23, t0.largeImage_id AS largeimage_id_24, t0.smallImage_id AS smallimage_id_25 FROM oro_catalog_category t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.is_visible AS is_visible_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.attribute_family_id AS attribute_family_id_6
FROM
  oro_attribute_group t0
WHERE
  t0.attribute_family_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.is_visible AS is_visible_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.attribute_family_id AS attribute_family_id_6 FROM oro_attribute_group t0 WHERE t0.attribute_family_id = 1 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.entity_config_field_id AS entity_config_field_id_2,
  t0.attribute_group_id AS attribute_group_id_3
FROM
  oro_attribute_group_rel t0
WHERE
  t0.attribute_group_id = ?

SELECT t0.id AS id_1, t0.entity_config_field_id AS entity_config_field_id_2, t0.attribute_group_id AS attribute_group_id_3 FROM oro_attribute_group_rel t0 WHERE t0.attribute_group_id = 1;

SELECT
  t0.id AS id_1,
  t0.entity_config_field_id AS entity_config_field_id_2,
  t0.attribute_group_id AS attribute_group_id_3
FROM
  oro_attribute_group_rel t0
WHERE
  t0.attribute_group_id = ?

SELECT t0.id AS id_1, t0.entity_config_field_id AS entity_config_field_id_2, t0.attribute_group_id AS attribute_group_id_3 FROM oro_attribute_group_rel t0 WHERE t0.attribute_group_id = 2;

SELECT
  t0.id AS id_1,
  t0.entity_config_field_id AS entity_config_field_id_2,
  t0.attribute_group_id AS attribute_group_id_3
FROM
  oro_attribute_group_rel t0
WHERE
  t0.attribute_group_id = ?

SELECT t0.id AS id_1, t0.entity_config_field_id AS entity_config_field_id_2, t0.attribute_group_id AS attribute_group_id_3 FROM oro_attribute_group_rel t0 WHERE t0.attribute_group_id = 3;

SELECT
  t0.id AS id_1,
  t0.entity_config_field_id AS entity_config_field_id_2,
  t0.attribute_group_id AS attribute_group_id_3
FROM
  oro_attribute_group_rel t0
WHERE
  t0.attribute_group_id = ?

SELECT t0.id AS id_1, t0.entity_config_field_id AS entity_config_field_id_2, t0.attribute_group_id AS attribute_group_id_3 FROM oro_attribute_group_rel t0 WHERE t0.attribute_group_id = 4;

SELECT
  t0.id AS id_1,
  t0.entity_config_field_id AS entity_config_field_id_2,
  t0.attribute_group_id AS attribute_group_id_3
FROM
  oro_attribute_group_rel t0
WHERE
  t0.attribute_group_id = ?

SELECT t0.id AS id_1, t0.entity_config_field_id AS entity_config_field_id_2, t0.attribute_group_id AS attribute_group_id_3 FROM oro_attribute_group_rel t0 WHERE t0.attribute_group_id = 5;

SELECT
  t0.string AS string_1,
  t0.id AS id_2,
  t0.fallback AS fallback_3,
  t0.product_id AS product_id_4,
  t0.localization_id AS localization_id_5
FROM
  oro_product_prod_name t0
WHERE
  t0.product_id = ?

SELECT t0.string AS string_1, t0.id AS id_2, t0.fallback AS fallback_3, t0.product_id AS product_id_4, t0.localization_id AS localization_id_5 FROM oro_product_prod_name t0 WHERE t0.product_id = 34;

SELECT
  DISTINCT o0_.scope_id AS sclr_0,
  o0_.menu AS menu_1
FROM
  oro_commerce_menu_upd o0_

SELECT DISTINCT o0_.scope_id AS sclr_0, o0_.menu AS menu_1 FROM oro_commerce_menu_upd o0_;

SELECT
  o0_.id AS id_0,
  o0_.type AS type_1,
  o0_.system_page_route AS system_page_route_2,
  o0_.is_default AS is_default_3,
  o0_.override_variant_configuration AS override_variant_configuration_4,
  o0_.do_not_render_title AS do_not_render_title_5,
  o0_.exclude_subcategories AS exclude_subcategories_6,
  o0_.serialized_data AS serialized_data_7,
  o0_.node_id AS node_id_8,
  o0_.cms_page_id AS cms_page_id_9,
  o0_.product_page_product_id AS product_page_product_id_10,
  o0_.product_collection_segment_id AS product_collection_segment_id_11,
  o0_.category_page_category_id AS category_page_category_id_12
FROM
  oro_web_catalog_variant o0_
  INNER JOIN oro_web_catalog_variant_slug o2_ ON o0_.id = o2_.content_variant_id
  INNER JOIN oro_redirect_slug o1_ ON o1_.id = o2_.slug_id
WHERE
  o1_.id = ?

SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.system_page_route AS system_page_route_2, o0_.is_default AS is_default_3, o0_.override_variant_configuration AS override_variant_configuration_4, o0_.do_not_render_title AS do_not_render_title_5, o0_.exclude_subcategories AS exclude_subcategories_6, o0_.serialized_data AS serialized_data_7, o0_.node_id AS node_id_8, o0_.cms_page_id AS cms_page_id_9, o0_.product_page_product_id AS product_page_product_id_10, o0_.product_collection_segment_id AS product_collection_segment_id_11, o0_.category_page_category_id AS category_page_category_id_12 FROM oro_web_catalog_variant o0_ INNER JOIN oro_web_catalog_variant_slug o2_ ON o0_.id = o2_.content_variant_id INNER JOIN oro_redirect_slug o1_ ON o1_.id = o2_.slug_id WHERE o1_.id = 58;

SELECT
  t0.string AS string_1,
  t0.text AS text_2,
  t0.id AS id_3,
  t0.fallback AS fallback_4,
  t0.wysiwyg AS wysiwyg_5,
  t0.wysiwyg_style AS wysiwyg_style_6,
  t0.wysiwyg_properties AS wysiwyg_properties_7,
  t0.serialized_data AS serialized_data_8,
  t0.localization_id AS localization_id_9
FROM
  oro_fallback_localization_val t0
  INNER JOIN oro_rel_1cf73d3121a159aea3971e ON t0.id = oro_rel_1cf73d3121a159aea3971e.localizedfallbackvalue_id
WHERE
  oro_rel_1cf73d3121a159aea3971e.product_id = ?

SELECT t0.string AS string_1, t0.text AS text_2, t0.id AS id_3, t0.fallback AS fallback_4, t0.wysiwyg AS wysiwyg_5, t0.wysiwyg_style AS wysiwyg_style_6, t0.wysiwyg_properties AS wysiwyg_properties_7, t0.serialized_data AS serialized_data_8, t0.localization_id AS localization_id_9 FROM oro_fallback_localization_val t0 INNER JOIN oro_rel_1cf73d3121a159aea3971e ON t0.id = oro_rel_1cf73d3121a159aea3971e.localizedfallbackvalue_id WHERE oro_rel_1cf73d3121a159aea3971e.product_id = 34;

SELECT
  t0.string AS string_1,
  t0.text AS text_2,
  t0.id AS id_3,
  t0.fallback AS fallback_4,
  t0.wysiwyg AS wysiwyg_5,
  t0.wysiwyg_style AS wysiwyg_style_6,
  t0.wysiwyg_properties AS wysiwyg_properties_7,
  t0.serialized_data AS serialized_data_8,
  t0.localization_id AS localization_id_9
FROM
  oro_fallback_localization_val t0
  INNER JOIN oro_rel_1cf73d3121a159ae2725f3 ON t0.id = oro_rel_1cf73d3121a159ae2725f3.localizedfallbackvalue_id
WHERE
  oro_rel_1cf73d3121a159ae2725f3.product_id = ?

SELECT t0.string AS string_1, t0.text AS text_2, t0.id AS id_3, t0.fallback AS fallback_4, t0.wysiwyg AS wysiwyg_5, t0.wysiwyg_style AS wysiwyg_style_6, t0.wysiwyg_properties AS wysiwyg_properties_7, t0.serialized_data AS serialized_data_8, t0.localization_id AS localization_id_9 FROM oro_fallback_localization_val t0 INNER JOIN oro_rel_1cf73d3121a159ae2725f3 ON t0.id = oro_rel_1cf73d3121a159ae2725f3.localizedfallbackvalue_id WHERE oro_rel_1cf73d3121a159ae2725f3.product_id = 34;

SELECT
  t0.string AS string_1,
  t0.text AS text_2,
  t0.id AS id_3,
  t0.fallback AS fallback_4,
  t0.wysiwyg AS wysiwyg_5,
  t0.wysiwyg_style AS wysiwyg_style_6,
  t0.wysiwyg_properties AS wysiwyg_properties_7,
  t0.serialized_data AS serialized_data_8,
  t0.localization_id AS localization_id_9
FROM
  oro_fallback_localization_val t0
  INNER JOIN oro_rel_1cf73d3121a159ae6e1a29 ON t0.id = oro_rel_1cf73d3121a159ae6e1a29.localizedfallbackvalue_id
WHERE
  oro_rel_1cf73d3121a159ae6e1a29.product_id = ?

SELECT t0.string AS string_1, t0.text AS text_2, t0.id AS id_3, t0.fallback AS fallback_4, t0.wysiwyg AS wysiwyg_5, t0.wysiwyg_style AS wysiwyg_style_6, t0.wysiwyg_properties AS wysiwyg_properties_7, t0.serialized_data AS serialized_data_8, t0.localization_id AS localization_id_9 FROM oro_fallback_localization_val t0 INNER JOIN oro_rel_1cf73d3121a159ae6e1a29 ON t0.id = oro_rel_1cf73d3121a159ae6e1a29.localizedfallbackvalue_id WHERE oro_rel_1cf73d3121a159ae6e1a29.product_id = 34;