| 0.0020 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0010 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.e-sentral.com'
|
| 0.0010 |
SELECT *
FROM `sites`
WHERE `site_id` = '1'
|
| 0.0009 |
SELECT *
FROM `site_values`
WHERE `site_id` = '1'
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '1'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0011 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'international_bestsellers'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '307'
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('307')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (49704,49704,101156,50991,51651)
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_release'
AND `site_id` = '1'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '17'
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('17')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112219,112243,107942,112031,112248)
|
| 0.0013 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'manga_comics'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '41'
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('41')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (36562,23231,45127,35524,50196)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '159'
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('159')
|
| 0.0011 |
SELECT *
FROM `authors`
WHERE `author_id` IN (36763,52635,30138,47184,33427)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '312'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0012 |
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.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (31861,6890,2580,41681,52957)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'belajar_bahasa'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '372'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0012 |
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.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (108065,28766,108068,10786,47570)
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'soft_skils'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '306'
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('306')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (35710,28028,47505,100187,7278)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'mandarin_bestseller_MY'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '297'
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('297')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (36921,47152,109734,57730,47153)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'haji'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '361'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0011 |
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('361')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (13557,1574,13582,109109,1574)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'romance_ENG_MY'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '303'
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('303')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (97867,11081,46659,34438,29696)
|
| 0.0015 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'indie'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '123'
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('123')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (109436,41363,31948,47234,15700)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'masak_apa_hari_ini'
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.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('375')
|
| 0.0010 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47551,36644,44203,17654,3054)
|
| 0.0012 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0012 |
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)
