0.0061 |
SHOW TABLES FROM `esentral_ebook`
|
0.0028 |
SELECT * FROM `site_domains` WHERE `domain` = 'www.e-sentral.com'
|
0.0019 |
SELECT * FROM `sites` WHERE `site_id` = '1'
|
0.0042 |
SELECT * FROM `site_values` WHERE `site_id` = '1'
|
0.0022 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'esentral'
|
0.0031 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '1' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0016 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'ramadan_tiba' AND `site_id` = '1'
|
0.0018 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '355' ORDER BY `sort_order` ASC LIMIT 1
|
0.0034 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('355')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (13573,129753,12436,12436,123503)
|
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 = 13573
|
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 = 129753
|
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 = 12436
|
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 = 12436
|
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 = 123503
|
0.0020 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_release' AND `site_id` = '1'
|
0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '17' ORDER BY `sort_order` ASC LIMIT 1
|
0.0081 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('17')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (40474,127665,109116,123853,16925)
|
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 = 40474
|
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 = 127665
|
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 = 109116
|
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 = 123853
|
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 = 16925
|
0.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'drama_adaptasi' AND `site_id` = '1'
|
0.0018 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '159' ORDER BY `sort_order` ASC LIMIT 1
|
0.0025 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('159')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (110097,127916,47218,82567,121191)
|
0.0014 |
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.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 = 127916
|
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 = 47218
|
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 = 82567
|
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 = 121191
|
0.0020 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'international_bestsellers' AND `site_id` = '1'
|
0.0024 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '307' ORDER BY `sort_order` ASC LIMIT 1
|
0.0103 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('307')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (39898,49475,55913,50000,36055)
|
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 = 39898
|
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 = 49475
|
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 = 55913
|
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 = 50000
|
0.0014 |
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 = 36055
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jobhunting' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '525' ORDER BY `sort_order` ASC LIMIT 1
|
0.0023 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('525')
|
0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (60030,106379,107773,2564,28036)
|
0.0014 |
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 = 60030
|
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 = 106379
|
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 = 107773
|
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 = 2564
|
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 = 28036
|
0.0020 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_ebooks' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '312' ORDER BY `sort_order` ASC LIMIT 1
|
0.0028 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('312')
|
0.0027 |
SELECT * FROM `authors` WHERE `author_id` IN (41681,31860,2580,2580,6890)
|
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 = 41681
|
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 = 31860
|
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 = 2580
|
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 = 2580
|
0.0027 |
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.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'rujukan_guru' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '419' ORDER BY `sort_order` ASC LIMIT 1
|
0.0020 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('419')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (52844,47916,52853,52850,52851)
|
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 = 52844
|
0.0014 |
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 = 47916
|
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 = 52853
|
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 = 52850
|
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 = 52851
|
0.0017 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'for_kids' AND `site_id` = '1'
|
0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '474' ORDER BY `sort_order` ASC LIMIT 1
|
0.0073 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('474')
|
0.0022 |
SELECT * FROM `authors` WHERE `author_id` IN (127250,71,109547,251,127250)
|
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 = 127250
|
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 = 71
|
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 = 109547
|
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 = 251
|
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 = 127250
|
0.0017 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'sekolah_rendah' AND `site_id` = '1'
|
0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '477' ORDER BY `sort_order` ASC LIMIT 1
|
0.0054 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('477')
|
0.0024 |
SELECT * FROM `authors` WHERE `author_id` IN (110159,123831,130493,121976,130648)
|
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 = 110159
|
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 = 123831
|
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 = 130493
|
0.0067 |
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 = 121976
|
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 = 130648
|
0.0022 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'sekolah_menengah' AND `site_id` = '1'
|
0.0042 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '480' ORDER BY `sort_order` ASC LIMIT 1
|
0.0031 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('480')
|
0.0016 |
SELECT * FROM `authors` WHERE `author_id` IN (30625,127271,110161,123848,12662)
|
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 = 30625
|
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 = 127271
|
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 = 110161
|
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 = 123848
|
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 = 12662
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'pengajian_tinggi' AND `site_id` = '1'
|
0.0017 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '476' ORDER BY `sort_order` ASC LIMIT 1
|
0.0079 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('476')
|
0.0777 |
SELECT * FROM `authors` WHERE `author_id` IN (125185,52460,123819,128098,45756)
|
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 = 125185
|
0.0080 |
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 = 52460
|
0.0079 |
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 = 123819
|
0.0081 |
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 = 128098
|
0.0051 |
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 = 45756
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'islamic_finance' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '488' ORDER BY `sort_order` ASC LIMIT 1
|
0.0018 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('488')
|
0.0012 |
SELECT * FROM `authors` WHERE `author_id` IN (82129,94818,125932,29957,125931)
|
0.0014 |
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 = 82129
|
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 = 94818
|
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 = 125932
|
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 = 29957
|
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 = 125931
|
0.0016 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'keep_motivated' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '478' ORDER BY `sort_order` ASC LIMIT 1
|
0.0020 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('478')
|
0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (11395,53069,112231,112194,12057)
|
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 = 11395
|
0.0014 |
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 = 53069
|
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 = 112231
|
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 = 112194
|
0.0014 |
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 = 12057
|
0.0016 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'koleksi_sasterawan_negara' AND `site_id` = '1'
|
0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '517' ORDER BY `sort_order` ASC LIMIT 1
|
0.0016 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('517')
|
0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (129376,111616,112107,129375,111652)
|
0.0028 |
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 = 129376
|
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 = 111616
|
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 = 112107
|
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 = 129375
|
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 = 111652
|
0.0018 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'oh_may_man' AND `site_id` = '1'
|
0.0017 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '501' ORDER BY `sort_order` ASC LIMIT 1
|
0.0021 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('501')
|
0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (107858,35707,52911,126024,110152)
|
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 = 107858
|
0.0014 |
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 = 35707
|
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 = 52911
|
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 = 126024
|
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 = 110152
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'cook_w_love' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '70' ORDER BY `sort_order` ASC LIMIT 1
|
0.0020 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('70')
|
0.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (109829,109837,32772,109829,32772)
|
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 = 109829
|
0.0014 |
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 = 109837
|
0.0068 |
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 = 32772
|
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 = 109829
|
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 = 32772
|
0.0017 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'my_girl' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '502' ORDER BY `sort_order` ASC LIMIT 1
|
0.0025 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('502')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (1,126261,13592,52758,40724)
|
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 = 1
|
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 = 126261
|
0.0014 |
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 = 13592
|
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 = 52758
|
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 = 40724
|
0.0048 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jom_kurus' AND `site_id` = '1'
|
0.0037 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '447' ORDER BY `sort_order` ASC LIMIT 1
|
0.0029 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('447')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (115495,21997,101041,47296,113658)
|
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 = 115495
|
0.0014 |
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 = 21997
|
0.0014 |
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 = 101041
|
0.0014 |
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 = 47296
|
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 = 113658
|
0.0021 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'binge_series' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '440' ORDER BY `sort_order` ASC LIMIT 1
|
0.0019 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('440')
|
0.0016 |
SELECT * FROM `authors` WHERE `author_id` IN (93965,51142,48002,103051,126737)
|
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 = 93965
|
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 = 51142
|
0.0014 |
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 = 48002
|
0.0014 |
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 = 103051
|
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 = 126737
|
0.0021 |
SELECT * FROM `sites_shelf` WHERE `slug` = '2021_audiobook' AND `site_id` = '1'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '495' ORDER BY `sort_order` ASC LIMIT 1
|
0.0020 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('495')
|
0.0016 |
SELECT * FROM `authors` WHERE `author_id` IN (127489,127491,127492,127497,127490)
|
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 = 127489
|
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 = 127491
|
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 = 127492
|
0.0014 |
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 = 127497
|
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 = 127490
|
0.0020 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'stayhomemillsboon' AND `site_id` = '1'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '485' ORDER BY `sort_order` ASC LIMIT 1
|
0.0023 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('485')
|
0.0016 |
SELECT * FROM `authors` WHERE `author_id` IN (103559,103221,94405,105104,104341)
|
0.0014 |
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 = 103559
|
0.0014 |
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 = 103221
|
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 = 94405
|
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 = 105104
|
0.0014 |
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 = 104341
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jom_deko' AND `site_id` = '1'
|
0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '357' ORDER BY `sort_order` ASC LIMIT 1
|
0.0020 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('357')
|
0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (117556,37009,36489,35007,25491)
|
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 = 117556
|
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 = 37009
|
0.0014 |
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 = 36489
|
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 = 35007
|
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 = 25491
|
0.0020 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'bacaan_am' AND `site_id` = '1'
|
0.0017 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '475' ORDER BY `sort_order` ASC LIMIT 1
|
0.0071 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('475')
|
0.0023 |
SELECT * FROM `authors` WHERE `author_id` IN (186,156,3068,3055,12189)
|
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 = 186
|
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 = 156
|
0.0014 |
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 = 3068
|
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 = 3055
|
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 = 12189
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jom_tambah_income' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '362' ORDER BY `sort_order` ASC LIMIT 1
|
0.0021 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('362')
|
0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (156,31904,47260,156,82197)
|
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 = 156
|
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 = 31904
|
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 = 47260
|
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 = 156
|
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 = 82197
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'belajar_bahasa' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '372' ORDER BY `sort_order` ASC LIMIT 1
|
0.0024 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('372')
|
0.0016 |
SELECT * FROM `authors` WHERE `author_id` IN (110808,37355,6493,114574,9676)
|
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 = 110808
|
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 = 37355
|
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 = 6493
|
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 = 114574
|
0.0014 |
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 = 9676
|
0.0017 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'tips_banyak_lagi' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '483' ORDER BY `sort_order` ASC LIMIT 1
|
0.0023 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('483')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (26028,116897,120895,57737,117993)
|
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 = 26028
|
0.0014 |
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 = 116897
|
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 = 120895
|
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 = 57737
|
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 = 117993
|
0.0021 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'mandarin_bestseller_MY' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '297' ORDER BY `sort_order` ASC LIMIT 1
|
0.0032 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('297')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (16737,16765,16734,47313,16763)
|
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 = 16737
|
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 = 16765
|
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 = 16734
|
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 = 47313
|
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 = 16763
|
0.0019 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'indie_alternatif' AND `site_id` = '1'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '123' ORDER BY `sort_order` ASC LIMIT 1
|
0.0121 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_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('123')
|
0.0022 |
SELECT * FROM `authors` WHERE `author_id` IN (31867,16729,37472,28626,52693)
|
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 = 31867
|
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 = 16729
|
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 = 37472
|
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 = 28626
|
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 = 52693
|
0.0038 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0022 |
SELECT * FROM `sites_ads_banner` WHERE `sites_ads_banner`.`site_id` = '1' AND `sites_ads_banner`.`group_id` = 6 AND `sites_ads_banner`.`status` = 'show' ORDER BY `sort_order` ASC
|
0.0016 |
SELECT `slug`, `keyword` FROM `sites_shelf_keywords` LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|