https://www.test.inzynio.pl/en

302 Redirect from
@front-page (f95d97)
Forwarded to
HomePageController :: homeListAction (0f95ac)
Method
GET
HTTP Status
200
IP
216.73.216.104
Profiled on
Token
9d4e5b

Query Metrics

131 Database Queries
29 Different statements
141.53 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.42 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: 
[
  "en"
  ""
]
View formatted query    View runnable query    Explain query
2 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.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 0.33 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
4 0.42 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
5 0.29 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
6 1.41 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
7 1.20 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
8 12.43 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
9 15.84 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
10 15.67 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
11 16.14 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
12 16.23 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
13 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" => "44"
]
View formatted query    View runnable query    Explain query
14 6.65 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
15 1.35 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
16 1.19 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
17 1.38 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
18 1.63 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
19 1.27 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
20 1.39 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
21 1.14 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
22 0.40 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
23 0.37 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
24 0.31 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
25 0.26 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
26 0.35 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
27 1.52 ms 
SELECT location.name AS city FROM location GROUP BY city;
Parameters: 
[]
View formatted query    View runnable query    Explain query
28 2.34 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
29 0.44 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
30 10.06 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
31 0.68 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
32 0.25 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
33 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: 
[
  1
]
View formatted query    View runnable query    Explain query
34 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: 
[
  1
]
View formatted query    View runnable query    Explain query
35 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: 
[
  40
]
View formatted query    View runnable query    Explain query
36 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: 
[
  24
]
View formatted query    View runnable query    Explain query
37 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: 
[
  20
]
View formatted query    View runnable query    Explain query
38 0.22 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
39 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: 
[
  10
]
View formatted query    View runnable query    Explain query
40 0.20 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
41 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
42 0.21 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
43 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
44 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
45 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
46 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
47 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
48 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
49 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
50 0.18 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
51 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
52 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
53 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
54 0.19 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
55 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
56 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
57 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
58 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
59 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
60 0.18 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
61 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
62 0.18 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
63 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
64 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
65 0.19 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
66 0.18 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
67 0.17 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
68 0.17 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
69 0.17 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
70 0.17 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
71 0.17 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
72 0.17 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
73 0.17 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
74 0.17 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
75 0.17 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
76 0.17 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
77 0.17 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
78 0.17 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
79 0.17 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
80 0.17 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
81 0.17 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
82 0.17 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
83 0.17 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
84 0.17 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
85 0.17 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
86 0.17 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
87 0.17 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
88 0.17 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
89 0.17 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
90 0.17 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
91 0.17 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
92 0.17 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
93 0.17 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
94 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
95 0.18 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
96 0.18 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
97 0.19 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
98 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
99 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
100 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
101 0.18 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
102 0.18 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
103 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: 
[
  "11"
]
View formatted query    View runnable query    Explain query
104 0.22 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
105 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
106 0.23 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
107 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: 
[
  40
]
View formatted query    View runnable query    Explain query
108 0.17 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
109 0.19 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
110 0.18 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
111 0.16 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
112 0.19 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
113 0.17 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
114 0.18 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
115 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
116 0.18 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
117 0.19 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
118 0.17 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
119 0.19 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
120 1.73 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
121 0.12 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
122 1.55 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
123 0.13 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
124 0.99 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
125 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
126 1.34 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
127 1.83 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
128 0.13 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
129 0.80 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
130 0.19 ms 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
131 0.17 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.