Query Metrics
8
Database Queries
8
Different statements
3.47 ms
Query time
0
Invalid entities
8
Managed entities
5
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
0.99 ms (28.61%) |
1 |
SELECT t0.path AS path_1, t0.alias AS alias_2, t0.primary_path AS primary_path_3, t0.type AS type_4, t0.method AS method_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM path_alias t0 WHERE t0.path = ? AND t0.locale_code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/actuator/gateway/routes" "en" 1 ] |
0.52 ms (15.05%) |
1 |
"COMMIT"
Parameters:
[] |
0.47 ms (13.56%) |
1 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.hostname AS hostname_3, t0.theme_name AS theme_name_4, t0.type AS type_5, t0.regional_locale AS regional_locale_6, t0.email_support AS email_support_7, t0.email_sales AS email_sales_8, t0.email_accounts AS email_accounts_9, t0.email_feedback AS email_feedback_10, t0.email_orders AS email_orders_11, t0.base_vat_rate AS base_vat_rate_12, t0.main_phone_number AS main_phone_number_13, t0.base_country_code AS base_country_code_14, t0.email_careers AS email_careers_15, t0.email_media AS email_media_16, t0.opening_hours AS opening_hours_17, t0.id AS id_18, t0.uuid AS uuid_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.handle AS handle_22, t0.active AS active_23, t0.default_locale_id AS default_locale_id_24, t0.base_currency_id AS base_currency_id_25, t0.bank_details_id AS bank_details_id_26, t0.site_banner_id AS site_banner_id_27 FROM channel t0 WHERE t0.hostname = ? LIMIT 1
Parameters:
[
"81.149.192.100"
]
|
0.40 ms (11.68%) |
1 |
INSERT INTO url_debug_log (http_status_code, current_url, redirect_url, query_string, referer_url, log_info, created_at, channel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 404 "https://81.149.192.100/actuator/gateway/routes" null null null null "2025-06-29 00:31:15" 1 ] |
0.31 ms (8.97%) |
1 |
SELECT t0.match_path AS match_path_1, t0.redirect_path AS redirect_path_2, t0.status_code AS status_code_3, t0.active AS active_4, t0.id AS id_5, t0.channel_id AS channel_id_6 FROM redirect t0 WHERE t0.match_path = ? AND t0.channel_id = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/actuator/gateway/routes" 1 1 ] |
0.29 ms (8.36%) |
1 |
SELECT t0.path AS path_1, t0.alias AS alias_2, t0.primary_path AS primary_path_3, t0.type AS type_4, t0.method AS method_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM path_alias t0 WHERE t0.path = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/actuator/gateway/routes" 1 ] |
0.27 ms (7.65%) |
1 |
SELECT t0.match_path AS match_path_1, t0.redirect_path AS redirect_path_2, t0.status_code AS status_code_3, t0.type AS type_4, t0.legacy_data AS legacy_data_5, t0.notes AS notes_6, t0.node_path AS node_path_7, t0.active AS active_8, t0.id AS id_9, t0.channel_id AS channel_id_10 FROM legacy_redirect t0 WHERE t0.match_path = ? AND t0.channel_id = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/actuator/gateway/routes" 1 1 ] |
0.21 ms (6.11%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
old_global_db | doctrine.dbal.old_global_db_connection |
old_latestimport_db | doctrine.dbal.old_latestimport_db_connection |
locale_uk | doctrine.dbal.locale_uk_connection |
locale_de | doctrine.dbal.locale_de_connection |
locale_es | doctrine.dbal.locale_es_connection |
locale_fr | doctrine.dbal.locale_fr_connection |
locale_it | doctrine.dbal.locale_it_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
5
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
core_write_rare | 3 |
core_append_only | 2 |
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Currency | 3 |
App\Entity\Locale | 1 |
App\Entity\BankDetails | 1 |
App\Entity\Channel | 1 |
App\Entity\SiteBanner | 1 |
App\Entity\UrlDebugLog | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Channel | No errors. |
App\Entity\Locale | No errors. |
App\Entity\Currency | No errors. |
App\Entity\BankDetails | No errors. |
App\Entity\SiteBanner | No errors. |
App\Entity\Product | No errors. |
App\Entity\Feedback | No errors. |
App\Entity\PaymentMethod | No errors. |
App\Entity\Voucher | No errors. |
App\Entity\SearchHistoryItem | No errors. |
App\Entity\DeliveryOption | No errors. |
App\Entity\TrendingSearch | No errors. |
App\Entity\PathAlias | No errors. |
App\Entity\Redirect | No errors. |
App\Entity\LegacyRedirect | No errors. |
App\Entity\UrlDebugLog | No errors. |