Query Metrics
20
Database Queries
3
Different statements
5.61 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.49 ms |
SELECT n0_.title AS title_0, n0_.short_content AS short_content_1, n0_.content AS content_2, n0_.cover_image_path AS cover_image_path_3, n0_.publish_at AS publish_at_4, n0_.id AS id_5, n0_.slug AS slug_6, n0_.enabled AS enabled_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n0_.created_by_id AS created_by_id_10, n0_.updated_by_id AS updated_by_id_11 FROM news n0_ WHERE n0_.publish_at < NOW() AND n0_.enabled = 1 ORDER BY n0_.publish_at DESC
Parameters:
[] |
2 | 0.42 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 10 "hu" ] |
3 | 0.21 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 10 "hu" ] |
4 | 0.26 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 9 "hu" ] |
5 | 0.28 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 9 "hu" ] |
6 | 0.24 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 8 "hu" ] |
7 | 0.24 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 8 "hu" ] |
8 | 0.24 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 7 "hu" ] |
9 | 0.23 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 7 "hu" ] |
10 | 0.24 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 6 "hu" ] |
11 | 0.27 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 6 "hu" ] |
12 | 0.26 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 5 "hu" ] |
13 | 0.25 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 5 "hu" ] |
14 | 0.25 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 4 "hu" ] |
15 | 0.27 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 4 "hu" ] |
16 | 0.26 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 3 "hu" ] |
17 | 0.25 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 3 "hu" ] |
18 | 0.24 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 2 "hu" ] |
19 | 0.24 ms |
SELECT n0_.locale AS locale_0, n0_.title AS title_1, n0_.short_content AS short_content_2, n0_.content AS content_3, n0_.id AS id_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.news_id AS news_id_7, n0_.created_by_id AS created_by_id_8, n0_.updated_by_id AS updated_by_id_9 FROM news_translation n0_ WHERE n0_.news_id = ? AND n0_.locale = ?
Parameters:
[ 2 "hu" ] |
20 | 0.48 ms |
SELECT l0_.code AS code_0, l0_.headquarter AS headquarter_1, l0_.company AS company_2, l0_.description AS description_3, l0_.country_code AS country_code_4, l0_.city AS city_5, l0_.address AS address_6, l0_.email AS email_7, l0_.message_email AS message_email_8, l0_.phone_number AS phone_number_9, l0_.facebook_link AS facebook_link_10, l0_.linkedin_link AS linkedin_link_11, l0_.gps_latitude AS gps_latitude_12, l0_.gps_longitude AS gps_longitude_13, l0_.id AS id_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, l0_.created_by_id AS created_by_id_17, l0_.updated_by_id AS updated_by_id_18 FROM location l0_
Parameters:
[] |
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\News | No errors. |
App\Entity\User | No errors. |
App\Entity\NewsTranslation | No errors. |
App\Entity\Location | No errors. |
App\Entity\LocationTranslation | No errors. |
App\Entity\Job | No errors. |
App\Entity\Message | No errors. |