http://cms.stage.geocloud.sk/admin/option/groups-list

Query Metrics

4 Database Queries
4 Different statements
42.27 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.82 ms
(49.26%)
1
SELECT t0.g_name AS g_name_1, t0.g_checkusers AS g_checkusers_2, t0.id AS id_3, t0.visibility AS visibility_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.last_check_at AS last_check_at_7, t0.next_check_at AS next_check_at_8 FROM cms_optiongroup t0 ORDER BY t0.edited_at ASC
Parameters:
[]
11.01 ms
(26.05%)
1
SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.value AS value_2, c0_.o_params AS o_params_3, c0_.id AS id_4, c0_.visibility AS visibility_5, c0_.created_at AS created_at_6, c0_.edited_at AS edited_at_7, c0_.last_check_at AS last_check_at_8, c0_.next_check_at AS next_check_at_9 FROM cms_option c0_ WHERE c0_.code IS NOT NULL AND c0_.visibility = ?
Parameters:
[
  1
]
6.78 ms
(16.04%)
1
SELECT t0.username AS username_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.description AS description_7, t0.is_active AS is_active_8, t0.settings AS settings_9, t0.icon AS icon_10, t0.new_pass_hash AS new_pass_hash_11, t0.slug AS slug_12, t0.source AS source_13, t0.is_public AS is_public_14, t0.u_params AS u_params_15, t0.id AS id_16, t0.visibility AS visibility_17, t0.created_at AS created_at_18, t0.edited_at AS edited_at_19, t0.last_check_at AS last_check_at_20, t0.next_check_at AS next_check_at_21 FROM cms_user t0 WHERE t0.id = ?
Parameters:
[
  4
]
3.66 ms
(8.65%)
1
SELECT t0.name AS name_1, t0.role AS role_2, t0.id AS id_3, t0.visibility AS visibility_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.last_check_at AS last_check_at_7, t0.next_check_at AS next_check_at_8 FROM cms_group t0 INNER JOIN cms_conn_user_group ON t0.id = cms_conn_user_group.group_id WHERE cms_conn_user_group.user_id = ?
Parameters:
[
  4
]

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