| 0.0055 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0011 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'esentral.id'
|
| 0.0042 |
SELECT *
FROM `sites`
WHERE `site_id` = '3'
|
| 0.0064 |
SELECT *
FROM `site_values`
WHERE `site_id` = '3'
|
| 0.0033 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentralid'
|
| 0.0013 |
SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
| 0.0060 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '3'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0033 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0124 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'indinesia'
AND `site_id` = '3'
|
| 0.0098 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '287'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.5937 |
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.0031 |
SELECT *
FROM `authors`
WHERE `author_id` IN (134418,15704,28626,113,28570)
|
| 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 = 134418
|
| 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 = 15704
|
| 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 = 28626
|
| 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 = 113
|
| 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 = 28570
|
| 0.0044 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi_seberang'
AND `site_id` = '3'
|
| 0.0011 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '668'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0315 |
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.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110097,109116,110097,119110,111007)
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110097
|
| 0.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 = 109116
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110097
|
| 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 = 119110
|
| 0.0009 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 111007
|
| 0.0024 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'specialforyou'
AND `site_id` = '3'
|
| 0.0013 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '564'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0044 |
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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108931,108931,133514,109856,133513)
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 108931
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 108931
|
| 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 = 133514
|
| 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 = 109856
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 133513
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '3'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '566'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0041 |
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.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (41681,31860,2580,6890,2580)
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 41681
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 31860
|
| 0.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 = 2580
|
| 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 = 6890
|
| 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 = 2580
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'kids'
AND `site_id` = '3'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '567'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0084 |
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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108026,17742,52550,118569,121358)
|
| 0.0047 |
SELECT authors_users.user_id, users.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.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 = 17742
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52550
|
| 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 = 118569
|
| 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 = 121358
|
| 0.0069 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'novel_melayu'
AND `site_id` = '3'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '341'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0101 |
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.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (36763,41604,110097,121191,36635)
|
| 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 = 36763
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 41604
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 110097
|
| 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 = 121191
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 36635
|
| 0.0016 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'best_seller'
AND `site_id` = '3'
|
| 0.0007 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '408'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0087 |
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.0012 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51747,53404,53257,53143,53206)
|
| 0.0009 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 51747
|
| 0.0029 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 53404
|
| 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 = 53257
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 53143
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 53206
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'kesehatan'
AND `site_id` = '3'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '527'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0155 |
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.0012 |
SELECT *
FROM `authors`
WHERE `author_id` IN (32328,56263,56264,34457,45071)
|
| 0.0009 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 32328
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 56263
|
| 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 = 56264
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 34457
|
| 0.0005 |
SELECT authors_users.user_id, users.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.0016 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'religi'
AND `site_id` = '3'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '458'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0088 |
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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (12436,12436,53072,123507,11781)
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 12436
|
| 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 = 12436
|
| 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 = 53072
|
| 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 = 123507
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 11781
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'english_novels'
AND `site_id` = '3'
|
| 0.0007 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '308'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0180 |
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.0028 |
SELECT *
FROM `authors`
WHERE `author_id` IN (7358,46358,102422,51258,52257)
|
| 0.0038 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 7358
|
| 0.0042 |
SELECT authors_users.user_id, users.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.0036 |
SELECT authors_users.user_id, users.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.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 = 51258
|
| 0.0010 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52257
|
| 0.0023 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'keuangan'
AND `site_id` = '3'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '470'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0061 |
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.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (9442,124798,28158,113870,96353)
|
| 0.0010 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 9442
|
| 0.0010 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 124798
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 28158
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 113870
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 96353
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'komik_terlaris'
AND `site_id` = '3'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '464'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0073 |
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.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (121358,132258,121269,127230,127229)
|
| 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 = 121358
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 132258
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 121269
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 127230
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 127229
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'based_on_true_stories'
AND `site_id` = '3'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '460'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0066 |
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.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (121238,123381,16504,60035,68)
|
| 0.0010 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 121238
|
| 0.0010 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 123381
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 16504
|
| 0.0009 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 60035
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 68
|
| 0.0021 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'chick_lit'
AND `site_id` = '3'
|
| 0.0064 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '424'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0133 |
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.0020 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112413,14683,109917,94284,93901)
|
| 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 = 112413
|
| 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 = 14683
|
| 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 = 109917
|
| 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 = 94284
|
| 0.0041 |
SELECT authors_users.user_id, users.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.0060 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'angker'
AND `site_id` = '3'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '342'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0147 |
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.0048 |
SELECT *
FROM `authors`
WHERE `author_id` IN (36640,109382,47558,41598,36637)
|
| 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 = 36640
|
| 0.0010 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109382
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 47558
|
| 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 = 41598
|
| 0.0005 |
SELECT authors_users.user_id, users.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.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'motivasi'
AND `site_id` = '3'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '463'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0065 |
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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (132260,131327,112214,14323,131409)
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 132260
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 131327
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 112214
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 14323
|
| 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 = 131409
|
| 0.0016 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'ayo_wisata'
AND `site_id` = '3'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '462'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0077 |
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.0008 |
SELECT *
FROM `authors`
WHERE `author_id` IN (95849,109307,98285,42630,120892)
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 95849
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 109307
|
| 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 = 98285
|
| 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 = 42630
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 120892
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'ayo_masak'
AND `site_id` = '3'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '320'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0072 |
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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (56698,82756,36644,3054,52749)
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 56698
|
| 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 = 82756
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 36644
|
| 0.0008 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 3054
|
| 0.0007 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52749
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'mandarin'
AND `site_id` = '3'
|
| 0.0023 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '289'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0185 |
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.0015 |
SELECT *
FROM `authors`
WHERE `author_id` IN (36614,36609,36602,37147,118599)
|
| 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 = 36614
|
| 0.0041 |
SELECT authors_users.user_id, users.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.0039 |
SELECT authors_users.user_id, users.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.0039 |
SELECT authors_users.user_id, users.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.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 = 118599
|
| 0.0034 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0057 |
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
|
