GET https://main-dev.2d-armony.it/

Query Metrics

5 Database Queries
5 Different statements
14.20 ms Query time
2 Invalid entities
76 Managed entities

Queries

Group similar statements

# Time Info
1 1.81 ms
SELECT t0.id AS id_1, t0.data_creazione AS data_creazione_2, t0.data_ultima_modifica AS data_ultima_modifica_3, t0.title AS title_4, t0.value AS value_5, t0.description AS description_6, t0.is_active AS is_active_7, t0.id_creatore AS id_creatore_8, t0.id_aggiornatore AS id_aggiornatore_9 FROM admin_config t0 WHERE t0.title = ?
Parameters:
[
  "isMaintenance"
]
2 2.69 ms
SELECT t0.data_creazione AS data_creazione_1, t0.data_ultima_modifica AS data_ultima_modifica_2, t0.nome AS nome_3, t0.module_name AS module_name_4, t0.slug AS slug_5, t0.note AS note_6, t0.is_active AS is_active_7, t0.id_servizio AS id_servizio_8, t0.id_creatore AS id_creatore_9, t0.id_aggiornatore AS id_aggiornatore_10 FROM servizio t0
Parameters:
[]
3 1.80 ms
SELECT c0_.data_creazione AS data_creazione_0, c0_.data_ultima_modifica AS data_ultima_modifica_1, c0_.titolo AS titolo_2, c0_.servizio AS servizio_3, c0_.chiave AS chiave_4, c0_.type AS type_5, c0_.options AS options_6, c0_.valore AS valore_7, c0_.descrizione AS descrizione_8, c0_.ordine AS ordine_9, c0_.id_configurazione AS id_configurazione_10, c0_.id_creatore AS id_creatore_11, c0_.id_aggiornatore AS id_aggiornatore_12, c0_.id_organizzazione AS id_organizzazione_13 FROM configurazione c0_ WHERE 1 = 1 AND c0_.id_organizzazione = ?
Parameters:
[
  null
]
4 3.14 ms
SELECT t0.data_creazione AS data_creazione_1, t0.data_ultima_modifica AS data_ultima_modifica_2, t0.nome AS nome_3, t0.note AS note_4, t0.org_params AS org_params_5, t0.max_users AS max_users_6, t0.historicize_days AS historicize_days_7, t0.language AS language_8, t0.org_prefix AS org_prefix_9, t0.org_slug AS org_slug_10, t0.secret AS secret_11, t0.is_active AS is_active_12, t0.id_organizzazione AS id_organizzazione_13, t0.id_creatore AS id_creatore_14, t0.id_aggiornatore AS id_aggiornatore_15, t0.id_avatar AS id_avatar_16 FROM organizzazione t0 WHERE t0.is_active = ? ORDER BY t0.nome ASC
Parameters:
[
  1
]
5 4.78 ms
SELECT t0.id AS id_1, t0.data_creazione AS data_creazione_2, t0.data_ultima_modifica AS data_ultima_modifica_3, t0.titolo AS titolo_4, t0.descrizione AS descrizione_5, t0.private_description AS private_description_6, t0.erp_cod AS erp_cod_7, t0.major_num AS major_num_8, t0.minor_num AS minor_num_9, t0.revision_num AS revision_num_10, t0.build_num AS build_num_11, t0.release_date AS release_date_12, t0.visible AS visible_13, t0.is_active AS is_active_14, t0.id_creatore AS id_creatore_15, t0.id_aggiornatore AS id_aggiornatore_16 FROM saas_release t0 WHERE t0.visible = ? ORDER BY t0.major_num DESC, t0.minor_num DESC, t0.revision_num DESC LIMIT 1
Parameters:
[
  1
]

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\Module 41
App\Entity\Organizzazione 18
App\Entity\Allegato 9
App\Entity\User 6
App\Entity\AdminConfig 1
App\Entity\Release 1

Entities Mapping

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\AdminConfig No errors.
App\Entity\User
  • The field App\Entity\User#managedTasks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Task#creatore does not contain the required 'inversedBy="managedTasks"' attribute.
App\Entity\Module No errors.
App\Entity\Role No errors.
App\Entity\Abilitazione No errors.
App\Entity\ReleaseNote No errors.
App\Entity\BaseOrgEntity No errors.
App\Entity\Configurazione No errors.
App\Entity\Organizzazione
  • The field App\Entity\Organizzazione#configParameters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Configurazione#orgProprietaria does not contain the required 'inversedBy="configParameters"' attribute.
  • The field App\Entity\Organizzazione#paymentTerms is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaymentTerm#orgProprietaria does not contain the required 'inversedBy="paymentTerms"' attribute.
  • The field App\Entity\Organizzazione#deviceTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DeviceType#orgProprietaria does not contain the required 'inversedBy="deviceTypes"' attribute.
  • The field App\Entity\Organizzazione#devices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Device#orgProprietaria does not contain the required 'inversedBy="devices"' attribute.
  • The field App\Entity\Organizzazione#vatTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TipoIva#orgProprietaria does not contain the required 'inversedBy="vatTypes"' attribute.
  • The field App\Entity\Organizzazione#contacts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contatto#orgProprietaria does not contain the required 'inversedBy="contacts"' attribute.
  • The field App\Entity\Organizzazione#smtpTransfers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SmtpTransfer#orgProprietaria does not contain the required 'inversedBy="smtpTransfers"' attribute.
  • The field App\Entity\Organizzazione#homeNotifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HomeNotification#orgProprietaria does not contain the required 'inversedBy="homeNotifications"' attribute.
App\Entity\Allegato No errors.
App\Entity\RandomToken No errors.
App\Entity\Appartenenza No errors.
App\Entity\Agency No errors.
App\Entity\PaymentTerm No errors.
App\Entity\DeviceType No errors.
App\Entity\Device No errors.
App\Entity\TipoIva No errors.
App\Entity\Contatto No errors.
App\Entity\SmtpTransfer No errors.
App\Entity\HomeNotification No errors.
App\Entity\JsonCategory No errors.
App\Entity\Release No errors.