Symfony Profiler

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

SELECT
  t0.node_type AS node_type_25,
  t0.system_managed AS system_managed_26,
  t0.id AS id_27,
  t0.uuid AS uuid_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.handle AS handle_31,
  t0.discr,
  t1.controller AS controller_32,
  t1.action AS action_33,
  t2.page_entity_id AS page_entity_id_34,
  t3.series_entity_id AS series_entity_id_35,
  t3.help_topic_id AS help_topic_id_36,
  t4.series_entity_id AS series_entity_id_37,
  t4.help_topic_id AS help_topic_id_38,
  t5.model_entity_id AS model_entity_id_39,
  t6.model_entity_id AS model_entity_id_40,
  t7.component_page_entity_id AS component_page_entity_id_41,
  t7.help_topic_id AS help_topic_id_42,
  t8.product_entity_id AS product_entity_id_43,
  t8.help_topic_id AS help_topic_id_44,
  t9.filter_page_entity_id AS filter_page_entity_id_45,
  t10.article_entity_id AS article_entity_id_46,
  t11.article_taxonomy_entity_id AS article_taxonomy_entity_id_47,
  t12.article_tag_entity_id AS article_tag_entity_id_48,
  t13.settings AS settings_49,
  t13.symfony_route_name AS symfony_route_name_50,
  t14.help_topic_entity_id AS help_topic_entity_id_51,
  t15.help_article_entity_id AS help_article_entity_id_52,
  t16.model_category_entity_id AS model_category_entity_id_53,
  t16.help_topic_id AS help_topic_id_54,
  t17.model_category_entity_id AS model_category_entity_id_55,
  t17.help_topic_id AS help_topic_id_56,
  t18.model_category_brand_entity_id AS model_category_brand_entity_id_57,
  t18.help_topic_id AS help_topic_id_58,
  t19.model_category_brand_entity_id AS model_category_brand_entity_id_59,
  t19.help_topic_id AS help_topic_id_60,
  t20.oem_part_entity_id AS oem_part_entity_id_61,
  t20.help_topic_id AS help_topic_id_62,
  t21.oem_brand_entity_id AS oem_brand_entity_id_63,
  t21.help_topic_id AS help_topic_id_64,
  t22.model_entity_id AS model_entity_id_65,
  t22.help_topic_id AS help_topic_id_66,
  t23.oem_category_entity_id AS oem_category_entity_id_67,
  t23.help_topic_id AS help_topic_id_68,
  t24.oem_brand_category_entity_id AS oem_brand_category_entity_id_69,
  t24.help_topic_id AS help_topic_id_70
FROM
  node t0
  LEFT JOIN core_node t1 ON t0.id = t1.id
  LEFT JOIN page_node t2 ON t0.id = t2.id
  LEFT JOIN series_node t3 ON t0.id = t3.id
  LEFT JOIN seriesssd_node t4 ON t0.id = t4.id
  LEFT JOIN model_node t5 ON t0.id = t5.id
  LEFT JOIN modelssd_node t6 ON t0.id = t6.id
  LEFT JOIN component_page_node t7 ON t0.id = t7.id
  LEFT JOIN product_node t8 ON t0.id = t8.id
  LEFT JOIN filter_page_node t9 ON t0.id = t9.id
  LEFT JOIN article_node t10 ON t0.id = t10.id
  LEFT JOIN article_taxonomy_node t11 ON t0.id = t11.id
  LEFT JOIN article_tag_node t12 ON t0.id = t12.id
  LEFT JOIN generic_node t13 ON t0.id = t13.id
  LEFT JOIN help_topic_node t14 ON t0.id = t14.id
  LEFT JOIN help_article_node t15 ON t0.id = t15.id
  LEFT JOIN model_category_node t16 ON t0.id = t16.id
  LEFT JOIN model_categoryssd_node t17 ON t0.id = t17.id
  LEFT JOIN model_category_brand_node t18 ON t0.id = t18.id
  LEFT JOIN model_category_brandssd_node t19 ON t0.id = t19.id
  LEFT JOIN oem_part_page_node t20 ON t0.id = t20.id
  LEFT JOIN oem_brand_node t21 ON t0.id = t21.id
  LEFT JOIN oem_model_node t22 ON t0.id = t22.id
  LEFT JOIN oem_category_node t23 ON t0.id = t23.id
  LEFT JOIN oem_brand_category_node t24 ON t0.id = t24.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.node_type AS node_type_25, t0.system_managed AS system_managed_26, t0.id AS id_27, t0.uuid AS uuid_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.handle AS handle_31, t0.discr, t1.controller AS controller_32, t1.action AS action_33, t2.page_entity_id AS page_entity_id_34, t3.series_entity_id AS series_entity_id_35, t3.help_topic_id AS help_topic_id_36, t4.series_entity_id AS series_entity_id_37, t4.help_topic_id AS help_topic_id_38, t5.model_entity_id AS model_entity_id_39, t6.model_entity_id AS model_entity_id_40, t7.component_page_entity_id AS component_page_entity_id_41, t7.help_topic_id AS help_topic_id_42, t8.product_entity_id AS product_entity_id_43, t8.help_topic_id AS help_topic_id_44, t9.filter_page_entity_id AS filter_page_entity_id_45, t10.article_entity_id AS article_entity_id_46, t11.article_taxonomy_entity_id AS article_taxonomy_entity_id_47, t12.article_tag_entity_id AS article_tag_entity_id_48, t13.settings AS settings_49, t13.symfony_route_name AS symfony_route_name_50, t14.help_topic_entity_id AS help_topic_entity_id_51, t15.help_article_entity_id AS help_article_entity_id_52, t16.model_category_entity_id AS model_category_entity_id_53, t16.help_topic_id AS help_topic_id_54, t17.model_category_entity_id AS model_category_entity_id_55, t17.help_topic_id AS help_topic_id_56, t18.model_category_brand_entity_id AS model_category_brand_entity_id_57, t18.help_topic_id AS help_topic_id_58, t19.model_category_brand_entity_id AS model_category_brand_entity_id_59, t19.help_topic_id AS help_topic_id_60, t20.oem_part_entity_id AS oem_part_entity_id_61, t20.help_topic_id AS help_topic_id_62, t21.oem_brand_entity_id AS oem_brand_entity_id_63, t21.help_topic_id AS help_topic_id_64, t22.model_entity_id AS model_entity_id_65, t22.help_topic_id AS help_topic_id_66, t23.oem_category_entity_id AS oem_category_entity_id_67, t23.help_topic_id AS help_topic_id_68, t24.oem_brand_category_entity_id AS oem_brand_category_entity_id_69, t24.help_topic_id AS help_topic_id_70 FROM node t0 LEFT JOIN core_node t1 ON t0.id = t1.id LEFT JOIN page_node t2 ON t0.id = t2.id LEFT JOIN series_node t3 ON t0.id = t3.id LEFT JOIN seriesssd_node t4 ON t0.id = t4.id LEFT JOIN model_node t5 ON t0.id = t5.id LEFT JOIN modelssd_node t6 ON t0.id = t6.id LEFT JOIN component_page_node t7 ON t0.id = t7.id LEFT JOIN product_node t8 ON t0.id = t8.id LEFT JOIN filter_page_node t9 ON t0.id = t9.id LEFT JOIN article_node t10 ON t0.id = t10.id LEFT JOIN article_taxonomy_node t11 ON t0.id = t11.id LEFT JOIN article_tag_node t12 ON t0.id = t12.id LEFT JOIN generic_node t13 ON t0.id = t13.id LEFT JOIN help_topic_node t14 ON t0.id = t14.id LEFT JOIN help_article_node t15 ON t0.id = t15.id LEFT JOIN model_category_node t16 ON t0.id = t16.id LEFT JOIN model_categoryssd_node t17 ON t0.id = t17.id LEFT JOIN model_category_brand_node t18 ON t0.id = t18.id LEFT JOIN model_category_brandssd_node t19 ON t0.id = t19.id LEFT JOIN oem_part_page_node t20 ON t0.id = t20.id LEFT JOIN oem_brand_node t21 ON t0.id = t21.id LEFT JOIN oem_model_node t22 ON t0.id = t22.id LEFT JOIN oem_category_node t23 ON t0.id = t23.id LEFT JOIN oem_brand_category_node t24 ON t0.id = t24.id WHERE t0.id = 548495 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/548495' AND t0.primary_path = 1 AND t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path_hint AS path_hint_3,
  t0.active AS active_4,
  t0.description AS description_5,
  t0.main_title AS main_title_6,
  t0.short_description AS short_description_7,
  t0.page_title AS page_title_8,
  t0.page_description AS page_description_9,
  t0.allow_robots_index AS allow_robots_index_10,
  t0.allow_robots_follow AS allow_robots_follow_11,
  t0.additional_meta_tags AS additional_meta_tags_12,
  t0.locale AS locale_13,
  t0.translatable_id AS translatable_id_14
FROM
  oem_part_page_node_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path_hint AS path_hint_3, t0.active AS active_4, t0.description AS description_5, t0.main_title AS main_title_6, t0.short_description AS short_description_7, t0.page_title AS page_title_8, t0.page_description AS page_description_9, t0.allow_robots_index AS allow_robots_index_10, t0.allow_robots_follow AS allow_robots_follow_11, t0.additional_meta_tags AS additional_meta_tags_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM oem_part_page_node_translation t0 WHERE t0.translatable_id = 548495;

SELECT
  t0.purchasable AS purchasable_1,
  t0.part_number AS part_number_2,
  t0.oem_part_image_order AS oem_part_image_order_3,
  t0.position AS position_4,
  t0.id AS id_5,
  t0.uuid AS uuid_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.active AS active_9,
  t0.allow_node_generation AS allow_node_generation_10,
  t0.part_code_type_id AS part_code_type_id_11,
  t0.product_variant_id AS product_variant_id_12,
  t0.oem_brand_id AS oem_brand_id_13,
  t0.main_oem_category_id AS main_oem_category_id_14,
  t0.main_oem_brand_category_id AS main_oem_brand_category_id_15,
  t0.device_type_id AS device_type_id_16,
  t17.id AS id_18,
  t17.feed_id AS feed_id_19,
  t17.disallowed_condition_types AS disallowed_condition_types_20,
  t17.oem_part_id AS oem_part_id_21
FROM
  oem_part t0
  LEFT JOIN product_feed_oem_part t17 ON t17.oem_part_id = t0.id
WHERE
  t0.id = ?

SELECT t0.purchasable AS purchasable_1, t0.part_number AS part_number_2, t0.oem_part_image_order AS oem_part_image_order_3, t0.position AS position_4, t0.id AS id_5, t0.uuid AS uuid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.active AS active_9, t0.allow_node_generation AS allow_node_generation_10, t0.part_code_type_id AS part_code_type_id_11, t0.product_variant_id AS product_variant_id_12, t0.oem_brand_id AS oem_brand_id_13, t0.main_oem_category_id AS main_oem_category_id_14, t0.main_oem_brand_category_id AS main_oem_brand_category_id_15, t0.device_type_id AS device_type_id_16, t17.id AS id_18, t17.feed_id AS feed_id_19, t17.disallowed_condition_types AS disallowed_condition_types_20, t17.oem_part_id AS oem_part_id_21 FROM oem_part t0 LEFT JOIN product_feed_oem_part t17 ON t17.oem_part_id = t0.id WHERE t0.id = 1983;

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.oem_part_entity_id AS oem_part_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  oem_part_page_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.oem_part_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.oem_part_entity_id AS oem_part_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM oem_part_page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.oem_part_entity_id = 1983;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.handle AS handle_5,
  t0.active AS active_6,
  t0.allow_node_generation AS allow_node_generation_7,
  t0.brand_id AS brand_id_8
FROM
  oem_brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.handle AS handle_5, t0.active AS active_6, t0.allow_node_generation AS allow_node_generation_7, t0.brand_id AS brand_id_8 FROM oem_brand t0 WHERE t0.id = 1;

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.oem_brand_entity_id AS oem_brand_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  oem_brand_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.oem_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.oem_brand_entity_id AS oem_brand_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM oem_brand_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.oem_brand_entity_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  oem_brand_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_brand_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.settings AS settings_1,
  t0.filter_settings AS filter_settings_2,
  t0.id AS id_3,
  t0.uuid AS uuid_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.handle AS handle_7,
  t0.active AS active_8,
  t0.materialized_path AS materialized_path_9,
  t0.allow_node_generation AS allow_node_generation_10,
  t0.oem_brand_id AS oem_brand_id_11
FROM
  oem_brand_category t0
WHERE
  t0.id = ?

SELECT t0.settings AS settings_1, t0.filter_settings AS filter_settings_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.handle AS handle_7, t0.active AS active_8, t0.materialized_path AS materialized_path_9, t0.allow_node_generation AS allow_node_generation_10, t0.oem_brand_id AS oem_brand_id_11 FROM oem_brand_category t0 WHERE t0.id = 13;

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.oem_brand_category_entity_id AS oem_brand_category_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  oem_brand_category_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.oem_brand_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.oem_brand_category_entity_id AS oem_brand_category_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM oem_brand_category_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.oem_brand_category_entity_id = 13;

SELECT
  o0_.settings AS settings_0,
  o0_.filter_settings AS filter_settings_1,
  o0_.id AS id_2,
  o0_.uuid AS uuid_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.handle AS handle_6,
  o0_.active AS active_7,
  o0_.materialized_path AS materialized_path_8,
  o0_.allow_node_generation AS allow_node_generation_9,
  o0_.oem_brand_id AS oem_brand_id_10
FROM
  oem_brand_category o0_
WHERE
  o0_.id IN (?, ?)
ORDER BY
  FIELD(o0_.id, ?, ?) ASC

SELECT o0_.settings AS settings_0, o0_.filter_settings AS filter_settings_1, o0_.id AS id_2, o0_.uuid AS uuid_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.handle AS handle_6, o0_.active AS active_7, o0_.materialized_path AS materialized_path_8, o0_.allow_node_generation AS allow_node_generation_9, o0_.oem_brand_id AS oem_brand_id_10 FROM oem_brand_category o0_ WHERE o0_.id IN ('10', '13') ORDER BY FIELD(o0_.id, '10', '13') 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.oem_brand_category_entity_id AS oem_brand_category_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  oem_brand_category_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.oem_brand_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.oem_brand_category_entity_id AS oem_brand_category_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM oem_brand_category_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.oem_brand_category_entity_id = 10;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.path_hint AS path_hint_4,
  t0.description AS description_5,
  t0.main_title AS main_title_6,
  t0.page_title AS page_title_7,
  t0.page_description AS page_description_8,
  t0.allow_robots_index AS allow_robots_index_9,
  t0.allow_robots_follow AS allow_robots_follow_10,
  t0.additional_meta_tags AS additional_meta_tags_11,
  t0.locale AS locale_12,
  t0.translatable_id AS translatable_id_13
FROM
  oem_brand_category_node_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.path_hint AS path_hint_4, t0.description AS description_5, t0.main_title AS main_title_6, t0.page_title AS page_title_7, t0.page_description AS page_description_8, t0.allow_robots_index AS allow_robots_index_9, t0.allow_robots_follow AS allow_robots_follow_10, t0.additional_meta_tags AS additional_meta_tags_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM oem_brand_category_node_translation t0 WHERE t0.translatable_id = 555756;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.path_hint AS path_hint_4,
  t0.description AS description_5,
  t0.main_title AS main_title_6,
  t0.page_title AS page_title_7,
  t0.page_description AS page_description_8,
  t0.allow_robots_index AS allow_robots_index_9,
  t0.allow_robots_follow AS allow_robots_follow_10,
  t0.additional_meta_tags AS additional_meta_tags_11,
  t0.locale AS locale_12,
  t0.translatable_id AS translatable_id_13
FROM
  oem_brand_category_node_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.path_hint AS path_hint_4, t0.description AS description_5, t0.main_title AS main_title_6, t0.page_title AS page_title_7, t0.page_description AS page_description_8, t0.allow_robots_index AS allow_robots_index_9, t0.allow_robots_follow AS allow_robots_follow_10, t0.additional_meta_tags AS additional_meta_tags_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM oem_brand_category_node_translation t0 WHERE t0.translatable_id = 555759;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  oem_part_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_part_translation t0 WHERE t0.translatable_id = 1983;

SELECT
  mav.*,
  ma.id as ma_id,
  ma.uuid as ma_uuid,
  ma.created_at as ma_created_at,
  ma.updated_at as ma_updated_at,
  ma.handle as ma_handle,
  ma.type as ma_type,
  ma.storage_type as ma_storage_type,
  ma.configuration as ma_configuration,
  ma.position as ma_position,
  ma.translatable as ma_translatable,
  ma.display as ma_display,
  ma.filterable as ma_filterable,
  ma.active as ma_active,
  mat.id as mat_id,
  mat.name as mat_name,
  mat.display_name as mat_display_name,
  mat.translatable_id as mat_translatable_id,
  mat.locale as mat_locale
FROM
  oem_attribute_value mav
  INNER JOIN oem_attribute ma ON mav.attribute_id = ma.id
  INNER JOIN oem_attribute_translation mat ON ma.id = mat.translatable_id
  AND mat.locale = ?
  INNER JOIN oem_attribute_value_mapping mavm ON mav.id = mavm.oem_attribute_value_id
WHERE
  mavm.oem_part_id = ?
  AND ma.display = 1
  AND ma.active = 1
  AND mav.active = 1
  AND mav.locale_code = ?
ORDER BY
  ma.position ASC,
  mav.position ASC

SELECT mav.*,
                ma.id as ma_id, ma.uuid as ma_uuid, ma.created_at as ma_created_at, ma.updated_at as ma_updated_at, ma.handle as ma_handle, ma.type as ma_type, 
                ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, 
                ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, 
                mat.id as mat_id, mat.name as mat_name, mat.display_name as mat_display_name, mat.translatable_id as mat_translatable_id, mat.locale as mat_locale 
                FROM oem_attribute_value mav
                INNER JOIN oem_attribute ma ON mav.attribute_id = ma.id
                INNER JOIN oem_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = 'en' 
                INNER JOIN oem_attribute_value_mapping mavm ON mav.id = mavm.oem_attribute_value_id 
                WHERE mavm.oem_part_id = 1983 AND ma.display = 1 AND ma.active = 1 AND mav.active = 1 AND mav.locale_code = 'en' ORDER BY ma.position ASC, mav.position ASC
            ;

SELECT
  m0_.id AS id_0,
  m0_.uuid AS uuid_1,
  m1_.poc_only AS poc_only_2,
  m1_.display_oem AS display_oem_3,
  m1_.id AS id_4,
  m1_.uuid AS uuid_5,
  m1_.created_at AS created_at_6,
  m1_.updated_at AS updated_at_7,
  m1_.handle AS handle_8,
  m1_.active AS active_9,
  m1_.legacy_id AS legacy_id_10,
  m1_.legacy_data AS legacy_data_11,
  m1_.allow_node_generation AS allow_node_generation_12,
  m1_.display_memory_modules AS display_memory_modules_13,
  m1_.display_ssds AS display_ssds_14,
  m2_.id AS id_15,
  m2_.short_name AS short_name_16,
  m2_.name AS name_17,
  m2_.description AS description_18,
  m2_.legacy_url_slug AS legacy_url_slug_19,
  m2_.locale AS locale_20,
  n3_.node_type AS node_type_21,
  n3_.system_managed AS system_managed_22,
  n3_.id AS id_23,
  n3_.uuid AS uuid_24,
  n3_.created_at AS created_at_25,
  n3_.updated_at AS updated_at_26,
  n3_.handle AS handle_27,
  n3_.discr AS discr_28
FROM
  model_compatible_part m0_
  INNER JOIN model m1_ ON m0_.model_id = m1_.id
  INNER JOIN model_translation m2_ ON m1_.id = m2_.translatable_id
  INNER JOIN oem_model_node o4_ ON m1_.id = o4_.model_entity_id
  LEFT JOIN node n3_ ON o4_.id = n3_.id
WHERE
  m0_.oem_part_id = ?
  AND m2_.locale = ?
  AND m1_.active = ?

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m1_.poc_only AS poc_only_2, m1_.display_oem AS display_oem_3, m1_.id AS id_4, m1_.uuid AS uuid_5, m1_.created_at AS created_at_6, m1_.updated_at AS updated_at_7, m1_.handle AS handle_8, m1_.active AS active_9, m1_.legacy_id AS legacy_id_10, m1_.legacy_data AS legacy_data_11, m1_.allow_node_generation AS allow_node_generation_12, m1_.display_memory_modules AS display_memory_modules_13, m1_.display_ssds AS display_ssds_14, m2_.id AS id_15, m2_.short_name AS short_name_16, m2_.name AS name_17, m2_.description AS description_18, m2_.legacy_url_slug AS legacy_url_slug_19, m2_.locale AS locale_20, n3_.node_type AS node_type_21, n3_.system_managed AS system_managed_22, n3_.id AS id_23, n3_.uuid AS uuid_24, n3_.created_at AS created_at_25, n3_.updated_at AS updated_at_26, n3_.handle AS handle_27, n3_.discr AS discr_28 FROM model_compatible_part m0_ INNER JOIN model m1_ ON m0_.model_id = m1_.id INNER JOIN model_translation m2_ ON m1_.id = m2_.translatable_id INNER JOIN oem_model_node o4_ ON m1_.id = o4_.model_entity_id LEFT JOIN node n3_ ON o4_.id = n3_.id WHERE m0_.oem_part_id = 1983 AND m2_.locale = 'en' AND m1_.active = 1;