string(33) "esentral-dist/javascripts/main.js"
  BENCHMARKS  
Loading Time: Base Classes  0.0035
Controller Execution Time ( Search Sphinx / Filter )  0.0968
Total Execution Time  0.1005
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,722,872 bytes
  POST DATA  
No POST data exists
  URI STRING  
search_sphinx/filter/pb_56_university-of-malaya-press/university/10
  CLASS/METHOD  
search_sphinx/filter
  DATABASE:  esentral_ebook (Search_sphinx:$db)   QUERIES: 11 (0.0499 seconds)  (Hide)
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 
`nameAS
0.0089   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,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_id10315,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_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,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_id10315,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 1010 
0.0160   SELECT `authors`.`author_id`, `authors`. `name`
FROM `authors`
WHERE `authors`.`author_idIN(2641108554224494849263726383181325212107162533342042273423455301153034530102636317831793180318293139315931693171082810829108531111911533115341160311704120171205812150121541220812214123461240512415125241264012641126421264312687126882605136021366714053143091439114392146131479714798148771591315914159151625416255225942259522596299532995429955299562995730140301413101731018310193130132015320163201732018320193202032095320963209733418334194224142242422434224542344423464236542366423675262252688527265273052732530095301253013530835308453096531005259653102589256025460255602566025782214822168221782267822688226982270822718316483165831719469183319948489485094851) 
0.0007   SELECT `publisher`.`publisher_id`, `publisher`. `name`
FROM `publisher`
WHERE `publisher`.`publisher_idIN(56) 
0.0008   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)