Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.email_pw AS email_pw_2,
  a0_.profile AS profile_3,
  a0_.active AS active_4,
  a0_.running AS running_5,
  a0_.relist AS relist_6,
  a0_.sniping AS sniping_7,
  a0_.blocked AS blocked_8,
  a0_.block_cnt AS block_cnt_9,
  a0_.locked_msg AS locked_msg_10,
  a0_.dyn_prices AS dyn_prices_11,
  a0_.new_buy AS new_buy_12,
  a0_.new_buy_selective AS new_buy_selective_13,
  a0_.item_max_buy_price AS item_max_buy_price_14,
  a0_.re_buy AS re_buy_15,
  a0_.import_watchlist AS import_watchlist_16,
  a0_.auto_re_buy AS auto_re_buy_17,
  a0_.direct_re_buy AS direct_re_buy_18,
  a0_.auto_new_buy AS auto_new_buy_19,
  a0_.tm_open AS tm_open_20,
  a0_.tm_state AS tm_state_21,
  a0_.solve_low_sbcs AS solve_low_sbcs_22,
  a0_.solve_high_sbcs AS solve_high_sbcs_23,
  a0_.force_sbcs AS force_sbcs_24,
  a0_.dead AS dead_25,
  a0_.cnt_tp_items AS cnt_tp_items_26,
  a0_.cnt_sold_tp_items AS cnt_sold_tp_items_27,
  a0_.cnt_inactive_tp_items AS cnt_inactive_tp_items_28,
  a0_.password AS password_29,
  a0_.ea_code1 AS ea_code1_30,
  a0_.ea_code2 AS ea_code2_31,
  a0_.ea_code3 AS ea_code3_32,
  a0_.ea_code4 AS ea_code4_33,
  a0_.ea_code5 AS ea_code5_34,
  a0_.ea_code6 AS ea_code6_35,
  a0_.credits AS credits_36,
  a0_.revenue AS revenue_37,
  a0_.discard_coins AS discard_coins_38,
  a0_.fut_wiz_value AS fut_wiz_value_39,
  a0_.ea_market_avg_value AS ea_market_avg_value_40,
  a0_.mfa_code AS mfa_code_41,
  a0_.two_factor_auth_key AS two_factor_auth_key_42,
  a0_.login2_fa_via_app AS login2_fa_via_app_43,
  a0_.psn_pw AS psn_pw_44,
  a0_.two_factor_psn_auth_key AS two_factor_psn_auth_key_45,
  a0_.two_factor_email_auth_key AS two_factor_email_auth_key_46,
  a0_.ut_sid AS ut_sid_47,
  a0_.fc_sid AS fc_sid_48,
  a0_.sniping_cnt1h AS sniping_cnt1h_49,
  a0_.sniping_cnt3h AS sniping_cnt3h_50,
  a0_.sniping_cnt6h AS sniping_cnt6h_51,
  a0_.sniping_cnt12h AS sniping_cnt12h_52,
  a0_.sniping_cnt24h AS sniping_cnt24h_53,
  a0_.sniping_cnt3d AS sniping_cnt3d_54,
  a0_.sniping_cnt1w AS sniping_cnt1w_55,
  a0_.note AS note_56,
  a0_.error_html AS error_html_57,
  a0_.platform AS platform_58,
  a0_.ft_added AS ft_added_59,
  a0_.ft_active AS ft_active_60,
  a0_.ft_sell AS ft_sell_61,
  a0_.ft_to_keep AS ft_to_keep_62,
  a0_.collect_rewards AS collect_rewards_63,
  a0_.open_packs AS open_packs_64,
  a0_.process_unassigned_items AS process_unassigned_items_65,
  a0_.player_mode AS player_mode_66,
  a0_.player_mode_item_cnt AS player_mode_item_cnt_67,
  a0_.chem_style_mode AS chem_style_mode_68,
  a0_.chem_style_mode_item_cnt AS chem_style_mode_item_cnt_69,
  a0_.scrape_club_items AS scrape_club_items_70,
  a0_.user_mass_info AS user_mass_info_71,
  a0_.num_sbc_per_loop AS num_sbc_per_loop_72,
  a0_.num_unopened_packs AS num_unopened_packs_73,
  a0_.creation_date AS creation_date_74,
  a0_.rebuy_date AS rebuy_date_75,
  a0_.new_buy_date AS new_buy_date_76,
  a0_.relist_date AS relist_date_77,
  a0_.sniping_date AS sniping_date_78,
  a0_.prev_pack_exp_date AS prev_pack_exp_date_79,
  a0_.check_packs_date AS check_packs_date_80,
  a0_.connection_date AS connection_date_81,
  a0_.loop_start_date AS loop_start_date_82,
  a0_.loop_finish_date AS loop_finish_date_83,
  a0_.scrape_date AS scrape_date_84,
  a0_.debug AS debug_85,
  a0_.owner_id AS owner_id_86
FROM
  account a0_
WHERE
  a0_.owner_id = ?
  AND LOWER(a0_.profile) LIKE LOWER(
    CONCAT('%', ?, '%')
  )
  AND a0_.tm_open = ?
ORDER BY
  a0_.relist_date ASC
LIMIT
  100

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.email_pw AS email_pw_2, a0_.profile AS profile_3, a0_.active AS active_4, a0_.running AS running_5, a0_.relist AS relist_6, a0_.sniping AS sniping_7, a0_.blocked AS blocked_8, a0_.block_cnt AS block_cnt_9, a0_.locked_msg AS locked_msg_10, a0_.dyn_prices AS dyn_prices_11, a0_.new_buy AS new_buy_12, a0_.new_buy_selective AS new_buy_selective_13, a0_.item_max_buy_price AS item_max_buy_price_14, a0_.re_buy AS re_buy_15, a0_.import_watchlist AS import_watchlist_16, a0_.auto_re_buy AS auto_re_buy_17, a0_.direct_re_buy AS direct_re_buy_18, a0_.auto_new_buy AS auto_new_buy_19, a0_.tm_open AS tm_open_20, a0_.tm_state AS tm_state_21, a0_.solve_low_sbcs AS solve_low_sbcs_22, a0_.solve_high_sbcs AS solve_high_sbcs_23, a0_.force_sbcs AS force_sbcs_24, a0_.dead AS dead_25, a0_.cnt_tp_items AS cnt_tp_items_26, a0_.cnt_sold_tp_items AS cnt_sold_tp_items_27, a0_.cnt_inactive_tp_items AS cnt_inactive_tp_items_28, a0_.password AS password_29, a0_.ea_code1 AS ea_code1_30, a0_.ea_code2 AS ea_code2_31, a0_.ea_code3 AS ea_code3_32, a0_.ea_code4 AS ea_code4_33, a0_.ea_code5 AS ea_code5_34, a0_.ea_code6 AS ea_code6_35, a0_.credits AS credits_36, a0_.revenue AS revenue_37, a0_.discard_coins AS discard_coins_38, a0_.fut_wiz_value AS fut_wiz_value_39, a0_.ea_market_avg_value AS ea_market_avg_value_40, a0_.mfa_code AS mfa_code_41, a0_.two_factor_auth_key AS two_factor_auth_key_42, a0_.login2_fa_via_app AS login2_fa_via_app_43, a0_.psn_pw AS psn_pw_44, a0_.two_factor_psn_auth_key AS two_factor_psn_auth_key_45, a0_.two_factor_email_auth_key AS two_factor_email_auth_key_46, a0_.ut_sid AS ut_sid_47, a0_.fc_sid AS fc_sid_48, a0_.sniping_cnt1h AS sniping_cnt1h_49, a0_.sniping_cnt3h AS sniping_cnt3h_50, a0_.sniping_cnt6h AS sniping_cnt6h_51, a0_.sniping_cnt12h AS sniping_cnt12h_52, a0_.sniping_cnt24h AS sniping_cnt24h_53, a0_.sniping_cnt3d AS sniping_cnt3d_54, a0_.sniping_cnt1w AS sniping_cnt1w_55, a0_.note AS note_56, a0_.error_html AS error_html_57, a0_.platform AS platform_58, a0_.ft_added AS ft_added_59, a0_.ft_active AS ft_active_60, a0_.ft_sell AS ft_sell_61, a0_.ft_to_keep AS ft_to_keep_62, a0_.collect_rewards AS collect_rewards_63, a0_.open_packs AS open_packs_64, a0_.process_unassigned_items AS process_unassigned_items_65, a0_.player_mode AS player_mode_66, a0_.player_mode_item_cnt AS player_mode_item_cnt_67, a0_.chem_style_mode AS chem_style_mode_68, a0_.chem_style_mode_item_cnt AS chem_style_mode_item_cnt_69, a0_.scrape_club_items AS scrape_club_items_70, a0_.user_mass_info AS user_mass_info_71, a0_.num_sbc_per_loop AS num_sbc_per_loop_72, a0_.num_unopened_packs AS num_unopened_packs_73, a0_.creation_date AS creation_date_74, a0_.rebuy_date AS rebuy_date_75, a0_.new_buy_date AS new_buy_date_76, a0_.relist_date AS relist_date_77, a0_.sniping_date AS sniping_date_78, a0_.prev_pack_exp_date AS prev_pack_exp_date_79, a0_.check_packs_date AS check_packs_date_80, a0_.connection_date AS connection_date_81, a0_.loop_start_date AS loop_start_date_82, a0_.loop_finish_date AS loop_finish_date_83, a0_.scrape_date AS scrape_date_84, a0_.debug AS debug_85, a0_.owner_id AS owner_id_86 FROM account a0_ WHERE a0_.owner_id = 1 AND LOWER(a0_.profile) LIKE LOWER(CONCAT('%', '', '%')) AND a0_.tm_open = 1 ORDER BY a0_.relist_date ASC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.image_id AS image_id_9
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.image_id AS image_id_9 FROM `user` t0 WHERE t0.email = 'admin@spawntree.de' LIMIT 1;

SELECT
  count(a0_.id) AS sclr_0
FROM
  account a0_
WHERE
  a0_.owner_id = ?
  AND LOWER(a0_.profile) LIKE LOWER(
    CONCAT('%', ?, '%')
  )
  AND a0_.tm_open = ?

SELECT count(a0_.id) AS sclr_0 FROM account a0_ WHERE a0_.owner_id = 1 AND LOWER(a0_.profile) LIKE LOWER(CONCAT('%', '', '%')) AND a0_.tm_open = 1;