GET https://storm.ewm.dev/api/map-buildings

Query Metrics

3 Database Queries
3 Different statements
6.42 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.87 ms
(91.46%)
1
SELECT t0_.asset_number AS asset_number_0, t0_.latitude AS latitude_1, t0_.longitude AS longitude_2, t0_.tenant_type AS tenant_type_3, t0_.tenant AS tenant_4, t0_.owner AS owner_5, t0_.surface AS surface_6, t0_.listing_rent AS listing_rent_7, t0_.warehouse_type AS warehouse_type_8 FROM tenant t0_
Parameters:
[]
0.42 ms
(6.54%)
1
SELECT b0_.asset_number AS asset_number_0, b0_.latitude AS latitude_1, b0_.longitude AS longitude_2, b0_.construction_date AS construction_date_3 FROM building b0_
Parameters:
[]
0.13 ms
(1.99%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.phone AS phone_4, t0.email AS email_5, t0.password AS password_6, t0.gender AS gender_7, t0.company AS company_8, t0.role AS role_9, t0.active AS active_10, t0.confirmed AS confirmed_11, t0.address AS address_12, t0.zip_code AS zip_code_13, t0.person_in_charge AS person_in_charge_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.offer_max_properties AS offer_max_properties_17, t0.offer_expires_at AS offer_expires_at_18, t0.offer_published_properties AS offer_published_properties_19, t0.nb_of_generation AS nb_of_generation_20, t0.last_generation_update_at AS last_generation_update_at_21, t0.city AS city_22, t0.report_credit_expired_at AS report_credit_expired_at_23, t0.report_credit_type AS report_credit_type_24, t0.report_credit_total_limited AS report_credit_total_limited_25, t0.report_credit_max_per_day AS report_credit_max_per_day_26, t0.report_credit_last_used_at AS report_credit_last_used_at_27, t0.report_credit_total_used AS report_credit_total_used_28, t0.report_credit_total_used_per_day AS report_credit_total_used_per_day_29, t0.image_id AS image_id_30 FROM owner t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "sb@ewm.swiss"
]

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.