-
- History
- Session
-
Request + –
Request
Cake Params
- controllerinfo
- actionmultiple
- named
- o123
- pass(empty)
- plugin(null)
- form(empty)
- url
- urlinfo/view/o:123
$_GET
- urlinfo/view/o:123
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
- keys
- 0controller
- 1action
- options(empty)
- defaults
- plugin(null)
- actionindex
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
- typecontent_type
- methodrequest_method
- serverserver_name
==== -
Sql Log + –
Sql Logs
default
Query Error Affected Num. rows Took (ms) Actions SHOW FULL COLUMNS FROM `sites5` 32 32 2 maybe slow SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; 1 1 1 SHOW FULL COLUMNS FROM `objectinfo` 27 27 1 SHOW FULL COLUMNS FROM `suppliers` 7 7 1 maybe slow SHOW FULL COLUMNS FROM `users` 7 7 1 maybe slow SHOW FULL COLUMNS FROM `uploaded_xmls` 12 12 1 maybe slow SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; 1 1 1 SHOW FULL COLUMNS FROM `uploaded_xml_data` 26 26 1 SHOW FULL COLUMNS FROM `detaillist` 28 28 1 SHOW FULL COLUMNS FROM `weeks` 4 4 1 maybe slow SHOW FULL COLUMNS FROM `category` 3 3 1 maybe slow SELECT `Week`.`year` FROM `weeks` AS `Week` WHERE `published` = 1 ORDER BY `year` DESC, `week` DESC LIMIT 1 1 1 0 SELECT `Week`.`week` FROM `weeks` AS `Week` WHERE `published` = 1 ORDER BY `year` DESC, `week` DESC LIMIT 1 1 1 0 SELECT `Objectinfo`.`id`, `Objectinfo`.`type`, `Objectinfo`.`parent`, `Objectinfo`.`name`, `Objectinfo`.`category`, `Objectinfo`.`section`, `Objectinfo`.`url`, `Objectinfo`.`information`, `Objectinfo`.`mspec`, `Objectinfo`.`mspec_file`, `Objectinfo`.`supplierid`, `Objectinfo`.`certificationid`, `Objectinfo`.`active`, `Objectinfo`.`mediacode`, `Objectinfo`.`logo`, `Objectinfo`.`site_image`, `Objectinfo`.`embed_link`, `Objectinfo`.`facebook_url`, `Objectinfo`.`twitter_url`, `Objectinfo`.`youtube_url`, `Objectinfo`.`linkedin_url`, `Objectinfo`.`pinterest_url`, `Objectinfo`.`instagram_url`, `Objectinfo`.`profile_id`, `Objectinfo`.`show_time_spent`, `Objectinfo`.`show_referrals`, `Objectinfo`.`show_seal` FROM `objectinfo` AS `Objectinfo` WHERE `id` = 123 LIMIT 1 1 1 0 SELECT `Supplier`.`name` FROM `suppliers` AS `Supplier` WHERE `Supplier`.`id` = 31 LIMIT 1 1 1 1 SELECT * from category AS Categories WHERE (id=3 AND private=0) 1 1 0 SELECT * from objectinfo AS Parent WHERE id=91 OR id=1755 2 2 1 maybe slow SELECT `Site`.`id`, `Site`.`objectid`, `Site`.`name`, `Site`.`type`, `Site`.`supplier`, `Site`.`parent`, `Site`.`category`, `Site`.`section`, `Site`.`logo`, `Site`.`uniquebrowsers`, `Site`.`visits`, `Site`.`pageviews`, `Site`.`uniquebrowsers_mon_fri_avg`, `Site`.`uniquebrowsers_sat_sun_avg`, `Site`.`mon_unique`, `Site`.`tue_unique`, `Site`.`wed_unique`, `Site`.`thu_unique`, `Site`.`fri_unique`, `Site`.`sat_unique`, `Site`.`sun_unique`, `Site`.`ref_social`, `Site`.`ref_search`, `Site`.`ref_direct`, `Site`.`ref_other`, `Site`.`time_spent`, `Site`.`weeklychange`, `Site`.`year`, `Site`.`week`, `Site`.`mark`, `Site`.`mediacode`, `Site`.`comment`, `Objectinfo`.`id`, `Objectinfo`.`type`, `Objectinfo`.`parent`, `Objectinfo`.`name`, `Objectinfo`.`category`, `Objectinfo`.`section`, `Objectinfo`.`url`, `Objectinfo`.`information`, `Objectinfo`.`mspec`, `Objectinfo`.`mspec_file`, `Objectinfo`.`supplierid`, `Objectinfo`.`certificationid`, `Objectinfo`.`active`, `Objectinfo`.`mediacode`, `Objectinfo`.`logo`, `Objectinfo`.`site_image`, `Objectinfo`.`embed_link`, `Objectinfo`.`facebook_url`, `Objectinfo`.`twitter_url`, `Objectinfo`.`youtube_url`, `Objectinfo`.`linkedin_url`, `Objectinfo`.`pinterest_url`, `Objectinfo`.`instagram_url`, `Objectinfo`.`profile_id`, `Objectinfo`.`show_time_spent`, `Objectinfo`.`show_referrals`, `Objectinfo`.`show_seal` FROM `sites5` AS `Site` LEFT JOIN `objectinfo` AS `Objectinfo` ON (`Site`.`objectid` = `Objectinfo`.`id`) WHERE `Site`.`id` = 123 AND CONCAT(`Site`.`year`, LPAD(`Site`.`week`, 2, '0')) <= '202416' ORDER BY `Site`.`year` DESC, `Site`.`week` DESC LIMIT 20 20 20 7 maybe slow Query Explain:
==== -
Timer + –
Memory
Peak Memory Use 10.84 MB
Message Memory use Component intitailization 6.69 MB Controller action start 6.74 MB Controller render start 7.33 MB View render complete 10.59 MB Timers
Total Request Time: 303 (ms)
Message Time in ms Graph Core Processing (Derived) 126.83 Component initialization and startup 3.46 Controller action 44.32 Render Controller Action 94.73 » Rendering View 92.87 » » Rendering APP/views/info/view.ctp 89.49 » » » Rendering APP/views/elements/showinfo_datatypelinks.ctp 0.69 » » Rendering APP/views/layouts/default.ctp 2.70 » » » Rendering APP/views/elements/backend/menu.ctp 0.64 ==== - Log