Symfony Profiler

Query Metrics

117 Database Queries

38 Different statements

340.77 ms Query time

0 Invalid entities

2378 Managed entities

2744 Cache hits

42 Cache misses

75 Cache puts

Queries

Group similar statements

default connection


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 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 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.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.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.path_hint AS path_hint_4, t0.main_title AS main_title_5, t0.description AS description_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_model_node_translation t0 WHERE t0.translatable_id = ?
SELECT o0_.id AS id_0 FROM model_compatible_part m1_ INNER JOIN oem_part o0_ ON m1_.oem_part_id = o0_.id WHERE m1_.model_id = ? AND o0_.active = ? ORDER BY o0_.position ASC
SELECT * FROM oem_attribute_value_mapping WHERE oem_part_id IN (2826,2827,2828,3243,8772,2823,2824,2825,3242,3355)
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, FIELD(entity_alias_0, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') 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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC) dctrn_result LIMIT 50
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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') 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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') 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, o1_.purchasable AS purchasable_7, o1_.part_number AS part_number_8, o1_.oem_part_image_order AS oem_part_image_order_9, o1_.position AS position_10, o1_.id AS id_11, o1_.uuid AS uuid_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.active AS active_15, o1_.allow_node_generation AS allow_node_generation_16, o2_.id AS id_17, o2_.name AS name_18, o2_.description AS description_19, o2_.locale AS locale_20, o3_.id AS id_21, o3_.name AS name_22, o3_.path_hint AS path_hint_23, o3_.active AS active_24, o3_.description AS description_25, o3_.main_title AS main_title_26, o3_.short_description AS short_description_27, o3_.page_title AS page_title_28, o3_.page_description AS page_description_29, o3_.allow_robots_index AS allow_robots_index_30, o3_.allow_robots_follow AS allow_robots_follow_31, o3_.additional_meta_tags AS additional_meta_tags_32, o3_.locale AS locale_33, m4_.file_name AS file_name_34, m4_.file_uri AS file_uri_35, m4_.file_mime AS file_mime_36, m4_.file_size AS file_size_37, m4_.status AS status_38, m4_.id AS id_39, m4_.uuid AS uuid_40, m4_.active AS active_41, m4_.locale_code AS locale_code_42, n0_.discr AS discr_43, o5_.oem_part_entity_id AS oem_part_entity_id_44, o5_.help_topic_id AS help_topic_id_45, o1_.part_code_type_id AS part_code_type_id_46, o1_.product_variant_id AS product_variant_id_47, o1_.oem_brand_id AS oem_brand_id_48, o1_.main_oem_category_id AS main_oem_category_id_49, o1_.main_oem_brand_category_id AS main_oem_brand_category_id_50, o1_.device_type_id AS device_type_id_51, o2_.translatable_id AS translatable_id_52, o3_.translatable_id AS translatable_id_53 FROM oem_part_page_node o5_ INNER JOIN node n0_ ON o5_.id = n0_.id LEFT JOIN oem_part o1_ ON o5_.oem_part_entity_id = o1_.id LEFT JOIN oem_part_translation o2_ ON o1_.id = o2_.translatable_id LEFT JOIN oem_part_page_node_translation o3_ ON o5_.id = o3_.translatable_id LEFT JOIN oem_part_featured_image o6_ ON o1_.id = o6_.oem_part_id LEFT JOIN managed_file m4_ ON m4_.id = o6_.managed_file_id WHERE o1_.active = ? AND o1_.id IN (2826, 2827, 2828, 3243, 8772, 2823, 2824, 2825, 3242, 3355) AND o2_.locale = ? AND o3_.locale = ? ORDER BY o2_.name ASC
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ?
SELECT t0.poc_only AS poc_only_1, t0.display_oem AS display_oem_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.legacy_id AS legacy_id_9, t0.legacy_data AS legacy_data_10, t0.allow_node_generation AS allow_node_generation_11, t0.display_memory_modules AS display_memory_modules_12, t0.display_ssds AS display_ssds_13, t0.brand_id AS brand_id_14, t0.series_id AS series_id_15, t0.model_image_id AS model_image_id_16, t0.device_type_id AS device_type_id_17, t0.model_category_brand_id AS model_category_brand_id_18, t0.oem_brand_id AS oem_brand_id_19 FROM model t0 WHERE t0.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 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, 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, 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 t0.popular AS popular_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.brand_logo_id AS brand_logo_id_9, t10.total AS total_11, t10.id AS id_12, t10.brand_id AS brand_id_13 FROM brand t0 LEFT JOIN models_upgraded t10 ON t10.brand_id = t0.id WHERE t0.id = ?
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 model_attribute_value mav
                INNER JOIN model_attribute ma ON mav.attribute_id = ma.id
                INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? 
                INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id 
                WHERE mavm.model_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 global_attribute_value mav
                INNER JOIN global_attribute ma ON mav.attribute_id = ma.id
                INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? 
                INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id 
                WHERE mavm.model_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 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 m0_.oem_part_id) AS sclr_0 FROM model_compatible_part m0_ INNER JOIN oem_part o1_ ON m0_.oem_part_id = o1_.id WHERE o1_.active = 1 AND m0_.model_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 = ?
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 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.short_name AS short_name_2, t0.name AS name_3, t0.description AS description_4, t0.legacy_url_slug AS legacy_url_slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM model_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 = ?
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.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = ?
SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?)
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 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 s0_.type AS type_0, s0_.price AS price_1, s0_.max_order_value AS max_order_value_2, s0_.min_order_value AS min_order_value_3, s0_.courier AS courier_4, s0_.config AS config_5, s0_.recommended AS recommended_6, s0_.position AS position_7, s0_.country_code AS country_code_8, s0_.product_code AS product_code_9, s0_.product_code_title AS product_code_title_10, s0_.tid AS tid_11, s0_.delivery_time_min AS delivery_time_min_12, s0_.delivery_time_max AS delivery_time_max_13, s0_.id AS id_14, s0_.uuid AS uuid_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.active AS active_18, s1_.description AS description_19, s1_.additional_text AS additional_text_20, s1_.id AS id_21, s1_.name AS name_22, s1_.locale AS locale_23, s1_.translatable_id AS translatable_id_24 FROM shipping_method s0_ LEFT JOIN shipping_method_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.country_code = ? AND s0_.active = 1 ORDER BY s0_.position ASC LIMIT 100
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ?
SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1
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 = ? AND t0.model_id = ? 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 = ? AND t0.channel_id = ? AND t0.feedback_stars = ? AND t0.clean = ? AND t0.valid = ? ORDER BY t0.feedback_time DESC LIMIT 12
SELECT t0.content AS content_1, t0.id AS id_2, t0.name AS name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM modal_translation t0 WHERE t0.translatable_id = ?

#▲	Time	Info
1	0.48 ms	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 Parameters: [`"/hp-compaq-storageworks-msa500-g2-oem" "en" 1`] View formatted query View runnable query Explain query 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 = '/hp-compaq-storageworks-msa500-g2-oem' AND t0.locale_code = 'en' AND t0.active = 1 LIMIT 1;
2	0.67 ms	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 = ? Parameters: [`555369`] View formatted query View runnable query Explain query 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 = 555369;
3	0.90 ms	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 Parameters: [`555369`] View formatted query View runnable query Explain query 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 = 555369 LIMIT 1;
4	0.62 ms	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 = ? Parameters: [`"node/555369" 1 1`] View formatted query View runnable query Explain query 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/555369' AND t0.primary_path = 1 AND t0.active = 1;
5	0.53 ms	SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.path_hint AS path_hint_4, t0.main_title AS main_title_5, t0.description AS description_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_model_node_translation t0 WHERE t0.translatable_id = ? Parameters: [`555369`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.path_hint AS path_hint_4, t0.main_title AS main_title_5, t0.description AS description_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_model_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.main_title AS main_title_5, t0.description AS description_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_model_node_translation t0 WHERE t0.translatable_id = 555369;
6	0.56 ms	SELECT o0_.id AS id_0 FROM model_compatible_part m1_ INNER JOIN oem_part o0_ ON m1_.oem_part_id = o0_.id WHERE m1_.model_id = ? AND o0_.active = ? ORDER BY o0_.position ASC Parameters: [`264282 1`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0 FROM model_compatible_part m1_ INNER JOIN oem_part o0_ ON m1_.oem_part_id = o0_.id WHERE m1_.model_id = ? AND o0_.active = ? ORDER BY o0_.position ASC SELECT o0_.id AS id_0 FROM model_compatible_part m1_ INNER JOIN oem_part o0_ ON m1_.oem_part_id = o0_.id WHERE m1_.model_id = 264282 AND o0_.active = 1 ORDER BY o0_.position ASC;
7	0.91 ms	SELECT * FROM oem_attribute_value_mapping WHERE oem_part_id IN (2826,2827,2828,3243,8772,2823,2824,2825,3242,3355) Parameters: [] View formatted query View runnable query Explain query SELECT * FROM oem_attribute_value_mapping WHERE oem_part_id IN ( 2826, 2827, 2828, 3243, 8772, 2823, 2824, 2825, 3242, 3355 ) SELECT * FROM oem_attribute_value_mapping WHERE oem_part_id IN (2826,2827,2828,3243,8772,2823,2824,2825,3242,3355);
8	0.58 ms	SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, FIELD(entity_alias_0, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') 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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC) dctrn_result LIMIT 50 Parameters: [`"oempart/2826" "oempart/2827" "oempart/2828" "oempart/3243" "oempart/8772" "oempart/2823" "oempart/2824" "oempart/2825" "oempart/3242" "oempart/3355"`] View formatted query View runnable query Explain query SELECT DISTINCT id_3 FROM ( SELECT DISTINCT id_3, FIELD( entity_alias_0, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355' ) 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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355' ) ASC ) dctrn_result LIMIT 50 SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, FIELD(entity_alias_0, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') 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 ('oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355')) dctrn_result_inner ORDER BY FIELD(entity_alias_0, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC) dctrn_result LIMIT 50;
9	0.41 ms	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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC Parameters: [`"oempart/2826" "oempart/2827" "oempart/2828" "oempart/3243" "oempart/8772" "oempart/2823" "oempart/2824" "oempart/2825" "oempart/3242" "oempart/3355" 287872 286870 290335 290384 289800 287871 286869 290334 290383 287948`] View formatted query View runnable query Explain query 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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355' ) 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 ('oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') AND e0_.id IN (287872, 286870, 290335, 290384, 289800, 287871, 286869, 290334, 290383, 287948) ORDER BY FIELD(e0_.entity_alias, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC;
10	0.47 ms	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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC) dctrn_result) dctrn_table Parameters: [`"oempart/2826" "oempart/2827" "oempart/2828" "oempart/3243" "oempart/8772" "oempart/2823" "oempart/2824" "oempart/2825" "oempart/3242" "oempart/3355"`] View formatted query View runnable query Explain query 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, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355' ) 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 ('oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ORDER BY FIELD(e0_.entity_alias, 'oempart/2826', 'oempart/2827', 'oempart/2828', 'oempart/3243', 'oempart/8772', 'oempart/2823', 'oempart/2824', 'oempart/2825', 'oempart/3242', 'oempart/3355') ASC) dctrn_result) dctrn_table;
11	1.50 ms	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, o1_.purchasable AS purchasable_7, o1_.part_number AS part_number_8, o1_.oem_part_image_order AS oem_part_image_order_9, o1_.position AS position_10, o1_.id AS id_11, o1_.uuid AS uuid_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.active AS active_15, o1_.allow_node_generation AS allow_node_generation_16, o2_.id AS id_17, o2_.name AS name_18, o2_.description AS description_19, o2_.locale AS locale_20, o3_.id AS id_21, o3_.name AS name_22, o3_.path_hint AS path_hint_23, o3_.active AS active_24, o3_.description AS description_25, o3_.main_title AS main_title_26, o3_.short_description AS short_description_27, o3_.page_title AS page_title_28, o3_.page_description AS page_description_29, o3_.allow_robots_index AS allow_robots_index_30, o3_.allow_robots_follow AS allow_robots_follow_31, o3_.additional_meta_tags AS additional_meta_tags_32, o3_.locale AS locale_33, m4_.file_name AS file_name_34, m4_.file_uri AS file_uri_35, m4_.file_mime AS file_mime_36, m4_.file_size AS file_size_37, m4_.status AS status_38, m4_.id AS id_39, m4_.uuid AS uuid_40, m4_.active AS active_41, m4_.locale_code AS locale_code_42, n0_.discr AS discr_43, o5_.oem_part_entity_id AS oem_part_entity_id_44, o5_.help_topic_id AS help_topic_id_45, o1_.part_code_type_id AS part_code_type_id_46, o1_.product_variant_id AS product_variant_id_47, o1_.oem_brand_id AS oem_brand_id_48, o1_.main_oem_category_id AS main_oem_category_id_49, o1_.main_oem_brand_category_id AS main_oem_brand_category_id_50, o1_.device_type_id AS device_type_id_51, o2_.translatable_id AS translatable_id_52, o3_.translatable_id AS translatable_id_53 FROM oem_part_page_node o5_ INNER JOIN node n0_ ON o5_.id = n0_.id LEFT JOIN oem_part o1_ ON o5_.oem_part_entity_id = o1_.id LEFT JOIN oem_part_translation o2_ ON o1_.id = o2_.translatable_id LEFT JOIN oem_part_page_node_translation o3_ ON o5_.id = o3_.translatable_id LEFT JOIN oem_part_featured_image o6_ ON o1_.id = o6_.oem_part_id LEFT JOIN managed_file m4_ ON m4_.id = o6_.managed_file_id WHERE o1_.active = ? AND o1_.id IN (2826, 2827, 2828, 3243, 8772, 2823, 2824, 2825, 3242, 3355) AND o2_.locale = ? AND o3_.locale = ? ORDER BY o2_.name ASC Parameters: [`1 "en" "en"`] View formatted query View runnable query Explain query 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, o1_.purchasable AS purchasable_7, o1_.part_number AS part_number_8, o1_.oem_part_image_order AS oem_part_image_order_9, o1_.position AS position_10, o1_.id AS id_11, o1_.uuid AS uuid_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.active AS active_15, o1_.allow_node_generation AS allow_node_generation_16, o2_.id AS id_17, o2_.name AS name_18, o2_.description AS description_19, o2_.locale AS locale_20, o3_.id AS id_21, o3_.name AS name_22, o3_.path_hint AS path_hint_23, o3_.active AS active_24, o3_.description AS description_25, o3_.main_title AS main_title_26, o3_.short_description AS short_description_27, o3_.page_title AS page_title_28, o3_.page_description AS page_description_29, o3_.allow_robots_index AS allow_robots_index_30, o3_.allow_robots_follow AS allow_robots_follow_31, o3_.additional_meta_tags AS additional_meta_tags_32, o3_.locale AS locale_33, m4_.file_name AS file_name_34, m4_.file_uri AS file_uri_35, m4_.file_mime AS file_mime_36, m4_.file_size AS file_size_37, m4_.status AS status_38, m4_.id AS id_39, m4_.uuid AS uuid_40, m4_.active AS active_41, m4_.locale_code AS locale_code_42, n0_.discr AS discr_43, o5_.oem_part_entity_id AS oem_part_entity_id_44, o5_.help_topic_id AS help_topic_id_45, o1_.part_code_type_id AS part_code_type_id_46, o1_.product_variant_id AS product_variant_id_47, o1_.oem_brand_id AS oem_brand_id_48, o1_.main_oem_category_id AS main_oem_category_id_49, o1_.main_oem_brand_category_id AS main_oem_brand_category_id_50, o1_.device_type_id AS device_type_id_51, o2_.translatable_id AS translatable_id_52, o3_.translatable_id AS translatable_id_53 FROM oem_part_page_node o5_ INNER JOIN node n0_ ON o5_.id = n0_.id LEFT JOIN oem_part o1_ ON o5_.oem_part_entity_id = o1_.id LEFT JOIN oem_part_translation o2_ ON o1_.id = o2_.translatable_id LEFT JOIN oem_part_page_node_translation o3_ ON o5_.id = o3_.translatable_id LEFT JOIN oem_part_featured_image o6_ ON o1_.id = o6_.oem_part_id LEFT JOIN managed_file m4_ ON m4_.id = o6_.managed_file_id WHERE o1_.active = ? AND o1_.id IN ( 2826, 2827, 2828, 3243, 8772, 2823, 2824, 2825, 3242, 3355 ) AND o2_.locale = ? AND o3_.locale = ? ORDER BY o2_.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, o1_.purchasable AS purchasable_7, o1_.part_number AS part_number_8, o1_.oem_part_image_order AS oem_part_image_order_9, o1_.position AS position_10, o1_.id AS id_11, o1_.uuid AS uuid_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.active AS active_15, o1_.allow_node_generation AS allow_node_generation_16, o2_.id AS id_17, o2_.name AS name_18, o2_.description AS description_19, o2_.locale AS locale_20, o3_.id AS id_21, o3_.name AS name_22, o3_.path_hint AS path_hint_23, o3_.active AS active_24, o3_.description AS description_25, o3_.main_title AS main_title_26, o3_.short_description AS short_description_27, o3_.page_title AS page_title_28, o3_.page_description AS page_description_29, o3_.allow_robots_index AS allow_robots_index_30, o3_.allow_robots_follow AS allow_robots_follow_31, o3_.additional_meta_tags AS additional_meta_tags_32, o3_.locale AS locale_33, m4_.file_name AS file_name_34, m4_.file_uri AS file_uri_35, m4_.file_mime AS file_mime_36, m4_.file_size AS file_size_37, m4_.status AS status_38, m4_.id AS id_39, m4_.uuid AS uuid_40, m4_.active AS active_41, m4_.locale_code AS locale_code_42, n0_.discr AS discr_43, o5_.oem_part_entity_id AS oem_part_entity_id_44, o5_.help_topic_id AS help_topic_id_45, o1_.part_code_type_id AS part_code_type_id_46, o1_.product_variant_id AS product_variant_id_47, o1_.oem_brand_id AS oem_brand_id_48, o1_.main_oem_category_id AS main_oem_category_id_49, o1_.main_oem_brand_category_id AS main_oem_brand_category_id_50, o1_.device_type_id AS device_type_id_51, o2_.translatable_id AS translatable_id_52, o3_.translatable_id AS translatable_id_53 FROM oem_part_page_node o5_ INNER JOIN node n0_ ON o5_.id = n0_.id LEFT JOIN oem_part o1_ ON o5_.oem_part_entity_id = o1_.id LEFT JOIN oem_part_translation o2_ ON o1_.id = o2_.translatable_id LEFT JOIN oem_part_page_node_translation o3_ ON o5_.id = o3_.translatable_id LEFT JOIN oem_part_featured_image o6_ ON o1_.id = o6_.oem_part_id LEFT JOIN managed_file m4_ ON m4_.id = o6_.managed_file_id WHERE o1_.active = 1 AND o1_.id IN (2826, 2827, 2828, 3243, 8772, 2823, 2824, 2825, 3242, 3355) AND o2_.locale = 'en' AND o3_.locale = 'en' ORDER BY o2_.name ASC;
12	0.25 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`2825`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 2825;
13	0.24 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`2823`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 2823;
14	0.22 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`2824`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 2824;
15	0.21 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`3355`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 3355;
16	0.22 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`2826`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 2826;
17	0.25 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`2827`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 2827;
18	0.23 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`3243`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 3243;
19	0.21 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`3242`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 3242;
20	0.21 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`2828`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 2828;
21	0.20 ms	SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? Parameters: [`8772`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = ? SELECT t0.id AS id_1, t0.feed_id AS feed_id_2, t0.disallowed_condition_types AS disallowed_condition_types_3, t0.oem_part_id AS oem_part_id_4 FROM product_feed_oem_part t0 WHERE t0.oem_part_id = 8772;
22	0.28 ms	SELECT t0.poc_only AS poc_only_1, t0.display_oem AS display_oem_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.legacy_id AS legacy_id_9, t0.legacy_data AS legacy_data_10, t0.allow_node_generation AS allow_node_generation_11, t0.display_memory_modules AS display_memory_modules_12, t0.display_ssds AS display_ssds_13, t0.brand_id AS brand_id_14, t0.series_id AS series_id_15, t0.model_image_id AS model_image_id_16, t0.device_type_id AS device_type_id_17, t0.model_category_brand_id AS model_category_brand_id_18, t0.oem_brand_id AS oem_brand_id_19 FROM model t0 WHERE t0.id = ? Parameters: [`264282`] View formatted query View runnable query Explain query SELECT t0.poc_only AS poc_only_1, t0.display_oem AS display_oem_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.legacy_id AS legacy_id_9, t0.legacy_data AS legacy_data_10, t0.allow_node_generation AS allow_node_generation_11, t0.display_memory_modules AS display_memory_modules_12, t0.display_ssds AS display_ssds_13, t0.brand_id AS brand_id_14, t0.series_id AS series_id_15, t0.model_image_id AS model_image_id_16, t0.device_type_id AS device_type_id_17, t0.model_category_brand_id AS model_category_brand_id_18, t0.oem_brand_id AS oem_brand_id_19 FROM model t0 WHERE t0.id = ? SELECT t0.poc_only AS poc_only_1, t0.display_oem AS display_oem_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.legacy_id AS legacy_id_9, t0.legacy_data AS legacy_data_10, t0.allow_node_generation AS allow_node_generation_11, t0.display_memory_modules AS display_memory_modules_12, t0.display_ssds AS display_ssds_13, t0.brand_id AS brand_id_14, t0.series_id AS series_id_15, t0.model_image_id AS model_image_id_16, t0.device_type_id AS device_type_id_17, t0.model_category_brand_id AS model_category_brand_id_18, t0.oem_brand_id AS oem_brand_id_19 FROM model t0 WHERE t0.id = 264282;
23	0.28 ms	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 model_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_entity_id = ? Parameters: [`264282`] View formatted query View runnable query Explain query 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 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, t1.discr FROM model_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_entity_id = 264282;
24	0.33 ms	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 = ? Parameters: [`264282`] View formatted query View runnable query Explain query 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 = 264282;
25	0.31 ms	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 = ? Parameters: [`264282`] View formatted query View runnable query Explain query 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 = 264282;
26	0.28 ms	SELECT t0.popular AS popular_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.brand_logo_id AS brand_logo_id_9, t10.total AS total_11, t10.id AS id_12, t10.brand_id AS brand_id_13 FROM brand t0 LEFT JOIN models_upgraded t10 ON t10.brand_id = t0.id WHERE t0.id = ? Parameters: [`107`] View formatted query View runnable query Explain query SELECT t0.popular AS popular_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.brand_logo_id AS brand_logo_id_9, t10.total AS total_11, t10.id AS id_12, t10.brand_id AS brand_id_13 FROM brand t0 LEFT JOIN models_upgraded t10 ON t10.brand_id = t0.id WHERE t0.id = ? SELECT t0.popular AS popular_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.brand_logo_id AS brand_logo_id_9, t10.total AS total_11, t10.id AS id_12, t10.brand_id AS brand_id_13 FROM brand t0 LEFT JOIN models_upgraded t10 ON t10.brand_id = t0.id WHERE t0.id = 107;
27	0.49 ms	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 model_attribute_value mav INNER JOIN model_attribute ma ON mav.attribute_id = ma.id INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id WHERE mavm.model_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 Parameters: [`"en" 264282 "en"`] View formatted query View runnable query Explain query 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 model_attribute_value mav INNER JOIN model_attribute ma ON mav.attribute_id = ma.id INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id WHERE mavm.model_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 model_attribute_value mav INNER JOIN model_attribute ma ON mav.attribute_id = ma.id INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = 'en' INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id WHERE mavm.model_id = 264282 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 ;
28	0.44 ms	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 global_attribute_value mav INNER JOIN global_attribute ma ON mav.attribute_id = ma.id INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id WHERE mavm.model_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 Parameters: [`"en" 264282 "en"`] View formatted query View runnable query Explain query 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 global_attribute_value mav INNER JOIN global_attribute ma ON mav.attribute_id = ma.id INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id WHERE mavm.model_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 global_attribute_value mav INNER JOIN global_attribute ma ON mav.attribute_id = ma.id INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = 'en' INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id WHERE mavm.model_id = 264282 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 ;
29	0.38 ms	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 = ? Parameters: [`264282 "memory_module"`] View formatted query View runnable query Explain query 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 = 264282 AND p0_.active = 1 AND p4_.active = 1 AND p4_.product_type = 'memory_module';
30	0.30 ms	SELECT COUNT(DISTINCT m0_.oem_part_id) AS sclr_0 FROM model_compatible_part m0_ INNER JOIN oem_part o1_ ON m0_.oem_part_id = o1_.id WHERE o1_.active = 1 AND m0_.model_id = ? Parameters: [`264282`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT m0_.oem_part_id) AS sclr_0 FROM model_compatible_part m0_ INNER JOIN oem_part o1_ ON m0_.oem_part_id = o1_.id WHERE o1_.active = 1 AND m0_.model_id = ? SELECT COUNT(DISTINCT m0_.oem_part_id) AS sclr_0 FROM model_compatible_part m0_ INNER JOIN oem_part o1_ ON m0_.oem_part_id = o1_.id WHERE o1_.active = 1 AND m0_.model_id = 264282;
31	0.19 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
32	0.25 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
33	0.22 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
34	0.28 ms	SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.description AS description_4, t0.legacy_url_slug AS legacy_url_slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM model_translation t0 WHERE t0.translatable_id = ? Parameters: [`264282`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.description AS description_4, t0.legacy_url_slug AS legacy_url_slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM model_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.description AS description_4, t0.legacy_url_slug AS legacy_url_slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM model_translation t0 WHERE t0.translatable_id = 264282;
35	0.22 ms	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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
36	0.40 ms	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 = ? Parameters: [`107`] View formatted query View runnable query Explain query 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 = 107;
37	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = 5;
38	0.30 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM oem_attribute_translation t0 WHERE t0.translatable_id = 6;
39	0.38 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`2825`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 2825 ORDER BY t0.position ASC;
40	0.29 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8475`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8475);
41	0.26 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8474`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8474);
42	0.25 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8473`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8473);
43	1.40 ms	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 Parameters: [`"en" 2825 "en"`] View formatted query View runnable query Explain query 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 = 2825 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 ;
44	0.44 ms	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 Parameters: [`"node/549337" "en" 1 1`] View formatted query View runnable query Explain query 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/549337' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
45	0.39 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`2823`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 2823 ORDER BY t0.position ASC;
46	0.28 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8469`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8469);
47	0.26 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8468`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8468);
48	0.24 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8467`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8467);
49	1.36 ms	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 Parameters: [`"en" 2823 "en"`] View formatted query View runnable query Explain query 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 = 2823 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 ;
50	0.46 ms	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 Parameters: [`"node/549335" "en" 1 1`] View formatted query View runnable query Explain query 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/549335' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
51	0.36 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`2824`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 2824 ORDER BY t0.position ASC;
52	0.28 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8472`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8472);
53	0.25 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8471`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8471);
54	0.24 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8470`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8470);
55	1.37 ms	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 Parameters: [`"en" 2824 "en"`] View formatted query View runnable query Explain query 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 = 2824 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 ;
56	0.47 ms	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 Parameters: [`"node/549336" "en" 1 1`] View formatted query View runnable query Explain query 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/549336' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
57	0.38 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`3355`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 3355 ORDER BY t0.position ASC;
58	0.30 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 10065`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 10065);
59	0.26 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 10064`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 10064);
60	0.25 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 10063`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 10063);
61	1.30 ms	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 Parameters: [`"en" 3355 "en"`] View formatted query View runnable query Explain query 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 = 3355 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 ;
62	0.45 ms	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 Parameters: [`"node/549867" "en" 1 1`] View formatted query View runnable query Explain query 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/549867' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
63	0.33 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`2826`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 2826 ORDER BY t0.position ASC;
64	0.23 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8477`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8477);
65	0.23 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8478`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8478);
66	0.26 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8476`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8476);
67	1.25 ms	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 Parameters: [`"en" 2826 "en"`] View formatted query View runnable query Explain query 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 = 2826 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 ;
68	0.43 ms	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 Parameters: [`"node/549338" "en" 1 1`] View formatted query View runnable query Explain query 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/549338' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
69	0.36 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`2827`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 2827 ORDER BY t0.position ASC;
70	0.24 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8480`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8480);
71	0.23 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8481`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8481);
72	0.22 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8479`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8479);
73	1.27 ms	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 Parameters: [`"en" 2827 "en"`] View formatted query View runnable query Explain query 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 = 2827 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 ;
74	0.42 ms	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 Parameters: [`"node/549339" "en" 1 1`] View formatted query View runnable query Explain query 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/549339' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
75	0.33 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`3243`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 3243 ORDER BY t0.position ASC;
76	0.24 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 9728`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 9728);
77	0.23 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 9729`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 9729);
78	0.23 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 9727`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 9727);
79	0.88 ms	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 Parameters: [`"en" 3243 "en"`] View formatted query View runnable query Explain query 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 = 3243 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 ;
80	0.37 ms	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 Parameters: [`"node/549755" "en" 1 1`] View formatted query View runnable query Explain query 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/549755' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
81	0.39 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`3242`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 3242 ORDER BY t0.position ASC;
82	0.29 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 9726`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 9726);
83	0.29 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 9725`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 9725);
84	0.30 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 9724`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 9724);
85	1.28 ms	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 Parameters: [`"en" 3242 "en"`] View formatted query View runnable query Explain query 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 = 3242 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 ;
86	0.52 ms	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 Parameters: [`"node/549754" "en" 1 1`] View formatted query View runnable query Explain query 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/549754' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
87	0.44 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`2828`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 2828 ORDER BY t0.position ASC;
88	0.33 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8483`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8483);
89	0.31 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8484`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8484);
90	0.30 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 8482`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 8482);
91	1.26 ms	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 Parameters: [`"en" 2828 "en"`] View formatted query View runnable query Explain query 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 = 2828 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 ;
92	0.46 ms	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 Parameters: [`"node/549340" "en" 1 1`] View formatted query View runnable query Explain query 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/549340' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
93	0.37 ms	SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC Parameters: [`8772`] View formatted query View runnable query Explain query SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = ? ORDER BY t0.position ASC SELECT t0.stock_level AS stock_level_1, t0.updated_at AS updated_at_2, t0.purchasable AS purchasable_3, t0.position AS position_4, t0.id AS id_5, t0.part_condition_type_id AS part_condition_type_id_6, t0.oem_part_id AS oem_part_id_7, t0.stock_status_id AS stock_status_id_8, t0.warranty_id AS warranty_id_9 FROM oem_part_stock t0 WHERE t0.oem_part_id = 8772 ORDER BY t0.position ASC;
94	0.28 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 26316`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 26316);
95	0.30 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 26315`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 26315);
96	0.29 ms	SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oem_part_stock = ?) Parameters: [`1 26314`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oem_part_stock = ? ) SELECT t0.price AS price_1, t0.sale_price AS sale_price_2, t0.old_price AS old_price_3, t0.id AS id_4, t0.channel_id AS channel_id_5, t0.oem_part_stock AS oem_part_stock_6 FROM oem_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oem_part_stock = 26314);
97	1.29 ms	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 Parameters: [`"en" 8772 "en"`] View formatted query View runnable query Explain query 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 = 8772 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 ;
98	0.49 ms	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 Parameters: [`"node/556930" "en" 1 1`] View formatted query View runnable query Explain query 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/556930' AND t0.locale_code = 'en' AND t0.active = 1 AND t0.primary_path = 1 LIMIT 1;
99	0.88 ms	SELECT s0_.type AS type_0, s0_.price AS price_1, s0_.max_order_value AS max_order_value_2, s0_.min_order_value AS min_order_value_3, s0_.courier AS courier_4, s0_.config AS config_5, s0_.recommended AS recommended_6, s0_.position AS position_7, s0_.country_code AS country_code_8, s0_.product_code AS product_code_9, s0_.product_code_title AS product_code_title_10, s0_.tid AS tid_11, s0_.delivery_time_min AS delivery_time_min_12, s0_.delivery_time_max AS delivery_time_max_13, s0_.id AS id_14, s0_.uuid AS uuid_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.active AS active_18, s1_.description AS description_19, s1_.additional_text AS additional_text_20, s1_.id AS id_21, s1_.name AS name_22, s1_.locale AS locale_23, s1_.translatable_id AS translatable_id_24 FROM shipping_method s0_ LEFT JOIN shipping_method_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.country_code = ? AND s0_.active = 1 ORDER BY s0_.position ASC LIMIT 100 Parameters: [`"GB"`] View formatted query View runnable query Explain query SELECT s0_.type AS type_0, s0_.price AS price_1, s0_.max_order_value AS max_order_value_2, s0_.min_order_value AS min_order_value_3, s0_.courier AS courier_4, s0_.config AS config_5, s0_.recommended AS recommended_6, s0_.position AS position_7, s0_.country_code AS country_code_8, s0_.product_code AS product_code_9, s0_.product_code_title AS product_code_title_10, s0_.tid AS tid_11, s0_.delivery_time_min AS delivery_time_min_12, s0_.delivery_time_max AS delivery_time_max_13, s0_.id AS id_14, s0_.uuid AS uuid_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.active AS active_18, s1_.description AS description_19, s1_.additional_text AS additional_text_20, s1_.id AS id_21, s1_.name AS name_22, s1_.locale AS locale_23, s1_.translatable_id AS translatable_id_24 FROM shipping_method s0_ LEFT JOIN shipping_method_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.country_code = ? AND s0_.active = 1 ORDER BY s0_.position ASC LIMIT 100 SELECT s0_.type AS type_0, s0_.price AS price_1, s0_.max_order_value AS max_order_value_2, s0_.min_order_value AS min_order_value_3, s0_.courier AS courier_4, s0_.config AS config_5, s0_.recommended AS recommended_6, s0_.position AS position_7, s0_.country_code AS country_code_8, s0_.product_code AS product_code_9, s0_.product_code_title AS product_code_title_10, s0_.tid AS tid_11, s0_.delivery_time_min AS delivery_time_min_12, s0_.delivery_time_max AS delivery_time_max_13, s0_.id AS id_14, s0_.uuid AS uuid_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.active AS active_18, s1_.description AS description_19, s1_.additional_text AS additional_text_20, s1_.id AS id_21, s1_.name AS name_22, s1_.locale AS locale_23, s1_.translatable_id AS translatable_id_24 FROM shipping_method s0_ LEFT JOIN shipping_method_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.country_code = 'GB' AND s0_.active = 1 ORDER BY s0_.position ASC LIMIT 100;
100	0.27 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"returns-and-refunds" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'returns-and-refunds' AND t0.active = 1 LIMIT 1;
101	0.22 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`4`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 4;
102	0.33 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"company-profile" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'company-profile' AND t0.active = 1 LIMIT 1;
103	0.23 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`8`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 8;
104	0.22 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"compatibility-guarantee" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'compatibility-guarantee' AND t0.active = 1 LIMIT 1;
105	0.21 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`14`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 14;
106	0.21 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"why-buy-from-us" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'why-buy-from-us' AND t0.active = 1 LIMIT 1;
107	0.19 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 2;
108	0.19 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"weee-directive" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'weee-directive' AND t0.active = 1 LIMIT 1;
109	0.18 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`13`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 13;
110	0.19 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"payment-options" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'payment-options' AND t0.active = 1 LIMIT 1;
111	0.18 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`7`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 7;
112	0.21 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"security-privacy" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'security-privacy' AND t0.active = 1 LIMIT 1;
113	0.22 ms	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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = ? Parameters: [`5`] View formatted query View runnable query Explain query 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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_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.page_entity_id AS page_entity_id_9, t1.discr FROM page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.page_entity_id = 5;
114	0.21 ms	SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 Parameters: [`"company-profile" 1`] View formatted query View runnable query Explain query SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = ? AND t0.active = ? LIMIT 1 SELECT t0.config AS config_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.legacy_id AS legacy_id_8, t0.legacy_data AS legacy_data_9, t0.allow_node_generation AS allow_node_generation_10, t0.parent_page_id AS parent_page_id_11 FROM page t0 WHERE t0.handle = 'company-profile' AND t0.active = 1 LIMIT 1;
115	141.21 ms	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 = ? AND t0.model_id = ? ORDER BY t0.feedback_time DESC LIMIT 12 Parameters: [`"uk" 1 5 1 1 264282`] View formatted query View runnable query Explain query 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 = ? AND t0.model_id = ? 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 AND t0.model_id = 264282 ORDER BY t0.feedback_time DESC LIMIT 12;
116	150.86 ms	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 Parameters: [`"uk" 1 5 1 1`] View formatted query View runnable query Explain query 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;
117	0.51 ms	SELECT t0.content AS content_1, t0.id AS id_2, t0.name AS name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM modal_translation t0 WHERE t0.translatable_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.content AS content_1, t0.id AS id_2, t0.name AS name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM modal_translation t0 WHERE t0.translatable_id = ? SELECT t0.content AS content_1, t0.id AS id_2, t0.name AS name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM modal_translation t0 WHERE t0.translatable_id = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
old_global_db	doctrine.dbal.old_global_db_connection
old_latestimport_db	doctrine.dbal.old_latestimport_db_connection
locale_uk	doctrine.dbal.locale_uk_connection
locale_de	doctrine.dbal.locale_de_connection
locale_es	doctrine.dbal.locale_es_connection
locale_fr	doctrine.dbal.locale_fr_connection
locale_it	doctrine.dbal.locale_it_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

2744 Hits

42 Misses

75 Puts

Number of cache hits

Region	Hits
core_write_rare	34
core_append_only	14
attribute	2693
content_write_rare	3

Number of cache misses

Region	Misses
model	1
brand	1
oempart	40

Number of cache puts

Region	Puts
model	4
brand	1
oempart	70

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\OemAttributeValue	1864
App\Entity\OemAttribute	207
App\Entity\OemPartStock	30
App\Entity\OemPartPricing	30
App\Entity\Translation\ShippingMethodTranslation	29
App\Entity\Translation\OemAttributeTranslation	25
App\Entity\Node	21
App\Entity\PathAlias	15
App\Entity\Feedback	12
App\Entity\ManagedFile	11
App\Entity\EntityAliasMap	10
App\Entity\OemPart	10
App\Entity\ProductVariant	10
App\Entity\Translation\OemPartTranslation	10
App\Entity\Translation\OemPartPageNodeTranslation	10
App\Entity\Page	8
App\Entity\Locale	6
App\Entity\ShippingMethod	6
App\Entity\BankDetails	5
App\Entity\Channel	5
App\Entity\Translation\OemModelNodeTranslation	5
App\Entity\Translation\OemBrandTranslation	5
App\Entity\Translation\ModelTranslation	5
App\Entity\Translation\DeviceTypeTranslation	5
App\Entity\Translation\BrandTranslation	5
App\Entity\Translation\ModalTranslation	5
App\Entity\Currency	3
App\Entity\PartCodeType	3
App\Entity\PartConditionType	3
App\Entity\Brand	2
App\Entity\ExchangeRate	2
App\Entity\SiteBanner	1
App\Entity\Model	1
App\Entity\OemBrand	1
App\Entity\OemCategory	1
App\Entity\OemBrandCategory	1
App\Entity\DeviceType	1
App\Entity\ModelCategoryBrand	1
App\Entity\ModelsUpgraded	1
App\Entity\StockStatus	1
App\Entity\Warranty	1
App\Entity\Modal	1

Entities Mapping

Class	Mapping errors
App\Entity\Channel	No errors.
App\Entity\Locale	No errors.
App\Entity\Currency	No errors.
App\Entity\BankDetails	No errors.
App\Entity\SiteBanner	No errors.
App\Entity\Product	No errors.
App\Entity\Feedback	No errors.
App\Entity\PaymentMethod	No errors.
App\Entity\Voucher	No errors.
App\Entity\SearchHistoryItem	No errors.
App\Entity\DeliveryOption	No errors.
App\Entity\TrendingSearch	No errors.
App\Entity\PathAlias	No errors.
App\Entity\Node	No errors.
App\Entity\OemModelNode	No errors.
App\Entity\CoreNode	No errors.
App\Entity\PageNode	No errors.
App\Entity\SeriesNode	No errors.
App\Entity\SeriesssdNode	No errors.
App\Entity\ModelNode	No errors.
App\Entity\ModelssdNode	No errors.
App\Entity\ComponentPageNode	No errors.
App\Entity\ProductNode	No errors.
App\Entity\FilterPageNode	No errors.
App\Entity\ArticleNode	No errors.
App\Entity\ArticleTaxonomyNode	No errors.
App\Entity\ArticleTagNode	No errors.
App\Entity\GenericNode	No errors.
App\Entity\HelpTopicNode	No errors.
App\Entity\HelpArticleNode	No errors.
App\Entity\ModelCategoryNode	No errors.
App\Entity\ModelCategoryssdNode	No errors.
App\Entity\ModelCategoryBrandNode	No errors.
App\Entity\ModelCategoryBrandssdNode	No errors.
App\Entity\OemPartPageNode	No errors.
App\Entity\OemBrandNode	No errors.
App\Entity\OemCategoryNode	No errors.
App\Entity\OemBrandCategoryNode	No errors.
App\Entity\Page	No errors.
App\Entity\Series	No errors.
App\Entity\HelpTopic	No errors.
App\Entity\Model	No errors.
App\Entity\ComponentPage	No errors.
App\Entity\FilterPage	No errors.
App\Entity\Article	No errors.
App\Entity\ArticleTaxonomy	No errors.
App\Entity\ArticleTag	No errors.
App\Entity\HelpArticle	No errors.
App\Entity\ModelCategory	No errors.
App\Entity\ModelCategoryBrand	No errors.
App\Entity\OemPart	No errors.
App\Entity\OemBrand	No errors.
App\Entity\OemCategory	No errors.
App\Entity\OemBrandCategory	No errors.
App\Entity\Translation\OemModelNodeTranslation	No errors.
App\Entity\ModelCompatiblePart	No errors.
App\Entity\OemAttribute	No errors.
App\Entity\OemAttributeValue	No errors.
App\Entity\Translation\OemAttributeTranslation	No errors.
App\Entity\EntityAliasMap	No errors.
App\Entity\Translation\OemPartTranslation	No errors.
App\Entity\Translation\OemPartPageNodeTranslation	No errors.
App\Entity\ManagedFile	No errors.
App\Entity\PartCodeType	No errors.
App\Entity\ProductVariant	No errors.
App\Entity\DeviceType	No errors.
App\Entity\OemPartStock	No errors.
App\Entity\ProductFeedOemPart	No errors.
App\Entity\ManagedFileUsage	No errors.
App\Entity\Brand	No errors.
App\Entity\OftPartCode	No errors.
App\Entity\ModelCompatibleProduct	No errors.
App\Entity\ModelAttributeValue	No errors.
App\Entity\Translation\ModelNodeTranslation	No errors.
App\Entity\Translation\ModelssdNodeTranslation	No errors.
App\Entity\GlobalAttributeValue	No errors.
App\Entity\Translation\ModelTranslation	No errors.
App\Entity\ModelsUpgraded	No errors.
App\Entity\Translation\BrandTranslation	No errors.
App\Entity\ModelAttribute	No errors.
App\Entity\Translation\ModelAttributeTranslation	No errors.
App\Entity\GlobalAttribute	No errors.
App\Entity\Translation\GlobalAttributeTranslation	No errors.
App\Entity\Translation\OemBrandNodeTranslation	No errors.
App\Entity\Translation\OemBrandTranslation	No errors.
App\Entity\Translation\DeviceTypeTranslation	No errors.
App\Entity\PartConditionType	No errors.
App\Entity\StockStatus	No errors.
App\Entity\Warranty	No errors.
App\Entity\OemPartPricing	No errors.
App\Entity\ExchangeRate	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\Translation\ShippingMethodTranslation	No errors.
App\Entity\Translation\PageNodeTranslation	No errors.
App\Entity\Translation\PageTranslation	No errors.
App\Entity\Modal	No errors.
App\Entity\Translation\ModalTranslation	No errors.

Symfony Profiler

GET https://www.monkeydevwork.co.uk/hp-compaq-storageworks-msa500-g2-oem

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Number of cache misses

Number of cache puts

Managed Entities

default entity manager

Entities Mapping