Query Metrics
14
Database Queries
10
Different statements
11.07 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.01 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 flv1q_tab t0 WHERE t0.class_name = ? LIMIT 1
Parameters:
[
"AdminDashboard"
]
|
| 2 | 1.58 ms |
SELECT f0_.id_employee AS id_employee_0, f0_.firstname AS firstname_1, f0_.lastname AS lastname_2, f0_.email AS email_3, f0_.passwd AS passwd_4, f0_.last_passwd_gen AS last_passwd_gen_5, f0_.reset_password_token AS reset_password_token_6, f0_.reset_password_validity AS reset_password_validity_7, f0_.default_tab AS default_tab_8, f0_.active AS active_9, f0_.last_connection_date AS last_connection_date_10, f0_.has_enabled_gravatar AS has_enabled_gravatar_11, f0_.stats_date_from AS stats_date_from_12, f0_.stats_date_to AS stats_date_to_13, f0_.stats_compare_from AS stats_compare_from_14, f0_.stats_compare_to AS stats_compare_to_15, f0_.stats_compare_option AS stats_compare_option_16, f0_.preselect_date_range AS preselect_date_range_17, f0_.bo_color AS bo_color_18, f0_.bo_theme AS bo_theme_19, f0_.bo_css AS bo_css_20, f0_.bo_width AS bo_width_21, f0_.bo_menu AS bo_menu_22, f0_.optin AS optin_23, f0_.id_last_order AS id_last_order_24, f0_.id_last_customer_message AS id_last_customer_message_25, f0_.id_last_customer AS id_last_customer_26, f0_.id_employee AS id_employee_27, f0_.firstname AS firstname_28, f0_.lastname AS lastname_29, f0_.email AS email_30, f0_.passwd AS passwd_31, f0_.last_passwd_gen AS last_passwd_gen_32, f0_.reset_password_token AS reset_password_token_33, f0_.reset_password_validity AS reset_password_validity_34, f0_.default_tab AS default_tab_35, f0_.active AS active_36, f0_.last_connection_date AS last_connection_date_37, f0_.has_enabled_gravatar AS has_enabled_gravatar_38, f0_.stats_date_from AS stats_date_from_39, f0_.stats_date_to AS stats_date_to_40, f0_.stats_compare_from AS stats_compare_from_41, f0_.stats_compare_to AS stats_compare_to_42, f0_.stats_compare_option AS stats_compare_option_43, f0_.preselect_date_range AS preselect_date_range_44, f0_.bo_color AS bo_color_45, f0_.bo_theme AS bo_theme_46, f0_.bo_css AS bo_css_47, f0_.bo_width AS bo_width_48, f0_.bo_menu AS bo_menu_49, f0_.optin AS optin_50, f0_.id_last_order AS id_last_order_51, f0_.id_last_customer_message AS id_last_customer_message_52, f0_.id_last_customer AS id_last_customer_53, f1_.id_profile AS id_profile_54, f2_.id_lang AS id_lang_55, f2_.name AS name_56, f2_.active AS active_57, f2_.iso_code AS iso_code_58, f2_.language_code AS language_code_59, f2_.locale AS locale_60, f2_.date_format_lite AS date_format_lite_61, f2_.date_format_full AS date_format_full_62, f2_.is_rtl AS is_rtl_63, f3_.id_employee_session AS id_employee_session_64, f3_.token AS token_65, f3_.date_add AS date_add_66, f3_.date_upd AS date_upd_67, f0_.id_profile AS id_profile_68, f0_.id_lang AS id_lang_69, f3_.id_employee AS id_employee_70 FROM flv1q_employee f0_ LEFT JOIN flv1q_profile f1_ ON f0_.id_profile = f1_.id_profile LEFT JOIN flv1q_lang f2_ ON f0_.id_lang = f2_.id_lang LEFT JOIN flv1q_employee_session f3_ ON f0_.id_employee = f3_.id_employee WHERE f0_.email = ?
Parameters:
[
"kontakt@sklep-centrumpepsyny.pl"
]
|
| 3 | 0.46 ms |
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 flv1q_employee t0 WHERE t0.id_employee = ?
Parameters:
[
1
]
|
| 4 | 0.35 ms |
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 flv1q_employee_session t0 WHERE t0.id_employee = ?
Parameters:
[
1
]
|
| 5 | 0.21 ms |
SELECT s.id_shop FROM flv1q_shop s
Parameters:
[] |
| 6 | 0.40 ms |
SELECT f0_.id_tab AS id_tab_0, f0_.class_name AS class_name_1 FROM flv1q_tab f0_ WHERE f0_.class_name = BINARY(?) AND f0_.id_tab <> 0
Parameters:
[
"AdminDashboard"
]
|
| 7 | 0.30 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 flv1q_tab t0 WHERE t0.id_tab = ? LIMIT 1
Parameters:
[
1
]
|
| 8 | 0.45 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 flv1q_tab t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
"admin_legacy_controller_route"
]
|
| 9 | 0.23 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 flv1q_tab t0 WHERE t0.class_name = ? LIMIT 1
Parameters:
[
"AdminDashboard"
]
|
| 10 | 0.22 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 flv1q_tab t0 WHERE t0.id_tab = ? LIMIT 1
Parameters:
[
1
]
|
| 11 | 0.21 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 flv1q_tab t0 WHERE t0.id_tab = ? LIMIT 1
Parameters:
[
147
]
|
| 12 | 0.21 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 flv1q_tab t0 WHERE t0.id_tab = ? LIMIT 1
Parameters:
[
147
]
|
| 13 | 1.96 ms |
SELECT q.id_quick_access, q.new_window, q.link, ql.name FROM flv1q_quick_access q INNER JOIN flv1q_quick_access_lang ql ON q.id_quick_access = ql.id_quick_access WHERE ql.id_lang = :languageId ORDER BY ql.name ASC
Parameters:
[ "languageId" => 1 ] |
| 14 | 2.49 ms |
SELECT t0.id_authorization_role AS id_authorization_role_1, t0.slug AS slug_2 FROM flv1q_authorization_role t0 INNER JOIN flv1q_access ON t0.id_authorization_role = flv1q_access.id_authorization_role WHERE flv1q_access.id_profile = ?
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\Tab | No errors. |
| PrestaShopBundle\Entity\TabLang | No 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. |