0.0068 |
SHOW TABLES FROM `esentral_ebook`
|
0.0024 |
SELECT * FROM `site_domains` WHERE `domain` = 'e-sentral.sg'
|
0.0011 |
SELECT * FROM `sites` WHERE `site_id` = '4'
|
0.0010 |
SELECT * FROM `site_values` WHERE `site_id` = '4'
|
0.0010 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'esentralsg'
|
0.0014 |
SELECT `slug`, `keyword` FROM `sites_shelf_keywords` LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
0.0026 |
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.0027 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'drama_adaptasi_seberang' AND `site_id` = '4'
|
0.0011 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '669' ORDER BY `sort_order` ASC LIMIT 1
|
0.0077 |
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.0011 |
SELECT * FROM `authors` WHERE `author_id` IN (110097,47218,41604,44673,44673)
|
0.0008 |
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.0008 |
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 = 47218
|
0.0007 |
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 = 41604
|
0.0009 |
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 = 44673
|
0.0009 |
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 = 44673
|
0.0035 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'short_stories' AND `site_id` = '4'
|
0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '711' 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('711')
|
0.0008 |
SELECT * FROM `authors` WHERE `author_id` IN (10313,135666,130584,135666,135666)
|
0.0008 |
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 = 10313
|
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 = 135666
|
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 = 130584
|
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 = 135666
|
0.0013 |
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 = 135666
|
0.0021 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_york_times_bestseller' AND `site_id` = '4'
|
0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '309' ORDER BY `sort_order` ASC LIMIT 1
|
0.0127 |
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.0040 |
SELECT * FROM `authors` WHERE `author_id` IN (54041,40366,48177,102099,108746)
|
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 = 54041
|
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 = 40366
|
0.0012 |
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.0035 |
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.0012 |
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.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'mills_boon_collection' AND `site_id` = '4'
|
0.0039 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '492' ORDER BY `sort_order` ASC LIMIT 1
|
0.5511 |
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.0027 |
SELECT * FROM `authors` WHERE `author_id` IN (93864,103131,103988,105119,103028)
|
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 = 93864
|
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 = 103131
|
0.0010 |
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.0009 |
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.0011 |
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.0043 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'latest_malay_novels' AND `site_id` = '4'
|
0.0033 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '294' ORDER BY `sort_order` ASC LIMIT 1
|
0.0241 |
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.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (111979,118430,124002,109116,108890)
|
0.0029 |
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.0034 |
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.0011 |
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.0010 |
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.0008 |
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.0018 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'truestories_SG' AND `site_id` = '4'
|
0.0011 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '299' ORDER BY `sort_order` ASC LIMIT 1
|
0.0112 |
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.0012 |
SELECT * FROM `authors` WHERE `author_id` IN (110826,53806,49790,119976,102393)
|
0.0009 |
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.0008 |
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.0007 |
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.0007 |
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.0007 |
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.0021 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'food_soul' AND `site_id` = '4'
|
0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '529' ORDER BY `sort_order` ASC LIMIT 1
|
0.0048 |
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.0013 |
SELECT * FROM `authors` WHERE `author_id` IN (118318,35710,114619,113806,22991)
|
0.0008 |
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.0007 |
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 = 35710
|
0.0006 |
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 = 114619
|
0.0006 |
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 = 113806
|
0.0007 |
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 = 22991
|
0.0022 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'entrepreneurship' AND `site_id` = '4'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '491' ORDER BY `sort_order` ASC LIMIT 1
|
0.0049 |
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.0013 |
SELECT * FROM `authors` WHERE `author_id` IN (131711,51430,131695,129662,126096)
|
0.0010 |
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.0011 |
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.0009 |
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 = 131695
|
0.0013 |
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 = 129662
|
0.0010 |
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 = 126096
|
0.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_books' AND `site_id` = '4'
|
0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '427' ORDER BY `sort_order` ASC LIMIT 1
|
0.0077 |
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.0013 |
SELECT * FROM `authors` WHERE `author_id` IN (2580,41681,31860,6890,2580)
|
0.0009 |
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.0009 |
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.0007 |
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.0008 |
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.0007 |
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.0029 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'kids' AND `site_id` = '4'
|
0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '429' ORDER BY `sort_order` ASC LIMIT 1
|
0.0079 |
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.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (30858,127654,130794,130474,17742)
|
0.0012 |
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.0010 |
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.0049 |
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 = 130794
|
0.0035 |
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 = 130474
|
0.0012 |
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 = 17742
|
0.0034 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'whats_cookin' AND `site_id` = '4'
|
0.0020 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '426' ORDER BY `sort_order` ASC LIMIT 1
|
0.0138 |
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.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (53514,117994,3054,113625,5842)
|
0.0011 |
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 = 117994
|
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 = 3054
|
0.0009 |
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 = 113625
|
0.0007 |
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 = 5842
|
0.0022 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'all_time_favorite' AND `site_id` = '4'
|
0.0009 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '433' ORDER BY `sort_order` ASC LIMIT 1
|
0.0159 |
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.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (110097,131321,121358,107782,3059)
|
0.0011 |
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.0009 |
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.0013 |
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.0008 |
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.0007 |
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.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'horror_stories' AND `site_id` = '4'
|
0.0009 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '293' ORDER BY `sort_order` ASC LIMIT 1
|
0.0089 |
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.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (277,109382,123839,47560,277)
|
0.0011 |
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.0031 |
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.0011 |
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.0011 |
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.0009 |
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.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'general_novels' AND `site_id` = '4'
|
0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '430' ORDER BY `sort_order` ASC LIMIT 1
|
0.0153 |
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.0039 |
SELECT * FROM `authors` WHERE `author_id` IN (101914,109988,109922,112392,32091)
|
0.0010 |
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.0009 |
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.0013 |
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.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 = 112392
|
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 = 32091
|
0.0020 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'romance_SG' AND `site_id` = '4'
|
0.0010 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '300' ORDER BY `sort_order` ASC LIMIT 1
|
0.0111 |
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.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (51438,109041,47988,53140,49129)
|
0.0009 |
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.0009 |
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.0010 |
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.0007 |
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.0006 |
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.0018 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'teen_novel' AND `site_id` = '4'
|
0.0009 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '428' ORDER BY `sort_order` ASC LIMIT 1
|
0.0079 |
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.0013 |
SELECT * FROM `authors` WHERE `author_id` IN (48937,111843,51655,48881,48822)
|
0.0011 |
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.0007 |
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.0007 |
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.0007 |
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.0007 |
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 = 48822
|
0.0032 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0029 |
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
|