Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

2.77 ms Query time

0 Invalid entities

0 Managed entities

Queries


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)
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
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
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;
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
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
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
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
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
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
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

#▲	Time	Info
1	0.36 ms	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"`] View formatted query View runnable query Explain query 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 ) 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='/aquasvet');
2	0.08 ms	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: [] View formatted query View runnable query Explain query 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 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;
3	0.07 ms	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`] View formatted query View runnable query Explain query 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 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 = 3 LIMIT 0, 1;
4	0.55 ms	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: [] View formatted query View runnable query Explain query 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; 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;;
5	0.45 ms	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"`] View formatted query View runnable query Explain query 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 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 = '1' ORDER BY SORT_INDEX;
6	0.22 ms	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" => "2"`] View formatted query View runnable query Explain query 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 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 = '2' ORDER BY SORT_INDEX;
7	0.22 ms	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" => "3"`] View formatted query View runnable query Explain query 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 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 = '3' ORDER BY SORT_INDEX;
8	0.24 ms	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" => "4"`] View formatted query View runnable query Explain query 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 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 = '4' ORDER BY SORT_INDEX;
9	0.19 ms	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" => "5"`] View formatted query View runnable query Explain query 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 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 = '5' ORDER BY SORT_INDEX;
10	0.21 ms	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" => "6"`] View formatted query View runnable query Explain query 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 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 = '6' ORDER BY SORT_INDEX;
11	0.19 ms	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" => "7"`] View formatted query View runnable query Explain query 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 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 = '7' ORDER BY SORT_INDEX;

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping