Query time 0.00042
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.47"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "1.21"
},
"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": 2,
"rows_produced_per_join": 1,
"filtered": "60.69",
"index_condition": "(`cscart_db`.`cscart_cp_videos`.`video_id` in (807,817))",
"cost_info": {
"read_cost": "1.29",
"eval_cost": "0.12",
"prefix_cost": "1.41",
"data_read_per_join": "1K"
},
"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.30",
"eval_cost": "0.12",
"prefix_cost": "1.83",
"data_read_per_join": "5K"
},
"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.30",
"eval_cost": "0.12",
"prefix_cost": "2.26",
"data_read_per_join": "19"
},
"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 |
| 817 |
C |
13 |
0 |
0 |
1687977000 |
A |
125048 |
|
860 |
https://www.kindlife.in/makeup-essentials |
https://cdn.kindlife.in/images/videos/thumb/860/905e69f7936349c3d923d146eb5283bb.jpg |
https://cdn.kindlife.in/images/videos/thumb/860/9356f41e4236d83286e62e380a4ae4ee.mp4 |
1713162496 |
en |
|
Discover Your Skin's Perfect Match: Skincare Essentials |
<p>Explore essential skincare favorites like the Happier Sunstick for convenient sun protection on the go, The Face Shop Chia Seed line for deep hydration and a refreshed complexion, and Suganda Serum for targeted skin concerns like acne and hyperpigmentation. Each product offers unique benefits: from UV protection and moisturization to targeted treatment and nourishment. Elevate your skincare routine with these must-have essentials, ensuring your skin stays healthy, radiant, and glowing every day!</p> |
|
1 |
2 |
0 |
0 |
|
|
|
|
36 |
M |
| 807 |
C |
13 |
0 |
0 |
1687458600 |
A |
83919 |
|
843 |
https://www.kindlife.in/my-travel-skincare-essentials |
https://cdn.kindlife.in/images/videos/thumb/843/b66e6e882d30ac4d37a29665171ebfe4.jpg |
https://cdn.kindlife.in/images/videos/thumb/843/dc780ccd0a14cfdd88d28fcf5fb4140c.mp4 |
1713162491 |
en |
|
My Travel Skincare Essentials |
<p> Start your skincare routine with Squalane Cleansing Oil for a gentle cleanse, followed by the 2% Hyaluronic Acid Serum with Bulgarian Rose for deep hydration. ? Lock in moisture with Chia Seed Hydro Cream, and protect your skin with Invisible Body Sunscreen SPF 60. ☀️ Refresh anytime with Hydrate + Refresh Toning Mist and keep your lips plump with Radiance + Plump Lip Mask. ? Finish with the Sunscreen Stick SPF 50+ PA+++ for all-day sun protection. ?✨</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></p>
<p><br></p>
</b><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"></b></p><p></p> |
|
1 |
1 |
0 |
0 |
|
|
|
|
7 |
M |