GET https://xn--1--3lc1a.xn--p1ai/

Query Metrics

15 Database Queries
6 Different statements
7,33 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0,89 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
2 0,78 ms
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.residential_development = ?
Parameters:
[
  "perspektiva"
]
3 0,55 ms
SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_1 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.residential_development = ? ORDER BY a0_.price ASC LIMIT 15
Parameters:
[
  "perspektiva"
]
4 0,78 ms
SELECT a0_.id AS id_0, a0_.residential_development AS residential_development_1, a0_.room_count AS room_count_2, a0_.price AS price_3, a0_.square AS square_4, a0_.floor AS floor_5, a0_.business AS business_6, a0_.tags AS tags_7, a0_.side_window AS side_window_8, a0_.images AS images_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.extra_data AS extra_data_12, a0_.deleted_at AS deleted_at_13 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.residential_development = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.price ASC
Parameters:
[
  "perspektiva"
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
]
5 0,50 ms
SELECT DISTINCT a0_.room_count AS room_count_0 FROM apartment a0_ WHERE a0_.residential_development = ? ORDER BY room_count_0 ASC
Parameters:
[
  "perspektiva"
]
6 0,40 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.business = 1 AND a0_.residential_development = ?
Parameters:
[
  "perspektiva"
]
7 0,43 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
8 0,35 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
9 0,36 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
10 0,35 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
11 0,34 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
12 0,35 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
13 0,52 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
14 0,38 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
15 0,35 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]

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\Apartment 14
App\Entity\ResidentialDevData 1

Entities Mapping

Class Mapping errors
App\Entity\ResidentialDevData No errors.
App\Entity\Apartment No errors.