SELECT 
  cscart_dosiin_posts.*, 
  cscart_dosiin_post_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_dosiin_posts 
  LEFT JOIN cscart_dosiin_post_categories ON cscart_dosiin_post_categories.post_id = cscart_dosiin_posts.post_id 
  LEFT JOIN cscart_dosiin_categories ON cscart_dosiin_categories.category_id = cscart_dosiin_post_categories.category_id 
  LEFT JOIN cscart_dosiin_post_descriptions ON cscart_dosiin_posts.post_id = cscart_dosiin_post_descriptions.post_id 
  AND cscart_dosiin_post_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_dosiin_posts.post_id 
  AND cscart_seo_names.type = 'b' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_dosiin_posts.post_id = 21 
  AND (
    cscart_dosiin_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_dosiin_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_dosiin_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_dosiin_posts.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_dosiin_posts.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_dosiin_posts.usergroup_ids
    )
  ) 
  AND cscart_dosiin_categories.status IN ('A', 'H') 
  AND cscart_dosiin_posts.status IN ('A', 'H')

Query time 0.00165

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_dosiin_posts",
          "access_type": "const",
          "possible_keys": ["PRIMARY", "status"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["post_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "cscart_dosiin_post_descriptions",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["post_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "cscart_dosiin_post_categories",
          "access_type": "ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["post_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100,
          "using_index": true
        }
      },
      {
        "table": {
          "table_name": "cscart_dosiin_categories",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["category_id"],
          "ref": ["dev_db.cscart_dosiin_post_categories.category_id"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "(cscart_dosiin_categories.usergroup_ids = '' or find_in_set(0,cscart_dosiin_categories.usergroup_ids) or find_in_set(1,cscart_dosiin_categories.usergroup_ids)) and cscart_dosiin_categories.`status` in ('A','H')"
        }
      },
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "206",
          "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
          "ref": ["const", "const", "const", "const"],
          "rows": 2,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_seo_names.`type` = 'b' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
        }
      }
    ]
  }
}

Result

post_id date timestamp separate status localization image_id company_id discussion_type author is_sent sent_timestamp featured usergroup_ids use_avail_period avail_from_timestamp avail_till_timestamp type total_view vote_up name short_description description lang_code page_title post_h2 post_h3 meta_description meta_keywords seo_name seo_path
21 1666160520 1666160520 N A 0 519 D Supper admin N 0 N 0 N 0 0 R 1515 2198 7 Truths That Said You Are a Lucky Person <p>Do you consider yourself to be a lucky person? If not, you should start thinking about it! Luck is one of the most important factors in achieving success. In this blog post, we will discuss nine truths that said you are a lucky person. If you can embrace these truths, you will be on your way to a better life!</p> <p> </p> <p>Do you consider yourself to be a lucky person? If not, you should start thinking about it! Luck is one of the most important factors in achieving success. In this blog post, we will discuss nine truths that said you are a lucky person. If you can embrace these truths, you will be on your way to a better life!</p> <p><br /> <img src="images/7t1.png" alt="7t1" /></p> <h2><strong>You have been blessed with good health.</strong></h2> <p>One of the biggest blessings in life is good health. Not everyone is lucky enough to be healthy, so you should appreciate your good health every day. Make sure to take care of your body by eating healthy foods and exercising regularly.</p> <p><br /> <img src="images/7t2.png" alt="7t2" /></p> <h2><strong>You have been blessed with a good education.</strong></h2> <p>Education is one of the most important things in life. It allows you to learn new things and grow as a person. You should be grateful for the opportunities you have been given to receive a good education. Make sure to use your education to make a positive impact on the world.</p> <p><br /> <img src="images/7t3.png" alt="7t3" /></p> <h2><strong>You have been blessed with a loving family.</strong></h2> <p>A loving family is one of the biggest blessings in life. They are there for you when you need them, and they support you no matter what. You should be grateful for your family, and make sure to spend time with them whenever possible.</p> <p><br /> <img src="images/7t4.png" alt="7t4" /></p> <h2><strong>You have been blessed with a home sweet home.</strong></h2> <p>Everyone is born with different opportunities and advantages. Some people are born into wealthy families, while others are born into poverty. However, it is important to remember that you are not defined by your circumstances at birth. You have the power to change your life for the better!</p> <p><br /> <img src="images/7t5.png" alt="7t5" /></p> <h2><strong>You have been blessed with a good job.</strong></h2> <p>A good job is one of the biggest blessings in life. It allows you to provide for yourself and your family. You should be thankful for the job you have, and make sure to work hard and be a valuable member of your team.</p> <p><br /> <img src="images/7t6.png" alt="7t6" /></p> <h2><strong>You have been blessed with great friends.</strong></h2> <p>A great group of friends is another one of the biggest blessings in life. They are there for you when you need them, and they make life more fun. You should be grateful for your friends, and make sure to stay in touch with them.</p> <p><br /> <img src="images/7t7.png" alt="7t7" /></p> <h2><strong>You have been blessed with a good life.</strong></h2> <p>So far, you have been blessed with many good things in life. You should be grateful for each and every one of them. Remember that luck is a major factor in achieving success. If you can embrace these truths, you will be on your way to a better life!</p> <p><br /> <img src="images/7t8.png" alt="7t8" /></p> en Bạn có bao giờ nghĩ rằng mình là một người may mắn không? Nếu không, hãy bắt đầu thử suy nghĩ về chủ đề này nhé!  Sự may mắn được xem là một trong những lý do để ta đạt đến thành công. Trong bài viết này, chúng ta sẽ đi qua 7 sự thật nói lên việc bạn l trong, những, sống, cuộc, người, việc, được, mình 7-truths-that-said-you-are-a-lucky-person 2