Query Metrics
3
Database Queries
3
Different statements
6.16 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.65 ms (43.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.owner_id AS owner_id_12, t0.parent_id AS parent_id_13, t0.children_display_configuration_id AS children_display_configuration_id_14 FROM koi_wishlist t0 WHERE t0.parent_id IS NULL AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||
|
1.98 ms (32.13%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.enabled AS enabled_6, t0.roles AS roles_7, t0.currency AS currency_8, t0.locale AS locale_9, t0.timezone AS timezone_10, t0.date_format AS date_format_11, t0.disk_space_allowed AS disk_space_allowed_12, t0.visibility AS visibility_13, t0.last_date_of_activity AS last_date_of_activity_14, t0.theme AS theme_15, t0.wishlists_feature_enabled AS wishlists_feature_enabled_16, t0.tags_feature_enabled AS tags_feature_enabled_17, t0.signs_feature_enabled AS signs_feature_enabled_18, t0.albums_feature_enabled AS albums_feature_enabled_19, t0.loans_feature_enabled AS loans_feature_enabled_20, t0.templates_feature_enabled AS templates_feature_enabled_21, t0.history_feature_enabled AS history_feature_enabled_22, t0.statistics_feature_enabled AS statistics_feature_enabled_23, t0.scraping_feature_enabled AS scraping_feature_enabled_24, t0.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_25, t0.display_items_name_in_grid_view AS display_items_name_in_grid_view_26, t0.search_results_display_mode AS search_results_display_mode_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.collections_display_configuration_id AS collections_display_configuration_id_36, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_37, t0.albums_display_configuration_id AS albums_display_configuration_id_38 FROM koi_user t0 WHERE t0.username = ? AND ((t0.id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.visibility = 'public')) LIMIT 1
Parameters:
[
"FieserOstfriese"
]
|
||||||||||||||||||||||||||
|
1.53 ms (24.79%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.display_mode AS display_mode_3, t0.sorting_property AS sorting_property_4, t0.sorting_type AS sorting_type_5, t0.sorting_direction AS sorting_direction_6, t0.show_visibility AS show_visibility_7, t0.show_actions AS show_actions_8, t0.show_number_of_children AS show_number_of_children_9, t0.show_number_of_items AS show_number_of_items_10, t0.show_item_quantities AS show_item_quantities_11, t0.columns AS columns_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_16 FROM koi_display_configuration t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters:
[
"019c0687-41d4-74c0-8215-d234735478d1"
]
|
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 |
|---|---|
| App\Entity\DisplayConfiguration | 3 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\DisplayConfiguration | No errors. |
| App\Entity\Collection | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\TagCategory | No errors. |
| App\Entity\Wishlist | No errors. |
| App\Entity\Template | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\Album | No errors. |
| App\Entity\Inventory | No errors. |
| App\Entity\Scraper | No errors. |
| App\Entity\ChoiceList | No errors. |
| App\Entity\Search | No errors. |
| App\Entity\Field | No errors. |
| App\Entity\Item | No errors. |
| App\Entity\Datum | No errors. |
| App\Entity\Wish | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Path | No errors. |
| App\Entity\SearchBlock | No errors. |
| App\Entity\Loan | No errors. |
| App\Entity\SearchFilter | No errors. |
| App\Entity\Configuration | No errors. |
| App\Entity\Error | No errors. |