for ($i = 0; $i < (is_countable($array) && count($array)); $i++) {
}
23 SELECT `main_localization_language`.`LID` AS `ID`, `main_localization_language`.`LID` AS `UALIAS_... (1) 0.00006
24 SELECT BE.ID IBLOCK_ELEMENT_ID ,BEP.IBLOCK_PROPERTY_ID ,BEP.VALUE ,BEP.VALU... (1) 0.00857
25 SELECT `iblock_property`.`ID` AS `ID`, `iblock_property`.`IBLOCK_ID` AS `IBLOCK_ID`, `iblock_pro... (1) 0.00062
26 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00013
27 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00006
28 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
29 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
30 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (12) 0.00038
31 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00032
32 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00030
33 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00031
34 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00007
35 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
36 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
37 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00006
38 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (12) 0.00035
39 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00032
40 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00030
41 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00031
42 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00008
43 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (18) 0.00033
44 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00035
45 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00035
46 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00029
47 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00008
48 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (18) 0.00030
49 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00030
50 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00028
51 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00026
52 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (12) 0.00031
53 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00029
54 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00027
55 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00026
56 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (18) 0.00030
57 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00030
58 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00028
59 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00026
60 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (18) 0.00030
61 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00030
62 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00028
63 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00026
64 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00009
65 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00006
66 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (12) 0.00032
67 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00032
68 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00029
69 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (12) 0.00027
70 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (18) 0.00040
71 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00039
72 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00038
73 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00035
74 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (18) 0.00034
75 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00034
76 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00033
77 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (18) 0.00031
$arFilter = array('IBLOCK_ID' => XX, "ID" => array(111,112,113,114));
$arSelect = array('IBLOCK_ID', 'NAME', 'SECTION_PAGE_URL', 'DETAIL_PICTURE', 'PROPERTY_MIN_PRICE','PICTURE');
Путь к файлу: /bitrix/components/bitrix/news.list/component.php
Время генерации: 2.2644019126892 сек.
Всего запросов: 5180, время: 1.7475614643305 сек. (77.18%)
1 SELECT DISTINCT B.* ,B.XML_ID as EXTERNAL_ID ,DATE_FORMAT(B.TIMESTAMP_X, '%d.%m.... (1) 0.00021
2 SELECT COUNT('x') as C FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INN... (1) 0.00083
3 SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.NAME as NAME,BE.SORT as SORT FROM b_... (1) 0.00096
4 SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,BE.NAME... (1) 0.00065
5 SELECT BE.ID IBLOCK_ELEMENT_ID ,BEP.IBLOCK_PROPERTY_ID ,BEP.VALUE ,BEP.VALU... (1) 0.00906
6 SELECT `iblock_property`.`ID` AS `ID`, `iblock_property`.`IBLOCK_ID` AS `IBLOCK_ID`, `iblock_pro... (1) 0.00061
7 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00009
8 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00006
9 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
10 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
11 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
12 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00005
13 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (24) 0.00032
14 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (24) 0.00031
15 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (24) 0.00030
16 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (24) 0.00027
17 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00008
18 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00010
19 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00007
20 SELECT `iblock_property_enumeration`.`ID` AS `ID`, `iblock_property_enumeration`.`VALUE` AS `VALU... (1) 0.00010
21 SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMEST... (24) 0.00032
22 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (24) 0.00032
788 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (6) 0.00029
789 SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEP... (6) 0.00026
var colvo = $(' .item').length; //получили количество например 21
var delcolvo = (colvo/4); разделили на 4
var newcolvo = (colvo-delcolvo); отняли, получили 20