Ustawy i projekty
Wszystkie projekty ustaw i uchwał zgłoszone w Sejmie, z etapem procesu i statusem ze źródła.
Wszystkie projekty ustaw i uchwał zgłoszone w Sejmie, z etapem procesu i statusem ze źródła.
1. (1.3ms; exec 1.28 + fetch 0.02; rows 1) SELECT COUNT(*) FROM sejm_bills b WHERE 1 = 12. (7.01ms; exec 6.75 + fetch 0.26; rows 50) SELECT b.object_id, b.term, b.bill_number, b.print_number, b.title, b.source_status, b.submission_type, b.received_on, b…3. (11.76ms; exec 10.33 + fetch 1.42; rows 371) SELECT l.bill_id, p.object_id AS process_id, a.object_id AS linked_act_id, p.eli_id, s.stage_type, s.stage_name, s.sourc…4. (1.98ms; exec 1.93 + fetch 0.05; rows 3) SELECT b.source_status AS value, COUNT(*) AS total FROM sejm_bills b WHERE 1 = 1 GROUP BY b.source_status ORDER BY total…5. (3.85ms; exec 3.79 + fetch 0.06; rows 4) SELECT b.submission_type AS value, COUNT(*) AS total FROM sejm_bills b WHERE 1 = 1 GROUP BY b.submission_type ORDER BY t…6. (5.53ms; exec 5.48 + fetch 0.04; rows 2) SELECT assignment.id AS assignment_id, assignment.object_id, topic.id AS topic_id, topic.slug, topic.name, assignment.ma…7. (1.2ms; exec 1.17 + fetch 0.02; rows 1) SELECT t.id, t.slug, t.name, COUNT(DISTINCT b.object_id) AS cases, COUNT(DISTINCT a.object_id) AS acts FROM topics t LEF…
1. (1.3ms; exec 1.28 + fetch 0.02; rows 1) SELECT COUNT(*) FROM sejm_bills b WHERE 1 = 12. (7.01ms; exec 6.75 + fetch 0.26; rows 50) SELECT b.object_id, b.term, b.bill_number, b.print_number, b.title, b.source_status, b.submission_type, b.received_on, b.applicant_type, JSON_VALUE(r.snapshot, '$.description') AS description, r.recorded_at AS changed_at FROM sejm_bills b LEFT JOIN object_revisions r ON r.id = b.current_revision_id WHERE 1 = 1 ORDER BY b.received_on DESC, b.object_id DESC LIMIT 50 OFFSET 7503. (11.76ms; exec 10.33 + fetch 1.42; rows 371) SELECT l.bill_id, p.object_id AS process_id, a.object_id AS linked_act_id, p.eli_id, s.stage_type, s.stage_name, s.source_date, publication.published_date, (SELECT MIN(e.id) FROM eli_act_source_facts fact JOIN eli_act_fact_evidence fe ON fe.fact_id = fact.id JOIN evidence e ON e.id = fe.evidence_id WHERE fact.act_id = a.object_id AND fact.field_code = 'promulgation' AND fact.source_date = publication.published_date AND JSON_VALUE(e.selector, '$.pointer') = '/promulgation') AS publication_evidence_id FROM (SELECT DISTINCT link.bill_id, link.process_id FROM sejm_bill_process_links link JOIN sejm_bills b ON b.object_id = link.bill_id AND b.current_revision_id = link.bill_revision_id WHERE link.bill_id IN (564,563,562,561,560,559,558,557,556,555,554,553,552,551,550,549,548,547,546,545,544,543,542,541,540,539,538,537,536,535,534,533,532,531,530,529,528,527,526,525,524,523,522,521,520,519,518,517,516,515)) l JOIN sejm_processes p ON p.object_id = l.process_id LEFT JOIN legal_acts a ON a.object_id = p.legal_act_id AND a.eli_id = p.eli_id LEFT JOIN publications publication ON publication.act_id = a.object_id AND a.publisher_code = 'DU' AND publication.publisher_code = 'DU' JOIN sejm_process_stages s ON s.process_revision_id = p.current_revision_id AND s.parent_path IS NULL ORDER BY l.bill_id, p.object_id, s.ordinal4. (1.98ms; exec 1.93 + fetch 0.05; rows 3) SELECT b.source_status AS value, COUNT(*) AS total FROM sejm_bills b WHERE 1 = 1 GROUP BY b.source_status ORDER BY total DESC5. (3.85ms; exec 3.79 + fetch 0.06; rows 4) SELECT b.submission_type AS value, COUNT(*) AS total FROM sejm_bills b WHERE 1 = 1 GROUP BY b.submission_type ORDER BY total DESC6. (5.53ms; exec 5.48 + fetch 0.04; rows 2) SELECT assignment.id AS assignment_id, assignment.object_id, topic.id AS topic_id, topic.slug, topic.name, assignment.match_basis, assignment.matched_value, assignment.evidence_id, rule.rule_code, rule.version AS rule_version, evidence.quote_text, CASE WHEN bill.object_id IS NULL THEN 'act' ELSE 'case' END AS kind, COALESCE(bill.title, act.title) AS title, COALESCE(bill.bill_number, act.eli_id) AS identifier, CASE WHEN bill.object_id IS NULL THEN CONCAT('/acts/', assignment.object_id) ELSE CONCAT('/cases/', assignment.object_id) END AS url, latest.decision AS latest_decision, actor.display_name AS latest_decision_by, latest.recorded_at AS latest_decision_at, NULL AS my_decision, NULL AS my_decision_at FROM topic_assignments assignment JOIN objects source_object ON source_object.id = assignment.object_id AND source_object.current_revision_id = assignment.revision_id JOIN topics topic ON topic.id = assignment.topic_id JOIN topic_rules rule ON rule.id = assignment.rule_id JOIN evidence ON evidence.id = assignment.evidence_id LEFT JOIN sejm_bills bill ON bill.object_id = assignment.object_id LEFT JOIN legal_acts act ON act.object_id = assignment.object_id LEFT JOIN topic_decisions latest ON latest.id = ( SELECT decision.id FROM topic_decisions decision WHERE decision.assignment_id = assignment.id ORDER BY decision.recorded_at DESC, decision.id DESC LIMIT 1) LEFT JOIN users actor ON actor.id = latest.actor_user_id WHERE assignment.is_current = 1 AND rule.enabled = 1 AND topic.enabled = 1 AND assignment.object_id IN (564,563,562,561,560,559,558,557,556,555,554,553,552,551,550,549,548,547,546,545,544,543,542,541,540,539,538,537,536,535,534,533,532,531,530,529,528,527,526,525,524,523,522,521,520,519,518,517,516,515) ORDER BY assignment.object_id, topic.name, FIELD(assignment.match_basis, 'eli_keyword', 'fulltext_phrase', 'title_term'), assignment.id7. (1.2ms; exec 1.17 + fetch 0.02; rows 1) SELECT t.id, t.slug, t.name, COUNT(DISTINCT b.object_id) AS cases, COUNT(DISTINCT a.object_id) AS acts FROM topics t LEFT JOIN topic_assignments assignment ON assignment.topic_id = t.id AND assignment.is_current = 1 LEFT JOIN topic_rules active_rule ON active_rule.id = assignment.rule_id AND active_rule.enabled = 1 LEFT JOIN objects current_object ON current_object.id = assignment.object_id AND current_object.current_revision_id = assignment.revision_id AND active_rule.id IS NOT NULL LEFT JOIN sejm_bills b ON b.object_id = current_object.id LEFT JOIN legal_acts a ON a.object_id = current_object.id WHERE t.enabled = 1 GROUP BY t.id, t.slug, t.name ORDER BY t.name, t.id
(1.02ms) /app/templates/overview/cases.php/app/public/index.php/app/vendor/autoload.php/app/vendor/composer/autoload_real.php/app/vendor/composer/platform_check.php/app/vendor/composer/ClassLoader.php/app/vendor/composer/autoload_static.php/app/vendor/symfony/deprecation-contracts/function.php/app/vendor/symfony/polyfill-php83/bootstrap.php/app/lib/PFrame.php/app/config/credentials/local.php/app/src/Http/AuthRoutes.php/app/src/Http/ReviewDecisionRoutes.php/app/src/Http/TopicDecisionRoutes.php/app/src/Http/WatchRoutes.php/app/src/Http/OverviewController.php/app/src/Overview/CaseReadModel.php/app/src/Time/AsOfTimestamp.php/app/src/Overview/LegislativeProgress.php/app/src/Topic/TopicReadModel.php/app/src/Overview/Format.php/app/templates/layout.php