Query Metrics
33
Database Queries
5
Different statements
32.85 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
23.16 ms (70.52%) |
28 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.code AS code_7, t0.provision AS provision_8, t0.name AS name_9, t0.surname AS surname_10, t0.person_type AS person_type_11, t0.nationality AS nationality_12, t0.tax_residency AS tax_residency_13, t0.address AS address_14, t0.street AS street_15, t0.town AS town_16, t0.postal AS postal_17, t0.address2 AS address2_18, t0.street2 AS street2_19, t0.town2 AS town2_20, t0.postal2 AS postal2_21, t0.ic AS ic_22, t0.dic AS dic_23, t0.birthdate AS birthdate_24, t0.phone AS phone_25, t0.bank_name AS bank_name_26, t0.bank_account AS bank_account_27, t0.swift AS swift_28, t0.iban AS iban_29, t0.notes AS notes_30, t0.id_type AS id_type_31, t0.id_number AS id_number_32, t0.id_author AS id_author_33, t0.id_validity AS id_validity_34, t0.businessman_registration_place AS businessman_registration_place_35, t0.businessman_registration_number AS businessman_registration_number_36, t0.company_registration_place AS company_registration_place_37, t0.company_registration_number AS company_registration_number_38, t0.company_registration_partition AS company_registration_partition_39, t0.company_registration_insertion AS company_registration_insertion_40, t0.company_representantive AS company_representantive_41, t0.deleted AS deleted_42, t0.bank_code AS bank_code_43, t0.invoice_automation AS invoice_automation_44, t0.bank_name_eur AS bank_name_eur_45, t0.bank_account_eur AS bank_account_eur_46, t0.bank_code_eur AS bank_code_eur_47, t0.iban_eur AS iban_eur_48, t0.swift_eur AS swift_eur_49, t0.anonymize AS anonymize_50, t0.tipster AS tipster_51, t0.created AS created_52, t0.changed AS changed_53, t0.ip AS ip_54, t0.company_id AS company_id_55, t0.created_user_id AS created_user_id_56, t0.changed_user_id AS changed_user_id_57 FROM user t0 WHERE t0.id = ?
Parameters:
[
606
]
|
6.79 ms (20.67%) |
1 |
SELECT o0_.id AS id_0, o0_.hash AS hash_1, o0_.merchant_code AS merchant_code_2, o0_.product_count AS product_count_3, o0_.product_price AS product_price_4, o0_.product_tax AS product_tax_5, o0_.name AS name_6, o0_.surname AS surname_7, o0_.person_type AS person_type_8, o0_.nationality AS nationality_9, o0_.tax_residency AS tax_residency_10, o0_.address AS address_11, o0_.street AS street_12, o0_.town AS town_13, o0_.postal AS postal_14, o0_.address2 AS address2_15, o0_.street2 AS street2_16, o0_.town2 AS town2_17, o0_.postal2 AS postal2_18, o0_.ic AS ic_19, o0_.dic AS dic_20, o0_.birthdate AS birthdate_21, o0_.phone AS phone_22, o0_.email AS email_23, o0_.bank_name AS bank_name_24, o0_.bank_account AS bank_account_25, o0_.swift AS swift_26, o0_.iban AS iban_27, o0_.id_type AS id_type_28, o0_.id_number AS id_number_29, o0_.id_author AS id_author_30, o0_.id_validity AS id_validity_31, o0_.businessman_registration_place AS businessman_registration_place_32, o0_.businessman_registration_number AS businessman_registration_number_33, o0_.company_registration_place AS company_registration_place_34, o0_.company_registration_number AS company_registration_number_35, o0_.company_registration_partition AS company_registration_partition_36, o0_.company_registration_insertion AS company_registration_insertion_37, o0_.company_representantive AS company_representantive_38, o0_.sign_place_user AS sign_place_user_39, o0_.message AS message_40, o0_.consent1 AS consent1_41, o0_.consent2 AS consent2_42, o0_.consent3 AS consent3_43, o0_.consent4 AS consent4_44, o0_.consent5 AS consent5_45, o0_.consent6 AS consent6_46, o0_.sign_date_user AS sign_date_user_47, o0_.sign_place_company AS sign_place_company_48, o0_.sign_date_company AS sign_date_company_49, o0_.product_interest AS product_interest_50, o0_.product_price_total AS product_price_total_51, o0_.product_price_total_in_words AS product_price_total_in_words_52, o0_.api_valid_till AS api_valid_till_53, o0_.id_type_other AS id_type_other_54, o0_.same_address AS same_address_55, o0_.deleted AS deleted_56, o0_.due_date AS due_date_57, o0_.what_generated AS what_generated_58, o0_.bank_code AS bank_code_59, o0_.api_income AS api_income_60, o0_.signed AS signed_61, o0_.signed_date AS signed_date_62, o0_.paid AS paid_63, o0_.paid_date AS paid_date_64, o0_.vp_delivery AS vp_delivery_65, o0_.vp_delivery_date AS vp_delivery_date_66, o0_.sent AS sent_67, o0_.sent_date AS sent_date_68, o0_.storno AS storno_69, o0_.storno_date AS storno_date_70, o0_.raynet_id AS raynet_id_71, o0_.reinvest AS reinvest_72, o0_.paid2 AS paid2_73, o0_.paid_date2 AS paid_date2_74, o0_.product_price_secondary_total AS product_price_secondary_total_75, o0_.product_price_secondary_total_in_words AS product_price_secondary_total_in_words_76, o0_.in_progress AS in_progress_77, o0_.in_progress_date AS in_progress_date_78, o0_.sequence_number AS sequence_number_79, o0_.vp_protocol_sent AS vp_protocol_sent_80, o0_.vp_protocol_blocked_for_send AS vp_protocol_blocked_for_send_81, o0_.birthnumber AS birthnumber_82, o0_.origin_of_funds AS origin_of_funds_83, o0_.origin_of_funds_custom AS origin_of_funds_custom_84, o0_.politically_exposed_person AS politically_exposed_person_85, o0_.created AS created_86, o0_.changed AS changed_87, o0_.ip AS ip_88, o0_.company_name AS company_name_89, o0_.gold_and_silver_api_response AS gold_and_silver_api_response_90, o0_.total_price_excl_vat AS total_price_excl_vat_91, o0_.total_price_vat AS total_price_vat_92, o0_.total_price_incl_vat AS total_price_incl_vat_93, o0_.delivery_price AS delivery_price_94, o0_.delivery_label AS delivery_label_95, o0_.payment_price AS payment_price_96, o0_.payment_label AS payment_label_97, o0_.type AS type_98, o0_.user_id AS user_id_99, o0_.merchant_id AS merchant_id_100, o0_.company_id AS company_id_101, o0_.product_id AS product_id_102, o0_.created_user_id AS created_user_id_103, o0_.changed_user_id AS changed_user_id_104 FROM `order` o0_ WHERE (o0_.deleted = 0 AND o0_.product_id IN (121)) AND o0_.type IN ('base', 'eshop') ORDER BY o0_.id DESC
Parameters:
[] |
1.44 ms (4.39%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.provision AS provision_3, t0.name AS name_4, t0.address AS address_5, t0.street AS street_6, t0.town AS town_7, t0.postal AS postal_8, t0.address2 AS address2_9, t0.street2 AS street2_10, t0.town2 AS town2_11, t0.postal2 AS postal2_12, t0.ic AS ic_13, t0.dic AS dic_14, t0.phone AS phone_15, t0.email AS email_16, t0.bank_name AS bank_name_17, t0.bank_account AS bank_account_18, t0.swift AS swift_19, t0.iban AS iban_20, t0.registration_place AS registration_place_21, t0.registration_number AS registration_number_22, t0.registration_partition AS registration_partition_23, t0.registration_insertion AS registration_insertion_24, t0.representantive AS representantive_25, t0.notes AS notes_26, t0.deleted AS deleted_27, t0.bank_code AS bank_code_28, t0.web_header AS web_header_29, t0.web_perex AS web_perex_30, t0.web_desc AS web_desc_31, t0.web_image AS web_image_32, t0.web_link AS web_link_33, t0.web_link_form AS web_link_form_34, t0.web_order AS web_order_35, t0.demio_form AS demio_form_36, t0.created AS created_37, t0.changed AS changed_38, t0.ip AS ip_39, t0.company_group_id AS company_group_id_40, t0.profile_photo_id AS profile_photo_id_41, t0.created_user_id AS created_user_id_42, t0.changed_user_id AS changed_user_id_43, t0.type FROM company t0 WHERE t0.id = ? AND t0.type IN ('type_company', 'type_group')
Parameters:
[
39
]
|
0.88 ms (2.67%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.price AS price_4, t0.tax AS tax_5, t0.notes AS notes_6, t0.interest AS interest_7, t0.token AS token_8, t0.x_api_token AS x_api_token_9, t0.deleted AS deleted_10, t0.generatorSigni AS generatorSigni_11, t0.signi_locale AS signi_locale_12, t0.signi_email AS signi_email_13, t0.signi_contract_role AS signi_contract_role_14, t0.signi_proposers AS signi_proposers_15, t0.signi_signing_order AS signi_signing_order_16, t0.product_type AS product_type_17, t0.due_date AS due_date_18, t0.generator_pdf AS generator_pdf_19, t0.allow_notification_change AS allow_notification_change_20, t0.allow_notification_change_emails AS allow_notification_change_emails_21, t0.generator_raynet AS generator_raynet_22, t0.raynet_instance AS raynet_instance_23, t0.raynet_username AS raynet_username_24, t0.raynet_password AS raynet_password_25, t0.web_header AS web_header_26, t0.web_desc AS web_desc_27, t0.web_params AS web_params_28, t0.web_company AS web_company_29, t0.web_files AS web_files_30, t0.web_link AS web_link_31, t0.web_order AS web_order_32, t0.active AS active_33, t0.min_count AS min_count_34, t0.currency AS currency_35, t0.price_secondary AS price_secondary_36, t0.digi_sign_access_key AS digi_sign_access_key_37, t0.digi_sign_secret_key AS digi_sign_secret_key_38, t0.generator_digi_sign AS generator_digi_sign_39, t0.digi_sign_branding AS digi_sign_branding_40, t0.reward AS reward_41, t0.vat AS vat_42, t0.material AS material_43, t0.margin AS margin_44, t0.short_desc AS short_desc_45, t0.long_desc AS long_desc_46, t0.use_gold_and_silver AS use_gold_and_silver_47, t0.gold_and_silver_key AS gold_and_silver_key_48, t0.gold_and_silver_product_id AS gold_and_silver_product_id_49, t0.vp_protocol_notification AS vp_protocol_notification_50, t0.vp_protocol_notification_delay AS vp_protocol_notification_delay_51, t0.use_adamna AS use_adamna_52, t0.adamna_api AS adamna_api_53, t0.adamna_token AS adamna_token_54, t0.adamna_identifier AS adamna_identifier_55, t0.adamna_user_id AS adamna_user_id_56, t0.invoice_payments_period AS invoice_payments_period_57, t0.invoice_payments_pvv AS invoice_payments_pvv_58, t0.created AS created_59, t0.changed AS changed_60, t0.ip AS ip_61, t0.company_id AS company_id_62, t0.template_id AS template_id_63, t0.primary_photo_id AS primary_photo_id_64, t0.template_valuable_paper_id AS template_valuable_paper_id_65, t0.template_valuable_paper_multi_id AS template_valuable_paper_multi_id_66, t0.template_valuable_paper_protocol_id AS template_valuable_paper_protocol_id_67, t0.created_user_id AS created_user_id_68, t0.changed_user_id AS changed_user_id_69 FROM product t0 WHERE t0.id = ?
Parameters:
[
121
]
|
0.57 ms (1.75%) |
1 |
SELECT t0.id AS id_1, t0.version AS version_2, t0.deleted AS deleted_3, t0.name AS name_4, t0.mime AS mime_5, t0.url AS url_6, t0.url_del AS url_del_7, t0.size AS size_8, t0.signed AS signed_9, t0.signi_contract_id AS signi_contract_id_10, t0.signi_state AS signi_state_11, t0.envelope_id AS envelope_id_12, t0.created AS created_13, t0.changed AS changed_14, t0.ip AS ip_15, t0.order_ent_id AS order_ent_id_16, t0.product_id AS product_id_17, t0.metal_id AS metal_id_18, t0.created_user_id AS created_user_id_19, t0.changed_user_id AS changed_user_id_20, t0.type, t0.json_file_id AS json_file_id_21 FROM file t0 WHERE t0.id = ? AND t0.type IN ('file', 'template', 'contract', 'signi', 'simple', 'digi_sign', 'photo', 'valuable', 'valuable_protocol')
Parameters:
[
3464
]
|
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\User |
|
App\Entity\Company | No errors. |
App\Entity\Order |
|
App\Entity\UserRelation |
|
App\Entity\InvoiceAutomation | No errors. |
App\Entity\InvoiceAutomationExpand | No errors. |
App\Entity\InterestPaidoff | No errors. |
App\Entity\InterestPaidoffReport | No errors. |
App\Entity\OrderEshop |
|
App\Entity\Product |
|
App\Entity\File\File | No errors. |
App\Entity\File\Photo | No errors. |
App\Entity\CompanyGroup | No errors. |
App\Entity\File\CompanyFile |
|
App\Entity\File\Template | No errors. |
App\Entity\File\Contract | No errors. |
App\Entity\File\Signi | No errors. |
App\Entity\File\SimpleFile | No errors. |
App\Entity\File\DigiSign | No errors. |
App\Entity\File\ValuableFile | No errors. |
App\Entity\File\ValuableProtocolFile | No errors. |
App\Entity\ProductParameter |
|
App\Entity\File\ProductFile | No errors. |