Filter

Books by Ирина Савинова:
2 books

Showing 2 from 2 for "~" filtered by Ирина Савинова ×
  BENCHMARKS  
Loading Time: Base Classes  0.0073
Controller Execution Time ( Search / Filter )  0.1216
Total Execution Time  0.1301
  GET DATA  
No GET data exists
  MEMORY USAGE  
5,895,568 bytes
  POST DATA  
No POST data exists
  URI STRING  
author/filter/au_16679_%C3%90%C3%91%C3%90%C3%90%C2%BD%C3%90-%C3%90%C3%90%C3%90%C2%B2%C3%90%C3%90%C2%BD%C3%90%C2%BE%C3%90%C2%B2%C3%90/~
  CLASS/METHOD  
search/filter
  DATABASE:  esentral_ebook (Search:$db)   QUERIES: 17 (0.0801 seconds)  (Hide)
0.0061   SHOW TABLES FROM `esentral_ebook
0.0020   SELECT *
FROM `site_domains`
WHERE `domain` = 'ubsmebooks.com' 
0.0050   SELECT *
FROM `sites`
WHERE `site_id` = '12' 
0.0017   SELECT *
FROM `site_values`
WHERE `site_id` = '12' 
0.0020   SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'ubsm' 
0.0030   SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelfON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id
0.0063   SELECT *
FROM `sites_shelf`
WHERE `site_id` = '12'
AND `shelf_status` = 1
ORDER BY 
`sort_order
0.0053   SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY 
`nameAS
0.0011   SELECT *
FROM `authors`
WHERE `authors`.`author_id` = '16679'
 
LIMIT 1 
0.0039   SELECT `books`.`book_id`
FROM `books`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
WHERE `books`.`author_idIN (16679)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`book_id
0.0020   SELECT `books`.`author_id`, `authors`.`name`
FROM `books`
RIGHT JOIN `authorsON `authors`.`author_id` = `books`.`author_id`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
WHERE `books`.`author_idIN (16679)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`author_id
0.0059   SELECT `books`.`publisher_id`, `publisher`.`name`
FROM `books`
LEFT JOIN `publisherON `publisher`.`publisher_id` = `books`.`publisher_id`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
WHERE `books`.`author_idIN (16679)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`publisher_id
0.0142   SELECT `nested_category`.`category_id`, `nested_category`.`name_english`
FROM `books`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
LEFT JOIN `nested_categoryON `nested_category`.`category_id` = `book_categories`.`category_id`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
WHERE `books`.`author_idIN (16679)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`category_id
0.0102   SELECT `books`.`book_id`, `books`.`title`, `books`.`synopsis`, `books`.`publisher_id`, `publisher`.`name` as `publisher`, `books`.`author_id`, `authors`.`name` as `author`, `books`.`category_id`, `nested_category`.`name_english` as `category`, `nested_category`.`name_english` as `name_english`, `books`.`multicat`, `books`.`s3_cover`, `books`.`filesize`, `books`.`isbn`, `books`.`format`, `books`.`language`, `iso_639_3`.`Ref_Name`, `books`.`retail_price` as `main_price`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`tax_rate`, `books`.`epub_type`
FROM `books`
LEFT JOIN `authorsON `authors`.`author_id` = `books`.`author_id`
LEFT JOIN `publisherON `publisher`.`publisher_id` = `books`.`publisher_id`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
LEFT JOIN `nested_categoryON `nested_category`.`category_id` = `book_categories`.`category_id`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
LEFT JOIN `iso_639_3ON `iso_639_3`.`lang_id` = `books_lang`.`lang_id`
WHERE `books`.`author_idIN (16679)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`book_id`
ORDER BY `books`.`languageASC, `book_idDESC
 LIMIT 10 
0.0073   SELECT `iso_639_3`.`lang_id`, `iso_639_3`.`Id`, `iso_639_3`.`Ref_Name`
FROM `books`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
LEFT JOIN `iso_639_3ON `iso_639_3`.`lang_id` = `books_lang`.`lang_id`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
WHERE `books`.`author_idIN (16679)
AND `
books`.`offshelf` = 'N'
AND `iso_639_3`.`lang_idIS NOT NULL
GROUP BY 
`iso_639_3`.`lang_id
0.0022   SELECT `nested_category`.`category_id`, `nested_category`.`name_english`
FROM `books`
LEFT JOIN `book_categoriesON `book_categories`.`book_id` = `books`.`book_id`
LEFT JOIN `nested_categoryON `nested_category`.`category_id` = `book_categories`.`category_id`
LEFT JOIN `books_langON `books_lang`.`book_id` = `books`.`book_id`
LEFT JOIN `iso_639_3ON `iso_639_3`.`lang_id` = `books_lang`.`lang_id`
WHERE `books`.`author_idIN (16679)
AND `
nested_category`.`category_idIS NOT NULL
GROUP BY 
`book_categories`.`category_id
0.0019   SELECT *
FROM `authors`
WHERE `authors`.`author_id` = '16679'
 
LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)