1 | 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 |
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` = 'bottom' ORDER BY `Menu`.`order` ASC | | 6 | 6 | 0 |
3 | 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 | 0 |
4 | 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 | 14 |
5 | 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 |
6 | 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 |
7 | 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 |
8 | SELECT `Content`.`id`, `Content`.`title`, `Content`.`class`, `Content`.`body`, `Content`.`slug`, `Content`.`type`, `Content`.`lft`, `Content`.`parent_id`, `Content`.`rght`, `Content`.`nav_label`, `Content`.`meta_custom`, `Content`.`visible`, `Content`.`created`, `Content`.`modified`, `ParentContent`.`id`, `ParentContent`.`title`, `ParentContent`.`class`, `ParentContent`.`body`, `ParentContent`.`slug`, `ParentContent`.`type`, `ParentContent`.`lft`, `ParentContent`.`parent_id`, `ParentContent`.`rght`, `ParentContent`.`nav_label`, `ParentContent`.`meta_custom`, `ParentContent`.`visible`, `ParentContent`.`created`, `ParentContent`.`modified`, `ContentMetatag`.`id`, `ContentMetatag`.`title`, `ContentMetatag`.`description`, `ContentMetatag`.`content_id`, `ContentMetatag`.`created`, `ContentMetatag`.`modified`, `CampaignList`.`id`, `CampaignList`.`title`, `CampaignList`.`type`, `CampaignList`.`content_id`, `CampaignList`.`priority_code_id`, `CampaignList`.`multi_queued_task_id`, `CampaignList`.`message`, `CampaignList`.`sent_count`, `CampaignList`.`scheduled_date`, `CampaignList`.`incoming_numbers`, `CampaignList`.`status`, `CampaignList`.`bounce_status`, `CampaignList`.`created`, `CampaignList`.`modified` FROM `rainyday_live`.`contents` AS `Content` LEFT JOIN `rainyday_live`.`contents` AS `ParentContent` ON (`Content`.`parent_id` = `ParentContent`.`id`) LEFT JOIN `rainyday_live`.`content_metatags` AS `ContentMetatag` ON (`ContentMetatag`.`content_id` = `Content`.`id`) LEFT JOIN `rainyday_live`.`campaign_lists` AS `CampaignList` ON (`CampaignList`.`content_id` = `Content`.`id`) WHERE `Content`.`slug` = 'resources' AND `Content`.`visible` = '1' AND `Content`.`type` IN ('pages', 'help', 'state_license') LIMIT 1 | | 1 | 1 | 0 |
9 | SELECT `Content`.`lft`, `Content`.`rght` FROM `rainyday_live`.`contents` AS `Content` WHERE `Content`.`id` = 95 LIMIT 1 | | 1 | 1 | 0 |
10 | SELECT `Content`.`id`, `Content`.`title`, `Content`.`class`, `Content`.`body`, `Content`.`slug`, `Content`.`type`, `Content`.`lft`, `Content`.`parent_id`, `Content`.`rght`, `Content`.`nav_label`, `Content`.`meta_custom`, `Content`.`visible`, `Content`.`created`, `Content`.`modified` FROM `rainyday_live`.`contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 73 AND `Content`.`rght` >= 74 ORDER BY `Content`.`lft` asc | | 1 | 1 | 0 |