Query time 0.00112
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "133.28"
},
"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": 76,
"rows_produced_per_join": 68,
"filtered": "90.00",
"index_condition": "(`webmarco`.`cscart_settings_objects`.`section_id` <=> 641)",
"cost_info": {
"read_cost": "36.00",
"eval_cost": "13.68",
"prefix_cost": "51.20",
"data_read_per_join": "53K"
},
"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": 68,
"filtered": "100.00",
"cost_info": {
"read_cost": "68.40",
"eval_cost": "13.68",
"prefix_cost": "133.28",
"data_read_per_join": "1K"
},
"used_columns": [
"object_id",
"company_id",
"value",
"storefront_id"
]
}
}
]
}
}
}
Result
object_id |
name |
section_id |
section_tab_id |
type |
position |
is_global |
description |
value |
8202 |
search_by_phone_num |
641 |
644 |
C |
0 |
N |
search_by_phone_num |
Y |
8205 |
search_categories |
641 |
645 |
C |
0 |
N |
search_categories |
N |
8209 |
out_stock_end |
641 |
646 |
C |
0 |
N |
out_stock_end |
Y |
8216 |
show_price |
641 |
648 |
S |
0 |
N |
show_price |
Y |
8221 |
image_width |
641 |
649 |
I |
0 |
N |
image_width |
75 |
8186 |
search_on_name |
641 |
643 |
C |
0 |
N |
search_on_name |
Y |
8203 |
search_by_vat_num |
641 |
644 |
C |
10 |
N |
search_by_vat_num |
Y |
8206 |
show_parent_category |
641 |
645 |
C |
10 |
N |
show_parent_category |
N |
8210 |
increase_popularity |
641 |
646 |
C |
10 |
N |
increase_popularity |
Y |
8214 |
search_storefront_categories |
641 |
647 |
C |
10 |
N |
search_storefront_categories |
N |
8217 |
show_cart |
641 |
648 |
S |
10 |
N |
show_cart |
Y |
8222 |
image_height |
641 |
649 |
I |
10 |
N |
image_height |
75 |
8178 |
search_products |
641 |
642 |
C |
10 |
N |
search_products |
Y |
8187 |
search_on_keywords |
641 |
643 |
C |
10 |
N |
search_on_keywords |
Y |
8204 |
search_by_url |
641 |
644 |
C |
20 |
N |
search_by_url |
Y |
8207 |
search_on_category_name |
641 |
645 |
C |
20 |
N |
search_on_category_name |
N |
8211 |
sort_by |
641 |
646 |
S |
20 |
N |
sort_by |
cls_relevance_with_popularity |
8215 |
allow_storefronts |
641 |
647 |
N |
20 |
N |
allow_storefronts |
N |
8218 |
show_product_code |
641 |
648 |
C |
20 |
N |
show_product_code |
Y |
8223 |
show_category_gradient |
641 |
649 |
C |
20 |
N |
show_category_gradient |
N |
8179 |
search_brands |
641 |
642 |
C |
20 |
N |
search_brands |
Y |
8188 |
search_on_metakeywords |
641 |
643 |
C |
20 |
N |
search_on_metakeywords |
N |
8208 |
search_on_category_metakeywords |
641 |
645 |
C |
30 |
N |
search_on_category_metakeywords |
N |
8212 |
sort_order |
641 |
646 |
S |
30 |
N |
sort_order |
desc |
8219 |
show_wish |
641 |
648 |
C |
30 |
N |
show_wish |
Y |
8224 |
color_type |
641 |
649 |
S |
30 |
N |
color_type |
M |
8180 |
brands_feature_id |
641 |
642 |
S |
30 |
N |
brands_feature_id |
1012 |
8189 |
search_on_metatitle |
641 |
643 |
C |
30 |
N |
search_on_metatitle |
N |
8220 |
show_category |
641 |
648 |
C |
40 |
N |
show_category |
Y |
8225 |
clr_category_e |
641 |
649 |
I |
40 |
N |
clr_category_e |
#DB4437 |
8181 |
search_vendors |
641 |
642 |
C |
40 |
N |
search_vendors |
Y |
8190 |
search_on_metadesc |
641 |
643 |
C |
40 |
N |
search_on_metadesc |
N |
8226 |
min_width |
641 |
649 |
I |
50 |
N |
min_width |
400 |
8182 |
search_blog |
641 |
642 |
C |
50 |
N |
search_blog |
N |
8191 |
search_on_pcode |
641 |
643 |
C |
50 |
N |
search_on_pcode |
Y |
8192 |
search_on_description |
641 |
643 |
C |
60 |
N |
search_on_description |
N |
8227 |
margin |
641 |
649 |
I |
60 |
N |
margin |
48 |
8183 |
search_pages |
641 |
642 |
C |
60 |
N |
search_pages |
N |
8193 |
search_on_short_description |
641 |
643 |
C |
70 |
N |
search_on_short_description |
Y |
8228 |
border_radius |
641 |
649 |
I |
70 |
N |
border_radius |
5 |
8194 |
search_on_product_id |
641 |
643 |
C |
80 |
N |
search_on_product_id |
Y |
8229 |
clr_border |
641 |
649 |
I |
80 |
N |
clr_border |
#A5ACB2 |
8185 |
block_enter_press |
641 |
642 |
C |
80 |
N |
block_enter_press |
N |
8195 |
search_on_features |
641 |
643 |
C |
90 |
N |
search_on_features |
N |
8230 |
clr_top_bg |
641 |
649 |
I |
90 |
N |
clr_top_bg |
#FAFAFA |
8196 |
search_by_features |
641 |
643 |
M |
100 |
N |
search_by_features |
|
8231 |
clr_hover |
641 |
649 |
I |
100 |
N |
clr_hover |
#F3F3F3 |
8197 |
search_on_options |
641 |
643 |
C |
110 |
N |
search_on_options |
N |
8232 |
clr_links |
641 |
649 |
I |
110 |
N |
clr_links |
#334553 |
8198 |
use_stop_words |
641 |
643 |
C |
120 |
N |
use_stop_words |
Y |
8233 |
clr_links_hover |
641 |
649 |
I |
120 |
N |
clr_links_hover |
#678ca9 |
8199 |
limit |
641 |
643 |
I |
130 |
N |
limit |
7 |
8200 |
characters_limit |
641 |
643 |
I |
140 |
N |
characters_limit |
3 |
8235 |
btn_atc_radius |
641 |
649 |
I |
140 |
N |
btn_atc_radius |
2 |
8201 |
autoredirect |
641 |
643 |
C |
150 |
N |
autoredirect |
N |
8236 |
clr_btn_atc_border |
641 |
649 |
I |
150 |
N |
clr_btn_atc_border |
#36a0fb |
8237 |
clr_btn_atc_border_hover |
641 |
649 |
I |
160 |
N |
clr_btn_atc_border_hover |
#a5acb2 |
8238 |
clr_btn_atc_text |
641 |
649 |
I |
170 |
N |
clr_btn_atc_text |
#fff |
8239 |
clr_btn_atc_text_hover |
641 |
649 |
I |
180 |
N |
clr_btn_atc_text_hover |
#334553 |
8240 |
clr_btn_atc_bg |
641 |
649 |
I |
190 |
N |
clr_btn_atc_bg |
#36a0fb |
8241 |
clr_btn_atc_bg_hover |
641 |
649 |
I |
200 |
N |
clr_btn_atc_bg_hover |
#fff |
8243 |
clr_btn_atw_text |
641 |
649 |
I |
220 |
N |
clr_btn_atw_text |
#e31b23 |
8244 |
clr_btn_atw_text_hover |
641 |
649 |
I |
230 |
N |
clr_btn_atw_text_hover |
#98002e |
8246 |
btn_radius |
641 |
649 |
I |
250 |
N |
btn_radius |
2 |
8247 |
clr_btn_border |
641 |
649 |
I |
260 |
N |
clr_btn_border |
#a5acb2 |
8248 |
clr_btn_border_hover |
641 |
649 |
I |
270 |
N |
clr_btn_border_hover |
#a5acb2 |
8249 |
clr_btn_text |
641 |
649 |
I |
280 |
N |
clr_btn_text |
#fff |
8250 |
clr_btn_text_hover |
641 |
649 |
I |
290 |
N |
clr_btn_text_hover |
#334553 |
8251 |
clr_btn_bg |
641 |
649 |
I |
300 |
N |
clr_btn_bg |
#a5acb2 |
8252 |
clr_btn_bg_hover |
641 |
649 |
I |
310 |
N |
clr_btn_bg_hover |
#fff |