Query time 0.00050
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.20"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "1.82"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_cp_videos",
"access_type": "range",
"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",
"rows_examined_per_scan": 3,
"rows_produced_per_join": 1,
"filtered": "60.69",
"index_condition": "(`cscart_db`.`cscart_cp_videos`.`video_id` in (312,318,421))",
"cost_info": {
"read_cost": "1.93",
"eval_cost": "0.18",
"prefix_cost": "2.11",
"data_read_per_join": "2K"
},
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.46",
"eval_cost": "0.18",
"prefix_cost": "2.75",
"data_read_per_join": "7K"
},
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.46",
"eval_cost": "0.18",
"prefix_cost": "3.38",
"data_read_per_join": "29"
},
"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 |
| 312 |
C |
13 |
0 |
0 |
1681669800 |
A |
76209 |
|
511 |
https://www.kindlife.in/get-un-ready-with-me |
https://cdn.kindlife.in/images/videos/thumb/511/30755d51424cb19384c1c8a56d93f21f.jpg |
https://cdn.kindlife.in/images/videos/thumb/511/6570b09a0e021373954534bffdddc471.mp4 |
1713161646 |
en |
|
Deep Cleanse with Rice Water |
<p>Achieve the perfect makeup removal and soothing skincare routine with these essentials. Start with The Face Shop Rice Water Bright Cleansing, which gently dissolves makeup and impurities. Follow with the Makeuperaser Removal Cloth for a thorough, eco-friendly clean. Finish with Spoilyourbody Superglow Foaming Face Wash to cleanse and calm your skin, leaving it refreshed and radiant. This trio ensures your skin is clean, soft, and glowing every day!</p> |
|
1 |
56 |
0 |
0 |
|
|
|
|
7 |
M |
| 318 |
C |
13 |
0 |
0 |
1681669800 |
A |
35855 |
|
505 |
https://admin.kindlife.in/taking-your-makeup-off |
https://cdn.kindlife.in/images/videos/thumb/505/94c1d698f0de79f744844491a904a8f0.jpg |
https://cdn.kindlife.in/images/videos/thumb/505/a5358d8ea70fe89eda9298f0f4b124c0.mp4 |
1713161558 |
en |
|
Unwind Your Skin: The Ultimate Makeup Removal Guide |
<p>Start your skincare routine with <strong>The Face Shop Rice Water Bright Cleansing Oil</strong>, a gentle yet effective cleanser that melts away makeup and impurities, leaving your skin soft and radiant. Follow up with <strong>COSRX Low pH Good Morning Gel Cleanser</strong> for a refreshing cleanse that balances your skin's pH and gently exfoliates dead skin cells. This duo ensures a clean, smooth, and hydrated complexion, making it the perfect base for your morning or evening skincare routine. Say goodbye to dirt and grime, and hello to fresh, glowing skin!</p><p></p> |
|
1 |
0 |
0 |
0 |
|
|
|
|
36 |
M |