| 0.0045 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0028 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'esentral.id'
|
| 0.0038 |
SELECT *
FROM `sites`
WHERE `site_id` = '3'
|
| 0.0032 |
SELECT *
FROM `site_values`
WHERE `site_id` = '3'
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '3'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0013 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 2.2153 |
SELECT COUNT(*) AS `numrows`
FROM `books`
WHERE `books`.`language` = 'Mandarin'
AND `books`.`offshelf` = 'N'
|
| 1.8705 |
SELECT `books`.`author_id`, `authors`.`name`
FROM `books`
RIGHT JOIN `authors` ON `authors`.`author_id` = `books`.`author_id`
WHERE `books`.`language` = 'Mandarin'
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`author_id`
|
| 2.2355 |
SELECT `books`.`publisher_id`, `publisher`.`name`
FROM `books`
LEFT JOIN `publisher` ON `publisher`.`publisher_id` = `books`.`publisher_id`
WHERE `books`.`language` = 'Mandarin'
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`publisher_id`
|
| 2.0229 |
SELECT `books`.`category_id`, `nested_category`.`name_english`
FROM `books`
LEFT JOIN `nested_category` ON `nested_category`.`category_id` = `books`.`category_id`
WHERE `books`.`language` = 'Mandarin'
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`category_id`
|
| 0.5242 |
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`, `books`.`idr_price` as `retail_price`, `books`.`idr_ori_price` as `ebook_price`, `books`.`tax_rate`
FROM `books`
LEFT JOIN `authors` ON `authors`.`author_id` = `books`.`author_id`
LEFT JOIN `publisher` ON `publisher`.`publisher_id` = `books`.`publisher_id`
LEFT JOIN `nested_category` ON `nested_category`.`category_id` = `books`.`category_id`
WHERE `books`.`language` = 'Mandarin'
AND `books`.`offshelf` = 'N'
ORDER BY `books`.`language` ASC, `book_id` DESC
LIMIT 10
|
| 0.0033 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` = '38'
LIMIT 1
|
