Symfony Profiler

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='/hriste/fotogalerie');

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

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 = '/hriste';

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 = 20
                                                    LIMIT 0, 1;

SELECT
  ID,
  FILE_NAME,
  FILE_EXT,
  FILE_SIZE,
  FILE_ICON
FROM
  OBJECTS_FILES
WHERE
  OBJECTS_ID = :id
ORDER BY
  ID

SELECT
                                                         ID,
                                                         FILE_NAME,
                                                         FILE_EXT,
                                                         FILE_SIZE,
                                                         FILE_ICON
                                                    FROM OBJECTS_FILES                                            
                                                    WHERE OBJECTS_ID = 20
                                                    ORDER BY ID;

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

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 = '/hriste' AND OBJECTS_CONTACTS.IN_OBJECT = 1
                                                    ORDER BY OBJECTS_CONTACTS.SORT_INDEX, CONTACTS.SORT_INDEX
                                                           ;