Query Metrics
10
Database Queries
8
Different statements
10.39 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.41 ms (32.81%) |
2 |
SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ?)) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?)))
Parameters:
[ "gruppobossoni.wi-staging.it" "/car-configurator/?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" "/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" "/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" "/car-configurator/?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" "/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" "/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" ] |
2.32 ms (22.29%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.codice_motornet AS codice_motornet_3, t0.codice_eurotax AS codice_eurotax_4, t0.nome AS nome_5, t0.deleted AS deleted_6, t0.dettaglio AS dettaglio_7, t0.accessori AS accessori_8, t0.last_update AS last_update_9, t0.carConfiguratorModelId AS carConfiguratorModelId_10 FROM car_configurator_version t0 WHERE t0.id = ?
Parameters:
[
"fa21cd23-9beb-4dfe-aa18-10ac3bccee04"
]
|
1.51 ms (14.50%) |
1 |
SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND r0_.source_path = ?
Parameters:
[ "gruppobossoni.wi-staging.it" "*" ] |
0.95 ms (9.14%) |
2 |
SELECT i0_.id AS id_0, i0_.tag_type AS tag_type_1, i0_.tag_reference AS tag_reference_2, i0_.label AS label_3 FROM imgbundle_image_tag i0_ WHERE i0_.tag_type = ? AND i0_.tag_reference = ? ORDER BY i0_.label ASC
Parameters:
[ "carConfiguratorModelList" "ed5fe47152117a2c7ef3685dc1f72c2ea4b7b0b3" ] |
0.86 ms (8.25%) |
1 |
SELECT c0_.id AS id_0, c0_.site AS site_1, c0_.label AS label_2, c0_.link AS link_3, c0_.link_blank AS link_blank_4, c0_.visible AS visible_5, c0_.initial_open AS initial_open_6, c0_.column_position AS column_position_7, c0_.sort_index AS sort_index_8, c0_.parentCustomMenuItemId AS parentCustomMenuItemId_9 FROM custom_menu_item c0_ WHERE c0_.visible = 1 AND c0_.site = ? ORDER BY c0_.column_position ASC, c0_.sort_index ASC
Parameters:
[
"default"
]
|
0.53 ms (5.09%) |
1 |
SELECT t0.id AS id_1, t0.codice_marca AS codice_marca_2, t0.codice_gamma_modello AS codice_gamma_modello_3, t0.descrizione_gamma_modello AS descrizione_gamma_modello_4, t0.url_name AS url_name_5, t0.sort_index AS sort_index_6, t0.active AS active_7, t0.visible AS visible_8, t0.dettaglio AS dettaglio_9, t0.last_update AS last_update_10, t0.price_from AS price_from_11, t0.versions_by_fuel AS versions_by_fuel_12, t0.from_to_params AS from_to_params_13, t0.image AS image_14 FROM car_configurator_model t0 WHERE t0.id = ?
Parameters:
[
"f9ef8731-c0cd-4a10-b130-6cbcbd208e97"
]
|
0.46 ms (4.43%) |
1 |
SELECT l0_.id AS id_0, l0_.site AS site_1, l0_.url AS url_2, l0_.is_visible AS is_visible_3, l0_.content AS content_4, l0_.content_secondary AS content_secondary_5, l0_.title AS title_6, l0_.seo_title AS seo_title_7, l0_.seo_description AS seo_description_8, l0_.pre_footer_title AS pre_footer_title_9, l0_.pre_footer_content AS pre_footer_content_10, l0_.date_create AS date_create_11, l0_.date_last_update AS date_last_update_12 FROM link_seo l0_ WHERE l0_.is_visible = 1 AND l0_.url = ? AND l0_.site = ?
Parameters:
[ "/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04" "default" ] |
0.36 ms (3.49%) |
1 |
SELECT b0_.code AS code_0 FROM brand b0_ WHERE b0_.eurotax_code = ? AND (b0_.is_vic IS NULL OR b0_.is_vic = 0)
Parameters:
[
"AUD"
]
|
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 |
---|---|
RedirectorBundle\Entity\RedirectorMapping | No errors. |
App\Entity\CarConfiguratorVersion | No errors. |
App\Entity\CarConfiguratorModel | No errors. |
IntranetBundle\Entity\RequestInfo | No errors. |
IntranetBundle\Entity\Brand | No errors. |
IntranetBundle\Entity\ViewLog | No errors. |
ImageBundle\Entity\ImageTag | No errors. |
IntranetBundle\Entity\LinkSeo | No errors. |
IntranetBundle\Entity\CustomMenuItem | No errors. |