Query Metrics
212
Database Queries
23
Different statements
493.95 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
309.19 ms (62.60%) |
84 |
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:
[ 1774399501 "site_domain_e19013cb161706785ddee46d4210cfcb" ] |
|
64.23 ms (13.00%) |
13 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5931
]
|
|
42.52 ms (8.61%) |
38 |
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:
[ 1774399501 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
30.85 ms (6.25%) |
7 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5931
]
|
|
10.71 ms (2.17%) |
20 |
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:
[ 1774399501 "object_12941\x01tags\x01" "class_5\x01tags\x01" "asset_9327\x01tags\x01" "asset_9328\x01tags\x01" ] |
|
7.81 ms (1.58%) |
1 |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE ( object_14.type IN ('object','variant','folder')) AND object_14.published = 1 ORDER BY `name` ASC
Parameters:
[] |
|
6.66 ms (1.35%) |
3 |
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:
[ 1774399501 "object_10930\x01tags\x01" "class_5\x01tags\x01" "asset_9240\x01tags\x01" "asset_9242\x01tags\x01" "asset_9241\x01tags\x01" "asset_9239\x01tags\x01" "asset_9243\x01tags\x01" "asset_9236\x01tags\x01" "asset_9237\x01tags\x01" "asset_9244\x01tags\x01" ] |
|
6.22 ms (1.26%) |
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:
[ 1774399501 "object_10940\x01tags\x01" "class_5\x01tags\x01" "asset_8115\x01tags\x01" "asset_8113\x01tags\x01" "asset_8114\x01tags\x01" ] |
|
3.94 ms (0.80%) |
4 |
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[ "a:6:{s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:2500;s:11:"imageHeight";i:3125;s:16:"embeddedMetaData";a:120:{s:8:"FileSize";s:6:"4.2 MB";s:14:"FileModifyDate";s:25:"2021:12:03 22:25:17+01:00";s:14:"FileAccessDate";s:25:"2021:12:08 06:58:51+01:00";s:19:"FileInodeChangeDate";s:25:"2021:12:07 17:22:43+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:5:"Apple";s:5:"Model";s:8:"iPhone 5";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:9:"Instagram";s:10:"ModifyDate";s:19:"2021:12:03 22:22:34";s:12:"ExposureTime";s:4:"1/60";s:7:"FNumber";d:2.4;s:15:"ExposureProgram";s:10:"Program AE";s:3:"ISO";i:50;s:11:"ExifVersion";s:4:"0221";s:16:"DateTimeOriginal";s:19:"2018:03:03 16:29:08";s:23:"ComponentsConfiguration";s:12:"Y, Cb, Cr, -";s:17:"ShutterSpeedValue";s:4:"1/60";s:13:"ApertureValue";d:2.4;s:15:"BrightnessValue";d:4.915820029;s:20:"ExposureCompensation";i:0;s:12:"MeteringMode";s:13:"Multi-segment";s:5:"Flash";s:17:"Off, Did not fire";s:11:"FocalLength";s:6:"4.1 mm";s:18:"SubSecTimeOriginal";i:915;s:10:"ColorSpace";s:4:"sRGB";s:14:"ExifImageWidth";i:2500;s:15:"ExifImageHeight";i:3125;s:13:"SensingMethod";s:19:"One-chip color area";s:9:"SceneType";s:21:"Directly photographed";s:12:"ExposureMode";s:4:"Auto";s:12:"WhiteBalance";s:4:"Auto";s:23:"FocalLengthIn35mmFormat";s:5:"33 mm";s:16:"SceneCaptureType";s:8:"Standard";s:8:"LensMake";s:5:"Apple";s:9:"LensModel";s:33:"iPhone 5 back camera 4.12mm f/2.4";s:14:"GPSLatitudeRef";s:5:"North";s:15:"GPSLongitudeRef";s:4:"East";s:11:"GPSAltitude";s:12:"51.8196002 m";s:12:"GPSTimeStamp";s:8:"01:00:38";s:6:"GPSDOP";i:65;s:12:"GPSDateStamp";s:10:"2018:03:07";s:10:"XMPToolkit";s:14:"XMP Core 5.5.0";s:6:"Format";s:10:"image/jpeg";s:23:"PhotographicSensitivity";i:50;s:9:"ColorMode";s:3:"RGB";s:14:"ICCProfileName";s:17:"sRGB IEC61966-2.1";s:10:"CreateDate";s:19:"2018:03:03 16:29:08";s:11:"CreatorTool";s:9:"Instagram";s:12:"MetadataDate";s:25:"2021:12:03 22:22:34+01:00";s:10:"DocumentID";s:40:"xmp.did:05801174072068119109CD0B7FCCB955";s:10:"InstanceID";s:40:"xmp.iid:06801174072068119109CD0B7FCCB955";s:18:"OriginalDocumentID";s:40:"xmp.did:05801174072068119109CD0B7FCCB955";s:4:"Lens";s:33:"iPhone 5 back camera 4.12mm f/2.4";s:13:"HistoryAction";s:26:"created | saved | produced";s:17:"HistoryInstanceID";s:83:"xmp.iid:05801174072068119109CD0B7FCCB955 | xmp.iid:06801174072068119109CD0B7FCCB955";s:20:"HistorySoftwareAgent";s:85:"Adobe Photoshop CS4 Macintosh | Adobe Photoshop CS4 Macintosh | Affinity Photo 1.10.4";s:11:"HistoryWhen";s:81:"2018:09:23 18:50:25+02:00 | 2018:09:23 18:50:25+02:00 | 2021:12:03 22:22:34+01:00";s:14:"HistoryChanged";s:1:"/";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:03 21:21:11";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:3125;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.4;s:9:"ImageSize";s:9:"2500x3125";s:10:"Megapixels";d:7.8;s:16:"ScaleFactor35efl";d:8;s:12:"ShutterSpeed";s:4:"1/60";s:22:"SubSecDateTimeOriginal";s:23:"2018:03:03 16:29:08.915";s:11:"GPSDateTime";s:20:"2018:03:07 01:00:38Z";s:11:"GPSLatitude";s:19:"52 deg 30' 48.95" N";s:12:"GPSLongitude";s:19:"13 deg 33' 18.20" E";s:17:"CircleOfConfusion";s:8:"0.004 mm";s:3:"FOV";s:8:"57.2 deg";s:16:"FocalLength35efl";s:34:"4.1 mm (35 mm equivalent: 33.0 mm)";s:11:"GPSPosition";s:40:"52 deg 30' 48.95" N, 13 deg 33' 18.20" E";s:18:"HyperfocalDistance";s:6:"1.88 m";s:10:"LightValue";d:9.4;}s:25:"embeddedMetaDataExtracted";b:1;s:8:"checksum";s:32:"0c073c0496915fc4e3270914aeca1a22";}" 8126 ] |
|
2.70 ms (0.55%) |
3 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
2.41 ms (0.49%) |
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:
[ 1774399501 "object_10920\x01tags\x01" "class_5\x01tags\x01" "asset_8139\x01tags\x01" "asset_8140\x01tags\x01" "asset_8141\x01tags\x01" "asset_8142\x01tags\x01" ] |
|
1.97 ms (0.40%) |
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:
[ "/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-godzilla-crack~w10924" "path" "auto_create" "/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-godzilla-crack~w10924" "path_query" "https://dev.bernhardknaus.com/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-godzilla-crack~w10924" "entire_uri" ] |
|
1.29 ms (0.26%) |
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:
[ 1774399501 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.75 ms (0.15%) |
7 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/" "marten-schech-godzilla-crack~w10924" ] |
|
0.75 ms (0.15%) |
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:
[ 1774399501 "object_10924\x01tags\x01" "class_5\x01tags\x01" "asset_8127\x01tags\x01" "asset_8126\x01tags\x01" "asset_8128\x01tags\x01" "asset_8129\x01tags\x01" "asset_8130\x01tags\x01" ] |
|
0.54 ms (0.11%) |
6 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-godzilla-crack~w10924"
]
|
|
0.29 ms (0.06%) |
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 ] |
|
0.26 ms (0.05%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"5"
]
|
|
0.24 ms (0.05%) |
2 |
SELECT object_localized_5_en.id as id, object_localized_5_en.type as `type` FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'work' AND preview = 1 AND published IS true AND artist__id = 493 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1 ORDER BY `priority` ASC, `workDateEnd` DESC, `workDate` DESC
Parameters:
[] |
|
0.23 ms (0.05%) |
1 |
SELECT * FROM object_relations_5 WHERE src_id = ?
Parameters:
[
10924
]
|
|
0.18 ms (0.04%) |
3 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
9
]
|
|
0.12 ms (0.02%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.08 ms (0.02%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
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.