Query Metrics
6
Identical Queries
9
Similar Queries
Identical Queries
Queries with identical parameters
default connection
| Times called | SQL |
|---|---|
| 2 |
SELECT COUNT(*) FROM oro_product_prod_descr t0 WHERE t0.product_id = ?
Parameters: [34]
|
| 2 |
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
Parameters: [1, 1, 1]
|
| 2 |
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_price_list_to_ws o1_ ON (o1_.combined_price_list_id = o0_.id) WHERE o1_.website_id = ? AND o0_.is_enabled = ? LIMIT 1
Parameters: [1, 1]
|
| 2 |
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
Parameters: [27, 24, 16, 15, 14]
|
| 4 |
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
Parameters: [34]
|
search connection
| Times called | SQL |
|---|---|
| 2 |
SELECT DISTINCT o0_.id AS id_0, o0_.entity AS entity_1, o0_.alias AS alias_2, o0_.record_id AS record_id_3, o0_.weight AS weight_4, o0_.changed AS changed_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7, o1_.value AS value_8, o2_.value AS value_9, o3_.value AS value_10, o4_.value AS value_11, o5_.value AS value_12, o6_.value AS value_13, o7_.value AS value_14, o8_.value AS value_15, o9_.value AS value_16, o10_.value AS value_17, o11_.value AS value_18, o12_.value AS value_19, o13_.value AS value_20, o14_.value AS value_21, o15_.value AS value_22, o16_.value AS value_23 FROM oro_website_search_item o0_ LEFT JOIN oro_website_search_integer o1_ ON o0_.id = o1_.item_id AND (o1_.field = ?) LEFT JOIN oro_website_search_text o2_ ON o0_.id = o2_.item_id AND (o2_.field = ?) LEFT JOIN oro_website_search_text o3_ ON o0_.id = o3_.item_id AND (o3_.field = ?) LEFT JOIN oro_website_search_text o4_ ON o0_.id = o4_.item_id AND (o4_.field = ?) LEFT JOIN oro_website_search_text o5_ ON o0_.id = o5_.item_id AND (o5_.field = ?) LEFT JOIN oro_website_search_text o6_ ON o0_.id = o6_.item_id AND (o6_.field = ?) LEFT JOIN oro_website_search_text o7_ ON o0_.id = o7_.item_id AND (o7_.field = ?) LEFT JOIN oro_website_search_integer o8_ ON o0_.id = o8_.item_id AND (o8_.field = ?) LEFT JOIN oro_website_search_integer o9_ ON o0_.id = o9_.item_id AND (o9_.field = ?) LEFT JOIN oro_website_search_text o10_ ON o0_.id = o10_.item_id AND (o10_.field = ?) LEFT JOIN oro_website_search_decimal o11_ ON o0_.id = o11_.item_id AND (o11_.field = ?) LEFT JOIN oro_website_search_integer o12_ ON o0_.id = o12_.item_id AND (o12_.field = ?) LEFT JOIN oro_website_search_datetime o13_ ON o0_.id = o13_.item_id AND (o13_.field = ?) LEFT JOIN oro_website_search_text o14_ ON o0_.id = o14_.item_id AND (o14_.field = ?) LEFT JOIN oro_website_search_text o15_ ON o0_.id = o15_.item_id AND (o15_.field = ?) LEFT JOIN oro_website_search_text o16_ ON o0_.id = o16_.item_id AND (o16_.field = ?) LEFT JOIN oro_website_search_integer o17_ ON o0_.id = o17_.item_id AND (o17_.field = ?) LEFT JOIN oro_website_search_text o18_ ON o0_.id = o18_.item_id AND (o18_.field = ?) LEFT JOIN oro_website_search_text o19_ ON o0_.id = o19_.item_id AND (o19_.field = ?) LEFT JOIN oro_website_search_integer o20_ ON o0_.id = o20_.item_id AND (o20_.field = ?) LEFT JOIN oro_website_search_integer o21_ ON o0_.id = o21_.item_id AND (o21_.field = ?) WHERE o0_.alias IN ('oro_product_1') AND ((((((o17_.field = ? AND o17_.value IN (?, ?, ?, ?, ?)) AND (o18_.field = ? AND o18_.value IN (?))) AND (o19_.field = ? AND o19_.value IN (?, ?))) AND (o20_.field = ? AND o20_.value = ?)) AND (o21_.field = ? AND o21_.value = ?))) ORDER BY o0_.weight DESC, o0_.record_id DESC NULLS LAST, o0_.id DESC LIMIT 1000
Parameters: [system_entity_id, type, sku, names_1, image_product_large, primary_unit, product_units, newArrival, variant_fields_count, image_product_large_webp, low_inventory_threshold, is_upcoming, availability_date, inv_status, schema_org_description_1, schema_org_brand_name_1, system_entity_id, status, inv_status, is_variant, visibility_anonymous, system_entity_id, 14, 15, 16, 24, 27, status, enabled, inv_status, in_stock, out_of_stock, is_variant, 0, visibility_anonymous, 1]
|
Similar Queries
Queries with different parameters
default connection
| Times called | SQL |
|---|---|
| 5 | 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 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 = ? |
| 3 | SELECT t0.id AS id_1, t0.parent_scope_used AS parent_scope_used_2, t0.rewrite_variant_title AS rewrite_variant_title_3, t0.materialized_path AS materialized_path_4, t0.tree_left AS tree_left_5, t0.tree_level AS tree_level_6, t0.tree_right AS tree_right_7, t0.tree_root AS tree_root_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.serialized_data AS serialized_data_11, t0.parent_id AS parent_id_12, t0.web_catalog_id AS web_catalog_id_13 FROM oro_web_catalog_content_node t0 WHERE t0.id = ? |
| 5 | 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_web_catalog_node_title ON t0.id = oro_web_catalog_node_title.localized_value_id WHERE oro_web_catalog_node_title.node_id = ? |
| 5 | 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_web_catalog_node_url ON t0.id = oro_web_catalog_node_url.localized_value_id WHERE oro_web_catalog_node_url.node_id = ? |
| 6 | 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 = ? |
| 2 | SELECT o0_."condition" AS condition_0, o0_.screens AS screens_1, o0_.system_page_route AS system_page_route_2, o0_.link_target AS link_target_3, o0_.menu_template AS menu_template_4, o0_.max_traverse_level AS max_traverse_level_5, o0_.id AS id_6, o0_."key" AS key_7, o0_.parent_key AS parent_key_8, o0_.uri AS uri_9, o0_.menu AS menu_10, o0_.icon AS icon_11, o0_.is_active AS is_active_12, o0_.priority AS priority_13, o0_.is_divider AS is_divider_14, o0_.is_custom AS is_custom_15, o0_.is_synthetic AS is_synthetic_16, o0_.serialized_data AS serialized_data_17, o0_.content_node_id AS content_node_id_18, o0_.scope_id AS scope_id_19, o0_.category_id AS category_id_20, o0_.image_id AS image_id_21 FROM oro_commerce_menu_upd o0_ WHERE o0_.menu = ? AND o0_.scope_id = ? ORDER BY o0_.id ASC |
| 6 | 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 = ? |
config connection
| Times called | SQL |
|---|---|
| 2 | SELECT o0_.id AS id_0, o0_.field_name AS field_name_1, o0_.type AS type_2, o0_.created AS created_3, o0_.updated AS updated_4, o0_.mode AS mode_5, o0_.data AS data_6, o0_.entity_id AS entity_id_7 FROM oro_entity_config_field o0_ INNER JOIN oro_entity_config_index_value o1_ ON o0_.id = o1_.field_id AND (o1_.scope = ? AND o1_.code = ? AND o1_.value = ?) LEFT JOIN oro_entity_config_index_value o2_ ON o0_.id = o2_.field_id AND (o2_.scope = ? AND o2_.code = ? AND o2_.value = ?) WHERE o2_.scope IS NULL AND o0_.id IN (?) ORDER BY o0_.id ASC |