| 0.0024 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0013 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'e-sentral.sg'
|
| 0.0014 |
SELECT *
FROM `sites`
WHERE `site_id` = '4'
|
| 0.0014 |
SELECT *
FROM `site_values`
WHERE `site_id` = '4'
|
| 0.0035 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '4'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0022 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0014 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'international_bestsellers'
AND `site_id` = '4'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '309'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0017 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('309')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (50121,101704,47979,50120,102079)
|
| 0.0035 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'romance_SG'
AND `site_id` = '4'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '300'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0015 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('300')
|
| 0.0013 |
SELECT *
FROM `authors`
WHERE `author_id` IN (34466,33383,47932,30849,28276)
|
| 0.0014 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'Crime_SG'
AND `site_id` = '4'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '301'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0016 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('301')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (23372,9608,3029,46741,9614)
|
| 0.0015 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'truestories_SG'
AND `site_id` = '4'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '299'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0016 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('299')
|
| 0.0013 |
SELECT *
FROM `authors`
WHERE `author_id` IN (4147,97620,4884,31462,23510)
|
| 0.0014 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'fiction'
AND `site_id` = '4'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '293'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0014 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('293')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (259,295,36400,3048,3003)
|
| 0.0015 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'fiksi'
AND `site_id` = '4'
|
| 0.0014 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '294'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0015 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('294')
|
| 0.0013 |
SELECT *
FROM `authors`
WHERE `author_id` IN (13131,12207,29647,1,732)
|
| 0.0014 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'academic'
AND `site_id` = '4'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '295'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0015 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('295')
|
| 0.0014 |
SELECT *
FROM `authors`
WHERE `author_id` IN (53064,25086,52957,47408,36856)
|
| 0.0015 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'akademik'
AND `site_id` = '4'
|
| 0.0015 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '296'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0016 |
SELECT `books`.`book_id`, `shelf_books`.`sites_shelf_id`, `books`.`title`, `books`.`s3_cover`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_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('296')
|
| 0.0015 |
SELECT *
FROM `authors`
WHERE `author_id` IN (9676,52939,47574,71,34514)
|
| 0.0017 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0016 |
SELECT *
FROM `sites_ads_banner`
WHERE `sites_ads_banner`.`site_id` = '4'
AND `sites_ads_banner`.`group_id` = 6
ORDER BY `sort_order` ASC
|
