Letný zraz Podjavorník 2020


(default) 34 queries took 44 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `galleries`661
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci';111
3SHOW FULL COLUMNS FROM `users`12121
4SHOW FULL COLUMNS FROM `partners`16161
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
6SHOW FULL COLUMNS FROM `memberinfos`41411
7SHOW FULL COLUMNS FROM `ranks`221
8SHOW FULL COLUMNS FROM `paymentmethods`441
9SHOW FULL COLUMNS FROM `membercars`17171
10SHOW FULL COLUMNS FROM `fueltypes`441
11SHOW FULL COLUMNS FROM `transmissions`441
12SHOW FULL COLUMNS FROM `axles`441
13SHOW FULL COLUMNS FROM `vipcards`881
14SHOW FULL COLUMNS FROM `pictures`10101
15SHOW FULL COLUMNS FROM `menuitems`13131
16SHOW FULL COLUMNS FROM `menus`551
17SHOW FULL COLUMNS FROM `categories`10101
18SHOW FULL COLUMNS FROM `settings`551
19SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1 111
20SHOW FULL COLUMNS FROM `pages`16161
21SHOW FULL COLUMNS FROM `attachments`771
22SHOW FULL COLUMNS FROM `attachments_pages`331
23SELECT `Page`.`id`, `Page`.`content`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`is_highlight` = 1 AND `Page`.`status` != 3 ORDER BY `Page`.`modified` desc 882
24SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` IN (274, 257, 261, 258, 256, 198, 195, 197) AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`) 001
25SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`title`, `Menuitem`.`url`, `Menuitem`.`parent_id`, `Menuitem`.`lft`, `Menuitem`.`rght`, `Menuitem`.`status`, `Menuitem`.`emph`, `Menuitem`.`is_category_list`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `menuitems` AS `Menuitem` LEFT JOIN `menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) WHERE `Menuitem`.`menu_id` = 2 AND `Menuitem`.`status` != 3 ORDER BY `Menuitem`.`sort` asc 884
26SELECT `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `categories` AS `Category` WHERE `Category`.`status` != 3 AND `Category`.`show_in_menu` = 1 551
27SHOW FULL COLUMNS FROM `adpositions`991
28SHOW FULL COLUMNS FROM `advertisements`13131
29SELECT `Adposition`.`id`, `Adposition`.`title`, `Adposition`.`comment`, `Adposition`.`position_width`, `Adposition`.`position_height`, `Adposition`.`ad_width`, `Adposition`.`ad_height`, `Adposition`.`visible_ads_count`, `Adposition`.`status` FROM `adpositions` AS `Adposition` WHERE `Adposition`.`status` = 1 221
30SELECT `Advertisement`.`id`, `Advertisement`.`adposition_id`, `Advertisement`.`partner_id`, `Advertisement`.`valid_from`, `Advertisement`.`valid_to`, `Advertisement`.`saved_filename`, `Advertisement`.`alt`, `Advertisement`.`url`, `Advertisement`.`status`, `Advertisement`.`display_count`, `Advertisement`.`click_count`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`valid_from` <= '2024-10-04 13:50:06' AND `Advertisement`.`valid_to` >= '2024-10-04 13:50:06' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC 006
31UPDATE `advertisements` AS `Advertisement` LEFT JOIN `adpositions` AS `Adposition` ON (`Advertisement`.`adposition_id` = `Adposition`.`id`) SET `Advertisement`.`display_count` = Advertisement.display_count + 1 WHERE `Advertisement`.`id` IS NULL00
32SELECT `Gallery`.`id`, `Gallery`.`user_id`, `Gallery`.`status`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`modified` FROM `galleries` AS `Gallery` WHERE `Gallery`.`id` = 68 AND `Gallery`.`status` = 1 LIMIT 1111
33SELECT `Picture`.`id`, `Picture`.`gallery_id`, `Picture`.`title`, `Picture`.`comment`, `Picture`.`original_filename`, `Picture`.`saved_filename`, `Picture`.`filesize`, `Picture`.`status`, `Picture`.`created`, `Picture`.`modified` FROM `pictures` AS `Picture` WHERE `Picture`.`gallery_id` = (68) 92923
34SELECT `Picture`.`id`, `Picture`.`gallery_id`, `Picture`.`title`, `Picture`.`comment`, `Picture`.`original_filename`, `Picture`.`saved_filename`, `Picture`.`filesize`, `Picture`.`status`, `Picture`.`created`, `Picture`.`modified`, `Gallery`.`id`, `Gallery`.`user_id`, `Gallery`.`status`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`modified` FROM `pictures` AS `Picture` LEFT JOIN `galleries` AS `Gallery` ON (`Picture`.`gallery_id` = `Gallery`.`id`) WHERE `Picture`.`id` = 1913 AND `Picture`.`gallery_id` = 68 AND `Picture`.`status` = 1 LIMIT 1111