Query Metrics
5
Database Queries
5
Different statements
1.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.77 ms (38.47%) |
1 |
SELECT n0_.id_employee AS id_employee_0, n0_.firstname AS firstname_1, n0_.lastname AS lastname_2, n0_.email AS email_3, n0_.passwd AS passwd_4, n0_.last_passwd_gen AS last_passwd_gen_5, n0_.reset_password_token AS reset_password_token_6, n0_.reset_password_validity AS reset_password_validity_7, n0_.default_tab AS default_tab_8, n0_.active AS active_9, n0_.last_connection_date AS last_connection_date_10, n0_.has_enabled_gravatar AS has_enabled_gravatar_11, n0_.stats_date_from AS stats_date_from_12, n0_.stats_date_to AS stats_date_to_13, n0_.stats_compare_from AS stats_compare_from_14, n0_.stats_compare_to AS stats_compare_to_15, n0_.stats_compare_option AS stats_compare_option_16, n0_.preselect_date_range AS preselect_date_range_17, n0_.bo_color AS bo_color_18, n0_.bo_theme AS bo_theme_19, n0_.bo_css AS bo_css_20, n0_.bo_width AS bo_width_21, n0_.bo_menu AS bo_menu_22, n0_.optin AS optin_23, n0_.id_last_order AS id_last_order_24, n0_.id_last_customer_message AS id_last_customer_message_25, n0_.id_last_customer AS id_last_customer_26, n0_.id_employee AS id_employee_27, n0_.firstname AS firstname_28, n0_.lastname AS lastname_29, n0_.email AS email_30, n0_.passwd AS passwd_31, n0_.last_passwd_gen AS last_passwd_gen_32, n0_.reset_password_token AS reset_password_token_33, n0_.reset_password_validity AS reset_password_validity_34, n0_.default_tab AS default_tab_35, n0_.active AS active_36, n0_.last_connection_date AS last_connection_date_37, n0_.has_enabled_gravatar AS has_enabled_gravatar_38, n0_.stats_date_from AS stats_date_from_39, n0_.stats_date_to AS stats_date_to_40, n0_.stats_compare_from AS stats_compare_from_41, n0_.stats_compare_to AS stats_compare_to_42, n0_.stats_compare_option AS stats_compare_option_43, n0_.preselect_date_range AS preselect_date_range_44, n0_.bo_color AS bo_color_45, n0_.bo_theme AS bo_theme_46, n0_.bo_css AS bo_css_47, n0_.bo_width AS bo_width_48, n0_.bo_menu AS bo_menu_49, n0_.optin AS optin_50, n0_.id_last_order AS id_last_order_51, n0_.id_last_customer_message AS id_last_customer_message_52, n0_.id_last_customer AS id_last_customer_53, n1_.id_profile AS id_profile_54, n2_.id_lang AS id_lang_55, n2_.name AS name_56, n2_.active AS active_57, n2_.iso_code AS iso_code_58, n2_.language_code AS language_code_59, n2_.locale AS locale_60, n2_.date_format_lite AS date_format_lite_61, n2_.date_format_full AS date_format_full_62, n2_.is_rtl AS is_rtl_63, n3_.id_employee_session AS id_employee_session_64, n3_.token AS token_65, n3_.date_add AS date_add_66, n3_.date_upd AS date_upd_67, n0_.id_profile AS id_profile_68, n0_.id_lang AS id_lang_69, n3_.id_employee AS id_employee_70 FROM n4u0_employee n0_ LEFT JOIN n4u0_profile n1_ ON n0_.id_profile = n1_.id_profile LEFT JOIN n4u0_lang n2_ ON n0_.id_lang = n2_.id_lang LEFT JOIN n4u0_employee_session n3_ ON n0_.id_employee = n3_.id_employee WHERE n0_.email = ?
Parameters:
[
"sila27.3.2022@gmail.com"
]
|
|
0.48 ms (24.32%) |
1 |
SELECT n0_.id_tab AS id_tab_0, n0_.class_name AS class_name_1 FROM n4u0_tab n0_ WHERE n0_.class_name = BINARY(?) AND n0_.id_tab <> 0
Parameters:
[
"Admin"
]
|
|
0.34 ms (17.21%) |
1 |
SELECT t0.id_employee AS id_employee_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.passwd AS passwd_5, t0.last_passwd_gen AS last_passwd_gen_6, t0.reset_password_token AS reset_password_token_7, t0.reset_password_validity AS reset_password_validity_8, t0.default_tab AS default_tab_9, t0.active AS active_10, t0.last_connection_date AS last_connection_date_11, t0.has_enabled_gravatar AS has_enabled_gravatar_12, t0.stats_date_from AS stats_date_from_13, t0.stats_date_to AS stats_date_to_14, t0.stats_compare_from AS stats_compare_from_15, t0.stats_compare_to AS stats_compare_to_16, t0.stats_compare_option AS stats_compare_option_17, t0.preselect_date_range AS preselect_date_range_18, t0.bo_color AS bo_color_19, t0.bo_theme AS bo_theme_20, t0.bo_css AS bo_css_21, t0.bo_width AS bo_width_22, t0.bo_menu AS bo_menu_23, t0.optin AS optin_24, t0.id_last_order AS id_last_order_25, t0.id_last_customer_message AS id_last_customer_message_26, t0.id_last_customer AS id_last_customer_27, t0.id_profile AS id_profile_28, t0.id_lang AS id_lang_29 FROM n4u0_employee t0 WHERE t0.id_employee = ?
Parameters:
[
4
]
|
|
0.23 ms (11.38%) |
1 |
SELECT t0.id_employee_session AS id_employee_session_1, t0.token AS token_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.id_employee AS id_employee_5 FROM n4u0_employee_session t0 WHERE t0.id_employee = ?
Parameters:
[
4
]
|
|
0.17 ms (8.62%) |
1 |
SELECT s.id_shop FROM n4u0_shop s
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\Employee\Employee | No errors. |
| PrestaShopBundle\Entity\Employee\Profile | No errors. |
| PrestaShopBundle\Entity\Lang | No errors. |
| PrestaShopBundle\Entity\Employee\EmployeeSession | No errors. |
| PrestaShopBundle\Entity\Employee\AuthorizationRole | No errors. |
| PrestaShopBundle\Entity\Translation | No errors. |
| PrestaShopBundle\Entity\Shop | No errors. |
| PrestaShopBundle\Entity\Tab | No errors. |