GET https://ubo.preprod.webpick.info/translation-logs/?page=1

Query Metrics

6 Database Queries
5 Different statements
1.35 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.user_name AS user_name_4, t0.roles AS roles_5, t0.profile_picture AS profile_picture_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.deleted AS deleted_10 FROM user_ubo t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.23 ms
SELECT s0_.id AS id_0, s0_.url AS url_1 FROM site s0_ WHERE s0_.deleted_at IS NULL AND s0_.translation_role = ?
Parameters:
[
  "source"
]
3 0.15 ms
SELECT s0_.id AS id_0, s0_.url AS url_1 FROM site s0_ WHERE s0_.deleted_at IS NULL AND s0_.translation_role = ?
Parameters:
[
  "target"
]
4 0.20 ms
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM translation_log t0_ INNER JOIN site s1_ ON t0_.source_site_id = s1_.id INNER JOIN site s2_ ON t0_.destination_site_id = s2_.id
Parameters:
[]
5 0.10 ms
SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM translation_log t0_ INNER JOIN site s1_ ON t0_.source_site_id = s1_.id INNER JOIN site s2_ ON t0_.destination_site_id = s2_.id ORDER BY t0_.id DESC LIMIT 10
Parameters:
[]
6 0.18 ms
SELECT t0_.id AS id_0, t0_.post_source_id AS post_source_id_1, t0_.post_source_url AS post_source_url_2, t0_.post_destination_id AS post_destination_id_3, t0_.post_destination_url AS post_destination_url_4, t0_.translated_at AS translated_at_5, t0_.status AS status_6, t0_.started_at AS started_at_7, t0_.finished_at AS finished_at_8, t0_.summary AS summary_9, t0_.attempts AS attempts_10, s1_.id AS id_11, s1_.url AS url_12, s1_.installation_type AS installation_type_13, s1_.created_at AS created_at_14, s1_.updated_at AS updated_at_15, s1_.deleted_at AS deleted_at_16, s1_.deleted AS deleted_17, s1_.wp_username AS wp_username_18, s1_.app_password AS app_password_19, s1_.basicauth_login AS basicauth_login_20, s1_.basicauth_password AS basicauth_password_21, s1_.language AS language_22, s1_.language_code AS language_code_23, s1_.translation_role AS translation_role_24, s2_.id AS id_25, s2_.url AS url_26, s2_.installation_type AS installation_type_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.deleted_at AS deleted_at_30, s2_.deleted AS deleted_31, s2_.wp_username AS wp_username_32, s2_.app_password AS app_password_33, s2_.basicauth_login AS basicauth_login_34, s2_.basicauth_password AS basicauth_password_35, s2_.language AS language_36, s2_.language_code AS language_code_37, s2_.translation_role AS translation_role_38, t0_.source_site_id AS source_site_id_39, t0_.destination_site_id AS destination_site_id_40, s1_.pole_id AS pole_id_41, s1_.type_id AS type_id_42, s2_.pole_id AS pole_id_43, s2_.type_id AS type_id_44 FROM translation_log t0_ INNER JOIN site s1_ ON t0_.source_site_id = s1_.id INNER JOIN site s2_ ON t0_.destination_site_id = s2_.id WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.id DESC
Parameters:
[
  61
  60
  59
  58
  57
  56
  55
  54
  53
  52
]

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\TranslationLog 10
App\Entity\Site 2
App\Entity\UserUbo 1
App\Entity\Pole 1
App\Entity\Type 1

Entities Mapping

Class Mapping errors
App\Entity\UserUbo No errors.
App\Entity\Site No errors.
App\Entity\TranslationLog No errors.
App\Entity\Pole No errors.
App\Entity\Type No errors.
App\Entity\TranslationLogStep No errors.
App\Entity\UserRoleSite No errors.