Symfony Profiler

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

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

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.url AS url_2,
  p0_.prompt AS prompt_3,
  p0_.chat_json AS chat_json_4,
  p0_.external_lab_reports_url AS external_lab_reports_url_5,
  p0_.product_matching_url AS product_matching_url_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.spider_source_matching_urls AS spider_source_matching_urls_9,
  p0_.state AS state_10,
  p0_.website_framework AS website_framework_11,
  p0_.debug_data AS debug_data_12,
  p0_.product_exclude_paths AS product_exclude_paths_13,
  p0_.user_id AS user_id_14
FROM
  project p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.prompt AS prompt_3, p0_.chat_json AS chat_json_4, p0_.external_lab_reports_url AS external_lab_reports_url_5, p0_.product_matching_url AS product_matching_url_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.spider_source_matching_urls AS spider_source_matching_urls_9, p0_.state AS state_10, p0_.website_framework AS website_framework_11, p0_.debug_data AS debug_data_12, p0_.product_exclude_paths AS product_exclude_paths_13, p0_.user_id AS user_id_14 FROM project p0_ WHERE p0_.id IN (66, 65, 64, 63, 62, 61, 60, 59, 58, 57, 52, 51, 50, 49, 48, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 18, 17, 15, 14, 4, 3, 2, 1) ORDER BY p0_.id DESC;

SELECT
  count(*) AS sclr_0
FROM
  project p0_

SELECT count(*) AS sclr_0 FROM project p0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lab_report_url AS lab_report_url_3,
  t0.results AS results_4,
  t0.product_page_url AS product_page_url_5,
  t0.additional_data AS additional_data_6,
  t0.state AS state_7,
  t0.expiry_date AS expiry_date_8,
  t0.extraction_date AS extraction_date_9,
  t0.thca_percentage AS thca_percentage_10,
  t0.total_thc_percentage AS total_thc_percentage_11,
  t0.delta_nine_percentage AS delta_nine_percentage_12,
  t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13,
  t0.comments AS comments_14,
  t0.debug_data AS debug_data_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.product_page_id AS product_page_id_18,
  t0.project_id AS project_id_19,
  t0.product_url_id AS product_url_id_20
FROM
  product t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lab_report_url AS lab_report_url_3, t0.results AS results_4, t0.product_page_url AS product_page_url_5, t0.additional_data AS additional_data_6, t0.state AS state_7, t0.expiry_date AS expiry_date_8, t0.extraction_date AS extraction_date_9, t0.thca_percentage AS thca_percentage_10, t0.total_thc_percentage AS total_thc_percentage_11, t0.delta_nine_percentage AS delta_nine_percentage_12, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13, t0.comments AS comments_14, t0.debug_data AS debug_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.product_page_id AS product_page_id_18, t0.project_id AS project_id_19, t0.product_url_id AS product_url_id_20 FROM product t0 WHERE t0.project_id = 66;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.title AS title_5,
  t0.state AS state_6,
  t0.source AS source_7,
  t0.debug_data AS debug_data_8,
  t0.product_type AS product_type_9,
  t0.product_page_data AS product_page_data_10,
  t0.spider_source_url_id AS spider_source_url_id_11,
  t0.project_id AS project_id_12
FROM
  product_url t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.project_id = 66;

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
WHERE
  t0.project_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 WHERE t0.project_id = 66;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lab_report_url AS lab_report_url_3,
  t0.results AS results_4,
  t0.product_page_url AS product_page_url_5,
  t0.additional_data AS additional_data_6,
  t0.state AS state_7,
  t0.expiry_date AS expiry_date_8,
  t0.extraction_date AS extraction_date_9,
  t0.thca_percentage AS thca_percentage_10,
  t0.total_thc_percentage AS total_thc_percentage_11,
  t0.delta_nine_percentage AS delta_nine_percentage_12,
  t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13,
  t0.comments AS comments_14,
  t0.debug_data AS debug_data_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.product_page_id AS product_page_id_18,
  t0.project_id AS project_id_19,
  t0.product_url_id AS product_url_id_20
FROM
  product t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lab_report_url AS lab_report_url_3, t0.results AS results_4, t0.product_page_url AS product_page_url_5, t0.additional_data AS additional_data_6, t0.state AS state_7, t0.expiry_date AS expiry_date_8, t0.extraction_date AS extraction_date_9, t0.thca_percentage AS thca_percentage_10, t0.total_thc_percentage AS total_thc_percentage_11, t0.delta_nine_percentage AS delta_nine_percentage_12, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13, t0.comments AS comments_14, t0.debug_data AS debug_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.product_page_id AS product_page_id_18, t0.project_id AS project_id_19, t0.product_url_id AS product_url_id_20 FROM product t0 WHERE t0.project_id = 65;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.title AS title_5,
  t0.state AS state_6,
  t0.source AS source_7,
  t0.debug_data AS debug_data_8,
  t0.product_type AS product_type_9,
  t0.product_page_data AS product_page_data_10,
  t0.spider_source_url_id AS spider_source_url_id_11,
  t0.project_id AS project_id_12
FROM
  product_url t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.project_id = 65;

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
WHERE
  t0.project_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 WHERE t0.project_id = 65;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lab_report_url AS lab_report_url_3,
  t0.results AS results_4,
  t0.product_page_url AS product_page_url_5,
  t0.additional_data AS additional_data_6,
  t0.state AS state_7,
  t0.expiry_date AS expiry_date_8,
  t0.extraction_date AS extraction_date_9,
  t0.thca_percentage AS thca_percentage_10,
  t0.total_thc_percentage AS total_thc_percentage_11,
  t0.delta_nine_percentage AS delta_nine_percentage_12,
  t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13,
  t0.comments AS comments_14,
  t0.debug_data AS debug_data_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.product_page_id AS product_page_id_18,
  t0.project_id AS project_id_19,
  t0.product_url_id AS product_url_id_20
FROM
  product t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lab_report_url AS lab_report_url_3, t0.results AS results_4, t0.product_page_url AS product_page_url_5, t0.additional_data AS additional_data_6, t0.state AS state_7, t0.expiry_date AS expiry_date_8, t0.extraction_date AS extraction_date_9, t0.thca_percentage AS thca_percentage_10, t0.total_thc_percentage AS total_thc_percentage_11, t0.delta_nine_percentage AS delta_nine_percentage_12, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13, t0.comments AS comments_14, t0.debug_data AS debug_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.product_page_id AS product_page_id_18, t0.project_id AS project_id_19, t0.product_url_id AS product_url_id_20 FROM product t0 WHERE t0.project_id = 64;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.title AS title_5,
  t0.state AS state_6,
  t0.source AS source_7,
  t0.debug_data AS debug_data_8,
  t0.product_type AS product_type_9,
  t0.product_page_data AS product_page_data_10,
  t0.spider_source_url_id AS spider_source_url_id_11,
  t0.project_id AS project_id_12
FROM
  product_url t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.project_id = 64;

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
WHERE
  t0.project_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 WHERE t0.project_id = 64;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lab_report_url AS lab_report_url_3,
  t0.results AS results_4,
  t0.product_page_url AS product_page_url_5,
  t0.additional_data AS additional_data_6,
  t0.state AS state_7,
  t0.expiry_date AS expiry_date_8,
  t0.extraction_date AS extraction_date_9,
  t0.thca_percentage AS thca_percentage_10,
  t0.total_thc_percentage AS total_thc_percentage_11,
  t0.delta_nine_percentage AS delta_nine_percentage_12,
  t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13,
  t0.comments AS comments_14,
  t0.debug_data AS debug_data_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.product_page_id AS product_page_id_18,
  t0.project_id AS project_id_19,
  t0.product_url_id AS product_url_id_20
FROM
  product t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lab_report_url AS lab_report_url_3, t0.results AS results_4, t0.product_page_url AS product_page_url_5, t0.additional_data AS additional_data_6, t0.state AS state_7, t0.expiry_date AS expiry_date_8, t0.extraction_date AS extraction_date_9, t0.thca_percentage AS thca_percentage_10, t0.total_thc_percentage AS total_thc_percentage_11, t0.delta_nine_percentage AS delta_nine_percentage_12, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13, t0.comments AS comments_14, t0.debug_data AS debug_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.product_page_id AS product_page_id_18, t0.project_id AS project_id_19, t0.product_url_id AS product_url_id_20 FROM product t0 WHERE t0.project_id = 63;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.title AS title_5,
  t0.state AS state_6,
  t0.source AS source_7,
  t0.debug_data AS debug_data_8,
  t0.product_type AS product_type_9,
  t0.product_page_data AS product_page_data_10,
  t0.spider_source_url_id AS spider_source_url_id_11,
  t0.project_id AS project_id_12
FROM
  product_url t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.project_id = 63;

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
WHERE
  t0.project_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 WHERE t0.project_id = 63;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lab_report_url AS lab_report_url_3,
  t0.results AS results_4,
  t0.product_page_url AS product_page_url_5,
  t0.additional_data AS additional_data_6,
  t0.state AS state_7,
  t0.expiry_date AS expiry_date_8,
  t0.extraction_date AS extraction_date_9,
  t0.thca_percentage AS thca_percentage_10,
  t0.total_thc_percentage AS total_thc_percentage_11,
  t0.delta_nine_percentage AS delta_nine_percentage_12,
  t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13,
  t0.comments AS comments_14,
  t0.debug_data AS debug_data_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.product_page_id AS product_page_id_18,
  t0.project_id AS project_id_19,
  t0.product_url_id AS product_url_id_20
FROM
  product t0
WHERE
  t0.project_id = ?