{ "query": "EXPLAIN ANALYZE SELECT first_name, last_name, SUM(amount) AS total FROM staff INNER JOIN payment ON staff.staff_id = payment.staff_id AND payment_date LIKE '2005-08%' GROUP BY first_name, last_name;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "EXPLAIN ANALYZE SELECT first_name, last_name, SUM(amount) AS total FROM staff INNER JOIN payment ON staff.staff_id = payment.staff_id AND payment_date LIKE '2005-08%' GROUP BY first_name, last_name;", "len": 198, "last": 198, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "EXPLAIN", "value": "EXPLAIN", "keyword": "EXPLAIN", "type": 1, "flags": 3, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ANALYZE", "value": "ANALYZE", "keyword": "ANALYZE", "type": 1, "flags": 3, "position": 8 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 15 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 16 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "first_name", "value": "first_name", "keyword": null, "type": 0, "flags": 0, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "last_name", "value": "last_name", "keyword": null, "type": 0, "flags": 0, "position": 35 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 45 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUM", "value": "SUM", "keyword": "SUM", "type": 1, "flags": 33, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 49 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "amount", "value": "amount", "keyword": null, "type": 0, "flags": 0, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 57 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 58 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "total", "value": "total", "keyword": null, "type": 0, "flags": 0, "position": 61 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 66 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "staff", "value": "staff", "keyword": null, "type": 0, "flags": 0, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INNER JOIN", "value": "INNER JOIN", "keyword": "INNER JOIN", "type": 1, "flags": 7, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 88 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "payment", "value": "payment", "keyword": null, "type": 0, "flags": 0, "position": 89 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 96 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON", "value": "ON", "keyword": "ON", "type": 1, "flags": 3, "position": 97 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "staff", "value": "staff", "keyword": null, "type": 0, "flags": 0, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 105 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "staff_id", "value": "staff_id", "keyword": null, "type": 0, "flags": 0, "position": 106 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "payment", "value": "payment", "keyword": null, "type": 0, "flags": 0, "position": 117 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "staff_id", "value": "staff_id", "keyword": null, "type": 0, "flags": 0, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 133 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 134 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 137 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "payment_date", "value": "payment_date", "keyword": null, "type": 0, "flags": 0, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 150 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LIKE", "value": "LIKE", "keyword": "LIKE", "type": 1, "flags": 3, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 155 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'2005-08%'", "value": "2005-08%", "keyword": null, "type": 7, "flags": 1, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 166 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "GROUP BY", "value": "GROUP BY", "keyword": "GROUP BY", "type": 1, "flags": 7, "position": 167 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 175 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "first_name", "value": "first_name", "keyword": null, "type": 0, "flags": 0, "position": 176 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "last_name", "value": "last_name", "keyword": null, "type": 0, "flags": 0, "position": 188 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 197 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 57, "idx": 57 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "bodyParser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@6" }, { "@type": "@7" }, { "@type": "@8" }, { "@type": "@9" }, { "@type": "@10" }, { "@type": "@11" }, { "@type": "@12" }, { "@type": "@13" }, { "@type": "@14" }, { "@type": "@15" }, { "@type": "@16" }, { "@type": "@17" }, { "@type": "@18" }, { "@type": "@19" }, { "@type": "@20" }, { "@type": "@21" }, { "@type": "@22" }, { "@type": "@23" }, { "@type": "@24" }, { "@type": "@25" }, { "@type": "@26" }, { "@type": "@27" }, { "@type": "@28" }, { "@type": "@29" }, { "@type": "@30" }, { "@type": "@31" }, { "@type": "@32" }, { "@type": "@33" }, { "@type": "@34" }, { "@type": "@35" }, { "@type": "@36" }, { "@type": "@37" }, { "@type": "@38" }, { "@type": "@39" }, { "@type": "@40" }, { "@type": "@41" }, { "@type": "@42" }, { "@type": "@43" }, { "@type": "@44" }, { "@type": "@45" }, { "@type": "@46" }, { "@type": "@47" }, { "@type": "@48" }, { "@type": "@49" }, { "@type": "@50" }, { "@type": "@51" }, { "@type": "@52" }, { "@type": "@53" }, { "@type": "@54" }, { "@type": "@55" }, { "@type": "@56" }, { "@type": "@57" }, { "@type": "@58" } ], "count": 53, "idx": 53 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "first_name", "expr": "first_name", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "last_name", "expr": "last_name", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "SUM(amount)", "alias": "total", "function": "SUM", "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "staff", "column": null, "expr": "staff", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword", "type": null, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "first_name", "expr": "first_name", "alias": null, "function": null, "subquery": null } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword", "type": null, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "last_name", "expr": "last_name", "alias": null, "function": null, "subquery": null } } ], "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "type": "INNER", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "payment", "column": null, "expr": "payment", "alias": null, "function": null, "subquery": null }, "on": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "staff", "staff_id", "payment" ], "isOperator": false, "expr": "staff.staff_id = payment.staff_id" }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [], "isOperator": true, "expr": "AND" }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "payment_date", "2005-08%" ], "isOperator": false, "expr": "payment_date LIKE '2005-08%'" } ], "using": null } ], "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 50 } ], "brackets": 0, "strict": false, "errors": [] }, "statementAlias": "EXPLAIN ANALYZE", "connectionId": null, "explainedDatabase": null, "explainedTable": null, "explainedColumn": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 56 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }