Since symfony/framework-bundle 5.3: Not setting the "framework.session.storage_factory_id" configuration option is deprecated, it will default to "session.storage.factory.native" and will replace the "framework.session.storage_id" configuration option in version 6.0.
Since symfony/security-http 5.3: The "Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag" service is deprecated, create your own "session.storage.factory" instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.anonymous.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.manager" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\AuthenticationProviderManager" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Event\AuthenticationFailureEvent" class is deprecated, use "Symfony\Component\Security\Http\Event\LoginFailureEvent" with the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.3: The "Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.4: The $authManager argument of "Symfony\Component\Security\Http\Firewall\AccessListener::__construct" is deprecated.
User Deprecated: Since symfony/security-http 5.4: Not setting the $exceptionOnNoToken argument of "Symfony\Component\Security\Http\Firewall\AccessListener::__construct" to "false" is deprecated.
"SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4 FROM reporter_partner r0_ GROUP BY r0_.reporter ORDER BY r0_.reporter ASC"
doctrine
[
"sql" => "SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4 FROM reporter_partner r0_ GROUP BY r0_.reporter ORDER BY r0_.reporter ASC"
]
debug
Executing query:
"SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4 FROM reporter_partner r0_ GROUP BY r0_.partner ORDER BY r0_.partner ASC"
doctrine
[
"sql" => "SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4 FROM reporter_partner r0_ GROUP BY r0_.partner ORDER BY r0_.partner ASC"
]
deprecation
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.
SELECT t.commodityCode FROM App\Entity\ReporterPartner t GROUP BY t.commodityCode ORDER BY t.commodityCode ASC
app
debug
Executing statement:
"SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4, p1_.id AS id_5, p1_.year AS year_6, p1_.month AS month_7, p1_.value AS value_8, p1_.period_date AS period_date_9, p1_.reporter_partner_id AS reporter_partner_id_10 FROM reporter_partner r0_ INNER JOIN period p1_ ON r0_.id = p1_.reporter_partner_id WHERE r0_.reporter = ? AND r0_.partner = ? AND r0_.trade_flow IN (?, ?, ?) AND p1_.month IS NOT NULL AND p1_.period_date >= ? AND p1_.period_date <= ? ORDER BY r0_.commodity_code ASC"
[
"sql" => "SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4, p1_.id AS id_5, p1_.year AS year_6, p1_.month AS month_7, p1_.value AS value_8, p1_.period_date AS period_date_9, p1_.reporter_partner_id AS reporter_partner_id_10 FROM reporter_partner r0_ INNER JOIN period p1_ ON r0_.id = p1_.reporter_partner_id WHERE r0_.reporter = ? AND r0_.partner = ? AND r0_.trade_flow IN (?, ?, ?) AND p1_.month IS NOT NULL AND p1_.period_date >= ? AND p1_.period_date <= ? ORDER BY r0_.commodity_code ASC"
"params" => [1 => "China"
2 => "USA"
3 => "Exports"
4 => "Imports"
5 => "Net Trade"
6 => "2020-01-03 08:08:25"
7 => "2020-12-03 08:08:25"
]
"types" => [1 => 22 => 23 => 24 => 25 => 26 => 27 => 2]
]
deprecation
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.factory.service" service is deprecated, use "session.storage.factory.native", "session.storage.factory.php_bridge" or "session.storage.factory.mock_file" instead.
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/security-core 5.4: Using an object that is not an instance of "Symfony\Component\Security\Core\User\UserInterface" as $user in "Symfony\Component\Security\Core\Authentication\Token\AnonymousToken" is deprecated.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.provider.anonymous.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\Provider\AnonymousAuthenticationProvider" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\Provider\AuthenticationProviderInterface" interface is deprecated, use the new authenticator system instead.
Populated the TokenStorage with an anonymous Token.
security
deprecation
User Deprecated: Since symfony/security-bundle 5.4: The "Symfony\Bundle\SecurityBundle\Security\FirewallConfig::allowsAnonymous()" method is deprecated.