Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

8.37 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

8.37 ms

SELECT v0_.id AS id_0, v0_.uuid AS uuid_1, v0_.name AS name_2, v0_.description AS description_3, v0_.image AS image_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.deleted_at AS deleted_at_7, v0_.is_active AS is_active_8, v1_.id AS id_9, v1_.name AS name_10, v1_.created_at AS created_at_11, v1_.updated_at AS updated_at_12, v1_.deleted_at AS deleted_at_13, v1_.is_active AS is_active_14, c2_.id AS id_15, c2_.name AS name_16, c2_.created_at AS created_at_17, c2_.updated_at AS updated_at_18, c2_.deleted_at AS deleted_at_19, c2_.is_active AS is_active_20, c3_.id AS id_21, c3_.name AS name_22, c3_.created_at AS created_at_23, c3_.updated_at AS updated_at_24, c3_.deleted_at AS deleted_at_25, c3_.is_active AS is_active_26, c4_.id AS id_27, c4_.name AS name_28, c4_.created_at AS created_at_29, c4_.updated_at AS updated_at_30, c4_.deleted_at AS deleted_at_31, c4_.is_active AS is_active_32, s5_.id AS id_33, s5_.name AS name_34, s5_.created_at AS created_at_35, s5_.updated_at AS updated_at_36, s5_.deleted_at AS deleted_at_37, s5_.is_active AS is_active_38, c6_.id AS id_39, c6_.name AS name_40, c6_.created_at AS created_at_41, c6_.updated_at AS updated_at_42, c6_.deleted_at AS deleted_at_43, c6_.is_active AS is_active_44, f7_.id AS id_45, f7_.name AS name_46, f7_.created_at AS created_at_47, f7_.updated_at AS updated_at_48, f7_.deleted_at AS deleted_at_49, f7_.is_active AS is_active_50, p8_.id AS id_51, p8_.name AS name_52, p8_.created_at AS created_at_53, p8_.updated_at AS updated_at_54, p8_.deleted_at AS deleted_at_55, p8_.is_active AS is_active_56, t9_.id AS id_57, t9_.name AS name_58, t9_.created_at AS created_at_59, t9_.updated_at AS updated_at_60, t9_.deleted_at AS deleted_at_61, t9_.is_active AS is_active_62, c10_.id AS id_63, c10_.name AS name_64, c10_.created_at AS created_at_65, c10_.updated_at AS updated_at_66, c10_.deleted_at AS deleted_at_67, c10_.is_active AS is_active_68, m11_.id AS id_69, m11_.name AS name_70, m11_.created_at AS created_at_71, m11_.updated_at AS updated_at_72, m11_.deleted_at AS deleted_at_73, m11_.is_active AS is_active_74, s12_.id AS id_75, s12_.name AS name_76, s12_.created_at AS created_at_77, s12_.updated_at AS updated_at_78, s12_.deleted_at AS deleted_at_79, s12_.is_active AS is_active_80, g13_.id AS id_81, g13_.name AS name_82, g13_.created_at AS created_at_83, g13_.updated_at AS updated_at_84, g13_.deleted_at AS deleted_at_85, g13_.is_active AS is_active_86, t14_.id AS id_87, t14_.name AS name_88, t14_.created_at AS created_at_89, t14_.updated_at AS updated_at_90, t14_.deleted_at AS deleted_at_91, t14_.is_active AS is_active_92 FROM visual v0_ LEFT JOIN visual_type v1_ ON v0_.visual_type_id = v1_.id LEFT JOIN category c2_ ON v0_.category_id = c2_.id LEFT JOIN category c3_ ON c2_.parent_id = c3_.id LEFT JOIN complexity c4_ ON v0_.complexity_id = c4_.id LEFT JOIN subject_orientation s5_ ON v0_.subject_orientation_id = s5_.id LEFT JOIN color_density c6_ ON v0_.color_density_id = c6_.id LEFT JOIN format f7_ ON v0_.format_id = f7_.id LEFT JOIN visual_placement v15_ ON v0_.id = v15_.visual_id LEFT JOIN placement p8_ ON p8_.id = v15_.placement_id LEFT JOIN visual_tag v16_ ON v0_.id = v16_.visual_id LEFT JOIN tag t9_ ON t9_.id = v16_.tag_id LEFT JOIN visual_color v17_ ON v0_.id = v17_.visual_id LEFT JOIN color c10_ ON c10_.id = v17_.color_id LEFT JOIN visual_mood v18_ ON v0_.id = v18_.visual_id LEFT JOIN mood m11_ ON m11_.id = v18_.mood_id LEFT JOIN visual_style v19_ ON v0_.id = v19_.visual_id LEFT JOIN style s12_ ON s12_.id = v19_.style_id LEFT JOIN visual_graphic_style v20_ ON v0_.id = v20_.visual_id LEFT JOIN graphic_style g13_ ON g13_.id = v20_.graphic_style_id LEFT JOIN visual_theme v21_ ON v0_.id = v21_.visual_id LEFT JOIN theme t14_ ON t14_.id = v21_.theme_id WHERE v0_.is_active = 1 ORDER BY v0_.created_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.uuid AS uuid_1,
  v0_.name AS name_2,
  v0_.description AS description_3,
  v0_.image AS image_4,
  v0_.created_at AS created_at_5,
  v0_.updated_at AS updated_at_6,
  v0_.deleted_at AS deleted_at_7,
  v0_.is_active AS is_active_8,
  v1_.id AS id_9,
  v1_.name AS name_10,
  v1_.created_at AS created_at_11,
  v1_.updated_at AS updated_at_12,
  v1_.deleted_at AS deleted_at_13,
  v1_.is_active AS is_active_14,
  c2_.id AS id_15,
  c2_.name AS name_16,
  c2_.created_at AS created_at_17,
  c2_.updated_at AS updated_at_18,
  c2_.deleted_at AS deleted_at_19,
  c2_.is_active AS is_active_20,
  c3_.id AS id_21,
  c3_.name AS name_22,
  c3_.created_at AS created_at_23,
  c3_.updated_at AS updated_at_24,
  c3_.deleted_at AS deleted_at_25,
  c3_.is_active AS is_active_26,
  c4_.id AS id_27,
  c4_.name AS name_28,
  c4_.created_at AS created_at_29,
  c4_.updated_at AS updated_at_30,
  c4_.deleted_at AS deleted_at_31,
  c4_.is_active AS is_active_32,
  s5_.id AS id_33,
  s5_.name AS name_34,
  s5_.created_at AS created_at_35,
  s5_.updated_at AS updated_at_36,
  s5_.deleted_at AS deleted_at_37,
  s5_.is_active AS is_active_38,
  c6_.id AS id_39,
  c6_.name AS name_40,
  c6_.created_at AS created_at_41,
  c6_.updated_at AS updated_at_42,
  c6_.deleted_at AS deleted_at_43,
  c6_.is_active AS is_active_44,
  f7_.id AS id_45,
  f7_.name AS name_46,
  f7_.created_at AS created_at_47,
  f7_.updated_at AS updated_at_48,
  f7_.deleted_at AS deleted_at_49,
  f7_.is_active AS is_active_50,
  p8_.id AS id_51,
  p8_.name AS name_52,
  p8_.created_at AS created_at_53,
  p8_.updated_at AS updated_at_54,
  p8_.deleted_at AS deleted_at_55,
  p8_.is_active AS is_active_56,
  t9_.id AS id_57,
  t9_.name AS name_58,
  t9_.created_at AS created_at_59,
  t9_.updated_at AS updated_at_60,
  t9_.deleted_at AS deleted_at_61,
  t9_.is_active AS is_active_62,
  c10_.id AS id_63,
  c10_.name AS name_64,
  c10_.created_at AS created_at_65,
  c10_.updated_at AS updated_at_66,
  c10_.deleted_at AS deleted_at_67,
  c10_.is_active AS is_active_68,
  m11_.id AS id_69,
  m11_.name AS name_70,
  m11_.created_at AS created_at_71,
  m11_.updated_at AS updated_at_72,
  m11_.deleted_at AS deleted_at_73,
  m11_.is_active AS is_active_74,
  s12_.id AS id_75,
  s12_.name AS name_76,
  s12_.created_at AS created_at_77,
  s12_.updated_at AS updated_at_78,
  s12_.deleted_at AS deleted_at_79,
  s12_.is_active AS is_active_80,
  g13_.id AS id_81,
  g13_.name AS name_82,
  g13_.created_at AS created_at_83,
  g13_.updated_at AS updated_at_84,
  g13_.deleted_at AS deleted_at_85,
  g13_.is_active AS is_active_86,
  t14_.id AS id_87,
  t14_.name AS name_88,
  t14_.created_at AS created_at_89,
  t14_.updated_at AS updated_at_90,
  t14_.deleted_at AS deleted_at_91,
  t14_.is_active AS is_active_92
FROM
  visual v0_
  LEFT JOIN visual_type v1_ ON v0_.visual_type_id = v1_.id
  LEFT JOIN category c2_ ON v0_.category_id = c2_.id
  LEFT JOIN category c3_ ON c2_.parent_id = c3_.id
  LEFT JOIN complexity c4_ ON v0_.complexity_id = c4_.id
  LEFT JOIN subject_orientation s5_ ON v0_.subject_orientation_id = s5_.id
  LEFT JOIN color_density c6_ ON v0_.color_density_id = c6_.id
  LEFT JOIN format f7_ ON v0_.format_id = f7_.id
  LEFT JOIN visual_placement v15_ ON v0_.id = v15_.visual_id
  LEFT JOIN placement p8_ ON p8_.id = v15_.placement_id
  LEFT JOIN visual_tag v16_ ON v0_.id = v16_.visual_id
  LEFT JOIN tag t9_ ON t9_.id = v16_.tag_id
  LEFT JOIN visual_color v17_ ON v0_.id = v17_.visual_id
  LEFT JOIN color c10_ ON c10_.id = v17_.color_id
  LEFT JOIN visual_mood v18_ ON v0_.id = v18_.visual_id
  LEFT JOIN mood m11_ ON m11_.id = v18_.mood_id
  LEFT JOIN visual_style v19_ ON v0_.id = v19_.visual_id
  LEFT JOIN style s12_ ON s12_.id = v19_.style_id
  LEFT JOIN visual_graphic_style v20_ ON v0_.id = v20_.visual_id
  LEFT JOIN graphic_style g13_ ON g13_.id = v20_.graphic_style_id
  LEFT JOIN visual_theme v21_ ON v0_.id = v21_.visual_id
  LEFT JOIN theme t14_ ON t14_.id = v21_.theme_id
WHERE
  v0_.is_active = 1
ORDER BY
  v0_.created_at DESC

SELECT v0_.id AS id_0, v0_.uuid AS uuid_1, v0_.name AS name_2, v0_.description AS description_3, v0_.image AS image_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.deleted_at AS deleted_at_7, v0_.is_active AS is_active_8, v1_.id AS id_9, v1_.name AS name_10, v1_.created_at AS created_at_11, v1_.updated_at AS updated_at_12, v1_.deleted_at AS deleted_at_13, v1_.is_active AS is_active_14, c2_.id AS id_15, c2_.name AS name_16, c2_.created_at AS created_at_17, c2_.updated_at AS updated_at_18, c2_.deleted_at AS deleted_at_19, c2_.is_active AS is_active_20, c3_.id AS id_21, c3_.name AS name_22, c3_.created_at AS created_at_23, c3_.updated_at AS updated_at_24, c3_.deleted_at AS deleted_at_25, c3_.is_active AS is_active_26, c4_.id AS id_27, c4_.name AS name_28, c4_.created_at AS created_at_29, c4_.updated_at AS updated_at_30, c4_.deleted_at AS deleted_at_31, c4_.is_active AS is_active_32, s5_.id AS id_33, s5_.name AS name_34, s5_.created_at AS created_at_35, s5_.updated_at AS updated_at_36, s5_.deleted_at AS deleted_at_37, s5_.is_active AS is_active_38, c6_.id AS id_39, c6_.name AS name_40, c6_.created_at AS created_at_41, c6_.updated_at AS updated_at_42, c6_.deleted_at AS deleted_at_43, c6_.is_active AS is_active_44, f7_.id AS id_45, f7_.name AS name_46, f7_.created_at AS created_at_47, f7_.updated_at AS updated_at_48, f7_.deleted_at AS deleted_at_49, f7_.is_active AS is_active_50, p8_.id AS id_51, p8_.name AS name_52, p8_.created_at AS created_at_53, p8_.updated_at AS updated_at_54, p8_.deleted_at AS deleted_at_55, p8_.is_active AS is_active_56, t9_.id AS id_57, t9_.name AS name_58, t9_.created_at AS created_at_59, t9_.updated_at AS updated_at_60, t9_.deleted_at AS deleted_at_61, t9_.is_active AS is_active_62, c10_.id AS id_63, c10_.name AS name_64, c10_.created_at AS created_at_65, c10_.updated_at AS updated_at_66, c10_.deleted_at AS deleted_at_67, c10_.is_active AS is_active_68, m11_.id AS id_69, m11_.name AS name_70, m11_.created_at AS created_at_71, m11_.updated_at AS updated_at_72, m11_.deleted_at AS deleted_at_73, m11_.is_active AS is_active_74, s12_.id AS id_75, s12_.name AS name_76, s12_.created_at AS created_at_77, s12_.updated_at AS updated_at_78, s12_.deleted_at AS deleted_at_79, s12_.is_active AS is_active_80, g13_.id AS id_81, g13_.name AS name_82, g13_.created_at AS created_at_83, g13_.updated_at AS updated_at_84, g13_.deleted_at AS deleted_at_85, g13_.is_active AS is_active_86, t14_.id AS id_87, t14_.name AS name_88, t14_.created_at AS created_at_89, t14_.updated_at AS updated_at_90, t14_.deleted_at AS deleted_at_91, t14_.is_active AS is_active_92 FROM visual v0_ LEFT JOIN visual_type v1_ ON v0_.visual_type_id = v1_.id LEFT JOIN category c2_ ON v0_.category_id = c2_.id LEFT JOIN category c3_ ON c2_.parent_id = c3_.id LEFT JOIN complexity c4_ ON v0_.complexity_id = c4_.id LEFT JOIN subject_orientation s5_ ON v0_.subject_orientation_id = s5_.id LEFT JOIN color_density c6_ ON v0_.color_density_id = c6_.id LEFT JOIN format f7_ ON v0_.format_id = f7_.id LEFT JOIN visual_placement v15_ ON v0_.id = v15_.visual_id LEFT JOIN placement p8_ ON p8_.id = v15_.placement_id LEFT JOIN visual_tag v16_ ON v0_.id = v16_.visual_id LEFT JOIN tag t9_ ON t9_.id = v16_.tag_id LEFT JOIN visual_color v17_ ON v0_.id = v17_.visual_id LEFT JOIN color c10_ ON c10_.id = v17_.color_id LEFT JOIN visual_mood v18_ ON v0_.id = v18_.visual_id LEFT JOIN mood m11_ ON m11_.id = v18_.mood_id LEFT JOIN visual_style v19_ ON v0_.id = v19_.visual_id LEFT JOIN style s12_ ON s12_.id = v19_.style_id LEFT JOIN visual_graphic_style v20_ ON v0_.id = v20_.visual_id LEFT JOIN graphic_style g13_ ON g13_.id = v20_.graphic_style_id LEFT JOIN visual_theme v21_ ON v0_.id = v21_.visual_id LEFT JOIN theme t14_ ON t14_.id = v21_.theme_id WHERE v0_.is_active = 1 ORDER BY v0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 65)
7	App\Repository\VisualLibrary\VisualRepository->findAllVisible (line 63)
8	App\Service\VisualLibrary\LibraryService->{closure:App\Service\VisualLibrary\LibraryService::getItems():62} (line 21)
9	App\Service\Core\CacheService->{closure:App\Service\Core\CacheService::get():19} (line 47)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():44} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 52)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 19)
17	App\Service\Core\CacheService->get (line 62)
18	App\Service\VisualLibrary\LibraryService->getItems (line 25)
19	App\Controller\Main\LibraryController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

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\VisualLibrary\Visual	No errors.
App\Entity\VisualLibrary\VisualType	No errors.
App\Entity\VisualLibrary\Category	No errors.
App\Entity\VisualLibrary\Complexity	No errors.
App\Entity\VisualLibrary\SubjectOrientation	No errors.
App\Entity\VisualLibrary\ColorDensity	No errors.
App\Entity\VisualLibrary\Format	No errors.
App\Entity\VisualLibrary\Placement	No errors.
App\Entity\VisualLibrary\Tag	No errors.
App\Entity\VisualLibrary\Color	No errors.
App\Entity\VisualLibrary\Mood	No errors.
App\Entity\VisualLibrary\Style	No errors.
App\Entity\VisualLibrary\GraphicStyle	No errors.
App\Entity\VisualLibrary\Theme	No errors.

Symfony Profiler

GET http://up-ink-v2.hopopup-design.fr/notre-bibliotheque

Configuration Settings

Theme