Symfony Profiler

[
  "route" => "homepage"
  "route_parameters" => [
    "_route" => "homepage"
    "_locale" => "ar"
    "_controller" => "App\Controller\MainController::homepage"
  ]
  "request_uri" => "https://data.maktabci.net/"
  "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" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "maktabci"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "maktabci"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_disabled AS is_disabled_6, t0.is_root AS is_root_7, t0.is_admin AS is_admin_8, t0.is_archived AS is_archived_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.updated_at AS updated_at_12, t13.id AS id_14, t13.nom_ar AS nom_ar_15, t13.prenom_ar AS prenom_ar_16, t13.nom_fr AS nom_fr_17, t13.prenom_fr AS prenom_fr_18, t13.date_naissance AS date_naissance_19, t13.residence AS residence_20, t13.situation_matrimoniale AS situation_matrimoniale_21, t13.profession AS profession_22, t13.langues_parlees AS langues_parlees_23, t13.ecole_frequentee AS ecole_frequentee_24, t13.lieu_naissance AS lieu_naissance_25, t13.commentaire AS commentaire_26, t13.is_archived AS is_archived_27, t13.contact AS contact_28, t13.numero_piece AS numero_piece_29, t13.date_expiration_piece AS date_expiration_piece_30, t13.specialite AS specialite_31, t13.annee_obtention_diplome AS annee_obtention_diplome_32, t13.date_debut_contrat AS date_debut_contrat_33, t13.lien_facebook AS lien_facebook_34, t13.lien_twitter AS lien_twitter_35, t13.nationalite AS nationalite_36, t13.image_name AS image_name_37, t13.is_predicateur_suivi AS is_predicateur_suivi_38, t13.created_at AS created_at_39, t13.deleted_at AS deleted_at_40, t13.updated_at AS updated_at_41, t13.user_id AS user_id_42, t13.diplome_id AS diplome_id_43, t13.pays_id AS pays_id_44, t13.created_by AS created_by_45, t13.deleted_by AS deleted_by_46, t13.updated_by AS updated_by_47, t0.pays_id AS pays_id_48, t0.created_by AS created_by_49, t0.deleted_by AS deleted_by_50, t0.updated_by AS updated_by_51 FROM `user` t0 LEFT JOIN predicateur t13 ON t13.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "dramane"
]

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "Container8ABSVhv\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "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 count(c0_.id) AS sclr_0 FROM cours c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM seminaire s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(d0_.id) AS sclr_0 FROM dawa d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM conference c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM fatwa f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM sermon s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM reunion r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rappel r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM recherche r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(v0_.id) AS sclr_0 FROM visite_autre v0_ WHERE v0_.predicateur_id = ? AND v0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(v0_.id) AS sclr_0 FROM visite_prison v0_ WHERE v0_.predicateur_id = ? AND v0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM suggestion s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM converti c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(l0_.id) AS sclr_0 FROM livre l0_ WHERE l0_.predicateur_id = ? AND l0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_coran_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_brochure_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_brochure_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_cassette_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_cassette_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_coran_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_livre_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_livre_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM formation f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM traduction t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rencontre r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(p0_.id) AS sclr_0 FROM panel p0_ WHERE p0_.predicateur_id = ? AND p0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.predicateur_id = ? AND j0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(m0_.id) AS sclr_0 FROM magazine m0_ WHERE m0_.predicateur_id = ? AND m0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM radio r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM television t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(a0_.id) AS sclr_0 FROM autre a0_ WHERE a0_.predicateur_id = ? AND a0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM twitter t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM facebook f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(y0_.id) AS sclr_0 FROM youtube y0_ WHERE y0_.predicateur_id = ? AND y0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(z0_.id) AS sclr_0 FROM zoom z0_ WHERE z0_.predicateur_id = ? AND z0_.trimestre_id = ?"
  "params" => [
    1 => 21
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_ar AS nom_ar_2, t0.prenom_ar AS prenom_ar_3, t0.nom_fr AS nom_fr_4, t0.prenom_fr AS prenom_fr_5, t0.date_naissance AS date_naissance_6, t0.residence AS residence_7, t0.situation_matrimoniale AS situation_matrimoniale_8, t0.profession AS profession_9, t0.langues_parlees AS langues_parlees_10, t0.ecole_frequentee AS ecole_frequentee_11, t0.lieu_naissance AS lieu_naissance_12, t0.commentaire AS commentaire_13, t0.is_archived AS is_archived_14, t0.contact AS contact_15, t0.numero_piece AS numero_piece_16, t0.date_expiration_piece AS date_expiration_piece_17, t0.specialite AS specialite_18, t0.annee_obtention_diplome AS annee_obtention_diplome_19, t0.date_debut_contrat AS date_debut_contrat_20, t0.lien_facebook AS lien_facebook_21, t0.lien_twitter AS lien_twitter_22, t0.nationalite AS nationalite_23, t0.image_name AS image_name_24, t0.is_predicateur_suivi AS is_predicateur_suivi_25, t0.created_at AS created_at_26, t0.deleted_at AS deleted_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29, t0.diplome_id AS diplome_id_30, t0.pays_id AS pays_id_31, t0.created_by AS created_by_32, t0.deleted_by AS deleted_by_33, t0.updated_by AS updated_by_34 FROM predicateur t0 WHERE t0.is_predicateur_suivi = ? AND t0.is_archived = ? AND t0.pays_id = ?"
  "params" => [
    1 => 1
    2 => 0
    3 => 1
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 1
  ]
]

[
  "sql" => """
     SELECT c.id, c.created_at AS createdAt, 'cours' AS type FROM cours c WHERE c.predicateur_id = :predicateurId AND c.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT s.id, s.created_at AS createdAt, 'seminaire' AS type FROM seminaire s WHERE s.predicateur_id = :predicateurId AND s.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'dawa' AS type FROM dawa d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT c.id, c.created_at AS createdAt, 'conference' AS type FROM conference c WHERE c.predicateur_id = :predicateurId AND c.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT f.id, f.created_at AS createdAt, 'fatwa' AS type FROM fatwa f WHERE f.predicateur_id = :predicateurId AND f.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'radio' AS type FROM radio r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT s.id, s.created_at AS createdAt, 'sermon' AS type FROM sermon s WHERE s.predicateur_id = :predicateurId AND s.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'reunion' AS type FROM reunion r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'rappel' AS type FROM rappel r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'recherche' AS type FROM recherche r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT v.id, v.created_at AS createdAt, 'visite_autre' AS type FROM visite_autre v WHERE v.predicateur_id = :predicateurId AND v.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT v.id, v.created_at AS createdAt, 'visite_prison' AS type FROM visite_prison v WHERE v.predicateur_id = :predicateurId AND v.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT c.id, c.created_at AS createdAt, 'converti' AS type FROM converti c WHERE c.predicateur_id = :predicateurId AND c.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT l.id, l.created_at AS createdAt, 'livre' AS type FROM livre l WHERE l.predicateur_id = :predicateurId AND l.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_autre' AS type FROM distribution_autre d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_coran_arabe' AS type FROM distribution_coran_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_brochure_arabe' AS type FROM distribution_brochure_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_brochure_traduit' AS type FROM distribution_brochure_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_cassette_arabe' AS type FROM distribution_cassette_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_cassette_traduit' AS type FROM distribution_cassette_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_coran_traduit' AS type FROM distribution_coran_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_livre_arabe' AS type FROM distribution_livre_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_livre_traduit' AS type FROM distribution_livre_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT f.id, f.created_at AS createdAt, 'formation' AS type FROM formation f WHERE f.predicateur_id = :predicateurId AND f.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT t.id, t.created_at AS createdAt, 'traduction' AS type FROM traduction t WHERE t.predicateur_id = :predicateurId AND t.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'rencontre' AS type FROM rencontre r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT p.id, p.created_at AS createdAt, 'panel' AS type FROM panel p WHERE p.predicateur_id = :predicateurId AND p.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT j.id, j.created_at AS createdAt, 'journal' AS type FROM journal j WHERE j.predicateur_id = :predicateurId AND j.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT m.id, m.created_at AS createdAt, 'magazine' AS type FROM magazine m WHERE m.predicateur_id = :predicateurId AND m.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT a.id, a.created_at AS createdAt, 'autre' AS type FROM autre a WHERE a.predicateur_id = :predicateurId AND a.trimestre_id = :trimestreId \n
                     ORDER BY createdAt DESC LIMIT 1\n
                
    """
  "params" => [
    "predicateurId" => 1
    "trimestreId" => 19
  ]
  "types" => []
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM conduite c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM cours c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM seminaire s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(d0_.id) AS sclr_0 FROM dawa d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM conference c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM fatwa f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM sermon s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM reunion r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rappel r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM recherche r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(v0_.id) AS sclr_0 FROM visite_autre v0_ WHERE v0_.predicateur_id = ? AND v0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(v0_.id) AS sclr_0 FROM visite_prison v0_ WHERE v0_.predicateur_id = ? AND v0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM suggestion s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM converti c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(l0_.id) AS sclr_0 FROM livre l0_ WHERE l0_.predicateur_id = ? AND l0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_autre d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_coran_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_brochure_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_brochure_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_cassette_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_cassette_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_coran_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_livre_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_livre_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM formation f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM traduction t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rencontre r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(p0_.id) AS sclr_0 FROM panel p0_ WHERE p0_.predicateur_id = ? AND p0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.predicateur_id = ? AND j0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(m0_.id) AS sclr_0 FROM magazine m0_ WHERE m0_.predicateur_id = ? AND m0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM radio r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM television t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(a0_.id) AS sclr_0 FROM autre a0_ WHERE a0_.predicateur_id = ? AND a0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM twitter t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM facebook f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(y0_.id) AS sclr_0 FROM youtube y0_ WHERE y0_.predicateur_id = ? AND y0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(z0_.id) AS sclr_0 FROM zoom z0_ WHERE z0_.predicateur_id = ? AND z0_.trimestre_id = ?"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rapport r0_ WHERE r0_.predicateur_sunnite_id IS NOT NULL AND r0_.created_by = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rapport r0_ WHERE r0_.predicateur_egare_id IS NOT NULL AND r0_.created_by = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
     SELECT c.id, c.created_at AS createdAt, 'cours' AS type FROM cours c WHERE c.predicateur_id = :predicateurId AND c.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT s.id, s.created_at AS createdAt, 'seminaire' AS type FROM seminaire s WHERE s.predicateur_id = :predicateurId AND s.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'dawa' AS type FROM dawa d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT c.id, c.created_at AS createdAt, 'conference' AS type FROM conference c WHERE c.predicateur_id = :predicateurId AND c.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT f.id, f.created_at AS createdAt, 'fatwa' AS type FROM fatwa f WHERE f.predicateur_id = :predicateurId AND f.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'radio' AS type FROM radio r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT s.id, s.created_at AS createdAt, 'sermon' AS type FROM sermon s WHERE s.predicateur_id = :predicateurId AND s.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'reunion' AS type FROM reunion r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'rappel' AS type FROM rappel r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'recherche' AS type FROM recherche r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT v.id, v.created_at AS createdAt, 'visite_autre' AS type FROM visite_autre v WHERE v.predicateur_id = :predicateurId AND v.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT v.id, v.created_at AS createdAt, 'visite_prison' AS type FROM visite_prison v WHERE v.predicateur_id = :predicateurId AND v.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT c.id, c.created_at AS createdAt, 'converti' AS type FROM converti c WHERE c.predicateur_id = :predicateurId AND c.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT l.id, l.created_at AS createdAt, 'livre' AS type FROM livre l WHERE l.predicateur_id = :predicateurId AND l.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_autre' AS type FROM distribution_autre d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_coran_arabe' AS type FROM distribution_coran_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_brochure_arabe' AS type FROM distribution_brochure_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_brochure_traduit' AS type FROM distribution_brochure_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_cassette_arabe' AS type FROM distribution_cassette_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_cassette_traduit' AS type FROM distribution_cassette_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_coran_traduit' AS type FROM distribution_coran_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_livre_arabe' AS type FROM distribution_livre_arabe d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT d.id, d.created_at AS createdAt, 'distribution_livre_traduit' AS type FROM distribution_livre_traduit d WHERE d.predicateur_id = :predicateurId AND d.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT f.id, f.created_at AS createdAt, 'formation' AS type FROM formation f WHERE f.predicateur_id = :predicateurId AND f.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT t.id, t.created_at AS createdAt, 'traduction' AS type FROM traduction t WHERE t.predicateur_id = :predicateurId AND t.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT r.id, r.created_at AS createdAt, 'rencontre' AS type FROM rencontre r WHERE r.predicateur_id = :predicateurId AND r.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT p.id, p.created_at AS createdAt, 'panel' AS type FROM panel p WHERE p.predicateur_id = :predicateurId AND p.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT j.id, j.created_at AS createdAt, 'journal' AS type FROM journal j WHERE j.predicateur_id = :predicateurId AND j.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT m.id, m.created_at AS createdAt, 'magazine' AS type FROM magazine m WHERE m.predicateur_id = :predicateurId AND m.trimestre_id = :trimestreId\n
                     UNION\n
                     SELECT a.id, a.created_at AS createdAt, 'autre' AS type FROM autre a WHERE a.predicateur_id = :predicateurId AND a.trimestre_id = :trimestreId \n
                     ORDER BY createdAt DESC LIMIT 1\n
                
    """
  "params" => [
    "predicateurId" => 2
    "trimestreId" => 19
  ]
  "types" => []
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM conduite c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM cours c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM seminaire s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(d0_.id) AS sclr_0 FROM dawa d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM conference c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM fatwa f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM sermon s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM reunion r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rappel r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM recherche r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(v0_.id) AS sclr_0 FROM visite_autre v0_ WHERE v0_.predicateur_id = ? AND v0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(v0_.id) AS sclr_0 FROM visite_prison v0_ WHERE v0_.predicateur_id = ? AND v0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(s0_.id) AS sclr_0 FROM suggestion s0_ WHERE s0_.predicateur_id = ? AND s0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(c0_.id) AS sclr_0 FROM converti c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(l0_.id) AS sclr_0 FROM livre l0_ WHERE l0_.predicateur_id = ? AND l0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_autre d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_coran_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_brochure_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_brochure_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_cassette_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_cassette_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_coran_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_livre_arabe d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT sum(d0_.quantite) AS sclr_0 FROM distribution_livre_traduit d0_ WHERE d0_.predicateur_id = ? AND d0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM formation f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM traduction t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM rencontre r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(p0_.id) AS sclr_0 FROM panel p0_ WHERE p0_.predicateur_id = ? AND p0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.predicateur_id = ? AND j0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(m0_.id) AS sclr_0 FROM magazine m0_ WHERE m0_.predicateur_id = ? AND m0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(r0_.id) AS sclr_0 FROM radio r0_ WHERE r0_.predicateur_id = ? AND r0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM television t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(a0_.id) AS sclr_0 FROM autre a0_ WHERE a0_.predicateur_id = ? AND a0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(t0_.id) AS sclr_0 FROM twitter t0_ WHERE t0_.predicateur_id = ? AND t0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(f0_.id) AS sclr_0 FROM facebook f0_ WHERE f0_.predicateur_id = ? AND f0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(y0_.id) AS sclr_0 FROM youtube y0_ WHERE y0_.predicateur_id = ? AND y0_.trimestre_id = ?"
  "params" => [
    1 => 2
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]