Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.name_pl AS name_pl_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  hotels_type t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM hotels_type t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  hotels_standard t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM hotels_standard t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.is_default AS is_default_3,
  t0.name_pl AS name_pl_4,
  t0.name_en AS name_en_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  addressation_lv1_continent t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.is_default AS is_default_3, t0.name_pl AS name_pl_4, t0.name_en AS name_en_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM addressation_lv1_continent t0 WHERE t0.code = 'EU' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name_pl AS name_pl_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.continent_id AS continent_id_7
FROM
  addressation_lv2_country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.continent_id AS continent_id_7 FROM addressation_lv2_country t0 WHERE t0.code = 'PL' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.is_default AS is_default_3,
  t0.name_pl AS name_pl_4,
  t0.name_en AS name_en_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  addressation_lv1_continent t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.is_default AS is_default_3, t0.name_pl AS name_pl_4, t0.name_en AS name_en_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM addressation_lv1_continent t0 WHERE t0.code = 'EU' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name_pl AS name_pl_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.continent_id AS continent_id_7
FROM
  addressation_lv2_country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.continent_id AS continent_id_7 FROM addressation_lv2_country t0 WHERE t0.code = 'PL' LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.attribute_group AS attribute_group_2,
  h0_.enabled AS enabled_3,
  h0_.idx_order AS idx_order_4,
  h0_.created_at AS created_at_5,
  h0_.updated_at AS updated_at_6
FROM
  hotels_attribute h0_
WHERE
  h0_.attribute_group = ?
  AND h0_.enabled = 1
ORDER BY
  h0_.idx_order ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.attribute_group AS attribute_group_2, h0_.enabled AS enabled_3, h0_.idx_order AS idx_order_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6 FROM hotels_attribute h0_ WHERE h0_.attribute_group = 1 AND h0_.enabled = 1 ORDER BY h0_.idx_order ASC;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.attribute_group AS attribute_group_2,
  h0_.enabled AS enabled_3,
  h0_.idx_order AS idx_order_4,
  h0_.created_at AS created_at_5,
  h0_.updated_at AS updated_at_6
FROM
  hotels_attribute h0_
WHERE
  h0_.attribute_group = ?
  AND h0_.enabled = 1
ORDER BY
  h0_.idx_order ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.attribute_group AS attribute_group_2, h0_.enabled AS enabled_3, h0_.idx_order AS idx_order_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6 FROM hotels_attribute h0_ WHERE h0_.attribute_group = 2 AND h0_.enabled = 1 ORDER BY h0_.idx_order ASC;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.attribute_group AS attribute_group_2,
  h0_.enabled AS enabled_3,
  h0_.idx_order AS idx_order_4,
  h0_.created_at AS created_at_5,
  h0_.updated_at AS updated_at_6
FROM
  hotels_attribute h0_
WHERE
  h0_.attribute_group = ?
  AND h0_.enabled = 1
ORDER BY
  h0_.idx_order ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.attribute_group AS attribute_group_2, h0_.enabled AS enabled_3, h0_.idx_order AS idx_order_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6 FROM hotels_attribute h0_ WHERE h0_.attribute_group = 3 AND h0_.enabled = 1 ORDER BY h0_.idx_order ASC;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.attribute_group AS attribute_group_2,
  h0_.enabled AS enabled_3,
  h0_.idx_order AS idx_order_4,
  h0_.created_at AS created_at_5,
  h0_.updated_at AS updated_at_6
FROM
  hotels_attribute h0_
WHERE
  h0_.attribute_group = ?
  AND h0_.enabled = 1
ORDER BY
  h0_.idx_order ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.attribute_group AS attribute_group_2, h0_.enabled AS enabled_3, h0_.idx_order AS idx_order_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6 FROM hotels_attribute h0_ WHERE h0_.attribute_group = 4 AND h0_.enabled = 1 ORDER BY h0_.idx_order ASC;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.api_identifier AS api_identifier_3,
  t0.name AS name_4,
  t0.group_name AS group_name_5,
  t0.brand_name AS brand_name_6,
  t0.owner_name AS owner_name_7,
  t0.pms_name AS pms_name_8,
  t0.pms_version AS pms_version_9,
  t0.enabled AS enabled_10,
  t0.standard AS standard_11,
  t0.rooms AS rooms_12,
  t0.coordinates AS coordinates_13,
  t0.inactive_rooms AS inactive_rooms_14,
  t0.object_type AS object_type_15,
  t0.checked AS checked_16,
  t0.approved_by_klips AS approved_by_klips_17,
  t0.address_manual_content AS address_manual_content_18,
  t0.klips_access_to_view AS klips_access_to_view_19,
  t0.reports_currency AS reports_currency_20,
  t0.convert_ratio_eur AS convert_ratio_eur_21,
  t0.convert_ratio_usd AS convert_ratio_usd_22,
  t0.blocked_status AS blocked_status_23,
  t0.account_type AS account_type_24,
  t0.account_premium_deadline AS account_premium_deadline_25,
  t0.invited_by AS invited_by_26,
  t0.invite_validated AS invite_validated_27,
  t0.invite_validated_date AS invite_validated_date_28,
  t0.invite_used AS invite_used_29,
  t0.google_places_id AS google_places_id_30,
  t0.booking_id AS booking_id_31,
  t0.tripadvisor_id AS tripadvisor_id_32,
  t0.facebook_id AS facebook_id_33,
  t0.trustmate_id AS trustmate_id_34,
  t0.is_apartment AS is_apartment_35,
  t0.short_name AS short_name_36,
  t0.unlocked_reports_till AS unlocked_reports_till_37,
  t0.unlocked_future_reports_till AS unlocked_future_reports_till_38,
  t0.excluded_from_comparison AS excluded_from_comparison_39,
  t0.system_report_last_checked_date AS system_report_last_checked_date_40,
  t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41,
  t0.daily_report_checkin_from AS daily_report_checkin_from_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t45.id AS id_46,
  t45.continent AS continent_47,
  t45.country AS country_48,
  t45.pna AS pna_49,
  t45.province AS province_50,
  t45.city AS city_51,
  t45.street AS street_52,
  t45.street_number AS street_number_53,
  t45.hotel_id AS hotel_id_54,
  t55.id AS id_56,
  t55.company_name AS company_name_57,
  t55.first_name AS first_name_58,
  t55.last_name AS last_name_59,
  t55.job_name AS job_name_60,
  t55.phone AS phone_61,
  t55.email AS email_62,
  t55.address AS address_63,
  t55.tax_vat AS tax_vat_64,
  t55.nip AS nip_65,
  t55.zip_code AS zip_code_66,
  t55.city AS city_67,
  t55.hotel_id AS hotel_id_68,
  t0.street_id AS street_id_69,
  t0.klips_seller_id AS klips_seller_id_70,
  t0.hotels_networks_id AS hotels_networks_id_71,
  t0.hotels_network_agreement_id AS hotels_network_agreement_id_72,
  t0.network_id AS network_id_73,
  t0.network_agreement_id AS network_agreement_id_74,
  t0.virtual_city_id AS virtual_city_id_75,
  t0.apartments_clusters_id AS apartments_clusters_id_76,
  t77.id AS id_78,
  t77.created_at AS created_at_79,
  t77.updated_at AS updated_at_80,
  t77.hotel_id AS hotel_id_81,
  t77.apartments_clusters_id AS apartments_clusters_id_82
FROM
  hotels t0
  LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id
  LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id
  LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id
WHERE
  t0.checked IS NULL
  AND t0.is_apartment = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.api_identifier AS api_identifier_3, t0.name AS name_4, t0.group_name AS group_name_5, t0.brand_name AS brand_name_6, t0.owner_name AS owner_name_7, t0.pms_name AS pms_name_8, t0.pms_version AS pms_version_9, t0.enabled AS enabled_10, t0.standard AS standard_11, t0.rooms AS rooms_12, t0.coordinates AS coordinates_13, t0.inactive_rooms AS inactive_rooms_14, t0.object_type AS object_type_15, t0.checked AS checked_16, t0.approved_by_klips AS approved_by_klips_17, t0.address_manual_content AS address_manual_content_18, t0.klips_access_to_view AS klips_access_to_view_19, t0.reports_currency AS reports_currency_20, t0.convert_ratio_eur AS convert_ratio_eur_21, t0.convert_ratio_usd AS convert_ratio_usd_22, t0.blocked_status AS blocked_status_23, t0.account_type AS account_type_24, t0.account_premium_deadline AS account_premium_deadline_25, t0.invited_by AS invited_by_26, t0.invite_validated AS invite_validated_27, t0.invite_validated_date AS invite_validated_date_28, t0.invite_used AS invite_used_29, t0.google_places_id AS google_places_id_30, t0.booking_id AS booking_id_31, t0.tripadvisor_id AS tripadvisor_id_32, t0.facebook_id AS facebook_id_33, t0.trustmate_id AS trustmate_id_34, t0.is_apartment AS is_apartment_35, t0.short_name AS short_name_36, t0.unlocked_reports_till AS unlocked_reports_till_37, t0.unlocked_future_reports_till AS unlocked_future_reports_till_38, t0.excluded_from_comparison AS excluded_from_comparison_39, t0.system_report_last_checked_date AS system_report_last_checked_date_40, t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41, t0.daily_report_checkin_from AS daily_report_checkin_from_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t45.id AS id_46, t45.continent AS continent_47, t45.country AS country_48, t45.pna AS pna_49, t45.province AS province_50, t45.city AS city_51, t45.street AS street_52, t45.street_number AS street_number_53, t45.hotel_id AS hotel_id_54, t55.id AS id_56, t55.company_name AS company_name_57, t55.first_name AS first_name_58, t55.last_name AS last_name_59, t55.job_name AS job_name_60, t55.phone AS phone_61, t55.email AS email_62, t55.address AS address_63, t55.tax_vat AS tax_vat_64, t55.nip AS nip_65, t55.zip_code AS zip_code_66, t55.city AS city_67, t55.hotel_id AS hotel_id_68, t0.street_id AS street_id_69, t0.klips_seller_id AS klips_seller_id_70, t0.hotels_networks_id AS hotels_networks_id_71, t0.hotels_network_agreement_id AS hotels_network_agreement_id_72, t0.network_id AS network_id_73, t0.network_agreement_id AS network_agreement_id_74, t0.virtual_city_id AS virtual_city_id_75, t0.apartments_clusters_id AS apartments_clusters_id_76, t77.id AS id_78, t77.created_at AS created_at_79, t77.updated_at AS updated_at_80, t77.hotel_id AS hotel_id_81, t77.apartments_clusters_id AS apartments_clusters_id_82 FROM hotels t0 LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id WHERE t0.checked IS NULL AND t0.is_apartment = 0;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.api_identifier AS api_identifier_3,
  t0.name AS name_4,
  t0.group_name AS group_name_5,
  t0.brand_name AS brand_name_6,
  t0.owner_name AS owner_name_7,
  t0.pms_name AS pms_name_8,
  t0.pms_version AS pms_version_9,
  t0.enabled AS enabled_10,
  t0.standard AS standard_11,
  t0.rooms AS rooms_12,
  t0.coordinates AS coordinates_13,
  t0.inactive_rooms AS inactive_rooms_14,
  t0.object_type AS object_type_15,
  t0.checked AS checked_16,
  t0.approved_by_klips AS approved_by_klips_17,
  t0.address_manual_content AS address_manual_content_18,
  t0.klips_access_to_view AS klips_access_to_view_19,
  t0.reports_currency AS reports_currency_20,
  t0.convert_ratio_eur AS convert_ratio_eur_21,
  t0.convert_ratio_usd AS convert_ratio_usd_22,
  t0.blocked_status AS blocked_status_23,
  t0.account_type AS account_type_24,
  t0.account_premium_deadline AS account_premium_deadline_25,
  t0.invited_by AS invited_by_26,
  t0.invite_validated AS invite_validated_27,
  t0.invite_validated_date AS invite_validated_date_28,
  t0.invite_used AS invite_used_29,
  t0.google_places_id AS google_places_id_30,
  t0.booking_id AS booking_id_31,
  t0.tripadvisor_id AS tripadvisor_id_32,
  t0.facebook_id AS facebook_id_33,
  t0.trustmate_id AS trustmate_id_34,
  t0.is_apartment AS is_apartment_35,
  t0.short_name AS short_name_36,
  t0.unlocked_reports_till AS unlocked_reports_till_37,
  t0.unlocked_future_reports_till AS unlocked_future_reports_till_38,
  t0.excluded_from_comparison AS excluded_from_comparison_39,
  t0.system_report_last_checked_date AS system_report_last_checked_date_40,
  t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41,
  t0.daily_report_checkin_from AS daily_report_checkin_from_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t45.id AS id_46,
  t45.continent AS continent_47,
  t45.country AS country_48,
  t45.pna AS pna_49,
  t45.province AS province_50,
  t45.city AS city_51,
  t45.street AS street_52,
  t45.street_number AS street_number_53,
  t45.hotel_id AS hotel_id_54,
  t55.id AS id_56,
  t55.company_name AS company_name_57,
  t55.first_name AS first_name_58,
  t55.last_name AS last_name_59,
  t55.job_name AS job_name_60,
  t55.phone AS phone_61,
  t55.email AS email_62,
  t55.address AS address_63,
  t55.tax_vat AS tax_vat_64,
  t55.nip AS nip_65,
  t55.zip_code AS zip_code_66,
  t55.city AS city_67,
  t55.hotel_id AS hotel_id_68,
  t0.street_id AS street_id_69,
  t0.klips_seller_id AS klips_seller_id_70,
  t0.hotels_networks_id AS hotels_networks_id_71,
  t0.hotels_network_agreement_id AS hotels_network_agreement_id_72,
  t0.network_id AS network_id_73,
  t0.network_agreement_id AS network_agreement_id_74,
  t0.virtual_city_id AS virtual_city_id_75,
  t0.apartments_clusters_id AS apartments_clusters_id_76,
  t77.id AS id_78,
  t77.created_at AS created_at_79,
  t77.updated_at AS updated_at_80,
  t77.hotel_id AS hotel_id_81,
  t77.apartments_clusters_id AS apartments_clusters_id_82
FROM
  hotels t0
  LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id
  LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id
  LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id
WHERE
  t0.checked IS NULL
  AND t0.is_apartment = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.api_identifier AS api_identifier_3, t0.name AS name_4, t0.group_name AS group_name_5, t0.brand_name AS brand_name_6, t0.owner_name AS owner_name_7, t0.pms_name AS pms_name_8, t0.pms_version AS pms_version_9, t0.enabled AS enabled_10, t0.standard AS standard_11, t0.rooms AS rooms_12, t0.coordinates AS coordinates_13, t0.inactive_rooms AS inactive_rooms_14, t0.object_type AS object_type_15, t0.checked AS checked_16, t0.approved_by_klips AS approved_by_klips_17, t0.address_manual_content AS address_manual_content_18, t0.klips_access_to_view AS klips_access_to_view_19, t0.reports_currency AS reports_currency_20, t0.convert_ratio_eur AS convert_ratio_eur_21, t0.convert_ratio_usd AS convert_ratio_usd_22, t0.blocked_status AS blocked_status_23, t0.account_type AS account_type_24, t0.account_premium_deadline AS account_premium_deadline_25, t0.invited_by AS invited_by_26, t0.invite_validated AS invite_validated_27, t0.invite_validated_date AS invite_validated_date_28, t0.invite_used AS invite_used_29, t0.google_places_id AS google_places_id_30, t0.booking_id AS booking_id_31, t0.tripadvisor_id AS tripadvisor_id_32, t0.facebook_id AS facebook_id_33, t0.trustmate_id AS trustmate_id_34, t0.is_apartment AS is_apartment_35, t0.short_name AS short_name_36, t0.unlocked_reports_till AS unlocked_reports_till_37, t0.unlocked_future_reports_till AS unlocked_future_reports_till_38, t0.excluded_from_comparison AS excluded_from_comparison_39, t0.system_report_last_checked_date AS system_report_last_checked_date_40, t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41, t0.daily_report_checkin_from AS daily_report_checkin_from_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t45.id AS id_46, t45.continent AS continent_47, t45.country AS country_48, t45.pna AS pna_49, t45.province AS province_50, t45.city AS city_51, t45.street AS street_52, t45.street_number AS street_number_53, t45.hotel_id AS hotel_id_54, t55.id AS id_56, t55.company_name AS company_name_57, t55.first_name AS first_name_58, t55.last_name AS last_name_59, t55.job_name AS job_name_60, t55.phone AS phone_61, t55.email AS email_62, t55.address AS address_63, t55.tax_vat AS tax_vat_64, t55.nip AS nip_65, t55.zip_code AS zip_code_66, t55.city AS city_67, t55.hotel_id AS hotel_id_68, t0.street_id AS street_id_69, t0.klips_seller_id AS klips_seller_id_70, t0.hotels_networks_id AS hotels_networks_id_71, t0.hotels_network_agreement_id AS hotels_network_agreement_id_72, t0.network_id AS network_id_73, t0.network_agreement_id AS network_agreement_id_74, t0.virtual_city_id AS virtual_city_id_75, t0.apartments_clusters_id AS apartments_clusters_id_76, t77.id AS id_78, t77.created_at AS created_at_79, t77.updated_at AS updated_at_80, t77.hotel_id AS hotel_id_81, t77.apartments_clusters_id AS apartments_clusters_id_82 FROM hotels t0 LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id WHERE t0.checked IS NULL AND t0.is_apartment = 0;

SELECT
  t0.id AS id_1,
  t0.parameter_key AS parameter_key_2,
  t0.name AS name_3,
  t0.category AS category_4,
  t0.description AS description_5,
  t0.value AS value_6,
  t0.type AS type_7,
  t0.rte AS rte_8
FROM
  core_system_parameters t0
WHERE
  t0.parameter_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.name AS name_3, t0.category AS category_4, t0.description AS description_5, t0.value AS value_6, t0.type AS type_7, t0.rte AS rte_8 FROM core_system_parameters t0 WHERE t0.parameter_key = 'compilation' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.counted_hotels AS counted_hotels_3,
  t0.indicator_occ AS indicator_occ_4,
  t0.indicator_adr AS indicator_adr_5,
  t0.indicator_rev_par AS indicator_rev_par_6,
  t0.indicator_dof AS indicator_dof_7,
  t0.indicator_demand AS indicator_demand_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  report_frontend_cache t0
WHERE
  t0.day = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.day AS day_2, t0.counted_hotels AS counted_hotels_3, t0.indicator_occ AS indicator_occ_4, t0.indicator_adr AS indicator_adr_5, t0.indicator_rev_par AS indicator_rev_par_6, t0.indicator_dof AS indicator_dof_7, t0.indicator_demand AS indicator_demand_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM report_frontend_cache t0 WHERE t0.day = '2025-12-05' LIMIT 1;