Query Metrics
12
Database Queries
10
Different statements
4.76 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.88 ms (18.41%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.tax_number AS tax_number_5, t0.street AS street_6, t0.build AS build_7, t0.flat AS flat_8, t0.post_code AS post_code_9, t0.city AS city_10, t0.country AS country_11, t0.notify AS notify_12, t0.description AS description_13, t0.invoice AS invoice_14, t15.id AS id_16, t15.number AS number_17, t15.company AS company_18, t15.number_int AS number_int_19, t15.client AS client_20, t15.forecast AS forecast_21, t15.bill_date AS bill_date_22, t15.due_date AS due_date_23, t15.gross_value AS gross_value_24, t15.tax_value AS tax_value_25, t15.net_value AS net_value_26, t15.date_diff AS date_diff_27, t15.description AS description_28, t15.deadline_note AS deadline_note_29, t15.service AS service_30, t15.status AS status_31, t15.type AS type_32, t15.customer_prio AS customer_prio_33, t15.created_date AS created_date_34, t15.updated_date AS updated_date_35, t15.deadline AS deadline_36, t15.last_notifying AS last_notifying_37, t15.paid_date AS paid_date_38, t15.emails_count AS emails_count_39, t15.pozycjonowanie AS pozycjonowanie_40, t15.gads AS gads_41, t15.fads AS fads_42, t15.opinie AS opinie_43, t15.reklama AS reklama_44, t15.domena AS domena_45, t15.hosting AS hosting_46, t15.sslt AS sslt_47, t15.rata AS rata_48, t15.prototyp AS prototyp_49, t15.grafika AS grafika_50, t15.programowanie AS programowanie_51, t15.aktualizacja AS aktualizacja_52, t15.opieka AS opieka_53, t15.archiwizacja AS archiwizacja_54, t15.logo AS logo_55, t15.identyfikacja AS identyfikacja_56, t15.pgraficzne AS pgraficzne_57, t15.zwiekszeniehostingu AS zwiekszeniehostingu_58, t15.inne AS inne_59, t15.sms_count AS sms_count_60, t15.comment AS comment_61, t15.opieka_wizytowka AS opieka_wizytowka_62, t15.prace_programistyczne AS prace_programistyczne_63 FROM invoices_payers t0 LEFT JOIN invoices t15 ON t0.invoice = t15.id WHERE t0.invoice IN (?)
Parameters:
[
14936
]
|
|
0.80 ms (16.92%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.nick_name AS nick_name_4, t0.email AS email_5, t0.phone AS phone_6, t0.password AS password_7, t0.type AS type_8, t0.created_date AS created_date_9, t0.active AS active_10, t0.access_modules AS access_modules_11, t0.profile_img AS profile_img_12 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"piotr@freeline.pl"
]
|
|
0.74 ms (15.45%) |
1 |
UPDATE invoices SET last_notifying = ?, emails_count = ? WHERE id = ?
Parameters:
[ "2026-02-10 09:54:56" 1 14936 ] |
|
0.43 ms (9.12%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.43 ms (9.00%) |
1 |
SELECT t0.id AS id_1, t0.number AS number_2, t0.company AS company_3, t0.number_int AS number_int_4, t0.client AS client_5, t0.forecast AS forecast_6, t0.bill_date AS bill_date_7, t0.due_date AS due_date_8, t0.gross_value AS gross_value_9, t0.tax_value AS tax_value_10, t0.net_value AS net_value_11, t0.date_diff AS date_diff_12, t0.description AS description_13, t0.deadline_note AS deadline_note_14, t0.service AS service_15, t0.status AS status_16, t0.type AS type_17, t0.customer_prio AS customer_prio_18, t0.created_date AS created_date_19, t0.updated_date AS updated_date_20, t0.deadline AS deadline_21, t0.last_notifying AS last_notifying_22, t0.paid_date AS paid_date_23, t0.emails_count AS emails_count_24, t0.pozycjonowanie AS pozycjonowanie_25, t0.gads AS gads_26, t0.fads AS fads_27, t0.opinie AS opinie_28, t0.reklama AS reklama_29, t0.domena AS domena_30, t0.hosting AS hosting_31, t0.sslt AS sslt_32, t0.rata AS rata_33, t0.prototyp AS prototyp_34, t0.grafika AS grafika_35, t0.programowanie AS programowanie_36, t0.aktualizacja AS aktualizacja_37, t0.opieka AS opieka_38, t0.archiwizacja AS archiwizacja_39, t0.logo AS logo_40, t0.identyfikacja AS identyfikacja_41, t0.pgraficzne AS pgraficzne_42, t0.zwiekszeniehostingu AS zwiekszeniehostingu_43, t0.inne AS inne_44, t0.sms_count AS sms_count_45, t0.comment AS comment_46, t0.opieka_wizytowka AS opieka_wizytowka_47, t0.prace_programistyczne AS prace_programistyczne_48 FROM invoices t0 WHERE t0.id = ?
Parameters:
[
14936
]
|
|
0.41 ms (8.68%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.deadline AS deadline_3, t0.invoice AS invoice_4 FROM invoices_items t0 WHERE t0.invoice IN (?)
Parameters:
[
14936
]
|
|
0.33 ms (6.98%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short AS short_3, t0.tax_number AS tax_number_4, t0.bank_number AS bank_number_5, t0.phone_number AS phone_number_6, t0.bdo AS bdo_7, t0.address AS address_8, t0.invoice AS invoice_9, t10.id AS id_11, t10.number AS number_12, t10.company AS company_13, t10.number_int AS number_int_14, t10.client AS client_15, t10.forecast AS forecast_16, t10.bill_date AS bill_date_17, t10.due_date AS due_date_18, t10.gross_value AS gross_value_19, t10.tax_value AS tax_value_20, t10.net_value AS net_value_21, t10.date_diff AS date_diff_22, t10.description AS description_23, t10.deadline_note AS deadline_note_24, t10.service AS service_25, t10.status AS status_26, t10.type AS type_27, t10.customer_prio AS customer_prio_28, t10.created_date AS created_date_29, t10.updated_date AS updated_date_30, t10.deadline AS deadline_31, t10.last_notifying AS last_notifying_32, t10.paid_date AS paid_date_33, t10.emails_count AS emails_count_34, t10.pozycjonowanie AS pozycjonowanie_35, t10.gads AS gads_36, t10.fads AS fads_37, t10.opinie AS opinie_38, t10.reklama AS reklama_39, t10.domena AS domena_40, t10.hosting AS hosting_41, t10.sslt AS sslt_42, t10.rata AS rata_43, t10.prototyp AS prototyp_44, t10.grafika AS grafika_45, t10.programowanie AS programowanie_46, t10.aktualizacja AS aktualizacja_47, t10.opieka AS opieka_48, t10.archiwizacja AS archiwizacja_49, t10.logo AS logo_50, t10.identyfikacja AS identyfikacja_51, t10.pgraficzne AS pgraficzne_52, t10.zwiekszeniehostingu AS zwiekszeniehostingu_53, t10.inne AS inne_54, t10.sms_count AS sms_count_55, t10.comment AS comment_56, t10.opieka_wizytowka AS opieka_wizytowka_57, t10.prace_programistyczne AS prace_programistyczne_58 FROM invoices_owner_data t0 LEFT JOIN invoices t10 ON t0.invoice = t10.id WHERE t0.invoice IN (?)
Parameters:
[
14936
]
|
|
0.30 ms (6.35%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.24 ms (5.11%) |
1 |
INSERT INTO reminders (type, created_date, client) VALUES (?, ?, ?)
Parameters:
[ "2" "2026-02-10 09:54:56" "14896" ] |
|
0.19 ms (3.97%) |
1 |
SELECT t0.id AS id_1, t0.owner_id AS owner_id_2, t0.type AS type_3, t0.name AS name_4, t0.email AS email_5, t0.short AS short_6, t0.template AS template_7 FROM email_templates t0 WHERE t0.short = ? LIMIT 1
Parameters:
[
"notify2"
]
|
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\Users |
|
| App\Entity\Preorders | No errors. |
| App\Entity\UserAccess | No errors. |
| App\Entity\SeoTask |
|
| App\Entity\SeoProjectCheck |
|
| App\Entity\Reminder | No errors. |
| App\Entity\UserResponsibility | No errors. |
| App\Entity\Invoices |
|
| App\Entity\InvoicesItems | No errors. |
| App\Entity\InvoicesPayers | No errors. |
| App\Entity\InvoicesOwnerData | No errors. |
| App\Entity\EmailTemplates | No errors. |
| App\Entity\Reminders | No errors. |