Symfony Profiler

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 = 121;

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 = 121;

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_.state = ?
    OR p0_.state IS NULL
  )
  AND p0_.project_id = ?
LIMIT
  1

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_.state = 'new' OR p0_.state IS NULL) AND p0_.project_id = 121 LIMIT 1;

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 = 121;

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 (121, 120, 119, 118, 117, 116, 115, 114, 112, 110, 108, 107, 105, 104, 103, 102, 101, 100, 99, 98, 97, 96, 95, 94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84, 83, 82, 81, 80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 67) ORDER BY p0_.id DESC;

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

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

SELECT
  count(*) AS sclr_0
FROM
  project p0_

SELECT count(*) AS sclr_0 FROM project p0_;