Query Metrics
37
Database Queries
18
Different statements
49.56 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.40 ms |
"START TRANSACTION"
Parameters:
[] |
| 2 | 3.85 ms |
INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)
Parameters:
[ 0 "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c" "/en/privacy" "2026-06-19 18:00:18" ] |
| 3 | 2.07 ms |
"COMMIT"
Parameters:
[] |
| 4 | 1.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"privacy"
]
|
| 5 | 2.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3 FROM api_menu t0 LIMIT 1
Parameters:
[] |
| 6 | 2.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.google AS google_9, t0.linkedin AS linkedin_10, t0.instagram AS instagram_11, t0.tiktok AS tiktok_12, t0.youtube AS youtube_13, t0.logo AS logo_14, t0.logo_movile_email AS logo_movile_email_15, t0.logo_contact AS logo_contact_16, t0.logo_fav AS logo_fav_17, t0.logo_aicat AS logo_aicat_18, t0.logo_agente AS logo_agente_19, t0.logo_miembro AS logo_miembro_20, t0.banner AS banner_21, t0.banner_url AS banner_url_22, t0.default_list_properties AS default_list_properties_23, t0.user AS user_24, t0.password AS password_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.primary_foot_1 AS primary_foot_1_28, t0.primary_foot_2 AS primary_foot_2_29, t0.filter_header AS filter_header_30, t0.newsletter AS newsletter_31, t0.first_time AS first_time_32, t0.activation AS activation_33, t0.roles AS roles_34 FROM api_agency t0 LIMIT 1
Parameters:
[] |
| 7 | 0.67 ms |
SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0
Parameters:
[] |
| 8 | 0.56 ms |
SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0 WHERE t0.predeterminado = ? LIMIT 1
Parameters:
[
1
]
|
| 9 | 0.51 ms |
SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0 WHERE t0.cod = ? LIMIT 1
Parameters:
[
"en"
]
|
| 10 | 3.12 ms |
SELECT t0.id AS id_1, t0.order_page AS order_page_2, t0.page_id AS page_id_3, t0.menu_id AS menu_id_4, t0.parent_id AS parent_id_5 FROM api_order_pages t0 WHERE t0.menu_id = ? ORDER BY t0.order_page ASC
Parameters:
[
1
]
|
| 11 | 2.84 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 12 | 0.65 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 21 1 ] |
| 13 | 0.55 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
137
]
|
| 14 | 0.63 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 137 1 ] |
| 15 | 2.12 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
141
]
|
| 16 | 0.83 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 141 1 ] |
| 17 | 0.53 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
145
]
|
| 18 | 0.87 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 145 1 ] |
| 19 | 1.92 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
55
]
|
| 20 | 0.72 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 99760 1 ] |
| 21 | 0.57 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
149
]
|
| 22 | 2.87 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 149 1 ] |
| 23 | 0.70 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
71
]
|
| 24 | 0.62 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 99999 1 ] |
| 25 | 0.56 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
63
]
|
| 26 | 0.63 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 88190 1 ] |
| 27 | 2.32 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
59
]
|
| 28 | 0.61 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 70840 1 ] |
| 29 | 0.49 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?
Parameters:
[
51
]
|
| 30 | 0.59 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? AND t0.status = ? LIMIT 1
Parameters:
[ "en" 60722 1 ] |
| 31 | 1.43 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"privacy"
]
|
| 32 | 3.17 ms |
SELECT identificador, valor_en as texto FROM textos
Parameters:
[] |
| 33 | 1.03 ms |
SELECT slug, text FROM api_agency_description WHERE lang = 'en'
Parameters:
[] |
| 34 | 1.98 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.group_page = ? AND t0.status = ?
Parameters:
[ 60722 1 ] |
| 35 | 0.60 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.group_page = ? AND t0.status = ? AND t0.lang = ? LIMIT 1
Parameters:
[ 60722 1 "en" ] |
| 36 | 1.75 ms |
SELECT friendly FROM api_properties_supertype_i18n WHERE id = (SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges' LIMIT 1) AND cod_lang = 'en_US'
Parameters:
[] |
| 37 | 0.62 ms |
SELECT friendly_en FROM tipus_operacio WHERE idTipusOperacio = (SELECT idTipusOperacio FROM tipus_operacio WHERE friendly_es = 'compra' || friendly_ca = 'compra' || friendly_en = 'compra')
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| admin | doctrine.dbal.admin_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| admin | doctrine.orm.admin_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\Tracking | No errors. |
| App\Entity\Main\ApiPages | No errors. |
| App\Entity\Main\ApiMenu | No errors. |
| App\Entity\Main\ApiOrderPages | No errors. |
| App\Entity\Main\ApiAgency | No errors. |
| App\Entity\Main\ApiAgencyLang | No errors. |
| App\Entity\Main\Textos | No errors. |
| App\Entity\Main\ApiAgencyDescription | No errors. |
| App\Entity\Main\TipusOperacio | No errors. |
| App\Entity\Main\ApiPropertiesSupertype | No errors. |
admin entity manager
No loaded entities.