Query Metrics
21
Database Queries
13
Different statements
523.51 ms
Query time
0
Invalid entities
Queries
default connection
tenant connection
#▲ | Time | Info |
---|---|---|
1 | 19.49 ms |
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[] |
2 | 19.47 ms |
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:
[] |
3 | 20.75 ms |
SELECT r0_.id AS id_0, u1_.id AS id_1, i2_.image AS image_2, i3_.image AS image_3, r4_.nombre AS nombre_4, u1_.nombre AS nombre_5, u1_.apellidos AS apellidos_6, l5_.locale AS locale_7, r0_.fecha_sorteo AS fecha_sorteo_8, DATEDIFF(r0_.fecha_sorteo, CURRENT_DATE) AS sclr_9, r6_.valor AS valor_10, c7_.symbol AS symbol_11, c7_.iso AS iso_12 FROM rifa r0_ INNER JOIN usuario u1_ ON (u1_.id = r0_.gestor_id) INNER JOIN rifa_translation r4_ ON (r0_.id = r4_.objeto_id) INNER JOIN rifa_currency r6_ ON (r0_.id = r6_.objeto_id) INNER JOIN estado_rifa e8_ ON (e8_.id = r0_.estado_id) INNER JOIN locale l5_ ON r4_.locale_id = l5_.id INNER JOIN currency c7_ ON r6_.currency_id = c7_.id LEFT JOIN imagen i3_ ON (r0_.imagen_base_id = i3_.id) LEFT JOIN imagen i2_ ON (u1_.imagen_perfil_principal_id = i2_.id) WHERE r0_.destacado = 1 AND e8_.ref = ? AND r0_.fecha_fin >= CURRENT_DATE AND c7_.iso = ? ORDER BY r0_.created_at DESC LIMIT 10
Parameters:
[ "APROBADA" "COP" ] |
4 | 19.98 ms |
SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.apellidos AS apellidos_2, u0_.numero_rifas AS numero_rifas_3, u0_.calificacion AS calificacion_4, i1_.image AS image_5 FROM usuario u0_ LEFT JOIN imagen i1_ ON (i1_.id = u0_.imagen_perfil_principal_id) INNER JOIN estado_solicitud e2_ ON (e2_.id = u0_.estado_gestor_id) WHERE u0_.destacado = 1 AND JSON_CONTAINS(u0_.roles, ?) = 1 AND e2_.nombre = ? AND u0_.activo = 1 LIMIT 10
Parameters:
[ ""ROLE_GESTOR"" "Aprobado" ] |
5 | 19.41 ms |
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[] |
6 | 19.41 ms |
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:
[
""
"es"
]
|
7 | 19.52 ms |
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:
[ "/" "es" ] |
8 | 84.96 ms |
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:
[] |
9 | 24.13 ms |
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, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_5 FROM imagen i0_ INNER JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) INNER JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 GROUP BY i0_.id ORDER BY i0_.orden ASC
Parameters:
[] |
10 | 20.01 ms |
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_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 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:
[
"principal_banner_home"
]
|
11 | 19.96 ms |
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_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 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:
[
"main_banner_home"
]
|
12 | 20.02 ms |
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_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 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:
[
"principal_banner_home"
]
|
13 | 60.77 ms |
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:
[] |
14 | 20.34 ms |
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_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 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"
]
|
15 | 19.90 ms |
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_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 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:
[
"social_media"
]
|
16 | 19.22 ms |
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\General\Currency | No errors. |
App\Entity\Rifa\Rifa | No errors. |
App\Entity\Usuario\Usuario | No errors. |
App\Entity\Rifa\RifaTranslation | No errors. |
App\Entity\Rifa\RifaCurrency | No errors. |
App\Entity\Rifa\EstadoRifa | No errors. |
App\Entity\General\Locale | No errors. |
App\Entity\General\Imagen | No errors. |
App\Entity\Solicitud\EstadoSolicitud | No errors. |
App\Entity\General\Seo | No errors. |
App\Entity\General\SeoTranslation | No errors. |
App\Entity\General\Texto | No errors. |
App\Entity\General\TextoTranslation | No errors. |
App\Entity\General\ImagenTranslation | No errors. |
App\Entity\General\Galeria | No errors. |
App\Entity\General\TextoBig | No errors. |
App\Entity\General\TextoBigTranslation | No errors. |
App\Entity\General\VersionAplicacion | No errors. |
App\Entity\General\VersionAplicacionTranslation | No errors. |