Query Metrics

6 Database Queries
6 Different statements
1.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.67 ms
SELECT t0.number AS number_1, t0.date AS date_2, t0.grand_total AS grand_total_3, t0.status AS status_4, t0.pdf AS pdf_5, t0.pdf_name AS pdf_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM payment_advice_credit t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 0.39 ms
SELECT t0.order_number AS order_number_1, t0.grand_total AS grand_total_2, t0.invoice_number AS invoice_number_3, t0.invoice_grand_total AS invoice_grand_total_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.payment_advice_credit_id AS payment_advice_credit_id_8 FROM payment_advice_credit_position t0 WHERE t0.payment_advice_credit_id = ?
Parameters:
[
  1
]
3 0.24 ms
SELECT t0.message AS message_1, t0.icon AS icon_2, t0.icon_background_color AS icon_background_color_3, t0.icon_color AS icon_color_4, t0.type AS type_5, t0.payload AS payload_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.creator_id AS creator_id_10 FROM note t0 INNER JOIN payment_advice_credit_note ON t0.id = payment_advice_credit_note.note_id WHERE payment_advice_credit_note.payment_advice_credit_id = ?
Parameters:
[
  1
]
4 0.21 ms
SELECT t0.username AS username_1, t0.password AS password_2, t0.reset_token AS reset_token_3, t0.reset_token_expires_at AS reset_token_expires_at_4, t0.email AS email_5, t0.is_active AS is_active_6, t0.full_name AS full_name_7, t0.auth_token AS auth_token_8, t0.telephone AS telephone_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.team_id AS team_id_13 FROM user t0
Parameters:
[]
5 0.18 ms
SELECT u0_.username AS username_0, u0_.password AS password_1, u0_.reset_token AS reset_token_2, u0_.reset_token_expires_at AS reset_token_expires_at_3, u0_.email AS email_4, u0_.is_active AS is_active_5, u0_.full_name AS full_name_6, u0_.auth_token AS auth_token_7, u0_.telephone AS telephone_8, u0_.id AS id_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.team_id AS team_id_12 FROM user u0_
Parameters:
[]
6 0.15 ms
SELECT n0_.is_send AS is_send_0, n0_.id AS id_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.note_id AS note_id_4 FROM notification n0_
Parameters:
[]

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.