Query Metrics
7
Database Queries
7
Different statements
5.05 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
3.77 ms (74.66%) |
1 |
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_ WHERE l0_.lang_id = ?
Parameters:
[
1
]
|
0.94 ms (18.52%) |
1 |
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_
Parameters:
[] |
0.14 ms (2.75%) |
1 |
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.http_host = ? OR s0_.http_host = ?
Parameters:
[ "www.vrcommerce.eu" "www.www.vrcommerce.eu" ] |
0.06 ms (1.28%) |
1 |
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.label = ?
Parameters:
[
"vrcommerce.eu"
]
|
0.05 ms (1.05%) |
1 |
SELECT t0.service_id AS service_id_1, t0.service_name AS service_name_2, t0.action AS action_3, t0.service_type AS service_type_4, t0.is_live AS is_live_5, t0.image AS image_6, t0.importance AS importance_7, t0.trial_months AS trial_months_8, t0.landing_url AS landing_url_9, t0.register_url AS register_url_10, t0.price AS price_11, t0.background_image AS background_image_12 FROM service t0 INNER JOIN server_service ON t0.service_id = server_service.service_id WHERE server_service.server_id = ?
Parameters:
[
16
]
|
0.05 ms (0.89%) |
1 |
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_
Parameters:
[] |
0.04 ms (0.83%) |
1 |
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = ?
Parameters:
[
1
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
dynamic_conn | doctrine.dbal.dynamic_conn_connection |
eshop_conn | doctrine.dbal.eshop_conn_connection |
eshop_demo_conn | doctrine.dbal.eshop_demo_conn_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
dynamic_em | doctrine.orm.dynamic_em_entity_manager |
eshop_em | doctrine.orm.eshop_em_entity_manager |
eshop_demo_em | doctrine.orm.eshop_demo_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Server | No errors. |
App\Entity\Service | No errors. |
App\Entity\Language | No errors. |
App\Entity\Currency | No errors. |
App\Entity\Module | No errors. |
dynamic_em entity manager
No loaded entities.
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.