*************************** 14. row ***************************
Query_ID: 39
Duration: 0.00002050
   Query: start transaction
*************************** 15. row ***************************
Query_ID: 40
Duration: 0.00002550
   Query: drop temporary table if exists searchRectifyCriteriaInserts
*************************** 16. row ***************************
Query_ID: 41
Duration: 0.00208800
   Query: create temporary table searchRectifyCriteriaInserts(
        nodeId int unsigned not null primary key
    ) engine=MEMORY
*************************** 17. row ***************************
Query_ID: 42
Duration: 0.00058225
   Query: insert ignore searchRectifyCriteriaInserts(nodeId)
    select nl.srcNodeId
    from searchCriterionT sc
    join nodeLinkTypeT nlt on nlt.isDefault = 'y'
    join tagT dst_tag on sc.nodeId = dst_tag.id  
    join nodeLinkT nl on nlt.id = nl.nodeLinkTypeId and sc.nodeId = nl.dstNodeId
    join tagT s
*************************** 18. row ***************************
Query_ID: 43
Duration: 0.00005625
   Query: insert ignore zzzDevNullSearchT(n)
    select __search_SetTag(session_id_, srci.nodeId, null, 1)
    from searchRectifyCriteriaInserts srci
*************************** 19. row ***************************
Query_ID: 44
Duration: 0.00005450
   Query: drop temporary table searchRectifyCriteriaInserts
*************************** 20. row ***************************
Query_ID: 45
Duration: 0.00001600
   Query: drop temporary table if exists searchRectifyCriteriaDeletes
*************************** 21. row ***************************
Query_ID: 46
Duration: 0.00015500
   Query: create temporary table searchRectifyCriteriaDeletes(
        nodeId int unsigned not null primary key
    ) engine=MEMORY
*************************** 22. row ***************************
Query_ID: 47
Duration: 0.00010650
   Query: insert ignore searchRectifyCriteriaDeletes(nodeId)
    select sc.nodeId
    from searchCriterionNumericT scn
    join searchCriterionT sc on scn.searchCriterionId = sc.id
    where sc.sessionId = session_id_
        and scn.valueLow is null
        and scn.valueHigh is null
*************************** 23. row ***************************
Query_ID: 48
Duration: 0.00009250
   Query: insert ignore searchRectifyCriteriaDeletes(nodeId)
    select sc.nodeId
    from searchCriterionDatetimeT scd
    join searchCriterionT sc on scd.searchCriterionId = sc.id
    where sc.sessionId = session_id_
        and scd.valueLow is null
        and scd.valueHigh is null
*************************** 24. row ***************************
Query_ID: 49
Duration: 0.00008575
   Query: delete from searchCriterionT
    using searchCriterionT
    join searchRectifyCriteriaDeletes srcd on searchCriterionT.nodeId = srcd.nodeId
    where searchCriterionT.sessionId = session_id_
*************************** 25. row ***************************
Query_ID: 50
Duration: 0.00003825
   Query: drop temporary table searchRectifyCriteriaDeletes
*************************** 26. row ***************************
Query_ID: 51
Duration: 0.00015075
   Query: select count(distinct sc.nodeTypeId) into count_notnull
    from searchCriterionT sc
    where sc.sessionId = session_id
        and sc.nodeTypeId is not null
        and sc.internalTypeId = 'tag'
*************************** 27. row ***************************
Query_ID: 52
Duration: 0.00014950
   Query: select count(*), greatest(coalesce(sum(t.factor), 0.001), 0.001) into count_null, sum_null
    from searchCriterionT sc
    join tagT t on sc.nodeId = t.id
    where sc.sessionId = session_id
        and sc.nodeTypeId is null
        and sc.internalTypeId = 'tag'
*************************** 28. row ***************************
Query_ID: 53
Duration: 0.00009000
   Query: select count(*) into count_numerics
    from searchCriterionT sc
    join searchCriterionNumericT scn on sc.id = scn.searchCriterionId
    where sc.sessionId = session_id
*************************** 29. row ***************************
Query_ID: 54
Duration: 0.00006850
   Query: select count(*) into count_datetimes
    from searchCriterionT sc
    join searchCriterionDatetimeT scd on sc.id = scd.searchCriterionId
    where sc.sessionId = session_id
*************************** 30. row ***************************
Query_ID: 55
Duration: 0.00122600
   Query: delete from searchResultT where sessionId = session_id
*************************** 31. row ***************************
Query_ID: 56
Duration: 0.40747850
   Query: insert ignore searchResultT(sessionId, nodeId)
    select session_id_, n.id
    from nodeT n
    join nodeLinkTypeT nlt on nlt.isDefault = 'y'
    join nodeTypeT nt on n.nodeTypeId = nt.id
    join tagT t on n.id = t.id and t.canSearch = 'y'
    where nt.requiredForObject = 'n'
        and not exist
*************************** 32. row ***************************
Query_ID: 57
Duration: 0.31216050
   Query: insert ignore searchResultT(sessionId, nodeId)
    select session_id_, n.id
    from nodeT n
    join nodeLinkTypeT nlt on nlt.isDefault = 'y'
    join tagT t on n.id = t.id and t.canSearch = 'y'
    where 1=1
    
        and exists(
            select 1
            from nodeLinkT nl1
            j
*************************** 33. row ***************************
Query_ID: 58
Duration: 0.00015925
   Query: insert searchResultT(sessionId, nodeId, collapsed)
    select session_id_, o.id, 'n'
    from objectT o
    join searchCriterionT sc on o.id = sc.nodeId
    join objectStatusT os on o.statusId = os.id
    where sc.sessionId = session_id_
        and os.public = 'y'
*************************** 34. row ***************************
Query_ID: 59
Duration: 0.00012325
   Query: delete from searchCriterionT
    using searchCriterionT
    join tagT tag on searchCriterionT.nodeId = tag.id
    left join searchResultT sr on searchCriterionT.nodeId = sr.nodeId and searchCriterionT.sessionId = sr.sessionId
    where searchCriterionT.sessionId = session_id_
        and sr.nodeId i
*************************** 35. row ***************************
Query_ID: 60
Duration: 0.00001675
   Query: drop temporary table if exists searchTemp
*************************** 36. row ***************************
Query_ID: 61
Duration: 0.00027350
   Query: create temporary table searchTemp(
        nodeId int unsigned not null primary key,
        relevancy double not null default 0.0,
        index(relevancy)
    ) engine=MEMORY
*************************** 37. row ***************************
Query_ID: 62
Duration: 0.00001275
   Query: drop temporary table if exists searchUpdateExtraObjectsData
*************************** 38. row ***************************
Query_ID: 63
Duration: 0.00011675
   Query: create temporary table searchUpdateExtraObjectsData(
        tagId int unsigned not null primary key,
        cnt int unsigned not null default 0
    ) engine=MEMORY
*************************** 39. row ***************************
Query_ID: 64
Duration: 0.00048525
   Query: insert searchUpdateExtraObjectsData(tagId, cnt)
    select tagresult.nodeId, 0
    from searchResultT tagresult
    where tagresult.sessionId = session_id_
*************************** 40. row ***************************
Query_ID: 65
Duration: 0.13948050
   Query: insert ignore searchTemp(nodeId, relevancy)
    select 
        n.id, 
        (
            (coalesce(sum(t5.factor), sum_null_tolerance_) / sum_null_ 
            + (count(avn7.attributeId) / count_numerics)
            + (count(avd9.attributeId) / count_datetimes)) 
        / 3) relevancy
    fro
*************************** 41. row ***************************
Query_ID: 66
Duration: 0.00379200
   Query: insert searchUpdateExtraObjectsData(tagId, cnt)
        select tagresult.nodeId, 1
        from searchResultT tagresult
        join nodeLinkTypeT nlt on nlt.isDefault = 'y'
        join tagT t on tagresult.nodeId = t.id
        where tagresult.sessionId = session_id_
            and exists (select 
*************************** 42. row ***************************
Query_ID: 67
Duration: 0.00088450
   Query: insert ignore searchResultT(sessionId, nodeId, relevancy)
    select session_id_, st.nodeId, st.relevancy
    from searchTemp st
    join nodeLinkTypeT nlt on nlt.isDefault = 'y'
    join objectT o on st.nodeId = o.id
    
    where 1=1
    
        and count_notnull_ =
            (select count(dis
*************************** 43. row ***************************
Query_ID: 68
Duration: 0.00001650
   Query: drop temporary table if exists searchUpdateSortCacheData
*************************** 44. row ***************************
Query_ID: 69
Duration: 0.00024050
   Query: create temporary table searchUpdateSortCacheData(
        objectId int unsigned not null,
        attributeId int unsigned not null,
        primary key(objectId, attributeId)
    ) engine=MEMORY
*************************** 45. row ***************************
Query_ID: 70
Duration: 0.00010200
   Query: insert zzzDevNullSearchT(n)
    select __object_UpdateSortCache(suscd.objectId, suscd.attributeId, null)
    from searchUpdateSortCacheData suscd
*************************** 46. row ***************************
Query_ID: 71
Duration: 0.00004050
   Query: drop temporary table searchUpdateSortCacheData
*************************** 47. row ***************************
Query_ID: 72
Duration: 0.00080825
   Query: update searchResultT sr join searchUpdateExtraObjectsData sueod on sr.nodeId = sueod.tagId set
        sr.extraObjects = sueod.cnt
    where sr.sessionId = session_id_
*************************** 48. row ***************************
Query_ID: 73
Duration: 0.00003350
   Query: drop temporary table searchUpdateExtraObjectsData
*************************** 49. row ***************************
Query_ID: 74
Duration: 0.00002425
   Query: drop temporary table searchTemp
*************************** 50. row ***************************
Query_ID: 75
Duration: 0.01130625
   Query: commit
50 rows in set (0.00 sec)