Symfony Profiler

SELECT
  t0.path AS path_1,
  t0.alias AS alias_2,
  t0.primary_path AS primary_path_3,
  t0.type AS type_4,
  t0.method AS method_5,
  t0.id AS id_6,
  t0.uuid AS uuid_7,
  t0.active AS active_8,
  t0.locale_code AS locale_code_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  path_alias t0
WHERE
  t0.path = ?
  AND t0.locale_code = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.path AS path_1, t0.alias AS alias_2, t0.primary_path AS primary_path_3, t0.type AS type_4, t0.method AS method_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM path_alias t0 WHERE t0.path = '/desktop-ssd-upgrades/microstar-msi/microstar-msi-ms-desktop' AND t0.locale_code = 'en' AND t0.active = 1 LIMIT 1;

SELECT
  n0_.id AS id_0
FROM
  node n0_
  LEFT JOIN core_node c1_ ON n0_.id = c1_.id
  LEFT JOIN page_node p2_ ON n0_.id = p2_.id
  LEFT JOIN series_node s3_ ON n0_.id = s3_.id
  LEFT JOIN seriesssd_node s4_ ON n0_.id = s4_.id
  LEFT JOIN model_node m5_ ON n0_.id = m5_.id
  LEFT JOIN modelssd_node m6_ ON n0_.id = m6_.id
  LEFT JOIN component_page_node c7_ ON n0_.id = c7_.id
  LEFT JOIN product_node p8_ ON n0_.id = p8_.id
  LEFT JOIN filter_page_node f9_ ON n0_.id = f9_.id
  LEFT JOIN article_node a10_ ON n0_.id = a10_.id
  LEFT JOIN article_taxonomy_node a11_ ON n0_.id = a11_.id
  LEFT JOIN article_tag_node a12_ ON n0_.id = a12_.id
  LEFT JOIN generic_node g13_ ON n0_.id = g13_.id
  LEFT JOIN help_topic_node h14_ ON n0_.id = h14_.id
  LEFT JOIN help_article_node h15_ ON n0_.id = h15_.id
  LEFT JOIN model_category_node m16_ ON n0_.id = m16_.id
  LEFT JOIN model_categoryssd_node m17_ ON n0_.id = m17_.id
  LEFT JOIN model_category_brand_node m18_ ON n0_.id = m18_.id
  LEFT JOIN model_category_brandssd_node m19_ ON n0_.id = m19_.id
  LEFT JOIN oem_part_page_node o20_ ON n0_.id = o20_.id
  LEFT JOIN oem_brand_node o21_ ON n0_.id = o21_.id
  LEFT JOIN oem_model_node o22_ ON n0_.id = o22_.id
  LEFT JOIN oem_category_node o23_ ON n0_.id = o23_.id
  LEFT JOIN oem_brand_category_node o24_ ON n0_.id = o24_.id
WHERE
  n0_.id = ?

SELECT n0_.id AS id_0 FROM node n0_ LEFT JOIN core_node c1_ ON n0_.id = c1_.id LEFT JOIN page_node p2_ ON n0_.id = p2_.id LEFT JOIN series_node s3_ ON n0_.id = s3_.id LEFT JOIN seriesssd_node s4_ ON n0_.id = s4_.id LEFT JOIN model_node m5_ ON n0_.id = m5_.id LEFT JOIN modelssd_node m6_ ON n0_.id = m6_.id LEFT JOIN component_page_node c7_ ON n0_.id = c7_.id LEFT JOIN product_node p8_ ON n0_.id = p8_.id LEFT JOIN filter_page_node f9_ ON n0_.id = f9_.id LEFT JOIN article_node a10_ ON n0_.id = a10_.id LEFT JOIN article_taxonomy_node a11_ ON n0_.id = a11_.id LEFT JOIN article_tag_node a12_ ON n0_.id = a12_.id LEFT JOIN generic_node g13_ ON n0_.id = g13_.id LEFT JOIN help_topic_node h14_ ON n0_.id = h14_.id LEFT JOIN help_article_node h15_ ON n0_.id = h15_.id LEFT JOIN model_category_node m16_ ON n0_.id = m16_.id LEFT JOIN model_categoryssd_node m17_ ON n0_.id = m17_.id LEFT JOIN model_category_brand_node m18_ ON n0_.id = m18_.id LEFT JOIN model_category_brandssd_node m19_ ON n0_.id = m19_.id LEFT JOIN oem_part_page_node o20_ ON n0_.id = o20_.id LEFT JOIN oem_brand_node o21_ ON n0_.id = o21_.id LEFT JOIN oem_model_node o22_ ON n0_.id = o22_.id LEFT JOIN oem_category_node o23_ ON n0_.id = o23_.id LEFT JOIN oem_brand_category_node o24_ ON n0_.id = o24_.id WHERE n0_.id = 536439;

SELECT
  n0_.node_type AS node_type_0,
  n0_.system_managed AS system_managed_1,
  n0_.id AS id_2,
  n0_.uuid AS uuid_3,
  n0_.created_at AS created_at_4,
  n0_.updated_at AS updated_at_5,
  n0_.handle AS handle_6,
  s1_.top_level AS top_level_7,
  s1_.popular AS popular_8,
  s1_.other AS other_9,
  s1_.id AS id_10,
  s1_.uuid AS uuid_11,
  s1_.created_at AS created_at_12,
  s1_.updated_at AS updated_at_13,
  s1_.handle AS handle_14,
  s1_.active AS active_15,
  s1_.materialized_path AS materialized_path_16,
  s1_.legacy_id AS legacy_id_17,
  s1_.legacy_secondary_id AS legacy_secondary_id_18,
  s1_.legacy_data AS legacy_data_19,
  s1_.legacy_duplicate_handle AS legacy_duplicate_handle_20,
  s1_.allow_node_generation AS allow_node_generation_21,
  s1_.display_memory_modules AS display_memory_modules_22,
  s1_.display_ssds AS display_ssds_23,
  s2_.id AS id_24,
  s2_.name AS name_25,
  s2_.path_hint AS path_hint_26,
  s2_.active AS active_27,
  s2_.description AS description_28,
  s2_.description_chatgpt AS description_chatgpt_29,
  s2_.display_ai_description AS display_ai_description_30,
  s2_.main_title AS main_title_31,
  s2_.page_title AS page_title_32,
  s2_.page_description AS page_description_33,
  s2_.allow_robots_index AS allow_robots_index_34,
  s2_.allow_robots_follow AS allow_robots_follow_35,
  s2_.additional_meta_tags AS additional_meta_tags_36,
  s2_.locale AS locale_37,
  s3_.id AS id_38,
  s3_.short_name AS short_name_39,
  s3_.name AS name_40,
  s3_.description AS description_41,
  s3_.legacy_url_slug AS legacy_url_slug_42,
  s3_.locale AS locale_43,
  b4_.popular AS popular_44,
  b4_.id AS id_45,
  b4_.uuid AS uuid_46,
  b4_.created_at AS created_at_47,
  b4_.updated_at AS updated_at_48,
  b4_.handle AS handle_49,
  b4_.active AS active_50,
  b4_.legacy_id AS legacy_id_51,
  m5_.popular AS popular_52,
  m5_.id AS id_53,
  m5_.uuid AS uuid_54,
  m5_.created_at AS created_at_55,
  m5_.updated_at AS updated_at_56,
  m5_.handle AS handle_57,
  m5_.active AS active_58,
  m5_.legacy_id AS legacy_id_59,
  m5_.legacy_secondary_id AS legacy_secondary_id_60,
  m5_.legacy_data AS legacy_data_61,
  m5_.legacy_url_slug AS legacy_url_slug_62,
  m5_.allow_node_generation AS allow_node_generation_63,
  m5_.display_memory_modules AS display_memory_modules_64,
  m5_.display_ssds AS display_ssds_65,
  m6_.file_name AS file_name_66,
  m6_.file_uri AS file_uri_67,
  m6_.file_mime AS file_mime_68,
  m6_.file_size AS file_size_69,
  m6_.status AS status_70,
  m6_.id AS id_71,
  m6_.uuid AS uuid_72,
  m6_.active AS active_73,
  m6_.locale_code AS locale_code_74,
  d7_.icon_uri AS icon_uri_75,
  d7_.id AS id_76,
  d7_.uuid AS uuid_77,
  d7_.handle AS handle_78,
  d7_.legacy_id AS legacy_id_79,
  n0_.discr AS discr_80,
  s8_.series_entity_id AS series_entity_id_81,
  s8_.help_topic_id AS help_topic_id_82,
  s1_.brand_id AS brand_id_83,
  s1_.series_image_id AS series_image_id_84,
  s1_.model_category_brand_id AS model_category_brand_id_85,
  s1_.device_type_id AS device_type_id_86,
  s2_.translatable_id AS translatable_id_87,
  s3_.translatable_id AS translatable_id_88,
  b4_.brand_logo_id AS brand_logo_id_89,
  m5_.model_category_id AS model_category_id_90,
  m5_.brand_id AS brand_id_91,
  m5_.device_type_id AS device_type_id_92
FROM
  seriesssd_node s8_
  INNER JOIN node n0_ ON s8_.id = n0_.id
  LEFT JOIN series s1_ ON s8_.series_entity_id = s1_.id
  LEFT JOIN seriesssd_node_translation s2_ ON s8_.id = s2_.translatable_id
  AND (s2_.locale = ?)
  LEFT JOIN series_translation s3_ ON s1_.id = s3_.translatable_id
  AND (s3_.locale = ?)
  LEFT JOIN brand b4_ ON s1_.brand_id = b4_.id
  LEFT JOIN model_category_brand m5_ ON s1_.model_category_brand_id = m5_.id
  LEFT JOIN managed_file m6_ ON s1_.series_image_id = m6_.id
  LEFT JOIN device_type d7_ ON s1_.device_type_id = d7_.id
WHERE
  n0_.id = ?

SELECT n0_.node_type AS node_type_0, n0_.system_managed AS system_managed_1, n0_.id AS id_2, n0_.uuid AS uuid_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, n0_.handle AS handle_6, s1_.top_level AS top_level_7, s1_.popular AS popular_8, s1_.other AS other_9, s1_.id AS id_10, s1_.uuid AS uuid_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.handle AS handle_14, s1_.active AS active_15, s1_.materialized_path AS materialized_path_16, s1_.legacy_id AS legacy_id_17, s1_.legacy_secondary_id AS legacy_secondary_id_18, s1_.legacy_data AS legacy_data_19, s1_.legacy_duplicate_handle AS legacy_duplicate_handle_20, s1_.allow_node_generation AS allow_node_generation_21, s1_.display_memory_modules AS display_memory_modules_22, s1_.display_ssds AS display_ssds_23, s2_.id AS id_24, s2_.name AS name_25, s2_.path_hint AS path_hint_26, s2_.active AS active_27, s2_.description AS description_28, s2_.description_chatgpt AS description_chatgpt_29, s2_.display_ai_description AS display_ai_description_30, s2_.main_title AS main_title_31, s2_.page_title AS page_title_32, s2_.page_description AS page_description_33, s2_.allow_robots_index AS allow_robots_index_34, s2_.allow_robots_follow AS allow_robots_follow_35, s2_.additional_meta_tags AS additional_meta_tags_36, s2_.locale AS locale_37, s3_.id AS id_38, s3_.short_name AS short_name_39, s3_.name AS name_40, s3_.description AS description_41, s3_.legacy_url_slug AS legacy_url_slug_42, s3_.locale AS locale_43, b4_.popular AS popular_44, b4_.id AS id_45, b4_.uuid AS uuid_46, b4_.created_at AS created_at_47, b4_.updated_at AS updated_at_48, b4_.handle AS handle_49, b4_.active AS active_50, b4_.legacy_id AS legacy_id_51, m5_.popular AS popular_52, m5_.id AS id_53, m5_.uuid AS uuid_54, m5_.created_at AS created_at_55, m5_.updated_at AS updated_at_56, m5_.handle AS handle_57, m5_.active AS active_58, m5_.legacy_id AS legacy_id_59, m5_.legacy_secondary_id AS legacy_secondary_id_60, m5_.legacy_data AS legacy_data_61, m5_.legacy_url_slug AS legacy_url_slug_62, m5_.allow_node_generation AS allow_node_generation_63, m5_.display_memory_modules AS display_memory_modules_64, m5_.display_ssds AS display_ssds_65, m6_.file_name AS file_name_66, m6_.file_uri AS file_uri_67, m6_.file_mime AS file_mime_68, m6_.file_size AS file_size_69, m6_.status AS status_70, m6_.id AS id_71, m6_.uuid AS uuid_72, m6_.active AS active_73, m6_.locale_code AS locale_code_74, d7_.icon_uri AS icon_uri_75, d7_.id AS id_76, d7_.uuid AS uuid_77, d7_.handle AS handle_78, d7_.legacy_id AS legacy_id_79, n0_.discr AS discr_80, s8_.series_entity_id AS series_entity_id_81, s8_.help_topic_id AS help_topic_id_82, s1_.brand_id AS brand_id_83, s1_.series_image_id AS series_image_id_84, s1_.model_category_brand_id AS model_category_brand_id_85, s1_.device_type_id AS device_type_id_86, s2_.translatable_id AS translatable_id_87, s3_.translatable_id AS translatable_id_88, b4_.brand_logo_id AS brand_logo_id_89, m5_.model_category_id AS model_category_id_90, m5_.brand_id AS brand_id_91, m5_.device_type_id AS device_type_id_92 FROM seriesssd_node s8_ INNER JOIN node n0_ ON s8_.id = n0_.id LEFT JOIN series s1_ ON s8_.series_entity_id = s1_.id LEFT JOIN seriesssd_node_translation s2_ ON s8_.id = s2_.translatable_id AND (s2_.locale = 'en') LEFT JOIN series_translation s3_ ON s1_.id = s3_.translatable_id AND (s3_.locale = 'en') LEFT JOIN brand b4_ ON s1_.brand_id = b4_.id LEFT JOIN model_category_brand m5_ ON s1_.model_category_brand_id = m5_.id LEFT JOIN managed_file m6_ ON s1_.series_image_id = m6_.id LEFT JOIN device_type d7_ ON s1_.device_type_id = d7_.id WHERE n0_.id = 536439;

SELECT
  t1.node_type AS node_type_2,
  t1.system_managed AS system_managed_3,
  t1.id AS id_4,
  t1.uuid AS uuid_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.handle AS handle_8,
  t0.series_entity_id AS series_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  series_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.series_entity_id = ?

SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.series_entity_id AS series_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM series_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.series_entity_id = 3734;

SELECT
  t0.total AS total_1,
  t0.id AS id_2,
  t0.brand_id AS brand_id_3
FROM
  models_upgraded t0
WHERE
  t0.brand_id = ?

SELECT t0.total AS total_1, t0.id AS id_2, t0.brand_id AS brand_id_3 FROM models_upgraded t0 WHERE t0.brand_id = 151;

SELECT
  t1.node_type AS node_type_2,
  t1.system_managed AS system_managed_3,
  t1.id AS id_4,
  t1.uuid AS uuid_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.handle AS handle_8,
  t0.model_category_brand_entity_id AS model_category_brand_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  model_category_brand_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.model_category_brand_entity_id = ?

SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.model_category_brand_entity_id AS model_category_brand_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_category_brand_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_brand_entity_id = 209;

SELECT
  t1.node_type AS node_type_2,
  t1.system_managed AS system_managed_3,
  t1.id AS id_4,
  t1.uuid AS uuid_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.handle AS handle_8,
  t0.model_category_brand_entity_id AS model_category_brand_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  model_category_brandssd_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.model_category_brand_entity_id = ?

SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.model_category_brand_entity_id AS model_category_brand_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_category_brandssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_brand_entity_id = 209;

SELECT
  t0.path AS path_1,
  t0.alias AS alias_2,
  t0.primary_path AS primary_path_3,
  t0.type AS type_4,
  t0.method AS method_5,
  t0.id AS id_6,
  t0.uuid AS uuid_7,
  t0.active AS active_8,
  t0.locale_code AS locale_code_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  path_alias t0
WHERE
  t0.alias = ?
  AND t0.primary_path = ?
  AND t0.active = ?

SELECT t0.path AS path_1, t0.alias AS alias_2, t0.primary_path AS primary_path_3, t0.type AS type_4, t0.method AS method_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM path_alias t0 WHERE t0.alias = 'node/536439' AND t0.primary_path = 1 AND t0.active = 1;

SELECT
  s0_.id AS id_0
FROM
  series s0_
WHERE
  s0_.materialized_path = ?
  AND s0_.active = ?
  AND s0_.display_ssds = ?

SELECT s0_.id AS id_0 FROM series s0_ WHERE s0_.materialized_path = '/3734' AND s0_.active = 1 AND s0_.display_ssds = 1;

SELECT
  m0_.id AS id_0
FROM
  model m0_
WHERE
  m0_.series_id = ?
  AND m0_.display_ssds = ?
  AND m0_.active = ?

SELECT m0_.id AS id_0 FROM model m0_ WHERE m0_.series_id = 3734 AND m0_.display_ssds = 1 AND m0_.active = 1;

SELECT
  *
FROM
  global_av_mapping_model
WHERE
  model_id IN (
    126541, 157360, 157364, 181571, 195441
  )

SELECT * FROM global_av_mapping_model WHERE model_id IN (126541,157360,157364,181571,195441);

SELECT
  DISTINCT id_3
FROM
  (
    SELECT
      DISTINCT id_3,
      FIELD(
        entity_alias_0, 'model/126541', 'model/157360',
        'model/157364', 'model/181571',
        'model/195441'
      )
    FROM
      (
        SELECT
          e0_.entity_alias AS entity_alias_0,
          e0_.entity_class AS entity_class_1,
          e0_.entity_id AS entity_id_2,
          e0_.id AS id_3
        FROM
          entity_alias_map e0_
        WHERE
          e0_.entity_alias IN (?, ?, ?, ?, ?)
      ) dctrn_result_inner
    ORDER BY
      FIELD(
        entity_alias_0, 'model/126541', 'model/157360',
        'model/157364', 'model/181571',
        'model/195441'
      ) ASC
  ) dctrn_result
LIMIT
  100

SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, FIELD(entity_alias_0, 'model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441') FROM (SELECT e0_.entity_alias AS entity_alias_0, e0_.entity_class AS entity_class_1, e0_.entity_id AS entity_id_2, e0_.id AS id_3 FROM entity_alias_map e0_ WHERE e0_.entity_alias IN ('model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441')) dctrn_result_inner ORDER BY FIELD(entity_alias_0, 'model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441') ASC) dctrn_result LIMIT 100;

SELECT
  e0_.entity_alias AS entity_alias_0,
  e0_.entity_class AS entity_class_1,
  e0_.entity_id AS entity_id_2,
  e0_.id AS id_3
FROM
  entity_alias_map e0_
WHERE
  e0_.entity_alias IN (?, ?, ?, ?, ?)
  AND e0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  FIELD(
    e0_.entity_alias, 'model/126541',
    'model/157360', 'model/157364',
    'model/181571', 'model/195441'
  ) ASC

SELECT e0_.entity_alias AS entity_alias_0, e0_.entity_class AS entity_class_1, e0_.entity_id AS entity_id_2, e0_.id AS id_3 FROM entity_alias_map e0_ WHERE e0_.entity_alias IN ('model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441') AND e0_.id IN (217823, 226220, 226221, 231006, 232406) ORDER BY FIELD(e0_.entity_alias, 'model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441') ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_3
    FROM
      (
        SELECT
          e0_.entity_alias AS entity_alias_0,
          e0_.entity_class AS entity_class_1,
          e0_.entity_id AS entity_id_2,
          e0_.id AS id_3
        FROM
          entity_alias_map e0_
        WHERE
          e0_.entity_alias IN (?, ?, ?, ?, ?)
        ORDER BY
          FIELD(
            e0_.entity_alias, 'model/126541',
            'model/157360', 'model/157364',
            'model/181571', 'model/195441'
          ) ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT e0_.entity_alias AS entity_alias_0, e0_.entity_class AS entity_class_1, e0_.entity_id AS entity_id_2, e0_.id AS id_3 FROM entity_alias_map e0_ WHERE e0_.entity_alias IN ('model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441') ORDER BY FIELD(e0_.entity_alias, 'model/126541', 'model/157360', 'model/157364', 'model/181571', 'model/195441') ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT n0_.node_type AS node_type_0,
  n0_.system_managed AS system_managed_1,
  n0_.id AS id_2,
  n0_.uuid AS uuid_3,
  n0_.created_at AS created_at_4,
  n0_.updated_at AS updated_at_5,
  n0_.handle AS handle_6,
  m1_.poc_only AS poc_only_7,
  m1_.display_oem AS display_oem_8,
  m1_.id AS id_9,
  m1_.uuid AS uuid_10,
  m1_.created_at AS created_at_11,
  m1_.updated_at AS updated_at_12,
  m1_.handle AS handle_13,
  m1_.active AS active_14,
  m1_.legacy_id AS legacy_id_15,
  m1_.legacy_data AS legacy_data_16,
  m1_.allow_node_generation AS allow_node_generation_17,
  m1_.display_memory_modules AS display_memory_modules_18,
  m1_.display_ssds AS display_ssds_19,
  m2_.id AS id_20,
  m2_.short_name AS short_name_21,
  m2_.name AS name_22,
  m2_.description AS description_23,
  m2_.legacy_url_slug AS legacy_url_slug_24,
  m2_.locale AS locale_25,
  m3_.id AS id_26,
  m3_.active AS active_27,
  m3_.name AS name_28,
  m3_.path_hint AS path_hint_29,
  m3_.main_title AS main_title_30,
  m3_.page_title AS page_title_31,
  m3_.page_description AS page_description_32,
  m3_.allow_robots_index AS allow_robots_index_33,
  m3_.allow_robots_follow AS allow_robots_follow_34,
  m3_.additional_meta_tags AS additional_meta_tags_35,
  m3_.locale AS locale_36,
  m4_.file_name AS file_name_37,
  m4_.file_uri AS file_uri_38,
  m4_.file_mime AS file_mime_39,
  m4_.file_size AS file_size_40,
  m4_.status AS status_41,
  m4_.id AS id_42,
  m4_.uuid AS uuid_43,
  m4_.active AS active_44,
  m4_.locale_code AS locale_code_45,
  d5_.icon_uri AS icon_uri_46,
  d5_.id AS id_47,
  d5_.uuid AS uuid_48,
  d5_.handle AS handle_49,
  d5_.legacy_id AS legacy_id_50,
  n0_.discr AS discr_51
FROM
  modelssd_node m6_
  INNER JOIN node n0_ ON m6_.id = n0_.id
  LEFT JOIN model m1_ ON m6_.model_entity_id = m1_.id
  LEFT JOIN model_translation m2_ ON m1_.id = m2_.translatable_id
  LEFT JOIN modelssd_node_translation m3_ ON m6_.id = m3_.translatable_id
  LEFT JOIN managed_file m4_ ON m1_.model_image_id = m4_.id
  LEFT JOIN device_type d5_ ON m1_.device_type_id = d5_.id
WHERE
  m1_.active = ?
  AND m1_.id IN (
    126541, 157360, 157364, 181571, 195441
  )
  AND m2_.locale = ?
  AND m3_.locale = ?
ORDER BY
  m3_.name ASC

SELECT DISTINCT n0_.node_type AS node_type_0, n0_.system_managed AS system_managed_1, n0_.id AS id_2, n0_.uuid AS uuid_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, n0_.handle AS handle_6, m1_.poc_only AS poc_only_7, m1_.display_oem AS display_oem_8, m1_.id AS id_9, m1_.uuid AS uuid_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.handle AS handle_13, m1_.active AS active_14, m1_.legacy_id AS legacy_id_15, m1_.legacy_data AS legacy_data_16, m1_.allow_node_generation AS allow_node_generation_17, m1_.display_memory_modules AS display_memory_modules_18, m1_.display_ssds AS display_ssds_19, m2_.id AS id_20, m2_.short_name AS short_name_21, m2_.name AS name_22, m2_.description AS description_23, m2_.legacy_url_slug AS legacy_url_slug_24, m2_.locale AS locale_25, m3_.id AS id_26, m3_.active AS active_27, m3_.name AS name_28, m3_.path_hint AS path_hint_29, m3_.main_title AS main_title_30, m3_.page_title AS page_title_31, m3_.page_description AS page_description_32, m3_.allow_robots_index AS allow_robots_index_33, m3_.allow_robots_follow AS allow_robots_follow_34, m3_.additional_meta_tags AS additional_meta_tags_35, m3_.locale AS locale_36, m4_.file_name AS file_name_37, m4_.file_uri AS file_uri_38, m4_.file_mime AS file_mime_39, m4_.file_size AS file_size_40, m4_.status AS status_41, m4_.id AS id_42, m4_.uuid AS uuid_43, m4_.active AS active_44, m4_.locale_code AS locale_code_45, d5_.icon_uri AS icon_uri_46, d5_.id AS id_47, d5_.uuid AS uuid_48, d5_.handle AS handle_49, d5_.legacy_id AS legacy_id_50, n0_.discr AS discr_51 FROM modelssd_node m6_ INNER JOIN node n0_ ON m6_.id = n0_.id LEFT JOIN model m1_ ON m6_.model_entity_id = m1_.id LEFT JOIN model_translation m2_ ON m1_.id = m2_.translatable_id LEFT JOIN modelssd_node_translation m3_ ON m6_.id = m3_.translatable_id LEFT JOIN managed_file m4_ ON m1_.model_image_id = m4_.id LEFT JOIN device_type d5_ ON m1_.device_type_id = d5_.id WHERE m1_.active = 1 AND m1_.id IN (126541, 157360, 157364, 181571, 195441) AND m2_.locale = 'en' AND m3_.locale = 'en' ORDER BY m3_.name ASC;

SELECT
  t1.node_type AS node_type_2,
  t1.system_managed AS system_managed_3,
  t1.id AS id_4,
  t1.uuid AS uuid_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.handle AS handle_8,
  t0.model_category_entity_id AS model_category_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  model_category_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.model_category_entity_id = ?

SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.model_category_entity_id AS model_category_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_category_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_entity_id = 2;

SELECT
  t1.node_type AS node_type_2,
  t1.system_managed AS system_managed_3,
  t1.id AS id_4,
  t1.uuid AS uuid_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.handle AS handle_8,
  t0.model_category_entity_id AS model_category_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  model_categoryssd_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.model_category_entity_id = ?

SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.model_category_entity_id AS model_category_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_categoryssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_entity_id = 2;

SELECT
  t0.alternative_name AS alternative_name_1,
  t0.id AS id_2,
  t0.active AS active_3,
  t0.name AS name_4,
  t0.path_hint AS path_hint_5,
  t0.page_title AS page_title_6,
  t0.page_description AS page_description_7,
  t0.allow_robots_index AS allow_robots_index_8,
  t0.allow_robots_follow AS allow_robots_follow_9,
  t0.additional_meta_tags AS additional_meta_tags_10,
  t0.description AS description_11,
  t0.description_chatgpt AS description_chatgpt_12,
  t0.display_ai_description AS display_ai_description_13,
  t0.short_description AS short_description_14,
  t0.content AS content_15,
  t0.content_chatgpt AS content_chatgpt_16,
  t0.display_ai_content AS display_ai_content_17,
  t0.main_title AS main_title_18,
  t0.locale AS locale_19,
  t0.translatable_id AS translatable_id_20
FROM
  model_categoryssd_node_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.alternative_name AS alternative_name_1, t0.id AS id_2, t0.active AS active_3, t0.name AS name_4, t0.path_hint AS path_hint_5, t0.page_title AS page_title_6, t0.page_description AS page_description_7, t0.allow_robots_index AS allow_robots_index_8, t0.allow_robots_follow AS allow_robots_follow_9, t0.additional_meta_tags AS additional_meta_tags_10, t0.description AS description_11, t0.description_chatgpt AS description_chatgpt_12, t0.display_ai_description AS display_ai_description_13, t0.short_description AS short_description_14, t0.content AS content_15, t0.content_chatgpt AS content_chatgpt_16, t0.display_ai_content AS display_ai_content_17, t0.main_title AS main_title_18, t0.locale AS locale_19, t0.translatable_id AS translatable_id_20 FROM model_categoryssd_node_translation t0 WHERE t0.translatable_id = 532798;