2019-03-05 12:16:27,428 DEBUG [org.teiid.COMMAND_LOG] (default task-7) 90tkfFhb7fPd 	START USER COMMAND:	startTime=2019-03-05 12:16:27.428	requestID=90tkfFhb7fPd.0	txID=null	sessionID=90tkfFhb7fPd	applicationName=JDBC	principal=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9	vdbName=svc	vdbVersion=1	sql=/*+ cache(ttl:300000 scope:USER) */ SELECT g0.fkProfile, g0.AddedDateTime, g0.fkIdCode, g0.product_name, g0.brands, g0.DatabaseID, g0.MealNumber, g0.AmountInG FROM my_nutri_diary.Diary AS g0 WHERE (g0.fkProfile = 2) AND (g0.AddedDateTime = {ts'2019-03-05 12:06:21.995'}) ORDER BY g0.fkProfile, g0.AddedDateTime /* 90tkfFhb7fPd */
2019-03-05 12:16:27,438 TRACE [org.teiid.COMMAND_LOG] (default task-7) 90tkfFhb7fPd 	PLAN USER COMMAND:	endTime=2019-03-05 12:16:27.438	requestID=90tkfFhb7fPd.0	txID=null	sessionID=90tkfFhb7fPd	principal=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9	vdbName=svc	vdbVersion=1	finalRowCount=null	plan=AccessNode:
  Relational Node ID: 1
  Output Columns:
    - fkProfile (long)
    - AddedDateTime (timestamp)
    - fkIdCode (long)
    - product_name (string)
    - brands (string)
    - DatabaseID (short)
    - MealNumber (string)
    - AmountInG (double)
  Cost Estimates: Estimated Node Cardinality: 1.0
  Query: SELECT g_0.fkProfile AS c_0, g_0.AddedDateTime AS c_1, g_0.fkIdCode AS c_2, g_0.product_name AS c_3, g_0.brands AS c_4, g_0.DatabaseID AS c_5, g_0.MealNumber AS c_6, g_0.AmountInG AS c_7 FROM my_nutri_diary.Diary AS g_0 WHERE (g_0.fkProfile IN (SELECT g_1.idProfile FROM my_nutri_diary.Account AS g_1 WHERE g_1.uuidUser = 'cef9d7d3-af13-4b13-9e93-ef3c5307f0e9')) AND (g_0.fkProfile = 2) AND (g_0.AddedDateTime = {ts'2019-03-05 12:06:21.995'}) ORDER BY c_0, c_1
  Model Name: my_nutri_diary

2019-03-05 12:16:27,441 DEBUG [org.teiid.COMMAND_LOG.SOURCE] (Worker0_QueryProcessorQueue8) 90tkfFhb7fPd 	START DATA SRC COMMAND:	startTime=2019-03-05 12:16:27.44	requestID=90tkfFhb7fPd.0	sourceCommandID=1	executionID=3	txID=null	modelName=my_nutri_diary	translatorName=mysql	sessionID=90tkfFhb7fPd	principal=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9	sql=SELECT g_0.fkProfile AS c_0, g_0.AddedDateTime AS c_1, g_0.fkIdCode AS c_2, g_0.product_name AS c_3, g_0.brands AS c_4, g_0.DatabaseID AS c_5, g_0.MealNumber AS c_6, g_0.AmountInG AS c_7 FROM my_nutri_diary.Diary AS g_0 WHERE (g_0.fkProfile IN (SELECT g_1.idProfile FROM my_nutri_diary.Account AS g_1 WHERE g_1.uuidUser = 'cef9d7d3-af13-4b13-9e93-ef3c5307f0e9')) AND (g_0.fkProfile = 2) AND (g_0.AddedDateTime = {ts'2019-03-05 12:06:21.995'}) ORDER BY c_0, c_1
2019-03-05 12:16:27,441 DEBUG [org.teiid.COMMAND_LOG.SOURCE] (Worker0_QueryProcessorQueue8) 90tkfFhb7fPd 	SOURCE SRC COMMAND:	endTime=2019-03-05 12:16:27.441	requestID=90tkfFhb7fPd.0	sourceCommandID=1	executionID=3	txID=null	modelName=my_nutri_diary	translatorName=mysql	sessionID=90tkfFhb7fPd	principal=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9	sourceCommand=[SELECT g_0.`fkProfile` AS c_0, g_0.`AddedDateTime` AS c_1, g_0.`fkIdCode` AS c_2, g_0.`product_name` AS c_3, g_0.`brands` AS c_4, g_0.`DatabaseID` AS c_5, g_0.`MealNumber` AS c_6, g_0.`AmountInG` AS c_7 FROM `Diary` AS g_0 WHERE g_0.`fkProfile` IN (SELECT g_1.`idProfile` FROM `Account` AS g_1 WHERE g_1.`uuidUser` = ?) AND g_0.`fkProfile` = 2 AND g_0.`AddedDateTime` = {ts '2019-03-05 12:06:21.0'} ORDER BY c_0, c_1]
2019-03-05 12:16:27,455 DEBUG [org.teiid.COMMAND_LOG.SOURCE] (default task-7) 90tkfFhb7fPd 	END SRC COMMAND:	endTime=2019-03-05 12:16:27.454	requestID=90tkfFhb7fPd.0	sourceCommandID=1	executionID=3	txID=null	modelName=my_nutri_diary	translatorName=mysql	sessionID=90tkfFhb7fPd	principal=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9	finalRowCount=0	cpuTime(ns)=8892953
2019-03-05 12:16:27,462 DEBUG [org.teiid.COMMAND_LOG] (default task-7) 90tkfFhb7fPd 	END USER COMMAND:	endTime=2019-03-05 12:16:27.462	requestID=90tkfFhb7fPd.0	txID=null	sessionID=90tkfFhb7fPd	principal=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9	vdbName=svc	vdbVersion=1	finalRowCount=0	plan=AccessNode:
  Relational Node ID: 1
  Output Columns:
    - fkProfile (long)
    - AddedDateTime (timestamp)
    - fkIdCode (long)
    - product_name (string)
    - brands (string)
    - DatabaseID (short)
    - MealNumber (string)
    - AmountInG (double)
  Statistics:
    - Node Output Rows: 0
    - Node Next Batch Process Time: 2
    - Node Cumulative Next Batch Process Time: 2
    - Node Cumulative Process Time: 16
    - Node Next Batch Calls: 2
    - Node Blocks: 1
  Cost Estimates: Estimated Node Cardinality: 1.0
  Query: SELECT g_0.fkProfile AS c_0, g_0.AddedDateTime AS c_1, g_0.fkIdCode AS c_2, g_0.product_name AS c_3, g_0.brands AS c_4, g_0.DatabaseID AS c_5, g_0.MealNumber AS c_6, g_0.AmountInG AS c_7 FROM my_nutri_diary.Diary AS g_0 WHERE (g_0.fkProfile IN (SELECT g_1.idProfile FROM my_nutri_diary.Account AS g_1 WHERE g_1.uuidUser = 'cef9d7d3-af13-4b13-9e93-ef3c5307f0e9')) AND (g_0.fkProfile = 2) AND (g_0.AddedDateTime = {ts'2019-03-05 12:06:21.995'}) ORDER BY c_0, c_1
  Model Name: my_nutri_diary