GET https://dev.bernhardknaus.com/formNewsletterOrder

Query Metrics

336 Database Queries
40 Different statements
294.58 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
48.59 ms
(16.49%)
88
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1774387882
  "site_domain_e19013cb161706785ddee46d4210cfcb"
]
29.02 ms
(9.85%)
2
SELECT COUNT(*) FROM (SELECT object_localized_5_de.id FROM object_localized_5_de WHERE (isDevItem IS false
            AND workType = 'architecture'
            AND workgroup__id > 0  AND published IS true AND artist__id = 579 AND  object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1 GROUP BY `workgroup__id`) XYZ
Parameters:
[]
18.78 ms
(6.38%)
10
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5931
]
17.92 ms
(6.08%)
34
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  4362
]
16.52 ms
(5.61%)
2
SELECT COUNT(*) FROM (SELECT object_localized_5_de.id FROM object_localized_5_de WHERE (isDevItem IS false
            AND workType = 'edition'
            AND workgroup__id > 0  AND published IS true AND artist__id = 579 AND  object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1 GROUP BY `workgroup__id`) XYZ
Parameters:
[]
13.12 ms
(4.45%)
1
SELECT COUNT(*) FROM object_localized_5_de WHERE (isDevItem IS false
            AND workType = 'work'  AND published IS true AND artist__id = 579 AND  object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[]
12.15 ms
(4.12%)
1
SELECT COUNT(*) FROM object_localized_3_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,579,%' AND  object_localized_3_de.type IN ('object','variant','folder')) AND object_localized_3_de.published = 1
Parameters:
[]
11.22 ms
(3.81%)
18
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
10.59 ms
(3.60%)
10
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5931
]
9.59 ms
(3.26%)
7
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[
  "a:6:{s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:2500;s:11:"imageHeight";i:1451;s:16:"embeddedMetaData";a:101:{s:8:"FileSize";s:6:"2.8 MB";s:14:"FileModifyDate";s:25:"2021:12:14 14:54:52+01:00";s:14:"FileAccessDate";s:25:"2021:12:17 16:14:55+01:00";s:19:"FileInodeChangeDate";s:25:"2021:12:17 15:54:59+01:00";s:15:"FilePermissions";s:9:"rw-r--r--";s:8:"FileType";s:4:"JPEG";s:17:"FileTypeExtension";s:3:"jpg";s:8:"MIMEType";s:10:"image/jpeg";s:11:"JFIFVersion";d:1.01;s:13:"ExifByteOrder";s:25:"Big-endian (Motorola, MM)";s:4:"Make";s:7:"samsung";s:5:"Model";s:8:"SM-G850F";s:11:"Orientation";s:19:"Horizontal (normal)";s:11:"XResolution";i:72;s:11:"YResolution";i:72;s:14:"ResolutionUnit";s:6:"inches";s:8:"Software";s:13:"G850FXXU2COI3";s:10:"ModifyDate";s:19:"2021:12:06 18:34:49";s:12:"ExposureTime";s:4:"1/33";s:7:"FNumber";d:2.2;s:15:"ExposureProgram";s:10:"Program AE";s:3:"ISO";i:40;s:11:"ExifVersion";s:4:"0220";s:16:"DateTimeOriginal";s:19:"2016:05:18 15:36:05";s:17:"ShutterSpeedValue";s:4:"1/33";s:13:"ApertureValue";d:2.2;s:15:"BrightnessValue";d:3.22;s:20:"ExposureCompensation";i:0;s:16:"MaxApertureValue";d:2.2;s:12:"MeteringMode";s:13:"Multi-segment";s:5:"Flash";s:8:"No Flash";s:11:"FocalLength";s:6:"4.1 mm";s:11:"UserComment";s:0:"";s:18:"SubSecTimeOriginal";i:889;s:10:"ColorSpace";s:4:"sRGB";s:14:"ExifImageWidth";i:2500;s:15:"ExifImageHeight";i:1451;s:12:"ExposureMode";s:4:"Auto";s:12:"WhiteBalance";s:4:"Auto";s:23:"FocalLengthIn35mmFormat";s:5:"31 mm";s:16:"SceneCaptureType";s:8:"Standard";s:13:"ImageUniqueID";s:23:"G16LLHA00SM G16LLHG11SM";s:10:"XMPToolkit";s:14:"XMP Core 5.5.0";s:10:"CreateDate";s:19:"2016:05:18 15:36:05";s:11:"CreatorTool";s:13:"G850FXXU2COI3";s:12:"MetadataDate";s:25:"2021:12:06 18:34:49+01:00";s:9:"ColorMode";s:3:"RGB";s:14:"ICCProfileName";s:17:"sRGB IEC61966-2.1";s:23:"PhotographicSensitivity";i:40;s:13:"HistoryAction";s:8:"produced";s:20:"HistorySoftwareAgent";s:21:"Affinity Photo 1.10.4";s:11:"HistoryWhen";s:25:"2021:12:06 18:34:49+01:00";s:10:"IPTCDigest";s:32:"d41d8cd98f00b204e9800998ecf8427e";s:14:"ProfileCMMType";s:10:"Little CMS";s:14:"ProfileVersion";s:5:"4.3.0";s:12:"ProfileClass";s:22:"Display Device Profile";s:14:"ColorSpaceData";s:4:"RGB ";s:22:"ProfileConnectionSpace";s:4:"XYZ ";s:15:"ProfileDateTime";s:19:"2021:12:06 17:00:48";s:20:"ProfileFileSignature";s:4:"acsp";s:15:"PrimaryPlatform";s:21:"Microsoft Corporation";s:8:"CMMFlags";s:25:"Not Embedded, Independent";s:18:"DeviceManufacturer";s:0:"";s:11:"DeviceModel";s:0:"";s:16:"DeviceAttributes";s:35:"Reflective, Glossy, Positive, Color";s:15:"RenderingIntent";s:10:"Perceptual";s:25:"ConnectionSpaceIlluminant";s:16:"0.9642 1 0.82491";s:14:"ProfileCreator";s:10:"Little CMS";s:9:"ProfileID";i:0;s:18:"ProfileDescription";s:17:"sRGB IEC61966-2.1";s:16:"ProfileCopyright";s:24:"No copyright, use freely";s:15:"MediaWhitePoint";s:16:"0.9642 1 0.82491";s:19:"ChromaticAdaptation";s:74:"1.04788 0.02292 -0.05022 0.02959 0.99048 -0.01707 -0.00925 0.01508 0.75168";s:15:"RedMatrixColumn";s:23:"0.43604 0.22249 0.01392";s:16:"BlueMatrixColumn";s:23:"0.14305 0.06061 0.71391";s:17:"GreenMatrixColumn";s:22:"0.38512 0.7169 0.09706";s:6:"RedTRC";s:48:"(Binary data 32 bytes, use -b option to extract)";s:8:"GreenTRC";s:48:"(Binary data 32 bytes, use -b option to extract)";s:7:"BlueTRC";s:48:"(Binary data 32 bytes, use -b option to extract)";s:20:"ChromaticityChannels";i:3;s:20:"ChromaticityColorant";s:11:"Unknown (0)";s:20:"ChromaticityChannel1";s:9:"0.64 0.33";s:20:"ChromaticityChannel2";s:11:"0.3 0.60001";s:20:"ChromaticityChannel3";s:12:"0.14999 0.06";s:10:"ImageWidth";i:2500;s:11:"ImageHeight";i:1451;s:15:"EncodingProcess";s:28:"Baseline DCT, Huffman coding";s:13:"BitsPerSample";i:8;s:15:"ColorComponents";i:3;s:16:"YCbCrSubSampling";s:16:"YCbCr4:4:4 (1 1)";s:8:"Aperture";d:2.2;s:9:"ImageSize";s:9:"2500x1451";s:10:"Megapixels";d:3.6;s:16:"ScaleFactor35efl";d:7.6;s:12:"ShutterSpeed";s:4:"1/33";s:22:"SubSecDateTimeOriginal";s:23:"2016:05:18 15:36:05.889";s:17:"CircleOfConfusion";s:8:"0.004 mm";s:3:"FOV";s:8:"60.3 deg";s:16:"FocalLength35efl";s:34:"4.1 mm (35 mm equivalent: 31.0 mm)";s:18:"HyperfocalDistance";s:6:"1.92 m";s:10:"LightValue";d:8.6;}s:25:"embeddedMetaDataExtracted";b:1;s:8:"checksum";s:32:"67e090cc9ab2ba54a41aad705d0ba547";}"
  8342
]
8.99 ms
(3.05%)
3
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "1"
]
8.97 ms
(3.05%)
1
SELECT COUNT(*) FROM object_localized_4_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,579,%' AND  object_localized_4_de.type IN ('object','variant','folder')) AND object_localized_4_de.published = 1
Parameters:
[]
7.78 ms
(2.64%)
14
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  12236
]
7.59 ms
(2.58%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1774387882
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_3\x01tags\x01"
  "document_4\x01tags\x01"
  "document_110\x01tags\x01"
  "document_19\x01tags\x01"
  "document_116\x01tags\x01"
  "document_77\x01tags\x01"
  "document_21\x01tags\x01"
  "document_22\x01tags\x01"
  "document_23\x01tags\x01"
  "document_78\x01tags\x01"
  "document_24\x01tags\x01"
  "document_25\x01tags\x01"
  "document_107\x01tags\x01"
  "document_74\x01tags\x01"
  "document_83\x01tags\x01"
  "document_82\x01tags\x01"
  "document_73\x01tags\x01"
  "document_26\x01tags\x01"
  "document_27\x01tags\x01"
  "document_88\x01tags\x01"
  "document_90\x01tags\x01"
  "document_91\x01tags\x01"
  "document_121\x01tags\x01"
]
6.27 ms
(2.13%)
3
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
Parameters:
[
  "urlHost"
  null
  null
]
6.20 ms
(2.11%)
4
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1774387882
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
6.07 ms
(2.06%)
34
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  4362
]
5.70 ms
(1.93%)
4
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1774387882
  "system\x01tags\x01"
  "site\x01tags\x01"
]
5.45 ms
(1.85%)
14
SELECT * FROM object_localized_data_5 WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
  12236
]
5.17 ms
(1.76%)
3
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/de/kuenstler/karim-noureldin~a579/ausstellungen/karim-noureldin-oreo~e9419"
]
5.06 ms
(1.72%)
4
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/de/kuenstler/karim-noureldin~a579/ausstellungen/"
  "karim-noureldin-oreo~e9419"
]
4.85 ms
(1.64%)
1
SELECT COUNT(*) FROM object_localized_5_de WHERE (isDevItem IS false
            AND workType = 'edition'
            AND workgroup__id IS NULL  AND published IS true AND artist__id = 579 AND  object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[]
4.80 ms
(1.63%)
1
SELECT COUNT(*) FROM object_localized_5_de INNER JOIN object_1 artist ON object_localized_5_de.artist__id = artist.oo_id AND object_localized_5_de.isDevItem IS false AND (artist.status = 'artist' OR artist.status = 'guest' OR artist.oo_id = 579 ) AND workType = 'architecture'  AND object_localized_5_de.published IS true AND artist__id = 579 WHERE ( object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[]
4.62 ms
(1.57%)
1
SELECT COUNT(*) FROM object_localized_5_de INNER JOIN object_1 artist ON object_localized_5_de.artist__id = artist.oo_id AND object_localized_5_de.isDevItem IS false AND (artist.status = 'artist' OR artist.status = 'guest' OR artist.status = 'exMarketingEdition'  OR artist.oo_id = 579 ) AND workType = 'edition'  AND object_localized_5_de.published IS true AND artist__id = 579 WHERE ( object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[]
4.48 ms
(1.52%)
1
SELECT COUNT(*) FROM object_localized_5_de WHERE (isDevItem IS false
            AND workType = 'architecture'
            AND workgroup__id IS NULL  AND published IS true AND artist__id = 579 AND  object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[]
3.00 ms
(1.02%)
14
SELECT * FROM object_relations_5 WHERE src_id = ?
Parameters:
[
  12236
]
2.75 ms
(0.93%)
14
SELECT * FROM object_store_5 WHERE oo_id = ? FOR UPDATE
Parameters:
[
  12236
]
2.20 ms
(0.75%)
14
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  12236
]
1.97 ms
(0.67%)
3
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/de/kuenstler/karim-noureldin~a579/ausstellungen/karim-noureldin-oreo~e9419"
  "path"
  "auto_create"
  "/de/kuenstler/karim-noureldin~a579/ausstellungen/karim-noureldin-oreo~e9419"
  "path_query"
  "https://dev.bernhardknaus.com/de/kuenstler/karim-noureldin~a579/ausstellungen/karim-noureldin-oreo~e9419"
  "entire_uri"
]
1.19 ms
(0.40%)
2
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1774387882
  "object_9419\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_8341\x01tags\x01"
  "asset_8342\x01tags\x01"
  "asset_8343\x01tags\x01"
  "asset_8344\x01tags\x01"
  "asset_8345\x01tags\x01"
  "asset_8346\x01tags\x01"
  "asset_8347\x01tags\x01"
  "asset_8348\x01tags\x01"
]
0.90 ms
(0.30%)
16
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
0.75 ms
(0.25%)
1
SELECT COUNT(*) FROM object_localized_11_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,579,%' AND  object_localized_11_de.type IN ('object','variant','folder')) AND object_localized_11_de.published = 1
Parameters:
[]
0.66 ms
(0.22%)
1
SELECT COUNT(*) FROM object_localized_2_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,579,%' AND  object_localized_2_de.type IN ('object','variant','folder')) AND object_localized_2_de.published = 1
Parameters:
[]
0.60 ms
(0.20%)
1
SELECT COUNT(*) FROM object_localized_12_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,579,%' AND  object_localized_12_de.type IN ('object','variant','folder')) AND object_localized_12_de.published = 1
Parameters:
[]
0.29 ms
(0.10%)
1
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
  9419
]
0.22 ms
(0.08%)
1
SELECT * FROM object_collection_multiLinks_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  9419
  "links"
]
0.17 ms
(0.06%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[
  1774387882
  "object_10976\x01tags\x01"
  "class_5\x01tags\x01"
  "asset_4387\x01tags\x01"
  "asset_4386\x01tags\x01"
]
0.15 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.15 ms
(0.05%)
3
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  9
]
0.10 ms
(0.04%)
1
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  8
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.