sdilshod · December 7, 2016 04:12 · sdilshod · Dec 7, 2016
diff --git a/development.log b/development.log
 Connecting to database specified by database.yml


 Started GET "/prices/453" for 127.0.0.1 at 2016-12-07 09:10:21 +0500
 Processing by PricesController#show as HTML
  Parameters: {"id"=>"453"}
  [1m[36mUser Load (1.4ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1[0m
  [1m[35mUserNotificationSettings Load (0.8ms)[0m  SELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1
  [1m[36m (0.3ms)[0m  [1mBEGIN[0m
  [1m[35m (0.9ms)[0m  UPDATE "users" SET "last_request_at" = '2016-12-07 04:10:23.170675', "perishable_token" = 'CAggBqQNP2EtTSygZNh', "updated_at" = '2016-12-07 04:10:23.173854' WHERE "users"."id" = 1
 [paperclip] Saving attachments.
  [1m[36m (13.0ms)[0m  [1mCOMMIT[0m
  [1m[35mUserRole Load (1.3ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mPrice Load (2.6ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = $1 LIMIT 1[0m  [["id", "453"]]
 Creating scope :region_type. Overwriting existing method Region.region_type.
  [1m[35mRegion Load (2.0ms)[0m  SELECT "regions".* FROM "regions" WHERE "regions"."id" = 28 ORDER BY "regions"."position" LIMIT 1
  [1m[36mUserRole Load (0.6ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" WHERE "user_roles"."custom" = 't'[0m
  [1m[35mCustomer Load (3.0ms)[0m  SELECT "customers".* FROM "customers" WHERE "customers"."id" = 4515 LIMIT 1
  [1m[36mCustomer Load (190.8ms)[0m  [1mSELECT "customers".* FROM "customers" WHERE "customers"."region_id" IN (SELECT "regions"."id" FROM "regions" WHERE (region_type = 'subdivision' or "default" = 't') ORDER BY "regions"."position")[0m
  [1m[35mPrice Load (9.6ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."customer_id" IN (5116, 5106, 5114, 5088, 5108, 4325, 4344, 4933, 5014, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 4938, 3531, 3598, 3631, 4164, 3704, 282, 296, 5082, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 5080, 4199, 4200, 4203, 4204, 4205, 4511, 4336, 4526, 4860, 5091, 4980, 5026, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4962, 5084, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 4812, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4515, 4510, 4513, 4512, 4524, 4499, 4394, 5078, 4396, 2980, 277, 2566, 4131, 4523, 5083, 4397, 4398, 4399, 5086, 5090, 5089, 5098, 4808, 4809, 4810, 4811, 4224, 4821, 4813, 4814, 5094, 4815, 4826, 4816, 4829, 4830, 4817, 4818, 4820, 4819, 279, 4822, 4823, 4824, 4825, 4827, 4828, 4831, 4832, 4833, 4834, 4835, 4836, 4837, 4838, 4839, 4840, 4841, 4842, 4843, 4844, 4845, 4846, 4847, 4848, 5020, 4849, 4850, 4852, 4854, 4853, 4855, 4856, 4857, 4859, 4861, 4862, 4912, 4863, 4877, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4872, 4873, 4874, 4875, 4876, 4878, 4879, 4880, 4881, 4906, 4882, 4884, 4885, 4886, 4896, 4887, 4888, 4925, 4889, 4890, 4891, 4892, 4893, 4894, 4851, 4897, 4898, 4899, 4900, 4901, 4902, 4904, 4905, 4907, 4908, 4909, 4910, 4911, 4913, 4926, 4914, 4915, 4916, 4917, 4918, 4919, 4920, 4921, 4922, 4923, 4924, 4927, 4928, 4929, 4930, 4931, 4932, 4934, 4935, 4949, 4936, 4937, 4939, 4940, 4941, 4942, 4943, 4945, 4946, 4947, 4948, 4950, 5011, 4951, 4952, 4953, 4976, 4128, 4954, 4955, 4944, 4956, 4958, 4957, 4959, 4960, 4961, 4963, 4964, 4967, 4966, 4968, 4969, 4970, 4971, 4972, 4973, 4974, 5076, 4975, 4977, 4978, 4979, 4981, 4982, 4984, 4983, 4985, 4986, 4987, 4988, 5009, 2528, 4990, 4991, 4992, 4993, 4994, 4995, 4225, 4996, 4997, 5010, 4999, 4998, 5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5012, 5013, 5015, 5016, 5017, 5019, 5018, 5021, 5022, 5023, 5024, 5025, 5027, 5028, 5029, 5030, 4226, 5031, 5032, 5033, 5034, 5035, 4460, 5036, 5037, 4965, 5038, 5039, 5040, 5041, 5042, 5043, 5044, 5045, 5046, 5047, 5048, 5049, 5050, 2573, 5051, 5052, 5053, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064, 5065, 5066, 5067, 5068, 5069, 5070, 5071, 5072, 4227, 5073, 266, 5074, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4521, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 4858, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 4531, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5117, 5125, 5113, 5099, 4504, 5103, 5119, 5107, 5127, 163, 5096, 5123, 5126, 261, 5095, 5120, 4517, 4514, 4516, 4519, 4520, 308, 5121, 5122, 5112, 5100, 5132, 5130, 5129, 5097, 5133, 5131, 5134, 5093, 5135, 5136, 5137, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 5141, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5092, 5102, 5138, 5139, 5140, 5142, 1, 5143, 5144, 5145, 5124, 5147, 5146, 4530, 5148, 5149, 5150, 5151, 5152) AND "prices"."id" = $1 LIMIT 1  [["id", "453"]]
  Rendered shared/_page_header.html.haml (3.7ms)
  [1m[36mLoadConfiguration Load (0.7ms)[0m  [1mSELECT "load_configurations".* FROM "load_configurations" WHERE "load_configurations"."load_config_owner_id" = 453 AND "load_configurations"."load_config_owner_type" = 'Price' LIMIT 1[0m
  Rendered prices/_load_form.html.haml (50.3ms)
  [1m[35mLog Load (0.9ms)[0m  SELECT "logs".* FROM "logs" WHERE "logs"."log_owner_id" = 453 AND "logs"."log_owner_type" = 'Price'
  [1m[36mLog Load (1.0ms)[0m  [1mSELECT "logs".* FROM "logs" WHERE "logs"."log_owner_id" = 453 AND "logs"."log_owner_type" = 'Price' ORDER BY id desc LIMIT 7[0m
  Rendered logs/_log_list.html.haml (164.3ms)
  [1m[35m (1.5ms)[0m  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "price_items" WHERE "price_items"."price_id" = 453 LIMIT 200) subquery_for_count 
  [1m[36mPriceItem Load (1.3ms)[0m  [1mSELECT "price_items".* FROM "price_items" WHERE "price_items"."price_id" = 453 LIMIT 200[0m
  [1m[35mPrice Load (1.1ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (12.9ms)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1[0m
  Rendered prices/_price_item.html.haml (3.2ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (3.0ms)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1[0m
  Rendered prices/_price_item.html.haml (3.0ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (3.0ms)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1[0m
  Rendered prices/_price_item.html.haml (3.1ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (3.4ms)
  Rendered prices/_prices.html.haml (93.6ms)
  Rendered prices/show.html.haml within layouts/application (378.5ms)
  [1m[36mCatalogType Load (0.7ms)[0m  [1mSELECT "catalog_types".* FROM "catalog_types" [0m
  [1m[35mUser Load (1.2ms)[0m  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
  [1m[36mUserNotificationSettings Load (0.6ms)[0m  [1mSELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mCustomer Load (67.4ms)[0m  [1mSELECT "customers".* FROM "customers" WHERE (user_id = 1 or (user_id is null and region_id = 28))[0m
  [1m[35m (0.3ms)[0m  SHOW max_identifier_length
  [1m[36m (14.0ms)[0m  [1mSELECT COUNT(*) AS count_all, dialogs.id AS dialogs_id FROM "dialogs" INNER JOIN "messages" ON "messages"."dialog_id" = "dialogs"."id" WHERE "dialogs"."customer_id" IN (5116, 303, 306, 4325, 4344, 4933, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 3531, 3598, 3631, 4164, 3704, 282, 296, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 4199, 4200, 4203, 4204, 4205, 4336, 4526, 5091, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4510, 4512, 4524, 4499, 4394, 4396, 2980, 277, 2566, 4131, 5083, 4397, 4398, 4399, 5089, 4809, 4811, 4224, 4821, 4813, 4815, 4829, 4817, 4819, 279, 4823, 4825, 4827, 4831, 4833, 4835, 4837, 4839, 4841, 4843, 4845, 4847, 4849, 4853, 4855, 4857, 4859, 4861, 4863, 4877, 4865, 4867, 4869, 4873, 4875, 4879, 4881, 4885, 4887, 4925, 4889, 4891, 4893, 4851, 4897, 4899, 4901, 4905, 4907, 4909, 4911, 4913, 4915, 4917, 4919, 4921, 4923, 4927, 4929, 4931, 4935, 4949, 4937, 4939, 4941, 4943, 4945, 4947, 5011, 4951, 4953, 4128, 4955, 4957, 4959, 4961, 4963, 4967, 4969, 4971, 4973, 4975, 4977, 4979, 4981, 4983, 4985, 4987, 5009, 2528, 4991, 4993, 4995, 4225, 4997, 4999, 5001, 5003, 5005, 5007, 5013, 5015, 5017, 5019, 5021, 5023, 5025, 5027, 5029, 4226, 5031, 5033, 5035, 4460, 5037, 4965, 5039, 5041, 5043, 5045, 5047, 5049, 2573, 5051, 5053, 5055, 5057, 5059, 5061, 5063, 5065, 5067, 5069, 5071, 4227, 5073, 266, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5113, 5099, 4504, 5103, 163, 5126, 261, 5095, 5120, 4514, 4516, 4520, 308, 5122, 5132, 5130, 5097, 5134, 5093, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5138, 5140, 5142, 1, 5144, 5124, 5146, 5148, 5150, 5152) AND (messages.read_by_manager = false) GROUP BY dialogs.id[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "customers".* FROM "customers" WHERE (user_id = 1 or (user_id is null and region_id = 28))[0m
  [1m[35m (12.4ms)[0m  SELECT COUNT(*) AS count_all, dialogs.id AS dialogs_id FROM "dialogs" INNER JOIN "messages" ON "messages"."dialog_id" = "dialogs"."id" WHERE (("dialogs"."customer_id" IN (5116, 303, 306, 4325, 4344, 4933, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 3531, 3598, 3631, 4164, 3704, 282, 296, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 4199, 4200, 4203, 4204, 4205, 4336, 4526, 5091, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4510, 4512, 4524, 4499, 4394, 4396, 2980, 277, 2566, 4131, 5083, 4397, 4398, 4399, 5089, 4809, 4811, 4224, 4821, 4813, 4815, 4829, 4817, 4819, 279, 4823, 4825, 4827, 4831, 4833, 4835, 4837, 4839, 4841, 4843, 4845, 4847, 4849, 4853, 4855, 4857, 4859, 4861, 4863, 4877, 4865, 4867, 4869, 4873, 4875, 4879, 4881, 4885, 4887, 4925, 4889, 4891, 4893, 4851, 4897, 4899, 4901, 4905, 4907, 4909, 4911, 4913, 4915, 4917, 4919, 4921, 4923, 4927, 4929, 4931, 4935, 4949, 4937, 4939, 4941, 4943, 4945, 4947, 5011, 4951, 4953, 4128, 4955, 4957, 4959, 4961, 4963, 4967, 4969, 4971, 4973, 4975, 4977, 4979, 4981, 4983, 4985, 4987, 5009, 2528, 4991, 4993, 4995, 4225, 4997, 4999, 5001, 5003, 5005, 5007, 5013, 5015, 5017, 5019, 5021, 5023, 5025, 5027, 5029, 4226, 5031, 5033, 5035, 4460, 5037, 4965, 5039, 5041, 5043, 5045, 5047, 5049, 2573, 5051, 5053, 5055, 5057, 5059, 5061, 5063, 5065, 5067, 5069, 5071, 4227, 5073, 266, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5113, 5099, 4504, 5103, 163, 5126, 261, 5095, 5120, 4514, 4516, 4520, 308, 5122, 5132, 5130, 5097, 5134, 5093, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5138, 5140, 5142, 1, 5144, 5124, 5146, 5148, 5150, 5152) AND "dialogs"."subject_type" = 'OrderItem')) AND (messages.read_by_manager = false) GROUP BY dialogs.id
  [1m[36mCatalogAccess::Base Load (0.6ms)[0m  [1mSELECT "catalog_access".* FROM "catalog_access" LIMIT 1[0m
  [1m[35mSiteConfig Load (1.0ms)[0m  SELECT "site_configs".* FROM "site_configs" LIMIT 1
 Completed 200 OK in 14278ms (Views: 8531.0ms | ActiveRecord: 384.4ms)


 Started GET "/prices/453" for 127.0.0.1 at 2016-12-07 09:10:36 +0500
 Processing by PricesController#show as HTML
  Parameters: {"id"=>"453"}
  [1m[36mUser Load (0.6ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1[0m
  [1m[35mUserNotificationSettings Load (0.6ms)[0m  SELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1
  [1m[36m (0.2ms)[0m  [1mBEGIN[0m
  [1m[35m (0.5ms)[0m  UPDATE "users" SET "last_request_at" = '2016-12-07 04:10:36.982641', "perishable_token" = 'WKmX8LNnVQTlhKCZA3D9', "updated_at" = '2016-12-07 04:10:36.984537' WHERE "users"."id" = 1
 [paperclip] Saving attachments.
  [1m[36m (14.4ms)[0m  [1mCOMMIT[0m
  [1m[35mUserRole Load (0.7ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mPrice Load (0.9ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = $1 LIMIT 1[0m  [["id", "453"]]
  [1m[35mRegion Load (0.7ms)[0m  SELECT "regions".* FROM "regions" WHERE "regions"."id" = 28 ORDER BY "regions"."position" LIMIT 1
  [1m[36mUserRole Load (1.1ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" WHERE "user_roles"."custom" = 't'[0m
  [1m[35mCustomer Load (0.8ms)[0m  SELECT "customers".* FROM "customers" WHERE "customers"."id" = 4515 LIMIT 1
  [1m[36mCustomer Load (276.7ms)[0m  [1mSELECT "customers".* FROM "customers" WHERE "customers"."region_id" IN (SELECT "regions"."id" FROM "regions" WHERE (region_type = 'subdivision' or "default" = 't') ORDER BY "regions"."position")[0m
  [1m[35mPrice Load (5.2ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."customer_id" IN (5116, 5106, 5114, 5088, 5108, 4325, 4344, 4933, 5014, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 4938, 3531, 3598, 3631, 4164, 3704, 282, 296, 5082, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 5080, 4199, 4200, 4203, 4204, 4205, 4511, 4336, 4526, 4860, 5091, 4980, 5026, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4962, 5084, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 4812, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4515, 4510, 4513, 4512, 4524, 4499, 4394, 5078, 4396, 2980, 277, 2566, 4131, 4523, 5083, 4397, 4398, 4399, 5086, 5090, 5089, 5098, 4808, 4809, 4810, 4811, 4224, 4821, 4813, 4814, 5094, 4815, 4826, 4816, 4829, 4830, 4817, 4818, 4820, 4819, 279, 4822, 4823, 4824, 4825, 4827, 4828, 4831, 4832, 4833, 4834, 4835, 4836, 4837, 4838, 4839, 4840, 4841, 4842, 4843, 4844, 4845, 4846, 4847, 4848, 5020, 4849, 4850, 4852, 4854, 4853, 4855, 4856, 4857, 4859, 4861, 4862, 4912, 4863, 4877, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4872, 4873, 4874, 4875, 4876, 4878, 4879, 4880, 4881, 4906, 4882, 4884, 4885, 4886, 4896, 4887, 4888, 4925, 4889, 4890, 4891, 4892, 4893, 4894, 4851, 4897, 4898, 4899, 4900, 4901, 4902, 4904, 4905, 4907, 4908, 4909, 4910, 4911, 4913, 4926, 4914, 4915, 4916, 4917, 4918, 4919, 4920, 4921, 4922, 4923, 4924, 4927, 4928, 4929, 4930, 4931, 4932, 4934, 4935, 4949, 4936, 4937, 4939, 4940, 4941, 4942, 4943, 4945, 4946, 4947, 4948, 4950, 5011, 4951, 4952, 4953, 4976, 4128, 4954, 4955, 4944, 4956, 4958, 4957, 4959, 4960, 4961, 4963, 4964, 4967, 4966, 4968, 4969, 4970, 4971, 4972, 4973, 4974, 5076, 4975, 4977, 4978, 4979, 4981, 4982, 4984, 4983, 4985, 4986, 4987, 4988, 5009, 2528, 4990, 4991, 4992, 4993, 4994, 4995, 4225, 4996, 4997, 5010, 4999, 4998, 5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5012, 5013, 5015, 5016, 5017, 5019, 5018, 5021, 5022, 5023, 5024, 5025, 5027, 5028, 5029, 5030, 4226, 5031, 5032, 5033, 5034, 5035, 4460, 5036, 5037, 4965, 5038, 5039, 5040, 5041, 5042, 5043, 5044, 5045, 5046, 5047, 5048, 5049, 5050, 2573, 5051, 5052, 5053, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064, 5065, 5066, 5067, 5068, 5069, 5070, 5071, 5072, 4227, 5073, 266, 5074, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4521, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 4858, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 4531, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5117, 5125, 5113, 5099, 4504, 5103, 5119, 5107, 5127, 163, 5096, 5123, 5126, 261, 5095, 5120, 4517, 4514, 4516, 4519, 4520, 308, 5121, 5122, 5112, 5100, 5132, 5130, 5129, 5097, 5133, 5131, 5134, 5093, 5135, 5136, 5137, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 5141, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5092, 5102, 5138, 5139, 5140, 5142, 1, 5143, 5144, 5145, 5124, 5147, 5146, 4530, 5148, 5149, 5150, 5151, 5152) AND "prices"."id" = $1 LIMIT 1  [["id", "453"]]
  Rendered shared/_page_header.html.haml (1.1ms)
  [1m[36mLoadConfiguration Load (0.5ms)[0m  [1mSELECT "load_configurations".* FROM "load_configurations" WHERE "load_configurations"."load_config_owner_id" = 453 AND "load_configurations"."load_config_owner_type" = 'Price' LIMIT 1[0m
  Rendered prices/_load_form.html.haml (9.9ms)
  [1m[35mLog Load (0.6ms)[0m  SELECT "logs".* FROM "logs" WHERE "logs"."log_owner_id" = 453 AND "logs"."log_owner_type" = 'Price'
  [1m[36mLog Load (0.8ms)[0m  [1mSELECT "logs".* FROM "logs" WHERE "logs"."log_owner_id" = 453 AND "logs"."log_owner_type" = 'Price' ORDER BY id desc LIMIT 7[0m
  Rendered logs/_log_list.html.haml (10.1ms)
  [1m[35m (0.7ms)[0m  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "price_items" WHERE "price_items"."price_id" = 453 LIMIT 200) subquery_for_count 
  [1m[36mPriceItem Load (1.1ms)[0m  [1mSELECT "price_items".* FROM "price_items" WHERE "price_items"."price_id" = 453 LIMIT 200[0m
  [1m[35mPrice Load (1.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (5.3ms)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1[0m
  Rendered prices/_price_item.html.haml (3.5ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (3.4ms)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1[0m
  Rendered prices/_price_item.html.haml (3.0ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (2.9ms)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1[0m
  Rendered prices/_price_item.html.haml (3.1ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT "prices".* FROM "prices" WHERE "prices"."id" = 453 LIMIT 1
  Rendered prices/_price_item.html.haml (3.2ms)
  Rendered prices/_prices.html.haml (35.6ms)
  Rendered prices/show.html.haml within layouts/application (222.1ms)
  [1m[36mCatalogType Load (0.5ms)[0m  [1mSELECT "catalog_types".* FROM "catalog_types" [0m
  [1m[35mUser Load (0.8ms)[0m  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
  [1m[36mUserNotificationSettings Load (0.6ms)[0m  [1mSELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mCustomer Load (73.2ms)[0m  [1mSELECT "customers".* FROM "customers" WHERE (user_id = 1 or (user_id is null and region_id = 28))[0m
  [1m[35m (10.1ms)[0m  SELECT COUNT(*) AS count_all, dialogs.id AS dialogs_id FROM "dialogs" INNER JOIN "messages" ON "messages"."dialog_id" = "dialogs"."id" WHERE "dialogs"."customer_id" IN (5116, 303, 306, 4325, 4344, 4933, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 3531, 3598, 3631, 4164, 3704, 282, 296, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 4199, 4200, 4203, 4204, 4205, 4336, 4526, 5091, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4510, 4512, 4524, 4499, 4394, 4396, 2980, 277, 2566, 4131, 5083, 4397, 4398, 4399, 5089, 4809, 4811, 4224, 4821, 4813, 4815, 4829, 4817, 4819, 279, 4823, 4825, 4827, 4831, 4833, 4835, 4837, 4839, 4841, 4843, 4845, 4847, 4849, 4853, 4855, 4857, 4859, 4861, 4863, 4877, 4865, 4867, 4869, 4873, 4875, 4879, 4881, 4885, 4887, 4925, 4889, 4891, 4893, 4851, 4897, 4899, 4901, 4905, 4907, 4909, 4911, 4913, 4915, 4917, 4919, 4921, 4923, 4927, 4929, 4931, 4935, 4949, 4937, 4939, 4941, 4943, 4945, 4947, 5011, 4951, 4953, 4128, 4955, 4957, 4959, 4961, 4963, 4967, 4969, 4971, 4973, 4975, 4977, 4979, 4981, 4983, 4985, 4987, 5009, 2528, 4991, 4993, 4995, 4225, 4997, 4999, 5001, 5003, 5005, 5007, 5013, 5015, 5017, 5019, 5021, 5023, 5025, 5027, 5029, 4226, 5031, 5033, 5035, 4460, 5037, 4965, 5039, 5041, 5043, 5045, 5047, 5049, 2573, 5051, 5053, 5055, 5057, 5059, 5061, 5063, 5065, 5067, 5069, 5071, 4227, 5073, 266, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5113, 5099, 4504, 5103, 163, 5126, 261, 5095, 5120, 4514, 4516, 4520, 308, 5122, 5132, 5130, 5097, 5134, 5093, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5138, 5140, 5142, 1, 5144, 5124, 5146, 5148, 5150, 5152) AND (messages.read_by_manager = false) GROUP BY dialogs.id
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1[0m  [["id", 1]]
  [1m[35mCACHE (0.0ms)[0m  SELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "customers".* FROM "customers" WHERE (user_id = 1 or (user_id is null and region_id = 28))
  [1m[36m (13.0ms)[0m  [1mSELECT COUNT(*) AS count_all, dialogs.id AS dialogs_id FROM "dialogs" INNER JOIN "messages" ON "messages"."dialog_id" = "dialogs"."id" WHERE (("dialogs"."customer_id" IN (5116, 303, 306, 4325, 4344, 4933, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 3531, 3598, 3631, 4164, 3704, 282, 296, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 4199, 4200, 4203, 4204, 4205, 4336, 4526, 5091, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4510, 4512, 4524, 4499, 4394, 4396, 2980, 277, 2566, 4131, 5083, 4397, 4398, 4399, 5089, 4809, 4811, 4224, 4821, 4813, 4815, 4829, 4817, 4819, 279, 4823, 4825, 4827, 4831, 4833, 4835, 4837, 4839, 4841, 4843, 4845, 4847, 4849, 4853, 4855, 4857, 4859, 4861, 4863, 4877, 4865, 4867, 4869, 4873, 4875, 4879, 4881, 4885, 4887, 4925, 4889, 4891, 4893, 4851, 4897, 4899, 4901, 4905, 4907, 4909, 4911, 4913, 4915, 4917, 4919, 4921, 4923, 4927, 4929, 4931, 4935, 4949, 4937, 4939, 4941, 4943, 4945, 4947, 5011, 4951, 4953, 4128, 4955, 4957, 4959, 4961, 4963, 4967, 4969, 4971, 4973, 4975, 4977, 4979, 4981, 4983, 4985, 4987, 5009, 2528, 4991, 4993, 4995, 4225, 4997, 4999, 5001, 5003, 5005, 5007, 5013, 5015, 5017, 5019, 5021, 5023, 5025, 5027, 5029, 4226, 5031, 5033, 5035, 4460, 5037, 4965, 5039, 5041, 5043, 5045, 5047, 5049, 2573, 5051, 5053, 5055, 5057, 5059, 5061, 5063, 5065, 5067, 5069, 5071, 4227, 5073, 266, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5113, 5099, 4504, 5103, 163, 5126, 261, 5095, 5120, 4514, 4516, 4520, 308, 5122, 5132, 5130, 5097, 5134, 5093, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5138, 5140, 5142, 1, 5144, 5124, 5146, 5148, 5150, 5152) AND "dialogs"."subject_type" = 'OrderItem')) AND (messages.read_by_manager = false) GROUP BY dialogs.id[0m
  [1m[35mCatalogAccess::Base Load (0.4ms)[0m  SELECT "catalog_access".* FROM "catalog_access" LIMIT 1
  [1m[36mSiteConfig Load (0.9ms)[0m  [1mSELECT "site_configs".* FROM "site_configs" LIMIT 1[0m
 Completed 200 OK in 5582ms (Views: 4476.0ms | ActiveRecord: 406.6ms)


 Started GET "/user_notifications/pop" for 127.0.0.1 at 2016-12-07 09:10:52 +0500
 Processing by UserNotificationsController#pop as JSON
  [1m[35mUser Load (0.6ms)[0m  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  [1m[36mUserNotificationSettings Load (0.5ms)[0m  [1mSELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1[0m
  [1m[35m (0.3ms)[0m  BEGIN
  [1m[36m (0.5ms)[0m  [1mUPDATE "users" SET "last_request_at" = '2016-12-07 04:10:53.197209', "perishable_token" = 'LnwgM5S2a5lDIy0CMIru', "updated_at" = '2016-12-07 04:10:53.199177' WHERE "users"."id" = 1[0m
 [paperclip] Saving attachments.
  [1m[35m (6.6ms)[0m  COMMIT
  [1m[36mUserRole Load (0.8ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1[0m
  [1m[35mUserNotification Load (0.8ms)[0m  SELECT "user_notifications".* FROM "user_notifications" WHERE "user_notifications"."user_id" = 1 AND "user_notifications"."viewed" = 'f' LIMIT 1
  Rendered text template (0.0ms)
 Completed 404 Not Found in 57ms (Views: 10.1ms | ActiveRecord: 12.9ms)


 Started GET "/prices/453/visible_zones" for 127.0.0.1 at 2016-12-07 09:11:27 +0500
 Processing by PricesController#visible_zones as */*
  Parameters: {"id"=>"453"}
  [1m[36mUser Load (0.7ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1[0m
  [1m[35mUserNotificationSettings Load (0.5ms)[0m  SELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1
  [1m[36m (0.2ms)[0m  [1mBEGIN[0m
  [1m[35m (0.5ms)[0m  UPDATE "users" SET "last_request_at" = '2016-12-07 04:11:27.882409', "perishable_token" = 'OGAxKQUIeF8n0ERAIk3G', "updated_at" = '2016-12-07 04:11:27.884588' WHERE "users"."id" = 1
 [paperclip] Saving attachments.
  [1m[36m (14.1ms)[0m  [1mCOMMIT[0m
  [1m[35mUserRole Load (0.8ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mPrice Load (0.9ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = $1 LIMIT 1[0m  [["id", "453"]]
  [1m[35mRegion Load (0.7ms)[0m  SELECT "regions".* FROM "regions" WHERE "regions"."id" = 28 ORDER BY "regions"."position" LIMIT 1
  [1m[36mUserRole Load (0.5ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" WHERE "user_roles"."custom" = 't'[0m
  [1m[35mCustomer Load (0.8ms)[0m  SELECT "customers".* FROM "customers" WHERE "customers"."id" = 4515 LIMIT 1
  [1m[36mVisibleZone Load (37.2ms)[0m  [1mSELECT "visible_zones".* FROM "visible_zones" [0m
  [1m[35mPriceVisibleZone Load (38.9ms)[0m  SELECT "price_visible_zones".* FROM "price_visible_zones" WHERE "price_visible_zones"."price_id" = 453
  Rendered prices/visible_zones.html.haml (172.8ms)
 Completed 200 OK in 396ms (Views: 81.8ms | ActiveRecord: 130.0ms)


 Started GET "/prices/453/price_stat_logs" for 127.0.0.1 at 2016-12-07 09:11:35 +0500
 Processing by PriceStatLogsController#index as HTML
  Parameters: {"price_id"=>"453"}
  [1m[36mUser Load (0.8ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1[0m
  [1m[35mUserNotificationSettings Load (0.6ms)[0m  SELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1
  [1m[36m (0.2ms)[0m  [1mBEGIN[0m
  [1m[35m (0.6ms)[0m  UPDATE "users" SET "last_request_at" = '2016-12-07 04:11:35.873327', "perishable_token" = '5zeBCaXuX277BTX44cZM', "updated_at" = '2016-12-07 04:11:35.875044' WHERE "users"."id" = 1
 [paperclip] Saving attachments.
  [1m[36m (16.8ms)[0m  [1mCOMMIT[0m
  [1m[35mUserRole Load (1.0ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mPrice Load (0.9ms)[0m  [1mSELECT "prices".* FROM "prices" WHERE "prices"."id" = $1 LIMIT 1[0m  [["id", "453"]]
  [1m[35mPriceStatLog Load (6.5ms)[0m  SELECT stat_date, stat_group FROM "price_stat_logs" WHERE "price_stat_logs"."price_id" = 453 ORDER BY stat_date desc LIMIT 30 OFFSET 0
  Rendered shared/_page_header.html.haml (0.8ms)
  Rendered price_stat_logs/index.html.haml within layouts/application (9.1ms)
  [1m[36mCatalogType Load (0.7ms)[0m  [1mSELECT "catalog_types".* FROM "catalog_types" [0m
  [1m[35mUser Load (0.8ms)[0m  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
  [1m[36mUserNotificationSettings Load (0.6ms)[0m  [1mSELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1
  [1m[36mCustomer Load (210.6ms)[0m  [1mSELECT "customers".* FROM "customers" WHERE (user_id = 1 or (user_id is null and region_id = 28))[0m
  [1m[35m (9.6ms)[0m  SELECT COUNT(*) AS count_all, dialogs.id AS dialogs_id FROM "dialogs" INNER JOIN "messages" ON "messages"."dialog_id" = "dialogs"."id" WHERE "dialogs"."customer_id" IN (5116, 303, 306, 4325, 4344, 4933, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 3531, 3598, 3631, 4164, 3704, 282, 296, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 4199, 4200, 4203, 4204, 4205, 4336, 4526, 5091, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4510, 4512, 4524, 4499, 4394, 4396, 2980, 277, 2566, 4131, 5083, 4397, 4398, 4399, 5089, 4809, 4811, 4224, 4821, 4813, 4815, 4829, 4817, 4819, 279, 4823, 4825, 4827, 4831, 4833, 4835, 4837, 4839, 4841, 4843, 4845, 4847, 4849, 4853, 4855, 4857, 4859, 4861, 4863, 4877, 4865, 4867, 4869, 4873, 4875, 4879, 4881, 4885, 4887, 4925, 4889, 4891, 4893, 4851, 4897, 4899, 4901, 4905, 4907, 4909, 4911, 4913, 4915, 4917, 4919, 4921, 4923, 4927, 4929, 4931, 4935, 4949, 4937, 4939, 4941, 4943, 4945, 4947, 5011, 4951, 4953, 4128, 4955, 4957, 4959, 4961, 4963, 4967, 4969, 4971, 4973, 4975, 4977, 4979, 4981, 4983, 4985, 4987, 5009, 2528, 4991, 4993, 4995, 4225, 4997, 4999, 5001, 5003, 5005, 5007, 5013, 5015, 5017, 5019, 5021, 5023, 5025, 5027, 5029, 4226, 5031, 5033, 5035, 4460, 5037, 4965, 5039, 5041, 5043, 5045, 5047, 5049, 2573, 5051, 5053, 5055, 5057, 5059, 5061, 5063, 5065, 5067, 5069, 5071, 4227, 5073, 266, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5113, 5099, 4504, 5103, 163, 5126, 261, 5095, 5120, 4514, 4516, 4520, 308, 5122, 5132, 5130, 5097, 5134, 5093, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5138, 5140, 5142, 1, 5144, 5124, 5146, 5148, 5150, 5152) AND (messages.read_by_manager = false) GROUP BY dialogs.id
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1[0m  [["id", 1]]
  [1m[35mCACHE (0.0ms)[0m  SELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "customers".* FROM "customers" WHERE (user_id = 1 or (user_id is null and region_id = 28))
  [1m[36m (13.7ms)[0m  [1mSELECT COUNT(*) AS count_all, dialogs.id AS dialogs_id FROM "dialogs" INNER JOIN "messages" ON "messages"."dialog_id" = "dialogs"."id" WHERE (("dialogs"."customer_id" IN (5116, 303, 306, 4325, 4344, 4933, 272, 2733, 2621, 2810, 2840, 2876, 2973, 3664, 3666, 3531, 3598, 3631, 4164, 3704, 282, 296, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4166, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4114, 4115, 4186, 4189, 4190, 4191, 4192, 4193, 4194, 4195, 4176, 4178, 4196, 4197, 4198, 4199, 4200, 4203, 4204, 4205, 4336, 4526, 5091, 2596, 2604, 2614, 2765, 2833, 2860, 2923, 2977, 3358, 3396, 3523, 3537, 3602, 4165, 5101, 4251, 268, 4252, 4253, 4254, 4255, 4256, 307, 4127, 4390, 4871, 4257, 4258, 5079, 4259, 4260, 4903, 4989, 4261, 4262, 4263, 4507, 4421, 4219, 4220, 4264, 284, 4265, 4266, 4267, 4268, 4269, 2714, 4270, 2774, 4271, 4272, 4273, 4274, 4275, 2908, 4276, 4277, 4278, 4279, 4221, 3519, 4280, 4281, 4282, 4283, 4284, 4139, 4285, 4288, 3432, 3449, 3538, 3550, 276, 3580, 4289, 5085, 3697, 4290, 4295, 4296, 4152, 4305, 4297, 3975, 4299, 4300, 3682, 4301, 4302, 4222, 4304, 4306, 4307, 4392, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4326, 4327, 4328, 4329, 4330, 4332, 4333, 4334, 4335, 4337, 4338, 4527, 4339, 4340, 4341, 4342, 4223, 4343, 4345, 4375, 4346, 4347, 4348, 4349, 4350, 4303, 4351, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4883, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4385, 4386, 4387, 4388, 4391, 4393, 4201, 4132, 4510, 4512, 4524, 4499, 4394, 4396, 2980, 277, 2566, 4131, 5083, 4397, 4398, 4399, 5089, 4809, 4811, 4224, 4821, 4813, 4815, 4829, 4817, 4819, 279, 4823, 4825, 4827, 4831, 4833, 4835, 4837, 4839, 4841, 4843, 4845, 4847, 4849, 4853, 4855, 4857, 4859, 4861, 4863, 4877, 4865, 4867, 4869, 4873, 4875, 4879, 4881, 4885, 4887, 4925, 4889, 4891, 4893, 4851, 4897, 4899, 4901, 4905, 4907, 4909, 4911, 4913, 4915, 4917, 4919, 4921, 4923, 4927, 4929, 4931, 4935, 4949, 4937, 4939, 4941, 4943, 4945, 4947, 5011, 4951, 4953, 4128, 4955, 4957, 4959, 4961, 4963, 4967, 4969, 4971, 4973, 4975, 4977, 4979, 4981, 4983, 4985, 4987, 5009, 2528, 4991, 4993, 4995, 4225, 4997, 4999, 5001, 5003, 5005, 5007, 5013, 5015, 5017, 5019, 5021, 5023, 5025, 5027, 5029, 4226, 5031, 5033, 5035, 4460, 5037, 4965, 5039, 5041, 5043, 5045, 5047, 5049, 2573, 5051, 5053, 5055, 5057, 5059, 5061, 5063, 5065, 5067, 5069, 5071, 4227, 5073, 266, 5077, 5075, 5081, 3493, 3987, 2763, 2839, 4522, 299, 4506, 4400, 4401, 4402, 4403, 2542, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4424, 4414, 4415, 4206, 267, 4417, 4418, 4419, 4420, 4422, 4423, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4228, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4229, 4230, 4448, 4449, 4450, 4451, 4452, 4453, 4133, 4454, 4455, 4456, 4457, 4458, 4459, 4461, 4462, 4134, 4463, 4447, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 302, 4488, 4489, 4490, 4491, 4129, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4500, 4501, 4502, 4503, 4505, 4508, 4509, 2521, 2522, 2524, 2525, 2526, 2527, 2529, 2530, 2531, 2541, 2532, 2533, 2523, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2543, 2544, 2545, 2546, 2547, 265, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2572, 2558, 2559, 289, 2560, 2746, 2561, 2562, 4130, 2563, 287, 2583, 288, 264, 297, 293, 286, 285, 292, 295, 294, 298, 2564, 270, 271, 274, 275, 280, 4207, 278, 283, 273, 2667, 2565, 253, 291, 301, 304, 300, 2567, 2568, 3347, 2569, 2570, 2571, 2574, 2597, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2584, 2585, 2586, 2587, 2588, 2589, 2722, 2590, 2591, 2593, 2594, 2595, 2598, 2753, 2599, 2600, 2601, 2602, 2603, 2605, 2720, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2615, 2616, 2617, 2618, 2684, 2619, 2620, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 2632, 2633, 2634, 2635, 2636, 2637, 2631, 2638, 2639, 2640, 3735, 2641, 2642, 2643, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2668, 2669, 2670, 2957, 2671, 2672, 2673, 2674, 4231, 2644, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683, 2685, 2686, 2776, 2687, 2688, 2745, 2689, 2690, 2691, 2692, 2693, 2694, 2695, 2696, 2697, 2698, 2699, 2700, 2701, 2702, 2726, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 4135, 2710, 2711, 2712, 2715, 2716, 2717, 2718, 2719, 2721, 2723, 2724, 2725, 2727, 2728, 2729, 2730, 2731, 2732, 2734, 2735, 2736, 2737, 2868, 2738, 2739, 2741, 2742, 2743, 2744, 2747, 2748, 4232, 2750, 2751, 2752, 2754, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2766, 2767, 2768, 2769, 2770, 2772, 2773, 2775, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2755, 2785, 2786, 2787, 2985, 2788, 2789, 2791, 2793, 2794, 2795, 2764, 2796, 2797, 2798, 2800, 2801, 2802, 2803, 2804, 2805, 2771, 2806, 2807, 2808, 2809, 2832, 2811, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 2823, 2824, 2825, 2790, 2826, 2828, 2829, 2830, 2831, 2834, 2835, 2836, 2837, 2838, 2841, 2842, 2843, 2844, 2845, 2847, 2848, 2849, 2850, 2851, 2852, 2897, 2854, 2855, 2857, 2858, 2859, 2861, 2862, 2863, 2792, 2865, 2866, 2869, 2870, 2871, 2872, 2873, 2874, 2799, 2875, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 3031, 2894, 2895, 2856, 2896, 4082, 2898, 2899, 2900, 4167, 2901, 2902, 3243, 2903, 3477, 2904, 2906, 2907, 2909, 2910, 2911, 2912, 2913, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2924, 2925, 2926, 2927, 2929, 2928, 2930, 2931, 2932, 2933, 2934, 2935, 2936, 2969, 2937, 2938, 2939, 2941, 2943, 2944, 2945, 2946, 2947, 2914, 3469, 4136, 2948, 2949, 3579, 2950, 2951, 2952, 2953, 2954, 2955, 2958, 2959, 2960, 2961, 2962, 2963, 2964, 2965, 2966, 2967, 2968, 2970, 2971, 2972, 4118, 4233, 2974, 2975, 2976, 2978, 2979, 2981, 2982, 2983, 2940, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 4234, 4352, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 2956, 3000, 3001, 3002, 3034, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3637, 3024, 3025, 3026, 3028, 3029, 3030, 3033, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 5128, 3051, 3052, 3054, 3055, 3485, 3057, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3087, 3088, 3089, 3090, 3091, 3092, 3094, 3095, 3096, 3053, 3097, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3146, 3147, 3148, 3149, 3150, 3151, 3152, 4137, 3153, 3154, 3155, 3156, 3157, 3158, 3300, 3159, 4138, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3310, 3167, 3168, 3169, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 4235, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 4236, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3239, 3240, 3241, 3242, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3638, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3374, 3375, 3376, 3377, 3378, 3379, 4237, 3380, 3381, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3639, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3428, 3429, 3430, 3431, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3466, 3467, 3468, 3470, 3471, 3472, 3473, 3475, 3476, 3479, 3480, 3481, 3482, 3483, 3484, 3777, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3494, 3495, 3496, 3032, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3520, 3521, 3522, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3532, 3533, 3534, 3535, 3536, 3539, 3540, 3541, 3542, 4895, 3543, 3544, 3545, 3546, 3762, 3547, 3548, 3549, 3551, 3552, 3553, 3554, 3555, 3474, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 2777, 3572, 3238, 3573, 3574, 3575, 3576, 3577, 3578, 3581, 3582, 3583, 305, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3632, 3634, 3635, 3636, 3655, 3640, 2984, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3744, 3648, 3650, 3651, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3678, 3679, 3680, 3681, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 4518, 3690, 3691, 3692, 3693, 4238, 3694, 3695, 3696, 3773, 3699, 3700, 3701, 3702, 4239, 3703, 3705, 3706, 3707, 4142, 3708, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 269, 3729, 3730, 3731, 3732, 3733, 3734, 3736, 3737, 3738, 3739, 3740, 3741, 3742, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3758, 3759, 3760, 3761, 3763, 3920, 3764, 3765, 3766, 3767, 290, 3768, 3769, 3770, 3771, 3772, 3774, 3775, 3776, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3952, 3794, 4240, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 4153, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3820, 3821, 4241, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 4395, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3853, 3854, 3855, 3856, 3857, 3858, 3859, 3860, 3861, 3862, 3863, 3864, 3865, 3866, 3868, 3869, 4187, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 4040, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3901, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3977, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 4210, 3961, 3962, 3963, 3964, 3965, 4011, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3976, 3989, 4188, 4145, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 4211, 3986, 3988, 3990, 3991, 3992, 3993, 3994, 3995, 3996, 3997, 3998, 4010, 3999, 4000, 4001, 4002, 4003, 4242, 4004, 4005, 4006, 4177, 4007, 4008, 4009, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4243, 4031, 4032, 4033, 4034, 4035, 4060, 4036, 4037, 4038, 4039, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4077, 4078, 4079, 4080, 4244, 4081, 4083, 4084, 4085, 4086, 2942, 4087, 4212, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4213, 4214, 4216, 4096, 4097, 4217, 4218, 4298, 2713, 2827, 2867, 2922, 3027, 3665, 3478, 3652, 3612, 3649, 4076, 4100, 4101, 4102, 4103, 4104, 4105, 4245, 4106, 4107, 4108, 4287, 4150, 4109, 4110, 4111, 4112, 4246, 4247, 4248, 4215, 5118, 5113, 5099, 4504, 5103, 163, 5126, 261, 5095, 5120, 4514, 4516, 4520, 308, 5122, 5132, 5130, 5097, 5134, 5093, 2846, 4384, 4113, 4249, 4250, 4331, 4389, 5087, 4416, 4472, 281, 2592, 2645, 4202, 2749, 2740, 2853, 2864, 2885, 2905, 3093, 3056, 3058, 3373, 3382, 3465, 3518, 3633, 3677, 3698, 3867, 4095, 4116, 4291, 4292, 4293, 4294, 4117, 4208, 4209, 4286, 4121, 4122, 4123, 4124, 4125, 4126, 4140, 4141, 4143, 4144, 4098, 4099, 4146, 4147, 4148, 4149, 4151, 4154, 4119, 4120, 5138, 5140, 5142, 1, 5144, 5124, 5146, 5148, 5150, 5152) AND "dialogs"."subject_type" = 'OrderItem')) AND (messages.read_by_manager = false) GROUP BY dialogs.id[0m
  [1m[35mCatalogAccess::Base Load (0.6ms)[0m  SELECT "catalog_access".* FROM "catalog_access" LIMIT 1
  [1m[36mRegion Load (0.9ms)[0m  [1mSELECT "regions".* FROM "regions" WHERE "regions"."id" = 28 ORDER BY "regions"."position" LIMIT 1[0m
  [1m[35mSiteConfig Load (0.9ms)[0m  SELECT "site_configs".* FROM "site_configs" LIMIT 1
  [1m[36mUserRole Load (0.6ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" WHERE "user_roles"."custom" = 't'[0m
 Completed 200 OK in 4571ms (Views: 4115.0ms | ActiveRecord: 272.9ms)


 Started GET "/user_notifications/pop" for 127.0.0.1 at 2016-12-07 09:11:48 +0500
 Processing by UserNotificationsController#pop as JSON
  [1m[35mUser Load (0.7ms)[0m  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  [1m[36mUserNotificationSettings Load (0.5ms)[0m  [1mSELECT "user_notification_settings".* FROM "user_notification_settings" WHERE "user_notification_settings"."user_id" = 1 LIMIT 1[0m
  [1m[35m (0.2ms)[0m  BEGIN
  [1m[36m (0.5ms)[0m  [1mUPDATE "users" SET "last_request_at" = '2016-12-07 04:11:48.429694', "perishable_token" = 'JJUN10pHELak1A2L5YW1', "updated_at" = '2016-12-07 04:11:48.431695' WHERE "users"."id" = 1[0m
 [paperclip] Saving attachments.
  [1m[35m (13.2ms)[0m  COMMIT
  [1m[36mUserRole Load (0.7ms)[0m  [1mSELECT "user_roles".* FROM "user_roles" INNER JOIN "user_role_assigns" ON "user_roles"."id" = "user_role_assigns"."user_role_id" WHERE "user_role_assigns"."user_id" = 1[0m
  [1m[35mUserNotification Load (0.7ms)[0m  SELECT "user_notifications".* FROM "user_notifications" WHERE "user_notifications"."user_id" = 1 AND "user_notifications"."viewed" = 'f' LIMIT 1
  Rendered text template (0.0ms)
 Completed 404 Not Found in 41ms (Views: 0.7ms | ActiveRecord: 16.5ms)


 Started POST "/prices/453/load" for 127.0.0.1 at 2016-12-07 09:11:59 +0500

 AbstractController::ActionNotFound - The action 'load' could not be found for PricesController:
  actionpack (3.2.13) lib/abstract_controller/base.rb:116:in `process'
  actionpack (3.2.13) lib/abstract_controller/rendering.rb:45:in `process'
  actionpack (3.2.13) lib/action_controller/metal.rb:203:in `dispatch'
  actionpack (3.2.13) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
  actionpack (3.2.13) lib/action_controller/metal.rb:246:in `block in action'
  actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
  actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:36:in `call'
  journey (1.0.4) lib/journey/router.rb:68:in `block in call'
  journey (1.0.4) lib/journey/router.rb:56:in `call'
  actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:612:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
  rack (1.4.7) lib/rack/etag.rb:23:in `call'
  rack (1.4.7) lib/rack/conditionalget.rb:35:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/head.rb:14:in `call'
  remotipart (1.2.1) lib/remotipart/middleware.rb:27:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/flash.rb:242:in `call'
  rack (1.4.7) lib/rack/session/abstract/id.rb:210:in `context'
  rack (1.4.7) lib/rack/session/abstract/id.rb:205:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/cookies.rb:341:in `call'
  activerecord (3.2.13) lib/active_record/query_cache.rb:64:in `call'
  activerecord (3.2.13) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
  activesupport (3.2.13) lib/active_support/callbacks.rb:405:in `_run__586772659511589398__call__2942710622137818274__callbacks'
  activesupport (3.2.13) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.13) lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
  activesupport (3.2.13) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.13) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/reloader.rb:65:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
  better_errors (2.1.1) lib/better_errors/middleware.rb:84:in `protected_app_call'
  better_errors (2.1.1) lib/better_errors/middleware.rb:79:in `better_errors_call'
  better_errors (2.1.1) lib/better_errors/middleware.rb:57:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
  railties (3.2.13) lib/rails/rack/logger.rb:32:in `call_app'
  railties (3.2.13) lib/rails/rack/logger.rb:16:in `block in call'
  activesupport (3.2.13) lib/active_support/tagged_logging.rb:22:in `tagged'
  railties (3.2.13) lib/rails/rack/logger.rb:16:in `call'
  quiet_assets (1.1.0) lib/quiet_assets.rb:27:in `call_with_quiet_assets'
  actionpack (3.2.13) lib/action_dispatch/middleware/request_id.rb:22:in `call'
  rack (1.4.7) lib/rack/methodoverride.rb:21:in `call'
  rack (1.4.7) lib/rack/runtime.rb:17:in `call'
  activesupport (3.2.13) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
  rack (1.4.7) lib/rack/lock.rb:15:in `call'
  actionpack (3.2.13) lib/action_dispatch/middleware/static.rb:63:in `call'
  railties (3.2.13) lib/rails/engine.rb:479:in `call'
  railties (3.2.13) lib/rails/application.rb:223:in `call'
  rack (1.4.7) lib/rack/content_length.rb:14:in `call'
  railties (3.2.13) lib/rails/rack/log_tailer.rb:17:in `call'
  rack (1.4.7) lib/rack/handler/webrick.rb:59:in `service'
  /home/sdilshod/.rvm/rubies/ruby-2.0.0-p247/lib/ruby/2.0.0/webrick/httpserver.rb:138:in `service'
  /home/sdilshod/.rvm/rubies/ruby-2.0.0-p247/lib/ruby/2.0.0/webrick/httpserver.rb:94:in `run'
  /home/sdilshod/.rvm/rubies/ruby-2.0.0-p247/lib/ruby/2.0.0/webrick/server.rb:295:in `block in start_thread'



 Started POST "/__better_errors/03380aa77586a775/variables" for 127.0.0.1 at 2016-12-07 09:11:59 +0500
diff --git a/lib_prices_controller.rb b/lib_prices_controller.rb
 #this is from lib/common_controllers/prices_controller.rb

 module CommonControllers
  class PricesController < ApplicationController
    def jobs
      @jobs = Price.manager(current_user).find(params[:id]).scheduled_tasks
      render :layout => false
    end

    def index
      @search = Price.includes(:web_service).metasearch(params[:search])
      @prices = @search.relation.where(:customer_id => Customer.suppliers.manager(current_user).map(&:id).uniq.sort).
                                 order(:name).page(params[:page]).per(20)
    end

    def show
      @price = Price.manager(current_user).find(params[:id])
      @prices = @price.price_items.limit(200)

      add_breadcrumb "Карточка прайса #{ @price.name }"
      respond_to do |format|
        format.html do
          render :partial => 'load_form', :layout => false if request.xhr?
        end
      end
    end

    def new
      if !current_user.region.default? && !current_user.region.enable_price?
        flash[:error] = 'Вы не можете создавать собственные прайс-листы'
        redirect_to(:action => :index) and return
      end

      @price = Price.new
    end

    def delivery_params
      @price = Price.manager(current_user).find(params[:id])
      render :layout => nil
    end
    
    def create
      if !current_user.region.default? && !current_user.region.enable_price?
        flash[:error] = 'Вы не можете создавать собственные прайс-листы'
        redirect_to(:action => :index) and return
      end

      @price = Price.new(params[:price])
      @price.send_config_flag = false
      if @price.save
        PriceRegion.create(:price_id => @price.id, :delivery_day => 0)
        
        redirect_to price_url(@price)
      else
        render :new
      end
    end

    def edit
      @price = Price.manager(current_user).find(params[:id])
      add_breadcrumb "Прайс #{ @price.name }", @price
      add_breadcrumb "Редактирование"
    end

    #Remind I'm not sure, but i think that methods, edit_file_fields and update_file_fields are so old. And instead of those, fo now, we have separate
    #       logic, via load_configuration controller. Therefore i will not write test for these methods
    def edit_file_fields
      @price = Price.manager(current_user).find(params[:id])
      if params[:file].blank?
        render :edit_file_fields, locals: { upload: true }
      else
        @price.config_iteration = "file_config"
        if @price.update_attributes(params[:price])
          @data = []
          filename  = params[:file].original_filename
          file_path = File.join(Rails.root, 'tmp', filename)
          FileUtils.cp params[:file].tempfile.path, file_path
          tmp_file, original_filename = file_path, filename
          tmp_file, original_filename = DataLoad.decompress_file(file_path) if filename =~ /(\.zip)|(\.rar)$/i

          data_load = DataLoad.new 30
          format = case original_filename
            when /\.(csv|txt)$/i  then :csv
            when /\.xls$/i  then :excel
            when /\.xlsx$/i then :xlsx
          end

          sheet = nil
          sheet = params[:price][:sheet].to_s.split('+').first if params[:price][:sheet]

          data_load.load(tmp_file, format, 0,
            :col_sep => params[:price][:col_sep],
            :sheet => sheet,
            :codepage => params[:price][:codepage],
            :preprocessor => params[:price][:preprocessor],
            :quote => params[:price][:quote]) do |data|
            @data = data
            break;
          end
          FileUtils.rm file_path
          if @data.length > 0
            render :edit_file_fields, locals: { upload: false }
          else
            render :edit_file_fields, locals: { upload: true }
          end
        else
          render :edit_file_fields, locals: { upload: true }
        end
      end
    end

    def update_file_fields
      @price = Price.manager(current_user).find(params[:id])
      check_cell = nil
      @price.cells.each { |cell| cell.cell = nil; cell.save }

      params[:cell_attrs].each do |params_cell|
        price_cell = @price.cells.where(id: params_cell[:id]).first
        unless params_cell[:id].empty?
          price_cell.cell = params_cell[:cell]
          price_cell.default = nil
          price_cell.replace = params_cell[:replace]
          price_cell.save
        end
        if params_cell[:check_cell] == "true"
          check_cell = params_cell[:cell]
        end
      end

      @price.config_iteration = "fields_config"

      @price.update_attributes(start_row: params[:price][:start_row], check_column: check_cell.to_i)
      @price.save

      @default_cells = @price.cells.where(cell: nil)
      if not @default_cells.empty?
        render :set_defaults_for_nil_cells
      else
        redirect_to price_url(@price)
      end
    end

    def update
      @price = Price.manager(current_user).find(params[:id])
      @price.update_attributes(params[:price])

      if @price.gk_supplier?
        @price.active = true
        if @price.web_service.blank?
          @price.web_service_id = WebService::RegionWS.first.id
        end
        @price.save
      end

      if params[:web_service_id] and not params[:web_service_id].empty? and @price.load_configuration
        @price.load_configuration.destroy
      end

      if @price.save
        if params[:file_config_redirect] == "true"
          if @price.load_configuration.nil?
            redirect_to new_price_load_configuration_path(@price)
          else
            redirect_to edit_price_load_configuration_path(@price, @price.load_configuration)
          end
        else
          redirect_to price_url(@price)
        end
      else
        render :edit
      end
    end

    def markup_templates
      @price            = Price.manager(current_user).find(params[:id])
      @markup_templates = MarkupTemplate.manager(current_user).order(:name)

      render :layout => nil
    end

    def apply_markup_template
      @price           = Price.manager(current_user).find(params[:id])
      flash[:notice]   = 'Изменение сохранены' if @price.update_attributes(params[:price])
      #@price.apply_markup(@markup_template) if @markup_template.present?

      redirect_to :action => :show
    end

    def clean
      @price = Price.manager(current_user).find(params[:id])
      @price.last_count = 0
      @price.save

      PriceItem.where(:price_id => @price.id).delete_all

      redirect_to price_url(@price)
    end

    def destroy
      @price = Price.manager(current_user).find(params[:id])
      unless @price.gk_supplier?
        PriceItem.where(:price_id => @price.id).delete_all
        @price.destroy
      else
        flash[:error] = "Нельзя удалить прайс-лист головной компании"
      end

      redirect_to prices_url
    end  

    def refresh
      @price           = Price.manager(current_user).find(params[:id])
      @price.last_load = Time.now
      @price.save

      @price.logs.create(:message => 'Обновлена дата загрузки', 
                         :log_type_id => Log::SUCCESS_TYPE_ID) 

      redirect_to price_url(@price) 
    end

    def delta
      @price        = Price.manager(current_user).find(params[:id])
      @price_source = Price.manager(current_user).find(params[:price_id])
      @price_not_in = Price.manager(current_user).find(params[:price_not_in])

      @price.delta @price_source, @price_not_in

      redirect_to price_url(@price) 
    end

    def download
      @price = Price.manager(current_user).find(params[:id])
      (Rails.env == 'development' ? @price.download : PriceDownloadWorker.perform_async(@price.id))

      @price.logs.create(:message => "Установлен в очередь на загрузку с удаленного хоста", :log_type_id => Log::SUCCESS_TYPE_ID)

      flash[:notice] = "Установлен в очередь на загрузку с удаленного хоста"
      
      redirect_to price_url(@price)
    end

    def feel_search
      @price = Price.manager(current_user).find(params[:id])
      TecdocArticle.delay.deactive_query(@price)

      @price.logs.create(:message => "Установлен в очередь на наполнение каталога", :log_type_id => Log::SUCCESS_TYPE_ID)
      flash[:notice] = "Установлен в очередь на наполнение каталога"

      redirect_to price_url(@price)
    end

    def email_load
      Price.delay.process_email
      
      flash[:notice] = "Задание на загрузку прайсов установлено в очередь"
      
      redirect_to prices_url
    end

    def search
      @prices = params[:q].blank? ? [] : 
                                    PriceItem.joins(:price).
                                              where(:clear_oem => params[:q].to_s.to_oem).
                                              where(:price => {:customer_id => Customer.manager(current_user).suppliers})
    end

    def load
      @price = Price.manager(current_user).find(params[:id])

      unless params[:price].blank?
        file_path = File.join(Rails.root, 'tmp', params[:price].original_filename)
        FileUtils.cp params[:price].tempfile.path, file_path

        if params[:async].blank?
          begin
            load_status = @price.load(params[:price].original_filename, file_path)

            if load_status == 1
              flash[:notice] = "Загружен"
            elsif load_status == -1
              flash[:notice] = "Формат файла не поддерживается"
              @price.logs.create(:message => 'Попытка подгрузки неизвестного формата файла', :log_type_id => Log::ERROR_TYPE_ID)
            elsif load_status == 0
              flash[:notice] = "Ошибка загрузки"
              @price.logs.create(:message => 'Попытка подгрузки закончилась ошибкой', :log_type_id => Log::ERROR_TYPE_ID) 
            else 
              flash[:error] = 'Неизвестный статус загрузки'
            end
          rescue => ex
            @price.logs.create(:message => "Ошибка загрузки #{ex.class}: #{ex.message}", :log_type_id => Log::ERROR_TYPE_ID)
            flash[:error] = "#{ex.class}: #{ex.message}"
          end
        else
          PriceLoadWorker.perform_async(@price.id, params[:price].original_filename, file_path)
          @price.logs.create(:message => 'Установлен в очередь на загрузку', :log_type_id => Log::SUCCESS_TYPE_ID)

          flash[:notice] = "Прайс лист установлен в очередь на загрузку"
        end
      end

      redirect_to price_url(@price)
    end

    def preload
      @data = []

      unless params[:price].blank?
        file_path = File.join(Rails.root, 'tmp', params[:price].original_filename)
        FileUtils.cp params[:price].tempfile.path, file_path
        tmp_file, original_filename = file_path, params[:price].original_filename
        tmp_file, original_filename = DataLoad.decompress_file(file_path) if params[:price].original_filename =~ /(\.zip)|(\.rar)$/i

        data_load = DataLoad.new 1000
        puts original_filename
        format = case original_filename
          when /\.(csv|txt)$/i  then :csv
          when /\.xls$/i  then :excel
          when /\.xlsx$/i then :xlsx
        end

        data_load.load(tmp_file, format, 0, :col_sep => params[:col_sep], :sheet => params[:sheet]) do |data|
          @data = data
          break;
        end

        FileUtils.rm file_path
      end

      render :preshow
    end

    def change_activation
      @price = Price.manager(current_user).find(params[:id])
      @price.change_activation!
    end

    def check_brands
      @check_brands = @price.price_check_brands
      render :layout => false
    end

    def change_check_price_make_name
      @price.update_attribute(:check_price_make_name, params[:check_price_make_name])
      render :nothing => true, :status => 200
    end

    def visible_zones
      render :layout => false
    end

    def add_zone
      params[:zone][:visible_zone_id] = nil unless params[:zone][:visible_zone_id].present?
      zone = PriceVisibleZone.new(params[:zone])
      if zone.save
        render json: {error: '', text: 'Прайс-лист успешно добавлен в зону видимости.', status: true, id: zone.id, name: zone.visible_zone.try(:name)}
      else
        render json: {error: "Произошли ошибки: #{zone.errors.full_messages.join(';')}", text: '', status: false}
      end
    end

    def destroy_zone
      price_visible_zone = PriceVisibleZone.find_by_id(params[:price_visible_zone_id])
      price_visible_zone.destroy if price_visible_zone
      render json: nil, status: :ok
    end

    def get_real_delivery_stats
      stats = {}
      Price.find(params[:id]).price_real_delivery_days.each{ |i| stats[i.real_delivery_day] = [i.delivered_count, i.denied_count] }
      render json: stats.to_json
    end

  end
 end
diff --git a/prices_controller.rb b/prices_controller.rb
 #this is from app/controllers/prices_controller.rb

 # -*- encoding : utf-8 -*-
 require 'stringio'
 require 'cgi'
 require 'share/common_controllers/prices_controller'

 class PricesController < CommonControllers::PricesController
  load_and_authorize_resource
  autocomplete :price, :name

  add_breadcrumb "Прайсы", :prices_path
  add_breadcrumb "Создать прайс", nil, only: "new"
  add_breadcrumb "Поиск", nil, only: "search"
  add_breadcrumb "Просмотр файла", nil, only: [ "preshow", "preload" ]

 end
diff --git a/route.rb b/route.rb
  .......

  resources :prices do
    get  :jobs, :on => :member
    get :autocomplete_price_name, :on => :collection
    get :visible_zones, on: :member
    get :check_brands, on: :member
    get :get_real_delivery_stats, on: :member
    post :add_zone, on: :collection
    post :destroy_zone, on: :collection
    post :change_check_price_make_name, on: :collection
    resources :price_coefs
    resources :price_weights
    resources :price_selects
    resources :price_rates
    resources :price_regions
    resources :customer_price_accesses
    resources :price_stat_logs
    resources :price_check_brands
    resources :price_items_analyzes, :as => :items_analyzes do
      get :show_result, :on => :collection
      get :check_status, :on => :collection
      get :print_result, :on => :collection
    end
    resources :oem_discount_groups do
      post :load, on: :collection
    end
    resources :work_weeks, :only => :create
    resources :load_configurations do
      get :edit_cells_defaults, on: :member
      put :update_cells_defaults, on: :member
    end


    collection do
      post :compare_result
      get :search
      get :compare
      get :preshow
      get :email_load      
      post :preload
    end

    member do
      post :load
      post :delta
      put :apply_markup_template
      put :edit_file_fields
      put :update_file_fields
      get  :markup_templates
      get  :refresh
      get  :download
      get  :yml
      get  :delivery_params
      get  :feel_search      
      get  :clean
      get :edit_file_fields
      post :change_activation
    end
  end
 .....
	#this is from lib/common_controllers/prices_controller.rb

	module CommonControllers
	class PricesController < ApplicationController
	def jobs
	@jobs = Price.manager(current_user).find(params[:id]).scheduled_tasks
	render :layout => false
	end

	def index
	@search = Price.includes(:web_service).metasearch(params[:search])
	@prices = @search.relation.where(:customer_id => Customer.suppliers.manager(current_user).map(&:id).uniq.sort).
	order(:name).page(params[:page]).per(20)
	end

	def show
	@price = Price.manager(current_user).find(params[:id])
	@prices = @price.price_items.limit(200)

	add_breadcrumb "Карточка прайса #{ @price.name }"
	respond_to do \|format\|
	format.html do
	render :partial => 'load_form', :layout => false if request.xhr?
	end
	end
	end

	def new
	if !current_user.region.default? && !current_user.region.enable_price?
	flash[:error] = 'Вы не можете создавать собственные прайс-листы'
	redirect_to(:action => :index) and return
	end

	@price = Price.new
	end

	def delivery_params
	@price = Price.manager(current_user).find(params[:id])
	render :layout => nil
	end

	def create
	if !current_user.region.default? && !current_user.region.enable_price?
	flash[:error] = 'Вы не можете создавать собственные прайс-листы'
	redirect_to(:action => :index) and return
	end

	@price = Price.new(params[:price])
	@price.send_config_flag = false
	if @price.save
	PriceRegion.create(:price_id => @price.id, :delivery_day => 0)

	redirect_to price_url(@price)
	else
	render :new
	end
	end

	def edit
	@price = Price.manager(current_user).find(params[:id])
	add_breadcrumb "Прайс #{ @price.name }", @price
	add_breadcrumb "Редактирование"
	end

	#Remind I'm not sure, but i think that methods, edit_file_fields and update_file_fields are so old. And instead of those, fo now, we have separate
	# logic, via load_configuration controller. Therefore i will not write test for these methods
	def edit_file_fields
	@price = Price.manager(current_user).find(params[:id])
	if params[:file].blank?
	render :edit_file_fields, locals: { upload: true }
	else
	@price.config_iteration = "file_config"
	if @price.update_attributes(params[:price])
	@data = []
	filename = params[:file].original_filename
	file_path = File.join(Rails.root, 'tmp', filename)
	FileUtils.cp params[:file].tempfile.path, file_path
	tmp_file, original_filename = file_path, filename
	tmp_file, original_filename = DataLoad.decompress_file(file_path) if filename =~ /(\.zip)\|(\.rar)$/i

	data_load = DataLoad.new 30
	format = case original_filename
	when /\.(csv\|txt)$/i then :csv
	when /\.xls$/i then :excel
	when /\.xlsx$/i then :xlsx
	end

	sheet = nil
	sheet = params[:price][:sheet].to_s.split('+').first if params[:price][:sheet]

	data_load.load(tmp_file, format, 0,
	:col_sep => params[:price][:col_sep],
	:sheet => sheet,
	:codepage => params[:price][:codepage],
	:preprocessor => params[:price][:preprocessor],
	:quote => params[:price][:quote]) do \|data\|
	@data = data
	break;
	end
	FileUtils.rm file_path
	if @data.length > 0
	render :edit_file_fields, locals: { upload: false }
	else
	render :edit_file_fields, locals: { upload: true }
	end
	else
	render :edit_file_fields, locals: { upload: true }
	end
	end
	end

	def update_file_fields
	@price = Price.manager(current_user).find(params[:id])
	check_cell = nil
	@price.cells.each { \|cell\| cell.cell = nil; cell.save }

	params[:cell_attrs].each do \|params_cell\|
	price_cell = @price.cells.where(id: params_cell[:id]).first
	unless params_cell[:id].empty?
	price_cell.cell = params_cell[:cell]
	price_cell.default = nil
	price_cell.replace = params_cell[:replace]
	price_cell.save
	end
	if params_cell[:check_cell] == "true"
	check_cell = params_cell[:cell]
	end
	end

	@price.config_iteration = "fields_config"

	@price.update_attributes(start_row: params[:price][:start_row], check_column: check_cell.to_i)
	@price.save

	@default_cells = @price.cells.where(cell: nil)
	if not @default_cells.empty?
	render :set_defaults_for_nil_cells
	else
	redirect_to price_url(@price)
	end
	end

	def update
	@price = Price.manager(current_user).find(params[:id])
	@price.update_attributes(params[:price])

	if @price.gk_supplier?
	@price.active = true
	if @price.web_service.blank?
	@price.web_service_id = WebService::RegionWS.first.id
	end
	@price.save
	end

	if params[:web_service_id] and not params[:web_service_id].empty? and @price.load_configuration
	@price.load_configuration.destroy
	end

	if @price.save
	if params[:file_config_redirect] == "true"
	if @price.load_configuration.nil?
	redirect_to new_price_load_configuration_path(@price)
	else
	redirect_to edit_price_load_configuration_path(@price, @price.load_configuration)
	end
	else
	redirect_to price_url(@price)
	end
	else
	render :edit
	end
	end

	def markup_templates
	@price = Price.manager(current_user).find(params[:id])
	@markup_templates = MarkupTemplate.manager(current_user).order(:name)

	render :layout => nil
	end

	def apply_markup_template
	@price = Price.manager(current_user).find(params[:id])
	flash[:notice] = 'Изменение сохранены' if @price.update_attributes(params[:price])
	#@price.apply_markup(@markup_template) if @markup_template.present?

	redirect_to :action => :show
	end

	def clean
	@price = Price.manager(current_user).find(params[:id])
	@price.last_count = 0
	@price.save

	PriceItem.where(:price_id => @price.id).delete_all

	redirect_to price_url(@price)
	end

	def destroy
	@price = Price.manager(current_user).find(params[:id])
	unless @price.gk_supplier?
	PriceItem.where(:price_id => @price.id).delete_all
	@price.destroy
	else
	flash[:error] = "Нельзя удалить прайс-лист головной компании"
	end

	redirect_to prices_url
	end

	def refresh
	@price = Price.manager(current_user).find(params[:id])
	@price.last_load = Time.now
	@price.save

	@price.logs.create(:message => 'Обновлена дата загрузки',
	:log_type_id => Log::SUCCESS_TYPE_ID)

	redirect_to price_url(@price)
	end

	def delta
	@price = Price.manager(current_user).find(params[:id])
	@price_source = Price.manager(current_user).find(params[:price_id])
	@price_not_in = Price.manager(current_user).find(params[:price_not_in])

	@price.delta @price_source, @price_not_in

	redirect_to price_url(@price)
	end

	def download
	@price = Price.manager(current_user).find(params[:id])
	(Rails.env == 'development' ? @price.download : PriceDownloadWorker.perform_async(@price.id))

	@price.logs.create(:message => "Установлен в очередь на загрузку с удаленного хоста", :log_type_id => Log::SUCCESS_TYPE_ID)

	flash[:notice] = "Установлен в очередь на загрузку с удаленного хоста"

	redirect_to price_url(@price)
	end

	def feel_search
	@price = Price.manager(current_user).find(params[:id])
	TecdocArticle.delay.deactive_query(@price)

	@price.logs.create(:message => "Установлен в очередь на наполнение каталога", :log_type_id => Log::SUCCESS_TYPE_ID)
	flash[:notice] = "Установлен в очередь на наполнение каталога"

	redirect_to price_url(@price)
	end

	def email_load
	Price.delay.process_email

	flash[:notice] = "Задание на загрузку прайсов установлено в очередь"

	redirect_to prices_url
	end

	def search
	@prices = params[:q].blank? ? [] :
	PriceItem.joins(:price).
	where(:clear_oem => params[:q].to_s.to_oem).
	where(:price => {:customer_id => Customer.manager(current_user).suppliers})
	end

	def load
	@price = Price.manager(current_user).find(params[:id])

	unless params[:price].blank?
	file_path = File.join(Rails.root, 'tmp', params[:price].original_filename)
	FileUtils.cp params[:price].tempfile.path, file_path

	if params[:async].blank?
	begin
	load_status = @price.load(params[:price].original_filename, file_path)

	if load_status == 1
	flash[:notice] = "Загружен"
	elsif load_status == -1
	flash[:notice] = "Формат файла не поддерживается"
	@price.logs.create(:message => 'Попытка подгрузки неизвестного формата файла', :log_type_id => Log::ERROR_TYPE_ID)
	elsif load_status == 0
	flash[:notice] = "Ошибка загрузки"
	@price.logs.create(:message => 'Попытка подгрузки закончилась ошибкой', :log_type_id => Log::ERROR_TYPE_ID)
	else
	flash[:error] = 'Неизвестный статус загрузки'
	end
	rescue => ex
	@price.logs.create(:message => "Ошибка загрузки #{ex.class}: #{ex.message}", :log_type_id => Log::ERROR_TYPE_ID)
	flash[:error] = "#{ex.class}: #{ex.message}"
	end
	else
	PriceLoadWorker.perform_async(@price.id, params[:price].original_filename, file_path)
	@price.logs.create(:message => 'Установлен в очередь на загрузку', :log_type_id => Log::SUCCESS_TYPE_ID)

	flash[:notice] = "Прайс лист установлен в очередь на загрузку"
	end
	end

	redirect_to price_url(@price)
	end

	def preload
	@data = []

	unless params[:price].blank?
	file_path = File.join(Rails.root, 'tmp', params[:price].original_filename)
	FileUtils.cp params[:price].tempfile.path, file_path
	tmp_file, original_filename = file_path, params[:price].original_filename
	tmp_file, original_filename = DataLoad.decompress_file(file_path) if params[:price].original_filename =~ /(\.zip)\|(\.rar)$/i

	data_load = DataLoad.new 1000
	puts original_filename
	format = case original_filename
	when /\.(csv\|txt)$/i then :csv
	when /\.xls$/i then :excel
	when /\.xlsx$/i then :xlsx
	end

	data_load.load(tmp_file, format, 0, :col_sep => params[:col_sep], :sheet => params[:sheet]) do \|data\|
	@data = data
	break;
	end

	FileUtils.rm file_path
	end

	render :preshow
	end

	def change_activation
	@price = Price.manager(current_user).find(params[:id])
	@price.change_activation!
	end

	def check_brands
	@check_brands = @price.price_check_brands
	render :layout => false
	end

	def change_check_price_make_name
	@price.update_attribute(:check_price_make_name, params[:check_price_make_name])
	render :nothing => true, :status => 200
	end

	def visible_zones
	render :layout => false
	end

	def add_zone
	params[:zone][:visible_zone_id] = nil unless params[:zone][:visible_zone_id].present?
	zone = PriceVisibleZone.new(params[:zone])
	if zone.save
	render json: {error: '', text: 'Прайс-лист успешно добавлен в зону видимости.', status: true, id: zone.id, name: zone.visible_zone.try(:name)}
	else
	render json: {error: "Произошли ошибки: #{zone.errors.full_messages.join(';')}", text: '', status: false}
	end
	end

	def destroy_zone
	price_visible_zone = PriceVisibleZone.find_by_id(params[:price_visible_zone_id])
	price_visible_zone.destroy if price_visible_zone
	render json: nil, status: :ok
	end

	def get_real_delivery_stats
	stats = {}
	Price.find(params[:id]).price_real_delivery_days.each{ \|i\| stats[i.real_delivery_day] = [i.delivered_count, i.denied_count] }
	render json: stats.to_json
	end

	end
	end
	#this is from app/controllers/prices_controller.rb

	# -- encoding : utf-8 --
	require 'stringio'
	require 'cgi'
	require 'share/common_controllers/prices_controller'

	class PricesController < CommonControllers::PricesController
	load_and_authorize_resource
	autocomplete :price, :name

	add_breadcrumb "Прайсы", :prices_path
	add_breadcrumb "Создать прайс", nil, only: "new"
	add_breadcrumb "Поиск", nil, only: "search"
	add_breadcrumb "Просмотр файла", nil, only: [ "preshow", "preload" ]

	end
	.......

	resources :prices do
	get :jobs, :on => :member
	get :autocomplete_price_name, :on => :collection
	get :visible_zones, on: :member
	get :check_brands, on: :member
	get :get_real_delivery_stats, on: :member
	post :add_zone, on: :collection
	post :destroy_zone, on: :collection
	post :change_check_price_make_name, on: :collection
	resources :price_coefs
	resources :price_weights
	resources :price_selects
	resources :price_rates
	resources :price_regions
	resources :customer_price_accesses
	resources :price_stat_logs
	resources :price_check_brands
	resources :price_items_analyzes, :as => :items_analyzes do
	get :show_result, :on => :collection
	get :check_status, :on => :collection
	get :print_result, :on => :collection
	end
	resources :oem_discount_groups do
	post :load, on: :collection
	end
	resources :work_weeks, :only => :create
	resources :load_configurations do
	get :edit_cells_defaults, on: :member
	put :update_cells_defaults, on: :member
	end


	collection do
	post :compare_result
	get :search
	get :compare
	get :preshow
	get :email_load
	post :preload
	end

	member do
	post :load
	post :delta
	put :apply_markup_template
	put :edit_file_fields
	put :update_file_fields
	get :markup_templates
	get :refresh
	get :download
	get :yml
	get :delivery_params
	get :feel_search
	get :clean
	get :edit_file_fields
	post :change_activation
	end
	end
	.....