cqusyc

    (Filename: ./Runtime/Export/Debug.bindings.h Line: 45)
2019-08-15 12:09:37.066 24406-25415/? E/Unity: Function SoundChannelInstance *SoundChannel::operator->() const may only be called from main thread!
     
    (Filename:  Line: 19)
2019-08-15 12:09:37.066 24406-25415/? E/Unity: Function SoundChannelInstance *SoundChannel::operator->() const may only be called from main thread!
     
    (Filename:  Line: 19)
2019-08-15 12:09:45.314 24406-25436/? I/Unity: HandleRewardedAdRewarded event received for 10 coins
     
    (Filename: ./Runtime/Export/Debug.bindings.h Line: 45)

cqusyc

2019-08-08 15:03:23.936 4303-4303/? W/UnityMain: type=1400 audit(0.0:66916): avc: denied { read } for name="gpuclk" dev="sysfs" ino=21004 scontext=u:r:untrusted_app:s0:c512,c768 tcontext=u:object_r:sysfs:s0 tclass=file permissive=0
2019-08-08 15:03:23.966 4303-4303/? W/UnityMain: type=1400 audit(0.0:66917): avc: denied { read } for name="gpuclk" dev="sysfs" ino=21004 scontext=u:r:untrusted_app:s0:c512,c768 tcontext=u:object_r:sysfs:s0 tclass=file permissive=0
2019-08-08 15:03:23.995 4219-4303/? D/Unity:  GL_AMD_compressed_ATC_texture GL_AMD_performance_monitor GL_AMD_program_binary_Z400 GL_EXT_debug_label GL_EXT_debug_marker GL_EXT_discard_framebuffer GL_EXT_robustness GL_EXT_texture_format_BGRA8888 GL_EXT_texture_type_2_10_10_10_REV GL_NV_fence GL_OES_compressed_ETC1_RGB8_texture GL_OES_depth_texture GL_OES_depth24 GL_OES_EGL_image GL_OES_EGL_sync GL_OES_EGL_image_external GL_OES_element_index_uint GL_OES_fbo_render_mipmap GL_OES_fragment_precision_high GL_OES_get_program_binary GL_OES_packed_depth_stencil G

cqusyc

库大小	库名称

20.47M	libiPhone-lib.a
4.73M	GoogleMobileAds
2.57M	FBAudienceNetwork
1.75M	AppLovinSDK
1.60M	BUAdSDK
1.22M	Il2CppTypeDefinitions.o
1.05M	VungleSDK

cqusyc

SELECT
    A.user_pseudo_id,
    sum(A.tap_count) as tap_count
FROM
    (
        SELECT user_pseudo_id, event_params.value.int_value AS tap_count, event_timestamp
        FROM
        `analytics_195246954.events_*` AS T,
            T.event_params
        WHERE

cqusyc

SELECT /* 查询最高菜品等级 */
        user_pseudo_id,
        COUNT(user_pseudo_id) as user_count  /* 只要已解锁的最高菜品等级 */
    FROM
        `analytics_195246954.events_*` AS T,
        T.event_params
    WHERE
        event_name = 'af_compound_food'
        AND event_params.key = 'level'
        AND event_params.value.int_value = 2

cqusyc

SELECT C.user_pseudo_id, D.stage, E.wave FROM
(
    SELECT
        A.user_pseudo_id, max(A.event_timestamp) as event_timestamp
    FROM
    (
        SELECT
            user_pseudo_id,
            event_timestamp,
            event_params.value.int_value as stage

cqusyc

SELECT /* 归并购买相同的菜品等级，按用户计数 */
  A.user_pseudo_id,
  COUNT(A.user_pseudo_id) as user_count
FROM (
    SELECT /* 查询最高菜品等级 */
        user_pseudo_id, event_timestamp
    FROM
        `analytics_195246954.events_*` AS T,
        T.event_params
    WHERE

cqusyc

SELECT /* 归并购买相同的菜品等级，按用户计数 */
  user_pseudo_id,
  COUNT(user_pseudo_id) as user_count
FROM (
    SELECT /* 查询最高菜品等级 */
        user_pseudo_id, event_timestamp
    FROM
        `analytics_195246954.events_*` AS T,
        T.event_params
    WHERE

cqusyc

SELECT
    A.user_pseudo_id,
    sum(A.tap_count) as tap_count  
FROM
    (
        SELECT user_pseudo_id, event_params.value.int_value AS tap_count, event_timestamp
        FROM
        `analytics_195246954.events_*` AS T,
            T.event_params
        WHERE

cqusyc

SELECT /* 查询最高菜品等级 */
        user_pseudo_id,
        COUNT(user_pseudo_id) as user_count  /* 只要已解锁的最高菜品等级 */
    FROM
        `analytics_195246954.events_*` AS T,
        T.event_params
    WHERE
        event_name = 'af_compound_food'
        AND event_params.key = 'level'
        AND event_params.value.int_value = 2