Symfony Profiler

Query Metrics

31 Database Queries

9 Different statements

67.28 ms Query time

1 Invalid entities

Queries


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
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
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
"START TRANSACTION"
INSERT INTO error_log (id, url_id, errmessage, session_id, is_info, created_by, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.algorithm AS algorithm_2, u0_.salt AS salt_3, u0_.password AS password_4, u0_.last_login AS last_login_5, u0_.is_active AS is_active_6, u0_.is_super_admin AS is_super_admin_7, u0_.first_name_string AS first_name_string_8, u0_.last_name_string AS last_name_string_9, u0_.e_mail_address_string AS e_mail_address_string_10, u0_.e_mail_address_subscribed AS e_mail_address_subscribed_11, u0_.mobile_number AS mobile_number_12, u0_.company_name AS company_name_13, u0_.company_vat AS company_vat_14, u0_.deleted AS deleted_15, u0_.date_of_birth AS date_of_birth_16, u0_.id_number AS id_number_17, u0_.passport_number AS passport_number_18, u0_.debit_order_day AS debit_order_day_19, u0_.referred_by AS referred_by_20, u0_.short_code AS short_code_21, u0_.id_doc_file_id AS id_doc_file_id_22, u0_.services AS services_23, u0_.created_by AS created_by_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26 FROM user_list u0_ WHERE u0_.e_mail_address_string = ? GROUP BY u0_.id LIMIT 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.site_host_name = ? AND t0.server_ip = ? AND t0.site_port = ? ORDER BY t0.created_at ASC LIMIT 1
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
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
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
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
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
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
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.algorithm AS algorithm_2, u0_.salt AS salt_3, u0_.password AS password_4, u0_.last_login AS last_login_5, u0_.is_active AS is_active_6, u0_.is_super_admin AS is_super_admin_7, u0_.first_name_string AS first_name_string_8, u0_.last_name_string AS last_name_string_9, u0_.e_mail_address_string AS e_mail_address_string_10, u0_.e_mail_address_subscribed AS e_mail_address_subscribed_11, u0_.mobile_number AS mobile_number_12, u0_.company_name AS company_name_13, u0_.company_vat AS company_vat_14, u0_.deleted AS deleted_15, u0_.date_of_birth AS date_of_birth_16, u0_.id_number AS id_number_17, u0_.passport_number AS passport_number_18, u0_.debit_order_day AS debit_order_day_19, u0_.referred_by AS referred_by_20, u0_.short_code AS short_code_21, u0_.id_doc_file_id AS id_doc_file_id_22, u0_.services AS services_23, u0_.created_by AS created_by_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26 FROM user_list u0_ WHERE u0_.e_mail_address_string = ? GROUP BY u0_.id LIMIT 1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.algorithm AS algorithm_2, u0_.salt AS salt_3, u0_.password AS password_4, u0_.last_login AS last_login_5, u0_.is_active AS is_active_6, u0_.is_super_admin AS is_super_admin_7, u0_.first_name_string AS first_name_string_8, u0_.last_name_string AS last_name_string_9, u0_.e_mail_address_string AS e_mail_address_string_10, u0_.e_mail_address_subscribed AS e_mail_address_subscribed_11, u0_.mobile_number AS mobile_number_12, u0_.company_name AS company_name_13, u0_.company_vat AS company_vat_14, u0_.deleted AS deleted_15, u0_.date_of_birth AS date_of_birth_16, u0_.id_number AS id_number_17, u0_.passport_number AS passport_number_18, u0_.debit_order_day AS debit_order_day_19, u0_.referred_by AS referred_by_20, u0_.short_code AS short_code_21, u0_.id_doc_file_id AS id_doc_file_id_22, u0_.services AS services_23, u0_.created_by AS created_by_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26 FROM user_list u0_ WHERE u0_.e_mail_address_string = ? GROUP BY u0_.id LIMIT 1
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
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
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
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
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_.id = ? AND s0_.cookie_name = ? AND s0_.symfony_cookie = ? AND s0_.remote_ip = ? LIMIT 1
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
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
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
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
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
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
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
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
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

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\CoreBundle\Entity\ErrorLog	No errors.
App\UserBundle\Entity\UserList	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\Sessions	No errors.
App\ClientBundle\Entity\Client	No errors.
App\ClientBundle\Entity\ClientSite	No errors.
App\UserBundle\Entity\UserListUserLevel	No errors.
App\UserBundle\Entity\TimeSheet	No errors.
App\UserBundle\Entity\TimeSheetQuery	No errors.
App\SessionsBundle\Entity\SessionValues	No errors.
App\SessionsBundle\Entity\SessionUrls	No errors.
App\SessionsBundle\Entity\SessionTextValues	No errors.
App\CrimeBundle\Entity\CCTVIncident	No errors.
App\ClientBundle\Entity\FloorPlan	No errors.
App\UserBundle\Entity\TimeSheetItem	No errors.

Symfony Profiler

GET https://ssc3.devstage.co.za/user/forgot.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping