Notice (8): Undefined variable: sync_device [APP/views/layouts/_default_bootstrap_layout.ctp, line 83]
Notice (8): Undefined variable: overview_page [APP/views/elements/bootstrap_header.ctp, line 2]
?>
Notice (8): Undefined index: HTTP_X_REQUESTED_WITH [APP/views/layouts/_default_bootstrap_layout.ctp, line 96]
(default) 55 queries took 91 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `challenge_team_invites`882
2DESCRIBE `challenge_teams`10101
3DESCRIBE `challenge_teams_users`441
4DESCRIBE `bookings`13131
5DESCRIBE `bookings_users`771
6DESCRIBE `booking_time_durations`331
7DESCRIBE `bookings_booking_time_durations`331
8DESCRIBE `payments`881
9DESCRIBE `filters`441
10DESCRIBE `filter_conditions`661
11DESCRIBE `filters_users`331
12DESCRIBE `catalogues`331
13DESCRIBE `catalogueassigns`331
14DESCRIBE `survey_responses`551
15DESCRIBE `surveys`17171
16DESCRIBE `survey_questions`26261
17DESCRIBE `survey_question_types`221
18DESCRIBE `survey_question_options`10101
19DESCRIBE `survey_survey_questions`331
20DESCRIBE `survey_answers`14141
21DESCRIBE `survey_answers_survey_responses`331
22DESCRIBE `key_performance_goals`10101
23DESCRIBE `key_performance_goal_conditions`10101
24DESCRIBE `survey_metrics`18181
25DESCRIBE `survey_metric_histogram_bins`15151
26DESCRIBE `histogram_bins_templates`551
27DESCRIBE `calculated_metrics`10101
28DESCRIBE `mailchimp_templates`441
29DESCRIBE `scheduled_notifications`10101
30DESCRIBE `survey_recipients`771
31DESCRIBE `report_access`331
32DESCRIBE `challenge_responses`441
33DESCRIBE `challenge_values`443
34DESCRIBE `challenge_parameters`331
35DESCRIBE `diet_participants`882
36DESCRIBE `diet_campaigns`11112
37DESCRIBE `diet_stages`662
38DESCRIBE `diet_options`552
39DESCRIBE `diet_items`22222
40DESCRIBE `diet_cms`662
41DESCRIBE `user_metrics_lists`332
42DESCRIBE `user_profile_changes`882
43DESCRIBE `homework`14141
44DESCRIBE `homework_types`221
45DESCRIBE `user_preferences`13131
46DESCRIBE `goal_metrics`18181
47DESCRIBE `goal_metrics_users`881
48DESCRIBE `gethealth_users`771
49DESCRIBE `challenges_cms_pages`441
50SELECT `SurveyMetric`.`id`, `SurveyMetric`.`name`, `SurveyMetric`.`pretty_name`, `SurveyMetric`.`is_percentile`, `SurveyMetric`.`min_val`, `SurveyMetric`.`max_val`, `SurveyMetric`.`normal_val_min`, `SurveyMetric`.`normal_val_max`, `SurveyMetric`.`unit`, `SurveyMetric`.`order_by`, `SurveyMetric`.`colour`, `SurveyMetric`.`description`, `SurveyMetric`.`demographic_description`, `SurveyMetric`.`graph_type`, `SurveyMetric`.`icon`, `SurveyMetric`.`group_id`, `SurveyMetric`.`hide_metric`, `SurveyMetric`.`hide_metric_dashboard` FROM `survey_metrics` AS `SurveyMetric` WHERE 1 = 1 ORDER BY `group_id` desc, `order_by` asc 1661663
51SELECT `SurveyMetricHistogramBin`.`id`, `SurveyMetricHistogramBin`.`survey_metric_id`, `SurveyMetricHistogramBin`.`name`, `SurveyMetricHistogramBin`.`range_min`, `SurveyMetricHistogramBin`.`range_max`, `SurveyMetricHistogramBin`.`description`, `SurveyMetricHistogramBin`.`personalised_description`, `SurveyMetricHistogramBin`.`demographic_description`, `SurveyMetricHistogramBin`.`accumulated_description`, `SurveyMetricHistogramBin`.`survay_metric_name`, `SurveyMetricHistogramBin`.`colour`, `SurveyMetricHistogramBin`.`is_high_risk`, `SurveyMetricHistogramBin`.`risk_category_id`, `SurveyMetricHistogramBin`.`template_id`, `SurveyMetricHistogramBin`.`eprogram_id` FROM `survey_metric_histogram_bins` AS `SurveyMetricHistogramBin` WHERE `SurveyMetricHistogramBin`.`survey_metric_id` IN (260, 287, 294, 15, 16, 10, 11, 13, 14, 18, 31, 97, 111, 112, 113, 116, 19, 35, 27, 44, 42, 28, 94, 228, 128, 205, 185, 187, 188, 29, 192, 193, 194, 195, 196, 197, 200, 203, 204, 199, 255, 256, 257, 258, 259, 269, 270, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 120, 119, 118, 251, 252, 253, 271, 254, 290, 216, 221, 229, 242, 243, 244, 245, 246, 247, 249, 250, 266, 267, 268, 272, 289, 291, 292, 293, 9, 212, 220, 227, 207, 211, 213, 224, 223, 198, 217, 222, 99, 115, 117, 107, 43, 49, 53, 69, 22, 215, 46, 47, 48, 129, 12, 125, 91, 21, 225, 236, 237, 238, 239, 240, 241, 263, 261, 262, 264, 124, 123, 121, 37, 41, 33, 235, 126, 219, 265, 134, 135, 136, 137, 138, 139, 140, 141, 142, 98, 108, 109, 110, 114, 186, 206, 189, 190, 191, 201, 202, 284, 285, 286, 92, 93, 95, 23, 26) ORDER BY range_min ASC 60260211
52SELECT `HistogramBinsTemplate`.`id`, `HistogramBinsTemplate`.`histogram_bin_id`, `HistogramBinsTemplate`.`upscore_template_id`, `HistogramBinsTemplate`.`downscore_template_id`, `HistogramBinsTemplate`.`samescore_template_id` FROM `histogram_bins_templates` AS `HistogramBinsTemplate` WHERE `HistogramBinsTemplate`.`histogram_bin_id` IN (260, 287, 294, 15, 16, 10, 11, 13, 14, 18, 31, 97, 111, 112, 113, 116, 19, 35, 27, 44, 42, 28, 94, 228, 128, 205, 185, 187, 188, 29, 192, 193, 194, 195, 196, 197, 200, 203, 204, 199, 255, 256, 257, 258, 259, 269, 270, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 120, 119, 118, 251, 252, 253, 271, 254, 290, 216, 221, 229, 242, 243, 244, 245, 246, 247, 249, 250, 266, 267, 268, 272, 289, 291, 292, 293, 9, 212, 220, 227, 207, 211, 213, 224, 223, 198, 217, 222, 99, 115, 117, 107, 43, 49, 53, 69, 22, 215, 46, 47, 48, 129, 12, 125, 91, 21, 225, 236, 237, 238, 239, 240, 241, 263, 261, 262, 264, 124, 123, 121, 37, 41, 33, 235, 126, 219, 265, 134, 135, 136, 137, 138, 139, 140, 141, 142, 98, 108, 109, 110, 114, 186, 206, 189, 190, 191, 201, 202, 284, 285, 286, 92, 93, 95, 23, 26) 47473
53SELECT `SurveyMetric`.`id`, `SurveyMetric`.`name`, `SurveyMetric`.`pretty_name`, `SurveyMetric`.`is_percentile`, `SurveyMetric`.`min_val`, `SurveyMetric`.`max_val`, `SurveyMetric`.`normal_val_min`, `SurveyMetric`.`normal_val_max`, `SurveyMetric`.`unit`, `SurveyMetric`.`order_by`, `SurveyMetric`.`colour`, `SurveyMetric`.`description`, `SurveyMetric`.`demographic_description`, `SurveyMetric`.`graph_type`, `SurveyMetric`.`icon`, `SurveyMetric`.`group_id`, `SurveyMetric`.`hide_metric`, `SurveyMetric`.`hide_metric_dashboard` FROM `survey_metrics` AS `SurveyMetric` WHERE `SurveyMetric`.`hide_metric` = 0 ORDER BY `order_by` asc, `group_id` desc 1541542
54SELECT `SurveyMetricHistogramBin`.`id`, `SurveyMetricHistogramBin`.`survey_metric_id`, `SurveyMetricHistogramBin`.`name`, `SurveyMetricHistogramBin`.`range_min`, `SurveyMetricHistogramBin`.`range_max`, `SurveyMetricHistogramBin`.`description`, `SurveyMetricHistogramBin`.`personalised_description`, `SurveyMetricHistogramBin`.`demographic_description`, `SurveyMetricHistogramBin`.`accumulated_description`, `SurveyMetricHistogramBin`.`survay_metric_name`, `SurveyMetricHistogramBin`.`colour`, `SurveyMetricHistogramBin`.`is_high_risk`, `SurveyMetricHistogramBin`.`risk_category_id`, `SurveyMetricHistogramBin`.`template_id`, `SurveyMetricHistogramBin`.`eprogram_id` FROM `survey_metric_histogram_bins` AS `SurveyMetricHistogramBin` WHERE `SurveyMetricHistogramBin`.`survey_metric_id` IN (260, 287, 294, 255, 256, 257, 258, 259, 269, 270, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 290, 216, 221, 229, 242, 244, 245, 246, 247, 250, 266, 267, 268, 272, 289, 291, 292, 293, 222, 215, 225, 236, 237, 238, 239, 240, 241, 263, 261, 262, 264, 126, 219, 265, 98, 284, 285, 286, 92, 15, 16, 10, 11, 13, 12, 14, 18, 31, 97, 99, 125, 46, 47, 48, 108, 109, 111, 110, 112, 113, 114, 115, 116, 19, 35, 117, 124, 123, 107, 121, 120, 119, 27, 118, 9, 44, 37, 41, 42, 43, 28, 33, 49, 53, 91, 93, 94, 95, 69, 251, 228, 252, 253, 271, 254, 21, 22, 23, 26, 212, 220, 227, 207, 211, 213, 224, 223, 128, 129, 205, 185, 186, 187, 188, 206, 189, 190, 191, 29, 192, 193, 194, 195, 196, 197, 200, 203, 204, 198, 199, 201, 202, 217) ORDER BY range_min ASC 56556510
55SELECT `HistogramBinsTemplate`.`id`, `HistogramBinsTemplate`.`histogram_bin_id`, `HistogramBinsTemplate`.`upscore_template_id`, `HistogramBinsTemplate`.`downscore_template_id`, `HistogramBinsTemplate`.`samescore_template_id` FROM `histogram_bins_templates` AS `HistogramBinsTemplate` WHERE `HistogramBinsTemplate`.`histogram_bin_id` IN (260, 287, 294, 255, 256, 257, 258, 259, 269, 270, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 290, 216, 221, 229, 242, 244, 245, 246, 247, 250, 266, 267, 268, 272, 289, 291, 292, 293, 222, 215, 225, 236, 237, 238, 239, 240, 241, 263, 261, 262, 264, 126, 219, 265, 98, 284, 285, 286, 92, 15, 16, 10, 11, 13, 12, 14, 18, 31, 97, 99, 125, 46, 47, 48, 108, 109, 111, 110, 112, 113, 114, 115, 116, 19, 35, 117, 124, 123, 107, 121, 120, 119, 27, 118, 9, 44, 37, 41, 42, 43, 28, 33, 49, 53, 91, 93, 94, 95, 69, 251, 228, 252, 253, 271, 254, 21, 22, 23, 26, 212, 220, 227, 207, 211, 213, 224, 223, 128, 129, 205, 185, 186, 187, 188, 206, 189, 190, 191, 29, 192, 193, 194, 195, 196, 197, 200, 203, 204, 198, 199, 201, 202, 217) 42422