0.47 ms (21.98%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 , publication_date_8 FROM (SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . resume AS resume_3 , a0_ . conclusion AS conclusion_4 , a0_ . pmid AS pmid_5 , a0_ . url AS url_6 , a0_ . doi AS doi_7 , a0_ . publication_date AS publication_date_8 , a0_ . authors AS authors_9 , a0_ . journal AS journal_10 , a0_ . volume AS volume_11 , a0_ . issue AS issue_12 , a0_ . pages AS pages_13 , a0_ . hypotheses AS hypotheses_14 , a0_ . population AS population_15 , a0_ . variables AS variables_16 , a0_ . protocol AS protocol_17 , a0_ . measurement_tools AS measurement_tools_18 , a0_ . statistical_analyses AS statistical_analyses_19 , a0_ . statistical_results AS statistical_results_20 , a0_ . conclusions AS conclusions_21 , a0_ . limitations AS limitations_22 , a0_ . personal_interest AS personal_interest_23 , a0_ . other_comments AS other_comments_24 , a0_ . is_read AS is_read_25 , a0_ . is_favorite AS is_favorite_26 , a0_ . in_progress AS in_progress_27 , a0_ . created_at AS created_at_28 , a0_ . updated_at AS updated_at_29 , c1_ . id AS id_30 , c1_ . slug AS slug_31 , c1_ . label AS label_32 , c1_ . focus AS focus_33 , c1_ . keywords AS keywords_34 , c1_ . position AS position_35 , c1_ . last_imported_at AS last_imported_at_36 FROM article a0_ INNER JOIN article_category a2_ ON a0_ . id = a2_ . article_id INNER JOIN category c1_ ON c1_ . id = a2_ . category_id WHERE c1_ . id = ? ) dctrn_result_inner ORDER BY publication_date_8 DESC ) dctrn_result LIMIT 12 OFFSET 180
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 , publication_date_8 FROM (SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . resume AS resume_3 , a0_ . conclusion AS conclusion_4 , a0_ . pmid AS pmid_5 , a0_ . url AS url_6 , a0_ . doi AS doi_7 , a0_ . publication_date AS publication_date_8 , a0_ . authors AS authors_9 , a0_ . journal AS journal_10 , a0_ . volume AS volume_11 , a0_ . issue AS issue_12 , a0_ . pages AS pages_13 , a0_ . hypotheses AS hypotheses_14 , a0_ . population AS population_15 , a0_ . variables AS variables_16 , a0_ . protocol AS protocol_17 , a0_ . measurement_tools AS measurement_tools_18 , a0_ . statistical_analyses AS statistical_analyses_19 , a0_ . statistical_results AS statistical_results_20 , a0_ . conclusions AS conclusions_21 , a0_ . limitations AS limitations_22 , a0_ . personal_interest AS personal_interest_23 , a0_ . other_comments AS other_comments_24 , a0_ . is_read AS is_read_25 , a0_ . is_favorite AS is_favorite_26 , a0_ . in_progress AS in_progress_27 , a0_ . created_at AS created_at_28 , a0_ . updated_at AS updated_at_29 , c1_ . id AS id_30 , c1_ . slug AS slug_31 , c1_ . label AS label_32 , c1_ . focus AS focus_33 , c1_ . keywords AS keywords_34 , c1_ . position AS position_35 , c1_ . last_imported_at AS last_imported_at_36 FROM article a0_ INNER JOIN article_category a2_ ON a0_ . id = a2_ . article_id INNER JOIN category c1_ ON c1_ . id = a2_ . category_id WHERE c1_ . id = 10 ) dctrn_result_inner ORDER BY publication_date_8 DESC ) dctrn_result LIMIT 12 OFFSET 180 ;
Copy
0.44 ms (20.72%)
1
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . resume AS resume_3 , a0_ . conclusion AS conclusion_4 , a0_ . pmid AS pmid_5 , a0_ . url AS url_6 , a0_ . doi AS doi_7 , a0_ . publication_date AS publication_date_8 , a0_ . authors AS authors_9 , a0_ . journal AS journal_10 , a0_ . volume AS volume_11 , a0_ . issue AS issue_12 , a0_ . pages AS pages_13 , a0_ . hypotheses AS hypotheses_14 , a0_ . population AS population_15 , a0_ . variables AS variables_16 , a0_ . protocol AS protocol_17 , a0_ . measurement_tools AS measurement_tools_18 , a0_ . statistical_analyses AS statistical_analyses_19 , a0_ . statistical_results AS statistical_results_20 , a0_ . conclusions AS conclusions_21 , a0_ . limitations AS limitations_22 , a0_ . personal_interest AS personal_interest_23 , a0_ . other_comments AS other_comments_24 , a0_ . is_read AS is_read_25 , a0_ . is_favorite AS is_favorite_26 , a0_ . in_progress AS in_progress_27 , a0_ . created_at AS created_at_28 , a0_ . updated_at AS updated_at_29 FROM article a0_ INNER JOIN article_category a2_ ON a0_ . id = a2_ . article_id INNER JOIN category c1_ ON c1_ . id = a2_ . category_id WHERE c1_ . id = ? ORDER BY a0_ . publication_date DESC ) dctrn_result ) dctrn_table
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . resume AS resume_3 , a0_ . conclusion AS conclusion_4 , a0_ . pmid AS pmid_5 , a0_ . url AS url_6 , a0_ . doi AS doi_7 , a0_ . publication_date AS publication_date_8 , a0_ . authors AS authors_9 , a0_ . journal AS journal_10 , a0_ . volume AS volume_11 , a0_ . issue AS issue_12 , a0_ . pages AS pages_13 , a0_ . hypotheses AS hypotheses_14 , a0_ . population AS population_15 , a0_ . variables AS variables_16 , a0_ . protocol AS protocol_17 , a0_ . measurement_tools AS measurement_tools_18 , a0_ . statistical_analyses AS statistical_analyses_19 , a0_ . statistical_results AS statistical_results_20 , a0_ . conclusions AS conclusions_21 , a0_ . limitations AS limitations_22 , a0_ . personal_interest AS personal_interest_23 , a0_ . other_comments AS other_comments_24 , a0_ . is_read AS is_read_25 , a0_ . is_favorite AS is_favorite_26 , a0_ . in_progress AS in_progress_27 , a0_ . created_at AS created_at_28 , a0_ . updated_at AS updated_at_29 FROM article a0_ INNER JOIN article_category a2_ ON a0_ . id = a2_ . article_id INNER JOIN category c1_ ON c1_ . id = a2_ . category_id WHERE c1_ . id = 10 ORDER BY a0_ . publication_date DESC ) dctrn_result ) dctrn_table ;
Copy