Query Metrics
7
Database Queries
7
Different statements
3.36 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.79 ms (23.57%) |
1 |
SELECT t0.id AS id_1, t0.address AS address_2, t0.phone_contact AS phone_contact_3, t0.email_contact AS email_contact_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.youtube AS youtube_7, t0.twitter AS twitter_8, t0.linkedin AS linkedin_9, t0.logo_name AS logo_name_10, t0.logo_footer_name AS logo_footer_name_11, t0.favicon_name AS favicon_name_12, t0.maintenance AS maintenance_13, t0.title AS title_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.meta_image_name AS meta_image_name_17, t0.payment_cb AS payment_cb_18, t0.payment_transfer AS payment_transfer_19, t0.payment_bank_cheque AS payment_bank_cheque_20, t0.payment_on_delivery AS payment_on_delivery_21, t0.payment_cbmodel AS payment_cbmodel_22, t0.payment_cbendpoint AS payment_cbendpoint_23, t0.payment_cbusername AS payment_cbusername_24, t0.payment_cbpassword AS payment_cbpassword_25, t0.payment_cbmode AS payment_cbmode_26, t0.denomination_virement AS denomination_virement_27, t0.iban AS iban_28, t0.bic AS bic_29, t0.payment_transfer_block_delay AS payment_transfer_block_delay_30, t0.payment_bank_cheque_order AS payment_bank_cheque_order_31, t0.payment_bank_cheque_address AS payment_bank_cheque_address_32, t0.payment_bank_cheque_block_delay AS payment_bank_cheque_block_delay_33, t0.allow_pickup_in_store AS allow_pickup_in_store_34, t0.api_key_google_maps AS api_key_google_maps_35, t0.api_key_public_grecaptcha AS api_key_public_grecaptcha_36, t0.api_key_private_grecaptcha AS api_key_private_grecaptcha_37, t0.latitude AS latitude_38, t0.longitude AS longitude_39, t0.zoom AS zoom_40, t0.map_id AS map_id_41, t0.marker_image_name AS marker_image_name_42, t0.api_freebird_backend_endpoint AS api_freebird_backend_endpoint_43, t0.api_freebird_licence_endpoint AS api_freebird_licence_endpoint_44, t0.api_freebird_backend_username AS api_freebird_backend_username_45, t0.api_freebird_backend_password AS api_freebird_backend_password_46, t0.section_id AS section_id_47, t0.caisse_id AS caisse_id_48, t0.stock_restriction_section AS stock_restriction_section_49, t0.font_primary AS font_primary_50, t0.font_secondary AS font_secondary_51, t0.color_primary AS color_primary_52, t0.color_secondary AS color_secondary_53, t0.tax AS tax_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.current_devise_id AS current_devise_id_57 FROM configuration t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.59 ms (17.46%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block1_id IN (?)
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.51 ms (15.15%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM footer t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.50 ms (14.88%) |
1 |
SELECT t0.id AS id_1, t0.title_block1 AS title_block1_2, t0.title_block2 AS title_block2_3, t0.title_block3 AS title_block3_4, t0.title_block4 AS title_block4_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM footer_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 1 "fr" ] |
||||||||||||||||||||||||||||||||
|
0.36 ms (10.65%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block2_id IN (?)
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.31 ms (9.17%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block3_id IN (?)
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.31 ms (9.13%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block4_id IN (?)
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Configuration | 1 |
| App\Entity\Devise | 1 |
| App\Entity\Footer | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Configuration | No errors. |
| App\Entity\Devise | No errors. |
| App\Entity\Footer | No errors. |
| App\Entity\FooterLink | No errors. |
| App\Entity\FooterTranslation | No errors. |