Symfony Profiler

SELECT
  DISTINCT category.id,
  category.name
FROM
  category
  INNER JOIN category2entity category2entity ON category.id = category2entity.category_id
  INNER JOIN offer offer ON offer.id = category2entity.entity_id
  INNER JOIN offer_extension offer_extension ON offer.id = offer_extension.offer_id
  INNER JOIN geo_location_relation geo_location_relation ON geo_location_relation.entity_id = offer.id
  INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id
WHERE
  (
    category.active = :categoryActive
  )
  AND (category.past = :categoryPast)
  AND (
    category.domain_object_id = :domainObjectId
  )
  AND (category.type = :categoryType)
  AND (
    category.type_id IN (1, 2)
  )
  AND (
    category.id IN (
      SELECT
        category_child_relation.child_id
      FROM
        category_child_relation
      WHERE
        category_child_relation.parent_id = :parentCategoryId
    )
  )
  AND (
    now() between offer.active_since
    and offer.active_till
  )
  AND (offer.active = :offerActive)
  AND (offer.hidden = :offerHidden)
  AND (
    (offer_extension.active IS NULL)
    OR (
      offer_extension.active = :offerExtensionActive
    )
  )
  AND (
    offer_extension.type = :tireExtensionType
  )
  AND (geo_location.schedule IS NOT NULL)

SELECT DISTINCT category.id, category.name FROM category INNER JOIN category2entity category2entity ON category.id = category2entity.category_id INNER JOIN offer offer ON offer.id = category2entity.entity_id INNER JOIN offer_extension offer_extension ON offer.id = offer_extension.offer_id INNER JOIN geo_location_relation geo_location_relation ON geo_location_relation.entity_id = offer.id INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id WHERE (category.active = 1) AND (category.past = 0) AND (category.domain_object_id = 1) AND (category.type = 0) AND (category.type_id IN (1, 2)) AND (category.id IN (SELECT category_child_relation.child_id FROM category_child_relation WHERE category_child_relation.parent_id  = 572)) AND (now() between offer.active_since and offer.active_till) AND (offer.active = 1) AND (offer.hidden = 0) AND ((offer_extension.active IS NULL) OR (offer_extension.active = 1)) AND (offer_extension.type = 3) AND (geo_location.schedule IS NOT NULL);

INSERT INTO visit (
  created_on, entity_id, entity_type_id,
  ip_address, device_type, referrer,
  id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO visit (created_on, entity_id, entity_type_id, ip_address, device_type, referrer, id, user_id) VALUES ('2025-09-16 05:17:24', 572, 5, '199.47.82.21', 0, '', 829522741, NULL);

SELECT
  NEXTVAL('visit_id_seq')

SELECT NEXTVAL('visit_id_seq');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";