Query Metrics
168
Database Queries
21
Different statements
66.88 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.99 ms (40.35%) |
61 |
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:
[ 1774410820 "site_domain_e19013cb161706785ddee46d4210cfcb" ] |
|
9.53 ms (14.24%) |
1 |
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[ "a:6:{s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:1400;s:11:"imageHeight";i:949;s:16:"embeddedMetaData";a:249:{s:8:"FileSize";s:5:"82 kB";s:14:"FileModifyDate";s:25:"2021:07:08 14:33:16+00:00";s:14:"FileAccessDate";s:25:"2021:07:08 14:33:16+00:00";s:19:"FileInodeChangeDate";s:25:"2021:07:08 14:33:16+00:00";s:15:"FilePermissions";s:9:"rw-rw-rw-";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:"Little-endian (Intel, II)";s:11:"Compression";s:3:"LZW";s:25:"PhotometricInterpretation";s:3:"RGB";s:4:"Make";s:5:"Canon";s:5:"Model";s:14:"Canon EOS 550D";s:11:"Orientation";s:19:"Horizontal (normal)";s:15:"SamplesPerPixel";i:3;s:11:"XResolution";i:72;s:11:"YResolution";i:72;s:19:"PlanarConfiguration";s:6:"Chunky";s:14:"ResolutionUnit";s:6:"inches";s:8:"Software";s:35:"Adobe Photoshop CC 2017 (Macintosh)";s:10:"ModifyDate";s:19:"2018:05:03 07:25:04";s:12:"ExposureTime";s:3:"1/8";s:7:"FNumber";d:13;s:15:"ExposureProgram";s:6:"Manual";s:3:"ISO";i:200;s:11:"ExifVersion";s:4:"0221";s:16:"DateTimeOriginal";s:19:"2015:08:12 09:35:35";s:10:"CreateDate";s:19:"2015:08:12 09:35:35";s:17:"ShutterSpeedValue";s:3:"1/8";s:13:"ApertureValue";d:13;s:20:"ExposureCompensation";i:0;s:16:"MaxApertureValue";d:4;s:12:"MeteringMode";s:13:"Multi-segment";s:5:"Flash";s:17:"Off, Did not fire";s:11:"FocalLength";s:7:"24.0 mm";s:10:"SubSecTime";i:11;s:18:"SubSecTimeOriginal";i:11;s:19:"SubSecTimeDigitized";i:11;s:10:"ColorSpace";s:12:"Uncalibrated";s:14:"ExifImageWidth";i:1400;s:15:"ExifImageHeight";i:949;s:21:"FocalPlaneXResolution";d:5728.176796;s:21:"FocalPlaneYResolution";d:5808.403361;s:24:"FocalPlaneResolutionUnit";s:6:"inches";s:14:"CustomRendered";s:6:"Normal";s:12:"ExposureMode";s:6:"Manual";s:12:"WhiteBalance";s:4:"Auto";s:16:"SceneCaptureType";s:8:"Standard";s:12:"SerialNumber";i:732350982;s:8:"LensInfo";s:12:"24-105mm f/?";s:9:"LensModel";s:22:"EF24-105mm f/4L IS USM";s:15:"ThumbnailOffset";i:976;s:15:"ThumbnailLength";i:2056;s:10:"XMPToolkit";s:62:"Adobe XMP Core 5.6-c138 79.159824, 2016/09/14-01:09:01 ";s:4:"Lens";s:22:"EF24-105mm f/4L IS USM";s:11:"ImageNumber";i:0;s:24:"ApproximateFocusDistance";d:1.68;s:17:"FlashCompensation";i:0;s:8:"Firmware";s:5:"1.0.8";s:34:"DistortionCorrectionAlreadyApplied";b:1;s:50:"LateralChromaticAberrationCorrectionAlreadyApplied";b:1;s:32:"VignetteCorrectionAlreadyApplied";b:1;s:5:"Label";s:10:"Erste Wahl";s:12:"MetadataDate";s:25:"2018:05:03 07:25:04+02:00";s:6:"Rating";i:0;s:11:"CreatorTool";s:35:"Adobe Photoshop CC 2017 (Macintosh)";s:9:"ColorMode";s:3:"RGB";s:14:"ICCProfileName";s:16:"Adobe RGB (1998)";s:10:"DocumentID";s:58:"adobe:docid:photoshop:bcdcedc1-8f20-117b-b17e-9d40bc1144c2";s:18:"OriginalDocumentID";s:32:"70592A6054963F41F943C666B9DEF4CA";s:10:"InstanceID";s:44:"xmp.iid:ee15221d-ce04-492c-aac2-ccf1eb3535a6";s:6:"Format";s:10:"image/jpeg";s:11:"RawFileName";s:12:"_MG_7337.CR2";s:7:"Version";d:9.7;s:14:"ProcessVersion";d:6.7;s:16:"AutoWhiteVersion";i:134348800;s:16:"ColorTemperature";i:4300;s:4:"Tint";s:3:"+16";s:10:"Saturation";i:0;s:9:"Sharpness";i:25;s:18:"LuminanceSmoothing";i:0;s:19:"ColorNoiseReduction";i:25;s:14:"VignetteAmount";i:0;s:10:"ShadowTint";i:0;s:6:"RedHue";i:0;s:13:"RedSaturation";i:0;s:8:"GreenHue";i:0;s:15:"GreenSaturation";i:0;s:7:"BlueHue";i:0;s:14:"BlueSaturation";i:0;s:8:"Vibrance";i:0;s:16:"HueAdjustmentRed";i:0;s:19:"HueAdjustmentOrange";i:0;s:19:"HueAdjustmentYellow";i:0;s:18:"HueAdjustmentGreen";i:0;s:17:"HueAdjustmentAqua";i:0;s:17:"HueAdjustmentBlue";i:0;s:19:"HueAdjustmentPurple";i:0;s:20:"HueAdjustmentMagenta";i:0;s:23:"SaturationAdjustmentRed";i:0;s:26:"SaturationAdjustmentOrange";i:0;s:26:"SaturationAdjustmentYellow";i:0;s:25:"SaturationAdjustmentGreen";i:0;s:24:"SaturationAdjustmentAqua";i:0;s:24:"SaturationAdjustmentBlue";i:0;s:26:"SaturationAdjustmentPurple";i:0;s:27:"SaturationAdjustmentMagenta";i:0;s:22:"LuminanceAdjustmentRed";i:0;s:25:"LuminanceAdjustmentOrange";i:0;s:25:"LuminanceAdjustmentYellow";i:0;s:24:"LuminanceAdjustmentGreen";i:0;s:23:"LuminanceAdjustmentAqua";i:0;s:23:"LuminanceAdjustmentBlue";i:0;s:25:"LuminanceAdjustmentPurple";i:0;s:26:"LuminanceAdjustmentMagenta";i:0;s:20:"SplitToningShadowHue";i:0;s:27:"SplitToningShadowSaturation";i:0;s:23:"SplitToningHighlightHue";i:0;s:30:"SplitToningHighlightSaturation";i:0;s:18:"SplitToningBalance";i:0;s:17:"ParametricShadows";i:0;s:15:"ParametricDarks";i:0;s:16:"ParametricLights";i:0;s:20:"ParametricHighlights";i:0;s:21:"ParametricShadowSplit";i:25;s:22:"ParametricMidtoneSplit";i:50;s:24:"ParametricHighlightSplit";i:75;s:13:"SharpenRadius";s:4:"+1.0";s:13:"SharpenDetail";i:25;s:18:"SharpenEdgeMasking";i:0;s:22:"PostCropVignetteAmount";i:0;s:11:"GrainAmount";i:0;s:25:"ColorNoiseReductionDetail";i:50;s:29:"ColorNoiseReductionSmoothness";i:50;s:17:"LensProfileEnable";i:1;s:26:"LensManualDistortionAmount";i:0;s:19:"PerspectiveVertical";i:0;s:21:"PerspectiveHorizontal";i:0;s:17:"PerspectiveRotate";d:0;s:16:"PerspectiveScale";i:100;s:17:"PerspectiveAspect";i:0;s:18:"PerspectiveUpright";i:0;s:12:"PerspectiveX";d:0;s:12:"PerspectiveY";d:0;s:13:"AutoLateralCA";i:1;s:12:"Exposure2012";d:-0.4;s:12:"Contrast2012";i:0;s:14:"Highlights2012";s:3:"+70";s:11:"Shadows2012";s:3:"+33";s:10:"Whites2012";s:3:"+28";s:10:"Blacks2012";i:-22;s:11:"Clarity2012";s:3:"+28";s:20:"DefringePurpleAmount";i:0;s:19:"DefringePurpleHueLo";i:30;s:19:"DefringePurpleHueHi";i:70;s:19:"DefringeGreenAmount";i:0;s:18:"DefringeGreenHueLo";i:40;s:18:"DefringeGreenHueHi";i:60;s:6:"Dehaze";i:0;s:15:"ToneMapStrength";i:0;s:18:"ConvertToGrayscale";b:0;s:13:"ToneCurveName";s:15:"Medium Contrast";s:17:"ToneCurveName2012";s:6:"Linear";s:13:"CameraProfile";s:14:"Adobe Standard";s:19:"CameraProfileDigest";s:32:"6B3E0C3051986B79DFB60C923C3DC656";s:16:"LensProfileSetup";s:12:"LensDefaults";s:15:"LensProfileName";s:38:"Adobe (Canon EF 24-105mm f/4 L IS USM)";s:19:"LensProfileFilename";s:64:"Canon EOS-1Ds Mark III (Canon EF 24-105mm f4 L IS USM) - RAW.lcp";s:17:"LensProfileDigest";s:32:"F59965C057650927AFD8E60143A071CA";s:26:"LensProfileDistortionScale";i:100;s:35:"LensProfileChromaticAberrationScale";i:100;s:26:"LensProfileVignettingScale";i:100;s:14:"UprightVersion";i:151388160;s:17:"UprightCenterMode";i:0;s:18:"UprightCenterNormX";d:0.5;s:18:"UprightCenterNormY";d:0.5;s:16:"UprightFocalMode";i:0;s:22:"UprightFocalLength35mm";i:35;s:14:"UprightPreview";b:0;s:21:"UprightTransformCount";i:6;s:24:"UprightFourSegmentsCount";i:0;s:11:"HasSettings";b:1;s:7:"HasCrop";b:0;s:14:"AlreadyApplied";b:1;s:13:"HistoryAction";s:69:"saved | saved | derived | saved | saved | converted | derived | saved";s:17:"HistoryInstanceID";s:232:"xmp.iid:d6d57732-ac58-4d39-b956-98fcebaac863 | xmp.iid:b4c19bc5-3ae2-4ea2-82f7-a03c363fc8a5 | xmp.iid:1d75a0bd-d736-49ce-a1f1-23a21cbd5ff5 | xmp.iid:3bfad845-55c8-413a-96f2-a3875cdaf69a | xmp.iid:ee15221d-ce04-492c-aac2-ccf1eb3535a6";s:11:"HistoryWhen";s:137:"2017:05:29 11:43:15+02:00 | 2017:06:04 16:28:52+02:00 | 2017:06:04 16:40:43+02:00 | 2018:05:03 07:25:04+02:00 | 2018:05:03 07:25:04+02:00";s:20:"HistorySoftwareAgent";s:196:"Adobe Photoshop Camera Raw 9.7 | Adobe Photoshop Camera Raw 9.7 (Macintosh) | Adobe Photoshop Camera Raw 9.7 (Macintosh) | Adobe Photoshop CC 2017 (Macintosh) | Adobe Photoshop CC 2017 (Macintosh)";s:14:"HistoryChanged";s:33:"/metadata | /metadata | / | / | /";s:17:"HistoryParameters";s:120:"converted from image/x-canon-cr2 to image/tiff | from image/tiff to image/jpeg | converted from image/tiff to image/jpeg";s:21:"DerivedFromInstanceID";s:44:"xmp.iid:3bfad845-55c8-413a-96f2-a3875cdaf69a";s:21:"DerivedFromDocumentID";s:58:"adobe:docid:photoshop:bf0781c2-899f-117a-a80c-c148886c6ef7";s:29:"DerivedFromOriginalDocumentID";s:32:"70592A6054963F41F943C666B9DEF4CA";s:9:"ToneCurve";s:55:"0, 0 | 32, 22 | 64, 56 | 128, 128 | 192, 196 | 255, 255";s:12:"ToneCurveRed";s:15:"0, 0 | 255, 255";s:14:"ToneCurveGreen";s:15:"0, 0 | 255, 255";s:13:"ToneCurveBlue";s:15:"0, 0 | 255, 255";s:15:"ToneCurvePV2012";s:15:"0, 0 | 255, 255";s:18:"ToneCurvePV2012Red";s:15:"0, 0 | 255, 255";s:20:"ToneCurvePV2012Green";s:15:"0, 0 | 255, 255";s:19:"ToneCurvePV2012Blue";s:15:"0, 0 | 255, 255";s:17:"CurrentIPTCDigest";s:32:"52b6a35ec4122656a5de5f9d05f51e65";s:17:"CodedCharacterSet";s:4:"UTF8";s:24:"ApplicationRecordVersion";i:0;s:11:"DateCreated";s:10:"2015:08:12";s:11:"TimeCreated";s:14:"09:35:35+00:00";s:10:"IPTCDigest";s:32:"52b6a35ec4122656a5de5f9d05f51e65";s:15:"DisplayedUnitsX";s:6:"inches";s:15:"DisplayedUnitsY";s:6:"inches";s:10:"PrintStyle";s:8:"Centered";s:13:"PrintPosition";s:3:"0 0";s:10:"PrintScale";i:1;s:11:"GlobalAngle";i:30;s:14:"GlobalAltitude";i:30;s:8:"URL_List";s:0:"";s:15:"SlicesGroupName";s:12:"ZombiesII_b2";s:9:"NumSlices";i:1;s:16:"PixelAspectRatio";i:1;s:18:"PhotoshopThumbnail";s:50:"(Binary data 2056 bytes, use -b option to extract)";s:17:"HasRealMergedData";s:3:"Yes";s:10:"WriterName";s:15:"Adobe Photoshop";s:10:"ReaderName";s:23:"Adobe Photoshop CC 2017";s:16:"PhotoshopQuality";i:12;s:15:"PhotoshopFormat";s:11:"Progressive";s:16:"ProgressiveScans";s:7:"3 Scans";s:10:"ImageWidth";i:1400;s:11:"ImageHeight";i:949;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:13;s:15:"DateTimeCreated";s:25:"2015:08:12 09:35:35+00:00";s:9:"ImageSize";s:8:"1400x949";s:10:"Megapixels";d:1.3;s:16:"ScaleFactor35efl";d:1.6;s:12:"ShutterSpeed";s:3:"1/8";s:16:"SubSecCreateDate";s:22:"2015:08:12 09:35:35.11";s:22:"SubSecDateTimeOriginal";s:22:"2015:08:12 09:35:35.11";s:16:"SubSecModifyDate";s:22:"2018:05:03 07:25:04.11";s:14:"ThumbnailImage";s:50:"(Binary data 2056 bytes, use -b option to extract)";s:17:"CircleOfConfusion";s:8:"0.019 mm";s:3:"DOF";s:22:"4.89 m (0.98 - 5.87 m)";s:3:"FOV";s:8:"51.0 deg";s:16:"FocalLength35efl";s:35:"24.0 mm (35 mm equivalent: 37.7 mm)";s:18:"HyperfocalDistance";s:6:"2.32 m";s:6:"LensID";s:29:"Canon EF 24-105mm f/4L IS USM";s:10:"LightValue";d:9.4;}s:25:"embeddedMetaDataExtracted";b:1;s:8:"checksum";s:32:"885f4dd98bdd95c97bcd8560dd43c552";}" 4738 ] |
|
6.48 ms (9.69%) |
29 |
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:
[ 1774410820 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
5.09 ms (7.61%) |
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 = 497 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:
[] |
|
3.54 ms (5.30%) |
15 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5931
]
|
|
3.40 ms (5.08%) |
12 |
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:
[ 1774410821 "object_12002\x01tags\x01" "class_5\x01tags\x01" "asset_4737\x01tags\x01" "asset_4738\x01tags\x01" ] |
|
2.99 ms (4.48%) |
2 |
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:
[] |
|
2.10 ms (3.14%) |
5 |
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/lena-von-goedeke~a497/works/workgroups/lena-von-goedeke-objects~g12421/item~w12002" "path" "auto_create" "/en/artist/lena-von-goedeke~a497/works/workgroups/lena-von-goedeke-objects~g12421/item~w12002" "path_query" "https://dev.bernhardknaus.com/en/artist/lena-von-goedeke~a497/works/workgroups/lena-von-goedeke-objects~g12421/item~w12002" "entire_uri" ] |
|
2.03 ms (3.03%) |
3 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5931
]
|
|
1.10 ms (1.64%) |
7 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/artist/lena-von-goedeke~a497/works/workgroups/lena-von-goedeke-objects~g12421/" "item~w12002" ] |
|
1.00 ms (1.49%) |
6 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/artist/lena-von-goedeke~a497/works/workgroups/lena-von-goedeke-objects~g12421/item~w12002"
]
|
|
0.75 ms (1.13%) |
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:
[ 1774410820 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.39 ms (0.58%) |
5 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.31 ms (0.46%) |
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:
[ 1774410821 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "document_85\x01tags\x01" "document_86\x01tags\x01" "document_96\x01tags\x01" "document_87\x01tags\x01" "object_12999\x01tags\x01" "object_13000\x01tags\x01" ] |
|
0.27 ms (0.41%) |
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.22 ms (0.34%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"5"
]
|
|
0.20 ms (0.30%) |
4 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
9
]
|
|
0.16 ms (0.23%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.16 ms (0.23%) |
1 |
SELECT * FROM object_relations_5 WHERE src_id = ?
Parameters:
[
12002
]
|
|
0.10 ms (0.16%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
11
]
|
|
0.07 ms (0.10%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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.