GET https://rifu.iridian.co/registro

Query Metrics

27 Database Queries
16 Different statements
670.71 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 20.05 ms
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
  "rifu.iridian.co"
]
2 19.26 ms
SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;
Parameters:
[]
3 19.27 ms
SELECT valor from main_setting where llave = 'validate_integrity';
Parameters:
[]
4 19.55 ms
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
  "rifu.iridian.co"
]
5 19.52 ms
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
  "rifu.iridian.co"
]
6 19.55 ms
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
  "rifu.iridian.co"
]
7 19.86 ms
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
  "rifu.iridian.co"
]

tenant connection

# Time Info
1 19.70 ms
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[]
2 84.99 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:
[]
3 20.19 ms
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
]
4 33.38 ms
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"
]
5 19.60 ms
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[]
6 19.64 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:
[
  "registro"
  "es"
]
7 19.60 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 33.08 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 37.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_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:
[]
10 19.36 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.habilitado = ?
Parameters:
[
  1
]
11 47.54 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:
[]
12 19.96 ms
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.code AS code_3, t0.orden AS orden_4, t0.iso3 AS iso3_5, t0.numeric_code AS numeric_code_6, t0.iso2 AS iso2_7, t0.phonecode AS phonecode_8, t0.capital AS capital_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.tld AS tld_12, t0.native AS native_13, t0.region AS region_14, t0.subregion AS subregion_15, t0.timezones AS timezones_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.emoji AS emoji_19, t0.emoji_u AS emoji_u_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.flag AS flag_23, t0.wiki_data_id AS wiki_data_id_24 FROM pais t0 WHERE t0.iso3 = ? LIMIT 1
Parameters:
[
  "COL"
]
13 19.88 ms
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.code AS code_3, t0.orden AS orden_4, t0.iso3 AS iso3_5, t0.numeric_code AS numeric_code_6, t0.iso2 AS iso2_7, t0.phonecode AS phonecode_8, t0.capital AS capital_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.tld AS tld_12, t0.native AS native_13, t0.region AS region_14, t0.subregion AS subregion_15, t0.timezones AS timezones_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.emoji AS emoji_19, t0.emoji_u AS emoji_u_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.flag AS flag_23, t0.wiki_data_id AS wiki_data_id_24 FROM pais t0 WHERE t0.iso3 = ? LIMIT 1
Parameters:
[
  "COL"
]
14 19.62 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.habilitado = ?
Parameters:
[
  1
]
15 20.36 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_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:
[
  "social_media"
]
16 20.50 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_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:
[
  "social_media"
]
17 19.42 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.habilitado = ?
Parameters:
[
  1
]
18 20.58 ms
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:
[]
19 19.46 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:
[]
20 19.46 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:
[]

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.