1 | SELECT `Configuration`.`name`, `Configuration`.`value` FROM `rainyday_live`.`configurations` AS `Configuration` WHERE 1 = 1 | | 129 | 129 | 92 |
2 | SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`position`, `Menu`.`icon`, `Menu`.`order`, `Menu`.`url_path`, `Menu`.`created`, `Menu`.`modified` FROM `rainyday_live`.`menus` AS `Menu` WHERE `Menu`.`position` = 'top' ORDER BY `Menu`.`order` ASC | | 2 | 2 | 0 |
3 | SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`position`, `Menu`.`icon`, `Menu`.`order`, `Menu`.`url_path`, `Menu`.`created`, `Menu`.`modified` FROM `rainyday_live`.`menus` AS `Menu` WHERE `Menu`.`position` = 'bottom' ORDER BY `Menu`.`order` ASC | | 6 | 6 | 0 |
4 | SELECT `State`.`code`, `State`.`id` FROM `rainyday_live`.`states` AS `State` LEFT JOIN `rainyday_live`.`countries` AS `Country` ON (`State`.`country_id` = `Country`.`id`) LEFT JOIN `rainyday_live`.`contents` AS `Content` ON (`State`.`agreement_id` = `Content`.`id`) LEFT JOIN `rainyday_live`.`contents` AS `License` ON (`State`.`license_id` = `License`.`id`) LEFT JOIN `rainyday_live`.`loan_rules` AS `LoanRule` ON (`LoanRule`.`entity_id` = `State`.`id` AND `LoanRule`.`entity_name` = 'State') WHERE ((`State`.`max_loans` > 0) OR (`State`.`max_loans` IS NULL)) | | 3 | 3 | 1 |
5 | SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`facebook_birthday`, `User`.`username`, `User`.`profile_name`, `User`.`external_id`, `User`.`opt_in`, `User`.`status`, `User`.`address`, `User`.`zip_code`, `User`.`city`, `User`.`token`, `User`.`service`, `User`.`password`, `User`.`group_id`, `User`.`state_id`, `User`.`ach_gateway_id`, `User`.`grade_period`, `User`.`notification_free_days`, `User`.`invitation_code`, `User`.`priority`, `User`.`available_invitations`, `User`.`consumed_invitations`, `User`.`granted_invitations`, `User`.`note`, `User`.`user_notes`, `User`.`armed_forces_active_member`, `User`.`evs_verified`, `User`.`clarity_verified`, `User`.`provider_age_verified`, `User`.`step`, `User`.`custom_fees`, `User`.`ranking_score`, `User`.`created`, `User`.`modified`, `User`.`last_login`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`last_name`, " ", `User`.`first_name`, " - ", `User`.`username`)) AS `User__full_name_with_username` FROM `rainyday_live`.`users` AS `User` WHERE `User`.`state_id` IN (2, 42, 4) | | 2000 | 2000 | 15 |
6 | SELECT `StatePaydayResponse`.`id`, `StatePaydayResponse`.`type`, `StatePaydayResponse`.`code`, `StatePaydayResponse`.`description`, `StatePaydayResponse`.`others`, `StatePaydayResponse`.`display_errors`, `StatePaydayResponse`.`state_id` FROM `rainyday_live`.`state_payday_responses` AS `StatePaydayResponse` WHERE `StatePaydayResponse`.`state_id` IN (2, 42, 4) | | 0 | 0 | 0 |
7 | SELECT `State`.`id`, `State`.`name`, `State`.`country_id`, `State`.`verify_new_users`, `State`.`agreement_id`, `State`.`license_id`, `State`.`max_loans`, `State`.`code`, `State`.`payday_url`, `State`.`payday_username`, `State`.`payday_password`, `State`.`payday_license`, `State`.`payday_root_element`, `State`.`verify_payday`, `State`.`monthly_income_percent`, `State`.`capping_fees_percent`, `State`.`created`, `State`.`modified` FROM `rainyday_live`.`states` AS `State` WHERE `State`.`code` IN ('CA', 'TN', 'LA') | | 3 | 3 | 0 |
8 | SELECT `Content`.`id`, `Content`.`slug` FROM `rainyday_live`.`contents` AS `Content` WHERE `Content`.`id` IN (105, 94) AND `Content`.`type` = 'state_license' | | 2 | 2 | 0 |