Symfony Profiler

[
  "event" => "pimcore.system.configuration.get"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\AdminConfigListener::updateSystemConfiguration"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8MB4"
    "host" => "mysql"
    "port" => 3306
    "user" => "pi_democultura"
    "password" => "<redacted>"
    "dbname" => "pi_democultura"
    "idle_connection_ttl" => 600
    "driverOptions" => [
      1002 => "SET sql_mode = '';"
    ]
    "serverVersion" => "8.2.0"
    "defaultTableOptions" => [
      "charset" => "UTF8MB4"
      "engine" => "InnoDB"
      "collate" => "utf8mb4_general_ci"
    ]
  ]
]

[
  "sql" => "SELECT * FROM tmp_store WHERE id = ?"
  "params" => [
    1 => "maintenance_mode"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users WHERE `type` = ? AND id = ?"
  "params" => [
    1 => "user"
    2 => 24
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_asset WHERE userId = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_document WHERE userId = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_object WHERE userId = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  24
  "pimcore_admin_dataobject_dataobject_get"
  []
  [
    "id" => "718"
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\CustomAdminEntryPointCheckListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Blackbit\DataDirectorBundle\EventListener\ContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\RoutingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\StaticPageGeneratorListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\AdminSessionBagListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\MaintenancePageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\FullPageCacheListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\PimcoreContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\DocumentFallbackListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\CsrfProtectionListener::handleRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\UserPerspectiveListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\UsageStatisticsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\TranslationDebugListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\BlockStateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\EditmodeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\OutputTimestampListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\DocumentFallbackListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\ElementListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\GlobalTemplateVariablesListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\EventedControllerListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\ResponseHeaderListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerG8jMIP2\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "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 => 1784736053
    2 => "object_718"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "34"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 => 1784736053
    2 => "object_718\x01tags\x01"
    3 => "class_34\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "object_718"
]

[
  "sql" => "SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (`date` > ? OR versionCount > ?) AND ((autoSave = 1 AND userId = ?) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1"
  "params" => [
    1 => 718
    2 => "object"
    3 => 1784733239
    4 => 9
    5 => 24
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT * FROM edit_lock WHERE cid = ? AND ctype = ?"
  "params" => [
    1 => 718
    2 => "object"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "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 => 1784736053
    2 => "system_resource_columns_edit_lock"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "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 => 1784736053
    2 => "system\x01tags\x01"
    3 => "resource\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "system_resource_columns_edit_lock"
]

[
  "sql" => "INSERT INTO edit_lock (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => null
    2 => 718
    3 => "object"
    4 => 24
    5 => "c9bfdddef0549ba71de7239f81c0f113"
    6 => 1784736053
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "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 => 1784736053
    2 => "object_717"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "12"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 => 1784736053
    2 => "object_717\x01tags\x01"
    3 => "class_12\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "object_717"
]

[
  "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 => 1784736053
    2 => "object_716"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "11"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 => 1784736053
    2 => "object_716\x01tags\x01"
    3 => "class_11\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "object_716"
]

[
  "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 => 1784736053
    2 => "object_1"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "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 => 1784736053
    2 => "object_1\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "object_1"
]

[
  "sql" => "SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1"
  "params" => [
    1 => "/Fondo Promemoria Group (716)/Affari generali e societari (717)/Atto costitutivo e statuti (718)/%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM tree_locks WHERE id IN (1,717,716) AND `type`='object' AND locked = 'propagate' LIMIT 1"
]

[
  "sql" => "SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"
]

[
  "sql" => """
    SELECT dataportId \n
                FROM plugin_pim_fieldmapping \n
                WHERE fieldName=? AND calculation LIKE ?
    """
  "params" => [
    1 => "__result_callback"
    2 => "%'Content-Disposition', 'inline'%"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM versions WHERE cid = ? AND ctype = ?  AND autoSave = 0 ORDER BY `id` ASC"
  "params" => [
    1 => 718
    2 => "object"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1367
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users WHERE `type` = ? AND id = ?"
  "params" => [
    1 => "user"
    2 => 6
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_asset WHERE userId = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_document WHERE userId = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_object WHERE userId = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1450
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1575
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users WHERE `type` = ? AND id = ?"
  "params" => [
    1 => "user"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_asset WHERE userId = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_document WHERE userId = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_object WHERE userId = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1576
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1577
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1779
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1780
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1861
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versions WHERE id = ?"
  "params" => [
    1 => 1867
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? "
  "params" => [
    1 => 718
    2 => "object"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT classId FROM objects WHERE `path` like ? AND `type` = 'object'"
  "params" => [
    1 => "/Fondo Promemoria Group (716)/Affari generali e societari (717)/Atto costitutivo e statuti (718)/%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "collocazioni_collegate"
    2 => 718
    3 => "collocazioni_collegate"
    4 => 718
    5 => "collocazioni_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => "SELECT * FROM object_relations_34 WHERE src_id = ?"
  "params" => [
    1 => 718
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "audiovideo_collegati"
    2 => 718
    3 => "audiovideo_collegati"
    4 => 718
    5 => "audiovideo_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "bibliografiefonti_collegate"
    2 => 718
    3 => "bibliografiefonti_collegate"
    4 => 718
    5 => "bibliografiefonti_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "corrispondenza_collegata"
    2 => 718
    3 => "corrispondenza_collegata"
    4 => 718
    5 => "corrispondenza_collegata"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "delibere_collegate"
    2 => 718
    3 => "delibere_collegate"
    4 => 718
    5 => "delibere_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "documenti_collegati"
    2 => 718
    3 => "documenti_collegati"
    4 => 718
    5 => "documenti_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "fotografie_collegate"
    2 => 718
    3 => "fotografie_collegate"
    4 => 718
    5 => "fotografie_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "iconografiche_collegate"
    2 => 718
    3 => "iconografiche_collegate"
    4 => 718
    5 => "iconografiche_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "manoscritti_collegati"
    2 => 718
    3 => "manoscritti_collegati"
    4 => 718
    5 => "manoscritti_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "oggetti_collegati"
    2 => 718
    3 => "oggetti_collegati"
    4 => 718
    5 => "oggetti_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "bibliografiche_collegate"
    2 => 718
    3 => "bibliografiche_collegate"
    4 => 718
    5 => "bibliografiche_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "verbali_collegati"
    2 => 718
    3 => "verbali_collegati"
    4 => 718
    5 => "verbali_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "fondi_collegati"
    2 => 718
    3 => "fondi_collegati"
    4 => 718
    5 => "fondi_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "livelli_collegati"
    2 => 718
    3 => "livelli_collegati"
    4 => 718
    5 => "livelli_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "raccolte_collegate"
    2 => 718
    3 => "raccolte_collegate"
    4 => 718
    5 => "raccolte_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "sezioni_collegate"
    2 => 718
    3 => "sezioni_collegate"
    4 => 718
    5 => "sezioni_collegate"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "sql" => """
    SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index\n
                FROM objects o, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND o.id = r.dest_id\n
                AND r.type='object'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index\n
                FROM assets a, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND a.id = r.dest_id\n
                AND r.type='asset'\n
    \n
                UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index\n
                FROM documents d, object_relations_34 r\n
                WHERE r.fieldname= ?\n
                AND r.ownertype = 'object'\n
                AND r.src_id = ?\n
                AND d.id = r.dest_id\n
                AND r.type='document'\n
    \n
                ORDER BY `index` ASC
    """
  "params" => [
    1 => "subfondi_collegati"
    2 => 718
    3 => "subfondi_collegati"
    4 => 718
    5 => "subfondi_collegati"
    6 => 718
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]