GET https://ssc3.devstage.co.za/404.html

Query Metrics

25 Database Queries
10 Different statements
30.88 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.07 ms
(32.62%)
1
INSERT INTO sessions (id, symfony_cookie, cookie_name, remote_ip, remote_domain, browser_string, created_by, created_at, updated_at, site_id, previous_session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "5beec6e3-d74d-414b-9406-250986313b0e"
  "ulmah81hq6e4a887ipd4p81kbf"
  "default-cookie-name"
  "216.73.216.51"
  "Unknown"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  null
  "2026-04-17 18:56:58"
  "2026-04-17 18:56:58"
  "8ecc5b2c-246e-44e5-9b6e-b42494f96e0a"
  null
]
5.44 ms
(17.61%)
8
SELECT t0.id AS id_1, t0.value_name AS value_name_2, t0.value AS value_3, t0.session_id AS session_id_4 FROM session_values t0 WHERE t0.session_id = ? AND t0.value_name = ? LIMIT 1
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#733
    __toString(): "5beec6e3-d74d-414b-9406-250986313b0e"
  }
  "logged_out"
]
4.34 ms
(14.05%)
5
SELECT t0.id AS id_1, t0.setting_name AS setting_name_2, t0.setting_system_name AS setting_system_name_3, t0.setting_value AS setting_value_4, t0.is_visible AS is_visible_5, t0.system_setting_group_id AS system_setting_group_id_6 FROM system_setting t0 WHERE t0.setting_system_name = ? LIMIT 1
Parameters:
[
  "cookie_name"
]
2.99 ms
(9.70%)
3
SELECT s0_.id AS id_0, s0_.symfony_cookie AS symfony_cookie_1, s0_.cookie_name AS cookie_name_2, s0_.remote_ip AS remote_ip_3, s0_.remote_domain AS remote_domain_4, s0_.browser_string AS browser_string_5, s0_.created_by AS created_by_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.site_id AS site_id_9, s0_.previous_session_id AS previous_session_id_10 FROM sessions s0_ WHERE s0_.updated_at >= ? AND s0_.cookie_name = ? AND s0_.symfony_cookie = ? AND s0_.remote_ip = ? LIMIT 1
Parameters:
[
  "2026-03-16 18:56:58"
  "default-cookie-name"
  "ulmah81hq6e4a887ipd4p81kbf"
  "216.73.216.51"
]
1.96 ms
(6.35%)
1
INSERT INTO session_values (id, value_name, value, session_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "42da394b-6f23-4643-948e-579c24f0f201"
  "lastURLLogged"
  "/404.html"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#733
    __toString(): "5beec6e3-d74d-414b-9406-250986313b0e"
  }
]
1.46 ms
(4.74%)
1
INSERT INTO session_urls (id, url, created_at, session_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "472d67ed-7f91-4eb9-bfa6-d4dd9ce07baa"
  "/404.html"
  "2026-04-17 18:56:58"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#733
    __toString(): "5beec6e3-d74d-414b-9406-250986313b0e"
  }
]
1.39 ms
(4.51%)
2
"COMMIT"
Parameters:
[]
1.26 ms
(4.09%)
2
"START TRANSACTION"
Parameters:
[]
0.99 ms
(3.19%)
1
SELECT t0.id AS id_1, t0.symfony_cookie AS symfony_cookie_2, t0.cookie_name AS cookie_name_3, t0.remote_ip AS remote_ip_4, t0.remote_domain AS remote_domain_5, t0.browser_string AS browser_string_6, t0.created_by AS created_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.site_id AS site_id_10, t0.previous_session_id AS previous_session_id_11 FROM sessions t0 WHERE t0.id = ?
Parameters:
[
  "6416caac-b54e-4e74-a600-bb336317e2d9"
]
0.97 ms
(3.14%)
1
SELECT t0.id AS id_1, t0.site_host_name AS site_host_name_2, t0.site_name AS site_name_3, t0.site_e_mail AS site_e_mail_4, t0.server_ip AS server_ip_5, t0.site_port AS site_port_6, t0.template_id AS template_id_7, t0.session_count AS session_count_8, t0.build_site_map AS build_site_map_9, t0.created_by AS created_by_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sites t0 WHERE t0.id = ?
Parameters:
[
  "8ecc5b2c-246e-44e5-9b6e-b42494f96e0a"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\CoreBundle\Entity\SystemSetting No errors.
App\CoreBundle\Entity\SystemSettingGroup No errors.
App\SessionsBundle\Entity\Sessions No errors.
App\SessionsBundle\Entity\Sites
  • The association App\SessionsBundle\Entity\Sites#user_list refers to the owning side field App\UserBundle\Entity\UserList#site which does not exist.
App\UserBundle\Entity\UserList No errors.
App\SessionsBundle\Entity\SessionValues No errors.
App\SessionsBundle\Entity\SessionUrls No errors.
App\SessionsBundle\Entity\SessionTextValues No errors.