Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Binary log

Select binary log to view 2 Files, 1,325 MiB 
SHOW BINLOG EVENTS LIMIT 0, 25
[ Edit inline ] [ Edit ] [ Create PHP code ] [ Refresh ]
Show full queries - »
Log name Position Event type Server ID Original position Information
mysql-bin.000001 4 Format_desc 1 248 
Server ver: 10.0.38-MariaDB, Binlog ver: 4
mysql-bin.000001 248 Gtid_list 1 273 
[]
mysql-bin.000001 273 Binlog_checkpoint 1 312 
mysql-bin.000001
mysql-bin.000001 312 Gtid 1 350 
GTID 0-1-1
mysql-bin.000001 350 Query 1 515 
DROP TEMPORARY TABLE IF EXISTS `qpsii_lgusystem`.`td_history_all` /* generated by server */
mysql-bin.000001 515 Gtid 1 553 
GTID 0-1-2
mysql-bin.000001 553 Query 1 761 
use `qpsii_lgusystem`; CREATE TEMPORARY TABLE td_history_all
    (
        faas_num INT,
        lvl INT,
        td_id INT,
        td_no VARCHAR(100)
    )
mysql-bin.000001 761 Gtid 1 799 
BEGIN GTID 0-1-3
mysql-bin.000001 799 Query 1 1331 
use `qpsii_lgusystem`; INSERT INTO td_history_all
            SELECT  NAME_CONST('faas_num',73),  NAME_CONST('lvl',0), t.td_id, t.td_no
            FROM ecao_faas_profile f
	    INNER JOIN ecao_tax_dec_profile t 
			ON f.faas_id = t.faas_id
			/*
	    inner join ecao_faas_profile_dtl  fd
			on (fd.ecao_faas_id =  f.faas_id)                 
            WHERE t.td_id = curr and (fd.classification is not null or fd.classification !='')
            */
            group by t.td_id
mysql-bin.000001 1331 Query 1 1411 
COMMIT
mysql-bin.000001 1411 Gtid 1 1449 
BEGIN GTID 0-1-4
mysql-bin.000001 1449 Query 1 1982 
use `qpsii_lgusystem`; INSERT INTO td_history_all
            SELECT  NAME_CONST('faas_num',121),  NAME_CONST('lvl',0), t.td_id, t.td_no
            FROM ecao_faas_profile f
	    INNER JOIN ecao_tax_dec_profile t 
			ON f.faas_id = t.faas_id
			/*
	    inner join ecao_faas_profile_dtl  fd
			on (fd.ecao_faas_id =  f.faas_id)                 
            WHERE t.td_id = curr and (fd.classification is not null or fd.classification !='')
            */
            group by t.td_id
mysql-bin.000001 1982 Query 1 2062 
COMMIT
mysql-bin.000001 2062 Gtid 1 2100 
BEGIN GTID 0-1-5
mysql-bin.000001 2100 Query 1 2633 
use `qpsii_lgusystem`; INSERT INTO td_history_all
            SELECT  NAME_CONST('faas_num',437),  NAME_CONST('lvl',0), t.td_id, t.td_no
            FROM ecao_faas_profile f
	    INNER JOIN ecao_tax_dec_profile t 
			ON f.faas_id = t.faas_id
			/*
	    inner join ecao_faas_profile_dtl  fd
			on (fd.ecao_faas_id =  f.faas_id)                 
            WHERE t.td_id = curr and (fd.classification is not null or fd.classification !='')
            */
            group by t.td_id
mysql-bin.000001 2633 Query 1 2713 
COMMIT
mysql-bin.000001 2713 Gtid 1 2751 
BEGIN GTID 0-1-6
mysql-bin.000001 2751 Query 1 3284 
use `qpsii_lgusystem`; INSERT INTO td_history_all
            SELECT  NAME_CONST('faas_num',513),  NAME_CONST('lvl',0), t.td_id, t.td_no
            FROM ecao_faas_profile f
	    INNER JOIN ecao_tax_dec_profile t 
			ON f.faas_id = t.faas_id
			/*
	    inner join ecao_faas_profile_dtl  fd
			on (fd.ecao_faas_id =  f.faas_id)                 
            WHERE t.td_id = curr and (fd.classification is not null or fd.classification !='')
            */
            group by t.td_id
mysql-bin.000001 3284 Query 1 3364 
COMMIT
mysql-bin.000001 3364 Gtid 1 3402 
BEGIN GTID 0-1-7
mysql-bin.000001 3402 Query 1 3935 
use `qpsii_lgusystem`; INSERT INTO td_history_all
            SELECT  NAME_CONST('faas_num',514),  NAME_CONST('lvl',0), t.td_id, t.td_no
            FROM ecao_faas_profile f
	    INNER JOIN ecao_tax_dec_profile t 
			ON f.faas_id = t.faas_id
			/*
	    inner join ecao_faas_profile_dtl  fd
			on (fd.ecao_faas_id =  f.faas_id)                 
            WHERE t.td_id = curr and (fd.classification is not null or fd.classification !='')
            */
            group by t.td_id
mysql-bin.000001 3935 Query 1 4015 
COMMIT
mysql-bin.000001 4015 Gtid 1 4053 
BEGIN GTID 0-1-8
mysql-bin.000001 4053 Query 1 4586 
use `qpsii_lgusystem`; INSERT INTO td_history_all
            SELECT  NAME_CONST('faas_num',517),  NAME_CONST('lvl',0), t.td_id, t.td_no
            FROM ecao_faas_profile f
	    INNER JOIN ecao_tax_dec_profile t 
			ON f.faas_id = t.faas_id
			/*
	    inner join ecao_faas_profile_dtl  fd
			on (fd.ecao_faas_id =  f.faas_id)                 
            WHERE t.td_id = curr and (fd.classification is not null or fd.classification !='')
            */
            group by t.td_id
mysql-bin.000001 4586 Query 1 4666 
COMMIT