Symfony Profiler

[
  "route" => "report_payment_transactions"
  "route_parameters" => [
    "_route" => "report_payment_transactions"
    "_controller" => "App\Controller\ReportController::paymentTransactions"
    "platform" => "openpay"
  ]
  "request_uri" => "https://efectivate.zentro.com.mx/reportes/cobros/transacciones/openpay?end=2026-06-15&start=2026-06-15"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\TwoFactorAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\TwoFactorAuthenticator"
]

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

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

[
  "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\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"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "db_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "efectivate_2025"
    "serverVersion" => "10.11.6-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 240427
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "oscar.vasquez+4@zentro.com.mx"
]

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

[
  "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" => "ContainerEJtRxA2\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => """
    SELECT pay.id_prestamo, MAX( pay.id ) AS id_pago, (SELECT bank_code FROM openpay_instrumentos WHERE id = (SELECT op_inst FROM prestamo_pago WHERE id=MAX( pay.id ))) AS bank,  (SELECT campo_valor FROM prestamo_solicitud_formulario WHERE id_prestamo = pay.id_prestamo AND campo_tipo = 11) AS empresa \n
                    FROM prestamo_pago AS pay WHERE pay.is_nc IS FALSE AND pay.rutasoporte IS NULL AND pay.status IN (2, 3) \n
                    AND pay.fec_pago BETWEEN "2026-06-15 00:00:00" AND "2026-06-15 23:59:59" AND pay.is_op_trans IS TRUE GROUP BY pay.id_prestamo
    """
]

[
  "sql" => "SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.landing_show AS landing_show_3, t0.landing_name AS landing_name_4, t0.image AS image_5, t0.estado AS estado_6, t0.image_size AS image_size_7, t0.updated_at AS updated_at_8 FROM formulario_empresas_filiales t0 WHERE t0.descripcion IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.descripcion ASC"
  "params" => [
    1 => "SECRETARIA DE SALUD SONORA"
    2 => "GOBIERNO DE TABASCO SANTANDER ST"
    3 => "GOBIERNO DE TABASCO BANORTE OP"
    4 => "SECRETARIA DE SALUD CHIAPAS BANCOMER MCO"
    5 => "SECRETARIA DE SALUD DURANGO RD"
    6 => "GOBIERNO DE CHIHUAHUA SANTANDER ST"
    7 => "SECRETARIA DE SALUD DURANGO SANTANDER MST"
    8 => "CBTIS F BANAMEX MOP"
    9 => "COPPEL BANCOPPEL MOP"
    10 => "COPPEL BANCOPPEL MOP"
    11 => "CBTIS F BANAMEX OPCO"
    12 => "CBTIS F BANAMEX OPCO"
    13 => "SECRETARIA DE SALUD SONORA BANORTE OP"
    14 => "COPPEL BANCOPPEL MST"
    15 => "COPPEL BANCOPPEL MST"
    16 => "GOBIERNO DE CHIHUAHUA SANTANDER ST"
    17 => "SECRETARIA DE SALUD CHIAPAS BANORTE MCO"
    18 => "GOBIERNO DE CHIHUAHUA BANCOMER CO"
    19 => "GOBIERNO DE CHIHUAHUA BANCOMER CO"
    20 => "COPPEL BANCOPPEL MOP"
    21 => "SECRETARIA DE SALUD AGUASCALIENTES BANORTE OP"
    22 => "SEP ESTATAL ZACATECAS BANCOMER MOP"
    23 => "SECRETARIA DE SALUD SINALOA RD"
    24 => "SECRETARIA DE SALUD SONORA RD"
    25 => "SECRETARIA DE SALUD GUANAJUATO RD"
    26 => "SECRETARIA DE SALUD YUCATAN HSBC MST"
    27 => "SECRETARIA DE SALUD SONORA RD"
    28 => "GOBIERNO DE CHIHUAHUA BANCOMER CO"
    29 => "COPPEL BANCOPPEL MST"
    30 => "COPPEL BANCOPPEL MST"
    31 => "SECRETARIA DE SALUD SONORA RD"
    32 => "GOBIERNO DE CHIHUAHUA BANORTE OP"
    33 => "GOBIERNO DE CHIHUAHUA SANTANDER ST"
    34 => "SECRETARIA DE SALUD CHIAPAS BANORTE MCO"
    35 => "CBTIS F BANAMEX OPCO"
    36 => "SECRETARIA DE SALUD CHIAPAS BANORTE MOP"
    37 => "COPPEL BANCOPPEL MST"
    38 => "ISSEMYM BANCOMER MCO"
    39 => "CBTIS F BANAMEX MOP"
    40 => "SECRETARIA DE SALUD SONORA SANTANDER MOP"
    41 => "COPPEL BANCOPPEL MST"
    42 => "SECRETARIA DE SALUD OAXACA BANORTE MCO"
    43 => "COPPEL BANCOPPEL MST"
    44 => "COPPEL BANCOPPEL MST"
    45 => "COPPEL BANCOPPEL MST"
    46 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    47 => "CBTIS F BANAMEX OPCO"
    48 => "SECRETARIA DE SALUD ESTADO DE MEXICO BANAMEX MST"
    49 => "COPPEL BANCOPPEL MST"
    50 => "IMSS BANCOMER MOP3"
    51 => "CBTIS F BANAMEX OPCO"
    52 => "CBTIS F BANAMEX MOP"
    53 => "SECRETARIA DE SALUD GUANAJUATO RD"
    54 => "SECRETARIA DE SALUD GUERRERO HSBC ST"
    55 => "COPPEL BANCOPPEL MST"
    56 => "SECRETARIA DE SALUD OAXACA BANORTE MOP"
    57 => "SEP ESTATAL TABASCO NEGRO BANCOMER MOP"
    58 => "CBTIS F BANAMEX OPCO"
    59 => "SECRETARIA DE SALUD CHIHUAHUA BANCOMER MCO"
    60 => "COPPEL BANCOPPEL MST"
    61 => "ISSEMYM BANCOMER MCO"
    62 => "SECRETARIA DE SALUD CHIAPAS BANORTE MOP"
    63 => "SEP ESTATAL ESTADO DE MEXICO BANORTE OP2"
    64 => "SEP ESTATAL ESTADO DE MEXICO BANORTE CO2"
    65 => "SECRETARIA DE SALUD SINALOA BANAMEX OP"
    66 => "COPPEL BANCOPPEL MOP"
    67 => "CBTIS F BANAMEX OPCO"
    68 => "CBTIS F BANAMEX OP"
    69 => "GOBIERNO DE CHIHUAHUA SANTANDER ST"
    70 => "SECRETARIA DE SALUD SONORA BANORTE OP"
    71 => "COPPEL BANCOPPEL MST"
    72 => "SECRETARIA DE SALUD CHIAPAS BANCOMER OP"
    73 => "SECRETARIA DE SALUD VERACRUZ FEDERAL BANORTE OPCO"
    74 => "SEP ESTATAL ESTADO DE MEXICO BANORTE OP3"
    75 => "SECRETARIA DE SALUD GUANAJUATO SANTANDER BLANCO ST"
    76 => "SECRETARIA DE SALUD CHIAPAS BANCOMER MCO"
    77 => "SEP FEDERAL GUANAJUATO F BANORTE MCO"
    78 => "GOBIERNO DE CHIHUAHUA BANORTE OP"
    79 => "SECRETARIA DE SALUD DURANGO BANORTE OP"
    80 => "SECRETARIA DE SALUD GUERRERO SANTANDER MCO"
    81 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    82 => "IMSS BANCOMER CO2"
    83 => "SEP FEDERAL DURANGO F BANAMEX MOP"
    84 => "SALUD COLIMA RD"
    85 => "COPPEL BANCOPPEL CO"
    86 => "SEP ESTATAL ZACATECAS BANCOMER MOP"
    87 => "CBTIS F BANAMEX OPCO"
    88 => "SECRETARIA DE SALUD CHIHUAHUA RD"
    89 => "SECRETARIA DE SALUD CHIAPAS BANORTE MOP"
    90 => "SECRETARIA DE SALUD CHIAPAS BANCOMER MCO"
    91 => "SECRETARIA DE SALUD GUANAJUATO SANTANDER BLANCO CO"
    92 => "SECRETARIA DE SALUD CHIHUAHUA SANTANDER ST"
    93 => "CBTIS F BANAMEX OP"
    94 => "CBTIS F SANTANDER ST"
    95 => "SEP FEDERAL BAJA CALIFORNIA F BANORTE CO"
    96 => "CBTIS F BANAMEX OPCO"
    97 => "SECRETARIA DE SALUD VERACRUZ FEDERAL BANCOMER MOP"
    98 => "CBTIS F BANORTE MCO"
    99 => "SEP FEDERAL CAMPECHE F BANAMEX OPCO"
    100 => "SEP FEDERAL GUANAJUATO F BANCOMER CO"
    101 => "SEP FEDERAL GUANAJUATO F BANORTE OP"
    102 => "SECRETARIA DE SALUD NAYARIT BANORTE OP"
    103 => "CBTIS F BANAMEX MOP"
    104 => "SECRETARIA DE SALUD SINALOA BANAMEX OP"
    105 => "IMSS BANCOMER OP2"
    106 => "IMSS BANORTE NUEVOS CK2"
    107 => "IMSS BANAMEX ST2"
    108 => "CBTIS F BANAMEX MOP"
    109 => "COPPEL BANCOPPEL MOP"
    110 => "GOBIERNO DE BAJA CALIFORNIA BANORTE OP"
    111 => "IMSS BANORTE OP"
    112 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    113 => "SECRETARIA DE SALUD CHIAPAS BANCOMER MCO"
    114 => "GOBIERNO DE CHIHUAHUA SANTANDER ST"
    115 => "CBTIS F BANAMEX OPCO"
    116 => "SEP ESTATAL TABASCO NEGRO BANCOMER OP"
    117 => "SEP FEDERAL TAMAULIPAS F BANORTE OP"
    118 => "SEP ESTATAL TABASCO NEGRO BANCOMER MCO"
    119 => "COPPEL BANCOPPEL CO"
    120 => "SECRETARIA DE SALUD ESTADO DE MEXICO SANTANDER ST"
    121 => "CBTIS F BANCOMER MCO"
    122 => "IMSS BANCOMER MOP"
    123 => "CBTIS F BANCOMER MCO"
    124 => "SECRETARIA DE SALUD NAYARIT BANCOMER CO"
    125 => "CBTIS F BANAMEX ST"
    126 => "SECRETARIA DE SALUD CHIAPAS BANORTE MCO"
    127 => "SECRETARIA DE SALUD YUCATAN BANORTE OP"
    128 => "IMSS BANAMEX OPCO2"
    129 => "COPPEL BANCOPPEL ST"
    130 => "SEP FEDERAL CAMPECHE F BANAMEX OPCO"
    131 => "CBTIS F BANAMEX OPCO"
    132 => "SECRETARIA DE SALUD OAXACA BANORTE MOP"
    133 => "SECRETARIA DE SALUD CHIAPAS BANORTE MOP"
    134 => "CBTIS F BANAMEX OPCO"
    135 => "SEP FEDERAL DURANGO F BANORTE OP"
    136 => "SECRETARIA DE SALUD HIDALGO BANCOMER OP"
    137 => "SECRETARIA DE SALUD SONORA BANORTE MOP"
    138 => "ISSEMYM BANCOMER CO"
    139 => "GOBIERNO DE SINALOA BANCOMER CO"
    140 => "CBTIS F BANCOMER MOP"
    141 => "CBTIS F BANORTE OP"
    142 => "SECRETARIA DE SALUD SONORA BANORTE OP"
    143 => "SECRETARIA DE SALUD GUERRERO SANTANDER ST"
    144 => "CBTIS F BANCOMER MOP"
    145 => "CBTIS F BANAMEX OPCO"
    146 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    147 => "SECRETARIA DE SALUD COLIMA BANORTE OP"
    148 => "SECRETARIA DE SALUD GUANAJUATO SANTANDER 3 UN"
    149 => "CBTIS F BANAMEX OP"
    150 => "SECRETARIA DE SALUD NAYARIT BANORTE OP"
    151 => "SECRETARIA DE SALUD SONORA BANORTE MOP"
    152 => "SEP ESTATAL ESTADO DE MEXICO BANORTE MOP2"
    153 => "SEP FEDERAL MEXICO F BANAMEX OP"
    154 => "SECRETARIA DE SALUD CHIAPAS BANORTE OP"
    155 => "COPPEL BANCOPPEL ST"
    156 => "SECRETARIA DE SALUD GUANAJUATO BANORTE"
    157 => "SECRETARIA DE SALUD CHIHUAHUA BANCOMER MCO"
    158 => "SECRETARIA DE SALUD VERACRUZ FEDERAL BANAMEX ST"
    159 => "SECRETARIA DE SALUD SINALOA BANCOMER CO"
    160 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    161 => "CBTIS F BANAMEX ST"
    162 => "CBTIS F BANAMEX MOP"
    163 => "SEP ESTATAL TABASCO NEGRO BANAMEX ST"
    164 => "COPPEL BANCOPPEL CO"
    165 => "SEP ESTATAL NUEVO LEON BANORTE OP"
    166 => "SECRETARIA DE SALUD CHIAPAS BANORTE MOP"
    167 => "CBTIS F BANAMEX OP"
    168 => "CBTIS F BANAMEX OPCO"
    169 => "CBTIS F BANAMEX ST"
    170 => "SEP FEDERAL CAMPECHE F BANCOMER MOP"
    171 => "COLEGIO DE ESTUDIOS CIENTIFICOS BANCOMER CO"
    172 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    173 => "SECRETARIA DE SALUD SINALOA BANCOMER CO"
    174 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    175 => "CBTIS F BANAMEX OPCO"
    176 => "COPPEL BANCOPPEL ST"
    177 => "CBTIS F BANAMEX OPCO"
    178 => "SECRETARIA DE SALUD DURANGO BANCOMER CO"
    179 => "COPPEL BANCOPPEL ST"
    180 => "SEP ESTATAL PUEBLA BCO"
    181 => "SECRETARIA DE SALUD GUERRERO BANAMEX ST"
    182 => "CBTIS F BANAMEX OPCO"
    183 => "SEP FEDERAL VERACRUZ F SANTANDER CO"
    184 => "CBTIS F BANORTE ST"
    185 => "SECRETARIA DE SALUD OAXACA BANORTE MCO"
    186 => "CBTIS F BANCOMER CO"
    187 => "CBTIS F BANAMEX OP"
    188 => "COPPEL BANCOPPEL ST"
    189 => "CBTIS F BANAMEX OPCO"
    190 => "CBTIS F BANAMEX UN"
    191 => "CBTIS F BANAMEX OP"
    192 => "COPPEL BANCOPPEL CO"
    193 => "SEP ESTATAL ESTADO DE MEXICO BANORTE OP3"
    194 => "SEP FEDERAL BAJA CALIFORNIA SUR F BANAMEX OP"
    195 => "CBTIS F BANORTE OP"
    196 => "SECRETARIA DE SALUD SINALOA BANAMEX CO"
    197 => "CBTIS F BANAMEX OPCO"
    198 => "CBTIS F BANAMEX OPCO"
    199 => "SECRETARIA DE SALUD TAMAULIPAS BANORTE CO"
    200 => "SECRETARIA DE SALUD CHIHUAHUA HSBC CO"
    201 => "CBTIS F BANAMEX OPCO"
    202 => "CBTIS F BANAMEX OP"
    203 => "SECRETARIA DE SALUD GUERRERO BANAMEX ST"
    204 => "SEP ESTATAL CHIHUAHUA F BANCOMER MOP"
    205 => "CBTIS F BANAMEX OP"
    206 => "SECRETARIA DE SALUD DURANGO BANORTE OP"
    207 => "SEP ESTATAL TABASCO NEGRO BANAMEX MOP"
    208 => "CBTIS F BANAMEX OP"
    209 => "CBTIS F BANAMEX MOP"
    210 => "SECRETARIA DE SALUD COLIMA AFIRME ST"
    211 => "SEP FEDERAL BAJA CALIFORNIA SUR F BANAMEX UN"
    212 => "SEP ESTATAL COAHUILA SCOTIABANK OP"
    213 => "COPPEL BANCOPPEL CO"
    214 => "CBTIS F BANAMEX UN"
    215 => "SECRETARIA DE SALUD YUCATAN BANORTE OP"
    216 => "SEP FEDERAL DURANGO F BANCOMER OP"
    217 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    218 => "SECRETARIA DE SALUD GUANAJUATO BANORTE"
    219 => "SECRETARIA DE SALUD GUERRERO BANAMEX OP"
    220 => "CBTIS F BANORTE OP"
    221 => "SECRETARIA DE SALUD TABASCO FEDERAL HSBC ST"
    222 => "CBTIS F BANAMEX OP"
    223 => "CBTIS F BANAMEX MOP"
    224 => "SECRETARIA DE SALUD GUANAJUATO SANTANDER BLANCO ST"
    225 => "CBTIS F BANAMEX OP"
    226 => "SEP ESTATAL NAYARIT BANORTE OP"
    227 => "SEP ESTATAL TABASCO NEGRO BANAMEX ST"
    228 => "SECRETARIA DE SALUD SONORA BANORTE OP"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 2
    75 => 2
    76 => 2
    77 => 2
    78 => 2
    79 => 2
    80 => 2
    81 => 2
    82 => 2
    83 => 2
    84 => 2
    85 => 2
    86 => 2
    87 => 2
    88 => 2
    89 => 2
    90 => 2
    91 => 2
    92 => 2
    93 => 2
    94 => 2
    95 => 2
    96 => 2
    97 => 2
    98 => 2
    99 => 2
    100 => 2
    101 => 2
    102 => 2
    103 => 2
    104 => 2
    105 => 2
    106 => 2
    107 => 2
    108 => 2
    109 => 2
    110 => 2
    111 => 2
    112 => 2
    113 => 2
    114 => 2
    115 => 2
    116 => 2
    117 => 2
    118 => 2
    119 => 2
    120 => 2
    121 => 2
    122 => 2
    123 => 2
    124 => 2
    125 => 2
    126 => 2
    127 => 2
    128 => 2
    129 => 2
    130 => 2
    131 => 2
    132 => 2
    133 => 2
    134 => 2
    135 => 2
    136 => 2
    137 => 2
    138 => 2
    139 => 2
    140 => 2
    141 => 2
    142 => 2
    143 => 2
    144 => 2
    145 => 2
    146 => 2
    147 => 2
    148 => 2
    149 => 2
    150 => 2
    151 => 2
    152 => 2
    153 => 2
    154 => 2
    155 => 2
    156 => 2
    157 => 2
    158 => 2
    159 => 2
    160 => 2
    161 => 2
    162 => 2
    163 => 2
    164 => 2
    165 => 2
    166 => 2
    167 => 2
    168 => 2
    169 => 2
    170 => 2
    171 => 2
    172 => 2
    173 => 2
    174 => 2
    175 => 2
    176 => 2
    177 => 2
    178 => 2
    179 => 2
    180 => 2
    181 => 2
    182 => 2
    183 => 2
    184 => 2
    185 => 2
    186 => 2
    187 => 2
    188 => 2
    189 => 2
    190 => 2
    191 => 2
    192 => 2
    193 => 2
    194 => 2
    195 => 2
    196 => 2
    197 => 2
    198 => 2
    199 => 2
    200 => 2
    201 => 2
    202 => 2
    203 => 2
    204 => 2
    205 => 2
    206 => 2
    207 => 2
    208 => 2
    209 => 2
    210 => 2
    211 => 2
    212 => 2
    213 => 2
    214 => 2
    215 => 2
    216 => 2
    217 => 2
    218 => 2
    219 => 2
    220 => 2
    221 => 2
    222 => 2
    223 => 2
    224 => 2
    225 => 2
    226 => 2
    227 => 2
    228 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.short_name AS short_name_3, t0.descrip AS descrip_4, t0.card_register AS card_register_5, t0.stp_code AS stp_code_6 FROM formulario_bancos t0 WHERE t0.codigo IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.descrip ASC"
  "params" => [
    1 => "000"
    2 => "014"
    3 => "072"
    4 => "012"
    5 => "012"
    6 => "014"
    7 => "014"
    8 => "002"
    9 => "137"
    10 => "012"
    11 => "002"
    12 => "002"
    13 => "072"
    14 => "137"
    15 => "137"
    16 => "014"
    17 => "012"
    18 => "014"
    19 => "012"
    20 => "137"
    21 => "072"
    22 => "012"
    23 => "072"
    24 => "072"
    25 => "000"
    26 => "021"
    27 => "072"
    28 => "012"
    29 => "012"
    30 => "012"
    31 => "072"
    32 => "072"
    33 => "014"
    34 => "012"
    35 => "002"
    36 => "072"
    37 => "044"
    38 => "127"
    39 => "002"
    40 => "014"
    41 => "137"
    42 => "072"
    43 => "137"
    44 => "137"
    45 => "137"
    46 => "002"
    47 => "002"
    48 => "000"
    49 => "137"
    50 => "012"
    51 => "002"
    52 => "002"
    53 => "000"
    54 => "021"
    55 => "137"
    56 => "072"
    57 => "012"
    58 => "002"
    59 => "012"
    60 => "137"
    61 => "127"
    62 => "127"
    63 => "000"
    64 => "072"
    65 => "002"
    66 => "137"
    67 => "002"
    68 => "002"
    69 => "014"
    70 => "072"
    71 => "137"
    72 => "012"
    73 => "072"
    74 => "072"
    75 => "014"
    76 => "012"
    77 => "072"
    78 => "072"
    79 => "072"
    80 => "014"
    81 => "002"
    82 => "012"
    83 => "002"
    84 => "062"
    85 => "137"
    86 => "012"
    87 => "002"
    88 => "002"
    89 => "072"
    90 => "012"
    91 => "014"
    92 => "014"
    93 => "002"
    94 => "014"
    95 => "072"
    96 => "002"
    97 => "012"
    98 => "072"
    99 => "002"
    100 => "012"
    101 => "072"
    102 => "072"
    103 => "002"
    104 => "002"
    105 => "012"
    106 => "072"
    107 => "002"
    108 => "002"
    109 => "137"
    110 => "072"
    111 => "072"
    112 => "002"
    113 => "012"
    114 => "014"
    115 => "002"
    116 => "012"
    117 => "072"
    118 => "012"
    119 => "137"
    120 => "014"
    121 => "072"
    122 => "012"
    123 => "000"
    124 => "012"
    125 => "000"
    126 => "072"
    127 => "072"
    128 => "002"
    129 => "137"
    130 => "002"
    131 => "002"
    132 => "127"
    133 => "072"
    134 => "002"
    135 => "072"
    136 => "012"
    137 => "072"
    138 => "012"
    139 => "012"
    140 => "012"
    141 => "127"
    142 => "072"
    143 => "014"
    144 => "000"
    145 => "002"
    146 => "002"
    147 => "072"
    148 => "014"
    149 => "002"
    150 => "072"
    151 => "072"
    152 => "072"
    153 => "002"
    154 => "072"
    155 => "137"
    156 => "072"
    157 => "012"
    158 => "127"
    159 => "012"
    160 => "002"
    161 => "127"
    162 => "127"
    163 => "036"
    164 => "127"
    165 => "072"
    166 => "072"
    167 => "002"
    168 => "002"
    169 => "127"
    170 => "012"
    171 => "012"
    172 => "002"
    173 => "012"
    174 => "002"
    175 => "012"
    176 => "137"
    177 => "002"
    178 => "012"
    179 => "137"
    180 => "012"
    181 => "002"
    182 => "012"
    183 => "014"
    184 => "000"
    185 => "072"
    186 => "044"
    187 => "002"
    188 => "137"
    189 => "002"
    190 => "002"
    191 => "002"
    192 => "127"
    193 => "072"
    194 => "002"
    195 => "072"
    196 => "002"
    197 => "002"
    198 => "002"
    199 => "072"
    200 => "021"
    201 => "002"
    202 => "002"
    203 => "000"
    204 => "000"
    205 => "002"
    206 => "072"
    207 => "012"
    208 => "002"
    209 => "002"
    210 => "062"
    211 => "002"
    212 => "044"
    213 => "137"
    214 => "002"
    215 => "072"
    216 => "012"
    217 => "002"
    218 => "072"
    219 => "002"
    220 => "127"
    221 => "021"
    222 => "002"
    223 => "002"
    224 => "000"
    225 => "002"
    226 => "072"
    227 => "012"
    228 => "072"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 2
    75 => 2
    76 => 2
    77 => 2
    78 => 2
    79 => 2
    80 => 2
    81 => 2
    82 => 2
    83 => 2
    84 => 2
    85 => 2
    86 => 2
    87 => 2
    88 => 2
    89 => 2
    90 => 2
    91 => 2
    92 => 2
    93 => 2
    94 => 2
    95 => 2
    96 => 2
    97 => 2
    98 => 2
    99 => 2
    100 => 2
    101 => 2
    102 => 2
    103 => 2
    104 => 2
    105 => 2
    106 => 2
    107 => 2
    108 => 2
    109 => 2
    110 => 2
    111 => 2
    112 => 2
    113 => 2
    114 => 2
    115 => 2
    116 => 2
    117 => 2
    118 => 2
    119 => 2
    120 => 2
    121 => 2
    122 => 2
    123 => 2
    124 => 2
    125 => 2
    126 => 2
    127 => 2
    128 => 2
    129 => 2
    130 => 2
    131 => 2
    132 => 2
    133 => 2
    134 => 2
    135 => 2
    136 => 2
    137 => 2
    138 => 2
    139 => 2
    140 => 2
    141 => 2
    142 => 2
    143 => 2
    144 => 2
    145 => 2
    146 => 2
    147 => 2
    148 => 2
    149 => 2
    150 => 2
    151 => 2
    152 => 2
    153 => 2
    154 => 2
    155 => 2
    156 => 2
    157 => 2
    158 => 2
    159 => 2
    160 => 2
    161 => 2
    162 => 2
    163 => 2
    164 => 2
    165 => 2
    166 => 2
    167 => 2
    168 => 2
    169 => 2
    170 => 2
    171 => 2
    172 => 2
    173 => 2
    174 => 2
    175 => 2
    176 => 2
    177 => 2
    178 => 2
    179 => 2
    180 => 2
    181 => 2
    182 => 2
    183 => 2
    184 => 2
    185 => 2
    186 => 2
    187 => 2
    188 => 2
    189 => 2
    190 => 2
    191 => 2
    192 => 2
    193 => 2
    194 => 2
    195 => 2
    196 => 2
    197 => 2
    198 => 2
    199 => 2
    200 => 2
    201 => 2
    202 => 2
    203 => 2
    204 => 2
    205 => 2
    206 => 2
    207 => 2
    208 => 2
    209 => 2
    210 => 2
    211 => 2
    212 => 2
    213 => 2
    214 => 2
    215 => 2
    216 => 2
    217 => 2
    218 => 2
    219 => 2
    220 => 2
    221 => 2
    222 => 2
    223 => 2
    224 => 2
    225 => 2
    226 => 2
    227 => 2
    228 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.is_nc AS is_nc_4, t0.is_op_trans AS is_op_trans_5, t0.is_co_trans AS is_co_trans_6, t0.is_st_trans AS is_st_trans_7, t0.is_un_trans AS is_un_trans_8, t0.is_program AS is_program_9, t0.id_openpay AS id_openpay_10, t0.auth_openpay AS auth_openpay_11, t0.id_conecta AS id_conecta_12, t0.auth_conecta AS auth_conecta_13, t0.id_stripe AS id_stripe_14, t0.auth_stripe AS auth_stripe_15, t0.id_unlimit AS id_unlimit_16, t0.auth_unlimit AS auth_unlimit_17, t0.fec_pago AS fec_pago_18, t0.monto AS monto_19, t0.rutasoporte AS rutasoporte_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.reject_cause AS reject_cause_23, t0.returned_at AS returned_at_24, t0.return_cause AS return_cause_25, t0.observations AS observations_26, t0.is_recurrent AS is_recurrent_27, t0.attempt_number AS attempt_number_28, t0.attempt_max AS attempt_max_29, t0.custom_recurrence AS custom_recurrence_30, t0.interval_minutes AS interval_minutes_31, t0.aplicado AS aplicado_32, t0.finiquito AS finiquito_33, t0.adjunto AS adjunto_34, t0.created_by AS created_by_35, t0.id_prestamo AS id_prestamo_36, t0.id_cuota AS id_cuota_37, t0.op_inst AS op_inst_38, t0.co_inst AS co_inst_39, t0.st_inst AS st_inst_40, t0.un_inst AS un_inst_41, t0.approved_by AS approved_by_42, t0.rejected_by AS rejected_by_43, t0.returned_by AS returned_by_44 FROM prestamo_pago t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 2168659
    2 => 2167964
    3 => 2167955
    4 => 2168428
    5 => 2168688
    6 => 2167967
    7 => 2168687
    8 => 2167743
    9 => 2167902
    10 => 2167899
    11 => 2167744
    12 => 2168106
    13 => 2168661
    14 => 2167904
    15 => 2167894
    16 => 2167966
    17 => 2168599
    18 => 2167959
    19 => 2167963
    20 => 2167915
    21 => 2168192
    22 => 2167613
    23 => 2168174
    24 => 2168658
    25 => 2168796
    26 => 2168902
    27 => 2168656
    28 => 2167962
    29 => 2167906
    30 => 2167901
    31 => 2168666
    32 => 2167954
    33 => 2167960
    34 => 2168493
    35 => 2167746
    36 => 2168490
    37 => 2167910
    38 => 2168724
    39 => 2167747
    40 => 2168838
    41 => 2167903
    42 => 2168852
    43 => 2167897
    44 => 2167914
    45 => 2167900
    46 => 2168201
    47 => 2167748
    48 => 2168704
    49 => 2167909
    50 => 2168775
    51 => 2167749
    52 => 2167750
    53 => 2168793
    54 => 2168559
    55 => 2167896
    56 => 2168850
    57 => 2168466
    58 => 2167751
    59 => 2168072
    60 => 2167916
    61 => 2168719
    62 => 2168462
    63 => 2168581
    64 => 2168737
    65 => 2168180
    66 => 2167898
    67 => 2167752
    68 => 2167753
    69 => 2167958
    70 => 2168835
    71 => 2167907
    72 => 2168324
    73 => 2168578
    74 => 2168742
    75 => 2168791
    76 => 2168409
    77 => 2168423
    78 => 2167956
    79 => 2168682
    80 => 2168280
    81 => 2168197
    82 => 2168916
    83 => 2168408
    84 => 2168667
    85 => 2167912
    86 => 2167614
    87 => 2167698
    88 => 2168630
    89 => 2168450
    90 => 2168395
    91 => 2168771
    92 => 2168641
    93 => 2167754
    94 => 2168780
    95 => 2168625
    96 => 2167700
    97 => 2168518
    98 => 2168626
    99 => 2167663
    100 => 2168908
    101 => 2168683
    102 => 2168539
    103 => 2167701
    104 => 2168098
    105 => 2168546
    106 => 2168890
    107 => 2168457
    108 => 2167755
    109 => 2167846
    110 => 2167957
    111 => 2168875
    112 => 2168195
    113 => 2168391
    114 => 2167961
    115 => 2168115
    116 => 2168451
    117 => 2168284
    118 => 2168452
    119 => 2167908
    120 => 2168696
    121 => 2168117
    122 => 2168574
    123 => 2168121
    124 => 2168537
    125 => 2168124
    126 => 2168448
    127 => 2168508
    128 => 2168730
    129 => 2167905
    130 => 2167784
    131 => 2168523
    132 => 2168808
    133 => 2168443
    134 => 2167758
    135 => 2168679
    136 => 2167615
    137 => 2168663
    138 => 2168716
    139 => 2167965
    140 => 2168131
    141 => 2168132
    142 => 2168660
    143 => 2168528
    144 => 2168136
    145 => 2167759
    146 => 2168196
    147 => 2168320
    148 => 2168762
    149 => 2167760
    150 => 2168536
    151 => 2168664
    152 => 2168229
    153 => 2168799
    154 => 2168461
    155 => 2167895
    156 => 2168760
    157 => 2168634
    158 => 2168388
    159 => 2168886
    160 => 2168199
    161 => 2168138
    162 => 2168139
    163 => 2168403
    164 => 2167892
    165 => 2167968
    166 => 2168453
    167 => 2167762
    168 => 2167710
    169 => 2167884
    170 => 2168444
    171 => 2168524
    172 => 2168198
    173 => 2168885
    174 => 2168611
    175 => 2168148
    176 => 2167911
    177 => 2167712
    178 => 2168047
    179 => 2167848
    180 => 2168635
    181 => 2168204
    182 => 2168149
    183 => 2168893
    184 => 2167631
    185 => 2168803
    186 => 2168401
    187 => 2167714
    188 => 2167891
    189 => 2167715
    190 => 2167877
    191 => 2167765
    192 => 2167893
    193 => 2168233
    194 => 2168381
    195 => 2168157
    196 => 2168175
    197 => 2167766
    198 => 2167767
    199 => 2168397
    200 => 2168632
    201 => 2167768
    202 => 2167769
    203 => 2168557
    204 => 2168470
    205 => 2167770
    206 => 2168092
    207 => 2168471
    208 => 2167722
    209 => 2167723
    210 => 2168671
    211 => 2168434
    212 => 2168464
    213 => 2167913
    214 => 2167872
    215 => 2168511
    216 => 2168811
    217 => 2168202
    218 => 2168894
    219 => 2168203
    220 => 2168162
    221 => 2168427
    222 => 2167724
    223 => 2167725
    224 => 2168291
    225 => 2167726
    226 => 2168549
    227 => 2168481
    228 => 2168832
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 1
    38 => 1
    39 => 1
    40 => 1
    41 => 1
    42 => 1
    43 => 1
    44 => 1
    45 => 1
    46 => 1
    47 => 1
    48 => 1
    49 => 1
    50 => 1
    51 => 1
    52 => 1
    53 => 1
    54 => 1
    55 => 1
    56 => 1
    57 => 1
    58 => 1
    59 => 1
    60 => 1
    61 => 1
    62 => 1
    63 => 1
    64 => 1
    65 => 1
    66 => 1
    67 => 1
    68 => 1
    69 => 1
    70 => 1
    71 => 1
    72 => 1
    73 => 1
    74 => 1
    75 => 1
    76 => 1
    77 => 1
    78 => 1
    79 => 1
    80 => 1
    81 => 1
    82 => 1
    83 => 1
    84 => 1
    85 => 1
    86 => 1
    87 => 1
    88 => 1
    89 => 1
    90 => 1
    91 => 1
    92 => 1
    93 => 1
    94 => 1
    95 => 1
    96 => 1
    97 => 1
    98 => 1
    99 => 1
    100 => 1
    101 => 1
    102 => 1
    103 => 1
    104 => 1
    105 => 1
    106 => 1
    107 => 1
    108 => 1
    109 => 1
    110 => 1
    111 => 1
    112 => 1
    113 => 1
    114 => 1
    115 => 1
    116 => 1
    117 => 1
    118 => 1
    119 => 1
    120 => 1
    121 => 1
    122 => 1
    123 => 1
    124 => 1
    125 => 1
    126 => 1
    127 => 1
    128 => 1
    129 => 1
    130 => 1
    131 => 1
    132 => 1
    133 => 1
    134 => 1
    135 => 1
    136 => 1
    137 => 1
    138 => 1
    139 => 1
    140 => 1
    141 => 1
    142 => 1
    143 => 1
    144 => 1
    145 => 1
    146 => 1
    147 => 1
    148 => 1
    149 => 1
    150 => 1
    151 => 1
    152 => 1
    153 => 1
    154 => 1
    155 => 1
    156 => 1
    157 => 1
    158 => 1
    159 => 1
    160 => 1
    161 => 1
    162 => 1
    163 => 1
    164 => 1
    165 => 1
    166 => 1
    167 => 1
    168 => 1
    169 => 1
    170 => 1
    171 => 1
    172 => 1
    173 => 1
    174 => 1
    175 => 1
    176 => 1
    177 => 1
    178 => 1
    179 => 1
    180 => 1
    181 => 1
    182 => 1
    183 => 1
    184 => 1
    185 => 1
    186 => 1
    187 => 1
    188 => 1
    189 => 1
    190 => 1
    191 => 1
    192 => 1
    193 => 1
    194 => 1
    195 => 1
    196 => 1
    197 => 1
    198 => 1
    199 => 1
    200 => 1
    201 => 1
    202 => 1
    203 => 1
    204 => 1
    205 => 1
    206 => 1
    207 => 1
    208 => 1
    209 => 1
    210 => 1
    211 => 1
    212 => 1
    213 => 1
    214 => 1
    215 => 1
    216 => 1
    217 => 1
    218 => 1
    219 => 1
    220 => 1
    221 => 1
    222 => 1
    223 => 1
    224 => 1
    225 => 1
    226 => 1
    227 => 1
    228 => 1
  ]
]

[
  "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.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id_usuario = ?"
  "params" => [
    1 => 240427
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 191601
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 194079
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 191601
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 37335
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 203143
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 254345
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 203143
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 58266
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 208645
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 224125
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 208645
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 45961
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 213722
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 204857
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 213722
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 62693
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 204516
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 245257
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 204516
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 53974
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 203259
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 198464
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 203259
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 58153
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 204344
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 248379
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 204344
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?"
  "params" => [
    1 => 55199
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 204810
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 255679
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC"
  "params" => [
    1 => 204810
  ]
  "types" => [
    1 => 1
  ]
]