Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.type AS type_2,
  p0_.value AS value_3,
  p0_.parameter_category_id AS parameter_category_id_4
FROM
  parameter p0_
ORDER BY
  p0_.parameter_category_id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.value AS value_3, p0_.parameter_category_id AS parameter_category_id_4 FROM parameter p0_ ORDER BY p0_.parameter_category_id ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.type AS type_2,
  p0_.value AS value_3,
  p0_.parameter_category_id AS parameter_category_id_4
FROM
  parameter p0_
ORDER BY
  p0_.parameter_category_id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.value AS value_3, p0_.parameter_category_id AS parameter_category_id_4 FROM parameter p0_ ORDER BY p0_.parameter_category_id ASC;

SELECT
  g0_.id AS id_0,
  g0_.technical_identifier AS technical_identifier_1,
  g0_.address AS address_2,
  g0_.zip AS zip_3,
  g0_.city AS city_4,
  g0_.country AS country_5,
  g0_.capacite AS capacite_6,
  g0_.license_key AS license_key_7,
  g0_.version AS version_8,
  g0_.url AS url_9,
  g0_.last_seen AS last_seen_10,
  g0_.rfid_test AS rfid_test_11,
  g0_.moxa_test AS moxa_test_12,
  g0_.current_version AS current_version_13,
  g0_.force_open AS force_open_14,
  g0_.occupation AS occupation_15,
  g0_.alertedroite AS alertedroite_16,
  g0_.alertegauche AS alertegauche_17,
  g0_.alertedroitedate AS alertedroitedate_18,
  g0_.alertegauchedate AS alertegauchedate_19,
  g0_.downloadrefresh AS downloadrefresh_20,
  g0_.uploadrefresh AS uploadrefresh_21,
  g0_.openrefresh AS openrefresh_22,
  g0_.doordelay AS doordelay_23,
  g0_.lightdelay AS lightdelay_24,
  g0_.dooralarm AS dooralarm_25,
  g0_.import AS import_26,
  g0_.export AS export_27,
  g0_.dateouverture AS dateouverture_28,
  g0_.datefermeture AS datefermeture_29,
  g0_.status AS status_30,
  g0_.destinataire_alertes AS destinataire_alertes_31,
  g0_.deleted_at AS deleted_at_32,
  g0_.alimentation AS alimentation_33,
  g0_.abonnementdispo AS abonnementdispo_34,
  g0_.opt AS opt_35,
  g0_.surnom AS surnom_36,
  g0_.latitude AS latitude_37,
  g0_.longitude AS longitude_38,
  g0_.nb_theorique_abo AS nb_theorique_abo_39,
  g0_.sms AS sms_40,
  g0_.abelsensoruuid AS abelsensoruuid_41,
  g0_.bbg AS bbg_42,
  g0_.di3 AS di3_43,
  g0_.di4 AS di4_44,
  g0_.di5 AS di5_45,
  g0_.synchronize AS synchronize_46,
  g0_.synchronize_demo AS synchronize_demo_47,
  g0_.lravuuid AS lravuuid_48,
  g0_.network_quality AS network_quality_49,
  g0_.visible AS visible_50,
  g0_.bi_sync AS bi_sync_51,
  g0_.id_bi AS id_bi_52,
  g0_.idfm_station_id AS idfm_station_id_53,
  g0_.id_marketing AS id_marketing_54,
  g0_.shelter_type_id AS shelter_type_id_55,
  g0_.shelter_address_id AS shelter_address_id_56
FROM
  garage g0_
WHERE
  g0_.last_seen > ?

SELECT g0_.id AS id_0, g0_.technical_identifier AS technical_identifier_1, g0_.address AS address_2, g0_.zip AS zip_3, g0_.city AS city_4, g0_.country AS country_5, g0_.capacite AS capacite_6, g0_.license_key AS license_key_7, g0_.version AS version_8, g0_.url AS url_9, g0_.last_seen AS last_seen_10, g0_.rfid_test AS rfid_test_11, g0_.moxa_test AS moxa_test_12, g0_.current_version AS current_version_13, g0_.force_open AS force_open_14, g0_.occupation AS occupation_15, g0_.alertedroite AS alertedroite_16, g0_.alertegauche AS alertegauche_17, g0_.alertedroitedate AS alertedroitedate_18, g0_.alertegauchedate AS alertegauchedate_19, g0_.downloadrefresh AS downloadrefresh_20, g0_.uploadrefresh AS uploadrefresh_21, g0_.openrefresh AS openrefresh_22, g0_.doordelay AS doordelay_23, g0_.lightdelay AS lightdelay_24, g0_.dooralarm AS dooralarm_25, g0_.import AS import_26, g0_.export AS export_27, g0_.dateouverture AS dateouverture_28, g0_.datefermeture AS datefermeture_29, g0_.status AS status_30, g0_.destinataire_alertes AS destinataire_alertes_31, g0_.deleted_at AS deleted_at_32, g0_.alimentation AS alimentation_33, g0_.abonnementdispo AS abonnementdispo_34, g0_.opt AS opt_35, g0_.surnom AS surnom_36, g0_.latitude AS latitude_37, g0_.longitude AS longitude_38, g0_.nb_theorique_abo AS nb_theorique_abo_39, g0_.sms AS sms_40, g0_.abelsensoruuid AS abelsensoruuid_41, g0_.bbg AS bbg_42, g0_.di3 AS di3_43, g0_.di4 AS di4_44, g0_.di5 AS di5_45, g0_.synchronize AS synchronize_46, g0_.synchronize_demo AS synchronize_demo_47, g0_.lravuuid AS lravuuid_48, g0_.network_quality AS network_quality_49, g0_.visible AS visible_50, g0_.bi_sync AS bi_sync_51, g0_.id_bi AS id_bi_52, g0_.idfm_station_id AS idfm_station_id_53, g0_.id_marketing AS id_marketing_54, g0_.shelter_type_id AS shelter_type_id_55, g0_.shelter_address_id AS shelter_address_id_56 FROM garage g0_ WHERE g0_.last_seen > '2026-03-11 23:06:08';

SELECT
  g0_.id AS id_0,
  g0_.technical_identifier AS technical_identifier_1,
  g0_.address AS address_2,
  g0_.zip AS zip_3,
  g0_.city AS city_4,
  g0_.country AS country_5,
  g0_.capacite AS capacite_6,
  g0_.license_key AS license_key_7,
  g0_.version AS version_8,
  g0_.url AS url_9,
  g0_.last_seen AS last_seen_10,
  g0_.rfid_test AS rfid_test_11,
  g0_.moxa_test AS moxa_test_12,
  g0_.current_version AS current_version_13,
  g0_.force_open AS force_open_14,
  g0_.occupation AS occupation_15,
  g0_.alertedroite AS alertedroite_16,
  g0_.alertegauche AS alertegauche_17,
  g0_.alertedroitedate AS alertedroitedate_18,
  g0_.alertegauchedate AS alertegauchedate_19,
  g0_.downloadrefresh AS downloadrefresh_20,
  g0_.uploadrefresh AS uploadrefresh_21,
  g0_.openrefresh AS openrefresh_22,
  g0_.doordelay AS doordelay_23,
  g0_.lightdelay AS lightdelay_24,
  g0_.dooralarm AS dooralarm_25,
  g0_.import AS import_26,
  g0_.export AS export_27,
  g0_.dateouverture AS dateouverture_28,
  g0_.datefermeture AS datefermeture_29,
  g0_.status AS status_30,
  g0_.destinataire_alertes AS destinataire_alertes_31,
  g0_.deleted_at AS deleted_at_32,
  g0_.alimentation AS alimentation_33,
  g0_.abonnementdispo AS abonnementdispo_34,
  g0_.opt AS opt_35,
  g0_.surnom AS surnom_36,
  g0_.latitude AS latitude_37,
  g0_.longitude AS longitude_38,
  g0_.nb_theorique_abo AS nb_theorique_abo_39,
  g0_.sms AS sms_40,
  g0_.abelsensoruuid AS abelsensoruuid_41,
  g0_.bbg AS bbg_42,
  g0_.di3 AS di3_43,
  g0_.di4 AS di4_44,
  g0_.di5 AS di5_45,
  g0_.synchronize AS synchronize_46,
  g0_.synchronize_demo AS synchronize_demo_47,
  g0_.lravuuid AS lravuuid_48,
  g0_.network_quality AS network_quality_49,
  g0_.visible AS visible_50,
  g0_.bi_sync AS bi_sync_51,
  g0_.id_bi AS id_bi_52,
  g0_.idfm_station_id AS idfm_station_id_53,
  g0_.id_marketing AS id_marketing_54,
  g0_.shelter_type_id AS shelter_type_id_55,
  g0_.shelter_address_id AS shelter_address_id_56
FROM
  garage g0_
  LEFT JOIN shelter_type s1_ ON g0_.shelter_type_id = s1_.id
WHERE
  s1_.id IS NOT NULL
  AND s1_.id <> ?
ORDER BY
  g0_.id ASC

SELECT g0_.id AS id_0, g0_.technical_identifier AS technical_identifier_1, g0_.address AS address_2, g0_.zip AS zip_3, g0_.city AS city_4, g0_.country AS country_5, g0_.capacite AS capacite_6, g0_.license_key AS license_key_7, g0_.version AS version_8, g0_.url AS url_9, g0_.last_seen AS last_seen_10, g0_.rfid_test AS rfid_test_11, g0_.moxa_test AS moxa_test_12, g0_.current_version AS current_version_13, g0_.force_open AS force_open_14, g0_.occupation AS occupation_15, g0_.alertedroite AS alertedroite_16, g0_.alertegauche AS alertegauche_17, g0_.alertedroitedate AS alertedroitedate_18, g0_.alertegauchedate AS alertegauchedate_19, g0_.downloadrefresh AS downloadrefresh_20, g0_.uploadrefresh AS uploadrefresh_21, g0_.openrefresh AS openrefresh_22, g0_.doordelay AS doordelay_23, g0_.lightdelay AS lightdelay_24, g0_.dooralarm AS dooralarm_25, g0_.import AS import_26, g0_.export AS export_27, g0_.dateouverture AS dateouverture_28, g0_.datefermeture AS datefermeture_29, g0_.status AS status_30, g0_.destinataire_alertes AS destinataire_alertes_31, g0_.deleted_at AS deleted_at_32, g0_.alimentation AS alimentation_33, g0_.abonnementdispo AS abonnementdispo_34, g0_.opt AS opt_35, g0_.surnom AS surnom_36, g0_.latitude AS latitude_37, g0_.longitude AS longitude_38, g0_.nb_theorique_abo AS nb_theorique_abo_39, g0_.sms AS sms_40, g0_.abelsensoruuid AS abelsensoruuid_41, g0_.bbg AS bbg_42, g0_.di3 AS di3_43, g0_.di4 AS di4_44, g0_.di5 AS di5_45, g0_.synchronize AS synchronize_46, g0_.synchronize_demo AS synchronize_demo_47, g0_.lravuuid AS lravuuid_48, g0_.network_quality AS network_quality_49, g0_.visible AS visible_50, g0_.bi_sync AS bi_sync_51, g0_.id_bi AS id_bi_52, g0_.idfm_station_id AS idfm_station_id_53, g0_.id_marketing AS id_marketing_54, g0_.shelter_type_id AS shelter_type_id_55, g0_.shelter_address_id AS shelter_address_id_56 FROM garage g0_ LEFT JOIN shelter_type s1_ ON g0_.shelter_type_id = s1_.id WHERE s1_.id IS NOT NULL AND s1_.id <> 3 ORDER BY g0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 1;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (1);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 2;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 2;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (2);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 2;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 3;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 3;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (3);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 3;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 4;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 4;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (4);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 4;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 5;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 5;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (5);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 5;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 6;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 6;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (6);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 6;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 7;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 7;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (7);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 7;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 8;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 8;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (8);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 8;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 9;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = 9;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.place_number AS place_number_3,
  t0.access_control_technical_name AS access_control_technical_name_4,
  t0.shelter_id AS shelter_id_5
FROM
  rack t0
WHERE
  t0.shelter_id IN (?)

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (9);

SELECT
  t0.id AS id_1,
  t0.locktag AS locktag_2,
  t0.lock_id AS lock_id_3,
  t0.serial AS serial_4,
  t0.garage_id AS garage_id_5
FROM
  garage_luckey t0
WHERE
  t0.garage_id = ?

SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = 9;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  access_type t0
  INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id
WHERE
  garage_access_type.garage_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = 10;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon AS icon_3,
  t0.rack_service_type_id AS rack_service_type_id_4
FROM
  rack_service t0
  INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id
WHERE
  garage_rack_service.garage_id = ?