Teams

Execution Time : 11.281 ms · Memory : 3.31 Mo · SQL : 5 Queries

Fermer
Array
(
    [Interface] => frontend
    [Params] => teams/
)
Fermer
Array
(
)
Fermer
Array
(
    [Interface] => frontend
    [Params] => teams/
)
Fermer
Array
(
    [_lang] => fr
)
Fermer
Array
(
)
Fermer
Array
(
)
Fermer
Array
(
    [PHPRC] => /home/dayraut/domains/mitjet2l.com/fcgi-bin/../etc/php5.2
    [SCRIPT_FILENAME] => /home/dayraut/domains/mitjet2l.com/public_html/index.php
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [PWD] => /home/dayraut/domains/mitjet2l.com/fcgi-bin
    [SHLVL] => 0
    [PHP_FCGI_MAX_REQUESTS] => 99999
    [FCGI_ROLE] => RESPONDER
    [REDIRECT_SCRIPT_URL] => /teams/
    [REDIRECT_SCRIPT_URI] => http://www.mitjet2l.com/teams/
    [REDIRECT_STATUS] => 200
    [SCRIPT_URL] => /teams/
    [SCRIPT_URI] => http://www.mitjet2l.com/teams/
    [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_IF_MODIFIED_SINCE] => Thu, 21 Nov 2019 17:25:21 UTC
    [HTTP_HOST] => www.mitjet2l.com
    [HTTP_CONNECTION] => close
    [HTTP_ACCEPT_ENCODING] => gzip
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache
    [SERVER_NAME] => www.mitjet2l.com
    [SERVER_ADDR] => 54.37.85.47
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 3.214.184.124
    [DOCUMENT_ROOT] => /home/dayraut/domains/mitjet2l.com/public_html
    [REQUEST_SCHEME] => http
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /home/dayraut/domains/mitjet2l.com/public_html
    [SERVER_ADMIN] => [no address given]
    [REMOTE_PORT] => 51400
    [REDIRECT_QUERY_STRING] => Interface=frontend&Params=teams/
    [REDIRECT_URL] => /teams/
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => Interface=frontend&Params=teams/
    [REQUEST_URI] => /teams/
    [SCRIPT_NAME] => /index.php
    [CONTENT_LENGTH] => 0
    [PHP_SELF] => /index.php
    [REQUEST_TIME] => 1575996200
)
Fermer
0.101 ms
SELECT `var`, `value` FROM configuration ORDER BY `var` ASC
0.026 ms
SELECT t.team_id, t.name_team, t.logo, t.manager_id, t.complement, t.address, t.cp, t.ville, t.tel, t.email, t.site , t.facebook, t.url_key FROM pilotes_teams t WHERE 1 AND t.series LIKE '%mitjet2l%' ORDER BY t.name_team ASC
0.115 ms
SELECT p.pilote_id, ps.carno, p.first_name, p.name, p.big_portrait, c.photo AS carphoto FROM pilotes p LEFT JOIN pilotes_to_series ps USING(pilote_id) LEFT JOIN cars c ON(c.no= ps.carno AND ps.saison = c.saison AND ps.serie = c.serie) WHERE 1 AND p.pilote_id IN (SELECT manager_id FROM pilotes_teams WHERE 1 AND series LIKE '%mitjet2l%' ) # AND ps.pilote_id > 0 ORDER BY p.pilote_id ASC
0.026 ms
SELECT ps.pilote_id, ps.team_id, ps.points, ps.rang, ps.carno, p.first_name, p.name, p.big_portrait, c.photo AS carphoto FROM pilotes_to_series ps LEFT JOIN pilotes p USING(pilote_id) LEFT JOIN cars c ON(c.no= ps.carno AND ps.saison = c.saison AND ps.serie = c.serie) WHERE ps.serie LIKE 'mitjet2l' AND ps.saison = 2019 AND ps.team_id IN (SELECT team_id FROM pilotes_teams WHERE 1 AND series LIKE '%mitjet2l%' ) AND ps.pilote_id > 0 # AND ps.rang > 0 ORDER BY ps.team_id ASC, ps.rang ASC
0.133 ms
SELECT name, subname, begin_date, DAY(begin_date) AS day, MONTH(begin_date) AS month, YEAR(begin_date) AS year FROM meetings WHERE begin_date > NOW() ORDER BY begin_date ASC LIMIT 1