Query time 0.00355
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"ordering_operation": {
"using_filesort": false,
"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": "2K"
},
"used_columns": [
"banner_id",
"status",
"type",
"target",
"timestamp",
"abt__ut2_use_avail_period",
"abt__ut2_avail_from",
"abt__ut2_avail_till"
]
}
},
{
"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",
"et_text",
"et_settings"
]
}
},
{
"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",
"using_index": true,
"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"
]
}
}
]
}
}
}
Result
banner_id |
type |
target |
status |
timestamp |
banner |
description |
url |
banner_image_id |
et_text |
et_settings |
2015 |
E |
T |
A |
1634853600 |
grid2skerd |
|
|
254681 |
a:3:{s:7:"desktop";a:5:{s:9:"image_url";s:0:"";s:5:"title";s:32:"Evidence of professional ability";s:4:"text";s:12:"- CAP
- DAP";s:8:"btn_text";s:0:"";s:7:"btn_url";s:0:"";}s:5:"phone";a:5:{s:9:"image_url";s:0:"";s:5:"title";s:32:"Evidence of professional ability";s:4:"text";s:12:"- CAP
- DAP";s:8:"btn_text";s:0:"";s:7:"btn_url";s:0:"";}s:6:"tablet";a:5:{s:9:"image_url";s:0:"";s:5:"title";s:32:"Evidence of professional ability";s:4:"text";s:12:"- CAP
- DAP";s:8:"btn_text";s:0:"";s:7:"btn_url";s:0:"";}} |
a:3:{s:7:"desktop";a:70:{s:3:"bkg";s:7:"#ffffff";s:9:"image_pos";s:1:"H";s:10:"image_pos2";s:1:"L";s:10:"image_pos3";s:1:"A";s:10:"image_pos4";s:1:"T";s:10:"image_vert";s:1:"T";s:11:"image_horiz";s:1:"L";s:12:"image_margin";s:15:"0px 0px 0px 0px";s:10:"image_anim";s:1:"A";s:12:"title_shadow";s:1:"N";s:8:"title_lh";s:6:"normal";s:10:"title_size";s:2:"35";s:12:"title_weight";s:1:"B";s:11:"title_style";s:1:"N";s:11:"title_color";s:7:"#000000";s:17:"title_bkg_enabled";s:1:"N";s:15:"title_bkg_color";s:7:"#000000";s:17:"title_bkg_opacity";s:3:"100";s:19:"title_inner_padding";s:15:"0px 0px 0px 0px";s:15:"title_bkg_round";s:1:"0";s:13:"title_padding";s:15:"0px 0px 0px 0px";s:11:"title_align";s:1:"C";s:10:"title_anim";s:1:"A";s:11:"text_shadow";s:1:"N";s:7:"text_lh";s:6:"normal";s:9:"text_size";s:2:"30";s:11:"text_weight";s:1:"N";s:10:"text_style";s:1:"N";s:10:"text_color";s:7:"#000000";s:17:"descr_bkg_enabled";s:1:"N";s:15:"descr_bkg_color";s:7:"#000000";s:17:"descr_bkg_opacity";s:3:"100";s:18:"text_inner_padding";s:15:"0px 0px 0px 0px";s:15:"descr_bkg_round";s:1:"0";s:12:"text_padding";s:15:"0px 0px 0px 0px";s:11:"descr_align";s:1:"C";s:10:"descr_anim";s:1:"A";s:10:"btn_shadow";s:1:"N";s:8:"btn_size";s:2:"18";s:10:"btn_weight";s:1:"N";s:9:"btn_style";s:1:"N";s:9:"btn_round";s:1:"0";s:14:"btn_text_color";s:7:"#ffffff";s:15:"btn_bkg_enabled";s:1:"N";s:13:"btn_bkg_color";s:7:"#000000";s:15:"btn_bkg_opacity";s:3:"100";s:20:"btn_text_color_hover";s:7:"#000000";s:21:"btn_hover_bkg_enabled";s:1:"N";s:19:"btn_bkg_color_hover";s:7:"#000000";s:21:"btn_bkg_opacity_hover";s:3:"100";s:17:"btn_border_enable";s:1:"N";s:15:"btn_border_size";s:1:"1";s:16:"btn_border_style";s:1:"S";s:16:"btn_border_color";s:7:"#ffffff";s:18:"btn_border_opacity";s:3:"100";s:22:"btn_hover_border_color";s:7:"#ffffff";s:24:"btn_hover_border_opacity";s:3:"100";s:11:"btn_padding";s:15:"6px 7px 6px 7px";s:9:"btn_horiz";s:1:"L";s:10:"btn_margin";s:15:"0px 0px 0px 0px";s:8:"btn_anim";s:1:"A";s:13:"wrapper_width";s:4:"auto";s:4:"vert";s:1:"C";s:5:"horiz";s:1:"C";s:14:"wrapper_margin";s:15:"0px 0px 0px 0px";s:19:"wrapper_bkg_enabled";s:1:"Y";s:17:"wrapper_bkg_color";s:7:"#ffffff";s:19:"wrapper_bkg_opacity";s:2:"70";s:15:"wrapper_padding";s:15:"5px 5px 5px 5px";s:13:"wrapper_round";s:4:"40px";}s:5:"phone";a:73:{s:7:"enabled";s:1:"N";s:3:"bkg";s:7:"#ffffff";s:6:"target";s:1:"T";s:3:"url";s:0:"";s:9:"image_pos";s:1:"H";s:10:"image_pos2";s:1:"L";s:10:"image_pos3";s:1:"A";s:10:"image_pos4";s:1:"T";s:10:"image_vert";s:1:"T";s:11:"image_horiz";s:1:"L";s:12:"image_margin";s:15:"0px 0px 0px 0px";s:10:"image_anim";s:1:"A";s:12:"title_shadow";s:1:"N";s:8:"title_lh";s:6:"normal";s:10:"title_size";s:2:"35";s:12:"title_weight";s:1:"B";s:11:"title_style";s:1:"N";s:11:"title_color";s:7:"#000000";s:17:"title_bkg_enabled";s:1:"N";s:15:"title_bkg_color";s:7:"#000000";s:17:"title_bkg_opacity";s:3:"100";s:19:"title_inner_padding";s:15:"0px 0px 0px 0px";s:15:"title_bkg_round";s:1:"0";s:13:"title_padding";s:15:"0px 0px 0px 0px";s:11:"title_align";s:1:"C";s:10:"title_anim";s:1:"A";s:11:"text_shadow";s:1:"N";s:7:"text_lh";s:6:"normal";s:9:"text_size";s:2:"30";s:11:"text_weight";s:1:"N";s:10:"text_style";s:1:"N";s:10:"text_color";s:7:"#000000";s:17:"descr_bkg_enabled";s:1:"N";s:15:"descr_bkg_color";s:7:"#000000";s:17:"descr_bkg_opacity";s:3:"100";s:18:"text_inner_padding";s:15:"0px 0px 0px 0px";s:15:"descr_bkg_round";s:1:"0";s:12:"text_padding";s:15:"0px 0px 0px 0px";s:11:"descr_align";s:1:"C";s:10:"descr_anim";s:1:"A";s:10:"btn_shadow";s:1:"N";s:8:"btn_size";s:2:"18";s:10:"btn_weight";s:1:"N";s:9:"btn_style";s:1:"N";s:9:"btn_round";s:1:"0";s:14:"btn_text_color";s:7:"#ffffff";s:15:"btn_bkg_enabled";s:1:"N";s:13:"btn_bkg_color";s:7:"#000000";s:15:"btn_bkg_opacity";s:3:"100";s:20:"btn_text_color_hover";s:7:"#000000";s:21:"btn_hover_bkg_enabled";s:1:"N";s:19:"btn_bkg_color_hover";s:7:"#000000";s:21:"btn_bkg_opacity_hover";s:3:"100";s:17:"btn_border_enable";s:1:"N";s:15:"btn_border_size";s:1:"1";s:16:"btn_border_style";s:1:"S";s:16:"btn_border_color";s:7:"#ffffff";s:18:"btn_border_opacity";s:3:"100";s:22:"btn_hover_border_color";s:7:"#ffffff";s:24:"btn_hover_border_opacity";s:3:"100";s:11:"btn_padding";s:15:"6px 7px 6px 7px";s:9:"btn_horiz";s:1:"L";s:10:"btn_margin";s:15:"0px 0px 0px 0px";s:8:"btn_anim";s:1:"A";s:13:"wrapper_width";s:4:"auto";s:4:"vert";s:1:"C";s:5:"horiz";s:1:"C";s:14:"wrapper_margin";s:15:"0px 0px 0px 0px";s:19:"wrapper_bkg_enabled";s:1:"Y";s:17:"wrapper_bkg_color";s:7:"#ffffff";s:19:"wrapper_bkg_opacity";s:2:"70";s:15:"wrapper_padding";s:15:"5px 5px 5px 5px";s:13:"wrapper_round";s:4:"40px";}s:6:"tablet";a:73:{s:7:"enabled";s:1:"N";s:3:"bkg";s:7:"#ffffff";s:6:"target";s:1:"T";s:3:"url";s:0:"";s:9:"image_pos";s:1:"H";s:10:"image_pos2";s:1:"L";s:10:"image_pos3";s:1:"A";s:10:"image_pos4";s:1:"T";s:10:"image_vert";s:1:"T";s:11:"image_horiz";s:1:"L";s:12:"image_margin";s:15:"0px 0px 0px 0px";s:10:"image_anim";s:1:"A";s:12:"title_shadow";s:1:"N";s:8:"title_lh";s:6:"normal";s:10:"title_size";s:2:"35";s:12:"title_weight";s:1:"B";s:11:"title_style";s:1:"N";s:11:"title_color";s:7:"#000000";s:17:"title_bkg_enabled";s:1:"N";s:15:"title_bkg_color";s:7:"#000000";s:17:"title_bkg_opacity";s:3:"100";s:19:"title_inner_padding";s:15:"0px 0px 0px 0px";s:15:"title_bkg_round";s:1:"0";s:13:"title_padding";s:15:"0px 0px 0px 0px";s:11:"title_align";s:1:"C";s:10:"title_anim";s:1:"A";s:11:"text_shadow";s:1:"N";s:7:"text_lh";s:6:"normal";s:9:"text_size";s:2:"30";s:11:"text_weight";s:1:"N";s:10:"text_style";s:1:"N";s:10:"text_color";s:7:"#000000";s:17:"descr_bkg_enabled";s:1:"N";s:15:"descr_bkg_color";s:7:"#000000";s:17:"descr_bkg_opacity";s:3:"100";s:18:"text_inner_padding";s:15:"0px 0px 0px 0px";s:15:"descr_bkg_round";s:1:"0";s:12:"text_padding";s:15:"0px 0px 0px 0px";s:11:"descr_align";s:1:"C";s:10:"descr_anim";s:1:"A";s:10:"btn_shadow";s:1:"N";s:8:"btn_size";s:2:"18";s:10:"btn_weight";s:1:"N";s:9:"btn_style";s:1:"N";s:9:"btn_round";s:1:"0";s:14:"btn_text_color";s:7:"#ffffff";s:15:"btn_bkg_enabled";s:1:"N";s:13:"btn_bkg_color";s:7:"#000000";s:15:"btn_bkg_opacity";s:3:"100";s:20:"btn_text_color_hover";s:7:"#000000";s:21:"btn_hover_bkg_enabled";s:1:"N";s:19:"btn_bkg_color_hover";s:7:"#000000";s:21:"btn_bkg_opacity_hover";s:3:"100";s:17:"btn_border_enable";s:1:"N";s:15:"btn_border_size";s:1:"1";s:16:"btn_border_style";s:1:"S";s:16:"btn_border_color";s:7:"#ffffff";s:18:"btn_border_opacity";s:3:"100";s:22:"btn_hover_border_color";s:7:"#ffffff";s:24:"btn_hover_border_opacity";s:3:"100";s:11:"btn_padding";s:15:"6px 7px 6px 7px";s:9:"btn_horiz";s:1:"L";s:10:"btn_margin";s:15:"0px 0px 0px 0px";s:8:"btn_anim";s:1:"A";s:13:"wrapper_width";s:4:"auto";s:4:"vert";s:1:"C";s:5:"horiz";s:1:"C";s:14:"wrapper_margin";s:15:"0px 0px 0px 0px";s:19:"wrapper_bkg_enabled";s:1:"Y";s:17:"wrapper_bkg_color";s:7:"#ffffff";s:19:"wrapper_bkg_opacity";s:2:"70";s:15:"wrapper_padding";s:15:"5px 5px 5px 5px";s:13:"wrapper_round";s:4:"40px";}} |