| 0.0050 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0066 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.e-sentral.com'
|
| 0.0039 |
SELECT *
FROM `sites`
WHERE `site_id` = '1'
|
| 0.0039 |
SELECT *
FROM `site_values`
WHERE `site_id` = '1'
|
| 0.0064 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '1'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0118 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0110 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'wbd_general_novel'
AND `site_id` = '1'
|
| 0.0036 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '349'
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('349')
|
| 0.0187 |
SELECT *
FROM `authors`
WHERE `author_id` IN (28627,47372,44202,47521,113)
|
| 0.0011 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'wbd_general_academics'
AND `site_id` = '1'
|
| 0.0026 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '350'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0065 |
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('350')
|
| 0.0143 |
SELECT *
FROM `authors`
WHERE `author_id` IN (14623,9095,11203,14621,11207)
|
| 0.0021 |
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.0024 |
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.0048 |
SELECT *
FROM `authors`
WHERE `author_id` IN (50968,51198,50290,102348,102363)
|
| 0.0040 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_release'
AND `site_id` = '1'
|
| 0.0011 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '17'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0350 |
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 (94846,44673,110299,110511,110304)
|
| 0.0048 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'pick_of_the_week'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '391'
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('391')
|
| 0.0015 |
SELECT *
FROM `authors`
WHERE `author_id` IN (189,35710,47260,82541,31998)
|
| 0.0038 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'cerita_seram'
AND `site_id` = '1'
|
| 0.0079 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '364'
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`.`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.0018 |
SELECT *
FROM `authors`
WHERE `author_id` IN (52755,30859,107858,36570,41695)
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'drama_adaptasi'
AND `site_id` = '1'
|
| 0.0030 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '159'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0055 |
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.0019 |
SELECT *
FROM `authors`
WHERE `author_id` IN (35980,41604,33427,47184,176)
|
| 0.0012 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'indie'
AND `site_id` = '1'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '123'
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`.`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.0137 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47232,41363,31948,15704,47234)
|
| 0.0034 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'haji'
AND `site_id` = '1'
|
| 0.0044 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '361'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0072 |
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.0045 |
SELECT *
FROM `authors`
WHERE `author_id` IN (1574,109109,2603,28013,1574)
|
| 0.0053 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'masak_apa_hari_ini'
AND `site_id` = '1'
|
| 0.0052 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '375'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0039 |
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.0034 |
SELECT *
FROM `authors`
WHERE `author_id` IN (12669,13615,3054,17654,95367)
|
| 0.0040 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '1'
|
| 0.0047 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '312'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0031 |
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.0214 |
SELECT *
FROM `authors`
WHERE `author_id` IN (2580,2580,31861,41681,6890)
|
| 0.0022 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'romance_BM_MY'
AND `site_id` = '1'
|
| 0.0010 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '85'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0030 |
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('85')
|
| 0.0043 |
SELECT *
FROM `authors`
WHERE `author_id` IN (31998,32253,107831,107829,44693)
|
| 0.0069 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'romance_ENG_MY'
AND `site_id` = '1'
|
| 0.0013 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '303'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0343 |
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.0062 |
SELECT *
FROM `authors`
WHERE `author_id` IN (98392,35111,17837,95804,29696)
|
| 0.0047 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'mandarin_bestseller_MY'
AND `site_id` = '1'
|
| 0.0012 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '297'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0304 |
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.0032 |
SELECT *
FROM `authors`
WHERE `author_id` IN (109734,47152,36614,94744,15562)
|
| 0.0035 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0037 |
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)
