Filter

Books in Business & Management category:
4059 books

Showing 10 from 4059 for "a" filtered by Pengurusan Dan Perniagaan ×
123
  BENCHMARKS  
Loading Time: Base Classes  0.0055
Controller Execution Time ( Search / Filter )  2.7596
Total Execution Time  2.7658
  GET DATA  
No GET data exists
  MEMORY USAGE  
8,626,848 bytes
  POST DATA  
No POST data exists
  URI STRING  
category/filter/cat_8_pengurusan-dan-perniagaan/a
  CLASS/METHOD  
search/filter
  DATABASE:  esentral_ebook (Search:$db)   QUERIES: 12 (2.6088 seconds)  (Hide)
0.0014   SHOW TABLES FROM `esentral_ebook
0.0124   SELECT *
FROM `site_domains`
WHERE `domain` = 'e-sentral.sg' 
0.0071   SELECT *
FROM `sites`
WHERE `site_id` = '4' 
0.0064   SELECT *
FROM `site_values`
WHERE `site_id` = '4' 
0.0007   SELECT *
FROM `sites_shelf`
WHERE `site_id` = '4'
AND `shelf_status` = 1
ORDER BY 
`sort_order
0.0009   SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` > 1
ORDER BY 
`nameAS
0.0991   SELECT COUNT(*) AS `numrows`
FROM `books`
WHERE `books`.`category_idIN (8)
AND `
books`.`offshelf` = 'N' 
0.6922   SELECT `books`.`author_id`, `authors`.`name`
FROM `books`
RIGHT JOIN `authorsON `authors`.`author_id` = `books`.`author_id`
WHERE `books`.`category_idIN (8)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`author_id
0.8015   SELECT `books`.`publisher_id`, `publisher`.`name`
FROM `books`
LEFT JOIN `publisherON `publisher`.`publisher_id` = `books`.`publisher_id`
WHERE `books`.`category_idIN (8)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`publisher_id
0.2838   SELECT `books`.`category_id`, `nested_category`.`name_english`
FROM `books`
LEFT JOIN `nested_categoryON `nested_category`.`category_id` = `books`.`category_id`
WHERE `books`.`category_idIN (8)
AND `
books`.`offshelf` = 'N'
GROUP BY `books`.`category_id
0.6799   SELECT `books`.`book_id`, `books`.`title`, `books`.`synopsis`, `books`.`publisher_id`, `publisher`.`name` as `publisher`, `books`.`author_id`, `authors`.`name` as `author`, `books`.`category_id`, `nested_category`.`name_english` as `category`, `nested_category`.`name_english` as `name_english`, `books`.`multicat`, `books`.`s3_cover`, `books`.`filesize`, `books`.`isbn`, `books`.`format`, `books`.`language`, `books`.`sgd_price` as `retail_price`, `books`.`sgd_ori_price` as `ebook_price`, `books`.`tax_rate`
FROM `books`
LEFT JOIN `authorsON `authors`.`author_id` = `books`.`author_id`
LEFT JOIN `publisherON `publisher`.`publisher_id` = `books`.`publisher_id`
LEFT JOIN `nested_categoryON `nested_category`.`category_id` = `books`.`category_id`
WHERE `books`.`category_idIN (8)
AND `
books`.`offshelf` = 'N'
ORDER BY `books`.`languageASC, `book_idDESC
 LIMIT 10 
0.0234   SELECT *
FROM `nested_category`
WHERE `nested_category`.`category_id` = '8'
 
LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)