19.33 ms (84.02%)
|
1 |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.external_url AS external_url_2, l0_.source AS source_3, l0_.type AS type_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.category AS category_7, l0_.state AS state_8, l0_.expiry_date AS expiry_date_9, l0_.extraction_date AS extraction_date_10, l0_.thca_percentage AS thca_percentage_11, l0_.total_thc_percentage AS total_thc_percentage_12, l0_.delta_nine_percentage AS delta_nine_percentage_13, l0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_14, l0_.comments AS comments_15, l0_.internal_url AS internal_url_16, l0_.markdown_content AS markdown_content_17, l0_.debug_data AS debug_data_18, l0_.json_content AS json_content_19, l0_.lab_name AS lab_name_20, l0_.sample_name AS sample_name_21, l0_.sample_matrix AS sample_matrix_22, l0_.internal_path AS internal_path_23, l0_.product_type AS product_type_24, l0_.project_id AS project_id_25, l0_.lab_report_source_id AS lab_report_source_id_26 FROM lab_report l0_
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.external_url AS external_url_2, l0_.source AS source_3, l0_.type AS type_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.category AS category_7, l0_.state AS state_8, l0_.expiry_date AS expiry_date_9, l0_.extraction_date AS extraction_date_10, l0_.thca_percentage AS thca_percentage_11, l0_.total_thc_percentage AS total_thc_percentage_12, l0_.delta_nine_percentage AS delta_nine_percentage_13, l0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_14, l0_.comments AS comments_15, l0_.internal_url AS internal_url_16, l0_.markdown_content AS markdown_content_17, l0_.debug_data AS debug_data_18, l0_.json_content AS json_content_19, l0_.lab_name AS lab_name_20, l0_.sample_name AS sample_name_21, l0_.sample_matrix AS sample_matrix_22, l0_.internal_path AS internal_path_23, l0_.product_type AS product_type_24, l0_.project_id AS project_id_25, l0_.lab_report_source_id AS lab_report_source_id_26 FROM lab_report l0_;
|
1.60 ms (6.96%)
|
1 |
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_
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_;
|
0.77 ms (3.33%)
|
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 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 = 6270;
|
0.68 ms (2.94%)
|
1 |
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 = 78;
|
0.63 ms (2.75%)
|
1 |
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.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.id = '6270';
|