{ "query": "SELECT * FROM address USE INDEX (idx_fk_city_id) FORCE KEY FOR GROUP BY (a, b,c) WHERE city_id<0", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "SELECT * FROM address USE INDEX (idx_fk_city_id) FORCE KEY FOR GROUP BY (a, b,c) WHERE city_id<0", "len": 97, "last": 97, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 6 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 8 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 9 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 10 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 14 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "address", "value": "address", "keyword": null, "type": 0, "flags": 0, "position": 15 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "USE", "value": "USE", "keyword": "USE", "type": 1, "flags": 3, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 26 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INDEX", "value": "INDEX", "keyword": "INDEX", "type": 1, "flags": 19, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 32 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "idx_fk_city_id", "value": "idx_fk_city_id", "keyword": null, "type": 0, "flags": 0, "position": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 49 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FORCE", "value": "FORCE", "keyword": "FORCE", "type": 1, "flags": 3, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "KEY", "value": "KEY", "keyword": "KEY", "type": 1, "flags": 19, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 59 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOR", "value": "FOR", "keyword": "FOR", "type": 1, "flags": 3, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 63 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "GROUP BY", "value": "GROUP BY", "keyword": "GROUP BY", "type": 1, "flags": 7, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "a", "value": "a", "keyword": null, "type": 0, "flags": 0, "position": 74 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 76 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "b", "value": "b", "keyword": null, "type": 0, "flags": 0, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "city_id", "value": "city_id", "keyword": null, "type": 0, "flags": 0, "position": 88 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "<", "value": "<", "keyword": null, "type": 2, "flags": 2, "position": 95 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 96 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 39, "idx": 39 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "*", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "address", "column": null, "expr": "address", "alias": null, "function": null, "subquery": null } ], "index_hints": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "type": "USE", "indexOrKey": "INDEX", "for": null, "indexes": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "(idx_fk_city_id)", "alias": null, "function": null, "subquery": null } ] }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "type": "FORCE", "indexOrKey": "KEY", "for": "GROUP BY", "indexes": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "(a, b,c)", "alias": null, "function": null, "subquery": null } ] } ], "partition": null, "where": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "city_id" ], "isOperator": false, "expr": "city_id<0" } ], "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 37 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }