»

1.
  
SELECT
SQL_CALC_FOUND_ROWS `memberfriendid`
FROM
`friend`
WHERE
`memberid` = '22' AND `memberfriendid`=

MySQL error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
function: query()
file: /var/www/vhosts/gaatuit.be/httpdocs/friend.php
line: 61

2.
  
SELECT
SQL_CALC_FOUND_ROWS mi.`menuitemid` AS 'mi_id', mi.`linktext` AS 'mi_linktext', mi.`url` AS 'mi_url', mi.`description` AS 'mi_description', mi.`icon` AS 'mi_icon', mi.`visiblearray` AS 'mi_visiblearray', mi.`sortorder` AS 'mi_sortorder'
FROM
`menu_item` mi
ORDER BY
`sortorder`

execution time: 0.00018191337585449 seconds
returned rows: 21 «« show | explain
function: query()
file: /var/www/vhosts/gaatuit.be/httpdocs/block/menu/menu.php
line: 60

3.
  
SELECT
SQL_CALC_FOUND_ROWS msi.`linktext` AS 'msi_linktext', msi.`url` AS 'msi_url', msi.`description` AS 'msi_description', msi.`icon` AS 'msi_icon', msi.`visiblearray` AS 'msi_visiblearray', msi.`menuitemid` AS 'msi_top_id', msi.`sortorder` AS 'msi_sortorder'
FROM
`menu_subitem` msi
ORDER BY
`sortorder`

execution time: 0.00030207633972168 seconds
returned rows: 77 «« show | explain
function: query()
file: /var/www/vhosts/gaatuit.be/httpdocs/block/menu/menu.php
line: 68

4.
  
SELECT
SQL_CALC_FOUND_ROWS DISTINCT `menuitemid`
FROM
`menu_subitem`

execution time: 0.00014019012451172 seconds
returned rows: 12 «« show | explain
function: query()
file: /var/www/vhosts/gaatuit.be/httpdocs/block/menu/menu.php
line: 74

5.
  
SELECT
SQL_CALC_FOUND_ROWS `settings`
FROM
`memberinfo`
WHERE
`memberid` = '22'

execution time: 0.00018095970153809 seconds
returned rows: 1 «« show | explain
function: query()
file: /var/www/vhosts/gaatuit.be/httpdocs/framework/class/Functions.php
line: 165

6.
  
SELECT
SQL_CALC_FOUND_ROWS m.`memberid`, m.`nickname`, p.`thumb`, f.`group`, uo.`status`, fg.`description`
FROM
`friend` f JOIN `photo` p ON p.`memberid` = f.`memberfriendid` JOIN `member` m ON m.`memberid`= f.`memberfriendid` JOIN `users_online` uo ON uo.`memberid`= f.`memberfriendid` JOIN `friendgroup` fg ON fg.`group` = f.`group`
WHERE
f.`active` = 1 AND f.`memberid`='22'
ORDER BY
f.`group` ASC

execution time: 0.062041997909546 seconds
returned rows: 5 «« show | explain
function: query()
file: /var/www/vhosts/gaatuit.be/httpdocs/block/friend/friend_overview.php
line: 43

messages: 0

watch: 0

$_COOKIE

Array
(
    [PHPSESSID] => qsggneqjspp39elnil1sd95ae7
)
                

$_FILES

Array
(
)
                

$_GET

Array
(
    [id] => 22
)
                

$_POST

Array
(
)
                

$_SERVER

Array
(
    [REDIRECT_STATUS] => 200
    [HTTP_X_CC_ID] => ccc02-01
    [HTTP_HOST] => www.gaatuit.be
    [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
    [HTTP_ACCEPT_ENCODING] => gzip
    [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
    [HTTP_CONNECTION] => close
    [HTTP_CACHE_CONTROL] => no-cache
    [HTTP_PRAGMA] => no-cache
    [HTTP_COOKIE] => PHPSESSID=qsggneqjspp39elnil1sd95ae7
    [PATH] => /sbin:/usr/sbin:/bin:/usr/bin
    [SERVER_SIGNATURE] => 
Apache Server at www.gaatuit.be Port 80

    [SERVER_SOFTWARE] => Apache
    [SERVER_NAME] => www.gaatuit.be
    [SERVER_ADDR] => 94.23.218.44
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 38.107.179.220
    [DOCUMENT_ROOT] => /var/www/vhosts/gaatuit.be/httpdocs
    [SERVER_ADMIN] => joekie@gmail.com
    [SCRIPT_FILENAME] => /var/www/vhosts/gaatuit.be/httpdocs/friend.php
    [REMOTE_PORT] => 44085
    [REDIRECT_QUERY_STRING] => id=22
    [REDIRECT_URL] => /friend/22
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => id=22
    [REQUEST_URI] => /friend/22
    [SCRIPT_NAME] => /friend.php
    [PHP_SELF] => /friend.php
    [REQUEST_TIME] => 1328562251
)
                

$_SESSION

Array
(
    [ADDTOMENU] => http://www.gaatuit.be/member/27
)