Symfony Profiler

[
  "route" => "front-page"
  "route_parameters" => [
    "_route" => "front-page"
    "url" => "oferty"
    "_controller" => "App\Controller\Front\PageController::getPageAction"
    "_locale" => "pl"
  ]
  "request_uri" => "https://www.test.inzynio.pl/pl/oferty?filters%5Blocation%5D%5B0%5D=poznan&filters%5Bpage%5D%5B0%5D=2"
  "method" => "GET"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "85.194.242.93"
    "port" => 3306
    "user" => "m1451_inzynio_t"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "m1451_inzynio_tt"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.locale = ? AND t0.url = ? LIMIT 1"
  "params" => [
    1 => "pl"
    2 => "oferty"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_pl AS name_pl_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_pl AS content_pl_6, t0.content_en AS content_en_7, t0.url_pl AS url_pl_8, t0.url_en AS url_en_9, t0.page_id AS page_id_10 FROM footer_link t0"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_pl AS name_pl_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_pl AS content_pl_6, t0.content_en AS content_en_7, t0.url_pl AS url_pl_8, t0.url_en AS url_en_9, t0.page_id AS page_id_10 FROM footer_link t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.shortcut AS shortcut_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.symbol AS symbol_5 FROM currency t0"
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
            SELECT\n
                JSON_OBJECT(\n
                    'id', item_category.id,\n
                    'plName', item_category.name,\n
                    'enName', JSON_EXTRACT(item_category.translation, '$.en.nameCategory'),\n
                    'slugName', item_category.search_slug\n
                )\n
             as item\n
            FROM search_industry\n
            LEFT JOIN item_category on item_category.id = search_industry.item_category_id\n
            ORDER BY search_industry.position ASC\n
            
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT\n
                JSON_OBJECT(\n
                    'name', search_city.name_pl,\n
                    'nameSlug', search_city.name_slug\n
                )\n
             as item\n
            FROM search_city WHERE search_city.name_slug IS NOT null AND search_city.name_slug != '' ORDER BY position ASC;
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT\n
                JSON_OBJECT(\n
                    'plName', another.label_pl,\n
                    'enName', another.label_en,\n
                    'slug', another.name_slug\n
                )\n
             as item\n
            FROM another WHERE active = 1 ORDER BY position ASC;
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT JSON_OBJECT('slugName', item_category.search_slug)\n
                 as item FROM item_category \n
                        WHERE item_category_id is NULL \n
                        AND active = 1 \n
                        AND search_slug is not null \n
                        AND search_slug != '';
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT location.name as city FROM location GROUP BY city;"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.content AS content_1, t0.id AS id_2 FROM technology_cache t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.content AS content_1, t0.id AS id_2 FROM company_cache t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.content AS content_1, t0.id AS id_2 FROM offer_name_cache t0 LIMIT 1"
]

[
  "sql" => """
    SELECT\n
                    JSON_ARRAY(\n
                        JSON_OBJECT(\n
                                'id', item.id,\n
                                'name', Case WHEN item.name = '' THEN item.name_en ELSE item.name END,\n
                                'slug', item.search_slug\n
                        )\n
                    ) as item\n
                FROM job_level as jl\n
                LEFT JOIN job_level_item jli on (jli.job_level_id = jl.id)\n
                LEft JOIN item on (item.id = jli.item_id)\n
                WHERE jl.active = 1 AND item.id is not null\n
                ORDER BY jl.position ASC;
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.can_show AS can_show_2 FROM level_job_select t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.search_engine_id AS search_engine_id_3, t0.item_category_id AS item_category_id_4 FROM search_industry t0 ORDER BY t0.position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_pl AS name_pl_2, t0.id_offer AS id_offer_3, t0.name_slug AS name_slug_4, t0.position AS position_5, t0.search_engine_id AS search_engine_id_6 FROM search_city t0 ORDER BY t0.position ASC"
]

[
  "sql" => """
    SELECT \n
                    JSON_OBJECT(\n
                            'namePl', CASE WHEN item_category.name = '' THEN JSON_EXTRACT(item_category.translation, '$.en.nameCategory') ELSE item_category.name END,\n
                            'nameEn', JSON_EXTRACT(item_category.translation, '$.en.nameCategory'),\n
                            'searchSlug', item_category.search_slug\n
                    )\n
                 as item FROM item_category WHERE item_category_id is NULL and active = 1;
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.label_pl AS label_pl_1, t0.label_en AS label_en_2, t0.calculation_factor AS calculation_factor_3, t0.name_slug AS name_slug_4, t0.active AS active_5, t0.position AS position_6, t0.id AS id_7, t0.item_id AS item_id_8 FROM another t0 WHERE t0.active = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT location.name as city FROM location GROUP BY city;"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.content AS content_1, t0.id AS id_2 FROM technology_cache t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.content AS content_1, t0.id AS id_2 FROM company_cache t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.content AS content_1, t0.id AS id_2 FROM offer_name_cache t0 LIMIT 1"
]

[
  "sql" => """
    SELECT \n
                    JSON_OBJECT(\n
                            'namePl', CASE WHEN item_category.name = '' THEN JSON_EXTRACT(item_category.translation, '$.en.nameCategory') ELSE item_category.name END,\n
                            'nameEn', JSON_EXTRACT(item_category.translation, '$.en.nameCategory'),\n
                            'searchSlug', item_category.search_slug\n
                    )\n
                 as item FROM item_category WHERE item_category_id is NULL and active = 1;
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_pl AS name_pl_2, t0.id_offer AS id_offer_3, t0.name_slug AS name_slug_4, t0.position AS position_5, t0.search_engine_id AS search_engine_id_6 FROM search_city t0 ORDER BY t0.position ASC"
]

[
  "sql" => "SELECT t0.name AS name_1, t0.lat AS lat_2, t0.lng AS lng_3, t0.full_name AS full_name_4, t0.id AS id_5 FROM location t0 WHERE t0.name = ? LIMIT 1"
  "params" => [
    1 => "poznan"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT JSON_ARRAY(\n
                   JSON_OBJECT(\n
                        'id', offer.id,\n
                        'industry', offer.id,\n
                        'offerNumber', (SELECT COUNT(offer2.id) FROM offer as offer2 WHERE offer.id = offer2.offer_id),\n
                        'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT(\n
                                    'workData', offer2.work_data, \n
                                    'language', offer2.language,\n
                                    'temporaryId', offer2.temporary_id\n
                        )) FROM offer as offer2 WHERE offer.id = offer2.offer_id),\n
                        'namePl', offer.offer_name_pl,\n
                        'nameEn', offer.offer_name_en,\n
                        'language', offer.language,\n
                        'temporaryId', offer.temporary_id,\n
                        'mainOffer', (SELECT JSON_OBJECT(\n
                                                     'logo', (SELECT JSON_OBJECT('fileName', file.file_name, 'extension', file.extension) FROM offer_company LEFT JOIN file on offer_company.logo_id = file.id WHERE offer2.offer_company_id = offer_company.id)\n
                                             ) FROM offer as offer2 WHERE offer.offer_id = offer2.id),\n
                        'logo', (SELECT JSON_OBJECT('fileName', file.file_name, 'extension', file.extension) FROM offer_company LEFT JOIN file on offer_company.logo_id = file.id WHERE offer.offer_company_id = offer_company.id),\n
                        'invoiceData', (SELECT JSON_OBJECT('name', invoice_data.name) FROM offer_company \n
        LEFT JOIN offer as mainOffer on (offer.offer_id = mainOffer.id)\n
        LEFT JOIN invoice_data on (invoice_data.id = offer_company.invoice_data_id) \n
        WHERE mainOffer.offer_company_id = offer_company.id OR offer.offer_company_id = offer_company.id\n
    ),\n
                        'workData', offer.work_data,\n
                        'salaryData', offer.salary_data,\n
                        'publishedAt', offer.published_at,\n
                        'boostedAt', offer.boost_date\n
                   )\n
                ) as item , (6371 * ACOS(COS(RADIANS('52.406374'))\n
                * COS(RADIANS(CAST(JSON_EXTRACT(offer.work_data, '$.address.lat') AS DECIMAL(9,6))))\n
                * COS(RADIANS(CAST(JSON_EXTRACT(offer.work_data, '$.address.lnt') AS DECIMAL(9,6))) - RADIANS('16.9251681'))\n
                + SIN(RADIANS('52.406374'))\n
                * SIN(RADIANS(CAST(JSON_EXTRACT(offer.work_data, '$.address.lat') AS DECIMAL(9,6))))\n
                 )) as distanceKM0\n
                FROM offer\n
                \n
                WHERE offer.done = 1\n
                AND offer.active = 1\n
                \n
                \n
                AND (offer.offer_id IS NOT NULL OR offer.order_id IS NULL)\n
                GROUP BY offer.id, offer.boost_date\n
                HAVING distanceKM0 <= 30\n
                ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC, distanceKM0 DESC\n
                LIMIT 20 OFFSET 20;
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT offer.id as offerMax , (6371 * ACOS(COS(RADIANS('52.406374'))\n
                * COS(RADIANS(CAST(JSON_EXTRACT(offer.work_data, '$.address.lat') AS DECIMAL(9,6))))\n
                * COS(RADIANS(CAST(JSON_EXTRACT(offer.work_data, '$.address.lnt') AS DECIMAL(9,6))) - RADIANS('16.9251681'))\n
                + SIN(RADIANS('52.406374'))\n
                * SIN(RADIANS(CAST(JSON_EXTRACT(offer.work_data, '$.address.lat') AS DECIMAL(9,6))))\n
                 )) as distanceKM0 FROM offer\n
                    \n
                    WHERE offer.done = 1\n
                    AND offer.active = 1\n
                     \n
                    \n
                    AND (offer.offer_id IS NOT NULL OR offer.order_id IS NULL)\n
                    GROUP BY offer.id, offer.boost_date\n
                    HAVING distanceKM0 <= 30\n
                    ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC, distanceKM0 DESC
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.footer_link_id = ? LIMIT 1"
  "params" => [
    1 => "8"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.footer_link_id = ? LIMIT 1"
  "params" => [
    1 => "10"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.footer_link_id = ? LIMIT 1"
  "params" => [
    1 => "11"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.footer_link_id = ? LIMIT 1"
  "params" => [
    1 => "12"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.footer_link_id = ? LIMIT 1"
  "params" => [
    1 => "14"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM page t0 WHERE t0.migration_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "m1451_inzynio_tt"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "m1451_inzynio_tt"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
        SELECT t.TABLE_NAME,\n
               t.ENGINE,\n
               t.AUTO_INCREMENT,\n
               t.TABLE_COMMENT,\n
               t.CREATE_OPTIONS,\n
               t.TABLE_COLLATION,\n
               ccsa.CHARACTER_SET_NAME\n
          FROM information_schema.TABLES t\n
            INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\n
              ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "m1451_inzynio_tt"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\n
                k.COLUMN_NAME,\n
                k.REFERENCED_TABLE_NAME,\n
                k.REFERENCED_COLUMN_NAME,\n
                k.ORDINAL_POSITION /*!50116,\n
                c.UPDATE_RULE,\n
                c.DELETE_RULE */\n
    FROM information_schema.key_column_usage k /*!50116\n
    INNER JOIN information_schema.referential_constraints c\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n
    AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'm1451_inzynio_tt' */ ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "m1451_inzynio_tt"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       c.COLUMN_NAME        AS field,\n
           c.COLUMN_TYPE       AS type,\n
           c.IS_NULLABLE        AS `null`,\n
           c.COLUMN_KEY         AS `key`,\n
           c.COLUMN_DEFAULT     AS `default`,\n
           c.EXTRA,\n
           c.COLUMN_COMMENT     AS comment,\n
           c.CHARACTER_SET_NAME AS characterset,\n
           c.COLLATION_NAME     AS collation\n
    FROM information_schema.COLUMNS c\n
        INNER JOIN information_schema.TABLES t\n
            ON t.TABLE_NAME = c.TABLE_NAME\n
         WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
    """
  "params" => [
    1 => "m1451_inzynio_tt"
    2 => "m1451_inzynio_tt"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\n
            INDEX_NAME  AS Key_name,\n
            COLUMN_NAME AS Column_Name,\n
            SUB_PART    AS Sub_Part,\n
            INDEX_TYPE  AS Index_Type\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "m1451_inzynio_tt"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]