BENCHMARKS  
Loading Time: Base Classes  0.0009
Controller Execution Time ( Search Sphinx / Filter )  0.0422
Total Execution Time  0.0432
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,466,960 bytes
  POST DATA  
No POST data exists
  URI STRING  
search_sphinx/filter/pb_1784_iman-publications/iman-publications
  CLASS/METHOD  
search_sphinx/filter
  DATABASE:  esentral_ebook (Search_sphinx:$db)   QUERIES: 11 (0.0108 seconds)  (Hide)
0.0016   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.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.0010   SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY 
`nameAS
0.0019   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 (207147,19502,207102,207103,207104,207105,207106,207107,207108,207109,207111,207140,207141,207142,207143,207144,207146,207149) AND b.offshelf 'N'
                       
ORDER BY FIELD(b.book_id207147,19502,207102,207103,207104,207105,207106,207107,207108,207109,207111,207140,207141,207142,207143,207144,207146,207149) 
0.0012   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 (207147,19502,207102,207103,207104,207105,207106,207107,207108,207109,207111,207140,207141,207142,207143,207144,207146,207149) AND b.offshelf 'N'
                       
ORDER BY FIELD(b.book_id207147,19502,207102,207103,207104,207105,207106,207107,207108,207109,207111,207140,207141,207142,207143,207144,207146,207149) LIMIT 010 
0.0007   SELECT `authors`.`author_id`, `authors`. `name`
FROM `authors`
WHERE `authors`.`author_idIN(9557318081955689556995570955719557295586955879558995591) 
0.0006   SELECT `publisher`.`publisher_id`, `publisher`. `name`
FROM `publisher`
WHERE `publisher`.`publisher_idIN(1784) 
0.0006   SELECT `nested_category`.`category_id`, `nested_category`. `name_english`
FROM `nested_category`
WHERE `nested_category`.`category_idIN(2316193626302371828) 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)