Query time 0.00112
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "93.60"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_settings_objects",
"access_type": "ref",
"possible_keys": [
"section_id"
],
"key": "section_id",
"used_key_parts": [
"section_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 45,
"rows_produced_per_join": 40,
"filtered": "90.00",
"index_condition": "(`webmarco`.`cscart_settings_objects`.`section_id` <=> 558)",
"cost_info": {
"read_cost": "36.00",
"eval_cost": "8.10",
"prefix_cost": "45.00",
"data_read_per_join": "31K"
},
"used_columns": [
"object_id",
"edition_type",
"name",
"section_id",
"section_tab_id",
"type",
"value",
"position",
"is_global"
],
"attached_condition": "((find_in_set('STOREFRONT',`webmarco`.`cscart_settings_objects`.`edition_type`) or find_in_set('ROOT',`webmarco`.`cscart_settings_objects`.`edition_type`) or find_in_set('MVE:STOREFRONT',`webmarco`.`cscart_settings_objects`.`edition_type`) or find_in_set('MVE:ROOT',`webmarco`.`cscart_settings_objects`.`edition_type`)) and (`webmarco`.`cscart_settings_objects`.`type` <> 'H'))"
}
},
{
"table": {
"table_name": "storefront_values",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"storefront_id",
"company_id"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"company_id",
"storefront_id"
],
"key_length": "11",
"ref": [
"webmarco.cscart_settings_objects.object_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 40,
"filtered": "100.00",
"cost_info": {
"read_cost": "40.50",
"eval_cost": "8.10",
"prefix_cost": "93.60",
"data_read_per_join": "971"
},
"used_columns": [
"object_id",
"company_id",
"value",
"storefront_id"
]
}
}
]
}
}
}
Result
object_id |
name |
section_id |
section_tab_id |
type |
position |
is_global |
description |
value |
7682 |
licensekey |
558 |
559 |
I |
0 |
N |
licensekey |
|
7687 |
cp_blog_power_color_scheme_settings |
558 |
560 |
E |
0 |
N |
cp_blog_power_color_scheme_settings |
color_scheme.tpl |
7689 |
list_display_views |
558 |
561 |
C |
0 |
N |
list_display_views |
N |
7697 |
post_display_views |
558 |
562 |
C |
0 |
N |
post_display_views |
N |
7710 |
mail_lists |
558 |
563 |
S |
0 |
N |
mail_lists |
0 |
7715 |
google_xml_notice |
558 |
564 |
E |
0 |
N |
google_xml_notice |
google_xml_notice.tpl |
7724 |
generate_blog_category_meta |
558 |
565 |
C |
0 |
N |
generate_blog_category_meta |
N |
7683 |
post_use_image |
558 |
559 |
C |
10 |
N |
post_use_image |
Y |
7688 |
blog_colors |
558 |
560 |
D |
10 |
N |
blog_colors |
a:13:{s:12:"header_color";s:7:"#272727";s:10:"link_color";s:7:"#666666";s:12:"button_color";s:7:"#38761d";s:17:"button_text_color";s:7:"#ffffff";s:10:"date_color";s:7:"#38761d";s:15:"date_text_color";s:7:"#ffffff";s:20:"content_header_color";s:7:"#272727";s:18:"content_text_color";s:7:"#434343";s:18:"content_link_color";s:7:"#1c4587";s:19:"blocks_header_color";s:7:"#272727";s:17:"blocks_text_color";s:7:"#434343";s:17:"blocks_link_color";s:7:"#1c4587";s:19:"blocks_border_color";s:7:"#d9d9d9";} |
7690 |
list_display_date |
558 |
561 |
C |
10 |
N |
list_display_date |
Y |
7698 |
post_show_image |
558 |
562 |
C |
10 |
N |
post_show_image |
N |
7725 |
generate_blog_article_meta |
558 |
565 |
C |
10 |
N |
generate_blog_article_meta |
N |
7684 |
blog_date_format |
558 |
559 |
S |
20 |
N |
blog_date_format |
%b %e, %Y |
7691 |
list_display_comments |
558 |
561 |
C |
20 |
N |
list_display_comments |
Y |
7699 |
post_image_position |
558 |
562 |
S |
20 |
N |
post_image_position |
top |
7711 |
marketing_info |
558 |
563 |
O |
20 |
N |
marketing_info |
|
7717 |
include_posts |
558 |
564 |
C |
20 |
N |
include_posts |
Y |
7726 |
add_to_sitemap |
558 |
565 |
S |
20 |
N |
add_to_sitemap |
none |
7685 |
posts_per_page |
558 |
559 |
I |
30 |
N |
posts_per_page |
12 |
7692 |
list_display_author |
558 |
561 |
C |
30 |
N |
list_display_author |
Y |
7700 |
post_image_width |
558 |
562 |
I |
30 |
N |
post_image_width |
300 |
7712 |
notices_list |
558 |
563 |
S |
30 |
N |
notices_list |
0 |
7718 |
posts_change |
558 |
564 |
S |
30 |
N |
posts_change |
daily |
7686 |
brand_feature_id |
558 |
559 |
I |
40 |
N |
brand_feature_id |
|
7693 |
list_display_type |
558 |
561 |
C |
40 |
N |
list_display_type |
Y |
7701 |
post_image_height |
558 |
562 |
I |
40 |
N |
post_image_height |
|
7713 |
send_article_delay |
558 |
563 |
I |
40 |
N |
send_article_delay |
12 |
7719 |
posts_priority |
558 |
564 |
S |
40 |
N |
posts_priority |
0.5 |
7694 |
list_show_tags |
558 |
561 |
C |
50 |
N |
list_show_tags |
Y |
7702 |
post_display_author |
558 |
562 |
C |
50 |
N |
post_display_author |
Y |
7714 |
send_articles |
558 |
563 |
I |
50 |
N |
send_articles |
1 |
7695 |
list_display_short_description |
558 |
561 |
C |
60 |
N |
list_display_short_description |
Y |
7703 |
post_display_categories |
558 |
562 |
C |
60 |
N |
post_display_categories |
Y |
7721 |
include_blog_categories |
558 |
564 |
C |
60 |
N |
include_blog_categories |
Y |
7696 |
list_display_view_more |
558 |
561 |
C |
70 |
N |
list_display_view_more |
Y |
7704 |
post_display_type |
558 |
562 |
C |
70 |
N |
post_display_type |
Y |
7722 |
blog_categories_change |
558 |
564 |
S |
70 |
N |
blog_categories_change |
daily |
7723 |
blog_categories_priority |
558 |
564 |
S |
80 |
N |
blog_categories_priority |
0.5 |
7706 |
gallery_image_width |
558 |
562 |
I |
90 |
N |
gallery_image_width |
895 |
7707 |
gallery_image_height |
558 |
562 |
I |
100 |
N |
gallery_image_height |
|
7708 |
gallery_type |
558 |
562 |
S |
110 |
N |
gallery_type |
scroller |
7709 |
gallery_columns |
558 |
562 |
I |
120 |
N |
gallery_columns |
3 |