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

Query time 0.00081

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.93"
    },
    "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.83",
            "eval_cost": "0.10",
            "prefix_cost": "0.93",
            "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
92 5 5/92 2 0 0 A 1155 11 1586059200 N N 0 N 0 default 0 N N C N 0 en Greeting Cards <h2 style="font-size: 18px; color: #333;"> Why should I buy Handmade Greeting Cards? </h2> If you're looking to wow a loved one, nothing says it better than hand-crafted greeting cards. Artisan work is worth investing in as every card is unique and full of life. Handmade cards are wrapped up in so much thoughtfulness and love, it's hard not to put a smile on someone's face when they receive one. There may be other cheaper options out there, but if you truly want to make an impact with your carefully selected words inside the card, handcrafted works of art will take your effort way beyond mediocrity. <h2 style="font-size: 18px; color: #333;"> Do Handmade Greeting Cards make a Good Gift? </h2> The perfect gift for anyone on your list may be handcrafted greeting cards. By finding handcrafted or artisanal cards, you can ensure that the recipient receives a truly unique memento of your generosity. While online and store-bought options may be convenient, handmade cards offer much more of a personal touch that is sure to be appreciated. Not only do handcrafted cards show thoughtfulness and kindness, but they also add an artistic touch to any gift-giving occasion. In today’s busy world, handcrafted cards make stand out amidst all the hustle and bustle and will create lasting memories for years to come. <h2 style="font-size: 18px; color: #333;"> What’s the difference between Handmade vs Mass-Produced Greeting Cards? </h2> Greeting cards are a perfect way to tell someone you care, share your well wishes, or celebrate an important event. However, there can be quite a difference between handcrafted greeting cards versus mass-produced ones. Handcrafted cards often have more depth of feeling and emotion, as they're made with love by an artisan with handpicked materials. Also, you know that your handcrafted card is one of a kind; each hand-drawing and design detail adds to its unique character. On the other hand, mass-produced cards will offer convenience and cost-effectiveness but may offer less sentimentality due to their impersonal nature. Either way you choose, handcrafted or mass-produced cards can express your sentiment in different ways! <h2 style="font-size: 18px; color: #333;"> What is the History of Greeting Cards? </h2> Greeting cards have been around for centuries, first handcrafted by artisans to express special relationship to those close to the sender. During Victorian times, hand-made greeting cards with unique designs and decorations became a popular way to communicate warm sentiments and admiration. Greeting cards from this era combined personal sentiments with beautiful hand-drawn illustrations, hand-cut fabrics, lace, ribbon and pressed flowers. Handwritten words of affection could be further conveyed through handcrafted embellishments that were designed as an art form in itself. Today, greeting cards continue to provide a heartfelt way for people to express themselves and are still crafted with the same care and delight found in the early handcrafted pieces! Shop high-quality handmade greeting cards from U.S. artisan creators. View hundreds of unique styles of handcrafted greeting cards. Handmade Greeting Cards - Handcrafted & Artisan Made - goimagine Handmade Greeting Cards greeting-cards 92 c 5 greeting-cards 5