SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_pages.page_id = 254 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'V')

Query time 0.00115

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_pages",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "page_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": "2K"
          },
          "used_columns": [
            "page_id",
            "company_id",
            "parent_id",
            "id_path",
            "status",
            "page_type",
            "position",
            "timestamp",
            "usergroup_ids",
            "localization",
            "new_window",
            "use_avail_period",
            "avail_from_timestamp",
            "avail_till_timestamp",
            "facebook_obj_type",
            "abt__ut2_microdata_schema_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_page_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "page_id",
            "lang_code"
          ],
          "key_length": "9",
          "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": "5K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link",
            "ab__custom_page_h1",
            "page_sitemap"
          ]
        }
      },
      {
        "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": "1.00",
            "eval_cost": "0.20",
            "prefix_cost": "1.20",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

page_id company_id parent_id id_path status page_type position timestamp usergroup_ids localization new_window use_avail_period avail_from_timestamp avail_till_timestamp facebook_obj_type abt__ut2_microdata_schema_type lang_code page description meta_keywords meta_description page_title link ab__custom_page_h1 page_sitemap seo_name seo_path
254 556 0 254 A T 0 1652392800 0 0 N 0 0 activity en Flota <h2 style="color:#000000;">FLEET</h2> <p><br /></p> <p style="color:#000000;font-size:15px;">We are a domestic and international shipping company, developed to provide premium freight services. We have a high-performance fleet and experienced drivers who specialize in the type of car and cargo they work with, so that we can provide a prompt transport service regardless of the nature of the transport or destination.<br /><br />We offer you a fleet of trucks (40 tons, 18 tons, 15 tons, 12 tons, 7.5 tons and 3.5 ton vans), MAN, Scania and Mercedes brands with Schmitz, Kogel or Krone convertible semi-trailers.<br /><br />All our trucks are equipped with a real-time GPS tracking and positioning system. The exact location of the vehicle and the exchange of information allow fast races.</p> <p><br /></p> <h2 style="color:#000000;">Category 40 tons</h2> <p></p> <ul><li style="color:#000000;"><b><b>MEGA</b></b></li></ul> <p style="color:#000000;font-size:15px;">Mega Liner lives up to its name. This is not only due to its useful mega-volume of 100 m3, but also due to its mega-endowments. For example: the 450 mm high hydraulic roof, the rear mounting system for the fastest possible loading / unloading or even the award-winning Multilock - Multiblock cargo insurance system. Thanks to the KTL powder coating system (in the color you require), the Mega Liner does not rust. Guaranteed. And, like all KRONE tarpaulin semi-trailers, Mega Liner also has a cargo insurance certificate regardless of the load. Being a semi-trailer for various uses, the Mega Liner has to face the challenges of every day. That's why KRONE has added many ingenious details. The hydraulic roof can be easily lifted with the help of hydraulic pumps from the 4 corners during loading-unloading operations. The roof rises by 450 mm. Another advantage is that the individual pumps do not require connecting pipes. Automotive containers also fit between the edges of the roof. frontal raising / lowering in 5 steps of height, allowing the adjustment of the total height of the semi-trailer. Multilock frame with anchoring possibilities from 100 to 100 mm. Easy-to-use sliding pillars, height-adjustable side pillars. And tarpaulin stretching systems: everything is done easily and quickly.</p> <table><tbody><tr><td><ul><li style="color:#000000;">L: 13.6</li><li style="color:#000000;">l: 2.45</li><li style="color:#000000;">h: 3.00</li></ul></td><td><ul><li style="color:#000000;">Curtain tarpaulin</li> <li style="color:#000000;">Sliding roof</li> <li style="color:#000000;">Hydraulic roof with 450mm height</li></ul></td></tr></tbody></table> <p><br /></p> <ul> <li style="color:#000000;"><b><b>NORMAL</b></b></li></ul> <p><span style="color:rgb(0,0,0);font-size:15px;">The Profi Liner is definitely a robust semi-trailer, well thought out for any activity. The front wall and rear doors are made of durable steel. And yet the semi-trailer is very light. For this reason, it can transport (almost) anything in conditions of maximum safety, thanks to the cargo insurance system for which KRONE has been awarded.</span><b><br /></b></p> <table><tbody><tr><td><ul><li style="color:#000000;">L: 13.6</li> <li style="color:#000000;">l: 2.45</li> <li style="color:#000000;">h: 2.70</li></ul></td><td><ul><li style="color:#000000;">Curtain tarpaulin</li> <li style="color:#000000;">Sliding roof</li></ul></td></tr></tbody></table> <h2 style="color:#000000;"><b>Category 18 tons</b></h2> <p></p> <ul><li style="color:#000000;"><b><b><b>Van</b></b></b></li></ul> <p style="color:#000000;font-size:15px;">Ready to ship.<b><b><br /></b></b></p> <table><tbody><tr><td><ul><li style="color:#000000;">L: 8.9</li><li style="color:#000000;">l: 2.45</li><li style="color:#000000;">h: 2.70</li></ul></td><td><ul><li style="color:#000000;">Payload: 9 tons</li><li style="color:#000000;">Pneumatic suspension</li></ul></td></tr></tbody></table> <h2 style="color:#000000;">Category 15 tons</h2> <p></p> <ul><li style="color:#000000;"><b><b>Canvas</b></b></li></ul> <p><span style="color:rgb(0,0,0);font-size:15px;">Shutters with shutters + sliding roof.</span><b><br /></b></p> <table><tbody><tr><td><ul><li style="color:#000000;">L: 7.2</li><li style="color:#000000;">l: 2.45</li><li style="color:#000000;">h: 2.50</li></ul></td><td><ul><li style="color:#000000;">Payload: 8 tons</li><li style="color:#000000;">Sliding roof</li></ul></td></tr></tbody></table> <h2 style="color:#000000;"><b>Category 12 tons</b></h2><p></p> <ul><li style="color:#000000;"><b><b><b>Canvas</b></b></b></li></ul> <p><span style="color:rgb(0,0,0);font-size:15px;">Curtain tarpaulin + sliding roof.</span><b><b><br /></b></b></p> <table><tbody><tr><td><ul><li style="color:#000000;">L: 7.2</li><li style="color:#000000;">l: 2.45</li><li style="color:#000000;">h: 2.70</li></ul></td><td><ul><li style="color:#000000;">Pneumatic suspension</li></ul></td></tr></tbody></table> <h2 style="color:#000000;">Category 7.5 tons</h2> <p></p> <ul><li style="color:#000000;"><b><b>Van + Tarpaulin with lift</b></b></li></ul> <p><span style="color:rgb(0,0,0);font-size:15px;">Transport of clothes on hangers and general merchandise.</span><b><br /></b></p> <table><tbody><tr><td><ul><li style="color:#000000;">L: 6-6.8</li><li style="color:#000000;">l: 2.45</li><li style="color:#000000;">h: 2.45-2.8</li></ul></td><td><ul><li style="color:#000000;">Tarpaulin + elevator</li><li style="color:#000000;">Garment transport van</li><li style="color:#000000;">Pneumatic suspension</li></ul></td></tr></tbody></table> <h2 style="color:#000000;"><b>Category 3.5 tons</b></h2> <p></p> <ul><li style="color:#000000;"><b><b><b>VAIN</b></b></b></li></ul> <p><span style="color:rgb(0,0,0);font-size:15px;"></span></p>Express transport<p><b><b><br /></b></b></p> <p><b><b><br /></b></b></p> <p><b><b><br /></b></b></p> <p><b><br /></b></p> <p><br /></p> webmarco, arion srl, transport, europa, urban, interurban, profesionalisti, company, localizare, mercedes, marfuri, international, flota, sofer, Suntem o companie de transport intern şi internaţional, dezvoltată pentru a oferi servicii premium de transport mărfuri. Deținem o flotă performantă şi şoferi experimentaţi care sunt specializaţi pentru tipul de maşina şi încărcătură cu care lucrează, ast FLOTA flota