| 0.0015 |
SHOW TABLES FROM `esentral_ebook`
|
| 0.0004 |
SELECT *
FROM `site_domains`
WHERE `domain` = 'www.bookcapital.my'
|
| 0.0003 |
SELECT *
FROM `sites`
WHERE `site_id` = '2'
|
| 0.0003 |
SELECT *
FROM `site_values`
WHERE `site_id` = '2'
|
| 0.0007 |
SELECT *
FROM `sites_shelf`
WHERE `site_id` = '2'
AND `shelf_status` = 1
ORDER BY `sort_order`
|
| 0.0007 |
SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'new_release'
AND `site_id` = '2'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '179'
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('179')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112773,112551,111958,1,95571)
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'born_digital'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '397'
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('397')
|
| 0.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (112773,111924,109874,111500,94685)
|
| 0.0005 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'malaysian_government_initiatives'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '376'
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('376')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (109108,52754,94763,37570,41681)
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'iiit_ebooks'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '351'
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('351')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (109834,94818,94825,94821,94819)
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'santapan_minda'
AND `site_id` = '2'
|
| 0.0005 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '240'
ORDER BY `sort_order` ASC
LIMIT 1
|
| 0.0022 |
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('240')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (37352,1,41687,47584,1)
|
| 0.0005 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'buku_interaktif'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '304'
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('304')
|
| 0.0003 |
SELECT *
FROM `authors`
WHERE `author_id` IN (31861,41681,2580,2580,6890)
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'malaysia_uni_press'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '257'
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('257')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (47661,37352,47567,37353,47631)
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'dewan_bahasa_dan_pustaka'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '325'
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('325')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (9676,52994,9355,53003,52995)
|
| 0.0006 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'jabatan_penerangan_malaysia'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '333'
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('333')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (82281,82281,82281,82281,82281)
|
| 0.0005 |
SELECT *
FROM `sites_shelf`
WHERE `slug` = 'raikan_cinta'
AND `site_id` = '2'
|
| 0.0004 |
SELECT *, `sites_shelf_id`
FROM `sites_shelf`
WHERE `sites_shelf`.`sites_shelf_id` = '266'
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('266')
|
| 0.0004 |
SELECT *
FROM `authors`
WHERE `author_id` IN (164,21,1,8,34493)
|
| 0.0004 |
SELECT `site_id`, `sites_tabs_id`, `name`
FROM `sites_tabs`
WHERE `site_id` = '2'
AND `tab_status` = 1
ORDER BY `sort_order`
|
| 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` = '29'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0004 |
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` = '14'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0004 |
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` = '16'
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` = '17'
AND `books`.`offshelf` = 'N'
ORDER BY `tabs_books`.`sort_order`
LIMIT 7
|
| 0.0006 |
SHOW COLUMNS FROM `sites_ads_banner`
|
| 0.0004 |
SELECT *
FROM `sites_ads_banner`
WHERE `sites_ads_banner`.`site_id` = '2'
AND `sites_ads_banner`.`group_id` = 6
ORDER BY `sort_order` ASC
|
-medium.jpg)
Mei2016(050.)-medium.jpg)
OGOS2016(050.)-medium.jpg)
