Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client 1
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

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

[
  "rifu.iridian.co"
]

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 = 'rifu.iridian.co' LIMIT 1;

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;

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

SELECT valor from main_setting where llave = 'validate_integrity';

[]

SELECT
  valor
from
  main_setting
where
  llave = 'validate_integrity';

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

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

SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC;

SELECT p0_.id AS id_0, p0_.folio_numero AS folio_numero_1, r1_.id AS id_2 FROM producto p0_ INNER JOIN rifa r1_ ON p0_.rifa_id = r1_.id LEFT JOIN compra c2_ ON p0_.compra_id = c2_.id LEFT JOIN estado_pedido e3_ ON c2_.estado_id = e3_.id WHERE p0_.updated_at <= ? AND (p0_.compra_id IS NULL OR (c2_.id IS NOT NULL AND (c2_.estado_id IS NULL OR e3_.ref <> ?))) AND r1_.alto_flujo = 1

[
  "2024-11-23 09:55:07"
  "APROBADA"
]

SELECT
  p0_.id AS id_0,
  p0_.folio_numero AS folio_numero_1,
  r1_.id AS id_2
FROM
  producto p0_
  INNER JOIN rifa r1_ ON p0_.rifa_id = r1_.id
  LEFT JOIN compra c2_ ON p0_.compra_id = c2_.id
  LEFT JOIN estado_pedido e3_ ON c2_.estado_id = e3_.id
WHERE
  p0_.updated_at <= ?
  AND (
    p0_.compra_id IS NULL
    OR (
      c2_.id IS NOT NULL
      AND (
        c2_.estado_id IS NULL
        OR e3_.ref <> ?
      )
    )
  )
  AND r1_.alto_flujo = 1

SELECT p0_.id AS id_0, p0_.folio_numero AS folio_numero_1, r1_.id AS id_2 FROM producto p0_ INNER JOIN rifa r1_ ON p0_.rifa_id = r1_.id LEFT JOIN compra c2_ ON p0_.compra_id = c2_.id LEFT JOIN estado_pedido e3_ ON c2_.estado_id = e3_.id WHERE p0_.updated_at <= '2024-11-23 09:55:07' AND (p0_.compra_id IS NULL OR (c2_.id IS NOT NULL AND (c2_.estado_id IS NULL OR e3_.ref <> 'APROBADA'))) AND r1_.alto_flujo = 1;

SELECT p0_.id AS id_0, p0_.folio_numero AS folio_numero_1, r1_.id AS id_2 FROM producto p0_ INNER JOIN rifa r1_ ON p0_.rifa_id = r1_.id LEFT JOIN compra c2_ ON p0_.compra_id = c2_.id LEFT JOIN estado_pedido e3_ ON c2_.estado_id = e3_.id WHERE p0_.updated_at <= ? AND (p0_.compra_id IS NULL OR (c2_.id IS NOT NULL AND (c2_.estado_id IS NULL OR e3_.ref <> ?))) AND (r1_.alto_flujo IS NULL OR r1_.alto_flujo = 0)

[
  "2024-11-23 09:40:07"
  "APROBADA"
]

SELECT
  p0_.id AS id_0,
  p0_.folio_numero AS folio_numero_1,
  r1_.id AS id_2
FROM
  producto p0_
  INNER JOIN rifa r1_ ON p0_.rifa_id = r1_.id
  LEFT JOIN compra c2_ ON p0_.compra_id = c2_.id
  LEFT JOIN estado_pedido e3_ ON c2_.estado_id = e3_.id
WHERE
  p0_.updated_at <= ?
  AND (
    p0_.compra_id IS NULL
    OR (
      c2_.id IS NOT NULL
      AND (
        c2_.estado_id IS NULL
        OR e3_.ref <> ?
      )
    )
  )
  AND (
    r1_.alto_flujo IS NULL
    OR r1_.alto_flujo = 0
  )

SELECT p0_.id AS id_0, p0_.folio_numero AS folio_numero_1, r1_.id AS id_2 FROM producto p0_ INNER JOIN rifa r1_ ON p0_.rifa_id = r1_.id LEFT JOIN compra c2_ ON p0_.compra_id = c2_.id LEFT JOIN estado_pedido e3_ ON c2_.estado_id = e3_.id WHERE p0_.updated_at <= '2024-11-23 09:40:07' AND (p0_.compra_id IS NULL OR (c2_.id IS NOT NULL AND (c2_.estado_id IS NULL OR e3_.ref <> 'APROBADA'))) AND (r1_.alto_flujo IS NULL OR r1_.alto_flujo = 0);

DELETE FROM producto WHERE folio_numero IN (?) AND rifa_id = ?

[
  null
  313
]

DELETE FROM
  producto
WHERE
  folio_numero IN (?)
  AND rifa_id = ?

DELETE FROM producto WHERE folio_numero IN (NULL) AND rifa_id = 313;