The "Symfony\Bridge\Doctrine\Logger\DbalLogger" class implements "Doctrine\DBAL\Logging\SQLLogger" that is deprecated Use {@link \Doctrine\DBAL\Logging\Middleware} or implement {@link \Doctrine\DBAL\Driver\Middleware} instead.
SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?)) ORDER BY s0_.published_at DESC LIMIT 10
[DateTime @1734489069 {#587date: 2024-12-18 02:31:09.144623 UTC (+00:00)}
9]
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, s1_.id AS id_6, s1_.full_name AS full_name_7, s1_.username AS username_8, s1_.email AS email_9, s1_.password AS password_10, s1_.roles AS roles_11, s2_.id AS id_12, s2_.name AS name_13, s0_.author_id AS author_id_14 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?)) AND s0_.id IN (?) ORDER BY s0_.published_at DESC, s2_.name ASC
[DateTime @1734489069 {#587date: 2024-12-18 02:31:09.144623 UTC (+00:00)}
9
[1792130]
]
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?))
Changed reference of service "App\EventSubscriber\CommentNotificationSubscriber" previously pointing to "router.default" to "router".
Changed reference of service "App\EventSubscriber\CommentNotificationSubscriber" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "App\EventSubscriber\RedirectToPreferredLocaleSubscriber" previously pointing to "router.default" to "router".
Changed reference of service "locale_listener" previously pointing to "router.default" to "router".
Changed reference of service "http_kernel" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "services_resetter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fragment.renderer.inline" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "console.command.router_debug" previously pointing to "router.default" to "router".
Changed reference of service "console.command.router_match" previously pointing to "router.default" to "router".
Changed reference of service "console.command.translation_debug" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type.choice" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type.file" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type.color" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.form.transformation_failure_handling" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.form.validator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.upload.validator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.csrf" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "mailer.mailer" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "mailer.transport_factory.abstract" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "mailer.transport_factory.null" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "mailer.transport_factory.sendmail" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "mailer.transport_factory.smtp" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "mailer.transport_factory.native" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "validator.builder" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "data_collector.events" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "data_collector.translation" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "router_listener" previously pointing to "router.default" to "router".
Changed reference of service "Symfony\Bundle\FrameworkBundle\Controller\RedirectController" previously pointing to "router.default" to "router".
Changed reference of service "security.logout_url_generator" previously pointing to "router.default" to "router".
Changed reference of service "security.http_utils" previously pointing to "router.default" to "router".
Changed reference of service "security.http_utils" previously pointing to "router.default" to "router".
Changed reference of service "security.context_listener" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.abstract" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.switchuser_listener" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authenticator.manager" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authenticator.json_login" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "debug.security.firewall" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "twig.extension.trans" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "twig.extension.routing" previously pointing to "router.default" to "router".
Changed reference of service "twig.extension.form" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "web_profiler.controller.profiler" previously pointing to "router.default" to "router".
Changed reference of service "web_profiler.controller.router" previously pointing to "router.default" to "router".
Changed reference of service "debug.file_link_formatter.url_format" previously pointing to "router.default" to "router".
Changed reference of service "web_profiler.debug_toolbar" previously pointing to "router.default" to "router".
Changed reference of service "webpack_encore.tag_renderer" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "maker.event_registry" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "maker.maker.make_registration_form" previously pointing to "router.default" to "router".
Changed reference of service ".service_locator.juHxRDM" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "debug.security.voter.security.access.authenticated_voter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "debug.security.voter.security.access.role_hierarchy_voter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "debug.security.voter.security.access.expression_voter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "debug.security.voter.App\Security\PostVoter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service ".service_locator.CuYicar" previously pointing to "router.default" to "router".
Changed reference of service ".service_locator.wSgjnB6" previously pointing to "translator.data_collector" to "translator".
Changed reference of service ".service_locator.oCg4uHe" previously pointing to "router.default" to "router".
Changed reference of service ".service_locator.XsyfP82" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Removed service "container.env"; reason: abstract.
Removed service "cache.adapter.system"; reason: abstract.
Removed service "cache.adapter.apcu"; reason: abstract.
Removed service "cache.adapter.filesystem"; reason: abstract.
Removed service "cache.adapter.psr6"; reason: abstract.
Removed service "cache.adapter.redis"; reason: abstract.
Removed service "cache.adapter.redis_tag_aware"; reason: abstract.
Removed service "cache.adapter.memcached"; reason: abstract.
Removed service "cache.adapter.doctrine_dbal"; reason: abstract.
Removed service "cache.adapter.pdo"; reason: abstract.
Removed service "cache.adapter.array"; reason: abstract.
Removed service "assets.path_package"; reason: abstract.
Removed service "assets.url_package"; reason: abstract.
Removed service "assets.static_version_strategy"; reason: abstract.
Removed service "assets.json_manifest_version_strategy"; reason: abstract.
Removed service "mailer.transport_factory.abstract"; reason: abstract.
Removed service "security.firewall.context"; reason: abstract.
Removed service "security.firewall.lazy_context"; reason: abstract.
Removed service "security.firewall.config"; reason: abstract.
Removed service "security.user.provider.missing"; reason: abstract.
Removed service "security.user.provider.in_memory"; reason: abstract.
Removed service "security.user.provider.ldap"; reason: abstract.
Removed service "security.user.provider.chain"; reason: abstract.
Removed service "security.logout_listener"; reason: abstract.
Removed service "security.logout.listener.session"; reason: abstract.
Removed service "security.logout.listener.cookie_clearing"; reason: abstract.
Removed service "security.logout.listener.default"; reason: abstract.
Removed service "security.authentication.listener.abstract"; reason: abstract.
Removed service "security.authentication.custom_success_handler"; reason: abstract.
Removed service "security.authentication.success_handler"; reason: abstract.
Removed service "security.authentication.custom_failure_handler"; reason: abstract.
Removed service "security.authentication.failure_handler"; reason: abstract.
Removed service "security.exception_listener"; reason: abstract.
Removed service "security.authentication.switchuser_listener"; reason: abstract.
Removed service "security.authenticator.manager"; reason: abstract.
Removed service "security.firewall.authenticator"; reason: abstract.
Removed service "security.listener.user_provider.abstract"; reason: abstract.
Removed service "security.listener.user_checker"; reason: abstract.
Removed service "security.listener.session"; reason: abstract.
Removed service "security.listener.login_throttling"; reason: abstract.
Removed service "security.authenticator.http_basic"; reason: abstract.
Removed service "security.authenticator.form_login"; reason: abstract.
Removed service "security.authenticator.json_login"; reason: abstract.
Removed service "security.authenticator.x509"; reason: abstract.
Removed service "security.authenticator.remote_user"; reason: abstract.
Removed service "doctrine.dbal.logger.profiling"; reason: abstract.
Removed service "doctrine.dbal.logger.backtrace"; reason: abstract.
Removed service "doctrine.dbal.connection"; reason: abstract.
Removed service "doctrine.dbal.connection.event_manager"; reason: abstract.
Removed service "doctrine.dbal.connection.configuration"; reason: abstract.
Removed service "doctrine.dbal.schema_asset_filter_manager"; reason: abstract.
Removed service "doctrine.orm.configuration"; reason: abstract.
Removed service "doctrine.orm.entity_manager.abstract"; reason: abstract.
Removed service "doctrine.orm.manager_configurator.abstract"; reason: abstract.
Removed service "doctrine.orm.security.user.provider"; reason: abstract.
Removed service "monolog.logger_prototype"; reason: abstract.
Removed service "monolog.activation_strategy.not_found"; reason: abstract.
Removed service "monolog.handler.fingers_crossed.error_level_activation_strategy"; reason: abstract.
Removed service "maker.auto_command.abstract"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Console\Command\Command.0.App\Command\AddUserCommand"; reason: abstract.
Removed service ".abstract.instanceof.App\Command\AddUserCommand"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Console\Command\Command.0.App\Command\DeleteUserCommand"; reason: abstract.
Removed service ".abstract.instanceof.App\Command\DeleteUserCommand"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Console\Command\Command.0.App\Command\ListUsersCommand"; reason: abstract.
Removed service ".abstract.instanceof.App\Command\ListUsersCommand"; reason: abstract.
Removed service ".instanceof.Symfony\Contracts\Service\ServiceSubscriberInterface.0.App\Controller\Admin\BlogController"; reason: abstract.
Removed service ".instanceof.Symfony\Bundle\FrameworkBundle\Controller\AbstractController.0.App\Controller\Admin\BlogController"; reason: abstract.
Removed service ".abstract.instanceof.App\Controller\Admin\BlogController"; reason: abstract.
Removed service ".instanceof.Symfony\Contracts\Service\ServiceSubscriberInterface.0.App\Controller\BlogController"; reason: abstract.
Removed service ".instanceof.Symfony\Bundle\FrameworkBundle\Controller\AbstractController.0.App\Controller\BlogController"; reason: abstract.
Removed service ".abstract.instanceof.App\Controller\BlogController"; reason: abstract.
Removed service ".instanceof.Symfony\Contracts\Service\ServiceSubscriberInterface.0.App\Controller\SecurityController"; reason: abstract.
Removed service ".instanceof.Symfony\Bundle\FrameworkBundle\Controller\AbstractController.0.App\Controller\SecurityController"; reason: abstract.
Removed service ".abstract.instanceof.App\Controller\SecurityController"; reason: abstract.
Removed service ".instanceof.Symfony\Contracts\Service\ServiceSubscriberInterface.0.App\Controller\UserController"; reason: abstract.
Removed service ".instanceof.Symfony\Bundle\FrameworkBundle\Controller\AbstractController.0.App\Controller\UserController"; reason: abstract.
Removed service ".abstract.instanceof.App\Controller\UserController"; reason: abstract.
Removed service ".instanceof.Doctrine\Bundle\FixturesBundle\ORMFixtureInterface.0.App\DataFixtures\AppFixtures"; reason: abstract.
Removed service ".abstract.instanceof.App\DataFixtures\AppFixtures"; reason: abstract.
Removed service ".instanceof.Symfony\Component\EventDispatcher\EventSubscriberInterface.0.App\EventSubscriber\CheckRequirementsSubscriber"; reason: abstract.
Removed service ".abstract.instanceof.App\EventSubscriber\CheckRequirementsSubscriber"; reason: abstract.
Removed service ".instanceof.Symfony\Component\EventDispatcher\EventSubscriberInterface.0.App\EventSubscriber\CommentNotificationSubscriber"; reason: abstract.
Removed service ".abstract.instanceof.App\EventSubscriber\CommentNotificationSubscriber"; reason: abstract.
Removed service ".instanceof.Symfony\Component\EventDispatcher\EventSubscriberInterface.0.App\EventSubscriber\ControllerSubscriber"; reason: abstract.
Removed service ".abstract.instanceof.App\EventSubscriber\ControllerSubscriber"; reason: abstract.
Removed service ".instanceof.Symfony\Component\EventDispatcher\EventSubscriberInterface.0.App\EventSubscriber\RedirectToPreferredLocaleSubscriber"; reason: abstract.
Removed service ".abstract.instanceof.App\EventSubscriber\RedirectToPreferredLocaleSubscriber"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Form\FormTypeInterface.0.App\Form\CommentType"; reason: abstract.
Removed service ".abstract.instanceof.App\Form\CommentType"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Form\FormTypeInterface.0.App\Form\PostType"; reason: abstract.
Removed service ".abstract.instanceof.App\Form\PostType"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Form\FormTypeInterface.0.App\Form\Type\ChangePasswordType"; reason: abstract.
Removed service ".abstract.instanceof.App\Form\Type\ChangePasswordType"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Form\FormTypeInterface.0.App\Form\Type\DateTimePickerType"; reason: abstract.
Removed service ".abstract.instanceof.App\Form\Type\DateTimePickerType"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Form\FormTypeInterface.0.App\Form\Type\TagsInputType"; reason: abstract.
Removed service ".abstract.instanceof.App\Form\Type\TagsInputType"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Form\FormTypeInterface.0.App\Form\UserType"; reason: abstract.
Removed service ".abstract.instanceof.App\Form\UserType"; reason: abstract.
Removed service ".instanceof.Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryInterface.0.App\Repository\PostRepository"; reason: abstract.
Removed service ".abstract.instanceof.App\Repository\PostRepository"; reason: abstract.
Removed service ".instanceof.Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryInterface.0.App\Repository\TagRepository"; reason: abstract.
Removed service ".abstract.instanceof.App\Repository\TagRepository"; reason: abstract.
Removed service ".instanceof.Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryInterface.0.App\Repository\UserRepository"; reason: abstract.
Removed service ".abstract.instanceof.App\Repository\UserRepository"; reason: abstract.
Removed service ".instanceof.Symfony\Component\Security\Core\Authorization\Voter\VoterInterface.0.App\Security\PostVoter"; reason: abstract.
Removed service ".abstract.instanceof.App\Security\PostVoter"; reason: abstract.
Removed service ".instanceof.Twig\Extension\ExtensionInterface.0.App\Twig\AppExtension"; reason: abstract.
Removed service ".abstract.instanceof.App\Twig\AppExtension"; reason: abstract.
Removed service ".instanceof.Twig\Extension\ExtensionInterface.0.App\Twig\SourceCodeExtension"; reason: abstract.
Removed service ".abstract.instanceof.App\Twig\SourceCodeExtension"; reason: abstract.