https://maliarskepotreby.sk/eshop/14/login Return to referer URL

Query Metrics

17 Database Queries
8 Different statements
11.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
0.30 ms
(2.67%)
2
SELECT e0_.eshop_id AS eshop_id_0, e0_.eshop_name AS eshop_name_1, e0_.user_id AS user_id_2, e0_.eshop_type AS eshop_type_3, e0_.priority AS priority_4, e0_.status AS status_5, e0_.date_inserted AS date_inserted_6, e0_.date_last_control AS date_last_control_7, e0_.logo_url AS logo_url_8, e0_.notes AS notes_9, e0_.admin_user_id AS admin_user_id_10, e0_.eshop_email AS eshop_email_11, e0_.order_email AS order_email_12, e0_.eshop_price AS eshop_price_13, e0_.eshop_current AS eshop_current_14, e0_.eshop_css AS eshop_css_15, e0_.product_view AS product_view_16, e0_.image_thumb_width AS image_thumb_width_17, e0_.image_thumb_height AS image_thumb_height_18, e0_.wire_frame_id AS wire_frame_id_19, e0_.product_list_wire_frame_id AS product_list_wire_frame_id_20, e0_.product_detail_wire_frame_id AS product_detail_wire_frame_id_21, e0_.preferred_language_id AS preferred_language_id_22, e0_.preferred_currency_id AS preferred_currency_id_23, e0_.round_price AS round_price_24, e0_.cut_long_description AS cut_long_description_25, e0_.display_products_from_subfolders AS display_products_from_subfolders_26, e0_.count_per_page AS count_per_page_27, e0_.is_product_catalogue AS is_product_catalogue_28, e0_.is_price_display AS is_price_display_29, e0_.display_netto_prices AS display_netto_prices_30, e0_.preferred_vat AS preferred_vat_31, e0_.category_image_thumb_width AS category_image_thumb_width_32, e0_.is_stock AS is_stock_33, e0_.display_products_from_subfolders_level AS display_products_from_subfolders_level_34, e0_.is_asynchrounous_shopping AS is_asynchrounous_shopping_35, e0_.is_virtual_reality AS is_virtual_reality_36 FROM eshop e0_ WHERE e0_.eshop_id = ?
Parameters:
[
  "14"
]
0.11 ms
(0.97%)
2
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:
[
  28
]
0.05 ms
(0.40%)
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:
[
  5
]

dynamic_conn connection

Time Count Info
4.08 ms
(36.46%)
1
SELECT c0_.contact_id AS contact_id_0, c0_.title AS title_1, c0_.first_name AS first_name_2, c0_.middle_name AS middle_name_3, c0_.last_name AS last_name_4, c0_.nick_name AS nick_name_5, c0_.company_name AS company_name_6, c0_.email AS email_7, c0_.email2 AS email2_8, c0_.email3 AS email3_9, c0_.phone AS phone_10, c0_.phone2 AS phone2_11, c0_.phone3 AS phone3_12, c0_.address1 AS address1_13, c0_.address2 AS address2_14, c0_.zip_code AS zip_code_15, c0_.country AS country_16, c0_.invoice_address1 AS invoice_address1_17, c0_.invoice_address2 AS invoice_address2_18, c0_.invoice_zip_code AS invoice_zip_code_19, c0_.invoice_country AS invoice_country_20, c0_.image1 AS image1_21, c0_.image2 AS image2_22, c0_.contact_user_name AS contact_user_name_23, c0_.contact_user_password AS contact_user_password_24, c0_.business_id AS business_id_25, c0_.dicid AS dicid_26, c0_.notes AS notes_27, c0_.erpkey AS erpkey_28, c0_.address_id AS address_id_29, c0_.delivery_address_id AS delivery_address_id_30, c0_.price_level_id AS price_level_id_31 FROM contact c0_ WHERE c0_.contact_user_name = ? AND c0_.contact_user_password = ?
Parameters:
[
  "webexciter@yahoo.com"
  "f70ecad3431881609e80685b57c48506"
]
3.11 ms
(27.85%)
5
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"
]
2.53 ms
(22.62%)
1
SELECT c0_.contact_id AS contact_id_0, c0_.title AS title_1, c0_.first_name AS first_name_2, c0_.middle_name AS middle_name_3, c0_.last_name AS last_name_4, c0_.nick_name AS nick_name_5, c0_.company_name AS company_name_6, c0_.email AS email_7, c0_.email2 AS email2_8, c0_.email3 AS email3_9, c0_.phone AS phone_10, c0_.phone2 AS phone2_11, c0_.phone3 AS phone3_12, c0_.address1 AS address1_13, c0_.address2 AS address2_14, c0_.zip_code AS zip_code_15, c0_.country AS country_16, c0_.invoice_address1 AS invoice_address1_17, c0_.invoice_address2 AS invoice_address2_18, c0_.invoice_zip_code AS invoice_zip_code_19, c0_.invoice_country AS invoice_country_20, c0_.image1 AS image1_21, c0_.image2 AS image2_22, c0_.contact_user_name AS contact_user_name_23, c0_.contact_user_password AS contact_user_password_24, c0_.business_id AS business_id_25, c0_.dicid AS dicid_26, c0_.notes AS notes_27, c0_.erpkey AS erpkey_28, c0_.address_id AS address_id_29, c0_.delivery_address_id AS delivery_address_id_30, c0_.price_level_id AS price_level_id_31 FROM contact c0_ WHERE c0_.contact_id = ?
Parameters:
[
  1
]
0.93 ms
(8.30%)
3
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_.eshop_id = ? AND w0_.web_page_type = ?
Parameters:
[
  "14"
  2
]
0.08 ms
(0.73%)
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:
[
  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\Eshop No errors.
App\Entity\Language No errors.
App\Entity\Currency No errors.
App\Entity\User No errors.
App\Entity\Service No errors.
App\Entity\Module No errors.
App\Entity\WireFrame No errors.

dynamic_em entity manager

Class Mapping errors
App\Entity\Eshop No errors.
App\Entity\WebPage No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
App\Entity\WebPageTranslation No errors.
App\Entity\Contact No errors.
App\Entity\Address No errors.
App\Entity\PriceLevel No errors.
App\Entity\ContactGroup No errors.
App\Entity\Consent No errors.

eshop_em entity manager

No loaded entities.

eshop_demo_em entity manager

No loaded entities.