Query Metrics
7
Database Queries
7
Different statements
3.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.24 ms (38.06%) |
1 |
SELECT MIN(V1.ID) AS ID, V1.AC_NAME AS AC_NAME, CONCAT(DATE_FORMAT(MIN(V1.AC_DATE_FROM), '%d.%m.%Y'), ' - ', DATE_FORMAT(MAX(V1.AC_DATE_TO), '%d.%m.%Y')) AS AC_DATES, GROUP_CONCAT(V1.AC_TIME SEPARATOR ', ') AS AC_TIMES FROM (SELECT MIN(COURSES_CATS.ID) AS ID, COURSES_CATS.AC_NAME AS AC_NAME, CONCAT(TIME_FORMAT(COURSES_DETS.AC_TIME_FROM, '%H:%i'), ' - ', TIME_FORMAT(COURSES_DETS.AC_TIME_TO, '%H:%i')) AS AC_TIME, MIN(COURSES_CATS.AC_DATE_FROM) AS AC_DATE_FROM, MAX(COURSES_CATS.AC_DATE_TO) AS AC_DATE_TO FROM ((COURSES_CATS JOIN COURSES_DETS ON (COURSES_CATS.ID = COURSES_DETS.AC_ID)) JOIN COURSES_2 ON (COURSES_2.COURSE_ID = COURSES_CATS.ID)) WHERE COURSES_CATS.AC_ACTIVE = 1 AND COURSES_CATS.OBJECT_ID = :object_id AND CURDATE() >= COURSES_CATS.AC_REG_FROM AND CURDATE() <= COURSES_CATS.AC_DATE_CLOSEANDSUB GROUP BY COURSES_CATS.AC_NAME, CONCAT(TIME_FORMAT(COURSES_DETS.AC_TIME_FROM, '%H:%i'), ' - ', TIME_FORMAT(COURSES_DETS.AC_TIME_TO, '%H:%i'))) V1 GROUP BY V1.AC_NAME
Parameters:
[ "object_id" => 3 ] |
|
1.21 ms (37.08%) |
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.52 ms (15.88%) |
1 |
SELECT CNT2, FORM_GDPR, CONTACT_EMAIL FROM COURSES_SETT WHERE ID=1
Parameters:
[] |
|
0.10 ms (3.10%) |
1 |
SELECT DISTINCT OBJECTS.ID AS ID, OBJECTS.OBJECT_NAME AS OBJECT_NAME, OBJECTS.OBJECT_SUBTITLE AS OBJECT_SUBTITLE, OBJECTS.OBJECT_LINK AS OBJECT_LINK, OBJECTS.OBJECT_EXT_LINK AS OBJECT_EXT_LINK, OBJECTS.OBJECT_CULTURE AS OBJECT_CULTURE, OBJECTS.OBJECT_SPORT AS OBJECT_SPORT, OBJECTS.OBJECT_CINEMA AS OBJECT_CINEMA, OBJECTS.OBJECT_IMG_SMALL AS OBJECT_IMG_SMALL, OBJECTS.OBJECT_IMG_LARGE AS OBJECT_IMG_LARGE, OBJECTS.OBJECT_FILE AS OBJECT_FILE, OBJECTS.SHOW_PROGRAM AS SHOW_PROGRAM, OBJECTS.VIRTUAL_TOUR_LINK AS VIRTUAL_TOUR_LINK, OBJECTS_INFO.OI_PHONE AS OI_PHONE, OBJECTS_INFO.OI_EMAIL AS OI_EMAIL, OBJECTS_INFO.OI_TIMELINE AS OI_TIMELINE, OBJECTS_INFO.OI_CALENDAR AS OI_CALENDAR, OBJECTS_INFO.OI_INFO AS OI_INFO, OBJECTS_INFO.OI_CONTACT AS OI_CONTACT, OBJECTS_INFO.OI_PUBLISH_EVENT AS OI_PUBLISH_EVENT, OBJECTS_INFO.OI_MAP_LAT AS OI_MAP_LAT, OBJECTS_INFO.OI_MAP_LNG AS OI_MAP_LNG, OBJECTS_INFO.OI_STREET AS OI_STREET, OBJECTS_INFO.OI_CITY AS OI_CITY, OBJECTS_INFO.OI_POSTAL AS OI_POSTAL, OBJECTS_INFO.OI_DEFTAB AS OI_DEFTAB, GROUP_CONCAT(PAGES.PAGE_FILE SEPARATOR '|') AS PAGE_INFO, OBJECTS.OBJECT_EMBED_LINK AS OBJECT_EMBED_LINK, OBJECT_CLASS AS OBJECT_CLASS, DATE_FORMAT(OBJECTS.LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE, OBJECTS_INFO.OI_ALERT AS OI_ALERT, OBJECTS_INFO.OI_STAT1_ICO, OBJECTS_INFO.OI_STAT1_VAL, OBJECTS_INFO.OI_STAT1_TXT1, OBJECTS_INFO.OI_STAT1_TXT2, OBJECTS_INFO.OI_STAT2_ICO, OBJECTS_INFO.OI_STAT2_VAL, OBJECTS_INFO.OI_STAT2_TXT1, OBJECTS_INFO.OI_STAT2_TXT2, OBJECTS_INFO.OI_STAT3_ICO, OBJECTS_INFO.OI_STAT3_VAL, OBJECTS_INFO.OI_STAT3_TXT1, OBJECTS_INFO.OI_STAT3_TXT2, OBJECTS_INFO.OH_NAME1, OBJECTS_INFO.OH_DAYS1, OBJECTS_INFO.OH_HOURS1, OBJECTS_INFO.OH_NAME2, OBJECTS_INFO.OH_DAYS2, OBJECTS_INFO.OH_HOURS2, OBJECTS_INFO.OH_NAME3, OBJECTS_INFO.OH_DAYS3, OBJECTS_INFO.OH_HOURS3, OBJECTS_INFO.OH_NAME4, OBJECTS_INFO.OH_DAYS4, OBJECTS_INFO.OH_HOURS4, OBJECTS_INFO.OH_NAME5, OBJECTS_INFO.OH_DAYS5, OBJECTS_INFO.OH_HOURS5, PAGES1.PAGE_FILE as HTML_FILE, IFNULL(PAGES2.PAGE_FILE,'') as HTML_FILE2 FROM (((((OBJECTS_INFO JOIN OBJECTS ON (OBJECTS_INFO.OBJECT_ID = OBJECTS.ID)) LEFT JOIN OBJECTS_TABS ON (OBJECTS_INFO.OBJECT_ID = OBJECTS_TABS.OBJECT_ID)) LEFT JOIN PAGES ON (PAGES.ID = OBJECTS_TABS.PAGE_ID)) INNER JOIN PAGES PAGES1 ON (OBJECTS_INFO.INFO_PAGES_ID = PAGES1.ID)) LEFT OUTER JOIN PAGES PAGES2 ON (OBJECTS_INFO.INFO_PAGES_ID2 = PAGES2.ID)) WHERE OBJECT_LINK = :link
Parameters:
[ "link" => "/aquasvet" ] |
|
0.07 ms (2.11%) |
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 ] |
|
0.07 ms (2.08%) |
1 |
SELECT ID, FILE_NAME, FILE_EXT, FILE_SIZE, FILE_ICON FROM OBJECTS_FILES WHERE OBJECTS_ID = :id ORDER BY ID
Parameters:
[ "id" => 3 ] |
|
0.06 ms (1.69%) |
1 |
SELECT OBJECTS_CONTACTS.OBJECT_ID AS OBJECT_ID, OBJECTS_CONTACTS.CONTACT_ID AS CONTACT_ID, CONTACTS.FIRST_NAME AS FIRST_NAME, CONTACTS.LAST_NAME AS LAST_NAME, CONTACTS.CONTACT_TITLE AS CONTACT_TITLE, CONTACTS.CONTACT_POSITION AS CONTACT_POSITION, CONTACTS.CONTACT_PHONE AS CONTACT_PHONE, CONTACTS.CONTACT_MOBILE AS CONTACT_MOBILE, CONTACTS.CONTACT_EMAIL AS CONTACT_EMAIL, OBJECTS_CONTACTS.SHOW_IN_INFO AS SHOW_IN_INFO, CONTACTS.CONTACT_IMG AS CONTACT_IMG, DATE_FORMAT(CONTACTS.LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE FROM OBJECTS_CONTACTS INNER JOIN CONTACTS ON OBJECTS_CONTACTS.CONTACT_ID = CONTACTS.ID INNER JOIN OBJECTS ON OBJECTS_CONTACTS.OBJECT_ID = OBJECTS.ID WHERE CONTACTS.CONTACT_ACTIVE = 1 AND OBJECTS.OBJECT_LINK = :link AND OBJECTS_CONTACTS.IN_OBJECT = 1 ORDER BY OBJECTS_CONTACTS.SORT_INDEX, CONTACTS.SORT_INDEX
Parameters:
[ "link" => "/aquasvet" ] |
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.
Entities Mapping
No loaded entities.