Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
SELECT * FROM `ms_msu`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
Sort by key:
Full texts id spz_sid snon_id parent_snon_id
Сюда пишем snon_id комплекта при комплектации 		kont dataop ndok
Номер документа 		tdok
Время документа 		pnz svop_id svop_pu sabor_kid sabor_rid spz_cid sprp_id mz_id zak spz sppr_id
op_sppr.id 		kol ost reserve
Зарезервировано 		cena sgo_id kurs
Курс валюты цены закупки 		cenao sgo_oid okurs
Курс валюты цены продажи 		cenad
Цена продажи без учета скидки 		original_price
Исходная стоимость товара 		discount_item
Скидка на позицию 		sopr_id sopr dsopr sob_id nobj mlskod seizm_id msus_id ppv dtz timz is_del susers_id
ID пользователя 		msut_id
Идентификатор транзакции (MS_MSUT:ID) 		parent_msut_id
Идентификатор связанной транзакции (для возвратов) 		stnds
Ставка НДС, по умолчанию из номенклатуры 		sumnds
НДС за единицу товара 		tax_type
Тип расчета итоговой суммы с НДС 		device_id
Идентификатор устройства с которого была совершена… 		spd_id
Идентификатор устройства с которого была совершена… 		marking_body
Данные по маркировке товара 		marking_raw
Полный код маркировки товара 		marking_raw_check
Результат проверки кода маркировки товара 		marking_tag marking_crpt_validation_request_id
Доп. параметр для разрешительного режима при ОКасс… 		marking_crpt_validation_request_timestamp
Доп. параметр для разрешительного режима при ОКасс… 		fiscal_spd_id
id устройства для фискализации 		quantity_real_sale
Проданное (фактическое) количество товара, как пра… 		product_name
Текущее название продукта 		modifiers
Модификаторы на момент продажи 		agent_tin
ИНН поставщика 		agent_phone
Телефон поставщика 		agent_name
Название организации поставщика 		agent_id
Идентификатор поставщика в нашей системе as_sabor.… 		agent_sign
признак поставщика (4,5,6) 		marking_check_result
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 1
 		1 1 2 0 247af0e6e03113ae30b177ccad31020d 2024-08-08 W23129705 18:08:25 1 1 1 4 1 0 0 0 1 123 123 0 22 1 1 444 1 1 444 0 0 0 NULL 0 101 1 0 2024-08-08 18:08:25 0 1 1 0 0 0 1 0 0 0 0 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 2
 		2 1 2 0 90840fc7adae37d0c27ad7d15fa25de0 2024-08-08 2024.0808/0001 18:07:57 1 90 1 6 1 0 0 1 1 1 1 0 22 1 1 444 1 1 444 0 0 0 NULL 0 101 2 0 2024-08-08 18:07:57 0 1 2 0 -1 0 1 0 0 0 0 Тестовый Товар NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 3
 		3 1 2 0 90840fc7adae37d0c27ad7d15fa25de0 2024-08-08 3 18:07:57 2 89 2 6 1 0 0 1 1 1 0 0 22 1 1 444 1 1 444 0 0 0 NULL 0 101 2 0 2024-08-08 18:07:57 0 1 3 0 -1 0 1 0 0 0 0 Тестовый Товар NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 4
 		4 1 3 0 3529f756a380d8737b6f15673bf96d0e 2024-08-12 W23452944 11:55:44 1 1 1 4 1 0 0 0 1 133 133 0 0 1 1 3200 1 1 3200 0 0 0 NULL 0 101 3 0 2024-08-12 11:55:44 0 1 4 0 0 0 1 0 0 0 0 [{"id":10,"name":"s","parent_id":11,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 5
 		5 1 3 0 556b2bddf59efdc8a56900ee9317cac1 2024-08-12 W23452944 11:55:44 1 1 1 4 1 0 0 0 1 333 333 0 0 1 1 3250 1 1 3250 0 0 0 NULL 0 101 4 0 2024-08-12 11:55:44 0 1 4 0 0 0 1 0 0 0 0 [{"id":10,"name":"m","parent_id":12,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 6
 		6 2 3 0 b6c14ef5f1fb40656998b9b5c0ed9288 2024-08-12 W23452944 11:55:44 1 1 1 4 1 0 0 0 1 122 122 0 0 1 1 3200 1 1 3200 0 0 0 NULL 0 101 5 0 2024-08-12 11:55:44 0 1 4 0 0 0 1 0 0 0 0 [{"id":10,"name":"s","parent_id":11,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 7
 		7 2 3 0 d5d23b3502fde34ed5767bc8dd29c9bb 2024-08-12 W23452944 11:55:44 1 1 1 4 1 0 0 0 1 223 223 0 0 1 1 3250 1 1 3250 0 0 0 NULL 0 101 6 0 2024-08-12 11:55:44 0 1 4 0 0 0 1 0 0 0 0 [{"id":10,"name":"m","parent_id":12,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 8
 		8 1 3 0 556b2bddf59efdc8a56900ee9317cac1 2024-08-12 W23453007 11:56:47 2 3 2 6 1 0 0 0 1 1 332 0 0 1 1 3250 1 1 5000 0 0 0 NULL 0 101 4 0 2024-08-12 11:56:47 0 1 5 0 -1 0 1 1 0 0 0 [{"id":12,"name":"m","parent_id":10,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 9
 		9 1 3 0 3529f756a380d8737b6f15673bf96d0e 2024-08-12 W23456612 12:56:52 2 3 2 6 1 0 0 0 1 1 132 0 0 1 1 3025 1 1 3200 0 175 0 NULL 0 101 3 0 2024-08-12 12:56:52 0 1 6 0 -1 0 1 1 0 0 0 [{"id":11,"name":"s","parent_id":10,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 10
 		10 1 3 0 556b2bddf59efdc8a56900ee9317cac1 2024-08-12 7 13:22:15 3 3 2 3 1 0 0 0 1 1 331 0 0 1 1 3250 1 1 5000 0 0 0 NULL 0 101 4 0 2024-08-12 13:22:15 0 1 7 0 -1 0 1 0 0 0 0 [{"id":12,"name":"m","parent_id":10,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 11
 		11 1 3 0 556b2bddf59efdc8a56900ee9317cac1 2024-08-12 8 13:22:55 4 3 2 3 1 0 0 0 1 1 330 0 0 1 1 3250 1 1 5000 0 0 0 NULL 0 101 4 0 2024-08-12 13:22:55 0 1 8 0 -1 0 1 0 0 0 0 [{"id":12,"name":"m","parent_id":10,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 12
 		12 1 4 0 3b3a5b317a2e2bde7c5aa7ddcdf604ea 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 240 1 1 240 0 0 0 NULL 0 101 7 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"s","parent_id":11,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 13
 		13 1 4 0 d6cdc76e78739653eb4b5200db760d35 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 244 1 1 244 0 0 0 NULL 0 101 8 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"s","parent_id":11,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 14
 		14 1 4 0 7b192defb3199ed6d6fc73f4329a4ed0 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 244 1 1 244 0 0 0 NULL 0 101 9 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"m","parent_id":12,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 15
 		15 1 4 0 d10907ef300ca03292260afa2dbae1a3 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 240 1 1 240 0 0 0 NULL 0 101 10 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"m","parent_id":12,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 16
 		16 2 4 0 a757faeeaa35b0761f51a213aa522d6f 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 240 1 1 240 0 0 0 NULL 0 101 11 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"s","parent_id":11,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 17
 		17 2 4 0 51788803fa50da2e93ec29e4db2d2a4f 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 244 1 1 244 0 0 0 NULL 0 101 12 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"s","parent_id":11,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 18
 		18 2 4 0 61e10c39a85a6649cce8f4d69d53b24e 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 244 1 1 244 0 0 0 NULL 0 101 13 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"m","parent_id":12,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 19
 		19 2 4 0 194f059cc4f9adb6b23f6e0a5adbc1cc 2024-08-12 W23458799 13:33:19 1 1 1 4 1 0 0 0 1 12 12 0 0 1 1 240 1 1 240 0 0 0 NULL 0 101 14 0 2024-08-12 13:33:19 0 1 9 0 0 0 1 0 0 0 0 [{"id":10,"name":"m","parent_id":12,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 20
 		20 1 3 0 3529f756a380d8737b6f15673bf96d0e 2024-08-12 W23459571 13:46:11 3 3 2 6 1 0 0 0 1 1 131 0 0 1 1 3025 1 1 3200 0 175 0 NULL 0 101 3 0 2024-08-12 13:46:11 0 1 10 0 -1 0 1 1 0 0 0 [{"id":11,"name":"s","parent_id":10,"parent_name":... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 21
 		21 1 5 0 36baec65088b02050c5b72ffb4d3620f 2024-08-12 W23459983 13:53:03 1 1 1 4 1 0 0 0 1 321 321 0 0 1 1 300 1 1 259 0 0 0 NULL 0 101 15 0 2024-08-12 13:53:03 0 1 11 0 20 0 1 0 0 0 0 [{"id":13,"name":"blue","parent_id":14,"parent_nam... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 22
 		22 1 5 0 171c44adebffa860d1937266a3e94851 2024-08-12 W23459983 13:53:03 1 1 1 4 1 0 0 0 1 123 123 0 0 1 1 299 1 1 250 0 0 0 NULL 0 101 16 0 2024-08-12 13:53:03 0 1 11 0 20 0 1 0 0 0 0 [{"id":13,"name":"green","parent_id":15,"parent_na... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 23
 		23 2 5 0 2a124faa5d515a8544ea44819f940519 2024-08-12 W23459983 13:53:03 1 1 1 4 1 0 0 0 1 32 32 0 0 1 1 300 1 1 259 0 0 0 NULL 0 101 17 0 2024-08-12 13:53:03 0 1 11 0 20 0 1 0 0 0 0 [{"id":13,"name":"blue","parent_id":14,"parent_nam... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 24
 		24 2 5 0 6663d8c658b4ec089c754568b732feaa 2024-08-12 W23459983 13:53:03 1 1 1 4 1 0 0 0 1 32 32 0 0 1 1 299 1 1 250 0 0 0 NULL 0 101 18 0 2024-08-12 13:53:03 0 1 11 0 20 0 1 0 0 0 0 [{"id":13,"name":"green","parent_id":15,"parent_na... NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM ms_msu WHERE `ms_msu`.`id` = 25
 		25 1 4 0 d10907ef300ca03292260afa2dbae1a3 2024-08-12 W23460013 13:53:33 2 3 2 6 1 0 0 0 1 1 11 0 0 1 1 240 1 1 240 0 0 0 NULL 0 101 10 0 2024-08-12 13:53:33 0 1 12 0 -1 0 1 1 0 0 0 [{"id":12,"name":"m","parent_id":10,"parent_name":... NULL NULL NULL NULL NULL NULL
With selected: With selected:
|
|
|
|
Filter rows:
Sort by key:
Query results operations Print Print Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view