[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address		= 0.0.0.0
# * Fine Tuning
#
#sazan 27.05.2014
#key_buffer		= 32M
#sazan 08112016 was 1200
key_buffer		= 1400M
#sazan 27.05.2014
#max_allowed_packet	= 32M
max_allowed_packet	= 500M
#sazan 27.05.2014
#thread_stack		= 192K
thread_stack		= 512K
#sazan 27.05.2014
#thread_cache_size       = 8
thread_cache_size       = 120
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
#sazan 27.05.2014
#myisam-recover         = BACKUP
myisam-recover         = FORCE
#sazan 27.05.2014
#max_connections        = 100
max_connections        = 500
#table_cache            = 64
#table_cache		= 500
table_cache		= 700
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
#default 1M sazan
query_cache_limit	= 64M
#sazan 27.05.2014
#query_cache_size        = 128M
query_cache_size        = 256M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
slow-query-log = 1
log_slow_queries	= /var/log/mysql/mysql-slow.log
long_query_time = 5
log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
#sazan 27.05.2014
#sazan 08112016 was 400
#innodb_buffer_pool_size = 2500M
innodb_buffer_pool_size = 9000M
innodb_thread_concurrency = 32
innodb_concurrency_tickets = 1000


[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
#sazan 16M
key_buffer		= 500M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

mysqldumpslow -s at -t 10
Reading mysql slow query log from /var/log/mysql/mysql-slow.log
Count: 1  Time=34.56s (34s)  Lock=0.00s (0s)  Rows=2.0 (2), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 10  Time=34.50s (344s)  Lock=0.00s (0s)  Rows=50.0 (500), fenguser2016[fenguser2016]@[10.11.128.71]
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `title` AS `order_value` FROM `og_project_messages` `co` WHERE `trashed_on` = 'S' AND `archived_by_id` = N AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_messages = true ) ) ) )
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_project_messages` `co` WHERE `trashed_by_id` = N AND N = N AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_messages = true ) ) ) ))
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `subject` AS `order_value` FROM `og_project_events` `co` WHERE  `trashed_on` = 'S' AND `archived_by_id` = N AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_events = true ) ) ) )
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_project_events` `co` WHERE `trashed_by_id` = N AND N = N AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_events = true ) ) ) ))
  UNION
  SELECT  'S' AS `object_manager_value`, `id` as `oid`, `filename` AS `order_value` FROM `og_project_files` `co` WHERE `trashed_on` = 'S' AND `archived_by_id` = N AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_files = true ) ) ) )
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_project_files` `co` WHERE `trashed_by_id` = N AND N = N AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_files = true ) ) ) ))
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `title` AS `order_value` FROM `og_project_tasks` `co` WHERE `is_template` = false AND `completed_on` = 'S' AND `trashed_on` = 'S' AND `archived_by_id` = N AND `is_template` = false AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) )
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_project_tasks` `co` WHERE `trashed_by_id` = N AND N = N AND `is_template` = false AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `name` AS `order_value` FROM `og_project_milestones` `co` WHERE `trashed_on` = 'S' AND `archived_by_id` = N AND `is_template` = false AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_milestones = true ) ) ) )
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_project_milestones` `co` WHERE `trashed_by_id` = N AND N = N AND `is_template` = false AND true   AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_milestones = true ) ) ) ))
  UNION
  SELECT  'S' AS `object_manager_value`, `id` as `oid`, `name` AS `order_value` FROM `og_companies` `co` WHERE `trashed_on` = 'S' AND `archived_by_id` = N AND true   AND ( true)
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_companies` `co` WHERE `trashed_by_id` = N AND N = N AND true   AND ( true))
  UNION
  SELECT 'S' AS `object_manager_value`, `id` AS `oid`, TRIM(CONCAT('S', `lastname`, `firstname`, `middlename`)) AS `order_value` FROM `og_contacts` `co` WHERE `trashed_on` = 'S' AND `archived_by_id` = N AND true    AND ( true)
  UNION
  SELECT  'S' AS `object_manager_value`, `id` AS `oid`, `text` AS `order_value` FROM `og_comments` WHERE `trashed_on` = 'S' AND `rel_object_manager` = 'S' AND `rel_object_id` IN (SELECT `co`.`id` FROM `og_contacts` `co` WHERE `trashed_by_id` = N AND N = N AND true   AND ( true)) ORDER BY `order_value`  ASC  LIMIT N,N

Count: 1  Time=34.29s (34s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 1  Time=34.29s (34s)  Lock=0.00s (0s)  Rows=2.0 (2), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 5  Time=34.16s (170s)  Lock=0.00s (0s)  Rows=1.8 (9), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 1  Time=34.12s (34s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 1  Time=34.12s (34s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N  AND `rel_object_id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'S' && `workspace_id` IN (N))  and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 1  Time=34.11s (34s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 2  Time=34.03s (68s)  Lock=0.00s (0s)  Rows=1.5 (3), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N   and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N,N,N,N,N,N,N,N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N

Count: 1  Time=33.99s (33s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@pm.citrt.net
  SELECT distinct `rel_object_manager`, `rel_object_id` FROM `og_searchable_objects` WHERE `content` LIKE 'S' AND `is_private` = N  AND `rel_object_id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'S' && `workspace_id` IN (N, N))  and EXISTS(SELECT * FROM og_project_tasks co where `rel_object_id` = id and trashed_by_id = N  AND (  ( ( `created_by_id` = N)
  OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
  WHERE `xx_oup`.`rel_object_id` = `co`.id
  AND `xx_oup`.`rel_object_manager` = 'S'
  AND `xx_oup`.`user_id` IN (N,N,N)
  AND `xx_oup`.can_read = true) )
  OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
  WHERE `xx_pu`.`user_id` IN (N,N,N)
  AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
  AND `xx_wo`.`object_id` = `co`.id
  AND `xx_wo`.`object_manager` = 'S'
  AND `xx_pu`.can_read_tasks = true ) ) ) ))  AND `rel_object_manager` = 'S'  ORDER BY `rel_object_id` DESC  LIMIT N, N