GET https://pedrobus.movilium.com/cotizador/get_vehiculos_ciudad?ciudad_id=5&pax=1

Query Metrics

4 Database Queries
4 Different statements
26.64 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 4.17 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.locale AS locale_5, t0.descuento_traslados AS descuento_traslados_6, t0.descuento_disposiciones AS descuento_disposiciones_7, t0.descuento_cenas AS descuento_cenas_8, t0.descuento_excursiones AS descuento_excursiones_9, t0.descuento_circuitos AS descuento_circuitos_10, t0.entidad_id AS entidad_id_11 FROM `users` t0 WHERE t0.id = ?
Parameters:
[
  31
]
2 7.53 ms
SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.n_bases AS n_bases_6, e0_.n_vehiculos AS n_vehiculos_7, e0_.validado AS validado_8 FROM entidades e0_ WHERE e0_.dominio = ? AND e0_.validado = ?
Parameters:
[
  "pedrobus.movilium.com"
  1
]
3 5.77 ms
SELECT c0_.id AS id_0, c0_.color_principal AS color_principal_1, c0_.color_secundario AS color_secundario_2, c0_.logo_filename AS logo_filename_3, c0_.entidad_id AS entidad_id_4 FROM configuration c0_ WHERE c0_.entidad_id = ? AND c0_.entidad_id = ?
Parameters:
[
  3
  3
]
4 9.16 ms
SELECT vehiculos.*
            FROM vehiculos
            INNER JOIN tarifas_vehiculos ON vehiculos.id = tarifas_vehiculos.id_vehiculo
            INNER JOIN tarifas ON tarifas.id = tarifas_vehiculos.id_tarifa                    
            WHERE tarifas.id_ciudad = ?
            AND vehiculos.plazas >= ?
            AND vehiculos.entidad_id = 3 ORDER BY vehiculos.plazas
Parameters:
[
  5
  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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The field 'App\Entity\User#descuentoTraslados' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoDisposiciones' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoCenas' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoExcursiones' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoCircuitos' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Entidad
  • The field App\Entity\Entidad#usuarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#entidad does not contain the required 'inversedBy="usuarios"' attribute.
App\Entity\GvServicio No errors.
App\Entity\Configuration No errors.