3 <a href="{{ url("webprofiler.dashboard", {profile: token}, {fragment: 'database'}) }}" title="{{ 'Database'|t }}">
4 <img width="20" height="28" alt="{{ 'Database'|t }}"
5 src="data:image/png;base64,{{ collector.icon }}"/>
6 <span class="sf-toolbar-info-piece-additional sf-toolbar-status sf-toolbar-status-{{ collector.colorCode }}">{{ collector.querycount }}</span>
7 {% if collector.querycount > 0 %}
8 <span class="sf-toolbar-info-piece-additional-detail">in {{ '%0.2f ms'|format(collector.time) }}</span>
13 <div class="sf-toolbar-info-piece">
14 <b>{{ 'DB Queries'|t }}</b>
15 <span>{{ collector.querycount }}</span>
17 <div class="sf-toolbar-info-piece">
18 <b>{{ 'Query time'|t }}</b>
19 <span>{{ '%0.2f ms'|format(collector.time) }}</span>
21 <div class="sf-toolbar-info-piece">
22 <b>{{ 'Default database'|t }}</b>
23 <span>{{ collector.database.driver }}://{{ collector.database.host }}:{{ collector.database.port }}
24 /{{ collector.database.database }}</span>
28 <div class="sf-toolbar-block">
29 <div class="sf-toolbar-icon">{{ icon|default('') }}</div>
30 <div class="sf-toolbar-info">{{ text|default('') }}</div>
35 <script id="database" type="text/template">
36 <h2 class="panel__title">{{ 'Database'|t }}</h2>
38 <form class="panel__toolbar">
39 <div class="panel__filter--text">
40 <input id="edit-caller" class="js--live-filter" placeholder="{{ 'Caller'|t }}" type="text"/>
41 <label for="edit-caller" class="panel__filter-label">{{ 'Caller'|t }}</label>
43 <div class="panel__filter--select">
44 <select id="edit-type" class="js--live-filter">
45 <option value="">{{ 'Any'|t }}</option>
46 <option value="select">Select</option>
47 <option value="insert">Insert</option>
48 <option value="update">Update</option>
49 <option value="create">Create</option>
50 <option value="delete">Delete</option>
52 <label for="edit-type" class="panel__filter-label">{{ 'Query type'|t }}</label>
54 <div class="panel__filter--select">
55 <select id="edit-hightlighted" class="js--live-filter">
56 <option value="">{{ 'Any'|t }}</option>
57 <option value="1">{{ 'Yes'|t }}</option>
58 <option value="0">{{ 'No'|t }}</option>
60 <label for="edit-type" class="panel__filter-label">{{ 'Slow queryes'|t }}</label>
62 <div class="panel__filter--select">
63 <select id="edit-database" class="js--live-filter">
64 <option value="">{{ 'Any'|t }}</option>
65 <% _.each(data.connections, function( item ){ %>
66 <option value="<%- item %>"><%- item %></option>
69 <label for="edit-database" class="panel__filter-label">{{ 'Database'|t }}</label>
72 <div class="button--flat l-right js--code-toggle--global js--placeholder-visible">{{ 'Swap Placeholders'|t }}</div>
76 <% _.each( data.queries, function( item, key ){ %>
77 <div class="panel__container<% if (item.time > data.query_highlight_threshold) { %> is--hightlighted <% } %>"
78 data-wp-caller="<%- item.caller.class != null ? item.caller.class.toLowerCase() : '' %>"
79 data-wp-database="<%- item.database %>"
80 data-wp-type="<%- item.type %>"
81 data-wp-hightlighted="<%- (item.time > data.query_highlight_threshold) ? '1' : '0' %>">
82 <div class="panel__expand-header ">
83 <pre <% if( item.query_args) { %> class="js--code-target"<% } %> >
84 <code class="sql js--placeholder-query">
87 <% if( item.query_args) { %>
88 <code class="sql js--clipboard-target is--hidden js--original-query">
89 <%- item.query_args %>
93 <ul class="list--inline">
94 <li><b>{{ 'Time'|t }}</b>: <%- Drupal.webprofiler.helpers.printTime(item.time) %></li>
95 <li><b>{{ 'Caller'|t }}</b>: <%= Drupal.webprofiler.helpers.classLink({"file" : item.caller.file,
96 "class" : item.caller.class, "line" : item.caller.line, "method" : item.caller.function}) %>
98 <li><b>{{ 'Database'|t }}</b>: <%- item.database %></li>
99 <li><b>{{ 'Target'|t }}</b>: <%- item.target %></li>
102 <% if(item.query_args){ %>
103 <div class="button--flat l-right js--code-toggle">{{ 'Swap Placeholders'|t }}</div>
106 <div class="button--flat l-right js--panel-toggle">{{ 'Info'|t }}</div>
108 <!--div class="button--flat l-right js--clipboard-trigger">{{ 'Copy Query'|t }}</div-->
109 <% if(item.explain){ %>
110 <div class="button--flat l-right js--explain-trigger"
111 data-wp-queryPosition="<%- key %>"
112 >{{ 'Explain'|t }}</div>
116 <% if(item.explain){ %>
117 <div class="loader--linear js--loader" style="display: none">
118 <div class="loader__bar"></div>
119 <div class="loader__bar"></div>
120 <div class="loader__bar"></div>
122 <div class="panel__expand-content js--explain-target"></div>
126 <div class="panel__expand-content">
127 <div class="wp-query-arguments">
128 <table class="table--duo">
131 <th>{{ 'placeholder'|t }}</th>
132 <th>{{ 'value'|t }}</th>
136 <% _.each( item.args, function( item, key ){ %>
139 <td><%= Drupal.webprofiler.helpers.frm(item) %></td>
150 <script id="wp-query-explain-template" type="text/template">
151 <table class="table--compact">
154 <% _.each(rc.data[1], function(value, key, list) { %>
159 <% _.each(rc.data, function(value) { %>
161 <% _.each(value, function(value2, key, list) { %>
162 <td><%= value2 %></td>