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

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 = 27 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 = ?
      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_.product_page_product_id = ?
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_.product_page_product_id = 27 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_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 (27) 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 = ?
  )
  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 o0_.status IN (?)
  AND o0_.serialized_data ->> 'inventory_status' IN (?, ?)
  AND NOT (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        oro_product_variant_link o4_
      WHERE
        o4_.product_id = o0_.id
    )
  )
  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
ORDER BY
  o0_.id ASC
LIMIT
  5

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 (14, 16, 24, 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 NOT (EXISTS (SELECT 1 AS sclr_1 FROM oro_product_variant_link o4_ WHERE o4_.product_id = o0_.id)) 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 ORDER BY o0_.id ASC LIMIT 5;

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_.product_id AS sclr_0,
  o1_.unit_code AS sclr_1,
  SUM(o0_.quantity) AS sclr_2
FROM
  oro_inventory_level o0_
  LEFT JOIN oro_product_unit_precision o1_ ON o0_.product_unit_precision_id = o1_.id
WHERE
  o0_.product_id IN (?, ?, ?, ?, ?)
GROUP BY
  o0_.product_id,
  o1_.unit_code

SELECT o0_.product_id AS sclr_0, o1_.unit_code AS sclr_1, SUM(o0_.quantity) AS sclr_2 FROM oro_inventory_level o0_ LEFT JOIN oro_product_unit_precision o1_ ON o0_.product_unit_precision_id = o1_.id WHERE o0_.product_id IN (34, 31, 24, 16, 14) GROUP BY o0_.product_id, o1_.unit_code;

SELECT
  o0_.id AS id_0,
  o0_.serialized_data AS serialized_data_1,
  o0_.row_hash AS row_hash_2,
  o0_.organization_id AS organization_id_3,
  o0_.user_id AS user_id_4,
  o0_.localization_id AS localization_id_5,
  o0_.website_id AS website_id_6,
  o0_.webCatalog_id AS webcatalog_id_7,
  o0_.customerGroup_id AS customergroup_id_8,
  o0_.customer_id AS customer_id_9
FROM
  oro_scope o0_
  INNER JOIN oro_redirect_slug o1_ ON (
    EXISTS (
      SELECT
        1
      FROM
        oro_slug_scope o2_
      WHERE
        o2_.slug_id = o1_.id
        AND o2_.scope_id IN (o0_.id)
    )
  )
WHERE
  (
    o0_.webCatalog_id = ?
    OR o0_.webCatalog_id IS NULL
  )
  AND o0_.customer_id IS NULL
  AND (
    o0_.customerGroup_id = ?
    OR o0_.customerGroup_id IS NULL
  )
  AND (
    o0_.localization_id = ?
    OR o0_.localization_id IS NULL
  )
  AND o0_.organization_id IS NULL
  AND o0_.user_id IS NULL
  AND o0_.website_id IS NULL
  AND (
    o0_.webCatalog_id IS NOT NULL
    OR o0_.customer_id IS NOT NULL
    OR o0_.customerGroup_id IS NOT NULL
    OR o0_.localization_id IS NOT NULL
    OR o0_.organization_id IS NOT NULL
    OR o0_.user_id IS NOT NULL
    OR o0_.website_id IS NOT NULL
  )
GROUP BY
  o0_.id
ORDER BY
  o0_.webCatalog_id DESC NULLS LAST,
  o0_.customerGroup_id DESC NULLS LAST,
  o0_.localization_id DESC NULLS LAST

SELECT o0_.id AS id_0, o0_.serialized_data AS serialized_data_1, o0_.row_hash AS row_hash_2, o0_.organization_id AS organization_id_3, o0_.user_id AS user_id_4, o0_.localization_id AS localization_id_5, o0_.website_id AS website_id_6, o0_.webCatalog_id AS webcatalog_id_7, o0_.customerGroup_id AS customergroup_id_8, o0_.customer_id AS customer_id_9 FROM oro_scope o0_ INNER JOIN oro_redirect_slug o1_ ON (EXISTS (SELECT 1 FROM oro_slug_scope o2_ WHERE o2_.slug_id = o1_.id AND o2_.scope_id IN (o0_.id))) WHERE (o0_.webCatalog_id = 1 OR o0_.webCatalog_id IS NULL) AND o0_.customer_id IS NULL AND (o0_.customerGroup_id = 1 OR o0_.customerGroup_id IS NULL) AND (o0_.localization_id = 1 OR o0_.localization_id IS NULL) AND o0_.organization_id IS NULL AND o0_.user_id IS NULL AND o0_.website_id IS NULL AND (o0_.webCatalog_id IS NOT NULL OR o0_.customer_id IS NOT NULL OR o0_.customerGroup_id IS NOT NULL OR o0_.localization_id IS NOT NULL OR o0_.organization_id IS NOT NULL OR o0_.user_id IS NOT NULL OR o0_.website_id IS NOT NULL) GROUP BY o0_.id ORDER BY o0_.webCatalog_id DESC NULLS LAST, o0_.customerGroup_id DESC NULLS LAST, o0_.localization_id DESC NULLS LAST;

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
  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 (27) 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.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 = 261;

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
  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.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 = 27;

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, 16, 24, 31, 34) 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
  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
  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
  COUNT(*)
FROM
  oro_product_variant_link t0
WHERE
  t0.product_id = ?

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

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 (27) AND o0_.currency IN ('USD') ORDER BY o0_.unit_code ASC, o0_.quantity ASC;

SELECT
  o0_.id AS id_0,
  o1_.string AS string_1,
  o1_.text AS text_2,
  o1_.id AS id_3,
  o1_.fallback AS fallback_4,
  o1_.wysiwyg AS wysiwyg_5,
  o1_.wysiwyg_style AS wysiwyg_style_6,
  o1_.wysiwyg_properties AS wysiwyg_properties_7,
  o1_.serialized_data AS serialized_data_8,
  o0_.content_node_id AS content_node_id_9,
  o0_.scope_id AS scope_id_10,
  o0_.category_id AS category_id_11,
  o0_.image_id AS image_id_12,
  o1_.localization_id AS localization_id_13
FROM
  oro_commerce_menu_upd o0_
  LEFT JOIN oro_commerce_menu_upd_title o2_ ON o0_.id = o2_.menu_update_id
  LEFT JOIN oro_fallback_localization_val o1_ ON o1_.id = o2_.localized_value_id
WHERE
  o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT o0_.id AS id_0, o1_.string AS string_1, o1_.text AS text_2, o1_.id AS id_3, o1_.fallback AS fallback_4, o1_.wysiwyg AS wysiwyg_5, o1_.wysiwyg_style AS wysiwyg_style_6, o1_.wysiwyg_properties AS wysiwyg_properties_7, o1_.serialized_data AS serialized_data_8, o0_.content_node_id AS content_node_id_9, o0_.scope_id AS scope_id_10, o0_.category_id AS category_id_11, o0_.image_id AS image_id_12, o1_.localization_id AS localization_id_13 FROM oro_commerce_menu_upd o0_ LEFT JOIN oro_commerce_menu_upd_title o2_ ON o0_.id = o2_.menu_update_id LEFT JOIN oro_fallback_localization_val o1_ ON o1_.id = o2_.localized_value_id WHERE o0_.id IN (7, 8, 9, 10, 11, 12, 13, 14, 15);

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.filename AS filename_3,
  t0.extension AS extension_4,
  t0.mime_type AS mime_type_5,
  t0.original_filename AS original_filename_6,
  t0.file_size AS file_size_7,
  t0.parent_entity_class AS parent_entity_class_8,
  t0.parent_entity_id AS parent_entity_id_9,
  t0.parent_entity_field_name AS parent_entity_field_name_10,
  t0.external_url AS external_url_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.serialized_data AS serialized_data_14,
  t0.owner_user_id AS owner_user_id_15,
  t0.digitalAsset_id AS digitalasset_id_16
FROM
  oro_attachment_file t0
WHERE
  t0.id IN (?, ?)