GET https://mozartcrm.littlebot.in/admin/lead-status?sort%5BlastUpdatedAt%5D=DESC&state=Switch%20Off

Query Metrics

30 Database Queries
4 Different statements
8.85 ms Query time
0 Invalid entities
28 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.18 ms
(47.21%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.initial_marking AS initial_marking_3, t0.ui_label AS ui_label_4, t0.fa_icon AS fa_icon_5, t0.visible_in_chart AS visible_in_chart_6, t0.ui_color AS ui_color_7, t0.sort_index AS sort_index_8, t0.parent_id AS parent_id_9 FROM state t0 INNER JOIN transition_froms_state ON t0.id = transition_froms_state.state_id WHERE transition_froms_state.transition_id = ?
Parameters:
[
  35
]
3.97 ms
(44.88%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.initial_marking AS initial_marking_3, t0.ui_label AS ui_label_4, t0.fa_icon AS fa_icon_5, t0.visible_in_chart AS visible_in_chart_6, t0.ui_color AS ui_color_7, t0.sort_index AS sort_index_8, t0.parent_id AS parent_id_9 FROM state t0 INNER JOIN transition_tos_state ON t0.id = transition_tos_state.state_id WHERE transition_tos_state.transition_id = ?
Parameters:
[
  35
]
0.42 ms
(4.78%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.initial_marking AS initial_marking_2, s0_.ui_label AS ui_label_3, s0_.fa_icon AS fa_icon_4, s0_.visible_in_chart AS visible_in_chart_5, s0_.ui_color AS ui_color_6, s0_.sort_index AS sort_index_7, s0_.parent_id AS parent_id_8 FROM state s0_ WHERE s0_.parent_id IS NULL ORDER BY s0_.id ASC
Parameters:
[]
0.28 ms
(3.13%)
1
SELECT t0.id AS id_1, t0.guard AS guard_2, t0.name AS name_3, t0.required_fields AS required_fields_4 FROM transition t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
LittleBot\Bundle\CoreBundle\Entity\State 14
LittleBot\Bundle\CoreBundle\Entity\Transition 14