-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.html
More file actions
380 lines (348 loc) · 48.1 KB
/
index.html
File metadata and controls
380 lines (348 loc) · 48.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
<meta http-equiv='X-UA-Compatible' content='IE=edge'>
<title>qqdb</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
<link rel="icon" href="favicon.webp">
<link rel="stylesheet" data-name="vs/editor/editor.main"
href="https://cdnjs.cloudflare.com/ajax/libs/monaco-editor/0.26.1/min/vs/editor/editor.main.min.css">
<meta name='viewport' content='width=device-width, initial-scale=1'>
<style>
.alias {
color: blue;
font-weight: bold;
}
.operator {
color: red;
}
table,
th,
td {
border: 1px solid;
padding: 5px;
}
</style>
<script src='./bundle.js'></script>
</head>
<body>
<script>var require = { paths: { 'vs': 'https://cdnjs.cloudflare.com/ajax/libs/monaco-editor/0.26.1/min/vs' } }</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/monaco-editor/0.26.1/min/vs/loader.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/monaco-editor/0.26.1/min/vs/editor/editor.main.nls.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/monaco-editor/0.26.1/min/vs/editor/editor.main.js"></script>
<div class="container">
<div class="mt-5 row justify-content-center">
<div style="display: flex;justify-content: center;">
<pre>
feature:
SELECT: col alias
FROM: subquery, alias
WHERE : <, >, =, <>, AND, OR, NESTED (1 = 1 AND (1 = 1)), IN(ids, subquery), NOT IN
JOIN, LEFT JOIN: subquery, hash join, nested exp in ON - like a where
ORDER BY: DESC, ASC (multiple cols)
GROUP BY: multiple cols + function(max, min, avg, string_agg) + HAVING (nested exp like a where + COUNT(*))
LIMIT, OFFSET
PERFOMANCE aka indexes: hash index(first exp(=) in where), bst index(first exp(<,>) in where).
sqlite(eav) output in console
</pre>
</div>
<hr>
<div class="col-2">
<select onchange="change(event)">
<option value="1">diaries</option>
<option value="2">EAV</option>
</select>
</div>
</div>
<div class="row mt-5">
<div class="col-6">
<div style="display: none; position: absolute;" class="spinner-border" role="status">
</div>
<img style="width:30px; cursor: pointer;margin-left: auto; display: flex; margin-bottom: 10px;"
onclick="run()" src="exec.webp">
<div id="sql" style="height:400px;border:1px solid black;"></div>
</div>
<div class="col-6">
<table class="main"></table>
</div>
</div>
<div class="row error mt-5 d-flex justify-content-center">
</div>
</div>
<div class="row">
<div class="d-flex flex-column justify-content-center align-items-center ">
<div class="d-flex flex-column">
<p><b>qqdb: </b><span class="exec_time"></span></p>
<p style="display: none;" class="sqlite"><b>php elequent sqlite <a href="./db">(download)</a>: </b><span
class="exec_time_sqlite">
- </span></p>
</div>
<table class="res">
<th>
</th>
</table>
</div>
</div>
</body>
<script>
var num = {};
var currAlias = [];
let sql = () => {
try {
return window?.monaco?.getValue() ?? '';
}
catch (e) {
return `SELECT *
FROM DIARY D
JOIN (SELECT P.DIARY_ID, MAX(P.ID) AS PID
FROM POSTS P
JOIN USERS U ON P.USER_ID = U.ID
GROUP BY P.DIARY_ID) PP ON D.ID = PP.DIARY_ID
JOIN USERS U ON D.USER_ID = U.ID
ORDER BY PP.PID DESC
`;
}
}
let main = document.querySelector('.main');
let diary = {
"POSTS": {
col: ['ID', 'MSG', 'USER_ID', 'DIARY_ID'],
data: [
[1, "Мой блог о php", 1, 1],
[2, "Как дела?", 2, 1],
[3, "Мой уютный блог обо всем на свете", 2, 2],
[4, "Сегодня хорошая погода", 2, 2],
],
},
"USERS": {
col: ["ID", "LOGIN", "STATUS"],
data: [
[1, "admin", 1],
[2, "user", 3],
]
},
"DIARY": {
col: ["ID", "NAME", "USER_ID"],
data: [
[1, "php и рефлексия", 2],
[2, "уютный бложик", 1],
[3, "left join уютный бложик", 10],
]
}
};
let eav = {
"IBLOCKS": {
col: ['ID', 'NAME', 'PARENT_ID', 'LEFT', 'RIGHT'],
data: [
[1, 'Каталог', 0],
[2, 'Обувь', 1],
[3, 'Тапочки', 2],
],
},
"IBLOCK_ELEMENTS": {
col: ['ID', 'NAME', 'IBLOCK_ID'],
data: [
[1, 'Домашние Тапочки Розовый Рай', 3],
[2, 'Домашние Тапочки Любимый Спорт', 3],
[3, 'test group by', 3],
],
},
"IBLOCK_PROPERTIES": {
col: ['ID', 'IS_NUMBER', 'IS_MULTY', 'NAME', 'IBLOCK_ID'],
data: [
[1, 0, 0, 'Артикул', 3],
[2, 0, 0, 'Материал', 3],
],
},
"IBLOCK_PROP_VALUES": {
col: ['ID', 'VALUE', 'VALUE_NUMBER', 'PROP_ID', 'EL_ID'],
data: [
[1, '174-15-xx', 0, 1, 1],
[2, '174-16-xx', 0, 1, 2],
[3, 'резина/кожа', 0, 2, 1],
[4, 'текстиль/полимер', 0, 2, 2],
[5, '174-15-xx', 0, 1, 3],
[6, '174-15-xx', 0, 2, 3],
],
},
};
eav['IBLOCK_PROP_VALUES'].data = JSON.parse(`[[1,"174-19-xx",null,1,1],[2,"\u0424\u0440\u0430\u043d\u0446\u0438\u044f "\u0410\u0439\u043b\u0438"",null,2,1],[3,"\u043f\u043e\u043b\u0438\u0443\u0440\u0435\u0442\u0430\u043d ",null,3,1],[4,"\/upload\/iblock\/eec\/k5104wrv3xoqct98uhv238tfvd0x5rho.jpg",null,4,1],[5,"\/upload\/iblock\/053\/5tyhm02v336qp0fm84bq089na1d1hyfa.jpg",null,5,1],[6,"\/upload\/iblock\/d4d\/u2xatv69oadnuc9p0fy8zhxasirtnmzd.jpg",null,5,1],[7,"\/upload\/iblock\/cd7\/vtnv79a1i60vpe2ym3x2uh0zeupl1pht.jpg",null,5,1],[8,"\/upload\/iblock\/eec\/k5104wrv3xoqct98uhv238tfvd0x5rho.jpg",null,5,1],[9,"\/upload\/iblock\/3c5\/byzvxxnf41yzz9kh8jokmzb0o7ryv4pr.jpg",null,5,1],[10,"174-15-xx",null,6,2],[11,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,7,2],[12,"\u0440\u0435\u0437\u0438\u043d\u0430\/\u043a\u043e\u0436\u0430",null,8,2],[13,"\/upload\/iblock\/b7d\/wzu48nxpm16l6cycvszws8su0l7htrvg.jpg",null,9,2],[14,"\/upload\/iblock\/fe0\/7djkd5w7lhk2kntdrtfma34xh07wvaba.jpg",null,10,2],[15,"\/upload\/iblock\/4d2\/xeiz1c8k4g5kxdvtplbp1cqdcqcja82s.jpg",null,10,2],[16,"\/upload\/iblock\/722\/2m0z084y5e0r4u3fxnm1k86amy6vsgyi.jpg",null,10,2],[17,"\/upload\/iblock\/dae\/r2eokwfgyubh1olasax6p3q974c2pz2a.jpg",null,10,2],[18,"\/upload\/iblock\/b7d\/wzu48nxpm16l6cycvszws8su0l7htrvg.jpg",null,10,2],[19,"174-16-xx",null,6,3],[20,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,7,3],[21,"\u0442\u0435\u043a\u0441\u0442\u0438\u043b\u044c\/\u043f\u043e\u043b\u0438\u043c\u0435\u0440",null,8,3],[22,"\/upload\/iblock\/ba4\/a5n6t9ljvmkbwcwh2jqfjewudwg6hpr9.jpg",null,9,3],[23,"\/upload\/iblock\/2d7\/ye142sote98ta586c4lv2mupfyiazump.jpg",null,10,3],[24,"\/upload\/iblock\/ba4\/a5n6t9ljvmkbwcwh2jqfjewudwg6hpr9.jpg",null,10,3],[25,"\/upload\/iblock\/ffc\/vevj8tr6ithuubhyiz542vzzikza4qkf.jpg",null,10,3],[26,"\/upload\/iblock\/30a\/wotch7ujqwqru5m23az8x95ekfpkypq3.jpg",null,10,3],[27,"\/upload\/iblock\/477\/5et2t2j2tsfofzg03h65i36g8kd9ebo3.jpg",null,10,3],[28,"174-18-xx",null,11,4],[29,"\u041a\u0438\u0442\u0430\u0439 "\u0413\u0443\u043d \u0414\u0436\u043e\u0439 \u041b\u0438"",null,12,4],[30,"\u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u044b",null,13,4],[31,"\/upload\/iblock\/92f\/mxsyoj7f673mwunttni26nopxrbiwgrr.jpg",null,14,4],[32,"\/upload\/iblock\/a34\/eg1epz727r4l5p04sitljpkflbqcfwk5.jpg",null,15,4],[33,"\/upload\/iblock\/02a\/1eu1y79fjcuf7vsh2g51icq0nubj7nzg.jpg",null,15,4],[34,"\/upload\/iblock\/d4a\/5ad6c8ko5cl835ara5p3v4ap91j8jsj4.jpg",null,15,4],[35,"\/upload\/iblock\/412\/yp955c80detz9mdpx3h87fn0hmqik15w.jpg",null,15,4],[36,"\/upload\/iblock\/92f\/mxsyoj7f673mwunttni26nopxrbiwgrr.jpg",null,15,4],[37,"174-20-xx",null,11,5],[38,"\u041a\u0438\u0442\u0430\u0439 "\u0413\u0443\u043d \u0414\u0436\u043e\u0439 \u041b\u0438"",null,12,5],[39,"\u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u044b",null,13,5],[40,"\/upload\/iblock\/e9e\/nhtdztsch5zumvk210l2l1ik0xpauq6s.jpg",null,14,5],[41,"\/upload\/iblock\/ea0\/4kseo5fr9gyf92zblrm9yc2zzw5k3fc1.jpg",null,15,5],[42,"\/upload\/iblock\/400\/3az9kxlo8fqviuhisvid2oi7y2xolmhb.jpg",null,15,5],[43,"\/upload\/iblock\/be0\/a2swwhlqtpk7k0u38djua351gjzrj638.jpg",null,15,5],[44,"\/upload\/iblock\/e9e\/nhtdztsch5zumvk210l2l1ik0xpauq6s.jpg",null,15,5],[45,"\/upload\/iblock\/008\/2stko2ql6rpm37cq69i8e335wilbg8jt.jpg",null,15,5],[46,"174-21-xx",null,11,6],[47,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,12,6],[48,"\u043a\u043e\u0436\u0430",null,13,6],[49,"\/upload\/iblock\/828\/rn6z2w4ecagc387ib7f5d7uoaf2ck5ni.jpg",null,14,6],[50,"174-17-xx",null,16,7],[51,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,17,7],[52,"\u043a\u043e\u0436\u0430",null,18,7],[53,"\/upload\/iblock\/ab7\/7xbuzetwaivpcorjmsfxiu3o4k7doz9z.jpg",null,19,7],[54,"\/upload\/iblock\/f13\/02229pup73wqs9iaf05q4g81pkzpvxml.jpg",null,20,7],[55,"\/upload\/iblock\/f49\/8w9hkqv95yb35gomqcglj1drp6axar6w.jpg",null,20,7],[56,"\/upload\/iblock\/5c2\/1aytzt2jcei5sr14fao78jteyndlcpxi.jpg",null,20,7],[57,"\/upload\/iblock\/ab7\/7xbuzetwaivpcorjmsfxiu3o4k7doz9z.jpg",null,20,7],[58,"\/upload\/iblock\/bba\/rnj8r47gc4k26nw7474ywvyclws9596e.jpg",null,20,7],[59,"company1",null,21,8],[60,"company3",null,21,8],[61,"brand2",null,21,8],[62,"brand1",null,21,8],[63,"brand3",null,21,8],[64,"144-12-xx",null,22,8],[65,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u0434\u043d\u0438\u0446\u0430"",null,23,8],[66,"\u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u044b",null,24,8],[67,"\/upload\/iblock\/f2d\/7emfgxuw65wr84ows9dtuo1a9lrweqju.jpg",null,25,8],[68,"\/upload\/iblock\/7ff\/h5jacqblt5pjbu6mb3nxwdn9uf10f1bt.jpg",null,26,8],[69,"\/upload\/iblock\/e58\/c7sgj65zf864vs89mj040liglphr3l8g.jpg",null,26,8],[70,"\/upload\/iblock\/ec0\/x6426aw4gd1fi93f3g2p3ym3u9x4ddk3.jpg",null,26,8],[71,"\/upload\/iblock\/f2d\/7emfgxuw65wr84ows9dtuo1a9lrweqju.jpg",null,26,8],[72,"\/upload\/iblock\/fcf\/tj2q14s76dw3e9s7cc88h0r0zf6n4q8n.jpg",null,26,8],[73,"company1",null,21,9],[74,"company3",null,21,9],[75,"brand2",null,21,9],[76,"brand1",null,21,9],[77,"brand3",null,21,9],[78,"144-13-xx",null,22,9],[79,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u0434\u043d\u0438\u0446\u0430"",null,23,9],[80,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,24,9],[81,"\/upload\/iblock\/d8e\/qx4mlhk7szpobhyh601u35h40rmneeeb.jpg",null,25,9],[82,"\/upload\/iblock\/bf3\/650mgjqdcsaei8ubxm55x6j7my66piqk.jpg",null,26,9],[83,"\/upload\/iblock\/d8e\/qx4mlhk7szpobhyh601u35h40rmneeeb.jpg",null,26,9],[84,"\/upload\/iblock\/3f2\/sk70mo2zpyzle2ypum70733vd03u1097.jpg",null,26,9],[85,"\/upload\/iblock\/901\/mllxnx8mjm6x4t9xh8fvp3qypqw5op8a.jpg",null,26,9],[86,"\/upload\/iblock\/cc2\/yhsqo5uoknsk1czsv83j63xxvdss7crj.jpg",null,26,9],[87,"company1",null,21,10],[88,"company3",null,21,10],[89,"brand2",null,21,10],[90,"brand1",null,21,10],[91,"brand3",null,21,10],[92,"144-14-xx",null,22,10],[93,"\/upload\/iblock\/7d0\/iq1dzxqrhf4w34h7jz3pu45jmyzyhtvj.jpg",null,25,10],[94,"\/upload\/iblock\/0ab\/qz1fbclemwyfwiqgirj3a36n2tws7vhv.jpg",null,26,10],[95,"\/upload\/iblock\/e5f\/5g3f3976gtvts7u5ojtqtvnqc8f4sw3g.jpg",null,26,10],[96,"\/upload\/iblock\/873\/bc8j86i4305e7plchwc1qy6moniyz7tu.jpg",null,26,10],[97,"\/upload\/iblock\/7d0\/iq1dzxqrhf4w34h7jz3pu45jmyzyhtvj.jpg",null,26,10],[98,"\/upload\/iblock\/987\/w25t49wq2eqpuuazopusgwcgds2a0g10.jpg",null,26,10],[99,"company1",null,21,11],[100,"company3",null,21,11],[101,"brand2",null,21,11],[102,"brand1",null,21,11],[103,"brand3",null,21,11],[104,"144-15-xx",null,22,11],[105,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u0434\u043d\u0438\u0446\u0430"",null,23,11],[106,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,24,11],[107,"\/upload\/iblock\/9bc\/hg7qbztjeblei5kpjjhp9z89p73gpqgh.jpg",null,25,11],[108,"\/upload\/iblock\/4ce\/bvhxxfb2fg0qg0yc8x2hhkh8hoqqdysz.jpg",null,26,11],[109,"\/upload\/iblock\/ea5\/7jctdwj40w66vwzor3fw4n6ugmu2zxuz.jpg",null,26,11],[110,"\/upload\/iblock\/9bc\/hg7qbztjeblei5kpjjhp9z89p73gpqgh.jpg",null,26,11],[111,"\/upload\/iblock\/bb3\/4ly3h7oiap1n3ruribkczcrtd4jjwcy7.jpg",null,26,11],[112,"\/upload\/iblock\/32d\/333ek7qeg5v0yfpnc4itzt2glm0tbiqc.jpg",null,26,11],[113,"\/upload\/iblock\/28f\/evrrhtf273j70m5v0imrds2u8r99ezxp.jpg",null,26,11],[114,"company2",null,27,12],[115,"company3",null,27,12],[116,"brand2",null,27,12],[117,"brand1",null,27,12],[118,"brand3",null,27,12],[119,"177-77-\u0445\u0445",null,28,12],[120,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,29,12],[121,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,30,12],[122,"\/upload\/iblock\/044\/twmsbml8ovgnhjpsbom9e80o93w2ckx8.jpg",null,31,12],[123,"company2",null,27,13],[124,"company3",null,27,13],[125,"brand2",null,27,13],[126,"brand1",null,27,13],[127,"brand3",null,27,13],[128,"177-78-\u0445\u0445",null,28,13],[129,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,29,13],[130,"\u0448\u0435\u043b\u043a",null,30,13],[131,"\/upload\/iblock\/4e6\/5a31akp267grl0tq71ch0juffyc3eimk.jpg",null,31,13],[132,"company2",null,27,14],[133,"company3",null,27,14],[134,"brand2",null,27,14],[135,"brand1",null,27,14],[136,"brand3",null,27,14],[137,"177-79-\u0445\u0445",null,28,14],[138,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,29,14],[139,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,30,14],[140,"\/upload\/iblock\/3f6\/f5pq9x5fwh6wy775vrbm8lzwew83535f.jpg",null,31,14],[141,"company1",null,32,15],[142,"company3",null,32,15],[143,"brand2",null,32,15],[144,"brand1",null,32,15],[145,"brand3",null,32,15],[146,"235-77-\u0445\u0445",null,33,15],[147,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,34,15],[148,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,35,15],[149,"\/upload\/iblock\/ddd\/fh2htpvg1a7nsui6np3ubuakkrlyuiwh.jpg",null,36,15],[150,"\/upload\/iblock\/273\/y50qkt7xw28jwlu6wxnyd133jen5oejp.jpg",null,37,15],[151,"\/upload\/iblock\/ef8\/cfqsp4255hxnrcezotbgcfeioifuikjq.jpg",null,37,15],[152,"\/upload\/iblock\/0c7\/xp2rayshgghn6474f7dysja1qqgjyl1n.jpg",null,37,15],[153,"\/upload\/iblock\/f34\/fmce2kssl4pybt15ezezecdt5y3a9x0o.jpg",null,37,15],[154,"\/upload\/iblock\/978\/1b5ym10q502m775xjj72gfvitqfak0ob.jpg",null,37,15],[155,"\/upload\/iblock\/ddd\/fh2htpvg1a7nsui6np3ubuakkrlyuiwh.jpg",null,37,15],[156,"company3",null,32,16],[157,"company4",null,32,16],[158,"brand2",null,32,16],[159,"brand1",null,32,16],[160,"brand3",null,32,16],[161,"235-78-\u0445\u0445",null,33,16],[162,"\u0420\u043e\u0441\u0441\u0438\u044f "\u0418\u043d\u0442\u0438\u043c \u0432 \u0421\u0435\u043c\u044c\u0435"",null,34,16],[163,"\u0445\u043b\u043e\u043f\u043e\u043a",null,35,16],[164,"\/upload\/iblock\/ece\/pm8s9vkblhq0iszt403ip5892veim7v6.jpg",null,36,16],[165,"\/upload\/iblock\/0d3\/nlookeyoszstm6kwz2vuo0wj54nqsyk7.jpg",null,37,16],[166,"\/upload\/iblock\/4c6\/qf2o43retzcgg81xp30hfpgqqvkpi165.jpg",null,37,16],[167,"\/upload\/iblock\/ece\/pm8s9vkblhq0iszt403ip5892veim7v6.jpg",null,37,16],[168,"\/upload\/iblock\/219\/00cryuv9t62ouewxyu8w7arswi4woqdd.jpg",null,37,16],[169,"\/upload\/iblock\/860\/hy314bu3ptwdmdnwsh2ggsrmcdc7bcnk.jpg",null,37,16],[170,"company3",null,32,17],[171,"company4",null,32,17],[172,"brand2",null,32,17],[173,"brand1",null,32,17],[174,"brand3",null,32,17],[175,"235-79-\u0445\u0445",null,33,17],[176,"\u0420\u043e\u0441\u0441\u0438\u044f "\u0418\u043d\u0442\u0438\u043c \u0432 \u0421\u0435\u043c\u044c\u0435"",null,34,17],[177,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,35,17],[178,"\/upload\/iblock\/f9f\/2el7esg30jlstbx63n0b30f3j49syz2i.jpg",null,36,17],[179,"company3",null,32,18],[180,"company4",null,32,18],[181,"brand2",null,32,18],[182,"brand1",null,32,18],[183,"brand3",null,32,18],[184,"235-80-xx",null,33,18],[185,"\u0420\u043e\u0441\u0441\u0438\u044f "\u0418\u043d\u0442\u0438\u043c \u0432 \u0421\u0435\u043c\u044c\u0435"",null,34,18],[186,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,35,18],[187,"\/upload\/iblock\/481\/kpnev7xg6i22kgsswy6f4zgolp72k79i.jpg",null,36,18],[188,"\/upload\/iblock\/44e\/ttvivhs4cob4j00crzu453k2uu11imlw.jpg",null,37,18],[189,"\/upload\/iblock\/491\/fp2h34v3vgxbih7bzfcrpkywgudvuo3s.jpg",null,37,18],[190,"\/upload\/iblock\/481\/kpnev7xg6i22kgsswy6f4zgolp72k79i.jpg",null,37,18],[191,"\/upload\/iblock\/a89\/7bywnzt3ud66emir0ybdebru63g0lrr1.jpg",null,37,18],[192,"\/upload\/iblock\/b69\/wc7bdnii5s5si3dm58s27skfw2knk3oc.jpg",null,37,18],[193,"company3",null,32,19],[194,"company4",null,32,19],[195,"brand2",null,32,19],[196,"brand1",null,32,19],[197,"brand3",null,32,19],[198,"235-81-xx",null,33,19],[199,"\u0420\u043e\u0441\u0441\u0438\u044f "\u0418\u043d\u0442\u0438\u043c \u0432 \u0421\u0435\u043c\u044c\u0435"",null,34,19],[200,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,35,19],[201,"\/upload\/iblock\/cf4\/ccw6egv16n5zla2os46dx1g6y9ovklfd.jpg",null,36,19],[202,"\/upload\/iblock\/b24\/nnuets36a7x38nm5x0vvoww4aeda7ocz.jpg",null,37,19],[203,"\/upload\/iblock\/cf4\/ccw6egv16n5zla2os46dx1g6y9ovklfd.jpg",null,37,19],[204,"\/upload\/iblock\/5a1\/9fl5tolmb23vdc1uz5pj2m347o02hdzl.jpg",null,37,19],[205,"\/upload\/iblock\/f05\/4ju4plrzzka14y0o5s2f1dfpx90ak31s.jpg",null,37,19],[206,"\/upload\/iblock\/1a4\/nwvnpatf46uzzsl4489pnaq7nrvh7o8d.jpg",null,37,19],[207,"\/upload\/iblock\/9ff\/k7x36jfep767jxjc0fy88nal1df6nbeq.jpg",null,37,19],[208,"company3",null,32,20],[209,"company4",null,32,20],[210,"brand2",null,32,20],[211,"brand1",null,32,20],[212,"brand3",null,32,20],[213,"235-82-xx",null,33,20],[214,"\u0421\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u043d\u044b\u0435 \u0428\u0442\u0430\u0442\u044b "USAGREY"",null,34,20],[215,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,35,20],[216,"\/upload\/iblock\/0b2\/uwckw95mu6uhd03a0daceymn0mzgecii.jpg",null,36,20],[217,"\/upload\/iblock\/7ac\/yr7awyi0btx2vy1x2zj2mpdifw8ytcmr.jpg",null,37,20],[218,"\/upload\/iblock\/0b2\/uwckw95mu6uhd03a0daceymn0mzgecii.jpg",null,37,20],[219,"\/upload\/iblock\/d76\/by0p0holh65da6zct2grkrfxwgio39ia.jpg",null,37,20],[220,"\/upload\/iblock\/025\/yub0lz1ze4gdjv0g80kj091iwu99syux.jpg",null,37,20],[221,"\/upload\/iblock\/da8\/rxodqb0lnomcrbfzv8myehfu0tdn70b7.jpg",null,37,20],[222,"company3",null,32,21],[223,"company4",null,32,21],[224,"brand2",null,32,21],[225,"brand1",null,32,21],[226,"brand3",null,32,21],[227,"235-83-xx",null,33,21],[228,"\u0420\u043e\u0441\u0441\u0438\u044f "\u0418\u043d\u0442\u0438\u043c \u0432 \u0421\u0435\u043c\u044c\u0435"",null,34,21],[229,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,35,21],[230,"\/upload\/iblock\/ff4\/dgcg6cntjrtrityk08n3gkvd4txm0631.jpg",null,36,21],[231,"\/upload\/iblock\/5ce\/l9p132p43qzj86lfjvuzsq6kd85q9cc3.jpg",null,37,21],[232,"\/upload\/iblock\/9cf\/lixedd0z48dfdizyu2z2x9vzib7hy8v1.jpg",null,37,21],[233,"\/upload\/iblock\/9fd\/7f09ozgetp3ro7pqzuhtqvlkrl6582no.jpg",null,37,21],[234,"\/upload\/iblock\/532\/ovacjt8qksefvuldr8cnpmk7pahnivhb.jpg",null,37,21],[235,"\/upload\/iblock\/ff4\/dgcg6cntjrtrityk08n3gkvd4txm0631.jpg",null,37,21],[236,"company3",null,38,22],[237,"company4",null,38,22],[238,"brand2",null,38,22],[239,"brand1",null,38,22],[240,"brand3",null,38,22],[241,"137-11-\u0445\u0445",null,39,22],[242,"\u0411\u0430\u043d\u0433\u043b\u0430\u0434\u0435\u0448 "\u0423\u0444\u0438\u043d\u044f\u043c"",null,40,22],[243,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,41,22],[244,"\/upload\/iblock\/1e0\/yq67rjaqa4sfz1i7o26lczl89gam593s.jpg",null,42,22],[245,"\/upload\/iblock\/e34\/qidmt2vi14hqp68xdz3w3117hmauba0a.jpg",null,43,22],[246,"\/upload\/iblock\/490\/fnt4zykjwe9h4llmxidjrdrqlhphbqsf.jpg",null,43,22],[247,"\/upload\/iblock\/1e0\/yq67rjaqa4sfz1i7o26lczl89gam593s.jpg",null,43,22],[248,"company3",null,38,23],[249,"company4",null,38,23],[250,"brand2",null,38,23],[251,"brand1",null,38,23],[252,"brand3",null,38,23],[253,"137-12-\u0445\u0445",null,39,23],[254,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,40,23],[255,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,41,23],[256,"\/upload\/iblock\/a8c\/u955n3hmxhv6ohbc8274pk5bdszqofga.jpg",null,42,23],[257,"\/upload\/iblock\/684\/fnpvvmba4c6t2dzrhd6k0f2bh8ko2rc1.jpg",null,43,23],[258,"\/upload\/iblock\/5d9\/9hqo6qwn6f7ovt63tonpf8412zy24c3c.jpg",null,43,23],[259,"\/upload\/iblock\/a8c\/u955n3hmxhv6ohbc8274pk5bdszqofga.jpg",null,43,23],[260,"\/upload\/iblock\/574\/hr3vpyhesu0yks76zs54tc4tds9wx3ln.jpg",null,43,23],[261,"company3",null,38,24],[262,"company4",null,38,24],[263,"brand2",null,38,24],[264,"brand1",null,38,24],[265,"brand3",null,38,24],[266,"137-13-\u0445\u0445",null,39,24],[267,"\u0411\u0430\u043d\u0433\u043b\u0430\u0434\u0435\u0448 "\u0423\u0444\u0438\u043d\u044f\u043c"",null,40,24],[268,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,41,24],[269,"\/upload\/iblock\/039\/x3flx83u5ue5gcg567hyubl0dloslknh.jpg",null,42,24],[270,"\/upload\/iblock\/4d6\/dhvnhng2v2mb757aaiijyhxsz1eccu98.jpg",null,43,24],[271,"\/upload\/iblock\/496\/mkvlc9sowjbkwk7scgjbufo2owceletf.jpg",null,43,24],[272,"\/upload\/iblock\/361\/wlj2hz10wmdw5g0qsl22qvdaryo6yb75.jpg",null,43,24],[273,"\/upload\/iblock\/039\/x3flx83u5ue5gcg567hyubl0dloslknh.jpg",null,43,24],[274,"company3",null,38,25],[275,"company4",null,38,25],[276,"brand2",null,38,25],[277,"brand1",null,38,25],[278,"brand3",null,38,25],[279,"137-14-\u0445\u0445",null,39,25],[280,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,40,25],[281,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,41,25],[282,"\/upload\/iblock\/074\/davamb6nbunumsjy3zpf8350uuslrccy.jpg",null,42,25],[283,"\/upload\/iblock\/0f5\/81e8rg9bx20dm82p6tnc2fdwfpzzdw2t.jpg",null,43,25],[284,"\/upload\/iblock\/074\/davamb6nbunumsjy3zpf8350uuslrccy.jpg",null,43,25],[285,"\/upload\/iblock\/3ca\/0z83tw7dzkq85o2hx07qhuoihzjema3r.jpg",null,43,25],[286,"\/upload\/iblock\/074\/davamb6nbunumsjy3zpf8350uuslrccy.jpg",null,43,25],[287,"\/upload\/iblock\/4b2\/nhqws724sddletiab8o0qkh6q0rfblbl.jpg",null,43,25],[288,"company3",null,38,26],[289,"company4",null,38,26],[290,"brand2",null,38,26],[291,"brand1",null,38,26],[292,"brand3",null,38,26],[293,"137-15-\u0445\u0445",null,39,26],[294,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,40,26],[295,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,41,26],[296,"\/upload\/iblock\/926\/8qx3mp5nzubhwhm1u6d9yah7fto6e5e8.jpg",null,42,26],[297,"\/upload\/iblock\/5c6\/qcauyggshpoxvswomkn1qhxctab9utfi.jpg",null,43,26],[298,"\/upload\/iblock\/926\/8qx3mp5nzubhwhm1u6d9yah7fto6e5e8.jpg",null,43,26],[299,"\/upload\/iblock\/814\/r9jhkj3uslnez94lvomf8jlwq0y1ha36.jpg",null,43,26],[300,"\/upload\/iblock\/ade\/5hu5r64au71443wlynuhek222r4mchx8.jpg",null,43,26],[301,"\/upload\/iblock\/dd1\/7aj185cu4085l2dw1734g0dvle8407dz.jpg",null,43,26],[302,"189-01-\u0445\u0445",null,44,27],[303,"\u041a\u0438\u0442\u0430\u0439 "\u0413\u0443\u043d \u0414\u0436\u043e\u0439 \u041b\u0438"",null,45,27],[304,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,46,27],[305,"\/upload\/iblock\/ab2\/n33p1d1h76g3ijcsq8jrz71l673jtly6.jpg",null,47,27],[306,"\/upload\/iblock\/69d\/5i2bqz0nhnmiwycbcorxw7jh0y5rybea.jpg",null,48,27],[307,"\/upload\/iblock\/97e\/h204au6um9w1p9fp81zqari9qeufmutr.jpg",null,48,27],[308,"\/upload\/iblock\/ab2\/n33p1d1h76g3ijcsq8jrz71l673jtly6.jpg",null,48,27],[309,"\/upload\/iblock\/ab2\/n33p1d1h76g3ijcsq8jrz71l673jtly6.jpg",null,48,27],[310,"\/upload\/iblock\/d9f\/jz0iq91g6tnxuo5c1fpqjy341xcmg3q4.jpg",null,48,27],[311,"189-02-\u0445\u0445",null,44,28],[312,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,45,28],[313,"\u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u044b",null,46,28],[314,"\/upload\/iblock\/69e\/jdmey2bm17tuaoc9z0f3tq5njewp02rb.jpg",null,47,28],[315,"\/upload\/iblock\/f7c\/0gsfayyo8uv6tvnzqrjuhar7dzyvcdkx.jpg",null,48,28],[316,"\/upload\/iblock\/69e\/jdmey2bm17tuaoc9z0f3tq5njewp02rb.jpg",null,48,28],[317,"\/upload\/iblock\/d57\/z543u4t0ybb0qy0gxv5pc378d6hveqc2.jpg",null,48,28],[318,"\/upload\/iblock\/35f\/3e2959jn1r9e2dw7i2n4jdudg3ntzway.jpg",null,48,28],[319,"\/upload\/iblock\/35f\/3e2959jn1r9e2dw7i2n4jdudg3ntzway.jpg",null,48,28],[320,"189-03-\u0445\u0445",null,44,29],[321,"\u041a\u0438\u0442\u0430\u0439 "\u0413\u0443\u043d \u0414\u0436\u043e\u0439 \u041b\u0438"",null,45,29],[322,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,46,29],[323,"\/upload\/iblock\/402\/x95lhvt7jolbbifg2rf6pax8vi7d39pc.jpg",null,47,29],[324,"\/upload\/iblock\/737\/nvpkr0tpnjk9zy1pdstc2s9k4n6gyabx.jpg",null,48,29],[325,"\/upload\/iblock\/402\/x95lhvt7jolbbifg2rf6pax8vi7d39pc.jpg",null,48,29],[326,"\/upload\/iblock\/427\/li9l89kwr378oqg738ycngelwbwuiq1g.jpg",null,48,29],[327,"\/upload\/iblock\/e3b\/ihcxlzlpsojl5mvtnjm58t0ywapt8a2p.jpg",null,48,29],[328,"\/upload\/iblock\/c04\/4wjssservb9f943f5fh9yh9sbag4k3xt.jpg",null,48,29],[329,"189-04-\u0445\u0445",null,44,30],[330,"\u0420\u043e\u0441\u0441\u0438\u044f "\u041c\u043e\u043b\u043e\u0434\u0430\u044f \u0441\u0435\u043c\u044c\u044f"",null,45,30],[331,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,46,30],[332,"\/upload\/iblock\/417\/kz28j12n314j7i7aeds2mi263dxhwqdy.jpg",null,47,30],[333,"\/upload\/iblock\/d6f\/aeclcvhf8n3bhxx54s6tandw3wfjgg33.jpg",null,48,30],[334,"\/upload\/iblock\/2b7\/c8e1n6bn5xvyicfeztmn7i39g9hoeefl.jpg",null,48,30],[335,"\/upload\/iblock\/d7a\/cag94ib01imm3bbypopsw41m53th3hvs.jpg",null,48,30],[336,"\/upload\/iblock\/d25\/it17qhnht5jyzkdpum781l3swlqdqn57.jpg",null,48,30],[337,"\/upload\/iblock\/417\/kz28j12n314j7i7aeds2mi263dxhwqdy.jpg",null,48,30],[338,"189-05-\u0445\u0445",null,44,31],[339,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,45,31],[340,"95% \u0445\u043b\u043e\u043f\u043e\u043a, 5% \u044d\u043b\u0430\u0441\u0442\u0430\u043d",null,46,31],[341,"\/upload\/iblock\/940\/ggw8xtsooefn9x2in2v8seahlhvoilh6.jpg",null,47,31],[342,"\/upload\/iblock\/750\/ds1l7zkd0u366lwa7b2o1febuqbqcjzb.jpg",null,48,31],[343,"\/upload\/iblock\/2c1\/lgnqpsfo4nktdi6ccyp8mrh54sf2n6kb.jpg",null,48,31],[344,"\/upload\/iblock\/940\/ggw8xtsooefn9x2in2v8seahlhvoilh6.jpg",null,48,31],[345,"\/upload\/iblock\/350\/ttxid2rvgq2u9noudy4m26nbvt7n6rng.jpg",null,48,31],[346,"\/upload\/iblock\/3b9\/qf9707df1x7epjacxeef3lfs1vg825kw.jpg",null,48,31],[347,"189-06-\u0445\u0445",null,44,32],[348,"\u041a\u0438\u0442\u0430\u0439 "\u0413\u0443\u043d \u0414\u0436\u043e\u0439 \u041b\u0438"",null,45,32],[349,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,46,32],[350,"\/upload\/iblock\/0c1\/1ncp7gblprmdxwrvrkwo24q00d61vreo.jpg",null,47,32],[351,"\/upload\/iblock\/75d\/rxpbp66qnzk490kfrxv2opqdij2o02n9.jpg",null,48,32],[352,"\/upload\/iblock\/78f\/sv59nob6z121d42v350zu2kvk77p2prx.jpg",null,48,32],[353,"\/upload\/iblock\/0c1\/1ncp7gblprmdxwrvrkwo24q00d61vreo.jpg",null,48,32],[354,"\/upload\/iblock\/e9c\/qw5pnr9f7fv1in577qdeyy3dxw73awkc.jpg",null,48,32],[355,"\/upload\/iblock\/17f\/pida0raj2dva8ypce6tc7ah37z2cejm6.jpg",null,48,32],[356,"\/upload\/iblock\/ac5\/w188lixhbzqp5r3e18fhty6d4h2521uc.jpg",null,48,32],[357,"188-11-xx",null,49,33],[358,"\u0420\u0443\u043c\u044b\u043d\u0438\u044f "\u0420\u0430\u0434\u0443\u0436\u043d\u044b\u0439 \u0412\u044d\u0439"",null,50,33],[359,"\u0442\u0440\u0438\u043a\u043e\u0442\u0430\u0436",null,51,33],[360,"\/upload\/iblock\/7a6\/6bmfmhkqfdqkslhs7ia47wu2ktrnk5t1.jpg",null,52,33],[361,"188-13-xx",null,49,34],[362,"\u0420\u0443\u043c\u044b\u043d\u0438\u044f "\u0420\u0430\u0434\u0443\u0436\u043d\u044b\u0439 \u0412\u044d\u0439"",null,50,34],[363,"\u043a\u043e\u0436\u0430",null,51,34],[364,"\/upload\/iblock\/480\/bx7ksxwomxpw87lr0blwyoc160f35mto.jpg",null,52,34],[365,"\/upload\/iblock\/8da\/agjpk49z2uzsc1dfcowiauxpcof869x8.jpg",null,53,34],[366,"\/upload\/iblock\/d8d\/3w71hhj849snrftm8shm0o6gzy520bgs.jpg",null,53,34],[367,"\/upload\/iblock\/480\/bx7ksxwomxpw87lr0blwyoc160f35mto.jpg",null,53,34],[368,"\/upload\/iblock\/a8b\/lm8dfx4ldnc4be7odrhprpfaj939i94w.jpg",null,53,34],[369,"\/upload\/iblock\/cdf\/xz0moubdyc9qn19o4yzqhhynn2l803jz.jpg",null,53,34],[370,"188-15-xx",null,49,35],[371,"\u041a\u0438\u0442\u0430\u0439 "\u0413\u0443\u043d \u0414\u0436\u043e\u0439 \u041b\u0438"",null,50,35],[372,"\u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u044b",null,51,35],[373,"\/upload\/iblock\/038\/8vssbgys6ys5sd4lsnmy1vwi6l25jkyd.jpg",null,52,35],[374,"\/upload\/iblock\/219\/wfdysvpar93thkn4b1j7os94vur0ex2c.jpg",null,53,35],[375,"\/upload\/iblock\/eb6\/q3gkh1uoc7813h65xvn74483mmamlvur.jpg",null,53,35],[376,"\/upload\/iblock\/038\/8vssbgys6ys5sd4lsnmy1vwi6l25jkyd.jpg",null,53,35],[377,"\/upload\/iblock\/31c\/tvikcu202eccrxib2aaq8bkc1uj6013a.jpg",null,53,35],[378,"\/upload\/iblock\/e90\/x79esbgrut966epf9z5ha50799657yvo.jpg",null,53,35],[379,"188-12-xx",null,54,36],[380,"\u0418\u0442\u0430\u043b\u0438\u044f "\u0424\u0438\u0440\u0441\u0442\u0438\u043b\u044c"",null,55,36],[381,"\u043a\u043e\u0436\u0430",null,56,36],[382,"\/upload\/iblock\/24a\/y1s0zimh8m62jz1550ozkm39h92k2yfs.jpg",null,57,36],[383,"\/upload\/iblock\/f00\/3fpfhzvl7ah7gg45qk1xjkxyaeuo2wq7.jpg",null,58,36],[384,"\/upload\/iblock\/556\/rga77st0g2otmxfmxpi5wxl0srz75oxa.jpg",null,58,36],[385,"\/upload\/iblock\/24a\/y1s0zimh8m62jz1550ozkm39h92k2yfs.jpg",null,58,36],[386,"\/upload\/iblock\/b62\/qmq49yuyhfqkbk0xhmaw0b1drj4a8gh9.jpg",null,58,36],[387,"\/upload\/iblock\/000\/p4mp1ih5b4hc08k9svhuesyo3sph35p5.jpg",null,58,36],[388,"188-14-xx",null,54,37],[389,"\u0418\u0442\u0430\u043b\u0438\u044f "\u0424\u0438\u0440\u0441\u0442\u0438\u043b\u044c"",null,55,37],[390,"\u043a\u043e\u0436\u0430",null,56,37],[391,"\/upload\/iblock\/b76\/ln83940ogm0hq4iwekzmnlefk301tunr.jpg",null,57,37],[392,"\/upload\/iblock\/a0d\/velid75mvh471rs0pwjft3dst2j3nehz.jpg",null,58,37],[393,"\/upload\/iblock\/add\/mh3an6h65z7w92mrevcapud7w59ptfe3.jpg",null,58,37],[394,"\/upload\/iblock\/b76\/ln83940ogm0hq4iwekzmnlefk301tunr.jpg",null,58,37],[395,"\/upload\/iblock\/b35\/w882ykoo45evglhyp03bftls76172stm.jpg",null,58,37],[396,"\/upload\/iblock\/260\/9trab58ywn1gkgo1qqkr3b4nfqqk142h.jpg",null,58,37],[397,"188-16-xx",null,54,38],[398,"\u0420\u043e\u0441\u0441\u0438\u044f "Grishko"",null,55,38],[399,"\u043a\u043e\u0436\u0430",null,56,38],[400,"\/upload\/iblock\/527\/zb5y9w5ghpngbo1t4ziixubwl80hoz4a.jpg",null,57,38],[401,"\/upload\/iblock\/eca\/t7pozxlnq48x9r4q0zfsgglylrw4ya3z.jpg",null,58,38],[402,"\/upload\/iblock\/f0b\/izhq73sjaysmlp8plik7dkwu3sbhojno.jpg",null,58,38],[403,"\/upload\/iblock\/527\/zb5y9w5ghpngbo1t4ziixubwl80hoz4a.jpg",null,58,38],[404,"\/upload\/iblock\/28f\/0ou6k4eekiysi149j6qqcb4w86n6zye3.jpg",null,58,38],[405,"\/upload\/iblock\/3c4\/f1mj4ctjbtjiws7if723gz16kyh7es3c.jpg",null,58,38]]`)
eav['IBLOCK_PROPERTIES'].data = JSON.parse(`[[1,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",3],[2,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",3],[3,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",3],[4,0,0,"DETAIL_PICTURE",3],[5,0,1,"photo",3],[6,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",4],[7,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",4],[8,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",4],[9,0,0,"DETAIL_PICTURE",4],[10,0,1,"photo",4],[11,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",6],[12,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",6],[13,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",6],[14,0,0,"DETAIL_PICTURE",6],[15,0,1,"photo",6],[16,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",7],[17,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",7],[18,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",7],[19,0,0,"DETAIL_PICTURE",7],[20,0,1,"photo",7],[21,0,1,"\u0411\u0440\u0435\u043d\u0434",8],[22,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",8],[23,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",8],[24,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",8],[25,0,0,"DETAIL_PICTURE",8],[26,0,1,"photo",8],[27,0,1,"\u0411\u0440\u0435\u043d\u0434",9],[28,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",9],[29,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",9],[30,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",9],[31,0,0,"DETAIL_PICTURE",9],[32,0,1,"\u0411\u0440\u0435\u043d\u0434",10],[33,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",10],[34,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",10],[35,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",10],[36,0,0,"DETAIL_PICTURE",10],[37,0,1,"photo",10],[38,0,1,"\u0411\u0440\u0435\u043d\u0434",11],[39,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",11],[40,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",11],[41,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",11],[42,0,0,"DETAIL_PICTURE",11],[43,0,1,"photo",11],[44,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",12],[45,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",12],[46,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",12],[47,0,0,"DETAIL_PICTURE",12],[48,0,1,"photo",12],[49,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",15],[50,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",15],[51,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",15],[52,0,0,"DETAIL_PICTURE",15],[53,0,1,"photo",15],[54,0,0,"\u0410\u0440\u0442\u0438\u043a\u0443\u043b",16],[55,0,0,"\u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c",16],[56,0,1,"\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b",16],[57,0,0,"DETAIL_PICTURE",16],[58,0,1,"photo",16]]`)
eav.IBLOCK_ELEMENTS.data = JSON.parse(`[[1,"\u041f\u0430\u043d\u0442\u043e\u043b\u0435\u0442\u044b \u041a\u043e\u0441\u0442\u0438 \u043d\u0430 \u041f\u043b\u044f\u0436\u0435",3],[2,"\u0414\u043e\u043c\u0430\u0448\u043d\u0438\u0435 \u0422\u0430\u043f\u043e\u0447\u043a\u0438 \u0420\u043e\u0437\u043e\u0432\u044b\u0439 \u0420\u0430\u0439",4],[3,"\u0414\u043e\u043c\u0430\u0448\u043d\u0438\u0435 \u0422\u0430\u043f\u043e\u0447\u043a\u0438 \u041b\u044e\u0431\u0438\u043c\u044b\u0439 \u0421\u043f\u043e\u0440\u0442",4],[4,"\u0422\u0443\u0444\u043b\u0438 \u0412\u0435\u0447\u0435\u0440\u043d\u044f\u044f \u0411\u0430\u0431\u043e\u0447\u043a\u0430",6],[5,"\u0422\u0443\u0444\u043b\u0438 \u041f\u043e\u043b\u0435\u0442 \u0412\u0430\u043b\u044c\u043a\u0438\u0440\u0438\u0438",6],[6,"\u0422\u0443\u0444\u043b\u0438 \u0423\u043b\u044c\u0442\u0440\u0430 \u041b\u0430\u0439\u043d",6],[7,"\u0422\u0443\u0444\u043b\u0438 \u041b\u0435\u0442\u043d\u044f\u044f \u041b\u0435\u0433\u043a\u043e\u0441\u0442\u044c",7],[8,"\u041f\u043b\u0430\u0442\u044c\u0435 \u041c\u043e\u0434\u043d\u0438\u0446\u0430 \u043d\u0430 \u041f\u0440\u043e\u0433\u0443\u043b\u043a\u0435",8],[9,"\u041f\u043b\u0430\u0442\u044c\u0435 \u0412\u0435\u0441\u0435\u043d\u043d\u044f\u044f \u041b\u0435\u0433\u043a\u043e\u0441\u0442\u044c",8],[10,"\u041f\u043b\u0430\u0442\u044c\u0435 \u041d\u043e\u0447\u043d\u0430\u044f \u0416\u0438\u0437\u043d\u044c",8],[11,"\u041f\u043b\u0430\u0442\u044c\u0435 \u041a\u0440\u0430\u0441\u043d\u0430\u044f \u0424\u0435\u044f",8],[12,"\u0428\u0442\u0430\u043d\u044b \u041f\u043e\u043b\u043e\u0441\u0430\u0442\u044b\u0439 \u0420\u0435\u0439\u0441",9],[13,"\u0428\u0442\u0430\u043d\u044b \u0416\u0438\u0437\u043d\u044c \u0432 \u0410\u0431\u0441\u0442\u0440\u0430\u043a\u0446\u0438\u0438",9],[14,"\u0428\u0442\u0430\u043d\u044b \u0426\u0432\u0435\u0442\u043e\u0447\u043d\u0430\u044f \u041f\u043e\u043b\u044f\u043d\u0430",9],[15,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u041c\u043e\u0440\u0441\u043a\u0430\u044f \u0412\u043e\u043b\u043d\u0430",10],[16,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u0411\u0435\u043b\u0430\u044f \u0421\u0432\u043e\u0431\u043e\u0434\u0430",10],[17,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u0418\u043d\u0442\u0438\u043c\u043d\u044b\u0439 \u0412\u0435\u0447\u0435\u0440",10],[18,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u041d\u043e\u0447\u044c \u041c\u043e\u0440\u043e\u0437\u043d\u044b\u0445 \u0423\u0437\u043e\u0440\u043e\u0432",10],[19,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u041e\u0433\u043e\u043d\u0435\u043a \u0432 \u041d\u043e\u0447\u0438",10],[20,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u0420\u043e\u0437\u043e\u0432\u043e\u0435 \u0421\u043c\u0443\u0449\u0435\u043d\u044c\u0435",10],[21,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435 \u041d\u043e\u0447\u044c \u043d\u0430\u0441\u0442\u0443\u043f\u0430\u0435\u0442",10],[22,"\u0424\u0443\u0442\u0431\u043e\u043b\u043a\u0430 \u041c\u0443\u0436\u0441\u043a\u0430\u044f \u0427\u0438\u0441\u0442\u043e\u0442\u0430",11],[23,"\u0424\u0443\u0442\u0431\u043e\u043b\u043a\u0430 \u0416\u0435\u043d\u0441\u043a\u0430\u044f \u0427\u0438\u0441\u0442\u043e\u0442\u0430",11],[24,"\u0424\u0443\u0442\u0431\u043e\u043b\u043a\u0430 \u0416\u0435\u043d\u0441\u043a\u0430\u044f \u041d\u043e\u0447\u044c",11],[25,"\u0424\u0443\u0442\u0431\u043e\u043b\u043a\u0430 \u041c\u0443\u0436\u0441\u043a\u043e\u0439 \u041e\u0433\u043e\u043d\u044c",11],[26,"\u0424\u0443\u0442\u0431\u043e\u043b\u043a\u0430 \u0416\u0435\u043d\u0441\u043a\u0438\u0439 \u0421\u043e\u0431\u043b\u0430\u0437\u043d",11],[27,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u044b\u0439 \u041a\u043e\u0441\u0442\u044e\u043c \u041d\u0435\u0436\u043d\u0430\u044f \u0422\u0435\u043f\u043b\u043e\u0442\u0430",12],[28,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u044b\u0439 \u041a\u043e\u0441\u0442\u044e\u043c \u041e\u0433\u043e\u043d\u044c \u0432 \u041d\u043e\u0447\u0438",12],[29,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u044b\u0439 \u041a\u043e\u0441\u0442\u044e\u043c \u042d\u043b\u0435\u0433\u0430\u043d\u0442\u043d\u043e\u0441\u0442\u044c \u0432 \u041d\u043e\u0447\u0438",12],[30,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u044b\u0439 \u041a\u043e\u0441\u0442\u044e\u043c \u0420\u043e\u0437\u043e\u0432\u044b\u0439 \u0412\u0438\u0445\u0440\u044c",12],[31,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u044b\u0439 \u041a\u043e\u0441\u0442\u044e\u043c \u0414\u044b\u0445\u0430\u043d\u0438\u0435 \u0421\u043f\u043e\u0440\u0442\u0430",12],[32,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u044b\u0439 \u041a\u043e\u0441\u0442\u044e\u043c \u0412\u0435\u0447\u0435\u0440\u043d\u0438\u0439 \u0421\u043f\u043e\u0440\u0442",12],[33,"\u0420\u0435\u043c\u0435\u043d\u044c \u0420\u0430\u0434\u0443\u0433\u0430",15],[34,"\u0420\u0435\u043c\u0435\u043d\u044c \u042d\u043b\u0435\u0433\u0430\u043d\u0442\u043d\u043e\u0441\u0442\u044c",15],[35,"\u0420\u0435\u043c\u0435\u043d\u044c \u041f\u043b\u0435\u0442\u0435\u043d\u0438\u0435",15],[36,"\u0420\u0435\u043c\u0435\u043d\u044c \u041a\u043b\u0430\u0441\u0441\u0438\u043a\u0430",16],[37,"\u0420\u0435\u043c\u0435\u043d\u044c \u0421\u0442\u0440\u043e\u0447\u043a\u0430",16],[38,"\u0420\u0435\u043c\u0435\u043d\u044c \u0413\u0440\u0443\u0431\u0430\u044f \u041a\u043e\u0436\u0430",16]]`)
eav.IBLOCKS.data = JSON.parse(`[[1,"\u041a\u0430\u0442\u0430\u043b\u043e\u0433",0,1,32],[2,"\u041e\u0431\u0443\u0432\u044c",1,2,13],[3,"\u041f\u0430\u043d\u0442\u043e\u043b\u0435\u0442\u044b",2,3,4],[4,"\u0422\u0430\u043f\u043e\u0447\u043a\u0438",2,5,6],[5,"\u0422\u0443\u0444\u043b\u0438",2,7,12],[6," \u0422\u0443\u0444\u043b\u0438 \u0416\u0435\u043d\u0441\u043a\u0438\u0435",5,8,9],[7,"\u0422\u0443\u0444\u043b\u0438 \u041c\u0443\u0436\u0441\u043a\u0438\u0435",5,10,11],[8,"\u041f\u043b\u0430\u0442\u044c\u044f",1,14,15],[9,"\u0428\u0442\u0430\u043d\u044b",1,16,17],[10,"\u041d\u0438\u0436\u043d\u0435\u0435 \u0431\u0435\u043b\u044c\u0435",1,18,19],[11,"\u0424\u0443\u0442\u0431\u043e\u043b\u043a\u0438",1,20,21],[12,"\u0421\u043f\u043e\u0440\u0442\u0438\u0432\u043d\u0430\u044f \u041e\u0434\u0435\u0436\u0434\u0430",1,22,23],[13,"\u0410\u043a\u0441\u0435\u0441\u0441\u0443\u0430\u0440\u044b",1,24,31],[14,"\u0420\u0435\u043c\u043d\u0438",13,25,30],[15,"\u0420\u0435\u043c\u043d\u0438 \u0416\u0435\u043d\u0441\u043a\u0438\u0435",14,26,27],[16,"\u0420\u0435\u043c\u043d\u0438 \u041c\u0443\u0436\u0441\u043a\u0438\u0435",14,28,29]]`)
let init = {};
let CURRENT = 1;
function change(event) {
if (event) {
mysql.table = event.target.value == "1" ? JSON.parse(JSON.stringify(diary)) : JSON.parse(JSON.stringify(eav));
init = JSON.parse(JSON.stringify(mysql.table))
}
if (event.target.value == '1') {
CURRENT = 1;
document.querySelector('.sqlite').style.display = 'none'
window.monaco.setValue(`SELECT *
FROM DIARY D
JOIN (SELECT P.DIARY_ID, MAX(P.ID) AS PID
FROM POSTS P
JOIN USERS U ON P.USER_ID = U.ID
GROUP BY P.DIARY_ID) PP ON D.ID = PP.DIARY_ID
JOIN USERS U ON D.USER_ID = U.ID
ORDER BY PP.PID DESC`);
} else {
CURRENT = 2
document.querySelector('.sqlite').style.display = 'block'
window.monaco.setValue(`SELECT *
FROM iblock_elements el
JOIN iblock_properties p on 1 = 1
AND p.iblock_id IN
(SELECT i.id
FROM iblocks i
JOIN iblocks ic on 1 = 1 AND ic.id = el.iblock_id
WHERE 1 = 1
AND (i.left < ic.left OR i.left = ic.left)
AND (i.right > ic.right OR i.right = ic.right)
)
JOIN iblock_prop_values pv on pv.prop_id = p.id
AND pv.el_id = el.id
WHERE el.iblock_id IN
(SELECT ib.id
FROM iblocks ib
JOIN (SELECT * FROM iblocks b where b.id = 2) gg on 1 = 1
WHERE 1 = 1
AND (ib.left > gg.left OR ib.left = gg.left)
AND (ib.right < gg.right OR ib.right = gg.right)
)`
)
}
table();
run();
}
let table = () => {
let html = "";
html += '<tr>'
Object.keys(init).forEach((key) => {
html += '<th>'
html += key;
html += '</th>'
});
html += '</tr>'
let max = Math.max(...Object.values(init).map((c) => c.col?.length))
for (let i = 0; i <= max - 1; i++) {
html += '<tr>'
for (let j = 0; j <= Object.keys(init).length - 1; j++) {
html += `<td>${init[Object.keys(init)[j]]?.col[i] ?? ''}</td>`
}
html += '</tr>'
}
document.querySelector(".main").innerHTML = html
}
window.addEventListener("load", (event) => {
table()
});
mysql.table = JSON.parse(JSON.stringify(diary))
init = JSON.parse(JSON.stringify(mysql.table))
table()
//index
let mainfn = (num) => {
let a = performance.now();
let res = (mysql.query(` ${sql()} `));
let b = performance.now();
if (CURRENT == 2) {
let sqlite = 0;
fetch('https://iblockcms.mooo.com/api/mctime', {
method: 'POST',
headers: {
'Content-Type': 'application/json'
},
body: JSON.stringify({
sql: sql()
})
})
.then(response => {
if (!response.ok) {
throw new Error(`HTTP error! status: ${response.status}`);
}
return response.json(); // Or response.text() if not expecting JSON
})
.then(data => {
console.log({ sqlite: data.data })
sqlite = data.time
document.querySelector('.exec_time_sqlite').innerHTML = sqlite.toFixed(3) + ' milliseconds';
})
.catch(error => {
sqlite = 'error'
document.querySelector('.exec_time_sqlite').innerHTML = sqlite + ' milliseconds';
});
}
document.querySelector('.exec_time').innerHTML = (b - a).toFixed(3) + ' milliseconds';
if (!res.length) {
document.querySelector(".res").innerHTML = `<h4>empty</h4>`
return;
}
let html = "";
html += '<tr>'
Object.keys(res[0]).forEach((key) => {
html += '<th>'
html += key;
html += '</th>'
});
html += '</tr>'
res.forEach((c) => {
html += '<tr>'
Object.values(c).forEach((c) => {
html += `<td>${c}</td>`
})
html += '</tr>'
});
document.querySelector(".res").innerHTML = html
}
var m = () => {
try {
num = $('textarea').prop("selectionStart");
mainfn(num, 0, num);
document.querySelector('.error').innerHTML = ``
} catch (e) {
document.querySelector('.exec_time').innerHTML = ``
document.querySelector(".res").innerHTML = ``
document.querySelector('.error').innerHTML = `
<div class="alert alert-danger d-flex align-items-center" role="alert">
<svg class="bi flex-shrink-0 me-2" width="24" height="24" role="img" aria-label="Danger:"><use xlink:href="#exclamation-triangle-fill"/></svg>
<div>
${e}
</div>
</div>
`;
}
$('.spinner-border').toggle();
};
function run() {
$('.spinner-border').toggle();
setTimeout(() => {
m();
}, 0)
}
run()
document.addEventListener("DOMContentLoaded", () => {
window.monaco = monaco.editor.create(document.getElementById('sql'), {
value: `SELECT *
FROM DIARY D
JOIN (SELECT P.DIARY_ID, MAX(P.ID) AS PID
FROM POSTS P
JOIN USERS U ON P.USER_ID = U.ID
GROUP BY P.DIARY_ID) PP ON D.ID = PP.DIARY_ID
JOIN USERS U ON D.USER_ID = U.ID
ORDER BY PP.PID DESC
`,
language: 'sql',
theme: 'vs-white',
minimap: { enabled: false },
});
setTimeout(() => {
mainfn();
}, 0)
});
</script>
</html>