SELECT 
  cscart_products.*, 
  cscart_product_descriptions.*, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    CASE WHEN (
      cscart_products_categories.link_type = 'M'
    ) THEN CONCAT(
      cscart_products_categories.category_id, 
      'M'
    ) ELSE cscart_products_categories.category_id END 
    ORDER BY 
      cscart_categories.storefront_id IN (0, 1) DESC, 
      (
        cscart_products_categories.link_type = 'M'
      ) DESC, 
      cscart_products_categories.category_position ASC, 
      cscart_products_categories.category_id ASC
  ) as category_ids, 
  popularity.total as popularity, 
  company_descr.i18n_company as company_name, 
  companies.ec_rfq_whatsapp_number, 
  companies.ec_rfq_phone_number, 
  companies.ec_rfq_bhf, 
  companies.ec_rfq_bht, 
  cscart_product_sales.amount as sales_amount, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_discussion.type as discussion_type, 
  cscart_product_review_prepared_data.average_rating average_rating, 
  cscart_product_review_prepared_data.reviews_count product_reviews_count, 
  cscart_ec_table_booking_system.booking_type as booking_type, 
  cscart_ec_table_booking_system.from_date as from_date, 
  cscart_ec_table_booking_system.to_date as to_date, 
  cscart_ec_table_booking_system.slot_time as slot_time, 
  cscart_ec_table_booking_system.free_time as free_time, 
  cscart_ec_table_booking_system.days_data as days_data, 
  cscart_ec_table_booking_system.quantity_selector as quantity_selector, 
  cscart_ec_table_booking_system.show_price_date as show_price_date, 
  cscart_ec_table_booking_system.blocked_date as blocked_date, 
  cscart_ec_table_booking_system.minimum_booking_time as minimum_booking_time 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  AND cscart_product_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_company_descriptions as company_descr ON company_descr.company_id = cscart_products.company_id 
  AND company_descr.lang_code = 'en' 
  LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id 
  INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_products.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_products.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_products.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_products.status IN ('A', 'H') 
  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id 
  AND cscart_product_sales.category_id = 9709 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 276868 
  AND cscart_seo_names.type = 'p' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id 
  AND cscart_discussion.object_type = 'P' 
  LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id 
  AND cscart_product_review_prepared_data.storefront_id = 0 
  LEFT JOIN cscart_ec_table_booking_system ON cscart_ec_table_booking_system.product_id = cscart_products.product_id 
  AND cscart_ec_table_booking_system.product_id = 276868 
WHERE 
  cscart_products.product_id = 276868 
  AND (
    companies.status IN ('A') 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00265

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.76"
    },
    "grouping_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_products",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "status"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "7K"
            },
            "used_columns": [
              "product_id",
              "product_code",
              "product_type",
              "status",
              "company_id",
              "list_price",
              "amount",
              "weight",
              "length",
              "width",
              "height",
              "shipping_freight",
              "low_avail_limit",
              "timestamp",
              "updated_timestamp",
              "usergroup_ids",
              "is_edp",
              "edp_shipping",
              "unlimited_download",
              "tracking",
              "free_shipping",
              "zero_price_action",
              "is_pbp",
              "is_op",
              "is_oper",
              "is_returnable",
              "return_period",
              "avail_since",
              "out_of_stock_actions",
              "localization",
              "min_qty",
              "max_qty",
              "qty_step",
              "list_qty_count",
              "tax_ids",
              "age_verification",
              "age_limit",
              "options_type",
              "exceptions_type",
              "details_layout",
              "shipping_params",
              "facebook_obj_type",
              "parent_product_id",
              "buy_now_url",
              "master_product_id",
              "master_product_status",
              "master_product_offers_count",
              "prestashop_product_id",
              "prestashop_account_id",
              "prestashop_is_parent",
              "amz_condition",
              "amz_condition_note",
              "amz_product_id",
              "amz_product_id_type",
              "transfer_price",
              "tax_value",
              "ebay_template_id",
              "product_hash",
              "ebay_price",
              "package_type",
              "ebay_status",
              "ebay_override_price",
              "subscription_product",
              "interval",
              "interval_count",
              "ec_rfq_product_type",
              "ec_rfq_service_options"
            ]
          }
        },
        {
          "table": {
            "table_name": "popularity",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "total"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "32"
            },
            "used_columns": [
              "product_id",
              "total"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_product_sales",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "pa"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "product_id"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 0,
            "rows_produced_per_join": 1,
            "filtered": "0.00",
            "unique_row_not_found": true,
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "16"
            },
            "used_columns": [
              "category_id",
              "product_id",
              "amount"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "pt"
            ],
            "key": "pt",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.00",
              "eval_cost": "0.20",
              "prefix_cost": "1.20",
              "data_read_per_join": "16"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type",
              "category_position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "webmarco.cscart_products_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.01",
              "prefix_cost": "1.40",
              "data_read_per_join": "303"
            },
            "used_columns": [
              "category_id",
              "usergroup_ids",
              "status",
              "storefront_id"
            ],
            "attached_condition": "((`webmarco`.`cscart_categories`.`storefront_id` in (0,1)) and ((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` in ('A','H')))"
          }
        },
        {
          "table": {
            "table_name": "cscart_product_prices",
            "access_type": "range",
            "possible_keys": [
              "usergroup",
              "product_id",
              "lower_limit",
              "usergroup_id"
            ],
            "key": "usergroup",
            "used_key_parts": [
              "product_id",
              "usergroup_id",
              "lower_limit"
            ],
            "key_length": "9",
            "rows_examined_per_scan": 2,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "using_join_buffer": "Block Nested Loop",
            "cost_info": {
              "read_cost": "0.10",
              "eval_cost": "0.02",
              "prefix_cost": "1.52",
              "data_read_per_join": "6"
            },
            "used_columns": [
              "product_id",
              "price",
              "percentage_discount",
              "lower_limit",
              "usergroup_id"
            ],
            "attached_condition": "(<if>(found_match(cscart_product_prices), 1, true) and <if>(is_not_null_compl(cscart_product_prices), ((`webmarco`.`cscart_product_prices`.`lower_limit` = 1) and (`webmarco`.`cscart_product_prices`.`product_id` = 276868) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true))"
          }
        },
        {
          "table": {
            "table_name": "cscart_product_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "product_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.02",
              "prefix_cost": "1.54",
              "data_read_per_join": "699"
            },
            "used_columns": [
              "product_id",
              "lang_code",
              "product",
              "shortname",
              "ab__spt_short_name",
              "short_description",
              "full_description",
              "meta_keywords",
              "meta_description",
              "search_words",
              "page_title",
              "age_warning_message",
              "promo_text",
              "ab__custom_product_h1",
              "ebay_title",
              "ebay_description",
              "override",
              "cls_stop_words",
              "ec_rfq_request_btn_text"
            ]
          }
        },
        {
          "table": {
            "table_name": "company_descr",
            "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": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.02",
              "prefix_cost": "1.56",
              "data_read_per_join": "406"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "i18n_company"
            ]
          }
        },
        {
          "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": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.02",
              "prefix_cost": "1.58",
              "data_read_per_join": "975"
            },
            "used_columns": [
              "company_id",
              "status",
              "ec_rfq_whatsapp_number",
              "ec_rfq_phone_number",
              "ec_rfq_bhf",
              "ec_rfq_bht"
            ],
            "attached_condition": "<if>(found_match(companies), ((`webmarco`.`companies`.`status` = 'A') or 0), true)"
          }
        },
        {
          "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": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.10",
              "eval_cost": "0.02",
              "prefix_cost": "1.70",
              "data_read_per_join": "173"
            },
            "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": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.02",
              "prefix_cost": "1.72",
              "data_read_per_join": "2"
            },
            "used_columns": [
              "object_id",
              "object_type",
              "type"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_product_review_prepared_data",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id",
              "storefront_id"
            ],
            "key_length": "7",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.02",
              "prefix_cost": "1.74",
              "data_read_per_join": "1"
            },
            "used_columns": [
              "product_id",
              "storefront_id",
              "average_rating",
              "reviews_count"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_ec_table_booking_system",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "4",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.02",
              "prefix_cost": "1.76",
              "data_read_per_join": "17"
            },
            "used_columns": [
              "product_id",
              "booking_type",
              "quantity_selector",
              "show_price_date",
              "blocked_date",
              "from_date",
              "to_date",
              "slot_time",
              "free_time",
              "days_data",
              "minimum_booking_time"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_ec_table_booking_system), <cache>((276868 = 276868)), true)"
          }
        }
      ]
    }
  }
}

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params facebook_obj_type parent_product_id buy_now_url master_product_id master_product_status master_product_offers_count prestashop_product_id prestashop_account_id prestashop_is_parent amz_condition amz_condition_note amz_product_id amz_product_id_type transfer_price tax_value ebay_template_id product_hash ebay_price package_type ebay_status ebay_override_price subscription_product interval interval_count ec_rfq_product_type ec_rfq_service_options lang_code product shortname ab__spt_short_name short_description full_description meta_keywords meta_description search_words page_title age_warning_message promo_text ab__custom_product_h1 ebay_title ebay_description override cls_stop_words ec_rfq_request_btn_text price category_ids popularity company_name ec_rfq_whatsapp_number ec_rfq_phone_number ec_rfq_bhf ec_rfq_bht sales_amount seo_name seo_path discussion_type average_rating product_reviews_count booking_type from_date to_date slot_time free_time days_data quantity_selector show_price_date blocked_date minimum_booking_time
276868 WM9843BI P A 351 0.00 10 0.000 0 0 0 0.00 0 1653580525 1653580644 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 864336599 Letter N P en Deepway Powder Clay <p><strong>Deepway Powder Clay</strong> </p> <p><br /></p> <ul><li>It is effective against eczema, psoriasis and many dermatological disorders. </li><li>It is significantly effective against allergic diseases (sun, cat etc.). </li><li>It is also very successful in removing acne and acne. </li><li>Removes our body from dead skin </li><li>It removes heavy metals accumulating under the skin from our body. </li><li>It is effective against inflammation in our body. </li><li>Lightens skin color at least 2-3 tones.</li><li>Effective against stress.</li></ul> <p><b>Detailed Information About Deepway® Powder Clay</b></p> <p><b>How Can I Buy The Product</b></p> <p>The product is currently only sold on Trendyol. Click the link below to buy</p> <p><b>Why Deepway® Powder Clay?</b> </p> <ul><li>It is produced from a clay formation with a high content of montmorillonite, which naturally contains six different clay forms (zaherite, anorhite, cristabalite, vermiculite, kaolonite, muscovite). These clay forms, which are in the smectite clay group, are frequently used in the fields of health and cosmetics. Therefore, the Deepway Powder Clay product offers you, the consumers, all the healing effects of the natural combination of six different clay forms. </li><li>We humans come into contact with many toxins in our daily lives. toxins; It can be caused by chemicals such as paint, cleaning materials, materials used in construction, poor quality water and pesticides, toxic fumes released to the outside, low quality processed foods. In particular, substances such as "heavy metal toxins" such as mercury, cadmium, lead and arsenic threaten our health significantly. Calcium bentonite clay, which is a type of volcanic clay, cleans your body by helping to remove most of these toxins from the body, thanks to its negative ion feature. Accordingly, it increases immunity and can reduce inflammation. In addition to its ability to remove toxins from the body, calcium bentonite clay also contains many beneficial minerals for our body. As a matter of fact, bentonite clay; It is known to be rich in minerals such as calcium, magnesium, silica, sodium, copper, iron and potassium. </li></ul> <p><b>How Does Calcium Bentonite Clay Remove Toxins From The Body?</b></p> <p>When Calcium Bentonite Clay emulsifies with water, its negative ion feature becomes active. However, harmful bacteria, toxins and pathogens in our body are all positively charged. Therefore, negatively charged ions attract positively charged ions (harmful bacteria, toxins and pathogens). In addition, calcium bentonite clay has the property of absorbing, enclosing and holding, as well as attracting. In this way, it is not possible to get rid of harmful toxins and pathogens from the clay particles. </p> <p>Calcium bentonite clay has been converted into products that can be taken orally or in forms that can be applied to the skin surface. Calcium bentonite clay adheres to various pathogens and toxins under the skin or on its surface, absorbs them and ensures their removal from the body. When applied topically to the skin, clay can help calm skin infections and speed up the healing time of wounds or eczema, even when prescription antibiotics don't help solve the problem, thanks to its antibiotic-treating abilities. It is used to purify the skin, especially by mixing it with the water in bath tubs. In this way, it cleans toxic substances and protects people from diseases by allowing more oxygen to enter the cells and the body to heal itself. Bentonite clay contains alkalizing minerals that bring the body's pH level to a better balance between acidity and alkalinity, helping blood, saliva and urine become more alkaline, and alkalizes the body. Especially the mouth is one of the most sensitive parts of our body against harmful external invaders such as bacteria and toxins. Calcium bentonite clay; This allows to remove harmful bacteria, fluoride from toothpastes, viruses and heavy metals. It promotes the increase of probiotics in the tooth walls and mouth. In this way, it also contributes to the development of our immunity. Calcium bentonite clay, also called montmorillonite clay, is emerging as a healthy living trend among people who want to detoxify their bodies and develop defenses against diseases. This healing clay has recently become an important market in our country as a reliable product that can be added to any detoxification program in the USA and Europe.</p> <p><br /><br /></p> <p><b>Preparation and Usage of Deepway® Powder Clay:</b></p> <p><b>It Has Two Different Uses</b></p> <ol><li>Usage</li></ol> <p>Depending on the area to be applied, a certain amount of powdered clay is placed in a non-metallic (glass, porcelain or wooden) container and mixed with the same amount of water. Clay, water 2-3 minutes. absorption and homogeneityA mixture is formed. The prepared cure is applied to the desired area and allowed to dry for 12-20 minutes. It is cleaned by washing with warm and plenty of water. </p> <p></p> <p>2. Usage</p> <p>Pour Deepway® powdered clay into a tub filled with water and mix thoroughly. Then enter the tub and wait in the water for at least 30 minutes. Then rinse your body</p> <p></p> <p><br /></p> <p></p> Eci, Barber, Series, Matte , Hold , Hair Wax, skin care, Deepway Powder Clay , yontstore , webmarco It is effective against eczema, psoriasis and many dermatological disorders. Eci, Barber, Series, Matte , Hold , Hair Wax, skin care, Deepway Powder Clay , yontstore , webmarco Deepway Powder Clay 5.68000000 9709M 1597 Yont Store deepway-toz-kil 9697/9701/9709 B