Query time 0.00077
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.65"
},
"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.46",
"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 |
| 506 |
A |
13 |
0 |
0 |
1681669800 |
A |
21551 |
|
298 |
https://www.kindlife.in/a-period-without-pain |
https://cdn.kindlife.in/images/videos/thumb/298/1cfec707a2a9beaf282dc289265a3e97.jpg |
https://cdn.kindlife.in/images/videos/thumb/298/30d624ea970bcff8ad3627df2b409128.mp4 |
1713161057 |
en |
|
Conquering Period Pain Naturally: What Women Want Experience! |
<p>Tired of dealing with those pesky period cramps? Join me as I try out the Cosmix What Women Want powder to help balance hormones and improve overall well-being.</p>
<p></p>
<p></p>
<p></p><li><strong>Understanding Hormonal Imbalance:</strong> Let's break down the science behind hormonal fluctuations and how they affect our bodies.</li><li><strong>Introducing What Women Want:</strong> A deep dive into the ingredients and benefits of this unique powder.</li><li><strong>My Personal Experience:</strong> I'll share my honest thoughts and results after using the powder consistently.</li><li><strong>How to Incorporate It into Your Routine:</strong> Tips on how to easily add this powder to your daily diet.</li><p></p><p></p>
<p></p>
<p></p> |
|
1 |
0 |
0 |
0 |
|
|
|
|
24 |
M |