GET https://sms-dev.tchatbooster.com/api/contact/get/4Z7KSQRXDP4J

Query Metrics

13 Database Queries
13 Different statements
2.38 ms Query time
1 Invalid entities
1140 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.45 ms
(18.68%)
1
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.company_division_id AS company_division_id_10, t0.contact_campaign_id AS contact_campaign_id_11 FROM mew_company_division_contact t0 WHERE t0.contact_campaign_id = ?
Parameters:
[
  1043208
]
0.29 ms
(12.09%)
1
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 WHERE t0.source_id = ?
Parameters:
[
  88
]
0.23 ms
(9.52%)
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 FROM mew_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "noel.lotito@tchatbooster.com"
]
0.22 ms
(9.14%)
1
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.state AS state_3, t0.comment AS comment_4, t0.stop_list AS stop_list_5, t0.full_name AS full_name_6, t0.delete_list AS delete_list_7, t0.delete_list_date AS delete_list_date_8, t0.stop_list_date AS stop_list_date_9, t0.created_at AS created_at_10, t0.token AS token_11, t0.source_id AS source_id_12, t0.phone_tchat_id AS phone_tchat_id_13 FROM mew_contact t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "4Z7KSQRXDP4J"
]
0.21 ms
(8.89%)
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_reminder1_active AS ftp_reminder1_active_16, t0.ftp_reminder1_message AS ftp_reminder1_message_17, t0.ftp_reminder1_hours AS ftp_reminder1_hours_18, t0.ftp_reminder2_active AS ftp_reminder2_active_19, t0.ftp_reminder2_message AS ftp_reminder2_message_20, t0.ftp_reminder2_hours AS ftp_reminder2_hours_21, t0.is_single_campaign_only AS is_single_campaign_only_22, t0.language AS language_23, t0.public_uuid AS public_uuid_24, t0.is_filter_active AS is_filter_active_25, t0.token AS token_26, t0.active AS active_27, t0.source_origin_id AS source_origin_id_28 FROM mew_source t0 WHERE t0.id = ?
Parameters:
[
  88
]
0.20 ms
(8.39%)
1
SELECT t0.id AS id_1, t0.action AS action_2, t0.cp_value AS cp_value_3, t0.cp_operator AS cp_operator_4, t0.email_value AS email_value_5, t0.email_operator AS email_operator_6, t0.budget_value AS budget_value_7, t0.budget_operator AS budget_operator_8, t0.room_count_value AS room_count_value_9, t0.room_count_operator AS room_count_operator_10, t0.phone_value AS phone_value_11, t0.phone_operator AS phone_operator_12, t0.status AS status_13, t0.active AS active_14, t0.token AS token_15, t0.source_id AS source_id_16, t0.company_division_id AS company_division_id_17, t0.program_id AS program_id_18 FROM mew_source_filter_item t0 WHERE t0.source_id = ?
Parameters:
[
  88
]
0.15 ms
(6.29%)
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.contact_id AS contact_id_7, t0.campaign_id AS campaign_id_8 FROM mew_contact_campaign t0 WHERE t0.contact_id = ?
Parameters:
[
  1016134
]
0.14 ms
(6.04%)
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.state AS state_5, t0.nb_contact_backup AS nb_contact_backup_6, t0.nb_contact_delete_backup AS nb_contact_delete_backup_7, t0.nb_contact_stop_backup AS nb_contact_stop_backup_8, t0.nb_contact_close_backup AS nb_contact_close_backup_9, t0.nb_contact_lead_backup AS nb_contact_lead_backup_10, t0.public_form_text AS public_form_text_11, t0.nb_contacts_init AS nb_contacts_init_12, t0.created_at AS created_at_13, t0.is_archived AS is_archived_14, t0.calculated_stats AS calculated_stats_15, t0.public_uuid AS public_uuid_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.token AS token_26, t0.source_id AS source_id_27, t28.id AS id_29, t28.date AS date_30, t28.paused AS paused_31, t28.token AS token_32, t28.campaign_id AS campaign_id_33, t28.source_id AS source_id_34 FROM mew_campaign t0 LEFT JOIN mew_stack t28 ON t28.campaign_id = t0.id WHERE t0.id = ?
Parameters:
[
  6629
]
0.13 ms
(5.37%)
1
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.company_id AS company_id_12 FROM mew_company_division t0 WHERE t0.id = ?
Parameters:
[
  50
]
0.11 ms
(4.82%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.parameter_key AS parameter_key_4, t0.token AS token_5, t0.source_id AS source_id_6 FROM mew_source_parameter t0 WHERE t0.source_id = ? ORDER BY t0.position ASC
Parameters:
[
  88
]
0.09 ms
(3.73%)
1
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 = ?
Parameters:
[
  1016134
]
0.09 ms
(3.61%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.token AS token_4 FROM mew_company t0 WHERE t0.id = ?
Parameters:
[
  10
]
0.08 ms
(3.40%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.information AS information_3, t0.date AS date_4, t0.sender AS sender_5, t0.seen AS seen_6, t0.seen_date AS seen_date_7, t0.date_received AS date_received_8, t0.error_details AS error_details_9, t0.error_number AS error_number_10, t0.scheduled_date AS scheduled_date_11, t0.udh AS udh_12, t0.token AS token_13, t0.contact_id AS contact_id_14, t0.user_id AS user_id_15, t0.seen_user_id AS seen_user_id_16, t0.campaign_id AS campaign_id_17, t0.reminder_id AS reminder_id_18 FROM mew_message t0 WHERE t0.contact_id = ? ORDER BY t0.date ASC
Parameters:
[
  1016134
]

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\SourceFilterItem 1106
App\Entity\SourceParameter 9
App\Entity\Tag 8
App\Entity\Message 4
App\Entity\User 2
App\Entity\CompanyDivision 2
App\Entity\Reminder 2
App\Entity\Contact 1
App\Entity\Source 1
App\Entity\PhoneNumber 1
App\Entity\ContactCampaign 1
App\Entity\Campaign 1
App\Entity\CompanyDivisionContact 1
App\Entity\Company 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Source No errors.
App\Entity\Message No errors.
App\Entity\Contact No errors.
App\Entity\PhoneNumber No errors.
App\Entity\Tag No errors.
App\Entity\Reminder No errors.
App\Entity\ContactCampaign No errors.
App\Entity\SourceOrigin No errors.
App\Entity\TemplateMessage No errors.
App\Entity\Campaign No errors.
App\Entity\Stack No errors.
App\Entity\SourceParameter No errors.
App\Entity\BlackListGroup No errors.
App\Entity\BlackListContact No errors.
App\Entity\CompanyDivisionSource No errors.
App\Entity\UnmatchedContact No errors.
App\Entity\ImportFilterStats No errors.
App\Entity\SourceFilterItem No errors.
App\Entity\ContactApi No errors.
App\Entity\CompanyDivisionContact No errors.
App\Entity\CompanyDivision
  • The field App\Entity\CompanyDivision#sourceFilterItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SourceFilterItem#companyDivision does not contain the required 'inversedBy="sourceFilterItems"' attribute.
App\Entity\Company No errors.
App\Entity\Program No errors.