BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Search Sphinx / Filter )  0.0834
Total Execution Time  0.0844
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,763,264 bytes
  POST DATA  
No POST data exists
  URI STRING  
search_sphinx/filter/pb_56_university-of-malaya-press/university/20
  CLASS/METHOD  
search_sphinx/filter
  DATABASE:  esentral_ebook (Search_sphinx:$db)   QUERIES: 11 (0.0239 seconds)  (Hide)
0.0017   SHOW TABLES FROM `esentral_ebook
0.0007   SELECT *
FROM `site_domains`
WHERE `domain` = 'www.e-sentral.com' 
0.0008   SELECT *
FROM `sites`
WHERE `site_id` = '1' 
0.0007   SELECT *
FROM `site_values`
WHERE `site_id` = '1' 
0.0049   SELECT *
FROM `sites_shelf`
WHERE `site_id` = '1'
AND `shelf_status` = 1
ORDER BY 
`sort_order
0.0011   SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY 
`nameAS
0.0068   SELECT
                       b
.book_idb.titleb.s3_coverb.filesize,
                       
b.retail_price as retail_priceb.ebook_price as ebook_priceb.synopsis,
                       
b.isbnb.formatb.languageb.tax_rate,
                       
b.category_idb.multicatb.imprint,
                       
a.name as author_namea.author_id,
                       
p.name as publisher_namep.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,203407,266078,266080,266134,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,203408,203409,203410,203416,203417,203418,203419,266038,266039,266040,266041,266081,266082,266130,266131,266133,266168,266169,266170,266171,266179,266180,267771) AND b.offshelf 'N'
                       
ORDER BY FIELD(b.book_id10315,73840,14130,67875,203340,1757,1758,2926,2941,13828,18560,50976,67932,68040,97219,97476,122198,203407,266078,266080,266134,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,203408,203409,203410,203416,203417,203418,203419,266038,266039,266040,266041,266081,266082,266130,266131,266133,266168,266169,266170,266171,266179,266180,267771) 
0.0026   SELECT
                       b
.book_idb.titleb.s3_coverb.filesize,
                       
b.retail_price as retail_priceb.ebook_price as ebook_priceb.synopsis,
                       
b.isbnb.formatb.languageb.tax_rate,
                       
b.category_idb.multicatb.imprint,
                       
a.name as author_namea.author_id,
                       
p.name as publisher_namep.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,203407,266078,266080,266134,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,203408,203409,203410,203416,203417,203418,203419,266038,266039,266040,266041,266081,266082,266130,266131,266133,266168,266169,266170,266171,266179,266180,267771) AND b.offshelf 'N'
                       
ORDER BY FIELD(b.book_id10315,73840,14130,67875,203340,1757,1758,2926,2941,13828,18560,50976,67932,68040,97219,97476,122198,203407,266078,266080,266134,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,203408,203409,203410,203416,203417,203418,203419,266038,266039,266040,266041,266081,266082,266130,266131,266133,266168,266169,266170,266171,266179,266180,267771) LIMIT 2010 
0.0019   SELECT `authors`.`author_id`, `authors`. `name`
FROM `authors`
WHERE `authors`.`author_idIN(26411085542244948492637263831813252121071625333420422734234553011530345301094889107771107773107823263631783179318031829313931593169317108281082910853111191153311534116031170412017120581215012154122081221412346124051241512524126401264112642126431268712688260513602136671405314309143911439214613147971479814877159131591415915162541625522594225952259629953299542995529956299573014030141310173101831019313013201532016320173201832019320203209532096320973341833419422414224242243422454234442346423654236642367526225268852726527305273253009530125301353083530845309653100525965310258925602546025560256602578221482216822178226782268822698227082271831648316583171946918331994848948509485194890948919489294896948979489894899107741107742107743107744107774107775107819107820107822107843107845107846107847107855107856) 
0.0017   SELECT `publisher`.`publisher_id`, `publisher`. `name`
FROM `publisher`
WHERE `publisher`.`publisher_idIN(56) 
0.0010   SELECT `nested_category`.`category_id`, `nested_category`. `name_english`
FROM `nested_category`
WHERE `nested_category`.`category_idIN(5181936313022316825152314921264354028) 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)