Query Metrics
37
Database Queries
18
Different statements
52.95 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
10.50 ms (19.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:
[ "fr" 21 1 ] |
|
8.02 ms (15.15%) |
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
]
|
|
6.55 ms (12.37%) |
1 |
SELECT slug, text FROM api_agency_description WHERE lang = 'fr'
Parameters:
[] |
|
3.78 ms (7.13%) |
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:
[] |
|
3.75 ms (7.08%) |
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:
[ 99760 1 "fr" ] |
|
3.58 ms (6.76%) |
1 |
SELECT identificador, valor_fr as texto FROM textos
Parameters:
[] |
|
2.90 ms (5.47%) |
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:
[
"empresa"
]
|
|
2.65 ms (5.00%) |
1 |
INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)
Parameters:
[ 0 "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c" "/fr/empresa" "2026-06-19 15:37:48" ] |
|
2.36 ms (4.47%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
1.94 ms (3.67%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.88 ms (3.55%) |
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:
[] |
|
1.83 ms (3.46%) |
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.70 ms (1.32%) |
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:
[ 99760 1 ] |
|
0.62 ms (1.16%) |
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.59 ms (1.12%) |
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.47 ms (0.90%) |
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.44 ms (0.84%) |
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.38 ms (0.72%) |
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"
]
|
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.