Query Metrics
8
Database Queries
8
Different statements
28.95 ms
Query time
5
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.50 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.username AS username_4, t0.password AS password_5, t0.remember_token AS remember_token_6, t0.role AS role_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t11.id AS id_12, t11.phone_number AS phone_number_13, t11.address1 AS address1_14, t11.address2 AS address2_15, t11.address3 AS address3_16, t11.address4 AS address4_17, t11.postcode AS postcode_18, t11.latitude AS latitude_19, t11.longitude AS longitude_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.deleted_at AS deleted_at_23, t11.user_id AS user_id_24 FROM user t0 LEFT JOIN employee t11 ON t11.user_id = t0.id WHERE t0.username = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"[email protected]"
]
|
2 | 1.72 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.job_id AS job_id_5, t0.user_id AS user_id_6 FROM job_status_log t0 WHERE t0.user_id = ?
Parameters:
[
1
]
|
3 | 8.07 ms |
SELECT c0_.id AS id_0, c0_.email AS email_1, c0_.first_name AS first_name_2, c0_.last_name AS last_name_3, c0_.phone_number AS phone_number_4, c0_.consent_to_marketing AS consent_to_marketing_5, c0_.communication_preference AS communication_preference_6, c0_.notes AS notes_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.deleted_at AS deleted_at_10 FROM customer c0_ WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
923
]
|
4 | 8.43 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
923
]
|
5 | 1.00 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
921
]
|
6 | 0.90 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
921
]
|
7 | 1.89 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
923
]
|
8 | 3.45 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.subject AS subject_3, t0.recipient_count AS recipient_count_4, t0.sensitive_content AS sensitive_content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.job_id AS job_id_8, t0.sender_id AS sender_id_9, t10.id AS id_11, t10.created_at AS created_at_12, t10.updated_at AS updated_at_13, t10.deleted_at AS deleted_at_14, t10.message_id AS message_id_15, t10.service_campaign_id AS service_campaign_id_16 FROM message t0 LEFT JOIN service_campaign_message t10 ON t10.message_id = t0.id WHERE t0.id = ?
Parameters:
[
489
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Employee | No errors. |
App\Entity\MessageLog | No errors. |
App\Entity\JobStatusLog | No errors. |
App\Entity\Job |
|
App\Entity\Message | No errors. |
App\Entity\Customer | No errors. |
App\Entity\Pond | No errors. |
App\Entity\PondImage | No errors. |
App\Entity\Service | No errors. |
App\Entity\JobMaterial |
|
App\Entity\Material |
|
App\Entity\JobImage | No errors. |
App\Entity\Schedule | No errors. |
App\Entity\ServiceCampaignMessage |
|
App\Entity\ServiceCampaign |
|