Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.12 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.12 ms (100.00%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.slug = ? LIMIT 1 Parameters: [`"robots.txt"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.slug = 'robots.txt' LIMIT 1;

Time▼

Count

Info

0.12 ms
(100.00%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "robots.txt"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.in_footer AS in_footer_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by_id AS created_by_id_8,
  t9.id AS id_10,
  t9.email AS email_11,
  t9.roles AS roles_12,
  t9.description AS description_13,
  t9.avatar AS avatar_14,
  t9.avatar_path AS avatar_path_15,
  t9.first_name AS first_name_16,
  t9.last_name AS last_name_17,
  t9.avatar_file AS avatar_file_18,
  t9.role_description AS role_description_19,
  t9.signing_limit_date AS signing_limit_date_20,
  t9.token_token AS token_token_21,
  t9.token_expire_at AS token_expire_at_22,
  t9.token_refresh_token AS token_refresh_token_23,
  t0.updated_by_id AS updated_by_id_24,
  t25.id AS id_26,
  t25.email AS email_27,
  t25.roles AS roles_28,
  t25.description AS description_29,
  t25.avatar AS avatar_30,
  t25.avatar_path AS avatar_path_31,
  t25.first_name AS first_name_32,
  t25.last_name AS last_name_33,
  t25.avatar_file AS avatar_file_34,
  t25.role_description AS role_description_35,
  t25.signing_limit_date AS signing_limit_date_36,
  t25.token_token AS token_token_37,
  t25.token_expire_at AS token_expire_at_38,
  t25.token_refresh_token AS token_refresh_token_39
FROM
  template_template_page t0
  LEFT JOIN account_users t9 ON t0.created_by_id = t9.id
  LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.slug = 'robots.txt' LIMIT 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.

Entities Mapping

Class	Mapping errors
App\Entity\Channel\SharedChannel	No errors.
App\Entity\Scholar\Lesson\Lesson	No errors.
Nellapp\Bundle\SDKBundle\Channel\Entity\UserFromChannel	No errors.
App\Entity\Template\TemplatePage	No errors.
Nellapp\Bundle\SDKBundle\Auth\Entity\Token	No errors.
App\Entity\Account\User	No errors.
App\Entity\Channel\Channel	No errors.
App\Entity\Scholar\Lesson\OriginLesson	No errors.
App\Entity\Scholar\Lesson\SharedLesson	No errors.
App\Entity\Scholar\Chapter\Chapter	No errors.
App\Entity\Payment\Product	No errors.
App\Entity\Payment\LessonProduct	No errors.
App\Entity\Scholar\Module\ModuleLesson	No errors.
App\Entity\Exercise\Stat	No errors.
App\Entity\Exercise\Exercise	No errors.
App\Entity\Scholar\Lesson\LessonPrerequisite	No errors.
App\Entity\Scholar\PracticalCase\PracticalCase	No errors.
App\Entity\Scholar\Lesson\LessonStats	No errors.
App\Entity\Scholar\ScholarUpdateTracker	No errors.
App\Entity\Account\LogUserData	No errors.
App\Entity\ChannelUserData\ChannelUserData	No errors.
App\Entity\Scholar\Training\Training	No errors.
App\Entity\Scholar\Module\Module	No errors.
App\Entity\Scholar\Indexed\IndexedContent	No errors.
App\Entity\Scholar\Indexed\IndexedContentMetadata	No errors.
App\Entity\Scholar\Lesson\LessonReview	No errors.
App\Entity\Common\File	No errors.
App\Entity\Scholar\ScholarVideo	No errors.
App\Entity\Scholar\Module\OriginModule	No errors.
Nellapp\Bundle\SDKBundle\Permission\Entity\AbstractChannelUserResourcePermission	No errors.
App\Entity\Scholar\Module\ModulePermission	No errors.
App\Entity\Scholar\Module\SharedModule	No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseResource	No errors.
App\Entity\Scholar\PracticalCase\FilePracticalCaseResponse	No errors.
App\Entity\Common\Assignable	No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseUser	No errors.
App\Entity\Scholar\PracticalCase\SharedPracticalCase	No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseResponse	No errors.
App\Entity\Scholar\PracticalCase\OriginPracticalCase	No errors.
App\Entity\Scholar\PracticalCase\FilePracticalCase	No errors.
App\Entity\Scholar\Training\TrainingPermission	No errors.
App\Entity\Scholar\Training\TrainingDescription	No errors.
App\Entity\Scholar\Training\SharedTraining	No errors.
App\Entity\Scholar\Training\TrainingModule	No errors.
App\Entity\Scholar\Chapter\OriginChapter	No errors.
App\Entity\Scholar\Chapter\SharedChapter	No errors.
App\Entity\Account\Notification	No errors.
App\Entity\Account\Advice	No errors.
App\Entity\ChannelUserData\AbstractCursus	No errors.
App\Entity\PartnerApi\PartnerApiUser	No errors.
App\Entity\Channel\ChannelGallery	No errors.
App\Entity\Channel\Image	No errors.
App\Entity\Channel\Partner\Partner	No errors.
App\Entity\Channel\ChannelDescription	No errors.
App\Entity\Channel\ShareContentProgress\AbstractProgress	No errors.
App\Entity\Channel\ShareContentProgress\ModuleUpdateShareContentProgress	No errors.
App\Entity\Channel\ShareContentProgress\TrainingUpdateShareContentProgress	No errors.
App\Entity\Channel\ShareContentProgress\UnShare\AbstractUnShareContentProgress	No errors.
App\Entity\Channel\ShareContentProgress\UnShare\LessonUnShareProgress	No errors.
App\Entity\Channel\ShareContentProgress\UnShare\ModuleUnShareProgress	No errors.
App\Entity\Channel\ShareContentProgress\UnShare\TrainingUnShareProgress	No errors.
App\Entity\Channel\ShareContentProgress\Share\AbstractShareContentProgress	No errors.
App\Entity\Channel\ShareContentProgress\Share\TrainingShareProgress	No errors.
App\Entity\Channel\ShareContentProgress\Share\LessonShareProgress	No errors.
App\Entity\Channel\ShareContentProgress\Share\ModuleShareProgress	No errors.
App\Entity\Channel\ChannelWhiteLabel	No errors.
App\Entity\Common\Address	No errors.
App\Entity\Channel\Institution	No errors.
App\Entity\Channel\Group	No errors.
App\Entity\Channel\Link	No errors.
App\Entity\Forum\AbstractMessage	No errors.
App\Entity\Forum\ChapterMessage	No errors.
App\Entity\Payment\OrderAttempt	No errors.
App\Entity\Payment\TrainingProduct	No errors.
App\Entity\Payment\ModuleProduct	No errors.
App\Entity\Exercise\Question\Question	No errors.
App\Entity\Exercise\Question\MultipleChoiceQuestion	No errors.
App\Entity\Exercise\Question\MultipleChoiceAnswer	No errors.
App\Entity\Exercise\User\ExerciseResult	No errors.
App\Entity\Exercise\User\QuestionResult	No errors.
App\Entity\Exercise\User\MultipleChoiceQuestionResult	No errors.
App\Entity\Exercise\SharedExercise	No errors.
App\Entity\Exercise\OriginExercise	No errors.
App\Entity\Achievement\AchievementTimeLog	No errors.
App\Entity\Achievement\AchievedContent	No errors.
App\Entity\Achievement\AchievementTimeLogLesson	No errors.
App\Entity\Achievement\AchievedChapter	No errors.
App\Entity\Achievement\AchievedTraining	No errors.
App\Entity\Achievement\AchievedModule	No errors.
App\Entity\Achievement\AchievedLesson	No errors.
Nellapp\Bundle\SDKBundle\Entity\AbstractCustomView	No errors.
Nellapp\Bundle\SDKBundle\Channel\Entity\ChannelUserRole	No errors.

Symfony Profiler

https://e-learning.staging.nellapp-01.drosalys.net/robots.txt

Configuration Settings

Theme