Symfony Profiler

SELECT
  t1.id AS id_2,
  t1.uuid AS uuid_3,
  t1.approve_status AS approve_status_4,
  t1.visibility_status AS visibility_status_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.expire_at AS expire_at_8,
  t1.deleted_at AS deleted_at_9,
  t1.ip_address AS ip_address_10,
  t1.view_count AS view_count_11,
  t1.score AS score_12,
  t0.title AS title_13,
  t0.slug AS slug_14,
  t0.brief AS brief_15,
  t0.description AS description_16,
  t0.price AS price_17,
  t0.price_alternative AS price_alternative_18,
  t0.price_time AS price_time_19,
  t1.user_id AS user_id_20,
  t0.subject_id AS subject_id_21,
  t1.type
FROM
  advert_offer t0
  INNER JOIN content_item t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.uuid AS uuid_3, t1.approve_status AS approve_status_4, t1.visibility_status AS visibility_status_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.expire_at AS expire_at_8, t1.deleted_at AS deleted_at_9, t1.ip_address AS ip_address_10, t1.view_count AS view_count_11, t1.score AS score_12, t0.title AS title_13, t0.slug AS slug_14, t0.brief AS brief_15, t0.description AS description_16, t0.price AS price_17, t0.price_alternative AS price_alternative_18, t0.price_time AS price_time_19, t1.user_id AS user_id_20, t0.subject_id AS subject_id_21, t1.type FROM advert_offer t0 INNER JOIN content_item t1 ON t0.id = t1.id WHERE t1.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.order_number AS order_number_5,
  t0.count AS count_6
FROM
  city t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 WHERE t0.slug = '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.icon AS icon_5,
  t0.order_number AS order_number_6,
  t0.count AS count_7
FROM
  subject t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 WHERE t0.slug = '' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `view` (
  user_token, type, value, created_at,
  ip_address, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO `view` (user_token, type, value, created_at, ip_address, user_id) VALUES ('917dfe5b-d52d-43f4-aa57-49ad6fdd43a8', 1, 9, '2024-04-27 15:50:43', '3.147.104.248', NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.order_number AS order_number_5,
  t0.count AS count_6
FROM
  city t0
  INNER JOIN advert_offer_city ON t0.id = advert_offer_city.city_id
WHERE
  advert_offer_city.advert_offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 INNER JOIN advert_offer_city ON t0.id = advert_offer_city.city_id WHERE advert_offer_city.advert_offer_id = 9;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.approve_status AS approve_status_2,
  c0_.visibility_status AS visibility_status_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.expire_at AS expire_at_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.ip_address AS ip_address_8,
  c0_.view_count AS view_count_9,
  c0_.score AS score_10,
  a1_.title AS title_11,
  a1_.slug AS slug_12,
  a1_.brief AS brief_13,
  a1_.description AS description_14,
  a1_.price AS price_15,
  a1_.price_alternative AS price_alternative_16,
  a1_.price_time AS price_time_17,
  c0_.type AS type_18,
  c0_.user_id AS user_id_19,
  a1_.subject_id AS subject_id_20
FROM
  advert_offer a1_
  INNER JOIN content_item c0_ ON a1_.id = c0_.id
WHERE
  a1_.subject_id = ?
  AND (
    EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        advert_offer_city a2_
      WHERE
        a2_.advert_offer_id = a1_.id
        AND a2_.city_id IN (?)
    )
  )
  AND c0_.id NOT IN (?)
  AND c0_.visibility_status = ?
  AND c0_.approve_status IN (?)
LIMIT
  6

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.approve_status AS approve_status_2, c0_.visibility_status AS visibility_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.expire_at AS expire_at_6, c0_.deleted_at AS deleted_at_7, c0_.ip_address AS ip_address_8, c0_.view_count AS view_count_9, c0_.score AS score_10, a1_.title AS title_11, a1_.slug AS slug_12, a1_.brief AS brief_13, a1_.description AS description_14, a1_.price AS price_15, a1_.price_alternative AS price_alternative_16, a1_.price_time AS price_time_17, c0_.type AS type_18, c0_.user_id AS user_id_19, a1_.subject_id AS subject_id_20 FROM advert_offer a1_ INNER JOIN content_item c0_ ON a1_.id = c0_.id WHERE a1_.subject_id = 2 AND (EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (2)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (2)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (52)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (53)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (54)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (55)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (56)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (57)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (58)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (59)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (60)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (61)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (62)) OR EXISTS (SELECT 1 FROM advert_offer_city a2_ WHERE a2_.advert_offer_id = a1_.id AND a2_.city_id IN (63))) AND c0_.id NOT IN (9) AND c0_.visibility_status = 1 AND c0_.approve_status IN (1, 2) LIMIT 6;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.approve_status AS approve_status_2,
  c0_.visibility_status AS visibility_status_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.expire_at AS expire_at_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.ip_address AS ip_address_8,
  c0_.view_count AS view_count_9,
  c0_.score AS score_10,
  a1_.title AS title_11,
  a1_.slug AS slug_12,
  a1_.brief AS brief_13,
  a1_.description AS description_14,
  a1_.price AS price_15,
  a1_.price_alternative AS price_alternative_16,
  a1_.price_time AS price_time_17,
  c0_.type AS type_18,
  c0_.user_id AS user_id_19,
  a1_.subject_id AS subject_id_20
FROM
  advert_offer a1_
  INNER JOIN content_item c0_ ON a1_.id = c0_.id
WHERE
  a1_.subject_id = ?
  AND c0_.id NOT IN (?)
  AND c0_.visibility_status = ?
  AND c0_.approve_status IN (?)
LIMIT
  3

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.approve_status AS approve_status_2, c0_.visibility_status AS visibility_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.expire_at AS expire_at_6, c0_.deleted_at AS deleted_at_7, c0_.ip_address AS ip_address_8, c0_.view_count AS view_count_9, c0_.score AS score_10, a1_.title AS title_11, a1_.slug AS slug_12, a1_.brief AS brief_13, a1_.description AS description_14, a1_.price AS price_15, a1_.price_alternative AS price_alternative_16, a1_.price_time AS price_time_17, c0_.type AS type_18, c0_.user_id AS user_id_19, a1_.subject_id AS subject_id_20 FROM advert_offer a1_ INNER JOIN content_item c0_ ON a1_.id = c0_.id WHERE a1_.subject_id = 2 AND c0_.id NOT IN (2, 3, 10, 9) AND c0_.visibility_status = 1 AND c0_.approve_status IN (1, 2) LIMIT 3;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.approve_status AS approve_status_2,
  c0_.visibility_status AS visibility_status_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.expire_at AS expire_at_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.ip_address AS ip_address_8,
  c0_.view_count AS view_count_9,
  c0_.score AS score_10,
  a1_.title AS title_11,
  a1_.slug AS slug_12,
  a1_.brief AS brief_13,
  a1_.description AS description_14,
  a1_.price AS price_15,
  a1_.price_alternative AS price_alternative_16,
  a1_.price_time AS price_time_17,
  c0_.type AS type_18,
  c0_.user_id AS user_id_19,
  a1_.subject_id AS subject_id_20
FROM
  advert_offer a1_
  INNER JOIN content_item c0_ ON a1_.id = c0_.id
WHERE
  c0_.id NOT IN (?)
  AND c0_.visibility_status = ?
  AND c0_.approve_status IN (?)
LIMIT
  2

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.approve_status AS approve_status_2, c0_.visibility_status AS visibility_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.expire_at AS expire_at_6, c0_.deleted_at AS deleted_at_7, c0_.ip_address AS ip_address_8, c0_.view_count AS view_count_9, c0_.score AS score_10, a1_.title AS title_11, a1_.slug AS slug_12, a1_.brief AS brief_13, a1_.description AS description_14, a1_.price AS price_15, a1_.price_alternative AS price_alternative_16, a1_.price_time AS price_time_17, c0_.type AS type_18, c0_.user_id AS user_id_19, a1_.subject_id AS subject_id_20 FROM advert_offer a1_ INNER JOIN content_item c0_ ON a1_.id = c0_.id WHERE c0_.id NOT IN (2, 3, 10, 9, 1) AND c0_.visibility_status = 1 AND c0_.approve_status IN (1, 2) LIMIT 2;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.genitive_name AS genitive_name_3,
  s0_.icon AS icon_4,
  s0_.order_number AS order_number_5,
  s0_.count AS count_6
FROM
  subject s0_
ORDER BY
  s0_.order_number ASC,
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.genitive_name AS genitive_name_3, s0_.icon AS icon_4, s0_.order_number AS order_number_5, s0_.count AS count_6 FROM subject s0_ ORDER BY s0_.order_number ASC, s0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.genitive_name AS genitive_name_3,
  c0_.order_number AS order_number_4,
  c0_.count AS count_5
FROM
  city c0_
ORDER BY
  c0_.order_number ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.genitive_name AS genitive_name_3, c0_.order_number AS order_number_4, c0_.count AS count_5 FROM city c0_ ORDER BY c0_.order_number ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.experience_description AS experience_description_2,
  t0.years_of_experience AS years_of_experience_3,
  t0.website AS website_4
FROM
  user_about_me t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.experience_description AS experience_description_2, t0.years_of_experience AS years_of_experience_3, t0.website AS website_4 FROM user_about_me t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.icon AS icon_5,
  t0.order_number AS order_number_6,
  t0.count AS count_7
FROM
  subject t0
  INNER JOIN user_about_me_subject ON t0.id = user_about_me_subject.subject_id
WHERE
  user_about_me_subject.about_me_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 INNER JOIN user_about_me_subject ON t0.id = user_about_me_subject.subject_id WHERE user_about_me_subject.about_me_id = 5;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.route AS route_5,
  t0.is_public AS is_public_6,
  t0.content AS content_7
FROM
  page t0
WHERE
  t0.is_public = ?
  AND t0.locale = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.slug AS slug_4, t0.route AS route_5, t0.is_public AS is_public_6, t0.content AS content_7 FROM page t0 WHERE t0.is_public = 1 AND t0.locale = 'cs';

SELECT
  t0.order_number AS order_number_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.slug AS slug_4
FROM
  advert_level t0
  INNER JOIN advert_offer_level ON t0.id = advert_offer_level.level_id
WHERE
  advert_offer_level.advert_offer_id = ?

SELECT t0.order_number AS order_number_1, t0.id AS id_2, t0.name AS name_3, t0.slug AS slug_4 FROM advert_level t0 INNER JOIN advert_offer_level ON t0.id = advert_offer_level.level_id WHERE advert_offer_level.advert_offer_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  advert_preferred_time_attribute t0
  INNER JOIN advert_offer_preferred_time_attribute ON t0.id = advert_offer_preferred_time_attribute.preferred_time_attribute_id
WHERE
  advert_offer_preferred_time_attribute.advert_offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM advert_preferred_time_attribute t0 INNER JOIN advert_offer_preferred_time_attribute ON t0.id = advert_offer_preferred_time_attribute.preferred_time_attribute_id WHERE advert_offer_preferred_time_attribute.advert_offer_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  advert_other_attribute t0
  INNER JOIN advert_offer_other_attribute ON t0.id = advert_offer_other_attribute.other_attribute_id
WHERE
  advert_offer_other_attribute.advert_offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM advert_other_attribute t0 INNER JOIN advert_offer_other_attribute ON t0.id = advert_offer_other_attribute.other_attribute_id WHERE advert_offer_other_attribute.advert_offer_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  advert_place_attribute t0
  INNER JOIN advert_offer_place_attribute ON t0.id = advert_offer_place_attribute.place_attribute_id
WHERE
  advert_offer_place_attribute.advert_offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM advert_place_attribute t0 INNER JOIN advert_offer_place_attribute ON t0.id = advert_offer_place_attribute.place_attribute_id WHERE advert_offer_place_attribute.advert_offer_id = 9;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 12 LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.rating AS rating_3,
  u0_.description AS description_4,
  u0_.created_at AS created_at_5,
  u0_.confirmed_at AS confirmed_at_6,
  u0_.ip_address AS ip_address_7,
  u0_.user_id AS user_id_8,
  u0_.from_user_id AS from_user_id_9
FROM
  user_rating u0_
WHERE
  u0_.user_id = ?
  AND u0_.confirmed_at IS NOT NULL

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.rating AS rating_3, u0_.description AS description_4, u0_.created_at AS created_at_5, u0_.confirmed_at AS confirmed_at_6, u0_.ip_address AS ip_address_7, u0_.user_id AS user_id_8, u0_.from_user_id AS from_user_id_9 FROM user_rating u0_ WHERE u0_.user_id = 12 AND u0_.confirmed_at IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.order_number AS order_number_5,
  t0.count AS count_6
FROM
  city t0
  INNER JOIN advert_offer_city ON t0.id = advert_offer_city.city_id
WHERE
  advert_offer_city.advert_offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 INNER JOIN advert_offer_city ON t0.id = advert_offer_city.city_id WHERE advert_offer_city.advert_offer_id = 2;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.order_number AS order_number_5,
  t0.count AS count_6
FROM
  city t0
  INNER JOIN advert_offer_city ON t0.id = advert_offer_city.city_id
WHERE
  advert_offer_city.advert_offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 INNER JOIN advert_offer_city ON t0.id = advert_offer_city.city_id WHERE advert_offer_city.advert_offer_id = 3;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 14;