Profile Information
Application afterLoad: 0.001 seconds, 0.33 MB
Application afterInitialise: 0.045 seconds, 3.09 MB
Application afterRoute: 0.048 seconds, 3.30 MB
Application afterDispatch: 0.252 seconds, 6.09 MB
Application afterRender: 0.293 seconds, 7.56 MB
Memory Usage
7974364
107 queries logged.
1.
SELECT *
FROM jos_session
WHERE session_id = 'be616705540d8a6767d859a1833603fa'
2.
DELETE
FROM jos_session
WHERE ( time < '1268662405' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'be616705540d8a6767d859a1833603fa'
4.
UPDATE `jos_session`
SET `time`='1268663305',`userid`='1',`usertype`='Super Administrator',`username`='chris',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:15:\"session.counter\";i:32;s:19:\"session.timer.start\";i:1268662949;s:18:\"session.timer.last\";i:1268663303;s:17:\"session.timer.now\";i:1268663303;s:22:\"session.client.browser\";s:91:\"Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:4:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"20\";}}}s:18:\"administrator::com\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:7:\"billets\";O:8:\"stdClass\":1:{s:5:\"model\";O:8:\"stdClass\":3:{s:20:\"categorieslimitstart\";i:0;s:10:\"categories\";O:8:\"stdClass\":3:{s:12:\"filter_order\";s:6:\"tbl.id\";s:16:\"filter_direction\";s:4:\"desc\";s:6:\"filter\";s:0:\"\";}s:18:\"categoriesparentid\";s:1:\"1\";}}}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:1:\"1\";s:4:\"name\";s:5:\"Chris\";s:8:\"username\";s:5:\"chris\";s:5:\"email\";s:19:\"chris@prothemer.com\";s:8:\"password\";s:65:\"8f66f16377912856c0c928bc4ef1db44:p4L3dYjcZQGwEerEUGi3GMSyGnkn2YVv\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-03-14 11:53:29\";s:13:\"lastvisitDate\";s:19:\"2010-03-15 14:22:29\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:69:\"admin_language=en-GB\nlanguage=en-GB\neditor=jce\nhelpsite=\ntimezone=2\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:70:\"/Volumes/Files/Sites/prothemer/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:3:\"jce\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:1:\"2\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"ecdf0d4a918acca1728694f059fc0cde\";}chartcount|i:5;'
WHERE session_id='be616705540d8a6767d859a1833603fa'
5.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
6.
SELECT *
FROM jos_components
WHERE parent = 0
7.
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
8.
SELECT *
FROM jos_billets_config
9.
SHOW COLUMNS
FROM jos_billets_fields LIKE 'checked_out'
10.
SHOW FIELDS
FROM jos_billets_config
11.
SELECT DATE_SUB('2010-03-15 00:00:00', INTERVAL 1 MONTH)
12.
SELECT DATE_ADD('2010-02-15 00:00:00', INTERVAL 1 DAY)
13.
SHOW FIELDS
FROM jos_billets_tickets
14.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-15 00:00:00'
AND tbl.created_datetime <= '2010-02-16 00:00:00'
15.
SELECT DATE_ADD('2010-02-16 00:00:00', INTERVAL 1 DAY)
16.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-16 00:00:00'
AND tbl.created_datetime <= '2010-02-17 00:00:00'
17.
SELECT DATE_ADD('2010-02-17 00:00:00', INTERVAL 1 DAY)
18.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-17 00:00:00'
AND tbl.created_datetime <= '2010-02-18 00:00:00'
19.
SELECT DATE_ADD('2010-02-18 00:00:00', INTERVAL 1 DAY)
20.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-18 00:00:00'
AND tbl.created_datetime <= '2010-02-19 00:00:00'
21.
SELECT DATE_ADD('2010-02-19 00:00:00', INTERVAL 1 DAY)
22.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-19 00:00:00'
AND tbl.created_datetime <= '2010-02-20 00:00:00'
23.
SELECT DATE_ADD('2010-02-20 00:00:00', INTERVAL 1 DAY)
24.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-20 00:00:00'
AND tbl.created_datetime <= '2010-02-21 00:00:00'
25.
SELECT DATE_ADD('2010-02-21 00:00:00', INTERVAL 1 DAY)
26.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-21 00:00:00'
AND tbl.created_datetime <= '2010-02-22 00:00:00'
27.
SELECT DATE_ADD('2010-02-22 00:00:00', INTERVAL 1 DAY)
28.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-22 00:00:00'
AND tbl.created_datetime <= '2010-02-23 00:00:00'
29.
SELECT DATE_ADD('2010-02-23 00:00:00', INTERVAL 1 DAY)
30.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-23 00:00:00'
AND tbl.created_datetime <= '2010-02-24 00:00:00'
31.
SELECT DATE_ADD('2010-02-24 00:00:00', INTERVAL 1 DAY)
32.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-24 00:00:00'
AND tbl.created_datetime <= '2010-02-25 00:00:00'
33.
SELECT DATE_ADD('2010-02-25 00:00:00', INTERVAL 1 DAY)
34.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-25 00:00:00'
AND tbl.created_datetime <= '2010-02-26 00:00:00'
35.
SELECT DATE_ADD('2010-02-26 00:00:00', INTERVAL 1 DAY)
36.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-26 00:00:00'
AND tbl.created_datetime <= '2010-02-27 00:00:00'
37.
SELECT DATE_ADD('2010-02-27 00:00:00', INTERVAL 1 DAY)
38.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-27 00:00:00'
AND tbl.created_datetime <= '2010-02-28 00:00:00'
39.
SELECT DATE_ADD('2010-02-28 00:00:00', INTERVAL 1 DAY)
40.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-02-28 00:00:00'
AND tbl.created_datetime <= '2010-03-01 00:00:00'
41.
SELECT DATE_ADD('2010-03-01 00:00:00', INTERVAL 1 DAY)
42.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-01 00:00:00'
AND tbl.created_datetime <= '2010-03-02 00:00:00'
43.
SELECT DATE_ADD('2010-03-02 00:00:00', INTERVAL 1 DAY)
44.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-02 00:00:00'
AND tbl.created_datetime <= '2010-03-03 00:00:00'
45.
SELECT DATE_ADD('2010-03-03 00:00:00', INTERVAL 1 DAY)
46.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-03 00:00:00'
AND tbl.created_datetime <= '2010-03-04 00:00:00'
47.
SELECT DATE_ADD('2010-03-04 00:00:00', INTERVAL 1 DAY)
48.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-04 00:00:00'
AND tbl.created_datetime <= '2010-03-05 00:00:00'
49.
SELECT DATE_ADD('2010-03-05 00:00:00', INTERVAL 1 DAY)
50.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-05 00:00:00'
AND tbl.created_datetime <= '2010-03-06 00:00:00'
51.
SELECT DATE_ADD('2010-03-06 00:00:00', INTERVAL 1 DAY)
52.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-06 00:00:00'
AND tbl.created_datetime <= '2010-03-07 00:00:00'
53.
SELECT DATE_ADD('2010-03-07 00:00:00', INTERVAL 1 DAY)
54.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-07 00:00:00'
AND tbl.created_datetime <= '2010-03-08 00:00:00'
55.
SELECT DATE_ADD('2010-03-08 00:00:00', INTERVAL 1 DAY)
56.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-08 00:00:00'
AND tbl.created_datetime <= '2010-03-09 00:00:00'
57.
SELECT DATE_ADD('2010-03-09 00:00:00', INTERVAL 1 DAY)
58.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-09 00:00:00'
AND tbl.created_datetime <= '2010-03-10 00:00:00'
59.
SELECT DATE_ADD('2010-03-10 00:00:00', INTERVAL 1 DAY)
60.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-10 00:00:00'
AND tbl.created_datetime <= '2010-03-11 00:00:00'
61.
SELECT DATE_ADD('2010-03-11 00:00:00', INTERVAL 1 DAY)
62.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-11 00:00:00'
AND tbl.created_datetime <= '2010-03-12 00:00:00'
63.
SELECT DATE_ADD('2010-03-12 00:00:00', INTERVAL 1 DAY)
64.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-12 00:00:00'
AND tbl.created_datetime <= '2010-03-13 00:00:00'
65.
SELECT DATE_ADD('2010-03-13 00:00:00', INTERVAL 1 DAY)
66.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-13 00:00:00'
AND tbl.created_datetime <= '2010-03-14 00:00:00'
67.
SELECT DATE_ADD('2010-03-14 00:00:00', INTERVAL 1 DAY)
68.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-14 00:00:00'
AND tbl.created_datetime <= '2010-03-15 00:00:00'
69.
SELECT DATE_ADD('2010-03-15 00:00:00', INTERVAL 1 DAY)
70.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.created_datetime >= '2010-03-15 00:00:00'
AND tbl.created_datetime <= '2010-03-16 00:00:00'
71.
SHOW FIELDS
FROM jos_billets_ticketstates
72.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '0'
73.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 0
ORDER BY ordering ASC
74.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '0'
75.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '0'
76.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '2'
77.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 2
ORDER BY ordering ASC
78.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '1'
79.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 1
ORDER BY ordering ASC
80.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '1'
81.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '3'
82.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 3
ORDER BY ordering ASC
83.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '2'
84.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 2
ORDER BY ordering ASC
85.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.stateid IN ('2')
86.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '1'
87.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 1
ORDER BY ordering ASC
88.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '1'
89.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '3'
90.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 3
ORDER BY ordering ASC
91.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.stateid IN ('1', '3')
92.
SELECT *
FROM jos_billets_ticketstates
WHERE id = '3'
93.
SELECT tbl.*
FROM jos_billets_ticketstates AS tbl
WHERE tbl.enabled = 1
AND tbl.parentid = 3
ORDER BY ordering ASC
94.
SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color
FROM jos_billets_tickets AS tbl
LEFT JOIN jos_users AS u
ON u.id = tbl.sender_userid
LEFT JOIN jos_billets_ticketdata AS td
ON td.ticketid = tbl.id
LEFT JOIN jos_billets_ticketstates AS states
ON tbl.stateid = states.id
LEFT JOIN jos_billets_labels AS label
ON tbl.labelid = label.id
WHERE tbl.stateid IN ('3')
95.
SHOW FIELDS
FROM jos_billets_labels
96.
SELECT tbl.*
FROM jos_billets_labels AS tbl
ORDER BY title
97.
SELECT
COUNT(*)
FROM
jos_billets_tickets AS db
WHERE 1
AND
db.stateid = '2'
98.
SELECT
COUNT(*)
FROM
jos_billets_tickets AS db
WHERE 1
AND
db.stateid = '2'
AND
db.firstresponse_by > '0'
AND
db.feedback_rating > '0'
99.
SELECT
COUNT(*)
FROM
jos_billets_tickets AS db
WHERE 1
AND
db.stateid = '2'
AND
db.firstresponse_by > '0'
AND
db.feedback_rating > '0'
100.
SELECT DATE_SUB('2010-03-01', INTERVAL 1 MONTH)
101.
SELECT
COUNT(*) AS count, SUM(db.feedback_rating) AS ratings
FROM
jos_billets_tickets AS db
WHERE 1
AND
db.stateid = '2'
AND
db.firstresponse_by > '0'
AND
db.closed_datetime >= '2010-02-01'
AND
db.closed_datetime < '2010-03-01'
102.
SELECT
COUNT(*) AS count, SUM(db.feedback_rating) AS ratings
FROM
jos_billets_tickets AS db
WHERE 1
AND
db.stateid = '2'
AND
db.firstresponse_by > '0'
AND
db.closed_datetime >= '2010-03-01'
AND
db.closed_datetime < '2010-03-15 00:00:00'
103.
SELECT m.*
FROM jos_modules AS m
WHERE published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY m.ordering, m.id
104.
SELECT a.*, SUM(b.home) AS home
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
GROUP BY a.id
105.
SELECT *
FROM jos_components
WHERE `option` <> "com_frontpage"
AND `option` <> "com_media"
AND enabled = 1
ORDER BY ordering, name
106.
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 1
107.
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1
Language Files Loaded
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_system_nonumberelements.ini 1
* /Volumes/Files/Sites/prothemer/language/en-GB/en-GB.com_flexicontent.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_billets.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_billets_feedbackhistory.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_billets_googletranslate.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_submenu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_title.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_toolbar.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_amigos.menu.ini
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_billets.menu.ini
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_configurator.menu.ini
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_contact.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_extplorer.menu.ini
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_flexicontent.menu.ini
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_jce.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_poll.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_search.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_jupdateman.menu.ini
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_banners.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_newsfeeds.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_weblinks.menu.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_status.ini 1
* /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_cachecleaner.ini 1
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None