0.0015 |
SHOW TABLES FROM `esentral_ebook`
|
0.0005 |
SELECT * FROM `site_domains` WHERE `domain` = 'www.bookcapital.my'
|
0.0004 |
SELECT * FROM `sites` WHERE `site_id` = '2'
|
0.0004 |
SELECT * FROM `site_values` WHERE `site_id` = '2'
|
0.0039 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'bookcapital'
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '2' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0007 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_release' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '179' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (126389,126390,126308,126089,126086)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'koleksi-profesor-diraja' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '494' ORDER BY `sort_order` ASC LIMIT 1
|
0.0005 |
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`.`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('494')
|
0.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (2638,47594,12017,107833)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'kembara-syria' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '484' ORDER BY `sort_order` ASC LIMIT 1
|
0.0005 |
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`.`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('484')
|
0.0006 |
SELECT * FROM `authors` WHERE `author_id` IN (123966,126024)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'born_digital' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '397' ORDER BY `sort_order` ASC LIMIT 1
|
0.0005 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (111924,109874,111500,94685,95576)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'komik' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '467' ORDER BY `sort_order` ASC LIMIT 1
|
0.0005 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (121725,121725,71,121725,71)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'iiit_ebooks' AND `site_id` = '2'
|
0.0004 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '351' ORDER BY `sort_order` ASC LIMIT 1
|
0.0006 |
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`.`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.0004 |
SELECT * FROM `authors` WHERE `author_id` IN (109834,94818,94825,94821,94819)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'malaysian_government_initiatives' AND `site_id` = '2'
|
0.0004 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '376' ORDER BY `sort_order` ASC LIMIT 1
|
0.0006 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (109108,94763,37570,41681,34487)
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'santapan_minda' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '240' ORDER BY `sort_order` ASC LIMIT 1
|
0.0018 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (37352,1,41687,47584,1)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'buku_interaktif' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '304' ORDER BY `sort_order` ASC LIMIT 1
|
0.0006 |
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`.`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.0044 |
SELECT * FROM `authors` WHERE `author_id` IN (31860,41681,2580,2580,6890)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'malaysia_uni_press' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '257' ORDER BY `sort_order` ASC LIMIT 1
|
0.0018 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (47661,37352,47567,37353,47631)
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'dewan_bahasa_dan_pustaka' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '325' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0005 |
SELECT * FROM `authors` WHERE `author_id` IN (9676,52994,9355,53003,52995)
|
0.0006 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jabatan_penerangan_malaysia' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '333' ORDER BY `sort_order` ASC LIMIT 1
|
0.0008 |
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`.`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.0043 |
SELECT * FROM `authors` WHERE `author_id` IN (82281,82281,82281,82281,82281)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'raikan_cinta' AND `site_id` = '2'
|
0.0005 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '266' ORDER BY `sort_order` ASC LIMIT 1
|
0.0007 |
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`.`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.0004 |
SELECT * FROM `authors` WHERE `author_id` IN (164,1,30139,29647,102)
|
0.0007 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0006 |
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
|