SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'de' 
  AND lang.name IN (
    'block_abt__ut2_advanced_subcategories_menu_description', 
    'block_abt__ut2_contacts_manually_description', 
    'block_abt__ut2_lite_checkout_place_order_button_description', 
    'block_abt__ut2_fly_menu_description', 
    'block_abt__ut2_block_opener_description', 
    'block_abt__ut2_lite_checkout_promotion_coupon_description', 
    'block_banners_description', 'block_blog_plus_description', 
    'block_blog_search_description', 
    'block_breadcrumbs_description', 
    'block_lite_checkout_customer_address_description', 
    'block_lite_checkout_customer_billing_description', 
    'block_lite_checkout_customer_information_description', 
    'block_lite_checkout_location_description', 
    'block_lite_checkout_newsletters_description', 
    'block_lite_checkout_customer_notes_description', 
    'block_lite_checkout_payment_methods_description', 
    'block_lite_checkout_shipping_methods_description', 
    'block_lite_checkout_customer_sign_in_description', 
    'block_lite_checkout_terms_and_conditions_description', 
    'block_geo_maps_customer_location_description', 
    'block_testimonials_description', 
    'block_gift_certificates_verify_description', 
    'block_main_description', 'block_html_block_description', 
    'block_smarty_block_description', 
    'block_safe_smarty_block_description', 
    'block_checkout_description', 'block_categories_description', 
    'block_blog_description', 'block_our_brands_description', 
    'block_my_account_description', 
    'block_menu_description', 'block_product_filters_description', 
    'block_products_description', 'block_product_filters_home_description', 
    'block_rss_feed_description', 'block_tags_description', 
    'block_pages_description', 'block_languages_description', 
    'block_store_locator_description', 
    'block_template_description', 'block_shipping_methods_description', 
    'block_cart_content_description', 
    'block_currencies_description', 
    'block_payment_methods_description'
  )

Query time 0.00108

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "32.21"
    },
    "table": {
      "table_name": "lang",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "lang_code",
        "name"
      ],
      "key_length": "392",
      "rows_examined_per_scan": 46,
      "rows_produced_per_join": 46,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`lang`.`lang_code` = 'de') and (`dbggbern`.`lang`.`name` in ('block_abt__ut2_advanced_subcategories_menu_description','block_abt__ut2_contacts_manually_description','block_abt__ut2_lite_checkout_place_order_button_description','block_abt__ut2_fly_menu_description','block_abt__ut2_block_opener_description','block_abt__ut2_lite_checkout_promotion_coupon_description','block_banners_description','block_blog_plus_description','block_blog_search_description','block_breadcrumbs_description','block_lite_checkout_customer_address_description','block_lite_checkout_customer_billing_description','block_lite_checkout_customer_information_description','block_lite_checkout_location_description','block_lite_checkout_newsletters_description','block_lite_checkout_customer_notes_description','block_lite_checkout_payment_methods_description','block_lite_checkout_shipping_methods_description','block_lite_checkout_customer_sign_in_description','block_lite_checkout_terms_and_conditions_description','block_geo_maps_customer_location_description','block_testimonials_description','block_gift_certificates_verify_description','block_main_description','block_html_block_description','block_smarty_block_description','block_safe_smarty_block_description','block_checkout_description','block_categories_description','block_blog_description','block_our_brands_description','block_my_account_description','block_menu_description','block_product_filters_description','block_products_description','block_product_filters_home_description','block_rss_feed_description','block_tags_description','block_pages_description','block_languages_description','block_store_locator_description','block_template_description','block_shipping_methods_description','block_cart_content_description','block_currencies_description','block_payment_methods_description')))",
      "cost_info": {
        "read_cost": "27.61",
        "eval_cost": "4.60",
        "prefix_cost": "32.21",
        "data_read_per_join": "18K"
      },
      "used_columns": [
        "lang_code",
        "name",
        "value"
      ]
    }
  }
}