Phoca Forum

Code: Select all

Profil zum Laufzeitverhalten
Application 0.003 seconds (+0.003); 0.60 MB (+0.60) - afterLoad
Application 0.125 seconds (+0.122); 6.99 MB (+6.39) - afterInitialise
Application 0.133 seconds (+0.008); 7.02 MB (+0.03) - afterRoute
Application 23.742 seconds (+23.609); 12.61 MB (+5.59) - afterDispatch
Application 23.896 seconds (+0.154); 14.10 MB (+1.49) - afterRender
Speichernutzung
14.13 MB (14,819,744 Bytes)
27 Queries Logged

    SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '03fmo73o714ej89oq95r8bnm9kftl90r'
    DELETE
      FROM `jos_session`
      WHERE `time` < 1309717087
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT folder AS type, element AS name, params
      FROM jos_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3)
      ORDER BY ordering
    SHOW FIELDS
      FROM jos_users
    SELECT *
      FROM jos_users
      WHERE id = 42
    SELECT g.id, g.title
      FROM jos_usergroups AS g JOIN jos_user_usergroup_map AS m
      ON m.group_id = g.id
      WHERE m.user_id = 42
    SELECT id, home, template, params
      FROM jos_template_styles
      WHERE client_id = 1
    SELECT template, params
      FROM jos_template_styles
      WHERE client_id = 1
      AND id = 2
    INSERT INTO `jos_rokadminaudit` (`user_id`,`ip`,`session_id`,`option`,`task`,`page`,`referrer`,`title`)
      VALUES ('42','xx.xx.154.183','xxxxxxxxxxxxxxxxxxxx','com_phocagallery','','/administrator/index.php?option=com_phocagallery&view=phocagalleryimgs','','')
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_rokcandy'
    SELECT *
      FROM jos_rokcandy
      WHERE published=1
    SELECT id, home, template, params
      FROM jos_template_styles
      WHERE client_id = 0
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_phocagallery'
    SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg
      FROM `jos_phocagallery` AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_users AS uua
      ON uua.id=a.userid
      LEFT JOIN jos_phocagallery_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = c.owner_id
      LEFT JOIN jos_phocagallery_img_votes_statistics AS v
      ON v.imgid = a.id
      WHERE (a.published IN (0, 1))
      AND a.catid = 207
      GROUP BY a.id
      ORDER BY a.title asc
    SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg
      FROM `jos_phocagallery` AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_users AS uua
      ON uua.id=a.userid
      LEFT JOIN jos_phocagallery_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = c.owner_id
      LEFT JOIN jos_phocagallery_img_votes_statistics AS v
      ON v.imgid = a.id
      WHERE (a.published IN (0, 1))
      AND a.catid = 207
      GROUP BY a.id
      ORDER BY a.title asc
      LIMIT 0, 20
    SELECT a.filename
      FROM jos_phocagallery AS a
    SELECT COUNT(a.id) AS count
      FROM jos_phocagallery AS a
      WHERE approved = 0
      LIMIT 0, 1
    SELECT a.title AS text, a.id AS value, a.parent_id as parentid
      FROM jos_phocagallery_categories AS a
      WHERE a.published = 1
      ORDER BY a.ordering
    SELECT a.lang_code AS value, a.title AS text, a.title_native
      FROM jos_languages AS a
      WHERE a.published >= 0
      ORDER BY a.title
    SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-07-03 18:48:31')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-07-03 18:48:31')
      AND m.access IN (1,1,2,3)
      AND m.client_id = 1
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY position, ordering
    SELECT COUNT(*)
      FROM jos_messages
      WHERE state = 0
      AND user_id_to = 42
    SELECT COUNT(session_id)
      FROM jos_session
      WHERE guest = 0
      AND client_id = 1
    SELECT COUNT(session_id)
      FROM jos_session
      WHERE guest = 0
      AND client_id = 0
    SELECT a.*, SUM(b.home) AS home
      FROM jos_menu_types AS a
      LEFT JOIN jos_menu AS b
      ON b.menutype = a.menutype
      WHERE (b.client_id = 0 OR b.client_id IS NULL)
      GROUP BY a.id
    SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
      FROM jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.client_id = 1
      AND e.enabled = 1
      AND m.id > 1
      ORDER BY m.lft