SELECT 
  company_descriptions.*, 
  companies.*, 
  cscart_vendor_plan_descriptions.plan, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  AVG(
    cscart_discussion_rating.rating_value
  ) AS average_rating, 
  CONCAT(
    companies.company_id, 
    '_', 
    IF (
      cscart_discussion_rating.thread_id, 
      cscart_discussion_rating.thread_id, 
      '0'
    )
  ) AS company_thread_ids 
FROM 
  cscart_companies AS companies 
  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id 
  AND company_descriptions.lang_code = 'pl' 
  LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id 
  AND cscart_vendor_plan_descriptions.lang_code = 'pl' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 236 
  AND cscart_seo_names.type = 'm' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'pl' 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = companies.company_id 
  AND cscart_discussion.object_type = 'M' 
  LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id 
  AND cscart_discussion_posts.status = 'A' 
  LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id 
  AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id 
WHERE 
  companies.company_id = 236

Query time 0.00042

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "3.45"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "companies",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "company_id"
          ],
          "key_length": "4",
          "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": "7K"
          },
          "used_columns": [
            "company_id",
            "status",
            "company",
            "lang_code",
            "address",
            "city",
            "state",
            "country",
            "zipcode",
            "email",
            "phone",
            "url",
            "storefront",
            "secure_storefront",
            "entry_page",
            "redirect_customer",
            "countries_list",
            "timestamp",
            "shippings",
            "logos",
            "request_user_id",
            "request_account_name",
            "request_account_data",
            "tax_number",
            "registered_from_storefront_id",
            "plan_id",
            "pre_moderation",
            "pre_moderation_edit",
            "pre_moderation_edit_vendors",
            "suspend_date",
            "grace_period_start",
            "last_time_suspended",
            "last_debt_notification_time",
            "p24_merchant_id",
            "p24_link",
            "p24_config_data",
            "ss_baselinker_api_allow",
            "ss_deepl_api_allow",
            "ss_shipx_vendor_point",
            "paypal_commerce_platform_account_id",
            "ref_code",
            "stripe_connect_account_id",
            "stripe_connect_account_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "company_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "company_id",
            "lang_code"
          ],
          "key_length": "10",
          "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": "1K"
          },
          "used_columns": [
            "company_id",
            "lang_code",
            "company_description",
            "i18n_company",
            "i18n_address",
            "i18n_city",
            "terms"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_vendor_plan_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "plan_id",
            "lang_code"
          ],
          "key_length": "10",
          "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": "792"
          },
          "used_columns": [
            "plan_id",
            "lang_code",
            "plan"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_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": 2,
          "rows_produced_per_join": 2,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.50",
            "eval_cost": "0.20",
            "prefix_cost": "0.70",
            "data_read_per_join": "3K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_discussion",
          "access_type": "const",
          "possible_keys": [
            "object_id"
          ],
          "key": "object_id",
          "used_key_parts": [
            "object_id",
            "object_type"
          ],
          "key_length": "6",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 2,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.20",
            "prefix_cost": "1.15",
            "data_read_per_join": "48"
          },
          "used_columns": [
            "thread_id",
            "object_id",
            "object_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_discussion_posts",
          "access_type": "ref",
          "possible_keys": [
            "thread_id",
            "thread_id_2"
          ],
          "key": "thread_id",
          "used_key_parts": [
            "thread_id"
          ],
          "key_length": "3",
          "ref": [
            "cscartdevel.cscart_discussion.thread_id"
          ],
          "rows_examined_per_scan": 2,
          "rows_produced_per_join": 4,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "1.00",
            "eval_cost": "0.40",
            "prefix_cost": "2.55",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "post_id",
            "thread_id",
            "status"
          ],
          "attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`cscartdevel`.`cscart_discussion_posts`.`status` = 'A'), true)"
        }
      },
      {
        "table": {
          "table_name": "cscart_discussion_rating",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY",
            "thread_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "post_id"
          ],
          "key_length": "3",
          "ref": [
            "cscartdevel.cscart_discussion_posts.post_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 4,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.50",
            "eval_cost": "0.40",
            "prefix_cost": "3.45",
            "data_read_per_join": "64"
          },
          "used_columns": [
            "rating_value",
            "post_id",
            "thread_id"
          ],
          "attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`cscartdevel`.`cscart_discussion_rating`.`thread_id` = `cscartdevel`.`cscart_discussion`.`thread_id`), true)"
        }
      }
    ]
  }
}

Result

company_id lang_code company_description i18n_company i18n_address i18n_city terms status company address city state country zipcode email phone url storefront secure_storefront entry_page redirect_customer countries_list timestamp shippings logos request_user_id request_account_name request_account_data tax_number registered_from_storefront_id plan_id pre_moderation pre_moderation_edit pre_moderation_edit_vendors suspend_date grace_period_start last_time_suspended last_debt_notification_time p24_merchant_id p24_link p24_config_data ss_baselinker_api_allow ss_deepl_api_allow ss_shipx_vendor_point paypal_commerce_platform_account_id ref_code stripe_connect_account_id stripe_connect_account_type plan seo_name seo_path average_rating company_thread_ids
236 pl <h3><em>Bardzo nam miło, że możemy gościć Cię w miejscu, w którym Twoje zdrowie jest najważniejsze.</em></h3> <p></p> <h2><b>Pozwól, że zaopiekujemy się Tobą. Spełniaj marzenia, a my zajmiemy się Twoim zdrowiem.</b></h2> <p>Aby zadbać o swoje zdrowie, zawsze jest dobry czas. Możemy starzeć się pełni wigoru i w dobrym samopoczuciu, nie tracąc czasu na chodzenie po lekarzach i&nbsp;&nbsp;pieniędzy na lekarstwa. Nawet w dzisiejszych czasach, możemy odżywiać się zdrowo i sprawić, by nasz organizm miał siłę, odporność i potrafił sam się naprawiać.</p> <p>To miejsce gdzie za pomocą 100% czystej, naturalnej żywności funkcjonalnej w postaci SOKU Z TRAWY JĘCZMIENNEJ i ALGI CHLORELLA&nbsp; pyrenoidosa sorokiniana, pomożemy Ci odżywić i oczyścić organizm. Podnieść odporność i witalność. Wspomóc procesy samoleczenia i zwalczyć dolegliwości/choroby</p> Biozielonki.pl <p>1. Dane Sprzedawcy&nbsp;&nbsp;</p> <p>TM Tomasz Maderak&nbsp;&nbsp;<br>ul. Wiktora Heltmana 84A/8, 30-644 Kraków&nbsp;&nbsp;<br>NIP: 6792715797&nbsp;&nbsp;<br>REGON: 523158420&nbsp;&nbsp;<br>E-mail: tomasz.zielonki@gmail.com<br>Telefon: 515-130-007</p> <p>2. Przedmiot działalności&nbsp;&nbsp;<br>Sprzedaż żywności funkcjonalnej (sok z trawy jęczmiennej i chlorella) od producenta Green Ways. Sprzedawca działa jako dystrybutor. W cenie produktów zawarta jest usługa opieki klienta – obejmuje ona dobór, dawkowanie i wsparcie podczas stosowania produktów.</p> <p>3. Miejsce sprzedaży&nbsp;&nbsp;<br><a href="https://oureden.io/pl/marketplace">https://oureden.io/pl/marketpl...</a></p> <p>4. Realizacja zamówień&nbsp;&nbsp;<br>Czas realizacji: 1–5 dni roboczych.&nbsp;&nbsp;<br>Dostawa: kurier lub paczkomat InPost.&nbsp;&nbsp;<br>Płatność: przelew, BLIK.&nbsp;&nbsp;<br>Możliwość wystawienia faktury.</p> <p>5. Zwroty&nbsp;&nbsp;<br>Produkty otwarte nie podlegają zwrotowi.&nbsp;&nbsp;<br>Zamknięte produkty można zwrócić – koszt zwrotu pokrywa kupujący.</p> <p>6. Reklamacje&nbsp;&nbsp;<br>Reklamacje należy kierować do producenta:&nbsp;&nbsp;<br>Green Ways Polska, ul. Prosta 169, 44-200 Rybnik&nbsp;&nbsp;<br>info@gw-int.pl, tel. ‪+48 221 047 660‬</p> <p>7. Dane osobowe&nbsp;&nbsp;<br></p> <p>Dane osobowe (imię, nazwisko, e-mail, telefon) są przetwarzane wyłącznie w celu realizacji zamówienia i świadczenia usługi opieki. Dane nie są przekazywane osobom trzecim poza koniecznością dostawy.</p> A Biozielonki.pl tomasz.zielonki@gmail.com +48 515130007 none Y 1752496865 0 a:4:{s:14:"company_fields";a:9:{i:55;s:1:"1";i:56;s:17:"TM Tomasz Maderak";i:37;s:6:"Tomasz";i:38;s:7:"Maderak";i:60;s:1:"Y";i:61;s:1:"Y";i:62;s:1:"Y";i:54;s:16:"Kiciusiek21k1m.1";i:63;s:0:"";}s:15:"admin_firstname";s:6:"Tomasz";s:14:"admin_lastname";s:7:"Maderak";s:6:"fields";a:0:{}} 1 2 N N N 0 0 0 0 0 Y N acct_1RkliuFv2FsuV4Bf S Standard biozielonki-pl 236_0