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, 
  companies.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_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 = 5427 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 276870 
  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 = 276870 
WHERE 
  cscart_products.product_id = 276870 
  AND (
    companies.status IN ('A') 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00186

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.74"
    },
    "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` = 276870) 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": "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.56",
              "data_read_per_join": "975"
            },
            "used_columns": [
              "company_id",
              "status",
              "company",
              "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.68",
              "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.70",
              "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.72",
              "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.74",
              "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>((276870 = 276870)), 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
276870 WM6599XM P A 351 0.00 10 0.000 0 0 0 0.00 0 1653637825 1653637850 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 320890492 Letter N P en Deepway® Antiaging Mask <p><strong>Deepway® Antiaging Mask</strong></p> <ul><li>Removes wrinkles and delays the effects of aging</li><li>Made with 100% natural oils and nano clays.</li><li>It provides the mineral and oil balance that the skin needs.</li>< li>Tightens the skin and makes it look smooth</li></ul> <p><b>Detailed Information</b> </p> <ul><li>Deepway® Anti-aging clay mask is produced from volcanic clay (calcium bentonite), which naturally contains six different clay forms, and accordingly has a very rich mineral content, and unique phytotherapeutic oils known for their anti-aging properties.</ li><li>Calcium bentonite clay is formed over millions of years as a result of natural geological and biological events such as chemical weathering and alteration of mineral-rich volcanic ash, tuff and lava. Although the number of minerals in it varies, it is a substance and mineral that naturally exists in nature. It is definitely not a chemical substance or compound. On the contrary, it is a natural substance that nature offers as a cure.</li><li>Calcium bentonite's skin-repairing effect and detox feature have been used as a source of healing and beauty by humans for thousands of years, primarily animals. These effects of calcium bentonite clay are due to its mineral richness and thermal, chemical and mechanical properties. As a matter of fact, Hunza Turks living in the region where Karakoram Mountains and Hindu Kush Mountains meet in Gilgit-Baltistan province of Pakistan are known worldwide for their healthy and long life span. Researches of scientists have revealed the importance of bentonite clay regarding the secrets of healthy and long life of Hunza Turks. There are some basic criteria that should be considered in the selection of these oils. These can be summarized as not being adulterated, being cold pressed and meeting the desired quality criteria. In particular, the "cold pressed" oils to be used in the products are at the top of the important quality criteria in ensuring high quality. In this way, vegetable oils will contain high levels of antioxidants, phenolics, phosphatide, carotenoids and plant sterols, vitamins A, D, E and K. These properties of phytotherapeutic oils used in Deepway skin masks are taken into consideration, based on the reasons stated. It has been known to be used for years. It is best used as a restorative and purifying agent in naturopathy. It contains natural minerals and elements that have a very high effect on the body. With aging, our body's capacity to produce minerals decreases and the mineral level in our body naturally decreases. Our skin, which is considered the largest organ of our body, is the part that is most affected by this negative situation and the earliest. Therefore, different agents are needed to provide these minerals and elements apart from water and food. At this point, calcium bentonite clay is an important solution against this problem when applied to the skin thanks to its mineral and elemental richness. In addition, the main known effects of calcium bentonite clay can be listed as follows.</li><li>Calcium bentonite clay is an important detox agent. Calcium bentonite clay absorbs bacteria, heavy metals, and toxins on and under the skin surface and removes them from the body thanks to its negative ion charge. It is delayed.</li><li>By accelerating the blood flow in the capillaries under the skin and feeding our skin, it draws the blood to the surface and helps our skin to be fed better, thus gaining a healthy appearance, preventing and reducing wrinkles.</li><li> Bentonite clay, by bringing the body's pH level to a better balance between acidity and alkalinity, protects our skin from possible skin disorders and ensures the formation of moisture balance.</li><li>Prevents and repairs acne that occurs or may occur on the skin.</li><li> It removes dead skin from the skin. In this way, it contributes to the formation of a smooth and youthful skin.</li><li>It allows the skin to return to its normal color (toning).</li><li>It makes the skin feel more silky and clean.</li><li>Cleansing Thanks to its feature, it contributes to the formation of new cells instead of dead cells and tightens the skin.</li><li>As it is a natural substance, it does not have any side effects. In addition, there is no harm in taking it orally as a food supplement. As a matter of fact, it is coded with the code E558 in the list of food additives and has no known side effects.</li><li>Calcium bentonite clay has a remarkable rejuvenating, relaxing, germ-busting, edema-relieving and pain-reducing effect.</li><li>An allergic effect of calcium bentonite clay has not been observed. Mud application should not be applied to acute inflammations, bleeding organ disorders, tuberculosis, tumors, chronic infections and varicose veins.</li></ul> <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>Use</b></p> <p>When your skin is dry and clean, apply it on your face as a thin layer with the help of hand or brush. Let it dry for 15-20 minutes. While waiting for it to dry, avoid movements such as laughing and talking that will definitely activate your facial muscles. Clean by washing with lukewarm water. You can use it twice a week depending on the skin's needs. Since it has a moisturizing feature, you may not feel the need for a moisturizer for a while. </p> <p><b>Content</b> </p> <ul><li>Bentonite Clay</li><li>Aloa Vera</li><li>Vitamin E</li><li>Almond Oil</li><li>Jojoba Oil</li><li >Argan Oil</li><li>Grape Seed Oil</li><li>Herbal Preservative</li></ul> <p><b>Features</b> </p> <ul><li>Providing the necessary minerals for our skin</li><li>Fighting premature aging and wrinkles,</li><li>Eczema, acne, acne etc. It is aimed to eliminate skin disorders,</li><li>It is aimed to make our skin look tighter, smoother and brighter.</li><li>It is suitable for all skin types</li></ul> <p><br /></p> Eci, Barber, Series, Matte , Hold , Hair Wax, skin care, personal care, mask, anti age, yontstore , webmarco It removes wrinkles and delays the effects of aging. Made with 100% natural oils and nano clays. Eci, Barber, Series, Matte , Hold , Hair Wax, skin care, personal care, mask, anti age, yontstore , webmarco Deepway® Antiaging Mask 5.68000000 5427M 2253 Yont Store deepway-antiaging-maske 4001/4003/4525/4857/5427 B