Symfony Profiler

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

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 = 'rifutest.com' LIMIT 1;

SELECT
  if(
    @@global.time_zone = 'SYSTEM', @@system_time_zone,
    @@global.time_zone
  ) AS timezone;

SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;;

SELECT
  valor
from
  main_setting
where
  llave = 'validate_integrity';

SELECT valor from main_setting where llave = 'validate_integrity';
            ;

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

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 = 'rifutest.com' LIMIT 1;

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

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 = 'rifutest.com' LIMIT 1;

SELECT
  s0_.valor AS valor_0,
  s0_.llave AS llave_1
FROM
  setting s0_
ORDER BY
  s0_.id ASC

SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC;

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

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;

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

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 = 'en' AND t0_.visible = 1 ORDER BY t0_.orden ASC;

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 = ?

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 = 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

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;

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

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 = 'en' AND t0_.visible = 1 ORDER BY t0_.orden ASC;

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 = ?

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 = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2
FROM
  locale t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2 FROM locale t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2
FROM
  locale t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2 FROM locale t0 WHERE t0.id = 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 = ?

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 = 2;

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

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 = 'COL' ORDER BY c0_.nombre ASC;

SELECT
  s0_.valor AS valor_0,
  s0_.llave AS llave_1
FROM
  setting s0_
ORDER BY
  s0_.id ASC

SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC;

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 = ?

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 = 'registro/gestor' AND l3_.locale = 'en';

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 = ?

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 = 'en';

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

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;

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

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;

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

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;

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

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 = 'social_media' GROUP BY i0_.id ORDER BY i0_.orden ASC;

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

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;