| 0.0016 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0006 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'e-sentral.com.bn'
|
| 0.0005 |
SELECT *
FROM `sites`
WHERE `site_id` = '8'
|
| 0.0005 |
SELECT *
FROM `site_values`
WHERE `site_id` = '8'
|
| 0.0005 |
SELECT *
FROM `header_notifications`
WHERE `active` = 1
AND `locale` = 'esentralbn'
|
| 0.0008 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '8'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0008 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0008 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'international_bestsellers'
AND `site_id` = '8'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '385'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0011 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`bnd_price` as `retail_price`, `books`.`bnd_ori_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('385')
|
| 0.0005 |
SELECT *
FROM `authors`
WHERE `author_id` IN (51063,48345,40371,47924,50631)
|
| 0.0007 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'belajar_bahasa'
AND `site_id` = '8'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '388'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0007 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`bnd_price` as `retail_price`, `books`.`bnd_ori_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('388')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (10786,10786,12516,28766,47570)
|
| 0.0007 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'interactive_books'
AND `site_id` = '8'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '382'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0007 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`bnd_price` as `retail_price`, `books`.`bnd_ori_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('382')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (6890,2580,2580,2580,31860)
|
| 0.0005 |
SELECT `site_id`, `sites_tabs_id`, `name`
FROM `sites_tabs`
WHERE `site_id` = '8'
AND `tab_status` = 1
ORDER BY `sort_order`
|
| 0.0006 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '33'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0005 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '30'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0005 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '32'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0006 |
SELECT `tabs_books`.`book_id`, `books`.`title`, `books`.`s3_cover`, `books`.`offshelf`
FROM `tabs_books`
JOIN `books` ON `tabs_books`.`book_id` = `books`.`book_id`
WHERE `tabs_books`.`sites_tabs_id` = '31'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0014 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0006 |
SELECT *
FROM `sites_ads_banner`
WHERE `sites_ads_banner`.`site_id` = '8'
AND `sites_ads_banner`.`group_id` = 6
AND `sites_ads_banner`.`status` = 'show'
ORDER BY `sort_order` ASC
|
