Query Metrics
11
Database Queries
9
Different statements
2.24 ms
Query time
0
Invalid entities
13
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.32 ms |
SELECT t0.id AS id_1, t0.platform_logo AS platform_logo_2, t0.platform_main_color AS platform_main_color_3, t0.platform_favicon AS platform_favicon_4, t0.platform_title AS platform_title_5, t0.push_notification_logo AS push_notification_logo_6, t0.push_notification_badge AS push_notification_badge_7, t0.contract_template_legal_person AS contract_template_legal_person_8, t0.contract_template_natural_person1 AS contract_template_natural_person1_9, t0.contract_template_natural_person2 AS contract_template_natural_person2_10, t0.contract_template_natural_person3 AS contract_template_natural_person3_11, t0.contract_template_natural_person4 AS contract_template_natural_person4_12, t0.contract_template_participation AS contract_template_participation_13, t0.ifu_template AS ifu_template_14, t0.primary_market_description AS primary_market_description_15, t0.secondary_market_reassurance AS secondary_market_reassurance_16, t0.payment_fees_sell_secondary_market AS payment_fees_sell_secondary_market_17, t0.payment_fees_buy_secondary_market AS payment_fees_buy_secondary_market_18, t0.sell_fees_platform AS sell_fees_platform_19, t0.page_one_ifu AS page_one_ifu_20, t0.page_three_ifu AS page_three_ifu_21, t0.given_power_pdf AS given_power_pdf_22, t0.sign_only_pdf AS sign_only_pdf_23, t0.duplicata_pdf AS duplicata_pdf_24, t0.universign_primary_market_email AS universign_primary_market_email_25, t0.universign_agemail AS universign_agemail_26, t0.universign_secondary_market_email AS universign_secondary_market_email_27, t0.contract_summary_text AS contract_summary_text_28, t0.contract_summary_video AS contract_summary_video_29, t0.cgpsummary_text AS cgpsummary_text_30, t0.cgpsummary_video AS cgpsummary_video_31, t0.contract_notice_documents AS contract_notice_documents_32, t0.company_address AS company_address_33, t0.company_rcs AS company_rcs_34, t0.company_siren AS company_siren_35, t0.company_orias AS company_orias_36, t0.company_capital AS company_capital_37, t0.company_address_only AS company_address_only_38, t0.company_zipcode_only AS company_zipcode_only_39, t0.company_city_only AS company_city_only_40, t0.contract_template_legal_person2 AS contract_template_legal_person2_41, t0.platform_mails_logo AS platform_mails_logo_42, t0.email_sender AS email_sender_43, t0.email_signature AS email_signature_44, t0.platform_url AS platform_url_45, t0.support_label AS support_label_46, t0.cheque_address AS cheque_address_47, t0.legal_representative_name AS legal_representative_name_48, t0.legal_representative_title AS legal_representative_title_49, t0.redaction_city AS redaction_city_50, t0.former_name AS former_name_51, t0.universign_observer_firstname AS universign_observer_firstname_52, t0.universign_observer_lastname AS universign_observer_lastname_53, t0.universign_observer_phone AS universign_observer_phone_54, t0.secondary_color AS secondary_color_55, t0.text_color_mode AS text_color_mode_56, t0.default_assistance_email AS default_assistance_email_57, t0.legal_notices_content AS legal_notices_content_58, t0.terms_content AS terms_content_59, t0.brevo_api_key_dev AS brevo_api_key_dev_60, t0.brevo_api_key_prod AS brevo_api_key_prod_61, t0.brevo_sms_sender AS brevo_sms_sender_62, t0.stripe_api_key_dev AS stripe_api_key_dev_63, t0.stripe_api_key_prod AS stripe_api_key_prod_64, t0.universign_user AS universign_user_65, t0.universign_password_dev AS universign_password_dev_66, t0.universign_password_prod AS universign_password_prod_67, t0.linkedin_url AS linkedin_url_68, t0.instagram_url AS instagram_url_69, t0.youtube_url AS youtube_url_70, t0.test_mode AS test_mode_71, t0.created_at AS created_at_72, t0.updated_at AS updated_at_73 FROM platform_options t0
Parameters:
[] |
| 2 | 0.12 ms |
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[] |
| 3 | 0.11 ms |
SELECT t0.id AS id_1, t0.public_tab AS public_tab_2, t0.private_spaces_tab AS private_spaces_tab_3, t0.secured_tab AS secured_tab_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM file_manager_options t0
Parameters:
[] |
| 4 | 0.32 ms |
SELECT t0.id AS id_1, t0.has_posts AS has_posts_2, t0.has_post_documents AS has_post_documents_3, t0.order_posts_by_position AS order_posts_by_position_4 FROM blog_options t0
Parameters:
[] |
| 5 | 0.17 ms |
SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.favicon AS favicon_3, t0.site_logo AS site_logo_4, t0.back_main_color AS back_main_color_5, t0.has_archive_entities AS has_archive_entities_6, t0.has_single_entities AS has_single_entities_7, t0.has_seo_entities AS has_seo_entities_8, t0.agency_link AS agency_link_9, t0.agency_name AS agency_name_10, t0.recaptcha_public_key AS recaptcha_public_key_11, t0.recaptcha_private_key AS recaptcha_private_key_12, t0.homepage_id AS homepage_id_13 FROM cms_options t0
Parameters:
[] |
| 6 | 0.14 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.contact_mail AS contact_mail_3, t0.address AS address_4, t0.analytics_code AS analytics_code_5, t0.tag_manager_code AS tag_manager_code_6, t0.has_youtube_videos AS has_youtube_videos_7, t0.sopp_customer_id AS sopp_customer_id_8, t0.id_sir_data_user AS id_sir_data_user_9, t0.id_sir_data_site AS id_sir_data_site_10, t0.service_used AS service_used_11, t0.script_injection AS script_injection_12, t0.contact_page_id AS contact_page_id_13, t0.policy_page_id AS policy_page_id_14 FROM rgpd_options t0
Parameters:
[] |
| 7 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alt AS alt_4, t0.description AS description_5, t0.file AS file_6, t0.visibility AS visibility_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM file t0 WHERE t0.id = ?
Parameters:
[
"2309"
]
|
| 8 | 0.13 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.value AS value_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.option_category_id AS option_category_id_8 FROM `option` t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"logo-gfv"
]
|
| 9 | 0.42 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "14" "fr" "Akyos\CmsBundle\Entity\Option" ] |
| 10 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.value AS value_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.option_category_id AS option_category_id_8 FROM `option` t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"logo-gfv"
]
|
| 11 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alt AS alt_4, t0.description AS description_5, t0.file AS file_6, t0.visibility AS visibility_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM file t0 WHERE t0.id = ?
Parameters:
[
35
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| messenger | doctrine.dbal.messenger_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 |
|---|---|
| Akyos\CmsBundle\Entity\Page | 3 |
| Akyos\FileManagerBundle\Entity\File | 2 |
| App\Entity\Platform\PlatformOptions | 1 |
| Akyos\BuilderBundle\Entity\BuilderOptions | 1 |
| Akyos\FileManagerBundle\Entity\FileManagerOptions | 1 |
| Akyos\BlogBundle\Entity\BlogOptions | 1 |
| Akyos\CmsBundle\Entity\CmsOptions | 1 |
| Akyos\CmsBundle\Entity\RgpdOptions | 1 |
| Akyos\CmsBundle\Entity\Option | 1 |
| Akyos\CmsBundle\Entity\OptionCategory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Platform\PlatformOptions | No errors. |
| App\Entity\Platform\Notification | No errors. |
| App\Entity\Ticket\Ticket | No errors. |
| Akyos\BuilderBundle\Entity\BuilderOptions | No errors. |
| Akyos\FileManagerBundle\Entity\FileManagerOptions | No errors. |
| Akyos\FileManagerBundle\Entity\PrivateSpace | No errors. |
| Akyos\BlogBundle\Entity\BlogOptions | No errors. |
| Akyos\CmsBundle\Entity\CmsOptions | No errors. |
| Akyos\CmsBundle\Entity\Page | No errors. |
| Akyos\CmsBundle\Entity\RgpdOptions | No errors. |
| Akyos\FileManagerBundle\Entity\File | No errors. |
| Akyos\CmsBundle\Entity\Option | No errors. |
| Akyos\CmsBundle\Entity\OptionCategory | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |