Query Metrics

12 Database Queries
3 Different statements
3.36 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.status AS status_1, t0.pdf AS pdf_2, t0.pdf_name AS pdf_name_3, t0.credit_note_numbers AS credit_note_numbers_4, t0.avis_number AS avis_number_5, t0.avis_date AS avis_date_6, t0.avis_total AS avis_total_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM payment_advice_avis t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 1.26 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.number IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "5100652525"
  "5100653727"
  "5100657267"
  "5100660713"
  "5100664761"
  "5100665848"
  "5100665851"
  "5100669206"
  "5100673445"
  "5100674674"
]
3 0.18 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:
[
  10
]
4 0.16 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:
[
  9
]
5 0.16 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:
[
  8
]
6 0.16 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:
[
  7
]
7 0.15 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:
[
  6
]
8 0.15 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
]
9 0.15 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:
[
  12
]
10 0.17 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:
[
  4
]
11 0.16 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:
[
  3
]
12 0.15 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:
[
  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.