Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

132 Database Queries

29 Different statements

194.28 ms Query time

0 Invalid entities

Queries

Group similar statements


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
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 = ?
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
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
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 = ?
SELECT t0.seo_right_block_pl AS seo_right_block_pl_1, t0.seo_left_block_pl AS seo_left_block_pl_2, t0.seo_right_block_en AS seo_right_block_en_3, t0.seo_left_block_en AS seo_left_block_en_4, t0.id AS id_5 FROM seo_main_page t0
SELECT JSON_OBJECT(
            'industry', JSON_OBJECT(
            'id', ic.id, 
            'name', ic.name, 
            'nameEn', JSON_VALUE(ic.translation, '$.en.nameCategory'), 'searchSlug', ic.search_slug),
            'offers', JSON_ARRAY()
         ) AS item
        FROM job_listings AS jl
        LEFT JOIN item_category ic ON(ic.id = jl.item_category_id)
        AND ic.active = 1
        WHERE jl.active = 1 
        ORDER BY jl.position;
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT
                         JSON_ARRAY(
                              JSON_OBJECT(
                                  'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id),
                                  'offerNamePL', offer.offer_name_pl,
                                  'offerNameEN', offer.offer_name_en,
                                  'language', offer.language,
                                  'salaryData', offer.salary_data,
                                  'temporaryId', offer.temporary_id,
                                  'workData', offer.work_data,
                                  'offerCompany', JSON_OBJECT(
                                        'logo', JSON_OBJECT(
                                            'fileName', FILE.file_name,
                                            'extension', FILE.extension
                                        ),
                                        'invoiceData', JSON_OBJECT('name', invoice_data.name)
                                  ),
                                  'boostDate', offer.boost_date,
                                  'publishedAt', offer.published_at
                              )
                         ) AS offer
                       FROM offer
                       LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id)
                       LEFT JOIN FILE ON (offer_company.logo_id = FILE.id)
                       LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id)
                       WHERE offer.category_id = :industryId 
                       AND offer.done = 1 
                       AND offer.active = 1 
                       AND offer.offer_id IS NULL
                       ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date
                            ELSE offer.published_at END DESC 
                            LIMIT 5 OFFSET 0
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.position AS position_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id_industry AS id_industry_8 FROM industry_list t0 WHERE t0.active = ? ORDER BY t0.position ASC
SELECT t0.name AS name_1, t0.position AS position_2, t0.active AS active_3, t0.update_at AS update_at_4, t0.created_at AS created_at_5, t0.search_slug AS search_slug_6, t0.id AS id_7 FROM cities_list t0 WHERE t0.active = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.active AS active_6, t0.id_item AS id_item_7 FROM popular_list t0 WHERE t0.active = ? ORDER BY t0.position ASC
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
SELECT
            JSON_OBJECT(
                'id', item_category.id,
                'plName', item_category.name,
                'enName', JSON_EXTRACT(item_category.translation, '$.en.nameCategory'),
                'slugName', item_category.search_slug
            )
         AS item
        FROM search_industry
        LEFT JOIN item_category ON item_category.id = search_industry.item_category_id
        ORDER BY search_industry.position ASC
SELECT
            JSON_OBJECT(
                'name', search_city.name_pl,
                'nameSlug', search_city.name_slug
            )
         AS item
        FROM search_city WHERE search_city.name_slug IS NOT NULL AND search_city.name_slug != '' ORDER BY position ASC;
SELECT
            JSON_OBJECT(
                'plName', another.label_pl,
                'enName', another.label_en,
                'slug', another.name_slug
            )
         AS item
        FROM another WHERE active = 1 ORDER BY position ASC;
SELECT JSON_OBJECT('slugName', item_category.search_slug)
             AS item FROM item_category 
                    WHERE item_category_id IS NULL 
                    AND active = 1 
                    AND search_slug IS NOT NULL 
                    AND search_slug != '';
SELECT location.name AS city FROM location GROUP BY city;
SELECT t0.content AS content_1, t0.id AS id_2 FROM technology_cache t0 LIMIT 1
SELECT t0.content AS content_1, t0.id AS id_2 FROM company_cache t0 LIMIT 1
SELECT t0.content AS content_1, t0.id AS id_2 FROM offer_name_cache t0 LIMIT 1
SELECT
                JSON_ARRAY(
                    JSON_OBJECT(
                            'id', item.id,
                            'name', CASE WHEN item.name = '' THEN item.name_en ELSE item.name END,
                            'slug', item.search_slug
                    )
                ) AS item
            FROM job_level AS jl
            LEFT JOIN job_level_item jli ON (jli.job_level_id = jl.id)
            LEFT JOIN item ON (item.id = jli.item_id)
            WHERE jl.active = 1 AND item.id IS NOT NULL
            ORDER BY jl.position ASC;
SELECT t0.id AS id_1, t0.can_show AS can_show_2 FROM level_job_select t0 WHERE t0.id = ? LIMIT 1
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
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
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 = ?
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
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 = ?
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
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
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 = ?
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
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
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 = ?
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
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 = ?
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
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
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
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
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
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
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS TYPE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS COMMENT,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS COLLATION
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	0.49 ms	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 Parameters: [`"pl" ""`] View formatted query View runnable query Explain query 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 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 = 'pl' AND t0.url = '' LIMIT 1;
2	0.34 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
3	0.44 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 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;
4	0.51 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 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;
5	0.39 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
6	0.61 ms	SELECT t0.seo_right_block_pl AS seo_right_block_pl_1, t0.seo_left_block_pl AS seo_left_block_pl_2, t0.seo_right_block_en AS seo_right_block_en_3, t0.seo_left_block_en AS seo_left_block_en_4, t0.id AS id_5 FROM seo_main_page t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.seo_right_block_pl AS seo_right_block_pl_1, t0.seo_left_block_pl AS seo_left_block_pl_2, t0.seo_right_block_en AS seo_right_block_en_3, t0.seo_left_block_en AS seo_left_block_en_4, t0.id AS id_5 FROM seo_main_page t0 SELECT t0.seo_right_block_pl AS seo_right_block_pl_1, t0.seo_left_block_pl AS seo_left_block_pl_2, t0.seo_right_block_en AS seo_right_block_en_3, t0.seo_left_block_en AS seo_left_block_en_4, t0.id AS id_5 FROM seo_main_page t0;
7	0.83 ms	SELECT JSON_OBJECT( 'industry', JSON_OBJECT( 'id', ic.id, 'name', ic.name, 'nameEn', JSON_VALUE(ic.translation, '$.en.nameCategory'), 'searchSlug', ic.search_slug), 'offers', JSON_ARRAY() ) AS item FROM job_listings AS jl LEFT JOIN item_category ic ON(ic.id = jl.item_category_id) AND ic.active = 1 WHERE jl.active = 1 ORDER BY jl.position; Parameters: [] View formatted query View runnable query Explain query SELECT JSON_OBJECT( 'industry', JSON_OBJECT( 'id', ic.id, 'name', ic.name, 'nameEn', JSON_VALUE( ic.translation, '$.en.nameCategory' ), 'searchSlug', ic.search_slug ), 'offers', JSON_ARRAY() ) AS item FROM job_listings AS jl LEFT JOIN item_category ic ON(ic.id = jl.item_category_id) AND ic.active = 1 WHERE jl.active = 1 ORDER BY jl.position; SELECT JSON_OBJECT( 'industry', JSON_OBJECT( 'id', ic.id, 'name', ic.name, 'nameEn', JSON_VALUE(ic.translation, '$.en.nameCategory'), 'searchSlug', ic.search_slug), 'offers', JSON_ARRAY() ) AS item FROM job_listings AS jl LEFT JOIN item_category ic ON(ic.id = jl.item_category_id) AND ic.active = 1 WHERE jl.active = 1 ORDER BY jl.position;;
8	9.17 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "2"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '2' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
9	25.13 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "19"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '19' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
10	27.94 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "79"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '79' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
11	26.83 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "91"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '91' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
12	22.64 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "32"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '32' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
13	2.27 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "44"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '44' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
14	13.06 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "103"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '103' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
15	2.07 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "106"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '106' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
16	1.50 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "67"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '67' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
17	1.86 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "56"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '56' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
18	2.32 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 Parameters: [`"industryId" => "109"`] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', ( SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offers', ( SELECT JSON_ARRAYAGG( JSON_OBJECT( 'workData', offer2.work_data, 'language', offer2.language, 'temporaryId', offer2.temporary_id ) ) FROM offer AS offer2 WHERE offer.id = offer2.offer_id ), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON( offer.offer_company_id = offer_company.id ) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON ( offer_company.invoice_data_id = invoice_data.id ) WHERE offer.category_id = :industryId AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0 SELECT JSON_ARRAY( JSON_OBJECT( 'localizationCount', (SELECT COUNT(offer2.id) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offers', (SELECT JSON_ARRAYAGG(JSON_OBJECT('workData', offer2.work_data,'language', offer2.language,'temporaryId', offer2.temporary_id)) FROM offer AS offer2 WHERE offer.id = offer2.offer_id), 'offerNamePL', offer.offer_name_pl, 'offerNameEN', offer.offer_name_en, 'language', offer.language, 'salaryData', offer.salary_data, 'temporaryId', offer.temporary_id, 'workData', offer.work_data, 'offerCompany', JSON_OBJECT( 'logo', JSON_OBJECT( 'fileName', FILE.file_name, 'extension', FILE.extension ), 'invoiceData', JSON_OBJECT('name', invoice_data.name) ), 'boostDate', offer.boost_date, 'publishedAt', offer.published_at ) ) AS offer FROM offer LEFT JOIN offer_company ON(offer.offer_company_id = offer_company.id) LEFT JOIN FILE ON (offer_company.logo_id = FILE.id) LEFT JOIN invoice_data ON (offer_company.invoice_data_id = invoice_data.id) WHERE offer.category_id = '109' AND offer.done = 1 AND offer.active = 1 AND offer.offer_id IS NULL ORDER BY CASE WHEN offer.boost_date IS NOT NULL THEN offer.boost_date ELSE offer.published_at END DESC LIMIT 5 OFFSET 0;
19	0.69 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.position AS position_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id_industry AS id_industry_8 FROM industry_list t0 WHERE t0.active = ? ORDER BY t0.position ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.position AS position_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id_industry AS id_industry_8 FROM industry_list t0 WHERE t0.active = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.position AS position_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id_industry AS id_industry_8 FROM industry_list t0 WHERE t0.active = 1 ORDER BY t0.position ASC;
20	0.51 ms	SELECT t0.name AS name_1, t0.position AS position_2, t0.active AS active_3, t0.update_at AS update_at_4, t0.created_at AS created_at_5, t0.search_slug AS search_slug_6, t0.id AS id_7 FROM cities_list t0 WHERE t0.active = ? ORDER BY t0.position ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.position AS position_2, t0.active AS active_3, t0.update_at AS update_at_4, t0.created_at AS created_at_5, t0.search_slug AS search_slug_6, t0.id AS id_7 FROM cities_list t0 WHERE t0.active = ? ORDER BY t0.position ASC SELECT t0.name AS name_1, t0.position AS position_2, t0.active AS active_3, t0.update_at AS update_at_4, t0.created_at AS created_at_5, t0.search_slug AS search_slug_6, t0.id AS id_7 FROM cities_list t0 WHERE t0.active = 1 ORDER BY t0.position ASC;
21	0.59 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.active AS active_6, t0.id_item AS id_item_7 FROM popular_list t0 WHERE t0.active = ? ORDER BY t0.position ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.active AS active_6, t0.id_item AS id_item_7 FROM popular_list t0 WHERE t0.active = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.active AS active_6, t0.id_item AS id_item_7 FROM popular_list t0 WHERE t0.active = 1 ORDER BY t0.position ASC;
22	0.41 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 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;
23	0.44 ms	SELECT JSON_OBJECT( 'id', item_category.id, 'plName', item_category.name, 'enName', JSON_EXTRACT(item_category.translation, '$.en.nameCategory'), 'slugName', item_category.search_slug ) AS item FROM search_industry LEFT JOIN item_category ON item_category.id = search_industry.item_category_id ORDER BY search_industry.position ASC Parameters: [] View formatted query View runnable query Explain query SELECT JSON_OBJECT( 'id', item_category.id, 'plName', item_category.name, 'enName', JSON_EXTRACT( item_category.translation, '$.en.nameCategory' ), 'slugName', item_category.search_slug ) AS item FROM search_industry LEFT JOIN item_category ON item_category.id = search_industry.item_category_id ORDER BY search_industry.position ASC SELECT JSON_OBJECT( 'id', item_category.id, 'plName', item_category.name, 'enName', JSON_EXTRACT(item_category.translation, '$.en.nameCategory'), 'slugName', item_category.search_slug ) AS item FROM search_industry LEFT JOIN item_category ON item_category.id = search_industry.item_category_id ORDER BY search_industry.position ASC ;
24	0.44 ms	SELECT JSON_OBJECT( 'name', search_city.name_pl, 'nameSlug', search_city.name_slug ) AS item FROM search_city WHERE search_city.name_slug IS NOT NULL AND search_city.name_slug != '' ORDER BY position ASC; Parameters: [] View formatted query View runnable query Explain query SELECT JSON_OBJECT( 'name', search_city.name_pl, 'nameSlug', search_city.name_slug ) AS item FROM search_city WHERE search_city.name_slug IS NOT NULL AND search_city.name_slug != '' ORDER BY position ASC; SELECT JSON_OBJECT( 'name', search_city.name_pl, 'nameSlug', search_city.name_slug ) AS item FROM search_city WHERE search_city.name_slug IS NOT NULL AND search_city.name_slug != '' ORDER BY position ASC;;
25	0.33 ms	SELECT JSON_OBJECT( 'plName', another.label_pl, 'enName', another.label_en, 'slug', another.name_slug ) AS item FROM another WHERE active = 1 ORDER BY position ASC; Parameters: [] View formatted query View runnable query Explain query SELECT JSON_OBJECT( 'plName', another.label_pl, 'enName', another.label_en, 'slug', another.name_slug ) AS item FROM another WHERE active = 1 ORDER BY position ASC; SELECT JSON_OBJECT( 'plName', another.label_pl, 'enName', another.label_en, 'slug', another.name_slug ) AS item FROM another WHERE active = 1 ORDER BY position ASC;;
26	0.45 ms	SELECT JSON_OBJECT('slugName', item_category.search_slug) AS item FROM item_category WHERE item_category_id IS NULL AND active = 1 AND search_slug IS NOT NULL AND search_slug != ''; Parameters: [] View formatted query View runnable query Explain query SELECT JSON_OBJECT( 'slugName', item_category.search_slug ) AS item FROM item_category WHERE item_category_id IS NULL AND active = 1 AND search_slug IS NOT NULL AND search_slug != ''; SELECT JSON_OBJECT('slugName', item_category.search_slug) AS item FROM item_category WHERE item_category_id IS NULL AND active = 1 AND search_slug IS NOT NULL AND search_slug != '';;
27	2.81 ms	SELECT location.name AS city FROM location GROUP BY city; Parameters: [] View formatted query View runnable query Explain query SELECT location.name AS city FROM location GROUP BY city; SELECT location.name AS city FROM location GROUP BY city;;
28	3.07 ms	SELECT t0.content AS content_1, t0.id AS id_2 FROM technology_cache t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.content AS content_1, t0.id AS id_2 FROM technology_cache t0 LIMIT 1 SELECT t0.content AS content_1, t0.id AS id_2 FROM technology_cache t0 LIMIT 1;
29	0.64 ms	SELECT t0.content AS content_1, t0.id AS id_2 FROM company_cache t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.content AS content_1, t0.id AS id_2 FROM company_cache t0 LIMIT 1 SELECT t0.content AS content_1, t0.id AS id_2 FROM company_cache t0 LIMIT 1;
30	10.85 ms	SELECT t0.content AS content_1, t0.id AS id_2 FROM offer_name_cache t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.content AS content_1, t0.id AS id_2 FROM offer_name_cache t0 LIMIT 1 SELECT t0.content AS content_1, t0.id AS id_2 FROM offer_name_cache t0 LIMIT 1;
31	0.48 ms	SELECT JSON_ARRAY( JSON_OBJECT( 'id', item.id, 'name', CASE WHEN item.name = '' THEN item.name_en ELSE item.name END, 'slug', item.search_slug ) ) AS item FROM job_level AS jl LEFT JOIN job_level_item jli ON (jli.job_level_id = jl.id) LEFT JOIN item ON (item.id = jli.item_id) WHERE jl.active = 1 AND item.id IS NOT NULL ORDER BY jl.position ASC; Parameters: [] View formatted query View runnable query Explain query SELECT JSON_ARRAY( JSON_OBJECT( 'id', item.id, 'name', CASE WHEN item.name = '' THEN item.name_en ELSE item.name END, 'slug', item.search_slug ) ) AS item FROM job_level AS jl LEFT JOIN job_level_item jli ON (jli.job_level_id = jl.id) LEFT JOIN item ON (item.id = jli.item_id) WHERE jl.active = 1 AND item.id IS NOT NULL ORDER BY jl.position ASC; SELECT JSON_ARRAY( JSON_OBJECT( 'id', item.id, 'name', CASE WHEN item.name = '' THEN item.name_en ELSE item.name END, 'slug', item.search_slug ) ) AS item FROM job_level AS jl LEFT JOIN job_level_item jli ON (jli.job_level_id = jl.id) LEFT JOIN item ON (item.id = jli.item_id) WHERE jl.active = 1 AND item.id IS NOT NULL ORDER BY jl.position ASC;;
32	0.29 ms	SELECT t0.id AS id_1, t0.can_show AS can_show_2 FROM level_job_select t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.can_show AS can_show_2 FROM level_job_select t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.can_show AS can_show_2 FROM level_job_select t0 WHERE t0.id = 1 LIMIT 1;
33	0.40 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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 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 = 1 LIMIT 1;
34	0.40 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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 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 = 1 LIMIT 1;
35	0.45 ms	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 Parameters: [`40`] View formatted query View runnable query Explain query 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 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 = 40 LIMIT 1;
36	0.33 ms	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 = ? Parameters: [`24`] View formatted query View runnable query Explain query 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 = ? 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 = 24;
37	0.34 ms	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 Parameters: [`20`] View formatted query View runnable query Explain query 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 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 = 20 LIMIT 1;
38	0.32 ms	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 = ? Parameters: [`10`] View formatted query View runnable query Explain query 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 = ? 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 = 10;
39	0.27 ms	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 Parameters: [`10`] View formatted query View runnable query Explain query 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 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 = 10 LIMIT 1;
40	0.31 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
41	0.38 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
42	0.38 ms	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 = ? Parameters: [`25`] View formatted query View runnable query Explain query 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 = ? 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 = 25;
43	0.39 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
44	0.31 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
45	0.44 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
46	0.30 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
47	0.33 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
48	0.31 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
49	0.31 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
50	0.34 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
51	0.34 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
52	0.34 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
53	0.29 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
54	0.29 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
55	0.29 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
56	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
57	0.31 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
58	0.24 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
59	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
60	0.27 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
61	0.31 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
62	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
63	0.29 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
64	0.32 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
65	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
66	0.27 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
67	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
68	0.24 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
69	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
70	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
71	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
72	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
73	0.27 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
74	0.23 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
75	0.29 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
76	0.27 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
77	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
78	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
79	0.27 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
80	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
81	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
82	0.28 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
83	0.24 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
84	0.24 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
85	0.20 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
86	0.20 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
87	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
88	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
89	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
90	0.22 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
91	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
92	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
93	0.28 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
94	0.28 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
95	0.23 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
96	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
97	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
98	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
99	0.23 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
100	0.24 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
101	0.21 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
102	0.22 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
103	0.25 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
104	0.24 ms	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 Parameters: [`"11"`] View formatted query View runnable query Explain query 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 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 = '11' LIMIT 1;
105	0.28 ms	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 = ? Parameters: [`48`] View formatted query View runnable query Explain query 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 = ? 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 = 48;
106	0.26 ms	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 Parameters: [`"8"`] View formatted query View runnable query Explain query 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 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 = '8' LIMIT 1;
107	0.27 ms	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 = ? Parameters: [`45`] View formatted query View runnable query Explain query 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 = ? 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 = 45;
108	0.24 ms	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 Parameters: [`40`] View formatted query View runnable query Explain query 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 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 = 40 LIMIT 1;
109	0.20 ms	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 Parameters: [`"10"`] View formatted query View runnable query Explain query 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 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 = '10' LIMIT 1;
110	0.27 ms	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 = ? Parameters: [`47`] View formatted query View runnable query Explain query 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 = ? 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 = 47;
111	0.25 ms	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 Parameters: [`"11"`] View formatted query View runnable query Explain query 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 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 = '11' LIMIT 1;
112	0.24 ms	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 Parameters: [`"12"`] View formatted query View runnable query Explain query 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 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 = '12' LIMIT 1;
113	0.26 ms	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 = ? Parameters: [`49`] View formatted query View runnable query Explain query 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 = ? 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 = 49;
114	0.24 ms	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 Parameters: [`"14"`] View formatted query View runnable query Explain query 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 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 = '14' LIMIT 1;
115	0.27 ms	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 = ? Parameters: [`51`] View formatted query View runnable query Explain query 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 = ? 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 = 51;
116	0.28 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
117	0.27 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
118	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
119	0.26 ms	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 Parameters: [`42`] View formatted query View runnable query Explain query 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 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 = 42 LIMIT 1;
120	0.25 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
121	1.72 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"m1451_inzynio_tt"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'm1451_inzynio_tt' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
122	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
123	1.47 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"m1451_inzynio_tt"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'm1451_inzynio_tt' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
124	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
125	1.00 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"m1451_inzynio_tt" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'm1451_inzynio_tt' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
126	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
127	1.43 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME 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 Parameters: [`"m1451_inzynio_tt" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME 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 SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'm1451_inzynio_tt' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'm1451_inzynio_tt' / ORDER BY k.ORDINAL_POSITION;
128	1.91 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"m1451_inzynio_tt" "m1451_inzynio_tt" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'm1451_inzynio_tt' AND t.TABLE_SCHEMA = 'm1451_inzynio_tt' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
129	0.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
130	0.87 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"m1451_inzynio_tt" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'm1451_inzynio_tt' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
131	0.21 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
132	0.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Page\Page	No errors.
App\Entity\Page\PageTranslation	No errors.
App\Entity\Blog	No errors.
App\Entity\FooterLink	No errors.
App\Entity\SeoMainPage	No errors.
App\Entity\IndustryList	No errors.
App\Entity\CitiesList	No errors.
App\Entity\PopularList	No errors.
App\Entity\SearchCache\TechnologyCache	No errors.
App\Entity\SearchCache\CompanyCache	No errors.
App\Entity\SearchCache\OfferNameCache	No errors.
App\Entity\LevelJobSelect	No errors.
App\Entity\Item\ItemCategory	No errors.
App\Entity\File	No errors.

Symfony Profiler

https://www.test.inzynio.pl/pl?error=Ta%20oferta%20wygas%C5%82a.%20Zapraszamy%20do%20aplikowania%20na%20inne%20oferty%20pracy.

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping