Query Metrics
263
Database Queries
17
Different statements
364.18 ms
Query time
0
Invalid entities
89
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.03 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 | 13.69 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.61 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.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.54 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474953
]
|
| 6 | 2.49 ms |
"COMMIT"
Parameters:
[] |
| 7 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.41 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474954
]
|
| 9 | 1.70 ms |
"COMMIT"
Parameters:
[] |
| 10 | 0.19 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 0.97 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474955
]
|
| 12 | 1.81 ms |
"COMMIT"
Parameters:
[] |
| 13 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 14 | 0.30 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474956
]
|
| 15 | 5.96 ms |
"COMMIT"
Parameters:
[] |
| 16 | 0.26 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 0.63 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474957
]
|
| 18 | 2.00 ms |
"COMMIT"
Parameters:
[] |
| 19 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 20 | 0.36 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474958
]
|
| 21 | 1.56 ms |
"COMMIT"
Parameters:
[] |
| 22 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 23 | 0.29 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474959
]
|
| 24 | 1.42 ms |
"COMMIT"
Parameters:
[] |
| 25 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 26 | 0.46 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474960
]
|
| 27 | 1.83 ms |
"COMMIT"
Parameters:
[] |
| 28 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
| 29 | 0.54 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474961
]
|
| 30 | 2.51 ms |
"COMMIT"
Parameters:
[] |
| 31 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
| 32 | 0.63 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474962
]
|
| 33 | 2.57 ms |
"COMMIT"
Parameters:
[] |
| 34 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
| 35 | 0.52 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474963
]
|
| 36 | 1.54 ms |
"COMMIT"
Parameters:
[] |
| 37 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 38 | 0.55 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474964
]
|
| 39 | 1.68 ms |
"COMMIT"
Parameters:
[] |
| 40 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 41 | 0.57 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474965
]
|
| 42 | 12.54 ms |
"COMMIT"
Parameters:
[] |
| 43 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 44 | 0.45 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474966
]
|
| 45 | 1.76 ms |
"COMMIT"
Parameters:
[] |
| 46 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 47 | 0.41 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474967
]
|
| 48 | 1.91 ms |
"COMMIT"
Parameters:
[] |
| 49 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 50 | 0.47 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474968
]
|
| 51 | 1.75 ms |
"COMMIT"
Parameters:
[] |
| 52 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 53 | 0.59 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474969
]
|
| 54 | 1.81 ms |
"COMMIT"
Parameters:
[] |
| 55 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 56 | 0.37 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474970
]
|
| 57 | 1.38 ms |
"COMMIT"
Parameters:
[] |
| 58 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 59 | 0.44 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474971
]
|
| 60 | 6.49 ms |
"COMMIT"
Parameters:
[] |
| 61 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
| 62 | 0.50 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474972
]
|
| 63 | 1.60 ms |
"COMMIT"
Parameters:
[] |
| 64 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 65 | 0.48 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474973
]
|
| 66 | 1.42 ms |
"COMMIT"
Parameters:
[] |
| 67 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 68 | 0.44 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474974
]
|
| 69 | 1.40 ms |
"COMMIT"
Parameters:
[] |
| 70 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 71 | 0.34 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474975
]
|
| 72 | 1.70 ms |
"COMMIT"
Parameters:
[] |
| 73 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
| 74 | 0.50 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474976
]
|
| 75 | 1.63 ms |
"COMMIT"
Parameters:
[] |
| 76 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 77 | 0.50 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474977
]
|
| 78 | 2.55 ms |
"COMMIT"
Parameters:
[] |
| 79 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 80 | 0.52 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474978
]
|
| 81 | 2.57 ms |
"COMMIT"
Parameters:
[] |
| 82 | 0.19 ms |
"START TRANSACTION"
Parameters:
[] |
| 83 | 0.52 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474979
]
|
| 84 | 1.61 ms |
"COMMIT"
Parameters:
[] |
| 85 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 86 | 0.38 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474980
]
|
| 87 | 1.54 ms |
"COMMIT"
Parameters:
[] |
| 88 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 89 | 0.43 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474981
]
|
| 90 | 1.55 ms |
"COMMIT"
Parameters:
[] |
| 91 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 92 | 0.38 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474982
]
|
| 93 | 1.33 ms |
"COMMIT"
Parameters:
[] |
| 94 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 95 | 0.28 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474983
]
|
| 96 | 1.58 ms |
"COMMIT"
Parameters:
[] |
| 97 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 98 | 0.39 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474984
]
|
| 99 | 1.41 ms |
"COMMIT"
Parameters:
[] |
| 100 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 101 | 0.37 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474985
]
|
| 102 | 2.01 ms |
"COMMIT"
Parameters:
[] |
| 103 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 104 | 0.33 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474986
]
|
| 105 | 1.13 ms |
"COMMIT"
Parameters:
[] |
| 106 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
| 107 | 0.42 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474987
]
|
| 108 | 1.46 ms |
"COMMIT"
Parameters:
[] |
| 109 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 110 | 0.39 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474988
]
|
| 111 | 2.24 ms |
"COMMIT"
Parameters:
[] |
| 112 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
| 113 | 0.50 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474989
]
|
| 114 | 1.72 ms |
"COMMIT"
Parameters:
[] |
| 115 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 116 | 0.39 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474990
]
|
| 117 | 2.96 ms |
"COMMIT"
Parameters:
[] |
| 118 | 0.39 ms |
"START TRANSACTION"
Parameters:
[] |
| 119 | 0.44 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474991
]
|
| 120 | 1.50 ms |
"COMMIT"
Parameters:
[] |
| 121 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 122 | 0.40 ms |
DELETE FROM weather WHERE id = ?
Parameters:
[
1474992
]
|
| 123 | 1.31 ms |
"COMMIT"
Parameters:
[] |
| 124 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 125 | 0.51 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-14 15:00:00" 15 "17.29" "Kouklia" "" ] |
| 126 | 3.59 ms |
"COMMIT"
Parameters:
[] |
| 127 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
| 128 | 0.41 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-14 18:00:00" 18 "16.58" "Kouklia" "" ] |
| 129 | 2.27 ms |
"COMMIT"
Parameters:
[] |
| 130 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 131 | 0.34 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-14 21:00:00" 21 "14.81" "Kouklia" "" ] |
| 132 | 1.71 ms |
"COMMIT"
Parameters:
[] |
| 133 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 134 | 0.40 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 00:00:00" 0 "12.78" "Kouklia" "0.13" ] |
| 135 | 1.46 ms |
"COMMIT"
Parameters:
[] |
| 136 | 0.87 ms |
"START TRANSACTION"
Parameters:
[] |
| 137 | 0.37 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 03:00:00" 3 "13.91" "Kouklia" "0.15" ] |
| 138 | 2.68 ms |
"COMMIT"
Parameters:
[] |
| 139 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 140 | 0.34 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 06:00:00" 6 "12.8" "Kouklia" "" ] |
| 141 | 1.52 ms |
"COMMIT"
Parameters:
[] |
| 142 | 0.56 ms |
"START TRANSACTION"
Parameters:
[] |
| 143 | 0.41 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 09:00:00" 9 "16.99" "Kouklia" "0.13" ] |
| 144 | 1.37 ms |
"COMMIT"
Parameters:
[] |
| 145 | 0.90 ms |
"START TRANSACTION"
Parameters:
[] |
| 146 | 0.97 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 12:00:00" 12 "17.09" "Kouklia" "0.46" ] |
| 147 | 1.34 ms |
"COMMIT"
Parameters:
[] |
| 148 | 0.98 ms |
"START TRANSACTION"
Parameters:
[] |
| 149 | 0.95 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 15:00:00" 15 "16.3" "Kouklia" "1.23" ] |
| 150 | 1.33 ms |
"COMMIT"
Parameters:
[] |
| 151 | 0.35 ms |
"START TRANSACTION"
Parameters:
[] |
| 152 | 0.44 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 18:00:00" 18 "15.37" "Kouklia" "0.41" ] |
| 153 | 1.93 ms |
"COMMIT"
Parameters:
[] |
| 154 | 0.99 ms |
"START TRANSACTION"
Parameters:
[] |
| 155 | 0.97 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-15 21:00:00" 21 "13.32" "Kouklia" "" ] |
| 156 | 1.46 ms |
"COMMIT"
Parameters:
[] |
| 157 | 0.98 ms |
"START TRANSACTION"
Parameters:
[] |
| 158 | 0.32 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 00:00:00" 0 "12.73" "Kouklia" "" ] |
| 159 | 1.35 ms |
"COMMIT"
Parameters:
[] |
| 160 | 1.01 ms |
"START TRANSACTION"
Parameters:
[] |
| 161 | 0.41 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 03:00:00" 3 "12.22" "Kouklia" "" ] |
| 162 | 2.33 ms |
"COMMIT"
Parameters:
[] |
| 163 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 164 | 0.32 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 06:00:00" 6 "12.65" "Kouklia" "" ] |
| 165 | 1.64 ms |
"COMMIT"
Parameters:
[] |
| 166 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 167 | 0.27 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 09:00:00" 9 "15.77" "Kouklia" "" ] |
| 168 | 1.31 ms |
"COMMIT"
Parameters:
[] |
| 169 | 0.73 ms |
"START TRANSACTION"
Parameters:
[] |
| 170 | 0.97 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 12:00:00" 12 "16.71" "Kouklia" "" ] |
| 171 | 1.59 ms |
"COMMIT"
Parameters:
[] |
| 172 | 0.60 ms |
"START TRANSACTION"
Parameters:
[] |
| 173 | 0.97 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 15:00:00" 15 "15.16" "Kouklia" "" ] |
| 174 | 2.09 ms |
"COMMIT"
Parameters:
[] |
| 175 | 0.55 ms |
"START TRANSACTION"
Parameters:
[] |
| 176 | 0.93 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 18:00:00" 18 "13.38" "Kouklia" "" ] |
| 177 | 1.34 ms |
"COMMIT"
Parameters:
[] |
| 178 | 0.91 ms |
"START TRANSACTION"
Parameters:
[] |
| 179 | 0.93 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-16 21:00:00" 21 "12.96" "Kouklia" "" ] |
| 180 | 1.38 ms |
"COMMIT"
Parameters:
[] |
| 181 | 0.73 ms |
"START TRANSACTION"
Parameters:
[] |
| 182 | 0.94 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 00:00:00" 0 "12.12" "Kouklia" "" ] |
| 183 | 2.08 ms |
"COMMIT"
Parameters:
[] |
| 184 | 0.51 ms |
"START TRANSACTION"
Parameters:
[] |
| 185 | 0.94 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 03:00:00" 3 "12.26" "Kouklia" "" ] |
| 186 | 1.59 ms |
"COMMIT"
Parameters:
[] |
| 187 | 0.56 ms |
"START TRANSACTION"
Parameters:
[] |
| 188 | 0.94 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 06:00:00" 6 "13.05" "Kouklia" "" ] |
| 189 | 2.55 ms |
"COMMIT"
Parameters:
[] |
| 190 | 0.69 ms |
"START TRANSACTION"
Parameters:
[] |
| 191 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 09:00:00" 9 "16.26" "Kouklia" "" ] |
| 192 | 2.06 ms |
"COMMIT"
Parameters:
[] |
| 193 | 0.71 ms |
"START TRANSACTION"
Parameters:
[] |
| 194 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 12:00:00" 12 "16.86" "Kouklia" "" ] |
| 195 | 2.59 ms |
"COMMIT"
Parameters:
[] |
| 196 | 0.56 ms |
"START TRANSACTION"
Parameters:
[] |
| 197 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 15:00:00" 15 "15.41" "Kouklia" "" ] |
| 198 | 1.55 ms |
"COMMIT"
Parameters:
[] |
| 199 | 1.03 ms |
"START TRANSACTION"
Parameters:
[] |
| 200 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 18:00:00" 18 "14.54" "Kouklia" "" ] |
| 201 | 1.62 ms |
"COMMIT"
Parameters:
[] |
| 202 | 1.14 ms |
"START TRANSACTION"
Parameters:
[] |
| 203 | 0.96 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-17 21:00:00" 21 "13.68" "Kouklia" "" ] |
| 204 | 1.79 ms |
"COMMIT"
Parameters:
[] |
| 205 | 0.80 ms |
"START TRANSACTION"
Parameters:
[] |
| 206 | 1.14 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 00:00:00" 0 "13.05" "Kouklia" "" ] |
| 207 | 5.16 ms |
"COMMIT"
Parameters:
[] |
| 208 | 0.42 ms |
"START TRANSACTION"
Parameters:
[] |
| 209 | 0.88 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 03:00:00" 3 "12.9" "Kouklia" "" ] |
| 210 | 1.88 ms |
"COMMIT"
Parameters:
[] |
| 211 | 0.76 ms |
"START TRANSACTION"
Parameters:
[] |
| 212 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 06:00:00" 6 "14.24" "Kouklia" "" ] |
| 213 | 2.45 ms |
"COMMIT"
Parameters:
[] |
| 214 | 0.53 ms |
"START TRANSACTION"
Parameters:
[] |
| 215 | 0.92 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 09:00:00" 9 "17.56" "Kouklia" "" ] |
| 216 | 2.12 ms |
"COMMIT"
Parameters:
[] |
| 217 | 0.42 ms |
"START TRANSACTION"
Parameters:
[] |
| 218 | 0.96 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 12:00:00" 12 "17.49" "Kouklia" "" ] |
| 219 | 2.92 ms |
"COMMIT"
Parameters:
[] |
| 220 | 0.76 ms |
"START TRANSACTION"
Parameters:
[] |
| 221 | 0.78 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 15:00:00" 15 "16.88" "Kouklia" "" ] |
| 222 | 2.18 ms |
"COMMIT"
Parameters:
[] |
| 223 | 1.96 ms |
"START TRANSACTION"
Parameters:
[] |
| 224 | 1.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 18:00:00" 18 "15.66" "Kouklia" "" ] |
| 225 | 3.06 ms |
"COMMIT"
Parameters:
[] |
| 226 | 0.46 ms |
"START TRANSACTION"
Parameters:
[] |
| 227 | 0.95 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-18 21:00:00" 21 "15.52" "Kouklia" "" ] |
| 228 | 2.09 ms |
"COMMIT"
Parameters:
[] |
| 229 | 0.41 ms |
"START TRANSACTION"
Parameters:
[] |
| 230 | 0.99 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-19 00:00:00" 0 "16.28" "Kouklia" "" ] |
| 231 | 2.72 ms |
"COMMIT"
Parameters:
[] |
| 232 | 0.63 ms |
"START TRANSACTION"
Parameters:
[] |
| 233 | 2.10 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-19 03:00:00" 3 "16.41" "Kouklia" "" ] |
| 234 | 3.13 ms |
"COMMIT"
Parameters:
[] |
| 235 | 0.47 ms |
"START TRANSACTION"
Parameters:
[] |
| 236 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-19 06:00:00" 6 "15.64" "Kouklia" "" ] |
| 237 | 1.97 ms |
"COMMIT"
Parameters:
[] |
| 238 | 0.55 ms |
"START TRANSACTION"
Parameters:
[] |
| 239 | 0.98 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-19 09:00:00" 9 "17.71" "Kouklia" "" ] |
| 240 | 2.03 ms |
"COMMIT"
Parameters:
[] |
| 241 | 0.57 ms |
"START TRANSACTION"
Parameters:
[] |
| 242 | 0.97 ms |
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-19 12:00:00" 12 "17.76" "Kouklia" "" ] |
| 243 | 1.91 ms |
"COMMIT"
Parameters:
[] |
| 244 | 1.63 ms |
"START TRANSACTION"
Parameters:
[] |
| 245 | 2.24 ms |
UPDATE company_details SET weather_last_scraped = ? WHERE id = ?
Parameters:
[ "2025-12-14 14:35:53" 1 ] |
| 246 | 2.09 ms |
"COMMIT"
Parameters:
[] |
| 247 | 16.84 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 >= ? ORDER BY w0_.date ASC, w0_.time ASC
Parameters:
[
"2025-12-14"
]
|
| 248 | 5.63 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"
]
|
| 249 | 5.51 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.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC
Parameters:
[ "Main" 1 ] |
| 250 | 12.68 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
]
|
| 251 | 1.86 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
]
|
| 252 | 7.33 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
]
|
| 253 | 7.46 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
]
|
| 254 | 3.44 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
]
|
| 255 | 0.56 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
]
|
| 256 | 0.48 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.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.category = ? ORDER BY t0.ranking ASC
Parameters:
[
"Sub"
]
|
| 257 | 0.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:
[
1
]
|
| 258 | 0.55 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
]
|
| 259 | 2.91 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"
]
|
| 260 | 11.65 ms |
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
"Useful Guide"
]
|
| 261 | 0.59 ms |
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
"Useful Guide"
]
|
| 262 | 6.93 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.is_active = ?
Parameters:
[
1
]
|
| 263 | 0.65 ms |
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC
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 | 40 |
| App\Entity\CmsCopy | 27 |
| App\Entity\Product | 13 |
| App\Entity\Languages | 4 |
| App\Entity\PhotoLocations | 3 |
| App\Entity\CompanyDetails | 1 |
| App\Entity\CmsCopyPageFormats | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Languages | No errors. |
| App\Entity\CompanyDetails | No errors. |
| App\Entity\Weather | No errors. |
| App\Entity\WebsiteContacts | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\CmsCopy | No errors. |
| App\Entity\CmsCopyPageFormats | No errors. |
| App\Entity\PhotoLocations | No errors. |
| App\Entity\Photos | No errors. |
| App\Entity\User | No errors. |