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

Query time 0.00099

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
6672 92 5/92/6672 3 0 0 A 76 50 1628740800 N N 0 N 0 default 0 N N C N 0 en Anniversary <h2 style="font-size: 18px; color: #333;"> Why should I buy Handmade Anniversary Cards? </h2> <p>If you’re looking for the perfect gift to celebrate your anniversary with that special someone, why not consider handcrafted anniversary cards? Handmade cards are created with individual care and attention by an artisan who takes time to create something truly unique and personal. Not only do handcrafted anniversary cards show thought and effort, but each one carries a story, so you can be sure no two are exactly alike! Every card will be special and remembered, which is what makes them such a great option for showing that special someone just how much you love them.</p> <h2 style="font-size: 18px; color: #333;"> Do Handmade Anniversary Cards make a Good Gift? </h2> <p>An anniversary card handcrafted with love and thoughtfulness is a wonderful gift to celebrate a special milestone. The gift of such an artisan card conveys the sentiment that so much more than a generic store-bought item was chosen, making the gesture all the more meaningful. When taking the time to handcraft something truly unique for your beloved, it speaks volumes about your affection for them and shows that no effort was spared in getting them something that can be cherished for years to come.</p> <h2 style="font-size: 18px; color: #333;"> What’s the difference between Handmade vs Mass-Produced Anniversary Cards? </h2> <p>Anniversary cards are a great way to express your sentiments to a loved one on special occasions. However, there are two main styles in which anniversary cards can be acquired – hand-crafted and mass-produced. Handmade cards are typically created by artisans who have put a lot of thought and care into designing each one with unique details or materials, making it a one-of-a-kind piece. Mass-produced cards, while also lovely, are usually pumped out in large quantities and contain identical messages to other cards on the shelf. Whichever you choose as your go-to anniversary card selection is up to you; handcrafted anniversary cards provide an extra touch that lets the recipient know how much time and effort was put into selecting it specifically for them!</p> <h2 style="font-size: 18px; color: #333;"> What is the History of Anniversary Cards? </h2> <p>Anniversary cards have a long and rich history. They have been sent as tokens of love and affection for centuries, but the practice of handcrafting them began in the 1800s. Specializing in artisanal designs that are hand-crafted with care and attention, you can find thoughtful anniversary cards to commemorate any special occasion. Each card is unique and perfect for conveying your heartfelt sentiments to that special someone. Just like in years past, an anniversary card is still a meaningful way of showing your appreciation for those who are closest to you.</p> Shop high-quality handmade anniversary cards from U.S. artisan creators. View hundreds of unique styles of handcrafted anniversary cards. Handmade Anniversary Cards - Handcrafted & Artisan Made - goimagine Handmade Anniversary Cards anniversary 6672 c 5/92 anniversary 5/92