1 | SELECT `Configuration`.`name`, `Configuration`.`value` FROM `properad_test`.`configurations` AS `Configuration` WHERE 1 = 1 | | 11 | 11 | 0 |
2 | SELECT `CalendarEvent`.`id`, `CalendarEvent`.`name`, `CalendarEvent`.`title`, `CalendarEvent`.`url`, `CalendarEvent`.`place`, `CalendarEvent`.`category_id`, `CalendarEvent`.`active`, `CalendarEvent`.`body_upper`, `CalendarEvent`.`body`, `CalendarEvent`.`awards`, `CalendarEvent`.`banner_id`, `CalendarEvent`.`image_id`, `CalendarEvent`.`link`, `CalendarEvent`.`start`, `CalendarEvent`.`end`, `CalendarEvent`.`lft`, `CalendarEvent`.`rght`, `CalendarEvent`.`parent_id`, `CalendarEvent`.`keywords`, `CalendarEvent`.`description`, `CalendarEvent`.`created`, `CalendarEvent`.`modified` FROM `properad_test`.`calendar_events` AS `CalendarEvent` WHERE ((NOT (`CalendarEvent`.`active` = '0')) AND (YEAR(`CalendarEvent`.`end`) >= 'YEAR(NOW)')) ORDER BY `CalendarEvent`.`start` ASC, `CalendarEvent`.`end` ASC, `CalendarEvent`.`modified` DESC, `CalendarEvent`.`created` DESC | | 2 | 2 | 1 |
3 | SELECT `CalendarEventPartner`.`id`, `CalendarEventPartner`.`calendar_event_id`, `CalendarEventPartner`.`partner_id`, `CalendarEventPartner`.`lft`, `CalendarEventPartner`.`rght`, `CalendarEventPartner`.`parent_id` FROM `properad_test`.`calendar_event_partners` AS `CalendarEventPartner` WHERE `CalendarEventPartner`.`calendar_event_id` IN (6, 7) | | 1 | 1 | 1 |
4 | SELECT `Partner`.`id`, `Partner`.`type`, `Partner`.`name`, `Partner`.`name_premium`, `Partner`.`symbol`, `Partner`.`body`, `Partner`.`summary`, `Partner`.`image`, `Partner`.`image_premium`, `Partner`.`show_logo_front`, `Partner`.`order_logo_front`, `Partner`.`register_url`, `Partner`.`login_url`, `Partner`.`payment_threshold`, `Partner`.`pluses`, `Partner`.`minuses`, `Partner`.`campaign_count`, `Partner`.`user_rates_count`, `Partner`.`avg_rate`, `Partner`.`avg_commission_settlement`, `Partner`.`avg_commission_amount`, `Partner`.`avg_tracking_capabilities`, `Partner`.`avg_campaign_amount`, `Partner`.`avg_new_campaign_frequency`, `Partner`.`avg_customer_service`, `Partner`.`avg_publisher_panel`, `Partner`.`avg_registration`, `Partner`.`show_register`, `Partner`.`show_landing`, `Partner`.`recommended`, `Partner`.`month`, `Partner`.`show_contact`, `Partner`.`company_data`, `Partner`.`contact_data`, `Partner`.`campaign_rate`, `Partner`.`premium`, `Partner`.`is_premium_in_ranking`, `Partner`.`premium_ranking_spot`, `Partner`.`lft`, `Partner`.`rght`, `Partner`.`parent_id`, `Partner`.`created`, `Partner`.`modified`, `Partner`.`visibility` FROM `properad_test`.`partners` AS `Partner` WHERE `Partner`.`id` = 20 ORDER BY `Partner`.`lft` ASC | | 1 | 1 | 1 |
5 | SELECT `CalendarEventCategoriesGroup`.`id`, `CalendarEventCategoriesGroup`.`calendar_event_id`, `CalendarEventCategoriesGroup`.`calendar_event_category_id`, `CalendarEventCategoriesGroup`.`lft`, `CalendarEventCategoriesGroup`.`rght`, `CalendarEventCategoriesGroup`.`parent_id` FROM `properad_test`.`calendar_event_categories_groups` AS `CalendarEventCategoriesGroup` WHERE `CalendarEventCategoriesGroup`.`calendar_event_id` IN (6, 7) | | 2 | 2 | 1 |
6 | SELECT `CalendarEventCategory`.`id`, `CalendarEventCategory`.`name`, `CalendarEventCategory`.`class_name`, `CalendarEventCategory`.`lft`, `CalendarEventCategory`.`rght`, `CalendarEventCategory`.`parent_id` FROM `properad_test`.`calendar_event_categories` AS `CalendarEventCategory` WHERE `CalendarEventCategory`.`id` = 9 ORDER BY `CalendarEventCategory`.`name` ASC | | 1 | 1 | 0 |
7 | SELECT `CalendarEventCategory`.`id`, `CalendarEventCategory`.`name`, `CalendarEventCategory`.`class_name`, `CalendarEventCategory`.`lft`, `CalendarEventCategory`.`rght`, `CalendarEventCategory`.`parent_id` FROM `properad_test`.`calendar_event_categories` AS `CalendarEventCategory` WHERE `CalendarEventCategory`.`id` = 10 ORDER BY `CalendarEventCategory`.`name` ASC | | 1 | 1 | 0 |
8 | SELECT `CalendarEventCategory`.`id`, `CalendarEventCategory`.`name`, `CalendarEventCategory`.`class_name`, `CalendarEventCategory`.`lft`, `CalendarEventCategory`.`rght`, `CalendarEventCategory`.`parent_id`, `ParentCalendarEventCategory`.`id`, `ParentCalendarEventCategory`.`name`, `ParentCalendarEventCategory`.`class_name`, `ParentCalendarEventCategory`.`lft`, `ParentCalendarEventCategory`.`rght`, `ParentCalendarEventCategory`.`parent_id` FROM `properad_test`.`calendar_event_categories` AS `CalendarEventCategory` LEFT JOIN `properad_test`.`calendar_event_categories` AS `ParentCalendarEventCategory` ON (`CalendarEventCategory`.`parent_id` = `ParentCalendarEventCategory`.`id`) WHERE 1 = 1 ORDER BY `CalendarEventCategory`.`lft` ASC, `CalendarEventCategory`.`name` ASC | | 2 | 2 | 0 |
9 | SELECT `ChildCalendarEventCategory`.`id`, `ChildCalendarEventCategory`.`name`, `ChildCalendarEventCategory`.`class_name`, `ChildCalendarEventCategory`.`lft`, `ChildCalendarEventCategory`.`rght`, `ChildCalendarEventCategory`.`parent_id` FROM `properad_test`.`calendar_event_categories` AS `ChildCalendarEventCategory` WHERE `ChildCalendarEventCategory`.`parent_id` IN (9, 10) | | 0 | 0 | 0 |
10 | SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`body`, `Banner`.`url`, `Banner`.`name`, `Banner`.`alt`, `Banner`.`active`, `Banner`.`active_contests`, `Banner`.`active_events`, `Banner`.`active_articles`, `Banner`.`target`, `Banner`.`form`, `Banner`.`lft`, `Banner`.`rght`, `Banner`.`parent_id`, `Banner`.`lp_id`, `Banner`.`created`, `Banner`.`modified` FROM `properad_test`.`banners` AS `Banner` WHERE `Banner`.`active_events` = '1' ORDER BY `lft` ASC, `id` DESC | | 0 | 0 | 0 |
11 | SELECT `Ad`.`id`, `Ad`.`parent_id`, `Ad`.`lft`, `Ad`.`rght`, `Ad`.`title`, `Ad`.`body`, `Ad`.`position`, `Ad`.`width`, `Ad`.`height`, `Ad`.`order`, `Ad`.`active`, `Ad`.`created`, `Ad`.`modified` FROM `properad_test`.`ads` AS `Ad` WHERE `Ad`.`position` = 'front_home_top' AND `Ad`.`active` = 1 | | 2 | 2 | 1 |