Query time 0.00452
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_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": "2K"
},
"used_columns": [
"page_id",
"company_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"usergroup_ids",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"facebook_obj_type"
]
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_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": "3K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"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": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
Result
| page_id |
company_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
usergroup_ids |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
facebook_obj_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
seo_name |
seo_path |
| 53 |
0 |
0 |
53 |
A |
T |
0 |
1697151600 |
0 |
|
0 |
N |
0 |
0 |
activity |
en |
The Inner Circle |
<div class="th-inner-circle">
<h2 class="ty-mainbox-simple-title">So, What Helped? </h2><h2 class="ty-mainbox-simple-title"><em>Your Stories</em></h2>
<div class="th-inner-circle__item">
<div class="th-inner-circle__item-image">
<img src="/design/themes/the_helpful/media/images/inner-circle/Real Stories-Rebecca.jpg">
</div>
<div class="th-inner-circle__item-caption">
<p><strong><em>"I didn't want to complain, but I was struggling".</em></strong></p><p>Rebecca has mastered the art of figuring sh*t out. Resourceful, deeply contemplative, and innately attuned to her surroundings, I was intrigued to hear her story of moving into the dilapidated house she and her husband are also restoring.</p>
<a href="/blog/but-what-helped-rebeccas-story/">Read more</a>
</div>
</div>
<div class="th-inner-circle__item">
<div class="th-inner-circle__item-image">
<img src="https://wearethehelpful.com/images/Viv.jpg?1731065949235">
</div>
<div class="th-inner-circle__item-caption">
<p><strong><em>“More time / Less guilt”.</em></strong></p>
<p>An intimate share of an unexpected overseas move and what those closest did to show up and support when it was truly needed.</p>
<a href="/blog/but-what-helped-an-unexpected-overseas-move-and-what-those-closest-did-to-show-up-and-support-when-it-was-truly-needed/">Read more</a>
</div>
</div>
<div class="th-inner-circle__item">
<div class="th-inner-circle__item-image">
<img src="https://wearethehelpful.com/images/Me.jpg?1731517272119">
</div>
<div class="th-inner-circle__item-caption">
<p><em><strong>“I was so busy being a mum, I didn’t have time to be a daughter.”</strong></em></p><p>
</p><p>Working so closely with Kate to build her vision for We Are The Helpful, we talked more intimately about her experience of losing her mum than we might have otherwise. Her words were as ever poignant, honest, and reflective, but this simple, disarming phrase struck me as so universally relatable.</p>
<a href="/blog/what-helped-kates-story-on-loss-and-motherhood/">Read more</a>
</div>
</div>
<div class="th-inner-circle__button">
<a href="/blog/" class="ty-btn ty-btn__primary">Your Stories: Read More</a>
</div>
</div> |
|
|
|
|
inner-circle |
|