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

Query Metrics

21 Database Queries
9 Different statements
60.38 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.58 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 2.19 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
]
3 22.30 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"
]
4 1.45 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 12:12:33"
  "default-cookie-name"
  "1776427944"
  "216.73.216.51"
]
5 0.80 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "logged_out"
]
6 2.08 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "logged_out"
]
7 1.99 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "logged_on_user_id"
]
8 0.84 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "logged_on_user_id"
]
9 1.40 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "lastURLLogged"
]
10 0.86 ms
"START TRANSACTION"
Parameters:
[]
11 1.11 ms
UPDATE session_values SET value = ? WHERE id = ?
Parameters:
[
  "/"
  "26a29d45-aa8f-4629-b348-3da4c129ce2a"
]
12 1.03 ms
"COMMIT"
Parameters:
[]
13 1.75 ms
"START TRANSACTION"
Parameters:
[]
14 2.93 ms
INSERT INTO session_urls (id, url, created_at, session_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "9eec2817-8577-4566-86fd-c34a4d02df94"
  "/"
  "2026-04-17 12:12:33"
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
]
15 3.93 ms
"COMMIT"
Parameters:
[]
16 0.80 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"
]
17 1.04 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 12:12:33"
  "default-cookie-name"
  "1776427944"
  "216.73.216.51"
]
18 0.91 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "logged_out"
]
19 2.86 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 5.84 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 12:12:33"
  "default-cookie-name"
  "1776427944"
  "216.73.216.51"
]
21 2.68 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:
[
  "7acdf0b7-246e-49ee-82f1-ad82f8002806"
  "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\SessionsBundle\Entity\SessionUrls No errors.
App\SessionsBundle\Entity\SessionValues No errors.
App\SessionsBundle\Entity\SessionTextValues No errors.
App\UserBundle\Entity\UserList No errors.