Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

88.15 ms Query time

1 Invalid entities

1 Managed entities

Queries


SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.ext_building_id AS ext_building_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM user t0 WHERE t0.username = ? LIMIT 1
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.status <> ? AND c0_.status <> ?
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_out_date = ? AND c0_.status <> ? AND c0_.status <> ?
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_out_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.checkin_status IN (?, ?) AND b1_.removed_at IS NULL GROUP BY b1_.name
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND (NOT EXISTS (SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS (SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS (SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = ?)))) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name
SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND (EXISTS (SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS (SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS (SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = ?)))) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name

#▲	Time	Info
1	1.32 ms	SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.ext_building_id AS ext_building_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM user t0 WHERE t0.username = ? LIMIT 1 Parameters: [`"checkin_api"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.ext_building_id AS ext_building_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM user t0 WHERE t0.username = ? LIMIT 1 SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.ext_building_id AS ext_building_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM user t0 WHERE t0.username = 'checkin_api' LIMIT 1;
2	10.76 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.status <> ? AND c0_.status <> ? Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "2025-10-04" "canceled" "not_confirmed"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.status <> ? AND c0_.status <> ? SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND c0_.check_in_date = '2025-10-04' AND c0_.status <> 'canceled' AND c0_.status <> 'not_confirmed';
3	9.84 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_out_date = ? AND c0_.status <> ? AND c0_.status <> ? Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "2025-10-04" "canceled" "not_confirmed"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_out_date = ? AND c0_.status <> ? AND c0_.status <> ? SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0 FROM checkin c0_ WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND c0_.check_out_date = '2025-10-04' AND c0_.status <> 'canceled' AND c0_.status <> 'not_confirmed';
4	7.79 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "2025-10-04" "confirmed"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON ( b1_.ext_building_id = c0_.building_id ) WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND c0_.check_in_date = '2025-10-04' AND c0_.status = 'confirmed' AND b1_.removed_at IS NULL GROUP BY b1_.name;
5	9.11 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_out_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "2025-10-04" "Fez check-in"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON ( b1_.ext_building_id = c0_.building_id ) WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_out_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND c0_.check_out_date = '2025-10-04' AND c0_.checkin_status = 'Fez check-in' AND b1_.removed_at IS NULL GROUP BY b1_.name;
6	8.77 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.checkin_status IN (?, ?) AND b1_.removed_at IS NULL GROUP BY b1_.name Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "2025-10-04" "Sem documentos" "Reenvio solicitado"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON ( b1_.ext_building_id = c0_.building_id ) WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.checkin_status IN (?, ?) AND b1_.removed_at IS NULL GROUP BY b1_.name SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND c0_.check_in_date = '2025-10-04' AND c0_.checkin_status IN ('Sem documentos', 'Reenvio solicitado') AND b1_.removed_at IS NULL GROUP BY b1_.name;
7	11.15 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "2025-10-04" "Documento enviado"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON ( b1_.ext_building_id = c0_.building_id ) WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND c0_.check_in_date = '2025-10-04' AND c0_.checkin_status = 'Documento enviado' AND b1_.removed_at IS NULL GROUP BY b1_.name;
8	14.47 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND (NOT EXISTS (SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS (SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS (SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = ?)))) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "clean" "2025-10-04" "Verificado"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON ( b1_.ext_building_id = c0_.building_id ) WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND ( NOT EXISTS ( SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS ( SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS ( SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = ? ) ) ) ) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND (NOT EXISTS (SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS (SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS (SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = 'clean')))) AND c0_.check_in_date = '2025-10-04' AND c0_.checkin_status = 'Verificado' AND b1_.removed_at IS NULL GROUP BY b1_.name;
9	14.94 ms	SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.building_id NOT IN (?, ?, ?, ?) AND (EXISTS (SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS (SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS (SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = ?)))) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name Parameters: ["191355" "210876" "192361" "208561" "205438" "195575" "201716" "202186" "195963" "199854" "197396" "196178" "196088" "213042" "213046" "205739" "215648" "218669" "218680" "218678" "226610" "226608" "239173" "241401" "254358" "254357" "254480" "254509" "254859" "254884" "256246" "256247" "256918" "259158" "256924" "257479" "257484" "257932" "256984" "257466" "259163" "270858" "277086" "270713" "282011" "283595" "287168" "293175" "293179" "302911" "303181" "303231" "303228" "306335" "310747" "307652" "313508" "307650" "313941" "313510" "315100" "315101" "315675" "315822" "316270" "316271" "316272" "316825" "317242" "316947" "317296" "317658" "317819" "317957" "317958" "318066" "317818" "318180" "318697" "318819" "318859" "318882" "319258" "319241" "198407" "178155" "203574" "164829" "clean" "2025-10-04" "Verificado"] View formatted query View runnable query Explain query SELECT COUNT( DISTINCT (c0_.id) ) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON ( b1_.ext_building_id = c0_.building_id ) WHERE c0_.building_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c0_.building_id NOT IN (?, ?, ?, ?) AND ( EXISTS ( SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS ( SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS ( SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = ? ) ) ) ) AND c0_.check_in_date = ? AND c0_.checkin_status = ? AND b1_.removed_at IS NULL GROUP BY b1_.name SELECT COUNT(DISTINCT (c0_.id)) AS sclr_0, b1_.name AS name_1 FROM checkin c0_ INNER JOIN building b1_ ON (b1_.ext_building_id = c0_.building_id) WHERE c0_.building_id IN ('191355', '210876', '192361', '208561', '205438', '195575', '201716', '202186', '195963', '199854', '197396', '196178', '196088', '213042', '213046', '205739', '215648', '218669', '218680', '218678', '226610', '226608', '239173', '241401', '254358', '254357', '254480', '254509', '254859', '254884', '256246', '256247', '256918', '259158', '256924', '257479', '257484', '257932', '256984', '257466', '259163', '270858', '277086', '270713', '282011', '283595', '287168', '293175', '293179', '302911', '303181', '303231', '303228', '306335', '310747', '307652', '313508', '307650', '313941', '313510', '315100', '315101', '315675', '315822', '316270', '316271', '316272', '316825', '317242', '316947', '317296', '317658', '317819', '317957', '317958', '318066', '317818', '318180', '318697', '318819', '318859', '318882', '319258', '319241') AND c0_.building_id NOT IN ('198407', '178155', '203574', '164829') AND (EXISTS (SELECT 1 AS sclr_2 FROM guest g2_ WHERE g2_.checkin_id = c0_.id AND EXISTS (SELECT 1 AS sclr_3 FROM guest_room g3_ WHERE g3_.guest_id = g2_.id AND EXISTS (SELECT 1 AS sclr_4 FROM room r4_ WHERE g3_.room_id = r4_.id AND r4_.housekeeping_status = 'clean')))) AND c0_.check_in_date = '2025-10-04' AND c0_.checkin_status = 'Verificado' AND b1_.removed_at IS NULL GROUP BY b1_.name;

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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Checkin	The field App\Entity\Checkin#authenticatedTokens is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AuthenticatedToken#checkin does not contain the required 'inversedBy="authenticatedTokens"' attribute.
App\Entity\Building	No errors.
App\Entity\Guest	No errors.
App\Entity\GuestRoom	No errors.
App\Entity\Room	No errors.

Symfony Profiler

GET http://checkinapp-services.checkin.svc.cluster.local/api/painel/counts

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping