GET https://stephen-nurse.com/houseguests/index/Active

Query Metrics

112 Database Queries
18 Different statements
122.79 ms Query time
0 Invalid entities
78 Managed entities

Queries

Group similar statements

# Time Info
1 7.13 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = ? LIMIT 1
Parameters:
[
  "en"
]
2 5.60 ms
SELECT t0.id AS id_1, t0.flight_stats_days AS flight_stats_days_2, t0.flight_stats_start_date AS flight_stats_start_date_3, t0.investment_date AS investment_date_4, t0.flight_stats_return_leg_offset AS flight_stats_return_leg_offset_5, t0.last_outlook_download AS last_outlook_download_6, t0.uk_days_start_date AS uk_days_start_date_7 FROM settings t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
3 5.94 ms
"START TRANSACTION"
Parameters:
[]
4 0.55 ms
UPDATE settings SET flight_stats_start_date = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1
]
5 0.11 ms
"COMMIT"
Parameters:
[]
6 0.57 ms
SELECT t0.id AS id_1, t0.admin_only AS admin_only_2, t0.is_active AS is_active_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.last_scraped AS last_scraped_6, t0.return_leg AS return_leg_7, t0.grouping_x AS grouping_x_8, t0.departure_city_id AS departure_city_id_9, t0.arrival_city_id AS arrival_city_id_10 FROM flight_destinations t0
Parameters:
[]
7 5.43 ms
"START TRANSACTION"
Parameters:
[]
8 0.79 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1819
]
9 4.81 ms
"COMMIT"
Parameters:
[]
10 0.14 ms
"START TRANSACTION"
Parameters:
[]
11 0.56 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1819
]
12 3.00 ms
"COMMIT"
Parameters:
[]
13 0.09 ms
"START TRANSACTION"
Parameters:
[]
14 0.50 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1820
]
15 1.24 ms
"COMMIT"
Parameters:
[]
16 0.09 ms
"START TRANSACTION"
Parameters:
[]
17 0.36 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1820
]
18 2.05 ms
"COMMIT"
Parameters:
[]
19 0.10 ms
"START TRANSACTION"
Parameters:
[]
20 0.38 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1821
]
21 1.16 ms
"COMMIT"
Parameters:
[]
22 0.11 ms
"START TRANSACTION"
Parameters:
[]
23 0.30 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1821
]
24 1.09 ms
"COMMIT"
Parameters:
[]
25 0.08 ms
"START TRANSACTION"
Parameters:
[]
26 0.25 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1834
]
27 1.11 ms
"COMMIT"
Parameters:
[]
28 0.13 ms
"START TRANSACTION"
Parameters:
[]
29 0.27 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1834
]
30 1.57 ms
"COMMIT"
Parameters:
[]
31 0.09 ms
"START TRANSACTION"
Parameters:
[]
32 0.34 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1838
]
33 1.22 ms
"COMMIT"
Parameters:
[]
34 0.09 ms
"START TRANSACTION"
Parameters:
[]
35 0.31 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1838
]
36 1.12 ms
"COMMIT"
Parameters:
[]
37 0.08 ms
"START TRANSACTION"
Parameters:
[]
38 0.26 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1839
]
39 1.12 ms
"COMMIT"
Parameters:
[]
40 0.08 ms
"START TRANSACTION"
Parameters:
[]
41 0.26 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1839
]
42 1.05 ms
"COMMIT"
Parameters:
[]
43 0.07 ms
"START TRANSACTION"
Parameters:
[]
44 0.28 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1840
]
45 1.06 ms
"COMMIT"
Parameters:
[]
46 0.08 ms
"START TRANSACTION"
Parameters:
[]
47 0.25 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1840
]
48 1.60 ms
"COMMIT"
Parameters:
[]
49 0.08 ms
"START TRANSACTION"
Parameters:
[]
50 0.28 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1841
]
51 1.16 ms
"COMMIT"
Parameters:
[]
52 0.09 ms
"START TRANSACTION"
Parameters:
[]
53 0.23 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1846
]
54 1.39 ms
"COMMIT"
Parameters:
[]
55 0.08 ms
"START TRANSACTION"
Parameters:
[]
56 0.25 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1846
]
57 1.19 ms
"COMMIT"
Parameters:
[]
58 0.12 ms
"START TRANSACTION"
Parameters:
[]
59 0.26 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1847
]
60 3.13 ms
"COMMIT"
Parameters:
[]
61 0.16 ms
"START TRANSACTION"
Parameters:
[]
62 0.32 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1847
]
63 1.39 ms
"COMMIT"
Parameters:
[]
64 0.07 ms
"START TRANSACTION"
Parameters:
[]
65 0.27 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1848
]
66 0.97 ms
"COMMIT"
Parameters:
[]
67 0.09 ms
"START TRANSACTION"
Parameters:
[]
68 0.27 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1848
]
69 1.36 ms
"COMMIT"
Parameters:
[]
70 0.07 ms
"START TRANSACTION"
Parameters:
[]
71 0.24 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1849
]
72 0.98 ms
"COMMIT"
Parameters:
[]
73 0.07 ms
"START TRANSACTION"
Parameters:
[]
74 0.25 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1850
]
75 0.93 ms
"COMMIT"
Parameters:
[]
76 0.15 ms
"START TRANSACTION"
Parameters:
[]
77 0.24 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1850
]
78 1.02 ms
"COMMIT"
Parameters:
[]
79 0.07 ms
"START TRANSACTION"
Parameters:
[]
80 0.24 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1851
]
81 0.95 ms
"COMMIT"
Parameters:
[]
82 0.08 ms
"START TRANSACTION"
Parameters:
[]
83 0.25 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1851
]
84 1.37 ms
"COMMIT"
Parameters:
[]
85 0.07 ms
"START TRANSACTION"
Parameters:
[]
86 0.27 ms
UPDATE flight_destinations SET date_start = ? WHERE id = ?
Parameters:
[
  "2025-12-11"
  1852
]
87 1.00 ms
"COMMIT"
Parameters:
[]
88 0.08 ms
"START TRANSACTION"
Parameters:
[]
89 0.29 ms
UPDATE flight_destinations SET date_end = ? WHERE id = ?
Parameters:
[
  "2025-12-12"
  1852
]
90 1.31 ms
"COMMIT"
Parameters:
[]
91 0.36 ms
SELECT t0.id AS id_1, t0.admin_only AS admin_only_2, t0.is_active AS is_active_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.last_scraped AS last_scraped_6, t0.return_leg AS return_leg_7, t0.grouping_x AS grouping_x_8, t0.departure_city_id AS departure_city_id_9, t0.arrival_city_id AS arrival_city_id_10 FROM flight_destinations t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
92 1.46 ms
SELECT t0.id AS id_1, t0.date_arrival AS date_arrival_2, t0.notes AS notes_3, t0.date_departure AS date_departure_4, t0.departure_notes AS departure_notes_5, t0.arrival_notes AS arrival_notes_6, t0.flight_from_london AS flight_from_london_7, t0.flight_to_london AS flight_to_london_8, t0.reference_information AS reference_information_9, t0.guest_name_id AS guest_name_id_10 FROM house_guests t0
Parameters:
[]
93 2.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.lowest_price AS lowest_price_3, t0.scrape_date AS scrape_date_4, t0.destination_id_id AS destination_id_id_5 FROM flight_stats t0
Parameters:
[]
94 5.14 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_qr_code AS company_qr_code_26, t0.footer_display_products AS footer_display_products_27, t0.footer_display_social_media AS footer_display_social_media_28, t0.header_display_login AS header_display_login_29, t0.contact_first_name AS contact_first_name_30, t0.contact_last_name AS contact_last_name_31, t0.home_page_photos_only AS home_page_photos_only_32, t0.database_password AS database_password_33, t0.sql_database AS sql_database_34, t0.header_display_tand_cs AS header_display_tand_cs_35, t0.header_display_products AS header_display_products_36, t0.header_display_sub_products AS header_display_sub_products_37, t0.footer_display_sub_products AS footer_display_sub_products_38, t0.include_contact_form_home_page AS include_contact_form_home_page_39, t0.multi_lingual AS multi_lingual_40, t0.enable_user_registration AS enable_user_registration_41, t0.include_qrcode_home_page AS include_qrcode_home_page_42, t0.header_display_contact_details AS header_display_contact_details_43, t0.header_display_business_contacts AS header_display_business_contacts_44, t0.header_display_weather AS header_display_weather_45, t0.header_display_facebook_pages AS header_display_facebook_pages_46, t0.header_display_competitors AS header_display_competitors_47, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_48, t0.title_useful_links AS title_useful_links_49, t0.header_display_photos AS header_display_photos_50, t0.title_products AS title_products_51, t0.title_sub_products AS title_sub_products_52, t0.company_address_map_link AS company_address_map_link_53, t0.company_address_instructions AS company_address_instructions_54, t0.registration_email AS registration_email_55, t0.user_include_home_address AS user_include_home_address_56, t0.user_include_business_address AS user_include_business_address_57, t0.user_include_personal_details AS user_include_personal_details_58, t0.user_include_job_details AS user_include_job_details_59, t0.website_contacts_auto_reply AS website_contacts_auto_reply_60, t0.contact_from_response AS contact_from_response_61, t0.default_user_password AS default_user_password_62, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_63, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_64, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_65, t0.user_import_divert_competitor AS user_import_divert_competitor_66, t0.user_import_divert_target_partner AS user_import_divert_target_partner_67, t0.photo_locations_sort AS photo_locations_sort_68, t0.testing_mode AS testing_mode_69, t0.header_display_useful_links AS header_display_useful_links_70, t0.contact_details_display_address AS contact_details_display_address_71, t0.contact_details_display_tel_numbers AS contact_details_display_tel_numbers_72, t0.contact_details_display_company_vcf AS contact_details_display_company_vcf_73, t0.footer_display_contact_details AS footer_display_contact_details_74, t0.contact_form_include_tel_number AS contact_form_include_tel_number_75, t0.contact_form_include_message AS contact_form_include_message_76, t0.auto_login_available AS auto_login_available_77, t0.registration_user_notes AS registration_user_notes_78, t0.header_display_products_logged_in AS header_display_products_logged_in_79, t0.header_display_sub_products_logged_in AS header_display_sub_products_logged_in_80, t0.header_display_photos_logged_in AS header_display_photos_logged_in_81, t0.competitor_outreach_email AS competitor_outreach_email_82, t0.competitor_outreach_email_subject AS competitor_outreach_email_subject_83, t0.header_display_team_bios AS header_display_team_bios_84, t0.weather_last_scraped AS weather_last_scraped_85 FROM company_details t0 WHERE t0.id = ?
Parameters:
[
  1
]
95 8.44 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.mobile AS mobile_4, t0.notes AS notes_5, t0.date_time AS date_time_6, t0.email AS email_7, t0.status AS status_8, t0.date_responded AS date_responded_9 FROM website_contacts t0 WHERE t0.status = ?
Parameters:
[
  "Pending"
]
96 0.74 ms
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.include_in_helpful_guide AS include_in_helpful_guide_12, t0.helpful_guide_topic AS helpful_guide_topic_13 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC
Parameters:
[
  "Main"
  1
]
97 0.89 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
98 1.51 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  16
]
99 0.61 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
100 1.84 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
101 0.41 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
102 0.40 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  17
]
103 0.38 ms
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.include_in_helpful_guide AS include_in_helpful_guide_12, t0.helpful_guide_topic AS helpful_guide_topic_13 FROM product t0 WHERE t0.category = ? ORDER BY t0.ranking ASC
Parameters:
[
  "Sub"
]
104 0.34 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
105 0.29 ms
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
106 1.30 ms
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
  "Public"
]
107 2.77 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
  2
]
108 1.74 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
  20
]
109 3.06 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
  3
]
110 3.47 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
  21
]
111 3.34 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
  30
]
112 4.17 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\CmsCopy 27
App\Entity\FlightDestinations 15
App\Entity\Product 13
App\Entity\Airports 6
App\Entity\FlightStats 4
App\Entity\Country 4
App\Entity\PhotoLocations 3
App\Entity\HouseGuests 2
App\Entity\Languages 1
App\Entity\Settings 1
App\Entity\CompanyDetails 1
App\Entity\CmsCopyPageFormats 1

Entities Mapping