Symfony Profiler

[
  "route" => "homepage"
  "route_parameters" => [
    "_route" => "homepage"
    "_controller" => "App\Controller\DefaultController::index"
  ]
  "request_uri" => "https://test.tillomeditalia.com/"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "exception" => Symfony\Component\Security\Core\Exception\InvalidCsrfTokenException {#114
    #message: "Invalid CSRF token."
    #code: 0
    #file: "/var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/EventListener/CsrfProtectionListener.php"
    #line: 51
    -token: null
    trace: {
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/EventListener/CsrfProtectionListener.php:51 {
        Symfony\Component\Security\Http\EventListener\CsrfProtectionListener->checkPassport(CheckPassportEvent $event): void …
        › if (false === $this->csrfTokenManager->isTokenValid($csrfToken)) {
        ›     throw new InvalidCsrfTokenException('Invalid CSRF token.');
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:270 {
        Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} …
        ›     }
        ›     ($closure = \Closure::fromCallable($listener))(...$args);
        › };
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
        Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
        ›     }
        ›     $listener($event, $eventName, $this);
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
        Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
        › if ($listeners) {
        ›     $this->callListeners($listeners, $eventName, $event);
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authentication/AuthenticatorManager.php:184 {
        Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator(AuthenticatorInterface $authenticator, Request $request): Response …
        › $event = new CheckPassportEvent($authenticator, $passport);
        › $this->eventDispatcher->dispatch($event);
        › 
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authentication/AuthenticatorManager.php:161 {
        Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators(array $authenticators, Request $request): Response …
        › 
        › $response = $this->executeAuthenticator($authenticator, $request);
        › if (null !== $response) {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authentication/AuthenticatorManager.php:141 {
        Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest(Request $request): Response …
        › 
        ›     return $this->executeAuthenticators($authenticators, $request);
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Firewall/AuthenticatorManagerListener.php:40 {
        Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate(RequestEvent $event): void …
        › $request = $event->getRequest();
        › $response = $this->authenticatorManager->authenticateRequest($request);
        › if (null === $response) {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticatorManagerListener.php:65 {
        Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate(RequestEvent $event): void …
        › 
        › $this->authenticationManagerListener->authenticate($event);
        › 
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:49 {
        Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate(RequestEvent $event) …
        › try {
        ›     $ret = $this->listener->authenticate($event);
        › } catch (LazyResponseException $e) {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Firewall/AbstractListener.php:26 {
        Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke(RequestEvent $event) …
        › if (false !== $this->supports($event->getRequest())) {
        ›     $this->authenticate($event);
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-bundle/Security/LazyFirewallContext.php:60 {
        Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke(RequestEvent $event) …
        › foreach ($listeners as $listener) {
        ›     $listener($event);
        › 
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:70 {
        Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners) …
        › 
        ›     $listener($event);
        › } else {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Firewall.php:92 {
        Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event) …
        › 
        ›     $this->callListeners($event, $authenticationListeners());
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117 {
        Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
        › 
        › ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
        › 
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
        Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
        ›     }
        ›     $listener($event, $eventName, $this);
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
        Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
        › if ($listeners) {
        ›     $this->callListeners($listeners, $eventName, $event);
        › }
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
        Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
        › try {
        ›     $this->dispatcher->dispatch($event, $eventName);
        › } finally {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/http-kernel/HttpKernel.php:139 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › $event = new RequestEvent($this, $request, $type);
        › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
        › 
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/http-kernel/HttpKernel.php:75 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
        › try {
        ›     return $this->handleRaw($request, $type);
        › } catch (\Exception $e) {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/http-kernel/Kernel.php:202 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
        › try {
        ›     return $this->getHttpKernel()->handle($request, $type, $catch);
        › } finally {
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        ›     $response->send();
      }
      /var/www/vhosts/test.tillomeditalia.com/vendor/autoload_runtime.php:29 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/vhosts/test.tillomeditalia.com/httpdocs/index.php:5 {
        › \r
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';\r
        › \r
        arguments: {
          "/var/www/vhosts/test.tillomeditalia.com/vendor/autoload_runtime.php"
        }
      }
    }
  }
  "authenticator" => "App\Security\FormLoginAuthenticator"
]

{
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/EventListener/CsrfProtectionListener.php:51 {
    Symfony\Component\Security\Http\EventListener\CsrfProtectionListener->checkPassport(CheckPassportEvent $event): void …
    › if (false === $this->csrfTokenManager->isTokenValid($csrfToken)) {
    ›     throw new InvalidCsrfTokenException('Invalid CSRF token.');
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:270 {
    Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} …
    ›     }
    ›     ($closure = \Closure::fromCallable($listener))(...$args);
    › };
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
    ›     }
    ›     $listener($event, $eventName, $this);
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
    › if ($listeners) {
    ›     $this->callListeners($listeners, $eventName, $event);
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authentication/AuthenticatorManager.php:184 {
    Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator(AuthenticatorInterface $authenticator, Request $request): Response …
    › $event = new CheckPassportEvent($authenticator, $passport);
    › $this->eventDispatcher->dispatch($event);
    › 
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authentication/AuthenticatorManager.php:161 {
    Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators(array $authenticators, Request $request): Response …
    › 
    › $response = $this->executeAuthenticator($authenticator, $request);
    › if (null !== $response) {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authentication/AuthenticatorManager.php:141 {
    Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest(Request $request): Response …
    › 
    ›     return $this->executeAuthenticators($authenticators, $request);
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Firewall/AuthenticatorManagerListener.php:40 {
    Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate(RequestEvent $event): void …
    › $request = $event->getRequest();
    › $response = $this->authenticatorManager->authenticateRequest($request);
    › if (null === $response) {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticatorManagerListener.php:65 {
    Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate(RequestEvent $event): void …
    › 
    › $this->authenticationManagerListener->authenticate($event);
    › 
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:49 {
    Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate(RequestEvent $event) …
    › try {
    ›     $ret = $this->listener->authenticate($event);
    › } catch (LazyResponseException $e) {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Firewall/AbstractListener.php:26 {
    Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke(RequestEvent $event) …
    › if (false !== $this->supports($event->getRequest())) {
    ›     $this->authenticate($event);
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-bundle/Security/LazyFirewallContext.php:60 {
    Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke(RequestEvent $event) …
    › foreach ($listeners as $listener) {
    ›     $listener($event);
    › 
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:70 {
    Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners) …
    › 
    ›     $listener($event);
    › } else {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/security-http/Firewall.php:92 {
    Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event) …
    › 
    ›     $this->callListeners($event, $authenticationListeners());
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117 {
    Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
    › 
    › ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
    › 
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
    ›     }
    ›     $listener($event, $eventName, $this);
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
    › if ($listeners) {
    ›     $this->callListeners($listeners, $eventName, $event);
    › }
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
    Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
    › try {
    ›     $this->dispatcher->dispatch($event, $eventName);
    › } finally {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/http-kernel/HttpKernel.php:139 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › $event = new RequestEvent($this, $request, $type);
    › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
    › 
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/http-kernel/HttpKernel.php:75 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
    › try {
    ›     return $this->handleRaw($request, $type);
    › } catch (\Exception $e) {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/http-kernel/Kernel.php:202 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
    › try {
    ›     return $this->getHttpKernel()->handle($request, $type, $catch);
    › } finally {
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    ›     $response->send();
  }
  /var/www/vhosts/test.tillomeditalia.com/vendor/autoload_runtime.php:29 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/vhosts/test.tillomeditalia.com/httpdocs/index.php:5 {
    › \r
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';\r
    › \r
    arguments: {
      "/var/www/vhosts/test.tillomeditalia.com/vendor/autoload_runtime.php"
    }
  }
}

[
  "authenticator" => "App\Security\FormLoginAuthenticator"
]

[
  "authenticator" => "App\Security\FormLoginAuthenticator"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::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" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

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

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

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

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

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

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "tillomed_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "test_tillomeditalia_com_db"
    "serverVersion" => "mariadb-5.5.68"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.yellow_alarm AS yellow_alarm_1, t0_.red_alarm AS red_alarm_2, t0_.avg_sell_cadence AS avg_sell_cadence_3, t0_.num_of_buy_dates AS num_of_buy_dates_4, t0_.last_order_date AS last_order_date_5, t0_.notes AS notes_6, t0_.disabled AS disabled_7, t0_.facility_id AS facility_id_8, t0_.product_id AS product_id_9 FROM til_join_table_facility_product t0_ LEFT JOIN til_facility t1_ ON t0_.facility_id = t1_.id ORDER BY t1_.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "sells_last_import_date"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "sells_old_last_import_date"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.import_date AS import_date_2, t0_.document_type AS document_type_3, t0_.issue_date AS issue_date_4, t0_.week_number AS week_number_5, t0_.month_number AS month_number_6, t0_.document_number AS document_number_7, t0_.product_code AS product_code_8, t0_.atc_code AS atc_code_9, t0_.aic_code AS aic_code_10, t0_.product_description AS product_description_11, t0_.lot_number AS lot_number_12, t0_.quantity AS quantity_13, t0_.net_unit_price AS net_unit_price_14, t0_.box_quantity AS box_quantity_15, t0_.net_box_price AS net_box_price_16, t0_.net_price AS net_price_17, t0_.charged_price AS charged_price_18, t0_.client_category AS client_category_19, t0_.client_code AS client_code_20, t0_.client_ministerial_code AS client_ministerial_code_21, t0_.client_business_name AS client_business_name_22, t0_.client_address AS client_address_23, t0_.client_province AS client_province_24, t0_.client_city AS client_city_25, t0_.client_zip AS client_zip_26, t0_.client_region AS client_region_27, t0_.vat AS vat_28, t0_.order_number AS order_number_29, t0_.order_date AS order_date_30, t0_.ref_date AS ref_date_31, t0_.receiver_client_code AS receiver_client_code_32, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_33, t0_.receiver_client_business_name AS receiver_client_business_name_34, t0_.receiver_client_address AS receiver_client_address_35, t0_.receiver_client_province AS receiver_client_province_36, t0_.receiver_client_city AS receiver_client_city_37, t0_.receiver_client_zip AS receiver_client_zip_38, t0_.receiver_client_region AS receiver_client_region_39, t0_.kam AS kam_40, t0_.extra AS extra_41, t0_.notes AS notes_42, t0_.email AS email_43, t0_.lot_expiration_date AS lot_expiration_date_44, t0_.vs_vi AS vs_vi_45, t0_.invoice_num AS invoice_num_46, t0_.division AS division_47, t0_.organization AS organization_48, t0_.material AS material_49, t0_.selling_unit AS selling_unit_50, t0_.tax AS tax_51, t0_.backup_quantity AS backup_quantity_52, t0_.backup_net_unit_price AS backup_net_unit_price_53, t0_.num_of_docs_control AS num_of_docs_control_54, t0_.control_docs_date AS control_docs_date_55, t0_.delivery_num AS delivery_num_56, t0_.delivery_date AS delivery_date_57, t0_.cost AS cost_58, t0_.cold AS cold_59, t0_.cig_number AS cig_number_60, t0_.invoice_voice AS invoice_voice_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.user_id AS user_id_65 FROM til_sell t0_ WHERE t0_.import_date > ? AND t0_.import_date <= ?"
  "params" => [
    1 => "2023-04-28"
    2 => "2023-04-30"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "sells_last_import_date"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.vat AS vat_2, t0_.address AS address_3, t0_.zip AS zip_4, t0_.email AS email_5, t0_.pec AS pec_6, t0_.sdi AS sdi_7, t0_.phone AS phone_8, t0_.fax AS fax_9, t0_.minister_code AS minister_code_10, t0_.head_group AS head_group_11, t0_.is_public AS is_public_12, t0_.lat AS lat_13, t0_.lng AS lng_14, t0_.city_id AS city_id_15, t0_.hospital_group_id AS hospital_group_id_16 FROM til_hospital t0_ WHERE t0_.is_public IS NULL"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.address AS address_2, t0_.zip AS zip_3, t0_.lat AS lat_4, t0_.lng AS lng_5, t0_.is_public AS is_public_6, t0_.is_abbandoned_ignored AS is_abbandoned_ignored_7, t0_.minister_code AS minister_code_8, t0_.city_id AS city_id_9, t0_.assigned_kam_id AS assigned_kam_id_10, t0_.hospital_id AS hospital_id_11 FROM til_facility t0_ WHERE t0_.hospital_id IS NULL ORDER BY t0_.name ASC LIMIT 50"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.motivation AS motivation_1, t0_.date AS date_2, t0_.response AS response_3, t0_.status AS status_4, t0_.is_notified AS is_notified_5, t0_.user_id AS user_id_6 FROM til_request_holiday t0_ WHERE t0_.status = ? ORDER BY t0_.date DESC"
  "params" => [
    1 => "insert"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.object_id AS object_id_2, t0.datetime AS datetime_3, t0.type AS type_4, t0.old_value AS old_value_5, t0.new_value AS new_value_6, t0.old_notes AS old_notes_7, t0.new_notes AS new_notes_8, t0.sender_id AS sender_id_9 FROM til_edit_request t0"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.name AS name_2, t0_.surname AS surname_3, t0_.password AS password_4, t0_.is_active AS is_active_5, t0_.is_admin_active AS is_admin_active_6, t0_.directory_path AS directory_path_7, t0_.one_time_code AS one_time_code_8, t0_.expiration_one_time_code AS expiration_one_time_code_9, t0_.is_email_notification_active AS is_email_notification_active_10, t0_.office_hours AS office_hours_11, t0_.is_alert_read AS is_alert_read_12, t0_.is_gdpr_sent AS is_gdpr_sent_13, t0_.role AS role_14, t0_.account_type_id AS account_type_id_15, t0_.supervisor_id AS supervisor_id_16 FROM til_user t0_ LEFT JOIN til_account_type t1_ ON t0_.account_type_id = t1_.id WHERE (t1_.level < 4) AND t0_.is_admin_active = 1 AND t1_.slug <> ? AND t0_.email <> ? ORDER BY t0_.surname ASC, t0_.name ASC"
  "params" => [
    1 => "supervisor_mario"
    2 => "rporrati@rpgmultimedia.it"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1746"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1746"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1746"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "33"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "33"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "33"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1926"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1926"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1926"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1844"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1844"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1844"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1748"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1748"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1748"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1348"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1348"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1348"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "2187"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "2187"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "2187"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "29"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "29"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "29"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1845"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1845"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1845"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1940"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1940"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1940"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1174"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1174"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1174"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1867"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1867"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1867"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "39"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "39"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "39"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "24"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "24"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "24"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "35"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "35"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "35"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1481"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1481"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1481"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "816"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "816"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "816"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1746"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "52"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "73"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "33"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "12"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "29"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "42"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "63"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1926"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "59"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "78"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1844"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "54"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "62"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1748"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "50"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "72"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1348"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "36"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "51"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "76"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "2187"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "80"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "29"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "17"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "25"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "47"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "65"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1845"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "55"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "69"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1940"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "60"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "64"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1174"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "23"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "31"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "49"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "70"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1867"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "56"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "61"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "39"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "10"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "13"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "34"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "40"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "67"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "24"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "6"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "18"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "30"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "53"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "75"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "35"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "15"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "32"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "48"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "74"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "1481"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "38"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "41"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "66"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "816"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC"
  "params" => [
    1 => "35"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "test_tillomeditalia_com_db"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

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

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

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

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

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