Skip to content

Instantly share code, notes, and snippets.

/debug Secret

Created October 28, 2012 12:21
Show Gist options
  • Save anonymous/ccd6e536289e649c502a to your computer and use it in GitHub Desktop.
Save anonymous/ccd6e536289e649c502a to your computer and use it in GitHub Desktop.
LanguageLocalizedURL Pagination issue
Pages Loaded
/en/
/processwire/
/processwire/access/
/processwire/access/users/
/en/admin/access/users//
/processwire/access/roles/
/en/admin/access/roles//
/en/admin/access/roles//
/processwire/setup/
/processwire/setup/languages/
/en/admin/setup/languages/default/
/en/admin/setup/languages/deutsch/
/en/english/
/en/404-page-not-found/
/en/about/
/en/templates/
/en/site-map/
/en/search/
/trash/
/en/deutsch/
/en/products/
/en/admin/access/users//
/en/about/child-page-example-1/
/processwire/page/
/processwire/page/add/
/processwire/access/permissions/
/en/admin/access/permissions/change-templates-on-pages/
/en/admin/access/permissions/administer-users-role-must-also-have-template-edit-access/
Session
Array ( [Session] => Array ( [_user_id] => 41 [_user_challenge] => 1f0845a2899b1a6b19faf190c5a5c055 [_user_fingerprint] => 127.0.0.1Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4 [_token_name] => TOKEN894171494 [_TOKEN894171494] => 56ef5540fb603293f26436945dab501a49d765a7baaa2e1f9bf24412fd7357dd [ModulesUninstalled] => Array ( [0] => CommentFilterAkismet [1] => FieldtypeCache [2] => FieldtypeComments [3] => FieldtypePageTitleLanguage [4] => FieldtypeRepeater [5] => FieldtypeTextLanguage [6] => FieldtypeTextareaLanguage [7] => Helloworld [8] => InputfieldCommentsAdmin [9] => InputfieldPageAutocomplete [10] => InputfieldRepeater [11] => LanguageLocalizedURL [12] => LanguageSupportFields [13] => LazyCron [14] => MarkupCache [15] => MarkupPageFields [16] => MarkupRSS [17] => PagePathHistory [18] => ProcessForgotPassword [19] => ProcessPageClone [20] => TextformatterNewlineBR [21] => TextformatterNewlineUL [22] => TextformatterStripTags ) ) )
Modules Loaded
FieldtypeCheckbox: FieldtypeCheckbox
FieldtypeFieldsetClose: FieldtypeFieldsetClose
FieldtypeFieldsetOpen: FieldtypeFieldsetOpen
FieldtypeFieldsetTabOpen: FieldtypeFieldsetTabOpen
FieldtypeFloat: FieldtypeFloat
FieldtypePageTitle: FieldtypePageTitle
FieldtypePassword: FieldtypePassword
FieldtypeURL: FieldtypeURL
LanguageSupport: LanguageSupport
MarkupPageArray: MarkupPageArray
PagePermissions: PagePermissions
PageRender: PageRender
SessionLoginThrottle: SessionLoginThrottle
SystemUpdater: SystemUpdater
LanguageLocalizedURL: LanguageLocalizedURL
Queries
0. SELECT id, class, flags, data FROM modules ORDER BY class [89 rows] [0.0007s, 0.0007s, 0.000714063644409s]
1. SELECT data FROM modules WHERE id=139 [1 rows] [0.0003s, 0.001s, 0.0239350795746s]
2. SELECT fields.id,fields.type,fields.flags,fields.name,fields.label,fields.data FROM `fields` ORDER BY fields.name [13 rows] [0.0004s, 0.0014s, 0.058541059494s]
3. SELECT fieldgroups.id,fieldgroups.name,fieldgroups_fields.fields_id,fieldgroups_fields.data FROM `fieldgroups` LEFT JOIN fieldgroups_fields ON fieldgroups_fields.fieldgroups_id=fieldgroups.id ORDER BY sort [27 rows] [0.0026s, 0.004s, 0.0655970573425s]
4. SELECT templates.id,templates.name,templates.fieldgroups_id,templates.flags,templates.cache_time,templates.data FROM `templates` ORDER BY templates.name [11 rows] [0.0003s, 0.0043s, 0.0702791213989s]
5. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_email.data AS `email__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_email ON field_email.pages_id=pages.id WHERE pages.parent_id=29 AND pages.templates_id=3 AND pages.id IN(41) GROUP BY pages.id [1 rows] [0.0005s, 0.0048s, 0.0775339603424s]
6. SELECT id, templates_id FROM pages WHERE id=29 [1 rows] [0.0003s, 0.0051s, 0.0798690319061s]
7. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(29) GROUP BY pages.id [1 rows] [0.0004s, 0.0055s, 0.0808701515198s]
8. SELECT id, templates_id FROM pages WHERE id=28 [1 rows] [0.0003s, 0.0058s, 0.0813729763031s]
9. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(28) GROUP BY pages.id [1 rows] [0.0004s, 0.0062s, 0.0822520256042s]
10. SELECT id, templates_id FROM pages WHERE id=2 [1 rows] [0.0002s, 0.0064s, 0.0826990604401s]
11. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(2) GROUP BY pages.id [1 rows] [0.0004s, 0.0068s, 0.0835599899292s]
12. SELECT id, templates_id FROM pages WHERE id=1 [1 rows] [0.0001s, 0.0069s, 0.0839040279388s]
13. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_summary.data AS `summary__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_summary ON field_summary.pages_id=pages.id WHERE pages.templates_id=1 AND pages.id IN(1) GROUP BY pages.id [1 rows] [0.0004s, 0.0073s, 0.0849959850311s]
14. SELECT field_roles.data AS `roles__data` FROM `field_roles` WHERE field_roles.pages_id='41' ORDER BY sort [2 rows] [0.0003s, 0.0076s, 0.0893681049347s]
15. SELECT id, templates_id FROM pages WHERE id IN(37,38) [2 rows] [0.0002s, 0.0078s, 0.0898449420929s]
16. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id WHERE pages.templates_id=4 AND pages.id IN(37,38) GROUP BY pages.id [2 rows] [0.0004s, 0.0082s, 0.0905539989471s]
17. SELECT id, templates_id FROM pages WHERE id=30 [1 rows] [0.0002s, 0.0084s, 0.091511964798s]
18. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(30) GROUP BY pages.id [1 rows] [0.0003s, 0.0087s, 0.0923171043396s]
19. SELECT pages.id,pages.parent_id,pages.templates_id FROM `pages` WHERE (pages.templates_id=43) AND (pages.status<9999999) GROUP BY pages.id /* Selector: template=language, status<9999999 */ [2 rows] [0.0004s, 0.0091s, 0.097934961319s]
20. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id WHERE pages.templates_id=43 AND pages.id IN(1007,1009) GROUP BY pages.id [2 rows] [0.0014s, 0.0105s, 0.0998411178589s]
21. SELECT id, templates_id FROM pages WHERE id=1006 [1 rows] [0.0002s, 0.0107s, 0.100384950638s]
22. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(1006) GROUP BY pages.id [1 rows] [0.0004s, 0.0111s, 0.101359128952s]
23. SELECT id, templates_id FROM pages WHERE id=22 [1 rows] [0.0003s, 0.0114s, 0.101936101913s]
24. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(22) GROUP BY pages.id [1 rows] [0.0004s, 0.0118s, 0.102913141251s]
25. SELECT field_language.data AS `language__data` FROM `field_language` WHERE field_language.pages_id='41' ORDER BY sort [1 rows] [0.0003s, 0.0121s, 0.106174945831s]
26. SELECT pages.id,pages.parent_id,pages.templates_id FROM `pages` JOIN pages AS parent2 ON (pages.parent_id=parent2.id AND parent2.name='en') JOIN pages AS rootparent ON (parent2.parent_id=rootparent.id AND rootparent.id=1) WHERE pages.name='products' AND (pages.status<9999999) GROUP BY pages.id LIMIT 0,1 /* Selector: path=/en/products/, status<9999999, start=0, limit=1 */ [0 rows] [0.0004s, 0.0125s, 0.116519927979s]
27. SELECT pages.id,pages.parent_id,pages.templates_id FROM `pages` JOIN pages AS rootparent ON (pages.parent_id=rootparent.id AND rootparent.id=1) WHERE pages.name='en' AND (pages.status<9999999) GROUP BY pages.id LIMIT 0,1 /* Selector: path=/en/, status<9999999, start=0, limit=1 */ [1 rows] [0.0004s, 0.0129s, 0.118180036545s]
28. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id WHERE pages.templates_id=44 AND pages.id IN(1010) GROUP BY pages.id [1 rows] [0.0004s, 0.0133s, 0.119080066681s]
29. SELECT pages.id,pages.parent_id,pages.templates_id FROM `pages` WHERE (pages.name='default') AND (pages.parent_id=1006) AND (pages.templates_id=43) AND (pages.status<2048) GROUP BY pages.id LIMIT 0,1 /* Selector: name=default, parent_id=1006, template=language, status<2048, start=0, limit=1 */ [1 rows] [0.0004s, 0.0137s, 0.12414598465s]
30. SELECT pages.id,pages.parent_id,pages.templates_id FROM `pages` WHERE (pages.parent_id=1) AND (pages.status<2048) GROUP BY pages.id ORDER BY pages.sort /* Selector: parent_id=1, sort=sort, status<2048 */ [10 rows] [0.0004s, 0.0141s, 0.126841068268s]
31. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_summary.data AS `summary__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_summary ON field_summary.pages_id=pages.id WHERE pages.parent_id=1 AND pages.templates_id=29 AND pages.id IN(1001,1003,27) GROUP BY pages.id [3 rows] [0.0016s, 0.0157s, 0.129148960114s]
32. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_summary.data AS `summary__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_summary ON field_summary.pages_id=pages.id WHERE pages.parent_id=1 AND pages.templates_id=34 AND pages.id IN(1005) GROUP BY pages.id [1 rows] [0.0005s, 0.0162s, 0.13205909729s]
33. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id WHERE pages.parent_id=1 AND pages.templates_id=26 AND pages.id IN(1000) GROUP BY pages.id [1 rows] [0.0004s, 0.0166s, 0.133641958237s]
34. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.parent_id=1 AND pages.templates_id=2 AND pages.id IN(7) GROUP BY pages.id [1 rows] [0.0004s, 0.017s, 0.135226964951s]
35. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id WHERE pages.parent_id=1 AND pages.templates_id=44 AND pages.id IN(1011) GROUP BY pages.id [1 rows] [0.0005s, 0.0175s, 0.137495040894s]
36. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id WHERE pages.parent_id=1 AND pages.templates_id=45 AND pages.id IN(1012) GROUP BY pages.id [1 rows] [0.0008s, 0.0183s, 0.14005613327s]
37. SELECT data FROM modules WHERE id=86 [1 rows] [0.0003s, 0.0186s, 0.145576953888s]
38. SELECT pages.id,pages.parent_id,pages.templates_id FROM `pages` WHERE (pages.parent_id=1) AND (pages.status<1024) GROUP BY pages.id ORDER BY pages.sort /* Selector: parent_id=1, sort=sort, status<1024 */ [4 rows] [0.0006s, 0.0192s, 0.155261993408s]
39. SELECT field_images.data AS `images__data`,field_images.description AS `images__description` FROM `field_images` WHERE field_images.pages_id='1' ORDER BY sort [8 rows] [0.0004s, 0.0196s, 0.164057970047s]
40. SELECT field_sidebar.data AS `sidebar__data` FROM `field_sidebar` WHERE field_sidebar.pages_id='1' [1 rows] [0.0004s, 0.02s, 0.172842979431s]
41. SELECT SQL_CALC_FOUND_ROWS pages.id,pages.parent_id,pages.templates_id FROM `pages` LEFT JOIN field_title AS _sort_title ON _sort_title.pages_id=pages.id WHERE (pages.id>1) AND (pages.status<1024) GROUP BY pages.id ORDER BY _sort_title.data LIMIT 0,10 /* Selector: id>1, limit=10, sort=title, status<1024 */ [10 rows] [0.0015s, 0.0215s, 0.175930976868s]
42. SELECT FOUND_ROWS() [1 rows] [0.0002s, 0.0217s, 0.176399946213s]
43. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_email.data AS `email__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_email ON field_email.pages_id=pages.id WHERE pages.templates_id=3 AND pages.id IN(40) GROUP BY pages.id [1 rows] [0.0004s, 0.0221s, 0.177555084229s]
44. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_summary.data AS `summary__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_summary ON field_summary.pages_id=pages.id WHERE pages.templates_id=29 AND pages.id IN(1002) GROUP BY pages.id [1 rows] [0.0005s, 0.0226s, 0.179240942001s]
45. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(6) GROUP BY pages.id [1 rows] [0.0005s, 0.0231s, 0.181219100952s]
46. SELECT id, templates_id FROM pages WHERE id=3 [1 rows] [0.0003s, 0.0234s, 0.181774139404s]
47. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(3) GROUP BY pages.id [1 rows] [0.0004s, 0.0238s, 0.182719945908s]
48. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id WHERE pages.templates_id=5 AND pages.id IN(52,51) GROUP BY pages.id [2 rows] [0.0004s, 0.0242s, 0.184975147247s]
49. SELECT id, templates_id FROM pages WHERE id=31 [1 rows] [0.0003s, 0.0245s, 0.186234951019s]
50. SELECT false AS isLoaded, pages.templates_id AS templates_id, pages.*, pages_sortfields.sortfield, (SELECT COUNT(*) FROM pages AS children WHERE children.parent_id=pages.id) AS numChildren,field_title.data AS `title__data`,field_process.data AS `process__data` FROM `pages` LEFT JOIN pages_sortfields ON pages_sortfields.pages_id=pages.id LEFT JOIN field_title ON field_title.pages_id=pages.id LEFT JOIN field_process ON field_process.pages_id=pages.id WHERE pages.templates_id=2 AND pages.id IN(31) GROUP BY pages.id [1 rows] [0.0015s, 0.026s, 0.188631057739s]
Fuel
wire
config
notices
sanitizer
db
modules
fieldtypes
fields
fieldgroups
templates
pages
permissions
roles
users
user
session
input
languages
process
page
User (root)
CURRENT USER'S ROLES
guest
superuser
CURRENT USER'S PERMISSIONS
page-delete
page-edit
page-lock
page-move
page-sort
page-template
page-view
profile-edit
user-admin
CURRENT USER'S PERMISSIONS ON THIS PAGE
page-delete
page-edit
page-lock
page-move
page-sort
page-template
page-view
profile-edit
user-admin
$_POST
Array
(
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment