SELECT 
  shop_policies.*, 
  return_policy_descriptions.policy AS return_policy, 
  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 = 'en' 
  LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id 
  AND cscart_vendor_plan_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 401 
  AND cscart_seo_names.type = 'm' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  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 
  LEFT JOIN cscart_return_policies AS return_policies ON return_policies.object_id = companies.company_id 
  AND return_policies.object_type = 'company' 
  LEFT JOIN cscart_return_policy_descriptions AS return_policy_descriptions ON return_policy_descriptions.policy_id = return_policies.policy_id 
  AND return_policy_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_shop_policies AS shop_policies ON shop_policies.company_id = companies.company_id 
  AND shop_policies.lang_code = 'en' 
WHERE 
  companies.company_id = 401

Query time 0.00160

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_discussion_posts",
          "access_type": "system",
          "possible_keys": [
            "thread_id",
            "thread_id_2"
          ],
          "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.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "448"
          },
          "used_columns": [
            "post_id",
            "thread_id",
            "status"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_discussion_rating",
          "access_type": "system",
          "possible_keys": [
            "PRIMARY",
            "thread_id"
          ],
          "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.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "16"
          },
          "used_columns": [
            "rating_value",
            "post_id",
            "thread_id"
          ]
        }
      },
      {
        "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": "15K"
          },
          "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",
            "paypal_commerce_platform_account_id",
            "discreet_shipping",
            "shipstation_enabled",
            "shipstation_fulfillment",
            "shipstation_api_key",
            "shipstation_api_secret",
            "shipstation_api_connected",
            "shipstation_webhook_id",
            "shipstation_store_id",
            "shipstation_warehouse_name",
            "shipstation_warehouse_street1",
            "shipstation_warehouse_street2",
            "shipstation_warehouse_street3",
            "shipstation_warehouse_country",
            "shipstation_warehouse_state",
            "shipstation_warehouse_city",
            "shipstation_warehouse_postal_code",
            "shipstation_warehouse_phone",
            "shipstation_warehouse_residential",
            "shipstation_warehouse_id",
            "shipengine_enabled",
            "shipengine_api_key",
            "shipengine_api_connected",
            "shipengine_webhook_id",
            "shipengine_account_id",
            "shipengine_external_account_id",
            "shipengine_api_key_id",
            "discreet_shipping_shop_name",
            "vacation_mode",
            "vacation_start_date",
            "vacation_end_date",
            "tagline",
            "shopify_token",
            "shopify_link_app",
            "shopify_api_key",
            "shopify_api_secret",
            "stripe_connect_account_id",
            "stripe_connect_account_type",
            "chitchats_enabled",
            "chitchats_client_id",
            "chitchats_api_key",
            "royal_mail_enabled",
            "royal_mail_api_key"
          ]
        }
      },
      {
        "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",
            "terms",
            "i18n_company",
            "i18n_address",
            "i18n_city"
          ]
        }
      },
      {
        "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": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.35",
            "data_read_per_join": "1K"
          },
          "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": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.45",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "thread_id",
            "object_id",
            "object_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "return_policies",
          "access_type": "ref",
          "possible_keys": [
            "object_type"
          ],
          "key": "object_type",
          "used_key_parts": [
            "object_type",
            "object_id"
          ],
          "key_length": "95",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.80",
            "data_read_per_join": "112"
          },
          "used_columns": [
            "policy_id",
            "object_type",
            "object_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "return_policy_descriptions",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "policy_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "cscartdb.return_policies.policy_id",
            "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.90",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "policy_id",
            "policy",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "shop_policies",
          "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": "1.00",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "company_id",
            "lang_code",
            "shop_policies"
          ]
        }
      }
    ]
  }
}

Result

company_id lang_code shop_policies return_policy company_description terms i18n_company i18n_address i18n_city 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 paypal_commerce_platform_account_id discreet_shipping shipstation_enabled shipstation_fulfillment shipstation_api_key shipstation_api_secret shipstation_api_connected shipstation_webhook_id shipstation_store_id shipstation_warehouse_name shipstation_warehouse_street1 shipstation_warehouse_street2 shipstation_warehouse_street3 shipstation_warehouse_country shipstation_warehouse_state shipstation_warehouse_city shipstation_warehouse_postal_code shipstation_warehouse_phone shipstation_warehouse_residential shipstation_warehouse_id shipengine_enabled shipengine_api_key shipengine_api_connected shipengine_webhook_id shipengine_account_id shipengine_external_account_id shipengine_api_key_id discreet_shipping_shop_name vacation_mode vacation_start_date vacation_end_date tagline shopify_token shopify_link_app shopify_api_key shopify_api_secret stripe_connect_account_id stripe_connect_account_type chitchats_enabled chitchats_client_id chitchats_api_key royal_mail_enabled royal_mail_api_key plan seo_name seo_path average_rating company_thread_ids
401 en Please read FAQ and Return Policy before placing your order. Which material do you use for your toys? How safe is it? Our products are meticulously handmade using 100% body-safe, platinum-cured silicone, proudly sourced and manufactured in the USA. Our silicone is free from harmful chemicals, it is non-toxic, hypoallergenic and gentle on sensitive skin. It ensures a comfortable and irritation-free experience. When it comes to your intimate experiences, quality should never be compromised. Are all of your toys made in the USA? All of our toys are made in Brooklyn, USA. All silicone materials are also purchased only through U.S suppliers and third-party inspected for quality assurance. Do your toys vary from the product photos on your website? Yes! Since our toys are handmade and the colors are hand-mixed, there will be slight differences in color properties. Our products are hand poured by artists, each of this product is unique, thus small imperfections in texture, density up to 10% are inherent in the product and are not considered defects. How do you ship your toys? We put our toys in a SinSaint box which goes inside of a standard brown cardboard box. We put a shipping label on a box and it doesn’t say what the package contains exactly. You will see our company name and the name of the toy that has been shipped to you, along with the delivery address. What’s your estimated manufacturing and shipping schedule? It will take between 2-5 business days to manufacture the product before we ship it to you. If you cannot track your order after 5 business days of placing your order, please e-mail us at info@sinsaint.com. Do you ship internationally? Yes, we do! Note: Recipients will be responsible for all duties and taxes incurred upon receipt of shipment. All international packages will be accompanied by an itemized Commercial Invoice to pass through Customs. We will not include any identifying terms such as dildo, anal while describing an item on a slip. Due to the nature of the product, we are unable to accept returns as a general rule. Exceptions may be made however these are considered on a case-by-case basis and must be related to production issues with the toy which were not stipulated on purchase. Any items marked as containing a defect or ‘Flops’ will have a description of the issue relating to the product and all sales are final. No returns and/or refunds will be given for any "Flop" products. When you receive your order it will arrive in a sealed clear bag, we encourage you to inspect it to the best of your ability without opening the clear plastic bag. Opening the bag is acknowledgement that you accept your product as is. Any requested returns, where the bag has been opened, are unlikely to be accepted as we cannot ensure the safety of the product. If you notice any defects before you have opened the bag, please email us with pictures of those defects. No returns or refunds will be accepted on the basis of incorrect ordering a toy firmness or size. All toys which are returned open are disposed of unless there is specific reason why this does not occur. We do not offer discounts or refunds for color on inventory toys. We do our best to capture the color of toys as accurately as possible in the listing pictures, but color may be affected by lighting, background, monitor settings, and perception, so a toy may look slightly different in color than it does in a listing. If you believe a toy does not match the listing pictures and you received the incorrect toy, please contact us and we may be able to exchange it if it is still in the sealed bag. When creating a custom toy, we will make every effort to match the colors you choose, but we cannot color match down to exact shades or hex codes. If you custom a signature color or named color from us be aware that there is variation in pours for each color and no pour will look exactly the same. A named color means that we use the same pigments and the same technique to pour it, but there is still a lot of variation between toys, each one is unique. If you still feel a mistake has been made in your custom, please contact us and provide pictures of the problem so that we may see how we can help remedy it. If your entire package arrived with damage to the outer package that occurred during shipping, please contact shipping carrier ( UPS, FedEx or USPS) for compensation. Our adult toys are meticulously handmade from 100% body-safe, eco-friendly, premium quality silicone proudly sourced and manufactured in the USA. SinSaint 2201 Neptune Ave Brooklyn A SinSaint 2201 Neptune Ave Brooklyn NY US 11224 info@sinsaint.com +16466663348 https://www.etsy.com/people/o6y87z30jx2d5ouq?ref=hdr_user_menu-profile none Y 1723469613 1163 a:4:{s:14:"company_fields";a:8:{i:37;s:4:"Oleg";i:38;s:9:"Semenenko";i:52;s:21:"https://sinsaint.com/";i:58;s:0:"";i:54;s:0:"";i:55;s:82:"https://www.instagram.com/sinsainttoys?igsh=MTJjNHIydGU5cHR2Mw%3D%3D&utm_source=qr";i:56;s:26:"https://x.com/sinsainttoys";i:57;s:37:"https://www.youtube.com/@sinsainttoys";}s:15:"admin_firstname";s:4:"Oleg";s:14:"admin_lastname";s:9:"Semenenko";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:0:"";i:62;s:82:"https://www.instagram.com/sinsainttoys?igsh=MTJjNHIydGU5cHR2Mw%3D%3D&utm_source=qr";i:63;s:26:"https://x.com/sinsainttoys";i:64;s:37:"https://www.youtube.com/@sinsainttoys";}} def502002e1bb4a8cbd287c4c53e55c08771921e5dd19e571a88028a5c63116301c81a811425511778e536638a2197bed37b351ca5b424233f83bf78118e9fe1468d89d3ddac7fdc0e9a274a8bca236232d2759d76a56b177b02bb612345 1 1 N N N 0 0 0 0 MLGNHQ4EMN3KS Y Y Y 136e2533f37b46f7b4e704a0234c1769 26b189c7733c4ccabaa13fdb97d66f94 Y 96424 1033380 N 0 N N 0 SinSaint Inc 0 0 0 SinSaint - High quality handmade sex toys from Brooklyn, USA N N Beta Plan sinsaint 401_0