| 1 |
0.91 ms |
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 = ?
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 = 1;
|
| 2 |
0.43 ms |
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 = ?
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 = 1;
|
| 3 |
0.67 ms |
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
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 = 1 ORDER BY t0.nombre ASC;
|
| 4 |
0.42 ms |
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.activo = ? ORDER BY t0.nombre ASC
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.activo = 1 ORDER BY t0.nombre ASC;
|
| 5 |
11.37 ms |
SELECT t0_.id AS id_0, t0_.clave AS clave_1, t0_.etiqueta AS etiqueta_2, t0_.tipo AS tipo_3, t0_.requerido AS requerido_4, t0_.opciones AS opciones_5, t0_.orden AS orden_6 FROM transfer_form_field t0_ ORDER BY t0_.orden ASC, t0_.id ASC
SELECT t0_.id AS id_0, t0_.clave AS clave_1, t0_.etiqueta AS etiqueta_2, t0_.tipo AS tipo_3, t0_.requerido AS requerido_4, t0_.opciones AS opciones_5, t0_.orden AS orden_6 FROM transfer_form_field t0_ ORDER BY t0_.orden ASC, t0_.id ASC;
|
| 6 |
5.82 ms |
SELECT v0_.id AS id_0, v0_.nombre AS nombre_1, v0_.descripcion AS descripcion_2, v0_.activo AS activo_3, v0_.orden AS orden_4, v0_.creado_en AS creado_en_5, v0_.actualizado_en AS actualizado_en_6 FROM vehicle_type v0_ WHERE v0_.activo = ? ORDER BY v0_.orden ASC, v0_.nombre ASC
SELECT v0_.id AS id_0, v0_.nombre AS nombre_1, v0_.descripcion AS descripcion_2, v0_.activo AS activo_3, v0_.orden AS orden_4, v0_.creado_en AS creado_en_5, v0_.actualizado_en AS actualizado_en_6 FROM vehicle_type v0_ WHERE v0_.activo = 1 ORDER BY v0_.orden ASC, v0_.nombre ASC;
|
| 7 |
15.99 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.nombre_completo AS nombre_completo_1, d0_.documento AS documento_2, d0_.telefono AS telefono_3, d0_.patente AS patente_4, d0_.modelo_vehiculo AS modelo_vehiculo_5, d0_.tipo_vehiculo AS tipo_vehiculo_6, d0_.foto_vehiculo AS foto_vehiculo_7, d0_.aprobado AS aprobado_8, d0_.notas AS notas_9, d0_.commission_percentage AS commission_percentage_10, d0_.cbu AS cbu_11, d0_.cvu AS cvu_12, d0_.bank_alias AS bank_alias_13, d0_.creado_en AS creado_en_14, d0_.actualizado_en AS actualizado_en_15, v1_.id AS id_16, v1_.nombre AS nombre_17, v1_.descripcion AS descripcion_18, v1_.activo AS activo_19, v1_.orden AS orden_20, v1_.creado_en AS creado_en_21, v1_.actualizado_en AS actualizado_en_22, v2_.id AS id_23, v2_.nombre AS nombre_24, v2_.descripcion AS descripcion_25, v2_.activo AS activo_26, v2_.creado_en AS creado_en_27, v2_.actualizado_en AS actualizado_en_28, d0_.usuario_id AS usuario_id_29, d0_.vehicle_type_id AS vehicle_type_id_30 FROM driver_profile d0_ LEFT JOIN vehicle_type v1_ ON d0_.vehicle_type_id = v1_.id LEFT JOIN driver_profile_vehicle_feature d3_ ON d0_.id = d3_.driver_profile_id LEFT JOIN vehicle_feature v2_ ON v2_.id = d3_.vehicle_feature_id WHERE d0_.aprobado = ? AND v1_.id IN (?, ?) ORDER BY v1_.orden ASC, d0_.nombre_completo ASC
SELECT DISTINCT d0_.id AS id_0, d0_.nombre_completo AS nombre_completo_1, d0_.documento AS documento_2, d0_.telefono AS telefono_3, d0_.patente AS patente_4, d0_.modelo_vehiculo AS modelo_vehiculo_5, d0_.tipo_vehiculo AS tipo_vehiculo_6, d0_.foto_vehiculo AS foto_vehiculo_7, d0_.aprobado AS aprobado_8, d0_.notas AS notas_9, d0_.commission_percentage AS commission_percentage_10, d0_.cbu AS cbu_11, d0_.cvu AS cvu_12, d0_.bank_alias AS bank_alias_13, d0_.creado_en AS creado_en_14, d0_.actualizado_en AS actualizado_en_15, v1_.id AS id_16, v1_.nombre AS nombre_17, v1_.descripcion AS descripcion_18, v1_.activo AS activo_19, v1_.orden AS orden_20, v1_.creado_en AS creado_en_21, v1_.actualizado_en AS actualizado_en_22, v2_.id AS id_23, v2_.nombre AS nombre_24, v2_.descripcion AS descripcion_25, v2_.activo AS activo_26, v2_.creado_en AS creado_en_27, v2_.actualizado_en AS actualizado_en_28, d0_.usuario_id AS usuario_id_29, d0_.vehicle_type_id AS vehicle_type_id_30 FROM driver_profile d0_ LEFT JOIN vehicle_type v1_ ON d0_.vehicle_type_id = v1_.id LEFT JOIN driver_profile_vehicle_feature d3_ ON d0_.id = d3_.driver_profile_id LEFT JOIN vehicle_feature v2_ ON v2_.id = d3_.vehicle_feature_id WHERE d0_.aprobado = 1 AND v1_.id IN (2, 1) ORDER BY v1_.orden ASC, d0_.nombre_completo ASC;
|
| 8 |
0.47 ms |
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 = ?
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 = 1;
|
| 9 |
0.33 ms |
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 = ?
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 = 1;
|
| 10 |
0.16 ms |
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 = ?
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 = 1;
|
| 11 |
0.14 ms |
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 = ?
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 = 3;
|
| 12 |
0.15 ms |
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 = ?
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 = 2;
|
| 13 |
0.22 ms |
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 = ?
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 = 2;
|
| 14 |
1.71 ms |
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_destination_id = ?
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_destination_id = 2;
|
| 15 |
0.44 ms |
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_destination_id = ?
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_destination_id = 1;
|
| 16 |
0.47 ms |
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
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 = 1 ORDER BY t0.posicion ASC;
|
| 17 |
0.30 ms |
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
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 = 2 ORDER BY t0.posicion ASC;
|