query-optimization-tips

A set of tips for making 1C database queries run faster. 1C is a business software platform, and these rules cover query writing and review.

In plain words
What is it for?
Use it when writing or reviewing 1C queries, especially when handling fields with several possible data types or choosing indexes and temporary tables.
Why use it?
It helps avoid query patterns that make the database do unnecessary joins or repeated work.

Cursor rule

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add rules/desko77/cursor-1c-skills/query-optimization-tips
Clone the repo
git clone --depth 1 https://github.com/Desko77/cursor-1c-skills
Per session 0 Nothing until a file matches its globs; then the whole rule loads.
When invoked 2,618 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00000 $0.02618
Opus 5 $0.00000 $0.01309
Sonnet 5 $0.00000 $0.00524
Haiku 4.5 $0.00000 $0.00262

Measured 2d ago against content hash c77581959c2b, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

query-optimization-tips scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

rules/query-optimization-tips.mdc · 242 lines

How it starts

The opening of the file, as written. The whole thing — 242 lines — stays where its author put it; the contents beside it link to each section on GitHub.

1C Query Optimization Tips

Полезные советы по оптимизации запросов 1С (стандарты ИТС).

Применяется: при написании и ревью запросов 1С.

Анти-паттерны производительности (запрос в цикле, реквизиты через точку, кеширование) описаны в anti_patterns.md - здесь не дублируются. Продвинутые паттерны (временные таблицы, пакетные запросы, СКД) - см. скил /1c-query-optimization.


Составные типы - ВЫРАЗИТЬ

Обращение через точку к полям составного типа (напр. Регистратор) создает соединения со ВСЕМИ возможными типами. Используй ВЫРАЗИТЬ для указания конкретного типа.

// Плохо: обращение к полю Регистратора без ВЫРАЗИТЬ - JOIN со ВСЕМИ типами регистраторов
"ВЫБРАТЬ
|	ТоварыНаСкладах.Регистратор.Дата КАК ДатаДокумента
|ИЗ
|	РегистрНакопления.ТоварыНаСкладах КАК ТоварыНаСкладах"

// Хорошо: указан конкретный тип
"ВЫБРАТЬ
|	ВЫРАЗИТЬ(ТоварыНаСкладах.Регистратор КАК Документ.ПоступлениеТоваровУслуг).Дата КАК ДатаДокумента
|ИЗ
|	РегистрНакопления.ТоварыНаСкладах КАК ТоварыНаСкладах"

// Для нескольких типов - ВЫБОР/КОГДА
"ВЫБРАТЬ
|	ВЫБОР
|		КОГДА ТоварыНаСкладах.Регистратор ССЫЛКА Документ.ПоступлениеТоваровУслуг
|			ТОГДА ВЫРАЗИТЬ(ТоварыНаСкладах.Регистратор КАК Документ.ПоступлениеТоваровУслуг).Дата
|		КОГДА ТоварыНаСкладах.Регистратор ССЫЛКА Документ.РеализацияТоваровУслуг
|			ТОГДА ВЫРАЗИТЬ(ТоварыНаСкладах.Регистратор КАК Документ.РеализацияТоваровУслуг).Дата
|	КОНЕЦ КАК ДатаДокумента
|ИЗ
|	РегистрНакопления.ТоварыНаСкладах КАК ТоварыНаСкладах"

ПРЕДСТАВЛЕНИЕ вместо .Наименование

Когда нужно только текстовое представление ссылки, ПРЕДСТАВЛЕНИЕ() избегает лишнего соединения.

// Плохо: создает дополнительный подзапрос к Справочник.Склады
"ВЫБРАТЬ
|	ТоварыНаСкладах.Склад.Наименование
|ИЗ
|	РегистрНакопления.ТоварыНаСкладах КАК ТоварыНаСкладах"

// Хорошо: без лишнего соединения
"ВЫБРАТЬ
|	ПРЕДСТАВЛЕНИЕ(ТоварыНаСкладах.Склад) КАК СкладПредставление
|ИЗ
|	РегистрНакопления.ТоварыНаСкладах КАК ТоварыНаСкладах"

Соединение с подзапросом - временные таблицы

Read the full file on GitHub · 242 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 242 lines · 0 tokens per session scan A c77581959c2b

Subscribe to this mod's changes

query-optimization-tips is a cursor rule published in the GitHub repository Desko77/cursor-1c-skills (53 stars, last pushed 5d ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 2,618 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other cursor rules, from other repositories

121-java-unit-testing

Java Unit testing guidelines.

alkoleft/platform-context-exporter · 0 tokens

architectural-planning

Cursor rule "architectural-planning" from alkoleft/platform-context-exporter, covering architectural planning for level 4 tasks, 🔍 architectural planning overview, 📋 architectural planning principles, 📋 architectural requirements analysis and functional requirements analysis.

alkoleft/platform-context-exporter · 6,209 tokens

reflection-comprehensive

Cursor rule "reflection-comprehensive" from alkoleft/platform-context-exporter, covering comprehensive reflection for level 4 tasks, 🔍 comprehensive reflection overview, 📋 reflection template structure, 1. system overview and system overview.

alkoleft/platform-context-exporter · 6,108 tokens

workflow-level4

Cursor rule "workflow-level4" from alkoleft/platform-context-exporter, covering comprehensive workflow for level 4 tasks, 🔍 level 4 workflow overview, 🔄 level transition handling, 📋 workflow phases and phase 1: initialization.

alkoleft/platform-context-exporter · 3,729 tokens

creative-phase-uiux

UI/UX Design Guidelines and Process for the Creative Phase.

alkoleft/platform-context-exporter · 0 tokens

optimization-integration

Cursor rule "optimization-integration" from alkoleft/platform-context-exporter, covering memory bank optimization integration, 🔄 optimization integration flow, 📋 optimization component registry, 🔄 optimization initialization sequence and 🔍 optimization configuration.

alkoleft/platform-context-exporter · 2,319 tokens