Query Metrics
23
Database Queries
16
Different statements
714.76 ms
Query time
0
Invalid entities
Grouped Statements
default connection
tenant connection
Time▼ | Count | Info |
---|---|---|
145.53 ms (20.36%) |
2 |
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:
[] |
56.03 ms (7.84%) |
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:
[] |
50.80 ms (7.11%) |
2 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.visible AS visible_2, t0_.orden AS orden_3 FROM tipo_persona t0_ LEFT JOIN tipo_persona_translation t1_ ON t0_.id = t1_.objeto_id LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id WHERE l2_.locale = ? AND t0_.visible = 1 ORDER BY t0_.orden ASC
Parameters:
[
"es"
]
|
50.11 ms (7.01%) |
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:
[ "registro/gestor" "es" ] |
50.11 ms (7.01%) |
2 |
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[] |
49.92 ms (6.98%) |
2 |
SELECT t0.id AS id_1, t0.nombre_tipo AS nombre_tipo_2, t0.locale_id AS locale_id_3, t0.objeto_id AS objeto_id_4 FROM tipo_persona_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
1
]
|
33.72 ms (4.72%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.orden AS orden_2, c0_.visible AS visible_3, c0_.cod_mu AS cod_mu_4, c0_.postal AS postal_5, c0_.state_code AS state_code_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.city_code AS city_code_9, c0_.departamento_id AS departamento_id_10, c0_.pais_id AS pais_id_11 FROM ciudad c0_ INNER JOIN pais p1_ ON c0_.pais_id = p1_.id WHERE p1_.iso3 = ? ORDER BY c0_.nombre ASC
Parameters:
[
"COL"
]
|
29.58 ms (4.14%) |
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, 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:
[] |
25.66 ms (3.59%) |
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_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"
]
|
25.35 ms (3.55%) |
1 |
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.entity AS entity_3, t0.visible AS visible_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM display_field_configuration t0 WHERE t0.visible = ?
Parameters:
[
1
]
|
25.12 ms (3.51%) |
1 |
SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.dominio AS dominio_2, r0_.orden AS orden_3, r0_.visible AS visible_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.icono_id AS icono_id_7 FROM redes_sociales r0_ WHERE r0_.visible = 1 ORDER BY r0_.orden ASC
Parameters:
[] |
24.97 ms (3.49%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2 FROM locale t0 WHERE t0.id = ?
Parameters:
[
1
]
|
24.95 ms (3.49%) |
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\General\Texto | No errors. |
App\Entity\General\TextoTranslation | No errors. |
App\Entity\General\Locale | No errors. |
App\Entity\General\TipoPersona | No errors. |
App\Entity\General\TipoPersonaTranslation | No errors. |
App\Entity\General\DisplayFieldConfiguration | No errors. |
App\Entity\General\RedesSociales | No errors. |
App\Entity\General\Imagen | No errors. |
App\Entity\General\Ciudad | No errors. |
App\Entity\General\Pais | No errors. |
App\Entity\General\Departamento | No errors. |
App\Entity\Usuario\TipoDocumentoTraslation | No errors. |
App\Entity\General\Seo | No errors. |
App\Entity\General\SeoTranslation | 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. |