0.0050 |
SHOW TABLES FROM `esentral_ebook`
|
0.0035 |
SELECT * FROM `site_domains` WHERE `domain` = 'ubsmebooks.com'
|
0.0014 |
SELECT * FROM `sites` WHERE `site_id` = '12'
|
0.0012 |
SELECT * FROM `site_values` WHERE `site_id` = '12'
|
0.0017 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'ubsm'
|
0.0012 |
SELECT `slug`, `keyword` FROM `sites_shelf_keywords` LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
0.0188 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '12' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0056 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0030 |
SELECT * FROM `authors` WHERE `authors`.`author_id` = '101071' LIMIT 1
|
0.0033 |
SELECT `books`.`book_id` FROM `books` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` WHERE `books`.`author_id` IN (101071) AND `books`.`offshelf` = 'N' GROUP BY `books`.`book_id`
|
0.0023 |
SELECT `books`.`author_id`, `authors`.`name` FROM `books` RIGHT JOIN `authors` ON `authors`.`author_id` = `books`.`author_id` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` WHERE `books`.`author_id` IN (101071) AND `books`.`offshelf` = 'N' GROUP BY `books`.`author_id`
|
0.0028 |
SELECT `books`.`publisher_id`, `publisher`.`name` FROM `books` LEFT JOIN `publisher` ON `publisher`.`publisher_id` = `books`.`publisher_id` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` WHERE `books`.`author_id` IN (101071) AND `books`.`offshelf` = 'N' GROUP BY `books`.`publisher_id`
|
0.0110 |
SELECT `nested_category`.`category_id`, `nested_category`.`name_english` FROM `books` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` LEFT JOIN `nested_category` ON `nested_category`.`category_id` = `book_categories`.`category_id` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` WHERE `books`.`author_id` IN (101071) AND `books`.`offshelf` = 'N' GROUP BY `books`.`category_id`
|
0.0075 |
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 `authors` ON `authors`.`author_id` = `books`.`author_id` LEFT JOIN `publisher` ON `publisher`.`publisher_id` = `books`.`publisher_id` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` LEFT JOIN `nested_category` ON `nested_category`.`category_id` = `book_categories`.`category_id` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` LEFT JOIN `iso_639_3` ON `iso_639_3`.`lang_id` = `books_lang`.`lang_id` WHERE `books`.`author_id` IN (101071) AND `books`.`offshelf` = 'N' GROUP BY `books`.`book_id` ORDER BY `books`.`language` ASC, `book_id` DESC LIMIT 10
|
0.0034 |
SELECT `iso_639_3`.`lang_id`, `iso_639_3`.`Id`, `iso_639_3`.`Ref_Name` FROM `books` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` LEFT JOIN `iso_639_3` ON `iso_639_3`.`lang_id` = `books_lang`.`lang_id` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` WHERE `books`.`author_id` IN (101071) AND `books`.`offshelf` = 'N' AND `iso_639_3`.`lang_id` IS NOT NULL GROUP BY `iso_639_3`.`lang_id`
|
0.0034 |
SELECT `nested_category`.`category_id`, `nested_category`.`name_english` FROM `books` LEFT JOIN `book_categories` ON `book_categories`.`book_id` = `books`.`book_id` LEFT JOIN `nested_category` ON `nested_category`.`category_id` = `book_categories`.`category_id` LEFT JOIN `books_lang` ON `books_lang`.`book_id` = `books`.`book_id` LEFT JOIN `iso_639_3` ON `iso_639_3`.`lang_id` = `books_lang`.`lang_id` WHERE `books`.`author_id` IN (101071) AND `nested_category`.`category_id` IS NOT NULL GROUP BY `book_categories`.`category_id`
|
0.0034 |
SELECT * FROM `authors` WHERE `authors`.`author_id` = '101071' LIMIT 1
|