SELECT 
  cscart_company_descriptions.*, 
  cscart_companies.*, 
  p.price, 
  p.periodicity, 
  p.commission, 
  p.products_limit, 
  p.revenue_limit, 
  p.vendor_store, 
  p.categories, 
  p.storefronts 
FROM 
  cscart_companies 
  LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id 
  AND cscart_company_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_vendor_plans p ON p.plan_id = cscart_companies.plan_id 
WHERE 
  cscart_companies.company_id IN('466') 
ORDER BY 
  cscart_companies.company_id asc 
LIMIT 
  0, 1

Query time 0.00075

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "ordering_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "9K"
            },
            "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",
              "pre_moderation",
              "pre_moderation_edit",
              "pre_moderation_edit_vendors",
              "plan_id",
              "sd_vendor_helper",
              "identifier_facebook_pixel",
              "stripe_connect_account_id",
              "tax_number",
              "facebook_pixel_id",
              "facebook_api_token",
              "handling_time_us",
              "handling_time_uk",
              "handling_time_it",
              "handling_time_in",
              "handling_time_mx",
              "handling_time_es",
              "handling_time_de",
              "handling_time_fr",
              "handling_time_cn",
              "handling_time_ca",
              "handling_time_jp",
              "handling_time",
              "blocked_date",
              "booking_data",
              "stripe_connect_account_type",
              "registered_from_storefront_id",
              "ec_rfq_whatsapp_number",
              "ec_rfq_phone_number",
              "ec_rfq_bhf",
              "ec_rfq_bht",
              "sd_ga_tracking_code",
              "sd_ga_api_secret"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "company_description",
              "terms",
              "meta_keywords",
              "meta_description",
              "page_title",
              "i18n_company",
              "i18n_address",
              "i18n_city"
            ]
          }
        },
        {
          "table": {
            "table_name": "p",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "plan_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "80"
            },
            "used_columns": [
              "plan_id",
              "price",
              "periodicity",
              "commission",
              "products_limit",
              "revenue_limit",
              "vendor_store",
              "categories",
              "storefronts"
            ]
          }
        }
      ]
    }
  }
}

Result

company_id lang_code company_description terms meta_keywords meta_description page_title 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 pre_moderation pre_moderation_edit pre_moderation_edit_vendors plan_id sd_vendor_helper identifier_facebook_pixel stripe_connect_account_id tax_number facebook_pixel_id facebook_api_token handling_time_us handling_time_uk handling_time_it handling_time_in handling_time_mx handling_time_es handling_time_de handling_time_fr handling_time_cn handling_time_ca handling_time_jp handling_time blocked_date booking_data stripe_connect_account_type registered_from_storefront_id ec_rfq_whatsapp_number ec_rfq_phone_number ec_rfq_bhf ec_rfq_bht sd_ga_tracking_code sd_ga_api_secret price periodicity commission products_limit revenue_limit vendor_store categories storefronts
466 sq <p><br /></p> <div class="text"> <p><br /></p> <p style="font-size:45px;" class="text-center"><span style="color:rgb(0,0,0);"><strong>Sallon Beautiful Lili</strong></span></p><p><br /></p> <div class="row-fluid"> <div class="span8"> <p style="font-size:25px;" class="far fa-check-circle"> <strong><span style="color:rgb(0,0,0);">Beautiful Lily Salon</span></strong> believes that the most important thing     a woman can have, after talent, is her hairdresser & beautician.</p> <p style="font-size:25px;" class="far fa-check-circle"> Give your look more     charm and renew your look!</p> <p style="font-size:25px;" class="far fa-check-circle"> We ensure that our customers remain satisfied with     the wide range of services we offer.</p> <p style="font-size:25px;" class="far fa-check-circle"> In our salon you will find professionalism and     comfortable facilities.</p> </div> <div class="span7"> <p><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2864%29.png?1640162661808" alt="Untitled%20design%20%2864%29.png?1640162661808" /></p><p><br /></p> </div> </div> <div class="row-fluid"> <div class="span4"> <p><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2866%29.png?1640163705572" alt="Untitled%20design%20%2866%29.png?1640163705572" /></p></div> <div class="span4"> <p><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2867%29.png?1640163789098" alt="Untitled%20design%20%2867%29.png?1640163789098" /></p></div> <div class="span4"> <p><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2868%29.png?1640163844098" alt="Untitled%20design%20%2868%29.png?1640163844098" /></p></div> <div class="span4"> <p><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2869%29.png?1640163880849" alt="Untitled%20design%20%2869%29.png?1640163880849" /></p><p><br /></p></div> </div> <div class="row-fluid"> <div class="span4"> <p style="font-size:25px;"> <span style="color:rgb(0,0,0);"><strong> Hairdressing</strong></span></p><p><strong> </strong></p><p style="font-size:20px;"><span style="color:rgb(0,0,0);">1. Cutting</span></p> <p style="font-size:20px;">2. Combing</p> <p style="font-size:20px;">3. Colouring</p> <p style="font-size:20px;">4. Hair with strands,<br /> balayge, ombre, and <br />any new trend</p> <p style="font-size:20px;">5. Makeup</p> <p style="font-size:20px;">6. Extensions</p> <p style="font-size:20px;">7. Styling</p> <p style="font-size:20px;">8. Bride arrangements</p> </div><strong> </strong><div class="span4"><strong> </strong><p style="font-size:25px;"><strong> <strong><span style="color:rgb(0,0,0);">Facial Treatments</span></strong></strong></p><strong> </strong><p style="font-size:20px;"><strong>1. Deep cleaning</strong></p><strong> </strong><p style="font-size:20px;"><strong>2. Microdermabrasion</strong></p><strong> </strong><p style="font-size:20px;"><strong>3. Microneedling (dermapen)</strong></p><strong> </strong><p style="font-size:20px;"><strong>4. Plexr (plasma pen)</strong></p><strong> </strong><p style="font-size:20px;"><strong>5. Treatments with different vitamins</strong></p><strong> </strong><p style="font-size:20px;"><strong>6. Pmu powder brow tattoo, eyebrows, brush, lip</strong></p><strong> </strong><p style="font-size:20px;"><strong>7. Microblading</strong></p><strong> </strong><p style="font-size:20px;"><strong>8. Lashes extensions, eyebrow lamination, lashes lifting</strong></p><strong> </strong></div><strong> </strong><div class="span4"><strong> </strong><p style="font-size:25px;"><strong> <strong><span style="color:rgb(0,0,0);">Care For Nails</span></strong></strong></p><strong> </strong><p style="font-size:20px;"><strong>1. Manicure</strong></p><strong> </strong><p style="font-size:20px;"><strong>2. Pedicure</strong></p><strong> </strong><p style="font-size:20px;"><strong>4. Nails with gel & acrylic</strong></p><strong> </strong><p style="font-size:20px;"><strong>5. Different designs</strong></p><strong> </strong><p><strong><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2865%29.png?1640162914536" alt="Untitled%20design%20%2865%29.png?1640162914536" /></strong></p><strong> </strong></div><strong> </strong><div class="span4"><strong> </strong><p style="font-size:25px;"><strong> <strong><span style="color:rgb(0,0,0);">Aesthetic</span></strong></strong></p><strong> </strong><p style="font-size:20px;"><strong>1. Body treatments</strong></p><strong> </strong><p style="font-size:20px;"><strong>2. Massages</strong></p><strong> </strong><p style="font-size:20px;"><strong>3. Scrub</strong></p><strong> </strong><p style="font-size:20px;"><strong>4. Slimming session</strong></p><strong> </strong><p><strong><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2870%29.png?1640164669568" alt="Untitled%20design%20%2870%29.png?1640164669568" /></strong></p><strong> </strong></div><strong> </strong></div><strong> </strong><p><strong><br /><br /></strong></p><strong></strong><p><strong><br /></strong></p><strong> </strong><div class="row-fluid"><strong> </strong><div class="span4"><strong> </strong><p><strong><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2871%29.png?1640164815640" alt="Untitled%20design%20%2871%29.png?1640164815640" /></strong></p><strong></strong></div><strong> </strong><div class="span4"><strong> </strong><p><strong><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2872%29.png?1640165042263" alt="Untitled%20design%20%2872%29.png?1640165042263" /></strong></p><strong></strong></div><strong> </strong><div class="span4"><strong> </strong><p><strong><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2873%29.png?1640165146534" alt="Untitled%20design%20%2873%29.png?1640165146534" /></strong></p><strong></strong></div><strong> </strong><div class="span4"><strong> </strong><p><strong><img src="https://webmarco.com/images/NewFolder%203/Untitled%20design%20%2874%29.png?1640165236436" alt="Untitled%20design%20%2874%29.png?1640165236436" /></strong></p><strong></strong></div><strong> </strong></div><strong> </strong></div> Sallon Beautiful Lili, haircuts, combing, dyeing, hair, balayge, ombre, new trend, fashionable, Makeup, AESTHETIC extensions, body treatments, slimming sessions, FACE TREATMENTS, Microblading, Lashes extensions, Manicure, pedicure, webmarco Sallon Beautiful Lili believes that the most important thing a woman can have, after her talent, is her hairdresser & beautician. Sallon Beautiful Lili - Quality, accuracy and dedication! Sallon Beautiful Lili Vojo Kushi Rruga Qemal Draçini Shkodër A Sallon Beautiful Lili Vojo Kushi Rruga Qemal Draçini Shkodër AL-10 AL 4001 lilianabrahimi@yahoo.com 0696178190 https://parukeriestetiklili.com/? none Y 1639739715 0 N N N 13 257615252 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 12.20 0 0.00 1