Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.35 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	0.54 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;
2	0.10 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;
3	0.71 ms	SELECT GROUP_CONCAT(CAST(AQUA_COURSES_1.ID AS CHAR) SEPARATOR ',') AS ID, GROUP_CONCAT(CAST(AQUA_COURSES_1.AC_MONTH AS CHAR) ORDER BY AQUA_COURSES_1.AC_MONTH SEPARATOR ',') AS AC_MONTH, CONCAT(GROUP_CONCAT(MONTHS.M_NAME2 ORDER BY MONTHS.M_NAME SEPARATOR ' + '), ' ', AQUA_COURSES_1.AC_YEAR) AS AC_MONTH_NAME FROM AQUA_COURSES_1 INNER JOIN MONTHS ON AQUA_COURSES_1.AC_MONTH = MONTHS.ID WHERE AQUA_COURSES_1.AC_ACTIVE = 1 GROUP BY AQUA_COURSES_1.AC_YEAR, AQUA_COURSES_1.AC_ACTIVE Parameters: [] View formatted query View runnable query Explain query SELECT GROUP_CONCAT( CAST(AQUA_COURSES_1.ID AS CHAR) SEPARATOR ',' ) AS ID, GROUP_CONCAT( CAST(AQUA_COURSES_1.AC_MONTH AS CHAR) ORDER BY AQUA_COURSES_1.AC_MONTH SEPARATOR ',' ) AS AC_MONTH, CONCAT( GROUP_CONCAT( MONTHS.M_NAME2 ORDER BY MONTHS.M_NAME SEPARATOR ' + ' ), ' ', AQUA_COURSES_1.AC_YEAR ) AS AC_MONTH_NAME FROM AQUA_COURSES_1 INNER JOIN MONTHS ON AQUA_COURSES_1.AC_MONTH = MONTHS.ID WHERE AQUA_COURSES_1.AC_ACTIVE = 1 GROUP BY AQUA_COURSES_1.AC_YEAR, AQUA_COURSES_1.AC_ACTIVE SELECT GROUP_CONCAT(CAST(AQUA_COURSES_1.ID AS CHAR) SEPARATOR ',') AS ID, GROUP_CONCAT(CAST(AQUA_COURSES_1.AC_MONTH AS CHAR) ORDER BY AQUA_COURSES_1.AC_MONTH SEPARATOR ',') AS AC_MONTH, CONCAT(GROUP_CONCAT(MONTHS.M_NAME2 ORDER BY MONTHS.M_NAME SEPARATOR ' + '), ' ', AQUA_COURSES_1.AC_YEAR) AS AC_MONTH_NAME FROM AQUA_COURSES_1 INNER JOIN MONTHS ON AQUA_COURSES_1.AC_MONTH = MONTHS.ID WHERE AQUA_COURSES_1.AC_ACTIVE = 1 GROUP BY AQUA_COURSES_1.AC_YEAR, AQUA_COURSES_1.AC_ACTIVE;

#▲

Time

Info

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

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

0.71 ms

SELECT
              GROUP_CONCAT(CAST(AQUA_COURSES_1.ID AS CHAR) SEPARATOR ',') AS ID,
              GROUP_CONCAT(CAST(AQUA_COURSES_1.AC_MONTH AS CHAR) ORDER BY AQUA_COURSES_1.AC_MONTH SEPARATOR ',') AS AC_MONTH,
              CONCAT(GROUP_CONCAT(MONTHS.M_NAME2 ORDER BY MONTHS.M_NAME SEPARATOR ' + '), ' ', AQUA_COURSES_1.AC_YEAR) AS AC_MONTH_NAME
            FROM AQUA_COURSES_1
              INNER JOIN MONTHS
                ON AQUA_COURSES_1.AC_MONTH = MONTHS.ID
            WHERE AQUA_COURSES_1.AC_ACTIVE = 1
            GROUP BY   
                     AQUA_COURSES_1.AC_YEAR,
                     AQUA_COURSES_1.AC_ACTIVE

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  GROUP_CONCAT(
    CAST(AQUA_COURSES_1.ID AS CHAR) SEPARATOR ','
  ) AS ID,
  GROUP_CONCAT(
    CAST(AQUA_COURSES_1.AC_MONTH AS CHAR)
    ORDER BY
      AQUA_COURSES_1.AC_MONTH SEPARATOR ','
  ) AS AC_MONTH,
  CONCAT(
    GROUP_CONCAT(
      MONTHS.M_NAME2
      ORDER BY
        MONTHS.M_NAME SEPARATOR ' + '
    ),
    ' ',
    AQUA_COURSES_1.AC_YEAR
  ) AS AC_MONTH_NAME
FROM
  AQUA_COURSES_1
  INNER JOIN MONTHS ON AQUA_COURSES_1.AC_MONTH = MONTHS.ID
WHERE
  AQUA_COURSES_1.AC_ACTIVE = 1
GROUP BY
  AQUA_COURSES_1.AC_YEAR,
  AQUA_COURSES_1.AC_ACTIVE

SELECT
              GROUP_CONCAT(CAST(AQUA_COURSES_1.ID AS CHAR) SEPARATOR ',') AS ID,
              GROUP_CONCAT(CAST(AQUA_COURSES_1.AC_MONTH AS CHAR) ORDER BY AQUA_COURSES_1.AC_MONTH SEPARATOR ',') AS AC_MONTH,
              CONCAT(GROUP_CONCAT(MONTHS.M_NAME2 ORDER BY MONTHS.M_NAME SEPARATOR ' + '), ' ', AQUA_COURSES_1.AC_YEAR) AS AC_MONTH_NAME
            FROM AQUA_COURSES_1
              INNER JOIN MONTHS
                ON AQUA_COURSES_1.AC_MONTH = MONTHS.ID
            WHERE AQUA_COURSES_1.AC_ACTIVE = 1
            GROUP BY   
                     AQUA_COURSES_1.AC_YEAR,
                     AQUA_COURSES_1.AC_ACTIVE;

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/prihlaska-na-kurz

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping