Executing (default) SELECT "User"."id", "User"."first_name", "User"."last_name", "User"."legal_name", "User"."country_code", "User"."phone_number", "User"."email", "User"."email_verification_code", "User"."email_is_verified", "User"."password", "User"."token", "User"."mobile_token", "User"."token_expiry_date", "User"."profile_picture_url", "User"."location_coordinates", "User"."city_fk", "User"."address", "User"."zip_code", "User"."phone_is_verified", "User"."reset_password_token", "User"."reset_password_token_expiry_date", "User"."location_fk", "User"."created_at", "User"."updated_at", "instructorDetail"."user_fk" AS "instructorDetail.user_fk", "instructorDetail"."is_active" AS "instructorDetail.is_active", "instructorDetail"."personal_bio" AS "instructorDetail.personal_bio", "instructorDetail"."pay_rate" AS "instructorDetail.pay_rate", "instructorDetail"."pay_rate_reason" AS "instructorDetail.pay_rate_reason", "instructorDetail"."is_trained" AS "instructorDetail.is_trained", "instructorDetail"."is_background_checked" AS "instructorDetail.is_background_checked", "instructorDetail"."birth_date" AS "instructorDetail.birth_date", "instructorDetail"."comment" AS "instructorDetail.comment", "instructorDetail"."stripe_account_id" AS "instructorDetail.stripe_account_id", "instructorDetail"."push_id" AS "instructorDetail.push_id", "instructorDetail"."app_info" AS "instructorDetail.app_info", "instructorDetail"."heard_about_ktp_from" AS "instructorDetail.heard_about_ktp_from", "instructorDetail"."heard_about_ktp_from_comment" AS "instructorDetail.heard_about_ktp_from_comment", "instructorDetail"."stripe_verification_problem" AS "instructorDetail.stripe_verification_problem", "instructorDetail"."account_bank_name" AS "instructorDetail.account_bank_name", "instructorDetail"."list_of_awards" AS "instructorDetail.list_of_awards", "instructorDetail"."list_of_certifications" AS "instructorDetail.list_of_certifications", "instructorDetail"."personal_highlight" AS "instructorDetail.personal_highlight", "instructorDetail"."professional_affiliations" AS "instructorDetail.professional_affiliations", "instructorDetail"."driver_licence_image_url" AS "instructorDetail.driver_licence_image_url", "instructorDetail"."driver_licence_back_image_url" AS "instructorDetail.driver_licence_back_image_url", "instructorDetail"."availabilities" AS "instructorDetail.availabilities", "instructorDetail"."is_screened" AS "instructorDetail.is_screened", "instructorDetail"."created_at" AS "instructorDetail.created_at", "instructorDetail"."updated_at" AS "instructorDetail.updated_at", "parentDetail"."user_fk" AS "parentDetail.user_fk", "parentDetail"."stripe_customer_id" AS "parentDetail.stripe_customer_id", "parentDetail"."emergency_contacts" AS "parentDetail.emergency_contacts", "parentDetail"."authorize_customer_profile_id" AS "parentDetail.authorize_customer_profile_id", "parentDetail"."created_at" AS "parentDetail.created_at", "parentDetail"."updated_at" AS "parentDetail.updated_at", "vendorDetail"."id" AS "vendorDetail.id", "vendorDetail"."login_fk" AS "vendorDetail.login_fk", "vendorDetail"."name" AS "vendorDetail.name", "vendorDetail"."vendor_type" AS "vendorDetail.vendor_type", "vendorDetail"."session_cut" AS "vendorDetail.session_cut", "vendorDetail"."monthly_fee" AS "vendorDetail.monthly_fee", "vendorDetail"."description" AS "vendorDetail.description", "vendorDetail"."stripe_verification_problem" AS "vendorDetail.stripe_verification_problem", "vendorDetail"."account_bank_name" AS "vendorDetail.account_bank_name", "vendorDetail"."stripe_account_id" AS "vendorDetail.stripe_account_id", "vendorDetail"."url" AS "vendorDetail.url", "vendorDetail"."logo_url" AS "vendorDetail.logo_url", "vendorDetail"."owner" AS "vendorDetail.owner", "vendorDetail"."staff" AS "vendorDetail.staff", "vendorDetail"."email" AS "vendorDetail.email", "vendorDetail"."city_fk" AS "vendorDetail.city_fk", "vendorDetail"."address" AS "vendorDetail.address", "vendorDetail"."zip_code" AS "vendorDetail.zip_code", "vendorDetail"."country_code" AS "vendorDetail.country_code", "vendorDetail"."phone_number" AS "vendorDetail.phone_number", "vendorDetail"."cancellation_policy" AS "vendorDetail.cancellation_policy", "vendorDetail"."liability_waiver" AS "vendorDetail.liability_waiver", "vendorDetail"."socials" AS "vendorDetail.socials", "vendorDetail"."faq" AS "vendorDetail.faq", "vendorDetail"."ein" AS "vendorDetail.ein", "vendorDetail"."account_plan" AS "vendorDetail.account_plan", "vendorDetail"."stripe_customer_id" AS "vendorDetail.stripe_customer_id", "vendorDetail"."created_at" AS "vendorDetail.created_at", "vendorDetail"."updated_at" AS "vendorDetail.updated_at", "adminDetail"."user_fk" AS "adminDetail.user_fk", "adminDetail"."role" AS "adminDetail.role", "adminDetail"."is_disabled" AS "adminDetail.is_disabled", "adminDetail"."created_at" AS "adminDetail.created_at", "adminDetail"."updated_at" AS "adminDetail.updated_at", "schoolDetail"."id" AS "schoolDetail.id", "schoolDetail"."login_fk" AS "schoolDetail.login_fk", "schoolDetail"."district_fk" AS "schoolDetail.district_fk", "schoolDetail"."is_active" AS "schoolDetail.is_active", "schoolDetail"."principal" AS "schoolDetail.principal", "schoolDetail"."secretary" AS "schoolDetail.secretary", "schoolDetail"."name" AS "schoolDetail.name", "schoolDetail"."pta" AS "schoolDetail.pta", "schoolDetail"."note" AS "schoolDetail.note", "schoolDetail"."is_preschool" AS "schoolDetail.is_preschool", "schoolDetail"."location_fk" AS "schoolDetail.location_fk", "schoolDetail"."created_at" AS "schoolDetail.created_at", "schoolDetail"."updated_at" AS "schoolDetail.updated_at" FROM "users" AS "User" LEFT OUTER JOIN "instructors" AS "instructorDetail" ON "User"."id" = "instructorDetail"."user_fk" LEFT OUTER JOIN "parents" AS "parentDetail" ON "User"."id" = "parentDetail"."user_fk" LEFT OUTER JOIN "vendors" AS "vendorDetail" ON "User"."id" = "vendorDetail"."login_fk" LEFT OUTER JOIN "admins" AS "adminDetail" ON "User"."id" = "adminDetail"."user_fk" LEFT OUTER JOIN "schools" AS "schoolDetail" ON "User"."id" = "schoolDetail"."login_fk" WHERE "User"."token" = '37112dce2537f1c5d59c585bf43b42dcbc4494f4322d4f5527bc6e212ed0ad53618971bdfb573b939d4f51e05f416326a745135e29cea5260f3708d54d004791' LIMIT 1;
Executing (default) SELECT "User"."id", "User"."first_name", "User"."last_name", "User"."legal_name", "User"."country_code", "User"."phone_number", "User"."email", "User"."email_verification_code", "User"."email_is_verified", "User"."password", "User"."token", "User"."mobile_token", "User"."token_expiry_date", "User"."profile_picture_url", "User"."location_coordinates", "User"."city_fk", "User"."address", "User"."zip_code", "User"."phone_is_verified", "User"."reset_password_token", "User"."reset_password_token_expiry_date", "User"."location_fk", "User"."created_at", "User"."updated_at", "instructorDetail"."user_fk" AS "instructorDetail.user_fk", "instructorDetail"."is_active" AS "instructorDetail.is_active", "instructorDetail"."personal_bio" AS "instructorDetail.personal_bio", "instructorDetail"."pay_rate" AS "instructorDetail.pay_rate", "instructorDetail"."pay_rate_reason" AS "instructorDetail.pay_rate_reason", "instructorDetail"."is_trained" AS "instructorDetail.is_trained", "instructorDetail"."is_background_checked" AS "instructorDetail.is_background_checked", "instructorDetail"."birth_date" AS "instructorDetail.birth_date", "instructorDetail"."comment" AS "instructorDetail.comment", "instructorDetail"."stripe_account_id" AS "instructorDetail.stripe_account_id", "instructorDetail"."push_id" AS "instructorDetail.push_id", "instructorDetail"."app_info" AS "instructorDetail.app_info", "instructorDetail"."heard_about_ktp_from" AS "instructorDetail.heard_about_ktp_from", "instructorDetail"."heard_about_ktp_from_comment" AS "instructorDetail.heard_about_ktp_from_comment", "instructorDetail"."stripe_verification_problem" AS "instructorDetail.stripe_verification_problem", "instructorDetail"."account_bank_name" AS "instructorDetail.account_bank_name", "instructorDetail"."list_of_awards" AS "instructorDetail.list_of_awards", "instructorDetail"."list_of_certifications" AS "instructorDetail.list_of_certifications", "instructorDetail"."personal_highlight" AS "instructorDetail.personal_highlight", "instructorDetail"."professional_affiliations" AS "instructorDetail.professional_affiliations", "instructorDetail"."driver_licence_image_url" AS "instructorDetail.driver_licence_image_url", "instructorDetail"."driver_licence_back_image_url" AS "instructorDetail.driver_licence_back_image_url", "instructorDetail"."availabilities" AS "instructorDetail.availabilities", "instructorDetail"."is_screened" AS "instructorDetail.is_screened", "instructorDetail"."created_at" AS "instructorDetail.created_at", "instructorDetail"."updated_at" AS "instructorDetail.updated_at", "parentDetail"."user_fk" AS "parentDetail.user_fk", "parentDetail"."stripe_customer_id" AS "parentDetail.stripe_customer_id", "parentDetail"."emergency_contacts" AS "parentDetail.emergency_contacts", "parentDetail"."authorize_customer_profile_id" AS "parentDetail.authorize_customer_profile_id", "parentDetail"."created_at" AS "parentDetail.created_at", "parentDetail"."updated_at" AS "parentDetail.updated_at", "vendorDetail"."id" AS "vendorDetail.id", "vendorDetail"."login_fk" AS "vendorDetail.login_fk", "vendorDetail"."name" AS "vendorDetail.name", "vendorDetail"."vendor_type" AS "vendorDetail.vendor_type", "vendorDetail"."session_cut" AS "vendorDetail.session_cut", "vendorDetail"."monthly_fee" AS "vendorDetail.monthly_fee", "vendorDetail"."description" AS "vendorDetail.description", "vendorDetail"."stripe_verification_problem" AS "vendorDetail.stripe_verification_problem", "vendorDetail"."account_bank_name" AS "vendorDetail.account_bank_name", "vendorDetail"."stripe_account_id" AS "vendorDetail.stripe_account_id", "vendorDetail"."url" AS "vendorDetail.url", "vendorDetail"."logo_url" AS "vendorDetail.logo_url", "vendorDetail"."owner" AS "vendorDetail.owner", "vendorDetail"."staff" AS "vendorDetail.staff", "vendorDetail"."email" AS "vendorDetail.email", "vendorDetail"."city_fk" AS "vendorDetail.city_fk", "vendorDetail"."address" AS "vendorDetail.address", "vendorDetail"."zip_code" AS "vendorDetail.zip_code", "vendorDetail"."country_code" AS "vendorDetail.country_code", "vendorDetail"."phone_number" AS "vendorDetail.phone_number", "vendorDetail"."cancellation_policy" AS "vendorDetail.cancellation_policy", "vendorDetail"."liability_waiver" AS "vendorDetail.liability_waiver", "vendorDetail"."socials" AS "vendorDetail.socials", "vendorDetail"."faq" AS "vendorDetail.faq", "vendorDetail"."ein" AS "vendorDetail.ein", "vendorDetail"."account_plan" AS "vendorDetail.account_plan", "vendorDetail"."stripe_customer_id" AS "vendorDetail.stripe_customer_id", "vendorDetail"."created_at" AS "vendorDetail.created_at", "vendorDetail"."updated_at" AS "vendorDetail.updated_at", "adminDetail"."user_fk" AS "adminDetail.user_fk", "adminDetail"."role" AS "adminDetail.role", "adminDetail"."is_disabled" AS "adminDetail.is_disabled", "adminDetail"."created_at" AS "adminDetail.created_at", "adminDetail"."updated_at" AS "adminDetail.updated_at", "schoolDetail"."id" AS "schoolDetail.id", "schoolDetail"."login_fk" AS "schoolDetail.login_fk", "schoolDetail"."district_fk" AS "schoolDetail.district_fk", "schoolDetail"."is_active" AS "schoolDetail.is_active", "schoolDetail"."principal" AS "schoolDetail.principal", "schoolDetail"."secretary" AS "schoolDetail.secretary", "schoolDetail"."name" AS "schoolDetail.name", "schoolDetail"."pta" AS "schoolDetail.pta", "schoolDetail"."note" AS "schoolDetail.note", "schoolDetail"."is_preschool" AS "schoolDetail.is_preschool", "schoolDetail"."location_fk" AS "schoolDetail.location_fk", "schoolDetail"."created_at" AS "schoolDetail.created_at", "schoolDetail"."updated_at" AS "schoolDetail.updated_at" FROM "users" AS "User" LEFT OUTER JOIN "instructors" AS "instructorDetail" ON "User"."id" = "instructorDetail"."user_fk" LEFT OUTER JOIN "parents" AS "parentDetail" ON "User"."id" = "parentDetail"."user_fk" LEFT OUTER JOIN "vendors" AS "vendorDetail" ON "User"."id" = "vendorDetail"."login_fk" LEFT OUTER JOIN "admins" AS "adminDetail" ON "User"."id" = "adminDetail"."user_fk" LEFT OUTER JOIN "schools" AS "schoolDetail" ON "User"."id" = "schoolDetail"."login_fk" WHERE "User"."token" = '37112dce2537f1c5d59c585bf43b42dcbc4494f4322d4f5527bc6e212ed0ad53618971bdfb573b939d4f51e05f416326a745135e29cea5260f3708d54d004791' LIMIT 1;
paginationTest { isDescending: false,
  dbPrimaryKeys: [ 'id' ],
  borders: [],
  limit: 300 }
Executing (default) SELECT count("Kid"."id") AS "count" FROM "kids" AS "Kid" INNER JOIN "asps_sessions_kids" AS "aspSessionKid" ON "Kid"."id" = "aspSessionKid"."kid_fk" INNER JOIN "asps_sessions" AS "aspSessionKid->session" ON "aspSessionKid"."session_fk" = "aspSessionKid->session"."id" AND "aspSessionKid->session"."school_fk" = 266;
Executing (default) SELECT count("Kid"."id") AS "count" FROM "kids" AS "Kid" INNER JOIN "asps_sessions_kids" AS "aspSessionKid" ON "Kid"."id" = "aspSessionKid"."kid_fk" INNER JOIN "asps_sessions" AS "aspSessionKid->session" ON "aspSessionKid"."session_fk" = "aspSessionKid->session"."id" AND "aspSessionKid->session"."school_fk" = 266;
Executing (default) SELECT "Kid"."id", "Kid"."gender", "Kid"."health_info", "Kid"."parent_fk", "Kid"."school_fk", "Kid"."birth_date", "Kid"."grade", "Kid"."first_name", "Kid"."last_name", "Kid"."profile_picture_url", "Kid"."is_preschool", "Kid"."old_obj_id", "Kid"."created_at", "Kid"."updated_at", "aspSessionKid"."kid_fk" AS "aspSessionKid.kid_fk", "aspSessionKid"."session_fk" AS "aspSessionKid.session_fk", "aspSessionKid->session"."id" AS "aspSessionKid.session.id", "aspSessionKid->session"."school_fk" AS "aspSessionKid.session.school_fk" FROM "kids" AS "Kid" INNER JOIN "asps_sessions_kids" AS "aspSessionKid" ON "Kid"."id" = "aspSessionKid"."kid_fk" INNER JOIN "asps_sessions" AS "aspSessionKid->session" ON "aspSessionKid"."session_fk" = "aspSessionKid->session"."id" AND "aspSessionKid->session"."school_fk" = 266 ORDER BY "Kid"."id" ASC LIMIT 300;
Executing (default) SELECT "id", "login_fk", "district_fk", "is_active", "principal", "secretary", "name", "pta", "note", "is_preschool", "location_fk", "created_at", "updated_at" FROM "schools" AS "School" WHERE "School"."id" IN (266, 98, 4, 16, 84);