SELECT 
  DISTINCT(cscart_cp_blog_posts.type) 
FROM 
  cscart_cp_blog_posts 
  INNER JOIN cscart_cp_blog_post_categories ON cscart_cp_blog_post_categories.post_id = cscart_cp_blog_posts.post_id 
  INNER JOIN cscart_cp_blog_categories ON cscart_cp_blog_categories.category_id = cscart_cp_blog_post_categories.category_id 
  AND (
    cscart_cp_blog_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_cp_blog_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_cp_blog_categories.usergroup_ids
    )
  ) 
  AND cscart_cp_blog_categories.status IN ('A', 'H') 
  LEFT JOIN cscart_cp_blog_post_descriptions ON cscart_cp_blog_posts.post_id = cscart_cp_blog_post_descriptions.post_id 
  AND cscart_cp_blog_post_descriptions.lang_code = 'ru' 
  LEFT JOIN cscart_cp_blog_authors ON cscart_cp_blog_authors.author_id = cscart_cp_blog_posts.author_id 
WHERE 
  1 
  AND cscart_cp_blog_posts.status IN ('A') 
  AND cscart_cp_blog_categories.company_id = 1 
  AND (
    cscart_cp_blog_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_cp_blog_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_cp_blog_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_cp_blog_posts.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_cp_blog_posts.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_cp_blog_posts.usergroup_ids
    )
  ) 
  AND (
    cscart_cp_blog_posts.use_avail_period = 'N' 
    OR (
      cscart_cp_blog_posts.use_avail_period = 'Y' 
      AND cscart_cp_blog_posts.avail_from_timestamp <= 1754116224 
      AND (
        IF (
          avail_till_timestamp > 0, avail_till_timestamp, 
          1754116224
        )
      ) >= 1754116224
    )
  ) 
  AND cscart_cp_blog_post_categories.category_id IN (2, 3) 
  AND cscart_cp_blog_posts.timestamp = 1702846800

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "9.08"
    },
    "duplicates_removal": {
      "using_temporary_table": true,
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_cp_blog_authors",
            "access_type": "system",
            "possible_keys": [
              "PRIMARY"
            ],
            "rows_examined_per_scan": 0,
            "rows_produced_per_join": 1,
            "filtered": "0.00",
            "const_row_not_found": true,
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "416"
            },
            "used_columns": [
              "author_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_cp_blog_categories",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 2,
            "rows_produced_per_join": 0,
            "filtered": "20.00",
            "index_condition": "(`44mm_ru`.`cscart_cp_blog_categories`.`category_id` in (2,3))",
            "cost_info": {
              "read_cost": "4.73",
              "eval_cost": "0.08",
              "prefix_cost": "4.81",
              "data_read_per_join": "633"
            },
            "used_columns": [
              "category_id",
              "usergroup_ids",
              "status",
              "company_id"
            ],
            "attached_condition": "((`44mm_ru`.`cscart_cp_blog_categories`.`company_id` = 1) and ((`44mm_ru`.`cscart_cp_blog_categories`.`usergroup_ids` = '') or find_in_set(0,`44mm_ru`.`cscart_cp_blog_categories`.`usergroup_ids`) or find_in_set(1,`44mm_ru`.`cscart_cp_blog_categories`.`usergroup_ids`)) and ((`44mm_ru`.`cscart_cp_blog_categories`.`usergroup_ids` = '') or find_in_set(0,`44mm_ru`.`cscart_cp_blog_categories`.`usergroup_ids`) or find_in_set(1,`44mm_ru`.`cscart_cp_blog_categories`.`usergroup_ids`)) and (`44mm_ru`.`cscart_cp_blog_categories`.`status` in ('A','H')))"
          }
        },
        {
          "table": {
            "table_name": "cscart_cp_blog_posts",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "status"
            ],
            "key": "status",
            "used_key_parts": [
              "status"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 34,
            "rows_produced_per_join": 0,
            "filtered": "2.86",
            "cost_info": {
              "read_cost": "1.40",
              "eval_cost": "0.08",
              "prefix_cost": "8.93",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "post_id",
              "timestamp",
              "status",
              "usergroup_ids",
              "use_avail_period",
              "avail_from_timestamp",
              "avail_till_timestamp",
              "type",
              "author_id"
            ],
            "attached_condition": "((`44mm_ru`.`cscart_cp_blog_posts`.`timestamp` = 1702846800) and ((`44mm_ru`.`cscart_cp_blog_posts`.`usergroup_ids` = '') or find_in_set(0,`44mm_ru`.`cscart_cp_blog_posts`.`usergroup_ids`) or find_in_set(1,`44mm_ru`.`cscart_cp_blog_posts`.`usergroup_ids`)) and ((`44mm_ru`.`cscart_cp_blog_posts`.`use_avail_period` = 'N') or ((`44mm_ru`.`cscart_cp_blog_posts`.`use_avail_period` = 'Y') and (`44mm_ru`.`cscart_cp_blog_posts`.`avail_from_timestamp` <= 1754116224) and (if((`44mm_ru`.`cscart_cp_blog_posts`.`avail_till_timestamp` > 0),`44mm_ru`.`cscart_cp_blog_posts`.`avail_till_timestamp`,1754116224) >= 1754116224))))"
          }
        },
        {
          "table": {
            "table_name": "cscart_cp_blog_post_categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "post_id",
              "category_id"
            ],
            "key_length": "6",
            "ref": [
              "44mm_ru.cscart_cp_blog_posts.post_id",
              "44mm_ru.cscart_cp_blog_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "using_index": true,
            "distinct": true,
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.08",
              "prefix_cost": "9.01",
              "data_read_per_join": "6"
            },
            "used_columns": [
              "post_id",
              "category_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_cp_blog_post_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "post_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "44mm_ru.cscart_cp_blog_posts.post_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "using_index": true,
            "distinct": true,
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.08",
              "prefix_cost": "9.09",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "post_id",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}