Query Metrics
3
Database Queries
3
Different statements
19.63 ms
Query time
0
Invalid entities
37
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
18.65 ms (95.01%) |
1 |
SELECT t0.id AS id_1, t0.expression AS expression_2, t0.lang AS lang_3, t0.status AS status_4, t0.priority AS priority_5, t0.brief AS brief_6, t0.internal_note AS internal_note_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.intro AS intro_10, t0.title AS title_11, t0.content AS content_12, t0.word_needed AS word_needed_13, t0.word_count AS word_count_14, t0.ytg_guide_id AS ytg_guide_id_15, t0.ytg_request_time AS ytg_request_time_16, t0.ytg_json_goal AS ytg_json_goal_17, t0.ytg_json_status AS ytg_json_status_18, t0.ytg_json_serp AS ytg_json_serp_19, t0.ytg_json_paa AS ytg_json_paa_20, t0.score AS score_21, t0.target_score AS target_score_22, t0.scrap_competitor AS scrap_competitor_23, t0.marketing_type AS marketing_type_24, t0.ia_workflow AS ia_workflow_25, t0.text_ordered_at AS text_ordered_at_26, t0.text_done_at AS text_done_at_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.project_id AS project_id_30, t0.manager_id AS manager_id_31 FROM redaction t0 WHERE t0.project_id = ? ORDER BY t0.expression ASC
Parameters:
[
3
]
|
||||||||||||||||||||||
|
0.55 ms (2.81%) |
1 |
SELECT t0.id AS id_1, t0.ndd AS ndd_2, t0.client_name AS client_name_3, t0.thema AS thema_4, t0.type AS type_5, t0.code_langue AS code_langue_6, t0.registrar AS registrar_7, t0.remote_path AS remote_path_8, t0.redirect_rules AS redirect_rules_9, t0.logo_path AS logo_path_10, t0.status AS status_11, t0.secure AS secure_12, t0.www AS www_13, t0.dns_configured AS dns_configured_14, t0.hosting_provisioned AS hosting_provisioned_15, t0.health_status AS health_status_16, t0.health_checked_at AS health_checked_at_17, t0.health_detail AS health_detail_18, t0.dns_status AS dns_status_19, t0.dns_checked_at AS dns_checked_at_20, t0.dns_detail AS dns_detail_21, t0.buyed_at AS buyed_at_22, t0.online_at AS online_at_23, t0.generated_at AS generated_at_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.publish_pending AS publish_pending_27, t0.framework_version AS framework_version_28, t0.persona_last_name AS persona_last_name_29, t0.persona_first_name AS persona_first_name_30, t0.persona_email AS persona_email_31, t0.persona_password AS persona_password_32, t0.persona_sexe AS persona_sexe_33, t0.persona_dob AS persona_dob_34, t0.persona_city AS persona_city_35, t0.author_bio AS author_bio_36, t0.nom AS nom_37, t0.name_h1 AS name_h1_38, t0.slogan AS slogan_39, t0.article_div AS article_div_40, t0.sisters_div AS sisters_div_41, t0.sisters_label AS sisters_label_42, t0.new_article_div AS new_article_div_43, t0.contact_dir AS contact_dir_44, t0.contact_label AS contact_label_45, t0.mention_label AS mention_label_46, t0.mention_url AS mention_url_47, t0.blog_url AS blog_url_48, t0.mail_dir AS mail_dir_49, t0.img_dir_name AS img_dir_name_50, t0.logo_img AS logo_img_51, t0.stylesheet_file_name AS stylesheet_file_name_52, t0.js_file_name AS js_file_name_53, t0.sitemap_file_name AS sitemap_file_name_54, t0.font_file_name AS font_file_name_55, t0.font_selected AS font_selected_56, t0.nav_color AS nav_color_57, t0.button_color AS button_color_58, t0.button_radius AS button_radius_59, t0.header_background_color AS header_background_color_60, t0.width AS width_61, t0.liseret_color AS liseret_color_62, t0.main_color AS main_color_63, t0.text_color AS text_color_64, t0.even_content_color AS even_content_color_65, t0.odd_content_color AS odd_content_color_66, t0.responsive_breakpoint AS responsive_breakpoint_67, t0.column_width AS column_width_68, t0.custom_css AS custom_css_69, t0.facebook_page AS facebook_page_70, t0.facebook_pixel AS facebook_pixel_71, t0.twitter_profile AS twitter_profile_72, t0.linkedin_profile AS linkedin_profile_73, t0.youtube_channel AS youtube_channel_74, t0.host_ip_id AS host_ip_id_75, t0.project_id AS project_id_76, t0.design_id AS design_id_77 FROM site t0 WHERE t0.id = ?
Parameters:
[
"112"
]
|
||||||||||||||||||||||
|
0.43 ms (2.18%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.company_name AS company_name_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.title AS title_9, t0.phone AS phone_10, t0.address AS address_11, t0.postal_code AS postal_code_12, t0.city AS city_13, t0.siret AS siret_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.entreprise_id AS entreprise_id_17, t0.manager_id AS manager_id_18, t0.default_project_id AS default_project_id_19, t0.dtype FROM `user` t0 WHERE t0.id = ?
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\Redaction | 31 |
| App\Entity\User | 1 |
| App\Entity\Entreprise | 1 |
| App\Entity\Project | 1 |
| App\Entity\Site | 1 |
| App\Entity\HostIp | 1 |
| App\Entity\SiteDesign | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Entreprise | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\HostIp | No errors. |
| App\Entity\SiteDesign | No errors. |
| App\Entity\Redaction | No errors. |