Query Metrics
26
Database Queries
5
Different statements
4.56 ms
Query time
0
Invalid entities
19
Managed entities
Grouped Statements
manager connection
| Time▼ | Count | Info |
|---|---|---|
|
1.79 ms (39.26%) |
8 |
SELECT t0.feat_id AS feat_id_1, t0.feat_seo AS feat_seo_2, t0.feat_cart AS feat_cart_3, t0.feat_cdrom AS feat_cdrom_4, t0.feat_icon AS feat_icon_5, t0.feat_language AS feat_language_6, t0.feat_theme AS feat_theme_7, t0.feat_document AS feat_document_8, t0.feat_duplicate AS feat_duplicate_9, t0.feat_link_editor AS feat_link_editor_10, t0.feat_email_extract AS feat_email_extract_11, t0.feat_enrich AS feat_enrich_12, t0.feat_background AS feat_background_13, t0.feat_tool AS feat_tool_14, t0.feat_movie AS feat_movie_15, t0.feat_contents AS feat_contents_16, t0.feat_logo AS feat_logo_17, t0.feat_cover_page AS feat_cover_page_18, t0.feat_statistics AS feat_statistics_19, t0.feat_statistics_plus AS feat_statistics_plus_20, t0.feat_animated_link AS feat_animated_link_21, t0.feat_read_speaker AS feat_read_speaker_22, t0.feat_archive AS feat_archive_23, t0.feat_social_networks AS feat_social_networks_24, t0.feat_mobile_device AS feat_mobile_device_25, t0.feat_thumbnails AS feat_thumbnails_26, t0.feat_signature AS feat_signature_27, t0.feat_library AS feat_library_28, t0.feat_loader AS feat_loader_29, t0.feat_marquee AS feat_marquee_30, t0.feat_qrcode AS feat_qrcode_31, t0.feat_dldoc AS feat_dldoc_32, t0.feat_search AS feat_search_33, t0.feat_goto AS feat_goto_34, t0.feat_title AS feat_title_35, t0.feat_spec AS feat_spec_36, t0.feat_publish AS feat_publish_37, t0.feat_regen AS feat_regen_38, t0.feat_pagelist AS feat_pagelist_39, t0.feat_security AS feat_security_40, t0.feat_enrich_plus AS feat_enrich_plus_41, t0.feat_white_mark AS feat_white_mark_42, t0.feat_notes AS feat_notes_43, t0.feat_dldoc_plus AS feat_dldoc_plus_44, t0.feat_color_links AS feat_color_links_45, t0.feat_banniere AS feat_banniere_46, t0.feat_form AS feat_form_47, t0.feat_products_list AS feat_products_list_48, t0.pack_id AS pack_id_49 FROM itm_feature t0 WHERE t0.feat_id = ?
Parameters:
[
1148
]
|
|
1.40 ms (30.78%) |
8 |
SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC
Parameters:
[
417
]
|
|
0.86 ms (18.85%) |
8 |
SELECT t0.sub_id AS sub_id_1, t0.sub_name AS sub_name_2, t0.sub_creation_date AS sub_creation_date_3, t0.sub_expiration_date AS sub_expiration_date_4, t0.sub_archive AS sub_archive_5, t0.sub_temporary AS sub_temporary_6, t0.sub_document_number AS sub_document_number_7, t0.sub_page_number AS sub_page_number_8, t0.sub_download_number AS sub_download_number_9, t0.sub_download_done AS sub_download_done_10, t0.sub_transfert_archive_date AS sub_transfert_archive_date_11, t0.sub_validate AS sub_validate_12, t0.cust_id AS cust_id_13, t0.feat_id AS feat_id_14 FROM itm_subscription t0 WHERE t0.sub_id = ?
Parameters:
[
417
]
|
|
0.26 ms (5.69%) |
1 |
SELECT i0_.sub_id AS sub_id_0, i0_.sub_name AS sub_name_1, i0_.sub_creation_date AS sub_creation_date_2, i0_.sub_expiration_date AS sub_expiration_date_3, i0_.sub_archive AS sub_archive_4, i0_.sub_temporary AS sub_temporary_5, i0_.sub_document_number AS sub_document_number_6, i0_.sub_page_number AS sub_page_number_7, i0_.sub_download_number AS sub_download_number_8, i0_.sub_download_done AS sub_download_done_9, i0_.sub_validate AS sub_validate_10, COUNT(i1_.cat_id) AS sclr_11, MAX(i1_.cat_page_number) AS sclr_12, i0_.feat_id AS sclr_13 FROM itm_subscription i0_ LEFT JOIN itm_catalog i1_ ON (i1_.sub_id = i0_.sub_id) WHERE i0_.cust_id = ? GROUP BY i0_.sub_id ORDER BY i0_.sub_id ASC
Parameters:
[
1
]
|
|
0.25 ms (5.42%) |
1 |
SELECT t0.use_id AS use_id_1, t0.use_login AS use_login_2, t0.use_password AS use_password_3, t0.roles AS roles_4, t0.use_first_name AS use_first_name_5, t0.use_last_name AS use_last_name_6, t0.use_email AS use_email_7, t0.use_id_parent AS use_id_parent_8, t0.last_connection AS last_connection_9, t0.count_connection AS count_connection_10, t0.password_last_changed AS password_last_changed_11, t0.require_password_change AS require_password_change_12, t0.two_factor_secret AS two_factor_secret_13, t0.two_factor_method AS two_factor_method_14, t0.two_factor_enabled AS two_factor_enabled_15, t0.two_factor_email_code AS two_factor_email_code_16, t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17, t0.failed_login_attempts AS failed_login_attempts_18, t0.locked_until AS locked_until_19, t0.cust_id AS cust_id_20, t0.priv_id AS priv_id_21 FROM itm_user t0 WHERE t0.use_id = ?
Parameters:
[
369
]
|
Database Connections
| Name | Service |
|---|---|
| manager | doctrine.dbal.manager_connection |
| stats | doctrine.dbal.stats_connection |
Entity Managers
| Name | Service |
|---|---|
| manager | doctrine.orm.manager_entity_manager |
| stats | doctrine.orm.stats_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
manager entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Manager\Subscription | 8 |
| App\Entity\Manager\Feature | 8 |
| App\Entity\Manager\User | 1 |
| App\Entity\Manager\Customer | 1 |
| App\Entity\Manager\Privilege | 1 |
stats entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
manager entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Manager\User | No errors. |
| App\Entity\Manager\Customer | No errors. |
| App\Entity\Manager\Privilege | No errors. |
| App\Entity\Manager\SubscriptionPermissions | No errors. |
| App\Entity\Manager\Subscription | No errors. |
| App\Entity\Manager\Document | No errors. |
| App\Entity\Manager\Feature | No errors. |
| App\Entity\Manager\Package | No errors. |
stats entity manager
No loaded entities.