Query Metrics
7
Database Queries
6
Different statements
7.50 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.05 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.49 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 3 | 0.92 ms |
UPDATE email_tracking SET open_count = ?, updated_at = ? WHERE id = ?
Parameters:
[ 4 "2026-06-03 04:25:33" 403 ]
|
||||||||||||||||||||||||||||||||
| 4 | 2.98 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 5 | 0.65 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 | 0.83 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 | 0.58 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. |