Query time 0.00161
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_banners",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"banner_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "6K"
},
"used_columns": [
"banner_id",
"status",
"type",
"target",
"localization",
"timestamp",
"company_id",
"abt__ut2_usergroup_ids",
"abt__ut2_use_avail_period",
"abt__ut2_avail_from",
"abt__ut2_avail_till",
"abt__ut2_button_use",
"abt__ut2_tablet_button_use",
"abt__ut2_tablet_button_use_use_own",
"abt__ut2_mobile_button_use",
"abt__ut2_mobile_button_use_use_own",
"abt__ut2_button_text_color",
"abt__ut2_tablet_button_text_color",
"abt__ut2_tablet_button_text_color_use_own",
"abt__ut2_mobile_button_text_color",
"abt__ut2_mobile_button_text_color_use_own",
"abt__ut2_button_text_color_use",
"abt__ut2_tablet_button_text_color_use",
"abt__ut2_tablet_button_text_color_use_use_own",
"abt__ut2_mobile_button_text_color_use",
"abt__ut2_mobile_button_text_color_use_use_own",
"abt__ut2_button_color",
"abt__ut2_tablet_button_color",
"abt__ut2_tablet_button_color_use_own",
"abt__ut2_mobile_button_color",
"abt__ut2_mobile_button_color_use_own",
"abt__ut2_button_color_use",
"abt__ut2_tablet_button_color_use",
"abt__ut2_tablet_button_color_use_use_own",
"abt__ut2_mobile_button_color_use",
"abt__ut2_mobile_button_color_use_use_own",
"abt__ut2_title_font_size",
"abt__ut2_tablet_title_font_size",
"abt__ut2_tablet_title_font_size_use_own",
"abt__ut2_mobile_title_font_size",
"abt__ut2_mobile_title_font_size_use_own",
"abt__ut2_title_color",
"abt__ut2_title_color_use",
"abt__ut2_title_font_weight",
"abt__ut2_title_tag",
"abt__ut2_background_type",
"abt__ut2_tablet_background_type",
"abt__ut2_tablet_background_type_use_own",
"abt__ut2_mobile_background_type",
"abt__ut2_mobile_background_type_use_own",
"abt__ut2_background_image_size",
"abt__ut2_tablet_background_image_size",
"abt__ut2_tablet_background_image_size_use_own",
"abt__ut2_mobile_background_image_size",
"abt__ut2_mobile_background_image_size_use_own",
"abt__ut2_title_shadow",
"abt__ut2_tablet_title_shadow",
"abt__ut2_tablet_title_shadow_use_own",
"abt__ut2_mobile_title_shadow",
"abt__ut2_mobile_title_shadow_use_own",
"abt__ut2_description_font_size",
"abt__ut2_tablet_description_font_size",
"abt__ut2_tablet_description_font_size_use_own",
"abt__ut2_mobile_description_font_size",
"abt__ut2_mobile_description_font_size_use_own",
"abt__ut2_description_color",
"abt__ut2_description_color_use",
"abt__ut2_description_bg_color",
"abt__ut2_description_bg_color_use",
"abt__ut2_tablet_main_image_use_own",
"abt__ut2_mobile_main_image_use_own",
"abt__ut2_tablet_background_image_use_own",
"abt__ut2_mobile_background_image_use_own",
"abt__ut2_background_mp4_video",
"abt__ut2_tablet_background_mp4_video",
"abt__ut2_tablet_background_mp4_video_use_own",
"abt__ut2_mobile_background_mp4_video",
"abt__ut2_mobile_background_mp4_video_use_own",
"abt__ut2_object",
"abt__ut2_background_color",
"abt__ut2_background_color_use",
"abt__ut2_class",
"abt__ut2_color_scheme",
"abt__ut2_content_valign",
"abt__ut2_tablet_content_valign",
"abt__ut2_tablet_content_valign_use_own",
"abt__ut2_mobile_content_valign",
"abt__ut2_mobile_content_valign_use_own",
"abt__ut2_content_align",
"abt__ut2_tablet_content_align",
"abt__ut2_tablet_content_align_use_own",
"abt__ut2_mobile_content_align",
"abt__ut2_mobile_content_align_use_own",
"abt__ut2_content_full_width",
"abt__ut2_tablet_content_full_width",
"abt__ut2_tablet_content_full_width_use_own",
"abt__ut2_mobile_content_full_width",
"abt__ut2_mobile_content_full_width_use_own",
"abt__ut2_content_bg",
"abt__ut2_tablet_content_bg",
"abt__ut2_tablet_content_bg_use_own",
"abt__ut2_mobile_content_bg",
"abt__ut2_mobile_content_bg_use_own",
"abt__ut2_content_bg_position",
"abt__ut2_tablet_content_bg_position",
"abt__ut2_tablet_content_bg_position_use_own",
"abt__ut2_mobile_content_bg_position",
"abt__ut2_mobile_content_bg_position_use_own",
"abt__ut2_content_bg_opacity",
"abt__ut2_tablet_content_bg_opacity",
"abt__ut2_tablet_content_bg_opacity_use_own",
"abt__ut2_mobile_content_bg_opacity",
"abt__ut2_mobile_content_bg_opacity_use_own",
"abt__ut2_content_bg_color",
"abt__ut2_tablet_content_bg_color",
"abt__ut2_tablet_content_bg_color_use_own",
"abt__ut2_mobile_content_bg_color",
"abt__ut2_mobile_content_bg_color_use_own",
"abt__ut2_content_bg_color_use",
"abt__ut2_tablet_content_bg_color_use",
"abt__ut2_tablet_content_bg_color_use_use_own",
"abt__ut2_mobile_content_bg_color_use",
"abt__ut2_mobile_content_bg_color_use_use_own",
"abt__ut2_padding",
"abt__ut2_tablet_padding",
"abt__ut2_tablet_padding_use_own",
"abt__ut2_mobile_padding",
"abt__ut2_mobile_padding_use_own",
"abt__ut2_how_to_open",
"abt__ut2_data_type",
"abt__ut2_youtube_use",
"abt__ut2_youtube_autoplay",
"abt__ut2_youtube_hide_controls",
"abt__ut2_tablet_use",
"abt__ut2_mobile_use",
"abt__ut2_image_position",
"abt__ut2_tablet_image_position",
"abt__ut2_tablet_image_position_use_own",
"abt__ut2_mobile_image_position",
"abt__ut2_mobile_image_position_use_own",
"abt__ut2_button_style"
]
}
},
{
"table": {
"table_name": "cscart_banner_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"banner_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "5K"
},
"used_columns": [
"banner_id",
"banner",
"url",
"description",
"lang_code",
"abt__ut2_button_text",
"abt__ut2_tablet_button_text",
"abt__ut2_tablet_button_text_use_own",
"abt__ut2_mobile_button_text",
"abt__ut2_mobile_button_text_use_own",
"abt__ut2_title",
"abt__ut2_tablet_title",
"abt__ut2_tablet_title_use_own",
"abt__ut2_mobile_title",
"abt__ut2_mobile_title_use_own",
"abt__ut2_url",
"abt__ut2_description",
"abt__ut2_tablet_description",
"abt__ut2_tablet_description_use_own",
"abt__ut2_mobile_description",
"abt__ut2_mobile_description_use_own",
"abt__ut2_youtube_id"
]
}
},
{
"table": {
"table_name": "cscart_banner_images",
"access_type": "const",
"possible_keys": [
"banner"
],
"key": "banner",
"used_key_parts": [
"banner_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"banner_image_id",
"banner_id",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_abt__ut2_banner_images",
"access_type": "const",
"possible_keys": [
"banner_lang_code"
],
"key": "banner_lang_code",
"used_key_parts": [
"banner_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"abt__ut2_banner_image_id",
"banner_id",
"lang_code"
]
}
}
]
}
}
Result
| banner_id |
status |
banner |
type |
target |
localization |
timestamp |
description |
url |
banner_image_id |
company_id |
abt__ut2_banner_image_id |
abt__ut2_usergroup_ids |
abt__ut2_use_avail_period |
abt__ut2_avail_from |
abt__ut2_avail_till |
abt__ut2_button_use |
abt__ut2_button_style |
abt__ut2_button_text_color |
abt__ut2_button_text_color_use |
abt__ut2_button_color |
abt__ut2_button_color_use |
abt__ut2_title_color |
abt__ut2_title_color_use |
abt__ut2_title_font_size |
abt__ut2_title_font_weight |
abt__ut2_title_tag |
abt__ut2_background_image_size |
abt__ut2_image_position |
abt__ut2_title_shadow |
abt__ut2_description_font_size |
abt__ut2_description_color |
abt__ut2_description_color_use |
abt__ut2_description_bg_color |
abt__ut2_description_bg_color_use |
abt__ut2_object |
abt__ut2_background_color |
abt__ut2_background_color_use |
abt__ut2_class |
abt__ut2_color_scheme |
abt__ut2_content_valign |
abt__ut2_content_align |
abt__ut2_content_full_width |
abt__ut2_content_bg |
abt__ut2_content_bg_position |
abt__ut2_content_bg_opacity |
abt__ut2_content_bg_color |
abt__ut2_content_bg_color_use |
abt__ut2_padding |
abt__ut2_how_to_open |
abt__ut2_data_type |
abt__ut2_youtube_use |
abt__ut2_youtube_autoplay |
abt__ut2_youtube_hide_controls |
abt__ut2_background_type |
abt__ut2_background_mp4_video |
abt__ut2_button_text |
abt__ut2_title |
abt__ut2_url |
abt__ut2_description |
abt__ut2_youtube_id |
abt__ut2_tablet_use |
abt__ut2_tablet_content_valign |
abt__ut2_tablet_content_valign_use_own |
abt__ut2_tablet_content_align |
abt__ut2_tablet_content_align_use_own |
abt__ut2_tablet_padding |
abt__ut2_tablet_padding_use_own |
abt__ut2_tablet_content_full_width |
abt__ut2_tablet_content_full_width_use_own |
abt__ut2_tablet_title |
abt__ut2_tablet_title_use_own |
abt__ut2_tablet_title_font_size |
abt__ut2_tablet_title_font_size_use_own |
abt__ut2_tablet_title_shadow |
abt__ut2_tablet_title_shadow_use_own |
abt__ut2_tablet_description |
abt__ut2_tablet_description_use_own |
abt__ut2_tablet_description_font_size |
abt__ut2_tablet_description_font_size_use_own |
abt__ut2_tablet_main_image_use_own |
abt__ut2_tablet_background_type |
abt__ut2_tablet_background_type_use_own |
abt__ut2_tablet_background_mp4_video |
abt__ut2_tablet_background_mp4_video_use_own |
abt__ut2_tablet_background_image_use_own |
abt__ut2_tablet_background_image_size |
abt__ut2_tablet_background_image_size_use_own |
abt__ut2_tablet_image_position |
abt__ut2_tablet_image_position_use_own |
abt__ut2_tablet_button_use |
abt__ut2_tablet_button_use_use_own |
abt__ut2_tablet_button_text |
abt__ut2_tablet_button_text_use_own |
abt__ut2_tablet_content_bg |
abt__ut2_tablet_content_bg_use_own |
abt__ut2_tablet_content_bg_position |
abt__ut2_tablet_content_bg_position_use_own |
abt__ut2_tablet_content_bg_opacity |
abt__ut2_tablet_content_bg_opacity_use_own |
abt__ut2_tablet_content_bg_color |
abt__ut2_tablet_content_bg_color_use_own |
abt__ut2_tablet_content_bg_color_use |
abt__ut2_tablet_content_bg_color_use_use_own |
abt__ut2_tablet_button_text_color |
abt__ut2_tablet_button_text_color_use_own |
abt__ut2_tablet_button_text_color_use |
abt__ut2_tablet_button_text_color_use_use_own |
abt__ut2_tablet_button_color |
abt__ut2_tablet_button_color_use_own |
abt__ut2_tablet_button_color_use |
abt__ut2_tablet_button_color_use_use_own |
abt__ut2_mobile_use |
abt__ut2_mobile_content_valign |
abt__ut2_mobile_content_valign_use_own |
abt__ut2_mobile_content_align |
abt__ut2_mobile_content_align_use_own |
abt__ut2_mobile_padding |
abt__ut2_mobile_padding_use_own |
abt__ut2_mobile_content_full_width |
abt__ut2_mobile_content_full_width_use_own |
abt__ut2_mobile_title |
abt__ut2_mobile_title_use_own |
abt__ut2_mobile_title_font_size |
abt__ut2_mobile_title_font_size_use_own |
abt__ut2_mobile_title_shadow |
abt__ut2_mobile_title_shadow_use_own |
abt__ut2_mobile_description |
abt__ut2_mobile_description_use_own |
abt__ut2_mobile_description_font_size |
abt__ut2_mobile_description_font_size_use_own |
abt__ut2_mobile_main_image_use_own |
abt__ut2_mobile_background_type |
abt__ut2_mobile_background_type_use_own |
abt__ut2_mobile_background_mp4_video |
abt__ut2_mobile_background_mp4_video_use_own |
abt__ut2_mobile_background_image_use_own |
abt__ut2_mobile_background_image_size |
abt__ut2_mobile_background_image_size_use_own |
abt__ut2_mobile_image_position |
abt__ut2_mobile_image_position_use_own |
abt__ut2_mobile_button_use |
abt__ut2_mobile_button_use_use_own |
abt__ut2_mobile_button_text |
abt__ut2_mobile_button_text_use_own |
abt__ut2_mobile_content_bg |
abt__ut2_mobile_content_bg_use_own |
abt__ut2_mobile_content_bg_position |
abt__ut2_mobile_content_bg_position_use_own |
abt__ut2_mobile_content_bg_opacity |
abt__ut2_mobile_content_bg_opacity_use_own |
abt__ut2_mobile_content_bg_color |
abt__ut2_mobile_content_bg_color_use_own |
abt__ut2_mobile_content_bg_color_use |
abt__ut2_mobile_content_bg_color_use_use_own |
abt__ut2_mobile_button_text_color |
abt__ut2_mobile_button_text_color_use_own |
abt__ut2_mobile_button_text_color_use |
abt__ut2_mobile_button_text_color_use_use_own |
abt__ut2_mobile_button_color |
abt__ut2_mobile_button_color_use_own |
abt__ut2_mobile_button_color_use |
abt__ut2_mobile_button_color_use_use_own |
| 40 |
A |
Баннер в товаре 1 (Демо) (Демо) |
abt__ut2 |
B |
|
1692738000 |
|
|
489 |
1 |
18 |
|
N |
0 |
0 |
N |
normal |
|
N |
|
N |
#000000 |
N |
32px |
700 |
div |
contain |
center |
N |
14px |
#000000 |
Y |
#666666 |
N |
image |
#b7b7b7 |
Y |
|
dark |
center |
left |
N |
none |
only_under_content |
50 |
|
N |
20px |
in_this_window |
url |
N |
Y |
N |
image |
|
Найти Apple |
<span style="text-transform:none">Шкафы<br/><span style="color: #000000">Закажите индивидуальную разработку</span></span> |
/izgotovlenie-ehlektrotekhnicheskih-shkafov-na-zakaz/ |
Заполните форму на индивидуальную разработку шкафа для Вашего проекта |
|
N |
center |
N |
center |
N |
20px 20px 20px 20px |
N |
N |
N |
|
N |
18px |
N |
N |
N |
|
N |
13px |
N |
N |
image |
N |
|
N |
N |
cover |
N |
center |
N |
N |
N |
|
N |
none |
N |
only_under_content |
N |
50 |
N |
|
N |
N |
N |
|
N |
N |
N |
|
N |
N |
N |
Y |
bottom |
Y |
center |
Y |
20px 0 |
Y |
Y |
Y |
|
N |
18px |
Y |
N |
N |
|
Y |
14px |
Y |
N |
image |
N |
|
N |
N |
cover |
N |
center |
N |
N |
N |
|
N |
none |
Y |
only_under_content |
N |
50 |
N |
|
N |
N |
N |
|
N |
N |
N |
|
N |
N |
N |