| 0.0068 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0019 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'esentral.id'
|
| 0.0019 |
SELECT *
FROM `sites`
WHERE `site_id` = '3'
|
| 0.0018 |
SELECT *
FROM `site_values`
WHERE `site_id` = '3'
|
| 0.0020 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentralid'
|
| 0.0029 |
SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
| 0.0037 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '3'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0021 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0022 |
SELECT *
FROM `authors`
WHERE `authors`.`author_id` = '37141'
LIMIT 1
|
| 0.0090 |
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 (37141)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`book_id`
|
| 0.0018 |
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 (37141)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`author_id`
|
| 0.0053 |
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 (37141)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`publisher_id`
|
| 0.0059 |
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 (37141)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`category_id`
|
| 0.0071 |
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`.`idr_price` as `retail_price`, `books`.`idr_ori_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 (37141)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`book_id`
ORDER BY `books`.`language` ASC, `book_id` DESC
LIMIT 10
|
| 0.0036 |
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 (37141)
AND `books`.`offshelf` = 'N'
AND `iso_639_3`.`lang_id` IS NOT NULL
GROUP BY `iso_639_3`.`lang_id`
|
| 0.0014 |
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 (37141)
AND `nested_category`.`category_id` IS NOT NULL
GROUP BY `book_categories`.`category_id`
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `authors`.`author_id` = '37141'
LIMIT 1
|
