The Bare Blog

The Bare blog is the best way to stay up to date with goings-on at the company.

I like... Posted April 16, 2012 at 17:13

This gem comes courtesy of our Joe Bullman who casts the undeniably sweet Sam in this Aldi ad - Sam has never acted in his life but charms the socks of us with his sweet performance and his natty braces!

11 Page execution time: 1.258 seconds

10 Total SQL queries execution time: 11 in 2.65 milliseconds (0.00265 s)

9 The following SQL queries have been executed: 
    Array
    (
        [0] => Array
            (
                [time] => 0.00015
                [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.00078
                [query] => SELECT
    		     *
    		     FROM bf_blog_entries
    		     WHERE 1 AND deleted != '1'
    		      AND published='1'
    		     
    		      AND urlname = 'i-like'
    		     
    		     
    		     
    		     
    
    		     
    		     
    		     
    		     ORDER BY postStamp DESC
    
    		     
    		     
                [affected] => 1
            )
    
        [2] => Array
            (
                [time] => 0.00034
                [query] => SELECT * FROM
    		 bf_blog_clips
    		  WHERE 1
    		 
    		 
    		 
    		  AND blogId IN (63)
    		     ORDER BY orderfield ASC
    		 
                [affected] => 1
            )
    
        [3] => Array
            (
                [time] => 0.00014
                [query] => SELECT
    		     *
    		     FROM bf_blog_entries
    		     WHERE 1 AND deleted != '1'
    		      AND published='1'
    		     
    		     
    		     
    		     
    		     
    		     
    
    		     
    		     
    		     
    		     ORDER BY postStamp DESC
    
    		     LIMIT 0, 3
    		     
                [affected] => 3
            )
    
        [4] => Array
            (
                [time] => 8.0E-5
                [query] => SELECT * FROM
    		 bf_blog_clips
    		  WHERE 1
    		 
    		 
    		 
    		  AND blogId IN (110,109,108)
    		     ORDER BY orderfield ASC
    		 
                [affected] => 2
            )
    
        [5] => Array
            (
                [time] => 0.00038
                [query] => SELECT i.*
    		  FROM bf_galleries_images i
    		  WHERE 1
    		 
    		 
    		 
    		  AND i.blog_id IN (63)
    		 
                [affected] => 0
            )
    
        [6] => Array
            (
                [time] => 0.00029
                [query] => 
    		SELECT
    			c.*
    
    		FROM bf_clips c 
    		WHERE c.deleted != '1'
    			
    			
    			 AND c.published='1'
    			
    	    
    			 AND c.id IN (1076)
    
    			
    			
    			
    			
    			
    			
    
    			
    
    			
    
    			
    			
    			
    		ORDER BY c.name ASC
    
    		
    	
                [affected] => 1
            )
    
        [7] => Array
            (
                [time] => 0.00011
                [query] => SELECT * FROM bf_content_types WHERE 1
    		 
    		 
    		 
    
    		 ORDER BY name DESC
    		 
                [affected] => 4
            )
    
        [8] => Array
            (
                [time] => 0.00015
                [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] => 0.00012
                [query] => SELECT * FROM
    		 bf_blog_clips
    		  WHERE 1
    		 
    		 
    		 
    		  AND blogId IN (110,109)
    		     ORDER BY orderfield ASC
    		 
                [affected] => 2
            )
    
        [10] => Array
            (
                [time] => 0.00011
                [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] => blog
        [controller] => index
        [action] => view
        [params] => i-like
    )
    

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/