0.0167 |
SHOW TABLES FROM `esentral_ebook`
|
0.0008 |
SELECT * FROM `site_domains` WHERE `domain` = 'www.e-sentral.com'
|
0.0007 |
SELECT * FROM `sites` WHERE `site_id` = '1'
|
0.0008 |
SELECT * FROM `site_values` WHERE `site_id` = '1'
|
0.0013 |
SELECT * FROM `sites_shelf` WHERE `site_id` = '1' AND `shelf_status` = 1 ORDER BY `sort_order`
|
0.0010 |
SELECT * FROM `nested_category` WHERE `nested_category`.`category_id` > 1 ORDER BY `name` ASC
|
0.0089 |
SELECT b.book_id, b.title, b.s3_cover, b.filesize, b.retail_price as retail_price, b.ebook_price as ebook_price, b.synopsis, b.isbn, b.format, b.language, b.tax_rate, b.category_id, b.multicat, b.imprint, a.name as author_name, a.author_id, p.name as publisher_name, p.publisher_id, nc.name_english FROM books as b LEFT JOIN authors as a on b.author_id = a.author_id LEFT JOIN publisher as p on b.publisher_id = p.publisher_id LEFT JOIN nested_category as nc ON b.category_id = nc.category_id WHERE b.book_id IN (10315,73840,14130,67875,203340,1757,1758,2926,2941,13828,18560,50976,67932,68040,97219,97476,122198,1756,1770,2923,2924,2925,2927,10316,10319,10320,10321,12245,12246,12251,12253,12348,12808,12809,13123,13286,13709,13768,13886,13891,13920,13932,14110,14143,14152,14280,14284,14285,14286,14287,14512,14513,14612,14613,15559,15832,16182,16461,16566,16567,16890,17568,17569,17570,18374,18375,18376,18561,18562,28425,28426,28427,43623,43624,43625,43626,43627,44070,44071,46773,46774,46775,47214,48523,48524,48525,48526,48527,48528,48641,48642,48643,50974,50975,67872,67873,67874,67876,67931,68039,68041,68108,68109,68110,73839,75647,75648,90519,90520,90703,93911,93913,93914,93936,93937,93946,97217,97218,97220,97221,97567,97568,99751,111308,111310,111311,122195,125477,125478,125479,125480,182983,182985,182986,183091,183092,183093,183094,183095,183096,184986,184987,184999,185098,185387,203339,203341,203342) AND b.offshelf = 'N' ORDER BY FIELD(b.book_id, 10315,73840,14130,67875,203340,1757,1758,2926,2941,13828,18560,50976,67932,68040,97219,97476,122198,1756,1770,2923,2924,2925,2927,10316,10319,10320,10321,12245,12246,12251,12253,12348,12808,12809,13123,13286,13709,13768,13886,13891,13920,13932,14110,14143,14152,14280,14284,14285,14286,14287,14512,14513,14612,14613,15559,15832,16182,16461,16566,16567,16890,17568,17569,17570,18374,18375,18376,18561,18562,28425,28426,28427,43623,43624,43625,43626,43627,44070,44071,46773,46774,46775,47214,48523,48524,48525,48526,48527,48528,48641,48642,48643,50974,50975,67872,67873,67874,67876,67931,68039,68041,68108,68109,68110,73839,75647,75648,90519,90520,90703,93911,93913,93914,93936,93937,93946,97217,97218,97220,97221,97567,97568,99751,111308,111310,111311,122195,125477,125478,125479,125480,182983,182985,182986,183091,183092,183093,183094,183095,183096,184986,184987,184999,185098,185387,203339,203341,203342)
|
0.0023 |
SELECT b.book_id, b.title, b.s3_cover, b.filesize, b.retail_price as retail_price, b.ebook_price as ebook_price, b.synopsis, b.isbn, b.format, b.language, b.tax_rate, b.category_id, b.multicat, b.imprint, a.name as author_name, a.author_id, p.name as publisher_name, p.publisher_id, nc.name_english FROM books as b LEFT JOIN authors as a on b.author_id = a.author_id LEFT JOIN publisher as p on b.publisher_id = p.publisher_id LEFT JOIN nested_category as nc ON b.category_id = nc.category_id WHERE b.book_id IN (10315,73840,14130,67875,203340,1757,1758,2926,2941,13828,18560,50976,67932,68040,97219,97476,122198,1756,1770,2923,2924,2925,2927,10316,10319,10320,10321,12245,12246,12251,12253,12348,12808,12809,13123,13286,13709,13768,13886,13891,13920,13932,14110,14143,14152,14280,14284,14285,14286,14287,14512,14513,14612,14613,15559,15832,16182,16461,16566,16567,16890,17568,17569,17570,18374,18375,18376,18561,18562,28425,28426,28427,43623,43624,43625,43626,43627,44070,44071,46773,46774,46775,47214,48523,48524,48525,48526,48527,48528,48641,48642,48643,50974,50975,67872,67873,67874,67876,67931,68039,68041,68108,68109,68110,73839,75647,75648,90519,90520,90703,93911,93913,93914,93936,93937,93946,97217,97218,97220,97221,97567,97568,99751,111308,111310,111311,122195,125477,125478,125479,125480,182983,182985,182986,183091,183092,183093,183094,183095,183096,184986,184987,184999,185098,185387,203339,203341,203342) AND b.offshelf = 'N' ORDER BY FIELD(b.book_id, 10315,73840,14130,67875,203340,1757,1758,2926,2941,13828,18560,50976,67932,68040,97219,97476,122198,1756,1770,2923,2924,2925,2927,10316,10319,10320,10321,12245,12246,12251,12253,12348,12808,12809,13123,13286,13709,13768,13886,13891,13920,13932,14110,14143,14152,14280,14284,14285,14286,14287,14512,14513,14612,14613,15559,15832,16182,16461,16566,16567,16890,17568,17569,17570,18374,18375,18376,18561,18562,28425,28426,28427,43623,43624,43625,43626,43627,44070,44071,46773,46774,46775,47214,48523,48524,48525,48526,48527,48528,48641,48642,48643,50974,50975,67872,67873,67874,67876,67931,68039,68041,68108,68109,68110,73839,75647,75648,90519,90520,90703,93911,93913,93914,93936,93937,93946,97217,97218,97220,97221,97567,97568,99751,111308,111310,111311,122195,125477,125478,125479,125480,182983,182985,182986,183091,183092,183093,183094,183095,183096,184986,184987,184999,185098,185387,203339,203341,203342) LIMIT 10, 10
|
0.0160 |
SELECT `authors`.`author_id`, `authors`. `name` FROM `authors` WHERE `authors`.`author_id` IN(2641, 10855, 42244, 94849, 2637, 2638, 3181, 3252, 12107, 16253, 33420, 42273, 42345, 53011, 53034, 53010, 2636, 3178, 3179, 3180, 3182, 9313, 9315, 9316, 9317, 10828, 10829, 10853, 11119, 11533, 11534, 11603, 11704, 12017, 12058, 12150, 12154, 12208, 12214, 12346, 12405, 12415, 12524, 12640, 12641, 12642, 12643, 12687, 12688, 2605, 13602, 13667, 14053, 14309, 14391, 14392, 14613, 14797, 14798, 14877, 15913, 15914, 15915, 16254, 16255, 22594, 22595, 22596, 29953, 29954, 29955, 29956, 29957, 30140, 30141, 31017, 31018, 31019, 31301, 32015, 32016, 32017, 32018, 32019, 32020, 32095, 32096, 32097, 33418, 33419, 42241, 42242, 42243, 42245, 42344, 42346, 42365, 42366, 42367, 52622, 52688, 52726, 52730, 52732, 53009, 53012, 53013, 53083, 53084, 53096, 53100, 52596, 53102, 58925, 60254, 60255, 60256, 60257, 82214, 82216, 82217, 82267, 82268, 82269, 82270, 82271, 83164, 83165, 83171, 94691, 83319, 94848, 94850, 94851)
|
0.0007 |
SELECT `publisher`.`publisher_id`, `publisher`. `name` FROM `publisher` WHERE `publisher`.`publisher_id` IN(56)
|
0.0008 |
SELECT `nested_category`.`category_id`, `nested_category`. `name_english` FROM `nested_category` WHERE `nested_category`.`category_id` IN(5, 18, 19, 36, 31, 30, 22, 3, 16, 8, 25, 15, 23, 14, 9, 21, 26, 4, 35, 40, 28)
|