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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.00 ms
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 0.99 ms
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"
]
3 1.05 ms
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"
]
4 0.97 ms
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"
]
5 0.95 ms
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"
]
6 0.58 ms
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"
]
7 0.72 ms
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_on_user_id"
]
8 0.56 ms
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_on_user_id"
]
9 0.64 ms
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"
  }
  "lastURLLogged"
]
10 0.62 ms
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"
  }
  "lastURLLogged"
]
11 0.58 ms
"START TRANSACTION"
Parameters:
[]
12 10.07 ms
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
]
13 1.96 ms
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"
  }
]
14 0.69 ms
"COMMIT"
Parameters:
[]
15 0.68 ms
"START TRANSACTION"
Parameters:
[]
16 1.46 ms
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"
  }
]
17 0.70 ms
"COMMIT"
Parameters:
[]
18 1.18 ms
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:
[
  "not_found_org"
]
19 0.82 ms
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"
]
20 1.24 ms
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"
]
21 0.65 ms
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:
[
  "session_length"
]
22 0.78 ms
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"
]
23 0.69 ms
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"
]
24 0.71 ms
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"
]
25 0.58 ms
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"
]

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.