GET https://dev.efectivate.com/

Query Metrics

6 Database Queries
4 Different statements
6.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 ms
SELECT p0_.id AS id_0, p0_.descripcion AS descripcion_1, p0_.resena AS resena_2 FROM producto_categoria p0_ INNER JOIN producto p1_ WHERE p1_.id_categoria_producto = p0_.id AND p1_.activo = 1
Parameters:
[]
2 0.86 ms
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.activo = ? ORDER BY t0.id_categoria_producto ASC
Parameters:
[
  1
]
3 0.81 ms
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.id_categoria_producto = ?
Parameters:
[
  1
]
4 0.66 ms
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.id_categoria_producto = ?
Parameters:
[
  5
]
5 0.63 ms
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.id_categoria_producto = ?
Parameters:
[
  6
]
6 2.21 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.landing_show AS landing_show_3, t0.landing_name AS landing_name_4, t0.image AS image_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7 FROM formulario_empresas_filiales t0
Parameters:
[]

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.