Pick Category
Debug :: Max query time » (0.002434) :: Querys 4 :: page load time » 0.00551 seconds :: close
Debug Info: [minimize]

Query :: time » 0.002434 :: affected rows » 1

INSERT INTO log_0 (time, ip, agent, site, page, vars) VALUES (1729621440, 51317314, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '/products.php?category_id=4', 'a:4:{s:6:\"$_POST\";a:0:{}s:5:\"$_GET\";a:1:{s:11:\"category_id\";s:1:\"4\";}s:9:\"$_SESSION\";a:1:{s:8:\"location\";a:2:{s:2:\"ip\";s:10:\"3.15.10.66\";s:6:\"ip_bin\";s:8:\"030f0a42\";}}s:7:\"$_FILES\";a:0:{}}')

Trace

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

Query :: time » 0.000292 :: 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.000214 :: affected rows » 10

SELECT * FROM categorys WHERE pro_only=0 ORDER BY ord
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcategorysALL1310.00Using where; Using filesort

Trace

page: products.php function: load_list line: 15
page: item.class.php function: query line: 134

Query :: time » 0.000338 :: affected rows » 6

SELECT p.* FROM products p, categorys c WHERE p.status>0 AND p.category_id=c.id AND p.category_id=4 AND p.prof_rating != 1 ORDER BY c.ord, p.ord
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcconstPRIMARYPRIMARY4const1100.00Using filesort
1SIMPLEprefcategory_idcategory_id4const630.00Using index condition; Using where

Trace

page: products.php function: query line: 65

Variables
Post :: array(0) {
}
Get :: array(1) {
  ["category_id"]=>
  int(4)
}
Session :: array(1) {
  ["location"]=>
  array(2) {
    ["ip"]=>
    string(10) "3.15.10.66"
    ["ip_bin"]=>
    string(8) "030f0a42"
  }
}
Files :: array(0) {
}