Query Metrics
37
Database Queries
18
Different statements
25.30 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
5.52 ms (21.83%) |
10 |
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 ] |
|
4.94 ms (19.54%) |
10 |
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
]
|
|
2.54 ms (10.04%) |
1 |
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:
[] |
|
2.50 ms (9.88%) |
1 |
SELECT identificador, valor_en as texto FROM textos
Parameters:
[] |
|
1.98 ms (7.82%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.34 ms (5.30%) |
2 |
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:
[
"portada-geoloc-en"
]
|
|
0.73 ms (2.90%) |
1 |
SELECT friendly_en FROM tipus_operacio WHERE idTipusOperacio = (SELECT idTipusOperacio FROM tipus_operacio WHERE friendly_es = 'compra' || friendly_ca = 'compra' || friendly_en = 'compra')
Parameters:
[] |
|
0.72 ms (2.83%) |
1 |
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:
[ 145 1 "en" ] |
|
0.72 ms (2.83%) |
1 |
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:
[] |
|
0.66 ms (2.62%) |
1 |
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:
[] |
|
0.60 ms (2.38%) |
1 |
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:
[ 145 1 ] |
|
0.55 ms (2.15%) |
1 |
INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)
Parameters:
[ 0 "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c" "/en/content/portada-geoloc-en" "2026-06-19 15:44:47" ] |
|
0.54 ms (2.13%) |
1 |
SELECT slug, text FROM api_agency_description WHERE lang = 'en'
Parameters:
[] |
|
0.46 ms (1.83%) |
1 |
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
]
|
|
0.45 ms (1.77%) |
1 |
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:
[] |
|
0.40 ms (1.57%) |
1 |
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
]
|
|
0.35 ms (1.38%) |
1 |
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"
]
|
|
0.30 ms (1.19%) |
1 |
"START TRANSACTION"
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.