Ticket #5043: debug_local_nom.htm

File debug_local_nom.htm, 2.9 KB (added by emilio.mejia@…, 5 years ago)

Debug for local query

Line 
1string(130) "select word_id,word_token, word, class, type, country_code, operator, search_name_count from word where word_token in (' co','co')"
2array(1) {
3  [0]=>
4  array(3) {
5    ["string"]=>
6    string(2) "co"
7    ["words"]=>
8    array(1) {
9      [0]=>
10      string(2) "co"
11    }
12    ["wordsets"]=>
13    array(1) {
14      [0]=>
15      array(1) {
16        [0]=>
17        string(2) "co"
18      }
19    }
20  }
21}
22array(1) {
23  ["co"]=>
24  array(1) {
25    [0]=>
26    array(8) {
27      ["word_id"]=>
28      string(4) "7616"
29      ["word_token"]=>
30      string(2) "co"
31      ["word"]=>
32      NULL
33      ["class"]=>
34      NULL
35      ["type"]=>
36      NULL
37      ["country_code"]=>
38      NULL
39      ["operator"]=>
40      NULL
41      ["search_name_count"]=>
42      string(6) "270352"
43    }
44  }
45}
46array(1) {
47  [2]=>
48  array(1) {
49    [0]=>
50    array(16) {
51      ["iSearchRank"]=>
52      int(2)
53      ["iNamePhrase"]=>
54      int(0)
55      ["sCountryCode"]=>
56      bool(false)
57      ["aName"]=>
58      array(0) {
59      }
60      ["aAddress"]=>
61      array(0) {
62      }
63      ["aFullNameAddress"]=>
64      array(0) {
65      }
66      ["aNameNonSearch"]=>
67      array(1) {
68        [7616]=>
69        string(4) "7616"
70      }
71      ["aAddressNonSearch"]=>
72      array(0) {
73      }
74      ["sOperator"]=>
75      string(0) ""
76      ["aFeatureName"]=>
77      array(0) {
78      }
79      ["sClass"]=>
80      string(0) ""
81      ["sType"]=>
82      string(0) ""
83      ["sHouseNumber"]=>
84      string(0) ""
85      ["fLat"]=>
86      float(10.361465)
87      ["fLon"]=>
88      float(-84.476996666667)
89      ["fRadius"]=>
90      float(0.1)
91    }
92  }
93}
94<table border="1"><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>house#</th><th>Lat</th><th>Lon</th><th>Radius</th></tr><tr><td>2</td><td></td><td>#co(7616)#</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10.361465</td><td>-84.476996666667</td><td>0.1</td></tr></table><hr><b>Search Loop, group 1, loop 1</b><table border="1"><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>house#</th><th>Lat</th><th>Lon</th><th>Radius</th></tr><tr><td>2</td><td></td><td>#co(7616)#</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10.361465</td><td>-84.476996666667</td><td>0.1</td></tr></table>string(469) "select place_id from search_name where array_cat(name_vector,ARRAY[]::integer[]) @> ARRAY[7616] and ST_DWithin(centroid, ST_SetSRID(ST_Point(-84.476996666667,10.361465),4326), 0.1) order by ST_Distance(centroid, ST_SetSRID(ST_Point(-84.476996666667,10.361465),4326)) ASC, ST_Distance(ST_SetSRID(ST_Point(-84.476996666667,10.361465),4326), centroid) asc, (case when importance = 0 OR importance IS NULL then 0.75-(search_rank::float/40) else importance end) DESC limit 2"
95<br><b>Place IDs:</b> array(0) {
96}