Symfony Profiler

Query Metrics

41 Database Queries

16 Different statements

6.10 ms Query time

0 Invalid entities

Queries


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 (?)
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 (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 = 1 AND priority = 99 ORDER BY `priority` DESC
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 (?)
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 (?, ?, ?)
SELECT * FROM tmp_store WHERE id = ?
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 (?)
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 (?)
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 (?)
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 (?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?, ?, ?, ?, ?, ?, ?, ?)
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 (?)
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 (?, ?)
SELECT name FROM classes WHERE id = ?
SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE (`urlSlug` = 'kpp-4p-connector-4pin-mini-din'  AND  object_localized_AWS_PROD_en.type IN ('variant','object')) AND object_localized_AWS_PROD_en.published = 1 LIMIT 1
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT date FROM http_error_log WHERE uri = ?
INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 = 1 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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

#▲	Time	Info
1	0.24 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: [`1770654409 "site_domain_9840da67fc407769f0624da2a6f8c7b6"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_9840da67fc407769f0624da2a6f8c7b6');
2	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: [`1770654409 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.12 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
4	0.22 ms	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 = 1 AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "path" "auto_create" "/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "path_query" "https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "entire_uri"`] View formatted query View runnable query Explain query 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 = 1 AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND `type` = 'path_query') OR (source = 'https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 1 AND priority = 99 ORDER BY `priority` DESC;
5	0.10 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: [`1770654409 "system_route_redirect"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.13 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: [`1770654409 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.10 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
8	0.10 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: [`1770654409 "output_1f90b38defe37793ec366e590c31487e_desktop"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_1f90b38defe37793ec366e590c31487e_desktop');
9	0.09 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: [`1770654409 "\x00tags\x00output_1f90b38defe37793ec366e590c31487e_desktop"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_1f90b38defe37793ec366e590c31487e_desktop');
10	0.09 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: [`1770654409 "output_1f90b38defe37793ec366e590c31487e"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_1f90b38defe37793ec366e590c31487e');
11	0.10 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: [`1770654409 "\x00tags\x00output_1f90b38defe37793ec366e590c31487e"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_1f90b38defe37793ec366e590c31487e');
12	0.09 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
13	0.11 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/us/fr/produits/connecteurs/Connecteurs/" "kpp-4p-connector-4pin-mini-din"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/us/fr/produits/connecteurs/Connecteurs/' AND `key` = BINARY 'kpp-4p-connector-4pin-mini-din';
14	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/us/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/us/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din';
15	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/us/%" "/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/us/%' AND documents_page.prettyUrl = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din';
16	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/us/fr/produits/connecteurs/" "Connecteurs"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/us/fr/produits/connecteurs/' AND `key` = BINARY 'Connecteurs';
17	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/us/fr/produits/connecteurs/Connecteurs"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/us/fr/produits/connecteurs/Connecteurs';
18	0.12 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/us/%" "/fr/produits/connecteurs/Connecteurs"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/us/%' AND documents_page.prettyUrl = '/fr/produits/connecteurs/Connecteurs';
19	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/us/fr/produits/" "connecteurs"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/us/fr/produits/' AND `key` = BINARY 'connecteurs';
20	0.12 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/us/fr/produits/connecteurs"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/us/fr/produits/connecteurs';
21	0.13 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/us/%" "/fr/produits/connecteurs"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/us/%' AND documents_page.prettyUrl = '/fr/produits/connecteurs';
22	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/us/fr/" "produits"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/us/fr/' AND `key` = BINARY 'produits';
23	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/us/fr/produits"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/us/fr/produits';
24	0.13 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/us/%" "/fr/produits"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/us/%' AND documents_page.prettyUrl = '/fr/produits';
25	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/us/" "fr"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/us/' AND `key` = BINARY 'fr';
26	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/us/fr"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/us/fr';
27	0.13 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/us/%" "/fr"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/us/%' AND documents_page.prettyUrl = '/fr';
28	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "us"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'us';
29	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: [`1770654409 "document_91"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_91');
30	0.14 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: [`1770654409 "document_91\x01tags\x01" "asset_2041\x01tags\x01" "asset_2046\x01tags\x01" "asset_2042\x01tags\x01" "asset_2044\x01tags\x01" "asset_2056\x01tags\x01" "asset_2045\x01tags\x01" "asset_2047\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_91tags', 'asset_2041tags', 'asset_2046tags', 'asset_2042tags', 'asset_2044tags', 'asset_2056tags', 'asset_2045tags', 'asset_2047tags');
31	0.11 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: [`1770654409 "document_properties_91"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_91');
32	0.11 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: [`1770654409 "document_properties\x01tags\x01" "document_91\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770654409 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_91tags');
33	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AWS_PROD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AWS_PROD';
34	0.35 ms	SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE (`urlSlug` = 'kpp-4p-connector-4pin-mini-din' AND object_localized_AWS_PROD_en.type IN ('variant','object')) AND object_localized_AWS_PROD_en.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE ( `urlSlug` = 'kpp-4p-connector-4pin-mini-din' AND object_localized_AWS_PROD_en.type IN ('variant', 'object') ) AND object_localized_AWS_PROD_en.published = 1 LIMIT 1 SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE (`urlSlug` = 'kpp-4p-connector-4pin-mini-din' AND object_localized_AWS_PROD_en.type IN ('variant','object')) AND object_localized_AWS_PROD_en.published = 1 LIMIT 1;
35	0.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
36	0.12 ms	SELECT date FROM http_error_log WHERE uri = ? Parameters: [`"https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din"`] View formatted query View runnable query Explain query SELECT date FROM http_error_log WHERE uri = ? SELECT date FROM http_error_log WHERE uri = 'https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din';
37	0.99 ms	INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:121:{s:23:"PHP_UPLOAD_MAX_FILESIZE";s:4:"100M";s:12:"PHP_TIMEZONE";s:13:"Europe/Prague";s:33:"PIMCORE_INSTALL_MYSQL_HOST_SOCKET";s:13:"sunny_db-test";s:8:"HOSTNAME";s:12:"ff5a38cb0e12";s:26:"PIMCORE_INSTALL_MYSQL_PORT";s:4:"3306";s:11:"PHP_INI_DIR";s:18:"/usr/local/etc/php";s:21:"COMPOSER_MEMORY_LIMIT";s:2:"-1";s:4:"HOME";s:13:"/var/www/html";s:30:"PIMCORE_INSTALL_ADMIN_USERNAME";s:7:"awebsys";s:30:"PIMCORE_INSTALL_MYSQL_DATABASE";s:7:"pimcore";s:19:"MYSQL_ROOT_PASSWORD";s:14:"boo0caech2mo6V";s:11:"PHP_LDFLAGS";s:12:"-Wl,-O1 -pie";s:23:"PHP_FPM_PM_MAX_CHILDREN";s:1:"5";s:10:"PHP_CFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:11:"CUSTOM_USER";s:7:"project";s:11:"PHP_VERSION";s:6:"8.2.30";s:26:"OPCACHE_MEMORY_CONSUMPTION";s:3:"128";s:14:"PHP_FPM_LISTEN";s:12:"0.0.0.0:9000";s:16:"CUSTOM_USER_HOME";s:13:"/var/www/html";s:30:"PIMCORE_INSTALL_MYSQL_USERNAME";s:7:"pimcore";s:8:"GPG_KEYS";s:122:"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC";s:12:"PHP_CPPFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:11:"PHP_ASC_URL";s:55:"https://www.php.net/distributions/php-8.2.30.tar.xz.asc";s:24:"COMPOSER_ALLOW_SUPERUSER";s:1:"1";s:17:"PHP_POST_MAX_SIZE";s:4:"100M";s:7:"PHP_URL";s:51:"https://www.php.net/distributions/php-8.2.30.tar.xz";s:26:"PHP_DISPLAY_STARTUP_ERRORS";s:1:"1";s:18:"OPCACHE_ENABLE_CLI";s:1:"0";s:22:"PHP_MAX_EXECUTION_TIME";s:2:"30";s:14:"OPCACHE_ENABLE";s:1:"1";s:10:"PHP_FPM_PM";s:7:"dynamic";s:14:"MYSQL_PASSWORD";s:14:"shiepheezig3Ah";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:28:"PHP_FPM_PM_MIN_SPARE_SERVERS";s:1:"1";s:23:"PHP_FPM_PM_MAX_REQUESTS";s:5:"10000";s:16:"PHP_MEMORY_LIMIT";s:4:"256M";s:14:"POHODA_API_KEY";s:19:"sunny:0ssCCv6JyLk59";s:10:"MYSQL_USER";s:7:"pimcore";s:28:"PHP_FPM_PM_MAX_SPARE_SERVERS";s:1:"3";s:19:"PHP_ERROR_REPORTING";s:5:"E_ALL";s:30:"PIMCORE_INSTALL_ADMIN_PASSWORD";s:14:"eaka5Giechahvu";s:24:"PHP_FPM_PM_START_SERVERS";s:1:"2";s:30:"PIMCORE_INSTALL_MYSQL_PASSWORD";s:14:"shiepheezig3Ah";s:11:"PHPIZE_DEPS";s:76:"autoconf \t\tdpkg-dev \t\tfile \t\tg++ \t\tgcc \t\tlibc-dev \t\tmake \t\tpkg-config \t\tre2c";s:3:"PWD";s:17:"/var/www/html/src";s:10:"PHP_SHA256";s:64:"bc90523e17af4db46157e75d0c9ef0b9d0030b0514e62c26ba7b513b8c4eb015";s:14:"MYSQL_DATABASE";s:7:"pimcore";s:29:"OPCACHE_MAX_ACCELERATED_FILES";s:5:"10000";s:27:"OPCACHE_VALIDATE_TIMESTAMPS";s:1:"1";s:26:"OPCACHE_CONSISTENCY_CHECKS";s:1:"0";s:8:"LC_CTYPE";s:7:"C.UTF-8";s:18:"SUPERVISOR_ENABLED";s:1:"1";s:21:"SUPERVISOR_SERVER_URL";s:21:"http://localhost:9001";s:23:"SUPERVISOR_PROCESS_NAME";s:7:"php-fpm";s:21:"SUPERVISOR_GROUP_NAME";s:7:"php-fpm";s:4:"USER";s:7:"project";s:14:"HTTP_X_REAL_IP";s:13:"85.208.96.199";s:23:"HTTP_X_FORWARDED_SERVER";s:12:"66a920af6370";s:23:"HTTP_X_FORWARDED_SCHEME";s:5:"https";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:21:"HTTP_X_FORWARDED_PORT";s:3:"443";s:21:"HTTP_X_FORWARDED_HOST";s:25:"sunny-usa.test.awebsys.cz";s:20:"HTTP_X_FORWARDED_FOR";s:24:"85.208.96.199, 10.3.3.60";s:20:"HTTP_ACCEPT_ENCODING";s:12:"gzip,deflate";s:11:"HTTP_ACCEPT";s:99:"text/html, application/rss+xml, application/atom+xml, text/xml, text/rss+xml, application/xhtml+xml";s:15:"HTTP_USER_AGENT";s:75:"Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)";s:9:"HTTP_HOST";s:25:"sunny-usa.test.awebsys.cz";s:15:"SCRIPT_FILENAME";s:34:"/var/www/html/src/public/index.php";s:9:"PATH_INFO";s:0:"";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"SERVER_NAME";s:1:"_";s:11:"SERVER_PORT";s:2:"80";s:11:"SERVER_ADDR";s:11:"172.18.0.40";s:11:"REMOTE_USER";s:0:"";s:11:"REMOTE_PORT";s:5:"55442";s:11:"REMOTE_ADDR";s:11:"172.18.0.10";s:15:"SERVER_SOFTWARE";s:12:"nginx/1.22.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:14:"REQUEST_SCHEME";s:4:"http";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:13:"DOCUMENT_ROOT";s:24:"/var/www/html/src/public";s:12:"DOCUMENT_URI";s:10:"/index.php";s:11:"REQUEST_URI";s:67:"/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din";s:11:"SCRIPT_NAME";s:10:"/index.php";s:14:"CONTENT_LENGTH";s:0:"";s:12:"CONTENT_TYPE";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1770654409.506869;s:12:"REQUEST_TIME";i:1770654409;s:4:"argv";a:0:{}s:4:"argc";i:0;s:7:"APP_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:16:"PIMCORE_DEV_MODE";s:5:"false";s:15:"TRUSTED_PROXIES";s:21:"127.0.0.1,REMOTE_ADDR";s:12:"PROJECT_NAME";s:5:"sunny";s:19:"PROJECT_BASE_DOMAIN";s:15:"test.awebsys.cz";s:14:"PROJECT_DOMAIN";s:21:"sunny.test.awebsys.cz";s:17:"PROJECT_DOMAIN_US";s:25:"sunny-usa.test.awebsys.cz";s:15:"REQUIRED_SCHEME";s:5:"https";s:7:"DB_HOST";s:13:"sunny_db-test";s:7:"DB_PORT";s:4:"3306";s:13:"COMPOSER_HOME";s:17:"/var/www/html/src";s:18:"ELASTICSEARCH_USER";s:7:"elastic";s:18:"ELASTICSEARCH_PASS";s:14:"rohVixeemahc7a";s:18:"ELASTICSEARCH_HOST";s:24:"sunny_elasticsearch-test";s:18:"ELASTICSEARCH_PORT";s:4:"9200";s:8:"MAIL_DSN";s:37:"smtp://username:password@mailhog:1025";s:23:"MESSENGER_TRANSPORT_DSN";s:18:"doctrine://default";s:11:"GOPAY_GO_ID";s:10:"8145182639";s:16:"GOPAY_SECURE_KEY";s:24:"wzGQTrSUE2SrQrZ4WDE38HP7";s:15:"GOPAY_CLIENT_ID";s:10:"1417260856";s:19:"GOPAY_CLIENT_SECRET";s:8:"NbcmrB2B";s:17:"GOPAY_GATEWAY_URL";s:32:"https://gw.sandbox.gopay.com/api";s:17:"ORDER_SENDER_MAIL";s:19:"info@sunny-euro.com";s:19:"ORDER_RECEIVER_MAIL";s:18:"sunny@sunny-usa.us";s:19:"SYMFONY_DOTENV_VARS";s:392:"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,TRUSTED_PROXIES,PROJECT_NAME,PROJECT_BASE_DOMAIN,PROJECT_DOMAIN,PROJECT_DOMAIN_US,REQUIRED_SCHEME,DB_HOST,DB_PORT,COMPOSER_HOME,ELASTICSEARCH_USER,ELASTICSEARCH_PASS,ELASTICSEARCH_HOST,ELASTICSEARCH_PORT,MAIL_DSN,MESSENGER_TRANSPORT_DSN,GOPAY_GO_ID,GOPAY_SECURE_KEY,GOPAY_CLIENT_ID,GOPAY_CLIENT_SECRET,GOPAY_GATEWAY_URL,ORDER_SENDER_MAIL,ORDER_RECEIVER_MAIL";s:21:"DOCTRINE_DEPRECATIONS";s:7:"trigger";}" 1770654409 1] View formatted query View runnable query Explain query INSERT INTO http_error_log ( uri, code, parametersGet, parametersPost, cookies, serverVars, date, count ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES ('https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:121:{s:23:\"PHP_UPLOAD_MAX_FILESIZE\";s:4:\"100M\";s:12:\"PHP_TIMEZONE\";s:13:\"Europe/Prague\";s:33:\"PIMCORE_INSTALL_MYSQL_HOST_SOCKET\";s:13:\"sunny_db-test\";s:8:\"HOSTNAME\";s:12:\"ff5a38cb0e12\";s:26:\"PIMCORE_INSTALL_MYSQL_PORT\";s:4:\"3306\";s:11:\"PHP_INI_DIR\";s:18:\"/usr/local/etc/php\";s:21:\"COMPOSER_MEMORY_LIMIT\";s:2:\"-1\";s:4:\"HOME\";s:13:\"/var/www/html\";s:30:\"PIMCORE_INSTALL_ADMIN_USERNAME\";s:7:\"awebsys\";s:30:\"PIMCORE_INSTALL_MYSQL_DATABASE\";s:7:\"pimcore\";s:19:\"MYSQL_ROOT_PASSWORD\";s:14:\"boo0caech2mo6V\";s:11:\"PHP_LDFLAGS\";s:12:\"-Wl,-O1 -pie\";s:23:\"PHP_FPM_PM_MAX_CHILDREN\";s:1:\"5\";s:10:\"PHP_CFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:11:\"CUSTOM_USER\";s:7:\"project\";s:11:\"PHP_VERSION\";s:6:\"8.2.30\";s:26:\"OPCACHE_MEMORY_CONSUMPTION\";s:3:\"128\";s:14:\"PHP_FPM_LISTEN\";s:12:\"0.0.0.0:9000\";s:16:\"CUSTOM_USER_HOME\";s:13:\"/var/www/html\";s:30:\"PIMCORE_INSTALL_MYSQL_USERNAME\";s:7:\"pimcore\";s:8:\"GPG_KEYS\";s:122:\"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC\";s:12:\"PHP_CPPFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:11:\"PHP_ASC_URL\";s:55:\"https://www.php.net/distributions/php-8.2.30.tar.xz.asc\";s:24:\"COMPOSER_ALLOW_SUPERUSER\";s:1:\"1\";s:17:\"PHP_POST_MAX_SIZE\";s:4:\"100M\";s:7:\"PHP_URL\";s:51:\"https://www.php.net/distributions/php-8.2.30.tar.xz\";s:26:\"PHP_DISPLAY_STARTUP_ERRORS\";s:1:\"1\";s:18:\"OPCACHE_ENABLE_CLI\";s:1:\"0\";s:22:\"PHP_MAX_EXECUTION_TIME\";s:2:\"30\";s:14:\"OPCACHE_ENABLE\";s:1:\"1\";s:10:\"PHP_FPM_PM\";s:7:\"dynamic\";s:14:\"MYSQL_PASSWORD\";s:14:\"shiepheezig3Ah\";s:4:\"PATH\";s:60:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\";s:28:\"PHP_FPM_PM_MIN_SPARE_SERVERS\";s:1:\"1\";s:23:\"PHP_FPM_PM_MAX_REQUESTS\";s:5:\"10000\";s:16:\"PHP_MEMORY_LIMIT\";s:4:\"256M\";s:14:\"POHODA_API_KEY\";s:19:\"sunny:0ssCCv6JyLk59\";s:10:\"MYSQL_USER\";s:7:\"pimcore\";s:28:\"PHP_FPM_PM_MAX_SPARE_SERVERS\";s:1:\"3\";s:19:\"PHP_ERROR_REPORTING\";s:5:\"E_ALL\";s:30:\"PIMCORE_INSTALL_ADMIN_PASSWORD\";s:14:\"eaka5Giechahvu\";s:24:\"PHP_FPM_PM_START_SERVERS\";s:1:\"2\";s:30:\"PIMCORE_INSTALL_MYSQL_PASSWORD\";s:14:\"shiepheezig3Ah\";s:11:\"PHPIZE_DEPS\";s:76:\"autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c\";s:3:\"PWD\";s:17:\"/var/www/html/src\";s:10:\"PHP_SHA256\";s:64:\"bc90523e17af4db46157e75d0c9ef0b9d0030b0514e62c26ba7b513b8c4eb015\";s:14:\"MYSQL_DATABASE\";s:7:\"pimcore\";s:29:\"OPCACHE_MAX_ACCELERATED_FILES\";s:5:\"10000\";s:27:\"OPCACHE_VALIDATE_TIMESTAMPS\";s:1:\"1\";s:26:\"OPCACHE_CONSISTENCY_CHECKS\";s:1:\"0\";s:8:\"LC_CTYPE\";s:7:\"C.UTF-8\";s:18:\"SUPERVISOR_ENABLED\";s:1:\"1\";s:21:\"SUPERVISOR_SERVER_URL\";s:21:\"http://localhost:9001\";s:23:\"SUPERVISOR_PROCESS_NAME\";s:7:\"php-fpm\";s:21:\"SUPERVISOR_GROUP_NAME\";s:7:\"php-fpm\";s:4:\"USER\";s:7:\"project\";s:14:\"HTTP_X_REAL_IP\";s:13:\"85.208.96.199\";s:23:\"HTTP_X_FORWARDED_SERVER\";s:12:\"66a920af6370\";s:23:\"HTTP_X_FORWARDED_SCHEME\";s:5:\"https\";s:22:\"HTTP_X_FORWARDED_PROTO\";s:5:\"https\";s:21:\"HTTP_X_FORWARDED_PORT\";s:3:\"443\";s:21:\"HTTP_X_FORWARDED_HOST\";s:25:\"sunny-usa.test.awebsys.cz\";s:20:\"HTTP_X_FORWARDED_FOR\";s:24:\"85.208.96.199, 10.3.3.60\";s:20:\"HTTP_ACCEPT_ENCODING\";s:12:\"gzip,deflate\";s:11:\"HTTP_ACCEPT\";s:99:\"text/html, application/rss+xml, application/atom+xml, text/xml, text/rss+xml, application/xhtml+xml\";s:15:\"HTTP_USER_AGENT\";s:75:\"Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)\";s:9:\"HTTP_HOST\";s:25:\"sunny-usa.test.awebsys.cz\";s:15:\"SCRIPT_FILENAME\";s:34:\"/var/www/html/src/public/index.php\";s:9:\"PATH_INFO\";s:0:\"\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:11:\"SERVER_NAME\";s:1:\"_\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"SERVER_ADDR\";s:11:\"172.18.0.40\";s:11:\"REMOTE_USER\";s:0:\"\";s:11:\"REMOTE_PORT\";s:5:\"55442\";s:11:\"REMOTE_ADDR\";s:11:\"172.18.0.10\";s:15:\"SERVER_SOFTWARE\";s:12:\"nginx/1.22.1\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:14:\"REQUEST_SCHEME\";s:4:\"http\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:13:\"DOCUMENT_ROOT\";s:24:\"/var/www/html/src/public\";s:12:\"DOCUMENT_URI\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:67:\"/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:14:\"CONTENT_LENGTH\";s:0:\"\";s:12:\"CONTENT_TYPE\";s:0:\"\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:12:\"QUERY_STRING\";s:0:\"\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:18:\"REQUEST_TIME_FLOAT\";d:1770654409.506869;s:12:\"REQUEST_TIME\";i:1770654409;s:4:\"argv\";a:0:{}s:4:\"argc\";i:0;s:7:\"APP_ENV\";s:3:\"dev\";s:9:\"APP_DEBUG\";s:1:\"0\";s:16:\"PIMCORE_DEV_MODE\";s:5:\"false\";s:15:\"TRUSTED_PROXIES\";s:21:\"127.0.0.1,REMOTE_ADDR\";s:12:\"PROJECT_NAME\";s:5:\"sunny\";s:19:\"PROJECT_BASE_DOMAIN\";s:15:\"test.awebsys.cz\";s:14:\"PROJECT_DOMAIN\";s:21:\"sunny.test.awebsys.cz\";s:17:\"PROJECT_DOMAIN_US\";s:25:\"sunny-usa.test.awebsys.cz\";s:15:\"REQUIRED_SCHEME\";s:5:\"https\";s:7:\"DB_HOST\";s:13:\"sunny_db-test\";s:7:\"DB_PORT\";s:4:\"3306\";s:13:\"COMPOSER_HOME\";s:17:\"/var/www/html/src\";s:18:\"ELASTICSEARCH_USER\";s:7:\"elastic\";s:18:\"ELASTICSEARCH_PASS\";s:14:\"rohVixeemahc7a\";s:18:\"ELASTICSEARCH_HOST\";s:24:\"sunny_elasticsearch-test\";s:18:\"ELASTICSEARCH_PORT\";s:4:\"9200\";s:8:\"MAIL_DSN\";s:37:\"smtp://username:password@mailhog:1025\";s:23:\"MESSENGER_TRANSPORT_DSN\";s:18:\"doctrine://default\";s:11:\"GOPAY_GO_ID\";s:10:\"8145182639\";s:16:\"GOPAY_SECURE_KEY\";s:24:\"wzGQTrSUE2SrQrZ4WDE38HP7\";s:15:\"GOPAY_CLIENT_ID\";s:10:\"1417260856\";s:19:\"GOPAY_CLIENT_SECRET\";s:8:\"NbcmrB2B\";s:17:\"GOPAY_GATEWAY_URL\";s:32:\"https://gw.sandbox.gopay.com/api\";s:17:\"ORDER_SENDER_MAIL\";s:19:\"info@sunny-euro.com\";s:19:\"ORDER_RECEIVER_MAIL\";s:18:\"sunny@sunny-usa.us\";s:19:\"SYMFONY_DOTENV_VARS\";s:392:\"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,TRUSTED_PROXIES,PROJECT_NAME,PROJECT_BASE_DOMAIN,PROJECT_DOMAIN,PROJECT_DOMAIN_US,REQUIRED_SCHEME,DB_HOST,DB_PORT,COMPOSER_HOME,ELASTICSEARCH_USER,ELASTICSEARCH_PASS,ELASTICSEARCH_HOST,ELASTICSEARCH_PORT,MAIL_DSN,MESSENGER_TRANSPORT_DSN,GOPAY_GO_ID,GOPAY_SECURE_KEY,GOPAY_CLIENT_ID,GOPAY_CLIENT_SECRET,GOPAY_GATEWAY_URL,ORDER_SENDER_MAIL,ORDER_RECEIVER_MAIL\";s:21:\"DOCTRINE_DEPRECATIONS\";s:7:\"trigger\";}', 1770654409, 1);
38	0.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
39	0.19 ms	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 = 1 ORDER BY `priority` DESC Parameters: [`"/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "path" "auto_create" "/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "path_query" "https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "entire_uri"`] View formatted query View runnable query Explain query 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 = 1 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND `type` = 'path_query') OR (source = 'https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 1 ORDER BY `priority` DESC;
40	0.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
41	0.18 ms	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: [`"/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "path" "auto_create" "/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "path_query" "https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din" "entire_uri"`] View formatted query View runnable query Explain query 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 SELECT * FROM redirects WHERE ( (source = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND `type` = 'path_query') OR (source = 'https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din' AND `type` = 'entire_uri') ) 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore_generic_data_index	doctrine.orm.pimcore_generic_data_index_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://sunny-usa.test.awebsys.cz/fr/produits/connecteurs/Connecteurs/kpp-4p-connector-4pin-mini-din

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping