Query Metrics
8
Database Queries
7
Different statements
7.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.85 ms (40.53%) |
2 |
SELECT d0_.id_employee AS id_employee_0, d0_.firstname AS firstname_1, d0_.lastname AS lastname_2, d0_.email AS email_3, d0_.passwd AS passwd_4, d0_.last_passwd_gen AS last_passwd_gen_5, d0_.reset_password_token AS reset_password_token_6, d0_.reset_password_validity AS reset_password_validity_7, d0_.default_tab AS default_tab_8, d0_.active AS active_9, d0_.last_connection_date AS last_connection_date_10, d0_.has_enabled_gravatar AS has_enabled_gravatar_11, d0_.stats_date_from AS stats_date_from_12, d0_.stats_date_to AS stats_date_to_13, d0_.stats_compare_from AS stats_compare_from_14, d0_.stats_compare_to AS stats_compare_to_15, d0_.stats_compare_option AS stats_compare_option_16, d0_.preselect_date_range AS preselect_date_range_17, d0_.bo_color AS bo_color_18, d0_.bo_theme AS bo_theme_19, d0_.bo_css AS bo_css_20, d0_.bo_width AS bo_width_21, d0_.bo_menu AS bo_menu_22, d0_.optin AS optin_23, d0_.id_last_order AS id_last_order_24, d0_.id_last_customer_message AS id_last_customer_message_25, d0_.id_last_customer AS id_last_customer_26, d0_.id_employee AS id_employee_27, d0_.firstname AS firstname_28, d0_.lastname AS lastname_29, d0_.email AS email_30, d0_.passwd AS passwd_31, d0_.last_passwd_gen AS last_passwd_gen_32, d0_.reset_password_token AS reset_password_token_33, d0_.reset_password_validity AS reset_password_validity_34, d0_.default_tab AS default_tab_35, d0_.active AS active_36, d0_.last_connection_date AS last_connection_date_37, d0_.has_enabled_gravatar AS has_enabled_gravatar_38, d0_.stats_date_from AS stats_date_from_39, d0_.stats_date_to AS stats_date_to_40, d0_.stats_compare_from AS stats_compare_from_41, d0_.stats_compare_to AS stats_compare_to_42, d0_.stats_compare_option AS stats_compare_option_43, d0_.preselect_date_range AS preselect_date_range_44, d0_.bo_color AS bo_color_45, d0_.bo_theme AS bo_theme_46, d0_.bo_css AS bo_css_47, d0_.bo_width AS bo_width_48, d0_.bo_menu AS bo_menu_49, d0_.optin AS optin_50, d0_.id_last_order AS id_last_order_51, d0_.id_last_customer_message AS id_last_customer_message_52, d0_.id_last_customer AS id_last_customer_53, d1_.id_profile AS id_profile_54, d2_.id_lang AS id_lang_55, d2_.name AS name_56, d2_.active AS active_57, d2_.iso_code AS iso_code_58, d2_.language_code AS language_code_59, d2_.locale AS locale_60, d2_.date_format_lite AS date_format_lite_61, d2_.date_format_full AS date_format_full_62, d2_.is_rtl AS is_rtl_63, d3_.id_employee_session AS id_employee_session_64, d3_.token AS token_65, d3_.date_add AS date_add_66, d3_.date_upd AS date_upd_67, d0_.id_profile AS id_profile_68, d0_.id_lang AS id_lang_69, d3_.id_employee AS id_employee_70 FROM djf0t_employee d0_ LEFT JOIN djf0t_profile d1_ ON d0_.id_profile = d1_.id_profile LEFT JOIN djf0t_lang d2_ ON d0_.id_lang = d2_.id_lang LEFT JOIN djf0t_employee_session d3_ ON d0_.id_employee = d3_.id_employee WHERE d0_.email = ?
Parameters:
[
"firma@tvojsen-mido.sk"
]
|
|
1.79 ms (25.45%) |
1 |
SELECT t0.id_authorization_role AS id_authorization_role_1, t0.slug AS slug_2 FROM djf0t_authorization_role t0 INNER JOIN djf0t_access ON t0.id_authorization_role = djf0t_access.id_authorization_role WHERE djf0t_access.id_profile = ?
Parameters:
[
1
]
|
|
1.62 ms (23.04%) |
1 |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM djf0t_lang t0 WHERE t0.id_lang = ?
Parameters:
[
"2"
]
|
|
0.25 ms (3.55%) |
1 |
INSERT INTO djf0t_employee_session (token, date_add, date_upd, id_employee) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "0b620ff589cc377ae44a1f56b22e43bb18a77500" 2 => "2026-11-08 13:43:50" 3 => "2026-11-08 13:43:50" 4 => 2 ] |
|
0.23 ms (3.32%) |
1 |
SELECT s.id_shop FROM djf0t_shop s
Parameters:
[] |
|
0.15 ms (2.09%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.14 ms (2.02%) |
1 |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| PrestaShopBundle\Entity\Lang | No errors. |
| PrestaShopBundle\Entity\Translation | No errors. |
| PrestaShopBundle\Entity\Shop | No errors. |
| PrestaShopBundle\Entity\Employee\Employee | No errors. |
| PrestaShopBundle\Entity\Employee\Profile | No errors. |
| PrestaShopBundle\Entity\Employee\EmployeeSession | No errors. |
| PrestaShopBundle\Entity\Employee\AuthorizationRole | No errors. |