POST https://staging.connect.seniorstairlifts.co.uk/webhook/superchat/message-inbound?token=472b5a698e8d9d16757cee8c229c5bfd9bfd1bf07ae455260e752b3f44622f4b

Response
200 OK
IP
63.177.197.30
Profiled on
Token
f99b30

Query Metrics

6 Database Queries
6 Different statements
7.22 ms Query time
3 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
4.64 ms
(64.18%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.74 ms
(10.26%) 		1 
SELECT p0_.id AS id_0, p0_.requirements AS requirements_1, p0_.source AS source_2, p0_.stairlift_condition AS stairlift_condition_3, p0_.staircase AS staircase_4, p0_.external_id AS external_id_5, p0_.external_distribution_id AS external_distribution_id_6, p0_.lead_type AS lead_type_7, p0_.extended_warranty AS extended_warranty_8, p0_.other_reason AS other_reason_9, p0_.third_dead_reason AS third_dead_reason_10, p0_.sub_dead_reason AS sub_dead_reason_11, p0_.status AS status_12, p0_.created_at_timestamp AS created_at_timestamp_13, p0_.updated_at_timestamp AS updated_at_timestamp_14, p0_.metadata AS metadata_15, p0_.customer_id AS customer_id_16, p0_.brand_id AS brand_id_17, p0_.api_user_id AS api_user_id_18, p0_.assigned_user_id AS assigned_user_id_19 FROM project p0_ LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id WHERE c1_.contact_number_normalized = ? AND p0_.created_at_timestamp >= ? AND (p0_.status = ? OR p0_.status = ?) ORDER BY p0_.created_at_timestamp DESC LIMIT 1
Parameters: 
[
  "447929421706"
  1784764800
  "unassigned"
  "lead"
]
View formatted query    View runnable query    Explain query
0.59 ms
(8.11%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.additional_name AS additional_name_3, t0.alternative_contact_number AS alternative_contact_number_4, t0.origin AS origin_5, t0.stripe_id AS stripe_id_6, t0.address_lines AS address_lines_7, t0.address_town AS address_town_8, t0.address_postcode AS address_postcode_9, t0.address_county AS address_county_10, t0.address_country AS address_country_11, t0.created_at_timestamp AS created_at_timestamp_12, t0.updated_at_timestamp AS updated_at_timestamp_13, t0.contact_number AS contact_number_14, t0.e164_contact_number AS e164_contact_number_15, t0.contact_number_normalized AS contact_number_normalized_16, t0.email_address AS email_address_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.display_id AS display_id_20, t0.created_by_user_id AS created_by_user_id_21, t0.last_updated_by_user_id AS last_updated_by_user_id_22, t0.xero_guid_id AS xero_guid_id_23 FROM customer t0 WHERE t0.id = ?
Parameters: 
[
  25612
]
View formatted query    View runnable query    Explain query
0.55 ms
(7.67%) 		1 
SELECT t0.is_pinned AS is_pinned_1, t0.anniversary_category AS anniversary_category_2, t0.is_deleted AS is_deleted_3, t0.deleted_at_timestamp AS deleted_at_timestamp_4, t0.id AS id_5, t0.body AS body_6, t0.category AS category_7, t0.completed_at_timestamp AS completed_at_timestamp_8, t0.created_at_timestamp AS created_at_timestamp_9, t0.updated_at_timestamp AS updated_at_timestamp_10, t0.due_at_timestamp AS due_at_timestamp_11, t0.project_id AS project_id_12, t0.deleted_by_user_id AS deleted_by_user_id_13, t0.assigned_user_id AS assigned_user_id_14, t0.created_by_user_id AS created_by_user_id_15, t0.last_updated_by_user_id AS last_updated_by_user_id_16 FROM project_note t0 WHERE t0.project_id = ? ORDER BY t0.created_at_timestamp DESC
Parameters: 
[
  19994
]
View formatted query    View runnable query    Explain query
0.46 ms
(6.37%) 		1 
INSERT INTO project_note (is_pinned, anniversary_category, is_deleted, deleted_at_timestamp, body, category, completed_at_timestamp, created_at_timestamp, updated_at_timestamp, due_at_timestamp, project_id, deleted_by_user_id, assigned_user_id, created_by_user_id, last_updated_by_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  0
  null
  0
  null
  "Customer: Stairlift Sales"
  null
  null
  1787403967
  null
  null
  19994
  null
  null
  null
  null
]
View formatted query    View runnable query    Explain query
0.25 ms
(3.41%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\ProjectNote 3
App\Entity\Project 1
App\Entity\Customer 1
App\Entity\ApiUser 1

Entities Mapping

Class Mapping errors
App\Entity\Project No errors.
App\Entity\Customer
  • The field 'App\Entity\Customer#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Customer#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Brand No errors.
App\Entity\ApiUser No errors.
App\Entity\User No errors.
App\Entity\Job No errors.
App\Entity\ProjectNote No errors.
App\Entity\Quote
  • The association App\Entity\Quote#quotedBy refers to the inverse side field App\Entity\User#quotes which does not exist.
  • The association App\Entity\Quote#soldBy refers to the inverse side field App\Entity\User#soldQuotes which does not exist.
App\Entity\PurchaseOrder No errors.
App\Entity\ProjectFile No errors.
App\Entity\Invoice No errors.
App\Entity\Xero\XeroGuid No errors.
App\Entity\PhoneCall No errors.
App\Entity\Warranty No errors.
App\Entity\Stock\Item
  • The field App\Entity\Stock\Item#pickOrders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Stock\PickOrder#requestedItems does not contain the required 'inversedBy: "pickOrders"' attribute.
App\Entity\Complaint No errors.