http://dev80.nexgen.cz/admin/login

Query Metrics

15 Database Queries
10 Different statements
27.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.34 ms
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
2 0.36 ms
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
  1
]
3 0.34 ms
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
  "cs"
]
4 0.41 ms
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
5 0.33 ms
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
  1
]
6 0.42 ms
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
  "cs"
]
7 0.29 ms
SELECT l0_.iso_2 AS iso_2_0 FROM lang l0_
Parameters:
[]
8 2.27 ms
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "note_recover"
]
9 3.08 ms
SELECT b0_.ip AS ip_0, b0_.username AS username_1, b0_.blocks AS blocks_2, b0_.blocked_to AS blocked_to_3, b0_.hidden AS hidden_4, b0_.id AS id_5 FROM brute_force_block b0_ WHERE b0_.username = ? AND b0_.blocked_to > ?
Parameters:
[
  ""
  "2025-04-25 14:08:27"
]
10 3.79 ms
SELECT b0_.ip AS ip_0, b0_.username AS username_1, b0_.attempt AS attempt_2, b0_.hidden AS hidden_3, b0_.id AS id_4 FROM brute_login_attempt b0_ WHERE b0_.username = ? AND b0_.hidden <> 1 AND b0_.attempt > ?
Parameters:
[
  ""
  "2025-04-25 12:08:27"
]
11 0.29 ms
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "disallow_recover"
]
12 5.31 ms
SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_
Parameters:
[]
13 0.67 ms
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0
Parameters:
[]
14 0.46 ms
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0
Parameters:
[]
15 7.76 ms
SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = ?
Parameters:
[
  "142356f602_680b7b3b2e4910.76869763"
]

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
NexCRM\BaseBundle\Entity\Lang No errors.
NexCRM\BaseBundle\Entity\Setting No errors.
NexCRM\BaseBundle\Entity\Country No errors.
NexCRM\BaseBundle\Entity\BruteForceLoginAttempt No errors.
NexCRM\BaseBundle\Entity\BruteForceBlock No errors.
NexCRM\BaseBundle\Entity\SettingTranslation No errors.
NexCRM\BaseBundle\Entity\LangToken No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord No errors.