SELECT 
  *, 
  seo_names.name as seo_name, 
  seo_names.path as seo_path 
FROM 
  categories 
  LEFT JOIN category_descriptions ON category_descriptions.category_id = categories.category_id 
  AND category_descriptions.lang_code = 'en' 
  LEFT JOIN seo_names ON seo_names.object_id = 9936 
  AND seo_names.type = 'c' 
  AND seo_names.dispatch = '' 
  AND seo_names.lang_code = 'en' 
WHERE 
  categories.category_id = 9936 
  AND (
    categories.usergroup_ids = '' 
    OR FIND_IN_SET(0, categories.usergroup_ids) 
    OR FIND_IN_SET(1, categories.usergroup_ids)
  )

Query time 0.00086

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.95"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "categories",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY",
            "c_status",
            "p_category_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "category_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": [
            "category_id",
            "parent_id",
            "id_path",
            "level",
            "company_id",
            "usergroup_ids",
            "status",
            "product_count",
            "position",
            "timestamp",
            "is_op",
            "localization",
            "age_verification",
            "age_limit",
            "parent_age_verification",
            "parent_age_limit",
            "selected_views",
            "default_view",
            "product_details_view",
            "product_columns",
            "is_trash",
            "is_default",
            "category_type",
            "ss_vendor_categories",
            "deleted_at",
            "storefront_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "category_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "category_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": "4K"
          },
          "used_columns": [
            "category_id",
            "lang_code",
            "category",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "age_warning_message",
            "mega_m_category_banner_url",
            "mega_m_category_svg_icon",
            "custom_header"
          ]
        }
      },
      {
        "table": {
          "table_name": "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.85",
            "eval_cost": "0.10",
            "prefix_cost": "0.95",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "company_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

category_id parent_id id_path level company_id usergroup_ids status product_count position timestamp is_op localization age_verification age_limit parent_age_verification parent_age_limit selected_views default_view product_details_view product_columns is_trash is_default category_type ss_vendor_categories deleted_at storefront_id lang_code category description meta_keywords meta_description page_title age_warning_message mega_m_category_banner_url mega_m_category_svg_icon custom_header name object_id type dispatch path seo_name seo_path
9936 93 5/93/9936 3 0 0 A 42 50 1637643600 N N 0 N 0 default 0 N N C N 0 en Gift Tags <h2 style="font-size: 18px; color: #333;"> Why should I buy Handmade Gift Tags? </h2> Buying handmade gift tags is a great way to personalize your gift giving. Not only are handcrafted tags made with care and quality, they are also one-of-a-kind pieces of art from artisan makers. They make fantastic keepsakes that your family can treasure for years to come. And still better, buying handcrafted tags helps support independent makers, who worked hard to handpick the materials and design each piece individually. So when you're looking for something special to attach to your gifts this season, think handcrafted – it makes the perfect unique finish to any present! <h2 style="font-size: 18px; color: #333;"> Do Handmade Gift Tags make a Good Gift? </h2> Handmade gift tags make a terrific gift! Not only do handcrafted items have an artisan-like quality that provides for a more unique experience, but they also tend to be longer lasting than store-bought alternatives. Each handcrafted tag can be personalized and tailored to the recipient’s individual interests, while offering an added level of intimacy that mass-produced products simply cannot replicate. Whether you're looking for something special to finish off a gift or just want to show someone how much you care, handmade tags are the perfect way to add that extra dose of love and affection. <h2 style="font-size: 18px; color: #333;"> What’s the difference between Handmade vs Mass-Produced Gift Tags? </h2> The handcrafted approach to creating gift tags is certainly a more special customized option than mass-produced tags. When handcrafted, every gift tag made by an artisan is a unique one of a kind item that you won't find anywhere else. It's personalized touches like these handcrafted gift tags that can really make any present stand out in the happiest of ways! Whether it's hand painted, hand embossed or embellished with precious ribbons, handcrafted gift tags can be truly special and treasured keepsakes for years to come. <h2 style="font-size: 18px; color: #333;"> What is the History of Gift Tags? </h2> Gift tags have been around since the late 19th century, when handcrafted paper tags were used to identify gifts. Over time, they became more than just identifiers: they became miniature works of art created by artisans who used unique materials and distinctive designs to make each one special. Today's gift tags come in a huge variety of styles and can be personalized for an extra touch of thoughtfulness for that special someone. They are no longer just ordinary tags, but reflections of the intricate handiwork produced by skilled craftsmen from all around the world. Shop high-quality handmade gift tags from U.S. artisan creators. View hundreds of unique styles of handcrafted gift tags. Handmade Gift Tags - Handcrafted & Artisan Made - goimagine Handmade Gift Tags gift-tags 9936 c 5/93 gift-tags 5/93