GET https://travelonlineagency.shophardware.com.ar/traslados/combos/1

Query Metrics

14 Database Queries
10 Different statements
4.73 ms Query time
0 Invalid entities
75 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.89 ms
(18.85%)
2
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.moneda_id AS moneda_id_3, t0.booking_id AS booking_id_4, t0.transfer_destination_id AS transfer_destination_id_5, t0.transfer_combo_id AS transfer_combo_id_6 FROM precio t0 WHERE t0.transfer_combo_id = ?
Parameters:
[
  1
]
0.76 ms
(16.04%)
1
SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.lenguaje_id AS lenguaje_id_4, t0.plataforma_id AS plataforma_id_5 FROM traduccion_plataforma t0 WHERE t0.plataforma_id = ?
Parameters:
[
  1
]
0.64 ms
(13.61%)
2
SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.combo_id AS combo_id_3, t0.destino_id AS destino_id_4 FROM transfer_combo_destination t0 WHERE t0.combo_id = ? ORDER BY t0.posicion ASC
Parameters:
[
  1
]
0.54 ms
(11.43%)
3
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.simbolo AS simbolo_3, t0.codigo_iso AS codigo_iso_4, t0.metodos_pago AS metodos_pago_5, t0.habilitada AS habilitada_6 FROM moneda t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.45 ms
(9.49%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.traslados_od_libres AS traslados_od_libres_3, t0.tasa_traslados_def AS tasa_traslados_def_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.link_instagram AS link_instagram_7, t0.link_whatsapp AS link_whatsapp_8, t0.contacto_telefono AS contacto_telefono_9, t0.contacto_correo AS contacto_correo_10, t0.contacto_direccion AS contacto_direccion_11, t0.comision_booking_partner AS comision_booking_partner_12, t0.enable_mercado_pago_payments AS enable_mercado_pago_payments_13, t0.enable_pay_pal_payments AS enable_pay_pal_payments_14, t0.enable_cash_payments AS enable_cash_payments_15, t0.cash_payment_instructions AS cash_payment_instructions_16, t0.language_def_id AS language_def_id_17, t0.moneda_def_id AS moneda_def_id_18, t0.credenciales_pay_pal_id AS credenciales_pay_pal_id_19, t0.credenciales_mercado_pago_id AS credenciales_mercado_pago_id_20 FROM plataforma t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.44 ms
(9.36%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.activo AS activo_5, t0.imagen_portada AS imagen_portada_6, t0.moneda_id AS moneda_id_7 FROM transfer_combo t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.28 ms
(5.83%)
1
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.habilitado AS habilitado_5, t0.plataforma_id AS plataforma_id_6, t0.moneda_def_id AS moneda_def_id_7 FROM lenguaje t0 WHERE t0.habilitado = ?
Parameters:
[
  1
]
0.27 ms
(5.77%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.coordenadas_lat AS coordenadas_lat_4, t0.coordenadas_lng AS coordenadas_lng_5, t0.descripcion_corta AS descripcion_corta_6, t0.descripcion AS descripcion_7, t0.tarifa_base AS tarifa_base_8, t0.activo AS activo_9, t0.destacado_inicio AS destacado_inicio_10, t0.orden_destacado AS orden_destacado_11, t0.imagen_portada AS imagen_portada_12, t0.logo AS logo_13, t0.instagram AS instagram_14, t0.x AS x_15, t0.facebook AS facebook_16, t0.whatsapp AS whatsapp_17, t0.sitio_web AS sitio_web_18, t0.categoria_id AS categoria_id_19, t0.moneda_id AS moneda_id_20 FROM transfer_destination t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.23 ms
(4.90%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.activo AS activo_5, t0.imagen_portada AS imagen_portada_6, t0.moneda_id AS moneda_id_7 FROM transfer_combo t0 WHERE t0.activo = ? ORDER BY t0.nombre ASC
Parameters:
[
  1
]
0.22 ms
(4.72%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.icono AS icono_3, t0.color AS color_4, t0.bootstrap_icon_id AS bootstrap_icon_id_5 FROM transfer_destination_category t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\TraduccionPlataforma 52
App\Entity\Precio 6
App\Entity\Moneda 3
App\Entity\Lenguaje 3
App\Entity\TransferComboDestination 3
App\Entity\TransferCombo 2
App\Entity\TransferDestination 2
App\Entity\Plataforma 1
App\Entity\CredencialesPayPal 1
App\Entity\CredencialesMercadoPago 1
App\Entity\TransferDestinationCategory 1