0.0012 |
SHOW TABLES FROM `esentral_ebook`
|
0.0004 |
SELECT * FROM `site_domains` WHERE `domain` = 'www.bookcapital.my'
|
0.0003 |
SELECT * FROM `sites` WHERE `site_id` = '2'
|
0.0003 |
SELECT * FROM `site_values` WHERE `site_id` = '2'
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '2' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0005 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0351 |
SELECT COUNT(*) AS `numrows` FROM `books` WHERE `books`.`category_id` IN (43) AND `books`.`offshelf` = 'N'
|
0.0372 |
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.0364 |
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.0354 |
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.0367 |
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.0004 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` = '43' LIMIT 1
|