GET https://prospectin.kisydev.fr/m/i/f1a14917-8c5b-4f30-9678-13cd1a31ef2c

Query Metrics

7 Database Queries
6 Different statements
10.46 ms Query time
0 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 1.30 ms
SELECT t0.id AS id_1, t0.tracking_id AS tracking_id_2, t0.subject AS subject_3, t0.status AS status_4, t0.sent_at AS sent_at_5, t0.opened_at AS opened_at_6, t0.open_count AS open_count_7, t0.template_id AS template_id_8, t0.sequence_id AS sequence_id_9, t0.step_number AS step_number_10, t0.smtp_config_id AS smtp_config_id_11, t0.user_id AS user_id_12, t0.contact_id AS contact_id_13, t0.enrollment_id AS enrollment_id_14, t0.message_id AS message_id_15, t0.recipient_email AS recipient_email_16, t0.body_html AS body_html_17, t0.error_message AS error_message_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.prospect_id AS prospect_id_21 FROM email_tracking t0 WHERE t0.tracking_id = ? LIMIT 1
Parameters:
[
  "f1a14917-8c5b-4f30-9678-13cd1a31ef2c"
]
2 0.31 ms
"START TRANSACTION"
Parameters:
[]
3 0.84 ms
UPDATE email_tracking SET open_count = ?, updated_at = ? WHERE id = ?
Parameters:
[
  3
  "2026-06-03 03:36:58"
  403
]
4 4.57 ms
"COMMIT"
Parameters:
[]
5 0.96 ms
SELECT t0.id AS id_1, t0.tracking_id AS tracking_id_2, t0.subject AS subject_3, t0.status AS status_4, t0.sent_at AS sent_at_5, t0.opened_at AS opened_at_6, t0.open_count AS open_count_7, t0.template_id AS template_id_8, t0.sequence_id AS sequence_id_9, t0.step_number AS step_number_10, t0.smtp_config_id AS smtp_config_id_11, t0.user_id AS user_id_12, t0.contact_id AS contact_id_13, t0.enrollment_id AS enrollment_id_14, t0.message_id AS message_id_15, t0.recipient_email AS recipient_email_16, t0.body_html AS body_html_17, t0.error_message AS error_message_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.prospect_id AS prospect_id_21 FROM email_tracking t0 WHERE t0.tracking_id = ? LIMIT 1
Parameters:
[
  "f1a14917-8c5b-4f30-9678-13cd1a31ef2c"
]
6 1.44 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.only_assigned_prospects AS only_assigned_prospects_7, t0.email_signature AS email_signature_8, t0.signature_image_path AS signature_image_path_9, t0.regions AS regions_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.role_id AS role_id_13, t0.smtp_config_id AS smtp_config_id_14, t0.email_signature_id AS email_signature_id_15 FROM users t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.html_content AS html_content_3, t0.image_path AS image_path_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.project_id AS project_id_7 FROM email_signatures t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\EmailTracking 1
App\Entity\Prospect 1
App\Entity\User 1
App\Entity\Role 1
App\Entity\SmtpConfig 1
App\Entity\EmailSignature 1
App\Entity\Project 1

Entities Mapping

Class Mapping errors
App\Entity\EmailTracking No errors.
App\Entity\Prospect No errors.
App\Entity\EmailReply No errors.
App\Entity\EmailAttachment No errors.
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\SmtpConfig No errors.
App\Entity\EmailSignature No errors.
App\Entity\Project No errors.
App\Entity\Interaction No errors.