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 > 1719431558 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_c1114a657c638166de0c8066ae0059b4');

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://www.rainbowmilk.com/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog', 500, 'a:1:{s:6:\"fbclid\";s:104:\"PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog\";}', 'a:0:{}', 'a:0:{}', 'a:87:{s:15:\"KUBERNETES_PORT\";s:20:\"tcp://10.233.0.1:443\";s:23:\"KUBERNETES_SERVICE_PORT\";s:3:\"443\";s:8:\"HOSTNAME\";s:47:\"rainbowmilk-com-prd-deployment-558d55957c-mdcjq\";s:14:\"MYSQL_TCP_PORT\";s:4:\"3306\";s:5:\"SHLVL\";s:1:\"1\";s:35:\"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP\";s:21:\"tcp://10.233.41.31:80\";s:4:\"HOME\";s:14:\"/home/www-data\";s:11:\"ENVIRONMENT\";s:3:\"prd\";s:3:\"CWD\";s:16:\"/var/www/pimcore\";s:6:\"DOMAIN\";s:19:\"www.rainbowmilk.com\";s:17:\"PHP_MAJOR_VERSION\";s:5:\"php81\";s:9:\"MYSQL_PWD\";s:25:\"38723962257c87c4aeabec602\";s:28:\"KUBERNETES_PORT_443_TCP_ADDR\";s:10:\"10.233.0.1\";s:14:\"CONTAINER_TYPE\";s:3:\"APP\";s:36:\"RAINBOWMILK_COM_PRD_SVC_SERVICE_HOST\";s:12:\"10.233.41.31\";s:4:\"PATH\";s:60:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\";s:8:\"WWW_PATH\";s:16:\"/var/www/pimcore\";s:28:\"KUBERNETES_PORT_443_TCP_PORT\";s:3:\"443\";s:18:\"S6_OVERLAY_RELEASE\";s:96:\"https://github.com/just-containers/s6-overlay/releases/download/v2.2.0.3/s6-overlay-amd64.tar.gz\";s:29:\"KUBERNETES_PORT_443_TCP_PROTO\";s:3:\"tcp\";s:10:\"MYSQL_HOST\";s:44:\"sch-mysql-prd-lb-02.rfc.fc-platform.internal\";s:10:\"MYSQL_USER\";s:15:\"ad3258bbf813217\";s:28:\"RAINBOWMILK_COM_PRD_SVC_PORT\";s:21:\"tcp://10.233.41.31:80\";s:36:\"RAINBOWMILK_COM_PRD_SVC_SERVICE_PORT\";s:2:\"80\";s:23:\"KUBERNETES_PORT_443_TCP\";s:20:\"tcp://10.233.0.1:443\";s:29:\"KUBERNETES_SERVICE_PORT_HTTPS\";s:3:\"443\";s:40:\"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP_ADDR\";s:12:\"10.233.41.31\";s:23:\"KUBERNETES_SERVICE_HOST\";s:10:\"10.233.0.1\";s:3:\"PWD\";s:24:\"/run/s6/services/php-fpm\";s:17:\"NEW_RELIC_ENABLED\";s:4:\"True\";s:21:\"NEW_RELIC_LICENSE_KEY\";s:40:\"eu01xx072476a8b4eb62fd03fdbae2faFFFFNRAL\";s:18:\"NEW_RELIC_APP_NAME\";s:19:\"prd-rainbowmilk-com\";s:14:\"MYSQL_DATABASE\";s:27:\"pimcore-prd-rainbowmilk-com\";s:40:\"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP_PORT\";s:2:\"80\";s:48:\"RAINBOWMILK_COM_PRD_SVC_SERVICE_PORT_PORT_80_TCP\";s:2:\"80\";s:41:\"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP_PROTO\";s:3:\"tcp\";s:4:\"USER\";s:8:\"www-data\";s:18:\"HTTP_CACHE_CONTROL\";s:9:\"max-age=0\";s:8:\"HTTP_VIA\";s:79:\"1.1 v1-akamaitech.net(ghost) (AkamaiGHost), 1.1 akamai.net(ghost) (AkamaiGHost)\";s:22:\"HTTP_AKAMAI_ORIGIN_HOP\";s:1:\"2\";s:20:\"HTTP_ACCEPT_ENCODING\";s:4:\"gzip\";s:31:\"HTTP_X_AKAMAI_CONFIG_LOG_DETAIL\";s:4:\"true\";s:19:\"HTTP_TRUE_CLIENT_IP\";s:11:\"5.193.92.89\";s:23:\"HTTP_X_AKAMAI_EDGESCAPE\";s:156:\"georegion=227,country_code=AE,city=DUBAI,lat=25.25,long=55.28,timezone=GMT+4,continent=AS,throughput=vhigh,bw=5000,network=etisalat,asnum=5384,location_id=0\";s:12:\"HTTP_REFERER\";s:24:\"https://l.instagram.com/\";s:15:\"HTTP_USER_AGENT\";s:204:\"Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/21F90 Instagram 336.1.8.30.85 (iPhone15,3; iOS 17_5_1; en_IN; en; scale=3.00; 1290x2796; 612888060)\";s:19:\"HTTP_SEC_FETCH_MODE\";s:8:\"navigate\";s:20:\"HTTP_ACCEPT_LANGUAGE\";s:26:\"en-IN,en-GB;q=0.9,en;q=0.8\";s:19:\"HTTP_SEC_FETCH_DEST\";s:8:\"document\";s:19:\"HTTP_SEC_FETCH_SITE\";s:10:\"cross-site\";s:11:\"HTTP_ACCEPT\";s:63:\"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\";s:20:\"HTTP_X_AMZN_TRACE_ID\";s:40:\"Root=1-667c7186-4f9f1beb751341a66c0ac5c2\";s:29:\"HTTP_X_ORIGINAL_FORWARDED_FOR\";s:39:\"5.193.92.89, 2.20.249.149, 2.16.110.140\";s:13:\"HTTP_X_SCHEME\";s:4:\"http\";s:23:\"HTTP_X_FORWARDED_SCHEME\";s:4:\"http\";s:22:\"HTTP_X_FORWARDED_PROTO\";s:4:\"http\";s:21:\"HTTP_X_FORWARDED_PORT\";s:2:\"80\";s:21:\"HTTP_X_FORWARDED_HOST\";s:19:\"www.rainbowmilk.com\";s:20:\"HTTP_X_FORWARDED_FOR\";s:11:\"5.193.92.89\";s:14:\"HTTP_X_REAL_IP\";s:11:\"5.193.92.89\";s:17:\"HTTP_X_REQUEST_ID\";s:32:\"e1a18ee9f3b894a2d3c6a5e6b73d60a7\";s:9:\"HTTP_HOST\";s:19:\"www.rainbowmilk.com\";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:14:\"10.233.103.234\";s:11:\"REMOTE_PORT\";s:5:\"40772\";s:11:\"REMOTE_ADDR\";s:13:\"10.233.64.178\";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:23:\"/var/www/pimcore/public\";s:12:\"DOCUMENT_URI\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:113:\"/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog\";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:111:\"fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog\";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:1719431558.493528;s:12:\"REQUEST_TIME\";i:1719431558;s:21:\"DOCTRINE_DEPRECATIONS\";s:7:\"trigger\";}', 1719431559, 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
  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 > 1719431558 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
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
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog' AND `type` = 'path_query') OR
                (source = 'http://www.rainbowmilk.com/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog' 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
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';

SELECT
  date
FROM
  http_error_log
WHERE
  uri = ?

SELECT date FROM http_error_log WHERE uri = 'http://www.rainbowmilk.com/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog';

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
  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 > 1719431558 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

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

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

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';