Search by Genre

Toggle log

11 Page execution time: 54 milliseconds (0.054 s)

10 Total SQL queries execution time: 10 in 5.61 milliseconds (0.00561 s)

9 The following SQL queries have been executed: 
    Array
    (
        [0] => Array
            (
                [time] => 0.00011
                [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.00303
                [query] => 
    		SELECT
    			c.*
    
    		FROM bf_clips c 
    		WHERE c.deleted != '1'
    			
    			
    			 AND c.published='1'
    			
    	    
    			
    
    			
    			
    			
    			
    			
    			 AND c.content_type NOT IN ('DIGITAL','COLLECTIVE')
    
    			
    
    			 AND c.work = '1'
    
    			
    			
    			
    		ORDER BY postStamp DESC
    
    		
    	
                [affected] => 101
            )
    
        [2] => Array
            (
                [time] => 0.00018
                [query] => SELECT * FROM bf_content_types WHERE 1
    		 
    		 
    		 
    
    		 ORDER BY name DESC
    		 
                [affected] => 4
            )
    
        [3] => Array
            (
                [time] => 0.00157
                [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 IN (0,12,12,5,12,15,15,15,15,15,14,18,14,7,12,8,8,8,15,5,24,24,24,24,24,21,24,8,8,8,14,21,7,23,23,23,23,11,12,14,14,14,12,7,19,21,21,21,5,11,13,19,19,13,13,15,12,14,14,14,14,14,19,19,19,15,15,15,14,14,14,14,12,12,12,11,11,11,11,10,10,10,10,10,10,10,7,7,7,7,5,5,5,7,5,15,13,13,13,11,12)
    				
    
    				
    
    				
    				AND deleted='0'
    				GROUP BY d.id
    			 ORDER BY name ASC
    			
    		
                [affected] => 13
            )
    
        [4] => Array
            (
                [time] => 0.00038
                [query] => SELECT * FROM bf_directors_types
    				  WHERE 1
    				  
    				   AND director_id IN (5,23,7,24,8,10,11,12,13,14,15,18,21)
    				 
                [affected] => 2
            )
    
        [5] => Array
            (
                [time] => 8.0E-5
                [query] => SELECT
    			*
    			FROM bf_static
    			WHERE 1 AND deleted != '1'
    			 AND published='1'
    			
                            
    			
    			
    			 AND urlname='awards'
    			
    			
    			ORDER BY `order` ASC
    
    			
    			
                [affected] => 1
            )
    
        [6] => Array
            (
                [time] => 7.0E-5
                [query] => SELECT
    			*
    			FROM bf_static
    			WHERE 1 AND deleted != '1'
    			 AND published='1'
    			
                            
    			
    			
    			 AND urlname='what-they-say'
    			
    			
    			ORDER BY `order` ASC
    
    			
    			
                [affected] => 1
            )
    
        [7] => Array
            (
                [time] => 7.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
            )
    
        [8] => Array
            (
                [time] => 5.0E-5
                [query] => SELECT * FROM
    		 bf_blog_clips
    		  WHERE 1
    		 
    		 
    		 
    		  AND blogId IN (111,110)
    		     ORDER BY orderfield ASC
    		 
                [affected] => 2
            )
    
        [9] => Array
            (
                [time] => 7.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] => work
    )
    

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/