Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.status AS status_4,
  a0_.valid_from AS valid_from_5,
  a0_.valid_to AS valid_to_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8,
  a0_.budget AS budget_9,
  c1_.status AS status_10,
  c1_.latest_change_at AS latest_change_at_11,
  c1_.featured_image AS featured_image_12,
  c1_.id AS id_13,
  c1_.company_name AS company_name_14,
  c1_.company_ic AS company_ic_15,
  c1_.company_dic AS company_dic_16,
  c1_.company_web AS company_web_17,
  c1_.company_tel AS company_tel_18,
  c1_.company_email AS company_email_19,
  c1_.requests_email AS requests_email_20,
  c1_.company_description AS company_description_21,
  c1_.short_description AS short_description_22,
  c1_.profile_type AS profile_type_23,
  c1_.youtube_video_url AS youtube_video_url_24,
  c1_.created_at AS created_at_25,
  c1_.company_address_street AS company_address_street_26,
  c1_.company_address_postal_code AS company_address_postal_code_27,
  c1_.company_address_city AS company_address_city_28,
  c1_.company_address_country AS company_address_country_29,
  a0_.discr AS discr_30,
  a0_.company_id AS company_id_31
FROM
  advertisement a0_
  INNER JOIN company_profile c1_ ON a0_.company_id = c1_.id
WHERE
  (
    a0_.status = ?
    AND a0_.valid_from <= ?
    AND a0_.valid_to >= ?
  )
  AND a0_.discr IN ('offer')
ORDER BY
  a0_.created_at DESC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.status AS status_4, a0_.valid_from AS valid_from_5, a0_.valid_to AS valid_to_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.budget AS budget_9, c1_.status AS status_10, c1_.latest_change_at AS latest_change_at_11, c1_.featured_image AS featured_image_12, c1_.id AS id_13, c1_.company_name AS company_name_14, c1_.company_ic AS company_ic_15, c1_.company_dic AS company_dic_16, c1_.company_web AS company_web_17, c1_.company_tel AS company_tel_18, c1_.company_email AS company_email_19, c1_.requests_email AS requests_email_20, c1_.company_description AS company_description_21, c1_.short_description AS short_description_22, c1_.profile_type AS profile_type_23, c1_.youtube_video_url AS youtube_video_url_24, c1_.created_at AS created_at_25, c1_.company_address_street AS company_address_street_26, c1_.company_address_postal_code AS company_address_postal_code_27, c1_.company_address_city AS company_address_city_28, c1_.company_address_country AS company_address_country_29, a0_.discr AS discr_30, a0_.company_id AS company_id_31 FROM advertisement a0_ INNER JOIN company_profile c1_ ON a0_.company_id = c1_.id WHERE (a0_.status = 0 AND a0_.valid_from <= '2025-12-22 23:59:59' AND a0_.valid_to >= '2025-12-22 23:59:59') AND a0_.discr IN ('offer') ORDER BY a0_.created_at DESC LIMIT 10;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  advertisement a0_
WHERE
  (
    a0_.status = ?
    AND a0_.valid_from <= ?
    AND a0_.valid_to >= ?
  )
  AND a0_.discr IN ('offer')

SELECT COUNT(a0_.id) AS sclr_0 FROM advertisement a0_ WHERE (a0_.status = 0 AND a0_.valid_from <= '2025-12-22 23:59:59' AND a0_.valid_to >= '2025-12-22 23:59:59') AND a0_.discr IN ('offer');

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  advertisement a0_
WHERE
  (
    a0_.status = ?
    AND a0_.valid_from <= ?
    AND a0_.valid_to >= ?
  )
  AND a0_.discr IN ('demand')

SELECT COUNT(a0_.id) AS sclr_0 FROM advertisement a0_ WHERE (a0_.status = 0 AND a0_.valid_from <= '2025-12-22 23:59:59' AND a0_.valid_to >= '2025-12-22 23:59:59') AND a0_.discr IN ('demand');

SELECT
  c0_.id AS id_0,
  COUNT(c1_.id) AS sclr_1
FROM
  category c0_
  INNER JOIN company_profile_industry_category c2_ ON c0_.id = c2_.industry_category_id
  INNER JOIN company_profile c1_ ON c1_.id = c2_.company_profile_id
WHERE
  c0_.discr IN ('industry')
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(c1_.id) AS sclr_1 FROM category c0_ INNER JOIN company_profile_industry_category c2_ ON c0_.id = c2_.industry_category_id INNER JOIN company_profile c1_ ON c1_.id = c2_.company_profile_id WHERE c0_.discr IN ('industry') GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.discr AS discr_3,
  c0_.parent_id AS parent_id_4
FROM
  category c0_
WHERE
  (
    c0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?
    )
  )
  AND c0_.discr IN ('industry')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.discr AS discr_3, c0_.parent_id AS parent_id_4 FROM category c0_ WHERE (c0_.id IN (17, 21, 23, 32, 34, 35, 38, 40, 46, 47, 49, 50, 51, 52, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 78, 80, 81, 82, 83, 84, 87, 90, 92, 93, 95, 96, 97, 100)) AND c0_.discr IN ('industry') ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 83 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 80 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 78 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 76 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 68 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 67 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 64 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 62 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 61 AND t0.discr IN ('industry');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4,
  t0.discr
FROM
  category t0
  INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id
WHERE
  advertisement_industry_category.advertisement_id = ?
  AND t0.discr IN ('industry')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.discr FROM category t0 INNER JOIN advertisement_industry_category ON t0.id = advertisement_industry_category.industry_category_id WHERE advertisement_industry_category.advertisement_id = 60 AND t0.discr IN ('industry');