Query Metrics
6
Database Queries
6
Different statements
8.79 ms
Query time
4
Invalid entities
76
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.84 ms (20.91%) |
1 |
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"
]
|
|
1.83 ms (20.85%) |
1 |
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
]
|
|
1.58 ms (17.94%) |
1 |
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
]
|
|
1.35 ms (15.32%) |
1 |
SELECT DATABASE()
Parameters:
[] |
|
1.14 ms (12.92%) |
1 |
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:
[] |
|
1.06 ms (12.05%) |
1 |
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
]
|
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 |
|
| 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 |
|
| 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. |
| App\Entity\TimeSchedule | No errors. |
| App\Entity\StageModelCategory | No errors. |
| App\Entity\LinkedExpert | No errors. |
| App\Entity\ArmonyNotification | No errors. |
| App\Entity\PostponedAction | No errors. |
| App\Entity\AccessBadge | No errors. |
| App\Entity\ProductionLine | No errors. |
| App\Entity\AccessLog | No errors. |
| App\Entity\Maintenance | No errors. |
| App\Entity\TeamMember | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\Progetto | No errors. |
| App\Entity\Item | No errors. |
| App\Entity\UserProductionBatch | No errors. |
| App\Entity\ProductionBatch |
|
| App\Entity\Campaign | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\TaskInterval | No errors. |
| App\Entity\PackingAssignment | No errors. |
| App\Entity\Contratto | No errors. |
| App\Entity\UserRole | No errors. |
| App\Entity\RoleOrg | No errors. |
| App\Entity\TipoAllegato | No errors. |
| App\Entity\Instruction | No errors. |
| App\Entity\RealEstate | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\ItemCategory | No errors. |
| App\Entity\Powwow | No errors. |
| App\Entity\DeliveryNote | No errors. |
| App\Entity\Product |
|
| App\Entity\Bom | No errors. |
| App\Entity\ProcedureModel | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\SerialNumber | No errors. |
| App\Entity\ApplicableDocumentCategory | No errors. |
| App\Entity\CanaleOnline | No errors. |
| App\Entity\Ceppo | No errors. |
| App\Entity\CeppoBatch | No errors. |
| App\Entity\Procedure | No errors. |
| App\Entity\Fattura | No errors. |
| App\Entity\CostDocument | No errors. |
| App\Entity\InstrumentCalibration | No errors. |
| App\Entity\MetrologicalConfirmation | No errors. |
| App\Entity\MeasuringInstrument | No errors. |
| App\Entity\HumanResourceCheck | No errors. |
| App\Entity\CostDocumentInvoice | No errors. |
| App\Entity\CeppoBatchEmail | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Municipality | No errors. |
| App\Entity\ProcedureModelDeviceType | No errors. |
| App\Entity\ProductionCycleStageModelDeviceCategory | No errors. |
| App\Entity\PriceList | No errors. |
| App\Entity\DeviceEvent | No errors. |
| App\Entity\DeviceChannel | No errors. |
| App\Entity\DeviceSample | No errors. |
| App\Entity\Cadenza | No errors. |
| App\Entity\DeviceCategory | No errors. |
| App\Entity\Simulation | No errors. |
| App\Entity\ProductionCycleStageModel | No errors. |
| App\Entity\ProcedureDevice | No errors. |
| App\Entity\ProductionBatchStageDevice | No errors. |
| App\Entity\DeviceRoom | No errors. |
| App\Entity\MaintenancePlan | No errors. |
| App\Entity\ContractRow | No errors. |
| App\Entity\ChartAccount | No errors. |
| App\Entity\CustomerCategory | No errors. |
| App\Entity\Agent | No errors. |
| App\Entity\DraftMovement | No errors. |
| App\Entity\JournalEntry | No errors. |
| App\Entity\Discount | No errors. |
| App\Entity\CourseModel | No errors. |
| App\Entity\CourseInstance | No errors. |
| App\Entity\CourseRegistration | No errors. |
| App\Entity\FidelityCard | No errors. |
| App\Entity\ContactAgent | No errors. |
| App\Entity\RealEstateDesire | No errors. |
| App\Entity\ContactBankAccount | No errors. |
| App\Entity\ContactPriceList | No errors. |
| App\Entity\Movement | No errors. |
| App\Entity\SitePage | No errors. |
| App\Entity\Annotation | No errors. |
| App\Entity\FilaQuote | No errors. |
| App\Entity\Recapito | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\ContactAccount | No errors. |
| App\Entity\Commento | No errors. |
| App\Entity\Quote | No errors. |
| App\Entity\OutgoingInvoice | No errors. |
| App\Entity\PersonContact | No errors. |
| App\Entity\ContactPairing | No errors. |
| App\Entity\CurrencyCausalCode | No errors. |
| App\Entity\CommoditySector | No errors. |
| App\Entity\ContactPool | No errors. |
| App\Entity\ContactSource | No errors. |
| App\Entity\ContactGroup | No errors. |
| App\Entity\PaymentMethod | No errors. |
| App\Entity\Reference | No errors. |
| App\Entity\Provincia | No errors. |
| App\Entity\Nazione | No errors. |