Jim Weedon

Toggle log

11 Page execution time: 592 milliseconds (0.592 s)

10 Total SQL queries execution time: 11 in 3.51 milliseconds (0.00351 s)

9 The following SQL queries have been executed: 
    Array
    (
        [0] => Array
            (
                [time] => 8.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.00114
                [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 deleted='0'
    				GROUP BY d.id
    			 ORDER BY order_field ASC
    			
    		
                [affected] => 20
            )
    
        [2] => Array
            (
                [time] => 6.0E-5
                [query] => SELECT * FROM bf_content_types WHERE 1
    		 
    		 
    		 
    
    		 ORDER BY name DESC
    		 
                [affected] => 4
            )
    
        [3] => Array
            (
                [time] => 0.00019
                [query] => SELECT * FROM bf_directors_types
    				  WHERE 1
    				  
    				   AND director_id IN (35,30,34,33,31,14,15,28,24,29,13,11,5,7,10,21,23,18,12,8)
    				 
                [affected] => 7
            )
    
        [4] => Array
            (
                [time] => 0.00024
                [query] => SELECT
    			u.*
    		FROM bf_showreels u
    		
    		WHERE 1 AND u.deleted != '1'
    			 AND u.published='1'
    			 AND u.id = 1714
    			
    			
    
    			
    			
    			
    			
    			
    			
    			
    			
    		ORDER BY u.postStamp DESC
    
    		
    	
                [affected] => 1
            )
    
        [5] => Array
            (
                [time] => 0.00089
                [query] => SELECT * FROM
    			 bf_showreels_clips
    			  WHERE 1
    			 
    			 
    			 
    			  AND showreelId IN (1714)
    			     ORDER BY orderfield ASC
    			 
                [affected] => 8
            )
    
        [6] => Array
            (
                [time] => 0.00031
                [query] => 
    		SELECT
    			c.*
    
    		FROM bf_clips c 
    		WHERE c.deleted != '1'
    			
    			
    			 AND c.published='1'
    			
    	    
    			 AND c.id IN (1765,1884,1170,499,57,54,1646,5)
    
    			
    			
    			
    			
    			
    			
    
    			
    
    			
    
    			
    			
    			
    		ORDER BY c.name ASC
    
    		
    	
                [affected] => 8
            )
    
        [7] => Array
            (
                [time] => 0.0004
                [query] => SELECT bf_testimonials.*, bf_directors.name AS director, bf_directors.urlname AS director_urlname FROM bf_testimonials LEFT JOIN bf_directors ON bf_testimonials.director_id =  bf_directors.id
    					WHERE 1 AND director_id = 12 AND bf_testimonials.published = 1 ORDER BY post_stamp ASC
                [affected] => 0
            )
    
        [8] => 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
            )
    
        [9] => Array
            (
                [time] => 6.0E-5
                [query] => SELECT * FROM
    		 bf_blog_clips
    		  WHERE 1
    		 
    		 
    		 
    		  AND blogId IN (111,110)
    		     ORDER BY orderfield ASC
    		 
                [affected] => 2
            )
    
        [10] => Array
            (
                [time] => 8.0E-5
                [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] => directors
        [controller] => index
        [action] => view
        [params] => jim
    )
    

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/