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' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  cscart_pages.page_id = 2 
  AND cscart_page_descriptions.lang_code = 'nl' 
  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', 'P')

Query time 0.00114

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "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.20",
            "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",
            "abt__ut2_microdata_schema_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.20",
            "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_ult_objects_sharing",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "share_object_id",
            "share_company_id",
            "share_object_type"
          ],
          "key_length": "159",
          "ref": [
            "const",
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.20",
            "prefix_cost": "0.00",
            "data_read_per_join": "160"
          },
          "used_columns": [
            "share_company_id",
            "share_object_id",
            "share_object_type"
          ]
        }
      },
      {
        "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": "1.00",
            "eval_cost": "0.20",
            "prefix_cost": "1.20",
            "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 abt__ut2_microdata_schema_type lang_code page description meta_keywords meta_description page_title link seo_name seo_path
2 1 0 2 A T 0 1208725200 0 0 N 0 0 activity nl About us <p>Founded in May 2015, <a href="https://www.eshopuganda.com">https://www.eshopuganda.com</a> - a service of Eshop Infosystems Ltd - Registration N0. 201026 (Uganda) and Registration No. NS-28HAJV8 (Kenya) - is the fastest growing eCommerce delivery site. It's primarily aimed at people living in the diaspora seeking to send support to their loved ones in Uganda. eshopuganda.com is operated by Eshop Infosystems Ltd ("we"), a company registered in Uganda & Kenya, East Africa.</p> <p>We see the delivery of flowers, gifts, groceries, wine, spirits, cakes and food as expressions of emotions and we pride ourselves on providing the best floral, gifting and groceries service anywhere in Uganda. Flowers are delivered by our network of preferred florists. Hampers, gifts, groceries, wine and spirits and food are all carefully packaged and distributed via our courier network. All products are backed by a 100% guarantee - if you are not happy with the service, a replacement will be sent or a full refund will be made within 5 days.</p> <p>A 100% guarantee is offered on all our flowers, gifts and roses. You no longer need to visit florists in Kampala, Wakiso, Mpigi, Entebbe or Florists in Mukono & Jinja. We make buying flowers a pleasure. Eshopuganda.com does cater for occasions like Valentine's Day, Mother's Day, Father's Day, Teacher's Day, Grandparents Day, Bosses Day, Christmas, Secretaries Day (Secretary's Day), Birthdays, Anniversaries and more.</p> <p>Eshopuganda.com brings you flowers and floral hampers, groceries and gifts beyond your wildest dreams. Send flowers to anywhere in Uganda with domestic offices all over. Delivering flowers on time with Eshopuganda.com is never a problem. No need to take time off work and visit florist's shops, our selection of flowers & gifts is unmatched. It's the ease of flower delivery and sending flowers straight to your doorstep. Floral arrangements and flowers are delivered same day if ordered before 12 noon. </p> <p>Gift deliveries vary depending on area which range from Kampala Suburbs and Wakiso all the way through to the awesome cities of Entebbe and Mpigi. Even more pleasurable is the fact that if you do live in Mukono, Jinja or Masaka you can now have the very best in floral arrangements and gifts, and reap the same rewards as you would if you resided in one of the larger spots in Kampala. You have most certainly come to the right place and can buy flowers and gifts online anytime.</p> <p><strong><br></strong></p> <p>Eshop Infosystems Ltd<br> Plot 1001, Block 244, Ggaba Rd, Susie House, Suite 2.9<br> (Next to the American Embassy, DFCU Bank & Opposite Embassy Supermarket)<br> P.O. Box 7615, Kampala Uganda</p> <p><strong>Cell:</strong> +256 (0) 780 256 314 -- +256 (0) 755 672 204<br><strong>Tel:</strong> +256 (0) 392 178 535</p> <p>Email: info@eshopuganda.com<br>Website<strong>:</strong> <a href="http://www.eshopuganda.com/">www.eshopuganda.com</a></p> <p>OR<br></p> <p>Sonyaco Plaza, Bank Road<br>Homa Bay<br>Mombasa, 254<br>Republic of Kenya<br></p> <p>&copy; Copyright 2015-2021</p> Online Shopping, Send Flowers to Uganda, Flowers Uganda, Uganda Flowers, Uganda Web Portal Founded in May 2015, eshopuganda.com is Uganda's fastest growing eCommerce delivery site. It's primarily aimed at people living in the diaspora seeking to send support to their loved ones in Uganda. About eshopuganda.com - Online Shopping in Uganda, Send Flowers to Uganda Online about-our-company