Query Metrics
9
Database Queries
8
Different statements
19.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.33 ms |
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 ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
"1"
]
|
| 2 | 8.34 ms |
SELECT p0_.id_employee AS id_employee_0, p0_.firstname AS firstname_1, p0_.lastname AS lastname_2, p0_.email AS email_3, p0_.passwd AS passwd_4, p0_.last_passwd_gen AS last_passwd_gen_5, p0_.reset_password_token AS reset_password_token_6, p0_.reset_password_validity AS reset_password_validity_7, p0_.default_tab AS default_tab_8, p0_.active AS active_9, p0_.last_connection_date AS last_connection_date_10, p0_.has_enabled_gravatar AS has_enabled_gravatar_11, p0_.stats_date_from AS stats_date_from_12, p0_.stats_date_to AS stats_date_to_13, p0_.stats_compare_from AS stats_compare_from_14, p0_.stats_compare_to AS stats_compare_to_15, p0_.stats_compare_option AS stats_compare_option_16, p0_.preselect_date_range AS preselect_date_range_17, p0_.bo_color AS bo_color_18, p0_.bo_theme AS bo_theme_19, p0_.bo_css AS bo_css_20, p0_.bo_width AS bo_width_21, p0_.bo_menu AS bo_menu_22, p0_.optin AS optin_23, p0_.id_last_order AS id_last_order_24, p0_.id_last_customer_message AS id_last_customer_message_25, p0_.id_last_customer AS id_last_customer_26, p0_.id_employee AS id_employee_27, p0_.firstname AS firstname_28, p0_.lastname AS lastname_29, p0_.email AS email_30, p0_.passwd AS passwd_31, p0_.last_passwd_gen AS last_passwd_gen_32, p0_.reset_password_token AS reset_password_token_33, p0_.reset_password_validity AS reset_password_validity_34, p0_.default_tab AS default_tab_35, p0_.active AS active_36, p0_.last_connection_date AS last_connection_date_37, p0_.has_enabled_gravatar AS has_enabled_gravatar_38, p0_.stats_date_from AS stats_date_from_39, p0_.stats_date_to AS stats_date_to_40, p0_.stats_compare_from AS stats_compare_from_41, p0_.stats_compare_to AS stats_compare_to_42, p0_.stats_compare_option AS stats_compare_option_43, p0_.preselect_date_range AS preselect_date_range_44, p0_.bo_color AS bo_color_45, p0_.bo_theme AS bo_theme_46, p0_.bo_css AS bo_css_47, p0_.bo_width AS bo_width_48, p0_.bo_menu AS bo_menu_49, p0_.optin AS optin_50, p0_.id_last_order AS id_last_order_51, p0_.id_last_customer_message AS id_last_customer_message_52, p0_.id_last_customer AS id_last_customer_53, p1_.id_profile AS id_profile_54, p2_.id_lang AS id_lang_55, p2_.name AS name_56, p2_.active AS active_57, p2_.iso_code AS iso_code_58, p2_.language_code AS language_code_59, p2_.locale AS locale_60, p2_.date_format_lite AS date_format_lite_61, p2_.date_format_full AS date_format_full_62, p2_.is_rtl AS is_rtl_63, p3_.id_employee_session AS id_employee_session_64, p3_.token AS token_65, p3_.date_add AS date_add_66, p3_.date_upd AS date_upd_67, p0_.id_profile AS id_profile_68, p0_.id_lang AS id_lang_69, p3_.id_employee AS id_employee_70 FROM ps_employee p0_ LEFT JOIN ps_profile p1_ ON p0_.id_profile = p1_.id_profile LEFT JOIN ps_lang p2_ ON p0_.id_lang = p2_.id_lang LEFT JOIN ps_employee_session p3_ ON p0_.id_employee = p3_.id_employee WHERE p0_.email = ?
Parameters:
[
"demo@demo.com"
]
|
| 3 | 6.40 ms |
SELECT t0.id_authorization_role AS id_authorization_role_1, t0.slug AS slug_2 FROM ps_authorization_role t0 INNER JOIN ps_access ON t0.id_authorization_role = ps_access.id_authorization_role WHERE ps_access.id_profile = ?
Parameters:
[
1
]
|
| 4 | 1.37 ms |
SELECT p0_.id_employee AS id_employee_0, p0_.firstname AS firstname_1, p0_.lastname AS lastname_2, p0_.email AS email_3, p0_.passwd AS passwd_4, p0_.last_passwd_gen AS last_passwd_gen_5, p0_.reset_password_token AS reset_password_token_6, p0_.reset_password_validity AS reset_password_validity_7, p0_.default_tab AS default_tab_8, p0_.active AS active_9, p0_.last_connection_date AS last_connection_date_10, p0_.has_enabled_gravatar AS has_enabled_gravatar_11, p0_.stats_date_from AS stats_date_from_12, p0_.stats_date_to AS stats_date_to_13, p0_.stats_compare_from AS stats_compare_from_14, p0_.stats_compare_to AS stats_compare_to_15, p0_.stats_compare_option AS stats_compare_option_16, p0_.preselect_date_range AS preselect_date_range_17, p0_.bo_color AS bo_color_18, p0_.bo_theme AS bo_theme_19, p0_.bo_css AS bo_css_20, p0_.bo_width AS bo_width_21, p0_.bo_menu AS bo_menu_22, p0_.optin AS optin_23, p0_.id_last_order AS id_last_order_24, p0_.id_last_customer_message AS id_last_customer_message_25, p0_.id_last_customer AS id_last_customer_26, p0_.id_employee AS id_employee_27, p0_.firstname AS firstname_28, p0_.lastname AS lastname_29, p0_.email AS email_30, p0_.passwd AS passwd_31, p0_.last_passwd_gen AS last_passwd_gen_32, p0_.reset_password_token AS reset_password_token_33, p0_.reset_password_validity AS reset_password_validity_34, p0_.default_tab AS default_tab_35, p0_.active AS active_36, p0_.last_connection_date AS last_connection_date_37, p0_.has_enabled_gravatar AS has_enabled_gravatar_38, p0_.stats_date_from AS stats_date_from_39, p0_.stats_date_to AS stats_date_to_40, p0_.stats_compare_from AS stats_compare_from_41, p0_.stats_compare_to AS stats_compare_to_42, p0_.stats_compare_option AS stats_compare_option_43, p0_.preselect_date_range AS preselect_date_range_44, p0_.bo_color AS bo_color_45, p0_.bo_theme AS bo_theme_46, p0_.bo_css AS bo_css_47, p0_.bo_width AS bo_width_48, p0_.bo_menu AS bo_menu_49, p0_.optin AS optin_50, p0_.id_last_order AS id_last_order_51, p0_.id_last_customer_message AS id_last_customer_message_52, p0_.id_last_customer AS id_last_customer_53, p1_.id_profile AS id_profile_54, p2_.id_lang AS id_lang_55, p2_.name AS name_56, p2_.active AS active_57, p2_.iso_code AS iso_code_58, p2_.language_code AS language_code_59, p2_.locale AS locale_60, p2_.date_format_lite AS date_format_lite_61, p2_.date_format_full AS date_format_full_62, p2_.is_rtl AS is_rtl_63, p3_.id_employee_session AS id_employee_session_64, p3_.token AS token_65, p3_.date_add AS date_add_66, p3_.date_upd AS date_upd_67, p0_.id_profile AS id_profile_68, p0_.id_lang AS id_lang_69, p3_.id_employee AS id_employee_70 FROM ps_employee p0_ LEFT JOIN ps_profile p1_ ON p0_.id_profile = p1_.id_profile LEFT JOIN ps_lang p2_ ON p0_.id_lang = p2_.id_lang LEFT JOIN ps_employee_session p3_ ON p0_.id_employee = p3_.id_employee WHERE p0_.email = ?
Parameters:
[
"demo@demo.com"
]
|
| 5 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 0.44 ms |
INSERT INTO ps_employee_session (token, date_add, date_upd, id_employee) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "aaf496338c1765e6fddc2b31e67684d1715fc326" 2 => "2026-07-24 11:00:08" 3 => "2026-07-24 11:00:08" 4 => 1 ] |
| 7 | 0.85 ms |
"COMMIT"
Parameters:
[] |
| 8 | 0.35 ms |
SELECT s.id_shop FROM ps_shop s
Parameters:
[] |
| 9 | 0.47 ms |
SELECT t0.id_tab AS id_tab_1, t0.id_parent AS id_parent_2, t0.position AS position_3, t0.module AS module_4, t0.class_name AS class_name_5, t0.route_name AS route_name_6, t0.active AS active_7, t0.enabled AS enabled_8, t0.icon AS icon_9, t0.wording AS wording_10, t0.wording_domain AS wording_domain_11 FROM ps_tab t0 WHERE t0.id_tab = ? LIMIT 1
Parameters:
[
1
]
|
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. |
| PrestaShopBundle\Entity\Tab | No errors. |
| PrestaShopBundle\Entity\TabLang | No errors. |