0.0070 |
SHOW TABLES FROM `esentral_ebook`
|
0.0020 |
SELECT * FROM `site_domains` WHERE `domain` = 'esentral.id'
|
0.0013 |
SELECT * FROM `sites` WHERE `site_id` = '3'
|
0.0016 |
SELECT * FROM `site_values` WHERE `site_id` = '3'
|
0.0022 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'esentralid'
|
0.0024 |
SELECT `slug`, `keyword` FROM `sites_shelf_keywords` LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
0.0041 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '3' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0022 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0031 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'indinesia' AND `site_id` = '3'
|
0.0023 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '287' ORDER BY `sort_order` ASC LIMIT 1
|
0.0046 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('287')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (134418,15704,28626,113,28570)
|
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 = 134418
|
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 = 15704
|
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 = 28626
|
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 = 113
|
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 = 28570
|
0.0050 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'drama_adaptasi_seberang' AND `site_id` = '3'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '668' ORDER BY `sort_order` ASC LIMIT 1
|
0.0076 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('668')
|
0.0022 |
SELECT * FROM `authors` WHERE `author_id` IN (110097,109116,110097,119110,111007)
|
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 = 110097
|
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 = 109116
|
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 = 110097
|
0.0030 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 119110
|
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 = 111007
|
0.0126 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'specialforyou' AND `site_id` = '3'
|
0.0022 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '564' ORDER BY `sort_order` ASC LIMIT 1
|
0.0054 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('564')
|
0.0019 |
SELECT * FROM `authors` WHERE `author_id` IN (108931,108931,133514,109856,133513)
|
0.0030 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 108931
|
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 = 108931
|
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 = 133514
|
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 = 109856
|
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 = 133513
|
0.0032 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_books' AND `site_id` = '3'
|
0.0018 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '566' ORDER BY `sort_order` ASC LIMIT 1
|
0.0021 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('566')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (41681,31860,2580,6890,2580)
|
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 = 41681
|
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 = 31860
|
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 = 2580
|
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 = 6890
|
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 = 2580
|
0.0032 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'kids' AND `site_id` = '3'
|
0.0023 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '567' ORDER BY `sort_order` ASC LIMIT 1
|
0.0022 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('567')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (108026,17742,52550,118569,121358)
|
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 = 108026
|
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 = 17742
|
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 = 52550
|
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 = 118569
|
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 = 121358
|
0.0033 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'novel_melayu' AND `site_id` = '3'
|
0.0018 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '341' ORDER BY `sort_order` ASC LIMIT 1
|
0.0047 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('341')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (36763,41604,110097,121191,36635)
|
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 = 36763
|
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 = 41604
|
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 = 110097
|
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 = 121191
|
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 = 36635
|
0.0042 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'best_seller' AND `site_id` = '3'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '408' ORDER BY `sort_order` ASC LIMIT 1
|
0.0037 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('408')
|
0.0019 |
SELECT * FROM `authors` WHERE `author_id` IN (51747,53404,53257,53143,53206)
|
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 = 51747
|
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 = 53404
|
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 = 53257
|
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 = 53143
|
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 = 53206
|
0.0034 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'kesehatan' AND `site_id` = '3'
|
0.0034 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '527' ORDER BY `sort_order` ASC LIMIT 1
|
0.0047 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('527')
|
0.0019 |
SELECT * FROM `authors` WHERE `author_id` IN (32328,56263,56264,34457,45071)
|
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 = 32328
|
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 = 56263
|
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 = 56264
|
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 = 34457
|
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 = 45071
|
0.0038 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'religi' AND `site_id` = '3'
|
0.0020 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '458' ORDER BY `sort_order` ASC LIMIT 1
|
0.0028 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('458')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (12436,12436,53072,123507,11781)
|
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 = 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.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 = 53072
|
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 = 123507
|
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 = 11781
|
0.0034 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'english_novels' AND `site_id` = '3'
|
0.0021 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '308' ORDER BY `sort_order` ASC LIMIT 1
|
0.0046 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('308')
|
0.0021 |
SELECT * FROM `authors` WHERE `author_id` IN (7358,46358,102422,51258,52257)
|
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 = 7358
|
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 = 46358
|
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 = 102422
|
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 = 51258
|
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 = 52257
|
0.0083 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'keuangan' AND `site_id` = '3'
|
0.0026 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '470' ORDER BY `sort_order` ASC LIMIT 1
|
0.0046 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('470')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (9442,124798,28158,113870,96353)
|
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 = 9442
|
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 = 124798
|
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 = 28158
|
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 = 113870
|
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 = 96353
|
0.0037 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'komik_terlaris' AND `site_id` = '3'
|
0.0022 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '464' ORDER BY `sort_order` ASC LIMIT 1
|
0.0070 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('464')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (121358,132258,121269,127230,127229)
|
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 = 121358
|
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 = 132258
|
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 = 121269
|
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 = 127230
|
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 = 127229
|
0.0048 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'based_on_true_stories' AND `site_id` = '3'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '460' ORDER BY `sort_order` ASC LIMIT 1
|
0.0024 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('460')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (121238,123381,16504,60035,68)
|
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 = 121238
|
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 = 123381
|
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 = 16504
|
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 = 60035
|
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 = 68
|
0.0035 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'chick_lit' AND `site_id` = '3'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '424' ORDER BY `sort_order` ASC LIMIT 1
|
0.0037 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('424')
|
0.0019 |
SELECT * FROM `authors` WHERE `author_id` IN (112413,14683,109917,94284,93901)
|
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 = 112413
|
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 = 14683
|
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 = 109917
|
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 = 94284
|
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 = 93901
|
0.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'angker' AND `site_id` = '3'
|
0.0022 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '342' ORDER BY `sort_order` ASC LIMIT 1
|
0.0037 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('342')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (36640,109382,47558,41598,36637)
|
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 = 36640
|
0.0015 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 109382
|
0.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 = 47558
|
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 = 41598
|
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 = 36637
|
0.0028 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'motivasi' AND `site_id` = '3'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '463' ORDER BY `sort_order` ASC LIMIT 1
|
0.0035 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('463')
|
0.0025 |
SELECT * FROM `authors` WHERE `author_id` IN (132260,131327,112214,14323,131409)
|
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 = 132260
|
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 = 131327
|
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 = 112214
|
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 = 14323
|
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 = 131409
|
0.0029 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'ayo_wisata' AND `site_id` = '3'
|
0.0018 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '462' ORDER BY `sort_order` ASC LIMIT 1
|
0.0031 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('462')
|
0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (95849,109307,98285,42630,120892)
|
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 = 95849
|
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 = 109307
|
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 = 98285
|
0.0030 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 42630
|
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 = 120892
|
0.0036 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'ayo_masak' AND `site_id` = '3'
|
0.0019 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '320' ORDER BY `sort_order` ASC LIMIT 1
|
0.0025 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('320')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (56698,82756,36644,3054,52749)
|
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 = 56698
|
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 = 82756
|
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 = 36644
|
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 = 3054
|
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 = 52749
|
0.0025 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'mandarin' AND `site_id` = '3'
|
0.0028 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '289' ORDER BY `sort_order` ASC LIMIT 1
|
0.0045 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`idr_price` as `retail_price`, `books`.`idr_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('289')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (36614,36609,36602,37147,118599)
|
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 = 36614
|
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 = 36609
|
0.0110 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 36602
|
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 = 37147
|
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 = 118599
|
0.0037 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0023 |
SELECT * FROM `sites_ads_banner` WHERE `sites_ads_banner`.`site_id` = '3' AND `sites_ads_banner`.`group_id` = 6 AND `sites_ads_banner`.`status` = 'show' ORDER BY `sort_order` ASC
|