https://legacy-qa.grupoaviatur.com/

Query Metrics

7 Database Queries
3 Different statements
12.90 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.agency_id AS agency_id_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "aviatur_service_token"
]
2 1.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.agency_id AS agency_id_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "aviatur_ath"
]
3 1.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.agency_id AS agency_id_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "aval_public_key_auth"
]
4 1.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.agency_id AS agency_id_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "aval_url_mocks"
]
5 1.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.agency_id AS agency_id_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "aval_public_key_auth"
]
6 2.30 ms
SELECT t0.id AS id_1, t0.externalId AS externalId_2, t0.officeId AS officeId_3, t0.name AS name_4, t0.nit AS nit_5, t0.phone AS phone_6, t0.address AS address_7, t0.mailContact AS mailContact_8, t0.mailBooking AS mailBooking_9, t0.mailOperations AS mailOperations_10, t0.mailVouchers AS mailVouchers_11, t0.domain AS domain_12, t0.domainSecure AS domainSecure_13, t0.domainOld AS domainOld_14, t0.urlRoute AS urlRoute_15, t0.idClientFacebook AS idClientFacebook_16, t0.idClientGoogle AS idClientGoogle_17, t0.customPort AS customPort_18, t0.phonesContact AS phonesContact_19, t0.socialmedia AS socialmedia_20, t0.assets_folder AS assets_folder_21, t0.twigFlux AS twigFlux_22, t0.customer_id AS customer_id_23 FROM agency t0 WHERE t0.domainSecure IN (?, ?) LIMIT 1
Parameters:
[
  "legacy-qa.grupoaviatur.com"
  "legacy-qa.grupoaviatur.com"
]
7 1.86 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.referer AS referer_4, t0.embebed AS embebed_5, t0.phone AS phone_6, t0.address AS address_7, t0.email AS email_8, t0.officeId AS officeId_9, t0.phonesContact AS phonesContact_10, t0.agency_id AS agency_id_11 FROM whitemark t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "legacy-qa.grupoaviatur.com"
]

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
Aviatur\GeneralBundle\Entity\Parameter No errors.
Aviatur\AgencyBundle\Entity\Agency
  • The field Aviatur\AgencyBundle\Entity\Agency#customer is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity Aviatur\CustomerBundle\Entity\Customer#agency does not contain the required 'mappedBy="customer"' attribute.
  • If association Aviatur\AgencyBundle\Entity\Agency#customer is one-to-one, then the inversed side Aviatur\CustomerBundle\Entity\Customer#agency has to be one-to-one as well.
  • The association Aviatur\AgencyBundle\Entity\Agency#adminFeeActivityLog refers to the owning side field Aviatur\FlightBundle\Entity\AdminFeeActivityLog#order which does not exist.
  • The mappings Aviatur\AgencyBundle\Entity\Agency#configFlightAgencyActivityLog and Aviatur\FlightBundle\Entity\ConfigFlightAgencyActivityLog#agency are inconsistent with each other.
FOS\OAuthServerBundle\Entity\Client No errors.
Aviatur\RestBundle\Entity\OauthClient No errors.
FOS\OAuthServerBundle\Entity\AccessToken No errors.
Aviatur\RestBundle\Entity\OauthAccesstoken No errors.
FOS\OAuthServerBundle\Entity\RefreshToken No errors.
Aviatur\RestBundle\Entity\OauthRefreshtoken No errors.
FOS\UserBundle\Model\User No errors.
Aviatur\CustomerBundle\Entity\Customer No errors.
Aviatur\GeneralBundle\Entity\Whitemark No errors.