Symfony Profiler

Query Metrics

59 Database Queries

31 Different statements

129.76 ms Query time

0 Invalid entities

360 Managed entities

85 Cache hits

21 Cache misses

29 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.main_title AS main_title_4, t0.page_title AS page_title_5, t0.page_description AS page_description_6, t0.allow_robots_index AS allow_robots_index_7, t0.allow_robots_follow AS allow_robots_follow_8, t0.additional_meta_tags AS additional_meta_tags_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM product_node_translation t0 WHERE t0.translatable_id = ?
SELECT t0.legacy_id AS legacy_id_1, t0.product_type AS product_type_2, t0.variant_selection_method AS variant_selection_method_3, t0.component AS component_4, t0.id AS id_5, t0.uuid AS uuid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.handle AS handle_9, t0.active AS active_10, t0.allow_node_generation AS allow_node_generation_11, t0.main_taxonomy_id AS main_taxonomy_id_12, t0.device_type_id AS device_type_id_13 FROM product 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.product_entity_id AS product_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM product_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.product_entity_id = ?
SELECT t0.settings AS settings_1, t0.filter_settings AS filter_settings_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.handle AS handle_7, t0.active AS active_8, t0.allow_node_generation AS allow_node_generation_9, t0.materialized_path AS materialized_path_10, t0.linked_taxonomy_id AS linked_taxonomy_id_11 FROM component_page t0 WHERE t0.linked_taxonomy_id = ? 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.component_page_entity_id AS component_page_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM component_page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.component_page_entity_id = ?
SELECT c0_.settings AS settings_0, c0_.filter_settings AS filter_settings_1, c0_.id AS id_2, c0_.uuid AS uuid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.handle AS handle_6, c0_.active AS active_7, c0_.allow_node_generation AS allow_node_generation_8, c0_.materialized_path AS materialized_path_9, c0_.linked_taxonomy_id AS linked_taxonomy_id_10 FROM component_page c0_ WHERE c0_.id IN (?) ORDER BY FIELD(c0_.id, ?) ASC
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.description_chatgpt AS description_chatgpt_5, t0.display_ai_description AS display_ai_description_6, t0.main_title AS main_title_7, t0.page_title AS page_title_8, t0.page_description AS page_description_9, t0.allow_robots_index AS allow_robots_index_10, t0.allow_robots_follow AS allow_robots_follow_11, t0.additional_meta_tags AS additional_meta_tags_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM component_page_node_translation t0 WHERE t0.translatable_id = ?
SELECT t0.name_updated AS name_updated_1, t0.description_updated AS description_updated_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_translation t0 WHERE t0.translatable_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 product_attribute_value mav
                INNER JOIN product_attribute ma ON mav.attribute_id = ma.id
                INNER JOIN product_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? 
                INNER JOIN product_av_mapping mavm ON mav.id = mavm.product_attribute_value_id 
                WHERE mavm.product_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.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_featured_image ON t0.id = product_featured_image.managed_file_id WHERE product_featured_image.product_id = ?
SELECT t0.requires_shipping AS requires_shipping_1, t0.position AS position_2, t0.manage_stock AS manage_stock_3, t0.product_variant_image_order AS product_variant_image_order_4, t0.oem_match_data AS oem_match_data_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.handle AS handle_10, t0.active AS active_11, t0.legacy_id AS legacy_id_12, t0.product_id AS product_id_13, t0.stock_status_id AS stock_status_id_14, t15.id AS id_16, t15.oem_number_id AS oem_number_id_17, t15.product_variant_id AS product_variant_id_18 FROM product_variant t0 LEFT JOIN product_variant_oem t15 ON t15.product_variant_id = t0.id WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_variant_translation t0 WHERE t0.translatable_id = ?
SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_variant_translation t0 WHERE t0.translatable_id = ?
SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_variant_translation t0 WHERE t0.translatable_id = ?
SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_variant_translation t0 WHERE t0.translatable_id = ?
SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?)
SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ?
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.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ?
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ?
SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ?
SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ?
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ?
SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ?
SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ?
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ?
SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ?
SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ?
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ?
SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.handle AS handle_5 FROM product_option t0 INNER JOIN product_product_option ON t0.id = product_product_option.product_option_id WHERE product_product_option.product_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 product_option_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ?
SELECT t0.position AS position_1, t0.icon AS icon_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 FROM delivery_option t0 INNER JOIN delivery_option_channel ON t0.id = delivery_option_channel.delivery_option_id WHERE delivery_option_channel.channel_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 delivery_option_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 delivery_option_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 delivery_option_translation t0 WHERE t0.translatable_id = ?
SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6, a0_.main_taxonomy_id AS main_taxonomy_id_7, a0_.author_id AS author_id_8 FROM article a0_ WHERE a0_.active = ? ORDER BY a0_.created_at DESC LIMIT 3
SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ?
SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ?
SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ?
SELECT t0.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 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

#▲	Time	Info
1	0.57 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: [`"/ssd-solid-state-drive-products/samsung-970-evo-plus-pcie-nvme-m-2-2280-ssd-internal-solid-state-drive" "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 = '/ssd-solid-state-drive-products/samsung-970-evo-plus-pcie-nvme-m-2-2280-ssd-internal-solid-state-drive' AND t0.locale_code = 'en' AND t0.active = 1 LIMIT 1;
2	0.76 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: [`537132`] 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 = 537132;
3	0.78 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: [`537132`] 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 = 537132 LIMIT 1;
4	0.60 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/537132" 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/537132' AND t0.primary_path = 1 AND t0.active = 1;
5	0.46 ms	SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.main_title AS main_title_4, t0.page_title AS page_title_5, t0.page_description AS page_description_6, t0.allow_robots_index AS allow_robots_index_7, t0.allow_robots_follow AS allow_robots_follow_8, t0.additional_meta_tags AS additional_meta_tags_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM product_node_translation t0 WHERE t0.translatable_id = ? Parameters: [`537132`] 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.main_title AS main_title_4, t0.page_title AS page_title_5, t0.page_description AS page_description_6, t0.allow_robots_index AS allow_robots_index_7, t0.allow_robots_follow AS allow_robots_follow_8, t0.additional_meta_tags AS additional_meta_tags_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM product_node_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.main_title AS main_title_4, t0.page_title AS page_title_5, t0.page_description AS page_description_6, t0.allow_robots_index AS allow_robots_index_7, t0.allow_robots_follow AS allow_robots_follow_8, t0.additional_meta_tags AS additional_meta_tags_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM product_node_translation t0 WHERE t0.translatable_id = 537132;
6	0.33 ms	SELECT t0.legacy_id AS legacy_id_1, t0.product_type AS product_type_2, t0.variant_selection_method AS variant_selection_method_3, t0.component AS component_4, t0.id AS id_5, t0.uuid AS uuid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.handle AS handle_9, t0.active AS active_10, t0.allow_node_generation AS allow_node_generation_11, t0.main_taxonomy_id AS main_taxonomy_id_12, t0.device_type_id AS device_type_id_13 FROM product t0 WHERE t0.id = ? Parameters: [`353`] View formatted query View runnable query Explain query SELECT t0.legacy_id AS legacy_id_1, t0.product_type AS product_type_2, t0.variant_selection_method AS variant_selection_method_3, t0.component AS component_4, t0.id AS id_5, t0.uuid AS uuid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.handle AS handle_9, t0.active AS active_10, t0.allow_node_generation AS allow_node_generation_11, t0.main_taxonomy_id AS main_taxonomy_id_12, t0.device_type_id AS device_type_id_13 FROM product t0 WHERE t0.id = ? SELECT t0.legacy_id AS legacy_id_1, t0.product_type AS product_type_2, t0.variant_selection_method AS variant_selection_method_3, t0.component AS component_4, t0.id AS id_5, t0.uuid AS uuid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.handle AS handle_9, t0.active AS active_10, t0.allow_node_generation AS allow_node_generation_11, t0.main_taxonomy_id AS main_taxonomy_id_12, t0.device_type_id AS device_type_id_13 FROM product t0 WHERE t0.id = 353;
7	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.product_entity_id AS product_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM product_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.product_entity_id = ? Parameters: [`353`] 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.product_entity_id AS product_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM product_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.product_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.product_entity_id AS product_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM product_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.product_entity_id = 353;
8	0.31 ms	SELECT t0.settings AS settings_1, t0.filter_settings AS filter_settings_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.handle AS handle_7, t0.active AS active_8, t0.allow_node_generation AS allow_node_generation_9, t0.materialized_path AS materialized_path_10, t0.linked_taxonomy_id AS linked_taxonomy_id_11 FROM component_page t0 WHERE t0.linked_taxonomy_id = ? LIMIT 1 Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.settings AS settings_1, t0.filter_settings AS filter_settings_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.handle AS handle_7, t0.active AS active_8, t0.allow_node_generation AS allow_node_generation_9, t0.materialized_path AS materialized_path_10, t0.linked_taxonomy_id AS linked_taxonomy_id_11 FROM component_page t0 WHERE t0.linked_taxonomy_id = ? LIMIT 1 SELECT t0.settings AS settings_1, t0.filter_settings AS filter_settings_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.handle AS handle_7, t0.active AS active_8, t0.allow_node_generation AS allow_node_generation_9, t0.materialized_path AS materialized_path_10, t0.linked_taxonomy_id AS linked_taxonomy_id_11 FROM component_page t0 WHERE t0.linked_taxonomy_id = 11 LIMIT 1;
9	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.component_page_entity_id AS component_page_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM component_page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.component_page_entity_id = ? Parameters: [`11`] 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.component_page_entity_id AS component_page_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM component_page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.component_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.component_page_entity_id AS component_page_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM component_page_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.component_page_entity_id = 11;
10	0.25 ms	SELECT c0_.settings AS settings_0, c0_.filter_settings AS filter_settings_1, c0_.id AS id_2, c0_.uuid AS uuid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.handle AS handle_6, c0_.active AS active_7, c0_.allow_node_generation AS allow_node_generation_8, c0_.materialized_path AS materialized_path_9, c0_.linked_taxonomy_id AS linked_taxonomy_id_10 FROM component_page c0_ WHERE c0_.id IN (?) ORDER BY FIELD(c0_.id, ?) ASC Parameters: [`"11" "11"`] View formatted query View runnable query Explain query SELECT c0_.settings AS settings_0, c0_.filter_settings AS filter_settings_1, c0_.id AS id_2, c0_.uuid AS uuid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.handle AS handle_6, c0_.active AS active_7, c0_.allow_node_generation AS allow_node_generation_8, c0_.materialized_path AS materialized_path_9, c0_.linked_taxonomy_id AS linked_taxonomy_id_10 FROM component_page c0_ WHERE c0_.id IN (?) ORDER BY FIELD(c0_.id, ?) ASC SELECT c0_.settings AS settings_0, c0_.filter_settings AS filter_settings_1, c0_.id AS id_2, c0_.uuid AS uuid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.handle AS handle_6, c0_.active AS active_7, c0_.allow_node_generation AS allow_node_generation_8, c0_.materialized_path AS materialized_path_9, c0_.linked_taxonomy_id AS linked_taxonomy_id_10 FROM component_page c0_ WHERE c0_.id IN ('11') ORDER BY FIELD(c0_.id, '11') ASC;
11	0.27 ms	SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.description_chatgpt AS description_chatgpt_5, t0.display_ai_description AS display_ai_description_6, t0.main_title AS main_title_7, t0.page_title AS page_title_8, t0.page_description AS page_description_9, t0.allow_robots_index AS allow_robots_index_10, t0.allow_robots_follow AS allow_robots_follow_11, t0.additional_meta_tags AS additional_meta_tags_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM component_page_node_translation t0 WHERE t0.translatable_id = ? Parameters: [`532776`] 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.description AS description_4, t0.description_chatgpt AS description_chatgpt_5, t0.display_ai_description AS display_ai_description_6, t0.main_title AS main_title_7, t0.page_title AS page_title_8, t0.page_description AS page_description_9, t0.allow_robots_index AS allow_robots_index_10, t0.allow_robots_follow AS allow_robots_follow_11, t0.additional_meta_tags AS additional_meta_tags_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM component_page_node_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.description_chatgpt AS description_chatgpt_5, t0.display_ai_description AS display_ai_description_6, t0.main_title AS main_title_7, t0.page_title AS page_title_8, t0.page_description AS page_description_9, t0.allow_robots_index AS allow_robots_index_10, t0.allow_robots_follow AS allow_robots_follow_11, t0.additional_meta_tags AS additional_meta_tags_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM component_page_node_translation t0 WHERE t0.translatable_id = 532776;
12	0.26 ms	SELECT t0.name_updated AS name_updated_1, t0.description_updated AS description_updated_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_translation t0 WHERE t0.translatable_id = ? Parameters: [`353`] View formatted query View runnable query Explain query SELECT t0.name_updated AS name_updated_1, t0.description_updated AS description_updated_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_translation t0 WHERE t0.translatable_id = ? SELECT t0.name_updated AS name_updated_1, t0.description_updated AS description_updated_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_translation t0 WHERE t0.translatable_id = 353;
13	4.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 product_attribute_value mav INNER JOIN product_attribute ma ON mav.attribute_id = ma.id INNER JOIN product_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN product_av_mapping mavm ON mav.id = mavm.product_attribute_value_id WHERE mavm.product_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" 353 "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 product_attribute_value mav INNER JOIN product_attribute ma ON mav.attribute_id = ma.id INNER JOIN product_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN product_av_mapping mavm ON mav.id = mavm.product_attribute_value_id WHERE mavm.product_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 product_attribute_value mav INNER JOIN product_attribute ma ON mav.attribute_id = ma.id INNER JOIN product_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = 'en' INNER JOIN product_av_mapping mavm ON mav.id = mavm.product_attribute_value_id WHERE mavm.product_id = 353 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 ;
14	0.47 ms	SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_featured_image ON t0.id = product_featured_image.managed_file_id WHERE product_featured_image.product_id = ? Parameters: [`353`] View formatted query View runnable query Explain query SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_featured_image ON t0.id = product_featured_image.managed_file_id WHERE product_featured_image.product_id = ? SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_featured_image ON t0.id = product_featured_image.managed_file_id WHERE product_featured_image.product_id = 353;
15	0.40 ms	SELECT t0.requires_shipping AS requires_shipping_1, t0.position AS position_2, t0.manage_stock AS manage_stock_3, t0.product_variant_image_order AS product_variant_image_order_4, t0.oem_match_data AS oem_match_data_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.handle AS handle_10, t0.active AS active_11, t0.legacy_id AS legacy_id_12, t0.product_id AS product_id_13, t0.stock_status_id AS stock_status_id_14, t15.id AS id_16, t15.oem_number_id AS oem_number_id_17, t15.product_variant_id AS product_variant_id_18 FROM product_variant t0 LEFT JOIN product_variant_oem t15 ON t15.product_variant_id = t0.id WHERE t0.product_id = ? ORDER BY t0.position ASC Parameters: [`353`] View formatted query View runnable query Explain query SELECT t0.requires_shipping AS requires_shipping_1, t0.position AS position_2, t0.manage_stock AS manage_stock_3, t0.product_variant_image_order AS product_variant_image_order_4, t0.oem_match_data AS oem_match_data_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.handle AS handle_10, t0.active AS active_11, t0.legacy_id AS legacy_id_12, t0.product_id AS product_id_13, t0.stock_status_id AS stock_status_id_14, t15.id AS id_16, t15.oem_number_id AS oem_number_id_17, t15.product_variant_id AS product_variant_id_18 FROM product_variant t0 LEFT JOIN product_variant_oem t15 ON t15.product_variant_id = t0.id WHERE t0.product_id = ? ORDER BY t0.position ASC SELECT t0.requires_shipping AS requires_shipping_1, t0.position AS position_2, t0.manage_stock AS manage_stock_3, t0.product_variant_image_order AS product_variant_image_order_4, t0.oem_match_data AS oem_match_data_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.handle AS handle_10, t0.active AS active_11, t0.legacy_id AS legacy_id_12, t0.product_id AS product_id_13, t0.stock_status_id AS stock_status_id_14, t15.id AS id_16, t15.oem_number_id AS oem_number_id_17, t15.product_variant_id AS product_variant_id_18 FROM product_variant t0 LEFT JOIN product_variant_oem t15 ON t15.product_variant_id = t0.id WHERE t0.product_id = 353 ORDER BY t0.position ASC;
16	0.26 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 product_variant_translation t0 WHERE t0.translatable_id = ? Parameters: [`1216`] 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 product_variant_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 product_variant_translation t0 WHERE t0.translatable_id = 1216;
17	0.22 ms	SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? Parameters: [`1216`] View formatted query View runnable query Explain query SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = 1216;
18	0.34 ms	SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?) Parameters: [`1 2713`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oft_part_no = ? ) SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oft_part_no = 2713);
19	0.29 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 product_variant_translation t0 WHERE t0.translatable_id = ? Parameters: [`1217`] 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 product_variant_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 product_variant_translation t0 WHERE t0.translatable_id = 1217;
20	0.23 ms	SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? Parameters: [`1217`] View formatted query View runnable query Explain query SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = 1217;
21	0.20 ms	SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?) Parameters: [`1 2714`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oft_part_no = ? ) SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oft_part_no = 2714);
22	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 product_variant_translation t0 WHERE t0.translatable_id = ? Parameters: [`1218`] 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 product_variant_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 product_variant_translation t0 WHERE t0.translatable_id = 1218;
23	0.23 ms	SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? Parameters: [`1218`] View formatted query View runnable query Explain query SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = 1218;
24	0.20 ms	SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?) Parameters: [`1 2715`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oft_part_no = ? ) SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oft_part_no = 2715);
25	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 product_variant_translation t0 WHERE t0.translatable_id = ? Parameters: [`1219`] 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 product_variant_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 product_variant_translation t0 WHERE t0.translatable_id = 1219;
26	0.20 ms	SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? Parameters: [`1219`] View formatted query View runnable query Explain query SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = ? SELECT t0.oft_part_no AS oft_part_no_1, t0.part_code_type AS part_code_type_2, t0.item_amount AS item_amount_3, t0.purchasable AS purchasable_4, t0.memory_price_id AS memory_price_id_5, t0.asin AS asin_6, t0.id AS id_7, t0.active AS active_8, t0.stock_id AS stock_id_9, t0.product_variant_id AS product_variant_id_10, t0.memory_spec_id AS memory_spec_id_11 FROM oft_part_code t0 WHERE t0.product_variant_id = 1219;
27	0.20 ms	SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = ? AND t0.oft_part_no = ?) Parameters: [`1 2716`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE ( t0.channel_id = ? AND t0.oft_part_no = ? ) SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.old_price AS old_price_4, t0.oft_part_no AS oft_part_no_5, t0.channel_id AS channel_id_6 FROM oft_part_pricing t0 WHERE (t0.channel_id = 1 AND t0.oft_part_no = 2716);
28	0.65 ms	SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? Parameters: [`1216`] View formatted query View runnable query Explain query SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = 1216;
29	0.97 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;
30	0.56 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? Parameters: [`1216`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = 1216;
31	0.38 ms	SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? Parameters: [`98`] View formatted query View runnable query Explain query SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = 98;
32	0.40 ms	SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? Parameters: [`1217`] View formatted query View runnable query Explain query SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = 1217;
33	0.38 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? Parameters: [`1217`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = 1217;
34	0.23 ms	SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? Parameters: [`99`] View formatted query View runnable query Explain query SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = 99;
35	0.30 ms	SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? Parameters: [`1218`] View formatted query View runnable query Explain query SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = 1218;
36	0.37 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? Parameters: [`1218`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = 1218;
37	0.23 ms	SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? Parameters: [`97`] View formatted query View runnable query Explain query SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = 97;
38	0.36 ms	SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? Parameters: [`1219`] View formatted query View runnable query Explain query SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = ? SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 INNER JOIN product_variant_images ON t0.id = product_variant_images.managed_file_id WHERE product_variant_images.product_variant_id = 1219;
39	0.36 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? Parameters: [`1219`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = ? SELECT t0.position AS position_1, t0.id AS id_2, t0.handle AS handle_3, t0.product_option_id AS product_option_id_4 FROM product_option_value t0 INNER JOIN product_variant_product_option_value ON t0.id = product_variant_product_option_value.product_option_value_id WHERE product_variant_product_option_value.product_variant_id = 1219;
40	0.22 ms	SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? Parameters: [`100`] View formatted query View runnable query Explain query SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = ? SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_option_value_translation t0 WHERE t0.translatable_id = 100;
41	0.33 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.handle AS handle_5 FROM product_option t0 INNER JOIN product_product_option ON t0.id = product_product_option.product_option_id WHERE product_product_option.product_id = ? Parameters: [`353`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.handle AS handle_5 FROM product_option t0 INNER JOIN product_product_option ON t0.id = product_product_option.product_option_id WHERE product_product_option.product_id = ? SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.handle AS handle_5 FROM product_option t0 INNER JOIN product_product_option ON t0.id = product_product_option.product_option_id WHERE product_product_option.product_id = 353;
42	0.23 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 product_option_translation t0 WHERE t0.translatable_id = ? Parameters: [`1`] 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 product_option_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 product_option_translation t0 WHERE t0.translatable_id = 1;
43	0.32 ms	SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? Parameters: [`2799`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = 2799;
44	0.20 ms	SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? Parameters: [`2801`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = 2801;
45	0.17 ms	SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? Parameters: [`2798`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = 2798;
46	0.17 ms	SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? Parameters: [`2800`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.oem_number AS oem_number_2, t3.id AS id_4, t3.oem_number_id AS oem_number_id_5, t3.product_variant_id AS product_variant_id_6 FROM oem_part_number t0 LEFT JOIN product_variant_oem t3 ON t3.oem_number_id = t0.id WHERE t0.id = 2800;
47	0.34 ms	SELECT t0.position AS position_1, t0.icon AS icon_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 FROM delivery_option t0 INNER JOIN delivery_option_channel ON t0.id = delivery_option_channel.delivery_option_id WHERE delivery_option_channel.channel_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.icon AS icon_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 FROM delivery_option t0 INNER JOIN delivery_option_channel ON t0.id = delivery_option_channel.delivery_option_id WHERE delivery_option_channel.channel_id = ? SELECT t0.position AS position_1, t0.icon AS icon_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 FROM delivery_option t0 INNER JOIN delivery_option_channel ON t0.id = delivery_option_channel.delivery_option_id WHERE delivery_option_channel.channel_id = 1;
48	0.25 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 delivery_option_translation t0 WHERE t0.translatable_id = ? Parameters: [`1`] 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 delivery_option_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 delivery_option_translation t0 WHERE t0.translatable_id = 1;
49	0.21 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 delivery_option_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 delivery_option_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 delivery_option_translation t0 WHERE t0.translatable_id = 2;
50	0.19 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 delivery_option_translation t0 WHERE t0.translatable_id = ? Parameters: [`3`] 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 delivery_option_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 delivery_option_translation t0 WHERE t0.translatable_id = 3;
51	0.41 ms	SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6, a0_.main_taxonomy_id AS main_taxonomy_id_7, a0_.author_id AS author_id_8 FROM article a0_ WHERE a0_.active = ? ORDER BY a0_.created_at DESC LIMIT 3 Parameters: [`1`] View formatted query View runnable query Explain query SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6, a0_.main_taxonomy_id AS main_taxonomy_id_7, a0_.author_id AS author_id_8 FROM article a0_ WHERE a0_.active = ? ORDER BY a0_.created_at DESC LIMIT 3 SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6, a0_.main_taxonomy_id AS main_taxonomy_id_7, a0_.author_id AS author_id_8 FROM article a0_ WHERE a0_.active = 1 ORDER BY a0_.created_at DESC LIMIT 3;
52	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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ? Parameters: [`100`] 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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ? SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = 100;
53	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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ? Parameters: [`99`] 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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ? SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = 99;
54	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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ? Parameters: [`98`] 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.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ? SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = 98;
55	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ? Parameters: [`100`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = 100;
56	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ? Parameters: [`99`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = 99;
57	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ? Parameters: [`98`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = 98;
58	105.69 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;
59	0.89 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;

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

85 Hits

21 Misses

29 Puts

Number of cache hits

Region	Hits
core_write_rare	34
core_append_only	13
product	34
general_write_rare	1
content_write_rare	3

Number of cache misses

Region	Misses
product	21

Number of cache puts

Region	Puts
product	29

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ManagedFile	115
App\Entity\Translation\ShippingMethodTranslation	29
App\Entity\Translation\ProductVariantTranslation	20
App\Entity\Translation\ProductOptionValueTranslation	20
App\Entity\ProductAttributeValue	15
App\Entity\Translation\DeliveryOptionTranslation	15
App\Entity\Translation\ArticleTranslation	15
App\Entity\Feedback	12
App\Entity\ProductAttribute	10
App\Entity\Translation\ProductAttributeTranslation	10
App\Entity\Locale	6
App\Entity\ShippingMethod	6
App\Entity\BankDetails	5
App\Entity\Channel	5
App\Entity\PathAlias	5
App\Entity\Node	5
App\Entity\Translation\ProductNodeTranslation	5
App\Entity\Translation\ComponentPageNodeTranslation	5
App\Entity\Translation\ProductTranslation	5
App\Entity\Translation\ProductOptionTranslation	5
App\Entity\ProductVariant	4
App\Entity\ProductVariantOEM	4
App\Entity\OemPartNumber	4
App\Entity\OftPartCode	4
App\Entity\OftPartPricing	4
App\Entity\ProductOptionValue	4
App\Entity\Currency	3
App\Entity\DeliveryOption	3
App\Entity\Article	3
App\Entity\ArticleTaxonomy	3
App\Entity\ExchangeRate	2
App\Entity\SiteBanner	1
App\Entity\Product	1
App\Entity\Taxonomy	1
App\Entity\ComponentPage	1
App\Entity\StockStatus	1
App\Entity\Stock	1
App\Entity\MemorySpec	1
App\Entity\ProductOption	1
App\Entity\Author	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\ProductNode	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\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\OemModelNode	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\ProductNodeTranslation	No errors.
App\Entity\Taxonomy	No errors.
App\Entity\DeviceType	No errors.
App\Entity\ProductOption	No errors.
App\Entity\ProductVariant	No errors.
App\Entity\ProductAttributeValue	No errors.
App\Entity\ProductTaxonomy	No errors.
App\Entity\ManagedFile	No errors.
App\Entity\Translation\ProductTranslation	No errors.
App\Entity\Translation\ComponentPageNodeTranslation	No errors.
App\Entity\Translation\ComponentPageTranslation	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\Translation\ProductAttributeTranslation	No errors.
App\Entity\ManagedFileUsage	No errors.
App\Entity\StockStatus	No errors.
App\Entity\ProductVariantOEM	No errors.
App\Entity\OemPartNumber	No errors.
App\Entity\ProductOptionValue	No errors.
App\Entity\OftPartCode	No errors.
App\Entity\Translation\ProductVariantTranslation	No errors.
App\Entity\Stock	No errors.
App\Entity\MemorySpec	No errors.
App\Entity\OftPartPricing	No errors.
App\Entity\ExchangeRate	No errors.
App\Entity\Translation\StockStatusTranslation	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\Translation\ShippingMethodTranslation	No errors.
App\Entity\Translation\ProductOptionValueTranslation	No errors.
App\Entity\Translation\ProductOptionTranslation	No errors.
App\Entity\OftPartCodeOEM	No errors.
App\Entity\Translation\DeliveryOptionTranslation	No errors.
App\Entity\Translation\ArticleNodeTranslation	No errors.
App\Entity\Author	No errors.
App\Entity\Translation\ArticleTranslation	No errors.

Symfony Profiler

GET https://www.monkeydevwork.co.uk/ssd-solid-state-drive-products/samsung-970-evo-plus-pcie-nvme-m-2-2280-ssd-internal-solid-state-drive

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