| 0.0010 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0002 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.e-sentral.com'
|
| 0.0002 |
SELECT *
FROM `sites`
WHERE `site_id` = '1'
|
| 0.0002 |
SELECT *
FROM `site_values`
WHERE `site_id` = '1'
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '1'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0004 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbdm_romantik'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '411'
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`.`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('411')
|
| 0.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112807,1,36763,60035,47300)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbdm_am'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '410'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0048 |
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('410')
|
| 0.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (11394,95569,119064,57737,156)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbdm_kanak'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '415'
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('415')
|
| 0.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (74,76,9359,250,71)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '312'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0004 |
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.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52957,2580,82167,31860,53064)
|
| 0.0003 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbdm_akademik_am'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '412'
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('412')
|
| 0.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (34504,108833,82224,107943,15642)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'buku_latihan_sekolah'
AND `site_id` = '1'
|
| 0.0003 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '419'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0009 |
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('419')
|
| 0.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (12662,71,71,12662,52853)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pbdm_undang_undang'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '418'
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`.`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('418')
|
| 0.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (2580,2580,2580,2580,2580)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_release'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '17'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0013 |
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.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (95573,33364,47218,118546,118553)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'stay_at_home'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '406'
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`.`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('406')
|
| 0.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47181,9095,94846,111979,118504)
|
| 0.0007 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'international_bestsellers'
AND `site_id` = '1'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '307'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0016 |
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.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51000,50565,51258,50350,50674)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'main_masak_masak'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '375'
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`.`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.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (3054,12669,3054,12669,3054)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'jom_buat_duit'
AND `site_id` = '1'
|
| 0.0003 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '362'
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`.`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.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (11394,3068,15621,189,156)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi'
AND `site_id` = '1'
|
| 0.0002 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '159'
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`.`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.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (110939,52647,108890,118494,47300)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'belajar_bahasa'
AND `site_id` = '1'
|
| 0.0003 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '372'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0004 |
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('372')
|
| 0.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108069,108066,108082,108065,108063)
|
| 0.0004 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'soft_skils'
AND `site_id` = '1'
|
| 0.0003 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '306'
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`.`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('306')
|
| 0.0002 |
SELECT *
FROM `authors`
WHERE `author_id` IN (95570,109397,13611,159,95570)
|
| 0.0006 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0004 |
SELECT *
FROM `sites_ads_banner`
WHERE `sites_ads_banner`.`site_id` = '1'
AND `sites_ads_banner`.`group_id` = 6
ORDER BY `sort_order` ASC
|
.jpg)
