| 0.0046 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0087 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'ubsmebooks.com'
|
| 0.0033 |
SELECT *
FROM `sites`
WHERE `site_id` = '12'
|
| 0.0071 |
SELECT *
FROM `site_values`
WHERE `site_id` = '12'
|
| 0.0016 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'ubsm'
|
| 0.0014 |
SELECT `slug`, `keyword`
FROM `sites_shelf_keywords`
LEFT JOIN `sites_shelf` ON `sites_shelf`.`sites_shelf_id` = `sites_shelf_keywords`.`sites_shelf_id`
|
| 0.0072 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '12'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0032 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0054 |
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.0021 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_1'
AND `site_id` = '12'
|
| 0.0024 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '605'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0108 |
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.0025 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,127118,127118,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.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.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 = 127118
|
| 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 = 127118
|
| 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 = 52725
|
| 0.0055 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_2'
AND `site_id` = '12'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '606'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0098 |
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.0034 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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.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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0039 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_3'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '607'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0015 |
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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0054 |
SELECT authors_users.user_id, users.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.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 = 52725
|
| 0.0019 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_4'
AND `site_id` = '12'
|
| 0.0011 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '608'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0059 |
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.0016 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,121461,12662,127701)
|
| 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 = 52725
|
| 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.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 = 121461
|
| 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 = 12662
|
| 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 = 127701
|
| 0.0019 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_5'
AND `site_id` = '12'
|
| 0.0019 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '609'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0012 |
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.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tahun_6'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '610'
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('610')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (128068,128065,128066,128067,52725)
|
| 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 = 128068
|
| 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 = 128065
|
| 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 = 128066
|
| 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 = 128067
|
| 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 = 52725
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_1'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '611'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0059 |
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.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52679,107835,52725,53016,52725)
|
| 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 = 52679
|
| 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 = 107835
|
| 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.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 = 53016
|
| 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 = 52725
|
| 0.0041 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_2'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '612'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0038 |
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.0010 |
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.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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0019 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_3'
AND `site_id` = '12'
|
| 0.0012 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '613'
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('613')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (130485,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 = 130485
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0016 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_4'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '614'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0060 |
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.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (128060,128015,128014,52725,128062)
|
| 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 = 128060
|
| 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 = 128015
|
| 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 = 128014
|
| 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 = 52725
|
| 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 = 128062
|
| 0.0014 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'etextbook_tingkatan_5'
AND `site_id` = '12'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '615'
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('615')
|
| 0.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52725,52725,52725,52725,52725)
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 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 = 52725
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'textbook'
AND `site_id` = '12'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '574'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0065 |
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('574')
|
| 0.0015 |
SELECT *
FROM `authors`
WHERE `author_id` IN (133553,133620,133580,133510,109122)
|
| 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 = 133553
|
| 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 = 133620
|
| 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 = 133580
|
| 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 = 133510
|
| 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 = 109122
|
| 0.0031 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'eng_bestseller'
AND `site_id` = '12'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '576'
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('576')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51142,38130,48002,38130,51749)
|
| 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 = 51142
|
| 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 = 38130
|
| 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 = 48002
|
| 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 = 38130
|
| 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 = 51749
|
| 0.0026 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'business_management'
AND `site_id` = '12'
|
| 0.0011 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '577'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0047 |
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('577')
|
| 0.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (126096,11256,129417,131695,131694)
|
| 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 = 126096
|
| 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 = 11256
|
| 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 = 129417
|
| 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 = 131695
|
| 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 = 131694
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'research_tools'
AND `site_id` = '12'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '578'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0064 |
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('578')
|
| 0.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (31891,94774,112917,129795,129984)
|
| 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 = 31891
|
| 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 = 94774
|
| 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 = 112917
|
| 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 = 129795
|
| 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 = 129984
|
| 0.0023 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'coders_choice'
AND `site_id` = '12'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '579'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0121 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('579')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (132581,54638,82487,55552,55405)
|
| 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 = 132581
|
| 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 = 54638
|
| 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 = 82487
|
| 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 = 55552
|
| 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 = 55405
|
| 0.0018 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'account_stats'
AND `site_id` = '12'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '580'
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('580')
|
| 0.0025 |
SELECT *
FROM `authors`
WHERE `author_id` IN (94818,125707,125707,52901,125780)
|
| 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 = 94818
|
| 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 = 125707
|
| 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 = 125707
|
| 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 = 52901
|
| 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 = 125780
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'economics_finance'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '581'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0052 |
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('581')
|
| 0.0017 |
SELECT *
FROM `authors`
WHERE `author_id` IN (82223,126311,10253,9313,42344)
|
| 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 = 82223
|
| 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 = 126311
|
| 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 = 10253
|
| 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 = 9313
|
| 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 = 42344
|
| 0.0025 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'islamic_finance'
AND `site_id` = '12'
|
| 0.0028 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '582'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0101 |
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('582')
|
| 0.0022 |
SELECT *
FROM `authors`
WHERE `author_id` IN (94818,125932,29957,125931,125931)
|
| 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 = 94818
|
| 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 = 125932
|
| 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 = 29957
|
| 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 = 125931
|
| 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 = 125931
|
| 0.0027 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'bahasa_melayu'
AND `site_id` = '12'
|
| 0.0048 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '583'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0080 |
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('583')
|
| 0.0036 |
SELECT *
FROM `authors`
WHERE `author_id` IN (42243,94803,36110,94925,112330)
|
| 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 = 42243
|
| 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 = 94803
|
| 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 = 36110
|
| 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 = 94925
|
| 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 = 112330
|
| 0.0020 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'eng_edu'
AND `site_id` = '12'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '584'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0079 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('584')
|
| 0.0008 |
SELECT *
FROM `authors`
WHERE `author_id` IN (118584,82272,126889,82270,10853)
|
| 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 = 118584
|
| 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 = 82272
|
| 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 = 126889
|
| 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 = 82270
|
| 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 = 10853
|
| 0.0045 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'agricultre_sustainability'
AND `site_id` = '12'
|
| 0.0016 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '585'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0134 |
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('585')
|
| 0.0027 |
SELECT *
FROM `authors`
WHERE `author_id` IN (113007,11634,13053,127538,125717)
|
| 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 = 113007
|
| 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 = 11634
|
| 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 = 13053
|
| 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 = 127538
|
| 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 = 125717
|
| 0.0045 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'koleksi_sasterawan_negara'
AND `site_id` = '12'
|
| 0.0016 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '586'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0060 |
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('586')
|
| 0.0012 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112107,111616,129375,129376,52412)
|
| 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 = 112107
|
| 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 = 111616
|
| 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 = 129375
|
| 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 = 129376
|
| 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 = 52412
|
| 0.0047 |
SELECT `site_id`, `sites_tabs_id`, `name`
FROM `sites_tabs`
WHERE `site_id` = '12'
AND `tab_status` = 1
ORDER BY `sort_order`
|
| 0.0065 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '41'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0060 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '36'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0036 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '37'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0054 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '39'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0047 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0046 |
SELECT *
FROM `sites_ads_banner`
WHERE `sites_ads_banner`.`site_id` = '12'
AND `sites_ads_banner`.`group_id` = 6
AND `sites_ads_banner`.`status` = 'show'
ORDER BY `sort_order` ASC
|
