Symfony Profiler

SELECT
  count(o.id_order)
FROM
  djf0t_orders o
  LEFT JOIN djf0t_customer cu ON o.id_customer = cu.id_customer
  LEFT JOIN djf0t_currency cur ON o.id_currency = cur.id_currency
  INNER JOIN djf0t_address a ON o.id_address_delivery = a.id_address
  LEFT JOIN djf0t_order_state os ON o.current_state = os.id_order_state
  LEFT JOIN djf0t_shop s ON o.id_shop = s.id_shop
  INNER JOIN djf0t_country c ON a.id_country = c.id_country
  INNER JOIN djf0t_country_lang cl ON c.id_country = cl.id_country
  AND cl.id_lang = :context_lang_id
  LEFT JOIN djf0t_order_state_lang osl ON os.id_order_state = osl.id_order_state
  AND osl.id_lang = :context_lang_id
WHERE
  o.`id_shop` IN (:context_shop_ids)

SELECT count(o.id_order) FROM djf0t_orders o LEFT JOIN djf0t_customer cu ON o.id_customer = cu.id_customer LEFT JOIN djf0t_currency cur ON o.id_currency = cur.id_currency INNER JOIN djf0t_address a ON o.id_address_delivery = a.id_address LEFT JOIN djf0t_order_state os ON o.current_state = os.id_order_state LEFT JOIN djf0t_shop s ON o.id_shop = s.id_shop INNER JOIN djf0t_country c ON a.id_country = c.id_country INNER JOIN djf0t_country_lang cl ON c.id_country = cl.id_country AND cl.id_lang = 2 LEFT JOIN djf0t_order_state_lang osl ON os.id_order_state = osl.id_order_state AND osl.id_lang = 2 WHERE o.`id_shop` IN (1);

SELECT
  CONCAT(
    LEFT(cu.`firstname`, 1),
    '. ',
    cu.`lastname`
  ) AS `customer`,
  o.id_order,
  o.reference,
  o.total_paid_tax_incl,
  os.paid,
  osl.name AS osname,
  o.id_currency,
  cur.iso_code,
  o.current_state,
  o.id_customer,
  cu.`id_customer` IS NULL as `deleted_customer`,
  os.color,
  o.payment,
  s.name AS shop_name,
  o.date_add,
  cu.company,
  cl.name AS country_name,
  o.invoice_number,
  o.delivery_number,
  (
    SELECT
      IF(
        count(so.id_order) > 0,
        0,
        1
      )
    FROM
      djf0t_orders so
    WHERE
      (so.id_customer = o.id_customer)
      AND (so.id_order < o.id_order)
    LIMIT
      1
  ) AS new,
  (
    SELECT
      COUNT(*)
    FROM
      `djf0t_order_detail` od_c
    WHERE
      od_c.`id_order` = o.`id_order`
  ) AS products_count,
  IF(
    COALESCE(
      NULLIF(
        (
          SELECT
            oi_fw.`number`
          FROM
            `djf0t_order_invoice` oi_fw
          WHERE
            oi_fw.`id_order` = o.`id_order`
          ORDER BY
            oi_fw.`id_order_invoice` DESC
          LIMIT
            1
        ), 0
      ),
      NULLIF(o.`invoice_number`, 0)
    ) IS NULL,
    '',
    CONCAT(
      YEAR(
        COALESCE(
          NULLIF(
            (
              SELECT
                oi_date_fw.`date_add`
              FROM
                `djf0t_order_invoice` oi_date_fw
              WHERE
                oi_date_fw.`id_order` = o.`id_order`
              ORDER BY
                oi_date_fw.`id_order_invoice` DESC
              LIMIT
                1
            ), '0000-00-00 00:00:00'
          ),
          NULLIF(
            o.`invoice_date`, '0000-00-00 00:00:00'
          ),
          o.`date_add`
        )
      ),
      LPAD(
        CAST(
          COALESCE(
            NULLIF(
              (
                SELECT
                  oi_fw.`number`
                FROM
                  `djf0t_order_invoice` oi_fw
                WHERE
                  oi_fw.`id_order` = o.`id_order`
                ORDER BY
                  oi_fw.`id_order_invoice` DESC
                LIMIT
                  1
              ), 0
            ),
            NULLIF(o.`invoice_number`, 0)
          ) AS CHAR
        ),
        GREATEST(
          4,
          CHAR_LENGTH(
            CAST(
              COALESCE(
                NULLIF(
                  (
                    SELECT
                      oi_fw.`number`
                    FROM
                      `djf0t_order_invoice` oi_fw
                    WHERE
                      oi_fw.`id_order` = o.`id_order`
                    ORDER BY
                      oi_fw.`id_order_invoice` DESC
                    LIMIT
                      1
                  ), 0
                ),
                NULLIF(o.`invoice_number`, 0)
              ) AS CHAR
            )
          )
        ),
        '0'
      )
    )
  ) AS invoice_number_display
FROM
  djf0t_orders o
  LEFT JOIN djf0t_customer cu ON o.id_customer = cu.id_customer
  LEFT JOIN djf0t_currency cur ON o.id_currency = cur.id_currency
  INNER JOIN djf0t_address a ON o.id_address_delivery = a.id_address
  LEFT JOIN djf0t_order_state os ON o.current_state = os.id_order_state
  LEFT JOIN djf0t_shop s ON o.id_shop = s.id_shop
  INNER JOIN djf0t_country c ON a.id_country = c.id_country
  INNER JOIN djf0t_country_lang cl ON c.id_country = cl.id_country
  AND cl.id_lang = :context_lang_id
  LEFT JOIN djf0t_order_state_lang osl ON os.id_order_state = osl.id_order_state
  AND osl.id_lang = :context_lang_id
WHERE
  o.`id_shop` IN (:context_shop_ids)
ORDER BY
  o.id_order DESC
LIMIT
  50

SELECT CONCAT(LEFT(cu.`firstname`, 1), '. ', cu.`lastname`) AS `customer`, o.id_order, o.reference, o.total_paid_tax_incl, os.paid, osl.name AS osname, o.id_currency, cur.iso_code, o.current_state, o.id_customer, cu.`id_customer` IS NULL as `deleted_customer`, os.color, o.payment, s.name AS shop_name, o.date_add, cu.company, cl.name AS country_name, o.invoice_number, o.delivery_number, (SELECT IF(count(so.id_order) > 0, 0, 1) FROM djf0t_orders so WHERE (so.id_customer = o.id_customer) AND (so.id_order < o.id_order) LIMIT 1) AS new, (SELECT COUNT(*) FROM `djf0t_order_detail` od_c WHERE od_c.`id_order` = o.`id_order`) AS products_count, IF(COALESCE(NULLIF((SELECT oi_fw.`number` FROM `djf0t_order_invoice` oi_fw WHERE oi_fw.`id_order` = o.`id_order` ORDER BY oi_fw.`id_order_invoice` DESC LIMIT 1), 0), NULLIF(o.`invoice_number`, 0)) IS NULL, '', CONCAT(YEAR(COALESCE(NULLIF((SELECT oi_date_fw.`date_add` FROM `djf0t_order_invoice` oi_date_fw WHERE oi_date_fw.`id_order` = o.`id_order` ORDER BY oi_date_fw.`id_order_invoice` DESC LIMIT 1), '0000-00-00 00:00:00'), NULLIF(o.`invoice_date`, '0000-00-00 00:00:00'), o.`date_add`)), LPAD(CAST(COALESCE(NULLIF((SELECT oi_fw.`number` FROM `djf0t_order_invoice` oi_fw WHERE oi_fw.`id_order` = o.`id_order` ORDER BY oi_fw.`id_order_invoice` DESC LIMIT 1), 0), NULLIF(o.`invoice_number`, 0)) AS CHAR), GREATEST(4, CHAR_LENGTH(CAST(COALESCE(NULLIF((SELECT oi_fw.`number` FROM `djf0t_order_invoice` oi_fw WHERE oi_fw.`id_order` = o.`id_order` ORDER BY oi_fw.`id_order_invoice` DESC LIMIT 1), 0), NULLIF(o.`invoice_number`, 0)) AS CHAR))), '0'))) AS invoice_number_display FROM djf0t_orders o LEFT JOIN djf0t_customer cu ON o.id_customer = cu.id_customer LEFT JOIN djf0t_currency cur ON o.id_currency = cur.id_currency INNER JOIN djf0t_address a ON o.id_address_delivery = a.id_address LEFT JOIN djf0t_order_state os ON o.current_state = os.id_order_state LEFT JOIN djf0t_shop s ON o.id_shop = s.id_shop INNER JOIN djf0t_country c ON a.id_country = c.id_country INNER JOIN djf0t_country_lang cl ON c.id_country = cl.id_country AND cl.id_lang = 2 LEFT JOIN djf0t_order_state_lang osl ON os.id_order_state = osl.id_order_state AND osl.id_lang = 2 WHERE o.`id_shop` IN (1) ORDER BY o.id_order DESC LIMIT 50;

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 = ?

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 = 'firma@tvojsen-mido.sk';

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

SELECT
  q.id_quick_access,
  q.new_window,
  q.link,
  ql.name
FROM
  djf0t_quick_access q
  INNER JOIN djf0t_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 djf0t_quick_access q INNER JOIN djf0t_quick_access_lang ql ON q.id_quick_access = ql.id_quick_access WHERE ql.id_lang = 2 ORDER BY ql.name ASC;

SELECT
  t0.id AS id_1,
  t0.employee AS employee_2,
  t0.shop AS shop_3,
  t0.controller AS controller_4,
  t0.action AS action_5,
  t0.filter AS filter_6,
  t0.filter_id AS filter_id_7
FROM
  djf0t_admin_filter t0
WHERE
  t0.employee = ?
  AND t0.shop = ?
  AND t0.filter_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM djf0t_admin_filter t0 WHERE t0.employee = 2 AND t0.shop = 1 AND t0.filter_id = 'order' LIMIT 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
  djf0t_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 djf0t_employee_session t0 WHERE t0.id_employee = 2;

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
  djf0t_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 djf0t_employee t0 WHERE t0.id_employee = 2;

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
  djf0t_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 djf0t_tab t0 WHERE t0.route_name = 'admin_orders_index' LIMIT 1;

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

SELECT d0_.id_tab AS id_tab_0, d0_.class_name AS class_name_1 FROM djf0t_tab d0_ WHERE d0_.class_name = BINARY('AdminOrders') AND d0_.id_tab <> 0;

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
  djf0t_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 djf0t_tab t0 WHERE t0.class_name = 'AdminOrders' LIMIT 1;

SELECT
  s.id_shop
FROM
  djf0t_shop s

SELECT s.id_shop FROM djf0t_shop s;