| 0.0079 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0034 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'e-sentral.sg'
|
| 0.0019 |
SELECT *
FROM `sites`
WHERE `site_id` = '4'
|
| 0.0024 |
SELECT *
FROM `site_values`
WHERE `site_id` = '4'
|
| 0.0028 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentralsg'
|
| 0.0023 |
SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
| 0.0035 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '4'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0024 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0027 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi_seberang'
AND `site_id` = '4'
|
| 0.0025 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '669'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0027 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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('669')
|
| 0.0022 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110097,110097,56071,36101,130918)
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110097
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110097
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 56071
|
| 0.0026 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 36101
|
| 0.0025 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 130918
|
| 0.0037 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_york_times_bestseller'
AND `site_id` = '4'
|
| 0.0027 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '309'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0035 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0023 |
SELECT *
FROM `authors`
WHERE `author_id` IN (54041,40366,48177,102099,108746)
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 54041
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 40366
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 48177
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 102099
|
| 0.0023 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 108746
|
| 0.0037 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'mills_boon_collection'
AND `site_id` = '4'
|
| 0.0024 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '492'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0032 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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('492')
|
| 0.0025 |
SELECT *
FROM `authors`
WHERE `author_id` IN (93864,103131,103988,105119,103028)
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 93864
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 103131
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 103988
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 105119
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 103028
|
| 0.0025 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'latest_malay_novels'
AND `site_id` = '4'
|
| 0.0020 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '294'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0040 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0034 |
SELECT *
FROM `authors`
WHERE `author_id` IN (111979,118430,124002,109116,108890)
|
| 0.0024 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 111979
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 118430
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 124002
|
| 0.0017 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109116
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 108890
|
| 0.0033 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'truestories_SG'
AND `site_id` = '4'
|
| 0.0023 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '299'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0034 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0028 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110826,53806,49790,119976,102393)
|
| 0.0023 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110826
|
| 0.0022 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 53806
|
| 0.0025 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 49790
|
| 0.0023 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 119976
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 102393
|
| 0.0024 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'food_soul'
AND `site_id` = '4'
|
| 0.0026 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '529'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0027 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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('529')
|
| 0.0021 |
SELECT *
FROM `authors`
WHERE `author_id` IN (118518,118318,108604,118516,118517)
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 118518
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 118318
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 108604
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 118516
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 118517
|
| 0.0033 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'entrepreneurship'
AND `site_id` = '4'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '491'
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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('491')
|
| 0.0017 |
SELECT *
FROM `authors`
WHERE `author_id` IN (10703,57706,28034,131711,51430)
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 10703
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 57706
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 28034
|
| 0.0017 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 131711
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 51430
|
| 0.0030 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '4'
|
| 0.0022 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '427'
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0024 |
SELECT *
FROM `authors`
WHERE `author_id` IN (2580,41681,31860,6890,2580)
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 2580
|
| 0.0032 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 41681
|
| 0.0025 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 31860
|
| 0.0038 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 6890
|
| 0.0030 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 2580
|
| 0.0028 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'kids'
AND `site_id` = '4'
|
| 0.0020 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '429'
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0021 |
SELECT *
FROM `authors`
WHERE `author_id` IN (30858,47169,74800,127654,113009)
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 30858
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 47169
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 74800
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 127654
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 113009
|
| 0.0031 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'whats_cookin'
AND `site_id` = '4'
|
| 0.0022 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '426'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0088 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0022 |
SELECT *
FROM `authors`
WHERE `author_id` IN (109829,29959,53514,29959,109829)
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109829
|
| 0.0023 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 29959
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 53514
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 29959
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109829
|
| 0.0028 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'all_time_favorite'
AND `site_id` = '4'
|
| 0.0027 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '433'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0031 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110097,131321,121358,107782,3059)
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110097
|
| 0.0017 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 131321
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 121358
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 107782
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 3059
|
| 0.0034 |
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.0028 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (277,109382,123839,47560,277)
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 277
|
| 0.0015 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109382
|
| 0.0017 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 123839
|
| 0.0017 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 47560
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 277
|
| 0.0027 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'general_novels'
AND `site_id` = '4'
|
| 0.0023 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '430'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0032 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0021 |
SELECT *
FROM `authors`
WHERE `author_id` IN (101914,109988,109922,112392,32091)
|
| 0.0030 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 101914
|
| 0.0024 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109988
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109922
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 112392
|
| 0.0018 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 32091
|
| 0.0033 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'romance_SG'
AND `site_id` = '4'
|
| 0.0027 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '300'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0028 |
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51438,109041,47988,53140,49129)
|
| 0.0019 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 51438
|
| 0.0017 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109041
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 47988
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 53140
|
| 0.0016 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 49129
|
| 0.0029 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'teen_novel'
AND `site_id` = '4'
|
| 0.0024 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '428'
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`.`retail_price` as `main_price`, `books`.`epub_type`, `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.0020 |
SELECT *
FROM `authors`
WHERE `author_id` IN (48937,111843,51655,47399,48881)
|
| 0.0021 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 48937
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 111843
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 51655
|
| 0.0022 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 47399
|
| 0.0023 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 48881
|
| 0.0036 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0027 |
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
|
