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/
The latest from bare blog
about N/A via twitterfeed