Query time 0.00069
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.64"
},
"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.25",
"eval_cost": "0.01",
"prefix_cost": "0.35",
"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.78",
"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": "1.92",
"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.69",
"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.45",
"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 |
| 864 |
C |
13 |
0 |
0 |
1692556200 |
A |
21551 |
|
911 |
https://www.kindlife.in/makhana-laddoos |
https://cdn.kindlife.in/images/videos/thumb/911/19a3e7d8ed0c6ff1e519a3d41b78ee1e.jpg |
https://cdn.kindlife.in/images/videos/thumb/911/112d6761a2f0f9ac65a1167be059362a.mp4 |
1713162841 |
en |
|
Sweet Tooth Slayer! Guilt-Free Makhana Laddoos for Fiber & Flavor. |
<p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Kickstarting the festive season with these ✨Makhana Laddoos✨, the perfect mix of yum and healthy, with a generous sprinkle of kindness of course ! Sugar cravings got you down? Replace them with healthy bliss! These Makhana Laddoos are packed with protein and fiber-rich fox nuts (makhana) to keep you satisfied. Naturally sweetened with options like dates or honey, they satisfy your sweet tooth without the guilt. Plus, a sprinkle of nuts or seeds (optional) adds a delightful crunch and healthy fats. Ditch the sugary treats and experience a delicious, guilt-free way to manage cravings and boost your energy!</span></p> |
|
1 |
7 |
0 |
3 |
|
|
|
|
24 |
M |