SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_pages.page_id = 87 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'B', 'F')

Query time 0.00110

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.70"
    },
    "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": 2,
          "rows_produced_per_join": 2,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.50",
            "eval_cost": "0.20",
            "prefix_cost": "0.70",
            "data_read_per_join": "3K"
          },
          "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
87 0 7 7/87 A B 0 1726527600 0 0 N 0 0 en How to tell if someone in your inner circle is struggling with sleep (and some tips to help them), with Sleep Expert Jade Zammit <p><span style="color: rgb(51, 51, 51); font-size: 16px;">When our loved ones are struggling in sleep, some are more open about it than others. For many, they don’t want to show the struggle and try to keep it to themselves, making it harder to see if they truly are struggling.</span></p> <p><strong>Here are some signs you can look out for:</strong></p> <ul><li>They are cancelling plans more often; often when we are suffering in sleep deprivation we become more isolated, anxieties peak and we disassociate ourselves more.</li><li>They comment on the lack of sleep they are having</li><li>Their self care has taken a hit, they feel and look exhausted, as if they are in survival mode.</li><li>Their mood swings are showing more, more irritable, more emotional or stressed.</li><li>Signs of post natal depression; many mums suffering in this can’t sleep when baby sleeps either.</li></ul> <p><strong>Here are some helpful questions you can ask to offer that conversation up;</strong></p> <ul><li>Are you sleeping enough?</li><li>What time were you two up this morning?</li><li>If the little one is a due a nap, you could ask; Do you want to catch up on sleep too</li></ul> <p>Do try to avoid the “are they a good sleeper?” question! Many parents feel some judgement in this to them or their little one and often will close right up instead! Try to offer more open questions to allow them to open up about what is going on. Once you can get a feel them you can start to ask if they need support.</p> <p>For those struggling in sleep – they may feel that they should be handling things, but it really is ok to be feeling the complete opposite. Asking for support or at least opening up to someone can feel like a huge weight lifted. It takes away that feeling of isolation too. Every parent in the world will have sleepless stories to tell, but sharing it with others can bring positive impacts for their mental health. Seeking support – is a fantastic step. You’ll never feel alone in it and get guidance to support your whole family, to allow you to be the parent you need to be.<span class="Apple-converted-space">&nbsp;</span></p> <p>We know that sleep is a big deal for those of us with young families, so we've partnered up with award winning sleep consultant, Jade Zammit, who is here to help your loved ones sleep.&nbsp; As any parent will testify, the gift of sleep in the ultimate luxury - you can check out Jade's gift packages on We are The Helpful today.</p> how-to-tell-if-someone-in-your-inner-circle-is-struggling-with-sleep-and-some-tips-to-help-them 7