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 = 250 
  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 = 250

Query time 0.00144

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
250 en As these are custom and made to order, we do not accept cancellations if we have started making your product. We sometimes make these the second they come in, and sometimes a few days later. Buyers are responsible for any customs and import taxes that may apply. We are not responsible for delays due to customs. Germany - Verpackungsgesetz (LUCID Packaging Register): In 2019 Germany’s Packaging Act VerpackG came into effect, imposing requirements on online retailers selling to buyers in Germany. The Packaging Act promotes recycling and reuse of packaging materials (e.g. cardboard boxes, tape, and bubble wrap). Twisted Mountain, LLC is registered at the Packaging Register of the Stiftung Zentrale Stelle Verpackungsregister (Foundation Central Agency Packaging Register – ZSVR) with registration number DE2953219273850. My Dual System Licensing partner for the collection, sorting & recycling of the packaging is ACTIVATE by RECLAY. As consumer please ensure that all received packaging is disposed of in the right recycling containers, Blue for all paper & cardboard and Yellow for all plastics. "Fast Shipping" explained We try to stock some of the most popular items. We ship 2 ish times a week. Some of the OMG fast shipping is someone will send in an order 5 mins before we're done packing and we'll get it in that day's shipments. Some items need made. We try to make 2-3 days a week (depends on the week's order levels). It is extremely common to make the orders the night of the day we get the order, sometimes the next night. We try to have things in the mail within 3 +/- 3 days of the order being received. On rare occasions we will have engagements, don't feel well, holiday commitments, etc that push that out but we try - and take pride in fast. Custom and personalized orders: Molds take 10-40 hours each to make production quality, and a lot of money sometimes. Can we make you a custom shape? Technically we could, but no it doesn't make sense to make one off shapes even if you paid the full price we'd charge. Can we make something custom within the existing molds? Yes. We have for example made up custom 9" colossus with suction cup for someone. There can be fees for design / print adapters, etc and we're happy to work with you on what can be done. Can we make custom marbles and pretty colors, etc - yes, we can. Happy to. We do have a proto mold process where the surface texture isn't perfect and has parting seams. We use that to check new shapes and firmness. Depending on what you're after we might be able to. Firmness: We put a lot of effort into finding the just right "squish". The vast majority of people find our squish levels perfect. Unless you know for sure you like super soft or firm, it's a good place to start with the default. Silicone feels firmer the wider it gets. Below about 1.8" diameter we use a 10A silicone. Above about 1.8 we soften the silicone so it feels like thinner 10A does. It's technically softer, but feels closer to "stock". We stock soft (00-50) and firm (20A), and will make you whatever you want. But we don't recommend small diameter things and soft unless you really want to do a lot more guiding the toy in (e.g. pushing super soft in). Due to the intimate nature and being made custom, we do not accept returns even if unopened. Beautiful, comfortable, high end silicone toys to enhance your fun times. Hand made artisanal items made of only the highest quality materials. Small business, but finest quality. We take great pride in making our customers happy. TwistedMountainToys 15050 W 138th St #2846 Olathe A TwistedMountainToys 15050 W 138th St #2846 Olathe KS US 66063 twistedmountaintoys@gmail.com 785-550-1212 https://www.etsy.com/shop/TwistedMountainToys none Y 1720294633 592 a:4:{s:14:"company_fields";a:8:{i:37;s:4:"John";i:38;s:7:"Ledford";i:52;s:0:"";i:58;s:0:"";i:54;s:44:"https://www.facebook.com/twistedmountaintoys";i:55;s:46:"https://www.instagram.com/twistedmountaintoys/";i:56;s:11:"ToysTwisted";i:57;s:0:"";}s:15:"admin_firstname";s:4:"John";s:14:"admin_lastname";s:7:"Ledford";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:44:"https://www.facebook.com/twistedmountaintoys";i:62;s:46:"https://www.instagram.com/twistedmountaintoys/";i:63;s:11:"ToysTwisted";i:64;s:0:"";}} def5020009e9286fb661bbf5bcc4a8c9a30326f9ede44f6a9fd7969ba3aa48783301d7ae62970d2c27df161453b593e404fe016b04c6eba5384bc93f600fa26e9c1e0fe0aa7c327e56ce0971b68c6f1f62a3c80c81f764ad1843c84ed40f 1 1 N N N 0 1722643261 1722643261 1722643261 TPBXX2AG8FN5E Y Y Y 5f298938b5d94d6ead740d025a432e88 ba9de0a555944151b3a5d9f78412ef03 Y 10013 444532 N 0 N AfTn2w7PJ2oZ/1YgX0zfvXCjblf6fYvmyci0x5Ax5Gc Y 0 6658794 bc62f6c7-0cb3-4717-b1d3-9fdb09a142bb 5395762 TMT, LLC 0 0 0 Fun Toys for Adventurous People N N Beta Plan twistedmountaintoys 250_0