Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.60"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "company_values",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"storefront_id",
"company_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "24"
},
"used_columns": [
"object_id",
"company_id",
"value",
"storefront_id"
]
}
},
{
"table": {
"table_name": "storefront_values",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"storefront_id",
"company_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "24"
},
"used_columns": [
"object_id",
"company_id",
"value",
"storefront_id"
]
}
},
{
"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": 58,
"rows_produced_per_join": 52,
"filtered": "90.00",
"index_condition": "(`eshopuga_upgr_4122`.`cscart_settings_objects`.`section_id` <=> 202)",
"cost_info": {
"read_cost": "33.00",
"eval_cost": "10.44",
"prefix_cost": "44.60",
"data_read_per_join": "41K"
},
"used_columns": [
"object_id",
"edition_type",
"name",
"section_id",
"section_tab_id",
"type",
"value",
"position",
"is_global"
],
"attached_condition": "((find_in_set('STOREFRONT',`eshopuga_upgr_4122`.`cscart_settings_objects`.`edition_type`) or find_in_set('VENDOR',`eshopuga_upgr_4122`.`cscart_settings_objects`.`edition_type`) or find_in_set('ROOT',`eshopuga_upgr_4122`.`cscart_settings_objects`.`edition_type`) or find_in_set('ULT:STOREFRONT',`eshopuga_upgr_4122`.`cscart_settings_objects`.`edition_type`) or find_in_set('ULT:VENDOR',`eshopuga_upgr_4122`.`cscart_settings_objects`.`edition_type`) or find_in_set('ULT:ROOT',`eshopuga_upgr_4122`.`cscart_settings_objects`.`edition_type`)) and (`eshopuga_upgr_4122`.`cscart_settings_objects`.`type` <> 'H'))"
}
}
]
}
}
}
Result
object_id |
name |
section_id |
section_tab_id |
type |
position |
is_global |
description |
value |
6486 |
licensekey |
202 |
203 |
I |
0 |
N |
licensekey |
|
6514 |
show_thumbnails |
202 |
205 |
C |
0 |
N |
show_thumbnails |
Y |
6543 |
use_sm |
202 |
206 |
C |
0 |
N |
use_sm |
N |
6546 |
use_boost |
202 |
207 |
C |
0 |
N |
use_boost |
N |
6496 |
search_by_exact_phrase |
202 |
204 |
S |
10 |
N |
search_by_exact_phrase |
all |
6487 |
cron_password |
202 |
203 |
I |
10 |
N |
cron_password |
PASSWORD |
6515 |
thumbnails_width |
202 |
205 |
I |
10 |
N |
thumbnails_width |
70 |
6544 |
show_sm |
202 |
206 |
N |
10 |
N |
show_sm |
|
6547 |
index_cron_info |
202 |
207 |
O |
10 |
N |
index_cron_info |
|
6497 |
speller |
202 |
204 |
S |
20 |
N |
speller |
none |
6488 |
record_search_history |
202 |
203 |
C |
20 |
N |
record_search_history |
Y |
6516 |
thumbnails_height |
202 |
205 |
I |
20 |
N |
thumbnails_height |
70 |
6545 |
sm_info |
202 |
206 |
O |
20 |
N |
sm_info |
|
6498 |
spell_amount |
202 |
204 |
I |
30 |
N |
spell_amount |
5 |
6489 |
letters_to_start |
202 |
203 |
I |
30 |
N |
letters_to_start |
3 |
6517 |
show_product_code |
202 |
205 |
C |
30 |
N |
show_product_code |
Y |
6499 |
search_in_short_description |
202 |
204 |
C |
40 |
N |
search_in_short_description |
N |
6490 |
search_delay |
202 |
203 |
I |
40 |
N |
search_delay |
500 |
6518 |
show_product_price |
202 |
205 |
C |
40 |
N |
show_product_price |
Y |
6500 |
search_in_full_description |
202 |
204 |
C |
50 |
N |
search_in_full_description |
N |
6491 |
items_limit |
202 |
203 |
I |
50 |
N |
items_limit |
5 |
6519 |
show_list_price |
202 |
205 |
C |
50 |
N |
show_list_price |
Y |
6501 |
search_in_keywords |
202 |
204 |
C |
60 |
N |
search_in_keywords |
Y |
6492 |
show_ajax_loader |
202 |
203 |
C |
60 |
N |
show_ajax_loader |
Y |
6520 |
show_add_to_cart |
202 |
205 |
C |
60 |
N |
show_add_to_cart |
Y |
6502 |
search_by_product_code |
202 |
204 |
C |
70 |
N |
search_by_product_code |
Y |
6493 |
ajax_loader |
202 |
203 |
S |
70 |
N |
ajax_loader |
loader_1 |
6521 |
show_add_to_wishlist |
202 |
205 |
C |
70 |
N |
show_add_to_wishlist |
N |
6503 |
search_by_categories |
202 |
204 |
S |
80 |
N |
search_by_categories |
none |
6494 |
popup_mheight |
202 |
203 |
I |
80 |
N |
popup_mheight |
600px |
6522 |
show_add_to_comparison_list |
202 |
205 |
C |
80 |
N |
show_add_to_comparison_list |
N |
6504 |
search_by_vendors |
202 |
204 |
C |
90 |
N |
search_by_vendors |
N |
6523 |
show_product_category |
202 |
205 |
S |
90 |
N |
show_product_category |
none |
6505 |
separate_common_products |
202 |
204 |
C |
100 |
N |
separate_common_products |
N |
6524 |
show_category_labels |
202 |
205 |
S |
100 |
N |
show_category_labels |
none |
6506 |
q_ignore |
202 |
204 |
|
110 |
N |
q_ignore |
|
6525 |
category_labels_colors |
202 |
205 |
I |
110 |
N |
category_labels_colors |
|
6526 |
style_settings |
202 |
205 |
D |
120 |
N |
style_settings |
a:13:{s:10:"background";a:2:{s:5:"color";s:7:"#ffffff";s:11:"hover_color";s:7:"#f3f3f3";}s:17:"header_background";a:2:{s:5:"color";s:7:"#efefef";s:11:"hover_color";s:7:"#efefef";}s:12:"popup_titles";a:2:{s:5:"color";s:7:"#434343";s:11:"hover_color";s:7:"#434343";}s:11:"add_to_cart";a:2:{s:5:"color";s:7:"#808080";s:11:"hover_color";s:7:"#b06c07";}s:15:"add_to_wishlist";a:2:{s:5:"color";s:7:"#808080";s:11:"hover_color";s:7:"#980d29";}s:14:"add_to_compare";a:2:{s:5:"color";s:7:"#1c1c1c";s:11:"hover_color";s:7:"#3060ab";}s:9:"load_more";a:2:{s:5:"color";s:7:"#26323e";s:11:"hover_color";s:7:"#192129";}s:8:"view_all";a:2:{s:5:"color";s:7:"#ffffff";s:11:"hover_color";s:7:"#f3f3f3";}s:13:"view_all_text";a:2:{s:5:"color";s:7:"#26323e";s:11:"hover_color";s:7:"#192129";}s:12:"product_name";a:2:{s:5:"color";s:7:"#313030";s:11:"hover_color";s:7:"#313030";}s:12:"product_code";a:2:{s:5:"color";s:7:"#000000";s:11:"hover_color";s:7:"#000000";}s:13:"product_price";a:2:{s:5:"color";s:7:"#000000";s:11:"hover_color";s:7:"#000000";}s:10:"list_price";a:2:{s:5:"color";s:7:"#000000";s:11:"hover_color";s:7:"#000000";}} |
6508 |
use_cache |
202 |
204 |
C |
130 |
N |
use_cache |
N |
6527 |
use_suggestions |
202 |
205 |
S |
130 |
N |
use_suggestions |
none |
6509 |
ignore_symbols |
202 |
204 |
|
140 |
N |
ignore_symbols |
|
6528 |
suggestions_amount |
202 |
205 |
I |
140 |
N |
suggestions_amount |
5 |
6510 |
order_results |
202 |
204 |
S |
150 |
N |
order_results |
popularity |
6529 |
h_suggestions_letters |
202 |
205 |
I |
150 |
N |
h_suggestions_letters |
4 |
6511 |
searchinfeatures |
202 |
204 |
C |
160 |
N |
searchinfeatures |
N |
6530 |
h_suggestions_requests |
202 |
205 |
I |
160 |
N |
h_suggestions_requests |
10 |
6512 |
searchinoptions |
202 |
204 |
C |
170 |
N |
searchinoptions |
N |
6531 |
show_brands_result |
202 |
205 |
C |
170 |
N |
show_brands_result |
N |
6513 |
cache_info |
202 |
204 |
O |
180 |
N |
cache_info |
|
6532 |
brand_id |
202 |
205 |
S |
180 |
N |
brand_id |
none |
6533 |
brands_amount |
202 |
205 |
I |
190 |
N |
brands_amount |
5 |
6534 |
show_categories_result |
202 |
205 |
C |
200 |
N |
show_categories_result |
Y |
6535 |
show_categories_path |
202 |
205 |
C |
210 |
N |
show_categories_path |
Y |
6536 |
categories_amount |
202 |
205 |
I |
220 |
N |
categories_amount |
5 |
6537 |
show_f_products_result |
202 |
205 |
C |
230 |
N |
show_f_products_result |
N |
6538 |
f_products_amount |
202 |
205 |
I |
240 |
N |
f_products_amount |
5 |
6539 |
show_vendors_result |
202 |
205 |
C |
250 |
N |
show_vendors_result |
N |
6540 |
vendors_amount |
202 |
205 |
I |
260 |
N |
vendors_amount |
5 |
6541 |
show_items |
202 |
205 |
N |
270 |
N |
show_items |
|
6542 |
items_amount |
202 |
205 |
I |
280 |
N |
items_amount |
5 |