Query time 0.00203
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"ordering_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_cp_videos",
"access_type": "const",
"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": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"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"
]
}
},
{
"table": {
"table_name": "cscart_cp_video_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"video_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "4K"
},
"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": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "16"
},
"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 |
| 374 |
C |
13 |
0 |
0 |
1681669800 |
A |
414 |
|
446 |
https://admin.kindlife.in/fit-for-festive-step-2-probiotics-and-prebiotics |
https://cdn.kindlife.in/images/videos/thumb/446/8ef630a2b4e7c858feb9bf4446c4f495.jpg |
https://cdn.kindlife.in/images/videos/thumb/446/ecc79087c645ad90c7e38e8e7186614a.mp4 |
1713161425 |
en |
|
Fit for Festive - Step 2 - Probiotics and Prebiotics |
<p>Begin your day with a probiotic and see the difference for yourself in energy, weight and immunity!</p>
<p>There is nothing more powerful than a healthy gut microbiome because that is the foundation of all healthy living. Great digestion = great health! </p>
<p>Fire up a sluggish system with the right probiotics. A huge range of them available right here at Kindlife. Go on and choose - As they say, go with your gut instinct! <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@prob"><a id="product_12018" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=12018" data-value="12018">Digestion Boost - Combo of Tummy Probiotic & Apple Cider Vinegar Gummies</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@"><a id="product_8940" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=8940" data-value="8940">Effervescent Tablets- Pre + Probiotic - 20 Tablets</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@probio"><a id="product_9106" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=9106" data-value="9106">Organic Himalayan Apple Cider Vinegar with 2X Strands of Probiotic Mother and Enzymes - 500ml</a></span> </p> |
|
1 |
1 |
0 |
0 |
|
|
|
|
24 |
M |