BENCHMARKS  
Loading Time: Base Classes  0.0008
Controller Execution Time ( Search Sphinx / Filter )  0.0383
Total Execution Time  0.0392
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,362,096 bytes
  POST DATA  
No POST data exists
  URI STRING  
search_sphinx/filter/au_33697_timothy-bond/timothy-bond
  CLASS/METHOD  
search_sphinx/filter
  DATABASE:  esentral_ebook (Search_sphinx:$db)   QUERIES: 10 (0.0091 seconds)  (Hide)
0.0015   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.0010   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 
`nameAS
0.0014   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 (51545,186249,186546,186547,186548,186550) AND b.offshelf 'N'
                       
ORDER BY FIELD(b.book_id51545,186249,186546,186547,186548,186550) 
0.0010   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 (51545,186249,186546,186547,186548,186550) AND b.offshelf 'N'
                       
ORDER BY FIELD(b.book_id51545,186249,186546,186547,186548,186550) LIMIT 010 
0.0007   SELECT `authors`.`author_id`, `authors`. `name`
FROM `authors`
WHERE `authors`.`author_idIN(33697) 
0.0008   SELECT `publisher`.`publisher_id`, `publisher`. `name`
FROM `publisher`
WHERE `publisher`.`publisher_idIN(12264542) 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)