Symfony Profiler

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;

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';

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;

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 481;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 482;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 483;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 484;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 485;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 486;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 487;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 488;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 489;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 490;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 491;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 492;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 493;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 494;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 495;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 496;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 497;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 498;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 499;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 500;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 501;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 502;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 503;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 504;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 505;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 506;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 507;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 508;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 509;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 510;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 511;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 512;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 513;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 514;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 515;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 516;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 517;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 518;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 519;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  weather
WHERE
  id = ?

DELETE FROM weather WHERE id = 520;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 20:00:00', 20, '13.83', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-16 23:00:00', 23, '14.03', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 02:00:00', 2, '13.4', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 05:00:00', 5, '13.41', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 08:00:00', 8, '12.91', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 11:00:00', 11, '16.51', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 14:00:00', 14, '17.66', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 17:00:00', 17, '16.89', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 20:00:00', 20, '15.07', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-17 23:00:00', 23, '14.86', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 02:00:00', 2, '14.79', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 05:00:00', 5, '14.93', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 08:00:00', 8, '16.43', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 11:00:00', 11, '18.53', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 14:00:00', 14, '18.51', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 17:00:00', 17, '17.74', 'Pathos', '');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO weather (
  date, time, weather, location, rain
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO weather (date, time, weather, location, rain) VALUES ('2025-12-18 20:00:00', 20, '17.51', 'Pathos', '');