| 0.0047 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0014 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'e-sentral.sg'
|
| 0.0008 |
SELECT *
FROM `sites`
WHERE `site_id` = '4'
|
| 0.0017 |
SELECT *
FROM `site_values`
WHERE `site_id` = '4'
|
| 0.0023 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentralsg'
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '4'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0018 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'whats_cookin'
AND `site_id` = '4'
|
| 0.0044 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '426'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0030 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('426')
|
| 0.0016 |
SELECT *
FROM `authors`
WHERE `author_id` IN (118522,109829,47157,17653,30004)
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'latest_malay_novels'
AND `site_id` = '4'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '294'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0018 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('294')
|
| 0.0008 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110097,111979,40474,36671,121748)
|
| 0.0026 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '4'
|
| 0.0020 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '427'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0012 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('427')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108575,6890,2580,31860,41681)
|
| 0.0059 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'all_time_favorite'
AND `site_id` = '4'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '433'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0016 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('433')
|
| 0.0030 |
SELECT *
FROM `authors`
WHERE `author_id` IN (109988,47208,110358,31998,111872)
|
| 0.0015 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_york_times_bestseller'
AND `site_id` = '4'
|
| 0.0037 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '309'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0037 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('309')
|
| 0.0031 |
SELECT *
FROM `authors`
WHERE `author_id` IN (48362,53220,102099,53097,36935)
|
| 0.0037 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'horror_stories'
AND `site_id` = '4'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '293'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0016 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('293')
|
| 0.0005 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47558,118543,277,20279,30859)
|
| 0.0008 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'general_novels'
AND `site_id` = '4'
|
| 0.0006 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '430'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0019 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('430')
|
| 0.0007 |
SELECT *
FROM `authors`
WHERE `author_id` IN (9461,46949,49507,53117,47302)
|
| 0.0009 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'romance_SG'
AND `site_id` = '4'
|
| 0.0006 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '300'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0008 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('300')
|
| 0.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51438,24856,46688,109041,45804)
|
| 0.0019 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'teen_novel'
AND `site_id` = '4'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '428'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0025 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('428')
|
| 0.0005 |
SELECT *
FROM `authors`
WHERE `author_id` IN (48881,48937,50167,48822,46358)
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'kids'
AND `site_id` = '4'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '429'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0008 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('429')
|
| 0.0005 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52557,52954,47169,47564,47564)
|
| 0.0007 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'truestories_SG'
AND `site_id` = '4'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '299'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0010 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`author_id`, `shelf_books`.`sort_order`
FROM `books`
LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id`
LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id`
WHERE `books`.`offshelf` = 'N'
AND `shelf_books`.`sites_shelf_id` IN('299')
|
| 0.0005 |
SELECT *
FROM `authors`
WHERE `author_id` IN (111953,31925,10584,108830,118523)
|
| 0.0012 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0008 |
SELECT *
FROM `sites_ads_banner`
WHERE `sites_ads_banner`.`site_id` = '4'
AND `sites_ads_banner`.`group_id` = 6
AND `sites_ads_banner`.`status` = 'show'
ORDER BY `sort_order` ASC
|
.jpg)
