Query time 0.00111
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.20"
},
"nested_loop": [
{
"table": {
"table_name": "q_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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": [
"category_id",
"parent_id",
"id_path",
"level",
"company_id",
"usergroup_ids",
"status",
"product_count",
"position",
"timestamp",
"is_op",
"localization",
"age_verification",
"age_limit",
"parent_age_verification",
"parent_age_limit",
"selected_views",
"default_view",
"product_details_view",
"product_columns",
"is_trash",
"category_type",
"abt__yt_banners_use",
"abt__yt_banner_max_position",
"ab__lc_catalog_image_control",
"ab__lc_landing",
"ab__lc_subsubcategories",
"ab__lc_menu_id",
"ab__lc_how_to_use_menu",
"ab__lc_inherit_control"
]
}
},
{
"table": {
"table_name": "q_category_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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": "3K"
},
"used_columns": [
"category_id",
"lang_code",
"category",
"description",
"meta_keywords",
"meta_description",
"page_title",
"age_warning_message"
]
}
},
{
"table": {
"table_name": "q_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
Result
category_id |
parent_id |
id_path |
level |
company_id |
usergroup_ids |
status |
product_count |
position |
timestamp |
is_op |
localization |
age_verification |
age_limit |
parent_age_verification |
parent_age_limit |
selected_views |
default_view |
product_details_view |
product_columns |
is_trash |
category_type |
abt__yt_banners_use |
abt__yt_banner_max_position |
ab__lc_catalog_image_control |
ab__lc_landing |
ab__lc_subsubcategories |
ab__lc_menu_id |
ab__lc_how_to_use_menu |
ab__lc_inherit_control |
lang_code |
category |
description |
meta_keywords |
meta_description |
page_title |
age_warning_message |
name |
object_id |
type |
dispatch |
path |
seo_name |
seo_path |
3 |
2 |
2/3 |
2 |
0 |
0 |
A |
28 |
10 |
1552420800 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
C |
N |
60 |
none |
N |
0 |
0 |
N |
N |
en |
Fragrance |
|
fragrance online, perfume online, looking for perfume, dior, vercase, best perfume in, perfume brands in, perfume shop in, fragrance shop online, creed, good girl, new perfume in, perfume for men, perfume brands, perfume movie, fragrancex |
Best price for genuine perfumes & fragrance in uae you can find on qazaan huge range 100% genuine | Great value and fast delivery
|
Shop online Fragrance best price in Dubai, Abu Dhabi and All UAE |
|
fragrance |
3 |
c |
|
2 |
fragrance |
2 |