Error 500 Internal Server Error

GET https://immigrationservices.atts-systems.com/weather/weather/fetch_weather_data_hourly

Forwarded to ErrorController (c5d1d4)

Query Metrics

147 Database Queries
6 Different statements
131.33 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 12.50 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 3.01 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 FROM company_details t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 3.90 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.weather AS weather_4, t0.location AS location_5, t0.rain AS rain_6 FROM weather t0
Parameters:
[]
4 0.20 ms
"START TRANSACTION"
Parameters:
[]
5 0.92 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 07:00:00"
  7
  "14.49"
  "Pathos"
  ""
]
6 2.54 ms
"COMMIT"
Parameters:
[]
7 0.14 ms
"START TRANSACTION"
Parameters:
[]
8 0.50 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 08:00:00"
  8
  "13.83"
  "Pathos"
  ""
]
9 1.83 ms
"COMMIT"
Parameters:
[]
10 0.15 ms
"START TRANSACTION"
Parameters:
[]
11 0.39 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 09:00:00"
  9
  "14.8"
  "Pathos"
  ""
]
12 1.38 ms
"COMMIT"
Parameters:
[]
13 0.28 ms
"START TRANSACTION"
Parameters:
[]
14 0.39 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 10:00:00"
  10
  "16"
  "Pathos"
  ""
]
15 1.59 ms
"COMMIT"
Parameters:
[]
16 0.16 ms
"START TRANSACTION"
Parameters:
[]
17 0.42 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 11:00:00"
  11
  "17.36"
  "Pathos"
  "0.1"
]
18 1.33 ms
"COMMIT"
Parameters:
[]
19 0.85 ms
"START TRANSACTION"
Parameters:
[]
20 0.96 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 12:00:00"
  12
  "18.69"
  "Pathos"
  "0.13"
]
21 1.76 ms
"COMMIT"
Parameters:
[]
22 0.29 ms
"START TRANSACTION"
Parameters:
[]
23 0.41 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 13:00:00"
  13
  "20.1"
  "Pathos"
  "0.18"
]
24 1.51 ms
"COMMIT"
Parameters:
[]
25 0.13 ms
"START TRANSACTION"
Parameters:
[]
26 0.43 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 14:00:00"
  14
  "21.14"
  "Pathos"
  "0.22"
]
27 2.73 ms
"COMMIT"
Parameters:
[]
28 0.11 ms
"START TRANSACTION"
Parameters:
[]
29 0.38 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 15:00:00"
  15
  "19.76"
  "Pathos"
  "0.15"
]
30 1.69 ms
"COMMIT"
Parameters:
[]
31 0.11 ms
"START TRANSACTION"
Parameters:
[]
32 0.36 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 16:00:00"
  16
  "19.63"
  "Pathos"
  ""
]
33 2.03 ms
"COMMIT"
Parameters:
[]
34 0.14 ms
"START TRANSACTION"
Parameters:
[]
35 0.32 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 17:00:00"
  17
  "18.06"
  "Pathos"
  ""
]
36 1.26 ms
"COMMIT"
Parameters:
[]
37 0.17 ms
"START TRANSACTION"
Parameters:
[]
38 0.32 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 18:00:00"
  18
  "17.05"
  "Pathos"
  ""
]
39 1.11 ms
"COMMIT"
Parameters:
[]
40 0.12 ms
"START TRANSACTION"
Parameters:
[]
41 0.29 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 19:00:00"
  19
  "16.38"
  "Pathos"
  ""
]
42 1.06 ms
"COMMIT"
Parameters:
[]
43 0.12 ms
"START TRANSACTION"
Parameters:
[]
44 0.29 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 20:00:00"
  20
  "19.11"
  "Pathos"
  ""
]
45 0.98 ms
"COMMIT"
Parameters:
[]
46 0.24 ms
"START TRANSACTION"
Parameters:
[]
47 0.31 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 21:00:00"
  21
  "18.95"
  "Pathos"
  ""
]
48 1.05 ms
"COMMIT"
Parameters:
[]
49 0.13 ms
"START TRANSACTION"
Parameters:
[]
50 0.28 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 22:00:00"
  22
  "18.77"
  "Pathos"
  ""
]
51 1.05 ms
"COMMIT"
Parameters:
[]
52 0.12 ms
"START TRANSACTION"
Parameters:
[]
53 0.29 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-26 23:00:00"
  23
  "18.59"
  "Pathos"
  ""
]
54 1.03 ms
"COMMIT"
Parameters:
[]
55 0.17 ms
"START TRANSACTION"
Parameters:
[]
56 0.28 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 00:00:00"
  0
  "18.44"
  "Pathos"
  ""
]
57 1.29 ms
"COMMIT"
Parameters:
[]
58 0.15 ms
"START TRANSACTION"
Parameters:
[]
59 0.30 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 01:00:00"
  1
  "18.21"
  "Pathos"
  ""
]
60 2.28 ms
"COMMIT"
Parameters:
[]
61 0.92 ms
"START TRANSACTION"
Parameters:
[]
62 0.72 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 02:00:00"
  2
  "18"
  "Pathos"
  ""
]
63 1.69 ms
"COMMIT"
Parameters:
[]
64 0.12 ms
"START TRANSACTION"
Parameters:
[]
65 0.37 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 03:00:00"
  3
  "17.78"
  "Pathos"
  ""
]
66 0.95 ms
"COMMIT"
Parameters:
[]
67 0.11 ms
"START TRANSACTION"
Parameters:
[]
68 0.35 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 04:00:00"
  4
  "17.66"
  "Pathos"
  "0.15"
]
69 1.56 ms
"COMMIT"
Parameters:
[]
70 0.11 ms
"START TRANSACTION"
Parameters:
[]
71 0.42 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 05:00:00"
  5
  "17.6"
  "Pathos"
  ""
]
72 1.60 ms
"COMMIT"
Parameters:
[]
73 0.22 ms
"START TRANSACTION"
Parameters:
[]
74 0.33 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 06:00:00"
  6
  "17.54"
  "Pathos"
  "0.11"
]
75 1.24 ms
"COMMIT"
Parameters:
[]
76 0.27 ms
"START TRANSACTION"
Parameters:
[]
77 0.44 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 07:00:00"
  7
  "17.65"
  "Pathos"
  ""
]
78 1.65 ms
"COMMIT"
Parameters:
[]
79 0.49 ms
"START TRANSACTION"
Parameters:
[]
80 1.09 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 08:00:00"
  8
  "18.41"
  "Pathos"
  ""
]
81 1.57 ms
"COMMIT"
Parameters:
[]
82 0.10 ms
"START TRANSACTION"
Parameters:
[]
83 0.35 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 09:00:00"
  9
  "19.09"
  "Pathos"
  ""
]
84 1.17 ms
"COMMIT"
Parameters:
[]
85 0.11 ms
"START TRANSACTION"
Parameters:
[]
86 0.31 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 10:00:00"
  10
  "19.86"
  "Pathos"
  ""
]
87 1.23 ms
"COMMIT"
Parameters:
[]
88 0.11 ms
"START TRANSACTION"
Parameters:
[]
89 0.30 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 11:00:00"
  11
  "20.64"
  "Pathos"
  ""
]
90 1.72 ms
"COMMIT"
Parameters:
[]
91 0.11 ms
"START TRANSACTION"
Parameters:
[]
92 0.28 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 12:00:00"
  12
  "21.21"
  "Pathos"
  ""
]
93 1.16 ms
"COMMIT"
Parameters:
[]
94 0.13 ms
"START TRANSACTION"
Parameters:
[]
95 0.29 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 13:00:00"
  13
  "21.5"
  "Pathos"
  ""
]
96 1.50 ms
"COMMIT"
Parameters:
[]
97 0.11 ms
"START TRANSACTION"
Parameters:
[]
98 0.29 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 14:00:00"
  14
  "21.44"
  "Pathos"
  ""
]
99 1.13 ms
"COMMIT"
Parameters:
[]
100 0.22 ms
"START TRANSACTION"
Parameters:
[]
101 0.44 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 15:00:00"
  15
  "21.15"
  "Pathos"
  ""
]
102 2.46 ms
"COMMIT"
Parameters:
[]
103 0.52 ms
"START TRANSACTION"
Parameters:
[]
104 0.53 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 16:00:00"
  16
  "20.83"
  "Pathos"
  ""
]
105 1.10 ms
"COMMIT"
Parameters:
[]
106 0.87 ms
"START TRANSACTION"
Parameters:
[]
107 0.84 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 17:00:00"
  17
  "20.12"
  "Pathos"
  ""
]
108 1.32 ms
"COMMIT"
Parameters:
[]
109 0.73 ms
"START TRANSACTION"
Parameters:
[]
110 0.94 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 18:00:00"
  18
  "19.84"
  "Pathos"
  ""
]
111 1.47 ms
"COMMIT"
Parameters:
[]
112 0.43 ms
"START TRANSACTION"
Parameters:
[]
113 1.03 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 19:00:00"
  19
  "19.73"
  "Pathos"
  ""
]
114 1.39 ms
"COMMIT"
Parameters:
[]
115 0.61 ms
"START TRANSACTION"
Parameters:
[]
116 0.93 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 20:00:00"
  20
  "19.63"
  "Pathos"
  ""
]
117 1.22 ms
"COMMIT"
Parameters:
[]
118 0.74 ms
"START TRANSACTION"
Parameters:
[]
119 0.79 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 21:00:00"
  21
  "19.53"
  "Pathos"
  ""
]
120 1.25 ms
"COMMIT"
Parameters:
[]
121 1.04 ms
"START TRANSACTION"
Parameters:
[]
122 0.47 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 22:00:00"
  22
  "19.33"
  "Pathos"
  ""
]
123 1.28 ms
"COMMIT"
Parameters:
[]
124 0.98 ms
"START TRANSACTION"
Parameters:
[]
125 0.50 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-27 23:00:00"
  23
  "19.12"
  "Pathos"
  ""
]
126 1.35 ms
"COMMIT"
Parameters:
[]
127 0.15 ms
"START TRANSACTION"
Parameters:
[]
128 0.49 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 00:00:00"
  0
  "18.79"
  "Pathos"
  ""
]
129 1.27 ms
"COMMIT"
Parameters:
[]
130 0.83 ms
"START TRANSACTION"
Parameters:
[]
131 0.85 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 01:00:00"
  1
  "18.54"
  "Pathos"
  ""
]
132 1.82 ms
"COMMIT"
Parameters:
[]
133 0.28 ms
"START TRANSACTION"
Parameters:
[]
134 1.07 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 02:00:00"
  2
  "18.46"
  "Pathos"
  ""
]
135 1.29 ms
"COMMIT"
Parameters:
[]
136 0.78 ms
"START TRANSACTION"
Parameters:
[]
137 0.78 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 03:00:00"
  3
  "18.37"
  "Pathos"
  ""
]
138 1.82 ms
"COMMIT"
Parameters:
[]
139 0.34 ms
"START TRANSACTION"
Parameters:
[]
140 0.80 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 04:00:00"
  4
  "18.28"
  "Pathos"
  ""
]
141 1.84 ms
"COMMIT"
Parameters:
[]
142 0.23 ms
"START TRANSACTION"
Parameters:
[]
143 0.83 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 05:00:00"
  5
  "18.15"
  "Pathos"
  ""
]
144 1.43 ms
"COMMIT"
Parameters:
[]
145 0.14 ms
"START TRANSACTION"
Parameters:
[]
146 0.39 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2025-11-28 06:00:00"
  6
  "18.28"
  "Pathos"
  ""
]
147 1.32 ms
"COMMIT"
Parameters:
[]

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\Weather 48
App\Entity\Languages 1
App\Entity\CompanyDetails 1

Entities Mapping

Class Mapping errors
App\Entity\Languages No errors.
App\Entity\CompanyDetails No errors.
App\Entity\Weather No errors.