GET https://aphroditewintercashcup.atts-systems.com/weather/index?date=2026-08-19

Query Metrics

297 Database Queries
10 Different statements
791.35 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 2.81 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 4.79 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, t0.vcf_photo AS vcf_photo_86 FROM company_details t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
3 0.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.15 ms
"START TRANSACTION"
Parameters:
[]
5 0.85 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91409
]
6 1.86 ms
"COMMIT"
Parameters:
[]
7 0.12 ms
"START TRANSACTION"
Parameters:
[]
8 0.35 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91410
]
9 1.42 ms
"COMMIT"
Parameters:
[]
10 6.11 ms
"START TRANSACTION"
Parameters:
[]
11 0.33 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91411
]
12 1.35 ms
"COMMIT"
Parameters:
[]
13 0.09 ms
"START TRANSACTION"
Parameters:
[]
14 0.22 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91412
]
15 1.22 ms
"COMMIT"
Parameters:
[]
16 0.16 ms
"START TRANSACTION"
Parameters:
[]
17 0.28 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91413
]
18 1.55 ms
"COMMIT"
Parameters:
[]
19 1.50 ms
"START TRANSACTION"
Parameters:
[]
20 0.30 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91414
]
21 6.26 ms
"COMMIT"
Parameters:
[]
22 3.80 ms
"START TRANSACTION"
Parameters:
[]
23 0.64 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91415
]
24 2.20 ms
"COMMIT"
Parameters:
[]
25 0.38 ms
"START TRANSACTION"
Parameters:
[]
26 0.40 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91416
]
27 3.20 ms
"COMMIT"
Parameters:
[]
28 0.12 ms
"START TRANSACTION"
Parameters:
[]
29 0.32 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91417
]
30 1.13 ms
"COMMIT"
Parameters:
[]
31 0.12 ms
"START TRANSACTION"
Parameters:
[]
32 0.93 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91418
]
33 1.33 ms
"COMMIT"
Parameters:
[]
34 0.38 ms
"START TRANSACTION"
Parameters:
[]
35 0.45 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91419
]
36 2.55 ms
"COMMIT"
Parameters:
[]
37 0.33 ms
"START TRANSACTION"
Parameters:
[]
38 1.04 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91420
]
39 1.46 ms
"COMMIT"
Parameters:
[]
40 0.27 ms
"START TRANSACTION"
Parameters:
[]
41 1.01 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91421
]
42 1.05 ms
"COMMIT"
Parameters:
[]
43 0.82 ms
"START TRANSACTION"
Parameters:
[]
44 1.01 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91422
]
45 2.11 ms
"COMMIT"
Parameters:
[]
46 0.79 ms
"START TRANSACTION"
Parameters:
[]
47 1.03 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91423
]
48 1.77 ms
"COMMIT"
Parameters:
[]
49 1.02 ms
"START TRANSACTION"
Parameters:
[]
50 1.04 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91424
]
51 12.60 ms
"COMMIT"
Parameters:
[]
52 0.67 ms
"START TRANSACTION"
Parameters:
[]
53 0.96 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91425
]
54 2.13 ms
"COMMIT"
Parameters:
[]
55 0.74 ms
"START TRANSACTION"
Parameters:
[]
56 0.98 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91426
]
57 2.10 ms
"COMMIT"
Parameters:
[]
58 0.77 ms
"START TRANSACTION"
Parameters:
[]
59 0.98 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91427
]
60 2.10 ms
"COMMIT"
Parameters:
[]
61 0.75 ms
"START TRANSACTION"
Parameters:
[]
62 0.98 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91428
]
63 2.08 ms
"COMMIT"
Parameters:
[]
64 0.70 ms
"START TRANSACTION"
Parameters:
[]
65 0.97 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91429
]
66 2.10 ms
"COMMIT"
Parameters:
[]
67 0.75 ms
"START TRANSACTION"
Parameters:
[]
68 0.96 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91430
]
69 2.09 ms
"COMMIT"
Parameters:
[]
70 0.84 ms
"START TRANSACTION"
Parameters:
[]
71 0.96 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91431
]
72 2.10 ms
"COMMIT"
Parameters:
[]
73 0.75 ms
"START TRANSACTION"
Parameters:
[]
74 0.97 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91432
]
75 2.10 ms
"COMMIT"
Parameters:
[]
76 0.76 ms
"START TRANSACTION"
Parameters:
[]
77 0.98 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91433
]
78 3.04 ms
"COMMIT"
Parameters:
[]
79 15.26 ms
"START TRANSACTION"
Parameters:
[]
80 3.89 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91434
]
81 2.16 ms
"COMMIT"
Parameters:
[]
82 2.97 ms
"START TRANSACTION"
Parameters:
[]
83 0.99 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91435
]
84 2.04 ms
"COMMIT"
Parameters:
[]
85 2.93 ms
"START TRANSACTION"
Parameters:
[]
86 1.02 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91436
]
87 2.56 ms
"COMMIT"
Parameters:
[]
88 0.80 ms
"START TRANSACTION"
Parameters:
[]
89 4.07 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91437
]
90 2.16 ms
"COMMIT"
Parameters:
[]
91 3.96 ms
"START TRANSACTION"
Parameters:
[]
92 0.97 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91438
]
93 2.03 ms
"COMMIT"
Parameters:
[]
94 4.06 ms
"START TRANSACTION"
Parameters:
[]
95 4.15 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91439
]
96 2.12 ms
"COMMIT"
Parameters:
[]
97 6.17 ms
"START TRANSACTION"
Parameters:
[]
98 0.96 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91440
]
99 2.03 ms
"COMMIT"
Parameters:
[]
100 3.99 ms
"START TRANSACTION"
Parameters:
[]
101 2.00 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91441
]
102 1.02 ms
"COMMIT"
Parameters:
[]
103 6.70 ms
"START TRANSACTION"
Parameters:
[]
104 2.25 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91442
]
105 2.26 ms
"COMMIT"
Parameters:
[]
106 4.03 ms
"START TRANSACTION"
Parameters:
[]
107 1.22 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91443
]
108 2.17 ms
"COMMIT"
Parameters:
[]
109 4.02 ms
"START TRANSACTION"
Parameters:
[]
110 2.96 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91444
]
111 2.23 ms
"COMMIT"
Parameters:
[]
112 5.13 ms
"START TRANSACTION"
Parameters:
[]
113 2.11 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91445
]
114 2.09 ms
"COMMIT"
Parameters:
[]
115 4.01 ms
"START TRANSACTION"
Parameters:
[]
116 1.24 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91446
]
117 1.95 ms
"COMMIT"
Parameters:
[]
118 4.07 ms
"START TRANSACTION"
Parameters:
[]
119 1.74 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91447
]
120 1.61 ms
"COMMIT"
Parameters:
[]
121 5.76 ms
"START TRANSACTION"
Parameters:
[]
122 1.99 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91448
]
123 2.19 ms
"COMMIT"
Parameters:
[]
124 10.20 ms
"START TRANSACTION"
Parameters:
[]
125 1.96 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91449
]
126 2.09 ms
"COMMIT"
Parameters:
[]
127 2.94 ms
"START TRANSACTION"
Parameters:
[]
128 1.00 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91450
]
129 2.04 ms
"COMMIT"
Parameters:
[]
130 0.85 ms
"START TRANSACTION"
Parameters:
[]
131 1.00 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91451
]
132 2.12 ms
"COMMIT"
Parameters:
[]
133 0.87 ms
"START TRANSACTION"
Parameters:
[]
134 3.13 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91452
]
135 2.10 ms
"COMMIT"
Parameters:
[]
136 1.95 ms
"START TRANSACTION"
Parameters:
[]
137 2.10 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91453
]
138 2.12 ms
"COMMIT"
Parameters:
[]
139 0.88 ms
"START TRANSACTION"
Parameters:
[]
140 0.86 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91454
]
141 1.71 ms
"COMMIT"
Parameters:
[]
142 2.10 ms
"START TRANSACTION"
Parameters:
[]
143 5.58 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91455
]
144 4.20 ms
"COMMIT"
Parameters:
[]
145 6.15 ms
"START TRANSACTION"
Parameters:
[]
146 1.97 ms
DELETE FROM weather WHERE id = ?
Parameters:
[
  91456
]
147 1.03 ms
"COMMIT"
Parameters:
[]
148 3.98 ms
"START TRANSACTION"
Parameters:
[]
149 2.94 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 03:00:00"
  3
  "24.4"
  "Kouklia"
  ""
]
150 2.07 ms
"COMMIT"
Parameters:
[]
151 0.81 ms
"START TRANSACTION"
Parameters:
[]
152 1.04 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 04:00:00"
  4
  "24.34"
  "Kouklia"
  ""
]
153 2.15 ms
"COMMIT"
Parameters:
[]
154 8.08 ms
"START TRANSACTION"
Parameters:
[]
155 2.05 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 05:00:00"
  5
  "24.18"
  "Kouklia"
  ""
]
156 1.01 ms
"COMMIT"
Parameters:
[]
157 4.07 ms
"START TRANSACTION"
Parameters:
[]
158 3.01 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 06:00:00"
  6
  "23.99"
  "Kouklia"
  ""
]
159 2.08 ms
"COMMIT"
Parameters:
[]
160 4.01 ms
"START TRANSACTION"
Parameters:
[]
161 2.07 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 07:00:00"
  7
  "24.96"
  "Kouklia"
  ""
]
162 2.12 ms
"COMMIT"
Parameters:
[]
163 2.98 ms
"START TRANSACTION"
Parameters:
[]
164 0.63 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 08:00:00"
  8
  "26.87"
  "Kouklia"
  ""
]
165 1.38 ms
"COMMIT"
Parameters:
[]
166 6.20 ms
"START TRANSACTION"
Parameters:
[]
167 4.23 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 09:00:00"
  9
  "29.43"
  "Kouklia"
  ""
]
168 2.11 ms
"COMMIT"
Parameters:
[]
169 2.88 ms
"START TRANSACTION"
Parameters:
[]
170 1.01 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 10:00:00"
  10
  "29.78"
  "Kouklia"
  ""
]
171 2.13 ms
"COMMIT"
Parameters:
[]
172 5.14 ms
"START TRANSACTION"
Parameters:
[]
173 4.27 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 11:00:00"
  11
  "30.97"
  "Kouklia"
  ""
]
174 2.29 ms
"COMMIT"
Parameters:
[]
175 2.69 ms
"START TRANSACTION"
Parameters:
[]
176 1.86 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 12:00:00"
  12
  "31.4"
  "Kouklia"
  ""
]
177 1.57 ms
"COMMIT"
Parameters:
[]
178 9.40 ms
"START TRANSACTION"
Parameters:
[]
179 0.97 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 13:00:00"
  13
  "34.15"
  "Kouklia"
  ""
]
180 2.08 ms
"COMMIT"
Parameters:
[]
181 4.06 ms
"START TRANSACTION"
Parameters:
[]
182 3.12 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 14:00:00"
  14
  "34.43"
  "Kouklia"
  ""
]
183 2.09 ms
"COMMIT"
Parameters:
[]
184 6.15 ms
"START TRANSACTION"
Parameters:
[]
185 1.00 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 15:00:00"
  15
  "34.53"
  "Kouklia"
  ""
]
186 2.08 ms
"COMMIT"
Parameters:
[]
187 4.03 ms
"START TRANSACTION"
Parameters:
[]
188 2.06 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 16:00:00"
  16
  "34.81"
  "Kouklia"
  ""
]
189 2.09 ms
"COMMIT"
Parameters:
[]
190 6.16 ms
"START TRANSACTION"
Parameters:
[]
191 0.99 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 17:00:00"
  17
  "34.33"
  "Kouklia"
  ""
]
192 2.09 ms
"COMMIT"
Parameters:
[]
193 6.10 ms
"START TRANSACTION"
Parameters:
[]
194 0.99 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 18:00:00"
  18
  "33.27"
  "Kouklia"
  ""
]
195 2.98 ms
"COMMIT"
Parameters:
[]
196 9.20 ms
"START TRANSACTION"
Parameters:
[]
197 1.96 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 19:00:00"
  19
  "31.36"
  "Kouklia"
  ""
]
198 1.76 ms
"COMMIT"
Parameters:
[]
199 1.92 ms
"START TRANSACTION"
Parameters:
[]
200 5.21 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 20:00:00"
  20
  "29.47"
  "Kouklia"
  ""
]
201 3.05 ms
"COMMIT"
Parameters:
[]
202 0.74 ms
"START TRANSACTION"
Parameters:
[]
203 4.19 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 21:00:00"
  21
  "27.51"
  "Kouklia"
  ""
]
204 2.00 ms
"COMMIT"
Parameters:
[]
205 7.97 ms
"START TRANSACTION"
Parameters:
[]
206 2.06 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 22:00:00"
  22
  "27.35"
  "Kouklia"
  ""
]
207 2.06 ms
"COMMIT"
Parameters:
[]
208 1.69 ms
"START TRANSACTION"
Parameters:
[]
209 5.20 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-25 23:00:00"
  23
  "27.05"
  "Kouklia"
  ""
]
210 2.04 ms
"COMMIT"
Parameters:
[]
211 5.84 ms
"START TRANSACTION"
Parameters:
[]
212 1.93 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 00:00:00"
  0
  "26.87"
  "Kouklia"
  ""
]
213 3.22 ms
"COMMIT"
Parameters:
[]
214 5.81 ms
"START TRANSACTION"
Parameters:
[]
215 2.14 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 01:00:00"
  1
  "26.11"
  "Kouklia"
  ""
]
216 1.31 ms
"COMMIT"
Parameters:
[]
217 2.45 ms
"START TRANSACTION"
Parameters:
[]
218 0.64 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 02:00:00"
  2
  "25.93"
  "Kouklia"
  ""
]
219 1.57 ms
"COMMIT"
Parameters:
[]
220 3.42 ms
"START TRANSACTION"
Parameters:
[]
221 0.32 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 03:00:00"
  3
  "25.56"
  "Kouklia"
  ""
]
222 2.01 ms
"COMMIT"
Parameters:
[]
223 4.21 ms
"START TRANSACTION"
Parameters:
[]
224 3.92 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 04:00:00"
  4
  "26.27"
  "Kouklia"
  ""
]
225 2.01 ms
"COMMIT"
Parameters:
[]
226 0.57 ms
"START TRANSACTION"
Parameters:
[]
227 1.13 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 05:00:00"
  5
  "26.1"
  "Kouklia"
  ""
]
228 2.08 ms
"COMMIT"
Parameters:
[]
229 3.01 ms
"START TRANSACTION"
Parameters:
[]
230 1.95 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 06:00:00"
  6
  "25.49"
  "Kouklia"
  ""
]
231 1.03 ms
"COMMIT"
Parameters:
[]
232 6.05 ms
"START TRANSACTION"
Parameters:
[]
233 1.97 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 07:00:00"
  7
  "25.86"
  "Kouklia"
  ""
]
234 1.01 ms
"COMMIT"
Parameters:
[]
235 0.77 ms
"START TRANSACTION"
Parameters:
[]
236 0.51 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 08:00:00"
  8
  "31.42"
  "Kouklia"
  ""
]
237 1.48 ms
"COMMIT"
Parameters:
[]
238 9.08 ms
"START TRANSACTION"
Parameters:
[]
239 2.00 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 09:00:00"
  9
  "31.98"
  "Kouklia"
  ""
]
240 2.03 ms
"COMMIT"
Parameters:
[]
241 6.96 ms
"START TRANSACTION"
Parameters:
[]
242 1.00 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 10:00:00"
  10
  "32.91"
  "Kouklia"
  ""
]
243 1.99 ms
"COMMIT"
Parameters:
[]
244 1.62 ms
"START TRANSACTION"
Parameters:
[]
245 2.06 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 11:00:00"
  11
  "34.17"
  "Kouklia"
  ""
]
246 2.09 ms
"COMMIT"
Parameters:
[]
247 0.45 ms
"START TRANSACTION"
Parameters:
[]
248 1.31 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 12:00:00"
  12
  "34.73"
  "Kouklia"
  ""
]
249 2.04 ms
"COMMIT"
Parameters:
[]
250 1.82 ms
"START TRANSACTION"
Parameters:
[]
251 0.51 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 13:00:00"
  13
  "35.17"
  "Kouklia"
  ""
]
252 1.99 ms
"COMMIT"
Parameters:
[]
253 2.41 ms
"START TRANSACTION"
Parameters:
[]
254 1.67 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 14:00:00"
  14
  "35.74"
  "Kouklia"
  ""
]
255 1.41 ms
"COMMIT"
Parameters:
[]
256 3.74 ms
"START TRANSACTION"
Parameters:
[]
257 3.51 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 15:00:00"
  15
  "35.53"
  "Kouklia"
  ""
]
258 1.84 ms
"COMMIT"
Parameters:
[]
259 1.62 ms
"START TRANSACTION"
Parameters:
[]
260 1.13 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 16:00:00"
  16
  "30.11"
  "Kouklia"
  ""
]
261 2.08 ms
"COMMIT"
Parameters:
[]
262 4.36 ms
"START TRANSACTION"
Parameters:
[]
263 16.18 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 17:00:00"
  17
  "29.86"
  "Kouklia"
  ""
]
264 2.02 ms
"COMMIT"
Parameters:
[]
265 2.69 ms
"START TRANSACTION"
Parameters:
[]
266 1.98 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 18:00:00"
  18
  "29.57"
  "Kouklia"
  ""
]
267 2.06 ms
"COMMIT"
Parameters:
[]
268 1.69 ms
"START TRANSACTION"
Parameters:
[]
269 0.82 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 19:00:00"
  19
  "28.71"
  "Kouklia"
  ""
]
270 2.14 ms
"COMMIT"
Parameters:
[]
271 7.96 ms
"START TRANSACTION"
Parameters:
[]
272 4.09 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 20:00:00"
  20
  "27.42"
  "Kouklia"
  ""
]
273 2.11 ms
"COMMIT"
Parameters:
[]
274 4.66 ms
"START TRANSACTION"
Parameters:
[]
275 4.27 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 21:00:00"
  21
  "27.35"
  "Kouklia"
  ""
]
276 2.06 ms
"COMMIT"
Parameters:
[]
277 10.00 ms
"START TRANSACTION"
Parameters:
[]
278 3.04 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 22:00:00"
  22
  "27.4"
  "Kouklia"
  ""
]
279 2.05 ms
"COMMIT"
Parameters:
[]
280 7.92 ms
"START TRANSACTION"
Parameters:
[]
281 2.96 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-26 23:00:00"
  23
  "27.44"
  "Kouklia"
  ""
]
282 2.04 ms
"COMMIT"
Parameters:
[]
283 28.46 ms
"START TRANSACTION"
Parameters:
[]
284 7.93 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-27 00:00:00"
  0
  "27.21"
  "Kouklia"
  ""
]
285 2.02 ms
"COMMIT"
Parameters:
[]
286 0.39 ms
"START TRANSACTION"
Parameters:
[]
287 0.95 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-27 01:00:00"
  1
  "27.01"
  "Kouklia"
  ""
]
288 2.09 ms
"COMMIT"
Parameters:
[]
289 0.45 ms
"START TRANSACTION"
Parameters:
[]
290 0.35 ms
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-27 02:00:00"
  2
  "26.49"
  "Kouklia"
  ""
]
291 1.63 ms
"COMMIT"
Parameters:
[]
292 0.47 ms
"START TRANSACTION"
Parameters:
[]
293 1.10 ms
UPDATE company_details SET weather_last_scraped = ? WHERE id = ?
Parameters:
[
  "2026-08-25 00:35:30"
  1
]
294 0.87 ms
"COMMIT"
Parameters:
[]
295 18.75 ms
SELECT w0_.id AS id_0, w0_.date AS date_1, w0_.time AS time_2, w0_.weather AS weather_3, w0_.location AS location_4, w0_.rain AS rain_5 FROM weather w0_ WHERE w0_.date >= ? AND (w0_.date BETWEEN ? AND ?) ORDER BY w0_.date ASC, w0_.time ASC
Parameters:
[
  "2026-08-25"
  "2026-08-19 00:00:00"
  "2026-08-19 23:59:59"
]
296 14.83 ms
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
297 2.64 ms
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]

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.
App\Entity\Product No errors.