नया ईसाई बाइबिल अध्ययन

स्वीडनबॉर्ग के कार्यों से

 

Brève Explication de la Doctrine de l'Église Nouvelle #0

इस मार्ग का अध्ययन करें

/ 120  
  

Table des matières

Introduction - 1

Decisions du Concile de Trente sur le Péché Originel. - 2-8

D’Après la Formule de Concorde, sur le Péché Originel. - 9-15

Une Exposition sommaire de la Doctrine de la Nouvelle Eglise - 16

I. Les Eglises séparées de l’Eglise Catholique-Romaine par la Réforme sont en dissidence sur différents points, mais toutes sont d’accord sur ces Articles: la Trinité de Personnes dans la Divinité; l’Origine du péché par Adam; l’Imputation du mérite du Christ; et la Justification par la foi seule. - 17-18

II. Les Catholiques-Romains, avant la Reforme, ont enseigné sur les quatre Articles ci-dessus nommés des choses absolument semblables à celles que les Reformes ont enseignées après cette Réforme, à savoir, semblables sur la Trinité de personnes dans la Divinité, semblables sur le Péché originel, semblables sur l’imputation du mérite du Christ et semblables sur la Justification par la foi en cette imputation, avec la seule différence qu’ils ont conjoint la même foi avec la charité ou les bonnes œuvres. - 19-20

III. Les Chefs de la Reforme, Luther, Melanchthon et Calvin, ont retenu tous les Dogmes sur la Trinité de Personnes dans la Divinité, sur le Péché Originel, sur l’imputation du Mérite du Christ, et sur la Justification par la foi, tels qu’ils étaient alors qu’ils avaient été chez les Catholiques-Romains; mais ils ont séparé la Charité ou les bonnes œuvres d’avec cette foi, et déclare qu’ils n’étaient pas ensemble salvifiques, afin de rompre avec les Catholiques-Romains quant aux essentiels mêmes de l’église, qui sont la Foi et la Charité. - 21-23

IV. Cependant les Chefs de la Reforme ont adjoint à leur foi les bonnes œuvres, et les ont aussi conjointes, mais dans L’homme comme dans un sujet passif, tandis que les Catholiques-Romain les conjoignent dans; l’homme comme dans un sujet actif: et cependant entre les uns et les autres il y a, en activité, conformité, quant à la foi, aux œuvres et aux mérites. - 24-29

V. Toute la Théologie aujourd’hui, dans le Monde Chrétien, a été fondée sur l’idée de Trois Dieux, laquelle tire son origine de la Trinite de Personnes. - 30-38

VI. Les Dogmes de cette Théologie paraissent erronés, après qu’on a rejeté l’idée de la Trinité de Personnes et par suite l’idée de Trois Dieux et qu’on y a substitué l’idée d’un seul Dieu, en qui est la Divine Trinité. - 39-40

VII. Alors la Foi vraiment salvifique, qui est en un seul Dieu, unie aux bonnes œuvres, est reconnue et reçue. - 41-42

VIII. Et cette Foi est en Dieu Sauveur Jésus-Christ, et sans sa forme simple elle est telle: 1. il y a un seul Dieu, en qui est la Divine Trinité, et ce Dieu est le Seigneur Jésus-Christ. 2. La Foi Salvifique est de croire en Lui. 3. il faut fuir les maux, parce qu’ils sont du diable et viennent du diable. 4. il faut faire les biens, parce qu’ils sont de Dieu et viennent de Dieu. 5. Et les biens doivent être faits par l’homme comme par lui-même, mais il doit croire que c’est par le Seigneur qu’ils sont chez lui et faits par lui. - 43-44

IX. La Foi d’aujourd’hui a séparé de l’Eglise la Religion, qui consiste dans la reconnaissance d’un seul Dieu, et dans le culte de ce Dieu d’après la foi de la charité. - 45-46

X. La foi de l’Eglise d’aujourd’hui ne peut être conjointe à la charité, ni produire aucun des fruits qui sent les bonnes œuvres. - 47-50

XI. De la Foi de l’Eglise d’aujourd’hui rejaillit un Culte de bouche et non un culte de vie, tandis que cependant le culte de bouche est accepté du Seigneur selon le culte de vie. - 51-52

XII. La Doctrine de l’Eglise d’aujourd’hui a été liée en un faisceau par plusieurs paradoxes, qui doivent être embrassés par la foi; et c’est pour cela que les dogmes de cette doctrine entrent seulement dans la mémoire, et non dans quel qu’entendement au-dessus de la mémoire, mais seulement dans des confirmations au-dessous de la mémoire. - 53-57

XIII. Les Dogmes de l’Eglise, d’aujourd’hui ne peuvent être appris qu’avec beaucoup de difficulté, ni être retenus sans qu’ils s’échappent, et ils ne peuvent être prêchés ni enseignés qu’avec beaucoup de ménagement et de précaution, de peur que leur nudité ne paraisse, et cela, parce que la vraie raison ne les perçoit pas et ne les reçoit pas. - 58-59

XIV. La Doctrine de la foi de l’Eglise d’aujourd’hui attribue à Dieu des propriétés humaines, telles que de regarder les hommes avec colère, de vouloir être réconcilié, d’être réconcilié par amour pour le Fils et par l’intercession; de vouloir être rendu propice par la vue des souffrances du Fils, et être ainsi ramené à la Miséricorde; d’imputer la justice du Fils à l’injuste qui supplie d’après la foi seule, et de le rendre ainsi d’ennemi ami, et d’enfant de la colère enfant de la grâce. - 60-63

XV. De la Foi de l’Eglise d’aujourd’hui sont nés et peuvent encore naitre des Fœtus énormes; par exemple, la Salvation opérée en un moment par la Miséricorde immédiate; la Prédestination; l’attention de Dieu nulle à l’égard des actes de l’homme, mais portée sur la foi seule; qu’il n’y a point de Lien de la charité et de la foi; que l’homme dans la conversion est comme un tronc d’arbre; et, plusieurs autres fœtus; puis, sur les Sacrements du Baptême et de la Sainte Cène, quant aux principes de la raison touchant le fruit qu’on en obtient, tirés de la Doctrine de la Justification par la foi seule; comme aussi sur la Personne du Christ. Les Hérésies depuis les premiers siècles jusqu’à ce jour n’ont point eu d’autre source que la Doctrine fondée sur l’idée de trois Dieux. - 64-69

XVI. Le dernier Etat de l’Eglise d’aujourd’hui, quand sa fin est arrivée, est entendu dans Matthieu 24:3, par la Consommation du siècle, et alors par l’Avènement du Seigneur. - 70-73

XVII. Par la grande Affliction, telle qu’il n’y en a point eu depuis le commencement du Monde et qu’il n’y en aura point, (Matthieu 24:21), il est entendu l’infestation par les faux, et par suite la consommation de tout vrai, ou la désolation, aujourd’hui dans les Eglises Chrétiennes. - 74-76

XVIII. Par ces paroles dans Matthieu 24:29: «Après l’affliction de ces jours-là, le Soleil sera obscurci, et la Lune ne donnera point sa lueur, et les Etoiles tomberont du Ciel, et les Puissances des deux seront ébranlées,» il est entendu que dans l’Eglise Chrétienne au dernier temps, quand sa fin approche, il n’y a ni Amour, ni Foi, ni Connaissances du bien et du vrai. - 77-81

XIX. Par les Boucs, dans Daniel et dans Matthieu, il est entendu ceux qui sont dans la Foi justifiante d’aujourd’hui. - 82-86

XX. Ceux qui se sont conformés dans la foi justifiante d’aujourd’hui sont entendus dans l’Apocalypse par le Dragon, ses deux Bêtes, et par les Sauterelles; et cette-même Foi confirmée y est signifiée par la grande Ville, nommée spirituellement Sodome et Egypte, où les deux témoins furent tués, et aussi par le Puits de l’abime d’où sortirent les Sauterelles. - 87-90

XXI. Si une Nouvelle Eglise n’était instaurée par le Seigneur, personne ne pourrait être sauvé, et cela est entendu par ces paroles: « Si n’étaient abrégés ces jours-là, aucune chair ne serait sauvée. » (Matthieu 24:22). - 91-94

XXII. Par ces paroles de l’Apocalypse: Celui qui était assis sur le Trône dit: voici, Nouvelles toutes choses Je fais. Et il dit: Ecris, car ces paroles sont véritables et certaines, » Apocalypse 21:5, il est entendu la mise à découvert et le rejet des Dogmes de la foi de l’Eglise d’aujourd’hui, et aussi la révélation et la réception des Dogmes de la Foi de la Nouvelle Eglise. - 95-98

XXIII. La Nouvelle Eglise, qui doit être instaurée par le Seigneur, est la Nouvelle Jérusalem, dont il est traité dans l’Apocalypse, Chap. 21 et 22, et qui y est appelée la fiancée et l’Epouse de l’Agneau. - 99-101

XXIV. La Foi de la Nouvelle Eglise ne peut être en aucune manière avec la Foi de la précédente Eglise; et si elles sont ensemble, il se fait une telle collision et un tel conflit, que tout ce qui appartient à l’Eglise chez l’homme est détruit. - 102-104

XXV. Les Catholiques-Romains ne savent rien aujourd’hui sur l’Imputation du Mérite du Christ, ni sur la Justification par la foi en imputation, dans laquelle leur Eglise a été initiée, parce que cette foi est entièrement cachée par les Externes du culte, qui sont en grand nombre; et c’est pour cela que s’ils s’éloignent en partie des Externes de leur culte, et s’adressent immédiatement à Dieu Sauveur Jésus-Christ, et qu’en outre ils participent aux deux Espèces dans la sainte Eucharistie, ils peuvent être introduits, plus facilement que les Réformés, dans la Nouvelle Jérusalem, c’est-à-dire, dans la Nouvelle Eglise du Seigneur. - 105-108

L’imputation. - 109-113

Deux Mémorables tirés de L’Apocalypse Révélée. - 114-115

APPENDIX.

La foi du Nouveau Ciel et de la Nouvelle Eglise dans sa forme universelle. - 116

La foi du Nouveau Ciel et de la Nouvelle Eglise dans la forme particulière. - 117

Trois mémorables tirés de L’Apocalypse Révélée. - 118-120

/ 120  
  

Thanks to L'Eglise Générale de la Nouvelle Jérusalem de Côte d'Ivoire for their permission to use the scanned and corrected text of this French translation.

स्वीडनबॉर्ग के कार्यों से

 

Brève Explication de la Doctrine de l'Église Nouvelle #8

इस मार्ग का अध्ययन करें

  
/ 120  
  

8. La foi vient par l’ouïe, lorsque l’homme tient pour vrai ce qui a été divinement révélé, et qu’il croit aux promesses de Dieu. La foi est le commencement du salut humain, le fondement et la racine de toute justification, sans laquelle il est impossible de plaire à Dieu, et de venir dans la société de ses enfants: la Justification se fait par la foi, l’espérance et la charité, et la foi à moins que l’espérance et la charité ne s’en approchent, n’est point une foi vive, mais c’est une foi morte qui n’unit point avec Christ. L’homme doit coopérer; il peut s’approcher et s’éloigner, autrement rien ne pourrait lui être donné, parce qu’il serait comme un corps inanimé. Puisque la réception de la justification renouvelle l’homme, et que cela se fait par l’application du mérite du Christ en lui, l’homme coopérant, il s’ensuit que les œuvres sont méritoires; mais parce qu’elles se font d’après la grâce et par l’Esprit Saint, et que le Christ Seul a mérité, Dieu fait que ses dons sont des mérites chez l’homme; de là il résulte que personne ne peut s’attribuer quelque chose du mérite.

  
/ 120  
  

Thanks to L'Eglise Générale de la Nouvelle Jérusalem de Côte d'Ivoire for their permission to use the scanned and corrected text of this French translation.

स्वीडनबॉर्ग के कार्यों से

 

Brève Explication de la Doctrine de l'Église Nouvelle #102

इस मार्ग का अध्ययन करें

  
/ 120  
  

102. La Foi de la Nouvelle Eglise ne peut être en aucune manière avec la Foi de la précédente Eglise; et si elles sont ensemble, il se fait une telle collision et un tel conflit, que tout ce qui appartient à l’Eglise chez l’homme est détruit.

  
/ 120  
  

Thanks to L'Eglise Générale de la Nouvelle Jérusalem de Côte d'Ivoire for their permission to use the scanned and corrected text of this French translation.

©2025 New Christian Bible Study Corporation. All rights reserved. Printed from <span style="text-decoration:underline;">newchristianbiblestudy.org</span>

Loading…
Loading the web debug toolbar…
Attempt #
Notice: file_put_contents(): Write of 3315 bytes failed with errno=28 No space left on device (500 Internal Server Error)

Symfony Exception

Symfony Docs

ErrorException

HTTP 500 Internal Server Error

Notice: file_put_contents(): Write of 3315 bytes failed with errno=28 No space left on device

Exception

ErrorException

Show exception properties 
ErrorException {#1501
  #severity: E_NOTICE
}
in vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php (line 170)
  2. if (\function_exists('gzencode')) {
  3. $data = gzencode($data, 3);
  4. }
  6. if (false === file_put_contents($file, $data, \LOCK_EX)) {
  7. return false;
  8. }
  10. if (!$profileIndexed) {
  11. // Add to index
in vendor/symfony/http-kernel/Profiler/Profiler.php -> write (line 97)
  1. if ($collector instanceof LateDataCollectorInterface) {
  2. $collector->lateCollect();
  3. }
  4. }
  6. if (!($ret = $this->storage->write($profile)) && null !== $this->logger) {
  7. $this->logger->warning('Unable to store the profiler information.', ['configured_storage' => $this->storage::class]);
  8. }
  10. return $ret;
  11. }
in vendor/symfony/http-kernel/EventListener/ProfilerListener.php -> saveProfile (line 129)
  1. }
  2. }
  4. // save profiles
  5. foreach ($this->profiles as $request) {
  6. $this->profiler->saveProfile($this->profiles[$request]);
  7. }
  9. $this->profiles = new \SplObjectStorage();
  10. $this->parents = new \SplObjectStorage();
  11. }
in vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> onKernelTerminate (line 115)
  1. $this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);
  3. $e = $this->stopwatch->start($this->name, 'event_listener');
  5. try {
  6. ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
  7. } finally {
  8. if ($e->isStarted()) {
  9. $e->stop();
  10. }
  11. }
in vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 206)
  2. foreach ($listeners as $listener) {
  3. if ($stoppable && $event->isPropagationStopped()) {
  4. break;
  5. }
  6. $listener($event, $eventName, $this);
  7. }
  8. }
  10. /**
  11. * Sorts the internal list of listeners for the given event by priority.
in vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 56)
  1. } else {
  2. $listeners = $this->getListeners($eventName);
  3. }
  5. if ($listeners) {
  6. $this->callListeners($listeners, $eventName, $event);
  7. }
  9. return $event;
  10. }
in vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 126)
  1. try {
  2. $this->beforeDispatch($eventName, $event);
  3. try {
  4. $e = $this->stopwatch->start($eventName, 'section');
  5. try {
  6. $this->dispatcher->dispatch($event, $eventName);
  7. } finally {
  8. if ($e->isStarted()) {
  9. $e->stop();
  10. }
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> dispatch (line 114)
  2. public function terminate(Request $request, Response $response): void
  3. {
  4. try {
  5. $this->terminating = true;
  6. $this->dispatcher->dispatch(new TerminateEvent($this, $request, $response), KernelEvents::TERMINATE);
  7. } finally {
  8. $this->terminating = false;
  9. }
  10. }
in vendor/symfony/http-kernel/Kernel.php -> terminate (line 145)
  1. if (false === $this->booted) {
  2. return;
  3. }
  5. if ($this->getHttpKernel() instanceof TerminableInterface) {
  6. $this->getHttpKernel()->terminate($request, $response);
  7. }
  8. }
  10. public function shutdown(): void
  11. {
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> terminate (line 53)
  1. } else {
  2. $response->send();
  3. }
  5. if ($this->kernel instanceof TerminableInterface) {
  6. $this->kernel->terminate($this->request, $response);
  7. }
  9. return 0;
  10. }
  11. }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/home/skymark/ncbsw/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs 1

Level Channel Message
INFO 02:54:58 deprecation User Deprecated: Class "Doctrine\ORM\Proxy\Autoloader" is deprecated. Use native lazy objects instead. (Autoloader.php:74 called by DoctrineBundle.php:136, https://github.com/doctrine/orm/pull/12005, package doctrine/orm) 
{
    "exception": {}
}
DEBUG 02:54:59 event Notified event "kernel.terminate" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelTerminate". 
{
    "event": "kernel.terminate",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelTerminate"
}
INFO 02:54:58 request Matched route "arbitrary_three_column". 
{
    "route": "arbitrary_three_column",
    "route_parameters": {
        "_route": "arbitrary_three_column",
        "_controller": "NCBS\\WebsiteBundle\\Controller\\GeneralController::multicolumn",
        "_locale": "hi",
        "column1Details": "swedenborg_breve-explication-de-la-doctrine_0",
        "column2Details": "swedenborg_breve-explication-de-la-doctrine_8",
        "column3Details": "swedenborg_breve-explication-de-la-doctrine_102"
    },
    "request_uri": "https://update.newchristianbiblestudy.org/hi/multi/swedenborg_breve-explication-de-la-doctrine_0/swedenborg_breve-explication-de-la-doctrine_8/swedenborg_breve-explication-de-la-doctrine_102",
    "method": "GET"
}
DEBUG 02:54:58 security Checking for authenticator support. 
{
    "firewall_name": "main",
    "authenticators": 0
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 02:54:58 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 02:54:58 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 02:54:58 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 02:54:58 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 02:54:58 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 02:54:58 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 02:54:58 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\RequestPayloadValueResolver::onKernelControllerArguments"
}
DEBUG 02:54:58 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
INFO 02:54:58 doctrine Connecting with parameters {params} 
{
    "params": {
        "driver": "pdo_pgsql",
        "idle_connection_ttl": 600,
        "host": "127.0.0.1",
        "port": 5432,
        "user": "skymark",
        "password": "<redacted>",
        "driverOptions": [],
        "defaultTableOptions": [],
        "dbname": "ncbsw",
        "serverVersion": "16",
        "charset": "utf8"
    }
}
DEBUG 02:54:58 doctrine Executing query: SELECT id FROM language WHERE shortcode = 'hi' limit 1 
{
    "sql": "SELECT id FROM language WHERE shortcode = 'hi' limit 1"
}
DEBUG 02:54:58 doctrine Executing query: SELECT MAX(sl.datemod) FROM ui_string_language sl JOIN ui_string s ON s.id = sl.ui_string_id WHERE sl.language_id IN (177, 123) AND s.is_active AND s.type_id IN (1, 3) 
{
    "sql": "SELECT MAX(sl.datemod)\n\t\t\t\tFROM ui_string_language sl\n\t\t\t\tJOIN ui_string s ON s.id = sl.ui_string_id\n\t\t\t\tWHERE sl.language_id IN (177, 123)\n\t\t\t\tAND s.is_active AND s.type_id IN (1, 3)"
}
DEBUG 02:54:58 doctrine Executing query: SELECT DISTINCT s.name, CASE WHEN sl2.id IS NULL THEN sl.text ELSE sl2.text END AS text, s.fix_quote FROM (SELECT * FROM ui_string_language WHERE language_id = 123) sl JOIN ui_string s ON s.id = sl.ui_string_id LEFT JOIN (SELECT * FROM ui_string_language WHERE language_id = 177 AND text IS NOT NULL AND text <> '') sl2 ON s.id = sl2.ui_string_id WHERE s.is_active AND s.type_id IN (1, 3) 
{
    "sql": "SELECT DISTINCT s.name,\n\t\t\t\t\t\t\t\tCASE WHEN sl2.id IS NULL THEN sl.text ELSE sl2.text END AS text,\n\t\t\t\t\t\t\t\ts.fix_quote\n\t\t\t\t\t\tFROM (SELECT * FROM ui_string_language WHERE language_id = 123) sl\n\t\t\t\t\t\tJOIN ui_string s ON s.id = sl.ui_string_id\n\t\t\t\t\t\tLEFT JOIN (SELECT * FROM ui_string_language\n\t\t\t\t\t\t\t\t\tWHERE language_id = 177\n\t\t\t\t\t\t\t\t\tAND text IS NOT NULL AND text <> '') sl2\n\t\t\t\t\t\tON s.id = sl2.ui_string_id\n\t\t\t\t\t\tWHERE s.is_active AND s.type_id IN (1, 3)"
}
DEBUG 02:54:58 doctrine Executing statement: SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? AND t0.type_id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? AND t0.type_id = ? LIMIT 1",
    "params": {
        "1": "breve-explication-de-la-doctrine",
        "2": 1,
        "3": 1
    },
    "types": {
        "1": 2,
        "2": 5,
        "3": 1
    }
}
INFO 02:54:58 deprecation User Deprecated: Since symfony/var-exporter 7.3: The "Symfony\Component\VarExporter\LazyGhostTrait" trait is deprecated, use native lazy objects instead. 
{
    "exception": {}
}
DEBUG 02:54:58 doctrine Executing query: select t.id from expositiontranslation t WHERE t.url = 'breve-explication-de-la-doctrine' and (t.ispublic and not t.restricted_access) 
{
    "sql": "select t.id from expositiontranslation t WHERE t.url = 'breve-explication-de-la-doctrine' and  (t.ispublic and not t.restricted_access) "
}
DEBUG 02:54:58 doctrine Executing statement: SELECT t0.id AS id_1, t0.title AS title_2, t0.fulltitle AS fulltitle_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.swedenborgtype AS swedenborgtype_8 FROM expositionwork t0 WHERE t0.id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.title AS title_2, t0.fulltitle AS fulltitle_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.swedenborgtype AS swedenborgtype_8 FROM expositionwork t0 WHERE t0.id = ?",
    "params": {
        "1": 5
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:58 doctrine Executing statement: SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgsection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgsection = ? AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = ? AND e2_.ispublic = true (parameters: {params}, types: {types}) 
{
    "sql": "SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgsection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgsection = ? AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = ? AND e2_.ispublic = true",
    "params": {
        "1": "0",
        "2": 5
    },
    "types": {
        "1": 2,
        "2": 1
    }
}
INFO 02:54:58 deprecation User Deprecated: Providing the property $uniqueConstraints on Doctrine\ORM\Mapping\Table does not have any effect and will be removed in Doctrine ORM 4.0. Please use the Doctrine\ORM\Mapping\UniqueConstraint attribute instead. (Table.php:36 called by TextUnit.php:10, https://github.com/doctrine/orm/pull/11357, package doctrine/orm) 
{
    "exception": {}
}
DEBUG 02:54:58 doctrine Executing query: SELECT text_style_override FROM language WHERE id = 137 
{
    "sql": "SELECT text_style_override  FROM language WHERE id = 137"
}
DEBUG 02:54:58 doctrine Executing query: SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 1395 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null 
{
    "sql": "SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 1395 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null"
}
DEBUG 02:54:58 doctrine Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.id = ?",
    "params": {
        "1": 54
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:58 doctrine Executing query: SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering < 1 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1 
{
    "sql": "SELECT p.id, t.url as translation_url, d.url as division_url,  (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering < 1 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1"
}
DEBUG 02:54:58 doctrine Executing query: SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering > 1 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1 
{
    "sql": "SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering > 1 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:58 doctrine Executing query: SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 1395 and t.work_id = w.id and t.language_id = l.id 
{
    "sql": "SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 1395 and t.work_id = w.id and t.language_id = l.id"
}
DEBUG 02:54:58 doctrine Executing query: select text from ui_string_language where ui_string_id = 469 and language_id = 137 
{
    "sql": "select text from ui_string_language where ui_string_id = 469 and language_id = 137"
}
DEBUG 02:54:58 doctrine Executing query: SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 35909 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 35909) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (t.enabled and not t.restricted_access) order by priority_order asc, t.languagedefault desc limit 1 
{
    "sql": "SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order  FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 35909 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 35909) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by priority_order asc, t.languagedefault desc limit 1"
}
DEBUG 02:54:58 doctrine Executing query: select array_to_string(array_agg(d.text ORDER BY tu.ordering, d.ordering),'') as content from expositiontranslationtext tt, expositiontextunit tu, expositiondisplayitem d where tu.passage_id = 35909 and tt.translation_id = 1395 and tu.id = tt.placement_id and d.container_id = tt.id 
{
    "sql": "select array_to_string(array_agg(d.text ORDER BY tu.ordering, d.ordering),'') as content from expositiontranslationtext tt, expositiontextunit tu, expositiondisplayitem d where tu.passage_id = 35909 and tt.translation_id = 1395 and tu.id = tt.placement_id and d.container_id = tt.id"
}
DEBUG 02:54:58 doctrine Executing query: select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 35909 and tt.translation_id = 1395 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text 
{
    "sql": "select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 35909 and tt.translation_id = 1395 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text"
}
DEBUG 02:54:58 doctrine Executing query: select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t WHERE tu.passage_id = 35909 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (t.enabled and not t.restricted_access) order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order, (case when t.id = 1395 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 35909 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and (t.ispublic and not t.restricted_access) and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e 
{
    "sql": "select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 35909 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 1395 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 35909 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e"
}
DEBUG 02:54:58 doctrine Executing query: select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1 
{
    "sql": "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:58 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 35909
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:58 doctrine Executing statement: SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ?",
    "params": {
        "1": 73863
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:58 doctrine Executing query: select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1 
{
    "sql": "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:58 doctrine Executing statement: SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? AND t0.type_id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? AND t0.type_id = ? LIMIT 1",
    "params": {
        "1": "breve-explication-de-la-doctrine",
        "2": 1,
        "3": 1
    },
    "types": {
        "1": 2,
        "2": 5,
        "3": 1
    }
}
DEBUG 02:54:58 doctrine Executing query: select t.id from expositiontranslation t WHERE t.url = 'breve-explication-de-la-doctrine' and (t.ispublic and not t.restricted_access) 
{
    "sql": "select t.id from expositiontranslation t WHERE t.url = 'breve-explication-de-la-doctrine' and  (t.ispublic and not t.restricted_access) "
}
DEBUG 02:54:58 doctrine Executing statement: SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgsection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgsection = ? AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = ? AND e2_.ispublic = true (parameters: {params}, types: {types}) 
{
    "sql": "SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgsection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgsection = ? AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = ? AND e2_.ispublic = true",
    "params": {
        "1": "8",
        "2": 5
    },
    "types": {
        "1": 2,
        "2": 1
    }
}
DEBUG 02:54:58 doctrine Executing query: SELECT text_style_override FROM language WHERE id = 137 
{
    "sql": "SELECT text_style_override  FROM language WHERE id = 137"
}
DEBUG 02:54:58 doctrine Executing query: SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 1395 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null 
{
    "sql": "SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 1395 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null"
}
DEBUG 02:54:58 doctrine Executing query: SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering < 80 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1 
{
    "sql": "SELECT p.id, t.url as translation_url, d.url as division_url,  (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering < 80 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1"
}
DEBUG 02:54:58 doctrine Executing query: SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering > 80 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1 
{
    "sql": "SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering > 80 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:58 doctrine Executing query: SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 1395 and t.work_id = w.id and t.language_id = l.id 
{
    "sql": "SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 1395 and t.work_id = w.id and t.language_id = l.id"
}
DEBUG 02:54:58 doctrine Executing query: select text from ui_string_language where ui_string_id = 469 and language_id = 137 
{
    "sql": "select text from ui_string_language where ui_string_id = 469 and language_id = 137"
}
DEBUG 02:54:58 doctrine Executing query: SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 2359 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 2359) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (t.enabled and not t.restricted_access) order by priority_order asc, t.languagedefault desc limit 1 
{
    "sql": "SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order  FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 2359 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 2359) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by priority_order asc, t.languagedefault desc limit 1"
}
DEBUG 02:54:58 doctrine Executing query: select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 2359 and tt.translation_id = 1395 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text 
{
    "sql": "select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 2359 and tt.translation_id = 1395 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text"
}
DEBUG 02:54:58 doctrine Executing query: select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t WHERE tu.passage_id = 2359 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (t.enabled and not t.restricted_access) order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order, (case when t.id = 1395 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 2359 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and (t.ispublic and not t.restricted_access) and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e 
{
    "sql": "select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 2359 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 1395 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 2359 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e"
}
DEBUG 02:54:59 doctrine Executing query: select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1 
{
    "sql": "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 2359
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ?",
    "params": {
        "1": 2359
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing query: select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1 
{
    "sql": "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? AND t0.type_id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? AND t0.type_id = ? LIMIT 1",
    "params": {
        "1": "breve-explication-de-la-doctrine",
        "2": 1,
        "3": 1
    },
    "types": {
        "1": 2,
        "2": 5,
        "3": 1
    }
}
DEBUG 02:54:59 doctrine Executing query: select t.id from expositiontranslation t WHERE t.url = 'breve-explication-de-la-doctrine' and (t.ispublic and not t.restricted_access) 
{
    "sql": "select t.id from expositiontranslation t WHERE t.url = 'breve-explication-de-la-doctrine' and  (t.ispublic and not t.restricted_access) "
}
DEBUG 02:54:59 doctrine Executing statement: SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgsection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgsection = ? AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = ? AND e2_.ispublic = true (parameters: {params}, types: {types}) 
{
    "sql": "SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgsection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgsection = ? AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = ? AND e2_.ispublic = true",
    "params": {
        "1": "102",
        "2": 5
    },
    "types": {
        "1": 2,
        "2": 1
    }
}
DEBUG 02:54:59 doctrine Executing query: SELECT text_style_override FROM language WHERE id = 137 
{
    "sql": "SELECT text_style_override  FROM language WHERE id = 137"
}
DEBUG 02:54:59 doctrine Executing query: SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 1395 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null 
{
    "sql": "SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 1395 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null"
}
DEBUG 02:54:59 doctrine Executing query: SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering < 1020 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1 
{
    "sql": "SELECT p.id, t.url as translation_url, d.url as division_url,  (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering < 1020 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1"
}
DEBUG 02:54:59 doctrine Executing query: SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering > 1020 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1 
{
    "sql": "SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 5 and p.division_id = d.id and p.ordering > 1020 and tt.translation_id=1395 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:59 doctrine Executing query: SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 1395 and t.work_id = w.id and t.language_id = l.id 
{
    "sql": "SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 1395 and t.work_id = w.id and t.language_id = l.id"
}
DEBUG 02:54:59 doctrine Executing query: select text from ui_string_language where ui_string_id = 469 and language_id = 137 
{
    "sql": "select text from ui_string_language where ui_string_id = 469 and language_id = 137"
}
DEBUG 02:54:59 doctrine Executing query: SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 2265 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 2265) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (t.enabled and not t.restricted_access) order by priority_order asc, t.languagedefault desc limit 1 
{
    "sql": "SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order  FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 2265 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 2265) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by priority_order asc, t.languagedefault desc limit 1"
}
DEBUG 02:54:59 doctrine Executing query: select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 2265 and tt.translation_id = 1395 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text 
{
    "sql": "select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 2265 and tt.translation_id = 1395 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text"
}
DEBUG 02:54:59 doctrine Executing query: select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t WHERE tu.passage_id = 2265 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (t.enabled and not t.restricted_access) order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order, (case when t.id = 1395 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 2265 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and (t.ispublic and not t.restricted_access) and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e 
{
    "sql": "select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 2265 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 1395 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 1395) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 2265 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e"
}
DEBUG 02:54:59 doctrine Executing query: select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1 
{
    "sql": "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 2265
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ?",
    "params": {
        "1": 2265
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing query: select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1 
{
    "sql": "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 1395 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
}
DEBUG 02:54:59 doctrine Executing query: SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id limit 1 
{
    "sql": "SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id limit 1"
}
DEBUG 02:54:59 doctrine Executing query: select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 137 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 1395 then 1 else case when t.language_id = 137 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 5 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t 
{
    "sql": "select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 137 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 1395 then 1 else case when t.language_id = 137 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 5 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t"
}
DEBUG 02:54:59 doctrine Executing query: SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id limit 1 
{
    "sql": "SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id limit 1"
}
DEBUG 02:54:59 doctrine Executing query: select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 137 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 1395 then 1 else case when t.language_id = 137 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 5 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t 
{
    "sql": "select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 137 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 1395 then 1 else case when t.language_id = 137 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 5 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t"
}
DEBUG 02:54:59 doctrine Executing query: SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id limit 1 
{
    "sql": "SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id limit 1"
}
DEBUG 02:54:59 doctrine Executing query: select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 137 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 1395 then 1 else case when t.language_id = 137 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 5 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t 
{
    "sql": "select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 137 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 1395 then 1 else case when t.language_id = 137 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 5 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t"
}
DEBUG 02:54:59 doctrine Executing query: select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id 
{
    "sql": "select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id"
}
DEBUG 02:54:59 doctrine Executing query: select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id 
{
    "sql": "select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id"
}
DEBUG 02:54:59 doctrine Executing query: select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id 
{
    "sql": "select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 1395 and t.work_id = w.id"
}
DEBUG 02:54:59 doctrine Executing query: SELECT lower(l.shortcode) AS shortcode, (CASE WHEN l.nativename IS NOT NULL AND l.nativename <> '' THEN l.nativename ELSE l.name END) AS name FROM language l INNER JOIN languageforui lui ON lui.language_id = l.id WHERE l.shortcode IS NOT NULL AND l.shortcode <> '' ORDER BY name 
{
    "sql": "SELECT lower(l.shortcode) AS shortcode, (CASE WHEN l.nativename IS NOT NULL AND l.nativename <> '' THEN l.nativename ELSE l.name END) AS name FROM language l INNER JOIN languageforui lui ON lui.language_id = l.id WHERE l.shortcode IS NOT NULL AND l.shortcode <> '' ORDER BY name"
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.work_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.work_id = ?",
    "params": {
        "1": 5
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ispublic AS ispublic_4, t0.level_id AS level_id_5, t0.startverse_id AS startverse_id_6, t0.endverse_id AS endverse_id_7, t0.chapter_id AS chapter_id_8 FROM biblestory t0 INNER JOIN story_work ON t0.id = story_work.story_id WHERE story_work.work_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ispublic AS ispublic_4, t0.level_id AS level_id_5, t0.startverse_id AS startverse_id_6, t0.endverse_id AS endverse_id_7, t0.chapter_id AS chapter_id_8 FROM biblestory t0 INNER JOIN story_work ON t0.id = story_work.story_id WHERE story_work.work_id = ?",
    "params": {
        "1": 5
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.work_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.work_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 5
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.title AS title_3, t0.swedenborgsection AS swedenborgsection_4, t0.division_id AS division_id_5 FROM expositionpassage t0 WHERE t0.division_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.title AS title_3, t0.swedenborgsection AS swedenborgsection_4, t0.division_id AS division_id_5 FROM expositionpassage t0 WHERE t0.division_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 54
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ?",
    "params": {
        "1": 73863
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 3706855
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 35909
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ?",
    "params": {
        "1": 2359
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 3706863
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 2359
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ?",
    "params": {
        "1": 2265
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 3706957
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 doctrine Executing statement: SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC",
    "params": {
        "1": 2265
    },
    "types": {
        "1": 1
    }
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Csrf\\SameOriginCsrfTokenManager::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 02:54:59 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 02:54:59 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 02:54:59 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 02:54:59 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 02:54:59 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
CRITICAL 02:54:59 request Uncaught PHP Exception ErrorException: "Notice: file_put_contents(): Write of 3315 bytes failed with errno=28 No space left on device" at FileProfilerStorage.php line 170 
{
    "exception": {}
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 02:54:59 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 02:54:59 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 02:54:59 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 02:54:59 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 02:54:59 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 02:54:59 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 02:54:59 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\RequestPayloadValueResolver::onKernelControllerArguments"
}
DEBUG 02:54:59 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Trace

ErrorException 
ErrorException:
Notice: file_put_contents(): Write of 3315 bytes failed with errno=28 No space left on device

  at vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:170
  at Symfony\Component\HttpKernel\Profiler\FileProfilerStorage->write()
     (vendor/symfony/http-kernel/Profiler/Profiler.php:97)
  at Symfony\Component\HttpKernel\Profiler\Profiler->saveProfile()
     (vendor/symfony/http-kernel/EventListener/ProfilerListener.php:129)
  at Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelTerminate()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:126)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/symfony/http-kernel/HttpKernel.php:114)
  at Symfony\Component\HttpKernel\HttpKernel->terminate()
     (vendor/symfony/http-kernel/Kernel.php:145)
  at Symfony\Component\HttpKernel\Kernel->terminate()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:53)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/skymark/ncbsw/vendor/autoload_runtime.php')
     (public/index.php:5)
Symfony\Component\VarDumper\Cloner\Data objects are immutable. (500 Internal Server Error)

Symfony Exception

Symfony Docs

BadMethodCallException

HTTP 500 Internal Server Error

Symfony\Component\VarDumper\Cloner\Data objects are immutable.

Exception

BadMethodCallException

in /home/skymark/ncbsw/vendor/symfony/var-dumper/Cloner/Data.php (line 152)
  1. return $this->__get($key);
  2. }
  4. public function offsetSet(mixed $key, mixed $value): void
  5. {
  6. throw new \BadMethodCallException(self::class.' objects are immutable.');
  7. }
  9. public function offsetUnset(mixed $key): void
  10. {
  11. throw new \BadMethodCallException(self::class.' objects are immutable.');
in /home/skymark/ncbsw/vendor/symfony/http-kernel/DataCollector/EventDataCollector.php -> offsetSet (line 91)
  1. /**
  2. * @see TraceableEventDispatcher
  3. */
  4. public function setCalledListeners(array $listeners, ?string $dispatcher = null): void
  5. {
  6. $this->data[$dispatcher ?? $this->defaultDispatcher]['called_listeners'] = $listeners;
  7. }
  9. /**
  10. * @see TraceableEventDispatcher
  11. */
in /home/skymark/ncbsw/vendor/symfony/http-kernel/DataCollector/EventDataCollector.php -> setCalledListeners (line 73)
  1. foreach ($this->dispatchers as $name => $dispatcher) {
  2. if (!$dispatcher instanceof TraceableEventDispatcher) {
  3. continue;
  4. }
  6. $this->setCalledListeners($dispatcher->getCalledListeners($this->currentRequest), $name);
  7. $this->setNotCalledListeners($dispatcher->getNotCalledListeners($this->currentRequest), $name);
  8. $this->setOrphanedEvents($dispatcher->getOrphanedEvents($this->currentRequest), $name);
  9. }
  11. $this->data = $this->cloneVar($this->data);
in /home/skymark/ncbsw/vendor/symfony/http-kernel/Profiler/Profiler.php -> lateCollect (line 93)
  1. public function saveProfile(Profile $profile): bool
  2. {
  3. // late collect
  4. foreach ($profile->getCollectors() as $collector) {
  5. if ($collector instanceof LateDataCollectorInterface) {
  6. $collector->lateCollect();
  7. }
  8. }
  10. if (!($ret = $this->storage->write($profile)) && null !== $this->logger) {
  11. $this->logger->warning('Unable to store the profiler information.', ['configured_storage' => $this->storage::class]);
in /home/skymark/ncbsw/vendor/symfony/http-kernel/EventListener/ProfilerListener.php -> saveProfile (line 129)
  1. }
  2. }
  4. // save profiles
  5. foreach ($this->profiles as $request) {
  6. $this->profiler->saveProfile($this->profiles[$request]);
  7. }
  9. $this->profiles = new \SplObjectStorage();
  10. $this->parents = new \SplObjectStorage();
  11. }
in /home/skymark/ncbsw/vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> onKernelTerminate (line 115)
  1. $this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);
  3. $e = $this->stopwatch->start($this->name, 'event_listener');
  5. try {
  6. ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
  7. } finally {
  8. if ($e->isStarted()) {
  9. $e->stop();
  10. }
  11. }
in /home/skymark/ncbsw/vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 206)
  2. foreach ($listeners as $listener) {
  3. if ($stoppable && $event->isPropagationStopped()) {
  4. break;
  5. }
  6. $listener($event, $eventName, $this);
  7. }
  8. }
  10. /**
  11. * Sorts the internal list of listeners for the given event by priority.
in /home/skymark/ncbsw/vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 56)
  1. } else {
  2. $listeners = $this->getListeners($eventName);
  3. }
  5. if ($listeners) {
  6. $this->callListeners($listeners, $eventName, $event);
  7. }
  9. return $event;
  10. }
in /home/skymark/ncbsw/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 126)
  1. try {
  2. $this->beforeDispatch($eventName, $event);
  3. try {
  4. $e = $this->stopwatch->start($eventName, 'section');
  5. try {
  6. $this->dispatcher->dispatch($event, $eventName);
  7. } finally {
  8. if ($e->isStarted()) {
  9. $e->stop();
  10. }
  11. }
in /home/skymark/ncbsw/vendor/symfony/http-kernel/HttpKernel.php -> dispatch (line 114)
  2. public function terminate(Request $request, Response $response): void
  3. {
  4. try {
  5. $this->terminating = true;
  6. $this->dispatcher->dispatch(new TerminateEvent($this, $request, $response), KernelEvents::TERMINATE);
  7. } finally {
  8. $this->terminating = false;
  9. }
  10. }
in /home/skymark/ncbsw/vendor/symfony/http-kernel/HttpKernel.php -> terminate (line 144)
  1. }
  3. $response->sendHeaders();
  4. $response->sendContent();
  6. $this->terminate($request, $response);
  7. }
  9. /**
  10. * Handles a request to convert it to a response.
  11. *
in /home/skymark/ncbsw/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php -> terminateWithException (line 84)
  1. if ($hasRun) {
  2. throw $e;
  3. }
  5. $hasRun = true;
  6. $kernel->terminateWithException($e, $request);
  7. };
  8. }
  9. } elseif ($event instanceof ConsoleEvent && $app = $event->getCommand()->getApplication()) {
  10. $output = $event->getOutput();
  11. if ($output instanceof ConsoleOutputInterface) {
in /home/skymark/ncbsw/vendor/symfony/error-handler/ErrorHandler.php :: {closure:Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure():78} (line 538)
  1. $this->exceptionHandler = null;
  2. }
  4. try {
  5. if (null !== $exceptionHandler) {
  6. $exceptionHandler($exception);
  8. return;
  9. }
  10. $handlerException ??= $exception;
  11. } catch (\Throwable $handlerException) {
ErrorHandler->handleException()

Stack Trace

BadMethodCallException 
BadMethodCallException:
Symfony\Component\VarDumper\Cloner\Data objects are immutable.

  at /home/skymark/ncbsw/vendor/symfony/var-dumper/Cloner/Data.php:152
  at Symfony\Component\VarDumper\Cloner\Data->offsetSet()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/DataCollector/EventDataCollector.php:91)
  at Symfony\Component\HttpKernel\DataCollector\EventDataCollector->setCalledListeners()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/DataCollector/EventDataCollector.php:73)
  at Symfony\Component\HttpKernel\DataCollector\EventDataCollector->lateCollect()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/Profiler/Profiler.php:93)
  at Symfony\Component\HttpKernel\Profiler\Profiler->saveProfile()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/EventListener/ProfilerListener.php:129)
  at Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelTerminate()
     (/home/skymark/ncbsw/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (/home/skymark/ncbsw/vendor/symfony/event-dispatcher/EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (/home/skymark/ncbsw/vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (/home/skymark/ncbsw/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:126)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/HttpKernel.php:114)
  at Symfony\Component\HttpKernel\HttpKernel->terminate()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/HttpKernel.php:144)
  at Symfony\Component\HttpKernel\HttpKernel->terminateWithException()
     (/home/skymark/ncbsw/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php:84)
  at Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::{closure:Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure():78}()
     (/home/skymark/ncbsw/vendor/symfony/error-handler/ErrorHandler.php:538)
  at Symfony\Component\ErrorHandler\ErrorHandler->handleException()