Query Metrics
55
Database Queries
30
Different statements
1213.75 ms
Query time
4
Invalid entities
Grouped Statements
default connection
tenant connection
Time▼ | Count | Info |
---|---|---|
158.13 ms (13.03%) |
8 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_en AS image_en_3, t0.image_mobile AS image_mobile_4, t0.image_mobile_en AS image_mobile_en_5, t0.path AS path_6, t0.link AS link_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.orden AS orden_11, t0.llave AS llave_12, t0.galeria_id AS galeria_id_13, t0.rifa_id AS rifa_id_14 FROM imagen t0 WHERE t0.id = ?
Parameters:
[
681
]
|
117.73 ms (9.70%) |
6 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?
Parameters:
[
1
]
|
85.22 ms (7.02%) |
1 |
SELECT t0_.llave AS llave_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', t2_.valor)) AS sclr_1 FROM texto t0_ LEFT JOIN texto_translation t2_ ON t0_.id = t2_.objeto_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC
Parameters:
[] |
79.05 ms (6.51%) |
4 |
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale_id AS locale_id_6, t0.paquete_boleta_rifa_id AS paquete_boleta_rifa_id_7 FROM paquete_boleta_rifa_translation t0 WHERE t0.paquete_boleta_rifa_id = ?
Parameters:
[
1
]
|
61.49 ms (5.07%) |
3 |
SELECT i0_.llave AS llave_0, g1_.llave AS llave_1, i0_.path AS path_2, i0_.link AS link_3, i0_.image AS image_4, i0_.image_en AS image_en_5, i0_.image_mobile AS image_mobile_6, i0_.image_mobile_en AS image_mobile_en_7, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_8 FROM imagen i0_ INNER JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) LEFT JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 AND g1_.llave = ? GROUP BY i0_.id ORDER BY i0_.orden ASC
Parameters:
[
"credit_cards"
]
|
58.91 ms (4.85%) |
3 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.habilitado = ?
Parameters:
[
1
]
|
54.04 ms (4.45%) |
1 |
SELECT i0_.llave AS llave_0, g1_.llave AS llave_1, i0_.path AS path_2, i0_.link AS link_3, i0_.image AS image_4, i0_.image_en AS image_en_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 FROM imagen i0_ LEFT JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) LEFT JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 GROUP BY i0_.id ORDER BY i0_.orden ASC
Parameters:
[] |
45.06 ms (3.71%) |
1 |
SELECT t0_.llave AS llave_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', t2_.valor)) AS sclr_1 FROM texto_big t0_ LEFT JOIN texto_big_translation t2_ ON t0_.id = t2_.objeto_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC
Parameters:
[] |
39.98 ms (3.29%) |
2 |
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[] |
39.52 ms (3.26%) |
2 |
SELECT s0_.id AS id_0, s0_.url AS url_1, i1_.image AS image_2, s2_.titulo AS titulo_3, s2_.keywords AS keywords_4, s2_.descripcion AS descripcion_5 FROM seo s0_ LEFT JOIN seo_translation s2_ ON s0_.id = s2_.objeto_id LEFT JOIN locale l3_ ON s2_.locale_id = l3_.id LEFT JOIN imagen i1_ ON s0_.imagen_id = i1_.id WHERE s0_.url = ? AND l3_.locale = ?
Parameters:
[ "promo/rifa-de-hamburguesa-macdonals/160" "en" ] |
38.98 ms (3.21%) |
2 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.id = ?
Parameters:
[
1
]
|
21.01 ms (1.73%) |
1 |
SELECT a0_.llave AS llave_0, a0_.nombre AS nombre_1, a1_.archivo AS archivo_2 FROM archivo a1_ INNER JOIN archivo_publico a0_ ON a1_.archivo_publico_id = a0_.id
Parameters:
[] |
20.37 ms (1.68%) |
1 |
SELECT r0_.numero_fin - r0_.numero_inicio + 1 AS sclr_0, (SELECT COUNT(p1_.id) AS sclr_2 FROM producto p1_ WHERE p1_.rifa_id = r0_.id) AS sclr_1 FROM rifa r0_ WHERE r0_.id = ?
Parameters:
[
160
]
|
20.12 ms (1.66%) |
1 |
SELECT t0.id AS id_1, t0.numero_inicio AS numero_inicio_2, t0.numero_fin AS numero_fin_3, t0.pagadero_al_portador AS pagadero_al_portador_4, t0.destacado AS destacado_5, t0.created_at AS created_at_6, t0.fecha_sorteo AS fecha_sorteo_7, t0.visible AS visible_8, t0.imagen_principal AS imagen_principal_9, t0.paht_comprobante_propiedad AS paht_comprobante_propiedad_10, t0.comprobante_terminosy_condiciones AS comprobante_terminosy_condiciones_11, t0.compra_minima AS compra_minima_12, t0.compra_maxima AS compra_maxima_13, t0.fecha_inicio AS fecha_inicio_14, t0.fecha_fin AS fecha_fin_15, t0.fecha_declaracion AS fecha_declaracion_16, t0.envio_comentario AS envio_comentario_17, t0.updated_at AS updated_at_18, t0.contract_id AS contract_id_19, t0.es_suscripcion AS es_suscripcion_20, t0.numero_boletas_vendidas AS numero_boletas_vendidas_21, t0.alto_flujo AS alto_flujo_22, t0.gestor_id AS gestor_id_23, t0.loteria_asociada_id AS loteria_asociada_id_24, t0.imagen_base_id AS imagen_base_id_25, t0.comprobante_propiedad_id AS comprobante_propiedad_id_26, t0.archivo_terminos_condiciones_id AS archivo_terminos_condiciones_id_27, t0.estado_id AS estado_id_28, t0.archivo_declaracion_id AS archivo_declaracion_id_29, t30.id AS id_31, t30.created_at AS created_at_32, t30.updated_at AS updated_at_33, t30.rifa_id AS rifa_id_34 FROM rifa t0 LEFT JOIN acceso_rifa t30 ON t30.rifa_id = t0.id WHERE t0.id = ?
Parameters:
[
160
]
|
20.01 ms (1.65%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.nombre AS nombre_3, t0.documento AS documento_4, t0.email AS email_5, t0.telefono AS telefono_6, t0.red_social AS red_social_7, t0.aprueba_tyc AS aprueba_tyc_8, t0.destacado AS destacado_9, t0.numero_rifas AS numero_rifas_10, t0.password AS password_11, t0.roles AS roles_12, t0.apellidos AS apellidos_13, t0.activar_boletin AS activar_boletin_14, t0.perfil_red_social AS perfil_red_social_15, t0.calificacion AS calificacion_16, t0.imagen_perfil AS imagen_perfil_17, t0.nombre_gestor AS nombre_gestor_18, t0.apodo AS apodo_19, t0.fecha_nacimiento AS fecha_nacimiento_20, t0.fecha_expedicion AS fecha_expedicion_21, t0.editable AS editable_22, t0.imagen_banner AS imagen_banner_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.fecha_ultimo_login AS fecha_ultimo_login_26, t0.ultima_direccion_ip AS ultima_direccion_ip_27, t0.fecha_ultimo_cambio_clave AS fecha_ultimo_cambio_clave_28, t0.fecha_activacion AS fecha_activacion_29, t0.fecha_desactivacion AS fecha_desactivacion_30, t0.activo AS activo_31, t0.envio_comentario AS envio_comentario_32, t0.saldo_retirable AS saldo_retirable_33, t0.saldo_no_retirable AS saldo_no_retirable_34, t0.descripcion_perfil AS descripcion_perfil_35, t0.intentos_login AS intentos_login_36, t0.acepta_cookies AS acepta_cookies_37, t0.metodo_registro AS metodo_registro_38, t0.direccion AS direccion_39, t0.acepta_correos AS acepta_correos_40, t0.token AS token_41, t0.acepta_monitoreo_cta AS acepta_monitoreo_cta_42, t0.email_contacto AS email_contacto_43, t0.correo_verificado AS correo_verificado_44, t0.tipo_persona_id AS tipo_persona_id_45, t0.certificado_existencia_id AS certificado_existencia_id_46, t0.documento_representante_id AS documento_representante_id_47, t0.imagen_perfil_principal_id AS imagen_perfil_principal_id_48, t0.imagen_banner_principal_id AS imagen_banner_principal_id_49, t0.estado_gestor_id AS estado_gestor_id_50, t0.ciudad_id AS ciudad_id_51, t0.imagen_destacada_id AS imagen_destacada_id_52, t53.id AS id_54, t53.updated_at AS updated_at_55, t53.created_at AS created_at_56, t53.usuario_id AS usuario_id_57, t53.estado_id AS estado_id_58, t53.acceso_rifas_id AS acceso_rifas_id_59, t0.tipo_documento_id AS tipo_documento_id_60 FROM usuario t0 LEFT JOIN acceso t53 ON t53.usuario_id = t0.id WHERE t0.id = ?
Parameters:
[
182
]
|
20.00 ms (1.65%) |
1 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.currency_id AS currency_id_3, t0.objeto_id AS objeto_id_4 FROM rifa_currency t0 WHERE t0.objeto_id = ?
Parameters:
[
160
]
|
19.79 ms (1.63%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.numero_boletas AS numero_boletas_3, t0.posicion AS posicion_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM paquete_boleta_rifa t0 INNER JOIN rifa_paquete_boleta_rifa ON t0.id = rifa_paquete_boleta_rifa.paquete_boleta_rifa_id WHERE rifa_paquete_boleta_rifa.rifa_id = ?
Parameters:
[
160
]
|
19.79 ms (1.63%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.locale_id AS locale_id_4, t0.objeto_id AS objeto_id_5 FROM subcategoria_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
10
]
|
19.73 ms (1.63%) |
1 |
SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.categoria_nombre AS categoria_nombre_5, t0.updated_at AS updated_at_6, t0.llave AS llave_7, t0.padre_id AS padre_id_8 FROM subcategoria t0 INNER JOIN rifa_subcategoria ON t0.id = rifa_subcategoria.subcategoria_id WHERE rifa_subcategoria.rifa_id = ?
Parameters:
[
160
]
|
19.72 ms (1.62%) |
1 |
SELECT t0.id AS id_1, t0.orden AS orden_2, t0.visible AS visible_3, t0.perfil AS perfil_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.red_social_id AS red_social_id_7, t0.usuario_id AS usuario_id_8 FROM redes_sociales_usuario t0 WHERE t0.usuario_id = ?
Parameters:
[
182
]
|
19.68 ms (1.62%) |
1 |
SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3, t0.symbol AS symbol_4 FROM currency t0 WHERE t0.iso = ? LIMIT 1
Parameters:
[
"COP"
]
|
19.67 ms (1.62%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_en AS image_en_3, t0.image_mobile AS image_mobile_4, t0.image_mobile_en AS image_mobile_en_5, t0.path AS path_6, t0.link AS link_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.orden AS orden_11, t0.llave AS llave_12, t0.galeria_id AS galeria_id_13, t0.rifa_id AS rifa_id_14 FROM imagen t0 WHERE t0.rifa_id = ?
Parameters:
[
160
]
|
19.65 ms (1.62%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.es_random AS es_random_5, t0.created_at AS created_at_6 FROM tipo_seleccion_boleta t0 INNER JOIN rifa_tipo_seleccion_boleta ON t0.id = rifa_tipo_seleccion_boleta.tipo_seleccion_boleta_id WHERE rifa_tipo_seleccion_boleta.rifa_id = ?
Parameters:
[
160
]
|
19.62 ms (1.62%) |
1 |
SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3, t0.symbol AS symbol_4 FROM currency t0
Parameters:
[] |
19.58 ms (1.61%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.termino_caducidad AS termino_caducidad_3, t0.descripcion_premio AS descripcion_premio_4, t0.texto_publicidad AS texto_publicidad_5, t0.caracteristica_producto AS caracteristica_producto_6, t0.caracteristica_producto2 AS caracteristica_producto2_7, t0.caracteristica_producto3 AS caracteristica_producto3_8, t0.caracteristica_producto4 AS caracteristica_producto4_9, t0.caracteristica_producto5 AS caracteristica_producto5_10, t0.locale_id AS locale_id_11, t0.objeto_id AS objeto_id_12 FROM rifa_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
160
]
|
19.58 ms (1.61%) |
1 |
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.nombre AS nombre_3, t0.orden AS orden_4 FROM estado_rifa t0 WHERE t0.id = ?
Parameters:
[
4
]
|
19.46 ms (1.60%) |
1 |
SELECT v0_.id AS id_0, v0_.version AS version_1, v0_.created_at AS created_at_2, v0_.updated_at AS updated_at_3 FROM version_aplicacion v0_ ORDER BY v0_.id DESC LIMIT 1
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
tenant | doctrine.dbal.tenant_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
tenant | doctrine.orm.tenant_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
MultiTenancyBundle\Entity\Hostname | No errors. |
MultiTenancyBundle\Entity\Tenant | No errors. |
tenant entity manager
Class | Mapping errors |
---|---|
App\Entity\General\Setting | No errors. |
App\Entity\Rifa\Rifa | No errors. |
App\Entity\Usuario\Usuario | No errors. |
App\Entity\Rifa\LoteriaAsociada | No errors. |
App\Entity\General\Imagen | No errors. |
App\Entity\General\Archivo | No errors. |
App\Entity\Rifa\EstadoRifa | No errors. |
App\Entity\Blacklist\AccesoRifa | No errors. |
App\Entity\Rifa\RifaTranslation | No errors. |
App\Entity\Rifa\RifaCurrency | No errors. |
App\Entity\Catalogue\Subcategoria | No errors. |
App\Entity\Rifa\PaqueteBoletaRifa | No errors. |
App\Entity\Rifa\Boleta | No errors. |
App\Entity\Rifa\ZonaRifa | No errors. |
App\Entity\Catalogue\Producto |
|
App\Entity\Rifa\RifaComentarios | No errors. |
App\Entity\Rifa\TipoSeleccionBoleta | No errors. |
App\Entity\General\ContractEvent | No errors. |
App\Entity\General\Locale | No errors. |
App\Entity\Usuario\TipoDocumentoTraslation | No errors. |
App\Entity\Rifa\EstadoRifaTranslation | No errors. |
App\Entity\General\Currency | No errors. |
App\Entity\Rifa\TipoSeleccionBoletaLocale | No errors. |
App\Entity\General\Galeria | No errors. |
App\Entity\General\ImagenTranslation | No errors. |
App\Entity\General\Seo | No errors. |
App\Entity\Rifa\PaqueteBoletaRifaTranslation | No errors. |
App\Entity\Catalogue\Categoria |
|
App\Entity\Catalogue\SubcategoriaTranslation | No errors. |
App\Entity\General\TipoPersona | No errors. |
App\Entity\Solicitud\EstadoSolicitud | No errors. |
App\Entity\General\Ciudad | No errors. |
App\Entity\Blacklist\Acceso | No errors. |
App\Entity\Blacklist\EstadoAcceso | No errors. |
App\Entity\Usuario\TipoDocumento | No errors. |
App\Entity\Cart\Compra | No errors. |
App\Entity\General\ImagenCliente | No errors. |
App\Entity\General\RedesSocialesUsuario | No errors. |
App\Entity\Usuario\UsuarioDescripcion | No errors. |
App\Entity\General\SolicitudEdicion | No errors. |
App\Entity\Usuario\DatosBancarios | No errors. |
App\Entity\Solicitud\SolicitudPago | No errors. |
App\Entity\Movimiento\RetiroGestor | No errors. |
App\Entity\Usuario\UsuarioEdicion | No errors. |
App\Entity\Usuario\UsuarioComentarios | No errors. |
App\Entity\Usuario\GrupoUsuario | No errors. |
App\Entity\Blacklist\AccesoGestor | No errors. |
App\Entity\Usuario\Funcion | No errors. |
App\Entity\Usuario\UsuarioEventoLog | No errors. |
App\Entity\General\EventoSignificativo | No errors. |
App\Entity\Cart\Retencion | No errors. |
App\Entity\Suscripcion\Suscripcion |
|
App\Entity\Suscripcion\Plan |
|
App\Entity\General\MetodoPago | No errors. |
App\Entity\Afiliacion\LinkAfiliacion | No errors. |
App\Entity\Usuario\UsuarioOtp | No errors. |
App\Entity\Usuario\ApiToken | No errors. |
App\Entity\General\RedesSociales | No errors. |
App\Entity\General\SeoTranslation | No errors. |
App\Entity\General\Texto | No errors. |
App\Entity\General\TextoTranslation | No errors. |
App\Entity\General\TextoBig | No errors. |
App\Entity\General\TextoBigTranslation | No errors. |
App\Entity\General\ArchivoPublico | No errors. |
App\Entity\General\VersionAplicacion | No errors. |
App\Entity\General\VersionAplicacionTranslation | No errors. |