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

Query Metrics

22 Database Queries
9 Different statements
16.15 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.95 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.64 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
]
3 0.67 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:
[
  "6881ca38-9099-45f8-9e0e-cab006d0aff6"
]
4 1.12 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-05-09 03:18:11"
  "default-cookie-name"
  "1781061488"
  "216.73.217.35"
]
5 0.67 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "logged_out"
]
6 0.51 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "logged_out"
]
7 0.82 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "logged_on_user_id"
]
8 0.49 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "logged_on_user_id"
]
9 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "lastURLLogged"
]
10 0.48 ms
"START TRANSACTION"
Parameters:
[]
11 0.68 ms
UPDATE session_values SET value = ? WHERE id = ?
Parameters:
[
  "/login"
  "4a22c176-a210-4b54-87d8-c87f88a47c16"
]
12 0.51 ms
"COMMIT"
Parameters:
[]
13 0.69 ms
"START TRANSACTION"
Parameters:
[]
14 1.95 ms
INSERT INTO session_urls (id, url, created_at, session_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "1c042d70-9b65-4834-b982-ae9a69417310"
  "/login"
  "2026-06-10 03:18:11"
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
]
15 0.72 ms
"COMMIT"
Parameters:
[]
16 0.89 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:
[
  "login_template"
]
17 0.67 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"
]
18 0.53 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-05-09 03:18:11"
  "default-cookie-name"
  "1781061488"
  "216.73.217.35"
]
19 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "logged_out"
]
20 0.61 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"
]
21 0.50 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-05-09 03:18:11"
  "default-cookie-name"
  "1781061488"
  "216.73.217.35"
]
22 0.48 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:
[
  "0cc2f35c-4132-4ba1-a817-c0ca5b72784d"
  "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.