Symfony Profiler

[
  "route" => "api_presto_bi_get_inventories"
  "route_parameters" => [
    "_route" => "api_presto_bi_get_inventories"
    "_controller" => "App\Controller\Api\PrestoBIController::getInventories"
    "timestamp" => "1772323200"
  ]
  "request_uri" => "https://recette.prestocuisine.fr/api/presto-bi/inventories/1772323200"
  "method" => "GET"
]

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

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

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

[
  "firewall_name" => "main"
  "authenticator" => "Nbgrp\OneloginSamlBundle\Security\Http\Authenticator\SamlAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Nbgrp\OneloginSamlBundle\Security\Http\Authenticator\SamlAuthenticator"
]

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

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

[
  "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.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerGEC32n7\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "recette_presto"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "recette_presto"
    "serverVersion" => "mariadb-10.5.12"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.dateFrom <= ? AND t0_.dateTo >= ? LIMIT 1"
  "params" => [
    1 => "2026-03-01 01:00:00"
    2 => "2026-03-01 01:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#916
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#916}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, COUNT(DISTINCT t2_.id) AS sclr_7, t2_.id AS id_8, t2_.reference AS reference_9, t2_.name AS name_10, t3_.id AS id_11, COUNT(DISTINCT t3_.id) AS sclr_12, t3_.date AS date_13, t3_.status AS status_14, t3_.amount AS amount_15, t3_.amountMP AS amountMP_16, t3_.amountBoissons AS amountBoissons_17, t3_.amountAutres AS amountAutres_18, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_19, (SELECT t5_.id FROM tbl_site t6_ INNER JOIN tbl_inventory t5_ ON t6_.id = t5_.site_id INNER JOIN tbl_inventory_stage_site t7_ ON t5_.id = t7_.inventory_id INNER JOIN tbl_inventory_stage t8_ ON t7_.stage_id = t8_.id WHERE t6_.id = t2_.id AND t5_.status IN (?, ?) AND t7_.isExported = 1 AND t8_.dateTo <= t1_.dateFrom ORDER BY t5_.date DESC LIMIT 1) AS sclr_20, (SELECT t9_.id FROM tbl_site t10_ INNER JOIN tbl_inventory t11_ ON t10_.id = t11_.site_id INNER JOIN tbl_inventory_stage_site t12_ ON t11_.id = t12_.inventory_id INNER JOIN tbl_inventory_stage t9_ ON t12_.stage_id = t9_.id WHERE t10_.id = t2_.id AND t11_.status IN (?, ?) AND t12_.isExported = 1 AND t9_.dateTo < t1_.dateFrom ORDER BY t11_.date DESC LIMIT 1) AS sclr_21, (SELECT t13_.id FROM tbl_inventory_stage t13_ WHERE t13_.dateTo < t1_.dateFrom ORDER BY t13_.dateFrom DESC LIMIT 1) AS sclr_22 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.id = ? GROUP BY t0_.id ORDER BY t2_.reference ASC"
  "params" => [
    1 => "done"
    2 => "exported"
    3 => "done"
    4 => "exported"
    5 => 121
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#916
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#916}
    3 => Doctrine\DBAL\ParameterType {#916}
    4 => Doctrine\DBAL\ParameterType {#916}
    5 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.date AS date_1, t0_.status AS status_2, t0_.amount AS amount_3, t0_.amountMP AS amountMP_4, t0_.amountBoissons AS amountBoissons_5, t0_.amountAutres AS amountAutres_6, SUM(CASE WHEN t1_.quantity > 0 THEN 1 ELSE 0 END) AS sclr_7, t2_.id AS id_8 FROM tbl_inventory t0_ LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory_product t1_ ON t0_.id = t1_.inventory_id WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY t0_.id ORDER BY t2_.reference ASC"
  "params" => [
    1 => 14800
    2 => 14871
    3 => 14906
    4 => 14876
    5 => 14883
    6 => 14827
    7 => 14866
    8 => 14911
    9 => 14838
    10 => 14859
    11 => 14853
    12 => 14885
    13 => 14828
    14 => 14908
    15 => 14879
    16 => 14881
    17 => 14843
    18 => 14825
    19 => 14896
    20 => 14903
    21 => 14916
    22 => 14915
    23 => 14914
    24 => 14832
    25 => 14545
    26 => 14846
    27 => 14909
    28 => 14910
    29 => 14889
    30 => 14844
    31 => 14840
    32 => 14833
    33 => 14863
    34 => 14897
    35 => 14857
    36 => 14888
    37 => 14890
    38 => 14847
    39 => 14858
    40 => 14868
    41 => 14826
    42 => 14829
    43 => 14892
    44 => 14893
    45 => 14900
    46 => 14907
    47 => 14864
    48 => 14894
    49 => 14904
    50 => 14816
    51 => 14822
    52 => 14860
    53 => 14912
    54 => 14743
    55 => 14830
    56 => 14862
    57 => 14848
    58 => 14831
    59 => 14873
    60 => 14917
    61 => 14913
    62 => 14887
    63 => 14870
    64 => 14874
    65 => 14836
    66 => 14850
    67 => 14310
    68 => 14835
    69 => 14849
    70 => 14901
    71 => 14837
    72 => 14851
    73 => 14821
    74 => 14823
    75 => 14841
    76 => 14819
    77 => 14817
    78 => 14818
    79 => 14880
    80 => 14895
    81 => 14861
    82 => 14855
    83 => 14867
    84 => 14820
    85 => 14856
    86 => 14902
    87 => 14842
    88 => 14865
    89 => 14824
    90 => 14839
    91 => 14886
    92 => 14869
    93 => 14834
    94 => 14882
    95 => 14884
    96 => 14872
    97 => 14891
    98 => 14877
    99 => 14898
    100 => 14845
    101 => 14854
    102 => 14905
    103 => 14878
    104 => 14875
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#918}
    3 => Doctrine\DBAL\ParameterType {#918}
    4 => Doctrine\DBAL\ParameterType {#918}
    5 => Doctrine\DBAL\ParameterType {#918}
    6 => Doctrine\DBAL\ParameterType {#918}
    7 => Doctrine\DBAL\ParameterType {#918}
    8 => Doctrine\DBAL\ParameterType {#918}
    9 => Doctrine\DBAL\ParameterType {#918}
    10 => Doctrine\DBAL\ParameterType {#918}
    11 => Doctrine\DBAL\ParameterType {#918}
    12 => Doctrine\DBAL\ParameterType {#918}
    13 => Doctrine\DBAL\ParameterType {#918}
    14 => Doctrine\DBAL\ParameterType {#918}
    15 => Doctrine\DBAL\ParameterType {#918}
    16 => Doctrine\DBAL\ParameterType {#918}
    17 => Doctrine\DBAL\ParameterType {#918}
    18 => Doctrine\DBAL\ParameterType {#918}
    19 => Doctrine\DBAL\ParameterType {#918}
    20 => Doctrine\DBAL\ParameterType {#918}
    21 => Doctrine\DBAL\ParameterType {#918}
    22 => Doctrine\DBAL\ParameterType {#918}
    23 => Doctrine\DBAL\ParameterType {#918}
    24 => Doctrine\DBAL\ParameterType {#918}
    25 => Doctrine\DBAL\ParameterType {#918}
    26 => Doctrine\DBAL\ParameterType {#918}
    27 => Doctrine\DBAL\ParameterType {#918}
    28 => Doctrine\DBAL\ParameterType {#918}
    29 => Doctrine\DBAL\ParameterType {#918}
    30 => Doctrine\DBAL\ParameterType {#918}
    31 => Doctrine\DBAL\ParameterType {#918}
    32 => Doctrine\DBAL\ParameterType {#918}
    33 => Doctrine\DBAL\ParameterType {#918}
    34 => Doctrine\DBAL\ParameterType {#918}
    35 => Doctrine\DBAL\ParameterType {#918}
    36 => Doctrine\DBAL\ParameterType {#918}
    37 => Doctrine\DBAL\ParameterType {#918}
    38 => Doctrine\DBAL\ParameterType {#918}
    39 => Doctrine\DBAL\ParameterType {#918}
    40 => Doctrine\DBAL\ParameterType {#918}
    41 => Doctrine\DBAL\ParameterType {#918}
    42 => Doctrine\DBAL\ParameterType {#918}
    43 => Doctrine\DBAL\ParameterType {#918}
    44 => Doctrine\DBAL\ParameterType {#918}
    45 => Doctrine\DBAL\ParameterType {#918}
    46 => Doctrine\DBAL\ParameterType {#918}
    47 => Doctrine\DBAL\ParameterType {#918}
    48 => Doctrine\DBAL\ParameterType {#918}
    49 => Doctrine\DBAL\ParameterType {#918}
    50 => Doctrine\DBAL\ParameterType {#918}
    51 => Doctrine\DBAL\ParameterType {#918}
    52 => Doctrine\DBAL\ParameterType {#918}
    53 => Doctrine\DBAL\ParameterType {#918}
    54 => Doctrine\DBAL\ParameterType {#918}
    55 => Doctrine\DBAL\ParameterType {#918}
    56 => Doctrine\DBAL\ParameterType {#918}
    57 => Doctrine\DBAL\ParameterType {#918}
    58 => Doctrine\DBAL\ParameterType {#918}
    59 => Doctrine\DBAL\ParameterType {#918}
    60 => Doctrine\DBAL\ParameterType {#918}
    61 => Doctrine\DBAL\ParameterType {#918}
    62 => Doctrine\DBAL\ParameterType {#918}
    63 => Doctrine\DBAL\ParameterType {#918}
    64 => Doctrine\DBAL\ParameterType {#918}
    65 => Doctrine\DBAL\ParameterType {#918}
    66 => Doctrine\DBAL\ParameterType {#918}
    67 => Doctrine\DBAL\ParameterType {#918}
    68 => Doctrine\DBAL\ParameterType {#918}
    69 => Doctrine\DBAL\ParameterType {#918}
    70 => Doctrine\DBAL\ParameterType {#918}
    71 => Doctrine\DBAL\ParameterType {#918}
    72 => Doctrine\DBAL\ParameterType {#918}
    73 => Doctrine\DBAL\ParameterType {#918}
    74 => Doctrine\DBAL\ParameterType {#918}
    75 => Doctrine\DBAL\ParameterType {#918}
    76 => Doctrine\DBAL\ParameterType {#918}
    77 => Doctrine\DBAL\ParameterType {#918}
    78 => Doctrine\DBAL\ParameterType {#918}
    79 => Doctrine\DBAL\ParameterType {#918}
    80 => Doctrine\DBAL\ParameterType {#918}
    81 => Doctrine\DBAL\ParameterType {#918}
    82 => Doctrine\DBAL\ParameterType {#918}
    83 => Doctrine\DBAL\ParameterType {#918}
    84 => Doctrine\DBAL\ParameterType {#918}
    85 => Doctrine\DBAL\ParameterType {#918}
    86 => Doctrine\DBAL\ParameterType {#918}
    87 => Doctrine\DBAL\ParameterType {#918}
    88 => Doctrine\DBAL\ParameterType {#918}
    89 => Doctrine\DBAL\ParameterType {#918}
    90 => Doctrine\DBAL\ParameterType {#918}
    91 => Doctrine\DBAL\ParameterType {#918}
    92 => Doctrine\DBAL\ParameterType {#918}
    93 => Doctrine\DBAL\ParameterType {#918}
    94 => Doctrine\DBAL\ParameterType {#918}
    95 => Doctrine\DBAL\ParameterType {#918}
    96 => Doctrine\DBAL\ParameterType {#918}
    97 => Doctrine\DBAL\ParameterType {#918}
    98 => Doctrine\DBAL\ParameterType {#918}
    99 => Doctrine\DBAL\ParameterType {#918}
    100 => Doctrine\DBAL\ParameterType {#918}
    101 => Doctrine\DBAL\ParameterType {#918}
    102 => Doctrine\DBAL\ParameterType {#918}
    103 => Doctrine\DBAL\ParameterType {#918}
    104 => Doctrine\DBAL\ParameterType {#918}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.id IN (?, ?, ?) ORDER BY t0_.dateFrom ASC LIMIT 1"
  "params" => [
    1 => 117
    2 => 119
    3 => 115
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#918}
    3 => Doctrine\DBAL\ParameterType {#918}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, t2_.id AS id_7, t3_.id AS id_8, t3_.date AS date_9, t3_.status AS status_10, t3_.amount AS amount_11, t3_.amountMP AS amountMP_12, t3_.amountBoissons AS amountBoissons_13, t3_.amountAutres AS amountAutres_14, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_15 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.dateTo > ? AND t1_.dateTo < ? AND t2_.id IN (?, ?, ?) AND (t3_.status IN (?, ?) OR (t3_.id IS NULL AND t0_.isDeferred = 1)) GROUP BY t0_.id ORDER BY t1_.dateFrom DESC, t2_.reference ASC"
  "params" => [
    1 => "2025-09-01 00:00:00"
    2 => "2026-03-01 00:00:00"
    3 => 87
    4 => 238
    5 => 264
    6 => "done"
    7 => "exported"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#916
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#916}
    3 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#918}
    5 => Doctrine\DBAL\ParameterType {#918}
    6 => Doctrine\DBAL\ParameterType {#916}
    7 => Doctrine\DBAL\ParameterType {#916}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.dateFrom <= ? AND t0_.dateTo >= ? LIMIT 1"
  "params" => [
    1 => "2026-04-01 01:00:00"
    2 => "2026-04-01 01:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#916
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#916}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, COUNT(DISTINCT t2_.id) AS sclr_7, t2_.id AS id_8, t2_.reference AS reference_9, t2_.name AS name_10, t3_.id AS id_11, COUNT(DISTINCT t3_.id) AS sclr_12, t3_.date AS date_13, t3_.status AS status_14, t3_.amount AS amount_15, t3_.amountMP AS amountMP_16, t3_.amountBoissons AS amountBoissons_17, t3_.amountAutres AS amountAutres_18, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_19, (SELECT t5_.id FROM tbl_site t6_ INNER JOIN tbl_inventory t5_ ON t6_.id = t5_.site_id INNER JOIN tbl_inventory_stage_site t7_ ON t5_.id = t7_.inventory_id INNER JOIN tbl_inventory_stage t8_ ON t7_.stage_id = t8_.id WHERE t6_.id = t2_.id AND t5_.status IN (?, ?) AND t7_.isExported = 1 AND t8_.dateTo <= t1_.dateFrom ORDER BY t5_.date DESC LIMIT 1) AS sclr_20, (SELECT t9_.id FROM tbl_site t10_ INNER JOIN tbl_inventory t11_ ON t10_.id = t11_.site_id INNER JOIN tbl_inventory_stage_site t12_ ON t11_.id = t12_.inventory_id INNER JOIN tbl_inventory_stage t9_ ON t12_.stage_id = t9_.id WHERE t10_.id = t2_.id AND t11_.status IN (?, ?) AND t12_.isExported = 1 AND t9_.dateTo < t1_.dateFrom ORDER BY t11_.date DESC LIMIT 1) AS sclr_21, (SELECT t13_.id FROM tbl_inventory_stage t13_ WHERE t13_.dateTo < t1_.dateFrom ORDER BY t13_.dateFrom DESC LIMIT 1) AS sclr_22 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.id = ? GROUP BY t0_.id ORDER BY t2_.reference ASC"
  "params" => [
    1 => "done"
    2 => "exported"
    3 => "done"
    4 => "exported"
    5 => 122
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#916
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#916}
    3 => Doctrine\DBAL\ParameterType {#916}
    4 => Doctrine\DBAL\ParameterType {#916}
    5 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.date AS date_1, t0_.status AS status_2, t0_.amount AS amount_3, t0_.amountMP AS amountMP_4, t0_.amountBoissons AS amountBoissons_5, t0_.amountAutres AS amountAutres_6, SUM(CASE WHEN t1_.quantity > 0 THEN 1 ELSE 0 END) AS sclr_7, t2_.id AS id_8 FROM tbl_inventory t0_ LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory_product t1_ ON t0_.id = t1_.inventory_id WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY t0_.id ORDER BY t2_.reference ASC"
  "params" => [
    1 => 14800
    2 => 14871
    3 => 14906
    4 => 14876
    5 => 14883
    6 => 14827
    7 => 14866
    8 => 14911
    9 => 14838
    10 => 14859
    11 => 14853
    12 => 14885
    13 => 14828
    14 => 14908
    15 => 14879
    16 => 14881
    17 => 14843
    18 => 14825
    19 => 14896
    20 => 14903
    21 => 14916
    22 => 14915
    23 => 14914
    24 => 14832
    25 => 14545
    26 => 14846
    27 => 14909
    28 => 14910
    29 => 14889
    30 => 14844
    31 => 14840
    32 => 14833
    33 => 14863
    34 => 14897
    35 => 14857
    36 => 14888
    37 => 14890
    38 => 14847
    39 => 14858
    40 => 14868
    41 => 14826
    42 => 14829
    43 => 14892
    44 => 14893
    45 => 14900
    46 => 14907
    47 => 14864
    48 => 14894
    49 => 14904
    50 => 14816
    51 => 14822
    52 => 14860
    53 => 14912
    54 => 14743
    55 => 14830
    56 => 14862
    57 => 14848
    58 => 14831
    59 => 14873
    60 => 14917
    61 => 14913
    62 => 14887
    63 => 14870
    64 => 14874
    65 => 14836
    66 => 14850
    67 => 14310
    68 => 14835
    69 => 14849
    70 => 14901
    71 => 14837
    72 => 14851
    73 => 14821
    74 => 14823
    75 => 14841
    76 => 14819
    77 => 14817
    78 => 14818
    79 => 14880
    80 => 14895
    81 => 14861
    82 => 14855
    83 => 14867
    84 => 14820
    85 => 14856
    86 => 14902
    87 => 14842
    88 => 14865
    89 => 14824
    90 => 14839
    91 => 14886
    92 => 14869
    93 => 14834
    94 => 14882
    95 => 14884
    96 => 14872
    97 => 14891
    98 => 14877
    99 => 14898
    100 => 14845
    101 => 14854
    102 => 14905
    103 => 14878
    104 => 14875
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#918}
    3 => Doctrine\DBAL\ParameterType {#918}
    4 => Doctrine\DBAL\ParameterType {#918}
    5 => Doctrine\DBAL\ParameterType {#918}
    6 => Doctrine\DBAL\ParameterType {#918}
    7 => Doctrine\DBAL\ParameterType {#918}
    8 => Doctrine\DBAL\ParameterType {#918}
    9 => Doctrine\DBAL\ParameterType {#918}
    10 => Doctrine\DBAL\ParameterType {#918}
    11 => Doctrine\DBAL\ParameterType {#918}
    12 => Doctrine\DBAL\ParameterType {#918}
    13 => Doctrine\DBAL\ParameterType {#918}
    14 => Doctrine\DBAL\ParameterType {#918}
    15 => Doctrine\DBAL\ParameterType {#918}
    16 => Doctrine\DBAL\ParameterType {#918}
    17 => Doctrine\DBAL\ParameterType {#918}
    18 => Doctrine\DBAL\ParameterType {#918}
    19 => Doctrine\DBAL\ParameterType {#918}
    20 => Doctrine\DBAL\ParameterType {#918}
    21 => Doctrine\DBAL\ParameterType {#918}
    22 => Doctrine\DBAL\ParameterType {#918}
    23 => Doctrine\DBAL\ParameterType {#918}
    24 => Doctrine\DBAL\ParameterType {#918}
    25 => Doctrine\DBAL\ParameterType {#918}
    26 => Doctrine\DBAL\ParameterType {#918}
    27 => Doctrine\DBAL\ParameterType {#918}
    28 => Doctrine\DBAL\ParameterType {#918}
    29 => Doctrine\DBAL\ParameterType {#918}
    30 => Doctrine\DBAL\ParameterType {#918}
    31 => Doctrine\DBAL\ParameterType {#918}
    32 => Doctrine\DBAL\ParameterType {#918}
    33 => Doctrine\DBAL\ParameterType {#918}
    34 => Doctrine\DBAL\ParameterType {#918}
    35 => Doctrine\DBAL\ParameterType {#918}
    36 => Doctrine\DBAL\ParameterType {#918}
    37 => Doctrine\DBAL\ParameterType {#918}
    38 => Doctrine\DBAL\ParameterType {#918}
    39 => Doctrine\DBAL\ParameterType {#918}
    40 => Doctrine\DBAL\ParameterType {#918}
    41 => Doctrine\DBAL\ParameterType {#918}
    42 => Doctrine\DBAL\ParameterType {#918}
    43 => Doctrine\DBAL\ParameterType {#918}
    44 => Doctrine\DBAL\ParameterType {#918}
    45 => Doctrine\DBAL\ParameterType {#918}
    46 => Doctrine\DBAL\ParameterType {#918}
    47 => Doctrine\DBAL\ParameterType {#918}
    48 => Doctrine\DBAL\ParameterType {#918}
    49 => Doctrine\DBAL\ParameterType {#918}
    50 => Doctrine\DBAL\ParameterType {#918}
    51 => Doctrine\DBAL\ParameterType {#918}
    52 => Doctrine\DBAL\ParameterType {#918}
    53 => Doctrine\DBAL\ParameterType {#918}
    54 => Doctrine\DBAL\ParameterType {#918}
    55 => Doctrine\DBAL\ParameterType {#918}
    56 => Doctrine\DBAL\ParameterType {#918}
    57 => Doctrine\DBAL\ParameterType {#918}
    58 => Doctrine\DBAL\ParameterType {#918}
    59 => Doctrine\DBAL\ParameterType {#918}
    60 => Doctrine\DBAL\ParameterType {#918}
    61 => Doctrine\DBAL\ParameterType {#918}
    62 => Doctrine\DBAL\ParameterType {#918}
    63 => Doctrine\DBAL\ParameterType {#918}
    64 => Doctrine\DBAL\ParameterType {#918}
    65 => Doctrine\DBAL\ParameterType {#918}
    66 => Doctrine\DBAL\ParameterType {#918}
    67 => Doctrine\DBAL\ParameterType {#918}
    68 => Doctrine\DBAL\ParameterType {#918}
    69 => Doctrine\DBAL\ParameterType {#918}
    70 => Doctrine\DBAL\ParameterType {#918}
    71 => Doctrine\DBAL\ParameterType {#918}
    72 => Doctrine\DBAL\ParameterType {#918}
    73 => Doctrine\DBAL\ParameterType {#918}
    74 => Doctrine\DBAL\ParameterType {#918}
    75 => Doctrine\DBAL\ParameterType {#918}
    76 => Doctrine\DBAL\ParameterType {#918}
    77 => Doctrine\DBAL\ParameterType {#918}
    78 => Doctrine\DBAL\ParameterType {#918}
    79 => Doctrine\DBAL\ParameterType {#918}
    80 => Doctrine\DBAL\ParameterType {#918}
    81 => Doctrine\DBAL\ParameterType {#918}
    82 => Doctrine\DBAL\ParameterType {#918}
    83 => Doctrine\DBAL\ParameterType {#918}
    84 => Doctrine\DBAL\ParameterType {#918}
    85 => Doctrine\DBAL\ParameterType {#918}
    86 => Doctrine\DBAL\ParameterType {#918}
    87 => Doctrine\DBAL\ParameterType {#918}
    88 => Doctrine\DBAL\ParameterType {#918}
    89 => Doctrine\DBAL\ParameterType {#918}
    90 => Doctrine\DBAL\ParameterType {#918}
    91 => Doctrine\DBAL\ParameterType {#918}
    92 => Doctrine\DBAL\ParameterType {#918}
    93 => Doctrine\DBAL\ParameterType {#918}
    94 => Doctrine\DBAL\ParameterType {#918}
    95 => Doctrine\DBAL\ParameterType {#918}
    96 => Doctrine\DBAL\ParameterType {#918}
    97 => Doctrine\DBAL\ParameterType {#918}
    98 => Doctrine\DBAL\ParameterType {#918}
    99 => Doctrine\DBAL\ParameterType {#918}
    100 => Doctrine\DBAL\ParameterType {#918}
    101 => Doctrine\DBAL\ParameterType {#918}
    102 => Doctrine\DBAL\ParameterType {#918}
    103 => Doctrine\DBAL\ParameterType {#918}
    104 => Doctrine\DBAL\ParameterType {#918}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.id IN (?, ?, ?, ?) ORDER BY t0_.dateFrom ASC LIMIT 1"
  "params" => [
    1 => 120
    2 => 117
    3 => 119
    4 => 115
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#918}
    3 => Doctrine\DBAL\ParameterType {#918}
    4 => Doctrine\DBAL\ParameterType {#918}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, t2_.id AS id_7, t3_.id AS id_8, t3_.date AS date_9, t3_.status AS status_10, t3_.amount AS amount_11, t3_.amountMP AS amountMP_12, t3_.amountBoissons AS amountBoissons_13, t3_.amountAutres AS amountAutres_14, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_15 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.dateTo > ? AND t1_.dateTo < ? AND t2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (t3_.status IN (?, ?) OR (t3_.id IS NULL AND t0_.isDeferred = 1)) GROUP BY t0_.id ORDER BY t1_.dateFrom DESC, t2_.reference ASC"
  "params" => [
    1 => "2025-09-01 00:00:00"
    2 => "2026-04-01 00:00:00"
    3 => 3
    4 => 7
    5 => 28
    6 => 30
    7 => 31
    8 => 32
    9 => 34
    10 => 36
    11 => 38
    12 => 40
    13 => 41
    14 => 42
    15 => 49
    16 => 50
    17 => 51
    18 => 53
    19 => 55
    20 => 59
    21 => 60
    22 => 66
    23 => 67
    24 => 76
    25 => 79
    26 => 82
    27 => 87
    28 => 88
    29 => 96
    30 => 97
    31 => 114
    32 => 117
    33 => 128
    34 => 131
    35 => 137
    36 => 145
    37 => 146
    38 => 154
    39 => 153
    40 => 156
    41 => 157
    42 => 159
    43 => 160
    44 => 201
    45 => 168
    46 => 169
    47 => 170
    48 => 171
    49 => 172
    50 => 173
    51 => 174
    52 => 176
    53 => 200
    54 => 210
    55 => 207
    56 => 238
    57 => 239
    58 => 240
    59 => 243
    60 => 244
    61 => 245
    62 => 251
    63 => 253
    64 => 255
    65 => 256
    66 => 257
    67 => 259
    68 => 263
    69 => 264
    70 => 268
    71 => 265
    72 => 279
    73 => 269
    74 => 272
    75 => 273
    76 => 274
    77 => 275
    78 => 282
    79 => 283
    80 => 284
    81 => 285
    82 => 286
    83 => 289
    84 => 292
    85 => 293
    86 => 294
    87 => 298
    88 => 299
    89 => 300
    90 => 301
    91 => 302
    92 => 304
    93 => 305
    94 => 307
    95 => 306
    96 => 311
    97 => 312
    98 => 313
    99 => 314
    100 => 317
    101 => 318
    102 => 323
    103 => 319
    104 => 324
    105 => 321
    106 => 320
    107 => "done"
    108 => "exported"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#916
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#916}
    3 => Doctrine\DBAL\ParameterType {#918
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#918}
    5 => Doctrine\DBAL\ParameterType {#918}
    6 => Doctrine\DBAL\ParameterType {#918}
    7 => Doctrine\DBAL\ParameterType {#918}
    8 => Doctrine\DBAL\ParameterType {#918}
    9 => Doctrine\DBAL\ParameterType {#918}
    10 => Doctrine\DBAL\ParameterType {#918}
    11 => Doctrine\DBAL\ParameterType {#918}
    12 => Doctrine\DBAL\ParameterType {#918}
    13 => Doctrine\DBAL\ParameterType {#918}
    14 => Doctrine\DBAL\ParameterType {#918}
    15 => Doctrine\DBAL\ParameterType {#918}
    16 => Doctrine\DBAL\ParameterType {#918}
    17 => Doctrine\DBAL\ParameterType {#918}
    18 => Doctrine\DBAL\ParameterType {#918}
    19 => Doctrine\DBAL\ParameterType {#918}
    20 => Doctrine\DBAL\ParameterType {#918}
    21 => Doctrine\DBAL\ParameterType {#918}
    22 => Doctrine\DBAL\ParameterType {#918}
    23 => Doctrine\DBAL\ParameterType {#918}
    24 => Doctrine\DBAL\ParameterType {#918}
    25 => Doctrine\DBAL\ParameterType {#918}
    26 => Doctrine\DBAL\ParameterType {#918}
    27 => Doctrine\DBAL\ParameterType {#918}
    28 => Doctrine\DBAL\ParameterType {#918}
    29 => Doctrine\DBAL\ParameterType {#918}
    30 => Doctrine\DBAL\ParameterType {#918}
    31 => Doctrine\DBAL\ParameterType {#918}
    32 => Doctrine\DBAL\ParameterType {#918}
    33 => Doctrine\DBAL\ParameterType {#918}
    34 => Doctrine\DBAL\ParameterType {#918}
    35 => Doctrine\DBAL\ParameterType {#918}
    36 => Doctrine\DBAL\ParameterType {#918}
    37 => Doctrine\DBAL\ParameterType {#918}
    38 => Doctrine\DBAL\ParameterType {#918}
    39 => Doctrine\DBAL\ParameterType {#918}
    40 => Doctrine\DBAL\ParameterType {#918}
    41 => Doctrine\DBAL\ParameterType {#918}
    42 => Doctrine\DBAL\ParameterType {#918}
    43 => Doctrine\DBAL\ParameterType {#918}
    44 => Doctrine\DBAL\ParameterType {#918}
    45 => Doctrine\DBAL\ParameterType {#918}
    46 => Doctrine\DBAL\ParameterType {#918}
    47 => Doctrine\DBAL\ParameterType {#918}
    48 => Doctrine\DBAL\ParameterType {#918}
    49 => Doctrine\DBAL\ParameterType {#918}
    50 => Doctrine\DBAL\ParameterType {#918}
    51 => Doctrine\DBAL\ParameterType {#918}
    52 => Doctrine\DBAL\ParameterType {#918}
    53 => Doctrine\DBAL\ParameterType {#918}
    54 => Doctrine\DBAL\ParameterType {#918}
    55 => Doctrine\DBAL\ParameterType {#918}
    56 => Doctrine\DBAL\ParameterType {#918}
    57 => Doctrine\DBAL\ParameterType {#918}
    58 => Doctrine\DBAL\ParameterType {#918}
    59 => Doctrine\DBAL\ParameterType {#918}
    60 => Doctrine\DBAL\ParameterType {#918}
    61 => Doctrine\DBAL\ParameterType {#918}
    62 => Doctrine\DBAL\ParameterType {#918}
    63 => Doctrine\DBAL\ParameterType {#918}
    64 => Doctrine\DBAL\ParameterType {#918}
    65 => Doctrine\DBAL\ParameterType {#918}
    66 => Doctrine\DBAL\ParameterType {#918}
    67 => Doctrine\DBAL\ParameterType {#918}
    68 => Doctrine\DBAL\ParameterType {#918}
    69 => Doctrine\DBAL\ParameterType {#918}
    70 => Doctrine\DBAL\ParameterType {#918}
    71 => Doctrine\DBAL\ParameterType {#918}
    72 => Doctrine\DBAL\ParameterType {#918}
    73 => Doctrine\DBAL\ParameterType {#918}
    74 => Doctrine\DBAL\ParameterType {#918}
    75 => Doctrine\DBAL\ParameterType {#918}
    76 => Doctrine\DBAL\ParameterType {#918}
    77 => Doctrine\DBAL\ParameterType {#918}
    78 => Doctrine\DBAL\ParameterType {#918}
    79 => Doctrine\DBAL\ParameterType {#918}
    80 => Doctrine\DBAL\ParameterType {#918}
    81 => Doctrine\DBAL\ParameterType {#918}
    82 => Doctrine\DBAL\ParameterType {#918}
    83 => Doctrine\DBAL\ParameterType {#918}
    84 => Doctrine\DBAL\ParameterType {#918}
    85 => Doctrine\DBAL\ParameterType {#918}
    86 => Doctrine\DBAL\ParameterType {#918}
    87 => Doctrine\DBAL\ParameterType {#918}
    88 => Doctrine\DBAL\ParameterType {#918}
    89 => Doctrine\DBAL\ParameterType {#918}
    90 => Doctrine\DBAL\ParameterType {#918}
    91 => Doctrine\DBAL\ParameterType {#918}
    92 => Doctrine\DBAL\ParameterType {#918}
    93 => Doctrine\DBAL\ParameterType {#918}
    94 => Doctrine\DBAL\ParameterType {#918}
    95 => Doctrine\DBAL\ParameterType {#918}
    96 => Doctrine\DBAL\ParameterType {#918}
    97 => Doctrine\DBAL\ParameterType {#918}
    98 => Doctrine\DBAL\ParameterType {#918}
    99 => Doctrine\DBAL\ParameterType {#918}
    100 => Doctrine\DBAL\ParameterType {#918}
    101 => Doctrine\DBAL\ParameterType {#918}
    102 => Doctrine\DBAL\ParameterType {#918}
    103 => Doctrine\DBAL\ParameterType {#918}
    104 => Doctrine\DBAL\ParameterType {#918}
    105 => Doctrine\DBAL\ParameterType {#918}
    106 => Doctrine\DBAL\ParameterType {#918}
    107 => Doctrine\DBAL\ParameterType {#916}
    108 => Doctrine\DBAL\ParameterType {#916}
  ]
]