User Deprecated: Since api-platform/symfony 4.1: The "api_platform.validator.query_parameter_validator" service is deprecated use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\ParameterValidator" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\ArrayItems" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Bounds" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Enum" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Length" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\MultipleOf" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Pattern" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Required" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
User Deprecated: Since api-platform/core 3.4: Injecting the "ApiPlatform\JsonSchema\TypeFactoryInterface" inside "ApiPlatform\JsonSchema\SchemaFactory" is deprecated and "ApiPlatform\JsonSchema\TypeFactoryInterface" will be removed in 4.x.
User Deprecated: In ORM 3.0, the AttributeDriver will report fields for the classes where they are declared. This may uncover invalid mapping configurations. To opt into the new mode today, set the "reportFieldsWhereDeclared" constructor parameter to true. (AttributeDriver.php:77 called by App_KernelDevDebugContainer.php:3258, https://github.com/doctrine/orm/pull/10455, package doctrine/orm)
"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:
[1 => 941964]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 941964]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => "en"
2 => "en"
3 => 941964]
, types:
[1 => 22 => 23 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => "en"
2 => "en"
3 => 941964]
"types" => [1 => 22 => 23 => 1]
]
debug
Executing statement:
"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:
[1 => 234792]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 234792]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 234792]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 234792]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 4321]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 4321]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 4321]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 4321]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 332]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 332]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 654]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 654]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 654]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 654]
"types" => [1 => 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:
[1 => "node/941964"
2 => 13 => 1]
, types:
[1 => 22 => 53 => 5]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => "node/941964"
2 => 13 => 1]
"types" => [1 => 22 => 53 => 5]
]
"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:
[1 => 2347922 => "memory_module"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 2347922 => "memory_module"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"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 = ?"
[
"sql" => "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 = ?"
"params" => [1 => 2347922 => 13 => "en"
4 => "en"
5 => "en"
6 => "en"
7 => "memory_module"
]
"types" => [1 => 12 => 53 => 24 => 25 => 26 => 27 => 2]
]
debug
Executing statement:
"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:
[1 => 2347922 => 467]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "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 (?)"
"params" => [1 => 2347922 => 467]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"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:
[1 => 4672 => "default"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 4672 => "default"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"""
\n SELECT mav.*,\n 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, \n ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, \n ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, \n 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 \n FROM product_attribute_value mav\n INNER JOIN product_attribute ma ON mav.attribute_id = ma.id\n INNER JOIN product_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? \n INNER JOIN product_av_mapping mavm ON mav.id = mavm.product_attribute_value_id \n 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\n
"""
(parameters:
[1 => "en"
2 => 1543 => "en"
]
, types:
[1 => 22 => 13 => 2]
)
doctrine
[
"sql" => """
\n SELECT mav.*,\n 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, \n ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, \n ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, \n 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 \n FROM product_attribute_value mav\n INNER JOIN product_attribute ma ON mav.attribute_id = ma.id\n INNER JOIN product_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? \n INNER JOIN product_av_mapping mavm ON mav.id = mavm.product_attribute_value_id \n 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\n
"""
"params" => [1 => "en"
2 => 1543 => "en"
]
"types" => [1 => 22 => 13 => 2]
]
debug
Executing statement:
"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:
[1 => 332]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 332]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 18]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 18]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 18]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 18]
"types" => [1 => 1]
]
debug
Executing statement:
"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:
[1 => 369]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 369]
"types" => [1 => 1]
]
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/369' not found': Unable to generate a URL for the named route "node/369" as such route does not exist.
app
debug
Executing statement:
"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:
[1 => 1029]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 1029]
"types" => [1 => 1]
]
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/1029' not found': Unable to generate a URL for the named route "node/1029" as such route does not exist.
app
debug
Executing statement:
"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:
[1 => 5436]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 5436]
"types" => [1 => 1]
]
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/5436' not found': Unable to generate a URL for the named route "node/5436" as such route does not exist.
app
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/941964' not found': Unable to generate a URL for the named route "node/941964" as such route does not exist.
app
debug
Executing statement:
"""
\n SELECT mav.*,\n 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, \n ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, \n ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, \n 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 \n FROM model_attribute_value mav\n INNER JOIN model_attribute ma ON mav.attribute_id = ma.id\n INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? \n INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id \n 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\n
"""
(parameters:
[1 => "en"
2 => 2347923 => "en"
]
, types:
[1 => 22 => 13 => 2]
)
doctrine
[
"sql" => """
\n SELECT mav.*,\n 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, \n ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, \n ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, \n 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 \n FROM model_attribute_value mav\n INNER JOIN model_attribute ma ON mav.attribute_id = ma.id\n INNER JOIN model_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? \n INNER JOIN model_attribute_value_mapping mavm ON mav.id = mavm.model_attribute_value_id \n 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\n
"""
"params" => [1 => "en"
2 => 2347923 => "en"
]
"types" => [1 => 22 => 13 => 2]
]
debug
Executing statement:
"""
\n SELECT mav.*,\n 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, \n ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, \n ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, \n 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 \n FROM global_attribute_value mav\n INNER JOIN global_attribute ma ON mav.attribute_id = ma.id\n INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? \n INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id \n 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\n
"""
(parameters:
[1 => "en"
2 => 2347923 => "en"
]
, types:
[1 => 22 => 13 => 2]
)
doctrine
[
"sql" => """
\n SELECT mav.*,\n 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, \n ma.storage_type as ma_storage_type, ma.configuration as ma_configuration, ma.position as ma_position, ma.translatable as ma_translatable, \n ma.display as ma_display, ma.filterable as ma_filterable, ma.active as ma_active, \n 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 \n FROM global_attribute_value mav\n INNER JOIN global_attribute ma ON mav.attribute_id = ma.id\n INNER JOIN global_attribute_translation mat ON ma.id = mat.translatable_id AND mat.locale = ? \n INNER JOIN global_av_mapping_model mavm ON mav.id = mavm.global_attribute_value_id \n 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\n
"""
"params" => [1 => "en"
2 => 2347923 => "en"
]
"types" => [1 => 22 => 13 => 2]
]
debug
Executing statement:
"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:
[1 => 18]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 18]
"types" => [1 => 1]
]
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/1029__en' not found': Unable to generate a URL for the named route "node/1029__en" as such route does not exist.
app
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/1029__en' not found': Unable to generate a URL for the named route "node/1029__en" as such route does not exist.
app
deprecation
User Deprecated: Since twig/twig 3.15: Using the "deprecated", "deprecating_package", and "alternative" options is deprecated, pass a "deprecation_info" one instead.
"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:
[1 => "uk"
2 => 13 => 54 => 15 => 16 => 234792]
, types:
[1 => 22 => 13 => 14 => 55 => 56 => 2]
)
doctrine
[
"sql" => "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"
"params" => [1 => "uk"
2 => 13 => 54 => 15 => 16 => 234792]
"types" => [1 => 22 => 13 => 14 => 55 => 56 => 2]
]
debug
Executing statement:
"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:
[1 => "uk"
2 => 13 => 54 => 15 => 1]
, types:
[1 => 22 => 13 => 14 => 55 => 5]
)
doctrine
[
"sql" => "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"
"params" => [1 => "uk"
2 => 13 => 54 => 15 => 1]
"types" => [1 => 22 => 13 => 14 => 55 => 5]
]
debug
Router Symfony\Bundle\FrameworkBundle\Routing\Router was unable to generate route. Reason: 'Route 'node/941964__en' not found': Unable to generate a URL for the named route "node/941964__en" as such route does not exist.
app
debug
Executing statement:
"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 => 1]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 1]
"types" => [1 => 1]
]