GET https://abc.iridian.co/searcher-result

Query Metrics

5 Database Queries
5 Different statements
5965.48 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 400.82 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.visible AS visible_2, p0_.destacado AS destacado_3, p0_.orden AS orden_4, p0_.part_number AS part_number_5, p1_.nombre AS nombre_6, p1_.resumen AS resumen_7, p2_.precio AS precio_8, p2_.precio_sin_descuento AS precio_sin_descuento_9, p3_.ref AS ref_10, p0_.per_stack AS per_stack_11, p0_.width AS width_12, p0_.length AS length_13, p0_.depth AS depth_14, p0_.weight AS weight_15, GROUP_CONCAT(JSON_OBJECT('principal', c4_.principal, 'image', m5_.file_path)) AS sclr_16 FROM producto p0_ LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN producto_precio p2_ ON p0_.id = p2_.producto_id LEFT JOIN producto_unidad p3_ ON p0_.unidad_id = p3_.id LEFT JOIN producto_core_image p6_ ON p0_.id = p6_.producto_id LEFT JOIN core_image c4_ ON c4_.id = p6_.core_image_id LEFT JOIN media_object m5_ ON c4_.image_id = m5_.id WHERE p0_.visible = 1 AND (p0_.is_deleted <> 1 OR p0_.is_deleted IS NULL) GROUP BY p0_.id LIMIT 12
Parameters:
[]
2 5496.99 ms
SELECT count(p0_.id) AS sclr_0 FROM producto p0_ LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN producto_precio p2_ ON p0_.id = p2_.producto_id LEFT JOIN producto_unidad p3_ ON p0_.unidad_id = p3_.id LEFT JOIN producto_core_image p5_ ON p0_.id = p5_.producto_id LEFT JOIN core_image c4_ ON c4_.id = p5_.core_image_id LEFT JOIN media_object m6_ ON c4_.image_id = m6_.id WHERE p0_.visible = 1 AND (p0_.is_deleted <> 1 OR p0_.is_deleted IS NULL)
Parameters:
[]
3 2.98 ms
SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3 FROM currency t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
4 33.72 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.orden AS orden_2, c0_.visible AS visible_3, c0_.home AS home_4, c0_.menu AS menu_5, c0_.ordenmenu AS ordenmenu_6, m1_.file_path AS file_path_7, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'nombre', c3_.nombre)) AS sclr_8 FROM categoria c0_ LEFT JOIN categoria_translation c3_ ON c0_.id = c3_.objeto_id LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id LEFT JOIN core_image c4_ ON c0_.imagen_id = c4_.id LEFT JOIN media_object m1_ ON c4_.image_id = m1_.id WHERE c0_.visible = 1 GROUP BY c0_.id ORDER BY c0_.orden ASC LIMIT 4
Parameters:
[]
5 30.97 ms
SELECT m0_.file_path AS file_path_0 FROM core_image c1_ LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id WHERE c1_.llave = ? LIMIT 1
Parameters:
[
  "logo_blanco"
]

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\Catalogue\Currency 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.