0.0014 |
SHOW TABLES FROM `esentral_ebook`
|
0.0006 |
SELECT * FROM `site_domains` WHERE `domain` = 'www.e-sentral.com'
|
0.0006 |
SELECT * FROM `sites` WHERE `site_id` = '1'
|
0.0006 |
SELECT * FROM `site_values` WHERE `site_id` = '1'
|
0.0009 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '1' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0009 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'wbd_general_novel' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '349' ORDER BY `sort_order` ASC LIMIT 1
|
0.0020 |
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.0007 |
SELECT * FROM `authors` WHERE `author_id` IN (34103,28636,3267,28633,3267)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'wbd_general_academics' AND `site_id` = '1'
|
0.0008 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '350' 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('350')
|
0.0008 |
SELECT * FROM `authors` WHERE `author_id` IN (14623,9095,11203,14621,11206)
|
0.0010 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'international_bestsellers' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '307' ORDER BY `sort_order` ASC LIMIT 1
|
0.0010 |
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.0007 |
SELECT * FROM `authors` WHERE `author_id` IN (50723,47452,49428,51138,51164)
|
0.0008 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'new_release' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '17' 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('17')
|
0.0006 |
SELECT * FROM `authors` WHERE `author_id` IN (11703,94810,36668,94801,94807)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'pilihan_raya' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '347' 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('347')
|
0.0010 |
SELECT * FROM `authors` WHERE `author_id` IN (32018,14612,60260,2637,12642)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'komik' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '323' ORDER BY `sort_order` ASC LIMIT 1
|
0.0009 |
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('323')
|
0.0007 |
SELECT * FROM `authors` WHERE `author_id` IN (94690,186,57708,186,56108)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_revision_book' AND `site_id` = '1'
|
0.0015 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '339' 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('339')
|
0.0007 |
SELECT * FROM `authors` WHERE `author_id` IN (53064,47408,60252,47389,82167)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'buku_cerita_kanak_kanak' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '331' ORDER BY `sort_order` ASC LIMIT 1
|
0.0010 |
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('331')
|
0.0006 |
SELECT * FROM `authors` WHERE `author_id` IN (2591,37481,3047,14158,37490)
|
0.0008 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'interactive_magazine' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '312' 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('312')
|
0.0006 |
SELECT * FROM `authors` WHERE `author_id` IN (31861,6890,2580,41681,2580)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'romance_BM_MY' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '85' 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('85')
|
0.0006 |
SELECT * FROM `authors` WHERE `author_id` IN (83163,40474,47221,31998,44190)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'mandarin_bestseller_MY' AND `site_id` = '1'
|
0.0008 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '297' 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('297')
|
0.0007 |
SELECT * FROM `authors` WHERE `author_id` IN (41699,57730,36581,14148,307)
|
0.0007 |
SELECT * FROM `sites_shelf` WHERE `slug` = 'romance_ENG_MY' AND `site_id` = '1'
|
0.0007 |
SELECT *, `sites_shelf_id` FROM `sites_shelf` WHERE `sites_shelf`.`sites_shelf_id` = '303' ORDER BY `sort_order` ASC LIMIT 1
|
0.0009 |
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.0007 |
SELECT * FROM `authors` WHERE `author_id` IN (11067,12700,13673,48748,49229)
|
0.0012 |
SHOW COLUMNS FROM `sites_ads_banner`
|
0.0008 |
SELECT * FROM `sites_ads_banner` WHERE `sites_ads_banner`.`site_id` = '1' AND `sites_ads_banner`.`group_id` = 6 ORDER BY `sort_order` ASC
|