Symfony Profiler

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 = 14;

SELECT
  o0_.id AS id_0,
  o0_.entity_class AS entity_class_1,
  o0_.workflow_step_id AS sclr_2,
  o0_.mode AS mode_3,
  o0_.field AS field_4,
  o0_.mode_values AS mode_values_5,
  o1_.related_entity AS related_entity_6,
  o1_.name AS name_7
FROM
  oro_workflow_restriction o0_
  INNER JOIN oro_workflow_definition o1_ ON o0_.workflow_name = o1_.name
WHERE
  o0_.entity_class = ?

SELECT o0_.id AS id_0, o0_.entity_class AS entity_class_1, o0_.workflow_step_id AS sclr_2, o0_.mode AS mode_3, o0_.field AS field_4, o0_.mode_values AS mode_values_5, o1_.related_entity AS related_entity_6, o1_.name AS name_7 FROM oro_workflow_restriction o0_ INNER JOIN oro_workflow_definition o1_ ON o0_.workflow_name = o1_.name WHERE o0_.entity_class = 'Symfony\\Component\\Form\\Form';

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 = '42118a5a70ca57aa1c1704ebb1b456d2' AND o0_.url = '/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
FROM
  oro_product o0_
  INNER JOIN oro_product_variant_link o1_ ON o0_.id = o1_.product_id
  LEFT JOIN oro_prod_vsb_resolv o2_ ON (
    o0_.id = o2_.product_id
    AND o2_.scope_id = ?
  )
  LEFT JOIN oro_cus_grp_prod_vsb_resolv o3_ ON (
    o0_.id = o3_.product_id
    AND o3_.scope_id = ?
  )
  LEFT JOIN oro_cus_prod_vsb_resolv o4_ ON (
    o0_.id = o4_.product_id
    AND o4_.scope_id = ?
  )
WHERE
  o1_.parent_product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND o0_.status IN (?)
  AND o0_.serialized_data ->> 'inventory_status' IN (?, ?)
  AND COALESCE(
    CASE WHEN o2_.visibility = 0 THEN
      1
    ELSE
      o2_.visibility
    END,
    1
  ) + COALESCE(
    CASE WHEN o3_.visibility = 0 THEN
      1
    ELSE
      o3_.visibility
    END,
    0
  ) * 10 + CASE WHEN o4_.visibility = 2 THEN
    (
      COALESCE(
        CASE WHEN o2_.visibility = 0 THEN
          1
        ELSE
          o2_.visibility
        END,
        1
      ) * 100
    )
  ELSE
    (
      COALESCE(
        CASE WHEN o4_.visibility = 0 THEN
          1
        ELSE
          o4_.visibility
        END,
        0
      ) * 100
    )
  END > 0

SELECT o0_.id AS id_0 FROM oro_product o0_ INNER JOIN oro_product_variant_link o1_ ON o0_.id = o1_.product_id LEFT JOIN oro_prod_vsb_resolv o2_ ON (o0_.id = o2_.product_id AND o2_.scope_id = 1) LEFT JOIN oro_cus_grp_prod_vsb_resolv o3_ ON (o0_.id = o3_.product_id AND o3_.scope_id = 3) LEFT JOIN oro_cus_prod_vsb_resolv o4_ ON (o0_.id = o4_.product_id AND o4_.scope_id = 1) WHERE o1_.parent_product_id IN (14, 15, 16, 24, 27, 31, 34, 37, 38, 39, 43, 46, 51, 54, 55) AND o0_.status IN ('enabled') AND o0_.serialized_data->>'inventory_status' IN ('prod_inventory_status.in_stock', 'prod_inventory_status.out_of_stock') AND COALESCE(CASE WHEN o2_.visibility = 0 THEN 1 ELSE o2_.visibility END, 1) + COALESCE(CASE WHEN o3_.visibility = 0 THEN 1 ELSE o3_.visibility END, 0) * 10 + CASE WHEN o4_.visibility = 2 THEN (COALESCE(CASE WHEN o2_.visibility = 0 THEN 1 ELSE o2_.visibility END, 1) * 100) ELSE (COALESCE(CASE WHEN o4_.visibility = 0 THEN 1 ELSE o4_.visibility END, 0) * 100) END > 0;

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 = 11;

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,
  o1_.id AS id_11,
  o1_.materialized_path AS materialized_path_12,
  o1_.title AS title_13,
  o1_.tree_left AS tree_left_14,
  o1_.tree_level AS tree_level_15,
  o1_.tree_right AS tree_right_16,
  o1_.tree_root AS tree_root_17,
  o1_.created_at AS created_at_18,
  o1_.updated_at AS updated_at_19,
  o1_.availability_date AS availability_date_20,
  o1_.serialized_data AS serialized_data_21,
  o0_.parent_id AS parent_id_22,
  o0_.default_product_options_id AS default_product_options_id_23,
  o0_.organization_id AS organization_id_24,
  o0_.manageInventory_id AS manageinventory_id_25,
  o0_.highlightLowInventory_id AS highlightlowinventory_id_26,
  o0_.inventoryThreshold_id AS inventorythreshold_id_27,
  o0_.lowInventoryThreshold_id AS lowinventorythreshold_id_28,
  o0_.minimumQuantityToOrder_id AS minimumquantitytoorder_id_29,
  o0_.maximumQuantityToOrder_id AS maximumquantitytoorder_id_30,
  o0_.decrementQuantity_id AS decrementquantity_id_31,
  o0_.backOrder_id AS backorder_id_32,
  o0_.isUpcoming_id AS isupcoming_id_33,
  o0_.largeImage_id AS largeimage_id_34,
  o0_.smallImage_id AS smallimage_id_35,
  o1_.parent_id AS parent_id_36,
  o1_.default_product_options_id AS default_product_options_id_37,
  o1_.organization_id AS organization_id_38,
  o1_.manageInventory_id AS manageinventory_id_39,
  o1_.highlightLowInventory_id AS highlightlowinventory_id_40,
  o1_.inventoryThreshold_id AS inventorythreshold_id_41,
  o1_.lowInventoryThreshold_id AS lowinventorythreshold_id_42,
  o1_.minimumQuantityToOrder_id AS minimumquantitytoorder_id_43,
  o1_.maximumQuantityToOrder_id AS maximumquantitytoorder_id_44,
  o1_.decrementQuantity_id AS decrementquantity_id_45,
  o1_.backOrder_id AS backorder_id_46,
  o1_.isUpcoming_id AS isupcoming_id_47,
  o1_.largeImage_id AS largeimage_id_48,
  o1_.smallImage_id AS smallimage_id_49
FROM
  oro_catalog_category o0_
  LEFT JOIN oro_catalog_category o1_ ON o0_.id = o1_.parent_id
WHERE
  o0_.tree_right < 21
  AND o0_.tree_left > 20
  AND o0_.tree_root = ?
ORDER BY
  o0_.tree_left ASC,
  o1_.tree_left ASC

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, o1_.id AS id_11, o1_.materialized_path AS materialized_path_12, o1_.title AS title_13, o1_.tree_left AS tree_left_14, o1_.tree_level AS tree_level_15, o1_.tree_right AS tree_right_16, o1_.tree_root AS tree_root_17, o1_.created_at AS created_at_18, o1_.updated_at AS updated_at_19, o1_.availability_date AS availability_date_20, o1_.serialized_data AS serialized_data_21, o0_.parent_id AS parent_id_22, o0_.default_product_options_id AS default_product_options_id_23, o0_.organization_id AS organization_id_24, o0_.manageInventory_id AS manageinventory_id_25, o0_.highlightLowInventory_id AS highlightlowinventory_id_26, o0_.inventoryThreshold_id AS inventorythreshold_id_27, o0_.lowInventoryThreshold_id AS lowinventorythreshold_id_28, o0_.minimumQuantityToOrder_id AS minimumquantitytoorder_id_29, o0_.maximumQuantityToOrder_id AS maximumquantitytoorder_id_30, o0_.decrementQuantity_id AS decrementquantity_id_31, o0_.backOrder_id AS backorder_id_32, o0_.isUpcoming_id AS isupcoming_id_33, o0_.largeImage_id AS largeimage_id_34, o0_.smallImage_id AS smallimage_id_35, o1_.parent_id AS parent_id_36, o1_.default_product_options_id AS default_product_options_id_37, o1_.organization_id AS organization_id_38, o1_.manageInventory_id AS manageinventory_id_39, o1_.highlightLowInventory_id AS highlightlowinventory_id_40, o1_.inventoryThreshold_id AS inventorythreshold_id_41, o1_.lowInventoryThreshold_id AS lowinventorythreshold_id_42, o1_.minimumQuantityToOrder_id AS minimumquantitytoorder_id_43, o1_.maximumQuantityToOrder_id AS maximumquantitytoorder_id_44, o1_.decrementQuantity_id AS decrementquantity_id_45, o1_.backOrder_id AS backorder_id_46, o1_.isUpcoming_id AS isupcoming_id_47, o1_.largeImage_id AS largeimage_id_48, o1_.smallImage_id AS smallimage_id_49 FROM oro_catalog_category o0_ LEFT JOIN oro_catalog_category o1_ ON o0_.id = o1_.parent_id WHERE o0_.tree_right < 21 AND o0_.tree_left > 20 AND o0_.tree_root = 1 ORDER BY o0_.tree_left ASC, o1_.tree_left ASC;

SELECT
  o0_.id AS id_0,
  o0_.status AS status_1,
  o0_.default_title AS default_title_2,
  o0_.created_at AS created_at_3,
  o0_.updated_at AS updated_at_4,
  o0_.external_id AS external_id_5,
  o0_.serialized_data AS serialized_data_6,
  o1_.string AS string_7,
  o1_.text AS text_8,
  o1_.id AS id_9,
  o1_.fallback AS fallback_10,
  o1_.wysiwyg AS wysiwyg_11,
  o1_.wysiwyg_style AS wysiwyg_style_12,
  o1_.wysiwyg_properties AS wysiwyg_properties_13,
  o1_.serialized_data AS serialized_data_14,
  o0_.business_unit_owner_id AS business_unit_owner_id_15,
  o0_.organization_id AS organization_id_16,
  o1_.localization_id AS localization_id_17
FROM
  oro_brand o0_
  LEFT JOIN oro_brand_name o2_ ON o0_.id = o2_.brand_id
  LEFT JOIN oro_fallback_localization_val o1_ ON o1_.id = o2_.localized_value_id

SELECT o0_.id AS id_0, o0_.status AS status_1, o0_.default_title AS default_title_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.external_id AS external_id_5, o0_.serialized_data AS serialized_data_6, o1_.string AS string_7, o1_.text AS text_8, o1_.id AS id_9, o1_.fallback AS fallback_10, o1_.wysiwyg AS wysiwyg_11, o1_.wysiwyg_style AS wysiwyg_style_12, o1_.wysiwyg_properties AS wysiwyg_properties_13, o1_.serialized_data AS serialized_data_14, o0_.business_unit_owner_id AS business_unit_owner_id_15, o0_.organization_id AS organization_id_16, o1_.localization_id AS localization_id_17 FROM oro_brand o0_ LEFT JOIN oro_brand_name o2_ ON o0_.id = o2_.brand_id LEFT JOIN oro_fallback_localization_val o1_ ON o1_.id = o2_.localized_value_id;

SELECT
  o0_.id AS id_0
FROM
  oro_product o0_
WHERE
  o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT o0_.id AS id_0 FROM oro_product o0_ WHERE o0_.id IN (14, 15, 16, 24, 27, 31, 34, 37, 38, 39, 43, 46, 51, 54, 55);

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';

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_content_node o1_ ON (
    (o0_.node_id = o1_.id)
  )
  LEFT JOIN oro_web_catalog_variant_scope o3_ ON o0_.id = o3_.variant_id
  LEFT JOIN oro_scope o2_ ON o2_.id = o3_.scope_id
  AND (
    (
      o2_.webCatalog_id = ?
      OR o2_.webCatalog_id IS NULL
    )
    AND (o2_.customer_id IS NULL)
    AND (
      o2_.customerGroup_id = ?
      OR o2_.customerGroup_id IS NULL
    )
    AND (
      o2_.localization_id = ?
      OR o2_.localization_id IS NULL
    )
    AND (o2_.organization_id IS NULL)
    AND (o2_.user_id IS NULL)
    AND (o2_.website_id IS NULL)
  )
WHERE
  o1_.web_catalog_id = ?
  AND o0_.category_page_category_id = ?
  AND o0_.exclude_subcategories = ?
ORDER BY
  o2_.webCatalog_id DESC NULLS LAST,
  o2_.customerGroup_id DESC NULLS LAST,
  o2_.localization_id DESC NULLS LAST,
  o1_.tree_level ASC
LIMIT
  1

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_content_node o1_ ON ((o0_.node_id = o1_.id)) LEFT JOIN oro_web_catalog_variant_scope o3_ ON o0_.id = o3_.variant_id LEFT JOIN oro_scope o2_ ON o2_.id = o3_.scope_id AND ((o2_.webCatalog_id = 1 OR o2_.webCatalog_id IS NULL) AND (o2_.customer_id IS NULL) AND (o2_.customerGroup_id = 1 OR o2_.customerGroup_id IS NULL) AND (o2_.localization_id = 1 OR o2_.localization_id IS NULL) AND (o2_.organization_id IS NULL) AND (o2_.user_id IS NULL) AND (o2_.website_id IS NULL)) WHERE o1_.web_catalog_id = 1 AND o0_.category_page_category_id = 11 AND o0_.exclude_subcategories = 0 ORDER BY o2_.webCatalog_id DESC NULLS LAST, o2_.customerGroup_id DESC NULLS LAST, o2_.localization_id DESC NULLS LAST, o1_.tree_level ASC LIMIT 1;

SELECT
  o0_.id AS id_0
FROM
  oro_catalog_category o0_
  LEFT JOIN oro_ctgr_vsb_resolv o1_ ON (o0_.id = o1_.category_id)
  LEFT JOIN oro_cus_grp_ctgr_vsb_resolv o2_ ON (
    o0_.id = o2_.category_id
    AND o2_.scope_id = ?
  )
WHERE
  CASE WHEN o1_.visibility IS NOT NULL
  AND o1_.visibility <> 0 THEN
    o1_.visibility
  ELSE
    1
  END + COALESCE(
    CASE WHEN o2_.visibility = 0 THEN
      1
    ELSE
      o2_.visibility
    END,
    0
  ) * 10 <= 0
ORDER BY
  o0_.id ASC

SELECT o0_.id AS id_0 FROM oro_catalog_category o0_ LEFT JOIN oro_ctgr_vsb_resolv o1_ ON (o0_.id = o1_.category_id) LEFT JOIN oro_cus_grp_ctgr_vsb_resolv o2_ ON (o0_.id = o2_.category_id AND o2_.scope_id = 3) WHERE CASE WHEN o1_.visibility IS NOT NULL AND o1_.visibility <> 0 THEN o1_.visibility ELSE 1 END + COALESCE(CASE WHEN o2_.visibility = 0 THEN 1 ELSE o2_.visibility END, 0) * 10 <= 0 ORDER BY o0_.id ASC;

SELECT
  o0_.is_enabled AS is_enabled_0,
  o0_.is_prices_calculated AS is_prices_calculated_1,
  o0_.id AS id_2,
  o0_.name AS name_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5
FROM
  oro_price_list_combined o0_
  INNER JOIN oro_cmb_plist_to_cus_gr o1_ ON (
    o1_.combined_price_list_id = o0_.id
  )
WHERE
  o1_.customer_group_id = ?
  AND o1_.website_id = ?
  AND o0_.is_enabled = ?
LIMIT
  1

SELECT o0_.is_enabled AS is_enabled_0, o0_.is_prices_calculated AS is_prices_calculated_1, o0_.id AS id_2, o0_.name AS name_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5 FROM oro_price_list_combined o0_ INNER JOIN oro_cmb_plist_to_cus_gr o1_ ON (o1_.combined_price_list_id = o0_.id) WHERE o1_.customer_group_id = 1 AND o1_.website_id = 1 AND o0_.is_enabled = 1 LIMIT 1;

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_ff3a7b9721a159aea3971e ON t0.id = oro_rel_ff3a7b9721a159aea3971e.localizedfallbackvalue_id
WHERE
  oro_rel_ff3a7b9721a159aea3971e.category_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_ff3a7b9721a159aea3971e ON t0.id = oro_rel_ff3a7b9721a159aea3971e.localizedfallbackvalue_id WHERE oro_rel_ff3a7b9721a159aea3971e.category_id = 11;

SELECT
  o0_.product_id AS sclr_0,
  o0_.unit_code AS sclr_1,
  o0_.quantity AS quantity_2,
  o0_.value AS value_3,
  o0_.currency AS currency_4
FROM
  oro_price_product_combined o0_
WHERE
  o0_.combined_price_list_id = ?
  AND o0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND o0_.currency IN (?)
ORDER BY
  o0_.unit_code ASC,
  o0_.quantity ASC

SELECT o0_.product_id AS sclr_0, o0_.unit_code AS sclr_1, o0_.quantity AS quantity_2, o0_.value AS value_3, o0_.currency AS currency_4 FROM oro_price_product_combined o0_ WHERE o0_.combined_price_list_id = 2 AND o0_.product_id IN (14, 15, 16, 24, 27, 31, 34, 37, 38, 39, 43, 46, 51, 54, 55) AND o0_.currency IN ('USD') ORDER BY o0_.unit_code ASC, o0_.quantity ASC;

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 = 21;

SELECT
  COALESCE(
    o0_.visibility, o1_.visibility, 0
  ) AS sclr_0
FROM
  oro_catalog_category o2_
  LEFT JOIN oro_ctgr_vsb_resolv o1_ ON (o1_.category_id = o2_.id)
  LEFT JOIN oro_cus_grp_ctgr_vsb_resolv o0_ ON (
    o0_.category_id = o2_.id
    AND o0_.scope_id = ?
  )
WHERE
  o2_.id = ?

SELECT COALESCE(o0_.visibility, o1_.visibility, 0) AS sclr_0 FROM oro_catalog_category o2_ LEFT JOIN oro_ctgr_vsb_resolv o1_ ON (o1_.category_id = o2_.id) LEFT JOIN oro_cus_grp_ctgr_vsb_resolv o0_ ON (o0_.category_id = o2_.id AND o0_.scope_id = 3) WHERE o2_.id = 11;

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
  o0_.id AS id_0,
  o0_.attribute AS attribute_1,
  o0_.entity_class AS entity_class_2,
  o0_.updatable AS updatable_3,
  o0_.deletable AS deletable_4,
  o1_.name AS name_5,
  o1_.label AS label_6,
  o1_.related_entity AS related_entity_7,
  o1_.entity_attribute_name AS entity_attribute_name_8,
  o1_.steps_display_ordered AS steps_display_ordered_9,
  o1_."system" AS system_10,
  o1_.active AS active_11,
  o1_.priority AS priority_12,
  o1_.configuration AS configuration_13,
  o1_.metadata AS metadata_14,
  o1_.exclusive_active_groups AS exclusive_active_groups_15,
  o1_.exclusive_record_groups AS exclusive_record_groups_16,
  o1_.created_at AS created_at_17,
  o1_.updated_at AS updated_at_18,
  o1_.applications AS applications_19,
  o0_.workflow_name AS workflow_name_20,
  o0_.workflow_step_id AS workflow_step_id_21,
  o1_.start_step_id AS start_step_id_22
FROM
  oro_workflow_entity_acl o0_
  INNER JOIN oro_workflow_definition o1_ ON o0_.workflow_name = o1_.name

SELECT o0_.id AS id_0, o0_.attribute AS attribute_1, o0_.entity_class AS entity_class_2, o0_.updatable AS updatable_3, o0_.deletable AS deletable_4, o1_.name AS name_5, o1_.label AS label_6, o1_.related_entity AS related_entity_7, o1_.entity_attribute_name AS entity_attribute_name_8, o1_.steps_display_ordered AS steps_display_ordered_9, o1_."system" AS system_10, o1_.active AS active_11, o1_.priority AS priority_12, o1_.configuration AS configuration_13, o1_.metadata AS metadata_14, o1_.exclusive_active_groups AS exclusive_active_groups_15, o1_.exclusive_record_groups AS exclusive_record_groups_16, o1_.created_at AS created_at_17, o1_.updated_at AS updated_at_18, o1_.applications AS applications_19, o0_.workflow_name AS workflow_name_20, o0_.workflow_step_id AS workflow_step_id_21, o1_.start_step_id AS start_step_id_22 FROM oro_workflow_entity_acl o0_ INNER JOIN oro_workflow_definition o1_ ON o0_.workflow_name = o1_.name;

SELECT
  o0_.name AS name_0,
  o0_.label AS label_1,
  o0_.related_entity AS related_entity_2,
  o0_.entity_attribute_name AS entity_attribute_name_3,
  o0_.steps_display_ordered AS steps_display_ordered_4,
  o0_."system" AS system_5,
  o0_.active AS active_6,
  o0_.priority AS priority_7,
  o0_.configuration AS configuration_8,
  o0_.metadata AS metadata_9,
  o0_.exclusive_active_groups AS exclusive_active_groups_10,
  o0_.exclusive_record_groups AS exclusive_record_groups_11,
  o0_.created_at AS created_at_12,
  o0_.updated_at AS updated_at_13,
  o0_.applications AS applications_14,
  o0_.start_step_id AS start_step_id_15
FROM
  oro_workflow_definition o0_
WHERE
  o0_.active = ?
ORDER BY
  o0_.priority ASC