Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.project AS project_3,
  t0.live_website AS live_website_4,
  t0.summary AS summary_5,
  t0.monthly_revenue AS monthly_revenue_6,
  t0.c_dev_directory AS c_dev_directory_7,
  t0.sql_database_file_name AS sql_database_file_name_8,
  t0.ats_template_last_updated AS ats_template_last_updated_9,
  t0.active_coding_project AS active_coding_project_10,
  t0.live_website_working AS live_website_working_11,
  t0.expand_collapse AS expand_collapse_12
FROM
  to_do_list t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.project AS project_3, t0.live_website AS live_website_4, t0.summary AS summary_5, t0.monthly_revenue AS monthly_revenue_6, t0.c_dev_directory AS c_dev_directory_7, t0.sql_database_file_name AS sql_database_file_name_8, t0.ats_template_last_updated AS ats_template_last_updated_9, t0.active_coding_project AS active_coding_project_10, t0.live_website_working AS live_website_working_11, t0.expand_collapse AS expand_collapse_12 FROM to_do_list t0 WHERE t0.id = '38';

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.email2 AS email2_2,
  u0_.email3 AS email3_3,
  u0_.email_verified AS email_verified_4,
  u0_.roles AS roles_5,
  u0_.password AS password_6,
  u0_.salutation AS salutation_7,
  u0_.first_name AS first_name_8,
  u0_.last_name AS last_name_9,
  u0_.full_name AS full_name_10,
  u0_.mobile AS mobile_11,
  u0_.mobile2 AS mobile2_12,
  u0_.plain_password AS plain_password_13,
  u0_.company AS company_14,
  u0_.birthday AS birthday_15,
  u0_.web_page AS web_page_16,
  u0_.notes AS notes_17,
  u0_.job_title AS job_title_18,
  u0_.linked_in AS linked_in_19,
  u0_.business_phone AS business_phone_20,
  u0_.business_street AS business_street_21,
  u0_.business_city AS business_city_22,
  u0_.business_postal_code AS business_postal_code_23,
  u0_.business_country AS business_country_24,
  u0_.home_phone AS home_phone_25,
  u0_.home_phone2 AS home_phone2_26,
  u0_.home_street AS home_street_27,
  u0_.home_city AS home_city_28,
  u0_.home_postal_code AS home_postal_code_29,
  u0_.home_country AS home_country_30,
  u0_.photo AS photo_31,
  u0_.default_language_id AS default_language_id_32,
  u0_.client_emails_sent_id AS client_emails_sent_id_33
FROM
  user u0_
WHERE
  u0_.roles LIKE ?
ORDER BY
  u0_.full_name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.email2 AS email2_2, u0_.email3 AS email3_3, u0_.email_verified AS email_verified_4, u0_.roles AS roles_5, u0_.password AS password_6, u0_.salutation AS salutation_7, u0_.first_name AS first_name_8, u0_.last_name AS last_name_9, u0_.full_name AS full_name_10, u0_.mobile AS mobile_11, u0_.mobile2 AS mobile2_12, u0_.plain_password AS plain_password_13, u0_.company AS company_14, u0_.birthday AS birthday_15, u0_.web_page AS web_page_16, u0_.notes AS notes_17, u0_.job_title AS job_title_18, u0_.linked_in AS linked_in_19, u0_.business_phone AS business_phone_20, u0_.business_street AS business_street_21, u0_.business_city AS business_city_22, u0_.business_postal_code AS business_postal_code_23, u0_.business_country AS business_country_24, u0_.home_phone AS home_phone_25, u0_.home_phone2 AS home_phone2_26, u0_.home_street AS home_street_27, u0_.home_city AS home_city_28, u0_.home_postal_code AS home_postal_code_29, u0_.home_country AS home_country_30, u0_.photo AS photo_31, u0_.default_language_id AS default_language_id_32, u0_.client_emails_sent_id AS client_emails_sent_id_33 FROM user u0_ WHERE u0_.roles LIKE '%\"ROLE_IT\"%' ORDER BY u0_.full_name ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.email2 AS email2_3,
  t0.email3 AS email3_4,
  t0.email_verified AS email_verified_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.salutation AS salutation_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.full_name AS full_name_11,
  t0.mobile AS mobile_12,
  t0.mobile2 AS mobile2_13,
  t0.plain_password AS plain_password_14,
  t0.company AS company_15,
  t0.birthday AS birthday_16,
  t0.web_page AS web_page_17,
  t0.notes AS notes_18,
  t0.job_title AS job_title_19,
  t0.linked_in AS linked_in_20,
  t0.business_phone AS business_phone_21,
  t0.business_street AS business_street_22,
  t0.business_city AS business_city_23,
  t0.business_postal_code AS business_postal_code_24,
  t0.business_country AS business_country_25,
  t0.home_phone AS home_phone_26,
  t0.home_phone2 AS home_phone2_27,
  t0.home_street AS home_street_28,
  t0.home_city AS home_city_29,
  t0.home_postal_code AS home_postal_code_30,
  t0.home_country AS home_country_31,
  t0.photo AS photo_32,
  t0.default_language_id AS default_language_id_33,
  t0.client_emails_sent_id AS client_emails_sent_id_34
FROM
  user t0
  INNER JOIN to_do_list_user ON t0.id = to_do_list_user.user_id
WHERE
  to_do_list_user.to_do_list_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.email2 AS email2_3, t0.email3 AS email3_4, t0.email_verified AS email_verified_5, t0.roles AS roles_6, t0.password AS password_7, t0.salutation AS salutation_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.full_name AS full_name_11, t0.mobile AS mobile_12, t0.mobile2 AS mobile2_13, t0.plain_password AS plain_password_14, t0.company AS company_15, t0.birthday AS birthday_16, t0.web_page AS web_page_17, t0.notes AS notes_18, t0.job_title AS job_title_19, t0.linked_in AS linked_in_20, t0.business_phone AS business_phone_21, t0.business_street AS business_street_22, t0.business_city AS business_city_23, t0.business_postal_code AS business_postal_code_24, t0.business_country AS business_country_25, t0.home_phone AS home_phone_26, t0.home_phone2 AS home_phone2_27, t0.home_street AS home_street_28, t0.home_city AS home_city_29, t0.home_postal_code AS home_postal_code_30, t0.home_country AS home_country_31, t0.photo AS photo_32, t0.default_language_id AS default_language_id_33, t0.client_emails_sent_id AS client_emails_sent_id_34 FROM user t0 INNER JOIN to_do_list_user ON t0.id = to_do_list_user.user_id WHERE to_do_list_user.to_do_list_id = 38;

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.footer_display_address AS footer_display_address_29,
  t0.footer_display_tel_numbers AS footer_display_tel_numbers_30,
  t0.footer_display_contact_details AS footer_display_contact_details_31,
  t0.header_display_login AS header_display_login_32,
  t0.contact_first_name AS contact_first_name_33,
  t0.contact_last_name AS contact_last_name_34,
  t0.home_page_photos_only AS home_page_photos_only_35,
  t0.database_password AS database_password_36,
  t0.sql_database AS sql_database_37,
  t0.header_display_tand_cs AS header_display_tand_cs_38,
  t0.header_display_products AS header_display_products_39,
  t0.header_display_sub_products AS header_display_sub_products_40,
  t0.footer_display_sub_products AS footer_display_sub_products_41,
  t0.include_contact_form_home_page AS include_contact_form_home_page_42,
  t0.multi_lingual AS multi_lingual_43,
  t0.enable_user_registration AS enable_user_registration_44,
  t0.include_qrcode_home_page AS include_qrcode_home_page_45,
  t0.header_display_contact_details AS header_display_contact_details_46,
  t0.header_display_business_contacts AS header_display_business_contacts_47,
  t0.header_display_weather AS header_display_weather_48,
  t0.header_display_facebook_pages AS header_display_facebook_pages_49,
  t0.header_display_competitors AS header_display_competitors_50,
  t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51,
  t0.title_useful_links AS title_useful_links_52,
  t0.header_display_photos AS header_display_photos_53,
  t0.title_products AS title_products_54,
  t0.title_sub_products AS title_sub_products_55,
  t0.company_address_map_link AS company_address_map_link_56,
  t0.company_address_instructions AS company_address_instructions_57,
  t0.registration_email AS registration_email_58,
  t0.user_include_home_address AS user_include_home_address_59,
  t0.user_include_business_address AS user_include_business_address_60,
  t0.user_include_personal_details AS user_include_personal_details_61,
  t0.user_include_job_details AS user_include_job_details_62,
  t0.website_contacts_email_alert AS website_contacts_email_alert_63,
  t0.website_contacts_auto_reply AS website_contacts_auto_reply_64,
  t0.contact_from_response AS contact_from_response_65,
  t0.default_user_password AS default_user_password_66,
  t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67,
  t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68,
  t0.header_display_tel_numbers AS header_display_tel_numbers_69,
  t0.header_display_address AS header_display_address_70,
  t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71,
  t0.user_import_divert_competitor AS user_import_divert_competitor_72,
  t0.user_import_divert_target_partner AS user_import_divert_target_partner_73,
  t0.photo_locations_sort AS photo_locations_sort_74
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.footer_display_address AS footer_display_address_29, t0.footer_display_tel_numbers AS footer_display_tel_numbers_30, t0.footer_display_contact_details AS footer_display_contact_details_31, t0.header_display_login AS header_display_login_32, t0.contact_first_name AS contact_first_name_33, t0.contact_last_name AS contact_last_name_34, t0.home_page_photos_only AS home_page_photos_only_35, t0.database_password AS database_password_36, t0.sql_database AS sql_database_37, t0.header_display_tand_cs AS header_display_tand_cs_38, t0.header_display_products AS header_display_products_39, t0.header_display_sub_products AS header_display_sub_products_40, t0.footer_display_sub_products AS footer_display_sub_products_41, t0.include_contact_form_home_page AS include_contact_form_home_page_42, t0.multi_lingual AS multi_lingual_43, t0.enable_user_registration AS enable_user_registration_44, t0.include_qrcode_home_page AS include_qrcode_home_page_45, t0.header_display_contact_details AS header_display_contact_details_46, t0.header_display_business_contacts AS header_display_business_contacts_47, t0.header_display_weather AS header_display_weather_48, t0.header_display_facebook_pages AS header_display_facebook_pages_49, t0.header_display_competitors AS header_display_competitors_50, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51, t0.title_useful_links AS title_useful_links_52, t0.header_display_photos AS header_display_photos_53, t0.title_products AS title_products_54, t0.title_sub_products AS title_sub_products_55, t0.company_address_map_link AS company_address_map_link_56, t0.company_address_instructions AS company_address_instructions_57, t0.registration_email AS registration_email_58, t0.user_include_home_address AS user_include_home_address_59, t0.user_include_business_address AS user_include_business_address_60, t0.user_include_personal_details AS user_include_personal_details_61, t0.user_include_job_details AS user_include_job_details_62, t0.website_contacts_email_alert AS website_contacts_email_alert_63, t0.website_contacts_auto_reply AS website_contacts_auto_reply_64, t0.contact_from_response AS contact_from_response_65, t0.default_user_password AS default_user_password_66, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68, t0.header_display_tel_numbers AS header_display_tel_numbers_69, t0.header_display_address AS header_display_address_70, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71, t0.user_import_divert_competitor AS user_import_divert_competitor_72, t0.user_import_divert_target_partner AS user_import_divert_target_partner_73, t0.photo_locations_sort AS photo_locations_sort_74 FROM company_details t0 WHERE t0.id = 1;

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
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 FROM product t0 WHERE t0.category = 'Main' AND t0.is_active = 1 ORDER BY t0.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.enabled_users AS enabled_users_3,
  t0.date AS date_4,
  t0.public_private AS public_private_5
FROM
  photo_locations t0
WHERE
  t0.public_private = ?

SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = 'Public';

SELECT
  COUNT(*) as count
FROM
  photo_locations
WHERE
  public_private = "Public"

SELECT COUNT(*) as count
        FROM photo_locations
        WHERE public_private = "Public"
    ;

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.enabled_users AS enabled_users_3,
  t0.date AS date_4,
  t0.public_private AS public_private_5
FROM
  photo_locations t0
WHERE
  t0.public_private = ?

SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = 'Public';

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.enabled_users AS enabled_users_3,
  t0.date AS date_4,
  t0.public_private AS public_private_5
FROM
  photo_locations t0
WHERE
  t0.public_private = ?

SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = 'Public';

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 13;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 19;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 18;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 15;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 10;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 23;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 17;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 9;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 22;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 14;

SELECT
  t0.id AS id_1,
  t0.photo_file AS photo_file_2,
  t0.rotate AS rotate_3,
  t0.location_id AS location_id_4,
  t0.uploaded_by_id AS uploaded_by_id_5
FROM
  photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = 21;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = 1;