Symfony Profiler

SELECT
  t0.feedback_locale_code AS feedback_locale_code_1,
  t0.verified AS verified_2,
  t0.feedback_user AS feedback_user_3,
  t0.feedback_text AS feedback_text_4,
  t0.feedback_type AS feedback_type_5,
  t0.feedback_stars AS feedback_stars_6,
  t0.feedback_time AS feedback_time_7,
  t0.feedback_name AS feedback_name_8,
  t0.clean AS clean_9,
  t0.valid AS valid_10,
  t0.extra_data AS extra_data_11,
  t0.feedback_item_title AS feedback_item_title_12,
  t0.oftpartno AS oftpartno_13,
  t0.feedback_origin AS feedback_origin_14,
  t0.origin_transaction_id AS origin_transaction_id_15,
  t0.order_id AS order_id_16,
  t0.origin_feedback_id AS origin_feedback_id_17,
  t0.model_id AS model_id_18,
  t0.product_id AS product_id_19,
  t0.feedback_role AS feedback_role_20,
  t0.feedback_language AS feedback_language_21,
  t0.feedback_item_id AS feedback_item_id_22,
  t0.feedback_page_number AS feedback_page_number_23,
  t0.id AS id_24,
  t0.channel_id AS channel_id_25
FROM
  feedback t0
WHERE
  t0.feedback_locale_code = ?
  AND t0.channel_id = ?
  AND t0.feedback_stars = ?
  AND t0.clean = ?
  AND t0.valid = ?
ORDER BY
  t0.feedback_time DESC
LIMIT
  12

SELECT t0.feedback_locale_code AS feedback_locale_code_1, t0.verified AS verified_2, t0.feedback_user AS feedback_user_3, t0.feedback_text AS feedback_text_4, t0.feedback_type AS feedback_type_5, t0.feedback_stars AS feedback_stars_6, t0.feedback_time AS feedback_time_7, t0.feedback_name AS feedback_name_8, t0.clean AS clean_9, t0.valid AS valid_10, t0.extra_data AS extra_data_11, t0.feedback_item_title AS feedback_item_title_12, t0.oftpartno AS oftpartno_13, t0.feedback_origin AS feedback_origin_14, t0.origin_transaction_id AS origin_transaction_id_15, t0.order_id AS order_id_16, t0.origin_feedback_id AS origin_feedback_id_17, t0.model_id AS model_id_18, t0.product_id AS product_id_19, t0.feedback_role AS feedback_role_20, t0.feedback_language AS feedback_language_21, t0.feedback_item_id AS feedback_item_id_22, t0.feedback_page_number AS feedback_page_number_23, t0.id AS id_24, t0.channel_id AS channel_id_25 FROM feedback t0 WHERE t0.feedback_locale_code = 'uk' AND t0.channel_id = 1 AND t0.feedback_stars = 5 AND t0.clean = 1 AND t0.valid = 1 ORDER BY t0.feedback_time DESC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main_title AS main_title_3,
  t0.description AS description_4,
  t0.content AS content_5,
  t0.locale AS locale_6,
  t0.featured_image_id AS featured_image_id_7,
  t0.translatable_id AS translatable_id_8
FROM
  article_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = 100;

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.locale_code = ?
  AND t0.active = ?
  AND t0.primary_path = ?
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.alias = 'node/809660' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;

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 (166836, 193790)
  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 (166836, 193790) 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.article_entity_id AS article_entity_id_9,
  t1.discr
FROM
  article_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.article_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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = 100;

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,
  m1_.popular AS popular_7,
  m1_.id AS id_8,
  m1_.uuid AS uuid_9,
  m1_.created_at AS created_at_10,
  m1_.updated_at AS updated_at_11,
  m1_.handle AS handle_12,
  m1_.active AS active_13,
  m1_.legacy_id AS legacy_id_14,
  m1_.legacy_secondary_id AS legacy_secondary_id_15,
  m1_.legacy_data AS legacy_data_16,
  m1_.legacy_url_slug AS legacy_url_slug_17,
  m1_.allow_node_generation AS allow_node_generation_18,
  m1_.display_memory_modules AS display_memory_modules_19,
  m1_.display_ssds AS display_ssds_20,
  m2_.id AS id_21,
  m2_.name AS name_22,
  m2_.path_hint AS path_hint_23,
  m2_.active AS active_24,
  m2_.page_title AS page_title_25,
  m2_.page_description AS page_description_26,
  m2_.allow_robots_index AS allow_robots_index_27,
  m2_.allow_robots_follow AS allow_robots_follow_28,
  m2_.additional_meta_tags AS additional_meta_tags_29,
  m2_.description AS description_30,
  m2_.description_chatgpt AS description_chatgpt_31,
  m2_.display_ai_description AS display_ai_description_32,
  m2_.short_description AS short_description_33,
  m2_.content AS content_34,
  m2_.main_title AS main_title_35,
  m2_.locale AS locale_36,
  m3_.id AS id_37,
  m3_.short_name AS short_name_38,
  m3_.name AS name_39,
  m3_.description AS description_40,
  m3_.locale AS locale_41,
  b4_.popular AS popular_42,
  b4_.id AS id_43,
  b4_.uuid AS uuid_44,
  b4_.created_at AS created_at_45,
  b4_.updated_at AS updated_at_46,
  b4_.handle AS handle_47,
  b4_.active AS active_48,
  b4_.legacy_id AS legacy_id_49,
  m5_.id AS id_50,
  m5_.uuid AS uuid_51,
  m5_.created_at AS created_at_52,
  m5_.updated_at AS updated_at_53,
  m5_.handle AS handle_54,
  m5_.active AS active_55,
  m5_.legacy_id AS legacy_id_56,
  m5_.legacy_secondary_id AS legacy_secondary_id_57,
  m5_.legacy_data AS legacy_data_58,
  m5_.allow_node_generation AS allow_node_generation_59,
  m5_.display_memory_modules AS display_memory_modules_60,
  m5_.display_ssds AS display_ssds_61,
  d6_.icon_uri AS icon_uri_62,
  d6_.id AS id_63,
  d6_.uuid AS uuid_64,
  d6_.handle AS handle_65,
  d6_.legacy_id AS legacy_id_66,
  n0_.discr AS discr_67,
  m7_.model_category_brand_entity_id AS model_category_brand_entity_id_68,
  m7_.help_topic_id AS help_topic_id_69,
  m1_.model_category_id AS model_category_id_70,
  m1_.brand_id AS brand_id_71,
  m1_.device_type_id AS device_type_id_72,
  m2_.translatable_id AS translatable_id_73,
  m3_.translatable_id AS translatable_id_74,
  b4_.brand_logo_id AS brand_logo_id_75,
  m5_.device_type_id AS device_type_id_76
FROM
  model_category_brandssd_node m7_
  INNER JOIN node n0_ ON m7_.id = n0_.id
  LEFT JOIN model_category_brand m1_ ON m7_.model_category_brand_entity_id = m1_.id
  LEFT JOIN model_category_brandssd_node_translation m2_ ON m7_.id = m2_.translatable_id
  AND (m2_.locale = ?)
  LEFT JOIN model_category_brand_translation m3_ ON m1_.id = m3_.translatable_id
  AND (m3_.locale = ?)
  LEFT JOIN brand b4_ ON m1_.brand_id = b4_.id
  LEFT JOIN model_category m5_ ON m1_.model_category_id = m5_.id
  LEFT JOIN device_type d6_ ON m1_.device_type_id = d6_.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, m1_.popular AS popular_7, m1_.id AS id_8, m1_.uuid AS uuid_9, m1_.created_at AS created_at_10, m1_.updated_at AS updated_at_11, m1_.handle AS handle_12, m1_.active AS active_13, m1_.legacy_id AS legacy_id_14, m1_.legacy_secondary_id AS legacy_secondary_id_15, m1_.legacy_data AS legacy_data_16, m1_.legacy_url_slug AS legacy_url_slug_17, m1_.allow_node_generation AS allow_node_generation_18, m1_.display_memory_modules AS display_memory_modules_19, m1_.display_ssds AS display_ssds_20, m2_.id AS id_21, m2_.name AS name_22, m2_.path_hint AS path_hint_23, m2_.active AS active_24, m2_.page_title AS page_title_25, m2_.page_description AS page_description_26, m2_.allow_robots_index AS allow_robots_index_27, m2_.allow_robots_follow AS allow_robots_follow_28, m2_.additional_meta_tags AS additional_meta_tags_29, m2_.description AS description_30, m2_.description_chatgpt AS description_chatgpt_31, m2_.display_ai_description AS display_ai_description_32, m2_.short_description AS short_description_33, m2_.content AS content_34, m2_.main_title AS main_title_35, m2_.locale AS locale_36, m3_.id AS id_37, m3_.short_name AS short_name_38, m3_.name AS name_39, m3_.description AS description_40, m3_.locale AS locale_41, b4_.popular AS popular_42, b4_.id AS id_43, b4_.uuid AS uuid_44, b4_.created_at AS created_at_45, b4_.updated_at AS updated_at_46, b4_.handle AS handle_47, b4_.active AS active_48, b4_.legacy_id AS legacy_id_49, m5_.id AS id_50, m5_.uuid AS uuid_51, m5_.created_at AS created_at_52, m5_.updated_at AS updated_at_53, m5_.handle AS handle_54, m5_.active AS active_55, m5_.legacy_id AS legacy_id_56, m5_.legacy_secondary_id AS legacy_secondary_id_57, m5_.legacy_data AS legacy_data_58, m5_.allow_node_generation AS allow_node_generation_59, m5_.display_memory_modules AS display_memory_modules_60, m5_.display_ssds AS display_ssds_61, d6_.icon_uri AS icon_uri_62, d6_.id AS id_63, d6_.uuid AS uuid_64, d6_.handle AS handle_65, d6_.legacy_id AS legacy_id_66, n0_.discr AS discr_67, m7_.model_category_brand_entity_id AS model_category_brand_entity_id_68, m7_.help_topic_id AS help_topic_id_69, m1_.model_category_id AS model_category_id_70, m1_.brand_id AS brand_id_71, m1_.device_type_id AS device_type_id_72, m2_.translatable_id AS translatable_id_73, m3_.translatable_id AS translatable_id_74, b4_.brand_logo_id AS brand_logo_id_75, m5_.device_type_id AS device_type_id_76 FROM model_category_brandssd_node m7_ INNER JOIN node n0_ ON m7_.id = n0_.id LEFT JOIN model_category_brand m1_ ON m7_.model_category_brand_entity_id = m1_.id LEFT JOIN model_category_brandssd_node_translation m2_ ON m7_.id = m2_.translatable_id AND (m2_.locale = 'en') LEFT JOIN model_category_brand_translation m3_ ON m1_.id = m3_.translatable_id AND (m3_.locale = 'en') LEFT JOIN brand b4_ ON m1_.brand_id = b4_.id LEFT JOIN model_category m5_ ON m1_.model_category_id = m5_.id LEFT JOIN device_type d6_ ON m1_.device_type_id = d6_.id WHERE n0_.id = 533012;

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 = 533012;

SELECT
  DISTINCT s0_.id AS id_0
FROM
  series s0_
  LEFT JOIN series_node s1_ ON s0_.id = s1_.series_entity_id
  LEFT JOIN node n2_ ON s1_.id = n2_.id
  LEFT JOIN series_translation s3_ ON s0_.id = s3_.translatable_id
WHERE
  s0_.model_category_brand_id = ?
  AND s0_.top_level = ?
  AND s0_.active = ?
  AND s0_.display_ssds = ?
  AND n2_.id IS NOT NULL
  AND s3_.locale = ?
ORDER BY
  s3_.name ASC

SELECT DISTINCT s0_.id AS id_0 FROM series s0_ LEFT JOIN series_node s1_ ON s0_.id = s1_.series_entity_id LEFT JOIN node n2_ ON s1_.id = n2_.id LEFT JOIN series_translation s3_ ON s0_.id = s3_.translatable_id WHERE s0_.model_category_brand_id = 578 AND s0_.top_level = 1 AND s0_.active = 1 AND s0_.display_ssds = 1 AND n2_.id IS NOT NULL AND s3_.locale = 'en' ORDER BY s3_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  device_type_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM device_type_translation t0 WHERE t0.translatable_id = 11;

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 = 532801;

SELECT
  DISTINCT id_3
FROM
  (
    SELECT
      DISTINCT id_3,
      FIELD(
        entity_alias_0, 'model/166836', 'model/193790'
      )
    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/166836', 'model/193790'
      ) ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, FIELD(entity_alias_0, 'model/166836', 'model/193790') 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/166836', 'model/193790')) dctrn_result_inner ORDER BY FIELD(entity_alias_0, 'model/166836', 'model/193790') ASC) dctrn_result LIMIT 50;

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 = '/motherboard-ssd-upgrades/arbor' AND t0.locale_code = 'en' AND t0.active = 1 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.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/533012' AND t0.primary_path = 1 AND t0.active = 1;

SELECT
  a0_.popular AS popular_0,
  a0_.id AS id_1,
  a0_.uuid AS uuid_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4,
  a0_.active AS active_5,
  a0_.allow_node_generation AS allow_node_generation_6,
  a0_.main_taxonomy_id AS main_taxonomy_id_7,
  a0_.author_id AS author_id_8
FROM
  article a0_
WHERE
  a0_.active = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  3

SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6, a0_.main_taxonomy_id AS main_taxonomy_id_7, a0_.author_id AS author_id_8 FROM article a0_ WHERE a0_.active = 1 ORDER BY a0_.created_at DESC LIMIT 3;

SELECT
  t0.alternative_name AS alternative_name_1,
  t0.website AS website_2,
  t0.model_identification_info AS model_identification_info_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  brand_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.alternative_name AS alternative_name_1, t0.website AS website_2, t0.model_identification_info AS model_identification_info_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM brand_translation t0 WHERE t0.translatable_id = 291;

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 = 578;