The "Symfony\Component\HttpKernel\DependencyInjection\Extension" class is considered internal since Symfony 7.1, to be deprecated in 8.1; use Symfony\Component\DependencyInjection\Extension\Extension instead. It may change without further notice. You should not use it from "Presta\SitemapBundle\DependencyInjection\PrestaSitemapExtension".
[
"sql" => "SELECT Value FROM `System` WHERE `Key` = ?"
"params" => [1 => "WebsiteDefaultCountry"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT currencyCode as CurrencyCode FROM Country c WHERE countryCode = ?"
(parameters:
[1 => "NA"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT currencyCode as CurrencyCode FROM Country c WHERE countryCode = ?"
"params" => [1 => "NA"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT currencySign as CurrencySign FROM Country c WHERE countryCode = ?"
(parameters:
[1 => "NA"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT currencySign as CurrencySign FROM Country c WHERE countryCode = ?"
"params" => [1 => "NA"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT CountryCode FROM Pricing p WHERE CountryCode = ?"
(parameters:
[1 => "NA"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT CountryCode FROM Pricing p WHERE CountryCode = ?"
"params" => [1 => "NA"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT p.*, c.currencySign as CurrencySign, c.currencyCode as CurrencyCode FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE p.CountryCode = ?"
(parameters:
[1 => "NA"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT p.*, c.currencySign as CurrencySign, c.currencyCode as CurrencyCode FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE p.CountryCode = ?"
"params" => [1 => "NA"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT * FROM Package WHERE ID = ?"
(parameters:
[1 => 1]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT * FROM Package WHERE ID = ?"
"params" => [1 => 1]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT * FROM Package WHERE ID = ?"
(parameters:
[1 => 2]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT * FROM Package WHERE ID = ?"
"params" => [1 => 2]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT * FROM Package WHERE ID = ?"
(parameters:
[1 => 3]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT * FROM Package WHERE ID = ?"
"params" => [1 => 3]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT * FROM Package WHERE ID = ?"
(parameters:
[1 => 100]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT * FROM Package WHERE ID = ?"
"params" => [1 => 100]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT c.CountryCode, countryName as CountryName FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE Active = ? GROUP BY CountryCode, CountryName ORDER BY CountryName ASC"
(parameters:
[1 => "Y"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT c.CountryCode, countryName as CountryName FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE Active = ? GROUP BY CountryCode, CountryName ORDER BY CountryName ASC"
"params" => [1 => "Y"
]
"types" => [1 => 2]
]