Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1183
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• JMS Serializer 0
• VichUploader
• Configuration

Query Metrics

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.sort_order AS sort_order_2, r0_.created AS created_3, r0_.created_by AS created_by_4, r0_.updated AS updated_5, r0_.updated_by AS updated_by_6 FROM research_status r0_ ORDER BY r0_.id ASC

[]

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.sort_order AS sort_order_2,
  r0_.created AS created_3,
  r0_.created_by AS created_by_4,
  r0_.updated AS updated_5,
  r0_.updated_by AS updated_by_6
FROM
  research_status r0_
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.sort_order AS sort_order_2, r0_.created AS created_3, r0_.created_by AS created_by_4, r0_.updated AS updated_5, r0_.updated_by AS updated_by_6 FROM research_status r0_ ORDER BY r0_.id ASC;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.sponsor AS sponsor_2, r0_.clinical_trials_id AS clinical_trials_id_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.help_needed AS help_needed_6, r0_.summary_description AS summary_description_7, r0_.full_description AS full_description_8, r0_.keywords AS keywords_9, r0_.created AS created_10, r0_.created_by AS created_by_11, r0_.updated AS updated_12, r0_.updated_by AS updated_by_13 FROM research_study r0_ ORDER BY r0_.end_date DESC) dctrn_result) dctrn_table

[]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.sponsor AS sponsor_2,
          r0_.clinical_trials_id AS clinical_trials_id_3,
          r0_.start_date AS start_date_4,
          r0_.end_date AS end_date_5,
          r0_.help_needed AS help_needed_6,
          r0_.summary_description AS summary_description_7,
          r0_.full_description AS full_description_8,
          r0_.keywords AS keywords_9,
          r0_.created AS created_10,
          r0_.created_by AS created_by_11,
          r0_.updated AS updated_12,
          r0_.updated_by AS updated_by_13
        FROM
          research_study r0_
        ORDER BY
          r0_.end_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.sponsor AS sponsor_2, r0_.clinical_trials_id AS clinical_trials_id_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.help_needed AS help_needed_6, r0_.summary_description AS summary_description_7, r0_.full_description AS full_description_8, r0_.keywords AS keywords_9, r0_.created AS created_10, r0_.created_by AS created_by_11, r0_.updated AS updated_12, r0_.updated_by AS updated_by_13 FROM research_study r0_ ORDER BY r0_.end_date DESC) dctrn_result) dctrn_table;