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 = 6681 
  AND seo_names.type = 'c' 
  AND seo_names.dispatch = '' 
  AND seo_names.lang_code = 'en' 
WHERE 
  categories.category_id = 6681 
  AND (
    categories.usergroup_ids = '' 
    OR FIND_IN_SET(0, categories.usergroup_ids) 
    OR FIND_IN_SET(1, categories.usergroup_ids)
  )

Query time 0.00168

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.98"
    },
    "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.88",
            "eval_cost": "0.10",
            "prefix_cost": "0.98",
            "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
6681 93 5/93/6681 3 0 0 A 17 40 1628740800 N N 0 N 0 default 0 N N C N 0 en Ribbon & Bows <h2 style="font-size: 18px; color: #333;"> Why should I buy Handmade Ribbon & Bows? </h2> <p>Support handcrafted goods and make a uniquely beautiful statement with handcrafted ribbon and bows! Buying handcrafted accessories allows you to add a personal touch to your project or gift. When you buy from an artisan, you purchase goods made with care, offering unique style and quality. Handmade ribbon & bows come in all sorts of delightful colors, textures, and patterns that can give your project or gift the perfect finishing touch. You'll feel great every time you choose a handcrafted item knowing that it was created with love and attention to detail for that special occasion, gift, or project. So whenever possible, show appreciation for artisans by choosing handmade ribbon & bows!</p> <h2 style="font-size: 18px; color: #333;"> Do Handmade Ribbon & Bows make a Good Gift? </h2> <p>Handmade ribbon and bows make an exceptional gift for a special occasion. They are handcrafted by skilled artisans with the utmost attention to detail, making them truly out of the ordinary. As a result, these handcrafted items bring a unique beauty to any present that is sure to be appreciated by friends and loved ones. It's easy to give an unforgettable gift when you choose handcrafted ribbon and bows!</p> <h2 style="font-size: 18px; color: #333;"> What’s the difference between Handmade vs Mass-Produced Ribbon & Bows? </h2> <p>When it comes to gift ribbon and bows, you have two options: handcrafted or mass-produced. As with most things in life, handcrafted pieces tend to be much more special than those made in a large, commercial setting. Handmade bows and ribbons are created with an artisan’s hand and care, reflecting the unique personality of their creator and providing the recipient with a tangible reflection of that creativity. Mass-produced bows and ribbons are usually identical when purchased in bulk, providing less satisfaction at the same cost as handcrafted versions. In summary, handmade ribbons and bows give gifts that special sparkle that let them stand out from the crowd &mdash; making them a great choice for your next gift!</p> <h2 style="font-size: 18px; color: #333;"> What is the History of Ribbon & Bows? </h2> <p>Ribbon and bows have a fascinating and quite elaborate history! Before the sewing machine was invented, handcrafted ribbon and bows were made by hand and often in small batches for their unique beauty. During the 1600s, mills began to mass-produce ribbons, although handcrafted artisan ribbons were still available up until the Industrial Revolution. Ribbon and bows became especially popular during the Victorian era when large hats adorned with colorful trimmings were all the rage. In more recent years, handcrafted ribbons and bows are becoming more sought after due to their craftsmanship as many artisans now create unique designs. Overall, ribbon and bows have quite an interesting history that can be traced back several hundred years!</p> Shop high-quality handmade ribbon & bows from U.S. artisan creators. View hundreds of unique styles of handcrafted ribbon & bows. Handmade Ribbon & Bows - Handcrafted & Artisan Made - goimagine Handmade Ribbon & Bows ribbon-and-bows 6681 c 5/93 ribbon-and-bows 5/93