0.0011 |
SHOW TABLES FROM `esentral_ebook`
|
0.0003 |
SELECT * FROM `site_domains` WHERE `domain` = 'e-sentral.sg'
|
0.0002 |
SELECT * FROM `sites` WHERE `site_id` = '4'
|
0.0002 |
SELECT * FROM `site_values` WHERE `site_id` = '4'
|
0.0003 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'esentralsg'
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '4' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0006 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_york_times_bestseller' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '309' 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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (83089,51747,46358,49146,48362)
|
0.0002 |
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 = 83089
|
0.0002 |
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 = 51747
|
0.0002 |
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 = 46358
|
0.0002 |
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 = 49146
|
0.0002 |
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 = 48362
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'mills_boon_collection' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '492' ORDER BY `sort_order` ASC LIMIT 1
|
0.0006 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (93864,103988,105119,103028,103038)
|
0.0003 |
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.0002 |
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.0002 |
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.0002 |
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.0002 |
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 = 103038
|
0.0004 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'entrepreneurship' AND `site_id` = '4'
|
0.0002 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '491' ORDER BY `sort_order` ASC LIMIT 1
|
0.0004 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (28036,20712,96899,10703,107974)
|
0.0002 |
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 = 28036
|
0.0002 |
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 = 20712
|
0.0002 |
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 = 96899
|
0.0001 |
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.0002 |
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 = 107974
|
0.0004 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_books' AND `site_id` = '4'
|
0.0002 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '427' ORDER BY `sort_order` ASC LIMIT 1
|
0.0006 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (2580,41681,31860,6890,2580)
|
0.0002 |
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.0002 |
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.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 = 31860
|
0.0002 |
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.0002 |
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.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'latest_malay_novels' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '294' 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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (110097,121191,82266,29645,59162)
|
0.0002 |
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.0002 |
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 = 121191
|
0.0002 |
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 = 82266
|
0.0002 |
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 = 29645
|
0.0002 |
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 = 59162
|
0.0008 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'kids' AND `site_id` = '4'
|
0.0002 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '429' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (52557,126930,124884,22572,47169)
|
0.0004 |
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 = 52557
|
0.0002 |
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 = 126930
|
0.0002 |
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 = 124884
|
0.0002 |
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 = 22572
|
0.0002 |
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.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'whats_cookin' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '426' ORDER BY `sort_order` ASC LIMIT 1
|
0.0009 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (17653,29959,109829,47174,118518)
|
0.0002 |
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 = 17653
|
0.0002 |
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.0002 |
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.0002 |
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 = 47174
|
0.0002 |
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.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'all_time_favorite' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '433' ORDER BY `sort_order` ASC LIMIT 1
|
0.0046 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (3059,47552,53222,110808,95591)
|
0.0002 |
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.0002 |
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 = 47552
|
0.0002 |
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 = 53222
|
0.0002 |
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 = 110808
|
0.0002 |
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 = 95591
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'horror_stories' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '293' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (123839,277,277,22678,121254)
|
0.0002 |
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.0002 |
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.0002 |
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.0002 |
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 = 22678
|
0.0002 |
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 = 121254
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'general_novels' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '430' 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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (121547,36323,118693,60237,39336)
|
0.0002 |
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 = 121547
|
0.0003 |
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 = 36323
|
0.0002 |
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 = 118693
|
0.0002 |
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 = 60237
|
0.0002 |
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 = 39336
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'romance_SG' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '300' ORDER BY `sort_order` ASC LIMIT 1
|
0.0006 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (27561,29934,46555,103174,65916)
|
0.0002 |
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 = 27561
|
0.0003 |
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 = 29934
|
0.0002 |
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 = 46555
|
0.0002 |
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 = 103174
|
0.0002 |
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 = 65916
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'teen_novel' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '428' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (48822,46358,35600,3025,35601)
|
0.0002 |
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.0002 |
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 = 46358
|
0.0002 |
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 = 35600
|
0.0002 |
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 = 3025
|
0.0002 |
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 = 35601
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'truestories_SG' AND `site_id` = '4'
|
0.0003 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '299' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0003 |
SELECT * FROM `authors` WHERE `author_id` IN (111953,31925,10584,108830,118523)
|
0.0002 |
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 = 111953
|
0.0002 |
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 = 31925
|
0.0002 |
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 = 10584
|
0.0002 |
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 = 108830
|
0.0002 |
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 = 118523
|
0.0003 |
SELECT `site_id`, `sites_tabs_id`, `name` FROM `sites_tabs` WHERE `site_id` = '4' AND `tab_status` = 1 ORDER BY `sort_order`
|
0.0004 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf` FROM `tabs_books` JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id` WHERE `tabs_books`.`sites_tabs_id` = '19' AND `books`.`offshelf` = 'N' ORDER BY `tabs_books`.`sort_order` LIMIT 7
|
0.0004 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf` FROM `tabs_books` JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id` WHERE `tabs_books`.`sites_tabs_id` = '21' AND `books`.`offshelf` = 'N' ORDER BY `tabs_books`.`sort_order` LIMIT 7
|
0.0004 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf` FROM `tabs_books` JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id` WHERE `tabs_books`.`sites_tabs_id` = '18' AND `books`.`offshelf` = 'N' ORDER BY `tabs_books`.`sort_order` LIMIT 7
|
0.0004 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf` FROM `tabs_books` JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id` WHERE `tabs_books`.`sites_tabs_id` = '20' AND `books`.`offshelf` = 'N' ORDER BY `tabs_books`.`sort_order` LIMIT 7
|
0.0017 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0010 |
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
|