Symfony Profiler

Query Metrics

36 Database Queries

14 Different statements

63.18 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

24.61 ms
(38.96%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.error AS error_3, t0.note AS note_4, t0.date_created AS date_created_5, t0.media_type AS media_type_6, t0.media_url AS media_url_7, t0.media_original_name AS media_original_name_8, t0.form_field_id AS form_field_id_9, t0.lang_id AS lang_id_10 FROM forms_fields_i18n t0 WHERE t0.form_field_id = ? AND t0.lang_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.error AS error_3,
  t0.note AS note_4,
  t0.date_created AS date_created_5,
  t0.media_type AS media_type_6,
  t0.media_url AS media_url_7,
  t0.media_original_name AS media_original_name_8,
  t0.form_field_id AS form_field_id_9,
  t0.lang_id AS lang_id_10
FROM
  forms_fields_i18n t0
WHERE
  t0.form_field_id = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.error AS error_3, t0.note AS note_4, t0.date_created AS date_created_5, t0.media_type AS media_type_6, t0.media_url AS media_url_7, t0.media_original_name AS media_original_name_8, t0.form_field_id AS form_field_id_9, t0.lang_id AS lang_id_10 FROM forms_fields_i18n t0 WHERE t0.form_field_id = 1057 AND t0.lang_id = 2 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 1568)
5	App\Controller\ScenesController->getFormsFieldLabel (line 1330)
6	App\Controller\ScenesController->getExcelRoleRootsGroupedByRole (line 665)
7	App\Controller\ScenesController->configExportExcelProject (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 13)

9.14 ms
(14.46%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 71)
5	App\Middleware\ControllerSubscriber->onKernelController (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 13)

5.65 ms
(8.94%)

SELECT f0_.id AS id_0, f0_.meta_key AS meta_key_1, f0_.type AS type_2, f0_.group_key AS group_key_3, f1_.label AS label_4, (s2_.title) AS sclr_5, p3_.title AS title_6 FROM forms_fields f0_ INNER JOIN scenes_roles_forms s4_ ON (s4_.form_field_id = f0_.id) INNER JOIN scenes_roles s2_ ON (s4_.scene_role_id = s2_.id) INNER JOIN scenes s5_ ON (s5_.id = s2_.scene_id) INNER JOIN projects p3_ ON (p3_.id = s5_.project_id) INNER JOIN forms_fields_i18n f1_ ON (f1_.form_field_id = f0_.id) INNER JOIN lang l6_ ON (l6_.id = f1_.lang_id) WHERE p3_.id = ? AND f0_.group_key NOT LIKE '%role.comment%' AND l6_.id = ? AND f0_.meta_key NOT IN ('birthday_check', 'privacy_check') GROUP BY f0_.meta_key ORDER BY f0_.sort ASC

Parameters:

[
  "101"
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.meta_key AS meta_key_1,
  f0_.type AS type_2,
  f0_.group_key AS group_key_3,
  f1_.label AS label_4,
  (s2_.title) AS sclr_5,
  p3_.title AS title_6
FROM
  forms_fields f0_
  INNER JOIN scenes_roles_forms s4_ ON (s4_.form_field_id = f0_.id)
  INNER JOIN scenes_roles s2_ ON (s4_.scene_role_id = s2_.id)
  INNER JOIN scenes s5_ ON (s5_.id = s2_.scene_id)
  INNER JOIN projects p3_ ON (p3_.id = s5_.project_id)
  INNER JOIN forms_fields_i18n f1_ ON (f1_.form_field_id = f0_.id)
  INNER JOIN lang l6_ ON (l6_.id = f1_.lang_id)
WHERE
  p3_.id = ?
  AND f0_.group_key NOT LIKE '%role.comment%'
  AND l6_.id = ?
  AND f0_.meta_key NOT IN (
    'birthday_check', 'privacy_check'
  )
GROUP BY
  f0_.meta_key
ORDER BY
  f0_.sort ASC

SELECT f0_.id AS id_0, f0_.meta_key AS meta_key_1, f0_.type AS type_2, f0_.group_key AS group_key_3, f1_.label AS label_4, (s2_.title) AS sclr_5, p3_.title AS title_6 FROM forms_fields f0_ INNER JOIN scenes_roles_forms s4_ ON (s4_.form_field_id = f0_.id) INNER JOIN scenes_roles s2_ ON (s4_.scene_role_id = s2_.id) INNER JOIN scenes s5_ ON (s5_.id = s2_.scene_id) INNER JOIN projects p3_ ON (p3_.id = s5_.project_id) INNER JOIN forms_fields_i18n f1_ ON (f1_.form_field_id = f0_.id) INNER JOIN lang l6_ ON (l6_.id = f1_.lang_id) WHERE p3_.id = '101' AND f0_.group_key NOT LIKE '%role.comment%' AND l6_.id = 2 AND f0_.meta_key NOT IN ('birthday_check', 'privacy_check') GROUP BY f0_.meta_key ORDER BY f0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 237)
7	App\Repository\FormsFieldsRepository->getProjectBaseMetaKeys (line 440)
8	App\Services\ProjectsService->excelConfigMetakeys (line 621)
9	App\Controller\ScenesController->configExportExcelProject (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 13)

5.63 ms
(8.91%)

SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.type AS type_3, t0.title AS title_4, t0.date_created AS date_created_5, t0.sendType AS sendType_6, t0.status AS status_7, t0.action AS action_8, t0.from_user_id AS from_user_id_9, t0.to_user_id AS to_user_id_10 FROM notifications t0 WHERE t0.status = ? AND t0.to_user_id = ? AND t0.type = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.relation_id AS relation_id_2,
  t0.type AS type_3,
  t0.title AS title_4,
  t0.date_created AS date_created_5,
  t0.sendType AS sendType_6,
  t0.status AS status_7,
  t0.action AS action_8,
  t0.from_user_id AS from_user_id_9,
  t0.to_user_id AS to_user_id_10
FROM
  notifications t0
WHERE
  t0.status = ?
  AND t0.to_user_id = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.type AS type_3, t0.title AS title_4, t0.date_created AS date_created_5, t0.sendType AS sendType_6, t0.status AS status_7, t0.action AS action_8, t0.from_user_id AS from_user_id_9, t0.to_user_id AS to_user_id_10 FROM notifications t0 WHERE t0.status = 0 AND t0.to_user_id = 1032 AND t0.type = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 20)
5	App\Services\NotificationsService->getUnreadNotificationCount (line 48)
6	App\Middleware\NotificationSubscriber->onKernelController (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 13)

5.04 ms
(7.98%)

SELECT 
            p.`title` AS projectTitle,
            s.`name` AS sceneTitle,
            sr.`title` AS roleTitle,
            u.`email`,
            u.`id` AS userId,
            usrfs.`status`
            ,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'name' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'name' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'name' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS name,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'surname' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'surname' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'surname' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS surname,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'birthday' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'birthday' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'birthday' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS birthday,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'playerage' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'playerage' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'playerage' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS playerage,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'gender' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'gender' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'gender' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS gender,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'appearance' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'appearance' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'appearance' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS appearance,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'country' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'country' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'country' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS country,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'city' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'city' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'city' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS city,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'language' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'language' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'language' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS language,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'agency' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'agency' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'agency' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS agency,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS agency_commercial,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS agency_fashion,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'height' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'height' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'height' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS height,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'shirt' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'shirt' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'shirt' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS shirt,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'pants' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'pants' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'pants' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS pants,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'shoe' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'shoe' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'shoe' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS shoe,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'instagram' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'instagram' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'instagram' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS instagram,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS profile_photo,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS full_body_photo,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Text_Drama_Experience,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Radio_Button,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Radio_Button_Drive_License,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Textarea_Respuesta_infinita,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Date_Expiraci_n_DNI,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Number_Meses_beb_,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Select_Ok_raparte,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Image_Tattoos,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Select_Competitor,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Tipo_de_pelo,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_rq_root_529cf14b7f8228_1775655889630,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_273_Text_Drama_Experience,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_273_Textarea_Respuesta_infinita,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_274_Text_Drama_Experience,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_275_Radio_Button,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_277_Checkbox_Test_10,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_278_Textarea_Respuesta_infinita,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_279_Date_Expiraci_n_DNI,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_280_Number_Meses_beb_,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_281_Select_Ok_raparte,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_282_Image_Tattoos,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_283_rq_root_2f287c0af3e7f8_1776765693389,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_284_Radio_Competitors_TEST,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS birthday_check
        FROM 
            users_scenes_roles_forms_status usrfs
        INNER JOIN 
            users_scenes_roles_forms usrf ON usrf.id = usrfs.user_scene_role_form_id
        INNER JOIN 
            scenes_roles sr ON sr.id = usrf.scene_role_id
        INNER JOIN 
            scenes s ON s.id = sr.scene_id
        INNER JOIN 
            projects p ON p.id = s.project_id
        INNER JOIN 
            users_forms_fields uff ON usrf.user_id = uff.user_id 
        INNER JOIN (
            SELECT 
                ff.id AS form_field_id, 
                ff.meta_key, 
                uff.user_id, 
                uff.value
            FROM 
                forms_fields ff
            INNER JOIN 
                users_forms_fields uff ON ff.id = uff.form_field_id
            WHERE 
                ff.meta_key IN ('name','surname','birthday','playerage','gender','appearance','country','city','language','agency','agency_commercial','agency_fashion','height','shirt','pants','shoe','instagram','profile_photo','full_body_photo','rq_272_Text_Drama_Experience','rq_272_Radio_Button','rq_272_Radio_Button_Drive_License','rq_272_Textarea_Respuesta_infinita','rq_272_Date_Expiraci_n_DNI','rq_272_Number_Meses_beb_','rq_272_Select_Ok_raparte','rq_272_Image_Tattoos','rq_272_Select_Competitor','rq_272_Tipo_de_pelo','rq_272_rq_root_529cf14b7f8228_1775655889630','rq_273_Text_Drama_Experience','rq_273_Textarea_Respuesta_infinita','rq_274_Text_Drama_Experience','rq_275_Radio_Button','rq_277_Checkbox_Test_10','rq_278_Textarea_Respuesta_infinita','rq_279_Date_Expiraci_n_DNI','rq_280_Number_Meses_beb_','rq_281_Select_Ok_raparte','rq_282_Image_Tattoos','rq_283_rq_root_2f287c0af3e7f8_1776765693389','rq_284_Radio_Competitors_TEST','birthday_check') 
            GROUP BY 
                ff.id, ff.meta_key, uff.user_id, uff.value
        ) AS meta ON meta.form_field_id = uff.form_field_id AND meta.user_id = uff.user_id
        INNER JOIN 
            users u ON u.id = usrf.user_id 
        WHERE 
            p.id = 101  
             AND usrfs.status = 1 AND usrfs.`level` = 4
        GROUP BY 
            usrfs.user_scene_role_form_id;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.`title` AS projectTitle,
  s.`name` AS sceneTitle,
  sr.`title` AS roleTitle,
  u.`email`,
  u.`id` AS userId,
  usrfs.`status`,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'name' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'name' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'name' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS name,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'surname' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'surname' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'surname' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS surname,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'birthday' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'birthday' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'birthday' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS birthday,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'playerage' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'playerage' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'playerage' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS playerage,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'gender' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'gender' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'gender' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS gender,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'appearance' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'appearance' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'appearance' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS appearance,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'country' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'country' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'country' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS country,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'city' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'city' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'city' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS city,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'language' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'language' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'language' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS language,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'agency' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'agency' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'agency' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS agency,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS agency_commercial,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS agency_fashion,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'height' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'height' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'height' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS height,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'shirt' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'shirt' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'shirt' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS shirt,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'pants' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'pants' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'pants' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS pants,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'shoe' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'shoe' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'shoe' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS shoe,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'instagram' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'instagram' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'instagram' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS instagram,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS profile_photo,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS full_body_photo,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Text_Drama_Experience,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Radio_Button,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Radio_Button_Drive_License,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Textarea_Respuesta_infinita,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Date_Expiraci_n_DNI,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Number_Meses_beb_,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Select_Ok_raparte,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Image_Tattoos,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Select_Competitor,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_Tipo_de_pelo,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_272_rq_root_529cf14b7f8228_1775655889630,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_273_Text_Drama_Experience,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_273_Textarea_Respuesta_infinita,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_274_Text_Drama_Experience,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_275_Radio_Button,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_277_Checkbox_Test_10,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_278_Textarea_Respuesta_infinita,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_279_Date_Expiraci_n_DNI,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_280_Number_Meses_beb_,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_281_Select_Ok_raparte,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_282_Image_Tattoos,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_283_rq_root_2f287c0af3e7f8_1776765693389,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS rq_284_Radio_Competitors_TEST,
  CASE WHEN COUNT(
    CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END
  ) = 1 THEN MAX(
    CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END
  ) ELSE GROUP_CONCAT(
    DISTINCT CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END
    ORDER BY
      meta.value SEPARATOR ', '
  ) END AS birthday_check
FROM
  users_scenes_roles_forms_status usrfs
  INNER JOIN users_scenes_roles_forms usrf ON usrf.id = usrfs.user_scene_role_form_id
  INNER JOIN scenes_roles sr ON sr.id = usrf.scene_role_id
  INNER JOIN scenes s ON s.id = sr.scene_id
  INNER JOIN projects p ON p.id = s.project_id
  INNER JOIN users_forms_fields uff ON usrf.user_id = uff.user_id
  INNER JOIN (
    SELECT
      ff.id AS form_field_id,
      ff.meta_key,
      uff.user_id,
      uff.value
    FROM
      forms_fields ff
      INNER JOIN users_forms_fields uff ON ff.id = uff.form_field_id
    WHERE
      ff.meta_key IN (
        'name', 'surname', 'birthday', 'playerage',
        'gender', 'appearance', 'country',
        'city', 'language', 'agency', 'agency_commercial',
        'agency_fashion', 'height', 'shirt',
        'pants', 'shoe', 'instagram', 'profile_photo',
        'full_body_photo', 'rq_272_Text_Drama_Experience',
        'rq_272_Radio_Button', 'rq_272_Radio_Button_Drive_License',
        'rq_272_Textarea_Respuesta_infinita',
        'rq_272_Date_Expiraci_n_DNI', 'rq_272_Number_Meses_beb_',
        'rq_272_Select_Ok_raparte', 'rq_272_Image_Tattoos',
        'rq_272_Select_Competitor', 'rq_272_Tipo_de_pelo',
        'rq_272_rq_root_529cf14b7f8228_1775655889630',
        'rq_273_Text_Drama_Experience',
        'rq_273_Textarea_Respuesta_infinita',
        'rq_274_Text_Drama_Experience',
        'rq_275_Radio_Button', 'rq_277_Checkbox_Test_10',
        'rq_278_Textarea_Respuesta_infinita',
        'rq_279_Date_Expiraci_n_DNI', 'rq_280_Number_Meses_beb_',
        'rq_281_Select_Ok_raparte', 'rq_282_Image_Tattoos',
        'rq_283_rq_root_2f287c0af3e7f8_1776765693389',
        'rq_284_Radio_Competitors_TEST',
        'birthday_check'
      )
    GROUP BY
      ff.id,
      ff.meta_key,
      uff.user_id,
      uff.value
  ) AS meta ON meta.form_field_id = uff.form_field_id
  AND meta.user_id = uff.user_id
  INNER JOIN users u ON u.id = usrf.user_id
WHERE
  p.id = 101
  AND usrfs.status = 1
  AND usrfs.`level` = 4
GROUP BY
  usrfs.user_scene_role_form_id;

SELECT 
            p.`title` AS projectTitle,
            s.`name` AS sceneTitle,
            sr.`title` AS roleTitle,
            u.`email`,
            u.`id` AS userId,
            usrfs.`status`
            ,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'name' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'name' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'name' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS name,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'surname' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'surname' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'surname' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS surname,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'birthday' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'birthday' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'birthday' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS birthday,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'playerage' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'playerage' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'playerage' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS playerage,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'gender' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'gender' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'gender' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS gender,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'appearance' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'appearance' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'appearance' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS appearance,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'country' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'country' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'country' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS country,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'city' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'city' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'city' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS city,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'language' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'language' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'language' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS language,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'agency' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'agency' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'agency' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS agency,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'agency_commercial' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS agency_commercial,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'agency_fashion' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS agency_fashion,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'height' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'height' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'height' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS height,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'shirt' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'shirt' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'shirt' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS shirt,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'pants' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'pants' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'pants' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS pants,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'shoe' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'shoe' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'shoe' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS shoe,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'instagram' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'instagram' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'instagram' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS instagram,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'profile_photo' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS profile_photo,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'full_body_photo' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS full_body_photo,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Text_Drama_Experience' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Text_Drama_Experience,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Radio_Button' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Radio_Button,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Radio_Button_Drive_License' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Radio_Button_Drive_License,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Textarea_Respuesta_infinita' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Textarea_Respuesta_infinita,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Date_Expiraci_n_DNI' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Date_Expiraci_n_DNI,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Number_Meses_beb_' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Number_Meses_beb_,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Select_Ok_raparte' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Select_Ok_raparte,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Image_Tattoos' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Image_Tattoos,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Select_Competitor' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Select_Competitor,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_Tipo_de_pelo' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_Tipo_de_pelo,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_272_rq_root_529cf14b7f8228_1775655889630' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_272_rq_root_529cf14b7f8228_1775655889630,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_273_Text_Drama_Experience' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_273_Text_Drama_Experience,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_273_Textarea_Respuesta_infinita' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_273_Textarea_Respuesta_infinita,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_274_Text_Drama_Experience' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_274_Text_Drama_Experience,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_275_Radio_Button' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_275_Radio_Button,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_277_Checkbox_Test_10' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_277_Checkbox_Test_10,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_278_Textarea_Respuesta_infinita' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_278_Textarea_Respuesta_infinita,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_279_Date_Expiraci_n_DNI' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_279_Date_Expiraci_n_DNI,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_280_Number_Meses_beb_' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_280_Number_Meses_beb_,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_281_Select_Ok_raparte' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_281_Select_Ok_raparte,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_282_Image_Tattoos' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_282_Image_Tattoos,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_283_rq_root_2f287c0af3e7f8_1776765693389' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_283_rq_root_2f287c0af3e7f8_1776765693389,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'rq_284_Radio_Competitors_TEST' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS rq_284_Radio_Competitors_TEST,  CASE WHEN COUNT(CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END) = 1 THEN MAX(CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END) ELSE GROUP_CONCAT(DISTINCT CASE WHEN meta.meta_key = 'birthday_check' THEN meta.value END ORDER BY meta.value SEPARATOR ', ') END AS birthday_check
        FROM 
            users_scenes_roles_forms_status usrfs
        INNER JOIN 
            users_scenes_roles_forms usrf ON usrf.id = usrfs.user_scene_role_form_id
        INNER JOIN 
            scenes_roles sr ON sr.id = usrf.scene_role_id
        INNER JOIN 
            scenes s ON s.id = sr.scene_id
        INNER JOIN 
            projects p ON p.id = s.project_id
        INNER JOIN 
            users_forms_fields uff ON usrf.user_id = uff.user_id 
        INNER JOIN (
            SELECT 
                ff.id AS form_field_id, 
                ff.meta_key, 
                uff.user_id, 
                uff.value
            FROM 
                forms_fields ff
            INNER JOIN 
                users_forms_fields uff ON ff.id = uff.form_field_id
            WHERE 
                ff.meta_key IN ('name','surname','birthday','playerage','gender','appearance','country','city','language','agency','agency_commercial','agency_fashion','height','shirt','pants','shoe','instagram','profile_photo','full_body_photo','rq_272_Text_Drama_Experience','rq_272_Radio_Button','rq_272_Radio_Button_Drive_License','rq_272_Textarea_Respuesta_infinita','rq_272_Date_Expiraci_n_DNI','rq_272_Number_Meses_beb_','rq_272_Select_Ok_raparte','rq_272_Image_Tattoos','rq_272_Select_Competitor','rq_272_Tipo_de_pelo','rq_272_rq_root_529cf14b7f8228_1775655889630','rq_273_Text_Drama_Experience','rq_273_Textarea_Respuesta_infinita','rq_274_Text_Drama_Experience','rq_275_Radio_Button','rq_277_Checkbox_Test_10','rq_278_Textarea_Respuesta_infinita','rq_279_Date_Expiraci_n_DNI','rq_280_Number_Meses_beb_','rq_281_Select_Ok_raparte','rq_282_Image_Tattoos','rq_283_rq_root_2f287c0af3e7f8_1776765693389','rq_284_Radio_Competitors_TEST','birthday_check') 
            GROUP BY 
                ff.id, ff.meta_key, uff.user_id, uff.value
        ) AS meta ON meta.form_field_id = uff.form_field_id AND meta.user_id = uff.user_id
        INNER JOIN 
            users u ON u.id = usrf.user_id 
        WHERE 
            p.id = 101  
             AND usrfs.status = 1 AND usrfs.`level` = 4
        GROUP BY 
            usrfs.user_scene_role_form_id;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 239)
2	App\Repository\UsersScenesRolesFormsStatusRepository->getLastSelection (line 2166)
3	App\Services\TalentsService->getLastSelection (line 2182)
4	App\Services\TalentsService->exportFinalTalents (line 574)
5	App\Controller\ScenesController->configExportExcelProject (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 13)

3.83 ms
(6.07%)

SELECT s0_.id AS id_0, s0_.required AS required_1, s0_.example_file AS example_file_2, s0_.date_created AS date_created_3, s0_.hash AS hash_4, s0_.status AS status_5, s0_.sort AS sort_6, s1_.id AS id_7, s1_.title AS title_8, s1_.description AS description_9, s1_.status AS status_10, s1_.image_reference_file AS image_reference_file_11, s1_.image_reference_original_name AS image_reference_original_name_12, s1_.date_created AS date_created_13, s2_.id AS id_14, s2_.name AS name_15, s2_.date_created AS date_created_16, p3_.id AS id_17, p3_.title AS title_18, p3_.hash AS hash_19, p3_.subtitle AS subtitle_20, p3_.logo_brand AS logo_brand_21, p3_.logo_production AS logo_production_22, p3_.date_created AS date_created_23, p3_.status AS status_24, p3_.grid AS grid_25, p3_.grid_viewer AS grid_viewer_26, p3_.image_compression AS image_compression_27, p3_.video_compression AS video_compression_28, p3_.reference_file_1 AS reference_file_1_29, p3_.reference_file_2 AS reference_file_2_30, f4_.id AS id_31, f4_.meta_key AS meta_key_32, f4_.size_col AS size_col_33, f4_.type AS type_34, f4_.sort AS sort_35, f4_.group_key AS group_key_36, f4_.searchable AS searchable_37, f4_.date_created AS date_created_38, f4_.default_checked AS default_checked_39, f4_.keyword AS keyword_40, f4_.reference AS reference_41, f4_.allow_note AS allow_note_42, f4_.allow_media AS allow_media_43, f4_.media_types AS media_types_44, s0_.scene_role_id AS scene_role_id_45, s0_.form_field_id AS form_field_id_46, s0_.parent_option_id AS parent_option_id_47, s1_.scene_id AS scene_id_48, s2_.project_id AS project_id_49, p3_.headquarter_id AS headquarter_id_50, p3_.project_type_id AS project_type_id_51, f4_.generic_question_id AS generic_question_id_52 FROM scenes_roles_forms s0_ INNER JOIN scenes_roles s1_ ON s0_.scene_role_id = s1_.id INNER JOIN scenes s2_ ON s1_.scene_id = s2_.id INNER JOIN projects p3_ ON s2_.project_id = p3_.id INNER JOIN forms_fields f4_ ON s0_.form_field_id = f4_.id WHERE p3_.id = ? AND s0_.status = 1 AND s0_.parent_option_id IS NULL AND f4_.group_key IN (?, ?) AND f4_.group_key <> ? AND f4_.type <> ? ORDER BY s1_.id ASC, s0_.sort ASC

Parameters:

[
  101
  "form.group.role"
  "form.group.media.role"
  "form.group.role.comment"
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.required AS required_1,
  s0_.example_file AS example_file_2,
  s0_.date_created AS date_created_3,
  s0_.hash AS hash_4,
  s0_.status AS status_5,
  s0_.sort AS sort_6,
  s1_.id AS id_7,
  s1_.title AS title_8,
  s1_.description AS description_9,
  s1_.status AS status_10,
  s1_.image_reference_file AS image_reference_file_11,
  s1_.image_reference_original_name AS image_reference_original_name_12,
  s1_.date_created AS date_created_13,
  s2_.id AS id_14,
  s2_.name AS name_15,
  s2_.date_created AS date_created_16,
  p3_.id AS id_17,
  p3_.title AS title_18,
  p3_.hash AS hash_19,
  p3_.subtitle AS subtitle_20,
  p3_.logo_brand AS logo_brand_21,
  p3_.logo_production AS logo_production_22,
  p3_.date_created AS date_created_23,
  p3_.status AS status_24,
  p3_.grid AS grid_25,
  p3_.grid_viewer AS grid_viewer_26,
  p3_.image_compression AS image_compression_27,
  p3_.video_compression AS video_compression_28,
  p3_.reference_file_1 AS reference_file_1_29,
  p3_.reference_file_2 AS reference_file_2_30,
  f4_.id AS id_31,
  f4_.meta_key AS meta_key_32,
  f4_.size_col AS size_col_33,
  f4_.type AS type_34,
  f4_.sort AS sort_35,
  f4_.group_key AS group_key_36,
  f4_.searchable AS searchable_37,
  f4_.date_created AS date_created_38,
  f4_.default_checked AS default_checked_39,
  f4_.keyword AS keyword_40,
  f4_.reference AS reference_41,
  f4_.allow_note AS allow_note_42,
  f4_.allow_media AS allow_media_43,
  f4_.media_types AS media_types_44,
  s0_.scene_role_id AS scene_role_id_45,
  s0_.form_field_id AS form_field_id_46,
  s0_.parent_option_id AS parent_option_id_47,
  s1_.scene_id AS scene_id_48,
  s2_.project_id AS project_id_49,
  p3_.headquarter_id AS headquarter_id_50,
  p3_.project_type_id AS project_type_id_51,
  f4_.generic_question_id AS generic_question_id_52
FROM
  scenes_roles_forms s0_
  INNER JOIN scenes_roles s1_ ON s0_.scene_role_id = s1_.id
  INNER JOIN scenes s2_ ON s1_.scene_id = s2_.id
  INNER JOIN projects p3_ ON s2_.project_id = p3_.id
  INNER JOIN forms_fields f4_ ON s0_.form_field_id = f4_.id
WHERE
  p3_.id = ?
  AND s0_.status = 1
  AND s0_.parent_option_id IS NULL
  AND f4_.group_key IN (?, ?)
  AND f4_.group_key <> ?
  AND f4_.type <> ?
ORDER BY
  s1_.id ASC,
  s0_.sort ASC

SELECT s0_.id AS id_0, s0_.required AS required_1, s0_.example_file AS example_file_2, s0_.date_created AS date_created_3, s0_.hash AS hash_4, s0_.status AS status_5, s0_.sort AS sort_6, s1_.id AS id_7, s1_.title AS title_8, s1_.description AS description_9, s1_.status AS status_10, s1_.image_reference_file AS image_reference_file_11, s1_.image_reference_original_name AS image_reference_original_name_12, s1_.date_created AS date_created_13, s2_.id AS id_14, s2_.name AS name_15, s2_.date_created AS date_created_16, p3_.id AS id_17, p3_.title AS title_18, p3_.hash AS hash_19, p3_.subtitle AS subtitle_20, p3_.logo_brand AS logo_brand_21, p3_.logo_production AS logo_production_22, p3_.date_created AS date_created_23, p3_.status AS status_24, p3_.grid AS grid_25, p3_.grid_viewer AS grid_viewer_26, p3_.image_compression AS image_compression_27, p3_.video_compression AS video_compression_28, p3_.reference_file_1 AS reference_file_1_29, p3_.reference_file_2 AS reference_file_2_30, f4_.id AS id_31, f4_.meta_key AS meta_key_32, f4_.size_col AS size_col_33, f4_.type AS type_34, f4_.sort AS sort_35, f4_.group_key AS group_key_36, f4_.searchable AS searchable_37, f4_.date_created AS date_created_38, f4_.default_checked AS default_checked_39, f4_.keyword AS keyword_40, f4_.reference AS reference_41, f4_.allow_note AS allow_note_42, f4_.allow_media AS allow_media_43, f4_.media_types AS media_types_44, s0_.scene_role_id AS scene_role_id_45, s0_.form_field_id AS form_field_id_46, s0_.parent_option_id AS parent_option_id_47, s1_.scene_id AS scene_id_48, s2_.project_id AS project_id_49, p3_.headquarter_id AS headquarter_id_50, p3_.project_type_id AS project_type_id_51, f4_.generic_question_id AS generic_question_id_52 FROM scenes_roles_forms s0_ INNER JOIN scenes_roles s1_ ON s0_.scene_role_id = s1_.id INNER JOIN scenes s2_ ON s1_.scene_id = s2_.id INNER JOIN projects p3_ ON s2_.project_id = p3_.id INNER JOIN forms_fields f4_ ON s0_.form_field_id = f4_.id WHERE p3_.id = 101 AND s0_.status = 1 AND s0_.parent_option_id IS NULL AND f4_.group_key IN ('form.group.role', 'form.group.media.role') AND f4_.group_key <> 'form.group.role.comment' AND f4_.type <> 8 ORDER BY s1_.id ASC, s0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 1314)
7	App\Controller\ScenesController->getExcelRoleRootsGroupedByRole (line 665)
8	App\Controller\ScenesController->configExportExcelProject (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 13)

1.73 ms
(2.74%)

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.roles AS roles_3, t0.email AS email_4, t0.password AS password_5, t0.name AS name_6, t0.date_created AS date_created_7, t0.status AS status_8, t0.forgot_code AS forgot_code_9, t0.forgot_date_expires AS forgot_date_expires_10, t0.lang_id AS lang_id_11, t0.selected_headquarter AS selected_headquarter_12 FROM users t0 WHERE t0.id = ?

Parameters:

[
  1032
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.roles AS roles_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.date_created AS date_created_7,
  t0.status AS status_8,
  t0.forgot_code AS forgot_code_9,
  t0.forgot_date_expires AS forgot_date_expires_10,
  t0.lang_id AS lang_id_11,
  t0.selected_headquarter AS selected_headquarter_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.roles AS roles_3, t0.email AS email_4, t0.password AS password_5, t0.name AS name_6, t0.date_created AS date_created_7, t0.status AS status_8, t0.forgot_code AS forgot_code_9, t0.forgot_date_expires AS forgot_date_expires_10, t0.lang_id AS lang_id_11, t0.selected_headquarter AS selected_headquarter_12 FROM users t0 WHERE t0.id = 1032;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 347)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 49)
15	App\Middleware\ControllerSubscriber->onKernelController (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 13)

1.44 ms
(2.27%)

SELECT e0_.id AS id_0, e0_.meta_key AS meta_key_1, e0_.role_level AS role_level_2, e0_.date_created AS date_created_3, e0_.project_id AS project_id_4, e0_.config_saved_by AS config_saved_by_5 FROM excel_config e0_ INNER JOIN projects p1_ ON (p1_.id = e0_.project_id) WHERE p1_.id = ? AND e0_.role_level >= ?

Parameters:

[
  "101"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.meta_key AS meta_key_1,
  e0_.role_level AS role_level_2,
  e0_.date_created AS date_created_3,
  e0_.project_id AS project_id_4,
  e0_.config_saved_by AS config_saved_by_5
FROM
  excel_config e0_
  INNER JOIN projects p1_ ON (p1_.id = e0_.project_id)
WHERE
  p1_.id = ?
  AND e0_.role_level >= ?

SELECT e0_.id AS id_0, e0_.meta_key AS meta_key_1, e0_.role_level AS role_level_2, e0_.date_created AS date_created_3, e0_.project_id AS project_id_4, e0_.config_saved_by AS config_saved_by_5 FROM excel_config e0_ INNER JOIN projects p1_ ON (p1_.id = e0_.project_id) WHERE p1_.id = '101' AND e0_.role_level >= 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 26)
7	App\Repository\ExcelConfigRepository->getExcelValues (line 588)
8	App\Services\ProjectsService->getConfigExcelValues (line 568)
9	App\Controller\ScenesController->configExportExcelProject (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 13)

1.16 ms
(1.84%)

SELECT t0.id AS id_1, t0.last_interaction_date AS last_interaction_date_2, t0.user_id AS user_id_3, t0.project_id AS project_id_4 FROM user_recent_projects_interactions t0 WHERE t0.user_id = ? AND t0.project_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_interaction_date AS last_interaction_date_2,
  t0.user_id AS user_id_3,
  t0.project_id AS project_id_4
FROM
  user_recent_projects_interactions t0
WHERE
  t0.user_id = ?
  AND t0.project_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_interaction_date AS last_interaction_date_2, t0.user_id AS user_id_3, t0.project_id AS project_id_4 FROM user_recent_projects_interactions t0 WHERE t0.user_id = 1032 AND t0.project_id = 101 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 55)
5	App\Middleware\ControllerSubscriber->onKernelController (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 13)

1.11 ms
(1.76%)

SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.date_created AS date_created_4 FROM config t0 WHERE t0.meta_key = ? LIMIT 1

Parameters:

[
  "roles"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.meta_key AS meta_key_2,
  t0.meta_value AS meta_value_3,
  t0.date_created AS date_created_4
FROM
  config t0
WHERE
  t0.meta_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.date_created AS date_created_4 FROM config t0 WHERE t0.meta_key = 'roles' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 179)
5	App\Services\UsersService->getRolesLevels (line 619)
6	App\Controller\ScenesController->configExportExcelProject (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 13)

1.10 ms
(1.75%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.hash AS hash_3, t0.subtitle AS subtitle_4, t0.logo_brand AS logo_brand_5, t0.logo_production AS logo_production_6, t0.date_created AS date_created_7, t0.status AS status_8, t0.grid AS grid_9, t0.grid_viewer AS grid_viewer_10, t0.image_compression AS image_compression_11, t0.video_compression AS video_compression_12, t0.reference_file_1 AS reference_file_1_13, t0.reference_file_2 AS reference_file_2_14, t0.headquarter_id AS headquarter_id_15, t0.project_type_id AS project_type_id_16 FROM projects t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "101"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.hash AS hash_3,
  t0.subtitle AS subtitle_4,
  t0.logo_brand AS logo_brand_5,
  t0.logo_production AS logo_production_6,
  t0.date_created AS date_created_7,
  t0.status AS status_8,
  t0.grid AS grid_9,
  t0.grid_viewer AS grid_viewer_10,
  t0.image_compression AS image_compression_11,
  t0.video_compression AS video_compression_12,
  t0.reference_file_1 AS reference_file_1_13,
  t0.reference_file_2 AS reference_file_2_14,
  t0.headquarter_id AS headquarter_id_15,
  t0.project_type_id AS project_type_id_16
FROM
  projects t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.hash AS hash_3, t0.subtitle AS subtitle_4, t0.logo_brand AS logo_brand_5, t0.logo_production AS logo_production_6, t0.date_created AS date_created_7, t0.status AS status_8, t0.grid AS grid_9, t0.grid_viewer AS grid_viewer_10, t0.image_compression AS image_compression_11, t0.video_compression AS video_compression_12, t0.reference_file_1 AS reference_file_1_13, t0.reference_file_2 AS reference_file_2_14, t0.headquarter_id AS headquarter_id_15, t0.project_type_id AS project_type_id_16 FROM projects t0 WHERE t0.id = '101' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	App\Middleware\ControllerSubscriber->onKernelController (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 13)

1.04 ms
(1.64%)

UPDATE user_recent_projects_interactions SET last_interaction_date = ? WHERE id = ?

Parameters:

[
  "2026-04-21 14:45:21"
  302
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user_recent_projects_interactions
SET
  last_interaction_date = ?
WHERE
  id = ?

UPDATE user_recent_projects_interactions SET last_interaction_date = '2026-04-21 14:45:21' WHERE id = 302;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 71)
7	App\Middleware\ControllerSubscriber->onKernelController (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 13)

0.87 ms
(1.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.default_lang AS default_lang_4 FROM lang t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.default_lang AS default_lang_4
FROM
  lang t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.default_lang AS default_lang_4 FROM lang t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\Lang->__get (line 46)
7	App\Entity\Lang->getCode (line 671)
8	App\Controller\ScenesController->configExportExcelProject (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 13)

0.82 ms
(1.30%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 71)
4	App\Middleware\ControllerSubscriber->onKernelController (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 13)

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\UserRecentProjectsInteractions	No errors.
App\Entity\Projects	No errors.
App\Entity\Users	No errors.
App\Entity\Lang	No errors.
App\Entity\Headquarters	No errors.
App\Entity\ProjectsTypes	No errors.
App\Entity\Notifications	No errors.
App\Entity\ExcelConfig	No errors.
App\Entity\UsersScenesRolesFormsStatus	No errors.
App\Entity\Config	No errors.
App\Entity\FormsFields	No errors.
App\Entity\ScenesRolesForms	No errors.
App\Entity\ScenesRoles	No errors.
App\Entity\Scenes	No errors.
App\Entity\FormsFieldsI18n	No errors.
App\Entity\FormsFieldsOptions	No errors.
App\Entity\GenericQuestion	No errors.

Symfony Profiler

GET https://lane.tridenia.es/scenes/ES/101/excel

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping