Query time 0.00064
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.83"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "2.19"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_tags",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"tag"
],
"key": "tag",
"used_key_parts": [
"tag"
],
"key_length": "767",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "10.00",
"cost_info": {
"read_cost": "0.44",
"eval_cost": "0.01",
"prefix_cost": "0.54",
"data_read_per_join": "78"
},
"used_columns": [
"tag_id",
"tag",
"status"
],
"attached_condition": "(`cscart_db`.`cscart_tags`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_tag_links",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"tag_id",
"ids",
"idx_tag_links_object_id"
],
"key": "tag_id",
"used_key_parts": [
"tag_id",
"object_type"
],
"key_length": "6",
"ref": [
"cscart_db.cscart_tags.tag_id",
"const"
],
"rows_examined_per_scan": 32,
"rows_produced_per_join": 3,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.33",
"prefix_cost": "0.97",
"data_read_per_join": "52"
},
"used_columns": [
"tag_id",
"object_type",
"object_id"
]
}
},
{
"table": {
"table_name": "cscart_cp_videos",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status_idx",
"video_id_idx",
"idx_cp_videos_status_userid_videoid",
"idx_status_timestamp"
],
"key": "PRIMARY",
"used_key_parts": [
"video_id"
],
"key_length": "3",
"ref": [
"cscart_db.cscart_tag_links.object_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "67.15",
"index_condition": "(`cscart_db`.`cscart_tag_links`.`object_id` = `cscart_db`.`cscart_cp_videos`.`video_id`)",
"cost_info": {
"read_cost": "0.82",
"eval_cost": "0.22",
"prefix_cost": "2.11",
"data_read_per_join": "3K"
},
"used_columns": [
"video_id",
"video_type",
"company_id",
"usergroup_ids",
"position",
"timestamp",
"status",
"user_id",
"extra_params",
"community_video_id",
"community_url",
"community_thumbnail",
"community_video_url",
"community_last_sync_timestamp"
],
"attached_condition": "(`cscart_db`.`cscart_cp_videos`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_cp_video_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"video_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscart_db.cscart_cp_videos.video_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.55",
"eval_cost": "0.22",
"prefix_cost": "2.88",
"data_read_per_join": "9K"
},
"used_columns": [
"video_id",
"lang_code",
"youtube_id",
"video",
"description",
"short_description",
"privacy",
"like_count",
"dislike_count",
"comment_count",
"meta_keywords",
"meta_description",
"page_title",
"tagged_brands"
]
}
},
{
"table": {
"table_name": "cscart_cp_video_category_links",
"access_type": "ref",
"possible_keys": [
"pt"
],
"key": "pt",
"used_key_parts": [
"video_id"
],
"key_length": "3",
"ref": [
"cscart_db.cscart_cp_videos.video_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.55",
"eval_cost": "0.22",
"prefix_cost": "3.64",
"data_read_per_join": "35"
},
"used_columns": [
"video_id",
"category_id",
"link_type",
"position"
]
}
}
]
}
}
}
Result
| video_id |
video_type |
company_id |
usergroup_ids |
position |
timestamp |
status |
user_id |
extra_params |
community_video_id |
community_url |
community_thumbnail |
community_video_url |
community_last_sync_timestamp |
lang_code |
youtube_id |
video |
description |
short_description |
privacy |
like_count |
dislike_count |
comment_count |
meta_keywords |
meta_description |
page_title |
tagged_brands |
category_id |
link_type |
| 516 |
A |
13 |
0 |
0 |
1681669800 |
A |
21551 |
|
284 |
https://www.kindlife.in/niacinamide-and-its-benefits |
https://cdn.kindlife.in/images/videos/thumb/284/cb0463886ca41285127a076f1b536a67.jpg |
https://cdn.kindlife.in/images/videos/thumb/284/9f8da86085bb874abd864388513c8b48.mp4 |
1713161046 |
en |
|
Niacinamide and it’s benefits |
<div>What are we are adding to our glossary today?</div>
<div>Niacinamide</div>
<div> </div>
<div>What is Niacinamide?</div>
<div>Niacinamide is one of the two forms of vitamin B3 . Vitamin B3 is also known as niacin. </div>
<div> </div>
<div>Benefits of Niacinamide ✨</div>
<div>Niacinamide can help build proteins in the skin and lock in moisture. It helps reduce redness and minimises the pore appearance. It also helps rebuild healthy skin cells while also protecting them from damage caused by ultraviolet rays. This powerful ingredient may prove helpful in reducing acne, especially inflammation. Over time, you may see fewer lesions and improved skin texture.</div>
<div> </div>
<div>How to apply✨</div>
<div>Many topical niacinamide products come in the form of serums. Your serum should be applied before moisturising. If you have sensitive case, it’s always better to start with a lower concentration. </div>
<div> </div>
<div><br></div> |
|
1 |
59 |
0 |
0 |
|
|
|
|
7 |
M |