| 1 |
0.57 ms |
SELECT DISTINCT a0_.id AS id_0 FROM ailog a0_ LIMIT 20 OFFSET 100
SELECT DISTINCT a0_.id AS id_0 FROM ailog a0_ LIMIT 20 OFFSET 100;
|
| 2 |
6.69 ms |
SELECT a0_.id AS id_0, a0_.request_content AS request_content_1, a0_.response_content AS response_content_2, a0_.model AS model_3, a0_.provider AS provider_4, a0_.action AS action_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.response_output_type AS response_output_type_8, a0_.project_id AS project_id_9, a0_.lab_report_id AS lab_report_id_10, a0_.product_url_id AS product_url_id_11 FROM ailog a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
2371
2372
2374
2376
2377
2378
2379
2239
2382
2212
2213
2214
2215
2216
2217
2218
2219
2223
2225
2227
]
SELECT a0_.id AS id_0, a0_.request_content AS request_content_1, a0_.response_content AS response_content_2, a0_.model AS model_3, a0_.provider AS provider_4, a0_.action AS action_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.response_output_type AS response_output_type_8, a0_.project_id AS project_id_9, a0_.lab_report_id AS lab_report_id_10, a0_.product_url_id AS product_url_id_11 FROM ailog a0_ WHERE a0_.id IN (2371, 2372, 2374, 2376, 2377, 2378, 2379, 2239, 2382, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2223, 2225, 2227);
|
| 3 |
1.45 ms |
SELECT count(*) AS sclr_0 FROM ailog a0_
SELECT count(*) AS sclr_0 FROM ailog a0_;
|
| 4 |
1.59 ms |
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.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.id = 3025;
|
| 5 |
0.52 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 = ?
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 = 29;
|
| 6 |
0.53 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 WHERE t0.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.id = 1100;
|
| 7 |
1.23 ms |
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.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.id = 3474;
|
| 8 |
0.75 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 = ?
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 = 35;
|
| 9 |
1.91 ms |
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.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.id = 3527;
|
| 10 |
1.49 ms |
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.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.id = 3108;
|
| 11 |
1.72 ms |
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.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.id = 3589;
|
| 12 |
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 = ?
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 = 25;
|
| 13 |
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 WHERE t0.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.id = 1104;
|
| 14 |
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 = ?
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 = 18;
|
| 15 |
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 WHERE t0.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.id = 1105;
|
| 16 |
1.03 ms |
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.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.id = 2947;
|
| 17 |
0.46 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 = ?
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 = 27;
|