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

Query time 0.00119

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.94"
    },
    "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
6713 28 5/28/6713 3 0 0 A 341 10 1628740800 N N 0 N 0 default 0 N N C N 0 en Bridal Gowns & Dresses <h2 style="font-size: 18px; color: #333;"> Why should I buy Handmade Bridal Gowns & Dresses? </h2> Handcrafted bridal gowns & dresses from an artisan offer unique style and quality that's hard to find elsewhere. When you buy handcrafted, you're investing in craftsmanship that’s been thoughtfully created with detailed precision and care. Whether you're looking for something classic, modern, or vintage-inspired, handcrafted gowns come in a variety of beautiful designs that will make you feel confident on your special day. Investing in handcrafted is like buying something more than just a dress - it’s buying into the story of artisans who have put all their heart and effort into creating the perfect wedding look for you. <h2 style="font-size: 18px; color: #333;"> Do Handmade Bridal Gowns & Dresses make a Good Gift? </h2> If you are considering a unique and special gift for someone special, why not consider handcrafted bridal gowns and dresses? Artisans make them with care, love and attention to detail, creating something truly remarkable. Handmade bridal gowns and dresses bring added sentiment too; knowing that it was handcrafted just for the recipient makes the item that much more meaningful. Whether as a wedding gift or an everyday outfit, such handcrafted garments will surely be treasured for many years to come. <h2 style="font-size: 18px; color: #333;"> What’s the difference between Handmade vs Mass-Produced Bridal Gowns & Dresses? </h2> Handmade or handcrafted bridal gowns and dresses offer a unique beauty that is hard to find with mass-produced gowns. An artisan puts their heart and soul into each hand-sewn stitch, lovingly creating an heirloom piece made with true craftsmanship. Not only is the quality of handcrafted pieces typically much higher than store-bought designs, but they are also one of a kind. Just as every bride's love story is special, handcrafted gowns and dresses provide the perfect opportunity for further personalization. From intricate hand beading to exquisite hand-painted laces, handcrafted wedding gowns are ultimately the perfect way to showcase your true beauty on the most important day of your life! <h2 style="font-size: 18px; color: #333;"> What is the History of Bridal Gowns & Dresses? </h2> The history of bridal gowns and dresses is quite fascinating! Gowns for a bride-to-be originated centuries ago when handcrafted, artisan creations were distinctly unique and hand sewn for each special occasion. During the Victorian era, the materials used to create the gowns were more luxurious with French fabrics and English laces accentuating the dress's silhouette. Without a doubt, bridal wear has come a long way from handcrafted designs to more modernized wedding day looks. It's clear that bride-to-be dresses have proven that they cannot be held back by current trends but rather continue to stand the test of time. Shop high-quality handmade bridal gowns & dresses from U.S. artisan creators. View hundreds of unique styles of handcrafted bridal gowns & dresses. Handmade Bridal Gowns & Dresses - Handcrafted & Artisan Made - goimagine Handmade Bridal Gowns & Dresses bridal-gowns 6713 c 5/28 bridal-gowns 5/28