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

Query Metrics

13 Database Queries
4 Different statements
6,74 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0,94 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,43 ms
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.deleted_at IS NULL
Parameters:
[]
3 0,66 ms
SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_1 FROM apartment a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.price ASC LIMIT 15
Parameters:
[]
4 0,85 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_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.price ASC
Parameters:
[
  109
  69
  110
  70
  108
  71
  56
  55
  58
  18
  74
  26
  57
  72
  75
]
5 0,50 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"
]
6 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"
]
7 0,29 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,29 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,31 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,26 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,29 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,28 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,26 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.