Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.status AS status_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.year_creation AS year_creation_4,
  c0_.number_project_last12_months AS number_project_last12_months_5,
  c0_.vat_number AS vat_number_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8
FROM
  company c0_
  LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id
WHERE
  c0_.status = ?
ORDER BY
  c0_.created_at DESC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.year_creation AS year_creation_4, c0_.number_project_last12_months AS number_project_last12_months_5, c0_.vat_number AS vat_number_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8 FROM company c0_ LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id WHERE c0_.status = 'active' ORDER BY c0_.created_at DESC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.postcode AS postcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.company_id AS company_id_7
FROM
  company_address t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.postcode AS postcode_4, t0.city AS city_5, t0.country AS country_6, t0.company_id AS company_id_7 FROM company_address t0 WHERE t0.company_id = 23;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.whats_app AS whats_app_4,
  t0.company_id AS company_id_5
FROM
  company_contact t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.whats_app AS whats_app_4, t0.company_id AS company_id_5 FROM company_contact t0 WHERE t0.company_id = 23;

SELECT
  t0.id AS id_1,
  t0.logo_image AS logo_image_2,
  t0.team_image AS team_image_3,
  t0.company_id AS company_id_4
FROM
  company_media t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.logo_image AS logo_image_2, t0.team_image AS team_image_3, t0.company_id AS company_id_4 FROM company_media t0 WHERE t0.company_id = 23;

SELECT
  t0.id AS id_1,
  t0.website_link AS website_link_2,
  t0.facebook_link AS facebook_link_3,
  t0.instagram_link AS instagram_link_4,
  t0.tiktok_link AS tiktok_link_5,
  t0.x_link AS x_link_6,
  t0.company_id AS company_id_7
FROM
  company_social_link t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.website_link AS website_link_2, t0.facebook_link AS facebook_link_3, t0.instagram_link AS instagram_link_4, t0.tiktok_link AS tiktok_link_5, t0.x_link AS x_link_6, t0.company_id AS company_id_7 FROM company_social_link t0 WHERE t0.company_id = 23;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.subscription_discount_snapshot AS subscription_discount_snapshot_3,
  t0.created_at AS created_at_4,
  t0.company_id AS company_id_5,
  t0.subscription_plan_price_id AS subscription_plan_price_id_6
FROM
  company_pending_subscription t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.subscription_discount_snapshot AS subscription_discount_snapshot_3, t0.created_at AS created_at_4, t0.company_id AS company_id_5, t0.subscription_plan_price_id AS subscription_plan_price_id_6 FROM company_pending_subscription t0 WHERE t0.company_id = 23;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.postcode AS postcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.company_id AS company_id_7
FROM
  company_address t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.postcode AS postcode_4, t0.city AS city_5, t0.country AS country_6, t0.company_id AS company_id_7 FROM company_address t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.whats_app AS whats_app_4,
  t0.company_id AS company_id_5
FROM
  company_contact t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.whats_app AS whats_app_4, t0.company_id AS company_id_5 FROM company_contact t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.logo_image AS logo_image_2,
  t0.team_image AS team_image_3,
  t0.company_id AS company_id_4
FROM
  company_media t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.logo_image AS logo_image_2, t0.team_image AS team_image_3, t0.company_id AS company_id_4 FROM company_media t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.website_link AS website_link_2,
  t0.facebook_link AS facebook_link_3,
  t0.instagram_link AS instagram_link_4,
  t0.tiktok_link AS tiktok_link_5,
  t0.x_link AS x_link_6,
  t0.company_id AS company_id_7
FROM
  company_social_link t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.website_link AS website_link_2, t0.facebook_link AS facebook_link_3, t0.instagram_link AS instagram_link_4, t0.tiktok_link AS tiktok_link_5, t0.x_link AS x_link_6, t0.company_id AS company_id_7 FROM company_social_link t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.subscription_discount_snapshot AS subscription_discount_snapshot_3,
  t0.created_at AS created_at_4,
  t0.company_id AS company_id_5,
  t0.subscription_plan_price_id AS subscription_plan_price_id_6
FROM
  company_pending_subscription t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.subscription_discount_snapshot AS subscription_discount_snapshot_3, t0.created_at AS created_at_4, t0.company_id AS company_id_5, t0.subscription_plan_price_id AS subscription_plan_price_id_6 FROM company_pending_subscription t0 WHERE t0.company_id = 1;

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.postcode AS postcode_2,
  p0_.year_of_construction AS year_of_construction_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.particular_project_budget_id AS particular_project_budget_id_6,
  p0_.user_id AS user_id_7
FROM
  particular_project p0_
  LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id
WHERE
  p0_.status LIKE ?
ORDER BY
  p0_.created_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.particular_project_budget_id AS particular_project_budget_id_6, p0_.user_id AS user_id_7 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.status LIKE '%active%' ORDER BY p0_.created_at DESC LIMIT 4;

SELECT
  s0_.id AS id_0,
  s0_.icon_image AS icon_image_1,
  s0_.sort AS sort_2,
  s1_.id AS id_3,
  s1_.title AS title_4,
  s1_.slug AS slug_5,
  s1_.profession_title AS profession_title_6,
  s1_.profession_description AS profession_description_7,
  s1_.seo_title AS seo_title_8,
  s1_.seo_description AS seo_description_9,
  s1_.seo_image AS seo_image_10,
  s1_.locale AS locale_11,
  s1_.translatable_id AS translatable_id_12
FROM
  service s0_
  LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id
  AND (s1_.locale = ?)

SELECT s0_.id AS id_0, s0_.icon_image AS icon_image_1, s0_.sort AS sort_2, s1_.id AS id_3, s1_.title AS title_4, s1_.slug AS slug_5, s1_.profession_title AS profession_title_6, s1_.profession_description AS profession_description_7, s1_.seo_title AS seo_title_8, s1_.seo_description AS seo_description_9, s1_.seo_image AS seo_image_10, s1_.locale AS locale_11, s1_.translatable_id AS translatable_id_12 FROM service s0_ LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr');

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.company_id AS company_id_3,
  t0.service_id AS service_id_4
FROM
  company_service t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.company_id AS company_id_3, t0.service_id AS service_id_4 FROM company_service t0 WHERE t0.company_id = 23 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.company_id AS company_id_3,
  t0.service_id AS service_id_4
FROM
  company_service t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.company_id AS company_id_3, t0.service_id AS service_id_4 FROM company_service t0 WHERE t0.company_id = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  particular_project_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM particular_project_translation t0 WHERE t0.translatable_id = 17;

SELECT
  t0.id AS id_1,
  t0.icon_image AS icon_image_2,
  t0.sort AS sort_3
FROM
  service t0
  INNER JOIN particular_project_service ON t0.id = particular_project_service.service_id
WHERE
  particular_project_service.particular_project_id = ?

SELECT t0.id AS id_1, t0.icon_image AS icon_image_2, t0.sort AS sort_3 FROM service t0 INNER JOIN particular_project_service ON t0.id = particular_project_service.service_id WHERE particular_project_service.particular_project_id = 17;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.sort AS sort_3,
  t0.particular_project_id AS particular_project_id_4
FROM
  particular_project_image t0
WHERE
  t0.particular_project_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = 17;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  particular_project_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM particular_project_translation t0 WHERE t0.translatable_id = 16;

SELECT
  t0.id AS id_1,
  t0.icon_image AS icon_image_2,
  t0.sort AS sort_3
FROM
  service t0
  INNER JOIN particular_project_service ON t0.id = particular_project_service.service_id
WHERE
  particular_project_service.particular_project_id = ?

SELECT t0.id AS id_1, t0.icon_image AS icon_image_2, t0.sort AS sort_3 FROM service t0 INNER JOIN particular_project_service ON t0.id = particular_project_service.service_id WHERE particular_project_service.particular_project_id = 16;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.sort AS sort_3,
  t0.particular_project_id AS particular_project_id_4
FROM
  particular_project_image t0
WHERE
  t0.particular_project_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = 16;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  particular_project_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM particular_project_translation t0 WHERE t0.translatable_id = 15;

SELECT
  t0.id AS id_1,
  t0.icon_image AS icon_image_2,
  t0.sort AS sort_3
FROM
  service t0
  INNER JOIN particular_project_service ON t0.id = particular_project_service.service_id
WHERE
  particular_project_service.particular_project_id = ?

SELECT t0.id AS id_1, t0.icon_image AS icon_image_2, t0.sort AS sort_3 FROM service t0 INNER JOIN particular_project_service ON t0.id = particular_project_service.service_id WHERE particular_project_service.particular_project_id = 15;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.sort AS sort_3,
  t0.particular_project_id AS particular_project_id_4
FROM
  particular_project_image t0
WHERE
  t0.particular_project_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = 15;