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

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_.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_.active AS active_21,
  m2_.name AS name_22,
  m2_.path_hint AS path_hint_23,
  m2_.main_title AS main_title_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_.locale AS locale_30,
  m3_.id AS id_31,
  m3_.short_name AS short_name_32,
  m3_.name AS name_33,
  m3_.description AS description_34,
  m3_.legacy_url_slug AS legacy_url_slug_35,
  m3_.locale AS locale_36,
  s4_.top_level AS top_level_37,
  s4_.popular AS popular_38,
  s4_.other AS other_39,
  s4_.id AS id_40,
  s4_.uuid AS uuid_41,
  s4_.created_at AS created_at_42,
  s4_.updated_at AS updated_at_43,
  s4_.handle AS handle_44,
  s4_.active AS active_45,
  s4_.materialized_path AS materialized_path_46,
  s4_.legacy_id AS legacy_id_47,
  s4_.legacy_secondary_id AS legacy_secondary_id_48,
  s4_.legacy_data AS legacy_data_49,
  s4_.legacy_duplicate_handle AS legacy_duplicate_handle_50,
  s4_.allow_node_generation AS allow_node_generation_51,
  s4_.display_memory_modules AS display_memory_modules_52,
  s4_.display_ssds AS display_ssds_53,
  b5_.popular AS popular_54,
  b5_.id AS id_55,
  b5_.uuid AS uuid_56,
  b5_.created_at AS created_at_57,
  b5_.updated_at AS updated_at_58,
  b5_.handle AS handle_59,
  b5_.active AS active_60,
  b5_.legacy_id AS legacy_id_61,
  m6_.popular AS popular_62,
  m6_.id AS id_63,
  m6_.uuid AS uuid_64,
  m6_.created_at AS created_at_65,
  m6_.updated_at AS updated_at_66,
  m6_.handle AS handle_67,
  m6_.active AS active_68,
  m6_.legacy_id AS legacy_id_69,
  m6_.legacy_secondary_id AS legacy_secondary_id_70,
  m6_.legacy_data AS legacy_data_71,
  m6_.legacy_url_slug AS legacy_url_slug_72,
  m6_.allow_node_generation AS allow_node_generation_73,
  m6_.display_memory_modules AS display_memory_modules_74,
  m6_.display_ssds AS display_ssds_75,
  m7_.file_name AS file_name_76,
  m7_.file_uri AS file_uri_77,
  m7_.file_mime AS file_mime_78,
  m7_.file_size AS file_size_79,
  m7_.status AS status_80,
  m7_.id AS id_81,
  m7_.uuid AS uuid_82,
  m7_.active AS active_83,
  m7_.locale_code AS locale_code_84,
  d8_.icon_uri AS icon_uri_85,
  d8_.id AS id_86,
  d8_.uuid AS uuid_87,
  d8_.handle AS handle_88,
  d8_.legacy_id AS legacy_id_89,
  o9_.oft_part_no AS oft_part_no_90,
  o9_.part_code_type AS part_code_type_91,
  o9_.item_amount AS item_amount_92,
  o9_.purchasable AS purchasable_93,
  o9_.memory_price_id AS memory_price_id_94,
  o9_.asin AS asin_95,
  o9_.id AS id_96,
  o9_.active AS active_97,
  n0_.discr AS discr_98,
  m10_.model_entity_id AS model_entity_id_99,
  m1_.brand_id AS brand_id_100,
  m1_.series_id AS series_id_101,
  m1_.model_image_id AS model_image_id_102,
  m1_.device_type_id AS device_type_id_103,
  m1_.model_category_brand_id AS model_category_brand_id_104,
  m1_.oem_brand_id AS oem_brand_id_105,
  m2_.translatable_id AS translatable_id_106,
  m3_.translatable_id AS translatable_id_107,
  s4_.brand_id AS brand_id_108,
  s4_.series_image_id AS series_image_id_109,
  s4_.model_category_brand_id AS model_category_brand_id_110,
  s4_.device_type_id AS device_type_id_111,
  b5_.brand_logo_id AS brand_logo_id_112,
  m6_.model_category_id AS model_category_id_113,
  m6_.brand_id AS brand_id_114,
  m6_.device_type_id AS device_type_id_115,
  o9_.stock_id AS stock_id_116,
  o9_.product_variant_id AS product_variant_id_117,
  o9_.memory_spec_id AS memory_spec_id_118
FROM
  model_node m10_
  INNER JOIN node n0_ ON m10_.id = n0_.id
  LEFT JOIN model m1_ ON m10_.model_entity_id = m1_.id
  LEFT JOIN model_node_translation m2_ ON m10_.id = m2_.translatable_id
  AND (m2_.locale = ?)
  LEFT JOIN model_translation m3_ ON m1_.id = m3_.translatable_id
  AND (m3_.locale = ?)
  LEFT JOIN series s4_ ON m1_.series_id = s4_.id
  LEFT JOIN brand b5_ ON m1_.brand_id = b5_.id
  LEFT JOIN model_category_brand m6_ ON m1_.model_category_brand_id = m6_.id
  LEFT JOIN managed_file m7_ ON m1_.model_image_id = m7_.id
  LEFT JOIN device_type d8_ ON m1_.device_type_id = d8_.id
  LEFT JOIN oft_part_code_model o11_ ON m1_.id = o11_.model_id
  LEFT JOIN oft_part_code o9_ ON o9_.id = o11_.oft_part_code_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_.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_.active AS active_21, m2_.name AS name_22, m2_.path_hint AS path_hint_23, m2_.main_title AS main_title_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_.locale AS locale_30, m3_.id AS id_31, m3_.short_name AS short_name_32, m3_.name AS name_33, m3_.description AS description_34, m3_.legacy_url_slug AS legacy_url_slug_35, m3_.locale AS locale_36, s4_.top_level AS top_level_37, s4_.popular AS popular_38, s4_.other AS other_39, s4_.id AS id_40, s4_.uuid AS uuid_41, s4_.created_at AS created_at_42, s4_.updated_at AS updated_at_43, s4_.handle AS handle_44, s4_.active AS active_45, s4_.materialized_path AS materialized_path_46, s4_.legacy_id AS legacy_id_47, s4_.legacy_secondary_id AS legacy_secondary_id_48, s4_.legacy_data AS legacy_data_49, s4_.legacy_duplicate_handle AS legacy_duplicate_handle_50, s4_.allow_node_generation AS allow_node_generation_51, s4_.display_memory_modules AS display_memory_modules_52, s4_.display_ssds AS display_ssds_53, b5_.popular AS popular_54, b5_.id AS id_55, b5_.uuid AS uuid_56, b5_.created_at AS created_at_57, b5_.updated_at AS updated_at_58, b5_.handle AS handle_59, b5_.active AS active_60, b5_.legacy_id AS legacy_id_61, m6_.popular AS popular_62, m6_.id AS id_63, m6_.uuid AS uuid_64, m6_.created_at AS created_at_65, m6_.updated_at AS updated_at_66, m6_.handle AS handle_67, m6_.active AS active_68, m6_.legacy_id AS legacy_id_69, m6_.legacy_secondary_id AS legacy_secondary_id_70, m6_.legacy_data AS legacy_data_71, m6_.legacy_url_slug AS legacy_url_slug_72, m6_.allow_node_generation AS allow_node_generation_73, m6_.display_memory_modules AS display_memory_modules_74, m6_.display_ssds AS display_ssds_75, m7_.file_name AS file_name_76, m7_.file_uri AS file_uri_77, m7_.file_mime AS file_mime_78, m7_.file_size AS file_size_79, m7_.status AS status_80, m7_.id AS id_81, m7_.uuid AS uuid_82, m7_.active AS active_83, m7_.locale_code AS locale_code_84, d8_.icon_uri AS icon_uri_85, d8_.id AS id_86, d8_.uuid AS uuid_87, d8_.handle AS handle_88, d8_.legacy_id AS legacy_id_89, o9_.oft_part_no AS oft_part_no_90, o9_.part_code_type AS part_code_type_91, o9_.item_amount AS item_amount_92, o9_.purchasable AS purchasable_93, o9_.memory_price_id AS memory_price_id_94, o9_.asin AS asin_95, o9_.id AS id_96, o9_.active AS active_97, n0_.discr AS discr_98, m10_.model_entity_id AS model_entity_id_99, m1_.brand_id AS brand_id_100, m1_.series_id AS series_id_101, m1_.model_image_id AS model_image_id_102, m1_.device_type_id AS device_type_id_103, m1_.model_category_brand_id AS model_category_brand_id_104, m1_.oem_brand_id AS oem_brand_id_105, m2_.translatable_id AS translatable_id_106, m3_.translatable_id AS translatable_id_107, s4_.brand_id AS brand_id_108, s4_.series_image_id AS series_image_id_109, s4_.model_category_brand_id AS model_category_brand_id_110, s4_.device_type_id AS device_type_id_111, b5_.brand_logo_id AS brand_logo_id_112, m6_.model_category_id AS model_category_id_113, m6_.brand_id AS brand_id_114, m6_.device_type_id AS device_type_id_115, o9_.stock_id AS stock_id_116, o9_.product_variant_id AS product_variant_id_117, o9_.memory_spec_id AS memory_spec_id_118 FROM model_node m10_ INNER JOIN node n0_ ON m10_.id = n0_.id LEFT JOIN model m1_ ON m10_.model_entity_id = m1_.id LEFT JOIN model_node_translation m2_ ON m10_.id = m2_.translatable_id AND (m2_.locale = 'en') LEFT JOIN model_translation m3_ ON m1_.id = m3_.translatable_id AND (m3_.locale = 'en') LEFT JOIN series s4_ ON m1_.series_id = s4_.id LEFT JOIN brand b5_ ON m1_.brand_id = b5_.id LEFT JOIN model_category_brand m6_ ON m1_.model_category_brand_id = m6_.id LEFT JOIN managed_file m7_ ON m1_.model_image_id = m7_.id LEFT JOIN device_type d8_ ON m1_.device_type_id = d8_.id LEFT JOIN oft_part_code_model o11_ ON m1_.id = o11_.model_id LEFT JOIN oft_part_code o9_ ON o9_.id = o11_.oft_part_code_id WHERE n0_.id = 561762;

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_entity_id AS model_entity_id_9,
  t1.discr
FROM
  modelssd_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.model_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_entity_id AS model_entity_id_9, t1.discr FROM modelssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_entity_id = 2771;

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_entity_id AS model_entity_id_9,
  t0.help_topic_id AS help_topic_id_10,
  t1.discr
FROM
  oem_model_node t0
  INNER JOIN node t1 ON t0.id = t1.id
WHERE
  t0.model_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_entity_id AS model_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM oem_model_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_entity_id = 2771;

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

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
  seriesssd_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 seriesssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.series_entity_id = 3302;

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

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

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

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/561762' AND t0.primary_path = 1 AND t0.active = 1;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  model_compatible_product m1_
  INNER JOIN model_compatible_product_variants m2_ ON m1_.id = m2_.model_compatible_product_id
  INNER JOIN product_variant p0_ ON p0_.id = m2_.product_variant_id
  INNER JOIN model m3_ ON m1_.model_id = m3_.id
  INNER JOIN product p4_ ON m1_.product_id = p4_.id
WHERE
  m3_.id = ?
  AND p0_.active = 1
  AND p4_.active = 1
  AND p4_.product_type = ?

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM model_compatible_product m1_ INNER JOIN model_compatible_product_variants m2_ ON m1_.id = m2_.model_compatible_product_id INNER JOIN product_variant p0_ ON p0_.id = m2_.product_variant_id INNER JOIN model m3_ ON m1_.model_id = m3_.id INNER JOIN product p4_ ON m1_.product_id = p4_.id WHERE m3_.id = 2771 AND p0_.active = 1 AND p4_.active = 1 AND p4_.product_type = 'memory_module';

SELECT
  m0_.id AS id_0,
  p1_.requires_shipping AS requires_shipping_1,
  p1_.position AS position_2,
  p1_.manage_stock AS manage_stock_3,
  p1_.product_variant_image_order AS product_variant_image_order_4,
  p1_.oem_match_data AS oem_match_data_5,
  p1_.id AS id_6,
  p1_.uuid AS uuid_7,
  p1_.created_at AS created_at_8,
  p1_.updated_at AS updated_at_9,
  p1_.handle AS handle_10,
  p1_.active AS active_11,
  p1_.legacy_id AS legacy_id_12,
  p2_.legacy_id AS legacy_id_13,
  p2_.product_type AS product_type_14,
  p2_.variant_selection_method AS variant_selection_method_15,
  p2_.component AS component_16,
  p2_.id AS id_17,
  p2_.uuid AS uuid_18,
  p2_.created_at AS created_at_19,
  p2_.updated_at AS updated_at_20,
  p2_.handle AS handle_21,
  p2_.active AS active_22,
  p2_.allow_node_generation AS allow_node_generation_23,
  n3_.node_type AS node_type_24,
  n3_.system_managed AS system_managed_25,
  n3_.id AS id_26,
  n3_.uuid AS uuid_27,
  n3_.created_at AS created_at_28,
  n3_.updated_at AS updated_at_29,
  n3_.handle AS handle_30,
  p4_.id AS id_31,
  p4_.name AS name_32,
  p4_.locale AS locale_33,
  p5_.id AS id_34,
  p6_.position AS position_35,
  p6_.id AS id_36,
  p6_.created_at AS created_at_37,
  p6_.updated_at AS updated_at_38,
  p6_.handle AS handle_39,
  p7_.id AS id_40,
  p7_.name AS name_41,
  p7_.locale AS locale_42,
  p8_.position AS position_43,
  p8_.id AS id_44,
  p8_.handle AS handle_45,
  p9_.value AS value_46,
  p9_.id AS id_47,
  p9_.locale AS locale_48,
  m10_.file_name AS file_name_49,
  m10_.file_uri AS file_uri_50,
  m10_.file_mime AS file_mime_51,
  m10_.file_size AS file_size_52,
  m10_.status AS status_53,
  m10_.id AS id_54,
  m10_.uuid AS uuid_55,
  m10_.active AS active_56,
  m10_.locale_code AS locale_code_57,
  o11_.id AS id_58,
  o11_.oem_number AS oem_number_59,
  p12_.name_updated AS name_updated_60,
  p12_.description_updated AS description_updated_61,
  p12_.id AS id_62,
  p12_.name AS name_63,
  p12_.description AS description_64,
  p12_.excerpt AS excerpt_65,
  p12_.locale AS locale_66,
  m0_.product_id AS product_id_67,
  m0_.model_id AS model_id_68,
  p1_.product_id AS product_id_69,
  p1_.stock_status_id AS stock_status_id_70,
  p2_.main_taxonomy_id AS main_taxonomy_id_71,
  p2_.device_type_id AS device_type_id_72,
  n3_.discr AS discr_73,
  p13_.product_entity_id AS product_entity_id_74,
  p13_.help_topic_id AS help_topic_id_75,
  p4_.translatable_id AS translatable_id_76,
  p5_.oem_number_id AS oem_number_id_77,
  p5_.product_variant_id AS product_variant_id_78,
  p7_.translatable_id AS translatable_id_79,
  p8_.product_option_id AS product_option_id_80,
  p9_.translatable_id AS translatable_id_81,
  p12_.translatable_id AS translatable_id_82
FROM
  model_compatible_product m0_
  INNER JOIN model_compatible_product_variants m14_ ON m0_.id = m14_.model_compatible_product_id
  INNER JOIN product_variant p1_ ON p1_.id = m14_.product_variant_id
  INNER JOIN product p2_ ON m0_.product_id = p2_.id
  LEFT JOIN product_node p13_ ON p2_.id = p13_.product_entity_id
  LEFT JOIN node n3_ ON p13_.id = n3_.id
  INNER JOIN product_variant_translation p4_ ON p1_.id = p4_.translatable_id
  LEFT JOIN product_variant_oem p5_ ON p1_.id = p5_.product_variant_id
  LEFT JOIN product_product_option p15_ ON p2_.id = p15_.product_id
  LEFT JOIN product_option p6_ ON p6_.id = p15_.product_option_id
  LEFT JOIN product_option_translation p7_ ON p6_.id = p7_.translatable_id
  LEFT JOIN product_variant_product_option_value p16_ ON p1_.id = p16_.product_variant_id
  LEFT JOIN product_option_value p8_ ON p8_.id = p16_.product_option_value_id
  LEFT JOIN product_option_value_translation p9_ ON p8_.id = p9_.translatable_id
  LEFT JOIN product_variant_featured_image p17_ ON p1_.id = p17_.product_variant_id
  LEFT JOIN managed_file m10_ ON m10_.id = p17_.managed_file_id
  LEFT JOIN oem_part_number o11_ ON p5_.oem_number_id = o11_.id
  INNER JOIN product_translation p12_ ON p2_.id = p12_.translatable_id
WHERE
  m0_.model_id = ?
  AND p2_.active = ?
  AND p4_.locale = ?
  AND p12_.locale = ?
  AND p9_.locale = ?
  AND p7_.locale = ?
  AND p2_.product_type = ?

SELECT m0_.id AS id_0, p1_.requires_shipping AS requires_shipping_1, p1_.position AS position_2, p1_.manage_stock AS manage_stock_3, p1_.product_variant_image_order AS product_variant_image_order_4, p1_.oem_match_data AS oem_match_data_5, p1_.id AS id_6, p1_.uuid AS uuid_7, p1_.created_at AS created_at_8, p1_.updated_at AS updated_at_9, p1_.handle AS handle_10, p1_.active AS active_11, p1_.legacy_id AS legacy_id_12, p2_.legacy_id AS legacy_id_13, p2_.product_type AS product_type_14, p2_.variant_selection_method AS variant_selection_method_15, p2_.component AS component_16, p2_.id AS id_17, p2_.uuid AS uuid_18, p2_.created_at AS created_at_19, p2_.updated_at AS updated_at_20, p2_.handle AS handle_21, p2_.active AS active_22, p2_.allow_node_generation AS allow_node_generation_23, n3_.node_type AS node_type_24, n3_.system_managed AS system_managed_25, n3_.id AS id_26, n3_.uuid AS uuid_27, n3_.created_at AS created_at_28, n3_.updated_at AS updated_at_29, n3_.handle AS handle_30, p4_.id AS id_31, p4_.name AS name_32, p4_.locale AS locale_33, p5_.id AS id_34, p6_.position AS position_35, p6_.id AS id_36, p6_.created_at AS created_at_37, p6_.updated_at AS updated_at_38, p6_.handle AS handle_39, p7_.id AS id_40, p7_.name AS name_41, p7_.locale AS locale_42, p8_.position AS position_43, p8_.id AS id_44, p8_.handle AS handle_45, p9_.value AS value_46, p9_.id AS id_47, p9_.locale AS locale_48, m10_.file_name AS file_name_49, m10_.file_uri AS file_uri_50, m10_.file_mime AS file_mime_51, m10_.file_size AS file_size_52, m10_.status AS status_53, m10_.id AS id_54, m10_.uuid AS uuid_55, m10_.active AS active_56, m10_.locale_code AS locale_code_57, o11_.id AS id_58, o11_.oem_number AS oem_number_59, p12_.name_updated AS name_updated_60, p12_.description_updated AS description_updated_61, p12_.id AS id_62, p12_.name AS name_63, p12_.description AS description_64, p12_.excerpt AS excerpt_65, p12_.locale AS locale_66, m0_.product_id AS product_id_67, m0_.model_id AS model_id_68, p1_.product_id AS product_id_69, p1_.stock_status_id AS stock_status_id_70, p2_.main_taxonomy_id AS main_taxonomy_id_71, p2_.device_type_id AS device_type_id_72, n3_.discr AS discr_73, p13_.product_entity_id AS product_entity_id_74, p13_.help_topic_id AS help_topic_id_75, p4_.translatable_id AS translatable_id_76, p5_.oem_number_id AS oem_number_id_77, p5_.product_variant_id AS product_variant_id_78, p7_.translatable_id AS translatable_id_79, p8_.product_option_id AS product_option_id_80, p9_.translatable_id AS translatable_id_81, p12_.translatable_id AS translatable_id_82 FROM model_compatible_product m0_ INNER JOIN model_compatible_product_variants m14_ ON m0_.id = m14_.model_compatible_product_id INNER JOIN product_variant p1_ ON p1_.id = m14_.product_variant_id INNER JOIN product p2_ ON m0_.product_id = p2_.id LEFT JOIN product_node p13_ ON p2_.id = p13_.product_entity_id LEFT JOIN node n3_ ON p13_.id = n3_.id INNER JOIN product_variant_translation p4_ ON p1_.id = p4_.translatable_id LEFT JOIN product_variant_oem p5_ ON p1_.id = p5_.product_variant_id LEFT JOIN product_product_option p15_ ON p2_.id = p15_.product_id LEFT JOIN product_option p6_ ON p6_.id = p15_.product_option_id LEFT JOIN product_option_translation p7_ ON p6_.id = p7_.translatable_id LEFT JOIN product_variant_product_option_value p16_ ON p1_.id = p16_.product_variant_id LEFT JOIN product_option_value p8_ ON p8_.id = p16_.product_option_value_id LEFT JOIN product_option_value_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN product_variant_featured_image p17_ ON p1_.id = p17_.product_variant_id LEFT JOIN managed_file m10_ ON m10_.id = p17_.managed_file_id LEFT JOIN oem_part_number o11_ ON p5_.oem_number_id = o11_.id INNER JOIN product_translation p12_ ON p2_.id = p12_.translatable_id WHERE m0_.model_id = 2771 AND p2_.active = 1 AND p4_.locale = 'en' AND p12_.locale = 'en' AND p9_.locale = 'en' AND p7_.locale = 'en' AND p2_.product_type = 'memory_module';