| 0.0136 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0021 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.e-sentral.com'
|
| 0.0017 |
SELECT *
FROM `sites`
WHERE `site_id` = '1'
|
| 0.0035 |
SELECT *
FROM `site_values`
WHERE `site_id` = '1'
|
| 0.0022 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentral'
|
| 0.0024 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '1'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0023 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0025 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_release'
AND `site_id` = '1'
|
| 0.0020 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '17'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0097 |
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`.`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('17')
|
| 0.0025 |
SELECT *
FROM `authors`
WHERE `author_id` IN (132390,132006,132258,52758,14268)
|
| 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 = 132390
|
| 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 = 132006
|
| 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 = 132258
|
| 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 = 52758
|
| 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 = 14268
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi'
AND `site_id` = '1'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '159'
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`.`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('159')
|
| 0.0023 |
SELECT *
FROM `authors`
WHERE `author_id` IN (41604,110097,109116,110097,3059)
|
| 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.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.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 = 109116
|
| 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.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 = 3059
|
| 0.0021 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'international_bestsellers'
AND `site_id` = '1'
|
| 0.0020 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '307'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0068 |
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`.`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('307')
|
| 0.0021 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51597,47980,49602,47950,48041)
|
| 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 = 51597
|
| 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 = 47980
|
| 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 = 49602
|
| 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 = 47950
|
| 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 = 48041
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'rujukan_guru'
AND `site_id` = '1'
|
| 0.0020 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '419'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0027 |
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`.`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('419')
|
| 0.0016 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52844,47916,52853,52850,52851)
|
| 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 = 52844
|
| 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 = 47916
|
| 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 = 52853
|
| 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 = 52850
|
| 0.0048 |
SELECT authors_users.user_id, users.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.0024 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'stay_strong_malaysians'
AND `site_id` = '1'
|
| 0.0018 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '478'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0036 |
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`.`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('478')
|
| 0.0017 |
SELECT *
FROM `authors`
WHERE `author_id` IN (53069,112219,15621,129451,107782)
|
| 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 = 53069
|
| 0.0035 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 112219
|
| 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 = 15621
|
| 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 = 129451
|
| 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 = 107782
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'gempakstarz'
AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '472'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0022 |
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`.`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('472')
|
| 0.0015 |
SELECT *
FROM `authors`
WHERE `author_id` IN (121725,122556,125867,122556,127230)
|
| 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 = 121725
|
| 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 = 122556
|
| 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 = 125867
|
| 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 = 122556
|
| 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 = 127230
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'ebelia_promo'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '540'
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`.`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('540')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (15702,186,128098,156,116897)
|
| 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 = 15702
|
| 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 = 186
|
| 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 = 128098
|
| 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 = 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 = 116897
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pts_cuti_sekolah'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '541'
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`.`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('541')
|
| 0.0018 |
SELECT *
FROM `authors`
WHERE `author_id` IN (16925,47263,186,60258,16925)
|
| 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 = 16925
|
| 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 = 47263
|
| 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 = 186
|
| 0.0053 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 60258
|
| 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 = 16925
|
| 0.0019 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'kuasai_skill_pengucapan_awam'
AND `site_id` = '1'
|
| 0.0024 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '539'
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`.`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('539')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (12643,108028,130784,114455,125179)
|
| 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 = 12643
|
| 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 = 108028
|
| 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 = 130784
|
| 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 = 114455
|
| 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 = 125179
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'gaya_hidupmu'
AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '533'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0022 |
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`.`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('533')
|
| 0.0024 |
SELECT *
FROM `authors`
WHERE `author_id` IN (131449,129459,118583,12367,212)
|
| 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 = 131449
|
| 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 = 129459
|
| 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 = 118583
|
| 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 = 12367
|
| 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 = 212
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbd_romantik'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '411'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0033 |
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`.`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('411')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47218,121191,111979,118546,109116)
|
| 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.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 = 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 = 111979
|
| 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 = 118546
|
| 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 = 109116
|
| 0.0016 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbd_wedding'
AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '532'
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`.`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('532')
|
| 0.0013 |
SELECT *
FROM `authors`
WHERE `author_id` IN (156,13592,47200,108025,12432)
|
| 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.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 = 13592
|
| 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 = 47200
|
| 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 = 108025
|
| 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 = 12432
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'Komik_m'
AND `site_id` = '1'
|
| 0.0016 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '530'
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`.`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('530')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (126305,126313,126319,186,186)
|
| 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 = 126305
|
| 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 = 126313
|
| 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 = 126319
|
| 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.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 = 186
|
| 0.0020 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'children_and_teens'
AND `site_id` = '1'
|
| 0.0018 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '474'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0027 |
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`.`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('474')
|
| 0.0018 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112801,47851,123135,3073,127250)
|
| 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 = 112801
|
| 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 = 47851
|
| 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 = 123135
|
| 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 = 3073
|
| 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 = 127250
|
| 0.0020 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbd_history'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '531'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0041 |
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`.`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('531')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (125181,125715,3062,118445,118445)
|
| 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 = 125181
|
| 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 = 125715
|
| 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 = 3062
|
| 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 = 118445
|
| 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 = 118445
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'indie_alternatif'
AND `site_id` = '1'
|
| 0.0023 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '123'
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`.`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('123')
|
| 0.0030 |
SELECT *
FROM `authors`
WHERE `author_id` IN (731,110148,15704,3059,28626)
|
| 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 = 731
|
| 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 = 110148
|
| 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.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 = 3059
|
| 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 = 28626
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'Islam'
AND `site_id` = '1'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '355'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0037 |
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`.`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('355')
|
| 0.0026 |
SELECT *
FROM `authors`
WHERE `author_id` IN (107945,112230,112358,110809,128101)
|
| 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 = 107945
|
| 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 = 112230
|
| 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 = 112358
|
| 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 = 110809
|
| 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 = 128101
|
| 0.0019 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_ebooks'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '312'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0030 |
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`.`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('312')
|
| 0.0020 |
SELECT *
FROM `authors`
WHERE `author_id` IN (30625,41681,31860,2580,30625)
|
| 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 = 30625
|
| 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 = 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.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 = 30625
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'sekolah_rendah'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '477'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0051 |
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`.`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('477')
|
| 0.0023 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110159,123831,110159,110161,12662)
|
| 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 = 110159
|
| 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 = 123831
|
| 0.0050 |
SELECT authors_users.user_id, users.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.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 = 110161
|
| 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 = 12662
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'sekolah_menengah'
AND `site_id` = '1'
|
| 0.0018 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '480'
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`.`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('480')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (12662,110161,123848,110161,123844)
|
| 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 = 12662
|
| 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 = 110161
|
| 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 = 123848
|
| 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 = 110161
|
| 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 = 123844
|
| 0.0017 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pengajian_tinggi'
AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '476'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0055 |
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`.`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('476')
|
| 0.0022 |
SELECT *
FROM `authors`
WHERE `author_id` IN (125185,52460,123819,128098,122644)
|
| 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 = 125185
|
| 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 = 52460
|
| 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 = 123819
|
| 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 = 128098
|
| 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 = 122644
|
| 0.0021 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'nak_buka_apa'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '70'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0037 |
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`.`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('70')
|
| 0.0017 |
SELECT *
FROM `authors`
WHERE `author_id` IN (126041,112359,3054,3054,3054)
|
| 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 = 126041
|
| 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 = 112359
|
| 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 = 3054
|
| 0.0035 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 3054
|
| 0.0020 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 3054
|
| 0.0026 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'jom_kurus'
AND `site_id` = '1'
|
| 0.0023 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '447'
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`.`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('447')
|
| 0.0017 |
SELECT *
FROM `authors`
WHERE `author_id` IN (115495,21997,101041,47296,113658)
|
| 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 = 115495
|
| 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 = 21997
|
| 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 = 101041
|
| 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 = 47296
|
| 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 = 113658
|
| 0.0020 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = '2021_audiobook'
AND `site_id` = '1'
|
| 0.0018 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '495'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0030 |
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`.`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('495')
|
| 0.0017 |
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.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 = 127491
|
| 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 = 127492
|
| 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 = 127497
|
| 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 = 127490
|
| 0.0028 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'bacaan_am'
AND `site_id` = '1'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '475'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0131 |
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`.`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('475')
|
| 0.0028 |
SELECT *
FROM `authors`
WHERE `author_id` IN (186,156,3066,13615,123505)
|
| 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 = 186
|
| 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 = 156
|
| 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 = 3066
|
| 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 = 13615
|
| 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 = 123505
|
| 0.0028 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'business_finance'
AND `site_id` = '1'
|
| 0.0021 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '362'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0036 |
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`.`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('362')
|
| 0.0020 |
SELECT *
FROM `authors`
WHERE `author_id` IN (128098,102,119111,47260,156)
|
| 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 = 128098
|
| 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 = 102
|
| 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 = 119111
|
| 0.0044 |
SELECT authors_users.user_id, users.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.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 = 156
|
| 0.0020 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'languages'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '372'
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`.`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('372')
|
| 0.0020 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108063,129413,108065,33389,108068)
|
| 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 = 108063
|
| 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 = 129413
|
| 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 = 108065
|
| 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 = 33389
|
| 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 = 108068
|
| 0.0021 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'tips_banyak_lagi'
AND `site_id` = '1'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '483'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0026 |
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`.`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('483')
|
| 0.0020 |
SELECT *
FROM `authors`
WHERE `author_id` IN (26028,116897,120895,57737,117993)
|
| 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 = 26028
|
| 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 = 116897
|
| 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 = 120895
|
| 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 = 57737
|
| 0.0043 |
SELECT authors_users.user_id, users.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.0023 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'mandarin_bestseller_MY'
AND `site_id` = '1'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '297'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0030 |
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`.`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('297')
|
| 0.0069 |
SELECT *
FROM `authors`
WHERE `author_id` IN (16737,16765,16734,47313,16763)
|
| 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 = 16737
|
| 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 = 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.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 = 47313
|
| 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 = 16763
|
| 0.0037 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0029 |
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.0022 |
SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
