Symfony Profiler

SELECT
  t0.state_id AS state_id_1,
  t0.state AS state_2,
  t0.code AS code_3,
  t0.country_code AS country_code_4,
  t0.region_code AS region_code_5
FROM
  xc_states t0
WHERE
  t0.state_id = ?

SELECT t0.state_id AS state_id_1, t0.state AS state_2, t0.code AS code_3, t0.country_code AS country_code_4, t0.region_code AS region_code_5 FROM xc_states t0 WHERE t0.state_id = '562';

SELECT
  x0_.numberOfReminderCoupons AS numberOfReminderCoupons_0,
  x0_.conciergeUserId AS conciergeUserId_1,
  x0_.auth_phone_number AS auth_phone_number_2,
  x0_.auth_phone_code AS auth_phone_code_3,
  x0_.auth_2fa_enabled AS auth_2fa_enabled_4,
  x0_.authy_id AS authy_id_5,
  x0_.profile_id AS profile_id_6,
  x0_.login AS login_7,
  x0_.password AS password_8,
  x0_.password_hint AS password_hint_9,
  x0_.password_hint_answer AS password_hint_answer_10,
  x0_.passwordResetKey AS passwordResetKey_11,
  x0_.passwordResetKeyDate AS passwordResetKeyDate_12,
  x0_.access_level AS access_level_13,
  x0_.added AS added_14,
  x0_.first_login AS first_login_15,
  x0_.last_login AS last_login_16,
  x0_.status AS status_17,
  x0_.statusComment AS statusComment_18,
  x0_.referer AS referer_19,
  x0_.language AS language_20,
  x0_.last_shipping_id AS last_shipping_id_21,
  x0_.last_payment_id AS last_payment_id_22,
  x0_.anonymous AS anonymous_23,
  x0_.forceChangePassword AS forceChangePassword_24,
  x0_.dateOfLoginAttempt AS dateOfLoginAttempt_25,
  x0_.countOfLoginAttempts AS countOfLoginAttempts_26,
  x0_.searchFakeField AS searchFakeField_27,
  x0_.xcPendingExport AS xcPendingExport_28,
  x0_.lastCheckoutEmail AS lastCheckoutEmail_29,
  x0_.order_id AS order_id_30,
  x0_.membership_id AS membership_id_31,
  x0_.pending_membership_id AS pending_membership_id_32
FROM
  xc_profiles x0_
  LEFT JOIN xc_profile_addresses x1_ ON x0_.profile_id = x1_.profile_id
WHERE
  (
    x0_.order_id IS NULL
    AND x0_.anonymous <> ?
  )
  AND x0_.login = ?
  AND x0_.status = ?
LIMIT
  1

SELECT x0_.numberOfReminderCoupons AS numberOfReminderCoupons_0, x0_.conciergeUserId AS conciergeUserId_1, x0_.auth_phone_number AS auth_phone_number_2, x0_.auth_phone_code AS auth_phone_code_3, x0_.auth_2fa_enabled AS auth_2fa_enabled_4, x0_.authy_id AS authy_id_5, x0_.profile_id AS profile_id_6, x0_.login AS login_7, x0_.password AS password_8, x0_.password_hint AS password_hint_9, x0_.password_hint_answer AS password_hint_answer_10, x0_.passwordResetKey AS passwordResetKey_11, x0_.passwordResetKeyDate AS passwordResetKeyDate_12, x0_.access_level AS access_level_13, x0_.added AS added_14, x0_.first_login AS first_login_15, x0_.last_login AS last_login_16, x0_.status AS status_17, x0_.statusComment AS statusComment_18, x0_.referer AS referer_19, x0_.language AS language_20, x0_.last_shipping_id AS last_shipping_id_21, x0_.last_payment_id AS last_payment_id_22, x0_.anonymous AS anonymous_23, x0_.forceChangePassword AS forceChangePassword_24, x0_.dateOfLoginAttempt AS dateOfLoginAttempt_25, x0_.countOfLoginAttempts AS countOfLoginAttempts_26, x0_.searchFakeField AS searchFakeField_27, x0_.xcPendingExport AS xcPendingExport_28, x0_.lastCheckoutEmail AS lastCheckoutEmail_29, x0_.order_id AS order_id_30, x0_.membership_id AS membership_id_31, x0_.pending_membership_id AS pending_membership_id_32 FROM xc_profiles x0_ LEFT JOIN xc_profile_addresses x1_ ON x0_.profile_id = x1_.profile_id WHERE (x0_.order_id IS NULL AND x0_.anonymous <> 1) AND x0_.login = '' AND x0_.status = 'E' LIMIT 1;

SELECT
  t0.ogMeta AS ogMeta_1,
  t0.useCustomOG AS useCustomOG_2,
  t0.csiHiddenCategory AS csiHiddenCategory_3,
  t0.csCreated AS csCreated_4,
  t0.csLastUpdate AS csLastUpdate_5,
  t0.flyoutColumns AS flyoutColumns_6,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_7,
  t0.category_id AS category_id_8,
  t0.lpos AS lpos_9,
  t0.rpos AS rpos_10,
  t0.enabled AS enabled_11,
  t0.show_title AS show_title_12,
  t0.depth AS depth_13,
  t0.pos AS pos_14,
  t0.root_category_look AS root_category_look_15,
  t0.metaDescType AS metaDescType_16,
  t0.xcPendingExport AS xcPendingExport_17,
  t18.id AS id_19,
  t18.subcategories_count_all AS subcategories_count_all_20,
  t18.subcategories_count_enabled AS subcategories_count_enabled_21,
  t18.category_id AS category_id_22,
  t23.alt AS alt_24,
  t23.width AS width_25,
  t23.height AS height_26,
  t23.hash AS hash_27,
  t23.needProcess AS needProcess_28,
  t23.id AS id_29,
  t23.path AS path_30,
  t23.fileName AS fileName_31,
  t23.mime AS mime_32,
  t23.storageType AS storageType_33,
  t23.size AS size_34,
  t23.date AS date_35,
  t23.category_id AS category_id_36,
  t37.alt AS alt_38,
  t37.width AS width_39,
  t37.height AS height_40,
  t37.hash AS hash_41,
  t37.needProcess AS needProcess_42,
  t37.id AS id_43,
  t37.path AS path_44,
  t37.fileName AS fileName_45,
  t37.mime AS mime_46,
  t37.storageType AS storageType_47,
  t37.size AS size_48,
  t37.date AS date_49,
  t37.category_id AS category_id_50,
  t0.parent_id AS parent_id_51
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_images t23 ON t23.category_id = t0.category_id
  LEFT JOIN xc_category_banners t37 ON t37.category_id = t0.category_id
WHERE
  t0.lpos = ?
LIMIT
  1

SELECT t0.ogMeta AS ogMeta_1, t0.useCustomOG AS useCustomOG_2, t0.csiHiddenCategory AS csiHiddenCategory_3, t0.csCreated AS csCreated_4, t0.csLastUpdate AS csLastUpdate_5, t0.flyoutColumns AS flyoutColumns_6, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_7, t0.category_id AS category_id_8, t0.lpos AS lpos_9, t0.rpos AS rpos_10, t0.enabled AS enabled_11, t0.show_title AS show_title_12, t0.depth AS depth_13, t0.pos AS pos_14, t0.root_category_look AS root_category_look_15, t0.metaDescType AS metaDescType_16, t0.xcPendingExport AS xcPendingExport_17, t18.id AS id_19, t18.subcategories_count_all AS subcategories_count_all_20, t18.subcategories_count_enabled AS subcategories_count_enabled_21, t18.category_id AS category_id_22, t23.alt AS alt_24, t23.width AS width_25, t23.height AS height_26, t23.hash AS hash_27, t23.needProcess AS needProcess_28, t23.id AS id_29, t23.path AS path_30, t23.fileName AS fileName_31, t23.mime AS mime_32, t23.storageType AS storageType_33, t23.size AS size_34, t23.date AS date_35, t23.category_id AS category_id_36, t37.alt AS alt_38, t37.width AS width_39, t37.height AS height_40, t37.hash AS hash_41, t37.needProcess AS needProcess_42, t37.id AS id_43, t37.path AS path_44, t37.fileName AS fileName_45, t37.mime AS mime_46, t37.storageType AS storageType_47, t37.size AS size_48, t37.date AS date_49, t37.category_id AS category_id_50, t0.parent_id AS parent_id_51 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_images t23 ON t23.category_id = t0.category_id LEFT JOIN xc_category_banners t37 ON t37.category_id = t0.category_id WHERE t0.lpos = 1 LIMIT 1;