GET https://subotai.oomai.app/

Query Metrics

4 Database Queries
4 Different statements
4.69 ms Query time
2 Invalid entities
13 Managed entities

Queries

Group similar statements

# Time Info
1 2.75 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.entity_state AS entity_state_3, t0.label AS label_4, t0.billing_address AS billing_address_5, t0.shipping_address AS shipping_address_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.email AS email_10, t0.bank_account AS bank_account_11, t0.document_quotation_header AS document_quotation_header_12, t0.document_quotation_footer AS document_quotation_footer_13, t0.document_invoice_header AS document_invoice_header_14, t0.document_invoice_footer AS document_invoice_footer_15, t0.currency AS currency_16, t0.subdomain AS subdomain_17, t0.logo AS logo_18, t0.date_start AS date_start_19, t0.date_end AS date_end_20, t0.active AS active_21 FROM dm_lib_purchaser t0 WHERE t0.entity_state IN (?, ?, ?, ?) AND t0.active = ? AND t0.subdomain = ? LIMIT 1
Parameters:
[
  "new"
  "update"
  "valid"
  "archive"
  1
  "subotai"
]
2 0.63 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.entity_type AS entity_type_3, t0.value AS value_4, t0.description AS description_5, t0.css_class AS css_class_6, t0.active AS active_7 FROM dm_site_param t0 WHERE t0.entity_type IN (?, ?)
Parameters:
[
  "image_login_support"
  "support_introduction"
]
3 0.79 ms
SELECT d0_.id AS id_0, d0_.date_creation AS date_creation_1, d0_.entity_type AS entity_type_2, d0_.label AS label_3, d0_.hourly_rate AS hourly_rate_4, d0_.color AS color_5, d0_.icon AS icon_6, d0_.date_start AS date_start_7, d0_.date_end AS date_end_8, d0_.active AS active_9, d0_.purchaser_id AS purchaser_id_10 FROM dm_lib_task_category d0_ WHERE d0_.active = 1 AND d0_.entity_type = ? AND (d0_.date_start IS NULL OR d0_.date_start <= ?) AND (d0_.date_end IS NULL OR d0_.date_end >= ?) AND d0_.purchaser_id = ? ORDER BY d0_.label ASC
Parameters:
[
  "ticket"
  "2025-12-06"
  "2025-12-06"
  2
]
4 0.52 ms
SELECT d0_.id AS id_0, d0_.date_creation AS date_creation_1, d0_.label AS label_2, d0_.color AS color_3, d0_.date_start AS date_start_4, d0_.date_end AS date_end_5, d0_.active AS active_6, d0_.position AS position_7 FROM dm_lib_generic_priority d0_ WHERE d0_.active = 1 ORDER BY d0_.position ASC
Parameters:
[]

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\LibTaskCategory 6
App\Entity\LibPriority 4
App\Entity\SiteParam 2
App\Entity\LibPurchaser 1

Entities Mapping

Class Mapping errors
App\Entity\LibPurchaser No errors.
App\Entity\LibCompany
  • The association App\Entity\LibCompany#billing_country refers to the inverse side field App\Entity\LibCountry#libCompanies which does not exist.
  • The association App\Entity\LibCompany#shipping_country refers to the inverse side field App\Entity\LibCountry#libCompanies which does not exist.
App\Entity\SiteAdminUser No errors.
App\Entity\LibCompanyContact No errors.
App\Entity\LibCompanyCategory No errors.
App\Entity\LibPurchaserDocument No errors.
App\Entity\FormLicence
  • The association App\Entity\FormLicence#licence_expires refers to the inverse side field App\Entity\LibLicenceExpires#formLicenses which does not exist.
App\Entity\FormTask No errors.
App\Entity\LibTaskCategory No errors.
App\Entity\FormProject No errors.
App\Entity\LibProjectCycle No errors.
App\Entity\LibProjectCategory No errors.
App\Entity\LibCompanySize No errors.
App\Entity\LibCompanyPaymentMethod No errors.
App\Entity\LibCompanyLeadSource No errors.
App\Entity\SiteParam No errors.
App\Entity\LibPriority No errors.