Method "Symfony\Component\DependencyInjection\Extension\ExtensionInterface::load()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataHubBundle\DependencyInjection\PimcoreDataHubExtension" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Extension\PrependExtensionInterface::prepend()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataHubBundle\DependencyInjection\PimcoreDataHubExtension" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Extension\ExtensionInterface::load()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\PimcoreDataImporterExtension" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Extension\PrependExtensionInterface::prepend()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\PimcoreDataImporterExtension" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataHubBundle\DependencyInjection\Compiler\ImportExportLocatorsPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataHubBundle\DependencyInjection\Compiler\CustomDocumentTypePass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\CompilerPass\MappingConfigurationFactoryPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\CompilerPass\ResolverConfigurationFactoryPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\CompilerPass\LoaderConfigurationFactoryPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\CompilerPass\InterpreterConfigurationFactoryPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Pimcore\Bundle\DataImporterBundle\DependencyInjection\CompilerPass\CleanupStrategyConfigurationFactoryPass" now to avoid errors or add an explicit @return annotation to suppress this message.
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "site_domain_bedb1e5f98f4fc452292c5f8cc85c060"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)"
[
"sql" => "SELECT * FROM settings_store WHERE id = ? AND scope = ?"
"params" => [1 => "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
2 => "pimcore"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"""
SELECT * FROM redirects WHERE\n (\n (source = ? AND (`type` = ? OR `type` = ?)) OR\n (source = ? AND `type` = ?) OR\n (source = ? AND `type` = ?)\n ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
"""
[
"sql" => """
SELECT * FROM redirects WHERE\n (\n (source = ? AND (`type` = ? OR `type` = ?)) OR\n (source = ? AND `type` = ?) OR\n (source = ? AND `type` = ?)\n ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
"""
"params" => [1 => "/api/webshop/common/contentList"
2 => "path"
3 => "auto_create"
4 => "/api/webshop/common/contentList"
5 => "path_query"
6 => "https://plm.turbob2b.com/api/webshop/common/contentList"
7 => "entire_uri"
]
"types" => [1 => 22 => 23 => 24 => 25 => 26 => 27 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "system_route_redirect"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "system_route_redirect"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
"SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
(parameters:
[1 => "/api/webshop/common/"
2 => "contentList"
]
, types:
[1 => 22 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
"params" => [1 => "/api/webshop/common/"
2 => "contentList"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"SELECT id FROM documents_page WHERE prettyUrl = ?"
(parameters:
[1 => "/api/webshop/common/contentList"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
"params" => [1 => "/api/webshop/common/contentList"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
(parameters:
[1 => "/api/webshop/"
2 => "common"
]
, types:
[1 => 22 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
"params" => [1 => "/api/webshop/"
2 => "common"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"SELECT id FROM documents_page WHERE prettyUrl = ?"
(parameters:
[1 => "/api/webshop/common"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
"params" => [1 => "/api/webshop/common"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
(parameters:
[1 => "/api/"
2 => "webshop"
]
, types:
[1 => 22 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
"params" => [1 => "/api/"
2 => "webshop"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"SELECT id FROM documents_page WHERE prettyUrl = ?"
(parameters:
[1 => "/api/webshop"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
"params" => [1 => "/api/webshop"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
(parameters:
[1 => "/"
2 => "api"
]
, types:
[1 => 22 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
"params" => [1 => "/"
2 => "api"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"SELECT id FROM documents_page WHERE prettyUrl = ?"
(parameters:
[1 => "/api"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
"params" => [1 => "/api"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
(parameters:
[1 => "/"
2 => ""
]
, types:
[1 => 22 => 2]
)
doctrine
[
"sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
"params" => [1 => "/"
2 => ""
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "document_1"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "document_1"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "document_1\x01tags\x01"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "document_1\x01tags\x01"
]
"types" => [1 => 12 => 2]
]
debug
Successfully got data for key
"document_1"
from cache
cache
[
"key" => "document_1"
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "document_properties_1"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "document_properties_1"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "\x00tags\x00document_properties_1"
]
"types" => [1 => 12 => 2]
]
debug
Key
"document_properties_1"
doesn't exist in cache
cache
[
"key" => "document_properties_1"
]
debug
Executing statement:
"""
SELECT * FROM properties WHERE\n (\n (cid IN (1) AND inheritable = 1) OR cid = ?\n ) AND ctype='document'
"""
(parameters:
[1 => 1]
, types:
[1 => 2]
)
doctrine
[
"sql" => """
SELECT * FROM properties WHERE\n (\n (cid IN (1) AND inheritable = 1) OR cid = ?\n ) AND ctype='document'
"""
"params" => [1 => 1]
"types" => [1 => 2]
]
[
"sql" => "SELECT name FROM classes WHERE id = ?"
"params" => [1 => "PimContent"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT object_PimContent.id as id, object_PimContent.type as `type` FROM object_PimContent WHERE ((`lang` = ?) AND object_PimContent.type IN ('object','variant','folder')) AND object_PimContent.published = 1 ORDER BY `oo_id` DESC LIMIT 4"
(parameters:
[1 => "zh"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT object_PimContent.id as id, object_PimContent.type as `type` FROM object_PimContent WHERE ((`lang` = ?) AND object_PimContent.type IN ('object','variant','folder')) AND object_PimContent.published = 1 ORDER BY `oo_id` DESC LIMIT 4"
"params" => [1 => "zh"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "object_37184"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "object_37184"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
"params" => [1 => 17763476452 => "object_37184\x01tags\x01"
3 => "class_PimContent\x01tags\x01"
4 => "asset_2566\x01tags\x01"
]
"types" => [1 => 12 => 23 => 24 => 2]
]
debug
Successfully got data for key
"object_37184"
from cache
cache
[
"key" => "object_37184"
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "object_34617"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "object_34617"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
"params" => [1 => 17763476452 => "object_34617\x01tags\x01"
3 => "class_PimContent\x01tags\x01"
4 => "asset_2471\x01tags\x01"
]
"types" => [1 => 12 => 23 => 24 => 2]
]
debug
Successfully got data for key
"object_34617"
from cache
cache
[
"key" => "object_34617"
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "object_34608"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "object_34608"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
"params" => [1 => 17763476452 => "object_34608\x01tags\x01"
3 => "class_PimContent\x01tags\x01"
4 => "asset_2482\x01tags\x01"
]
"types" => [1 => 12 => 23 => 24 => 2]
]
debug
Successfully got data for key
"object_34608"
from cache
cache
[
"key" => "object_34608"
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
(parameters:
[1 => 17763476452 => "object_34606"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
"params" => [1 => 17763476452 => "object_34606"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
[
"sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)"
"params" => [1 => 17763476452 => "object_34606\x01tags\x01"
3 => "class_PimContent\x01tags\x01"
4 => "asset_2479\x01tags\x01"
]
"types" => [1 => 12 => 23 => 24 => 2]
]
debug
Successfully got data for key
"object_34606"
from cache
cache
[
"key" => "object_34606"
]
deprecation
User Deprecated: Getting query parts is deprecated as they are implementation details. (QueryBuilder.php:1333 called by QueryBuilderHelperTrait.php:132, https://github.com/doctrine/dbal/pull/6179, package doctrine/dbal)
"SELECT COUNT(*) FROM object_PimContent WHERE ((`lang` = ?) AND object_PimContent.type IN ('object','variant','folder')) AND object_PimContent.published = 1"
(parameters:
[1 => "zh"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT COUNT(*) FROM object_PimContent WHERE ((`lang` = ?) AND object_PimContent.type IN ('object','variant','folder')) AND object_PimContent.published = 1"
"params" => [1 => "zh"
]
"types" => [1 => 2]
]
deprecation
User Deprecated: Since symfony/framework-bundle 6.4: The "annotations.cached_reader" service is deprecated without replacement.
User Deprecated: Since symfony/serializer 6.4: Passing a "Doctrine\Common\Annotations\PsrCachedReader" instance as argument 1 to "Symfony\Component\Serializer\Mapping\Loader\AttributeLoader::__construct()" is deprecated, pass null or omit the parameter instead.
User Deprecated: Since symfony/validator 6.4: Method "Symfony\Component\Validator\ValidatorBuilder::setDoctrineAnnotationReader()" is deprecated without replacement.