Copyright © 2014 Opelclub Slovensko All Rights Reserved
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `galleries` | 6 | 6 | 1 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci'; | 1 | 1 | 0 | |
| 3 | SHOW FULL COLUMNS FROM `users` | 12 | 12 | 0 | |
| 4 | SHOW FULL COLUMNS FROM `partners` | 16 | 16 | 0 | |
| 5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | |
| 6 | SHOW FULL COLUMNS FROM `memberinfos` | 41 | 41 | 1 | |
| 7 | SHOW FULL COLUMNS FROM `ranks` | 2 | 2 | 0 | |
| 8 | SHOW FULL COLUMNS FROM `paymentmethods` | 4 | 4 | 0 | |
| 9 | SHOW FULL COLUMNS FROM `membercars` | 17 | 17 | 0 | |
| 10 | SHOW FULL COLUMNS FROM `fueltypes` | 4 | 4 | 0 | |
| 11 | SHOW FULL COLUMNS FROM `transmissions` | 4 | 4 | 0 | |
| 12 | SHOW FULL COLUMNS FROM `axles` | 4 | 4 | 0 | |
| 13 | SHOW FULL COLUMNS FROM `vipcards` | 8 | 8 | 0 | |
| 14 | SHOW FULL COLUMNS FROM `pictures` | 10 | 10 | 0 | |
| 15 | SHOW FULL COLUMNS FROM `menuitems` | 13 | 13 | 0 | |
| 16 | SHOW FULL COLUMNS FROM `menus` | 5 | 5 | 0 | |
| 17 | SHOW FULL COLUMNS FROM `categories` | 10 | 10 | 0 | |
| 18 | SHOW FULL COLUMNS FROM `settings` | 5 | 5 | 0 | |
| 19 | SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1 | 1 | 1 | 0 | |
| 20 | SHOW FULL COLUMNS FROM `pages` | 16 | 16 | 1 | |
| 21 | SHOW FULL COLUMNS FROM `attachments` | 7 | 7 | 0 | |
| 22 | SHOW FULL COLUMNS FROM `attachments_pages` | 3 | 3 | 0 | |
| 23 | SELECT `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 | 8 | 8 | 1 | |
| 24 | SELECT `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`) | 0 | 0 | 0 | |
| 25 | SELECT `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 | 8 | 8 | 0 | |
| 26 | SELECT `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 | 5 | 5 | 0 | |
| 27 | SHOW FULL COLUMNS FROM `adpositions` | 9 | 9 | 0 | |
| 28 | SHOW FULL COLUMNS FROM `advertisements` | 13 | 13 | 0 | |
| 29 | SELECT `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 | 2 | 2 | 0 | |
| 30 | SELECT `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-11-21 11:24:05' AND `Advertisement`.`valid_to` >= '2024-11-21 11:24:05' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC | 0 | 0 | 1 | |
| 31 | UPDATE `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 NULL | 0 | 0 | ||
| 32 | SELECT `Picture`.`gallery_id`, (COUNT(`Picture`.`gallery_id`)) AS `Picture__cnt` FROM `pictures` AS `Picture` WHERE `Picture`.`status` = 1 GROUP BY `Picture`.`gallery_id` | 53 | 53 | 2 | |
| 33 | SELECT `Gallery`.`id`, `Gallery`.`user_id` FROM `galleries` AS `Gallery` WHERE `Gallery`.`status` = 1 | 55 | 55 | 0 | |
| 34 | SELECT `User`.`id`, `User`.`nickname` FROM `users` AS `User` WHERE `User`.`status` = 1 AND `User`.`id` IN (1951, 1678, 2110, 1714, 2105, 2254, 2059, 1691, 1749, 2221, 1653, 2260, 1704, 3, 1760, 2208, 2184, 2285, 2288, 2368, 2362, 1916, 2126, 2432, 2438, 2436, 2411, 2441, 2445, 2457, 2460, 2477, 2485, 2513, 2516, 2530, 2450, 2121, 3446, 6591) | 38 | 38 | 1 | |
| 35 | SELECT COUNT(*) AS `count` FROM `galleries` AS `Gallery` LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) WHERE `Gallery`.`status` = 1 | 1 | 1 | 0 | |
| 36 | SELECT `Gallery`.`id`, `Gallery`.`user_id`, `Gallery`.`status`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`modified`, `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified` FROM `galleries` AS `Gallery` LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) WHERE `Gallery`.`status` = 1 ORDER BY `Gallery`.`modified` desc LIMIT 40, 10 | 10 | 10 | 0 | |
| 37 | SELECT `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` = (25) LIMIT 6 | 5 | 5 | 0 | |
| 38 | SELECT `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` = (24) LIMIT 6 | 5 | 5 | 0 | |
| 39 | SELECT `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` = (23) LIMIT 6 | 2 | 2 | 0 | |
| 40 | SELECT `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` = (22) LIMIT 6 | 0 | 0 | 0 | |
| 41 | SELECT `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` = (21) LIMIT 6 | 4 | 4 | 0 | |
| 42 | SELECT `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` = (20) LIMIT 6 | 4 | 4 | 0 | |
| 43 | SELECT `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` = (19) LIMIT 6 | 0 | 0 | 0 | |
| 44 | SELECT `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` = (18) LIMIT 6 | 0 | 0 | 0 | |
| 45 | SELECT `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` = (17) LIMIT 6 | 6 | 6 | 0 | |
| 46 | SELECT `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` = (16) LIMIT 6 | 6 | 6 | 0 |
