Symfony Profiler

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
  t0.id AS id_1,
  t0.data AS data_2,
  t0.close AS close_3,
  t0.close_date AS close_date_4,
  t0.date_creation AS date_creation_5,
  t0.structured_data AS structured_data_6,
  t0.public_uuid AS public_uuid_7,
  t0.contact_id AS contact_id_8,
  t0.campaign_id AS campaign_id_9
FROM
  mew_contact_campaign t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.close AS close_3, t0.close_date AS close_date_4, t0.date_creation AS date_creation_5, t0.structured_data AS structured_data_6, t0.public_uuid AS public_uuid_7, t0.contact_id AS contact_id_8, t0.campaign_id AS campaign_id_9 FROM mew_contact_campaign t0 WHERE t0.contact_id = 1309711;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.lead AS lead_3,
  t0.lead_date AS lead_date_4,
  t0.data_api AS data_api_5,
  t0.data_api_response_code AS data_api_response_code_6,
  t0.data_api_response_errors AS data_api_response_errors_7,
  t0.active AS active_8,
  t0.token AS token_9,
  t0.public_uuid AS public_uuid_10,
  t0.company_division_id AS company_division_id_11,
  t0.contact_campaign_id AS contact_campaign_id_12
FROM
  mew_company_division_contact t0
WHERE
  t0.contact_campaign_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.lead AS lead_3, t0.lead_date AS lead_date_4, t0.data_api AS data_api_5, t0.data_api_response_code AS data_api_response_code_6, t0.data_api_response_errors AS data_api_response_errors_7, t0.active AS active_8, t0.token AS token_9, t0.public_uuid AS public_uuid_10, t0.company_division_id AS company_division_id_11, t0.contact_campaign_id AS contact_campaign_id_12 FROM mew_company_division_contact t0 WHERE t0.contact_campaign_id = 1338006;

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

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;

SELECT
  m0_.id AS id_0,
  m0_.text AS text_1,
  m0_.rich_content AS rich_content_2,
  m0_.information AS information_3,
  m0_.date AS date_4,
  m0_.sender AS sender_5,
  m0_.seen AS seen_6,
  m0_.seen_date AS seen_date_7,
  m0_.date_received AS date_received_8,
  m0_.error_details AS error_details_9,
  m0_.error_number AS error_number_10,
  m0_.scheduled_date AS scheduled_date_11,
  m0_.udh AS udh_12,
  m0_.parts AS parts_13,
  m0_.token AS token_14,
  m0_.public_uuid AS public_uuid_15,
  m0_.contact_id AS contact_id_16,
  m0_.user_id AS user_id_17,
  m0_.seen_user_id AS seen_user_id_18,
  m0_.campaign_id AS campaign_id_19,
  m0_.reminder_id AS reminder_id_20
FROM
  mew_message m0_
WHERE
  m0_.contact_id = ?
  AND m0_.scheduled_date IS NULL
ORDER BY
  m0_.date DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.rich_content AS rich_content_2, m0_.information AS information_3, m0_.date AS date_4, m0_.sender AS sender_5, m0_.seen AS seen_6, m0_.seen_date AS seen_date_7, m0_.date_received AS date_received_8, m0_.error_details AS error_details_9, m0_.error_number AS error_number_10, m0_.scheduled_date AS scheduled_date_11, m0_.udh AS udh_12, m0_.parts AS parts_13, m0_.token AS token_14, m0_.public_uuid AS public_uuid_15, m0_.contact_id AS contact_id_16, m0_.user_id AS user_id_17, m0_.seen_user_id AS seen_user_id_18, m0_.campaign_id AS campaign_id_19, m0_.reminder_id AS reminder_id_20 FROM mew_message m0_ WHERE m0_.contact_id = 1309711 AND m0_.scheduled_date IS NULL ORDER BY m0_.date DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.rich_content AS rich_content_3,
  t0.scheduled_at AS scheduled_at_4,
  t0.status AS status_5,
  t0.processing_at AS processing_at_6,
  t0.sent_at AS sent_at_7,
  t0.failed_reason AS failed_reason_8,
  t0.priority AS priority_9,
  t0.dispateched_at AS dispateched_at_10,
  t0.contact_id AS contact_id_11,
  t0.campaign_id AS campaign_id_12,
  t0.reminder_id AS reminder_id_13,
  t0.message_id AS message_id_14
FROM
  mew_message_queue t0
WHERE
  t0.message_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.rich_content AS rich_content_3, t0.scheduled_at AS scheduled_at_4, t0.status AS status_5, t0.processing_at AS processing_at_6, t0.sent_at AS sent_at_7, t0.failed_reason AS failed_reason_8, t0.priority AS priority_9, t0.dispateched_at AS dispateched_at_10, t0.contact_id AS contact_id_11, t0.campaign_id AS campaign_id_12, t0.reminder_id AS reminder_id_13, t0.message_id AS message_id_14 FROM mew_message_queue t0 WHERE t0.message_id = 4141147;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.token AS token_4,
  t0.source_id AS source_id_5
FROM
  mew_tag t0
  INNER JOIN mew_tag_contact ON t0.id = mew_tag_contact.tag_id
WHERE
  mew_tag_contact.contact_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.token AS token_4, t0.source_id AS source_id_5 FROM mew_tag t0 INNER JOIN mew_tag_contact ON t0.id = mew_tag_contact.tag_id WHERE mew_tag_contact.contact_id = 1309711;

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.date_send AS date_send_3,
  t0.message AS message_4,
  t0.channel_type AS channel_type_5,
  t0.state AS state_6,
  t0.nb_contact_backup AS nb_contact_backup_7,
  t0.nb_contact_delete_backup AS nb_contact_delete_backup_8,
  t0.nb_contact_stop_backup AS nb_contact_stop_backup_9,
  t0.nb_contact_close_backup AS nb_contact_close_backup_10,
  t0.nb_contact_lead_backup AS nb_contact_lead_backup_11,
  t0.public_form_text AS public_form_text_12,
  t0.nb_contacts_init AS nb_contacts_init_13,
  t0.created_at AS created_at_14,
  t0.is_archived AS is_archived_15,
  t0.calculated_stats AS calculated_stats_16,
  t0.reference AS reference_17,
  t0.postal_code AS postal_code_18,
  t0.city AS city_19,
  t0.comment AS comment_20,
  t0.url AS url_21,
  t0.extra_1 AS extra_1_22,
  t0.extra_2 AS extra_2_23,
  t0.extra_3 AS extra_3_24,
  t0.updated_at AS updated_at_25,
  t0.messages_condition AS messages_condition_26,
  t0.is_paused AS is_paused_27,
  t0.token AS token_28,
  t0.public_uuid AS public_uuid_29,
  t0.source_id AS source_id_30,
  t31.id AS id_32,
  t31.date AS date_33,
  t31.paused AS paused_34,
  t31.token AS token_35,
  t31.campaign_id AS campaign_id_36,
  t31.source_id AS source_id_37,
  t0.phone_number_id AS phone_number_id_38
FROM
  mew_campaign t0
  LEFT JOIN mew_stack t31 ON t31.campaign_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_send AS date_send_3, t0.message AS message_4, t0.channel_type AS channel_type_5, t0.state AS state_6, t0.nb_contact_backup AS nb_contact_backup_7, t0.nb_contact_delete_backup AS nb_contact_delete_backup_8, t0.nb_contact_stop_backup AS nb_contact_stop_backup_9, t0.nb_contact_close_backup AS nb_contact_close_backup_10, t0.nb_contact_lead_backup AS nb_contact_lead_backup_11, t0.public_form_text AS public_form_text_12, t0.nb_contacts_init AS nb_contacts_init_13, t0.created_at AS created_at_14, t0.is_archived AS is_archived_15, t0.calculated_stats AS calculated_stats_16, t0.reference AS reference_17, t0.postal_code AS postal_code_18, t0.city AS city_19, t0.comment AS comment_20, t0.url AS url_21, t0.extra_1 AS extra_1_22, t0.extra_2 AS extra_2_23, t0.extra_3 AS extra_3_24, t0.updated_at AS updated_at_25, t0.messages_condition AS messages_condition_26, t0.is_paused AS is_paused_27, t0.token AS token_28, t0.public_uuid AS public_uuid_29, t0.source_id AS source_id_30, t31.id AS id_32, t31.date AS date_33, t31.paused AS paused_34, t31.token AS token_35, t31.campaign_id AS campaign_id_36, t31.source_id AS source_id_37, t0.phone_number_id AS phone_number_id_38 FROM mew_campaign t0 LEFT JOIN mew_stack t31 ON t31.campaign_id = t0.id WHERE t0.id = 8634;

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,
  m0_.source_id AS source_id_12,
  m0_.phone_tchat_id AS phone_tchat_id_13
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_14
      FROM
        mew_message m5_
      WHERE
        m5_.contact_id = m0_.id
        AND m5_.sender = ?
    )
  )
  AND m0_.id IN (?, ?)
ORDER BY
  m4_.date DESC

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, m0_.source_id AS source_id_12, m0_.phone_tchat_id AS phone_tchat_id_13 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_14 FROM mew_message m5_ WHERE m5_.contact_id = m0_.id AND m5_.sender = 'contact')) AND m0_.id IN (1309711, 1304574) ORDER BY m4_.date DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active_export_lead_by_mail AS active_export_lead_by_mail_3,
  t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4,
  t0.object_export_lead_by_mail AS object_export_lead_by_mail_5,
  t0.api_lead_connector AS api_lead_connector_6,
  t0.api_lead_connector_source AS api_lead_connector_source_7,
  t0.api_lead_connector_usage AS api_lead_connector_usage_8,
  t0.api_lead_connector_context AS api_lead_connector_context_9,
  t0.reference AS reference_10,
  t0.token AS token_11,
  t0.public_uuid AS public_uuid_12,
  t0.company_id AS company_id_13
FROM
  mew_company_division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_export_lead_by_mail AS active_export_lead_by_mail_3, t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4, t0.object_export_lead_by_mail AS object_export_lead_by_mail_5, t0.api_lead_connector AS api_lead_connector_6, t0.api_lead_connector_source AS api_lead_connector_source_7, t0.api_lead_connector_usage AS api_lead_connector_usage_8, t0.api_lead_connector_context AS api_lead_connector_context_9, t0.reference AS reference_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.company_id AS company_id_13 FROM mew_company_division t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.color AS color_4,
  t0.token AS token_5,
  t0.public_uuid AS public_uuid_6
FROM
  mew_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.color AS color_4, t0.token AS token_5, t0.public_uuid AS public_uuid_6 FROM mew_company t0 WHERE t0.id = 1;

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;