Symfony Profiler

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

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;

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

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 = 2005 ORDER BY t0.center_id ASC;

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 = ?

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 = 2005;

SELECT
  t0.id AS id_1,
  t0.candidatos_vendidos AS candidatos_vendidos_2,
  t0.candidatosenworksheet AS candidatosenworksheet_3,
  t0.examtype_id AS examtype_id_4,
  t0.worksheet_id AS worksheet_id_5
FROM
  examtype_sale t0
WHERE
  t0.worksheet_id = ?

SELECT t0.id AS id_1, t0.candidatos_vendidos AS candidatos_vendidos_2, t0.candidatosenworksheet AS candidatosenworksheet_3, t0.examtype_id AS examtype_id_4, t0.worksheet_id AS worksheet_id_5 FROM examtype_sale t0 WHERE t0.worksheet_id = 12399;

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 = ?

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 = 4;

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

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;

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 = ?

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 = 19;

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

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 (2005, 2001, 1998, 2006, 2002, 2003, 1991, 1989, 1995, 1999, 2000, 1993, 1996, 1990, 1994, 2004, 1985, 1992, 1984, 1986) ORDER BY a0_.dateannouncement DESC;