Symfony Profiler

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/vip/nedvizhimost' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  NEXTVAL('visit_id_seq')

SELECT NEXTVAL('visit_id_seq');

"START TRANSACTION"

"START TRANSACTION";

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-19 14:45:09', 6255, 5, '14.191.51.156', 0, '', 829592580, NULL);

"COMMIT"

"COMMIT";

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  = 6255)) 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);