Dream Volume

Toggle log

11 Page execution time: 554 milliseconds (0.554 s)

10 Total SQL queries execution time: 8 in 2.17 milliseconds (0.00217 s)

9 The following SQL queries have been executed: 
    Array
    (
        [0] => Array
            (
                [time] => 9.0E-5
                [query] => SELECT
    			c.*
    			FROM bf_clips_categories c
    			 LEFT JOIN bf_clips_categories_relationship t ON (t.category_id = c.id) LEFT JOIN bf_clips cl ON (cl.id = t.clip_id)
    			WHERE 1
    			
    			
    				
                            
    			
    				
    			 AND ((t.clip_id IS NOT NULL) AND (cl.work = '1') AND (cl.content_type NOT IN ('DIGITAL','COLLECTIVE')))
    				
    			GROUP BY c.id
    
    			ORDER BY c.name ASC
    
    			
    			
                [affected] => 13
            )
    
        [1] => Array
            (
                [time] => 0.00092
                [query] => 
    		SELECT
    			c.*
    
    		FROM bf_clips c 
    		WHERE c.deleted != '1'
    			
    			 AND c.urlname='dream-volume'
    			 AND c.published='1'
    			
    	    
    			
    
    			
    			
    			
    			
    			
    			
    
    			
    
    			 AND c.work = '1'
    
    			
    			
    			
    		ORDER BY c.name ASC
    
    		
    	
                [affected] => 1
            )
    
        [2] => Array
            (
                [time] => 0.0001
                [query] => SELECT * FROM bf_content_types WHERE 1
    		 
    		 
    		 
    
    		 ORDER BY name DESC
    		 
                [affected] => 4
            )
    
        [3] => Array
            (
                [time] => 0.00067
                [query] => SELECT
    				*
    			FROM bf_directors d
    			LEFT JOIN bf_directors_types t ON t.director_id = d.id
    			WHERE 1
    				 AND d.published='1'
    				AND d.id=11
    				
    				
    				
    				
    
    				
    
    				
    				AND deleted='0'
    				GROUP BY d.id
    			 ORDER BY name ASC
    			
    		
                [affected] => 1
            )
    
        [4] => Array
            (
                [time] => 0.00014
                [query] => SELECT * FROM bf_directors_types
    				  WHERE 1
    				  
    				   AND director_id IN (11)
    				 
                [affected] => 0
            )
    
        [5] => Array
            (
                [time] => 6.0E-5
                [query] => SELECT
    		     *
    		     FROM bf_blog_entries
    		     WHERE 1 AND deleted != '1'
    		      AND published='1'
    		     
    		     
    		     
    		     
    		     
    		     
    
    		     
    		     
    		     
    		     ORDER BY postStamp DESC
    
    		     LIMIT 0, 2
    		     
                [affected] => 2
            )
    
        [6] => Array
            (
                [time] => 5.0E-5
                [query] => SELECT * FROM
    		 bf_blog_clips
    		  WHERE 1
    		 
    		 
    		 
    		  AND blogId IN (111,110)
    		     ORDER BY orderfield ASC
    		 
                [affected] => 2
            )
    
        [7] => Array
            (
                [time] => 0.00014
                [query] => SELECT
    			*
    			FROM bf_static
    			WHERE 1 AND deleted != '1'
    			 AND published='1'
    			
                            
    			
    			
    			 AND urlname='wine'
    			
    			
    			ORDER BY `order` ASC
    
    			
    			
                [affected] => 0
            )
    
    )
    

8 $_POST data: 
    Array
    (
    )
    

7 $_GET data: 
    Array
    (
        [module] => work
        [controller] => index
        [action] => view
        [params] => dream-volume
    )
    

6 The database is initialized

5 Default timezone set to: Europe/London

4 Config files loaded:
    /var/www/clients/barefilms/www.barefilms.co.uk/application/config/config.ini


3 Config Environment: live

2 PHP include path: 
    /var/www/clients/barefilms/www.barefilms.co.uk/application/
    /var/www/clients/barefilms/www.barefilms.co.uk/libs/

1 Application directory: /var/www/clients/barefilms/www.barefilms.co.uk/application/