Current Promotions

Debug :: Max query time » (0.001409) :: Querys 8 :: page load time » 0.008357 seconds :: close
Debug Info: [minimize]

Query :: time » 0.001409 :: affected rows » 1

INSERT INTO log_1 (time, ip, agent, site, page, vars) VALUES (1731038299, 750797578, 'CCBot/2.0 (https://commoncrawl.org/faq/)', '', '/', 'a:4:{s:6:\"$_POST\";a:0:{}s:5:\"$_GET\";a:0:{}s:9:\"$_SESSION\";a:0:{}s:7:\"$_FILES\";a:0:{}}')

Trace

page: index.php function: include line: 2
page: consts.php function: query line: 106

Query :: time » 0.000345 :: affected rows » 0

SELECT ml.*, mb.postal_code, mb.lat, mb.lon, mb.accuracy FROM maxmind_blocks mb, maxmind_locations ml WHERE mb.network_start <= X'2cc0430a' AND mb.network_stop >= X'2cc0430a' AND mb.geoname_id=ml.id ORDER BY mb.network_start DESC LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEmbrangePRIMARYPRIMARY181100.00Using where
1SIMPLEmleq_refPRIMARYPRIMARY4scs.mb.geoname_id1100.00

Trace

page: index.php function: include line: 2
page: consts.php function: get_location line: 117
page: maxmind.class.php function: query line: 138

Query :: time » 0.000188 :: affected rows » 30

SELECT * FROM attributes ORDER BY ord
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEattributesALL29100.00Using filesort

Trace

page: index.php function: include line: 5
page: head.php function: load_list line: 13
page: item.class.php function: query line: 134

Query :: time » 0.000453 :: affected rows » 28

SELECT * FROM products WHERE status>0 && (prof_rating=0 || prof_rating=2)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEproductsALL546.33Using where

Trace

page: index.php function: where line: 50
page: item.class.php function: query line: 180

Query :: time » 0.000443 :: affected rows » 38

SELECT * FROM videos WHERE 1=1 ORDER BY ord
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEvideosALL38100.00Using filesort

Trace

page: index.php function: where line: 68
page: item.class.php function: query line: 180

Query :: time » 0.00052 :: affected rows » 7

SELECT * FROM promotions WHERE status=2 AND product_id!=0
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpromotionsALL279.00Using where

Trace

page: index.php function: load_promotions line: 95
page: promotion.class.php function: where line: 37
page: item.class.php function: query line: 180

Query :: time » 0.000414 :: affected rows » 54

SELECT * FROM products
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEproductsALL54100.00

Trace

page: index.php function: load_list line: 102
page: item.class.php function: query line: 134

Query :: time » 0.000363 :: affected rows » 113

SELECT * FROM product_sizes
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEproduct_sizesALL113100.00

Trace

page: index.php function: load_list line: 103
page: item.class.php function: query line: 134

Variables
Post :: array(0) {
}
Get :: array(0) {
}
Session :: array(1) {
  ["location"]=>
  array(2) {
    ["ip"]=>
    string(12) "44.192.67.10"
    ["ip_bin"]=>
    string(8) "2cc0430a"
  }
}
Files :: array(0) {
}