Edice: Knihovna českých spisovatelů
vázaná, dobrý stav
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `CmsLanguage`.`id`, `CmsLanguage`.`parent_id`, `CmsLanguage`.`cms_navigation_root_id`, `CmsLanguage`.`template`, `CmsLanguage`.`image`, `CmsLanguage`.`title`, `CmsLanguage`.`description`, `CmsLanguage`.`gravity`, `CmsLanguage`.`cms_navigation_group_id`, `CmsLanguage`.`slug`, `CmsLanguage`.`redirect`, `CmsLanguage`.`protected`, `CmsLanguage`.`created`, `CmsLanguage`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsLanguage` WHERE `CmsLanguage`.`slug` = 'cze' AND `parent_id` IS NULL ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`slug` = 'cze' AND `CmsNavigation`.`parent_id` IS NULL ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 3 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`slug` = 'knihy' AND `CmsNavigation`.`parent_id` = 1 ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 1 ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`slug` = 'detail' AND `CmsNavigation`.`parent_id` = 3 ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 6 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 3 ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 7 | SELECT `CmsLanguage`.`id`, `CmsLanguage`.`parent_id`, `CmsLanguage`.`cms_navigation_root_id`, `CmsLanguage`.`template`, `CmsLanguage`.`image`, `CmsLanguage`.`title`, `CmsLanguage`.`description`, `CmsLanguage`.`gravity`, `CmsLanguage`.`cms_navigation_group_id`, `CmsLanguage`.`slug`, `CmsLanguage`.`redirect`, `CmsLanguage`.`protected`, `CmsLanguage`.`created`, `CmsLanguage`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsLanguage` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsLanguage`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `parent_id` IS NULL ORDER BY `gravity` ASC | 1 | 1 | 0 | |
| 8 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 1 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC | 3 | 3 | 0 | |
| 9 | SELECT `CmsNavigationStub`.`id`, `CmsNavigationStub`.`cms_navigation_id`, `CmsNavigationStub`.`template`, `CmsNavigationStub`.`title`, `CmsNavigationStub`.`description`, `CmsNavigationStub`.`content_short`, `CmsNavigationStub`.`content`, `CmsNavigationStub`.`gravity`, `CmsNavigationStub`.`created`, `CmsNavigationStub`.`updated` FROM `d203837_antik`.`cms_navigation_stubs` AS `CmsNavigationStub` WHERE `CmsNavigationStub`.`cms_navigation_id` = 4 | 1 | 1 | 0 | |
| 10 | SELECT COUNT(*) AS `count` FROM `d203837_antik`.`books` AS `Book` WHERE `Book`.`id` = 91744 | 1 | 1 | 0 | |
| 11 | SELECT `Book`.`id`, `Book`.`binding_id`, `Book`.`series_id`, `Book`.`illustrator_id`, `Book`.`director_id`, `Book`.`publisher_id`, `Book`.`quantity`, `Book`.`published_year`, `Book`.`price`, `Book`.`name`, `Book`.`image`, `Book`.`authors`, `Book`.`description`, `Book`.`description_long`, `Book`.`created`, `Book`.`updated`, `Series`.`id`, `Series`.`book_count`, `Series`.`name`, `Series`.`description`, `Series`.`created`, `Series`.`updated`, `Illustrator`.`id`, `Illustrator`.`book_count`, `Illustrator`.`first_name`, `Illustrator`.`last_name`, `Illustrator`.`created`, `Illustrator`.`updated`, (CONCAT(`Illustrator`.`last_name`, " ", `Illustrator`.`first_name`)) AS `Illustrator__name`, `Director`.`id`, `Director`.`book_count`, `Director`.`first_name`, `Director`.`last_name`, `Director`.`created`, `Director`.`updated`, (CONCAT(`Director`.`last_name`, " ", `Director`.`first_name`)) AS `Director__name`, `Publisher`.`id`, `Publisher`.`book_count`, `Publisher`.`name`, `Publisher`.`created`, `Publisher`.`updated`, `Binding`.`id`, `Binding`.`name`, `Binding`.`created`, `Binding`.`updated`, `FulltextBook`.`book_id`, `FulltextBook`.`book_text` FROM `d203837_antik`.`books` AS `Book` LEFT JOIN `d203837_antik`.`series` AS `Series` ON (`Book`.`series_id` = `Series`.`id`) LEFT JOIN `d203837_antik`.`illustrators` AS `Illustrator` ON (`Book`.`illustrator_id` = `Illustrator`.`id`) LEFT JOIN `d203837_antik`.`directors` AS `Director` ON (`Book`.`director_id` = `Director`.`id`) LEFT JOIN `d203837_antik`.`publishers` AS `Publisher` ON (`Book`.`publisher_id` = `Publisher`.`id`) LEFT JOIN `d203837_antik`.`bindings` AS `Binding` ON (`Book`.`binding_id` = `Binding`.`id`) LEFT JOIN `d203837_antik`.`fulltext_books` AS `FulltextBook` ON (`FulltextBook`.`book_id` = `Book`.`id`) WHERE `Book`.`id` = 91744 ORDER BY `Book`.`name` ASC LIMIT 1 | 1 | 1 | 1 | |
| 12 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`mode`, `Category`.`promoted`, `Category`.`name`, `Category`.`icon`, `Category`.`description`, `Category`.`created`, `Category`.`updated`, `BooksCategory`.`book_id`, `BooksCategory`.`category_id` FROM `d203837_antik`.`categories` AS `Category` JOIN `d203837_antik`.`books_categories` AS `BooksCategory` ON (`BooksCategory`.`book_id` = 91744 AND `BooksCategory`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
| 13 | SELECT `Author`.`id`, `Author`.`hidden`, `Author`.`first_name`, `Author`.`last_name`, `Author`.`created`, `Author`.`updated`, (CONCAT(`Author`.`last_name`, " ", `Author`.`first_name`)) AS `Author__name`, `AuthorsBook`.`author_id`, `AuthorsBook`.`book_id` FROM `d203837_antik`.`authors` AS `Author` JOIN `d203837_antik`.`authors_books` AS `AuthorsBook` ON (`AuthorsBook`.`book_id` = 91744 AND `AuthorsBook`.`author_id` = `Author`.`id`) | 1 | 1 | 0 | |
| 14 | SELECT `BooksCategory`.`book_id` FROM `d203837_antik`.`books_categories` AS `BooksCategory` WHERE category_id = (54) ORDER BY RAND() ASC LIMIT 5 | 5 | 5 | 9 | |
| 15 | SELECT `Book`.`id`, `Book`.`binding_id`, `Book`.`series_id`, `Book`.`illustrator_id`, `Book`.`director_id`, `Book`.`publisher_id`, `Book`.`quantity`, `Book`.`published_year`, `Book`.`price`, `Book`.`name`, `Book`.`image`, `Book`.`authors`, `Book`.`description`, `Book`.`description_long`, `Book`.`created`, `Book`.`updated` FROM `d203837_antik`.`books` AS `Book` WHERE `Book`.`id` != 91744 AND ((`Book`.`series_id` = 3181) OR (`Book`.`id` IN (19661, 43063, 7979, 29427, 21215))) LIMIT 5 | 5 | 5 | 1 | |
| 16 | SELECT `Author`.`id`, `Author`.`hidden`, `Author`.`first_name`, `Author`.`last_name`, `Author`.`created`, `Author`.`updated`, (CONCAT(`Author`.`last_name`, " ", `Author`.`first_name`)) AS `Author__name`, `AuthorsBook`.`author_id`, `AuthorsBook`.`book_id` FROM `d203837_antik`.`authors` AS `Author` JOIN `d203837_antik`.`authors_books` AS `AuthorsBook` ON (`AuthorsBook`.`book_id` IN (7979, 19661, 21215, 29427, 43063) AND `AuthorsBook`.`author_id` = `Author`.`id`) | 5 | 5 | 1 | |
| 17 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 1 AND `CmsNavigation`.`cms_navigation_group_id` = 2 ORDER BY `gravity` ASC | 1 | 1 | 0 | |
| 18 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 1 ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 19 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 18 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC | 3 | 3 | 0 | |
| 20 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 18 ORDER BY `gravity` ASC LIMIT 1 | 1 | 1 | 0 | |
| 21 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 24 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC | 0 | 0 | 0 | |
| 22 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 26 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC | 0 | 0 | 0 | |
| 23 | SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 19 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC | 0 | 0 | 0 | |
| 24 | SELECT `Book`.`id`, `Book`.`binding_id`, `Book`.`series_id`, `Book`.`illustrator_id`, `Book`.`director_id`, `Book`.`publisher_id`, `Book`.`quantity`, `Book`.`published_year`, `Book`.`price`, `Book`.`name`, `Book`.`image`, `Book`.`authors`, `Book`.`description`, `Book`.`description_long`, `Book`.`created`, `Book`.`updated` FROM `d203837_antik`.`books` AS `Book` WHERE `Book`.`id` = 91744 ORDER BY `Book`.`name` ASC LIMIT 1 | 1 | 1 | 2 | |
| 25 | SELECT `Author`.`id`, `Author`.`hidden`, `Author`.`first_name`, `Author`.`last_name`, `Author`.`created`, `Author`.`updated`, (CONCAT(`Author`.`last_name`, " ", `Author`.`first_name`)) AS `Author__name`, `AuthorsBook`.`author_id`, `AuthorsBook`.`book_id` FROM `d203837_antik`.`authors` AS `Author` JOIN `d203837_antik`.`authors_books` AS `AuthorsBook` ON (`AuthorsBook`.`book_id` = 91744 AND `AuthorsBook`.`author_id` = `Author`.`id`) | 1 | 1 | 0 |