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 = 139 
  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.00336

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
139 0 7 7/139 A B 0 1758063600 0 0 N 0 0 en The Power of Comfort: Why Robes, Pyjamas, Blankets, Socks and Loungewear Make the Most Thoughtful Gifts <p><em>Image: TBCo</em></p> <p>When life feels heavy - whether it’s the sleepless fog of new motherhood, the heartbreak of loss, the exhaustion of illness, or the sheer weight of overwhelm - comfort isn’t just nice, it’s essential. It’s what holds us when the world feels like too much. And it’s why gifts rooted in comfort - the robe, the blanket, the pair of soft socks - are often the most meaningful gifts we’ll ever receive.</p> <p>At We are The Helpful, we believe comfort gifting is love in action. These aren’t throwaway gestures. They’re everyday rituals that remind her she’s cared for, seen and supported.</p> <h4>Why comfort gifting matters</h4> <ul><li>Motherhood: A soft robe or pair of pyjamas is more than clothing, it’s armour for the long nights, the early mornings, the endless feeds. </li><li>Loss + Grief: Nothing can fix heartbreak, but wrapping her in warmth and softness can help her feel held. </li><li>Illness + Recovery: Loungewear, blankets and robes give her permission to rest. They turn convalescence into something softer, kinder, less clinical. </li><li>Overwhelm + Burnout: Comfort gifts say: pause, take a breath, let yourself be held. And sometimes, that’s exactly what’s needed. </li></ul> <h4>Comfort as a sensory gift</h4> <p>Psychologists know this: soft textures and warmth calm the nervous system. That’s why slipping into fresh pyjamas or pulling on cosy socks can change an entire day. When you gift comfort, you’re not just giving fabric and textiles, you’re giving rest, warmth and reassurance.</p> <h4>Our favourite comfort gift ideas</h4> <ul><li>Robes: Perfect for wrapping up after a shower, nursing in the night, or simply feeling a little more put together when the day feels chaotic. </li><li>Pyjamas: Soft, breathable, and flattering - a daily reminder to rest without compromise. </li><li><a href="https://wearethehelpful.com/family-self-care/clean-organise/services/cashmere-blanket-oatmeal-melange-small/">Blankets</a>: The ultimate hug in gift form. Ideal for grief, recovery, or simply carving out a moment on the sofa. </li><li><a href="https://wearethehelpful.com/illness-recovery/tbco-cashmere-and-merino-socks-rose-clone/">Socks:</a> Small, simple, always welcome. The “I thought of you” gift that delivers instant warmth. </li></ul> <h4>Comfort is never “just” a gift</h4> <p>A robe won’t heal grief. Socks can’t erase illness. Pyjamas won’t stop burnout. But they will make her feel held, seen, and loved through it all.</p> <p>That’s the power of comfort gifting: the simplest items, elevated to something unforgettable because of when, and why, they were given.</p> <p></p> comfort gifts UK, robes gift, pyjamas gift, blanket gift, socks gift, loungewear gift, thoughtful gifts, gifts for recovery, gifts for new mums Discover the power of comfort gifting. Shop robes, pyjamas, blankets, socks, and loungewear - thoughtful gifts for motherhood, loss, illness, overwhelm and recovery. Comfort Gifts UK: Robes, Pyjamas, Blankets, Socks & Loungewear | We are The Helpful the-power-of-comfort-why-robes-pyjamas-blankets-socks-and-loungewear-make-the-most-thoughtful-gifts 7