bienvenue sur strascity.com
(default) 10 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `plpb_strascity`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `plpb_strascity`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '558a53ed69ba91f78558390e709210c5' LIMIT 1000
3SELECT `Tag`.`tag`, `Tag`.`created`, (SELECT count(*) FROM tags WHERE tag=Tag.tag) as count FROM `plpb_strascity`.`tags` AS `Tag` WHERE 1 = 1 GROUP BY `Tag`.`tag` ORDER BY `count` desc LIMIT 12001
4SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `plpb_strascity`.`categories` AS `Category` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `Category`.`type` = 'Video' AND `Category`.`active` = '1' ORDER BY `Category`.`weight` asc111
5SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC221
6SELECT `Event`.`id`, `Event`.`category_id`, `Event`.`title`, `Event`.`description`, `Event`.`user_id`, `Event`.`location`, `Event`.`from`, `Event`.`from_time`, `Event`.`to`, `Event`.`to_time`, `Event`.`created`, `Event`.`type`, `Event`.`photo`, `Event`.`event_rsvp_count`, `Event`.`address`, `Event`.`timezone`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `plpb_strascity`.`events` AS `Event` LEFT JOIN `plpb_strascity`.`users` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `plpb_strascity`.`categories` AS `Category` ON (`Event`.`category_id` = `Category`.`id`) WHERE `Event`.`to` >= CURDATE() AND `Event`.`type` = 1 AND `User`.`active` = '1' ORDER BY `Event`.`from` asc LIMIT 10001
7SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `plpb_strascity`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1111
8SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `plpb_strascity`.`settings` AS `Setting` LEFT JOIN `plpb_strascity`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1111
9SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `plpb_strascity`.`settings` AS `Setting` LEFT JOIN `plpb_strascity`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1111
10SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `plpb_strascity`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1110