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 > 1782479325 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_466021a78a73b1fdb4a23943e92882f9_phone', 'output_466021a78a73b1fdb4a23943e92882f9_phone');

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://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:121:{s:8:\"smtppass\";s:44:\"QPzH1zWgdVpjzlt3fIrDqs8GNc0stn+KinWq2seYNf5O\";s:15:\"KUBERNETES_PORT\";s:20:\"tcp://172.20.0.1:443\";s:23:\"KUBERNETES_SERVICE_PORT\";s:3:\"443\";s:33:\"PIMCORE_INSTALL_MYSQL_HOST_SOCKET\";s:58:\"cms-prod-restored.cjveix7s4jyo.eu-west-1.rds.amazonaws.com\";s:4:\"test\";s:5:\"test1\";s:9:\"APP_DEBUG\";s:1:\"0\";s:28:\"CORPORATE_NGINX_SERVICE_HOST\";s:13:\"172.20.52.149\";s:8:\"HOSTNAME\";s:34:\"corporate-pimcore-64bb77899d-lfbcr\";s:11:\"PHP_INI_DIR\";s:18:\"/usr/local/etc/php\";s:21:\"COMPOSER_MEMORY_LIMIT\";s:2:\"-1\";s:7:\"DB_PORT\";s:4:\"3306\";s:4:\"host\";s:58:\"cms-prod-restored.cjveix7s4jyo.eu-west-1.rds.amazonaws.com\";s:18:\"ERECRUITER_XML_URL\";s:194:\"https://offers.erecruiter.pl/skk/company/20133278/offers.xml?hash=ADB0264E2BCC43B70FF5208473AB3E01888E8DF21D301AF2ED73AF7DF8AA7955456D9B496211E46DFB25DE6F996EC40769FAC4A1DF31C74D3C94DF97C48BFC30\";s:5:\"SHLVL\";s:1:\"1\";s:8:\"username\";s:7:\"pimcore\";s:4:\"HOME\";s:14:\"/home/www-data\";s:7:\"DB_NAME\";s:7:\"pimcore\";s:8:\"smtphost\";s:18:\"smtp.office365.com\";s:24:\"GOOGLE_GEOCODING_API_KEY\";s:39:\"AIzaSyDtkhPiFQHxJNDOuMCS-Uvf-WYw_G9omMw\";s:8:\"smtpuser\";s:28:\"stronakorporacyjna@gemini.pl\";s:10:\"MAILER_DSN\";s:85:\"smtp://stronakorporacyjna%40gemini.pl:Cq%2F7WLK%28A6%21s%3FXg6@smtp.office365.com:587\";s:11:\"PHP_LDFLAGS\";s:12:\"-Wl,-O1 -pie\";s:11:\"DB_DATABASE\";s:7:\"pimcore\";s:28:\"CORPORATE_NGINX_SERVICE_PORT\";s:2:\"80\";s:20:\"CORPORATE_NGINX_PORT\";s:22:\"tcp://172.20.52.149:80\";s:10:\"PHP_CFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:17:\"PARAMETERS_SECRET\";s:32:\"1MvBBuu48%p3Ji$78lhuWa1cHt&Q5^LM\";s:11:\"PHP_VERSION\";s:6:\"8.1.28\";s:8:\"GPG_KEYS\";s:122:\"528995BFEDFBA7191D46839EF9BA0ADA31CBD89E 39B641343D8C104B2B146DC3F9C39DC0B9698544 F1F692238FBC1666E5A5CCD4199F9DFEF6FFBAFD\";s:17:\"RECAPTCHA_ENABLED\";s:4:\"true\";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:55:\"https://www.php.net/distributions/php-8.1.28.tar.xz.asc\";s:24:\"COMPOSER_ALLOW_SUPERUSER\";s:1:\"1\";s:9:\"adminpass\";s:12:\"Mm5hc2QzbmRh\";s:32:\"CORPORATE_NGINX_PORT_80_TCP_ADDR\";s:13:\"172.20.52.149\";s:38:\"CORPORATE_PIMCORE_SERVICE_PORT_FASTCGI\";s:4:\"9000\";s:7:\"PHP_URL\";s:51:\"https://www.php.net/distributions/php-8.1.28.tar.xz\";s:25:\"GOOGLE_RECAPTCHA_SITE_KEY\";s:40:\"6LfcjVAsAAAAAGeHwMwDzwpoSdBobgwcqyzGZu7a\";s:16:\"PIMCORE_DEV_MODE\";s:5:\"false\";s:36:\"CORPORATE_PIMCORE_PORT_9000_TCP_ADDR\";s:13:\"172.20.152.28\";s:32:\"CORPORATE_NGINX_PORT_80_TCP_PORT\";s:2:\"80\";s:28:\"KUBERNETES_PORT_443_TCP_ADDR\";s:10:\"172.20.0.1\";s:33:\"CORPORATE_NGINX_PORT_80_TCP_PROTO\";s:3:\"tcp\";s:4:\"PATH\";s:87:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/root/.composer/vendor/bin\";s:10:\"MAX_UPLOAD\";s:3:\"50M\";s:36:\"CORPORATE_PIMCORE_PORT_9000_TCP_PORT\";s:4:\"9000\";s:4:\"port\";s:4:\"3306\";s:28:\"KUBERNETES_PORT_443_TCP_PORT\";s:3:\"443\";s:37:\"CORPORATE_PIMCORE_PORT_9000_TCP_PROTO\";s:3:\"tcp\";s:16:\"PHP_MEMORY_LIMIT\";s:4:\"256M\";s:8:\"password\";s:12:\"aDIzc2FzZGFz\";s:6:\"engine\";s:5:\"mysql\";s:29:\"KUBERNETES_PORT_443_TCP_PROTO\";s:3:\"tcp\";s:19:\"PIMCORE_ENVIRONMENT\";s:4:\"prod\";s:30:\"CORPORATE_PIMCORE_SERVICE_HOST\";s:13:\"172.20.152.28\";s:7:\"API_KEY\";s:30:\"KLcrkN^Fb2HZDXZq%Q4yxmndJBPPu2\";s:30:\"PIMCORE_INSTALL_ADMIN_PASSWORD\";s:12:\"Mm5hc2QzbmRh\";s:27:\"CORPORATE_NGINX_PORT_80_TCP\";s:22:\"tcp://172.20.52.149:80\";s:23:\"GOOGLE_RECAPTCHA_SECRET\";s:40:\"6LfcjVAsAAAAAOwlqjNy340thc8BXLXCeIgKwa6y\";s:9:\"SMTP_PASS\";s:16:\"Cq/7WLK(A6!s?Xg6\";s:31:\"CORPORATE_PIMCORE_PORT_9000_TCP\";s:24:\"tcp://172.20.152.28:9000\";s:10:\"SENTRY_DSN\";s:85:\"https://e68b4c6349be5f297051adcfd59ea85c@o338873.ingest.us.sentry.io/4510107331264512\";s:18:\"SENTRY_ENVIRONMENT\";s:4:\"prod\";s:6:\"dbname\";s:7:\"pimcore\";s:29:\"KUBERNETES_SERVICE_PORT_HTTPS\";s:3:\"443\";s:23:\"KUBERNETES_PORT_443_TCP\";s:20:\"tcp://172.20.0.1:443\";s:30:\"CORPORATE_PIMCORE_SERVICE_PORT\";s:4:\"9000\";s:22:\"CORPORATE_PIMCORE_PORT\";s:24:\"tcp://172.20.152.28:9000\";s:11:\"PHPIZE_DEPS\";s:78:\"autoconf 		dpkg-dev dpkg 		file 		g++ 		gcc 		libc-dev 		make 		pkgconf 		re2c\";s:11:\"DB_PASSWORD\";s:12:\"aDIzc2FzZGFz\";s:23:\"KUBERNETES_SERVICE_HOST\";s:10:\"172.20.0.1\";s:3:\"PWD\";s:16:\"/var/www/pimcore\";s:10:\"PHP_SHA256\";s:64:\"95d0b2e9466108fd750dab5c30a09e5c67f5ad2cb3b1ffb3625a038a755ad080\";s:12:\"PHP_MAX_POST\";s:3:\"60M\";s:33:\"CORPORATE_NGINX_SERVICE_PORT_HTTP\";s:2:\"80\";s:7:\"DB_HOST\";s:58:\"cms-prod-restored.cjveix7s4jyo.eu-west-1.rds.amazonaws.com\";s:9:\"SMTP_HOST\";s:18:\"smtp.office365.com\";s:7:\"DB_USER\";s:7:\"pimcore\";s:19:\"PHP_MAX_FILE_UPLOAD\";s:3:\"200\";s:9:\"SMTP_USER\";s:28:\"stronakorporacyjna@gemini.pl\";s:4:\"USER\";s:8:\"www-data\";s:12:\"HTTP_REFERER\";s:105:\"https://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820\";s:20:\"HTTP_ACCEPT_LANGUAGE\";s:11:\"pl,en;q=0.8\";s:20:\"HTTP_ACCEPT_ENCODING\";s:23:\"gzip, deflate, br, zstd\";s:11:\"HTTP_ACCEPT\";s:85:\"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8\";s:15:\"HTTP_USER_AGENT\";s:164:\"Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (HTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)\";s:20:\"HTTP_X_AMZN_TRACE_ID\";s:40:\"Root=1-6a3e79dd-09de0257232b444d65f2f4c5\";s:21:\"HTTP_X_FORWARDED_PORT\";s:3:\"443\";s:22:\"HTTP_X_FORWARDED_PROTO\";s:5:\"https\";s:20:\"HTTP_X_FORWARDED_FOR\";s:15:\"114.119.145.212\";s:9:\"HTTP_HOST\";s:19:\"geminipolska.com.pl\";s:9:\"PATH_INFO\";s:0:\"\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:11:\"SERVER_NAME\";s:1:\"_\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"SERVER_ADDR\";s:12:\"10.146.9.127\";s:11:\"REMOTE_PORT\";s:0:\"\";s:11:\"REMOTE_ADDR\";s:15:\"114.119.145.212\";s:15:\"SERVER_SOFTWARE\";s:12:\"nginx/1.30.3\";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:23:\"/var/www/pimcore/public\";s:12:\"DOCUMENT_URI\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:78:\"/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820\";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:15:\"SCRIPT_FILENAME\";s:33:\"/var/www/pimcore/public/index.php\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:18:\"REQUEST_TIME_FLOAT\";d:1782479325.477962;s:12:\"REQUEST_TIME\";i:1782479325;s:7:\"APP_ENV\";s:3:\"dev\";s:10:\"APP_SECRET\";s:40:\"PUT_RANDOM_STRING_HERE_32CHARACTERS_LONG\";s:16:\"DB_ROOT_PASSWORD\";s:4:\"ROOT\";s:9:\"DB_ENGINE\";s:5:\"mysql\";s:16:\"RECAPTCHA_SECRET\";s:0:\"\";s:19:\"SYMFONY_DOTENV_VARS\";s:62:\"APP_ENV,APP_SECRET,DB_ROOT_PASSWORD,DB_ENGINE,RECAPTCHA_SECRET\";}', 1782479325, 1);

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

SELECT id FROM documents WHERE path = BINARY '/iera/' AND `key` = BINARY 'Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820';

SELECT
  *
FROM
  object_store_1
WHERE
  oo_id = ?

SELECT * FROM object_store_1 WHERE oo_id = 7820;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820';

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
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820' AND `type` = 'path_query') OR
                (source = 'http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC;

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820' AND `type` = 'path_query') OR
                (source = 'http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  objects.*,
  tree_locks.locked as o_locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.o_id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  o_id = ?

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = 7820;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

SELECT
  date
FROM
  http_error_log
WHERE
  uri = ?

SELECT date FROM http_error_log WHERE uri = 'http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820';

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 7820;

SELECT
  o_type,
  o_className,
  o_classId
FROM
  objects
WHERE
  o_id = ?

SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 7820;

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

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';