Query Metrics
7
Database Queries
6
Different statements
7.35 ms
Query time
7
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.99 ms |
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
]
|
2 | 1.34 ms |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.merchant_code AS merchant_code_3, t0.product_count AS product_count_4, t0.product_price AS product_price_5, t0.product_tax AS product_tax_6, t0.name AS name_7, t0.surname AS surname_8, t0.person_type AS person_type_9, t0.nationality AS nationality_10, t0.tax_residency AS tax_residency_11, t0.address AS address_12, t0.street AS street_13, t0.town AS town_14, t0.postal AS postal_15, t0.address2 AS address2_16, t0.street2 AS street2_17, t0.town2 AS town2_18, t0.postal2 AS postal2_19, t0.ic AS ic_20, t0.dic AS dic_21, t0.birthdate AS birthdate_22, t0.phone AS phone_23, t0.email AS email_24, t0.bank_name AS bank_name_25, t0.bank_account AS bank_account_26, t0.swift AS swift_27, t0.iban AS iban_28, t0.id_type AS id_type_29, t0.id_number AS id_number_30, t0.id_author AS id_author_31, t0.id_validity AS id_validity_32, t0.businessman_registration_place AS businessman_registration_place_33, t0.businessman_registration_number AS businessman_registration_number_34, t0.company_registration_place AS company_registration_place_35, t0.company_registration_number AS company_registration_number_36, t0.company_registration_partition AS company_registration_partition_37, t0.company_registration_insertion AS company_registration_insertion_38, t0.company_representantive AS company_representantive_39, t0.sign_place_user AS sign_place_user_40, t0.message AS message_41, t0.consent1 AS consent1_42, t0.consent2 AS consent2_43, t0.consent3 AS consent3_44, t0.consent4 AS consent4_45, t0.consent5 AS consent5_46, t0.consent6 AS consent6_47, t0.sign_date_user AS sign_date_user_48, t0.sign_place_company AS sign_place_company_49, t0.sign_date_company AS sign_date_company_50, t0.product_interest AS product_interest_51, t0.product_price_total AS product_price_total_52, t0.product_price_total_in_words AS product_price_total_in_words_53, t0.api_valid_till AS api_valid_till_54, t0.id_type_other AS id_type_other_55, t0.same_address AS same_address_56, t0.deleted AS deleted_57, t0.due_date AS due_date_58, t0.what_generated AS what_generated_59, t0.bank_code AS bank_code_60, t0.api_income AS api_income_61, t0.signed AS signed_62, t0.signed_date AS signed_date_63, t0.paid AS paid_64, t0.paid_date AS paid_date_65, t0.vp_delivery AS vp_delivery_66, t0.vp_delivery_date AS vp_delivery_date_67, t0.sent AS sent_68, t0.sent_date AS sent_date_69, t0.storno AS storno_70, t0.storno_date AS storno_date_71, t0.raynet_id AS raynet_id_72, t0.reinvest AS reinvest_73, t0.paid2 AS paid2_74, t0.paid_date2 AS paid_date2_75, t0.product_price_secondary_total AS product_price_secondary_total_76, t0.product_price_secondary_total_in_words AS product_price_secondary_total_in_words_77, t0.in_progress AS in_progress_78, t0.in_progress_date AS in_progress_date_79, t0.sequence_number AS sequence_number_80, t0.vp_protocol_sent AS vp_protocol_sent_81, t0.vp_protocol_blocked_for_send AS vp_protocol_blocked_for_send_82, t0.birthnumber AS birthnumber_83, t0.origin_of_funds AS origin_of_funds_84, t0.origin_of_funds_custom AS origin_of_funds_custom_85, t0.politically_exposed_person AS politically_exposed_person_86, t0.created AS created_87, t0.changed AS changed_88, t0.ip AS ip_89, t0.user_id AS user_id_90, t0.merchant_id AS merchant_id_91, t0.company_id AS company_id_92, t0.product_id AS product_id_93, t0.created_user_id AS created_user_id_94, t0.changed_user_id AS changed_user_id_95, t0.type, t0.company_name AS company_name_96, t0.gold_and_silver_api_response AS gold_and_silver_api_response_97, t0.total_price_excl_vat AS total_price_excl_vat_98, t0.total_price_vat AS total_price_vat_99, t0.total_price_incl_vat AS total_price_incl_vat_100, t0.delivery_price AS delivery_price_101, t0.delivery_label AS delivery_label_102, t0.payment_price AS payment_price_103, t0.payment_label AS payment_label_104 FROM `order` t0 WHERE t0.id = ? AND t0.type IN ('base', 'eshop')
Parameters:
[
"2534"
]
|
3 | 0.82 ms |
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:
[
40
]
|
4 | 0.71 ms |
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:
[
2
]
|
5 | 1.08 ms |
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:
[
122
]
|
6 | 0.72 ms |
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:
[
4057
]
|
7 | 0.69 ms |
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.order_ent_id = ? AND t0.type IN ('file', 'template', 'contract', 'signi', 'simple', 'digi_sign', 'photo', 'valuable', 'valuable_protocol')
Parameters:
[
2534
]
|
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\Product |
|
App\Entity\OrderEshop |
|
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. |