Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.date_creation AS date_creation_7,
  t0.reset_password_token AS reset_password_token_8,
  t0.date_request_reset_password AS date_request_reset_password_9,
  t0.need_to_reset_password AS need_to_reset_password_10,
  t0.image_name AS image_name_11,
  t0.phone_number AS phone_number_12,
  t0.anonymous AS anonymous_13,
  t0.email_auth_code AS email_auth_code_14,
  t0.is_email_auth_enabled AS is_email_auth_enabled_15,
  t0.ignore_read AS ignore_read_16,
  t0.token AS token_17,
  t0.active AS active_18,
  t0.public_uuid AS public_uuid_19
FROM
  mew_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.date_creation AS date_creation_7, t0.reset_password_token AS reset_password_token_8, t0.date_request_reset_password AS date_request_reset_password_9, t0.need_to_reset_password AS need_to_reset_password_10, t0.image_name AS image_name_11, t0.phone_number AS phone_number_12, t0.anonymous AS anonymous_13, t0.email_auth_code AS email_auth_code_14, t0.is_email_auth_enabled AS is_email_auth_enabled_15, t0.ignore_read AS ignore_read_16, t0.token AS token_17, t0.active AS active_18, t0.public_uuid AS public_uuid_19 FROM mew_user t0 WHERE t0.email = 'joachim@cupani.dev' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.import_has_header AS import_has_header_4,
  t0.parameter_separator AS parameter_separator_5,
  t0.ftp_server AS ftp_server_6,
  t0.ftp_user AS ftp_user_7,
  t0.ftp_password AS ftp_password_8,
  t0.ftp_path AS ftp_path_9,
  t0.ftp_active AS ftp_active_10,
  t0.sftp_private_key AS sftp_private_key_11,
  t0.is_sftp AS is_sftp_12,
  t0.ftp_port AS ftp_port_13,
  t0.ftp_hours AS ftp_hours_14,
  t0.ftp_message AS ftp_message_15,
  t0.ftp_channel_type AS ftp_channel_type_16,
  t0.ftp_reminder1_active AS ftp_reminder1_active_17,
  t0.ftp_reminder1_message AS ftp_reminder1_message_18,
  t0.ftp_reminder1_hours AS ftp_reminder1_hours_19,
  t0.ftp_reminder2_active AS ftp_reminder2_active_20,
  t0.ftp_reminder2_message AS ftp_reminder2_message_21,
  t0.ftp_reminder2_hours AS ftp_reminder2_hours_22,
  t0.is_single_campaign_only AS is_single_campaign_only_23,
  t0.language AS language_24,
  t0.is_filter_active AS is_filter_active_25,
  t0.messages_condition AS messages_condition_26,
  t0.token AS token_27,
  t0.active AS active_28,
  t0.public_uuid AS public_uuid_29,
  t0.source_origin_id AS source_origin_id_30,
  t0.favorite_phone_number_id AS favorite_phone_number_id_31
FROM
  mew_source t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.import_has_header AS import_has_header_4, t0.parameter_separator AS parameter_separator_5, t0.ftp_server AS ftp_server_6, t0.ftp_user AS ftp_user_7, t0.ftp_password AS ftp_password_8, t0.ftp_path AS ftp_path_9, t0.ftp_active AS ftp_active_10, t0.sftp_private_key AS sftp_private_key_11, t0.is_sftp AS is_sftp_12, t0.ftp_port AS ftp_port_13, t0.ftp_hours AS ftp_hours_14, t0.ftp_message AS ftp_message_15, t0.ftp_channel_type AS ftp_channel_type_16, t0.ftp_reminder1_active AS ftp_reminder1_active_17, t0.ftp_reminder1_message AS ftp_reminder1_message_18, t0.ftp_reminder1_hours AS ftp_reminder1_hours_19, t0.ftp_reminder2_active AS ftp_reminder2_active_20, t0.ftp_reminder2_message AS ftp_reminder2_message_21, t0.ftp_reminder2_hours AS ftp_reminder2_hours_22, t0.is_single_campaign_only AS is_single_campaign_only_23, t0.language AS language_24, t0.is_filter_active AS is_filter_active_25, t0.messages_condition AS messages_condition_26, t0.token AS token_27, t0.active AS active_28, t0.public_uuid AS public_uuid_29, t0.source_origin_id AS source_origin_id_30, t0.favorite_phone_number_id AS favorite_phone_number_id_31 FROM mew_source t0 WHERE t0.token = 'SIKBJOWBYZYE' LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      date_45
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.phone AS phone_1,
          m0_.state AS state_2,
          m0_.comment AS comment_3,
          m0_.stop_list AS stop_list_4,
          m0_.full_name AS full_name_5,
          m0_.delete_list AS delete_list_6,
          m0_.delete_list_date AS delete_list_date_7,
          m0_.stop_list_date AS stop_list_date_8,
          m0_.created_at AS created_at_9,
          m0_.token AS token_10,
          m0_.public_uuid AS public_uuid_11,
          m1_.id AS id_12,
          m1_.name AS name_13,
          m1_.image_name AS image_name_14,
          m1_.import_has_header AS import_has_header_15,
          m1_.parameter_separator AS parameter_separator_16,
          m1_.ftp_server AS ftp_server_17,
          m1_.ftp_user AS ftp_user_18,
          m1_.ftp_password AS ftp_password_19,
          m1_.ftp_path AS ftp_path_20,
          m1_.ftp_active AS ftp_active_21,
          m1_.sftp_private_key AS sftp_private_key_22,
          m1_.is_sftp AS is_sftp_23,
          m1_.ftp_port AS ftp_port_24,
          m1_.ftp_hours AS ftp_hours_25,
          m1_.ftp_message AS ftp_message_26,
          m1_.ftp_channel_type AS ftp_channel_type_27,
          m1_.ftp_reminder1_active AS ftp_reminder1_active_28,
          m1_.ftp_reminder1_message AS ftp_reminder1_message_29,
          m1_.ftp_reminder1_hours AS ftp_reminder1_hours_30,
          m1_.ftp_reminder2_active AS ftp_reminder2_active_31,
          m1_.ftp_reminder2_message AS ftp_reminder2_message_32,
          m1_.ftp_reminder2_hours AS ftp_reminder2_hours_33,
          m1_.is_single_campaign_only AS is_single_campaign_only_34,
          m1_.language AS language_35,
          m1_.is_filter_active AS is_filter_active_36,
          m1_.messages_condition AS messages_condition_37,
          m1_.token AS token_38,
          m1_.active AS active_39,
          m1_.public_uuid AS public_uuid_40,
          m2_.id AS id_41,
          m2_.text AS text_42,
          m2_.rich_content AS rich_content_43,
          m2_.information AS information_44,
          m2_.date AS date_45,
          m2_.sender AS sender_46,
          m2_.seen AS seen_47,
          m2_.seen_date AS seen_date_48,
          m2_.date_received AS date_received_49,
          m2_.error_details AS error_details_50,
          m2_.error_number AS error_number_51,
          m2_.scheduled_date AS scheduled_date_52,
          m2_.udh AS udh_53,
          m2_.parts AS parts_54,
          m2_.token AS token_55,
          m2_.public_uuid AS public_uuid_56
        FROM
          mew_contact m0_
          LEFT JOIN mew_contact_campaign m3_ ON m0_.id = m3_.contact_id
          LEFT JOIN mew_campaign m4_ ON m3_.campaign_id = m4_.id
          LEFT JOIN mew_source m1_ ON m4_.source_id = m1_.id
          LEFT JOIN mew_message m2_ ON m0_.id = m2_.contact_id
        WHERE
          m1_.token = ?
          AND (
            EXISTS (
              SELECT
                1 AS sclr_57
              FROM
                mew_message m5_
              WHERE
                m5_.contact_id = m0_.id
                AND m5_.sender = ?
            )
          )
        ORDER BY
          m2_.date ASC
      ) dctrn_result_inner
    ORDER BY
      date_45 DESC
  ) dctrn_result
LIMIT
  100
OFFSET
  100

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_45 FROM (SELECT m0_.id AS id_0, m0_.phone AS phone_1, m0_.state AS state_2, m0_.comment AS comment_3, m0_.stop_list AS stop_list_4, m0_.full_name AS full_name_5, m0_.delete_list AS delete_list_6, m0_.delete_list_date AS delete_list_date_7, m0_.stop_list_date AS stop_list_date_8, m0_.created_at AS created_at_9, m0_.token AS token_10, m0_.public_uuid AS public_uuid_11, m1_.id AS id_12, m1_.name AS name_13, m1_.image_name AS image_name_14, m1_.import_has_header AS import_has_header_15, m1_.parameter_separator AS parameter_separator_16, m1_.ftp_server AS ftp_server_17, m1_.ftp_user AS ftp_user_18, m1_.ftp_password AS ftp_password_19, m1_.ftp_path AS ftp_path_20, m1_.ftp_active AS ftp_active_21, m1_.sftp_private_key AS sftp_private_key_22, m1_.is_sftp AS is_sftp_23, m1_.ftp_port AS ftp_port_24, m1_.ftp_hours AS ftp_hours_25, m1_.ftp_message AS ftp_message_26, m1_.ftp_channel_type AS ftp_channel_type_27, m1_.ftp_reminder1_active AS ftp_reminder1_active_28, m1_.ftp_reminder1_message AS ftp_reminder1_message_29, m1_.ftp_reminder1_hours AS ftp_reminder1_hours_30, m1_.ftp_reminder2_active AS ftp_reminder2_active_31, m1_.ftp_reminder2_message AS ftp_reminder2_message_32, m1_.ftp_reminder2_hours AS ftp_reminder2_hours_33, m1_.is_single_campaign_only AS is_single_campaign_only_34, m1_.language AS language_35, m1_.is_filter_active AS is_filter_active_36, m1_.messages_condition AS messages_condition_37, m1_.token AS token_38, m1_.active AS active_39, m1_.public_uuid AS public_uuid_40, m2_.id AS id_41, m2_.text AS text_42, m2_.rich_content AS rich_content_43, m2_.information AS information_44, m2_.date AS date_45, m2_.sender AS sender_46, m2_.seen AS seen_47, m2_.seen_date AS seen_date_48, m2_.date_received AS date_received_49, m2_.error_details AS error_details_50, m2_.error_number AS error_number_51, m2_.scheduled_date AS scheduled_date_52, m2_.udh AS udh_53, m2_.parts AS parts_54, m2_.token AS token_55, m2_.public_uuid AS public_uuid_56 FROM mew_contact m0_ LEFT JOIN mew_contact_campaign m3_ ON m0_.id = m3_.contact_id LEFT JOIN mew_campaign m4_ ON m3_.campaign_id = m4_.id LEFT JOIN mew_source m1_ ON m4_.source_id = m1_.id LEFT JOIN mew_message m2_ ON m0_.id = m2_.contact_id WHERE m1_.token = 'SIKBJOWBYZYE' AND (EXISTS (SELECT 1 AS sclr_57 FROM mew_message m5_ WHERE m5_.contact_id = m0_.id AND m5_.sender = 'contact')) ORDER BY m2_.date ASC) dctrn_result_inner ORDER BY date_45 DESC) dctrn_result LIMIT 100 OFFSET 100;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.phone AS phone_1,
          m0_.state AS state_2,
          m0_.comment AS comment_3,
          m0_.stop_list AS stop_list_4,
          m0_.full_name AS full_name_5,
          m0_.delete_list AS delete_list_6,
          m0_.delete_list_date AS delete_list_date_7,
          m0_.stop_list_date AS stop_list_date_8,
          m0_.created_at AS created_at_9,
          m0_.token AS token_10,
          m0_.public_uuid AS public_uuid_11
        FROM
          mew_contact m0_
          LEFT JOIN mew_contact_campaign m1_ ON m0_.id = m1_.contact_id
          LEFT JOIN mew_campaign m2_ ON m1_.campaign_id = m2_.id
          LEFT JOIN mew_source m3_ ON m2_.source_id = m3_.id
          LEFT JOIN mew_message m4_ ON m0_.id = m4_.contact_id
        WHERE
          m3_.token = ?
          AND (
            EXISTS (
              SELECT
                1 AS sclr_12
              FROM
                mew_message m5_
              WHERE
                m5_.contact_id = m0_.id
                AND m5_.sender = ?
            )
          )
        ORDER BY
          m4_.date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.phone AS phone_1, m0_.state AS state_2, m0_.comment AS comment_3, m0_.stop_list AS stop_list_4, m0_.full_name AS full_name_5, m0_.delete_list AS delete_list_6, m0_.delete_list_date AS delete_list_date_7, m0_.stop_list_date AS stop_list_date_8, m0_.created_at AS created_at_9, m0_.token AS token_10, m0_.public_uuid AS public_uuid_11 FROM mew_contact m0_ LEFT JOIN mew_contact_campaign m1_ ON m0_.id = m1_.contact_id LEFT JOIN mew_campaign m2_ ON m1_.campaign_id = m2_.id LEFT JOIN mew_source m3_ ON m2_.source_id = m3_.id LEFT JOIN mew_message m4_ ON m0_.id = m4_.contact_id WHERE m3_.token = 'SIKBJOWBYZYE' AND (EXISTS (SELECT 1 AS sclr_12 FROM mew_message m5_ WHERE m5_.contact_id = m0_.id AND m5_.sender = 'contact')) ORDER BY m4_.date DESC) dctrn_result) dctrn_table;