Query time 0.00044
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 |
| 355 |
C |
13 |
0 |
0 |
1681669800 |
A |
63828 |
|
467 |
https://admin.kindlife.in/popped-a-pimple-now-what |
https://cdn.kindlife.in/images/videos/thumb/467/f49e14d3aaaa394e4aa92e855b96fb2c.jpg |
https://cdn.kindlife.in/images/videos/thumb/467/e90c94e51556b04f847cdf6e5f7751c1.mp4 |
1713161526 |
en |
|
Popped a Pimple now What? |
<div>Feeling guilty & freaking out after popping a pimple?</div>
<div> </div>
<div>Here are some steps you can follow to treat acne. </div>
<div> </div>
<div>Avoid touching the spot: keep the area clean. You want to avoid contaminating the area with bacteria that may be on your fingers or nail tips and which could cause an infection.</div>
<div> </div>
<div>Ice it: Applying a clean, cloth-covered ice cube and apply it on the affected area it helps in reducing the inflammation of your pimples and decreases the redness. </div>
<div> </div>
<div>Use a Pimple Patch: It helps to fight acne and reduce inflammation also helps to keep you from picking.</div>
<div> </div>
<div>Spot treat it with Tea tree oil/ Niaciniamde/ Benzoyl peroxide: It helps reduce acne scars, calm redness, swelling, and inflammation.</div>
<div> </div>
<div>Wear sunscreen daily: It helps prevent Hyperpigmentation and scarring.<br /><br />Recommendations :<br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@belm"><a id="product_18025" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=18025" data-value="18025">Dr. Belmeur Clarifying Spot Soothing Patches - 24 Patches</a></span> <br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@bel"><a id="product_18027" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=18027" data-value="18027">Dr. Belmeur Clarifying Ultra Soothing Patches - 6 Patches</a></span> <br /><span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@n"><a id="product_5585" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=5585" data-value="5585">5% Niacinamide Serum - 30ml</a></span> <br /></div>
<div> </div>
<div>Give it some time to heal: Consistency and Patience is the key.</div>
<div> </div> |
|
1 |
0 |
0 |
0 |
|
|
|
|
7 |
M |