| 0.0024 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0013 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.bookcapital.my'
|
| 0.0013 |
SELECT *
FROM `sites`
WHERE `site_id` = '2'
|
| 0.0013 |
SELECT *
FROM `site_values`
WHERE `site_id` = '2'
|
| 0.0016 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '2'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0016 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0305 |
SELECT COUNT(*) AS `numrows`
FROM `books`
WHERE `books`.`category_id` IN (43)
AND `books`.`offshelf` = 'N'
|
| 0.0323 |
SELECT `books`.`author_id`, `authors`.`name`
FROM `books`
RIGHT JOIN `authors` ON `authors`.`author_id` = `books`.`author_id`
WHERE `books`.`category_id` IN (43)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`author_id`
|
| 0.0315 |
SELECT `books`.`publisher_id`, `publisher`.`name`
FROM `books`
LEFT JOIN `publisher` ON `publisher`.`publisher_id` = `books`.`publisher_id`
WHERE `books`.`category_id` IN (43)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`publisher_id`
|
| 0.0307 |
SELECT `books`.`category_id`, `nested_category`.`name_english`
FROM `books`
LEFT JOIN `nested_category` ON `nested_category`.`category_id` = `books`.`category_id`
WHERE `books`.`category_id` IN (43)
AND `books`.`offshelf` = 'N'
GROUP BY `books`.`category_id`
|
| 0.0320 |
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`.`retail_price` as `retail_price`, `books`.`ebook_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`.`category_id` IN (43)
AND `books`.`offshelf` = 'N'
ORDER BY `books`.`language` ASC, `book_id` DESC
LIMIT 10
|
| 0.0016 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` = '43'
LIMIT 1
|
