SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  AND cscart_page_descriptions.lang_code = 'en' 
  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' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  1 
  AND cscart_pages.parent_id IN (7) 
  AND cscart_pages.status IN ('A') 
  AND cscart_pages.page_type IN ('B') 
  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.use_avail_period = 'N' 
    OR (
      cscart_pages.use_avail_period = 'Y' 
      AND cscart_pages.avail_from_timestamp <= 1773288862 
      AND (
        cscart_pages.avail_till_timestamp >= 1773288862 
        OR cscart_pages.avail_till_timestamp = 0
      )
    )
  ) 
ORDER BY 
  cscart_pages.timestamp desc 
LIMIT 
  0, 10

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.04"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_pages",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "parent_id"
            ],
            "key": "parent_id",
            "used_key_parts": [
              "parent_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 10,
            "rows_produced_per_join": 0,
            "filtered": "4.17",
            "cost_info": {
              "read_cost": "0.60",
              "eval_cost": "0.04",
              "prefix_cost": "1.60",
              "data_read_per_join": "1K"
            },
            "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"
            ],
            "attached_condition": "((`gaseus`.`cscart_pages`.`status` = 'A') and (`gaseus`.`cscart_pages`.`page_type` = 'B') and ((`gaseus`.`cscart_pages`.`usergroup_ids` = '') or (0 <> find_in_set(0,`gaseus`.`cscart_pages`.`usergroup_ids`)) or (0 <> find_in_set(1,`gaseus`.`cscart_pages`.`usergroup_ids`))) and ((`gaseus`.`cscart_pages`.`use_avail_period` = 'N') or ((`gaseus`.`cscart_pages`.`use_avail_period` = 'Y') and (`gaseus`.`cscart_pages`.`avail_from_timestamp` <= 1773288862) and ((`gaseus`.`cscart_pages`.`avail_till_timestamp` >= 1773288862) or (`gaseus`.`cscart_pages`.`avail_till_timestamp` = 0)))))"
          }
        },
        {
          "table": {
            "table_name": "cscart_page_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "page_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "gaseus.cscart_pages.page_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.10",
              "eval_cost": "0.04",
              "prefix_cost": "1.75",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "page_id",
              "lang_code",
              "page",
              "description",
              "meta_keywords",
              "meta_description",
              "page_title",
              "link"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_ult_objects_sharing",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "share_object_id",
              "share_company_id",
              "share_object_type"
            ],
            "key_length": "159",
            "ref": [
              "gaseus.cscart_pages.page_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "0.10",
              "eval_cost": "0.04",
              "prefix_cost": "1.89",
              "data_read_per_join": "66"
            },
            "used_columns": [
              "share_company_id",
              "share_object_id",
              "share_object_type"
            ],
            "attached_condition": "(`gaseus`.`cscart_ult_objects_sharing`.`share_object_id` = `gaseus`.`cscart_pages`.`page_id`)"
          }
        },
        {
          "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": [
              "gaseus.cscart_pages.page_id",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.10",
              "eval_cost": "0.04",
              "prefix_cost": "2.04",
              "data_read_per_join": "723"
            },
            "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 lang_code page description meta_keywords meta_description page_title link seo_name seo_path
50 1 7 7/50 A B 0 1757023200 0 0 N 0 0 en Gaseus outlines its future plans for growth and innovation <p><img src="https://test.gaseus.es/images/blog/1/news_3.png?1757068508250"></p> <p>At Gaseus, we believe that building the future of digital procurement requires more than technology &mdash; it requires vision. Today, we want to share some of our upcoming plans that will guide our development over the next months.</p> <p>First, we are expanding our geographic reach. Following successful onboarding of European suppliers, our marketplace will open to new regions, enabling more industrial buyers to access the platform with localized support. This step will allow us to serve EPC contractors and integrators across multiple markets, offering them the same seamless procurement experience.</p> <p>Second, we are preparing to introduce advanced analytics. Real-time dashboards will soon be available to buyers and suppliers, providing instant insights into procurement activity, order status, and spending trends. These tools will not only improve transparency but also empower decision-makers with actionable data.</p> <p>Third, sustainability remains at the core of our mission. Gaseus will implement features that highlight eco-friendly product options and help buyers align their procurement with corporate sustainability goals. By enabling responsible sourcing, we aim to support long-term environmental commitments in the industrial gases sector.</p> <p>These initiatives mark only the beginning. Our commitment is to continue innovating, collaborating, and scaling &mdash; always with the goal of simplifying complex procurement processes while ensuring reliability and compliance for our users.</p> gaseus-outlines-its-future-plans-for-growth-and-innovation 7
49 1 7 7/49 A B 0 1756850400 0 0 N 0 0 en New partnerships: Vulkan and GasTech join Gaseus <p><img src="https://test.gaseus.es/images/blog/1/news_2.png?1757068288692"><br></p> <p>We are pleased to announce that Vulkan and GasTech, two recognized leaders in industrial gas systems, have joined the Gaseus marketplace as partner suppliers. This collaboration represents an important step in expanding the diversity and reliability of products available on our platform.</p> <p>Vulkan is known worldwide for its advanced valve technology, delivering safety and precision in demanding environments. GasTech, on the other hand, specializes in instrumentation and integrated solutions for industrial gases. By bringing their portfolios to Gaseus, both companies open new opportunities for EPC contractors, integrators, and industrial buyers seeking trustworthy suppliers.</p> <p>With this expansion, our marketplace is no longer only a technical solution &mdash; it is also a growing ecosystem of reliable partners. Buyers using Gaseus can now access Vulkan and GasTech products directly through the platform, benefit from transparent pricing, and take advantage of seamless SAP integration.</p> <p>This partnership underlines our mission: to simplify procurement while guaranteeing high-quality engineering solutions. We are confident that working with Vulkan and GasTech will strengthen trust in Gaseus as the preferred channel for sourcing components in the industrial gases sector. Together, we will continue to push boundaries and set new benchmarks for collaboration in the B2B marketplace space.</p> new-partnerships-vulkan-and-gastech-join-gaseus 7
48 1 7 7/48 A B 0 1756677600 0 0 N 0 0 en Gaseus launches service ready for SAP integration <p><img src="https://test.gaseus.es/images/blog/1/news_1.png?1757067991854"><br></p> <p>Gaseus is proud to announce the official launch of its digital marketplace, now fully operational and designed from the ground up to integrate seamlessly with SAP systems. Built on PunchOut/OCI standards, the service allows enterprise procurement teams to work with suppliers directly, without leaving their familiar SAP environment.</p> <p>This milestone is more than a technical achievement. For years, industrial gas system suppliers and buyers have faced inefficiencies: fragmented catalogs, manual uploads, and inconsistent data flows between ERP systems. With Gaseus, those barriers are eliminated. Procurement officers can now browse products, configure solutions, and place orders directly from within SAP. The system automatically synchronizes data, ensuring accuracy in pricing, compliance with corporate policies, and full visibility of transactions.</p> <p>For suppliers, the launch means immediate access to enterprise buyers who demand integration. Instead of adapting their systems individually for each client, suppliers can connect once to Gaseus and become available across multiple industries and EPC contractors.</p> <p>Our focus remains on simplicity, reliability, and compliance. With this launch, Gaseus sets a new standard for digital procurement in the industrial gases sector. We believe that this platform will enable faster sourcing decisions, reduce operational costs, and build long-term trust between buyers and suppliers.</p> gaseus-launches-service-ready-for-sap-integration 7