Why is the site running slowly on Bitrix?

Question

1C-Bitrix

There is an online store. The initial problem is that the standard Bitrix monitoring claims that the site is running slowly - it shows a speed of 2.08 on average. CDN is on, composite site is off. Now I'm trying to analyze the components that work slowly.
The slowest indicator in sections.

Seems like 278 requests from one page is quite a lot. I started looking, and to build a catalog of goods, 2 requests are made for each product.
1 request.
SELECT P.ID ,P.CODE ,P.TEMPLATE ,P.ENTITY_TYPE ,P.ENTITY_ID ,IP.VALUE
FROM
b_iblock_element_iprop IP
INNER JOIN b_iblock_iproperty P ON P.ID = IP.IPROP_ID
WHERE
IP.IBLOCK_ID = 1 AND IP.ELEMENT_ID = 463765
2 request.
select ID
from
b_catalog_product_sets
where
OWNER_ID in(463765) and TYPE=2
limit 1
In general, I didn’t work much with Bitrix, can you tell me if I’m digging there at all? What should be analyzed first?

Answer 1

We put free Newrelic on the site, it will show what exactly "thinks" for a long time when processing the response, by the server.
If this is a database:
1. Enable logging of slow requests.
2. We explain these queries in order to identify non-optimal indexes
3. We create indexes
I can also advise mysqltuner to check whether the database settings are optimal.
If the code: then analyze, profile the code with xdebug, and the same newrelic will give you the top slow scripts. It remains to make a review and find bottlenecks.
Set up monitoring of infrastructure resources (io, cpu util, etc.). I'll say stupidity, but the base, I hope, on ssd?

Answer 2

Can you link to the site? Then you can be more specific.
Look at this indicator "Waiting (TTFB)" on slow pages, this is the time of page formation on the server.

Answer 3

To get started, enable all regular optimization tools - compression, merge, autocache, composite, etc.
Then everyone sits on the sofas and scolds Bitrix ... Otherwise
, this banality hurts the eyes:
and this one:
You may have to abandon the CDN - a fashionable word, but in your case only harm ...