message: Don't forget to explicitly call the close() method at the end of your script. This can be a life saver if you have heavy traffic and frequent queries
method: close()
close all
1.
SELECT
az_ragione_sociale,az_ragione_socialen, az_indirizzo,
az_cap, az_telefono,
cat_namen, cats_namen,
localita.prov_namen as az_localita,
capoluoghi.cap_namen as az_provincia
FROM
aziende
JOIN category ON az_macro_categoria = cat_id
JOIN category_s ON az_microcategoria = cats_id
JOIN province localita ON az_prov_id = localita.prov_id
JOIN capoluoghi ON localita.prov_sigla= capoluoghi.cap_sigla
WHERE
az_site_id = 2 AND
az_macro_categoria = 3
ORDER BY
az_ragione_sociale ASC
LIMIT
0, 50
MySQL error message: Error writing file '/tmp/MYODrNxd' (Errcode: 122)
Backtrace Full trace
function: query
file: /var/www/vhosts/aziendepiemonte.net/httpdocs/include/sotto_inclusioni/new_site/template/home_aziende_nocache.php
line: 33
close all
1.
SELECT
site_id, site_name, site_link, site_keywords, site_description, site_lang, site_title, site_google_analytics,
site_google_maps, site_google_verify, site_regione_sonorika
FROM
Sites_Name
WHERE
site_link = 'www.aziendepiemonte.net'
execution time: 0.00028085708618164 seconds
returned rows: 1 ««
show
| explain
Backtrace Full trace
function: query
file: /var/www/vhosts/aziendepiemonte.net/httpdocs/include/sotto_inclusioni/constancts.inc.php
line: 23
close all
2.
SELECT
cat_id, cat_name, cat_namen, cat_tag_keywords, cat_tag_description
FROM
category
WHERE
cat_namen = 'arredamento'
execution time: 0.00016212463378906 seconds
returned rows: 1 ««
show
| explain
Backtrace Full trace
function: query
file: /var/www/vhosts/aziendepiemonte.net/httpdocs/include/sotto_inclusioni/new_site/analizza_parametri.php
line: 5
close all
3.
SELECT
prov_name, prov_namen
FROM
province
WHERE
prov_site_id = 2 AND prov_capoluogo = '1'
ORDER BY
prov_name ASC
execution time: 0.00037288665771484 seconds
returned rows: 8 ««
show
| explain
Backtrace Full trace
function: query
file: /var/www/vhosts/aziendepiemonte.net/httpdocs/include/sotto_inclusioni/new_site/template/home_province.php
line: 31
close all
message: Don't forget to explicitly call the close() method at the end of your script. This can be a life saver if you have heavy traffic and frequent queries
method: close()
close all
watch: 0
$_FILES
Array
(
)
$_GET
Array
(
[categoria] => aziende arredamento
)
$_POST
Array
(
)
$_SERVER
Array
(
[REDIRECT_STATUS] => 200
[HTTP_X_CC_ID] => ccc03-02
[HTTP_HOST] => www.aziendepiemonte.net
[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
[PATH] => /sbin:/usr/sbin:/bin:/usr/bin
[SERVER_SIGNATURE] => Apache/2.2.3 (CentOS) Server at www.aziendepiemonte.net Port 80
[SERVER_SOFTWARE] => Apache/2.2.3 (CentOS)
[SERVER_NAME] => www.aziendepiemonte.net
[SERVER_ADDR] => 62.149.164.63
[SERVER_PORT] => 80
[REMOTE_ADDR] => 38.107.191.117
[DOCUMENT_ROOT] => /var/www/vhosts/aziendepiemonte.net/httpdocs
[SERVER_ADMIN] => info@ileven.net
[SCRIPT_FILENAME] => /var/www/vhosts/aziendepiemonte.net/httpdocs/index.php
[REMOTE_PORT] => 47747
[REDIRECT_QUERY_STRING] => categoria=aziende+arredamento
[REDIRECT_URL] => /aziende+arredamento/
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => categoria=aziende+arredamento
[REQUEST_URI] => /aziende+arredamento/
[SCRIPT_NAME] => /index.php
[PHP_SELF] => /index.php
[REQUEST_TIME] => 1268528460
)
$_SESSION