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

SELECT
  CONTACTS.FIRST_NAME,
  CONTACTS.LAST_NAME,
  CONTACTS.CONTACT_TITLE,
  CONTACTS.CONTACT_POSITION,
  CONTACTS.CONTACT_MOBILE,
  CONTACTS.CONTACT_PHONE,
  CONTACTS.CONTACT_EMAIL,
  CONTACTS.CONTACT_IMG,
  CONTACTS.SORT_INDEX,
  DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE
FROM
  CONTACTS
WHERE
  CONTACT_ACTIVE = 1
  AND CONTACT_MAIN = 1
  AND CONTACT_GLOBAL = 1
ORDER BY
  SORT_INDEX

SELECT CONTACTS.FIRST_NAME,
                        CONTACTS.LAST_NAME,
                        CONTACTS.CONTACT_TITLE,
		                CONTACTS.CONTACT_POSITION,
					    CONTACTS.CONTACT_MOBILE,
					    CONTACTS.CONTACT_PHONE,
					    CONTACTS.CONTACT_EMAIL,
					    CONTACTS.CONTACT_IMG,
					    CONTACTS.SORT_INDEX,
                        DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE 
                      FROM CONTACTS 
                      WHERE CONTACT_ACTIVE = 1 AND CONTACT_MAIN = 1 AND CONTACT_GLOBAL = 1 
                      ORDER BY SORT_INDEX;

SELECT
  CONTACTS.FIRST_NAME,
  CONTACTS.LAST_NAME,
  CONTACTS.CONTACT_TITLE,
  CONTACTS.CONTACT_POSITION,
  CONTACTS.CONTACT_MOBILE,
  CONTACTS.CONTACT_PHONE,
  CONTACTS.CONTACT_EMAIL,
  CONTACTS.CONTACT_IMG,
  CONTACTS.SORT_INDEX,
  DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE
FROM
  CONTACTS
WHERE
  ID NOT IN (
    SELECT
      CONTACT_ID
    FROM
      OBJECTS_CONTACTS
    GROUP BY
      CONTACT_ID
  )
  AND CONTACTS.CONTACT_ACTIVE = 1
  AND CONTACTS.CONTACT_MAIN = 0
  AND CONTACTS.CONTACT_GLOBAL = 1
ORDER BY
  CONTACTS.SORT_INDEX ASC

SELECT CONTACTS.FIRST_NAME,
                        CONTACTS.LAST_NAME,
                        CONTACTS.CONTACT_TITLE,
		                CONTACTS.CONTACT_POSITION,
					    CONTACTS.CONTACT_MOBILE,
					    CONTACTS.CONTACT_PHONE,
					    CONTACTS.CONTACT_EMAIL,
					    CONTACTS.CONTACT_IMG,
					    CONTACTS.SORT_INDEX,
                        DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE 
					FROM CONTACTS
					WHERE ID NOT IN (SELECT CONTACT_ID FROM OBJECTS_CONTACTS GROUP BY CONTACT_ID) AND CONTACTS.CONTACT_ACTIVE = 1 AND CONTACTS.CONTACT_MAIN = 0 AND CONTACTS.CONTACT_GLOBAL = 1
					ORDER BY CONTACTS.SORT_INDEX ASC;

SELECT
  OBJECTS_CONTACTS.OBJECT_ID,
  CONTACTS.FIRST_NAME,
  CONTACTS.LAST_NAME,
  CONTACTS.CONTACT_TITLE,
  CONTACTS.CONTACT_POSITION,
  CONTACTS.CONTACT_MOBILE,
  CONTACTS.CONTACT_PHONE,
  CONTACTS.CONTACT_EMAIL,
  CONTACTS.CONTACT_IMG,
  OBJECTS.OBJECT_NAME,
  OBJECTS.OBJECT_LINK,
  OBJECTS.OBJECT_IMG_SMALL,
  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 CONTACTS.CONTACT_MAIN = 0
  AND OBJECTS_CONTACTS.IN_CONTACTS = 1
ORDER BY
  OBJECTS.SORT_INDEX,
  OBJECTS_CONTACTS.SORT_INDEX_CONTACT

SELECT
                      OBJECTS_CONTACTS.OBJECT_ID,
                      CONTACTS.FIRST_NAME,
                      CONTACTS.LAST_NAME,
                      CONTACTS.CONTACT_TITLE,
                      CONTACTS.CONTACT_POSITION,
                      CONTACTS.CONTACT_MOBILE,
                      CONTACTS.CONTACT_PHONE,
                      CONTACTS.CONTACT_EMAIL,
                      CONTACTS.CONTACT_IMG,
                      OBJECTS.OBJECT_NAME,
                      OBJECTS.OBJECT_LINK,
                      OBJECTS.OBJECT_IMG_SMALL,
                      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 CONTACTS.CONTACT_MAIN = 0
                    AND OBJECTS_CONTACTS.IN_CONTACTS = 1
                    ORDER BY OBJECTS.SORT_INDEX, OBJECTS_CONTACTS.SORT_INDEX_CONTACT;