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 = 3 
  AND cscart_page_descriptions.lang_code = 'no' 
  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.00096

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
3 1 0 3 A T 0 1208725200 0 0 N 0 0 activity no Privacy policy <h1><span style="font-size: 24px;">What information do we collect?</span></h1> <p>We collect information from you when you register on our site, place an order, subscribe to our newsletter or fill out a form.</p> <p>When ordering or registering on our site, as appropriate, you may be asked to enter your: name, e-mail address or mailing address. You may, however, visit our site anonymously.</p> <h3>What do we use your information for?</h3> <p>Any of the information we collect from you may be used in one of the following ways:</p> <ul> <li>To personalize your experience<br> (your information helps us to better respond to your individual needs)</li><li>To improve our website<br> (we continually strive to improve our website offerings based on the information and feedback we receive from you)</li><li>To improve customer service<br> (your information helps us to more effectively respond to your customer service requests and support needs)</li><li>To process transactions <ul> <li>Your information, whether public or private, will not be sold, exchanged, transferred, or given to any other company for any reason whatsoever, without your consent, other than for the express purpose of delivering the purchased product or service requested.</li></ul></li><li>To administer a contest, promotion, survey or other site feature</li><li>To send periodic emails <ul> <li>The email address you provide for order processing, may be used to send you information and updates pertaining to your order, in addition to receiving occasional company news, updates, related product or service information, etc.</li></ul>Note: If at any time you would like to unsubscribe from receiving future emails, we include detailed unsubscribe instructions at the bottom of each email.</li></ul> <h3>How do we protect your information?</h3> <p>We implement a variety of security measures to maintain the safety of your personal information when you place an order or enter, submit, or access your personal information.</p> <p>We offer the use of a secure server. All supplied sensitive information is transmitted via Secure Socket Layer (SSL) technology and then encrypted into our Payment gateway providers database only to be accessible by those authorized with special access rights to such systems, and are required to keep the information confidential.</p> <h3>Do we use cookies?</h3> <p>Yes (Cookies are small files that a site or its service provider transfers to your computers hard drive through your Web browser (if you allow) that enables the sites or service providers systems to recognize your browser and capture and remember certain information).</p> <p>We use cookies to help us remember and process the items in your shopping cart, understand and save your preferences for future visits and keep track of advertisements.</p> <h3>Do we disclose any information to outside parties?</h3> <p>We do not sell, trade, or otherwise transfer to outside parties your personally identifiable information. This does not include trusted third parties who assist us in operating our website, conducting our business, or servicing you, so long as those parties agree to keep this information confidential. We may also release your information when we believe release is appropriate to comply with the law, enforce our site policies, or protect ours or others rights, property, or safety. However, non-personally identifiable visitor information may be provided to other parties for marketing, advertising, or other uses.</p> <h3>Third party links</h3> <p>Occasionally, at our discretion, we may include or offer third party products or services on our website. These third party sites have separate and independent privacy policies. We therefore have no responsibility or liability for the content and activities of these linked sites. Nonetheless, we seek to protect the integrity of our site and welcome any feedback about these sites.</p> <h3>Online Privacy Policy Only</h3> <p>This online privacy policy applies only to information collected through our website and not to information collected offline.</p> <h3>Your Consent</h3> <p>By using our site, you consent to our privacy policy.</p> <h3>Changes to our Privacy Policy</h3> <p>If we decide to change our privacy policy, we will post those changes on this page, and/or update the Privacy Policy modification date below.</p> <p>This policy was last modified on 01.August.2015</p> <p><strong></strong><strong>Eshop Infosystems Ltd</strong><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: <a href="http://www.eshopuganda.com">www.eshopuganda.com</a></p> <p>OR </p> <p>Sonyaco Plaza, Bank Road <br> Homa Bay<br>Mombasa, 254<br>Republic of Kenya</p> <p>&copy; Copyright 2015-2021<br></p> Online Shopping in Uganda, Flowers Uganda, Uganda Flowers, Send Flowers to Uganda, Online Shopping Founded in May 2015, www.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. Eshopuganda.com is operated by Eshop Infosystems Ltd Privacy Policy - eshopuganda.com - Send Flowers to Uganda, Online Shopping privacy-policy