Query Metrics
215
Database Queries
24
Different statements
34.22 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.67 ms (39.96%) |
86 |
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:
[ 1774399515 "site_domain_e19013cb161706785ddee46d4210cfcb" ] |
|
5.60 ms (16.37%) |
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:
[ 1774399515 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
2.52 ms (7.37%) |
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:
[ 1774399516 "object_12941\x01tags\x01" "class_5\x01tags\x01" "asset_9327\x01tags\x01" "asset_9328\x01tags\x01" ] |
|
2.42 ms (7.08%) |
6 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5931
]
|
|
2.04 ms (5.95%) |
3 |
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[ "a:6:{s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:2500;s:11:"imageHeight";i:3760;s:16:"embeddedMetaData";a:195:{s:8:"FileSize";s:6:"5.2 MB";s:14:"FileModifyDate";s:25:"2021:12:03 22:34:04+01:00";s:14:"FileAccessDate";s:25:"2021:12:08 07:17:28+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:17:"NIKON CORPORATION";s:5:"Model";s:11:"NIKON D3200";s:11:"Orientation";s:19:"Horizontal (normal)";s:11:"XResolution";i:300;s:11:"YResolution";i:300;s:14:"ResolutionUnit";s:6:"inches";s:8:"Software";s:8:"Ver.1.00";s:10:"ModifyDate";s:19:"2019:05:10 16:30:20";s:16:"YCbCrPositioning";s:8:"Co-sited";s:12:"ExposureTime";s:5:"1/125";s:7:"FNumber";d:5.6;s:15:"ExposureProgram";s:11:"Not Defined";s:3:"ISO";i:400;s:15:"SensitivityType";s:26:"Recommended Exposure Index";s:11:"ExifVersion";s:4:"0230";s:16:"DateTimeOriginal";s:19:"2019:05:10 16:30:20";s:10:"CreateDate";s:19:"2019:05:10 16:30:20";s:23:"ComponentsConfiguration";s:12:"Y, Cb, Cr, -";s:22:"CompressedBitsPerPixel";i:4;s:20:"ExposureCompensation";i:0;s:16:"MaxApertureValue";d:3.5;s:12:"MeteringMode";s:13:"Multi-segment";s:11:"LightSource";s:7:"Unknown";s:5:"Flash";s:17:"Off, Did not fire";s:11:"FocalLength";s:7:"18.0 mm";s:16:"MakerNoteVersion";d:2.1;s:7:"Quality";s:4:"Fine";s:12:"WhiteBalance";s:4:"Auto";s:9:"FocusMode";s:4:"AF-A";s:12:"FlashSetting";s:0:"";s:9:"FlashType";s:0:"";s:20:"WhiteBalanceFineTune";s:3:"0 0";s:11:"WB_RBLevels";s:23:"1.95703125 1.234375 1 1";s:12:"ProgramShift";i:0;s:18:"ExposureDifference";i:0;s:11:"Compression";s:16:"JPEG (old-style)";s:17:"PreviewImageStart";i:13974;s:18:"PreviewImageLength";i:25153;s:17:"FlashExposureComp";i:0;s:10:"ISOSetting";i:400;s:13:"ImageBoundary";s:13:"0 0 6016 4000";s:25:"ExternalFlashExposureComp";i:0;s:25:"FlashExposureBracketValue";d:0;s:20:"ExposureBracketValue";i:0;s:11:"CropHiSpeed";s:49:"Off (6080x4012 cropped to 6080x4012 at pixel 0,0)";s:14:"ExposureTuning";i:0;s:12:"SerialNumber";i:6275456;s:13:"VRInfoVersion";s:4:"0100";s:18:"VibrationReduction";s:3:"Off";s:6:"VRMode";s:6:"Normal";s:16:"ActiveD-Lighting";s:4:"Auto";s:21:"PictureControlVersion";s:4:"0100";s:18:"PictureControlName";s:8:"Standard";s:18:"PictureControlBase";s:8:"Standard";s:20:"PictureControlAdjust";s:16:"Default Settings";s:25:"PictureControlQuickAdjust";s:3:"n/a";s:10:"Brightness";s:6:"Normal";s:13:"HueAdjustment";s:4:"None";s:12:"FilterEffect";s:3:"n/a";s:12:"ToningEffect";s:3:"n/a";s:16:"ToningSaturation";s:3:"n/a";s:8:"TimeZone";s:6:"+01:00";s:15:"DaylightSavings";s:2:"No";s:17:"DateDisplayFormat";s:5:"D/M/Y";s:12:"ISOExpansion";s:3:"Off";s:4:"ISO2";i:400;s:13:"ISOExpansion2";s:3:"Off";s:21:"AutoDistortionControl";s:3:"Off";s:8:"LensType";s:4:"G VR";s:4:"Lens";s:18:"18-105mm f/3.5-5.6";s:9:"FlashMode";s:12:"Did Not Fire";s:12:"ShootingMode";s:12:"Single-Frame";s:15:"ShotInfoVersion";s:4:"0224";s:15:"FirmwareVersion";s:5:"1.00f";s:14:"NoiseReduction";s:3:"Off";s:13:"WB_GRBGLevels";s:15:"256 501 316 256";s:15:"LensDataVersion";s:4:"0204";s:17:"ExitPupilPosition";s:7:"93.1 mm";s:10:"AFAperture";d:3.7;s:13:"FocusPosition";s:4:"0x05";s:13:"FocusDistance";s:6:"5.62 m";s:12:"LensIDNumber";i:158;s:10:"LensFStops";d:5.33;s:14:"MinFocalLength";s:7:"18.3 mm";s:14:"MaxFocalLength";s:8:"106.8 mm";s:21:"MaxApertureAtMinFocal";d:3.6;s:21:"MaxApertureAtMaxFocal";d:5.7;s:10:"MCUVersion";i:160;s:20:"EffectiveMaxAperture";d:3.6;s:13:"DateStampMode";s:3:"Off";s:14:"RetouchHistory";s:4:"None";s:13:"ImageDataSize";i:8696798;s:12:"ShutterCount";i:17173;s:16:"FlashInfoVersion";s:4:"0105";s:11:"FlashSource";s:4:"None";s:21:"ExternalFlashFirmware";s:3:"n/a";s:18:"ExternalFlashFlags";s:6:"(none)";s:18:"FlashCommanderMode";s:3:"Off";s:16:"FlashControlMode";s:3:"Off";s:17:"FlashCompensation";i:0;s:15:"FlashGNDistance";i:0;s:16:"FlashColorFilter";s:4:"None";s:22:"FlashGroupAControlMode";s:3:"Off";s:22:"FlashGroupBControlMode";s:3:"Off";s:22:"FlashGroupCControlMode";s:3:"Off";s:23:"FlashGroupACompensation";i:0;s:23:"FlashGroupBCompensation";i:0;s:23:"FlashGroupCCompensation";i:0;s:25:"ExternalFlashCompensation";i:0;s:18:"FlashExposureComp3";i:0;s:18:"FlashExposureComp4";i:0;s:11:"VariProgram";s:15:"Auto(Flash Off)";s:20:"MultiExposureVersion";s:4:"0100";s:17:"MultiExposureMode";s:3:"Off";s:18:"MultiExposureShots";i:0;s:21:"MultiExposureAutoGain";s:3:"Off";s:21:"HighISONoiseReduction";s:6:"Normal";s:11:"PowerUpTime";s:19:"0000:00:00 00:00:00";s:14:"AFInfo2Version";s:4:"0100";s:16:"ContrastDetectAF";s:3:"Off";s:10:"AFAreaMode";s:9:"Auto-area";s:13:"PhaseDetectAF";s:13:"On (11-point)";s:14:"PrimaryAFPoint";s:6:"Center";s:12:"AFPointsUsed";s:74:"Center, Mid-left, Far Left, Mid-right, Upper-right, Lower-right, Far Right";s:23:"ContrastDetectAFInFocus";s:2:"No";s:15:"FileInfoVersion";s:4:"0100";s:16:"MemoryCardNumber";i:0;s:15:"DirectoryNumber";i:100;s:10:"FileNumber";s:4:"0266";s:18:"RetouchInfoVersion";s:4:"0200";s:20:"RetouchNEFProcessing";s:3:"Off";s:11:"UserComment";s:0:"";s:10:"SubSecTime";i:10;s:18:"SubSecTimeOriginal";i:10;s:19:"SubSecTimeDigitized";i:10;s:15:"FlashpixVersion";s:4:"0100";s:10:"ColorSpace";s:4:"sRGB";s:14:"ExifImageWidth";i:2500;s:15:"ExifImageHeight";i:3760;s:12:"InteropIndex";s:27:"R98 - DCF basic file (sRGB)";s:14:"InteropVersion";s:4:"0100";s:13:"SensingMethod";s:19:"One-chip color area";s:10:"FileSource";s:14:"Digital Camera";s:9:"SceneType";s:21:"Directly photographed";s:10:"CFAPattern";s:23:"[Red,Green][Green,Blue]";s:14:"CustomRendered";s:6:"Normal";s:12:"ExposureMode";s:4:"Auto";s:16:"DigitalZoomRatio";i:1;s:23:"FocalLengthIn35mmFormat";s:5:"27 mm";s:16:"SceneCaptureType";s:8:"Standard";s:11:"GainControl";s:11:"Low gain up";s:8:"Contrast";s:6:"Normal";s:10:"Saturation";s:6:"Normal";s:9:"Sharpness";s:6:"Normal";s:20:"SubjectDistanceRange";s:7:"Unknown";s:12:"GPSVersionID";s:7:"2.3.0.0";s:15:"ThumbnailOffset";i:39286;s:15:"ThumbnailLength";i:9021;s:10:"ImageWidth";i:2500;s:11:"ImageHeight";i:3760;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:2:0 (2 2)";s:8:"Aperture";d:5.6;s:11:"BlueBalance";d:1.234375;s:9:"ImageSize";s:9:"2500x3760";s:10:"Megapixels";d:9.4;s:12:"PreviewImage";s:51:"(Binary data 25153 bytes, use -b option to extract)";s:10:"RedBalance";d:1.957031;s:16:"ScaleFactor35efl";d:1.5;s:12:"ShutterSpeed";s:5:"1/125";s:16:"SubSecCreateDate";s:22:"2019:05:10 16:30:20.10";s:22:"SubSecDateTimeOriginal";s:22:"2019:05:10 16:30:20.10";s:16:"SubSecModifyDate";s:22:"2019:05:10 16:30:20.10";s:14:"ThumbnailImage";s:50:"(Binary data 9021 bytes, use -b option to extract)";s:9:"AutoFocus";s:2:"On";s:6:"LensID";s:45:"AF-S DX VR Zoom-Nikkor 18-105mm f/3.5-5.6G ED";s:8:"LensSpec";s:23:"18-105mm f/3.5-5.6 G VR";s:17:"CircleOfConfusion";s:8:"0.020 mm";s:3:"DOF";s:18:"inf (1.91 m - inf)";s:3:"FOV";s:17:"67.2 deg (7.47 m)";s:16:"FocalLength35efl";s:35:"18.0 mm (35 mm equivalent: 27.0 mm)";s:18:"HyperfocalDistance";s:6:"2.89 m";s:10:"LightValue";d:9.9;}s:25:"embeddedMetaDataExtracted";b:1;s:8:"checksum";s:32:"8d6ecc9b558dbf057c3bb221cdaa68e7";}" 8140 ] |
|
1.64 ms (4.78%) |
4 |
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-pinkhouse~w10920" "path" "auto_create" "/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-pinkhouse~w10920" "path_query" "https://dev.bernhardknaus.com/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-pinkhouse~w10920" "entire_uri" ] |
|
1.26 ms (3.67%) |
12 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5931
]
|
|
0.63 ms (1.83%) |
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-pinkhouse~w10920" ] |
|
0.58 ms (1.69%) |
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:
[ 1774399516 "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" ] |
|
0.57 ms (1.65%) |
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:
[ 1774399515 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.42 ms (1.23%) |
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:
[ 1774399516 "object_10920\x01tags\x01" "class_5\x01tags\x01" "asset_8139\x01tags\x01" "asset_8140\x01tags\x01" "asset_8141\x01tags\x01" "asset_8142\x01tags\x01" ] |
|
0.41 ms (1.20%) |
6 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/artist/marten-schech~a493/works/workgroups/marten-schech-site-specific-interventions~g12311/marten-schech-pinkhouse~w10920"
]
|
|
0.36 ms (1.07%) |
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:
[ 1774399516 "object_18257\x01tags\x01" "class_5\x01tags\x01" "asset_10509\x01tags\x01" "asset_10510\x01tags\x01" "asset_10511\x01tags\x01" "asset_10468\x01tags\x01" "asset_10469\x01tags\x01" ] |
|
0.33 ms (0.98%) |
4 |
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.33 ms (0.96%) |
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:
[ 1774399516 "object_10940\x01tags\x01" "class_5\x01tags\x01" "asset_8115\x01tags\x01" "asset_8113\x01tags\x01" "asset_8114\x01tags\x01" ] |
|
0.31 ms (0.91%) |
4 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.23 ms (0.67%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"5"
]
|
|
0.23 ms (0.67%) |
4 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
9
]
|
|
0.19 ms (0.56%) |
1 |
SELECT * FROM object_relations_5 WHERE src_id = ?
Parameters:
[
10920
]
|
|
0.14 ms (0.42%) |
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.09 ms (0.28%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.09 ms (0.27%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
11
]
|
|
0.08 ms (0.23%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.08 ms (0.22%) |
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:
[] |
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.