Kies hieronder een specifieke rubriek indien u de bedrijvenlijst verder wenst te verfijnen
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `bizlist_dbase`.`categories` AS `Category` WHERE 1 = 1 | 6 | 6 | 0 | |
SELECT `Company`.`id`, `Company`.`category_id`, `Company`.`name`, `Company`.`slug`, `Company`.`description`, `Company`.`phone`, `Company`.`email`, `Company`.`website`, `Company`.`street`, `Company`.`nr`, `Company`.`zip`, `Company`.`town`, `Company`.`province`, `Company`.`approved`, `Company`.`site_id`, `Company`.`created`, `Company`.`nofollow`, (CONCAT(`Company`.`street`, " ", `Company`.`nr`)) AS `Company__address`, (CONCAT(`Company`.`zip`, " ", `Company`.`town`)) AS `Company__ziptown` FROM `bizlist_dbase`.`companies` AS `Company` WHERE `Company`.`category_id` IN (1, 2, 3, 4, 5, 6) | 2515 | 2515 | 16 | |
SELECT `Site`.`id` FROM `bizlist_dbase`.`sites` AS `Site` WHERE `url` = 'bizlist.be' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Company`.`id`, `Company`.`category_id`, `Company`.`name`, `Company`.`slug`, `Company`.`description`, `Company`.`phone`, `Company`.`email`, `Company`.`website`, `Company`.`street`, `Company`.`nr`, `Company`.`zip`, `Company`.`town`, `Company`.`province`, `Company`.`approved`, `Company`.`site_id`, `Company`.`created`, `Company`.`nofollow`, (CONCAT(`Company`.`street`, " ", `Company`.`nr`)) AS `Company__address`, (CONCAT(`Company`.`zip`, " ", `Company`.`town`)) AS `Company__ziptown`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Site`.`id`, `Site`.`url`, `Photo`.`id`, `Photo`.`company_id`, `Photo`.`filename` FROM `bizlist_dbase`.`companies` AS `Company` LEFT JOIN `bizlist_dbase`.`categories` AS `Category` ON (`Company`.`category_id` = `Category`.`id`) LEFT JOIN `bizlist_dbase`.`sites` AS `Site` ON (`Company`.`site_id` = `Site`.`id`) LEFT JOIN `bizlist_dbase`.`photos` AS `Photo` ON (`Photo`.`company_id` = `Company`.`id`) WHERE lower(province) = 'antwerpen' AND `site_id` = '' AND `approved` = '1' LIMIT 12 | 4 | 4 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `bizlist_dbase`.`companies` AS `Company` LEFT JOIN `bizlist_dbase`.`categories` AS `Category` ON (`Company`.`category_id` = `Category`.`id`) LEFT JOIN `bizlist_dbase`.`sites` AS `Site` ON (`Company`.`site_id` = `Site`.`id`) LEFT JOIN `bizlist_dbase`.`photos` AS `Photo` ON (`Photo`.`company_id` = `Company`.`id`) WHERE lower(province) = 'antwerpen' AND `site_id` = '' AND `approved` = '1' | 1 | 1 | 2 | maybe slow |
Peak Memory Use 77.55 MB
Message | Memory use |
---|---|
Component initialization | 3.29 MB |
Controller action start | 15.65 MB |
Controller render start | 16.01 MB |
View render complete | 17.24 MB |
Total Request Time: 1070 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 41.33 | |
Event: Controller.initialize | 134.96 | |
Event: Controller.startup | 0.93 | |
Controller action | 13.50 | |
Event: Controller.beforeRender | 421.17 | |
» Processing toolbar data | 420.96 | |
Rendering View | 8.12 | |
» Event: View.beforeRender | 0.07 | |
» Rendering APP/View/Companies/view_province.ctp | 5.78 | |
» » Rendering APP/View/Elements/pagination.ctp | 0.80 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.04 | |
» Rendering APP/View/Layouts/default.ctp | 1.00 | |
Event: View.afterLayout | 0.00 |
.99 to .99 make catching Archie and winning the game easier.