| 0.0034 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0009 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.e-sentral.com'
|
| 0.0007 |
SELECT *
FROM `sites`
WHERE `site_id` = '1'
|
| 0.0007 |
SELECT *
FROM `site_values`
WHERE `site_id` = '1'
|
| 0.0038 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentral'
|
| 0.0035 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '1'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0010 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0038 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'maulidur_rasul_my'
AND `site_id` = '1'
|
| 0.0051 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '482'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0027 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`retail_price` as `retail_price`, `books`.`ebook_price` as `ebook_price`, `books`.`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('482')
|
| 0.0084 |
SELECT *
FROM `authors`
WHERE `author_id` IN (121251,112360,16505,47592,2611)
|
| 0.0038 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_release'
AND `site_id` = '1'
|
| 0.0012 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '17'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0073 |
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`.`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.0040 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47183,47200,110152,3054,125711)
|
| 0.0036 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_ebooks'
AND `site_id` = '1'
|
| 0.0007 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '312'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0019 |
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`.`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.0055 |
SELECT *
FROM `authors`
WHERE `author_id` IN (41681,31860,2580,2580,6890)
|
| 0.0049 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'international_bestsellers'
AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '307'
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`.`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.0051 |
SELECT *
FROM `authors`
WHERE `author_id` IN (50458,49073,50684,53467,101171)
|
| 0.0010 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi'
AND `site_id` = '1'
|
| 0.0022 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '159'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0028 |
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`.`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.0007 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108890,110097,121191,110153,3072)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'motivasi_diri'
AND `site_id` = '1'
|
| 0.0007 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '478'
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`.`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.0009 |
SELECT *
FROM `authors`
WHERE `author_id` IN (159,52699,15550,119064,29430)
|
| 0.0008 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'ini_cerita_seram'
AND `site_id` = '1'
|
| 0.0008 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '364'
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`.`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('364')
|
| 0.0022 |
SELECT *
FROM `authors`
WHERE `author_id` IN (41695,110302,56069,24465,52756)
|
| 0.0009 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'jom_tambah_income'
AND `site_id` = '1'
|
| 0.0006 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '362'
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`.`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.0022 |
SELECT *
FROM `authors`
WHERE `author_id` IN (57737,3052,82198,44178,94762)
|
| 0.0021 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'wbc_kids'
AND `site_id` = '1'
|
| 0.0006 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '474'
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`.`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.0006 |
SELECT *
FROM `authors`
WHERE `author_id` IN (126,2567,2567,292,2567)
|
| 0.0009 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'sekolah_rendah'
AND `site_id` = '1'
|
| 0.0007 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '477'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0396 |
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`.`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.0054 |
SELECT *
FROM `authors`
WHERE `author_id` IN (37349,12662,52939,12662,121976)
|
| 0.0085 |
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.0014 |
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`.`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.0050 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110161,121487,47293,123850,12662)
|
| 0.0033 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'masak_ape_tu'
AND `site_id` = '1'
|
| 0.0012 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '375'
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`.`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.0017 |
SELECT *
FROM `authors`
WHERE `author_id` IN (3054,3054,52749,112359,3054)
|
| 0.0010 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'indie_alternatif'
AND `site_id` = '1'
|
| 0.0006 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '123'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0165 |
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`.`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.0059 |
SELECT *
FROM `authors`
WHERE `author_id` IN (15702,112744,47232,31292,112800)
|
| 0.0039 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'gempakstarz'
AND `site_id` = '1'
|
| 0.0039 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '472'
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`.`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.0013 |
SELECT *
FROM `authors`
WHERE `author_id` IN (121725,122556,122556,122556,122556)
|
| 0.0010 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'mandarin_bestseller_MY'
AND `site_id` = '1'
|
| 0.0009 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '297'
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`.`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.0053 |
SELECT *
FROM `authors`
WHERE `author_id` IN (16737,94758,16765,16734,47313)
|
| 0.0013 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0023 |
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
|
-medium.jpg)
