Extbase Variable Dump
TYPO3\CMS\Core\Database\Query\QueryBuilderprototypeobject
   connection => protectedTYPO3\CMS\Core\Database\Connectionprototypeobject
      _expr => protectedTYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilderprototypeobject
         connection => protectedTYPO3\CMS\Core\Database\Connectionprototypeobjectsee above
      prepareConnectionCommands => privatearray(empty)
      _conn => protectedDoctrine\DBAL\Driver\Mysqli\Connectionprototypeobject
      _config => protectedDoctrine\DBAL\Configurationprototypeobject
         _attributes => protectedarray(empty)
      _eventManager => protectedDoctrine\Common\EventManagerprototypeobject
         listeners => privatearray(3 items)
            onSchemaColumnDefinition => array(1 item)
               00000000687bdd370000000062ebbde8 => TYPO3\CMS\Core\Database\Schema\EventListener\SchemaColumnDefinitionListenerprototypeobject
            onSchemaIndexDefinition => array(1 item)
               00000000687bdd080000000062ebbde8 => TYPO3\CMS\Core\Database\Schema\EventListener\SchemaIndexDefinitionListenerprototypeobject
            onSchemaAlterTable => array(1 item)
               00000000687bdd360000000062ebbde8 => TYPO3\CMS\Core\Database\Schema\EventListener\SchemaAlterTableListenerprototypeobject
      _schemaManager => protectedNULL
      _driver => protectedDoctrine\DBAL\Driver\Mysqli\Driverprototypeobject
      defaultFetchMode => protected2 (integer)
      logger => protectedNULL
   concreteQueryBuilder => protectedDoctrine\DBAL\Query\QueryBuilderprototypeobject
      connection => privateTYPO3\CMS\Core\Database\Connectionprototypeobjectsee above
      sqlParts => privatearray(10 items)
         select => array(16 items)
            0 => '`items`.`uid` AS `uid`' (22 chars)
            1 => '`items`.`pid` AS `pid`' (22 chars)
            2 => '`items`.`tstamp` AS `tstamp`' (28 chars)
            3 => '`items`.`title` AS `title`' (26 chars)
            4 => '`items`.`subtitle` AS `subtitle`' (32 chars)
            5 => '`items`.`nav_title` AS `nav_title`' (34 chars)
            6 => '`items`.`abstract` AS `abstract`' (32 chars)
            7 => '`items`.`abstract` AS `content`' (31 chars)
            8 => '`items`.`media` AS `image`' (26 chars)
            9 => '`items`.`lastUpdated` AS `datetime`' (35 chars)
            10 => '`items`.`doktype` AS `cobjtype`' (31 chars)
            11 => '`items`.`target` AS `target`' (28 chars)
            12 => '`items`.`sorting` AS `ranking`' (30 chars)
            13 => '`items`.`sorting` AS `sorting`' (30 chars)
            14 => ''pages' as ctype' (16 chars)
            15 => 'media.uid as mediaUid, media.identifier as mediaPath' (52 chars)
         distinct => FALSE
         from => array(1 item)
            0 => array(2 items)
               table => '`pages`' (7 chars)
               alias => '`items`' (7 chars)
         join => array(2 items)
            `items` => array(1 item)
               0 => array(4 items)
                  joinType => 'inner' (5 chars)
                  joinTable => '`sys_file_reference`' (20 chars)
                  joinAlias => '`ref`' (5 chars)
                  joinCondition => '(`items`.`uid` = `ref`.`uid_foreign`) AND (`ref`.`tablenames` = 'pages') AND
                      (`ref`.`fieldname` = 'media') AND (`ref`.`deleted` = 0) AND (`ref`.`hidden`
                      = 0) AND (`ref`.`showinpreview` IN (1, 2))
' (195 chars)
`ref` => array(1 item) 0 => array(4 items) joinType => 'left' (4 chars) joinTable => '`sys_file`' (10 chars) joinAlias => '`media`' (7 chars) joinCondition => TYPO3\CMS\Core\Database\Query\Expression\CompositeExpressionprototypeobject (1 items) parts => privatearray(1 item)max depth type => private'AND' (3 chars)
set => array(empty) where => TYPO3\CMS\Core\Database\Query\Expression\CompositeExpressionprototypeobject (7 items) parts => privatearray(7 items) 0 => '`items`.`tstamp` <= 1713973509' (30 chars) 1 => TYPO3\CMS\Core\Database\Query\Expression\CompositeExpressionprototypeobject (1 items) parts => privatearray(1 item) 0 => '`doktype` = 3' (13 chars) type => private'OR' (2 chars) 2 => '`items`.`pid` IN (7595, 9772, 12409, 12404)' (43 chars) 3 => '`items`.`hidden` IN (0)' (23 chars) 4 => '`items`.`deleted` IN (0)' (24 chars) 5 => '`items`.`hidden` IN (0)' (23 chars) 6 => '`items`.`deleted` IN (0)' (24 chars) type => private'AND' (3 chars) groupBy => array(empty) having => NULL orderBy => array(empty) values => array(empty)
sql => privateNULL params => privatearray(empty) paramTypes => privatearray(empty) type => private0 (integer) state => private0 (integer) firstResult => private0 (integer) maxResults => privateNULL boundCounter => private0 (integer)
restrictionContainer => protectedTYPO3\CMS\Core\Database\Query\Restriction\DefaultRestrictionContainerprototypeobject defaultRestrictionTypes => protectedarray(4 items) 0 => 'TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction' (60 chars) 1 => 'TYPO3\CMS\Core\Database\Query\Restriction\HiddenRestriction' (59 chars) 2 => 'TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestriction' (62 chars) 3 => 'TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestriction' (60 chars) restrictions => protectedarray(5 items) TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction => TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestrictionprototypeobject TYPO3\CMS\Core\Database\Query\Restriction\HiddenRestriction => TYPO3\CMS\Core\Database\Query\Restriction\HiddenRestrictionprototypeobject TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestriction => TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestrictionprototypeobject accessTimeStamp => protected1713973500 (integer) TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestriction => TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestrictionprototypeobject accessTimeStamp => protected1713973500 (integer) Bitmotion\MarketingAutomation\Persona\PersonaRestriction => Bitmotion\MarketingAutomation\Persona\PersonaRestrictionsingletonobject sqlFieldTemplate => private'CREATE TABLE %s ( `%s` varchar(100) DEFAULT '' NOT NULL);' (57 chars) tcaFieldTemplate => privatearray(2 items) label => 'LLL:EXT:marketing_automation/Resources/Private/Language/locallang_tca.xlf:tx
                  _marketingautomation_persona_restriction.label
' (122 chars) config => array(6 items) type => 'select' (6 chars) renderType => 'selectMultipleSideBySide' (24 chars) exclusiveKeys => '-1' (2 chars) foreign_table => 'tx_marketingautomation_persona' (30 chars) foreign_table_where => 'ORDER BY tx_marketingautomation_persona.title' (45 chars) items => array(3 items) 0 => array(2 items)max depth 1 => array(2 items)max depth 2 => array(2 items)max depth
persona => privateBitmotion\MarketingAutomation\Persona\Personaprototypeobject id => protected0 (integer) language => protected0 (integer)
enforcedRestrictions => protectedarray(1 item) Bitmotion\MarketingAutomation\Persona\PersonaRestriction => Bitmotion\MarketingAutomation\Persona\PersonaRestrictionsingletonobjectsee above
additionalRestrictions => protectedarray(1 item) Bitmotion\MarketingAutomation\Persona\PersonaRestriction => array(empty) restrictionsAppliedInJoinCondition => privatearray(1 item) 0 => 'media' (5 chars)