User Deprecated: The Liip\ImagineBundle\Templating\FilterExtension class is deprecated since version 2.7 and will be removed in 3.0; configure "liip_imagine.twig.mode" to "lazy" instead.
User Deprecated: Since symfony/security-core 5.4: Not setting the 5th argument of "Symfony\Component\Security\Core\Authorization\AuthorizationChecker::__construct" to "false" is deprecated.
User Deprecated: Since symfony/security-bundle 5.3: The "sulu_security.encoder_factory" service is deprecated, use "security.password_hasher_factory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactory" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactoryInterface" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactoryInterface" instead.
User Deprecated: The "Sulu\Component\Localization\Localization::setXDefault" method is deprecated on "Sulu\Component\Localization\Localization" use "setDefault" instead.
User Deprecated: The "Sulu\Component\Webspace\Portal::getXDefaultLocalization" method is deprecated on "Sulu\Component\Webspace\Portal" use "getDefaultLocalization" instead.
User Deprecated: The "Sulu\Component\Webspace\Portal::setXDefaultLocalization" method is deprecated on "Sulu\Component\Webspace\Portal" use "setDefaultLocalization" instead.
"SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?"
(parameters:
[1 => "16"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?"
"params" => [1 => "16"
]
"types" => [1 => 2]
]
debug
Executing statement:
"UPDATE me_file_versions SET downloadCounter = downloadCounter + 1 WHERE id = ?"
(parameters:
[1 => 17]
, types:
[1 => 1]
)
doctrine
[
"sql" => "UPDATE me_file_versions SET downloadCounter = downloadCounter + 1 WHERE id = ?"
"params" => [1 => 17]
"types" => [1 => 1]
]
deprecation
User Deprecated: Since symfony/security-bundle 5.4: Setting the $authenticatorManagerEnabled argument of "Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector::__construct" to "false" is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/http-kernel 5.3: "Symfony\Component\HttpKernel\Event\KernelEvent::isMasterRequest()" is deprecated, use "isMainRequest()" instead.
[
"sql" => """
SELECT DISTINCT k.CONSTRAINT_NAME,\n k.COLUMN_NAME,\n k.REFERENCED_TABLE_NAME,\n k.REFERENCED_COLUMN_NAME,\n k.ORDINAL_POSITION /*!50116,\n c.UPDATE_RULE,\n c.DELETE_RULE */\nFROM information_schema.key_column_usage k /*!50116\nINNER JOIN information_schema.referential_constraints c\nON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\nAND c.TABLE_NAME = k.TABLE_NAME\nAND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
"""
"params" => [1 => "rm9b6_bn_invest"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"""
SELECT c.COLUMN_NAME AS field,\n c.COLUMN_TYPE AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_SCHEMA = c.TABLE_SCHEMA\n AND t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""
[
"sql" => """
SELECT c.COLUMN_NAME AS field,\n c.COLUMN_TYPE AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_SCHEMA = c.TABLE_SCHEMA\n AND t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""
"params" => [1 => "rm9b6_bn_invest"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"""
SELECT NON_UNIQUE AS Non_Unique,\n INDEX_NAME AS Key_name,\n COLUMN_NAME AS Column_Name,\n SUB_PART AS Sub_Part,\n INDEX_TYPE AS Index_Type\nFROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
"""
