Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Emails
• Serializer
• JMS Serializer 0 + 0
• EasyAdmin
• Configuration

Query Metrics

SELECT count(DISTINCT g0_.id) AS sclr_0 FROM guest g0_ LEFT JOIN room r1_ ON g0_.room_id = r1_.id WHERE g0_.hotel_id = ?

[
  1
]

SELECT
  count(DISTINCT g0_.id) AS sclr_0
FROM
  guest g0_
  LEFT JOIN room r1_ ON g0_.room_id = r1_.id
WHERE
  g0_.hotel_id = ?

SELECT count(DISTINCT g0_.id) AS sclr_0 FROM guest g0_ LEFT JOIN room r1_ ON g0_.room_id = r1_.id WHERE g0_.hotel_id = 1;

SELECT g0_.id AS id_0, g0_.booking_id AS booking_id_1, g0_.first_name AS first_name_2, g0_.last_name AS last_name_3, g0_.document_number AS document_number_4, g0_.document_type AS document_type_5, g0_.date_of_birth AS date_of_birth_6, g0_.nationality AS nationality_7, g0_.gender AS gender_8, g0_.registration_date AS registration_date_9, g0_.check_in_date AS check_in_date_10, g0_.check_in_time AS check_in_time_11, g0_.check_out_date AS check_out_date_12, g0_.check_out_time AS check_out_time_13, g0_.city_tax_exemption AS city_tax_exemption_14, g0_.referer AS referer_15, g0_.property_name AS property_name_16, g0_.is_reported AS is_reported_17, r1_.id AS id_18, r1_.unit AS unit_19, r1_.external_id AS external_id_20, g0_.hotel_id AS hotel_id_21, g0_.room_id AS room_id_22, r1_.hotel_id AS hotel_id_23, r1_.ajpes_property_id AS ajpes_property_id_24 FROM guest g0_ LEFT JOIN room r1_ ON g0_.room_id = r1_.id WHERE g0_.hotel_id = ? AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY g0_.registration_date DESC, g0_.id DESC

[
  1
  84
  83
  82
  78
  77
  75
  74
  68
  67
  66
  65
  64
  61
  60
  59
  58
  57
  56
  55
  54
]

SELECT
  g0_.id AS id_0,
  g0_.booking_id AS booking_id_1,
  g0_.first_name AS first_name_2,
  g0_.last_name AS last_name_3,
  g0_.document_number AS document_number_4,
  g0_.document_type AS document_type_5,
  g0_.date_of_birth AS date_of_birth_6,
  g0_.nationality AS nationality_7,
  g0_.gender AS gender_8,
  g0_.registration_date AS registration_date_9,
  g0_.check_in_date AS check_in_date_10,
  g0_.check_in_time AS check_in_time_11,
  g0_.check_out_date AS check_out_date_12,
  g0_.check_out_time AS check_out_time_13,
  g0_.city_tax_exemption AS city_tax_exemption_14,
  g0_.referer AS referer_15,
  g0_.property_name AS property_name_16,
  g0_.is_reported AS is_reported_17,
  r1_.id AS id_18,
  r1_.unit AS unit_19,
  r1_.external_id AS external_id_20,
  g0_.hotel_id AS hotel_id_21,
  g0_.room_id AS room_id_22,
  r1_.hotel_id AS hotel_id_23,
  r1_.ajpes_property_id AS ajpes_property_id_24
FROM
  guest g0_
  LEFT JOIN room r1_ ON g0_.room_id = r1_.id
WHERE
  g0_.hotel_id = ?
  AND g0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  g0_.registration_date DESC,
  g0_.id DESC

SELECT g0_.id AS id_0, g0_.booking_id AS booking_id_1, g0_.first_name AS first_name_2, g0_.last_name AS last_name_3, g0_.document_number AS document_number_4, g0_.document_type AS document_type_5, g0_.date_of_birth AS date_of_birth_6, g0_.nationality AS nationality_7, g0_.gender AS gender_8, g0_.registration_date AS registration_date_9, g0_.check_in_date AS check_in_date_10, g0_.check_in_time AS check_in_time_11, g0_.check_out_date AS check_out_date_12, g0_.check_out_time AS check_out_time_13, g0_.city_tax_exemption AS city_tax_exemption_14, g0_.referer AS referer_15, g0_.property_name AS property_name_16, g0_.is_reported AS is_reported_17, r1_.id AS id_18, r1_.unit AS unit_19, r1_.external_id AS external_id_20, g0_.hotel_id AS hotel_id_21, g0_.room_id AS room_id_22, r1_.hotel_id AS hotel_id_23, r1_.ajpes_property_id AS ajpes_property_id_24 FROM guest g0_ LEFT JOIN room r1_ ON g0_.room_id = r1_.id WHERE g0_.hotel_id = 1 AND g0_.id IN (84, 83, 82, 78, 77, 75, 74, 68, 67, 66, 65, 64, 61, 60, 59, 58, 57, 56, 55, 54) ORDER BY g0_.registration_date DESC, g0_.id DESC;

SELECT DISTINCT g0_.id AS id_0, g0_.registration_date AS registration_date_1, g0_.id AS id_2 FROM guest g0_ LEFT JOIN room r1_ ON g0_.room_id = r1_.id WHERE g0_.hotel_id = ? ORDER BY g0_.registration_date DESC, g0_.id DESC LIMIT 20

[
  1
]

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.registration_date AS registration_date_1,
  g0_.id AS id_2
FROM
  guest g0_
  LEFT JOIN room r1_ ON g0_.room_id = r1_.id
WHERE
  g0_.hotel_id = ?
ORDER BY
  g0_.registration_date DESC,
  g0_.id DESC
LIMIT
  20

SELECT DISTINCT g0_.id AS id_0, g0_.registration_date AS registration_date_1, g0_.id AS id_2 FROM guest g0_ LEFT JOIN room r1_ ON g0_.room_id = r1_.id WHERE g0_.hotel_id = 1 ORDER BY g0_.registration_date DESC, g0_.id DESC LIMIT 20;

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.check_in_time AS check_in_time_4, t0.check_out_time AS check_out_time_5, t0.is_auto_send AS is_auto_send_6, t0.slug AS slug_7, t0.booking_provider AS booking_provider_8, t0.payment_provider AS payment_provider_9, t0.smart_lock_provider AS smart_lock_provider_10, t0.tourism_registry_provider AS tourism_registry_provider_11, t0.ai_assistant_provider AS ai_assistant_provider_12, t0.city_tax_under7 AS city_tax_under7_13, t0.city_tax7_to18 AS city_tax7_to18_14, t0.city_tax18_and_over AS city_tax18_and_over_15, t0.admin_id AS admin_id_16 FROM hotel t0 WHERE t0.slug = ? LIMIT 1

[
  "greenslo"
]

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.name AS name_3,
  t0.check_in_time AS check_in_time_4,
  t0.check_out_time AS check_out_time_5,
  t0.is_auto_send AS is_auto_send_6,
  t0.slug AS slug_7,
  t0.booking_provider AS booking_provider_8,
  t0.payment_provider AS payment_provider_9,
  t0.smart_lock_provider AS smart_lock_provider_10,
  t0.tourism_registry_provider AS tourism_registry_provider_11,
  t0.ai_assistant_provider AS ai_assistant_provider_12,
  t0.city_tax_under7 AS city_tax_under7_13,
  t0.city_tax7_to18 AS city_tax7_to18_14,
  t0.city_tax18_and_over AS city_tax18_and_over_15,
  t0.admin_id AS admin_id_16
FROM
  hotel t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.check_in_time AS check_in_time_4, t0.check_out_time AS check_out_time_5, t0.is_auto_send AS is_auto_send_6, t0.slug AS slug_7, t0.booking_provider AS booking_provider_8, t0.payment_provider AS payment_provider_9, t0.smart_lock_provider AS smart_lock_provider_10, t0.tourism_registry_provider AS tourism_registry_provider_11, t0.ai_assistant_provider AS ai_assistant_provider_12, t0.city_tax_under7 AS city_tax_under7_13, t0.city_tax7_to18 AS city_tax7_to18_14, t0.city_tax18_and_over AS city_tax18_and_over_15, t0.admin_id AS admin_id_16 FROM hotel t0 WHERE t0.slug = 'greenslo' LIMIT 1;

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token AS token_5 FROM admin t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.token AS token_5
FROM
  admin t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token AS token_5 FROM admin t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.check_in_time AS check_in_time_4, t0.check_out_time AS check_out_time_5, t0.is_auto_send AS is_auto_send_6, t0.slug AS slug_7, t0.booking_provider AS booking_provider_8, t0.payment_provider AS payment_provider_9, t0.smart_lock_provider AS smart_lock_provider_10, t0.tourism_registry_provider AS tourism_registry_provider_11, t0.ai_assistant_provider AS ai_assistant_provider_12, t0.city_tax_under7 AS city_tax_under7_13, t0.city_tax7_to18 AS city_tax7_to18_14, t0.city_tax18_and_over AS city_tax18_and_over_15, t0.admin_id AS admin_id_16 FROM hotel t0 WHERE t0.admin_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.name AS name_3,
  t0.check_in_time AS check_in_time_4,
  t0.check_out_time AS check_out_time_5,
  t0.is_auto_send AS is_auto_send_6,
  t0.slug AS slug_7,
  t0.booking_provider AS booking_provider_8,
  t0.payment_provider AS payment_provider_9,
  t0.smart_lock_provider AS smart_lock_provider_10,
  t0.tourism_registry_provider AS tourism_registry_provider_11,
  t0.ai_assistant_provider AS ai_assistant_provider_12,
  t0.city_tax_under7 AS city_tax_under7_13,
  t0.city_tax7_to18 AS city_tax7_to18_14,
  t0.city_tax18_and_over AS city_tax18_and_over_15,
  t0.admin_id AS admin_id_16
FROM
  hotel t0
WHERE
  t0.admin_id = ?

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.check_in_time AS check_in_time_4, t0.check_out_time AS check_out_time_5, t0.is_auto_send AS is_auto_send_6, t0.slug AS slug_7, t0.booking_provider AS booking_provider_8, t0.payment_provider AS payment_provider_9, t0.smart_lock_provider AS smart_lock_provider_10, t0.tourism_registry_provider AS tourism_registry_provider_11, t0.ai_assistant_provider AS ai_assistant_provider_12, t0.city_tax_under7 AS city_tax_under7_13, t0.city_tax7_to18 AS city_tax7_to18_14, t0.city_tax18_and_over AS city_tax18_and_over_15, t0.admin_id AS admin_id_16 FROM hotel t0 WHERE t0.admin_id = 1;