Symfony Profiler

[
  "route" => "administracion_home"
  "route_parameters" => [
    "_route" => "administracion_home"
    "_controller" => "App\Controller\ConvocatoriaController::indexAction"
  ]
  "request_uri" => "https://rentabilidad.examia.com/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "rentabilidad"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "10.2.29-MariaDB"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "rentabilidad"
  ]
]

[
  "sql" => "SELECT t0.id AS id_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.date AS date_7, t0.email AS email_8, t0.password AS password_9, t0.salt AS salt_10, t0.isactive AS isactive_11, t0.role AS role_12, t0.enable AS enable_13, t0.looked AS looked_14, t0.expires AS expires_15, t0.ennomina AS ennomina_16, t0.tipo, t1.puederentabilidad AS puederentabilidad_17, t1.puedeinforme AS puedeinforme_18, t1.puedetasas AS puedetasas_19, t1.puedegastosfijos AS puedegastosfijos_20, t1.puedeusuarios AS puedeusuarios_21, t1.puedeverpagosusuarios AS puedeverpagosusuarios_22, t1.puedecand AS puedecand_23, t1.computerbased AS computerbased_24, t1.paperbased AS paperbased_25, t1.tipover AS tipover_26, t1.veredicion AS veredicion_27, t2.puedecand AS puedecand_28, t2.puedeoral AS puedeoral_29, t2.puedeextra AS puedeextra_30, t2.puededevolucion AS puededevolucion_31, t2.puedetasas AS puedetasas_32, t2.puedegastosfijos AS puedegastosfijos_33 FROM user t0 LEFT JOIN usersuperadmin t1 ON t0.id = t1.id LEFT JOIN useradmin t2 ON t0.id = t2.id LEFT JOIN userreviser t3 ON t0.id = t3.id WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "rubensr@winecta.com"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.blocked AS blocked_2, a0_.dateannouncement AS dateannouncement_3, a0_.fechanotificacion AS fechanotificacion_4, a0_.nombre AS nombre_5, a0_.nombrepb AS nombrepb_6, a0_.nombrecb AS nombrecb_7, a0_.isdeleted AS isdeleted_8, a0_.totalcostexamexpenses AS totalcostexamexpenses_9, a0_.totalcostextraexpenses AS totalcostextraexpenses_10, a0_.incorporadocb AS incorporadocb_11, a0_.incorporadopb AS incorporadopb_12, a0_.modificado AS modificado_13, a0_.terminada AS terminada_14, a0_.gastosporcandidato AS gastosporcandidato_15, a0_.ingresosporcandidato AS ingresosporcandidato_16, a0_.calculadoporcandidato AS calculadoporcandidato_17, a0_.venuesparticipantes AS venuesparticipantes_18, a0_.centrosparticipantes AS centrosparticipantes_19, a0_.jsoncertificados AS jsoncertificados_20, a0_.gastoporcandidato AS gastoporcandidato_21, a0_.ingresoporcandidato AS ingresoporcandidato_22, a0_.ratiobeneficioporcandidato AS ratiobeneficioporcandidato_23, a0_.examsandalucia_id AS examsandalucia_id_24 FROM announcement a0_ WHERE a0_.isdeleted = 0 AND a0_.terminada = 0 ORDER BY a0_.dateannouncement DESC) dctrn_result) dctrn_table"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, dateannouncement_3 FROM (SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.blocked AS blocked_2, a0_.dateannouncement AS dateannouncement_3, a0_.fechanotificacion AS fechanotificacion_4, a0_.nombre AS nombre_5, a0_.nombrepb AS nombrepb_6, a0_.nombrecb AS nombrecb_7, a0_.isdeleted AS isdeleted_8, a0_.totalcostexamexpenses AS totalcostexamexpenses_9, a0_.totalcostextraexpenses AS totalcostextraexpenses_10, a0_.incorporadocb AS incorporadocb_11, a0_.incorporadopb AS incorporadopb_12, a0_.modificado AS modificado_13, a0_.terminada AS terminada_14, a0_.gastosporcandidato AS gastosporcandidato_15, a0_.ingresosporcandidato AS ingresosporcandidato_16, a0_.calculadoporcandidato AS calculadoporcandidato_17, a0_.venuesparticipantes AS venuesparticipantes_18, a0_.centrosparticipantes AS centrosparticipantes_19, a0_.jsoncertificados AS jsoncertificados_20, a0_.gastoporcandidato AS gastoporcandidato_21, a0_.ingresoporcandidato AS ingresoporcandidato_22, a0_.ratiobeneficioporcandidato AS ratiobeneficioporcandidato_23, a0_.examsandalucia_id AS examsandalucia_id_24 FROM announcement a0_ WHERE a0_.isdeleted = 0 AND a0_.terminada = 0) dctrn_result_inner ORDER BY dateannouncement_3 DESC) dctrn_result LIMIT 20"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.blocked AS blocked_2, a0_.dateannouncement AS dateannouncement_3, a0_.fechanotificacion AS fechanotificacion_4, a0_.nombre AS nombre_5, a0_.nombrepb AS nombrepb_6, a0_.nombrecb AS nombrecb_7, a0_.isdeleted AS isdeleted_8, a0_.totalcostexamexpenses AS totalcostexamexpenses_9, a0_.totalcostextraexpenses AS totalcostextraexpenses_10, a0_.incorporadocb AS incorporadocb_11, a0_.incorporadopb AS incorporadopb_12, a0_.modificado AS modificado_13, a0_.terminada AS terminada_14, a0_.gastosporcandidato AS gastosporcandidato_15, a0_.ingresosporcandidato AS ingresosporcandidato_16, a0_.calculadoporcandidato AS calculadoporcandidato_17, a0_.venuesparticipantes AS venuesparticipantes_18, a0_.centrosparticipantes AS centrosparticipantes_19, a0_.jsoncertificados AS jsoncertificados_20, a0_.gastoporcandidato AS gastoporcandidato_21, a0_.ingresoporcandidato AS ingresoporcandidato_22, a0_.ratiobeneficioporcandidato AS ratiobeneficioporcandidato_23, a0_.examsandalucia_id AS examsandalucia_id_24, a0_.usercreated_id AS usercreated_id_25 FROM announcement a0_ WHERE a0_.isdeleted = 0 AND a0_.terminada = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.dateannouncement DESC"
  "params" => [
    1 => 2005
    2 => 2001
    3 => 1998
    4 => 2006
    5 => 2002
    6 => 2003
    7 => 1991
    8 => 1989
    9 => 1995
    10 => 1999
    11 => 2000
    12 => 1993
    13 => 1996
    14 => 1990
    15 => 1994
    16 => 2004
    17 => 1985
    18 => 1992
    19 => 1984
    20 => 1986
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#653}
    3 => Doctrine\DBAL\ParameterType {#653}
    4 => Doctrine\DBAL\ParameterType {#653}
    5 => Doctrine\DBAL\ParameterType {#653}
    6 => Doctrine\DBAL\ParameterType {#653}
    7 => Doctrine\DBAL\ParameterType {#653}
    8 => Doctrine\DBAL\ParameterType {#653}
    9 => Doctrine\DBAL\ParameterType {#653}
    10 => Doctrine\DBAL\ParameterType {#653}
    11 => Doctrine\DBAL\ParameterType {#653}
    12 => Doctrine\DBAL\ParameterType {#653}
    13 => Doctrine\DBAL\ParameterType {#653}
    14 => Doctrine\DBAL\ParameterType {#653}
    15 => Doctrine\DBAL\ParameterType {#653}
    16 => Doctrine\DBAL\ParameterType {#653}
    17 => Doctrine\DBAL\ParameterType {#653}
    18 => Doctrine\DBAL\ParameterType {#653}
    19 => Doctrine\DBAL\ParameterType {#653}
    20 => Doctrine\DBAL\ParameterType {#653}
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numberofcandidates AS numberofcandidates_2, t0.candidatesocupados AS candidatesocupados_3, t0.publicfee AS publicfee_4, t0.boardfee AS boardfee_5, t0.type AS type_6, t0.codecenter AS codecenter_7, t0.rate_id AS rate_id_8, t0.announcement_id AS announcement_id_9 FROM examtype t0 WHERE t0.announcement_id = ?"
  "params" => [
    1 => 2005
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.isdeleted AS isdeleted_3, t0.dateworksheet AS dateworksheet_4, t0.starttime AS starttime_5, t0.endtime AS endtime_6, t0.totalnumberofcandidates AS totalnumberofcandidates_7, t0.totalpublicfee AS totalpublicfee_8, t0.totalboardfee AS totalboardfee_9, t0.haspayvenue AS haspayvenue_10, t0.payvenue AS payvenue_11, t0.payvenuetext AS payvenuetext_12, t0.numberfroom AS numberfroom_13, t0.totalcosttsa AS totalcosttsa_14, t0.totalextrapaytsa AS totalextrapaytsa_15, t0.totalcostvigilant AS totalcostvigilant_16, t0.totalcostextrapayvigilant AS totalcostextrapayvigilant_17, t0.totalcostauxiliarpersonnel AS totalcostauxiliarpersonnel_18, t0.totalcostextrapayauxiliarpersonnel AS totalcostextrapayauxiliarpersonnel_19, t0.type AS type_20, t0.venuenotificado AS venuenotificado_21, t0.datevenuenotificado AS datevenuenotificado_22, t0.usercreated_id AS usercreated_id_23, t0.center_id AS center_id_24, t0.venue_id AS venue_id_25, t0.announcement_id AS announcement_id_26, t0.slot_id AS slot_id_27 FROM worksheet t0 WHERE t0.announcement_id = ? ORDER BY t0.center_id ASC"
  "params" => [
    1 => 2005
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.examname AS examname_2, t0.date AS date_3, t0.isdeleted AS isdeleted_4, t0.publicfee AS publicfee_5, t0.boardfee AS boardfee_6, t0.tsa AS tsa_7, t0.supervisor AS supervisor_8, t0.supervisororal AS supervisororal_9, t0.usher AS usher_10, t0.oralexaminer AS oralexaminer_11, t0.auxiliarpersonnel AS auxiliarpersonnel_12, t0.venue AS venue_13, t0.vigilant AS vigilant_14, t0.idcrm AS idcrm_15, t0.examsandalucia_id AS examsandalucia_id_16 FROM rate t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numberofcandidates AS numberofcandidates_2, t0.candidatesocupados AS candidatesocupados_3, t0.publicfee AS publicfee_4, t0.boardfee AS boardfee_5, t0.type AS type_6, t0.codecenter AS codecenter_7, t0.rate_id AS rate_id_8, t0.announcement_id AS announcement_id_9 FROM examtype t0 WHERE t0.announcement_id = ?"
  "params" => [
    1 => 2001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.isdeleted AS isdeleted_3, t0.dateworksheet AS dateworksheet_4, t0.starttime AS starttime_5, t0.endtime AS endtime_6, t0.totalnumberofcandidates AS totalnumberofcandidates_7, t0.totalpublicfee AS totalpublicfee_8, t0.totalboardfee AS totalboardfee_9, t0.haspayvenue AS haspayvenue_10, t0.payvenue AS payvenue_11, t0.payvenuetext AS payvenuetext_12, t0.numberfroom AS numberfroom_13, t0.totalcosttsa AS totalcosttsa_14, t0.totalextrapaytsa AS totalextrapaytsa_15, t0.totalcostvigilant AS totalcostvigilant_16, t0.totalcostextrapayvigilant AS totalcostextrapayvigilant_17, t0.totalcostauxiliarpersonnel AS totalcostauxiliarpersonnel_18, t0.totalcostextrapayauxiliarpersonnel AS totalcostextrapayauxiliarpersonnel_19, t0.type AS type_20, t0.venuenotificado AS venuenotificado_21, t0.datevenuenotificado AS datevenuenotificado_22, t0.usercreated_id AS usercreated_id_23, t0.center_id AS center_id_24, t0.venue_id AS venue_id_25, t0.announcement_id AS announcement_id_26, t0.slot_id AS slot_id_27 FROM worksheet t0 WHERE t0.announcement_id = ? ORDER BY t0.center_id ASC"
  "params" => [
    1 => 2001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.examname AS examname_2, t0.date AS date_3, t0.isdeleted AS isdeleted_4, t0.publicfee AS publicfee_5, t0.boardfee AS boardfee_6, t0.tsa AS tsa_7, t0.supervisor AS supervisor_8, t0.supervisororal AS supervisororal_9, t0.usher AS usher_10, t0.oralexaminer AS oralexaminer_11, t0.auxiliarpersonnel AS auxiliarpersonnel_12, t0.venue AS venue_13, t0.vigilant AS vigilant_14, t0.idcrm AS idcrm_15, t0.examsandalucia_id AS examsandalucia_id_16 FROM rate t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numberofcandidates AS numberofcandidates_2, t0.candidatesocupados AS candidatesocupados_3, t0.publicfee AS publicfee_4, t0.boardfee AS boardfee_5, t0.type AS type_6, t0.codecenter AS codecenter_7, t0.rate_id AS rate_id_8, t0.announcement_id AS announcement_id_9 FROM examtype t0 WHERE t0.announcement_id = ?"
  "params" => [
    1 => 1998
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.isdeleted AS isdeleted_3, t0.dateworksheet AS dateworksheet_4, t0.starttime AS starttime_5, t0.endtime AS endtime_6, t0.totalnumberofcandidates AS totalnumberofcandidates_7, t0.totalpublicfee AS totalpublicfee_8, t0.totalboardfee AS totalboardfee_9, t0.haspayvenue AS haspayvenue_10, t0.payvenue AS payvenue_11, t0.payvenuetext AS payvenuetext_12, t0.numberfroom AS numberfroom_13, t0.totalcosttsa AS totalcosttsa_14, t0.totalextrapaytsa AS totalextrapaytsa_15, t0.totalcostvigilant AS totalcostvigilant_16, t0.totalcostextrapayvigilant AS totalcostextrapayvigilant_17, t0.totalcostauxiliarpersonnel AS totalcostauxiliarpersonnel_18, t0.totalcostextrapayauxiliarpersonnel AS totalcostextrapayauxiliarpersonnel_19, t0.type AS type_20, t0.venuenotificado AS venuenotificado_21, t0.datevenuenotificado AS datevenuenotificado_22, t0.usercreated_id AS usercreated_id_23, t0.center_id AS center_id_24, t0.venue_id AS venue_id_25, t0.announcement_id AS announcement_id_26, t0.slot_id AS slot_id_27 FROM worksheet t0 WHERE t0.announcement_id = ? ORDER BY t0.center_id ASC"
  "params" => [
    1 => 1998
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numberofcandidates AS numberofcandidates_2, t0.candidatesocupados AS candidatesocupados_3, t0.publicfee AS publicfee_4, t0.boardfee AS boardfee_5, t0.type AS type_6, t0.codecenter AS codecenter_7, t0.rate_id AS rate_id_8, t0.announcement_id AS announcement_id_9 FROM examtype t0 WHERE t0.announcement_id = ?"
  "params" => [
    1 => 2006
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.isdeleted AS isdeleted_3, t0.dateworksheet AS dateworksheet_4, t0.starttime AS starttime_5, t0.endtime AS endtime_6, t0.totalnumberofcandidates AS totalnumberofcandidates_7, t0.totalpublicfee AS totalpublicfee_8, t0.totalboardfee AS totalboardfee_9, t0.haspayvenue AS haspayvenue_10, t0.payvenue AS payvenue_11, t0.payvenuetext AS payvenuetext_12, t0.numberfroom AS numberfroom_13, t0.totalcosttsa AS totalcosttsa_14, t0.totalextrapaytsa AS totalextrapaytsa_15, t0.totalcostvigilant AS totalcostvigilant_16, t0.totalcostextrapayvigilant AS totalcostextrapayvigilant_17, t0.totalcostauxiliarpersonnel AS totalcostauxiliarpersonnel_18, t0.totalcostextrapayauxiliarpersonnel AS totalcostextrapayauxiliarpersonnel_19, t0.type AS type_20, t0.venuenotificado AS venuenotificado_21, t0.datevenuenotificado AS datevenuenotificado_22, t0.usercreated_id AS usercreated_id_23, t0.center_id AS center_id_24, t0.venue_id AS venue_id_25, t0.announcement_id AS announcement_id_26, t0.slot_id AS slot_id_27 FROM worksheet t0 WHERE t0.announcement_id = ? ORDER BY t0.center_id ASC"
  "params" => [
    1 => 2006
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numberofcandidates AS numberofcandidates_2, t0.candidatesocupados AS candidatesocupados_3, t0.publicfee AS publicfee_4, t0.boardfee AS boardfee_5, t0.type AS type_6, t0.codecenter AS codecenter_7, t0.rate_id AS rate_id_8, t0.announcement_id AS announcement_id_9 FROM examtype t0 WHERE t0.announcement_id = ?"
  "params" => [
    1 => 2002
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.isdeleted AS isdeleted_3, t0.dateworksheet AS dateworksheet_4, t0.starttime AS starttime_5, t0.endtime AS endtime_6, t0.totalnumberofcandidates AS totalnumberofcandidates_7, t0.totalpublicfee AS totalpublicfee_8, t0.totalboardfee AS totalboardfee_9, t0.haspayvenue AS haspayvenue_10, t0.payvenue AS payvenue_11, t0.payvenuetext AS payvenuetext_12, t0.numberfroom AS numberfroom_13, t0.totalcosttsa AS totalcosttsa_14, t0.totalextrapaytsa AS totalextrapaytsa_15, t0.totalcostvigilant AS totalcostvigilant_16, t0.totalcostextrapayvigilant AS totalcostextrapayvigilant_17, t0.totalcostauxiliarpersonnel AS totalcostauxiliarpersonnel_18, t0.totalcostextrapayauxiliarpersonnel AS totalcostextrapayauxiliarpersonnel_19, t0.type AS type_20, t0.venuenotificado AS venuenotificado_21, t0.datevenuenotificado AS datevenuenotificado_22, t0.usercreated_id AS usercreated_id_23, t0.center_id AS center_id_24, t0.venue_id AS venue_id_25, t0.announcement_id AS announcement_id_26, t0.slot_id AS slot_id_27 FROM worksheet t0 WHERE t0.announcement_id = ? ORDER BY t0.center_id ASC"
  "params" => [
    1 => 2002
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.examname AS examname_2, t0.date AS date_3, t0.isdeleted AS isdeleted_4, t0.publicfee AS publicfee_5, t0.boardfee AS boardfee_6, t0.tsa AS tsa_7, t0.supervisor AS supervisor_8, t0.supervisororal AS supervisororal_9, t0.usher AS usher_10, t0.oralexaminer AS oralexaminer_11, t0.auxiliarpersonnel AS auxiliarpersonnel_12, t0.venue AS venue_13, t0.vigilant AS vigilant_14, t0.idcrm AS idcrm_15, t0.examsandalucia_id AS examsandalucia_id_16 FROM rate t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.examname AS examname_2, t0.date AS date_3, t0.isdeleted AS isdeleted_4, t0.publicfee AS publicfee_5, t0.boardfee AS boardfee_6, t0.tsa AS tsa_7, t0.supervisor AS supervisor_8, t0.supervisororal AS supervisororal_9, t0.usher AS usher_10, t0.oralexaminer AS oralexaminer_11, t0.auxiliarpersonnel AS auxiliarpersonnel_12, t0.venue AS venue_13, t0.vigilant AS vigilant_14, t0.idcrm AS idcrm_15, t0.examsandalucia_id AS examsandalucia_id_16 FROM rate t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#653
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]