Symfony Profiler

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8MB4"
    "host" => "localhost"
    "port" => 3306
    "user" => "pimcore_upgrade"
    "password" => "<redacted>"
    "dbname" => "pimcore_upgrade"
    "idle_connection_ttl" => 600
    "driverOptions" => [
      1002 => "SET sql_mode = '';"
    ]
    "serverVersion" => "10.5.21-MariaDB-0+deb11u1"
    "defaultTableOptions" => [
      "charset" => "UTF8MB4"
      "engine" => "InnoDB"
      "collate" => "utf8mb4_unicode_520_ci"
    ]
  ]
]

[
  "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 => 1770090062
    2 => "site_domain_c0d65ebf83354c98307dde87e6e5a961"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1366
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "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 => 1770090062
    2 => "system\x01tags\x01"
    3 => "site\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1366
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1379}
  ]
]

[
  "key" => "site_domain_c0d65ebf83354c98307dde87e6e5a961"
]

[
  "sql" => "SELECT * FROM tmp_store WHERE id = ?"
  "params" => [
    1 => "maintenance_mode"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "route" => "admin_pimcoredatahub_webservice"
  "route_parameters" => [
    "_route" => "admin_pimcoredatahub_webservice"
    "_controller" => "Pimcore\Bundle\DataHubBundle\Controller\WebserviceController::webonyxAction"
    "clientname" => "offers"
  ]
  "request_uri" => "https://pim.experienciah.app/pimcore-graphql-webservices/offers"
  "method" => "POST"
]

[
  "path" => "/pimcore-graphql-webservices/offers"
  "context" => "default"
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/pimcore-graphql-webservices/"
    2 => "offers"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1379}
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/pimcore-graphql-webservices/offers"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => "pimcore-graphql-webservices"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1379}
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/pimcore-graphql-webservices"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => ""
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1379}
  ]
]

[
  "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 => 1770090062
    2 => "document_1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1366
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "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 => 1770090062
    2 => "document_1\x01tags\x01"
    3 => "asset_337\x01tags\x01"
    4 => "asset_3\x01tags\x01"
    5 => "asset_319\x01tags\x01"
    6 => "asset_361\x01tags\x01"
    7 => "asset_320\x01tags\x01"
    8 => "asset_318\x01tags\x01"
    9 => "asset_321\x01tags\x01"
    10 => "asset_224\x01tags\x01"
    11 => "asset_35\x01tags\x01"
    12 => "asset_211\x01tags\x01"
    13 => "asset_90\x01tags\x01"
    14 => "asset_58\x01tags\x01"
    15 => "asset_180\x01tags\x01"
    16 => "asset_124\x01tags\x01"
    17 => "asset_164\x01tags\x01"
    18 => "asset_81\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1366
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1379}
    4 => Doctrine\DBAL\ParameterType {#1379}
    5 => Doctrine\DBAL\ParameterType {#1379}
    6 => Doctrine\DBAL\ParameterType {#1379}
    7 => Doctrine\DBAL\ParameterType {#1379}
    8 => Doctrine\DBAL\ParameterType {#1379}
    9 => Doctrine\DBAL\ParameterType {#1379}
    10 => Doctrine\DBAL\ParameterType {#1379}
    11 => Doctrine\DBAL\ParameterType {#1379}
    12 => Doctrine\DBAL\ParameterType {#1379}
    13 => Doctrine\DBAL\ParameterType {#1379}
    14 => Doctrine\DBAL\ParameterType {#1379}
    15 => Doctrine\DBAL\ParameterType {#1379}
    16 => Doctrine\DBAL\ParameterType {#1379}
    17 => Doctrine\DBAL\ParameterType {#1379}
    18 => Doctrine\DBAL\ParameterType {#1379}
  ]
]

[
  "key" => "document_1"
]

[
  "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 => 1770090062
    2 => "document_properties_1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1366
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "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 => 1770090062
    2 => "document_properties\x01tags\x01"
    3 => "document_1\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1366
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1379}
  ]
]

[
  "key" => "document_properties_1"
]

[
  "editmode" => "false"
  "params" => [
    "param" => false
    "adminRequest" => false
    "user" => false
  ]
]

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

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\CustomAdminEntryPointCheckListener::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\Bridge\Doctrine\Middleware\IdleConnection\Listener::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" => "ContainerBL7zFt6\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT id, name FROM classes"
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "barLounge"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "18"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "BusinessLeisure"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "22"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Chambre"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "11"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "ClasseHotel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "CLASS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Espace"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "ESP"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Event"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "EV"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Explore"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "ExpressYourself"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "23"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Fitness"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Hotel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "HOT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "LinkActivityDefinition"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "5"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Marque"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "MA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Mice"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "14"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "News"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "NE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Offre"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Programme"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "26"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Restaurant"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "13"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Restaurants"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "RoomService"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "20"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Services"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "SRV"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "SPA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "12"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "spas"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "17"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "SsoIdentity"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "3"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Sub"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "TermSegmentBuilderDefinition"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "4"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "TypesEspaces"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "7"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "TypesOffres"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "9"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "TypesServices"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "8"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "UniversEnfants"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "21"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "WorkCelebrate"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "24"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "zone404"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "27"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Restaurant"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Offre"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Marque"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "Hotel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1379
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT COUNT(*) FROM object_localized_10_en WHERE  (\n
                (\n
                    SELECT `read` from `plugin_datahub_workspaces_object`\n
                    WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'\n
                    AND LOCATE(CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key),`plugin_datahub_workspaces_object`.cpath)=1\n
                    ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC\n
                    LIMIT 1\n
                )=1\n
                OR\n
                (\n
                    SELECT `read` from `plugin_datahub_workspaces_object`\n
                    WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'\n
                    AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key))=1\n
                    ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC\n
                    LIMIT 1\n
                )=1\n
                ) AND  ((`object_localized_10_en`.`modificationDate` > '1770090002') )  AND  object_localized_10_en.type IN ('object','folder','variant')
    """
]

[
  "sql" => """
    SELECT object_localized_10_en.id as id, object_localized_10_en.type as `type` FROM object_localized_10_en WHERE  (\n
                (\n
                    SELECT `read` from `plugin_datahub_workspaces_object`\n
                    WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'\n
                    AND LOCATE(CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key),`plugin_datahub_workspaces_object`.cpath)=1\n
                    ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC\n
                    LIMIT 1\n
                )=1\n
                OR\n
                (\n
                    SELECT `read` from `plugin_datahub_workspaces_object`\n
                    WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'\n
                    AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key))=1\n
                    ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC\n
                    LIMIT 1\n
                )=1\n
                ) AND  ((`object_localized_10_en`.`modificationDate` > '1770090002') )  AND  object_localized_10_en.type IN ('object','folder','variant')
    """
]