|
Portada » Eventos EventosPage 1 of 1, showing 13 events out of 13 total, starting on record 1, ending on 13
<< anterior | siguiente >>
|
|
|
Portada » Eventos EventosPage 1 of 1, showing 13 events out of 13 total, starting on record 1, ending on 13
<< anterior | siguiente >>
|
|
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `events` | 14 | 14 | 1 | |
| 2 | DESCRIBE `events_categories` | 4 | 4 | 0 | |
| 3 | DESCRIBE `users` | 25 | 25 | 1 | |
| 4 | DESCRIBE `groups` | 3 | 3 | 0 | |
| 5 | DESCRIBE `companies_directories` | 5 | 5 | 0 | |
| 6 | DESCRIBE `galleries` | 9 | 9 | 0 | |
| 7 | DESCRIBE `images` | 8 | 8 | 0 | |
| 8 | SELECT COUNT(*) AS `count` FROM `events` AS `Event` LEFT JOIN `events_categories` AS `EventsCategory` ON (`Event`.`events_category_id` = `EventsCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Event`.`user_id` = `User`.`id`) WHERE `Event`.`status` = '1' | 1 | 1 | 0 | |
| 9 | SELECT `Event`.`id`, `Event`.`title`, `Event`.`body`, `Event`.`image`, `Event`.`event_date`, `Event`.`location`, `Event`.`homepage`, `Event`.`status`, `Event`.`price`, `Event`.`events_category_id`, `Event`.`user_id`, `Event`.`created`, `Event`.`updated`, `Event`.`deleted`, `EventsCategory`.`id`, `EventsCategory`.`name`, `EventsCategory`.`created`, `EventsCategory`.`updated`, `User`.`id`, `User`.`fullname`, `User`.`username`, `User`.`password`, `User`.`contact`, `User`.`avatar`, `User`.`address`, `User`.`zip`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`phone`, `User`.`fax`, `User`.`url`, `User`.`email`, `User`.`status`, `User`.`code`, `User`.`page_header`, `User`.`page_text`, `User`.`page_text_events`, `User`.`created`, `User`.`updated`, `User`.`deleted`, `User`.`companies_directory_id`, `User`.`group_id` FROM `events` AS `Event` LEFT JOIN `events_categories` AS `EventsCategory` ON (`Event`.`events_category_id` = `EventsCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Event`.`user_id` = `User`.`id`) WHERE `Event`.`status` = '1' ORDER BY `Event`.`event_date` desc LIMIT 20 | 13 | 13 | 1 | |
| 10 | SELECT `EventsCategory`.`id`, `EventsCategory`.`name` FROM `events_categories` AS `EventsCategory` WHERE 1 = 1 | 6 | 6 | 0 | |
| 11 | DESCRIBE `banners` | 12 | 12 | 1 | |
| 12 | SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`url`, `Banner`.`path`, `Banner`.`type`, `Banner`.`zone`, `Banner`.`pages`, `Banner`.`only_home`, `Banner`.`visits`, `Banner`.`created`, `Banner`.`updated`, `Banner`.`deleted` FROM `banners` AS `Banner` WHERE `Banner`.`zone` LIKE '%header%' AND `Banner`.`pages` LIKE '%/events%' ORDER BY rand() ASC | 0 | 0 | 0 | |
| 13 | SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`url`, `Banner`.`path`, `Banner`.`type`, `Banner`.`zone`, `Banner`.`pages`, `Banner`.`only_home`, `Banner`.`visits`, `Banner`.`created`, `Banner`.`updated`, `Banner`.`deleted` FROM `banners` AS `Banner` WHERE `Banner`.`zone` LIKE '%side_right%' AND `Banner`.`pages` LIKE '%/events%' ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 0 | |
| 14 | SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`url`, `Banner`.`path`, `Banner`.`type`, `Banner`.`zone`, `Banner`.`pages`, `Banner`.`only_home`, `Banner`.`visits`, `Banner`.`created`, `Banner`.`updated`, `Banner`.`deleted` FROM `banners` AS `Banner` WHERE `Banner`.`zone` LIKE '%footer%' AND `Banner`.`pages` LIKE '%/events%' ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 0 | |
| 15 | DESCRIBE `homes` | 6 | 6 | 0 | |
| 16 | SELECT `Texto`.`id`, `Texto`.`title`, `Texto`.`body`, `Texto`.`video`, `Texto`.`created`, `Texto`.`updated` FROM `homes` AS `Texto` WHERE `Texto`.`id` = 8 LIMIT 1 | 1 | 1 | 0 |