Query Metrics
                200
                Database Queries
            
            
                25
                Different statements
            
            
                41.19 ms
                Query time
            
            
                0
                Invalid entities
            
        Grouped Statements
| Time▼ | Count | Info | 
|---|---|---|
| 
                                                
                                                13.68 ms (33.22%)  | 
                                            71 | 
                                            SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 1762189052 "site_domain_43419afe57696b349fd61a20df5a68f3" ]  | 
                                    
| 
                                                
                                                10.11 ms (24.55%)  | 
                                            50 | 
                                            SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 1762189052 "system\x01tags\x01" "site\x01tags\x01" ]  | 
                                    
| 
                                                
                                                2.42 ms (5.87%)  | 
                                            12 | 
                                            SELECT * FROM settings_store WHERE id = ? AND scope = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ "system_settings" "pimcore_system_settings" ]  | 
                                    
| 
                                                
                                                1.84 ms (4.47%)  | 
                                            8 | 
                                            SELECT objects.*, tree_locks.locked AS locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  6396
]
                                             | 
                                    
| 
                                                
                                                1.69 ms (4.09%)  | 
                                            8 | 
                                            SELECT * FROM object_relations_10 WHERE src_id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  6396
]
                                             | 
                                    
| 
                                                
                                                1.53 ms (3.71%)  | 
                                            8 | 
                                            SELECT * FROM object_store_10 WHERE oo_id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  6396
]
                                             | 
                                    
| 
                                                
                                                1.40 ms (3.40%)  | 
                                            8 | 
                                            SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  6396
]
                                             | 
                                    
| 
                                                
                                                0.98 ms (2.38%)  | 
                                            4 | 
                                            SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ "/manufacturer/portfolio/" "Bharat-Industrial-Manufacturing-Co-1726637039" ]  | 
                                    
| 
                                                
                                                0.93 ms (2.27%)  | 
                                            4 | 
                                            SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 1762189052 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ]  | 
                                    
| 
                                                
                                                0.87 ms (2.11%)  | 
                                            5 | 
                                            SELECT name FROM classes WHERE id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  "11"
]
                                             | 
                                    
| 
                                                
                                                0.80 ms (1.95%)  | 
                                            3 | 
                                            SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ "/Static/" "DefaultImage.jpeg" ]  | 
                                    
| 
                                                
                                                0.73 ms (1.77%)  | 
                                            1 | 
                                            SELECT object_10.id AS id, object_10.type AS `type` FROM object_10 WHERE ((ProfessionalPath = ?) AND object_10.type IN ('object','variant','folder')) AND object_10.published = 1 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                            
                                                                                    [ Pimcore\Model\DataObject\ProProfile {#2323 : "/Services/Manufacturers/Profiles/Bharat-Industrial-Manufacturing-Co-1726637039" } ]  | 
                                    
| 
                                                
                                                0.57 ms (1.39%)  | 
                                            3 | 
                                            SELECT id FROM documents_page WHERE prettyUrl = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  "/manufacturer/portfolio/Bharat-Industrial-Manufacturing-Co-1726637039"
]
                                             | 
                                    
| 
                                                
                                                0.48 ms (1.17%)  | 
                                            2 | 
                                            SELECT * FROM object_relations_15 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object' 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 3354 "Professional" ]  | 
                                    
| 
                                                
                                                0.44 ms (1.06%)  | 
                                            2 | 
                                            SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 1762189052 "object_7257\x01tags\x01" "class_10\x01tags\x01" "asset_945\x01tags\x01" "asset_949\x01tags\x01" ]  | 
                                    
| 
                                                
                                                0.43 ms (1.04%)  | 
                                            1 | 
                                            SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ "/manufacturer/portfolio/Bharat-Industrial-Manufacturing-Co-1726637039" "path" "auto_create" "/manufacturer/portfolio/Bharat-Industrial-Manufacturing-Co-1726637039?page=1" "path_query" "https://arqonz.in/manufacturer/portfolio/Bharat-Industrial-Manufacturing-Co-1726637039?page=1" "entire_uri" ]  | 
                                    
| 
                                                
                                                0.40 ms (0.98%)  | 
                                            2 | 
                                            SELECT id FROM classes WHERE name = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  "ProReview"
]
                                             | 
                                    
| 
                                                
                                                0.29 ms (0.70%)  | 
                                            1 | 
                                            SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 1762189052 "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ]  | 
                                    
| 
                                                
                                                0.26 ms (0.64%)  | 
                                            1 | 
                                            SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ "/Services/Manufacturers/Profiles/" "Bharat-Industrial-Manufacturing-Co-1726637039" ]  | 
                                    
| 
                                                
                                                0.26 ms (0.63%)  | 
                                            1 | 
                                            SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?) 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 1762189052 "object_7258\x01tags\x01" "class_10\x01tags\x01" "asset_950\x01tags\x01" "asset_954\x01tags\x01" "asset_955\x01tags\x01" "asset_956\x01tags\x01" ]  | 
                                    
| 
                                                
                                                0.24 ms (0.57%)  | 
                                            1 | 
                                            SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  435
]
                                             | 
                                    
| 
                                                
                                                0.23 ms (0.57%)  | 
                                            1 | 
                                            SELECT * FROM object_relations_17 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object' 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [ 3352 "Customer" ]  | 
                                    
| 
                                                
                                                0.21 ms (0.50%)  | 
                                            1 | 
                                            SELECT * FROM translations_messages LIMIT 1; 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    []  | 
                                    
| 
                                                
                                                0.20 ms (0.50%)  | 
                                            1 | 
                                            SELECT * FROM tmp_store WHERE id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  "maintenance_mode"
]
                                             | 
                                    
| 
                                                
                                                0.19 ms (0.46%)  | 
                                            1 | 
                                            SELECT customSettings FROM assets WHERE id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  435
]
                                             | 
                                    
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.
Entities Mapping
No mapped entities.