Query Metrics
49
Database Queries
5
Different statements
33.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.44 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ ORDER BY p0_.id DESC LIMIT 50 OFFSET 6250
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 2 | 0.75 ms |
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
Parameters:
[ 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 ]
|
||||||||||||||||||||||||||||||||
| 3 | 1.14 ms |
SELECT count(*) AS sclr_0 FROM product p0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 4 | 0.49 ms |
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 = ?
Parameters:
[
73
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.56 ms |
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 = ?
Parameters:
[
62
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.54 ms |
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 = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 7 | 0.50 ms |
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 = ?
Parameters:
[
60
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.57 ms |
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 = ?
Parameters:
[
59
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.50 ms |
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 = ?
Parameters:
[
58
]
|
||||||||||||||||||||||||||||||||
| 10 | 0.51 ms |
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 = ?
Parameters:
[
57
]
|
||||||||||||||||||||||||||||||||
| 11 | 0.42 ms |
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 = ?
Parameters:
[
71
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.47 ms |
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 = ?
Parameters:
[
56
]
|
||||||||||||||||||||||||||||||||
| 13 | 0.41 ms |
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 = ?
Parameters:
[
69
]
|
||||||||||||||||||||||||||||||||
| 14 | 0.51 ms |
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 = ?
Parameters:
[
55
]
|
||||||||||||||||||||||||||||||||
| 15 | 0.49 ms |
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 = ?
Parameters:
[
54
]
|
||||||||||||||||||||||||||||||||
| 16 | 0.58 ms |
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 = ?
Parameters:
[
53
]
|
||||||||||||||||||||||||||||||||
| 17 | 0.67 ms |
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 = ?
Parameters:
[
52
]
|
||||||||||||||||||||||||||||||||
| 18 | 0.61 ms |
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 = ?
Parameters:
[
51
]
|
||||||||||||||||||||||||||||||||
| 19 | 0.56 ms |
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 = ?
Parameters:
[
50
]
|
||||||||||||||||||||||||||||||||
| 20 | 0.77 ms |
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 = ?
Parameters:
[
49
]
|
||||||||||||||||||||||||||||||||
| 21 | 0.62 ms |
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 = ?
Parameters:
[
48
]
|
||||||||||||||||||||||||||||||||
| 22 | 0.66 ms |
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 = ?
Parameters:
[
47
]
|
||||||||||||||||||||||||||||||||
| 23 | 0.70 ms |
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 = ?
Parameters:
[
45
]
|
||||||||||||||||||||||||||||||||
| 24 | 0.81 ms |
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 = ?
Parameters:
[
44
]
|
||||||||||||||||||||||||||||||||
| 25 | 0.69 ms |
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 = ?
Parameters:
[
31
]
|
||||||||||||||||||||||||||||||||
| 26 | 0.69 ms |
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 = ?
Parameters:
[
38
]
|
||||||||||||||||||||||||||||||||
| 27 | 0.70 ms |
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 = ?
Parameters:
[
37
]
|
||||||||||||||||||||||||||||||||
| 28 | 0.62 ms |
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 = ?
Parameters:
[
36
]
|
||||||||||||||||||||||||||||||||
| 29 | 0.89 ms |
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 = ?
Parameters:
[
35
]
|
||||||||||||||||||||||||||||||||
| 30 | 0.66 ms |
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 = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
| 31 | 0.63 ms |
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 = ?
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||||
| 32 | 0.72 ms |
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 = ?
Parameters:
[
32
]
|
||||||||||||||||||||||||||||||||
| 33 | 1.11 ms |
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 = ?
Parameters:
[
31
]
|
||||||||||||||||||||||||||||||||
| 34 | 0.77 ms |
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 = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||
| 35 | 0.67 ms |
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 = ?
Parameters:
[
29
]
|
||||||||||||||||||||||||||||||||
| 36 | 0.59 ms |
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 = ?
Parameters:
[
50
]
|
||||||||||||||||||||||||||||||||
| 37 | 0.67 ms |
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 = ?
Parameters:
[
28
]
|
||||||||||||||||||||||||||||||||
| 38 | 0.65 ms |
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 = ?
Parameters:
[
27
]
|
||||||||||||||||||||||||||||||||
| 39 | 0.47 ms |
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 = ?
Parameters:
[
67
]
|
||||||||||||||||||||||||||||||||
| 40 | 0.60 ms |
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 = ?
Parameters:
[
25
]
|
||||||||||||||||||||||||||||||||
| 41 | 0.82 ms |
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 = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||
| 42 | 0.51 ms |
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 = ?
Parameters:
[
59
]
|
||||||||||||||||||||||||||||||||
| 43 | 0.69 ms |
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 = ?
Parameters:
[
23
]
|
||||||||||||||||||||||||||||||||
| 44 | 0.58 ms |
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 = ?
Parameters:
[
22
]
|
||||||||||||||||||||||||||||||||
| 45 | 1.00 ms |
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 = ?
Parameters:
[
21
]
|
||||||||||||||||||||||||||||||||
| 46 | 0.54 ms |
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 = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 47 | 0.61 ms |
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 = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||||||||||
| 48 | 0.59 ms |
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 = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 49 | 0.61 ms |
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 = ?
Parameters:
[
15
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\ProductPage | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\ProductUrl | No errors. |
| App\Entity\LabReport | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SpiderSourceUrl | No errors. |
| App\Entity\LabReportSource | No errors. |
| App\Entity\LabReportFail | No errors. |
| App\Entity\AILog | No errors. |
| App\Entity\AIBatchJob | No errors. |