| 1 |
0.18 ms
|
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.tagline AS tagline_4, t0.description AS description_5, t0.color_primary AS color_primary_6, t0.color_header_start AS color_header_start_7, t0.color_header_end AS color_header_end_8, t0.logo AS logo_9, t0.position AS position_10, t0.is_active AS is_active_11 FROM project t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.tagline AS tagline_4, t0.description AS description_5, t0.color_primary AS color_primary_6, t0.color_header_start AS color_header_start_7, t0.color_header_end AS color_header_end_8, t0.logo AS logo_9, t0.position AS position_10, t0.is_active AS is_active_11 FROM project t0 WHERE t0.slug = 'ssh' LIMIT 1;
|
| 2 |
0.22 ms
|
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.resume AS resume_4, t0.conclusion AS conclusion_5, t0.pmid AS pmid_6, t0.url AS url_7, t0.doi AS doi_8, t0.publication_date AS publication_date_9, t0.authors AS authors_10, t0.journal AS journal_11, t0.volume AS volume_12, t0.issue AS issue_13, t0.pages AS pages_14, t0.hypotheses AS hypotheses_15, t0.population AS population_16, t0.variables AS variables_17, t0.protocol AS protocol_18, t0.measurement_tools AS measurement_tools_19, t0.statistical_analyses AS statistical_analyses_20, t0.statistical_results AS statistical_results_21, t0.conclusions AS conclusions_22, t0.limitations AS limitations_23, t0.personal_interest AS personal_interest_24, t0.other_comments AS other_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27 FROM article t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.resume AS resume_4, t0.conclusion AS conclusion_5, t0.pmid AS pmid_6, t0.url AS url_7, t0.doi AS doi_8, t0.publication_date AS publication_date_9, t0.authors AS authors_10, t0.journal AS journal_11, t0.volume AS volume_12, t0.issue AS issue_13, t0.pages AS pages_14, t0.hypotheses AS hypotheses_15, t0.population AS population_16, t0.variables AS variables_17, t0.protocol AS protocol_18, t0.measurement_tools AS measurement_tools_19, t0.statistical_analyses AS statistical_analyses_20, t0.statistical_results AS statistical_results_21, t0.conclusions AS conclusions_22, t0.limitations AS limitations_23, t0.personal_interest AS personal_interest_24, t0.other_comments AS other_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27 FROM article t0 WHERE t0.id = '14172';
|
| 3 |
0.20 ms
|
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.is_public AS is_public_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.project_id AS project_id_7, t0.author_id AS author_id_8 FROM note t0 WHERE t0.project_id = ? ORDER BY t0.title ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.is_public AS is_public_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.project_id AS project_id_7, t0.author_id AS author_id_8 FROM note t0 WHERE t0.project_id = 3 ORDER BY t0.title ASC;
|
| 5 |
0.22 ms
|
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.label ASC
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = 3 ORDER BY t0.position ASC, t0.label ASC;
|
| 6 |
0.16 ms
|
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_favorite AS is_favorite_3, t0.in_progress AS in_progress_4, t0.linked_at AS linked_at_5, t0.unlinked_at AS unlinked_at_6, t0.article_id AS article_id_7, t0.project_id AS project_id_8, t0.in_progress_by_id AS in_progress_by_id_9 FROM article_project t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_favorite AS is_favorite_3, t0.in_progress AS in_progress_4, t0.linked_at AS linked_at_5, t0.unlinked_at AS unlinked_at_6, t0.article_id AS article_id_7, t0.project_id AS project_id_8, t0.in_progress_by_id AS in_progress_by_id_9 FROM article_project t0 WHERE t0.article_id = 14172;
|
| 7 |
0.12 ms
|
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 14172;
|