Query Metrics
76
Database Queries
14
Different statements
62.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.60 ms |
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:
[ 1781998532 [ "\x00tags\x00output_eee99f8853e8f6c7c7208a9c33ccd569_desktop" "output_eee99f8853e8f6c7c7208a9c33ccd569_desktop" ] ] |
| 2 | 0.37 ms |
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:
[ 1781998532 [ "\x00tags\x00output_eee99f8853e8f6c7c7208a9c33ccd569" "output_eee99f8853e8f6c7c7208a9c33ccd569" ] ] |
| 3 | 0.40 ms |
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:
[ 1781998532 [ "\x00tags\x00site_domain_6e91b5b0bfa77e0b1ed7bc6492755ea3" "site_domain_6e91b5b0bfa77e0b1ed7bc6492755ea3" ] ] |
| 4 | 0.35 ms |
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:
[ 1781998532 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_6e91b5b0bfa77e0b1ed7bc6492755ea3\x00tags\x00" ] ] |
| 5 | 0.55 ms |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/en/shop/Products/Spare-Parts/Rims~c397" "sourcePathQuery" => "/en/shop/Products/Spare-Parts/Rims~c397" "sourceEntireUri" => "http://35.176.121.236/en/shop/Products/Spare-Parts/Rims~c397" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
| 6 | 0.38 ms |
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:
[ 1781998532 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ] ] |
| 7 | 0.29 ms |
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:
[ 1781998532 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ] ] |
| 8 | 0.18 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
| 9 | 0.30 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Rims~c397" "path" => "/en/shop/Products/Spare-Parts/" ] |
| 10 | 0.25 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/shop/Products/Spare-Parts/Rims~c397" ] |
| 11 | 0.23 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Spare-Parts" "path" => "/en/shop/Products/" ] |
| 12 | 0.23 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/shop/Products/Spare-Parts" ] |
| 13 | 0.29 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Products" "path" => "/en/shop/" ] |
| 14 | 0.20 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/shop/Products" ] |
| 15 | 0.20 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "shop" "path" => "/en/" ] |
| 16 | 0.19 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/shop" ] |
| 17 | 0.14 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "en" "path" => "/" ] |
| 18 | 0.25 ms |
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:
[ 1781998532 [ "\x00tags\x00document_3" "document_3" ] ] |
| 19 | 0.73 ms |
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:
[ 1781998532 [ "document_3\x00tags\x00" "document_1\x00tags\x00" "asset_631\x00tags\x00" "asset_632\x00tags\x00" "asset_633\x00tags\x00" "asset_635\x00tags\x00" "asset_947\x00tags\x00" "asset_958\x00tags\x00" "asset_319\x00tags\x00" "asset_457\x00tags\x00" "asset_318\x00tags\x00" "asset_321\x00tags\x00" "asset_957\x00tags\x00" ] ] |
| 20 | 0.28 ms |
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:
[ 1781998532 [ "\x00tags\x00document_properties_3" "document_properties_3" ] ] |
| 21 | 0.25 ms |
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:
[ 1781998532 [ "document_properties\x00tags\x00" "document_3\x00tags\x00" "document_properties_3\x00tags\x00" ] ] |
| 22 | 0.14 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
| 23 | 0.15 ms |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
| 24 | 0.14 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
| 25 | 0.12 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
10
]
|
| 26 | 0.12 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
9
]
|
| 27 | 0.12 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
8
]
|
| 28 | 0.11 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
7
]
|
| 29 | 0.14 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
6
]
|
| 30 | 0.11 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
4
]
|
| 31 | 0.11 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
3
]
|
| 32 | 0.16 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
2
]
|
| 33 | 0.16 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
13
]
|
| 34 | 0.42 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 35 | 0.32 ms |
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:
[ 1781998532 [ "\x00tags\x00object_860" "object_860" ] ] |
| 36 | 0.27 ms |
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:
[ 1781998532 [ "object_860\x00tags\x00" "class_2\x00tags\x00" ] ] |
| 37 | 0.34 ms |
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:
[ 1781998532 [ "\x00tags\x00cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ] ] |
| 38 | 0.17 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 39 | 0.18 ms |
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:
[ 1781998532 [ "\x00tags\x00cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ] ] |
| 40 | 0.14 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 41 | 0.17 ms |
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:
[ 1781998532 [ "\x00tags\x00cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ] ] |
| 42 | 0.17 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 43 | 0.25 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "Sports-Cars-Fan" "path" => "/Customer Management/segments/calculated/Interest-Target-Groups/" ] |
| 44 | 0.30 ms |
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:
[ 1781998532 [ "\x00tags\x00object_875" "object_875" ] ] |
| 45 | 0.30 ms |
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:
[ 1781998532 [ "object_875\x00tags\x00" "class_2\x00tags\x00" ] ] |
| 46 | 0.31 ms |
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:
[ 1781998532 [ "\x00tags\x00url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ] ] |
| 47 | 0.18 ms |
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:
[ 1781998532 [ "\x00tags\x00url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ] ] |
| 48 | 0.19 ms |
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:
[ 1781998532 [ "\x00tags\x00url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ] ] |
| 49 | 0.32 ms |
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:
[ 1781998532 [ "\x00tags\x00targeting_geoip_e99931c2a6c859d0175d501afae04e1a7914c867" "targeting_geoip_e99931c2a6c859d0175d501afae04e1a7914c867" ] ] |
| 50 | 0.28 ms |
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:
[ 1781998532 [ "targeting\x00tags\x00" "targeting_geoip\x00tags\x00" "targeting_geoip_e99931c2a6c859d0175d501afae04e1a7914c867\x00tags\x00" ] ] |
| 51 | 0.35 ms |
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:
[ 1781998532 [ "\x00tags\x00object_397" "object_397" ] ] |
| 52 | 0.20 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
397
]
|
| 53 | 0.27 ms |
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
"http://35.176.121.236/en/shop/Products/Spare-Parts/Rims%7Ec397"
]
|
| 54 | 3.49 ms |
INSERT INTO http_error_log (`uri`, `code`, `parametersGet`, `parametersPost`, `cookies`, `serverVars`, `date`, `count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "http://35.176.121.236/en/shop/Products/Spare-Parts/Rims%7Ec397" 500 "a:0:{}" "a:0:{}" "a:0:{}" "a:57:{s:4:"PATH";s:532:"/opt/bitnami/apache/bin:/opt/bitnami/common/bin:/opt/bitnami/apache/bin:/opt/bitnami/apache2/bin:/opt/bitnami/common/bin:/opt/bitnami/gonit/bin:/opt/bitnami/mariadb/bin:/opt/bitnami/mariadb/sbin:/opt/bitnami/php/bin:/opt/bitnami/php/sbin:/opt/bitnami/nami/bin:/opt/bitnami/apache/bin:/opt/bitnami/apache2/bin:/opt/bitnami/common/bin:/opt/bitnami/gonit/bin:/opt/bitnami/mariadb/bin:/opt/bitnami/mariadb/sbin:/opt/bitnami/php/bin:/opt/bitnami/php/sbin:/opt/bitnami/nami/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:19:"PIMCORE_ENVIRONMENT";s:4:"prod";s:4:"USER";s:6:"daemon";s:4:"HOME";s:9:"/usr/sbin";s:11:"SCRIPT_NAME";s:10:"/index.php";s:11:"REQUEST_URI";s:41:"/en/shop/Products/Spare-Parts/Rims%7Ec397";s:12:"QUERY_STRING";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:12:"REDIRECT_URL";s:39:"/en/shop/Products/Spare-Parts/Rims~c397";s:11:"REMOTE_PORT";s:5:"35522";s:15:"SCRIPT_FILENAME";s:37:"/opt/bitnami/pimcore/public/index.php";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:27:"/opt/bitnami/pimcore/public";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:4:"http";s:13:"DOCUMENT_ROOT";s:27:"/opt/bitnami/pimcore/public";s:11:"REMOTE_ADDR";s:14:"216.244.66.246";s:11:"SERVER_PORT";s:2:"80";s:11:"SERVER_ADDR";s:12:"172.31.9.222";s:11:"SERVER_NAME";s:14:"35.176.121.236";s:15:"SERVER_SOFTWARE";s:35:"Apache/2.4.48 (Unix) OpenSSL/1.1.1n";s:16:"SERVER_SIGNATURE";s:0:"";s:19:"HTTP_ACCEPT_CHARSET";s:36:"utf-8;q=0.7,iso-8859-1;q=0.2,*;q=0.1";s:15:"HTTP_USER_AGENT";s:88:"Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)";s:11:"HTTP_ACCEPT";s:3:"*/*";s:9:"HTTP_HOST";s:14:"35.176.121.236";s:10:"SCRIPT_URI";s:60:"http://35.176.121.236/en/shop/Products/Spare-Parts/Rims~c397";s:10:"SCRIPT_URL";s:39:"/en/shop/Products/Spare-Parts/Rims~c397";s:15:"REDIRECT_STATUS";s:3:"200";s:28:"REDIRECT_PIMCORE_ENVIRONMENT";s:4:"prod";s:19:"REDIRECT_SCRIPT_URI";s:60:"http://35.176.121.236/en/shop/Products/Spare-Parts/Rims~c397";s:19:"REDIRECT_SCRIPT_URL";s:39:"/en/shop/Products/Spare-Parts/Rims~c397";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1781998532.511209;s:12:"REQUEST_TIME";i:1781998532;s:7:"APP_ENV";s:3:"dev";s:7:"AWS_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:15:"COGNITO_POOL_ID";s:19:"eu-west-2_s7aWIx1ZD";s:17:"STRIPE_PUBLIC_KEY";s:107:"pk_test_51LdFYfLKNrIbEvGe5y8DQpqWU2jSSpZr99RPW0wdMzNrrxKR95HwEAQ0fn8p9lYl3rdou1ViWc3UliWTJ6r7RP4j001vYlJl1A";s:25:"STRIPE_ADD_MEMBER_PROD_ID";s:19:"prod_NV6Ia9qStr2jMF";s:27:"THUMBNAIL_OSGO_S3_BASE_PATH";s:59:"https://oscare-pimcore.s3.eu-west-2.amazonaws.com/thumbnail";s:24:"ASSETS_OSGO_S3_BASE_PATH";s:56:"https://oscare-pimcore.s3.eu-west-2.amazonaws.com/assets";s:30:"OSCARE_HEADOFFICE_S3_BASE_PATH";s:52:"https://oscare-headoffice.s3.eu-west-2.amazonaws.com";s:25:"GOOGLE_RECAPTCHA_SITE_KEY";s:0:"";s:23:"GOOGLE_RECAPTCHA_SECRET";s:0:"";s:14:"RECAPTCHA3_KEY";s:40:"6LdJhdgkAAAAABmvSwaCUJ5k5MYRqf03WvnWl24a";s:17:"RECAPTCHA3_SECRET";s:40:"6LdJhdgkAAAAAImMc3Q7Z5kpoawZsBXMdDSFkCmv";s:13:"APP_CLIENT_ID";s:25:"92b1t6uf75m3af1k64teov0t5";s:12:"USER_POOL_ID";s:19:"eu-west-2_u17bcGLwU";s:16:"IDENTITY_POOL_ID";s:46:"eu-west-2:e490529c-157f-486d-8abf-2a430e20d697";s:17:"MERLIN_DATASOURCE";s:5:"mbs01";s:10:"MERLIN_URL";s:39:"http://3.8.247.79:8181/merlin.asmx?WSDL";s:19:"SYMFONY_DOTENV_VARS";s:325:"APP_ENV,AWS_ENV,APP_DEBUG,COGNITO_POOL_ID,STRIPE_PUBLIC_KEY,STRIPE_ADD_MEMBER_PROD_ID,THUMBNAIL_OSGO_S3_BASE_PATH,ASSETS_OSGO_S3_BASE_PATH,OSCARE_HEADOFFICE_S3_BASE_PATH,GOOGLE_RECAPTCHA_SITE_KEY,GOOGLE_RECAPTCHA_SECRET,RECAPTCHA3_KEY,RECAPTCHA3_SECRET,APP_CLIENT_ID,USER_POOL_ID,IDENTITY_POOL_ID,MERLIN_DATASOURCE,MERLIN_URL";}" 1781998532 1 ] |
| 55 | 0.17 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Error-Page" "path" => "/en/" ] |
| 56 | 0.35 ms |
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:
[ 1781998532 [ "\x00tags\x00document_198" "document_198" ] ] |
| 57 | 0.28 ms |
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:
[ 1781998532 [ "document_198\x00tags\x00" ] ] |
| 58 | 0.37 ms |
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:
[ 1781998532 [ "\x00tags\x00document_target_groups_198" "document_target_groups_198" ] ] |
| 59 | 0.17 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
198
]
|
| 60 | 0.34 ms |
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:
[ 1781998532 [ "\x00tags\x00document_properties_198" "document_properties_198" ] ] |
| 61 | 0.32 ms |
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:
[ 1781998532 [ "document_properties\x00tags\x00" "document_198\x00tags\x00" "document_properties_198\x00tags\x00" ] ] |
| 62 | 0.43 ms |
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:
[ 1781998532 [ "\x00tags\x00document_12" "document_12" ] ] |
| 63 | 0.35 ms |
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:
[ 1781998532 [ "document_12\x00tags\x00" ] ] |
| 64 | 0.34 ms |
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:
[ 1781998532 [ "\x00tags\x00document_target_groups_12" "document_target_groups_12" ] ] |
| 65 | 0.13 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
12
]
|
| 66 | 0.29 ms |
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:
[ 1781998532 [ "\x00tags\x00tag_inc__2dee893a22572d20b0cd13b30c298ba8" "tag_inc__2dee893a22572d20b0cd13b30c298ba8" ] ] |
| 67 | 0.28 ms |
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:
[ 1781998532 [ "output_inline\x00tags\x00" "output\x00tags\x00" "tag_inc__2dee893a22572d20b0cd13b30c298ba8\x00tags\x00" ] ] |
| 68 | 38.96 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 1 => null 2 => null 3 => null 4 => 1781998532 ] |
| 69 | 0.51 ms |
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:
[ 1781998532 [ "\x00tags\x00document_properties_12" "document_properties_12" ] ] |
| 70 | 0.33 ms |
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:
[ 1781998532 [ "document_properties\x00tags\x00" "document_12\x00tags\x00" "document_properties_12\x00tags\x00" ] ] |
| 71 | 0.34 ms |
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:
[ 1781998532 [ "\x00tags\x00document_227" "document_227" ] ] |
| 72 | 0.26 ms |
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:
[ 1781998532 [ "document_227\x00tags\x00" ] ] |
| 73 | 0.30 ms |
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:
[ 1781998532 [ "\x00tags\x00document_299" "document_299" ] ] |
| 74 | 0.28 ms |
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:
[ 1781998532 [ "document_299\x00tags\x00" "asset_3044\x00tags\x00" ] ] |
| 75 | 0.28 ms |
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:
[ 1781998532 [ "\x00tags\x00document_88" "document_88" ] ] |
| 76 | 0.25 ms |
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:
[ 1781998532 [ "document_88\x00tags\x00" ] ] |
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.