Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_5061e09f81735ede2c26d4894faa91ad');

INSERT INTO http_error_log (
  uri, code, parametersGet, parametersPost,
  cookies, serverVars, date, count
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES ('http://45.132.247.172:85/de/Schutzzaeune-alt', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:63:{s:8:\"HOSTNAME\";s:12:\"62a73504f967\";s:11:\"PHP_INI_DIR\";s:18:\"/usr/local/etc/php\";s:21:\"COMPOSER_MEMORY_LIMIT\";s:2:\"-1\";s:17:\"WEB_DOCUMENT_ROOT\";s:14:\"/var/www/html/\";s:4:\"HOME\";s:8:\"/var/www\";s:11:\"PHP_LDFLAGS\";s:12:\"-Wl,-O1 -pie\";s:10:\"PHP_CFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:11:\"PHP_VERSION\";s:5:\"8.2.5\";s:13:\"COMPOSER_HOME\";s:10:\"/.composer\";s:8:\"GPG_KEYS\";s:122:\"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC\";s:12:\"PHP_CPPFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:11:\"PHP_ASC_URL\";s:54:\"https://www.php.net/distributions/php-8.2.5.tar.xz.asc\";s:24:\"COMPOSER_ALLOW_SUPERUSER\";s:1:\"1\";s:7:\"PHP_URL\";s:50:\"https://www.php.net/distributions/php-8.2.5.tar.xz\";s:4:\"PATH\";s:60:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\";s:11:\"PHPIZE_DEPS\";s:76:\"autoconf 		dpkg-dev 		file 		g++ 		gcc 		libc-dev 		make 		pkg-config 		re2c\";s:3:\"PWD\";s:13:\"/var/www/html\";s:10:\"PHP_SHA256\";s:64:\"800738c359b7f1e67e40c22713d2d90276bc85ba1c21b43d99edd43c254c5f76\";s:4:\"USER\";s:8:\"www-data\";s:9:\"HTTP_HOST\";s:17:\"45.132.247.172:85\";s:20:\"HTTP_ACCEPT_ENCODING\";s:23:\"gzip, br, zstd, deflate\";s:15:\"HTTP_USER_AGENT\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:11:\"HTTP_ACCEPT\";s:3:\"*/*\";s:15:\"SCRIPT_FILENAME\";s:30:\"/var/www/html/public/index.php\";s:9:\"PATH_INFO\";s:0:\"\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:11:\"SERVER_NAME\";s:0:\"\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"SERVER_ADDR\";s:10:\"172.24.0.7\";s:11:\"REMOTE_PORT\";s:5:\"14660\";s:11:\"REMOTE_ADDR\";s:12:\"3.145.92.213\";s:15:\"SERVER_SOFTWARE\";s:12:\"nginx/1.24.0\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:14:\"REQUEST_SCHEME\";s:4:\"http\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:13:\"DOCUMENT_ROOT\";s:20:\"/var/www/html/public\";s:12:\"DOCUMENT_URI\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:20:\"/de/Schutzzaeune-alt\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:14:\"CONTENT_LENGTH\";s:0:\"\";s:12:\"CONTENT_TYPE\";s:0:\"\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:12:\"QUERY_STRING\";s:0:\"\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:18:\"REQUEST_TIME_FLOAT\";d:1735042254.261523;s:12:\"REQUEST_TIME\";i:1735042254;s:4:\"argv\";a:0:{}s:4:\"argc\";i:0;s:7:\"APP_ENV\";s:3:\"dev\";s:9:\"APP_DEBUG\";s:1:\"0\";s:16:\"PIMCORE_DEV_MODE\";s:5:\"false\";s:10:\"APP_SECRET\";s:32:\"SLZYfFJ3GeFS9ZQEKVJn3UKPc8ouYMAm\";s:15:\"PROJECT_DB_USER\";s:7:\"pimcore\";s:15:\"PROJECT_DB_PASS\";s:7:\"pimcore\";s:10:\"PROJECT_DB\";s:7:\"pimcore\";s:7:\"DB_HOST\";s:2:\"db\";s:25:\"PROJECT_DB_SERVER_VERSION\";s:6:\"8.0.30\";s:10:\"MAILER_DSN\";s:98:\"smtp://rohdesendenhomepage%40itservice-kassel.de:DsAlafXyMwiogCz0CrA6@mail.itservice-kassel.de:465\";s:14:\"ELASTIC_HOST_1\";s:25:\"http://elasticsearch:9200\";s:23:\"ELASTIC_LOGGING_ENABLED\";s:4:\"true\";s:19:\"SYMFONY_DOTENV_VARS\";s:172:\"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,APP_SECRET,PROJECT_DB_USER,PROJECT_DB_PASS,PROJECT_DB,DB_HOST,PROJECT_DB_SERVER_VERSION,MAILER_DSN,ELASTIC_HOST_1,ELASTIC_LOGGING_ENABLED\";s:21:\"DOCTRINE_DEPRECATIONS\";s:7:\"trigger\";}', 1735042254, 1);

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/Schutzzaeune-alt' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Schutzzaeune-alt' AND `type` = 'path_query') OR
                (source = 'http://45.132.247.172:85/de/Schutzzaeune-alt' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/Schutzzaeune-alt' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Schutzzaeune-alt' AND `type` = 'path_query') OR
                (source = 'http://45.132.247.172:85/de/Schutzzaeune-alt' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/de/' AND `key` = BINARY 'Schutzzaeune-alt';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Schutzzaeune-alt'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Schutzzaeune-alt' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  date
FROM
  http_error_log
WHERE
  uri = ?

SELECT date FROM http_error_log WHERE uri = 'http://45.132.247.172:85/de/Schutzzaeune-alt';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1899
tags
', 'asset_9177
tags
', 'asset_9178
tags
', 'asset_9179
tags
', 'asset_9176
tags
');

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(`path`)
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';