Time |
Query |
0.55ms
|
select * from `crm_sessions` where `id` = '89614119d56eaeb8c6c52e22bdcf956d292ac317' limit 1
|
0.39ms
|
select * from `crm_relation_fields` where `relatable_type` = 'Application\Gallery' order by `name` asc
|
0.55ms
|
select * from `crm_dbconfig_settings` where `id` in (select COALESCE(MIN(CASE WHEN environment = "production" THEN id END), MIN(id)) from `crm_dbconfig_settings` where `group` = 'application' group by `package`, `key`) and `package` is null and `group` = 'application'
|
22.87ms
|
select * from `crm_galleries` where (select count(*) from `crm_app_applications` where `crm_app_applications`.`gallery_id` = `crm_galleries`.`id` and `year` = '2020' and `outcome` = 'approved' and `year` = '2020') >= 1 order by `name` asc
|
5.96ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` in ('3864', '1901', '451', '3923', '942', '3476', '4036', '3872', '190', '1239', '4165', '3938', '4159', '419', '420', '1333', '4120', '4067', '466', '633', '2312', '485', '515', '2678', '3956', '3837', '1852', '2893', '583', '2567', '3118', '4157', '3494', '657', '3553', '3767', '632', '3796', '4088', '785', '482', '483', '1991', '3924', '4092', '3859', '4113', '361', '496', '2961', '503', '3642', '4079', '3777', '3821', '1006', '1010', '2609', '3936', '4160', '4097', '3448', '3383', '4164', '2070', '1187', '4069', '2358', '2779', '1261', '3492') order by `created_at` desc
|
14.63ms
|
select `country`, `country` from `crm_galleries` where (select count(*) from `crm_app_applications` where `crm_app_applications`.`gallery_id` = `crm_galleries`.`id` and `year` = '2020' and `outcome` = 'approved' and `year` = '2020') >= 1
|
0.74ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3923' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.55ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3923' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.22ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3923' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.67ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '190' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.67ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '190' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.26ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '190' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.65ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1239' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.53ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1239' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1239' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.58ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3938' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.62ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3938' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3938' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.59ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4159' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.65ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4159' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4159' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.49ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '419' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.48ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '419' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.15ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '419' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.63ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '420' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.62ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '420' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '420' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.47ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1333' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.54ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1333' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1333' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.56ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4120' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.57ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4120' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4120' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.52ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4067' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.52ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4067' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.2ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4067' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.52ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '466' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.54ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '466' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '466' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.57ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2312' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.54ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2312' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2312' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.92ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '485' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.47ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '485' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '485' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.51ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '515' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.42ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '515' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '515' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.6ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2678' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.67ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2678' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2678' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.59ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3837' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.62ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3837' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3837' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.47ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1852' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.68ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1852' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1852' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.59ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2893' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.82ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2893' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.46ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2893' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.95ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '583' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.94ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '583' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.27ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '583' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.83ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2567' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
1.01ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2567' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.29ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2567' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.55ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4157' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.62ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4157' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.27ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4157' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.8ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '657' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.95ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '657' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.29ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '657' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.85ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3553' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.87ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3553' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.31ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3553' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.9ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '482' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.76ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '482' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.2ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '482' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.63ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '483' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.57ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '483' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '483' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.58ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3924' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.58ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3924' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.2ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3924' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.41ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4092' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.41ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4092' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4092' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4113' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.39ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4113' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4113' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.58ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '496' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.39ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '496' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '496' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.51ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '503' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.43ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '503' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.15ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '503' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.48ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3642' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.45ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3642' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.32ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3642' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.87ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1006' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.43ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1006' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.15ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1006' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.27ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4097' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.28ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4097' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4097' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.35ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3448' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.37ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3448' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3448' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3383' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.38ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3383' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.59ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3383' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.37ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2070' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.41ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2070' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2070' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.35ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2358' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2358' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.13ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2358' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2779' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.37ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2779' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.13ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2779' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.24ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3821' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.26ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3821' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.13ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3821' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.31ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3796' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.39ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3796' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3796' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.26ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4164' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.25ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4164' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4164' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
1.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1187' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
1.15ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1187' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.33ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1187' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.88ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1901' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
1.16ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1901' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.62ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1901' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.77ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4036' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.77ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4036' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.42ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4036' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.78ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3956' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.83ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3956' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.44ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3956' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.88ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4088' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.71ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4088' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.28ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4088' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.95ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1991' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
1.02ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1991' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.28ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1991' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.44ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3777' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.37ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3777' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.16ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3777' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.49ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2609' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.54ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2609' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.16ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2609' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.32ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4160' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.31ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4160' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.16ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4160' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.61ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '942' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.66ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '942' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '942' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.63ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '785' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.64ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '785' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '785' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.58ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1261' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.61ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1261' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1261' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.65ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3767' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.62ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3767' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.2ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3767' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.65ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3864' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.63ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3864' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.29ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3864' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.86ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '451' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.9ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '451' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.3ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '451' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.96ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3118' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
1.1ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3118' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.29ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3118' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.81ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '632' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
1ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '632' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.29ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '632' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.46ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2961' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.57ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2961' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '2961' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.4ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4165' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.4ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4165' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4165' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.54ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '361' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.61ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '361' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '361' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.49ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3476' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.58ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3476' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.19ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3476' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3872' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.39ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3872' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.18ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3872' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '633' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.41ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '633' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.15ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '633' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.36ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4079' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.43ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4079' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4079' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.26ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4069' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.29ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4069' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.17ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '4069' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.37ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3494' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.39ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3494' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.15ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3494' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.41ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3492' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.48ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3492' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.14ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3492' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.43ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1010' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.45ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1010' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.13ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '1010' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.32ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3936' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.39ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3936' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.13ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3936' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.24ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3859' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' limit 1
|
0.26ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3859' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|
0.13ms
|
select * from `crm_app_applications` where `crm_app_applications`.`gallery_id` = '3859' and `year` = '2020' and `crm_app_applications`.`outcome` = 'approved' order by `created_at` desc
|