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 t0.pearl_category_index AS pearl_category_index_1, t0.pearl_category_name AS pearl_category_name_2 FROM pearl_category t0 WHERE t0.pearl_category_index = ? LIMIT 1

[
  "33"
]

SELECT
  t0.pearl_category_index AS pearl_category_index_1,
  t0.pearl_category_name AS pearl_category_name_2
FROM
  pearl_category t0
WHERE
  t0.pearl_category_index = ?
LIMIT
  1

SELECT t0.pearl_category_index AS pearl_category_index_1, t0.pearl_category_name AS pearl_category_name_2 FROM pearl_category t0 WHERE t0.pearl_category_index = '33' LIMIT 1;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT pearl_index_0 FROM (SELECT p0_.pearl_index AS pearl_index_0, p0_.pearl_title AS pearl_title_1, p0_.pearl_author AS pearl_author_2, p0_.pearl_category AS pearl_category_3, p0_.pearl_audience AS pearl_audience_4, p0_.pearl_message AS pearl_message_5, p0_.pearl_timestamp AS pearl_timestamp_6, p0_.pearl_emailed AS pearl_emailed_7, p0_.pearl_keywords AS pearl_keywords_8, p0_.pearl_reference AS pearl_reference_9, p0_.pearl_active AS pearl_active_10, p0_.pearl_updated AS pearl_updated_11, p0_.pearl_preview AS pearl_preview_12, p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13, p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14, p0_.format AS format_15, p1_.pearl_file_index AS pearl_file_index_16, p1_.pearl_message_index AS pearl_message_index_17, p1_.pearl_file_title AS pearl_file_title_18, p1_.pearl_file_type AS pearl_file_type_19, p1_.pearl_file_size AS pearl_file_size_20, p1_.pearl_file_timestamp AS pearl_file_timestamp_21, p1_.pearl_file_location AS pearl_file_location_22, p1_.pearl_file_audience AS pearl_file_audience_23 FROM pearl p0_ LEFT JOIN pearl_file p1_ ON p0_.pearl_index = p1_.pearl_message_index WHERE p0_.pearl_active = 1 AND p0_.pearl_category = ? ORDER BY p0_.pearl_emailed DESC) dctrn_result) dctrn_table

[
  "33"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT pearl_index_0
    FROM
      (
        SELECT
          p0_.pearl_index AS pearl_index_0,
          p0_.pearl_title AS pearl_title_1,
          p0_.pearl_author AS pearl_author_2,
          p0_.pearl_category AS pearl_category_3,
          p0_.pearl_audience AS pearl_audience_4,
          p0_.pearl_message AS pearl_message_5,
          p0_.pearl_timestamp AS pearl_timestamp_6,
          p0_.pearl_emailed AS pearl_emailed_7,
          p0_.pearl_keywords AS pearl_keywords_8,
          p0_.pearl_reference AS pearl_reference_9,
          p0_.pearl_active AS pearl_active_10,
          p0_.pearl_updated AS pearl_updated_11,
          p0_.pearl_preview AS pearl_preview_12,
          p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13,
          p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14,
          p0_.format AS format_15,
          p1_.pearl_file_index AS pearl_file_index_16,
          p1_.pearl_message_index AS pearl_message_index_17,
          p1_.pearl_file_title AS pearl_file_title_18,
          p1_.pearl_file_type AS pearl_file_type_19,
          p1_.pearl_file_size AS pearl_file_size_20,
          p1_.pearl_file_timestamp AS pearl_file_timestamp_21,
          p1_.pearl_file_location AS pearl_file_location_22,
          p1_.pearl_file_audience AS pearl_file_audience_23
        FROM
          pearl p0_
          LEFT JOIN pearl_file p1_ ON p0_.pearl_index = p1_.pearl_message_index
        WHERE
          p0_.pearl_active = 1
          AND p0_.pearl_category = ?
        ORDER BY
          p0_.pearl_emailed DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT pearl_index_0 FROM (SELECT p0_.pearl_index AS pearl_index_0, p0_.pearl_title AS pearl_title_1, p0_.pearl_author AS pearl_author_2, p0_.pearl_category AS pearl_category_3, p0_.pearl_audience AS pearl_audience_4, p0_.pearl_message AS pearl_message_5, p0_.pearl_timestamp AS pearl_timestamp_6, p0_.pearl_emailed AS pearl_emailed_7, p0_.pearl_keywords AS pearl_keywords_8, p0_.pearl_reference AS pearl_reference_9, p0_.pearl_active AS pearl_active_10, p0_.pearl_updated AS pearl_updated_11, p0_.pearl_preview AS pearl_preview_12, p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13, p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14, p0_.format AS format_15, p1_.pearl_file_index AS pearl_file_index_16, p1_.pearl_message_index AS pearl_message_index_17, p1_.pearl_file_title AS pearl_file_title_18, p1_.pearl_file_type AS pearl_file_type_19, p1_.pearl_file_size AS pearl_file_size_20, p1_.pearl_file_timestamp AS pearl_file_timestamp_21, p1_.pearl_file_location AS pearl_file_location_22, p1_.pearl_file_audience AS pearl_file_audience_23 FROM pearl p0_ LEFT JOIN pearl_file p1_ ON p0_.pearl_index = p1_.pearl_message_index WHERE p0_.pearl_active = 1 AND p0_.pearl_category = '33' ORDER BY p0_.pearl_emailed DESC) dctrn_result) dctrn_table;