https://portal.pondsnorthwest.com/customers/923

Query Metrics

8 Database Queries
8 Different statements
28.95 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.43 ms
(29.11%)
1
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
]
8.07 ms
(27.88%)
1
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
]
3.50 ms
(12.08%)
1
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]"
]
3.45 ms
(11.92%)
1
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
]
1.89 ms
(6.53%)
1
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
]
1.72 ms
(5.93%)
1
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
]
1.00 ms
(3.45%)
1
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
]
0.90 ms
(3.10%)
1
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
]

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
  • The mappings App\Entity\Job#jobMaterials and App\Entity\JobMaterial#job are inconsistent with each other.
  • The field App\Entity\Job#schedules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Schedule#job does not contain the required 'inversedBy="schedules"' attribute.
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
  • The association App\Entity\JobMaterial#material refers to the inverse side field App\Entity\Material#jobMaterial which does not exist.
  • The association App\Entity\JobMaterial#job refers to the inverse side field App\Entity\Job#jobMaterial which does not exist.
App\Entity\Material
  • The mappings App\Entity\Material#jobMaterials and App\Entity\JobMaterial#material are inconsistent with each other.
App\Entity\JobImage No errors.
App\Entity\Schedule No errors.
App\Entity\ServiceCampaignMessage
  • The association App\Entity\ServiceCampaignMessage#serviceCampaign refers to the inverse side field App\Entity\ServiceCampaign#serviceCampaignMessage which does not exist.
App\Entity\ServiceCampaign
  • The mappings App\Entity\ServiceCampaign#serviceCampaignMessages and App\Entity\ServiceCampaignMessage#serviceCampaign are inconsistent with each other.