Query Metrics
5
Identical Queries
5
Similar Queries
Identical Queries
Queries with identical parameters
default connection
| Times called | SQL |
|---|---|
| 2 |
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
Parameters: [1]
|
| 2 |
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
Parameters: [3]
|
| 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_.code AS code_0 FROM oro_product_unit o0_ ORDER BY o0_.code ASC
Parameters: { }
|
Similar Queries
Queries with different parameters
default connection
| Times called | SQL |
|---|---|
| 2 | 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 = ? |
| 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 |
| 2 | 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 = ? |
| 13 | 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 = ? |
| 15 | 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 = ? |