File manager - Edit - /home/opticamezl/www/newok/sqlqueries.tar
Back
widget.min.js.gz 0000644 00000002760 15175452402 0007600 0 ustar 00 � �Wmo�8�~��W����&�a���܇ (��u�%W�����AR�$�/A-��C���u#˕Ē쟨�L������Au�X.LV��PS�Q]��IWTO��m�� "i=2�7�����܀�`����-H�����|���̣x���J�Ʌ}/x�s� {��Y���w��`υh0D�����rjKn�WV)��:[sɜj����$�c`�-J�1����Ɣ��h�%i�������_JJ�v9J���Z���H����1>`���(դM��W��^)��(��G��i-" � �lߒ�� ���*� ��v(�UU�`T�I� m1r)�E��9�ȪȖGWij�r_(i��L� FUmҨ�t%����M�w��=_��"\S���d��.+4P���~�r�LiV�'���pjN�9I� ������K�����H�{� �A1�W҂�Ɓ_@�$��<y+�77�%=�X �������)`W$}7̠�9c�mL.1�1��̑��^@��2�u �}S�p_�8���%1��{�sP���V�/�������mt��͍ �=�P}�C�)�*q~�J�ܣp���G�7���b�̣H�}$��5�:�cuK|=35���V@���(��_�鏆Һ c��TP)����E����L<=֘��jP�2���j�����}Q�ȋ/�i��Y���@gle8d��9�' �O��ե��_�.�� &� <8@�^j�a����w�K٣����Gv�m�r4�&�̸|�5ݍP҂��u�"̌#�f���[�{�)�Q�"JG�j40��%� :ݽ�� ����y�2S�-&�L�¸��z��d��UJћ�Bu�̓i�� �q5<�clG�����.�;�߾���-u�%�J �g�W$h�'���g�%R��f�y��6=�/m�F)��>c��BN�x�D�2cU�I��nh�Y{Z�5մ2q|%3n�W��}\���QD�@�κ�;�Y=��2*�p��� ��ʳ[�g7N~tO� �'mr�V��qu�]���.�rt��1?��:8�"�����mY�V�Hr��� M�g7���<Q�tJ�u"S�bJ|:��ϸ�������<+9L��[Ҷ�K�K�s�%{�_��(��[?���Q��[��6Z^��ǰ�K�u]������i�|ߦ<�Mi~���v�fC��T%I� ���t�pzz�b�]V$q�Y��h��^�L�^�����`������;s�X��0s_�K*��d��_�^�ؤȞ&��qwC�R���F.n�r��'n�cϺP˳�cZ�Z7Cg��eH���囔����S�D[��E���ߎ�ru� ]�֔`�8>�'Fi���Z ��:ږ�(� t{~�1�y��8�`ce������=R߷���A-���b5�箽�����:b��x���:lK~��yg~m';g!�����v�Wd����YGi widget.min.css.gz 0000644 00000001374 15175452402 0007754 0 ustar 00 � �W�j�0~�һh8eY�|��ѫ�~�X:NDeU�k�&P6Ʈ��=�^a$q�$������R���b�c�_�\�� ���Y�i1M��R�)���)�)�Q�y�P�Z�&�O��q����:*��',?IJN�c)�@9�*N���)���7�J22�e�+=�/�����B�^��?�E&Z^^��4���)tÜy�X%��,��8^`�V�7�y�):G�q�Cy�o��ޑ ��N ��=�@r���;A8*��N(�� �lJ�d'(�3M�[2#i�;�L��T�1|b�C��UV��e<���8�%�Jx���|�+遂����z�S��S6��Z��M�� ۍs�M<��)!���_�5��3����%��DOyӧ��C>:;��J�Z� h��y?X�H�-�?ݐw�����G7�}�lA�� z/�[:�����m��I�Tc�%r_7� ��z�_�AmB+�3~�6-���g5���0��aad� ��.�t��"���@���wg��ḲO3i=��ܸ9�$��$>�A]�T@���Y�&t�.�T�~��!\���L����/6p��da��~\7X�TQb��G<�-}ҢD��.d �)���)#��ݵ*˚����N�$��ZU�LU(�f�{P&���L逮m�^����� !�۠� ��MY��3[m��3[E����*�% jҡ%��q�)V ]H��r�b�ZD\�83�ng widget.min.js 0000644 00000007551 15175452402 0007164 0 ustar 00 (function(n){var s=PhpDebugBar.utils.makecsscls("phpdebugbar-widgets-"),p=PhpDebugBar.Widgets.SQLQueriesWidget=PhpDebugBar.Widget.extend({className:s("sqlqueries"),onFilterClick:function(c){n(c).toggleClass(s("excluded"));var r=[];this.$toolbar.find(s(".filter")+s(".excluded")).each(function(){r.push(this.rel)}),this.$list.$el.find("li[connection="+n(c).attr("rel")+"]").toggle(),this.set("exclude",r)},onCopyToClipboard:function(c){var r=n(c).parent("li").find("code").get(0),t=function(){try{document.execCommand("copy"),alert("Query copied to the clipboard")}catch{console.log("Oops, unable to copy")}},e=function(i){if(document.selection){var a=document.body.createTextRange();a.moveToElementText(i),a.select()}else if(window.getSelection){var a=document.createRange();a.selectNodeContents(i),window.getSelection().removeAllRanges(),window.getSelection().addRange(a)}t(),window.getSelection().removeAllRanges()};e(r)},render:function(){this.$status=n("<div />").addClass(s("status")).appendTo(this.$el),this.$toolbar=n("<div></div>").addClass(s("toolbar")).appendTo(this.$el);var c=[],r=this;this.$list=new PhpDebugBar.Widgets.ListWidget({itemRenderer:function(t,e){if(n("<code />").addClass(s("sql")).html(PhpDebugBar.Widgets.highlight(e.sql,"sql")).appendTo(t),e.duration_str&&n('<span title="Duration" />').addClass(s("duration")).text(e.duration_str).appendTo(t),e.memory_str&&n('<span title="Memory usage" />').addClass(s("memory")).text(e.memory_str).appendTo(t),typeof e.row_count<"u"&&n('<span title="Row count" />').addClass(s("row-count")).text(e.row_count).appendTo(t),typeof e.stmt_id<"u"&&e.stmt_id&&n('<span title="Prepared statement ID" />').addClass(s("stmt-id")).text(e.stmt_id).appendTo(t),e.connection&&(n('<span title="Connection" />').addClass(s("database")).text(e.connection).appendTo(t),t.attr("connection",e.connection),n.inArray(e.connection,c)==-1&&(c.push(e.connection),n("<a />").addClass(s("filter")).text(e.connection).attr("rel",e.connection).on("click",function(){r.onFilterClick(this)}).appendTo(r.$toolbar),c.length>1&&(r.$toolbar.show(),r.$list.$el.css("margin-bottom","20px")))),typeof e.is_success<"u"&&!e.is_success&&(t.addClass(s("error")),t.append(n("<span />").addClass(s("error")).text("["+e.error_code+"] "+e.error_message))),n('<span title="Copy to clipboard" />').addClass(s("copy-clipboard")).css("cursor","pointer").on("click",function(o){r.onCopyToClipboard(this),o.stopPropagation()}).appendTo(t),e.params&&!n.isEmptyObject(e.params)){var i=n('<table><tr><th colspan="2">Params</th></tr></table>').addClass(s("params")).appendTo(t);for(var a in e.params)typeof e.params[a]!="function"&&i.append('<tr><td class="'+s("name")+'">'+a+'</td><td class="'+s("value")+'">'+e.params[a]+"</td></tr>");t.css("cursor","pointer").click(function(){i.is(":visible")?i.hide():i.show()})}}}),this.$list.$el.appendTo(this.$el),this.bindAttr("data",function(t){if(t.length<=0)return!1;this.$list.set("data",t.statements),this.$status.empty();for(var e={},i=0,a=0,o=0;o<t.statements.length;o++){var d=t.statements[o].sql;t.statements[o].params&&!n.isEmptyObject(t.statements[o].params)&&(d+=" {"+n.param(t.statements[o].params,!1)+"}"),e[d]=e[d]||{keys:[]},e[d].keys.push(o)}for(var d in e)if(e[d].keys.length>1){a+=e[d].keys.length;for(var o=0;o<e[d].keys.length;o++)this.$list.$el.find("."+s("list-item")).eq(e[d].keys[o]).addClass(s("sql-duplicate"))}else i++;var l=n("<span />").text(t.nb_statements+" statements were executed").appendTo(this.$status);t.nb_failed_statements&&l.append(", "+t.nb_failed_statements+" of which failed"),a&&(l.append(", "+a+" of which were duplicates"),l.append(", "+i+" unique")),t.accumulated_duration_str&&this.$status.append(n('<span title="Accumulated duration" />').addClass(s("duration")).text(t.accumulated_duration_str)),t.memory_usage_str&&this.$status.append(n('<span title="Memory usage" />').addClass(s("memory")).text(t.memory_usage_str))})}})})(PhpDebugBar.$); widget.min.css 0000644 00000007547 15175452402 0007345 0 ustar 00 @charset "UTF-8";div.phpdebugbar-widgets-sqlqueries .phpdebugbar-widgets-status{color:#555;background:#fafafa;border-bottom:1px solid #ddd;padding:6px;font-family:SFMono-Regular,Consolas,Liberation Mono,Menlo,Courier,monospace;font-weight:700}div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item.phpdebugbar-widgets-error{color:red}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-database,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-duration,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-memory,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-row-count,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-copy-clipboard,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-stmt-id{float:right;color:#888;margin-left:8px}div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-database,div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-duration,div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-memory,div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-row-count,div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-copy-clipboard,div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-stmt-id{color:#555}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-database:before,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-duration:before,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-memory:before,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-row-count:before,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-copy-clipboard:before,div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-stmt-id:before{margin-right:4px;font-family:PhpDebugbarFontAwesome;font-size:12px}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-database:before{content:""}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-duration:before{content:""}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-memory:before{content:""}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-row-count:before{content:""}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-stmt-id:before{content:""}div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-copy-clipboard:before{content:""}div.phpdebugbar-widgets-sqlqueries table.phpdebugbar-widgets-params{border-collapse:collapse;border:1px solid #ddd;width:70%;margin:10px;font-family:SFMono-Regular,Consolas,Liberation Mono,Menlo,Courier,monospace;display:none}div.phpdebugbar-widgets-sqlqueries table.phpdebugbar-widgets-params td{text-align:center;border:1px solid #ddd}div.phpdebugbar-widgets-sqlqueries table.phpdebugbar-widgets-params .phpdebugbar-widgets-name{width:20%;font-weight:700}div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item span.phpdebugbar-widgets-error{font-weight:700;display:block}code.phpdebugbar-widgets-sql{white-space:pre-wrap;overflow-wrap:break-word;word-wrap:break-word}div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item.phpdebugbar-widgets-sql-duplicate{background-color:#edeff0}div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item.phpdebugbar-widgets-sql-duplicate:hover{background-color:#ffc}div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-toolbar{z-index:1;background:#fff;width:100%;display:none;position:fixed;bottom:0}div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-toolbar a.phpdebugbar-widgets-filter{float:right;color:#fff;background:#7cacd5;border-radius:4px;margin:0 2px;padding:2px 4px;font-size:12px;text-decoration:none}div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-toolbar a.phpdebugbar-widgets-filter.phpdebugbar-widgets-excluded{color:#888;background:#eee} widget.js 0000644 00000017336 15175452402 0006404 0 ustar 00 (function($) { var csscls = PhpDebugBar.utils.makecsscls('phpdebugbar-widgets-'); /** * Widget for the displaying sql queries * * Options: * - data */ var SQLQueriesWidget = PhpDebugBar.Widgets.SQLQueriesWidget = PhpDebugBar.Widget.extend({ className: csscls('sqlqueries'), onFilterClick: function(el) { $(el).toggleClass(csscls('excluded')); var excludedLabels = []; this.$toolbar.find(csscls('.filter') + csscls('.excluded')).each(function() { excludedLabels.push(this.rel); }); this.$list.$el.find("li[connection=" + $(el).attr("rel") + "]").toggle(); this.set('exclude', excludedLabels); }, onCopyToClipboard: function (el) { var code = $(el).parent('li').find('code').get(0); var copy = function () { try { document.execCommand('copy'); alert('Query copied to the clipboard'); } catch (err) { console.log('Oops, unable to copy'); } }; var select = function (node) { if (document.selection) { var range = document.body.createTextRange(); range.moveToElementText(node); range.select(); } else if (window.getSelection) { var range = document.createRange(); range.selectNodeContents(node); window.getSelection().removeAllRanges(); window.getSelection().addRange(range); } copy(); window.getSelection().removeAllRanges(); }; select(code); }, render: function() { this.$status = $('<div />').addClass(csscls('status')).appendTo(this.$el); this.$toolbar = $('<div></div>').addClass(csscls('toolbar')).appendTo(this.$el); var filters = [], self = this; this.$list = new PhpDebugBar.Widgets.ListWidget({ itemRenderer: function(li, stmt) { $('<code />').addClass(csscls('sql')).html(PhpDebugBar.Widgets.highlight(stmt.sql, 'sql')).appendTo(li); if (stmt.duration_str) { $('<span title="Duration" />').addClass(csscls('duration')).text(stmt.duration_str).appendTo(li); } if (stmt.memory_str) { $('<span title="Memory usage" />').addClass(csscls('memory')).text(stmt.memory_str).appendTo(li); } if (typeof(stmt.row_count) != 'undefined') { $('<span title="Row count" />').addClass(csscls('row-count')).text(stmt.row_count).appendTo(li); } if (typeof(stmt.stmt_id) != 'undefined' && stmt.stmt_id) { $('<span title="Prepared statement ID" />').addClass(csscls('stmt-id')).text(stmt.stmt_id).appendTo(li); } if (stmt.connection) { $('<span title="Connection" />').addClass(csscls('database')).text(stmt.connection).appendTo(li); li.attr("connection",stmt.connection); if ( $.inArray(stmt.connection, filters) == -1 ) { filters.push(stmt.connection); $('<a />') .addClass(csscls('filter')) .text(stmt.connection) .attr('rel', stmt.connection) .on('click', function() { self.onFilterClick(this); }) .appendTo(self.$toolbar); if (filters.length>1) { self.$toolbar.show(); self.$list.$el.css("margin-bottom","20px"); } } } if (typeof(stmt.is_success) != 'undefined' && !stmt.is_success) { li.addClass(csscls('error')); li.append($('<span />').addClass(csscls('error')).text("[" + stmt.error_code + "] " + stmt.error_message)); } $('<span title="Copy to clipboard" />') .addClass(csscls('copy-clipboard')) .css('cursor', 'pointer') .on('click', function (event) { self.onCopyToClipboard(this); event.stopPropagation(); }) .appendTo(li); if (stmt.params && !$.isEmptyObject(stmt.params)) { var table = $('<table><tr><th colspan="2">Params</th></tr></table>').addClass(csscls('params')).appendTo(li); for (var key in stmt.params) { if (typeof stmt.params[key] !== 'function') { table.append('<tr><td class="' + csscls('name') + '">' + key + '</td><td class="' + csscls('value') + '">' + stmt.params[key] + '</td></tr>'); } } li.css('cursor', 'pointer').click(function() { if (table.is(':visible')) { table.hide(); } else { table.show(); } }); } }}); this.$list.$el.appendTo(this.$el); this.bindAttr('data', function(data) { // the PDO collector maybe is empty if (data.length <= 0) { return false; } this.$list.set('data', data.statements); this.$status.empty(); // Search for duplicate statements. for (var sql = {}, unique = 0, duplicate = 0, i = 0; i < data.statements.length; i++) { var stmt = data.statements[i].sql; if (data.statements[i].params && !$.isEmptyObject(data.statements[i].params)) { stmt += ' {' + $.param(data.statements[i].params, false) + '}'; } sql[stmt] = sql[stmt] || { keys: [] }; sql[stmt].keys.push(i); } // Add classes to all duplicate SQL statements. for (var stmt in sql) { if (sql[stmt].keys.length > 1) { duplicate += sql[stmt].keys.length; for (var i = 0; i < sql[stmt].keys.length; i++) { this.$list.$el.find('.' + csscls('list-item')).eq(sql[stmt].keys[i]) .addClass(csscls('sql-duplicate')); } } else { unique++; } } var t = $('<span />').text(data.nb_statements + " statements were executed").appendTo(this.$status); if (data.nb_failed_statements) { t.append(", " + data.nb_failed_statements + " of which failed"); } if (duplicate) { t.append(", " + duplicate + " of which were duplicates"); t.append(", " + unique + " unique"); } if (data.accumulated_duration_str) { this.$status.append($('<span title="Accumulated duration" />').addClass(csscls('duration')).text(data.accumulated_duration_str)); } if (data.memory_usage_str) { this.$status.append($('<span title="Memory usage" />').addClass(csscls('memory')).text(data.memory_usage_str)); } }); } }); })(PhpDebugBar.$); widget.css 0000644 00000010311 15175452402 0006542 0 ustar 00 div.phpdebugbar-widgets-sqlqueries .phpdebugbar-widgets-status { font-family: "SFMono-Regular", Consolas, "Liberation Mono", Menlo, Courier, monospace; padding: 6px 6px; border-bottom: 1px solid #ddd; font-weight: bold; color: #555; background: #fafafa; } div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item.phpdebugbar-widgets-error { color: red; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-database, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-duration, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-memory, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-row-count, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-copy-clipboard, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-stmt-id { float: right; margin-left: 8px; color: #888; } div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-database, div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-duration, div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-memory, div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-row-count, div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-copy-clipboard, div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-status span.phpdebugbar-widgets-stmt-id { color: #555; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-database:before, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-duration:before, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-memory:before, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-row-count:before, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-copy-clipboard:before, div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-stmt-id:before { font-family: PhpDebugbarFontAwesome; margin-right: 4px; font-size: 12px; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-database:before { content: "\f1c0"; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-duration:before { content: "\f017"; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-memory:before { content: "\f085"; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-row-count:before { content: "\f0ce"; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-stmt-id:before { content: "\f08d"; } div.phpdebugbar-widgets-sqlqueries span.phpdebugbar-widgets-copy-clipboard:before { content: "\f0c5"; } div.phpdebugbar-widgets-sqlqueries table.phpdebugbar-widgets-params { display: none; width: 70%; margin: 10px; border: 1px solid #ddd; font-family: "SFMono-Regular", Consolas, "Liberation Mono", Menlo, Courier, monospace; border-collapse: collapse; } div.phpdebugbar-widgets-sqlqueries table.phpdebugbar-widgets-params td { border: 1px solid #ddd; text-align: center; } div.phpdebugbar-widgets-sqlqueries table.phpdebugbar-widgets-params .phpdebugbar-widgets-name { width: 20%; font-weight: bold; } div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item span.phpdebugbar-widgets-error { display: block; font-weight: bold; } code.phpdebugbar-widgets-sql { white-space: pre-wrap; overflow-wrap: break-word; word-wrap: break-word; } div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item.phpdebugbar-widgets-sql-duplicate { background-color: #edeff0; } div.phpdebugbar-widgets-sqlqueries li.phpdebugbar-widgets-list-item.phpdebugbar-widgets-sql-duplicate:hover { background-color: #ffc; } div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-toolbar { display:none; position: fixed; bottom: 0; width: 100%; background: #fff; z-index: 1; } div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-toolbar a.phpdebugbar-widgets-filter { float: right; font-size: 12px; padding: 2px 4px; background: #7cacd5; margin: 0 2px; border-radius: 4px; color: #fff; text-decoration: none; } div.phpdebugbar-widgets-sqlqueries div.phpdebugbar-widgets-toolbar a.phpdebugbar-widgets-filter.phpdebugbar-widgets-excluded { background: #eee; color: #888; }
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Generation time: 0 |
proxy
|
phpinfo
|
Settings