Symfony Profiler

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3189171;

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 193;

SELECT
  object_localized_78_de.o_id as o_id,
  object_localized_78_de.o_type as o_type
FROM
  object_localized_78_de
WHERE
  (
    (
      (
        categories LIKE "%,2660,%"
        OR categories LIKE "%,2582,%"
        OR categories LIKE "%,2578,%"
        OR categories LIKE "%,2661,%"
        OR categories LIKE "%,2670,%"
        OR categories LIKE "%,2671,%"
        OR categories LIKE "%,2581,%"
        OR categories LIKE "%,2579,%"
        OR categories LIKE "%,2669,%"
        OR categories LIKE "%,2668,%"
        OR categories LIKE "%,19359564,%"
        OR categories LIKE "%,2577,%"
        OR categories LIKE "%,2576,%"
        OR categories LIKE "%,2574,%"
        OR categories LIKE "%,2575,%"
        OR categories LIKE "%,2573,%"
        OR categories LIKE "%,2822,%"
        OR categories LIKE "%,2831,%"
        OR categories LIKE "%,1221087,%"
        OR categories LIKE "%,1132322,%"
        OR categories LIKE "%,2764,%"
        OR categories LIKE "%,2830,%"
        OR categories LIKE "%,2823,%"
        OR categories LIKE "%,2767,%"
        OR categories LIKE "%,1221088,%"
        OR categories LIKE "%,1221089,%"
        OR categories LIKE "%,2662,%"
        OR categories LIKE "%,2778,%"
        OR categories LIKE "%,2775,%"
        OR categories LIKE "%,2769,%"
        OR categories LIKE "%,2777,%"
        OR categories LIKE "%,2773,%"
        OR categories LIKE "%,2776,%"
        OR categories LIKE "%,2774,%"
        OR categories LIKE "%,2779,%"
        OR categories LIKE "%,2770,%"
        OR categories LIKE "%,2768,%"
        OR categories LIKE "%,2772,%"
        OR categories LIKE "%,2820,%"
        OR categories LIKE "%,2580,%"
        OR categories LIKE "%,2748,%"
        OR categories LIKE "%,2665,%"
        OR categories LIKE "%,2664,%"
      )
    )
    AND (
      o_id IN (
        3625812, 3625822, 5882763, 5882899,
        5947592, 5947613, 5947614, 5947617,
        5947623, 5947625, 5947628, 5947631,
        5947633, 5989193, 5989205, 5989206,
        5989210, 5989211, 5989214, 5989216,
        5989219, 5989219, 5989219, 5989220,
        9480249, 9499514, 9499515, 9499516,
        11250582, 16306177, 19910734, 24494898,
        24495073, 24495130, 24740137, 41323832,
        41323877, 41323892, 43348011, 43348011,
        43348545, 43349153, 47201328, 47935375,
        47935642, 48270258, 48270774, 50770905,
        50771110
      )
    )
    AND object_localized_78_de.o_type IN ('object', 'folder')
  )
  AND object_localized_78_de.o_published = 1
LIMIT
  8

SELECT object_localized_78_de.o_id as o_id, object_localized_78_de.o_type as o_type FROM object_localized_78_de WHERE (((categories LIKE "%,2660,%" OR categories LIKE "%,2582,%" OR categories LIKE "%,2578,%" OR categories LIKE "%,2661,%" OR categories LIKE "%,2670,%" OR categories LIKE "%,2671,%" OR categories LIKE "%,2581,%" OR categories LIKE "%,2579,%" OR categories LIKE "%,2669,%" OR categories LIKE "%,2668,%" OR categories LIKE "%,19359564,%" OR categories LIKE "%,2577,%" OR categories LIKE "%,2576,%" OR categories LIKE "%,2574,%" OR categories LIKE "%,2575,%" OR categories LIKE "%,2573,%" OR categories LIKE "%,2822,%" OR categories LIKE "%,2831,%" OR categories LIKE "%,1221087,%" OR categories LIKE "%,1132322,%" OR categories LIKE "%,2764,%" OR categories LIKE "%,2830,%" OR categories LIKE "%,2823,%" OR categories LIKE "%,2767,%" OR categories LIKE "%,1221088,%" OR categories LIKE "%,1221089,%" OR categories LIKE "%,2662,%" OR categories LIKE "%,2778,%" OR categories LIKE "%,2775,%" OR categories LIKE "%,2769,%" OR categories LIKE "%,2777,%" OR categories LIKE "%,2773,%" OR categories LIKE "%,2776,%" OR categories LIKE "%,2774,%" OR categories LIKE "%,2779,%" OR categories LIKE "%,2770,%" OR categories LIKE "%,2768,%" OR categories LIKE "%,2772,%" OR categories LIKE "%,2820,%" OR categories LIKE "%,2580,%" OR categories LIKE "%,2748,%" OR categories LIKE "%,2665,%" OR categories LIKE "%,2664,%"))  AND (o_id IN (3625812,3625822,5882763,5882899,5947592,5947613,5947614,5947617,5947623,5947625,5947628,5947631,5947633,5989193,5989205,5989206,5989210,5989211,5989214,5989216,5989219,5989219,5989219,5989220,9480249,9499514,9499515,9499516,11250582,16306177,19910734,24494898,24495073,24495130,24740137,41323832,41323877,41323892,43348011,43348011,43348545,43349153,47201328,47935375,47935642,48270258,48270774,50770905,50771110))  AND  object_localized_78_de.o_type IN ('object','folder')) AND object_localized_78_de.o_published = 1 LIMIT 8;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT
  COUNT(*)
FROM
  object_localized_78_de
WHERE
  (
    (
      (
        categories LIKE "%,2660,%"
        OR categories LIKE "%,2582,%"
        OR categories LIKE "%,2578,%"
        OR categories LIKE "%,2661,%"
        OR categories LIKE "%,2670,%"
        OR categories LIKE "%,2671,%"
        OR categories LIKE "%,2581,%"
        OR categories LIKE "%,2579,%"
        OR categories LIKE "%,2669,%"
        OR categories LIKE "%,2668,%"
        OR categories LIKE "%,19359564,%"
        OR categories LIKE "%,2577,%"
        OR categories LIKE "%,2576,%"
        OR categories LIKE "%,2574,%"
        OR categories LIKE "%,2575,%"
        OR categories LIKE "%,2573,%"
        OR categories LIKE "%,2822,%"
        OR categories LIKE "%,2831,%"
        OR categories LIKE "%,1221087,%"
        OR categories LIKE "%,1132322,%"
        OR categories LIKE "%,2764,%"
        OR categories LIKE "%,2830,%"
        OR categories LIKE "%,2823,%"
        OR categories LIKE "%,2767,%"
        OR categories LIKE "%,1221088,%"
        OR categories LIKE "%,1221089,%"
        OR categories LIKE "%,2662,%"
        OR categories LIKE "%,2778,%"
        OR categories LIKE "%,2775,%"
        OR categories LIKE "%,2769,%"
        OR categories LIKE "%,2777,%"
        OR categories LIKE "%,2773,%"
        OR categories LIKE "%,2776,%"
        OR categories LIKE "%,2774,%"
        OR categories LIKE "%,2779,%"
        OR categories LIKE "%,2770,%"
        OR categories LIKE "%,2768,%"
        OR categories LIKE "%,2772,%"
        OR categories LIKE "%,2820,%"
        OR categories LIKE "%,2580,%"
        OR categories LIKE "%,2748,%"
        OR categories LIKE "%,2665,%"
        OR categories LIKE "%,2664,%"
      )
    )
    AND (
      o_id IN (
        3625812, 3625822, 5882763, 5882899,
        5947592, 5947613, 5947614, 5947617,
        5947623, 5947625, 5947628, 5947631,
        5947633, 5989193, 5989205, 5989206,
        5989210, 5989211, 5989214, 5989216,
        5989219, 5989219, 5989219, 5989220,
        9480249, 9499514, 9499515, 9499516,
        11250582, 16306177, 19910734, 24494898,
        24495073, 24495130, 24740137, 41323832,
        41323877, 41323892, 43348011, 43348011,
        43348545, 43349153, 47201328, 47935375,
        47935642, 48270258, 48270774, 50770905,
        50771110
      )
    )
    AND object_localized_78_de.o_type IN ('object', 'folder')
  )
  AND object_localized_78_de.o_published = 1

SELECT COUNT(*) FROM object_localized_78_de WHERE (((categories LIKE "%,2660,%" OR categories LIKE "%,2582,%" OR categories LIKE "%,2578,%" OR categories LIKE "%,2661,%" OR categories LIKE "%,2670,%" OR categories LIKE "%,2671,%" OR categories LIKE "%,2581,%" OR categories LIKE "%,2579,%" OR categories LIKE "%,2669,%" OR categories LIKE "%,2668,%" OR categories LIKE "%,19359564,%" OR categories LIKE "%,2577,%" OR categories LIKE "%,2576,%" OR categories LIKE "%,2574,%" OR categories LIKE "%,2575,%" OR categories LIKE "%,2573,%" OR categories LIKE "%,2822,%" OR categories LIKE "%,2831,%" OR categories LIKE "%,1221087,%" OR categories LIKE "%,1132322,%" OR categories LIKE "%,2764,%" OR categories LIKE "%,2830,%" OR categories LIKE "%,2823,%" OR categories LIKE "%,2767,%" OR categories LIKE "%,1221088,%" OR categories LIKE "%,1221089,%" OR categories LIKE "%,2662,%" OR categories LIKE "%,2778,%" OR categories LIKE "%,2775,%" OR categories LIKE "%,2769,%" OR categories LIKE "%,2777,%" OR categories LIKE "%,2773,%" OR categories LIKE "%,2776,%" OR categories LIKE "%,2774,%" OR categories LIKE "%,2779,%" OR categories LIKE "%,2770,%" OR categories LIKE "%,2768,%" OR categories LIKE "%,2772,%" OR categories LIKE "%,2820,%" OR categories LIKE "%,2580,%" OR categories LIKE "%,2748,%" OR categories LIKE "%,2665,%" OR categories LIKE "%,2664,%"))  AND (o_id IN (3625812,3625822,5882763,5882899,5947592,5947613,5947614,5947617,5947623,5947625,5947628,5947631,5947633,5989193,5989205,5989206,5989210,5989211,5989214,5989216,5989219,5989219,5989219,5989220,9480249,9499514,9499515,9499516,11250582,16306177,19910734,24494898,24495073,24495130,24740137,41323832,41323877,41323892,43348011,43348011,43348545,43349153,47201328,47935375,47935642,48270258,48270774,50770905,50771110))  AND  object_localized_78_de.o_type IN ('object','folder')) AND object_localized_78_de.o_published = 1;

SELECT
  object_localized_PackageCategory_de.o_id as o_id,
  object_localized_PackageCategory_de.o_type as o_type
FROM
  object_localized_PackageCategory_de
WHERE
  (
    (
      o_id IN (:ids)
    )
    AND (name != '')
    AND object_localized_PackageCategory_de.o_type IN ('object', 'folder')
  )
  AND object_localized_PackageCategory_de.o_published = 1
ORDER BY
  `name`

SELECT object_localized_PackageCategory_de.o_id as o_id, object_localized_PackageCategory_de.o_type as o_type FROM object_localized_PackageCategory_de WHERE ((o_id IN (2660, 2582, 2578, 2661, 2670, 2671, 2581, 2579, 2669, 2668, 19359564, 2577, 2576, 2574, 2575, 2573, 2822, 2831, 1221087, 1132322, 2764, 2830, 2823, 2767, 1221088, 1221089, 2662, 2778, 2775, 2769, 2777, 2773, 2776, 2774, 2779, 2770, 2768, 2772, 2820, 2580, 2748, 2665, 2664))  AND (name != '' )  AND  object_localized_PackageCategory_de.o_type IN ('object','folder')) AND object_localized_PackageCategory_de.o_published = 1 ORDER BY `name`   ;

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Urlaub-planen/Pauschalen/' AND `key` = BINARY 'Steiermark-Reisebuero-Top-Angebote';

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'defaultSiteConfig'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;

SELECT
  object_localized_Region_de.o_id as o_id,
  object_localized_Region_de.o_type as o_type
FROM
  object_localized_Region_de
WHERE
  (
    object_localized_Region_de.o_type IN ('object', 'folder')
  )
  AND object_localized_Region_de.o_published = 1

SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ( object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1;

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote';

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    (
      o_path LIKE "/Packages/PackageCategories/touristik/%"
    )
    AND (o_className = "packageCategory")
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ((o_path LIKE "/Packages/PackageCategories/touristik/%") AND (o_className = "packageCategory") AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT
  o_id
FROM
  object_collection_PackagePeriod_78
WHERE
  endDate >= 1732650972

SELECT o_id FROM object_collection_PackagePeriod_78 WHERE endDate >= 1732650972;

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 193;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(193, 193) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 193;

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId = ?
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId = 4312 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 4312;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Pauschalen/Steiermark-Reisebuero-Top-Angebote' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;