Symfony Profiler

Query Metrics

258 Database Queries

14 Different statements

221.40 ms Query time

0 Invalid entities

61 Managed entities

Queries


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
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 = ?
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
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM weather WHERE id = ?
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
UPDATE company_details SET weather_last_scraped = ? WHERE id = ?
"COMMIT"
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
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 = ?
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?

#▲	Time	Info
1	10.31 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"`] View formatted query View runnable query Explain query 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 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 = 'en' LIMIT 1;
2	1.06 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"`] View formatted query View runnable query Explain query 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 = ? 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 = '1';
3	0.62 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: [] View formatted query View runnable query Explain query 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 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;
4	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
5	0.82 ms	DELETE FROM weather WHERE id = ? Parameters: [`43537`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43537;
6	3.63 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
7	1.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
8	0.92 ms	DELETE FROM weather WHERE id = ? Parameters: [`43538`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43538;
9	1.58 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
10	0.33 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
11	0.37 ms	DELETE FROM weather WHERE id = ? Parameters: [`43539`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43539;
12	1.15 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
13	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	0.33 ms	DELETE FROM weather WHERE id = ? Parameters: [`43540`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43540;
15	1.83 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
17	1.09 ms	DELETE FROM weather WHERE id = ? Parameters: [`43541`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43541;
18	1.63 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
19	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
20	0.32 ms	DELETE FROM weather WHERE id = ? Parameters: [`43542`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43542;
21	1.45 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
22	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
23	0.31 ms	DELETE FROM weather WHERE id = ? Parameters: [`43543`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43543;
24	1.03 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
25	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
26	0.28 ms	DELETE FROM weather WHERE id = ? Parameters: [`43544`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43544;
27	1.95 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
28	0.18 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
29	0.31 ms	DELETE FROM weather WHERE id = ? Parameters: [`43545`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43545;
30	1.45 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
31	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
32	0.36 ms	DELETE FROM weather WHERE id = ? Parameters: [`43546`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43546;
33	1.39 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
34	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
35	0.32 ms	DELETE FROM weather WHERE id = ? Parameters: [`43547`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43547;
36	2.51 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
37	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
38	0.51 ms	DELETE FROM weather WHERE id = ? Parameters: [`43548`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43548;
39	1.55 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
40	0.22 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
41	0.60 ms	DELETE FROM weather WHERE id = ? Parameters: [`43549`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43549;
42	2.07 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
43	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
44	0.35 ms	DELETE FROM weather WHERE id = ? Parameters: [`43550`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43550;
45	1.23 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
46	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
47	0.32 ms	DELETE FROM weather WHERE id = ? Parameters: [`43551`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43551;
48	1.08 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
49	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
50	0.33 ms	DELETE FROM weather WHERE id = ? Parameters: [`43552`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43552;
51	1.10 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
52	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
53	0.40 ms	DELETE FROM weather WHERE id = ? Parameters: [`43553`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43553;
54	1.91 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
55	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
56	0.42 ms	DELETE FROM weather WHERE id = ? Parameters: [`43554`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43554;
57	1.48 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
58	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
59	0.34 ms	DELETE FROM weather WHERE id = ? Parameters: [`43555`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43555;
60	1.22 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
61	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
62	0.34 ms	DELETE FROM weather WHERE id = ? Parameters: [`43556`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43556;
63	1.94 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
64	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
65	0.34 ms	DELETE FROM weather WHERE id = ? Parameters: [`43557`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43557;
66	1.19 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
67	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
68	0.30 ms	DELETE FROM weather WHERE id = ? Parameters: [`43558`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43558;
69	1.22 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
70	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
71	0.34 ms	DELETE FROM weather WHERE id = ? Parameters: [`43559`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43559;
72	1.26 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
73	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
74	0.36 ms	DELETE FROM weather WHERE id = ? Parameters: [`43560`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43560;
75	1.71 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
76	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
77	0.37 ms	DELETE FROM weather WHERE id = ? Parameters: [`43561`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43561;
78	1.01 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
79	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
80	0.36 ms	DELETE FROM weather WHERE id = ? Parameters: [`43562`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43562;
81	1.46 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
82	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
83	0.25 ms	DELETE FROM weather WHERE id = ? Parameters: [`43563`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43563;
84	1.13 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
85	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
86	0.50 ms	DELETE FROM weather WHERE id = ? Parameters: [`43564`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43564;
87	1.48 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
88	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
89	0.34 ms	DELETE FROM weather WHERE id = ? Parameters: [`43565`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43565;
90	1.25 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
91	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
92	0.35 ms	DELETE FROM weather WHERE id = ? Parameters: [`43566`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43566;
93	1.72 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
94	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
95	0.38 ms	DELETE FROM weather WHERE id = ? Parameters: [`43567`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43567;
96	1.88 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
97	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
98	0.36 ms	DELETE FROM weather WHERE id = ? Parameters: [`43568`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43568;
99	1.85 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
100	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
101	0.32 ms	DELETE FROM weather WHERE id = ? Parameters: [`43569`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43569;
102	1.73 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
103	0.18 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
104	5.41 ms	DELETE FROM weather WHERE id = ? Parameters: [`43570`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43570;
105	7.92 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
106	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
107	0.43 ms	DELETE FROM weather WHERE id = ? Parameters: [`43571`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43571;
108	2.39 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
109	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
110	0.36 ms	DELETE FROM weather WHERE id = ? Parameters: [`43572`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43572;
111	1.30 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
112	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
113	0.40 ms	DELETE FROM weather WHERE id = ? Parameters: [`43573`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43573;
114	1.83 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
115	0.56 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
116	0.51 ms	DELETE FROM weather WHERE id = ? Parameters: [`43574`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43574;
117	1.84 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
118	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
119	0.52 ms	DELETE FROM weather WHERE id = ? Parameters: [`43575`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43575;
120	1.22 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
121	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
122	0.57 ms	DELETE FROM weather WHERE id = ? Parameters: [`43576`] View formatted query View runnable query Explain query DELETE FROM weather WHERE id = ? DELETE FROM weather WHERE id = 43576;
123	1.18 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
124	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
125	0.53 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 03:00:00" 3 "12.83" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 03:00:00', 3, '12.83', 'Haslemere', '');
126	1.68 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
127	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
128	0.36 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 06:00:00" 6 "12.41" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 06:00:00', 6, '12.41', 'Haslemere', '');
129	1.36 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
130	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
131	0.29 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 09:00:00" 9 "15.59" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 09:00:00', 9, '15.59', 'Haslemere', '');
132	1.86 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
133	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
134	0.32 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 12:00:00" 12 "16.1" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 12:00:00', 12, '16.1', 'Haslemere', '');
135	1.41 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
136	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
137	0.25 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 15:00:00" 15 "15.27" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 15:00:00', 15, '15.27', 'Haslemere', '');
138	1.18 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
139	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
140	0.27 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 18:00:00" 18 "14.02" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 18:00:00', 18, '14.02', 'Haslemere', '');
141	1.01 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
142	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
143	0.26 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-16 21:00:00" 21 "13.12" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 21:00:00', 21, '13.12', 'Haslemere', '');
144	1.02 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
145	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
146	0.34 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 00:00:00" 0 "12.23" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 00:00:00', 0, '12.23', 'Haslemere', '');
147	1.02 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
148	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
149	0.27 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 03:00:00" 3 "11.88" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 03:00:00', 3, '11.88', 'Haslemere', '');
150	1.01 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
151	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
152	0.22 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 06:00:00" 6 "12.44" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 06:00:00', 6, '12.44', 'Haslemere', '');
153	1.00 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
154	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
155	0.25 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 09:00:00" 9 "16.28" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 09:00:00', 9, '16.28', 'Haslemere', '');
156	1.20 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
157	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
158	0.25 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 12:00:00" 12 "17.35" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 12:00:00', 12, '17.35', 'Haslemere', '');
159	1.62 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
160	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
161	0.25 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 15:00:00" 15 "15.53" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 15:00:00', 15, '15.53', 'Haslemere', '');
162	1.71 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
163	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
164	0.25 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 18:00:00" 18 "13.9" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 18:00:00', 18, '13.9', 'Haslemere', '');
165	1.84 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
166	0.20 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
167	0.32 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-17 21:00:00" 21 "13.33" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 21:00:00', 21, '13.33', 'Haslemere', '');
168	2.21 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
169	0.32 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
170	0.52 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 00:00:00" 0 "13.1" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 00:00:00', 0, '13.1', 'Haslemere', '');
171	2.56 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
172	0.30 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
173	0.53 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 03:00:00" 3 "13.11" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 03:00:00', 3, '13.11', 'Haslemere', '');
174	8.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
175	0.37 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
176	0.51 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 06:00:00" 6 "14.79" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 06:00:00', 6, '14.79', 'Haslemere', '');
177	1.74 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
178	0.35 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
179	0.30 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 09:00:00" 9 "18.2" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 09:00:00', 9, '18.2', 'Haslemere', '');
180	1.43 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
181	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
182	0.40 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 12:00:00" 12 "18.55" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 12:00:00', 12, '18.55', 'Haslemere', '');
183	1.14 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
184	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
185	0.28 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 15:00:00" 15 "16.71" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 15:00:00', 15, '16.71', 'Haslemere', '');
186	1.16 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
187	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
188	0.30 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 18:00:00" 18 "16.16" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 18:00:00', 18, '16.16', 'Haslemere', '');
189	1.72 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
190	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
191	0.30 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-18 21:00:00" 21 "15.91" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 21:00:00', 21, '15.91', 'Haslemere', '');
192	1.20 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
193	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
194	0.29 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 00:00:00" 0 "15.2" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 00:00:00', 0, '15.2', 'Haslemere', '');
195	1.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
196	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
197	0.24 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 03:00:00" 3 "15.35" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 03:00:00', 3, '15.35', 'Haslemere', '');
198	1.39 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
199	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
200	0.41 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 06:00:00" 6 "15.68" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 06:00:00', 6, '15.68', 'Haslemere', '');
201	2.03 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
202	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
203	0.35 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 09:00:00" 9 "17.7" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 09:00:00', 9, '17.7', 'Haslemere', '');
204	1.16 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
205	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
206	0.30 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 12:00:00" 12 "17.74" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 12:00:00', 12, '17.74', 'Haslemere', '');
207	1.31 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
208	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
209	0.31 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 15:00:00" 15 "16.49" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 15:00:00', 15, '16.49', 'Haslemere', '');
210	1.28 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
211	0.13 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
212	0.43 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 18:00:00" 18 "16.08" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 18:00:00', 18, '16.08', 'Haslemere', '');
213	1.62 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
214	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
215	0.30 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-19 21:00:00" 21 "15.03" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-19 21:00:00', 21, '15.03', 'Haslemere', '');
216	1.12 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
217	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
218	0.26 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 00:00:00" 0 "14.7" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 00:00:00', 0, '14.7', 'Haslemere', '');
219	1.09 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
220	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
221	0.24 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 03:00:00" 3 "14.52" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 03:00:00', 3, '14.52', 'Haslemere', '');
222	1.11 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
223	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
224	0.27 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 06:00:00" 6 "15.17" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 06:00:00', 6, '15.17', 'Haslemere', '');
225	1.17 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
226	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
227	0.30 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 09:00:00" 9 "17.64" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 09:00:00', 9, '17.64', 'Haslemere', '');
228	1.20 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
229	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
230	0.29 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 12:00:00" 12 "17.96" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 12:00:00', 12, '17.96', 'Haslemere', '');
231	1.98 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
232	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
233	0.33 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 15:00:00" 15 "16.49" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 15:00:00', 15, '16.49', 'Haslemere', '');
234	1.01 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
235	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
236	0.27 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 18:00:00" 18 "15.86" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 18:00:00', 18, '15.86', 'Haslemere', '');
237	1.52 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
238	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
239	0.24 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-20 21:00:00" 21 "15.66" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-20 21:00:00', 21, '15.66', 'Haslemere', '');
240	1.36 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
241	0.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
242	0.26 ms	INSERT INTO weather (date, time, weather, location, rain) VALUES (?, ?, ?, ?, ?) Parameters: [`"2025-12-21 00:00:00" 0 "15.53" "Haslemere" ""`] View formatted query View runnable query Explain query INSERT INTO weather ( date, time, weather, location, rain ) VALUES (?, ?, ?, ?, ?) INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-21 00:00:00', 0, '15.53', 'Haslemere', '');
243	1.58 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
244	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
245	0.81 ms	UPDATE company_details SET weather_last_scraped = ? WHERE id = ? Parameters: [`"2025-12-16 00:04:04" 1`] View formatted query View runnable query Explain query UPDATE company_details SET weather_last_scraped = ? WHERE id = ? UPDATE company_details SET weather_last_scraped = '2025-12-16 00:04:04' WHERE id = 1;
246	1.72 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
247	3.53 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: [`"2025-12-16" "2025-12-09 00:00:00" "2025-12-09 23:59:59"`] View formatted query View runnable query Explain query 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 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 >= '2025-12-16' AND (w0_.date BETWEEN '2025-12-09 00:00:00' AND '2025-12-09 23:59:59') ORDER BY w0_.date ASC, w0_.time ASC;
248	0.84 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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'Pending';
249	5.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.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`] View formatted query View runnable query Explain query 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 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 = 'Main' AND t0.is_active = 1 ORDER BY t0.ranking ASC;
250	0.91 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: [`5`] View formatted query View runnable query Explain query 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 = ? 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 = 5;
251	7.48 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`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
252	3.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: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
253	0.66 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`] View formatted query View runnable query Explain query 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 = ? 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 = 4;
254	0.45 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`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
255	1.83 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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'Public';
256	0.59 ms	SELECT COUNT() FROM product t0 WHERE t0.category = ? Parameters: [`"Useful Guide"`] View formatted query View runnable query Explain query SELECT COUNT() FROM product t0 WHERE t0.category = ? SELECT COUNT(*) FROM product t0 WHERE t0.category = 'Useful Guide';
257	0.32 ms	SELECT COUNT() FROM product t0 WHERE t0.category = ? Parameters: [`"Useful Guide"`] View formatted query View runnable query Explain query SELECT COUNT() FROM product t0 WHERE t0.category = ? SELECT COUNT(*) FROM product t0 WHERE t0.category = 'Useful Guide';
258	0.23 ms	SELECT COUNT() FROM product t0 WHERE t0.category = ? Parameters: [`"Useful Guide"`] View formatted query View runnable query Explain query SELECT COUNT() FROM product t0 WHERE t0.category = ? SELECT COUNT(*) FROM product t0 WHERE t0.category = '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	40
App\Entity\CmsCopy	13
App\Entity\Product	5
App\Entity\CompanyDetails	1
App\Entity\CmsCopyPageFormats	1
App\Entity\PhotoLocations	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.

Symfony Profiler

GET https://www.whistlesandbells.atts-systems.com/weather/index?date=2025-12-09

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping