1014.17 ms (91.95%)
35
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 ;
Copy
40.55 ms (3.68%)
35
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 ;
Copy
25.03 ms (2.27%)
35
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 ;
Copy
21.31 ms (1.93%)
35
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 = 66 LIMIT 1 ;
Copy
0.85 ms (0.08%)
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_ WHERE p0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY p0_ . id DESC
Parameters :
[
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
]
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
Copy
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 ;
Copy
0.53 ms (0.05%)
1
SELECT count (* ) AS sclr_0 FROM project p0_
SELECT count (* ) AS sclr_0 FROM project p0_ ;
Copy
0.48 ms (0.04%)
1
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 ;
Copy