GET https://kas.webmax.cloud/aquasvet/kurzy-plavani

Query Metrics

11 Database Queries
5 Different statements
2.77 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.72 ms
(62.20%)
7
SELECT
                          ID as ID,
                          SORT_INDEX as SORT_INDEX,
                          AC_ID as AC_ID,
                            AC_DAY1,
                            AC_DAY2,
                            AC_DAY3,
                            AC_DAY4,
                            AC_DAY5,
                            AC_DAY6,
                            AC_DAY7,
                            TIME_FORMAT(AC_TIME_FROM, '%H:%i') as AC_TIME_FROM,
                            TIME_FORMAT(AC_TIME_TO, '%H:%i') as AC_TIME_TO,
                            AC_TEXT1,
                            AC_TEXT2
                        FROM AQUA_COURSES_DETS
                          WHERE AC_ID = :id
                          ORDER BY SORT_INDEX
Parameters:
[
  "id" => "1"
]
0.55 ms
(19.80%)
1
SELECT
                                                      ID,
                                                      AC_INSTR_ID,
                                                      AC_NAME,
                                                      AC_DURATION,
                                                      AC_PRICE,
                                                      AC_DESC,
                                                      AC_RULES,
                                                      AC_ACTIVE,
                                                      LAST_USER,
                                                      LAST_UPDATE,
                                                      DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i') as PREVCACHE,
                                                      SORT_INDEX,
                                                      AC_AGE_FROM,
                                                      AC_AGE_TO,
                                                      AC_CAPACITY,
                                                      AC_SUBST
                                                    FROM AQUA_COURSES_CATS
                                                    WHERE AC_ACTIVE = 1
                                                    ORDER BY SORT_INDEX;
Parameters:
[]
0.36 ms
(12.93%)
1
SELECT PI_MESSAGE FROM PAGEINFO 
                                                WHERE 
                                                ((CURDATE() BETWEEN DATE(PI_FROM) AND DATE(PI_TO)) OR 
                                                (CURDATE() > DATE(PI_FROM) AND PI_TO IS NULL) OR 
                                                (CURDATE() < DATE(PI_FROM) AND PI_FROM IS NULL) OR 
                                                (PI_TO IS NULL AND PI_FROM IS NULL)) AND PI_ACTIVE = 1 AND (PI_URI = '*' OR PI_URI=:uri)
Parameters:
[
  "uri" => "/aquasvet"
]
0.08 ms
(2.71%)
1
SELECT
                                                        MONTHS_CYCLE,
                                                        PREPARE_TEXT,
                                                        FORM_COND,
                                                        FORM_GDPR,
                                                        CONTACT_EMAIL,
                                                        CONTACT_PHONE,
                                                        MYCOURSE_TEXT,
                                                        CNT1,
                                                        HTML_INFO,
                                                        MAIL_INFO,
                                                        DAY3
                                                    FROM AQUA_COURSES_SETT
                                                    WHERE ID=1
Parameters:
[]
0.07 ms
(2.36%)
1
SELECT
                                                          OBJECT_ID,
                                                          PRICELIST_INFO,
                                                          PRICELIST1_NAME,
                                                          PRICELIST2_NAME,
                                                          PRICELIST3_NAME,
                                                          PRICELIST1_FROM,
                                                          PRICELIST2_FROM,
                                                          PRICELIST3_FROM,
                                                          PRICELIST1_DATA,
                                                          PRICELIST2_DATA,
                                                          PRICELIST3_DATA
                                                    FROM OBJECTS_PRICELISTS                                            
                                                    WHERE OBJECT_ID = :id
                                                    LIMIT 0, 1
Parameters:
[
  "id" => 3
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

No loaded entities.