Query time 0.00281
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "jmj_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": "4K"
},
"used_columns": [
"banner_id",
"status",
"type",
"target",
"localization",
"timestamp",
"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_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_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_usergroup_ids",
"abt__ut2_background_type",
"abt__ut2_tablet_background_type",
"abt__ut2_mobile_background_type",
"abt__ut2_tablet_background_type_use_own",
"abt__ut2_mobile_background_type_use_own",
"abt__ut2_button_style",
"abt__ut2_content_bg_align",
"abt__ut2_tablet_content_bg_align_use_own",
"abt__ut2_mobile_content_bg_align_use_own",
"abt__ut2_tablet_content_bg_align",
"abt__ut2_mobile_content_bg_align",
"abt__ut2_products_template",
"abt__ut2_products_links_thumb_columns",
"abt__ut2_products_links_thumb_rows",
"abt__ut2_products_small_items_columns",
"abt__ut2_products_small_items_rows",
"abt__ut2_products_grid_columns",
"abt__ut2_products_list",
"group_id",
"abt__ut2_image_v_position",
"abt__ut2_tablet_image_v_position",
"abt__ut2_tablet_image_v_position_use_own",
"abt__ut2_mobile_image_v_position",
"abt__ut2_mobile_image_v_position_use_own",
"abt__ut2_image_h_position",
"abt__ut2_tablet_image_h_position",
"abt__ut2_tablet_image_h_position_use_own",
"abt__ut2_mobile_image_h_position",
"abt__ut2_mobile_image_h_position_use_own",
"abt__ut2_background_v_position",
"abt__ut2_tablet_background_v_position",
"abt__ut2_tablet_background_v_position_use_own",
"abt__ut2_mobile_background_v_position",
"abt__ut2_mobile_background_v_position_use_own",
"abt__ut2_background_h_position",
"abt__ut2_tablet_background_h_position",
"abt__ut2_tablet_background_h_position_use_own",
"abt__ut2_mobile_background_h_position",
"abt__ut2_mobile_background_h_position_use_own"
]
}
},
{
"table": {
"table_name": "jmj_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": "7K"
},
"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",
"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"
]
}
},
{
"table": {
"table_name": "jmj_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": "jmj_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 |
group_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_v_position |
abt__ut2_image_h_position |
abt__ut2_background_v_position |
abt__ut2_background_h_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_align |
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_products_template |
abt__ut2_products_links_thumb_columns |
abt__ut2_products_links_thumb_rows |
abt__ut2_products_small_items_columns |
abt__ut2_products_small_items_rows |
abt__ut2_products_grid_columns |
abt__ut2_products_list |
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_v_position |
abt__ut2_tablet_image_v_position_use_own |
abt__ut2_tablet_image_h_position |
abt__ut2_tablet_image_h_position_use_own |
abt__ut2_tablet_background_v_position |
abt__ut2_tablet_background_v_position_use_own |
abt__ut2_tablet_background_h_position |
abt__ut2_tablet_background_h_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_align |
abt__ut2_tablet_content_bg_align_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_v_position |
abt__ut2_mobile_image_v_position_use_own |
abt__ut2_mobile_image_h_position |
abt__ut2_mobile_image_h_position_use_own |
abt__ut2_mobile_background_v_position |
abt__ut2_mobile_background_v_position_use_own |
abt__ut2_mobile_background_h_position |
abt__ut2_mobile_background_h_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_align |
abt__ut2_mobile_content_bg_align_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 |
| 27 |
A |
MAIN-3 |
abt__ut2 |
B |
|
1624386600 |
|
|
260 |
0 |
3 |
0 |
N |
0 |
0 |
N |
normal |
|
N |
|
N |
#ffffff |
Y |
36px |
900 |
div |
contain |
center |
center |
center |
center |
N |
20px |
#ffffff |
Y |
|
N |
image |
|
N |
banner-main-3 |
dark |
center |
left |
N |
none |
only_under_content |
auto |
10 |
|
N |
30px 0 30px 2.5% |
in_this_window |
url |
N |
N |
N |
image |
|
|
XPLORE 3 DECADES<br>OF <span>TURST</span></br> |
|
<br>
<b>Xplore is built on the legacy of a brand with </b><br>
<b>presence in 15 cities, 15000+ vendors and 2000+ </b><br>
<b>customers to enable businesses gain a </b><br>
<b>competitive edge.</b> |
|
|
0 |
0 |
0 |
0 |
0 |
|
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 |
center |
N |
center |
N |
center |
N |
N |
N |
|
N |
none |
N |
only_under_content |
N |
auto |
N |
10 |
N |
|
N |
N |
N |
|
N |
N |
N |
|
N |
N |
N |
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 |
center |
N |
center |
N |
center |
N |
N |
N |
|
N |
none |
N |
only_under_content |
N |
auto |
N |
10 |
N |
|
N |
N |
N |
|
N |
N |
N |
|
N |
N |
N |