Query Metrics
                59
                Database Queries
            
            
                26
                Different statements
            
            
                184.46 ms
                Query time
            
            
                0
                Invalid entities
            
                    Grouped Statements
| Time▼ | Count | Info | 
|---|---|---|
| 
                                    
                                    26.42 ms (14.32%)  | 
                                1 | 
                                UPDATE users SET `lastLogin` = ? WHERE `id` = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ 1761656458 9 ]  | 
                        
| 
                                    
                                    19.01 ms (10.31%)  | 
                                1 | 
                                SELECT * FROM object_store_15 WHERE oo_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53558
]
                                 | 
                        
| 
                                    
                                    18.18 ms (9.85%)  | 
                                1 | 
                                SELECT object_15.o_id as o_id, `object_15`.`o_type` FROM `object_15` WHERE ((lcdv = '1CSISUKIFKY0A0D4' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1) LIMIT 1 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            []  | 
                        
| 
                                    
                                    15.58 ms (8.45%)  | 
                                5 | 
                                SELECT * FROM object_relations_13 WHERE src_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53560
]
                                 | 
                        
| 
                                    
                                    11.88 ms (6.44%)  | 
                                1 | 
                                SELECT * FROM object_relations_5 WHERE src_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53522
]
                                 | 
                        
| 
                                    
                                    10.83 ms (5.87%)  | 
                                7 | 
                                SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53558
]
                                 | 
                        
| 
                                    
                                    10.16 ms (5.51%)  | 
                                5 | 
                                SELECT * FROM object_store_13 WHERE oo_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53560
]
                                 | 
                        
| 
                                    
                                    9.60 ms (5.20%)  | 
                                1 | 
                                SELECT object_13.o_id as o_id, `object_13`.`o_type` FROM `object_13` WHERE ((lcdv16__id = :lcdv AND (custRegion__id = :regid) AND object_13.o_type IN ('object','folder')) AND object_13.o_published = 1) 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "lcdv" => 53558 "regid" => 872 ]  | 
                        
| 
                                    
                                    9.09 ms (4.93%)  | 
                                1 | 
                                SELECT * FROM object_relations_15 WHERE src_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53558
]
                                 | 
                        
| 
                                    
                                    8.06 ms (4.37%)  | 
                                1 | 
                                SELECT * FROM object_collection_VehicleMasterCharacteristics_15 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ 53558 "descriptiveInformation" ]  | 
                        
| 
                                    
                                    7.68 ms (4.16%)  | 
                                1 | 
                                SELECT * FROM object_store_5 WHERE oo_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53522
]
                                 | 
                        
| 
                                    
                                    5.12 ms (2.78%)  | 
                                1 | 
                                SELECT object_4.o_id as o_id, `object_4`.`o_type` FROM `object_4` WHERE ((code = '21' AND object_4.o_type IN ('object','folder')) AND object_4.o_published = 1) LIMIT 1 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            []  | 
                        
| 
                                    
                                    4.15 ms (2.25%)  | 
                                2 | 
                                SELECT * FROM users WHERE `type` = ? AND `name` = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "user" "PIMAP001" ]  | 
                        
| 
                                    
                                    3.57 ms (1.93%)  | 
                                1 | 
                                SELECT object_12.o_id as o_id, `object_12`.`o_type` FROM `object_12` WHERE ((lcdv16__id = :lcdv AND (customerRegion__id = :regid) AND object_12.o_type IN ('object','folder')) AND object_12.o_published = 1) 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "lcdv" => 53558 "regid" => 872 ]  | 
                        
| 
                                    
                                    3.36 ms (1.82%)  | 
                                7 | 
                                SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  53558
]
                                 | 
                        
| 
                                    
                                    3.31 ms (1.80%)  | 
                                3 | 
                                SELECT * FROM users_workspaces_document WHERE userId = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  9
]
                                 | 
                        
| 
                                    
                                    2.88 ms (1.56%)  | 
                                3 | 
                                SELECT id FROM documents WHERE path = :path AND `key` = :key 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "key" => "vehiclepriceinfo" "path" => "/api/" ]  | 
                        
| 
                                    
                                    2.68 ms (1.45%)  | 
                                1 | 
                                SELECT object_14.o_id as o_id, `object_14`.`o_type` FROM `object_14` WHERE ((lcdv16__id = ? AND (custRegion__id = ?) AND object_14.o_type IN ('object','folder')) AND object_14.o_published = 1) 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ 53558 872 ]  | 
                        
| 
                                    
                                    2.55 ms (1.38%)  | 
                                1 | 
                                SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "sourcePath" => "/api/vehiclepriceinfo" "sourcePathQuery" => "/api/vehiclepriceinfo" "sourceEntireUri" => "http://ps.dp-uat.citroen.in/api/vehiclepriceinfo" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ]  | 
                        
| 
                                    
                                    2.40 ms (1.30%)  | 
                                3 | 
                                SELECT * FROM users_workspaces_asset WHERE userId = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  9
]
                                 | 
                        
| 
                                    
                                    2.32 ms (1.26%)  | 
                                1 | 
                                SELECT object_5.o_id as o_id, `object_5`.`o_type` FROM `object_5` WHERE ((lcdv16__id = :lcdv AND (customerRegion__id = :regid) AND object_5.o_type IN ('object','folder')) AND object_5.o_published = 1) 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "lcdv" => 53558 "regid" => 872 ]  | 
                        
| 
                                    
                                    1.90 ms (1.03%)  | 
                                4 | 
                                SELECT name FROM classes WHERE id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  "4"
]
                                 | 
                        
| 
                                    
                                    1.67 ms (0.91%)  | 
                                2 | 
                                SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "prettyUrl" => "/api/vehiclepriceinfo" ]  | 
                        
| 
                                    
                                    1.31 ms (0.71%)  | 
                                3 | 
                                SELECT * FROM users_workspaces_object WHERE userId = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [
  9
]
                                 | 
                        
| 
                                    
                                    0.37 ms (0.20%)  | 
                                1 | 
                                select `dependency` from object_collection_VehicleMasterCharacteristics_15 where o_id = 53558 and fieldname = 'descriptiveInformation' and `index` = 0 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            []  | 
                        
| 
                                    
                                    0.37 ms (0.20%)  | 
                                1 | 
                                SELECT * FROM users WHERE `type` = ? AND id = ? 
                                    Parameters:  
                                
                                
                                                                    
                                
                                                                    
                                
                                                            [ "role" "3" ]  | 
                        
Database Connections
| Name | Service | 
|---|---|
| default | doctrine.dbal.default_connection | 
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.