Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.test_phase_start AS test_phase_start_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.street AS street_11, t0.zip_code AS zip_code_12, t0.city AS city_13, t0.country AS country_14, t0.stripe_customer_id AS stripe_customer_id_15, t0.pending_package_slug AS pending_package_slug_16, t0.pending_package_interval AS pending_package_interval_17, t0.vat_id AS vat_id_18, t0.favorite_cooldown_until AS favorite_cooldown_until_19 FROM `user` t0 WHERE t0.id = ?

[
  28
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.test_phase_start AS test_phase_start_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.street AS street_11,
  t0.zip_code AS zip_code_12,
  t0.city AS city_13,
  t0.country AS country_14,
  t0.stripe_customer_id AS stripe_customer_id_15,
  t0.pending_package_slug AS pending_package_slug_16,
  t0.pending_package_interval AS pending_package_interval_17,
  t0.vat_id AS vat_id_18,
  t0.favorite_cooldown_until AS favorite_cooldown_until_19
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.test_phase_start AS test_phase_start_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.street AS street_11, t0.zip_code AS zip_code_12, t0.city AS city_13, t0.country AS country_14, t0.stripe_customer_id AS stripe_customer_id_15, t0.pending_package_slug AS pending_package_slug_16, t0.pending_package_interval AS pending_package_interval_17, t0.vat_id AS vat_id_18, t0.favorite_cooldown_until AS favorite_cooldown_until_19 FROM `user` t0 WHERE t0.id = 28;

SELECT t0.id AS id_1, t0.emma_id AS emma_id_2, t0.land AS land_3 FROM warngebiet t0 INNER JOIN user_warngebiete ON t0.id = user_warngebiete.warngebiet_id WHERE user_warngebiete.user_id = ?

[
  28
]

SELECT
  t0.id AS id_1,
  t0.emma_id AS emma_id_2,
  t0.land AS land_3
FROM
  warngebiet t0
  INNER JOIN user_warngebiete ON t0.id = user_warngebiete.warngebiet_id
WHERE
  user_warngebiete.user_id = ?

SELECT t0.id AS id_1, t0.emma_id AS emma_id_2, t0.land AS land_3 FROM warngebiet t0 INNER JOIN user_warngebiete ON t0.id = user_warngebiete.warngebiet_id WHERE user_warngebiete.user_id = 28;

SELECT t0.id AS id_1, t0.attribute_key AS attribute_key_2, t0.value AS value_3, t0.user_id AS user_id_4 FROM user_attribute t0 WHERE t0.user_id = ? AND t0.attribute_key = ? LIMIT 1

[
  28
  "package_request_type"
]

SELECT
  t0.id AS id_1,
  t0.attribute_key AS attribute_key_2,
  t0.value AS value_3,
  t0.user_id AS user_id_4
FROM
  user_attribute t0
WHERE
  t0.user_id = ?
  AND t0.attribute_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.attribute_key AS attribute_key_2, t0.value AS value_3, t0.user_id AS user_id_4 FROM user_attribute t0 WHERE t0.user_id = 28 AND t0.attribute_key = 'package_request_type' LIMIT 1;

SELECT t0.id AS id_1, t0.attribute_key AS attribute_key_2, t0.value AS value_3, t0.user_id AS user_id_4 FROM user_attribute t0 WHERE t0.user_id = ? AND t0.attribute_key = ? LIMIT 1

[
  28
  "refresh_intervall"
]

SELECT
  t0.id AS id_1,
  t0.attribute_key AS attribute_key_2,
  t0.value AS value_3,
  t0.user_id AS user_id_4
FROM
  user_attribute t0
WHERE
  t0.user_id = ?
  AND t0.attribute_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.attribute_key AS attribute_key_2, t0.value AS value_3, t0.user_id AS user_id_4 FROM user_attribute t0 WHERE t0.user_id = 28 AND t0.attribute_key = 'refresh_intervall' LIMIT 1;

SELECT l.*
        FROM location l
        INNER JOIN user_favorite_locations ufl ON l.id = ufl.location_id
        WHERE ufl.user_id = :userId

[
  "userId" => 28
]

SELECT
  l.*
FROM
  location l
  INNER JOIN user_favorite_locations ufl ON l.id = ufl.location_id
WHERE
  ufl.user_id = :userId

SELECT l.*
        FROM location l
        INNER JOIN user_favorite_locations ufl ON l.id = ufl.location_id
        WHERE ufl.user_id = 28
    ;

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.asl AS asl_5, t0.country AS country_6, t0.iso2 AS iso2_7, t0.admin1 AS admin1_8, t0.postcodes AS postcodes_9, t0.timezone AS timezone_10, t0.population AS population_11, t0.feature_class AS feature_class_12, t0.feature_code AS feature_code_13, t0.url AS url_14, t0.external_id AS external_id_15 FROM location t0 WHERE t0.id = ?

[
  207
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lat AS lat_3,
  t0.lon AS lon_4,
  t0.asl AS asl_5,
  t0.country AS country_6,
  t0.iso2 AS iso2_7,
  t0.admin1 AS admin1_8,
  t0.postcodes AS postcodes_9,
  t0.timezone AS timezone_10,
  t0.population AS population_11,
  t0.feature_class AS feature_class_12,
  t0.feature_code AS feature_code_13,
  t0.url AS url_14,
  t0.external_id AS external_id_15
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.asl AS asl_5, t0.country AS country_6, t0.iso2 AS iso2_7, t0.admin1 AS admin1_8, t0.postcodes AS postcodes_9, t0.timezone AS timezone_10, t0.population AS population_11, t0.feature_class AS feature_class_12, t0.feature_code AS feature_code_13, t0.url AS url_14, t0.external_id AS external_id_15 FROM location t0 WHERE t0.id = 207;

SELECT w0_.id AS id_0, w0_.lat AS lat_1, w0_.lon AS lon_2, w0_.asl AS asl_3, w0_.request_type AS request_type_4, w0_.request_params AS request_params_5, w0_.response_data AS response_data_6, w0_.timestamp AS timestamp_7, w0_.place_name AS place_name_8 FROM weather_cache w0_ WHERE w0_.lat = ? AND w0_.lon = ? AND w0_.asl = ? AND w0_.request_type = ? AND w0_.request_params = ? ORDER BY w0_.timestamp DESC LIMIT 1

[
  47.5067
  12.0403
  641
  "basic-day_snowice-day_air-day_sunmoon_snowice-1h_basic-1h"
  "{"lat":47.5067,"lon":12.0403,"format":"json"}"
]

SELECT
  w0_.id AS id_0,
  w0_.lat AS lat_1,
  w0_.lon AS lon_2,
  w0_.asl AS asl_3,
  w0_.request_type AS request_type_4,
  w0_.request_params AS request_params_5,
  w0_.response_data AS response_data_6,
  w0_.timestamp AS timestamp_7,
  w0_.place_name AS place_name_8
FROM
  weather_cache w0_
WHERE
  w0_.lat = ?
  AND w0_.lon = ?
  AND w0_.asl = ?
  AND w0_.request_type = ?
  AND w0_.request_params = ?
ORDER BY
  w0_.timestamp DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.lat AS lat_1, w0_.lon AS lon_2, w0_.asl AS asl_3, w0_.request_type AS request_type_4, w0_.request_params AS request_params_5, w0_.response_data AS response_data_6, w0_.timestamp AS timestamp_7, w0_.place_name AS place_name_8 FROM weather_cache w0_ WHERE w0_.lat = 47.5067 AND w0_.lon = 12.0403 AND w0_.asl = 641 AND w0_.request_type = 'basic-day_snowice-day_air-day_sunmoon_snowice-1h_basic-1h' AND w0_.request_params = '{\"lat\":47.5067,\"lon\":12.0403,\"format\":\"json\"}' ORDER BY w0_.timestamp DESC LIMIT 1;

SELECT t0.id AS id_1, t0.attribute_key AS attribute_key_2, t0.value AS value_3, t0.user_id AS user_id_4 FROM user_attribute t0 WHERE t0.user_id = ? AND t0.attribute_key = ? LIMIT 1

[
  28
  "max_favorites"
]

SELECT
  t0.id AS id_1,
  t0.attribute_key AS attribute_key_2,
  t0.value AS value_3,
  t0.user_id AS user_id_4
FROM
  user_attribute t0
WHERE
  t0.user_id = ?
  AND t0.attribute_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.attribute_key AS attribute_key_2, t0.value AS value_3, t0.user_id AS user_id_4 FROM user_attribute t0 WHERE t0.user_id = 28 AND t0.attribute_key = 'max_favorites' LIMIT 1;