Query Metrics

18 Database Queries
6 Different statements
36.28 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 12.66 ms
SELECT c0_.id AS id_0, c0_.url AS url_1, c0_.orden AS orden_2, c0_.visible AS visible_3, c0_.seccion AS seccion_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.logo_id AS logo_id_7, c0_.nombre_id AS nombre_id_8, c0_.descripcion_id AS descripcion_id_9 FROM colaborador c0_ WHERE c0_.visible = ? ORDER BY c0_.seccion ASC, c0_.orden ASC
Parameters:
[
  1
]
2 9.52 ms
SELECT f0_.id AS id_0, f0_.orden AS orden_1, f0_.visible AS visible_2, f0_.section AS section_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.title_id AS title_id_6, f0_.description_id AS description_id_7, f0_.icon_id AS icon_id_8 FROM feature f0_ WHERE f0_.visible = ? ORDER BY f0_.section ASC, f0_.orden ASC
Parameters:
[
  1
]
3 0.91 ms
SELECT t0.id AS id_1, t0.llave AS llave_2, t0.link AS link_3, t0.section_id AS section_id_4 FROM texto t0 WHERE t0.id = ?
Parameters:
[
  1011
]
4 5.16 ms
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.locale_id AS locale_id_3, t0.objeto_id AS objeto_id_4 FROM texto_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
  1011
]
5 0.72 ms
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.principal AS principal_6, t0.llave AS llave_7, t0.link AS link_8, t0.seccion AS seccion_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.image_id AS image_id_12, t0.galeria_id AS galeria_id_13 FROM core_image t0 WHERE t0.id = ?
Parameters:
[
  257682
]
6 0.90 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = ?
Parameters:
[
  198586
]
7 0.88 ms
SELECT t0.id AS id_1, t0.llave AS llave_2, t0.link AS link_3, t0.section_id AS section_id_4 FROM texto t0 WHERE t0.id = ?
Parameters:
[
  1012
]
8 0.38 ms
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.locale_id AS locale_id_3, t0.objeto_id AS objeto_id_4 FROM texto_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
  1012
]
9 0.91 ms
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.principal AS principal_6, t0.llave AS llave_7, t0.link AS link_8, t0.seccion AS seccion_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.image_id AS image_id_12, t0.galeria_id AS galeria_id_13 FROM core_image t0 WHERE t0.id = ?
Parameters:
[
  257683
]
10 0.42 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = ?
Parameters:
[
  198587
]
11 0.67 ms
SELECT t0.id AS id_1, t0.llave AS llave_2, t0.link AS link_3, t0.section_id AS section_id_4 FROM texto t0 WHERE t0.id = ?
Parameters:
[
  1013
]
12 0.41 ms
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.locale_id AS locale_id_3, t0.objeto_id AS objeto_id_4 FROM texto_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
  1013
]
13 0.33 ms
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.principal AS principal_6, t0.llave AS llave_7, t0.link AS link_8, t0.seccion AS seccion_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.image_id AS image_id_12, t0.galeria_id AS galeria_id_13 FROM core_image t0 WHERE t0.id = ?
Parameters:
[
  257684
]
14 0.36 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = ?
Parameters:
[
  198588
]
15 0.81 ms
SELECT t0.id AS id_1, t0.llave AS llave_2, t0.link AS link_3, t0.section_id AS section_id_4 FROM texto t0 WHERE t0.id = ?
Parameters:
[
  1014
]
16 0.45 ms
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.locale_id AS locale_id_3, t0.objeto_id AS objeto_id_4 FROM texto_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
  1014
]
17 0.34 ms
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.principal AS principal_6, t0.llave AS llave_7, t0.link AS link_8, t0.seccion AS seccion_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.image_id AS image_id_12, t0.galeria_id AS galeria_id_13 FROM core_image t0 WHERE t0.id = ?
Parameters:
[
  257685
]
18 0.45 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = ?
Parameters:
[
  198589
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Content\Feature 4
App\Entity\Core\Texto 4
App\Entity\Core\CoreImage 4
App\Entity\Core\TextoTranslation 4
App\Entity\Core\MediaObject 4
App\Entity\Core\Locale 1

Entities Mapping

Class Mapping errors
App\Entity\Pais No errors.
App\Entity\Quote\QuoteProduct No errors.
App\Entity\Quote\Quote No errors.
App\Entity\Core\Capability No errors.
App\Entity\Core\TenantSetting No errors.
App\Entity\Core\Locale No errors.
App\Entity\Core\CoreImageTranslation No errors.
App\Entity\Core\SettingEncrypted No errors.
App\Entity\Core\TextoBigTranslation No errors.
App\Entity\Core\CoreImage No errors.
App\Entity\Core\LinkInterna No errors.
App\Entity\Core\Texto No errors.
App\Entity\Core\ContactType No errors.
App\Entity\Core\CoreArchivo No errors.
App\Entity\Core\Galeria No errors.
App\Entity\Core\LinkTituloTranslation No errors.
App\Entity\Core\MediaObject No errors.
App\Entity\Core\ContactForm No errors.
App\Entity\Core\LinkTitulo No errors.
App\Entity\Core\Section No errors.
App\Entity\Core\TextoBig No errors.
App\Entity\Core\CoreArchivoTranslation No errors.
App\Entity\Core\TextoTranslation No errors.
App\Entity\Core\LinkInternaTranslation No errors.
App\Entity\Store\Direccion No errors.
App\Entity\Store\DepartamentoTranslation No errors.
App\Entity\Store\Inventario No errors.
App\Entity\Store\Pais No errors.
App\Entity\Store\Horario No errors.
App\Entity\Store\Departamento No errors.
App\Entity\Store\Ciudad No errors.
App\Entity\Store\Tienda No errors.
App\Entity\Store\PaisTranslation No errors.
App\Entity\Store\CiudadTranslation No errors.
App\Entity\Store\Kml No errors.
App\Entity\User\User No errors.
App\Entity\User\RequestNotification No errors.
App\Entity\Transaction\EstadoPedido No errors.
App\Entity\Transaction\HomologacionEstado No errors.
App\Entity\Transaction\EstadoCarrito No errors.
App\Entity\Transaction\PagoLog No errors.
App\Entity\Transaction\Transaccion No errors.
App\Entity\Transaction\Compra No errors.
App\Entity\Transaction\Estado No errors.
App\Entity\Transaction\Pasarela No errors.
App\Entity\Transaction\EstadoPedidoTranslation No errors.
App\Entity\Transaction\CompraItem No errors.
App\Entity\Transaction\EstadoCarritoTranslation No errors.
App\Entity\Transaction\MetodoPago No errors.
App\Entity\Transaction\MetodoPagoTranslation No errors.
App\Entity\Transaction\Carrito No errors.
App\Entity\Transaction\EstadoTranslation No errors.
App\Entity\Catalogue\Festivo No errors.
App\Entity\Catalogue\ProductoDeleted No errors.
App\Entity\Catalogue\ProductoCurrency No errors.
App\Entity\Catalogue\ProductoTranslation No errors.
App\Entity\Catalogue\Option No errors.
App\Entity\Catalogue\ProductoCondicion No errors.
App\Entity\Catalogue\ListaPrecio No errors.
App\Entity\Catalogue\ProductoUnidad No errors.
App\Entity\Catalogue\TipoAtributoTranslation No errors.
App\Entity\Catalogue\Currency No errors.
App\Entity\Catalogue\Condicion No errors.
App\Entity\Catalogue\ColorTranslation No errors.
App\Entity\Catalogue\CategoriaTranslation No errors.
App\Entity\Catalogue\TipoProducto No errors.
App\Entity\Catalogue\TipoCombinacionCurrency No errors.
App\Entity\Catalogue\ValorAtributoTranslation No errors.
App\Entity\Catalogue\LimiteProducto No errors.
App\Entity\Catalogue\ProductoUnidadTranslation No errors.
App\Entity\Catalogue\Producto No errors.
App\Entity\Catalogue\TipoCombinacionProducto No errors.
App\Entity\Catalogue\TipoOptionTranslation No errors.
App\Entity\Catalogue\ValorAtributo No errors.
App\Entity\Catalogue\Color No errors.
App\Entity\Catalogue\OptionTranslation No errors.
App\Entity\Catalogue\TipoProductoTranslation No errors.
App\Entity\Catalogue\Talla No errors.
App\Entity\Catalogue\MarcaTranslation No errors.
App\Entity\Catalogue\Caja No errors.
App\Entity\Catalogue\TallaTranslation No errors.
App\Entity\Catalogue\SubcategoriaTranslation No errors.
App\Entity\Catalogue\Categoria No errors.
App\Entity\Catalogue\TipoOption No errors.
App\Entity\Catalogue\TipoAtributo No errors.
App\Entity\Catalogue\ProductoPrecio No errors.
App\Entity\Catalogue\Subcategoria No errors.
App\Entity\Catalogue\Impuesto No errors.
App\Entity\Catalogue\Marca No errors.
App\Entity\Content\Colaborador No errors.
App\Entity\Content\Feature No errors.
App\Entity\Content\Faq No errors.
App\Entity\Content\ProcessStep No errors.
App\Entity\Logistica\HomologacionTipoEnvio No errors.
App\Entity\Logistica\TipoEnvio No errors.
App\Entity\Logistica\LogEnvio No errors.
App\Entity\Logistica\HomologacionEstadoEnvio No errors.
App\Entity\Logistica\OperadorLogistico No errors.
App\Entity\Logistica\TipoEnvioTranslation No errors.
App\Entity\Logistica\EstadoEnvioTranslation No errors.
App\Entity\Logistica\SeguimientoTracking No errors.
App\Entity\Logistica\EstadoEnvio No errors.
App\Entity\Logistica\Envio No errors.
Vich\UploaderBundle\Entity\File No errors.