Symfony Profiler

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
  iubda_tab t0
WHERE
  t0.class_name = ?
LIMIT
  1

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 iubda_tab t0 WHERE t0.class_name = 'AdminXbookTimeline' LIMIT 1;

SELECT
  q.id_quick_access,
  q.new_window,
  q.link,
  ql.name
FROM
  iubda_quick_access q
  INNER JOIN iubda_quick_access_lang ql ON q.id_quick_access = ql.id_quick_access
WHERE
  ql.id_lang = :languageId
ORDER BY
  ql.name ASC

SELECT q.id_quick_access, q.new_window, q.link, ql.name FROM iubda_quick_access q INNER JOIN iubda_quick_access_lang ql ON q.id_quick_access = ql.id_quick_access WHERE ql.id_lang = 1 ORDER BY ql.name ASC;

SELECT
  t0.id_authorization_role AS id_authorization_role_1,
  t0.slug AS slug_2
FROM
  iubda_authorization_role t0
  INNER JOIN iubda_access ON t0.id_authorization_role = iubda_access.id_authorization_role
WHERE
  iubda_access.id_profile = ?

SELECT t0.id_authorization_role AS id_authorization_role_1, t0.slug AS slug_2 FROM iubda_authorization_role t0 INNER JOIN iubda_access ON t0.id_authorization_role = iubda_access.id_authorization_role WHERE iubda_access.id_profile = 1;

SELECT
  i0_.id_employee AS id_employee_0,
  i0_.firstname AS firstname_1,
  i0_.lastname AS lastname_2,
  i0_.email AS email_3,
  i0_.passwd AS passwd_4,
  i0_.last_passwd_gen AS last_passwd_gen_5,
  i0_.reset_password_token AS reset_password_token_6,
  i0_.reset_password_validity AS reset_password_validity_7,
  i0_.default_tab AS default_tab_8,
  i0_.active AS active_9,
  i0_.last_connection_date AS last_connection_date_10,
  i0_.has_enabled_gravatar AS has_enabled_gravatar_11,
  i0_.stats_date_from AS stats_date_from_12,
  i0_.stats_date_to AS stats_date_to_13,
  i0_.stats_compare_from AS stats_compare_from_14,
  i0_.stats_compare_to AS stats_compare_to_15,
  i0_.stats_compare_option AS stats_compare_option_16,
  i0_.preselect_date_range AS preselect_date_range_17,
  i0_.bo_color AS bo_color_18,
  i0_.bo_theme AS bo_theme_19,
  i0_.bo_css AS bo_css_20,
  i0_.bo_width AS bo_width_21,
  i0_.bo_menu AS bo_menu_22,
  i0_.optin AS optin_23,
  i0_.id_last_order AS id_last_order_24,
  i0_.id_last_customer_message AS id_last_customer_message_25,
  i0_.id_last_customer AS id_last_customer_26,
  i0_.id_employee AS id_employee_27,
  i0_.firstname AS firstname_28,
  i0_.lastname AS lastname_29,
  i0_.email AS email_30,
  i0_.passwd AS passwd_31,
  i0_.last_passwd_gen AS last_passwd_gen_32,
  i0_.reset_password_token AS reset_password_token_33,
  i0_.reset_password_validity AS reset_password_validity_34,
  i0_.default_tab AS default_tab_35,
  i0_.active AS active_36,
  i0_.last_connection_date AS last_connection_date_37,
  i0_.has_enabled_gravatar AS has_enabled_gravatar_38,
  i0_.stats_date_from AS stats_date_from_39,
  i0_.stats_date_to AS stats_date_to_40,
  i0_.stats_compare_from AS stats_compare_from_41,
  i0_.stats_compare_to AS stats_compare_to_42,
  i0_.stats_compare_option AS stats_compare_option_43,
  i0_.preselect_date_range AS preselect_date_range_44,
  i0_.bo_color AS bo_color_45,
  i0_.bo_theme AS bo_theme_46,
  i0_.bo_css AS bo_css_47,
  i0_.bo_width AS bo_width_48,
  i0_.bo_menu AS bo_menu_49,
  i0_.optin AS optin_50,
  i0_.id_last_order AS id_last_order_51,
  i0_.id_last_customer_message AS id_last_customer_message_52,
  i0_.id_last_customer AS id_last_customer_53,
  i1_.id_profile AS id_profile_54,
  i2_.id_lang AS id_lang_55,
  i2_.name AS name_56,
  i2_.active AS active_57,
  i2_.iso_code AS iso_code_58,
  i2_.language_code AS language_code_59,
  i2_.locale AS locale_60,
  i2_.date_format_lite AS date_format_lite_61,
  i2_.date_format_full AS date_format_full_62,
  i2_.is_rtl AS is_rtl_63,
  i3_.id_employee_session AS id_employee_session_64,
  i3_.token AS token_65,
  i3_.date_add AS date_add_66,
  i3_.date_upd AS date_upd_67,
  i0_.id_profile AS id_profile_68,
  i0_.id_lang AS id_lang_69,
  i3_.id_employee AS id_employee_70
FROM
  iubda_employee i0_
  LEFT JOIN iubda_profile i1_ ON i0_.id_profile = i1_.id_profile
  LEFT JOIN iubda_lang i2_ ON i0_.id_lang = i2_.id_lang
  LEFT JOIN iubda_employee_session i3_ ON i0_.id_employee = i3_.id_employee
WHERE
  i0_.email = ?

SELECT i0_.id_employee AS id_employee_0, i0_.firstname AS firstname_1, i0_.lastname AS lastname_2, i0_.email AS email_3, i0_.passwd AS passwd_4, i0_.last_passwd_gen AS last_passwd_gen_5, i0_.reset_password_token AS reset_password_token_6, i0_.reset_password_validity AS reset_password_validity_7, i0_.default_tab AS default_tab_8, i0_.active AS active_9, i0_.last_connection_date AS last_connection_date_10, i0_.has_enabled_gravatar AS has_enabled_gravatar_11, i0_.stats_date_from AS stats_date_from_12, i0_.stats_date_to AS stats_date_to_13, i0_.stats_compare_from AS stats_compare_from_14, i0_.stats_compare_to AS stats_compare_to_15, i0_.stats_compare_option AS stats_compare_option_16, i0_.preselect_date_range AS preselect_date_range_17, i0_.bo_color AS bo_color_18, i0_.bo_theme AS bo_theme_19, i0_.bo_css AS bo_css_20, i0_.bo_width AS bo_width_21, i0_.bo_menu AS bo_menu_22, i0_.optin AS optin_23, i0_.id_last_order AS id_last_order_24, i0_.id_last_customer_message AS id_last_customer_message_25, i0_.id_last_customer AS id_last_customer_26, i0_.id_employee AS id_employee_27, i0_.firstname AS firstname_28, i0_.lastname AS lastname_29, i0_.email AS email_30, i0_.passwd AS passwd_31, i0_.last_passwd_gen AS last_passwd_gen_32, i0_.reset_password_token AS reset_password_token_33, i0_.reset_password_validity AS reset_password_validity_34, i0_.default_tab AS default_tab_35, i0_.active AS active_36, i0_.last_connection_date AS last_connection_date_37, i0_.has_enabled_gravatar AS has_enabled_gravatar_38, i0_.stats_date_from AS stats_date_from_39, i0_.stats_date_to AS stats_date_to_40, i0_.stats_compare_from AS stats_compare_from_41, i0_.stats_compare_to AS stats_compare_to_42, i0_.stats_compare_option AS stats_compare_option_43, i0_.preselect_date_range AS preselect_date_range_44, i0_.bo_color AS bo_color_45, i0_.bo_theme AS bo_theme_46, i0_.bo_css AS bo_css_47, i0_.bo_width AS bo_width_48, i0_.bo_menu AS bo_menu_49, i0_.optin AS optin_50, i0_.id_last_order AS id_last_order_51, i0_.id_last_customer_message AS id_last_customer_message_52, i0_.id_last_customer AS id_last_customer_53, i1_.id_profile AS id_profile_54, i2_.id_lang AS id_lang_55, i2_.name AS name_56, i2_.active AS active_57, i2_.iso_code AS iso_code_58, i2_.language_code AS language_code_59, i2_.locale AS locale_60, i2_.date_format_lite AS date_format_lite_61, i2_.date_format_full AS date_format_full_62, i2_.is_rtl AS is_rtl_63, i3_.id_employee_session AS id_employee_session_64, i3_.token AS token_65, i3_.date_add AS date_add_66, i3_.date_upd AS date_upd_67, i0_.id_profile AS id_profile_68, i0_.id_lang AS id_lang_69, i3_.id_employee AS id_employee_70 FROM iubda_employee i0_ LEFT JOIN iubda_profile i1_ ON i0_.id_profile = i1_.id_profile LEFT JOIN iubda_lang i2_ ON i0_.id_lang = i2_.id_lang LEFT JOIN iubda_employee_session i3_ ON i0_.id_employee = i3_.id_employee WHERE i0_.email = 'x@alexandrox.com';

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
  iubda_tab t0
WHERE
  t0.id_tab = ?
LIMIT
  1

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 iubda_tab t0 WHERE t0.id_tab = 1 LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.id_tab AS id_tab_2,
  t0.id_lang AS id_lang_3
FROM
  iubda_tab_lang t0
WHERE
  t0.id_tab = ?

SELECT t0.name AS name_1, t0.id_tab AS id_tab_2, t0.id_lang AS id_lang_3 FROM iubda_tab_lang t0 WHERE t0.id_tab = 270;

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
  iubda_employee t0
WHERE
  t0.id_employee = ?

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 iubda_employee t0 WHERE t0.id_employee = 1;

SELECT
  i0_.id_tab AS id_tab_0,
  i0_.class_name AS class_name_1
FROM
  iubda_tab i0_
WHERE
  i0_.class_name = BINARY(?)
  AND i0_.id_tab <> 0

SELECT i0_.id_tab AS id_tab_0, i0_.class_name AS class_name_1 FROM iubda_tab i0_ WHERE i0_.class_name = BINARY('AdminXbookTimeline') AND i0_.id_tab <> 0;

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
  iubda_employee_session t0
WHERE
  t0.id_employee = ?

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 iubda_employee_session t0 WHERE t0.id_employee = 1;

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
  iubda_tab t0
WHERE
  t0.route_name = ?
LIMIT
  1

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 iubda_tab t0 WHERE t0.route_name = 'admin_legacy_controller_route' LIMIT 1;

SELECT
  s.id_shop
FROM
  iubda_shop s

SELECT s.id_shop FROM iubda_shop s;