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

Query Metrics

15 Database Queries
6 Different statements
9,68 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0,92 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 1,05 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,87 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,97 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"
  69
  70
  71
  54
  57
  56
  58
  55
  59
  19
  18
  53
  50
  20
  51
]
5 0,77 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,67 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.business = 1 AND a0_.residential_development = ?
Parameters:
[
  "perspektiva"
]
7 0,75 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,56 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,44 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,37 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,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"
]
12 0,32 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,71 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,48 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,46 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 15
App\Entity\ResidentialDevData 1

Entities Mapping

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