Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 187
• Events
• Routing
• Cache
• Translation 29
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Workflow
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.external_url AS external_url_3, t0.source AS source_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.category AS category_8, t0.state AS state_9, t0.expiry_date AS expiry_date_10, t0.extraction_date AS extraction_date_11, t0.thca_percentage AS thca_percentage_12, t0.total_thc_percentage AS total_thc_percentage_13, t0.delta_nine_percentage AS delta_nine_percentage_14, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_15, t0.comments AS comments_16, t0.internal_url AS internal_url_17, t0.markdown_content AS markdown_content_18, t0.debug_data AS debug_data_19, t0.json_content AS json_content_20, t0.lab_name AS lab_name_21, t0.sample_name AS sample_name_22, t0.sample_matrix AS sample_matrix_23, t0.internal_path AS internal_path_24, t0.product_type AS product_type_25, t0.project_id AS project_id_26, t0.lab_report_source_id AS lab_report_source_id_27 FROM lab_report t0 INNER JOIN product_lab_report ON t0.id = product_lab_report.lab_report_id WHERE product_lab_report.product_id = ?

[
  62
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.external_url AS external_url_3,
  t0.source AS source_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.category AS category_8,
  t0.state AS state_9,
  t0.expiry_date AS expiry_date_10,
  t0.extraction_date AS extraction_date_11,
  t0.thca_percentage AS thca_percentage_12,
  t0.total_thc_percentage AS total_thc_percentage_13,
  t0.delta_nine_percentage AS delta_nine_percentage_14,
  t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_15,
  t0.comments AS comments_16,
  t0.internal_url AS internal_url_17,
  t0.markdown_content AS markdown_content_18,
  t0.debug_data AS debug_data_19,
  t0.json_content AS json_content_20,
  t0.lab_name AS lab_name_21,
  t0.sample_name AS sample_name_22,
  t0.sample_matrix AS sample_matrix_23,
  t0.internal_path AS internal_path_24,
  t0.product_type AS product_type_25,
  t0.project_id AS project_id_26,
  t0.lab_report_source_id AS lab_report_source_id_27
FROM
  lab_report t0
  INNER JOIN product_lab_report ON t0.id = product_lab_report.lab_report_id
WHERE
  product_lab_report.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.external_url AS external_url_3, t0.source AS source_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.category AS category_8, t0.state AS state_9, t0.expiry_date AS expiry_date_10, t0.extraction_date AS extraction_date_11, t0.thca_percentage AS thca_percentage_12, t0.total_thc_percentage AS total_thc_percentage_13, t0.delta_nine_percentage AS delta_nine_percentage_14, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_15, t0.comments AS comments_16, t0.internal_url AS internal_url_17, t0.markdown_content AS markdown_content_18, t0.debug_data AS debug_data_19, t0.json_content AS json_content_20, t0.lab_name AS lab_name_21, t0.sample_name AS sample_name_22, t0.sample_matrix AS sample_matrix_23, t0.internal_path AS internal_path_24, t0.product_type AS product_type_25, t0.project_id AS project_id_26, t0.lab_report_source_id AS lab_report_source_id_27 FROM lab_report t0 INNER JOIN product_lab_report ON t0.id = product_lab_report.lab_report_id WHERE product_lab_report.product_id = 62;

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.prompt AS prompt_4, t0.chat_json AS chat_json_5, t0.external_lab_reports_url AS external_lab_reports_url_6, t0.product_matching_url AS product_matching_url_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.spider_source_matching_urls AS spider_source_matching_urls_10, t0.state AS state_11, t0.website_framework AS website_framework_12, t0.debug_data AS debug_data_13, t0.product_exclude_paths AS product_exclude_paths_14, t0.user_id AS user_id_15 FROM project t0 WHERE t0.id = ?

[
  73
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.prompt AS prompt_4,
  t0.chat_json AS chat_json_5,
  t0.external_lab_reports_url AS external_lab_reports_url_6,
  t0.product_matching_url AS product_matching_url_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.spider_source_matching_urls AS spider_source_matching_urls_10,
  t0.state AS state_11,
  t0.website_framework AS website_framework_12,
  t0.debug_data AS debug_data_13,
  t0.product_exclude_paths AS product_exclude_paths_14,
  t0.user_id AS user_id_15
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.prompt AS prompt_4, t0.chat_json AS chat_json_5, t0.external_lab_reports_url AS external_lab_reports_url_6, t0.product_matching_url AS product_matching_url_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.spider_source_matching_urls AS spider_source_matching_urls_10, t0.state AS state_11, t0.website_framework AS website_framework_12, t0.debug_data AS debug_data_13, t0.product_exclude_paths AS product_exclude_paths_14, t0.user_id AS user_id_15 FROM project t0 WHERE t0.id = 73;

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ ORDER BY p0_.id DESC LIMIT 50 OFFSET 6250

[]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
ORDER BY
  p0_.id DESC
LIMIT
  50
OFFSET
  6250

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ ORDER BY p0_.id DESC LIMIT 50 OFFSET 6250;

SELECT count(*) AS sclr_0 FROM product p0_

[]

SELECT
  count(*) AS sclr_0
FROM
  product p0_

SELECT count(*) AS sclr_0 FROM product p0_;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.lab_report_url AS lab_report_url_2, p0_.results AS results_3, p0_.product_page_url AS product_page_url_4, p0_.additional_data AS additional_data_5, p0_.state AS state_6, p0_.expiry_date AS expiry_date_7, p0_.extraction_date AS extraction_date_8, p0_.thca_percentage AS thca_percentage_9, p0_.total_thc_percentage AS total_thc_percentage_10, p0_.delta_nine_percentage AS delta_nine_percentage_11, p0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_12, p0_.comments AS comments_13, p0_.debug_data AS debug_data_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.product_page_id AS product_page_id_17, p0_.project_id AS project_id_18, p0_.product_url_id AS product_url_id_19 FROM product p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC

[
  62
  61
  60
  59
  58
  57
  56
  55
  54
  53
  52
  51
  50
  49
  48
  47
  45
  44
  38
  37
  36
  35
  34
  33
  32
  31
  30
  29
  28
  27
  25
  24
  23
  22
  21
  17
  16
  15
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.lab_report_url AS lab_report_url_2,
  p0_.results AS results_3,
  p0_.product_page_url AS product_page_url_4,
  p0_.additional_data AS additional_data_5,
  p0_.state AS state_6,
  p0_.expiry_date AS expiry_date_7,
  p0_.extraction_date AS extraction_date_8,
  p0_.thca_percentage AS thca_percentage_9,
  p0_.total_thc_percentage AS total_thc_percentage_10,
  p0_.delta_nine_percentage AS delta_nine_percentage_11,
  p0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_12,
  p0_.comments AS comments_13,
  p0_.debug_data AS debug_data_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p0_.product_page_id AS product_page_id_17,
  p0_.project_id AS project_id_18,
  p0_.product_url_id AS product_url_id_19
FROM
  product p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.lab_report_url AS lab_report_url_2, p0_.results AS results_3, p0_.product_page_url AS product_page_url_4, p0_.additional_data AS additional_data_5, p0_.state AS state_6, p0_.expiry_date AS expiry_date_7, p0_.extraction_date AS extraction_date_8, p0_.thca_percentage AS thca_percentage_9, p0_.total_thc_percentage AS total_thc_percentage_10, p0_.delta_nine_percentage AS delta_nine_percentage_11, p0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_12, p0_.comments AS comments_13, p0_.debug_data AS debug_data_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.product_page_id AS product_page_id_17, p0_.project_id AS project_id_18, p0_.product_url_id AS product_url_id_19 FROM product p0_ WHERE p0_.id IN (62, 61, 60, 59, 58, 57, 56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 45, 44, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 25, 24, 23, 22, 21, 17, 16, 15) ORDER BY p0_.id DESC;