Symfony Profiler

Query Metrics

20 Database Queries

11 Different statements

498.07 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

57.28 ms
(11.50%)

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:

[
  "rifutest.com"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	MultiTenancyBundle\EventListener\TenantRequestListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

18.73 ms
(3.76%)

SELECT valor from main_setting where llave = 'validate_integrity';

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  valor
from
  main_setting
where
  llave = 'validate_integrity';

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 39)
2	App\EventListener\KernelRequestListener->onKernelRequest (line 116)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

18.71 ms
(3.76%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 30)
2	App\EventListener\KernelRequestListener->onKernelRequest (line 116)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

tenant connection

Time▼	Count	Info
120.49 ms (24.19%)	6	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_about"`] View formatted query View runnable query Explain query 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 = 'main_banner_about' GROUP BY i0_.id ORDER BY i0_.orden ASC;
82.82 ms (16.63%)	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: [] View formatted query View runnable query Explain query 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;
60.61 ms (12.17%)	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: [] View formatted query View runnable query Explain query 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;
38.56 ms (7.74%)	2	SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query 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;
38.50 ms (7.73%)	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: [`"acerca-de" "es"`] View formatted query View runnable query Explain query 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 = 'acerca-de' AND l3_.locale = 'es';
23.38 ms (4.69%)	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: [] View formatted query View runnable query Explain query 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;
19.88 ms (3.99%)	1	SELECT p0_.pregunta AS pregunta_0, p0_.respuesta AS respuesta_1 FROM pregunta_frecuente p1_ INNER JOIN pregunta_frecuente_translation p0_ ON (p1_.id = p0_.pregunta_frecuente_id) INNER JOIN locale l2_ ON p0_.locale_id = l2_.id WHERE l2_.locale = ? AND p1_.visible = 1 ORDER BY p1_.orden ASC Parameters: [`"es"`] View formatted query View runnable query Explain query SELECT p0_.pregunta AS pregunta_0, p0_.respuesta AS respuesta_1 FROM pregunta_frecuente p1_ INNER JOIN pregunta_frecuente_translation p0_ ON ( p1_.id = p0_.pregunta_frecuente_id ) INNER JOIN locale l2_ ON p0_.locale_id = l2_.id WHERE l2_.locale = ? AND p1_.visible = 1 ORDER BY p1_.orden ASC SELECT p0_.pregunta AS pregunta_0, p0_.respuesta AS respuesta_1 FROM pregunta_frecuente p1_ INNER JOIN pregunta_frecuente_translation p0_ ON (p1_.id = p0_.pregunta_frecuente_id) INNER JOIN locale l2_ ON p0_.locale_id = l2_.id WHERE l2_.locale = 'es' AND p1_.visible = 1 ORDER BY p1_.orden ASC;
19.11 ms (3.84%)	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: [] View formatted query View runnable query Explain query 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;

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\PreguntaFrecuente	No errors.
App\Entity\General\PreguntaFrecuenteTranslation	No errors.
App\Entity\General\Locale	No errors.
App\Entity\General\Seo	No errors.
App\Entity\General\SeoTranslation	No errors.
App\Entity\General\Imagen	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.

Symfony Profiler

GET https://rifutest.com/acerca-de

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

tenant entity manager