Query time 0.00188
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "78.76"
},
"nested_loop": [
{
"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": 75,
"rows_produced_per_join": 75,
"filtered": "100.00",
"index_condition": "((`test_uchur_k`.`lang`.`lang_code` = 'kk') and (`test_uchur_k`.`lang`.`name` in ('block_bundles_description','block_condition_table_description','block_featured_brands_description','block_information_columns_description','block_our_advantages_description','block_registration_block_description','block_user_profile_image_description','block_user_profile_infor_description','block_user_profile_links_description','block_wholesale_promo_description','block_abt__ut2_advanced_subcategories_menu_description','block_abt__ut2_contacts_manually_description','block_abt__ut2_lite_checkout_place_order_button_description','block_ab__deal_of_the_day_description','block_ab__fast_navigation_description','block_ab__fast_navigation_categories_description','block_ab__promotion_categories_filter_description','block_abt__ut2_fly_menu_description','block_ab__multi_deal_of_the_day_description','block_abt__ut2_block_opener_description','block_abt__ut2_lite_checkout_promotion_coupon_description','block_ab__promotion_main_data_description','block_ab__promotions_description','block_ab__vg_videos_description','block_availability_in_stores_description','block_our_brands_description','block_breadcrumbs_description','block_call_request_description','block_cart_content_description','block_categories_description','block_checkout_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_currencies_description','block_geo_maps_customer_location_description','block_gdpr_description','block_gift_certificates_verify_description','block_html_block_description','block_smarty_block_description','block_safe_smarty_block_description','block_languages_description','block_main_description','block_menu_description','block_my_account_description','block_pages_description','block_payment_methods_description','block_polls_description','block_product_bundles_description','block_product_filters_description','block_product_filters_home_description','block_products_description','block_rss_feed_description','block_shipping_methods_description','block_store_locator_description','block_tags_description','block_template_description','block_testimonials_description','block_user_loyalty_card_description','block_banners_description','block_vacancies_description','block_folding_list_description','block_uchur_categories_panels_description','block_contacts_description','block_mobile_app_promo_description','block_social_links_description','block_blog_description','block_yandex_search_description')))",
"cost_info": {
"read_cost": "45.01",
"eval_cost": "7.50",
"prefix_cost": "52.51",
"data_read_per_join": "29K"
},
"used_columns": [
"lang_code",
"name",
"value"
]
}
},
{
"table": {
"table_name": "cscart_ult_language_values",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"lang_code",
"name",
"company_id"
],
"key_length": "396",
"ref": [
"test_uchur_k.lang.lang_code",
"test_uchur_k.lang.name",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 75,
"filtered": "100.00",
"cost_info": {
"read_cost": "18.75",
"eval_cost": "7.50",
"prefix_cost": "78.76",
"data_read_per_join": "29K"
},
"used_columns": [
"lang_code",
"name",
"value",
"company_id"
]
}
}
]
}
}
Result
| name |
value |
| block_abt__ut2_block_opener_description |
Opens a block with the wrapper "Onclick-dropdown" or "AB: Onclick-dropdown (external allocation)" |
| block_ab__deal_of_the_day_description |
Preview of the chosen promotion |
| block_ab__fast_navigation_categories_description |
Fast navigation block by subcategories |
| block_ab__fast_navigation_description |
Block with fast navigation |
| block_ab__multi_deal_of_the_day_description |
Display anounce of one of chosen promotions, considering to their priorities |
| block_ab__promotions_description |
Promotions list |
| block_ab__promotion_categories_filter_description |
List of product categories that participate in the promotion |
| block_ab__promotion_main_data_description |
General promotion data (name, image, description etc.) |
| block_ab__vg_videos_description |
Displays video list that are attached to products of selected page |
| block_availability_in_stores_description |
List of stores where the product can be purchased |
| block_banners_description |
Графикалық және мәтіндік Баннерлер |
| block_breadcrumbs_description |
Navigation breadcrumbs |
| block_call_request_description |
Store phone number and form for requesting a call |
| block_cart_content_description |
Current cart content |
| block_categories_description |
Category trees |
| block_checkout_description |
Current order information |
| block_currencies_description |
Currency selector |
| block_gdpr_description |
Allows registered users to request their personal data or anonymization |
| block_geo_maps_customer_location_description |
Customer city and city selection form |
| block_gift_certificates_verify_description |
Gift certificate input and validation |
| block_html_block_description |
Any HTML content |
| block_languages_description |
Language selector |
| block_lite_checkout_customer_address_description |
Profile fields for customer address |
| block_lite_checkout_customer_billing_description |
Profile fields for billing address |
| block_lite_checkout_customer_information_description |
Profile fields for customer information |
| block_lite_checkout_customer_notes_description |
Customer's notes about the order |
| block_lite_checkout_customer_sign_in_description |
Sign-in button |
| block_lite_checkout_location_description |
Customer's city, state, and country |
| block_lite_checkout_newsletters_description |
Ability to sign up for newsletters |
| block_lite_checkout_payment_methods_description |
Payment method selection |
| block_lite_checkout_shipping_methods_description |
Shipping method selection |
| block_lite_checkout_terms_and_conditions_description |
Checkbox for accepting terms and conditions |
| block_main_description |
Main content (loaded by controller) |
| block_my_account_description |
Customer profile access |
| block_our_brands_description |
Product brands presented in the store |
| block_pages_description |
Store pages |
| block_payment_methods_description |
Available payment methods |
| block_products_description |
Product showcase |
| block_product_bundles_description |
Product bundles form |
| block_product_filters_description |
Product filtering options |
| block_product_filters_home_description |
Product filtering options, displayed on home page |
| block_rss_feed_description |
RSS feed subscription icon |
| block_safe_smarty_block_description |
Any HTML/Smarty content |
| block_shipping_methods_description |
Available shipping methods |
| block_smarty_block_description |
Any HTML/Smarty content |
| block_store_locator_description |
Store locator block |
| block_tags_description |
Product tags |
| block_template_description |
Block with a particular template |
| block_testimonials_description |
User testimonials |
| block_yandex_search_description |
Блок с кодом формы Яндекс поиска |