Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 158
• Events
• Routing
• Cache
• Translation 10
• Security
• Twig
• HTTP Client
• Doctrine 5
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Blocks 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.precioCompra AS precioCompra_2, t0.precioVenta AS precioVenta_3, t0.dia AS dia_4, t0.shortName AS shortName_5, t0.oficina AS oficina_6 FROM cotizaciones t0

[]

SELECT
  t0.id AS id_1,
  t0.precioCompra AS precioCompra_2,
  t0.precioVenta AS precioVenta_3,
  t0.dia AS dia_4,
  t0.shortName AS shortName_5,
  t0.oficina AS oficina_6
FROM
  cotizaciones t0

SELECT t0.id AS id_1, t0.precioCompra AS precioCompra_2, t0.precioVenta AS precioVenta_3, t0.dia AS dia_4, t0.shortName AS shortName_5, t0.oficina AS oficina_6 FROM cotizaciones t0;

SELECT c.precioCompra, c.precioVenta, c.dia, d.title
                FROM cotizaciones c, divisa d
                WHERE c.dia >= DATE_ADD( LAST_DAY( DATE_SUB( NOW( ) , INTERVAL 2 MONTH ) ) , INTERVAL 1 DAY )
                AND d.id=c.shortName
                AND d.id= ?
                AND c.oficina= ?
                ORDER BY c.dia ASC

[
  41
  0
]

SELECT
  c.precioCompra,
  c.precioVenta,
  c.dia,
  d.title
FROM
  cotizaciones c,
  divisa d
WHERE
  c.dia >= DATE_ADD(
    LAST_DAY(
      DATE_SUB(
        NOW(),
        INTERVAL 2 MONTH
      )
    ),
    INTERVAL 1 DAY
  )
  AND d.id = c.shortName
  AND d.id = ?
  AND c.oficina = ?
ORDER BY
  c.dia ASC

SELECT c.precioCompra, c.precioVenta, c.dia, d.title
                FROM cotizaciones c, divisa d
                WHERE c.dia >= DATE_ADD( LAST_DAY( DATE_SUB( NOW( ) , INTERVAL 2 MONTH ) ) , INTERVAL 1 DAY )
                AND d.id=c.shortName
                AND d.id= 41
                AND c.oficina= 0
                ORDER BY c.dia ASC;

SELECT t0.id AS id_1, t0.descripcion1 AS descripcion1_2, t0.meta_robots AS meta_robots_3, t0.descripcion2 AS descripcion2_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.meta_title AS meta_title_7, t0.slug AS slug_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM divisa_conversion_translation t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1

[
  "peso-colombiano"
  "es"
]

SELECT
  t0.id AS id_1,
  t0.descripcion1 AS descripcion1_2,
  t0.meta_robots AS meta_robots_3,
  t0.descripcion2 AS descripcion2_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.meta_description AS meta_description_6,
  t0.meta_title AS meta_title_7,
  t0.slug AS slug_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  divisa_conversion_translation t0
WHERE
  t0.slug = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.descripcion1 AS descripcion1_2, t0.meta_robots AS meta_robots_3, t0.descripcion2 AS descripcion2_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.meta_title AS meta_title_7, t0.slug AS slug_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM divisa_conversion_translation t0 WHERE t0.slug = 'peso-colombiano' AND t0.locale = 'es' LIMIT 1;

SELECT t0.id AS id_1, t0.shortName AS shortName_2, t0.altFlag AS altFlag_3, t0.peso AS peso_4, t0.simbolo AS simbolo_5, t0.title AS title_6, t0.bloqueado AS bloqueado_7, t0.maestro AS maestro_8, t0.virtual AS virtual_9, t0.visible AS visible_10, t0.redondeoMinimo AS redondeoMinimo_11, t0.numDecimales AS numDecimales_12, t0.url_organismo_oficial AS url_organismo_oficial_13, t0.compraMinima AS compraMinima_14, t0.imagen_id AS imagen_id_15, t0.banner_id AS banner_id_16 FROM divisa t0

[]

SELECT
  t0.id AS id_1,
  t0.shortName AS shortName_2,
  t0.altFlag AS altFlag_3,
  t0.peso AS peso_4,
  t0.simbolo AS simbolo_5,
  t0.title AS title_6,
  t0.bloqueado AS bloqueado_7,
  t0.maestro AS maestro_8,
  t0.virtual AS virtual_9,
  t0.visible AS visible_10,
  t0.redondeoMinimo AS redondeoMinimo_11,
  t0.numDecimales AS numDecimales_12,
  t0.url_organismo_oficial AS url_organismo_oficial_13,
  t0.compraMinima AS compraMinima_14,
  t0.imagen_id AS imagen_id_15,
  t0.banner_id AS banner_id_16
FROM
  divisa t0

SELECT t0.id AS id_1, t0.shortName AS shortName_2, t0.altFlag AS altFlag_3, t0.peso AS peso_4, t0.simbolo AS simbolo_5, t0.title AS title_6, t0.bloqueado AS bloqueado_7, t0.maestro AS maestro_8, t0.virtual AS virtual_9, t0.visible AS visible_10, t0.redondeoMinimo AS redondeoMinimo_11, t0.numDecimales AS numDecimales_12, t0.url_organismo_oficial AS url_organismo_oficial_13, t0.compraMinima AS compraMinima_14, t0.imagen_id AS imagen_id_15, t0.banner_id AS banner_id_16 FROM divisa t0;

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.alt AS alt_3, t0.latitud AS latitud_4, t0.longitud AS longitud_5, t0.telefono AS telefono_6, t0.direccion AS direccion_7, t0.codigo_postal AS codigo_postal_8, t0.peso AS peso_9, t0.activo AS activo_10, t0.url_google AS url_google_11, t0.provincia AS provincia_12, t0.localidad AS localidad_13, t0.oficinaERP AS oficinaERP_14, t0.imagen_id AS imagen_id_15, t0.imagen_mapa_id AS imagen_mapa_id_16 FROM oficina t0

[]

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.alt AS alt_3,
  t0.latitud AS latitud_4,
  t0.longitud AS longitud_5,
  t0.telefono AS telefono_6,
  t0.direccion AS direccion_7,
  t0.codigo_postal AS codigo_postal_8,
  t0.peso AS peso_9,
  t0.activo AS activo_10,
  t0.url_google AS url_google_11,
  t0.provincia AS provincia_12,
  t0.localidad AS localidad_13,
  t0.oficinaERP AS oficinaERP_14,
  t0.imagen_id AS imagen_id_15,
  t0.imagen_mapa_id AS imagen_mapa_id_16
FROM
  oficina t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.alt AS alt_3, t0.latitud AS latitud_4, t0.longitud AS longitud_5, t0.telefono AS telefono_6, t0.direccion AS direccion_7, t0.codigo_postal AS codigo_postal_8, t0.peso AS peso_9, t0.activo AS activo_10, t0.url_google AS url_google_11, t0.provincia AS provincia_12, t0.localidad AS localidad_13, t0.oficinaERP AS oficinaERP_14, t0.imagen_id AS imagen_id_15, t0.imagen_mapa_id AS imagen_mapa_id_16 FROM oficina t0;

SELECT t0.id AS id_1, t0.altBanner AS altBanner_2, t0.nombre AS nombre_3, t0.texto1 AS texto1_4, t0.texto2 AS texto2_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.nombrebanco AS nombrebanco_9, t0.mostrarTop AS mostrarTop_10, t0.mostrarFoot AS mostrarFoot_11, t0.slug AS slug_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM divisa_translation t0 WHERE t0.translatable_id = ?

[
  41
]

SELECT
  t0.id AS id_1,
  t0.altBanner AS altBanner_2,
  t0.nombre AS nombre_3,
  t0.texto1 AS texto1_4,
  t0.texto2 AS texto2_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.meta_description AS meta_description_7,
  t0.meta_title AS meta_title_8,
  t0.nombrebanco AS nombrebanco_9,
  t0.mostrarTop AS mostrarTop_10,
  t0.mostrarFoot AS mostrarFoot_11,
  t0.slug AS slug_12,
  t0.locale AS locale_13,
  t0.translatable_id AS translatable_id_14
FROM
  divisa_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.altBanner AS altBanner_2, t0.nombre AS nombre_3, t0.texto1 AS texto1_4, t0.texto2 AS texto2_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.nombrebanco AS nombrebanco_9, t0.mostrarTop AS mostrarTop_10, t0.mostrarFoot AS mostrarFoot_11, t0.slug AS slug_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM divisa_translation t0 WHERE t0.translatable_id = 41;

SELECT t0.id AS id_1, t0.altBanner AS altBanner_2, t0.nombre AS nombre_3, t0.texto1 AS texto1_4, t0.texto2 AS texto2_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.nombrebanco AS nombrebanco_9, t0.mostrarTop AS mostrarTop_10, t0.mostrarFoot AS mostrarFoot_11, t0.slug AS slug_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM divisa_translation t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1

[
  "peso-colombiano"
  "es"
]

SELECT
  t0.id AS id_1,
  t0.altBanner AS altBanner_2,
  t0.nombre AS nombre_3,
  t0.texto1 AS texto1_4,
  t0.texto2 AS texto2_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.meta_description AS meta_description_7,
  t0.meta_title AS meta_title_8,
  t0.nombrebanco AS nombrebanco_9,
  t0.mostrarTop AS mostrarTop_10,
  t0.mostrarFoot AS mostrarFoot_11,
  t0.slug AS slug_12,
  t0.locale AS locale_13,
  t0.translatable_id AS translatable_id_14
FROM
  divisa_translation t0
WHERE
  t0.slug = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.altBanner AS altBanner_2, t0.nombre AS nombre_3, t0.texto1 AS texto1_4, t0.texto2 AS texto2_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.nombrebanco AS nombrebanco_9, t0.mostrarTop AS mostrarTop_10, t0.mostrarFoot AS mostrarFoot_11, t0.slug AS slug_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM divisa_translation t0 WHERE t0.slug = 'peso-colombiano' AND t0.locale = 'es' LIMIT 1;