Query Metrics
37
Database Queries
18
Different statements
32.82 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
9.20 ms (28.02%) |
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:
[ "fr" 21 1 ] |
|
7.42 ms (22.62%) |
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.98 ms (9.07%) |
1 |
SELECT identificador, valor_fr as texto FROM textos
Parameters:
[] |
|
2.28 ms (6.94%) |
1 |
SELECT slug, text FROM api_agency_description WHERE lang = 'fr'
Parameters:
[] |
|
1.64 ms (4.99%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.53 ms (4.66%) |
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:
[
"cookies"
]
|
|
0.91 ms (2.76%) |
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:
[ 99999 1 ] |
|
0.81 ms (2.48%) |
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 = 'fr_FR'
Parameters:
[] |
|
0.77 ms (2.36%) |
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.73 ms (2.22%) |
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.69 ms (2.10%) |
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:
[ 99999 1 "fr" ] |
|
0.63 ms (1.92%) |
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.62 ms (1.89%) |
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:
[
"fr"
]
|
|
0.61 ms (1.85%) |
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.57 ms (1.75%) |
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.56 ms (1.71%) |
1 |
INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)
Parameters:
[ 0 "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c" "/fr/cookies" "2026-06-19 17:43:55" ] |
|
0.52 ms (1.60%) |
1 |
SELECT friendly_fr FROM tipus_operacio WHERE idTipusOperacio = (SELECT idTipusOperacio FROM tipus_operacio WHERE friendly_es = 'compra' || friendly_ca = 'compra' || friendly_en = 'compra')
Parameters:
[] |
|
0.35 ms (1.06%) |
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.