A
A
Alex Sokol2018-12-19 01:10:59
1C-Bitrix
Alex Sokol, 2018-12-19 01:10:59

How to track a request to the database in Bitrix, that is, where does the call come from?

The server admins began to complain that there were always alerts about the same request.
SELECT FPS0.PROPERTY_46 as PROPERTY_SUMM_VALUE, concat(BE.ID , ':' , 46) as PROPERTY_SUMM_VALUE_ID,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE
FROM
b_iblock B
INNER JOIN b_lang L ON B.LID=L.LID
INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
INNER JOIN b_iblock_element_prop_s9 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
WHERE 1=1
AND (
(((BE. IBLOCK_ID = '9'))))
AND ((((BE.DATE_CREATE > '2017-08-16 12:23:17'))))
AND ((((FPS0.PROPERTY_48 = '880533'))))
)
AND (((BE.WF_STATUS_ID= 1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) |
FPS0.PROPERTY_48 = different this is a property of type Binding to an element
From the admin panel, calling the list of elements of this IB-9 gives an error, it says that there is not enough RAM, there are more than 600 thousand records
All calls to IB-9 by code seem to have been monitored, in some places they were disabled
But we can’t find this call, I also searched through the ssh search and in phpStorm, like "IBLOCK_ID" => 9
How else can I monitor and find where the call comes from?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Y
Yaroslav Alexandrov, 2018-12-19
@alexyarik

Didn't you look here?
https://dev.1c-bitrix.ru/learning/course/index.php...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question