Query Metrics
34
Database Queries
29
Different statements
298.39 ms
Query time
0
Invalid entities
174
Managed entities
52
Cache hits
4
Cache misses
8
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
147.07 ms (49.29%) |
1 |
SELECT t0.feedback_locale_code AS feedback_locale_code_1, t0.verified AS verified_2, t0.feedback_user AS feedback_user_3, t0.feedback_text AS feedback_text_4, t0.feedback_type AS feedback_type_5, t0.feedback_stars AS feedback_stars_6, t0.feedback_time AS feedback_time_7, t0.feedback_name AS feedback_name_8, t0.clean AS clean_9, t0.valid AS valid_10, t0.extra_data AS extra_data_11, t0.feedback_item_title AS feedback_item_title_12, t0.oftpartno AS oftpartno_13, t0.feedback_origin AS feedback_origin_14, t0.origin_transaction_id AS origin_transaction_id_15, t0.order_id AS order_id_16, t0.origin_feedback_id AS origin_feedback_id_17, t0.model_id AS model_id_18, t0.product_id AS product_id_19, t0.feedback_role AS feedback_role_20, t0.feedback_language AS feedback_language_21, t0.feedback_item_id AS feedback_item_id_22, t0.feedback_page_number AS feedback_page_number_23, t0.id AS id_24, t0.channel_id AS channel_id_25 FROM feedback t0 WHERE t0.feedback_locale_code = ? AND t0.channel_id = ? AND t0.feedback_stars = ? AND t0.clean = ? AND t0.valid = ? AND t0.model_id = ? ORDER BY t0.feedback_time DESC LIMIT 12
Parameters:
[ "uk" 1 5 1 1 109200 ] |
|
130.33 ms (43.68%) |
1 |
SELECT t0.feedback_locale_code AS feedback_locale_code_1, t0.verified AS verified_2, t0.feedback_user AS feedback_user_3, t0.feedback_text AS feedback_text_4, t0.feedback_type AS feedback_type_5, t0.feedback_stars AS feedback_stars_6, t0.feedback_time AS feedback_time_7, t0.feedback_name AS feedback_name_8, t0.clean AS clean_9, t0.valid AS valid_10, t0.extra_data AS extra_data_11, t0.feedback_item_title AS feedback_item_title_12, t0.oftpartno AS oftpartno_13, t0.feedback_origin AS feedback_origin_14, t0.origin_transaction_id AS origin_transaction_id_15, t0.order_id AS order_id_16, t0.origin_feedback_id AS origin_feedback_id_17, t0.model_id AS model_id_18, t0.product_id AS product_id_19, t0.feedback_role AS feedback_role_20, t0.feedback_language AS feedback_language_21, t0.feedback_item_id AS feedback_item_id_22, t0.feedback_page_number AS feedback_page_number_23, t0.id AS id_24, t0.channel_id AS channel_id_25 FROM feedback t0 WHERE t0.feedback_locale_code = ? AND t0.channel_id = ? AND t0.feedback_stars = ? AND t0.clean = ? AND t0.valid = ? ORDER BY t0.feedback_time DESC LIMIT 12
Parameters:
[ "uk" 1 5 1 1 ] |
|
5.32 ms (1.78%) |
3 |
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" 192 "en" ] |
|
3.99 ms (1.34%) |
1 |
SELECT m0_.id AS id_0, p1_.requires_shipping AS requires_shipping_1, p1_.position AS position_2, p1_.manage_stock AS manage_stock_3, p1_.product_variant_image_order AS product_variant_image_order_4, p1_.oem_match_data AS oem_match_data_5, p1_.id AS id_6, p1_.uuid AS uuid_7, p1_.created_at AS created_at_8, p1_.updated_at AS updated_at_9, p1_.handle AS handle_10, p1_.active AS active_11, p1_.legacy_id AS legacy_id_12, p2_.legacy_id AS legacy_id_13, p2_.product_type AS product_type_14, p2_.variant_selection_method AS variant_selection_method_15, p2_.component AS component_16, p2_.id AS id_17, p2_.uuid AS uuid_18, p2_.created_at AS created_at_19, p2_.updated_at AS updated_at_20, p2_.handle AS handle_21, p2_.active AS active_22, p2_.allow_node_generation AS allow_node_generation_23, n3_.node_type AS node_type_24, n3_.system_managed AS system_managed_25, n3_.id AS id_26, n3_.uuid AS uuid_27, n3_.created_at AS created_at_28, n3_.updated_at AS updated_at_29, n3_.handle AS handle_30, p4_.id AS id_31, p4_.name AS name_32, p4_.locale AS locale_33, p5_.id AS id_34, p6_.position AS position_35, p6_.id AS id_36, p6_.created_at AS created_at_37, p6_.updated_at AS updated_at_38, p6_.handle AS handle_39, p7_.id AS id_40, p7_.name AS name_41, p7_.locale AS locale_42, p8_.position AS position_43, p8_.id AS id_44, p8_.handle AS handle_45, p9_.value AS value_46, p9_.id AS id_47, p9_.locale AS locale_48, m10_.file_name AS file_name_49, m10_.file_uri AS file_uri_50, m10_.file_mime AS file_mime_51, m10_.file_size AS file_size_52, m10_.status AS status_53, m10_.id AS id_54, m10_.uuid AS uuid_55, m10_.active AS active_56, m10_.locale_code AS locale_code_57, o11_.id AS id_58, o11_.oem_number AS oem_number_59, p12_.name_updated AS name_updated_60, p12_.description_updated AS description_updated_61, p12_.id AS id_62, p12_.name AS name_63, p12_.description AS description_64, p12_.excerpt AS excerpt_65, p12_.locale AS locale_66, m0_.product_id AS product_id_67, m0_.model_id AS model_id_68, p1_.product_id AS product_id_69, p1_.stock_status_id AS stock_status_id_70, p2_.main_taxonomy_id AS main_taxonomy_id_71, p2_.device_type_id AS device_type_id_72, n3_.discr AS discr_73, p13_.product_entity_id AS product_entity_id_74, p13_.help_topic_id AS help_topic_id_75, p4_.translatable_id AS translatable_id_76, p5_.oem_number_id AS oem_number_id_77, p5_.product_variant_id AS product_variant_id_78, p7_.translatable_id AS translatable_id_79, p8_.product_option_id AS product_option_id_80, p9_.translatable_id AS translatable_id_81, p12_.translatable_id AS translatable_id_82 FROM model_compatible_product m0_ INNER JOIN model_compatible_product_variants m14_ ON m0_.id = m14_.model_compatible_product_id INNER JOIN product_variant p1_ ON p1_.id = m14_.product_variant_id INNER JOIN product p2_ ON m0_.product_id = p2_.id LEFT JOIN product_node p13_ ON p2_.id = p13_.product_entity_id LEFT JOIN node n3_ ON p13_.id = n3_.id INNER JOIN product_variant_translation p4_ ON p1_.id = p4_.translatable_id LEFT JOIN product_variant_oem p5_ ON p1_.id = p5_.product_variant_id LEFT JOIN product_product_option p15_ ON p2_.id = p15_.product_id LEFT JOIN product_option p6_ ON p6_.id = p15_.product_option_id LEFT JOIN product_option_translation p7_ ON p6_.id = p7_.translatable_id LEFT JOIN product_variant_product_option_value p16_ ON p1_.id = p16_.product_variant_id LEFT JOIN product_option_value p8_ ON p8_.id = p16_.product_option_value_id LEFT JOIN product_option_value_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN product_variant_featured_image p17_ ON p1_.id = p17_.product_variant_id LEFT JOIN managed_file m10_ ON m10_.id = p17_.managed_file_id LEFT JOIN oem_part_number o11_ ON p5_.oem_number_id = o11_.id INNER JOIN product_translation p12_ ON p2_.id = p12_.translatable_id WHERE m0_.model_id = ? AND p2_.active = ? AND p4_.locale = ? AND p12_.locale = ? AND p9_.locale = ? AND p7_.locale = ? AND p2_.product_type = ?
Parameters:
[ 109200 1 "en" "en" "en" "en" "memory_module" ] |
|
1.86 ms (0.62%) |
4 |
SELECT t0.feed_product_id AS feed_product_id_1, t0.feed_id AS feed_id_2, t0.mpn_fake AS mpn_fake_3, t0.gtin AS gtin_4, t0.id AS id_5, t0.model_id AS model_id_6, t0.product_variant_id AS product_variant_id_7, t0.oft_part_code_id AS oft_part_code_id_8 FROM product_feed t0 WHERE t0.oft_part_code_id = ? AND t0.product_variant_id = ? AND t0.model_id = ? LIMIT 1
Parameters:
[ 833 555 109200 ] |
|
0.87 ms (0.29%) |
1 |
SELECT n0_.node_type AS node_type_0, n0_.system_managed AS system_managed_1, n0_.id AS id_2, n0_.uuid AS uuid_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, n0_.handle AS handle_6, m1_.poc_only AS poc_only_7, m1_.display_oem AS display_oem_8, m1_.id AS id_9, m1_.uuid AS uuid_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.handle AS handle_13, m1_.active AS active_14, m1_.legacy_id AS legacy_id_15, m1_.legacy_data AS legacy_data_16, m1_.allow_node_generation AS allow_node_generation_17, m1_.display_memory_modules AS display_memory_modules_18, m1_.display_ssds AS display_ssds_19, m2_.id AS id_20, m2_.active AS active_21, m2_.name AS name_22, m2_.path_hint AS path_hint_23, m2_.main_title AS main_title_24, m2_.page_title AS page_title_25, m2_.page_description AS page_description_26, m2_.allow_robots_index AS allow_robots_index_27, m2_.allow_robots_follow AS allow_robots_follow_28, m2_.additional_meta_tags AS additional_meta_tags_29, m2_.locale AS locale_30, m3_.id AS id_31, m3_.short_name AS short_name_32, m3_.name AS name_33, m3_.description AS description_34, m3_.legacy_url_slug AS legacy_url_slug_35, m3_.locale AS locale_36, s4_.top_level AS top_level_37, s4_.popular AS popular_38, s4_.other AS other_39, s4_.id AS id_40, s4_.uuid AS uuid_41, s4_.created_at AS created_at_42, s4_.updated_at AS updated_at_43, s4_.handle AS handle_44, s4_.active AS active_45, s4_.materialized_path AS materialized_path_46, s4_.legacy_id AS legacy_id_47, s4_.legacy_secondary_id AS legacy_secondary_id_48, s4_.legacy_data AS legacy_data_49, s4_.legacy_duplicate_handle AS legacy_duplicate_handle_50, s4_.allow_node_generation AS allow_node_generation_51, s4_.display_memory_modules AS display_memory_modules_52, s4_.display_ssds AS display_ssds_53, b5_.popular AS popular_54, b5_.id AS id_55, b5_.uuid AS uuid_56, b5_.created_at AS created_at_57, b5_.updated_at AS updated_at_58, b5_.handle AS handle_59, b5_.active AS active_60, b5_.legacy_id AS legacy_id_61, m6_.popular AS popular_62, m6_.id AS id_63, m6_.uuid AS uuid_64, m6_.created_at AS created_at_65, m6_.updated_at AS updated_at_66, m6_.handle AS handle_67, m6_.active AS active_68, m6_.legacy_id AS legacy_id_69, m6_.legacy_secondary_id AS legacy_secondary_id_70, m6_.legacy_data AS legacy_data_71, m6_.legacy_url_slug AS legacy_url_slug_72, m6_.allow_node_generation AS allow_node_generation_73, m6_.display_memory_modules AS display_memory_modules_74, m6_.display_ssds AS display_ssds_75, m7_.file_name AS file_name_76, m7_.file_uri AS file_uri_77, m7_.file_mime AS file_mime_78, m7_.file_size AS file_size_79, m7_.status AS status_80, m7_.id AS id_81, m7_.uuid AS uuid_82, m7_.active AS active_83, m7_.locale_code AS locale_code_84, d8_.icon_uri AS icon_uri_85, d8_.id AS id_86, d8_.uuid AS uuid_87, d8_.handle AS handle_88, d8_.legacy_id AS legacy_id_89, o9_.oft_part_no AS oft_part_no_90, o9_.part_code_type AS part_code_type_91, o9_.item_amount AS item_amount_92, o9_.purchasable AS purchasable_93, o9_.memory_price_id AS memory_price_id_94, o9_.asin AS asin_95, o9_.id AS id_96, o9_.active AS active_97, n0_.discr AS discr_98, m10_.model_entity_id AS model_entity_id_99, m1_.brand_id AS brand_id_100, m1_.series_id AS series_id_101, m1_.model_image_id AS model_image_id_102, m1_.device_type_id AS device_type_id_103, m1_.model_category_brand_id AS model_category_brand_id_104, m1_.oem_brand_id AS oem_brand_id_105, m2_.translatable_id AS translatable_id_106, m3_.translatable_id AS translatable_id_107, s4_.brand_id AS brand_id_108, s4_.series_image_id AS series_image_id_109, s4_.model_category_brand_id AS model_category_brand_id_110, s4_.device_type_id AS device_type_id_111, b5_.brand_logo_id AS brand_logo_id_112, m6_.model_category_id AS model_category_id_113, m6_.brand_id AS brand_id_114, m6_.device_type_id AS device_type_id_115, o9_.stock_id AS stock_id_116, o9_.product_variant_id AS product_variant_id_117, o9_.memory_spec_id AS memory_spec_id_118 FROM model_node m10_ INNER JOIN node n0_ ON m10_.id = n0_.id LEFT JOIN model m1_ ON m10_.model_entity_id = m1_.id LEFT JOIN model_node_translation m2_ ON m10_.id = m2_.translatable_id AND (m2_.locale = ?) LEFT JOIN model_translation m3_ ON m1_.id = m3_.translatable_id AND (m3_.locale = ?) LEFT JOIN series s4_ ON m1_.series_id = s4_.id LEFT JOIN brand b5_ ON m1_.brand_id = b5_.id LEFT JOIN model_category_brand m6_ ON m1_.model_category_brand_id = m6_.id LEFT JOIN managed_file m7_ ON m1_.model_image_id = m7_.id LEFT JOIN device_type d8_ ON m1_.device_type_id = d8_.id LEFT JOIN oft_part_code_model o11_ ON m1_.id = o11_.model_id LEFT JOIN oft_part_code o9_ ON o9_.id = o11_.oft_part_code_id WHERE n0_.id = ?
Parameters:
[ "en" "en" 704563 ] |
|
0.86 ms (0.29%) |
1 |
SELECT mav.*, ma.id as ma_id, ma.uuid as ma_uuid, ma.created_at as ma_created_at, ma.updated_at as ma_updated_at, ma.handle as ma_handle, ma.type as ma_type, ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, mat.id as mat_id, mat.name as mat_name, mat.display_name as mat_display_name, mat.translatable_id as mat_translatable_id, mat.locale as mat_locale FROM model_attribute_value mav INNER JOIN model_attribute ma ON mav.attribute_id = ma.id INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id WHERE mavm.model_id = ? AND ma.display = 1 AND ma.active = 1 AND mav.active = 1 AND mav.locale_code = ? ORDER BY ma.position ASC, mav.position ASC
Parameters:
[ "en" 109200 "en" ] |
|
0.77 ms (0.26%) |
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 = ?
Parameters:
[
704563
]
|
|
0.65 ms (0.22%) |
1 |
SELECT o0_.oft_part_no AS oft_part_no_0, o0_.part_code_type AS part_code_type_1, o0_.item_amount AS item_amount_2, o0_.purchasable AS purchasable_3, o0_.memory_price_id AS memory_price_id_4, o0_.asin AS asin_5, o0_.id AS id_6, o0_.active AS active_7, m1_.id AS id_8, m1_.memory_specification AS memory_specification_9, s2_.stock_location AS stock_location_10, s2_.stock_level AS stock_level_11, s2_.id AS id_12, o3_.id AS id_13, o3_.price AS price_14, o3_.sale_price AS sale_price_15, o3_.old_price AS old_price_16, o0_.stock_id AS stock_id_17, o0_.product_variant_id AS product_variant_id_18, o0_.memory_spec_id AS memory_spec_id_19, o3_.oft_part_no AS oft_part_no_20, o3_.channel_id AS channel_id_21 FROM oft_part_code o0_ LEFT JOIN memory_spec m1_ ON o0_.memory_spec_id = m1_.id LEFT JOIN stock s2_ ON o0_.stock_id = s2_.id LEFT JOIN oft_part_pricing o3_ ON o0_.id = o3_.oft_part_no WHERE EXISTS (SELECT 1 FROM oft_part_code_model o4_ WHERE o4_.oft_part_code_id = o0_.id AND o4_.model_id IN (?)) AND o0_.product_variant_id IN (?, ?, ?, ?)
Parameters:
[ 109200 555 556 646 648 ] |
|
0.59 ms (0.20%) |
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 = ?
Parameters:
[ "node/704563" 1 1 ] |
|
0.57 ms (0.19%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM model_compatible_product m1_ INNER JOIN model_compatible_product_variants m2_ ON m1_.id = m2_.model_compatible_product_id INNER JOIN product_variant p0_ ON p0_.id = m2_.product_variant_id INNER JOIN model m3_ ON m1_.model_id = m3_.id INNER JOIN product p4_ ON m1_.product_id = p4_.id WHERE m3_.id = ? AND p0_.active = 1 AND p4_.active = 1 AND p4_.product_type = ?
Parameters:
[ 109200 "memory_module" ] |
|
0.46 ms (0.16%) |
1 |
SELECT mav.*, ma.id as ma_id, ma.uuid as ma_uuid, ma.created_at as ma_created_at, ma.updated_at as ma_updated_at, ma.handle as ma_handle, ma.type as ma_type, ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, mat.id as mat_id, mat.name as mat_name, mat.display_name as mat_display_name, mat.translatable_id as mat_translatable_id, mat.locale as mat_locale FROM global_attribute_value mav INNER JOIN global_attribute ma ON mav.attribute_id = ma.id INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id WHERE mavm.model_id = ? AND ma.display = 1 AND ma.active = 1 AND mav.active = 1 AND mav.locale_code = ? ORDER BY ma.position ASC, mav.position ASC
Parameters:
[ "en" 109200 "en" ] |
|
0.45 ms (0.15%) |
1 |
SELECT o0_.oft_part_no AS oft_part_no_0, o0_.part_code_type AS part_code_type_1, o0_.item_amount AS item_amount_2, o0_.purchasable AS purchasable_3, o0_.memory_price_id AS memory_price_id_4, o0_.asin AS asin_5, o0_.id AS id_6, o0_.active AS active_7, m1_.id AS id_8, m1_.memory_specification AS memory_specification_9, s2_.stock_location AS stock_location_10, s2_.stock_level AS stock_level_11, s2_.id AS id_12, o3_.id AS id_13, o3_.price AS price_14, o3_.sale_price AS sale_price_15, o3_.old_price AS old_price_16, o0_.stock_id AS stock_id_17, o0_.product_variant_id AS product_variant_id_18, o0_.memory_spec_id AS memory_spec_id_19, o3_.oft_part_no AS oft_part_no_20, o3_.channel_id AS channel_id_21 FROM oft_part_code o0_ LEFT JOIN memory_spec m1_ ON o0_.memory_spec_id = m1_.id LEFT JOIN stock s2_ ON o0_.stock_id = s2_.id LEFT JOIN oft_part_pricing o3_ ON o0_.id = o3_.oft_part_no WHERE o0_.product_variant_id IN (?, ?, ?, ?) AND o0_.part_code_type = ?
Parameters:
[ 555 556 646 648 "default" ] |
|
0.44 ms (0.15%) |
1 |
SELECT s0_.id AS id_0 FROM shipping_method s0_ WHERE s0_.country_code = ? AND s0_.price = ? AND s0_.active = 1
Parameters:
[ "GB" 0 ] |
|
0.39 ms (0.13%) |
1 |
SELECT t0.alternative_name AS alternative_name_1, t0.id AS id_2, t0.name AS name_3, t0.path_hint AS path_hint_4, t0.active AS active_5, t0.page_title AS page_title_6, t0.page_description AS page_description_7, t0.allow_robots_index AS allow_robots_index_8, t0.allow_robots_follow AS allow_robots_follow_9, t0.additional_meta_tags AS additional_meta_tags_10, t0.description AS description_11, t0.description_chatgpt AS description_chatgpt_12, t0.display_ai_description AS display_ai_description_13, t0.short_description AS short_description_14, t0.content AS content_15, t0.content_chatgpt AS content_chatgpt_16, t0.display_ai_content AS display_ai_content_17, t0.main_title AS main_title_18, t0.locale AS locale_19, t0.translatable_id AS translatable_id_20 FROM model_category_node_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
355
]
|
|
0.33 ms (0.11%) |
1 |
SELECT t0.content AS content_1, t0.id AS id_2, t0.name AS name_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM modal_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.31 ms (0.11%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path_hint AS path_hint_3, t0.active AS active_4, t0.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.description AS description_10, t0.description_chatgpt AS description_chatgpt_11, t0.display_ai_description AS display_ai_description_12, t0.short_description AS short_description_13, t0.content AS content_14, t0.main_title AS main_title_15, t0.locale AS locale_16, t0.translatable_id AS translatable_id_17 FROM model_category_brand_node_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
879
]
|
|
0.31 ms (0.10%) |
1 |
SELECT t0.alternative_name AS alternative_name_1, t0.website AS website_2, t0.model_identification_info AS model_identification_info_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM brand_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
270
]
|
|
0.29 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path_hint AS path_hint_3, t0.active AS active_4, t0.description AS description_5, t0.description_chatgpt AS description_chatgpt_6, t0.display_ai_description AS display_ai_description_7, t0.main_title AS main_title_8, t0.page_title AS page_title_9, t0.page_description AS page_description_10, t0.allow_robots_index AS allow_robots_index_11, t0.allow_robots_follow AS allow_robots_follow_12, t0.additional_meta_tags AS additional_meta_tags_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM series_node_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5263
]
|
|
0.28 ms (0.10%) |
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.model_category_entity_id AS model_category_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_category_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_entity_id = ?
Parameters:
[
4
]
|
|
0.27 ms (0.09%) |
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.model_category_entity_id AS model_category_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_categoryssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_entity_id = ?
Parameters:
[
4
]
|
|
0.26 ms (0.09%) |
1 |
SELECT t0.total AS total_1, t0.id AS id_2, t0.brand_id AS brand_id_3 FROM models_upgraded t0 WHERE t0.brand_id = ?
Parameters:
[
270
]
|
|
0.25 ms (0.08%) |
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.model_entity_id AS model_entity_id_9, t1.discr FROM modelssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_entity_id = ?
Parameters:
[
109200
]
|
|
0.24 ms (0.08%) |
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.series_entity_id AS series_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM series_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.series_entity_id = ?
Parameters:
[
335
]
|
|
0.24 ms (0.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM device_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
|
0.24 ms (0.08%) |
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.model_category_brand_entity_id AS model_category_brand_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_category_brand_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_brand_entity_id = ?
Parameters:
[
504
]
|
|
0.24 ms (0.08%) |
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.model_category_brand_entity_id AS model_category_brand_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM model_category_brandssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_category_brand_entity_id = ?
Parameters:
[
504
]
|
|
0.23 ms (0.08%) |
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.series_entity_id AS series_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM seriesssd_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.series_entity_id = ?
Parameters:
[
335
]
|
|
0.23 ms (0.08%) |
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.model_entity_id AS model_entity_id_9, t0.help_topic_id AS help_topic_id_10, t1.discr FROM oem_model_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.model_entity_id = ?
Parameters:
[
109200
]
|
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
52
Hits
4
Misses
8
Puts
Number of cache hits
| Region | Hits |
|---|---|
| core_write_rare | 34 |
| core_append_only | 13 |
| content_write_rare | 4 |
| general_write_rare | 1 |
Number of cache misses
| Region | Misses |
|---|---|
| core_write_rare | 4 |
Number of cache puts
| Region | Puts |
|---|---|
| core_write_rare | 8 |
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\OftPartPricing | 20 |
| App\Entity\Feedback | 12 |
| App\Entity\Node | 7 |
| App\Entity\Locale | 6 |
| App\Entity\ProductAttributeValue | 6 |
| App\Entity\Translation\ModelCategoryNodeTranslation | 6 |
| App\Entity\BankDetails | 5 |
| App\Entity\Channel | 5 |
| App\Entity\PathAlias | 5 |
| App\Entity\ProductAttribute | 5 |
| App\Entity\Translation\ProductAttributeTranslation | 5 |
| App\Entity\Translation\BrandTranslation | 5 |
| App\Entity\Translation\ModelCategoryBrandNodeTranslation | 5 |
| App\Entity\Translation\SeriesNodeTranslation | 5 |
| App\Entity\Translation\DeviceTypeTranslation | 5 |
| App\Entity\Translation\ModalTranslation | 5 |
| App\Entity\OftPartCode | 4 |
| App\Entity\Stock | 4 |
| App\Entity\ProductVariant | 4 |
| App\Entity\Translation\ProductVariantTranslation | 4 |
| App\Entity\ProductFeed | 4 |
| App\Entity\Currency | 3 |
| App\Entity\MemorySpec | 3 |
| App\Entity\ModelCompatibleProduct | 3 |
| App\Entity\Product | 3 |
| App\Entity\Translation\ProductTranslation | 3 |
| App\Entity\ModelAttributeValue | 3 |
| App\Entity\ModelAttribute | 3 |
| App\Entity\Translation\ModelAttributeTranslation | 3 |
| App\Entity\ManagedFile | 2 |
| App\Entity\ProductOptionValue | 2 |
| App\Entity\Translation\ProductOptionValueTranslation | 2 |
| App\Entity\ExchangeRate | 2 |
| App\Entity\SiteBanner | 1 |
| App\Entity\Model | 1 |
| App\Entity\Translation\ModelNodeTranslation | 1 |
| App\Entity\Translation\ModelTranslation | 1 |
| App\Entity\Series | 1 |
| App\Entity\Brand | 1 |
| App\Entity\ModelCategoryBrand | 1 |
| App\Entity\DeviceType | 1 |
| App\Entity\ModelsUpgraded | 1 |
| App\Entity\ModelCategory | 1 |
| App\Entity\StockStatus | 1 |
| App\Entity\Taxonomy | 1 |
| App\Entity\ProductOption | 1 |
| App\Entity\Translation\ProductOptionTranslation | 1 |
| App\Entity\Modal | 1 |