Symfony Profiler

SELECT
  count(m0_.id) AS sclr_0
FROM
  magazine_subscription m0_
  INNER JOIN magazine_subscription_numbers m1_ ON m0_.subscription_number_id = m1_.id
  INNER JOIN circle c2_ ON m0_.circle_id = c2_.id
WHERE
  m0_.id LIKE ?
  OR m0_.code LIKE ?
  OR m0_.name LIKE ?
  OR m0_.phone LIKE ?
  OR m0_.address1 LIKE ?
  OR m0_.city LIKE ?
  OR c2_.circle_code LIKE ?
  OR m0_.manual_booking_ref LIKE ?
  OR m1_.id LIKE ?

SELECT count(m0_.id) AS sclr_0 FROM magazine_subscription m0_ INNER JOIN magazine_subscription_numbers m1_ ON m0_.subscription_number_id = m1_.id INNER JOIN circle c2_ ON m0_.circle_id = c2_.id WHERE m0_.id LIKE '%1062845%' OR m0_.code LIKE '%1062845%' OR m0_.name LIKE '%1062845%' OR m0_.phone LIKE '%1062845%' OR m0_.address1 LIKE '%1062845%' OR m0_.city LIKE '%1062845%' OR c2_.circle_code LIKE '%1062845%' OR m0_.manual_booking_ref LIKE '%1062845%' OR m1_.id LIKE '%1062845%';

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.class AS class_2,
  m0_.code AS code_3,
  m0_.sur_name AS sur_name_4,
  m0_.name AS name_5,
  m0_.address1 AS address1_6,
  m0_.address2 AS address2_7,
  m0_.address3 AS address3_8,
  m0_.city AS city_9,
  m0_.pin AS pin_10,
  m0_.phone AS phone_11,
  m0_.sub_type AS sub_type_12,
  m0_.is_foreign AS is_foreign_13,
  m0_.is_suspend AS is_suspend_14,
  m0_.subscription_date AS subscription_date_15,
  m0_.expire_date AS expire_date_16,
  m0_.temp_date AS temp_date_17,
  m0_.mag_copy AS mag_copy_18,
  m0_.mag_cop1 AS mag_cop1_19,
  m0_.remarks AS remarks_20,
  m0_.language AS language_21,
  m0_.old_code AS old_code_22,
  m0_.mailing_order AS mailing_order_23,
  m0_.registration_date AS registration_date_24,
  m0_.subscription_type AS subscription_type_25,
  m0_.amount AS amount_26,
  m0_.is_paid AS is_paid_27,
  m0_.is_verified_by_circle AS is_verified_by_circle_28,
  m0_.is_old AS is_old_29,
  m0_.manual_booking_ref AS manual_booking_ref_30,
  m0_.mobile AS mobile_31,
  m0_.is_by_hand AS is_by_hand_32,
  m0_.dispatch_mode AS dispatch_mode_33,
  m0_.email AS email_34,
  m0_.is_print AS is_print_35,
  m0_.payment_type AS payment_type_36,
  m0_.uuid AS uuid_37,
  m0_.created_on AS created_on_38,
  m0_.registered_by AS registered_by_39,
  m0_.subscription_start_date AS subscription_start_date_40,
  m0_.registered_from AS registered_from_41,
  m0_.ip AS ip_42,
  m0_.is_old_lifetime AS is_old_lifetime_43,
  m0_.state AS state_44,
  m0_.old_lifetime_magazine AS old_lifetime_magazine_45,
  m0_.old_lifetime_suspended_on AS old_lifetime_suspended_on_46,
  m0_.circle_id AS circle_id_47,
  m0_.member_id AS member_id_48,
  m0_.country_id AS country_id_49,
  m0_.destination_circle_id AS destination_circle_id_50,
  m0_.by_hand_master_id AS by_hand_master_id_51,
  m0_.destination_zone_id AS destination_zone_id_52,
  m0_.is_admin_id AS is_admin_id_53,
  m0_.subscription_number_id AS subscription_number_id_54,
  m0_.user_id AS user_id_55
FROM
  magazine_subscription m0_
  LEFT JOIN magazine_subscription_numbers m1_ ON m0_.subscription_number_id = m1_.id
  LEFT JOIN circle c2_ ON m0_.circle_id = c2_.id
WHERE
  m0_.id LIKE ?
  OR m0_.code LIKE ?
  OR m0_.name LIKE ?
  OR m0_.phone LIKE ?
  OR m0_.address1 LIKE ?
  OR m0_.city LIKE ?
  OR c2_.circle_code LIKE ?
  OR m0_.manual_booking_ref LIKE ?
  OR m1_.id LIKE ?
ORDER BY
  m0_.id DESC
LIMIT
  10
OFFSET
  10

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.class AS class_2, m0_.code AS code_3, m0_.sur_name AS sur_name_4, m0_.name AS name_5, m0_.address1 AS address1_6, m0_.address2 AS address2_7, m0_.address3 AS address3_8, m0_.city AS city_9, m0_.pin AS pin_10, m0_.phone AS phone_11, m0_.sub_type AS sub_type_12, m0_.is_foreign AS is_foreign_13, m0_.is_suspend AS is_suspend_14, m0_.subscription_date AS subscription_date_15, m0_.expire_date AS expire_date_16, m0_.temp_date AS temp_date_17, m0_.mag_copy AS mag_copy_18, m0_.mag_cop1 AS mag_cop1_19, m0_.remarks AS remarks_20, m0_.language AS language_21, m0_.old_code AS old_code_22, m0_.mailing_order AS mailing_order_23, m0_.registration_date AS registration_date_24, m0_.subscription_type AS subscription_type_25, m0_.amount AS amount_26, m0_.is_paid AS is_paid_27, m0_.is_verified_by_circle AS is_verified_by_circle_28, m0_.is_old AS is_old_29, m0_.manual_booking_ref AS manual_booking_ref_30, m0_.mobile AS mobile_31, m0_.is_by_hand AS is_by_hand_32, m0_.dispatch_mode AS dispatch_mode_33, m0_.email AS email_34, m0_.is_print AS is_print_35, m0_.payment_type AS payment_type_36, m0_.uuid AS uuid_37, m0_.created_on AS created_on_38, m0_.registered_by AS registered_by_39, m0_.subscription_start_date AS subscription_start_date_40, m0_.registered_from AS registered_from_41, m0_.ip AS ip_42, m0_.is_old_lifetime AS is_old_lifetime_43, m0_.state AS state_44, m0_.old_lifetime_magazine AS old_lifetime_magazine_45, m0_.old_lifetime_suspended_on AS old_lifetime_suspended_on_46, m0_.circle_id AS circle_id_47, m0_.member_id AS member_id_48, m0_.country_id AS country_id_49, m0_.destination_circle_id AS destination_circle_id_50, m0_.by_hand_master_id AS by_hand_master_id_51, m0_.destination_zone_id AS destination_zone_id_52, m0_.is_admin_id AS is_admin_id_53, m0_.subscription_number_id AS subscription_number_id_54, m0_.user_id AS user_id_55 FROM magazine_subscription m0_ LEFT JOIN magazine_subscription_numbers m1_ ON m0_.subscription_number_id = m1_.id LEFT JOIN circle c2_ ON m0_.circle_id = c2_.id WHERE m0_.id LIKE '%1062845%' OR m0_.code LIKE '%1062845%' OR m0_.name LIKE '%1062845%' OR m0_.phone LIKE '%1062845%' OR m0_.address1 LIKE '%1062845%' OR m0_.city LIKE '%1062845%' OR c2_.circle_code LIKE '%1062845%' OR m0_.manual_booking_ref LIKE '%1062845%' OR m1_.id LIKE '%1062845%' ORDER BY m0_.id DESC LIMIT 10 OFFSET 10;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.deleted AS deleted_6,
  t0.deleted_on AS deleted_on_7
FROM
  admin t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.deleted AS deleted_6, t0.deleted_on AS deleted_on_7 FROM admin t0 WHERE t0.id = 8;