Query Metrics
111
Database Queries
33
Different statements
143.01 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.23 ms (18.34%) |
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 = 553 ) AND workType = 'architecture' AND object_localized_5_de.published IS true AND artist__id = 553 WHERE ( object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[] |
|
22.96 ms (16.06%) |
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 = 553 ) AND workType = 'edition' AND object_localized_5_de.published IS true AND artist__id = 553 WHERE ( object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[] |
|
18.22 ms (12.74%) |
18 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
12.33 ms (8.62%) |
1 |
SELECT COUNT(*) FROM object_localized_5_de WHERE (isDevItem IS false AND workType = 'work' AND published IS true AND artist__id = 553 AND object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[] |
|
11.09 ms (7.75%) |
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/george-pusenkoff~a553/ausstellungen/george-pusenkoff-digital-field-paintings~e9489" "path" "auto_create" "/de/kuenstler/george-pusenkoff~a553/ausstellungen/george-pusenkoff-digital-field-paintings~e9489" "path_query" "https://dev.bernhardknaus.com/de/kuenstler/george-pusenkoff~a553/ausstellungen/george-pusenkoff-digital-field-paintings~e9489" "entire_uri" ] |
|
8.30 ms (5.81%) |
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 = 553 AND object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1 GROUP BY `workgroup__id`) XYZ
Parameters:
[] |
|
8.02 ms (5.61%) |
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 = 553 AND object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[] |
|
7.28 ms (5.09%) |
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 ] |
|
4.76 ms (3.33%) |
2 |
SELECT COUNT(*) FROM (SELECT object_localized_5_de.id FROM object_localized_5_de WHERE (isDevItem IS false AND workType = 'work' AND workgroup__id > 0 AND published IS true AND artist__id = 553 AND object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1 GROUP BY `workgroup__id`) XYZ
Parameters:
[] |
|
4.70 ms (3.29%) |
1 |
SELECT COUNT(*) FROM object_localized_5_de WHERE (isDevItem IS false AND workType = 'work' AND workgroup__id IS NULL AND preview = true AND published IS true AND artist__id = 553 AND object_localized_5_de.type IN ('object','variant','folder')) AND object_localized_5_de.published = 1
Parameters:
[] |
|
3.74 ms (2.61%) |
22 |
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:
[ 1774387873 "site_domain_e19013cb161706785ddee46d4210cfcb" ] |
|
3.54 ms (2.48%) |
1 |
SELECT COUNT(*) FROM object_localized_11_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,553,%' AND object_localized_11_de.type IN ('object','variant','folder')) AND object_localized_11_de.published = 1
Parameters:
[] |
|
2.19 ms (1.53%) |
4 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5931
]
|
|
1.00 ms (0.70%) |
2 |
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[ "a:6:{s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:1400;s:11:"imageHeight";i:1050;s:16:"embeddedMetaData";a:141:{s:8:"FileSize";s:6:"130 kB";s:14:"FileModifyDate";s:25:"2021:07:08 14:09:20+00:00";s:14:"FileAccessDate";s:25:"2021:07:08 14:09:20+00:00";s:19:"FileInodeChangeDate";s:25:"2021:07:08 14:09:20+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:4:"Make";s:5:"Canon";s:5:"Model";s:21:"Canon DIGITAL IXUS v2";s:11:"Orientation";s:19:"Horizontal (normal)";s:11:"XResolution";i:72;s:11:"YResolution";i:72;s:14:"ResolutionUnit";s:6:"inches";s:10:"ModifyDate";s:19:"2002:09:21 16:42:49";s:16:"YCbCrPositioning";s:8:"Centered";s:12:"ExposureTime";s:4:"1/60";s:7:"FNumber";d:2.8;s:11:"ExifVersion";s:4:"0220";s:16:"DateTimeOriginal";s:19:"2002:09:21 16:42:49";s:10:"CreateDate";s:19:"2002:09:21 16:42:49";s:23:"ComponentsConfiguration";s:12:"Y, Cb, Cr, -";s:22:"CompressedBitsPerPixel";i:3;s:17:"ShutterSpeedValue";s:4:"1/60";s:13:"ApertureValue";d:2.8;s:16:"MaxApertureValue";d:2.8;s:5:"Flash";s:9:"On, Fired";s:11:"FocalLength";s:6:"5.4 mm";s:9:"MacroMode";s:6:"Normal";s:9:"SelfTimer";s:3:"Off";s:7:"Quality";s:4:"Fine";s:14:"CanonFlashMode";s:2:"On";s:15:"ContinuousDrive";s:6:"Single";s:9:"FocusMode";s:6:"Single";s:10:"RecordMode";s:4:"JPEG";s:14:"CanonImageSize";s:5:"Large";s:8:"EasyMode";s:6:"Manual";s:11:"DigitalZoom";s:4:"None";s:8:"Contrast";s:6:"Normal";s:10:"Saturation";s:6:"Normal";s:9:"Sharpness";i:0;s:9:"CameraISO";i:50;s:12:"MeteringMode";s:4:"Spot";s:10:"FocusRange";s:4:"Auto";s:7:"AFPoint";s:23:"Auto AF point selection";s:17:"CanonExposureMode";s:4:"Easy";s:8:"LensType";s:3:"n/a";s:14:"MaxFocalLength";s:10:"10.8125 mm";s:14:"MinFocalLength";s:10:"5.40625 mm";s:10:"FocalUnits";s:5:"32/mm";s:11:"MaxAperture";d:2.9;s:11:"MinAperture";d:7.1;s:9:"FlashBits";s:8:"Built-in";s:15:"FocusContinuous";s:6:"Single";s:9:"AESetting";s:9:"Normal AE";s:15:"DisplayAperture";d:2.8;s:15:"ZoomSourceWidth";i:1600;s:15:"ZoomTargetWidth";i:1600;s:16:"SpotMeteringMode";s:6:"Center";s:11:"PhotoEffect";s:3:"Off";s:17:"ManualFlashOutput";s:3:"n/a";s:9:"FocalType";s:4:"Zoom";s:15:"FocalPlaneXSize";s:7:"5.36 mm";s:15:"FocalPlaneYSize";s:7:"4.01 mm";s:7:"AutoISO";i:100;s:7:"BaseISO";i:50;s:10:"MeasuredEV";d:6.97;s:14:"TargetAperture";d:2.8;s:18:"TargetExposureTime";s:4:"1/60";s:20:"ExposureCompensation";i:0;s:12:"WhiteBalance";s:6:"Cloudy";s:11:"SlowShutter";s:3:"Off";s:14:"SequenceNumber";i:1;s:15:"OpticalZoomCode";i:0;s:16:"FlashGuideNumber";d:4.875;s:15:"AFPointsInFocus";s:3:"All";s:17:"FlashExposureComp";i:0;s:22:"AutoExposureBracketing";s:3:"Off";s:15:"AEBBracketValue";i:0;s:11:"ControlMode";s:3:"n/a";s:18:"FocusDistanceUpper";s:7:"16.31 m";s:18:"FocusDistanceLower";s:3:"0 m";s:12:"BulbDuration";i:0;s:10:"CameraType";s:7:"Compact";s:10:"AutoRotate";s:4:"None";s:14:"CanonImageType";s:24:"IMG:DIGITAL IXUS v2 JPEG";s:20:"CanonFirmwareVersion";s:21:"Firmware Version 1.00";s:10:"FileNumber";s:8:"102-0266";s:9:"OwnerName";s:13:"Ilja & George";s:12:"CanonModelID";s:51:"PowerShot S200 / Digital IXUS v2 / IXY Digital 200a";s:11:"UserComment";s:0:"";s:15:"FlashpixVersion";s:4:"0100";s:10:"ColorSpace";s:4:"sRGB";s:14:"ExifImageWidth";i:1400;s:15:"ExifImageHeight";i:1050;s:12:"InteropIndex";s:27:"R98 - DCF basic file (sRGB)";s:14:"InteropVersion";s:4:"0100";s:17:"RelatedImageWidth";i:1600;s:18:"RelatedImageHeight";i:1200;s:21:"FocalPlaneXResolution";d:7766.990291;s:21:"FocalPlaneYResolution";d:7741.935484;s:24:"FocalPlaneResolutionUnit";s:6:"inches";s:13:"SensingMethod";s:19:"One-chip color area";s:10:"FileSource";s:14:"Digital Camera";s:14:"CustomRendered";s:6:"Normal";s:12:"ExposureMode";s:4:"Auto";s:16:"DigitalZoomRatio";i:1;s:16:"SceneCaptureType";s:8:"Standard";s:11:"Compression";s:16:"JPEG (old-style)";s:15:"ThumbnailOffset";i:2066;s:15:"ThumbnailLength";i:3920;s:10:"ImageWidth";i:1400;s:11:"ImageHeight";i:1050;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:2.8;s:14:"ConditionalFEC";i:0;s:9:"DriveMode";s:21:"Single-frame Shooting";s:9:"FlashType";s:14:"Built-In Flash";s:3:"ISO";i:50;s:9:"ImageSize";s:9:"1400x1050";s:4:"Lens";s:13:"5.4 - 10.8 mm";s:6:"LensID";s:14:"Unknown 5-10mm";s:10:"Megapixels";d:1.5;s:15:"RedEyeReduction";s:3:"Off";s:16:"ScaleFactor35efl";d:6.6;s:12:"ShootingMode";s:6:"Manual";s:18:"ShutterCurtainHack";s:16:"1st-curtain sync";s:12:"ShutterSpeed";s:4:"1/60";s:14:"ThumbnailImage";s:50:"(Binary data 3920 bytes, use -b option to extract)";s:17:"CircleOfConfusion";s:8:"0.005 mm";s:3:"DOF";s:18:"inf (1.79 m - inf)";s:3:"FOV";s:8:"53.5 deg";s:16:"FocalLength35efl";s:34:"5.4 mm (35 mm equivalent: 35.7 mm)";s:18:"HyperfocalDistance";s:6:"2.30 m";s:9:"Lens35efl";s:48:"5.4 - 10.8 mm (35 mm equivalent: 35.7 - 71.4 mm)";s:10:"LightValue";d:9.9;}s:25:"embeddedMetaDataExtracted";b:1;s:8:"checksum";s:32:"e54013e1e986ceca13d068097f821511";}" 3806 ] |
|
0.97 ms (0.68%) |
1 |
SELECT COUNT(*) FROM object_localized_4_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,553,%' AND object_localized_4_de.type IN ('object','variant','folder')) AND object_localized_4_de.published = 1
Parameters:
[] |
|
0.95 ms (0.66%) |
1 |
SELECT COUNT(*) FROM object_localized_2_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,553,%' AND object_localized_2_de.type IN ('object','variant','folder')) AND object_localized_2_de.published = 1
Parameters:
[] |
|
0.82 ms (0.57%) |
1 |
SELECT COUNT(*) FROM object_localized_3_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,553,%' AND object_localized_3_de.type IN ('object','variant','folder')) AND object_localized_3_de.published = 1
Parameters:
[] |
|
0.78 ms (0.54%) |
1 |
SELECT COUNT(*) FROM object_localized_12_de WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,553,%' AND object_localized_12_de.type IN ('object','variant','folder')) AND object_localized_12_de.published = 1
Parameters:
[] |
|
0.75 ms (0.52%) |
16 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.73 ms (0.51%) |
4 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5931
]
|
|
0.66 ms (0.46%) |
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:
[ 1774387873 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.63 ms (0.44%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/kuenstler/george-pusenkoff~a553/ausstellungen/" "george-pusenkoff-digital-field-paintings~e9489" ] |
|
0.44 ms (0.30%) |
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:
[ 1774387873 "object_9489\x01tags\x01" "class_3\x01tags\x01" "asset_3805\x01tags\x01" "asset_3806\x01tags\x01" "asset_3807\x01tags\x01" ] |
|
0.39 ms (0.27%) |
3 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de/kuenstler/george-pusenkoff~a553/ausstellungen/george-pusenkoff-digital-field-paintings~e9489"
]
|
|
0.33 ms (0.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:
[ 1774387873 "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" ] |
|
0.22 ms (0.15%) |
1 |
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
9489
]
|
|
0.22 ms (0.15%) |
1 |
SELECT * FROM object_collection_multiLinks_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 9489 "links" ] |
|
0.20 ms (0.14%) |
3 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
9
]
|
|
0.17 ms (0.12%) |
2 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
|
0.14 ms (0.10%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.11 ms (0.08%) |
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:
[ 1774387873 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.07 ms (0.05%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
8
]
|
|
0.07 ms (0.05%) |
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:
[ 1774387873 "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" ] |
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.