No products in that category
Debug :: Max query time » (0.00136) :: Querys 4 :: page load time » 0.004399 seconds :: close
Debug Info: [minimize]

Query :: time » 0.00136 :: affected rows » 1

INSERT INTO log_1 (time, ip, agent, site, page, vars) VALUES (1711661528, 916708741, 'claudebot', '', '/products.php?attribute_id=32', 'a:4:{s:6:\"$_POST\";a:0:{}s:5:\"$_GET\";a:1:{s:12:\"attribute_id\";s:2:\"32\";}s:9:\"$_SESSION\";a:0:{}s:7:\"$_FILES\";a:0:{}}')

Trace

page: products.php function: include line: 4
page: consts.php function: query line: 106

Query :: time » 0.000341 :: 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'36a3dd85' AND mb.network_stop >= X'36a3dd85' 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: products.php function: include line: 4
page: consts.php function: get_location line: 117
page: maxmind.class.php function: query line: 138

Query :: time » 0.000167 :: affected rows » 30

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

Trace

page: products.php function: include line: 6
page: head.php function: load_list line: 13
page: item.class.php function: query line: 134

Query :: time » 0.000507 :: affected rows » 0

SELECT p.* FROM products p, product_attributes pa WHERE p.status>0 AND pa.product_id=p.id AND pa.attribute_id=32 AND p.prof_rating != 1 ORDER BY p.ord
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpaindexPRIMARYPRIMARY8250.00Using where; Using index; Using temporary; Using filesort
1SIMPLEpeq_refPRIMARYPRIMARY4scs.pa.product_id130.00Using where

Trace

page: products.php function: query line: 65

Variables
Post :: array(0) {
}
Get :: array(1) {
  ["attribute_id"]=>
  int(32)
}
Session :: array(1) {
  ["location"]=>
  array(2) {
    ["ip"]=>
    string(14) "54.163.221.133"
    ["ip_bin"]=>
    string(8) "36a3dd85"
  }
}
Files :: array(0) {
}