SELECT 
  * 
FROM 
  cscart_vd_vendors 
WHERE 
  id = 186

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_vd_vendors",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

id vendor_type brand_name brand_defination email brand_description website instagram_handle facebook_handle tiktok_handle quality_authenticity plus_sizes region_availability not_mexican_what_country physical_store is_approved status is_special popularity lang_code created_at updated_at
186 E STEPHANIE JERÓNIMO Elegante, versátil, atemporal Ldmi.stephanie@outlook.es STEPHANIE JERÓNIMO es una marca de ropa de diseño minimalista donde se implementan técnicas artesanales, creando una nueva propuesta oaxaqueña al emplear telas de telar de pedal elaboradas dentro del estado de Oaxaca. https://stephaniejeronimo.com/ https://www.instagram.com/stephaniejronimo?igsh=MWt6MzVpcHEzNjU2aA== www.facebook.com/stephaniejronimo https://www.tiktok.com/@stephaniejronimo?_t=8rLlFaGhIxz&_r=1 Oaxaca A A N 335 es 2025-02-17 18:49:42 2025-07-12 17:33:23