0.0066 |
SHOW TABLES FROM `esentral_ebook`
|
0.0011 |
SELECT * FROM `site_domains` WHERE `domain` = 'ebook.bookcapital.my'
|
0.0009 |
SELECT * FROM `sites` WHERE `site_id` = '2'
|
0.0008 |
SELECT * FROM `site_values` WHERE `site_id` = '2'
|
0.0052 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'bookcapital'
|
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.0177 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '2' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0045 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0036 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'malaysia_membaca' AND `site_id` = '2'
|
0.0116 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '500' ORDER BY `sort_order` ASC LIMIT 1
|
0.0083 |
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('500')
|
0.0028 |
SELECT * FROM `authors` WHERE `author_id` IN (112107,111616,129375,129376,52412)
|
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 = 112107
|
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 = 111616
|
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 = 129375
|
0.0029 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 129376
|
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 = 52412
|
0.0097 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'inthought_ebooks' AND `site_id` = '2'
|
0.0021 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '351' ORDER BY `sort_order` ASC LIMIT 1
|
0.0199 |
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('351')
|
0.0013 |
SELECT * FROM `authors` WHERE `author_id` IN (148894,130828,145566,146708,142997)
|
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 = 148894
|
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 = 130828
|
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 = 145566
|
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 = 146708
|
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 = 142997
|
0.0052 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'kasih-wanita' AND `site_id` = '2'
|
0.0166 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '694' ORDER BY `sort_order` ASC LIMIT 1
|
0.0196 |
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('694')
|
0.0032 |
SELECT * FROM `authors` WHERE `author_id` IN (129762,132260,130825,10908,11531)
|
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 = 129762
|
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 = 132260
|
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 = 130825
|
0.0071 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 10908
|
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 = 11531
|
0.0054 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'tahap_1' AND `site_id` = '2'
|
0.0042 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '617' ORDER BY `sort_order` ASC LIMIT 1
|
0.0039 |
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('617')
|
0.0056 |
SELECT * FROM `authors` WHERE `author_id` IN (52725,52725,127118,127118,52725)
|
0.0201 |
SELECT authors_users.user_id, users.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.0086 |
SELECT authors_users.user_id, users.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 = 127118
|
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 = 127118
|
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.0031 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'tahap_2' AND `site_id` = '2'
|
0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '618' 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('618')
|
0.0011 |
SELECT * FROM `authors` WHERE `author_id` IN (52725,52725,121461,12662,127701)
|
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.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.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 = 121461
|
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 = 12662
|
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 = 127701
|
0.0038 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'menengah_rendah' AND `site_id` = '2'
|
0.0025 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '619' 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('619')
|
0.0012 |
SELECT * FROM `authors` WHERE `author_id` IN (107835,22605,53016,52725,22605)
|
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 = 107835
|
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 = 22605
|
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 = 53016
|
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.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 = 22605
|
0.0025 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'menengah_atas' AND `site_id` = '2'
|
0.0010 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '620' 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('620')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (128013,52725,52725,128014,128060)
|
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 = 128013
|
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.0037 |
SELECT authors_users.user_id, users.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 = 128014
|
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 = 128060
|
0.0026 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'adaptasi_novel' AND `site_id` = '2'
|
0.0016 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '498' ORDER BY `sort_order` ASC LIMIT 1
|
0.1486 |
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('498')
|
0.0902 |
SELECT * FROM `authors` WHERE `author_id` IN (121191,14268,110097,35707,158)
|
0.0112 |
SELECT authors_users.user_id, users.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.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 = 14268
|
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 = 110097
|
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 = 35707
|
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 = 158
|
0.0030 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'ebuku_percuma' AND `site_id` = '2'
|
0.0018 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '497' 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('497')
|
0.0031 |
SELECT * FROM `authors` WHERE `author_id` IN (33696,16818,94684,16816,126707)
|
0.0029 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 33696
|
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 = 16818
|
0.0029 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 94684
|
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 = 16816
|
0.1096 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 126707
|
0.0072 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_release' AND `site_id` = '2'
|
0.0122 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '179' ORDER BY `sort_order` ASC LIMIT 1
|
0.0287 |
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('179')
|
0.0057 |
SELECT * FROM `authors` WHERE `author_id` IN (126389,126390,126308,126089,126086)
|
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 = 126389
|
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 = 126390
|
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 = 126308
|
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 = 126089
|
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 = 126086
|
0.0026 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'born_digital' AND `site_id` = '2'
|
0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '397' 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('397')
|
0.0024 |
SELECT * FROM `authors` WHERE `author_id` IN (111924,109874,94685,95576)
|
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 = 111924
|
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 = 109874
|
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 = 94685
|
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 = 95576
|
0.0415 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'komik' AND `site_id` = '2'
|
0.0273 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '467' ORDER BY `sort_order` ASC LIMIT 1
|
0.0085 |
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('467')
|
0.0021 |
SELECT * FROM `authors` WHERE `author_id` IN (121725,121725,71,121725,71)
|
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 = 121725
|
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 = 121725
|
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 = 71
|
0.0076 |
SELECT authors_users.user_id, users.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.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 = 71
|
0.0018 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'malaysian_government_initiatives' AND `site_id` = '2'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '376' ORDER BY `sort_order` ASC LIMIT 1
|
0.0043 |
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('376')
|
0.0018 |
SELECT * FROM `authors` WHERE `author_id` IN (94763,37570,41681,34487,34487)
|
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 = 94763
|
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 = 37570
|
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 = 41681
|
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 = 34487
|
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 = 34487
|
0.0025 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'santapan_minda' AND `site_id` = '2'
|
0.0009 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '240' ORDER BY `sort_order` ASC LIMIT 1
|
0.0469 |
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('240')
|
0.0019 |
SELECT * FROM `authors` WHERE `author_id` IN (37352,1,41687,47584,1)
|
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 = 37352
|
0.0133 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 1
|
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 = 41687
|
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 = 47584
|
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 = 1
|
0.0042 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'buku_interaktif' AND `site_id` = '2'
|
0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '304' ORDER BY `sort_order` ASC LIMIT 1
|
0.0109 |
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('304')
|
0.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (31860,41681,2580,2580,6890)
|
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 = 31860
|
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 = 41681
|
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 = 2580
|
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 = 2580
|
0.0034 |
SELECT authors_users.user_id, users.fullname FROM authors_users LEFT JOIN users ON authors_users.user_id = users.id WHERE authors_users.status = 'approved' AND authors_users.author_id = 6890
|
0.0055 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'malaysia_uni_press' AND `site_id` = '2'
|
0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '257' ORDER BY `sort_order` ASC LIMIT 1
|
0.0297 |
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('257')
|
0.0022 |
SELECT * FROM `authors` WHERE `author_id` IN (47661,37352,47567,37353,47631)
|
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 = 47661
|
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 = 37352
|
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 = 47567
|
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 = 37353
|
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 = 47631
|
0.0048 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'dewan_bahasa_dan_pustaka' AND `site_id` = '2'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '325' ORDER BY `sort_order` ASC LIMIT 1
|
0.0071 |
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('325')
|
0.0020 |
SELECT * FROM `authors` WHERE `author_id` IN (52994,9355,53003,52995,52998)
|
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 = 52994
|
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 = 9355
|
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 = 53003
|
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 = 52995
|
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 = 52998
|
0.0040 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jabatan_penerangan_malaysia' AND `site_id` = '2'
|
0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '333' ORDER BY `sort_order` ASC LIMIT 1
|
0.0074 |
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('333')
|
0.0014 |
SELECT * FROM `authors` WHERE `author_id` IN (82281,82281,82281,82281,82281)
|
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 = 82281
|
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 = 82281
|
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 = 82281
|
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 = 82281
|
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 = 82281
|
0.0037 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'raikan_cinta' AND `site_id` = '2'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '266' 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('266')
|
0.0035 |
SELECT * FROM `authors` WHERE `author_id` IN (164,1,30139,29647,102)
|
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 = 164
|
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 = 1
|
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 = 30139
|
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 = 29647
|
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 = 102
|
0.0044 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0021 |
SELECT * FROM `sites_ads_banner` WHERE `sites_ads_banner`.`site_id` = '2' AND `sites_ads_banner`.`group_id` = 6 AND `sites_ads_banner`.`status` = 'show' ORDER BY `sort_order` ASC
|