Query Metrics
21
Database Queries
5
Different statements
42.27 ms
Query time
1
Invalid entities
96
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
32.89 ms (77.81%) |
17 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.username_canonical AS username_canonical_7, t0.status AS status_8, t0.points AS points_9, t0.points_approved AS points_approved_10, t0.points_waiting AS points_waiting_11, t0.points_paid AS points_paid_12, t0.points_available AS points_available_13, t0.all_extra_points AS all_extra_points_14, t0.czwartaedycja AS czwartaedycja_15, t0.piataedycja AS piataedycja_16, t0.szostaedycja AS szostaedycja_17, t0.siodmaedycja AS siodmaedycja_18, t0.osmaedycja AS osmaedycja_19, t0.enabled AS enabled_20, t0.salt AS salt_21, t0.last_login AS last_login_22, t0.is_allowed AS is_allowed_23, t0.statements AS statements_24, t0.statements2 AS statements2_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.profile_id AS profile_id_29, t30.id AS id_31, t30.title AS title_32, t30.name AS name_33, t30.lastname AS lastname_34, t30.company AS company_35, t30.street AS street_36, t30.phone AS phone_37, t30.description AS description_38, t30.zip_code AS zip_code_39, t30.city AS city_40, t30.province AS province_41, t30.employess AS employess_42, t30.regulations AS regulations_43, t30.regulations41 AS regulations41_44, t30.regulations42 AS regulations42_45, t30.commercial_info AS commercial_info_46, t30.house_number AS house_number_47, t30.apartment_number AS apartment_number_48, t30.tax_office AS tax_office_49, t30.phone_approval AS phone_approval_50, t30.postal_street AS postal_street_51, t30.postal_zip_code AS postal_zip_code_52, t30.postal_city AS postal_city_53, t30.postal_house_number AS postal_house_number_54, t30.postal_apartment_number AS postal_apartment_number_55, t30.regions AS regions_56, t30.activity AS activity_57, t30.vip AS vip_58, t30.wykonawca AS wykonawca_59, t30.del AS del_60, t30.invoice_street AS invoice_street_61, t30.invoice_house_number AS invoice_house_number_62, t30.invoice_apartment_number AS invoice_apartment_number_63, t30.invoice_zip_code AS invoice_zip_code_64, t30.invoice_city AS invoice_city_65, t30.invoice_nip AS invoice_nip_66, t30.invoice_company AS invoice_company_67, t30.distributor_id AS distributor_id_68, t30.sap_number AS sap_number_69, t0.adviser_id AS adviser_id_70 FROM user t0 LEFT JOIN profile t30 ON t0.profile_id = t30.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
5583
]
|
3.90 ms (9.23%) |
1 |
SELECT DISTINCT i0_.id AS id_0, i0_.id AS id_1 FROM i_invoice i0_ WHERE (i0_.type = (?) AND i0_.status = (?)) AND (i0_.deleted_at IS NULL) ORDER BY i0_.id DESC LIMIT 50 OFFSET 50
Parameters:
[ 3 1 ] |
2.51 ms (5.93%) |
1 |
SELECT count(i0_.id) AS sclr_0 FROM i_invoice i0_ WHERE (i0_.type = (?) AND i0_.status = (?)) AND (i0_.deleted_at IS NULL)
Parameters:
[ 3 1 ] |
1.65 ms (3.90%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.status AS status_2, i0_.points AS points_3, i0_.description AS description_4, i0_.promo AS promo_5, i0_.type AS type_6, i0_.add_extra_point AS add_extra_point_7, i0_.platform AS platform_8, i0_.edycja AS edycja_9, i0_.emptyinvoice AS emptyinvoice_10, i0_.reason AS reason_11, i0_.custom_reason AS custom_reason_12, i0_.kind AS kind_13, i0_.document_date AS document_date_14, i0_.seller AS seller_15, i0_.accepted_at AS accepted_at_16, i0_.accepted_by AS accepted_by_17, i0_.created_at AS created_at_18, i0_.updated_at AS updated_at_19, i0_.deleted_at AS deleted_at_20, i0_.author_id AS author_id_21, i0_.creator_id AS creator_id_22 FROM i_invoice i0_ WHERE (i0_.type = (?) AND i0_.status = (?) AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (i0_.deleted_at IS NULL) ORDER BY i0_.id DESC
Parameters:
[ 3 1 160199 160196 160184 160175 160173 160168 160161 160159 160155 160149 160147 160146 160145 160144 160143 160124 160123 160122 160121 160120 160119 160116 160115 160109 160108 160107 160106 160105 160104 160087 160083 160070 160031 160030 160029 160021 160020 160016 160015 160012 160004 160001 159991 159918 159916 159912 159910 159904 ] |
1.32 ms (3.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3 FROM user_groups t0 INNER JOIN user_group ON t0.id = user_group.group_id WHERE user_group.user_id = ?
Parameters:
[
5583
]
|
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\Invoice | 48 |
App\Entity\User | 30 |
App\Entity\Profile | 17 |
App\Entity\Group | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Profile | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Article | No errors. |
App\Entity\Invoice |
|
App\Entity\Group | No errors. |
App\Entity\Order | No errors. |
App\Entity\Point | No errors. |
App\Entity\DeliveryAddress | No errors. |
App\Entity\InvoicePhoto | No errors. |
App\Entity\InvoiceProduct | No errors. |
App\Entity\InvoiceLog | No errors. |