Following https://github.com/sonata-project/SonataAdminBundle/issues/3924

Question	Answer
Bundle version	composer show sonata-project/*
	sonata-project/admin-bundle 3.x-dev 62c313c The missing Symfony Admin Generator
	sonata-project/block-bundle 3.x-dev ee778ac Symfony SonataBlockBundle
	sonata-project/cache 1.0.7 Cache library
	sonata-project/classification-bundle 3.x-dev aa61d55 Symfony SonataClassificationBundle
	sonata-project/core-bundle 3.x-dev d2f84a6 Symfony SonataCoreBundle
	sonata-project/datagrid-bundle dev-master 311afa1 Symfony SonataDatagridBundle
	sonata-project/doctrine-extensions 1.0.2 Doctrine2 behavioral extensions
	sonata-project/doctrine-orm-admin-bundle 3.x-dev 3c85820 Symfony Sonata / Integrate Doctrine ORM into the SonataAdminBundle
	sonata-project/easy-extends-bundle 2.1.10 Symfony SonataEasyExtendsBundle
	sonata-project/exporter 1.4.1 Lightweight Exporter library
	sonata-project/intl-bundle 2.2.4 Symfony SonataIntlBundle
	sonata-project/media-bundle 3.x-dev ec413fa Symfony SonataMediaBundle
	sonata-project/notification-bundle 3.0.0 Symfony SonataNotificationBundle
Symfony version	composer show symfony/*
	symfony/assetic-bundle v2.8.0 Integrates Assetic into Symfony2
	symfony/monolog-bundle 2.11.1 Symfony MonologBundle
	symfony/polyfill-apcu v1.2.0 Symfony polyfill backporting apcu_* functions to lower PHP versions
	symfony/polyfill-intl-icu v1.2.0 Symfony polyfill for intl’s ICU-related data and classes
	symfony/polyfill-mbstring v1.2.0 Symfony polyfill for the Mbstring extension
	symfony/polyfill-php54 v1.2.0 Symfony polyfill backporting some PHP 5.4+ features to lower PHP versions
	symfony/polyfill-php55 v1.2.0 Symfony polyfill backporting some PHP 5.5+ features to lower PHP versions
	symfony/polyfill-php56 v1.2.0 Symfony polyfill backporting some PHP 5.6+ features to lower PHP versions
	symfony/polyfill-php70 v1.2.0 Symfony polyfill backporting some PHP 7.0+ features to lower PHP versions
	symfony/polyfill-util v1.2.0 Symfony utilities for portability of PHP codes
	symfony/security-acl v3.0.0 Symfony Security Component - ACL (Access Control List)
	symfony/swiftmailer-bundle v2.3.11 Symfony SwiftmailerBundle
	symfony/symfony v2.8.6 The Symfony PHP framework
php version	php --version
	PHP 5.6.20 (cli) (built: Mar 31 2016 14:56:44)
	Copyright © 1997-2016 The PHP Group
	Zend Engine v2.6.0, Copyright © 1998-2016 Zend Technologies

Error message

The SF debug bar shows too many queries on all my admin classes. My admin classes have nothing custom. I played a bit with my entities and found out that if I delete the mappedBy fields from my User class, it doesn’t do those queries anymore, but then the entity is not valid anymore, since it needs mappedBy for every inversedBy field.

Steps to reproduce

The admin’s entity

/**
 * @ORM\Table()
 * @ORM\Entity
 */
class BannedUsers
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @ORM\ManyToOne(targetEntity="User")
     * @ORM\JoinColumn(referencedColumnName="id",onDelete="CASCADE")
     */
    private $user;

    /**
     * @ORM\ManyToOne(targetEntity="User")
     * @ORM\JoinColumn(referencedColumnName="id",onDelete="CASCADE")
     */
    private $censor;

    /**
     * @ORM\Column(type="string",nullable=true,length=2000)
     */
    private $reason;


    /**
     * @ORM\Column(type="boolean")
     */
    private $isBanActive=true;

    /**
     * @ORM\Column(type="datetime")
     * @Timestampable(on="create")
     */
    private $bannedAt;

This is my user class, pretty big but maybe it helps:

/**
 * @ORM\Entity(repositoryClass="UserRepository")
 * @ORM\Table(name="fos_user")
 */
class User extends BaseUser
{
    const DEFAULT_PATIENT_CREDIT = 300;

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @ORM\ManyToMany(targetEntity="MedAppBundle\Entity\Group",inversedBy="users")
     * @ORM\JoinTable(name="fos_user_user_group",
     *      joinColumns={@ORM\JoinColumn(name="user_id", referencedColumnName="id",onDelete="CASCADE")},
     *      inverseJoinColumns={@ORM\JoinColumn(name="group_id", referencedColumnName="id")}
     * )
     */
    protected $groups;


    /**
     * @var string
     * @Assert\NotBlank(message="user.firstname.blank",groups={"Profile"})
     * @ORM\Column(name="firstname", type="string",nullable=true)
     */
    protected $firstname;

    /**
     * @var string
     * @Assert\NotBlank(message="user.lastname.blank",groups={"Profile"})
     * @ORM\Column(name="lastname", type="string",nullable=true)
     */
    protected $lastname;

    /**
     * @var string
     *
     * @ORM\Column(name="phoneno", type="string",nullable=true)
     */
    protected $phoneno;

    /**
     * @var string
     *
     * @ORM\Column(name="registration_ip", type="string",nullable=true)
     */
    protected $registrationIp;

    /**
     * @var string
     *
     * @ORM\Column(name="effects", type="boolean")
     */
    protected $effects = true;
    /**
     *
     * @ORM\Column(name="public_email", type="boolean")
     */
    protected $public_email = true;
    /**
     * @Assert\Valid
     * @ORM\OneToOne(targetEntity="MedAppBundle\Entity\MedicSettings",mappedBy="medic", cascade={"persist"})
     * @Assert\Valid()
     */
    protected $medicinfo;
    /**
     * @ORM\OneToMany(targetEntity="MedAppBundle\Entity\MedicComm",mappedBy="medic")
     */
    protected $mediccomm;

    /**
     * @ORM\OneToOne(targetEntity="PrivateMessageBundle\Entity\MessageSettings",mappedBy="user",cascade={"persist"})
     */
    protected $messageSettings;


    /**
     * @ORM\OneToOne(targetEntity="SupportMessageBundle\Entity\TicketSettings",mappedBy="user",cascade={"persist"})
     */
    protected $ticketSettings;

    /**
     * @ORM\OneToOne(targetEntity="Application\Sonata\MediaBundle\Entity\Media",cascade={"persist"})
     * @ORM\JoinColumn(referencedColumnName="id",onDelete="SET NULL")
     */
    protected $profilepic;

    /**
     * @var Media
     *
     * @ORM\OneToMany(targetEntity="Application\Sonata\MediaBundle\Entity\Media", mappedBy="user")
     * @ORM\JoinColumn(name="images", referencedColumnName="id",nullable=true)
     */
    private $images;

    /**
     * @var Media
     *
     * @ORM\OneToMany(targetEntity="Application\Sonata\MediaBundle\Entity\Gallery", mappedBy="user")
     * @ORM\JoinColumn(name="galleries", referencedColumnName="id",nullable=true)
     */
    private $galleries;



    /**
     * @var float
     *
     * @ORM\Column(name="credit", type="float")
     */
    protected $credit = 0;

    /**
     *
     * @ORM\ManyToOne(targetEntity="MedAppBundle\Entity\User")
     * @ORM\JoinColumn(name="referredBy", referencedColumnName="id",nullable=true,onDelete="SET NULL")
     */
    protected $referredBy;

    /**
     * @var string
     *
     * @ORM\Column(name="locationData", type="string",nullable=true)
     */
    protected $locationData;

    /**
     * @ORM\OneToMany(targetEntity="MedAppBundle\Entity\Stream",mappedBy="streamer")
     * @ORM\JoinColumn(referencedColumnName="id")
     */
    private $streams;

    /**
     * @var string
     *
     * @ORM\Column(name="savedFilters", type="string",nullable=true)
     */
    protected $savedFilters;


    /**
     *
     * @ORM\Column(name="registration_date", type="datetime",nullable=true)
     */
    protected $registrationDate;

    /**
     * @ORM\OneToMany(targetEntity="MedAppBundle\Entity\FavoriteUsers",mappedBy="user")
     * @ORM\JoinColumn(referencedColumnName="id")
     */
    private $favUsers;

    /**
     * @var string
     *
     * @ORM\Column(name="chosen_theme", type="string",nullable=true)
     */
    protected $chosenTheme;

    /**
     * @var string
     *
     * @ORM\Column(name="site_lang", type="string",nullable=true)
     */
    protected $siteLang;

    /**
     * @var integer
     *
     * @ORM\Column(name="total_time_live", type="integer", nullable=true)
     *
     */
    protected $totalTimeLive;

    /**
     *
     * @ORM\ManyToOne(targetEntity="FirmBundle\Entity\Firm",inversedBy="firmAdmins", cascade={"persist"})
     */
    protected $adminOfFirm;

    /**
     * @ORM\OneToMany(targetEntity="MedAppBundle\Entity\EmailList",mappedBy="user")
     * @ORM\JoinColumn(referencedColumnName="id")
     */
    private $emailList;

    /**
     * @ORM\OneToOne(targetEntity="MedAppBundle\Entity\Newsletter",mappedBy="user")
     * @ORM\JoinColumn(referencedColumnName="id")
     */
    private $newsletter;

    /**
     * @var string
     *
     * @ORM\Column(name="folderName", type="string", nullable=true)
     */
    public $folderName;

    /**
     *
     * @ORM\Column(name="bonus_received", type="boolean")
     */
    protected $bonusReceived = false;

    /**
     *
     * @ORM\Column(name="purchase_bonus_eligibility", type="boolean", options={"default" = true }, nullable=true )
     */
    protected $purchaseBonusEligibility;

    /**
     * @ORM\OneToMany(targetEntity="MedAppBundle\Entity\PendingProfileImage",mappedBy="user")
     */
    protected $pendingProfileImages;

    /**
     * @ORM\Column(name="is_validated_phone_no", type="boolean", nullable=true)
     */
    private $isValidatedPhoneNo;

    /**
     * @ORM\Column(name="mobile_validation_pin", type="string", nullable=true)
     */
    private $mobileValidationPin;

    /**
     * @ORM\Column(name="username_token", type="string", nullable=true, options={"default" = true })
     */
    private $usernameToken;




    /**
     * @ORM\OneToOne(targetEntity="MedAppBundle\Entity\AccountDocument", mappedBy="user")
     */
    private $accountDocument;


    /**
     * @ORM\OneToMany(targetEntity="MedAppBundle\Entity\AccountDocument", mappedBy="takenByAdmin")
     * @ORM\JoinColumn(referencedColumnName="id",onDelete="CASCADE")
     */
    private $takenPending;

Expected results

If I delete all the mappedBy fields, the same page on my admin shows less queries, as I want it to be, but invalid entity:

Here’s the queries table https://jsfiddle.net/nmxz4j7y/

Actual results

Here’s one of my admin classes’s example:

Here’s the query table: https://jsfiddle.net/nmxz4j7y/1/