Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  speech_type t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2 FROM speech_type t0 WHERE t0.id = 'remote' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.label AS label_1
FROM
  speech_type s0_

SELECT s0_.id AS id_0, s0_.label AS label_1 FROM speech_type s0_;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.job AS job_1,
          s0_.about_you AS about_you_2,
          s0_.about_your_job AS about_your_job_3,
          s0_.about_your_formation AS about_your_formation_4,
          s0_.about_your_offer AS about_your_offer_5,
          s0_.my_address_enabled AS my_address_enabled_6,
          s0_.itdlc_number AS itdlc_number_7,
          s0_.itdlc_distance_max AS itdlc_distance_max_8,
          s0_.available AS available_9,
          s0_.available_at AS available_at_10,
          s0_.context_available AS context_available_11,
          s0_.nb_itdlc_archived AS nb_itdlc_archived_12,
          s0_.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_13,
          s0_.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_14,
          s0_.nb_successive_non_response AS nb_successive_non_response_15,
          s0_.last_registration_step AS last_registration_step_16,
          s0_.available_date_updated AS available_date_updated_17,
          s0_.created_at AS created_at_18,
          s0_.updated_at AS updated_at_19,
          s0_.status AS status_20,
          s0_.comment AS comment_21,
          s0_.idv1 AS idv1_22,
          ST_AsText(a1_.position) AS position_23
        FROM
          speaker s0_
          INNER JOIN address a1_ ON s0_.current_address_id = a1_.id
          INNER JOIN speaker_speech_type s3_ ON s0_.id = s3_.speaker_id
          INNER JOIN speech_type s2_ ON s2_.id = s3_.speech_type_id
        WHERE
          s0_.status = ?
          AND s0_.context_available = ?
          AND s2_.id = ?
        ORDER BY
          s0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.job AS job_1, s0_.about_you AS about_you_2, s0_.about_your_job AS about_your_job_3, s0_.about_your_formation AS about_your_formation_4, s0_.about_your_offer AS about_your_offer_5, s0_.my_address_enabled AS my_address_enabled_6, s0_.itdlc_number AS itdlc_number_7, s0_.itdlc_distance_max AS itdlc_distance_max_8, s0_.available AS available_9, s0_.available_at AS available_at_10, s0_.context_available AS context_available_11, s0_.nb_itdlc_archived AS nb_itdlc_archived_12, s0_.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_13, s0_.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_14, s0_.nb_successive_non_response AS nb_successive_non_response_15, s0_.last_registration_step AS last_registration_step_16, s0_.available_date_updated AS available_date_updated_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.status AS status_20, s0_.comment AS comment_21, s0_.idv1 AS idv1_22, ST_AsText(a1_.position) AS position_23 FROM speaker s0_ INNER JOIN address a1_ ON s0_.current_address_id = a1_.id INNER JOIN speaker_speech_type s3_ ON s0_.id = s3_.speaker_id INNER JOIN speech_type s2_ ON s2_.id = s3_.speech_type_id WHERE s0_.status = 'published' AND s0_.context_available = 1 AND s2_.id = 'remote' ORDER BY s0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1
FROM
  activity_area a0_

SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.status AS status_2,
  c0_.activity_area_more AS activity_area_more_3,
  c0_.head_office_address AS head_office_address_4,
  c0_.head_office_zipcode AS head_office_zipcode_5,
  c0_.head_office_city AS head_office_city_6,
  c0_.head_office_country AS head_office_country_7,
  c0_.nb_employees AS nb_employees_8,
  c0_.logo AS logo_9,
  c0_.website_url AS website_url_10,
  c0_.perimeter AS perimeter_11,
  c0_.skills AS skills_12,
  c0_.partner AS partner_13,
  c0_.partner_itdlc AS partner_itdlc_14,
  c0_.partner_pee AS partner_pee_15,
  c0_.partner_foundation AS partner_foundation_16,
  c0_.slug AS slug_17,
  c0_.max_published_pee AS max_published_pee_18,
  c0_.count_pee_subscription_came AS count_pee_subscription_came_19,
  c0_.count_speaker AS count_speaker_20,
  c0_.count_itdlc_archived AS count_itdlc_archived_21,
  c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22,
  c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23,
  c0_.count_company_location AS count_company_location_24,
  c0_.company_idv1 AS company_idv1_25,
  c0_.other_activity_area AS other_activity_area_26,
  c0_.created_at AS created_at_27,
  c0_.updated_at AS updated_at_28,
  c0_.idv1 AS idv1_29,
  c0_.comment AS comment_30,
  c0_.activity_area_id AS activity_area_id_31,
  c0_.academy_id AS academy_id_32,
  c0_.corporation_id AS corporation_id_33,
  c0_.created_by AS created_by_34,
  c0_.updated_by AS updated_by_35
FROM
  company c0_
WHERE
  c0_.status = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ WHERE c0_.status = 'published' ORDER BY c0_.name ASC;

SELECT
  e0_.id AS id_0,
  e0_.label AS label_1
FROM
  education_level e0_

SELECT e0_.id AS id_0, e0_.label AS label_1 FROM education_level e0_;

SELECT
  c0_.id AS id_0,
  c0_.label AS label_1
FROM
  class_level c0_

SELECT c0_.id AS id_0, c0_.label AS label_1 FROM class_level c0_;