Redirect 301 redirect from GET @fe_venue_index (5bb7c2)

GET https://test.test.kursimple.de/frontend/venue/

Query Metrics

22 Database Queries
6 Different statements
9.78 ms Query time
0 Invalid entities
21 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.77 ms
(28.36%)
7
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.title AS title_6, t0.description AS description_7, t0.author AS author_8, t0.client_id AS client_id_9, t0.venue_id AS venue_id_10 FROM venue_image t0 WHERE t0.venue_id = ? ORDER BY t0.order_id ASC
Parameters:
[
  1
]
2.31 ms
(23.67%)
7
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.number AS number_5, t0.floor AS floor_6, t0.building AS building_7, t0.client_id AS client_id_8, t0.venueId AS venueId_9 FROM venue_room t0 WHERE t0.venueId = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
1.75 ms
(17.85%)
3
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.keycloak_client_id AS keycloak_client_id_18, t0.keycloakGroupId AS keycloakGroupId_19 FROM client t0 WHERE t0.subdomain = ? LIMIT 1
Parameters:
[
  "test"
]
1.63 ms
(16.69%)
1
SELECT v0_.id AS id_0, v0_.created AS created_1, v0_.modified AS modified_2, v0_.name AS name_3, v0_.postalcode AS postalcode_4, v0_.city AS city_5, v0_.street AS street_6, v0_.street_number AS street_number_7, v0_.geo_latitude AS geo_latitude_8, v0_.geo_longitude AS geo_longitude_9, v0_.client_id AS client_id_10 FROM venue v0_ LEFT JOIN client c1_ ON v0_.client_id = c1_.id WHERE c1_.id = ? ORDER BY v0_.name ASC
Parameters:
[
  1
]
0.66 ms
(6.72%)
3
SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1
Parameters:
[
  1
  "THEME_NAME"
]
0.66 ms
(6.72%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.session_id AS session_id_4, t0.customer_id AS customer_id_5, t0.client_id AS client_id_6 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
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
App\Entity\VenueRoom 10
App\Entity\Venue 7
App\Entity\VenueImage 2
App\User\Entity\Client 1
App\Entity\ClientConfigVariable 1

Entities Mapping