Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics_page_access a0_ WHERE a0_.ip = ? AND a0_.is_bot = 1

[
  "10.1.170.64"
]

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  analytics_page_access a0_
WHERE
  a0_.ip = ?
  AND a0_.is_bot = 1

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics_page_access a0_ WHERE a0_.ip = '10.1.170.64' AND a0_.is_bot = 1;

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.page_url AS page_url_4, t0.accessed_at AS accessed_at_5, t0.session_id AS session_id_6, t0.visit_count AS visit_count_7, t0.referer AS referer_8, t0.country AS country_9, t0.city AS city_10, t0.is_bot AS is_bot_11, t0.bot_type AS bot_type_12 FROM analytics_page_access t0 WHERE t0.ip = ? AND t0.page_url = ? LIMIT 1

[
  "10.1.170.64"
  "/landing"
]

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.user_agent AS user_agent_3,
  t0.page_url AS page_url_4,
  t0.accessed_at AS accessed_at_5,
  t0.session_id AS session_id_6,
  t0.visit_count AS visit_count_7,
  t0.referer AS referer_8,
  t0.country AS country_9,
  t0.city AS city_10,
  t0.is_bot AS is_bot_11,
  t0.bot_type AS bot_type_12
FROM
  analytics_page_access t0
WHERE
  t0.ip = ?
  AND t0.page_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.page_url AS page_url_4, t0.accessed_at AS accessed_at_5, t0.session_id AS session_id_6, t0.visit_count AS visit_count_7, t0.referer AS referer_8, t0.country AS country_9, t0.city AS city_10, t0.is_bot AS is_bot_11, t0.bot_type AS bot_type_12 FROM analytics_page_access t0 WHERE t0.ip = '10.1.170.64' AND t0.page_url = '/landing' LIMIT 1;

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics_page_access a0_ WHERE a0_.ip = ? AND a0_.is_bot = 1

[
  "10.1.170.64"
]

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  analytics_page_access a0_
WHERE
  a0_.ip = ?
  AND a0_.is_bot = 1

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics_page_access a0_ WHERE a0_.ip = '10.1.170.64' AND a0_.is_bot = 1;

UPDATE analytics_page_access SET is_bot = ?, bot_type = ? WHERE ip = ?

[
  1
  "Generic Bot"
  "10.1.170.64"
]

UPDATE
  analytics_page_access
SET
  is_bot = ?,
  bot_type = ?
WHERE
  ip = ?

UPDATE analytics_page_access SET is_bot = 1, bot_type = 'Generic Bot' WHERE ip = '10.1.170.64';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO analytics_page_access (ip, user_agent, page_url, accessed_at, session_id, visit_count, referer, country, city, is_bot, bot_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "10.1.170.64"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "/landing"
  "2026-05-31 03:10:35"
  ""
  1
  null
  null
  null
  1
  "Generic Bot"
]

INSERT INTO analytics_page_access (
  ip, user_agent, page_url, accessed_at,
  session_id, visit_count, referer,
  country, city, is_bot, bot_type
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO analytics_page_access (ip, user_agent, page_url, accessed_at, session_id, visit_count, referer, country, city, is_bot, bot_type) VALUES ('10.1.170.64', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/landing', '2026-05-31 03:10:35', '', 1, NULL, NULL, NULL, 1, 'Generic Bot');

"COMMIT"

[]

"COMMIT"

"COMMIT";