| 0.0089 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0031 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'ubsmebooks.com'
|
| 0.0080 |
SELECT *
FROM `sites`
WHERE `site_id` = '12'
|
| 0.0027 |
SELECT *
FROM `site_values`
WHERE `site_id` = '12'
|
| 0.0026 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'ubsm'
|
| 0.0015 |
SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
| 0.0071 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '12'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0019 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0027 |
SELECT `books`.`book_id`, `books`.`title`, `books`.`isbn`, `books`.`protection`, `books`.`synopsis`, `books`.`s3_cover`, `books`.`language`, `books`.`author_id`, `books`.`category_id`, `books`.`publisher_id`, `books`.`ebook_price`, `books`.`retail_price`, `retail_price` as `price`, `authors`.`name` as `author`
FROM `books`
JOIN `authors` ON `books`.`author_id` = `authors`.`author_id`
WHERE `books`.`offshelf` = 'N'
AND `books`.`offshelf` = 'N'
LIMIT 5
|
| 0.0035 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_1'
AND `site_id` = '12'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '605'
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('605')
|
| 0.0021 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0084 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 52725
|
| 0.0041 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_2'
AND `site_id` = '12'
|
| 0.0067 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '606'
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('606')
|
| 0.0016 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0124 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 0.0095 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 52725
|
| 0.0053 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_3'
AND `site_id` = '12'
|
| 0.0032 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '607'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0035 |
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('607')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0058 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 0.0030 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_4'
AND `site_id` = '12'
|
| 0.0026 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '608'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0045 |
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('608')
|
| 0.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,121461,12662,127701)
|
| 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 = 52725
|
| 0.0033 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 121461
|
| 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 = 12662
|
| 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 = 127701
|
| 0.0037 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_5'
AND `site_id` = '12'
|
| 0.0023 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '609'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0056 |
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('609')
|
| 0.0027 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 0.0032 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 0.0080 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0053 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_6'
AND `site_id` = '12'
|
| 0.0018 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '610'
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('610')
|
| 0.0025 |
SELECT *
FROM `authors`
WHERE `author_id` IN (128068,128065,128066,128067,52725)
|
| 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 = 128068
|
| 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 = 128065
|
| 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 = 128066
|
| 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 = 128067
|
| 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 = 52725
|
| 0.0041 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_1'
AND `site_id` = '12'
|
| 0.0025 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '611'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0029 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('611')
|
| 0.0106 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52679,107835,52725,53016,52725)
|
| 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 = 52679
|
| 0.0138 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 107835
|
| 0.0031 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 53016
|
| 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 = 52725
|
| 0.0047 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_2'
AND `site_id` = '12'
|
| 0.0032 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '612'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0138 |
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('612')
|
| 0.0024 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0060 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 52725
|
| 0.0040 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 0.0055 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_3'
AND `site_id` = '12'
|
| 0.0016 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '613'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0034 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('613')
|
| 0.0026 |
SELECT *
FROM `authors`
WHERE `author_id` IN (130485,52725,52725,52725,52725)
|
| 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 = 130485
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0036 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_4'
AND `site_id` = '12'
|
| 0.0017 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '614'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0035 |
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('614')
|
| 0.0013 |
SELECT *
FROM `authors`
WHERE `author_id` IN (128060,128015,128014,52725,128062)
|
| 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 = 128060
|
| 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 = 128015
|
| 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 = 128014
|
| 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 = 52725
|
| 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 = 128062
|
| 0.0099 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_5'
AND `site_id` = '12'
|
| 0.0029 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '615'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0045 |
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('615')
|
| 0.0029 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0066 |
SELECT authors_users.user_id, users.fullname
FROM authors_users
LEFT JOIN users ON authors_users.user_id = users.id
WHERE authors_users.status = 'approved'
AND authors_users.author_id = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0053 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pb_56_university-of-malaya-press'
AND `site_id` = '12'
|
| 0.0031 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '716'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0048 |
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('716')
|
| 0.0073 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pb_133_penerbit-universiti-sains-malaysia'
AND `site_id` = '12'
|
| 0.0072 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '717'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0029 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('717')
|
| 0.0045 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pb_5187_penerbit-ukm'
AND `site_id` = '12'
|
| 0.0028 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '718'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0239 |
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('718')
|
| 0.0039 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pb_147_upm-press'
AND `site_id` = '12'
|
| 0.0040 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '719'
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` = `s |
