Query Metrics
26
Database Queries
16
Different statements
11.18 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
5.30 ms (47.43%) |
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:
[ "virtualrealitycommerce.eu" "www.virtualrealitycommerce.eu" ] |
0.79 ms (7.08%) |
1 |
SELECT w0_.wire_frame_id AS wire_frame_id_0, w0_.wire_frame_name AS wire_frame_name_1, w0_.wire_frame_file AS wire_frame_file_2, w0_.wire_frame_image AS wire_frame_image_3, w0_.service_id AS service_id_4 FROM wire_frame w0_ WHERE w0_.wire_frame_id = ?
Parameters:
[
1
]
|
0.63 ms (5.62%) |
1 |
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ?
Parameters:
[
95
]
|
0.18 ms (1.64%) |
2 |
SELECT w0_.website_id AS website_id_0, w0_.website_name AS website_name_1, w0_.date_created AS date_created_2, w0_.date_last_login AS date_last_login_3, w0_.version AS version_4, w0_.design_css AS design_css_5, w0_.layout_id AS layout_id_6, w0_.status_id AS status_id_7, w0_.notes AS notes_8, w0_.website_url AS website_url_9, w0_.date_payment AS date_payment_10, w0_.homepage_id AS homepage_id_11, w0_.user_id AS user_id_12, w0_.website_current AS website_current_13, w0_.website_css AS website_css_14, w0_.wire_frame_id AS wire_frame_id_15, w0_.preferred_language_id AS preferred_language_id_16 FROM website w0_ WHERE w0_.website_id = ?
Parameters:
[
"56"
]
|
0.05 ms (0.48%) |
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:
[
"virtualrealitycommerce.eu"
]
|
0.05 ms (0.41%) |
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.04 ms (0.38%) |
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.04 ms (0.35%) |
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.33%) |
1 |
SELECT t0.lang_id AS lang_id_1, t0.lang_name AS lang_name_2, t0.lang_key AS lang_key_3, t0.is_live AS is_live_4 FROM language t0 INNER JOIN website_language ON t0.lang_id = website_language.lang_id WHERE website_language.website_id = ?
Parameters:
[
56
]
|
0.04 ms (0.33%) |
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:
[
12
]
|
0.04 ms (0.32%) |
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
]
|
dynamic_conn connection
Time▼ | Count | Info |
---|---|---|
3.38 ms (30.26%) |
4 |
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\WebPage" ] |
0.24 ms (2.13%) |
1 |
SELECT w0_.web_page_id AS web_page_id_0, w0_.web_page_name AS web_page_name_1, w0_.web_page_content AS web_page_content_2, w0_.web_page_description AS web_page_description_3, w0_.website_id AS website_id_4, w0_.eshop_id AS eshop_id_5, w0_.date_inserted AS date_inserted_6, w0_.date_last_control AS date_last_control_7, w0_.date_published AS date_published_8, w0_.web_page_type AS web_page_type_9, w0_.seo_title AS seo_title_10, w0_.seo_description AS seo_description_11, w0_.priority AS priority_12, w0_.image_file AS image_file_13, w0_.score AS score_14, w0_.auction_hall_id AS auction_hall_id_15 FROM web_page w0_ WHERE w0_.web_page_id = ?
Parameters:
[
"5"
]
|
0.16 ms (1.47%) |
4 |
SELECT w0_.web_page_id AS web_page_id_0, w0_.web_page_name AS web_page_name_1, w0_.web_page_content AS web_page_content_2, w0_.web_page_description AS web_page_description_3, w0_.website_id AS website_id_4, w0_.eshop_id AS eshop_id_5, w0_.date_inserted AS date_inserted_6, w0_.date_last_control AS date_last_control_7, w0_.date_published AS date_published_8, w0_.web_page_type AS web_page_type_9, w0_.seo_title AS seo_title_10, w0_.seo_description AS seo_description_11, w0_.priority AS priority_12, w0_.image_file AS image_file_13, w0_.score AS score_14, w0_.auction_hall_id AS auction_hall_id_15 FROM web_page w0_ WHERE w0_.website_id = ? AND w0_.web_page_type = ?
Parameters:
[ "56" 2 ] |
0.11 ms (1.01%) |
3 |
SELECT w0_.web_menu_id AS web_menu_id_0, w0_.web_menu_name AS web_menu_name_1, w0_.web_menu_content_before AS web_menu_content_before_2, w0_.web_menu_content_after AS web_menu_content_after_3, w0_.website_id AS website_id_4, w0_.web_menu_type AS web_menu_type_5 FROM web_menu w0_ WHERE w0_.website_id = ? AND w0_.web_menu_type = ?
Parameters:
[ "56" 0 ] |
0.08 ms (0.75%) |
2 |
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
Parameters:
[
5
]
|
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\Website | No errors. |
App\Entity\Language | No errors. |
App\Entity\User | No errors. |
App\Entity\Service | No errors. |
App\Entity\Module | No errors. |
App\Entity\Server | No errors. |
App\Entity\Currency | No errors. |
App\Entity\WireFrame | No errors. |
dynamic_em entity manager
Class | Mapping errors |
---|---|
App\Entity\WebPage | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\WebPageTranslation | No errors. |
App\Entity\WebMenu | No errors. |
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.