Query time 0.00053
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.69"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "1.34"
},
"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": "67.15",
"index_condition": "(`cscart_db`.`cscart_cp_videos`.`video_id` in (1268,1327))",
"cost_info": {
"read_cost": "1.28",
"eval_cost": "0.13",
"prefix_cost": "1.41",
"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.34",
"eval_cost": "0.13",
"prefix_cost": "1.88",
"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.34",
"eval_cost": "0.13",
"prefix_cost": "2.35",
"data_read_per_join": "21"
},
"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 |
| 1327 |
A |
13 |
0 |
0 |
1719340200 |
A |
113246 |
|
0 |
https://www.kindlife.in/foxtale-milky-way-rapid-spot-reduction-drops |
https://www.kindlife.in/images/video_library/1327_VID_63161226_180402_022_preview.jpg |
https://www.kindlife.in/images/video_library/1327_VID_63161226_180402_022.mp4 |
0 |
en |
|
Bye-Bye Blemishes |
<p>Introducing Foxtale's The Milky Way Rapid Spot Reduction Drops – your new secret weapon against pesky spots! Like magic from the Milky Way, these drops work their cosmic charm overnight, soothing and shrinking spots while you dream. Wake up to clearer, happier skin that twinkles like stars in the night sky. Embrace the galaxy's gift to skincare and say goodbye to spots with a smile!<br></p>
<p><span data-state="closed"><b class="rounded-md p-1 text-token-text-tertiary hover:text-token-text-primary"><br></b></span></p><p><b class="rounded-md p-1 text-token-text-tertiary hover:text-token-text-primary">
</b></p><b class="rounded-md p-1 text-token-text-tertiary hover:text-token-text-primary">
</b><p><b class="rounded-md p-1 text-token-text-tertiary hover:text-token-text-primary"></b></p><p></p> |
|
1 |
1 |
0 |
0 |
|
|
|
26723 |
7 |
M |
| 1268 |
A |
13 |
0 |
0 |
1716489000 |
A |
210173 |
|
0 |
https://www.kindlife.in/brightening-serums-for-you |
https://www.kindlife.in/images/video_library/1268_1000300160_preview.jpg |
https://www.kindlife.in/images/video_library/1268_1000300160.mp4 |
0 |
en |
|
From Fades to Flawless! |
<p>Achieve clear, bright skin with Plum 10% Niacinamide Face Serum! Infused with Vitamin B3 and Japanese Fermented Rice Water, it evens skin tone and reduces blemishes, suiting all skin types. For extra brightening, our 2% Alpha Arbutin Face Serum with Hyaluronic Acid targets dark spots and keeps your skin hydrated. Need quick results? The Milky Way Rapid Spot Reduction Drops work wonders for reducing spots in no time! </p> |
|
1 |
1 |
0 |
0 |
|
|
|
23702,10384,26723 |
7 |
M |