toggle
1. (238.67ms; exec 237.52 + fetch 1.15; rows 104) SELECT a.id AS artifact_id, s.source_text AS snippet, MATCH(s.search_text) AGAINST ('+paliwa*' IN BOOLEAN MODE) AS relevance FROM text_segments s JOIN extractions e ON e.id = s.extraction_id JOIN processing_runs r ON r.id = e.run_id JOIN artifacts a ON a.id = e.source_artifact_id WHERE MATCH(s.search_text) AGAINST ('+paliwa*' IN BOOLEAN MODE) AND r.state = 'completed' AND NOT EXISTS (SELECT 1 FROM extractions selected JOIN processing_runs selected_run ON selected_run.id = selected.run_id WHERE selected.source_artifact_id = e.source_artifact_id AND selected_run.state = 'completed' AND (CASE selected.quality_state WHEN 'success' THEN 0 WHEN 'unreadable' THEN 1 ELSE 2 END < CASE e.quality_state WHEN 'success' THEN 0 WHEN 'unreadable' THEN 1 ELSE 2 END OR (CASE selected.quality_state WHEN 'success' THEN 0 WHEN 'unreadable' THEN 1 ELSE 2 END = CASE e.quality_state WHEN 'success' THEN 0 WHEN 'unreadable' THEN 1 ELSE 2 END AND (COALESCE(selected_run.finished_at, '1000-01-01') > COALESCE(r.finished_at, '1000-01-01') OR (selected_run.finished_at <=> r.finished_at AND selected.id > e.id))))) AND EXISTS ( SELECT 1 FROM document_version_artifacts binding JOIN document_versions version ON version.object_id = binding.version_id JOIN documents document ON document.object_id = version.document_id WHERE binding.artifact_id = a.id AND binding.role = 'html' AND binding.language = 'und' AND binding.current_selector_sha IS NOT NULL AND document.document_kind = 'statement_transcript' AND version.sequence_no = (SELECT MAX(latest.sequence_no) FROM document_versions latest WHERE latest.document_id = document.object_id) ) ORDER BY relevance DESC, a.sha256, s.page_from, s.page_to, s.extraction_id, s.ordinal LIMIT 121
2. (28.22ms; exec 27.13 + fetch 1.09; rows 104) SELECT STRAIGHT_JOIN statement.object_id AS statement_id, statement.statement_number, statement.speaker_name, mp.object_id AS member_id, day.term, day.proceeding_number, day.source_date AS day_date, dayStatement.ordinal, binding.artifact_id, binding.evidence_id, transcriptEvidence.selector_type AS transcript_selector_type, transcriptEvidence.selector AS transcript_selector, transcriptFetch.id AS fetch_id, transcriptFetch.requested_url AS source_url, LOWER(HEX(artifact.sha256)) AS sha256, artifact.detected_mime AS mime, artifact.byte_size, dayEvidence.id AS list_evidence_id, dayFetch.id AS list_fetch_id, dayFetch.requested_url AS list_source_url, LOWER(HEX(dayArtifact.sha256)) AS list_sha256, dayEvidence.selector_type AS list_selector_type, dayEvidence.selector AS list_selector FROM document_version_artifacts binding JOIN document_versions version ON version.object_id = binding.version_id JOIN documents document ON document.object_id = version.document_id AND document.document_kind = 'statement_transcript' AND version.sequence_no = (SELECT MAX(latest.sequence_no) FROM document_versions latest WHERE latest.document_id = document.object_id) JOIN sejm_transcript_days day ON day.object_id = document.owner_object_id JOIN sejm_statements statement ON statement.transcript_day_id = day.object_id AND statement.statement_number = CAST(SUBSTRING_INDEX(document.source_document_key, ':', -1) AS UNSIGNED) AND document.source_document_key = CONCAT('sejm:statement:', statement.statement_number) JOIN sejm_transcript_day_statements dayStatement ON dayStatement.day_id = day.object_id AND dayStatement.day_revision_id = day.current_revision_id AND dayStatement.statement_id = statement.object_id LEFT JOIN sejm_mp_identities mp ON mp.term = day.term AND mp.mp_number = statement.source_member_id JOIN evidence dayEvidence ON dayEvidence.id = dayStatement.evidence_id JOIN fetches dayFetch ON dayFetch.id = dayEvidence.fetch_id JOIN artifacts dayArtifact ON dayArtifact.id = dayEvidence.artifact_id JOIN artifacts artifact ON artifact.id = binding.artifact_id LEFT JOIN evidence transcriptEvidence ON transcriptEvidence.id = binding.evidence_id LEFT JOIN fetches transcriptFetch ON transcriptFetch.id = transcriptEvidence.fetch_id WHERE binding.role = 'html' AND binding.language = 'und' AND binding.current_selector_sha IS NOT NULL AND binding.artifact_id IN (14409, 14429, 8005, 6026, 8472, 10837, 6014, 8488, 8004, 17009, 23790, 14411, 8565, 12890, 6522, 7183, 8494, 16969, 8553, 1077, 13863, 6316, 8519, 23802, 6070, 8024, 6025, 23848, 23824, 6024, 14441, 6088, 11271, 21456, 8457, 8540, 13875, 6059, 8468, 27074, 23814, 14419, 16346, 25252, 6015, 3063, 17174, 17140, 77, 3516, 23671, 8554, 23825, 24914, 6506, 24941, 12549, 6038, 14484, 3288, 16968, 13528, 8023, 23793, 21857, 13848, 16966, 14028, 21454, 24350, 6058, 9241, 13513, 5235, 23836, 23847, 2648, 14468, 13916, 13378, 8528, 12550, 16993, 14421, 1537, 318, 16967, 23791, 24930, 6039, 23152, 17153, 21654, 8077, 6060, 14681, 6057, 8564, 3334, 10618, 14408, 23823, 23834, 18845) ORDER BY day.source_date DESC, day.term DESC, day.proceeding_number DESC, dayStatement.ordinal