Alphabétique
1 mots sur un total de 1, p. 1/1
- ← Précédent
- Suivant →
Warning (2): Declaration of WordsController::paginate($conditions, $none_dictionary) should be compatible with Controller::paginate($object = NULL, $scope = Array, $whitelist = Array) [APP/Controller/WordsController.php, line 4]
Notice (8): Indirect modification of overloaded property WordsController::$Paginator has no effect [APP/Controller/WordsController.php, line 10]
Warning (2): Creating default object from empty value [APP/Controller/WordsController.php, line 10]
Notice (8): Undefined offset: 112 [APP/Controller/WordsController.php, line 51]
Alphabétique
1 mots sur un total de 1, p. 1/1
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Type`.`id`, `Type`.`type` FROM `jvconsul_gdfjprod`.`types` AS `Type` WHERE 1 = 1 | 19 | 19 | 0 | |
2 | SELECT COUNT(DISTINCT words.id) as count FROM words LEFT JOIN `words_dictionaries` ON `words_dictionaries`.`word_id` = `words`.`id` LEFT JOIN `dictionaries` ON `dictionaries`.`id` = `words_dictionaries`.`dictionary_id` LEFT JOIN `words_origins` ON `words_origins`.`word_id` = `words`.`id` LEFT JOIN `origins` ON `origins`.`id` = `words_origins`.`origin_id` LEFT JOIN `words_regions` ON `words_regions`.`word_id` = `words`.`id` LEFT JOIN `regions` ON `regions`.`id` = `words_regions`.`region_id` LEFT JOIN `words_types` ON `words_types`.`word_id` = `words`.`id` LEFT JOIN `types` ON `types`.`id` = `words_types`.`type_id` WHERE origins.id = 112 | 1 | 1 | 1 | |
3 | SELECT words.id, words.spelling, GROUP_CONCAT(DISTINCT definitions.id) as definitions, GROUP_CONCAT(DISTINCT dictionaries.dictionary ORDER BY dictionaries.dictionary ASC SEPARATOR ', ') as dictionaries, GROUP_CONCAT(DISTINCT origins.origin ORDER BY origins.origin ASC SEPARATOR ', ') as origins, GROUP_CONCAT(DISTINCT types.type ORDER BY types.type ASC SEPARATOR ', ') as types, GROUP_CONCAT(DISTINCT regions.region ORDER BY regions.region ASC SEPARATOR ', ') as regions FROM words LEFT JOIN `definitions` ON `definitions`.`word_id` = `words`.`id` LEFT JOIN `words_dictionaries` ON `words_dictionaries`.`word_id` = `words`.`id` LEFT JOIN `dictionaries` ON `dictionaries`.`id` = `words_dictionaries`.`dictionary_id` LEFT JOIN `words_origins` ON `words_origins`.`word_id` = `words`.`id` LEFT JOIN `origins` ON `origins`.`id` = `words_origins`.`origin_id` LEFT JOIN `words_types` ON `words_types`.`word_id` = `words`.`id` LEFT JOIN `types` ON `types`.`id` = `words_types`.`type_id` LEFT JOIN `words_regions` ON `words_regions`.`word_id` = `words`.`id` LEFT JOIN `regions` ON `regions`.`id` = `words_regions`.`region_id` WHERE words.id IN( SELECT words.id FROM words LEFT JOIN `words_dictionaries` ON `words_dictionaries`.`word_id` = `words`.`id` LEFT JOIN `dictionaries` ON `dictionaries`.`id` = `words_dictionaries`.`dictionary_id` LEFT JOIN `words_origins` ON `words_origins`.`word_id` = `words`.`id` LEFT JOIN `origins` ON `origins`.`id` = `words_origins`.`origin_id` LEFT JOIN `words_types` ON `words_types`.`word_id` = `words`.`id` LEFT JOIN `types` ON `types`.`id` = `words_types`.`type_id` LEFT JOIN `words_regions` ON `words_regions`.`word_id` = `words`.`id` LEFT JOIN `regions` ON `regions`.`id` = `words_regions`.`region_id` WHERE origins.id = 112 ) GROUP BY words.id ORDER BY words.spelling LIMIT 0, 10 | 1 | 1 | 2 | |
4 | SELECT `Definition`.`id`, `Definition`.`definition` FROM `jvconsul_gdfjprod`.`definitions` AS `Definition` WHERE word_id IN(1761) | 1 | 1 | 0 |
No post data.
To view Cookies, add CookieComponent to Controller
Peak Memory Use 5.83 MB
Message | Memory use |
---|---|
Component initialization | 2.90 MB |
Controller action start | 3.10 MB |
Controller render start | 4.48 MB |
View render complete | 5.25 MB |
Total Request Time: 84 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 35.00 | |
Event: Controller.initialize | 0.06 | |
Event: Controller.startup | 2.44 | |
Controller action | 30.09 | |
Event: Controller.beforeRender | 3.04 | |
» Processing toolbar data | 2.97 | |
Rendering View | 5.93 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Words/browse.ctp | 4.38 | |
» » Rendering APP/View/Elements/user_bar.ctp | 0.11 | |
» » Rendering APP/View/Elements/pagination.ctp | 0.16 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/default.ctp | 0.85 | |
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp | 0.32 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/Config/' |
Constant | Value |
---|---|
APP | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/' |
APP_DIR | 'app' |
APPLIBS | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/Lib/' |
CACHE | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/tmp/cache/' |
CAKE | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/lib' |
CORE_PATH | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/lib/' |
CAKE_VERSION | '2.10.13' |
CSS | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'https://gdfj.jewish-languages.org' |
IMAGES | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/tmp/logs/' |
ROOT | '/home/jvconsul/JewishLanguages/cakephp2-gdfj' |
TESTS | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/Test/' |
TMP | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/tmp/' |
VENDORS | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '7.0.33' |
Context Document Root | '/home/jvconsul/JewishLanguages/cakephp2-gdfj' |
Context Prefix | '' |
Document Root | '/home/jvconsul/JewishLanguages/cakephp2-gdfj' |
Gateway Interface | 'CGI/1.1' |
Https | 'on' |
Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
Http Accept Encoding | 'gzip' |
Http Authorization | '' |
Http Connection | 'Keep-Alive' |
Http Host | 'gdfj.jewish-languages.org' |
Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
Path | '/bin:/usr/bin' |
Query String | 'origin=112' |
Redirect Https | 'on' |
Redirect Http Authorization | '' |
Redirect Query String | 'origin=112' |
Redirect Redirect Https | 'on' |
Redirect Redirect Ssl Tls Sni | 'gdfj.jewish-languages.org' |
Redirect Redirect Status | '200' |
Redirect Redirect Unique Id | 'XG9dL0F4HOiVIP43furRzgAAAUk' |
Redirect Ssl Tls Sni | 'gdfj.jewish-languages.org' |
Redirect Status | '200' |
Redirect Unique Id | 'XG9dL0F4HOiVIP43furRzgAAAUk' |
Redirect Url | '/app/webroot/words' |
Remote Addr | '34.207.152.62' |
Remote Port | '56726' |
Request Method | 'GET' |
Request Scheme | 'https' |
Request Uri | '/words?origin=112' |
Script Filename | '/home/jvconsul/JewishLanguages/cakephp2-gdfj/app/webroot/index.php' |
Script Name | '/app/webroot/index.php' |
Server Addr | '66.198.240.41' |
Server Admin | 'webmaster@gdfj.jewish-languages.org' |
Server Name | 'gdfj.jewish-languages.org' |
Server Port | '443' |
Server Protocol | 'HTTP/1.1' |
Server Signature | '' |
Server Software | 'Apache' |
Ssl Tls Sni | 'gdfj.jewish-languages.org' |
Unique Id | 'XG9dL0F4HOiVIP43furRzgAAAUk' |
Php Self | '/app/webroot/index.php' |
Request Time Float | (float) 1550802223.5409 |
Request Time | (int) 1550802223 |