| 0.0410 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0015 |
SELECT * FROM `site_domains` WHERE `domain` = 'www.e-sentral.com'
|
| 0.0080 |
SELECT * FROM `sites` WHERE `site_id` = '1'
|
| 0.0052 |
SELECT * FROM `site_values` WHERE `site_id` = '1'
|
| 0.0011 |
SELECT * FROM `header_notifications` WHERE `active` = 1 AND `locale` = 'esentral'
|
| 0.0023 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '1' AND `shelf_status` = 1 ORDER BY `sort_order`
|
| 0.0016 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
| 0.0057 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_release' AND `site_id` = '1'
|
| 0.0031 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '17' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0081 |
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('17')
|
| 0.0072 |
SELECT * FROM `authors` WHERE `author_id` IN (127916,52758,127915,52758,127518)
|
| 0.0043 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'drama_adaptasi' AND `site_id` = '1'
|
| 0.0036 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '159' 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`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('159')
|
| 0.0028 |
SELECT * FROM `authors` WHERE `author_id` IN (109116,112090,14268,108890,121191)
|
| 0.0029 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'gempakstarz' AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '472' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0049 |
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('472')
|
| 0.0048 |
SELECT * FROM `authors` WHERE `author_id` IN (125867,121725,125867,122556,122556)
|
| 0.0075 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'spm_revision_series' AND `site_id` = '1'
|
| 0.0023 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '496' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0070 |
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('496')
|
| 0.0035 |
SELECT * FROM `authors` WHERE `author_id` IN (110161,127271,53064,110161,111677)
|
| 0.0025 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'international_bestsellers' AND `site_id` = '1'
|
| 0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '307' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0063 |
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('307')
|
| 0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (49507,79589,49602,49343,48711)
|
| 0.0015 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'binge_series' AND `site_id` = '1'
|
| 0.0032 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '440' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0017 |
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('440')
|
| 0.0056 |
SELECT * FROM `authors` WHERE `author_id` IN (39018,47930,48002,34418,103051)
|
| 0.0013 |
SELECT * FROM `sites_shelf` WHERE `slug` = '2021_audiobook' AND `site_id` = '1'
|
| 0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '495' 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('495')
|
| 0.0015 |
SELECT * FROM `authors` WHERE `author_id` IN (127489,127491,127492,127497,127490)
|
| 0.0013 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'stayhomemillsboon' AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '485' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0017 |
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('485')
|
| 0.0017 |
SELECT * FROM `authors` WHERE `author_id` IN (103128,103210,103131,60239,82283)
|
| 0.0014 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jom_deko' AND `site_id` = '1'
|
| 0.0013 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '357' 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`.`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('357')
|
| 0.0012 |
SELECT * FROM `authors` WHERE `author_id` IN (93875,46063,122887,117972,45360)
|
| 0.0081 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_ebooks' AND `site_id` = '1'
|
| 0.0022 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '312' 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`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('312')
|
| 0.0030 |
SELECT * FROM `authors` WHERE `author_id` IN (41681,31860,2580,2580,6890)
|
| 0.0024 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'bacaan_am' AND `site_id` = '1'
|
| 0.0012 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '475' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0152 |
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('475')
|
| 0.0179 |
SELECT * FROM `authors` WHERE `author_id` IN (166,159,124367,95430,156)
|
| 0.0021 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'sekolah_rendah' AND `site_id` = '1'
|
| 0.0052 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '477' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0117 |
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('477')
|
| 0.0034 |
SELECT * FROM `authors` WHERE `author_id` IN (37349,47320,12662,12662,12662)
|
| 0.0036 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'sekolah_menengah' AND `site_id` = '1'
|
| 0.0037 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '480' 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`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('480')
|
| 0.0030 |
SELECT * FROM `authors` WHERE `author_id` IN (121487,12662,53064,122617,47293)
|
| 0.0038 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'keep_motivated' AND `site_id` = '1'
|
| 0.0038 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '478' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0037 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('478')
|
| 0.0032 |
SELECT * FROM `authors` WHERE `author_id` IN (119064,112205,52837,60030,53036)
|
| 0.0038 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'pengajian_tinggi' AND `site_id` = '1'
|
| 0.0038 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '476' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0068 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('476')
|
| 0.0051 |
SELECT * FROM `authors` WHERE `author_id` IN (127378,125185,11212,126893,108025)
|
| 0.0025 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'jom_tambah_income' AND `site_id` = '1'
|
| 0.0074 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '362' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0036 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('362')
|
| 0.0026 |
SELECT * FROM `authors` WHERE `author_id` IN (44194,82545,13606,3052,94762)
|
| 0.0079 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'for_kids' AND `site_id` = '1'
|
| 0.0038 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '474' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0078 |
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('474')
|
| 0.0021 |
SELECT * FROM `authors` WHERE `author_id` IN (109547,71,118569,127250,118578)
|
| 0.0033 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'belajar_bahasa' AND `site_id` = '1'
|
| 0.0046 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '372' 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`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('372')
|
| 0.0011 |
SELECT * FROM `authors` WHERE `author_id` IN (108063,28766,114574,108065,10786)
|
| 0.0018 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'masak_sampai_jadi' AND `site_id` = '1'
|
| 0.0038 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '375' 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`.`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('375')
|
| 0.0025 |
SELECT * FROM `authors` WHERE `author_id` IN (36644,13615,3054,44203,100982)
|
| 0.0032 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'tips_banyak_lagi' AND `site_id` = '1'
|
| 0.0045 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '483' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0041 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('483')
|
| 0.0029 |
SELECT * FROM `authors` WHERE `author_id` IN (57737,117993,94877,112360,108833)
|
| 0.0039 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'mandarin_bestseller_MY' AND `site_id` = '1'
|
| 0.0038 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '297' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0034 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('297')
|
| 0.0035 |
SELECT * FROM `authors` WHERE `author_id` IN (16737,16765,16734,47313,16763)
|
| 0.0038 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'islamic_finance' AND `site_id` = '1'
|
| 0.0038 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '488' ORDER BY `sort_order` ASC LIMIT 1
|
| 0.0036 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('488')
|
| 0.0029 |
SELECT * FROM `authors` WHERE `author_id` IN (125931,11633,94818,29957,123960)
|
| 0.0031 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'indie_alternatif' AND `site_id` = '1'
|
| 0.0050 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '123' 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`.`epub_type`, `books`.`author_id`, `shelf_books`.`sort_order` FROM `books` LEFT JOIN `shelf_books` ON `books`.`book_id` = `shelf_books`.`book_id` LEFT JOIN `sites_shelf` ON `shelf_books`.`sites_shelf_id` = `sites_shelf`.`sites_shelf_id` WHERE `books`.`offshelf` = 'N' AND `shelf_books`.`sites_shelf_id` IN('123')
|
| 0.0040 |
SELECT * FROM `authors` WHERE `author_id` IN (15702,112744,47232,31292,112800)
|
| 0.0017 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0015 |
SELECT * FROM `sites_ads_banner` WHERE `sites_ads_banner`.`site_id` = '1' AND `sites_ads_banner`.`group_id` = 6 AND `sites_ads_banner`.`status` = 'show' ORDER BY `sort_order` ASC
|