Query Metrics
5
Database Queries
5
Different statements
2.00 ms
Query time
4
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.74 ms |
SELECT c0_.namespace AS namespace_0, c0_.name AS name_1, c0_.value AS value_2, c0_.default_value AS default_value_3, c0_.id AS id_4, c0_.type AS type_5, c0_.created AS created_6, c0_.updated AS updated_7, c0_.system AS system_8 FROM configuration c0_ WHERE c0_.namespace = ?
Parameters:
[
"general"
]
|
| 2 | 0.32 ms |
SELECT s0_.resource AS resource_0, s0_.doctrine_settings AS doctrine_settings_1, s0_.elastic_settings AS elastic_settings_2, s0_.system_settings AS system_settings_3, s0_.user_settings AS user_settings_4, s0_.id AS id_5, s0_.name AS name_6, s0_.parent_id AS parent_id_7, s0_.extension_id AS extension_id_8 FROM search_preset_2 s0_ WHERE s0_.name = ? LIMIT 1
Parameters:
[
"pricing.currency"
]
|
| 3 | 0.24 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.configurations AS configurations_3, s0_.system AS system_4, s0_.created AS created_5, s0_.updated AS updated_6 FROM searcher s0_ WHERE s0_.name = ? LIMIT 1
Parameters:
[
"default"
]
|
| 4 | 0.49 ms |
SELECT DISTINCT COUNT(DISTINCT c0_.id) AS sclr_0 FROM currency c0_
Parameters:
[] |
| 5 | 0.21 ms |
SELECT DISTINCT c0_.id AS id_0 FROM currency c0_ ORDER BY c0_.id DESC LIMIT 25
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Nilead\SearchBundle\Model\SearchPreset2 | 1 |
| Nilead\SearchBundle\Model\Searcher | 1 |