Package: python-django-debug-toolbar Version: 1:0+git201107220111-96e46c6-1 Severity: normal
Debug toolbar makes 2 additional sql queries for each query made by django itself. Parts from mysql.log are included. In /admin/ number of queries may be 35 instead of 11 with previous version. -- System Information: Debian Release: wheezy/sid APT prefers unstable APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.39-2-686-pae (SMP w/2 CPU cores) Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages python-django-debug-toolbar depends on: ii libjs-jquery 1.6.2-1 JavaScript library for dynamic web ii libjs-jquery-cookie 4-1 jQuery cookie plugin ii python 2.6.7-2 interactive high-level object-orie ii python-django 1.3-2 High-level Python web development ii python-support 1.0.14 automated rebuilding support for P Versions of packages python-django-debug-toolbar recommends: pn python-pygments <none> (no description available) python-django-debug-toolbar suggests no packages. -- no debconf information *** /tmp/mysql_with_0.85.txt 110806 22:38:29 3503 Connect msu@localhost on msu 3503 Query SET NAMES utf8 3503 Query set autocommit=0 3503 Query SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' AND `django_session`.`expire_date` > '2011-08-06 22:38:29' ) 3503 Query SELECT `static_pages_staticpagetext`.`id`, `static_pages_staticpagetext`.`lang`, `static_pages_staticpagetext`.`content`, `static_pages_staticpagetext`.`name`, `static_pages_staticpagetext`.`page_id`, `static_pages_staticpage`.`id`, `static_pages_staticpage`.`parent_id`, `static_pages_staticpage`.`code`, `static_pages_staticpage`.`sort`, `static_pages_staticpage`.`url` FROM `static_pages_staticpagetext` INNER JOIN `static_pages_staticpage` ON (`static_pages_staticpagetext`.`page_id` = `static_pages_staticpage`.`id`) LEFT OUTER JOIN `static_pages_staticpage` T3 ON (`static_pages_staticpage`.`parent_id` = T3.`id`) WHERE (`static_pages_staticpagetext`.`lang` = 'ru' AND T3.`id` IS NULL) 3503 Query SELECT `quicklinks_quicklink`.`id`, `quicklinks_quicklink`.`lang`, `quicklinks_quicklink`.`name`, `quicklinks_quicklink`.`description`, `quicklinks_quicklink`.`url` FROM `quicklinks_quicklink` WHERE `quicklinks_quicklink`.`lang` = 'ru' 3503 Query SELECT `auth_user`.`id`, `auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`, `auth_user`.`email`, `auth_user`.`password`, `auth_user`.`is_staff`, `auth_user`.`is_active`, `auth_user`.`is_superuser`, `auth_user`.`last_login`, `auth_user`.`date_joined` FROM `auth_user` WHERE `auth_user`.`id` = 1 3503 Query SELECT (1) AS `a` FROM `django_session` WHERE `django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' LIMIT 1 3503 Query UPDATE `django_session` SET `session_data` = 'MjJjZmU2Mjg1NDJjODhkYzBlNjA3Yzc1MGM2MWNmMzhhOGNhODI5OTqAAn1xAShVDV9hdXRoX3Vz\nZXJfaWRxAooBAVUPZGphbmdvX2xhbmd1YWdlcQNYAgAAAHJ1cQRVEl9hdXRoX3VzZXJfYmFja2Vu\nZHEFVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHEGdS4=\n', `expire_date` = '2011-08-20 22:38:29' WHERE `django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' 3503 Query commit 3503 Quit 3504 Connect msu@localhost on msu 3504 Query SET NAMES utf8 3504 Query set autocommit=0 3504 Query SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' AND `django_session`.`expire_date` > '2011-08-06 22:38:29' ) 3504 Quit 3505 Connect msu@localhost on msu 3505 Query SET NAMES utf8 3505 Query set autocommit=0 3505 Query SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' AND `django_session`.`expire_date` > '2011-08-06 22:38:29' ) 3505 Quit *** /tmp/mysql_with_1.0.txt 110806 22:31:29 3487 Connect msu@localhost on msu 3487 Query SET NAMES utf8 3487 Query set autocommit=0 110806 22:34:37 3487 Query SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' AND `django_session`.`expire_date` > '2011-08-06 22:34:37' ) 3487 Query SELECT `auth_user`.`id`, `auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`, `auth_user`.`email`, `auth_user`.`password`, `auth_user`.`is_staff`, `auth_user`.`is_active`, `auth_user`.`is_superuser`, `auth_user`.`last_login`, `auth_user`.`date_joined` FROM `auth_user` WHERE `auth_user`.`id` = 1 3487 Query SELECT `static_pages_staticpagetext`.`id`, `static_pages_staticpagetext`.`lang`, `static_pages_staticpagetext`.`content`, `static_pages_staticpagetext`.`name`, `static_pages_staticpagetext`.`page_id`, `static_pages_staticpage`.`id`, `static_pages_staticpage`.`parent_id`, `static_pages_staticpage`.`code`, `static_pages_staticpage`.`sort`, `static_pages_staticpage`.`url` FROM `static_pages_staticpagetext` INNER JOIN `static_pages_staticpage` ON (`static_pages_staticpagetext`.`page_id` = `static_pages_staticpage`.`id`) LEFT OUTER JOIN `static_pages_staticpage` T3 ON (`static_pages_staticpage`.`parent_id` = T3.`id`) WHERE (`static_pages_staticpagetext`.`lang` = 'ru' AND T3.`id` IS NULL) 3487 Query SELECT `quicklinks_quicklink`.`id`, `quicklinks_quicklink`.`lang`, `quicklinks_quicklink`.`name`, `quicklinks_quicklink`.`description`, `quicklinks_quicklink`.`url` FROM `quicklinks_quicklink` WHERE `quicklinks_quicklink`.`lang` = 'ru' LIMIT 21 3487 Query SELECT `quicklinks_quicklink`.`id`, `quicklinks_quicklink`.`lang`, `quicklinks_quicklink`.`name`, `quicklinks_quicklink`.`description`, `quicklinks_quicklink`.`url` FROM `quicklinks_quicklink` WHERE `quicklinks_quicklink`.`lang` = 'ru' LIMIT 21 3487 Query SELECT `quicklinks_quicklink`.`id`, `quicklinks_quicklink`.`lang`, `quicklinks_quicklink`.`name`, `quicklinks_quicklink`.`description`, `quicklinks_quicklink`.`url` FROM `quicklinks_quicklink` WHERE `quicklinks_quicklink`.`lang` = 'ru' 110806 22:34:38 3487 Query SELECT (1) AS `a` FROM `django_session` WHERE `django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' LIMIT 1 3487 Query UPDATE `django_session` SET `session_data` = 'MjJjZmU2Mjg1NDJjODhkYzBlNjA3Yzc1MGM2MWNmMzhhOGNhODI5OTqAAn1xAShVDV9hdXRoX3Vz\nZXJfaWRxAooBAVUPZGphbmdvX2xhbmd1YWdlcQNYAgAAAHJ1cQRVEl9hdXRoX3VzZXJfYmFja2Vu\nZHEFVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHEGdS4=\n', `expire_date` = '2011-08-20 22:34:38' WHERE `django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' 3487 Query commit 3487 Quit 3488 Connect msu@localhost on msu 3488 Query SET NAMES utf8 3488 Query set autocommit=0 3488 Query SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' AND `django_session`.`expire_date` > '2011-08-06 22:34:38' ) 3488 Quit 3489 Connect msu@localhost on msu 3489 Query SET NAMES utf8 3489 Query set autocommit=0 3489 Query SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '8c1e8f76a22b346bd8e4f53f8278a3bd' AND `django_session`.`expire_date` > '2011-08-06 22:34:38' ) 3489 Quit -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org