kmorozov
kmorozov
/ trace-with-prepare.json
Created
October 15, 2021 19:28
MySql optimizer trace. With prepared statement
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "steps": [ | |
| { | |
| "statement_parameters": [ | |
| "LONGLONG", | |
| "LONGLONG" | |
| ] | |
| }, | |
| { | |
| "join_optimization": { |
kmorozov
/ trace-no-prepare.json
Created
October 15, 2021 19:27
MySql optimizer trace. No prepared statement.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "steps": [ | |
| { | |
| "join_preparation": { | |
| "select#": 1, | |
| "steps": [ | |
| { | |
| "expanded_query": "/* select#1 */ select `samples`.`id` AS `id`,`samples`.`organization_id` AS `organization_id`,`samples`.`device_id` AS `device_id`,`samples`.`percent_remaining` AS `percent_remaining`,`samples`.`percent_remaining_2` AS `percent_remaining_2`,`samples`.`created_at` AS `created_at`,`samples`.`updated_at` AS `updated_at`,`samples`.`raw_reading` AS `raw_reading`,`samples`.`filtered_reading` AS `filtered_reading`,`samples`.`raw_reading_2` AS `raw_reading_2`,`samples`.`signal_strength` AS `signal_strength`,`samples`.`battery_reading` AS `battery_reading`,`samples`.`basestation_id` AS `basestation_id` from `samples` where ((`samples`.`device_id` = 5852) and (`samples`.`device_id` is not null) and (`samples`.`id` <> 188315308)) order by `samples`.`created_at` desc limit 1" | |
| } | |
| ] |
kmorozov
/ FeatPoints.user.js
Last active
October 15, 2018 18:09
Feat-costs plugin for Archive of Nethys
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // ==UserScript== | |
| // @name FeatCosts | |
| // @namespace com.dnineteen | |
| // @include http://www.aonprd.com/FeatDisplay.aspx* | |
| // @include http://www.aonprd.com/Feats.aspx | |
| // @include http://aonprd.com/FeatDisplay.aspx* | |
| // @include http://aonprd.com/Feats.aspx | |
| // @require http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js | |
| // @version 1.0.5 | |
| // |