Select Queries (19)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM `alesiesc_clip322`.cb8p_config
            [timetook] => 0.00039
            [memBefore] => 0
            [memAfter] => 3.5919799804688
            [memUsed] => 3.5919799804688
        )

    [1] => Array
        (
            [q] => SELECT * FROM `alesiesc_clip322`.cb8p_config
            [timetook] => 0.00028300000000001
            [memBefore] => 3.5919799804688
            [memAfter] => 3.8248596191406
            [memUsed] => 0.23287963867188
        )

    [2] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_languages  WHERE  language_default='yes'   
            [timetook] => 0.000168
            [memBefore] => 3.8248596191406
            [memAfter] => 6.9289169311523
            [memUsed] => 3.1040573120117
        )

    [3] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_languages  WHERE  language_default='yes'   
            [timetook] => 0.000221
            [memBefore] => 6.9289169311523
            [memAfter] => 6.931037902832
            [memUsed] => 0.0021209716796875
        )

    [4] => Array
        (
            [q] => SELECT * FROM `alesiesc_clip322`.cb8p_config
            [timetook] => 0.00040500000000002
            [memBefore] => 6.931037902832
            [memAfter] => 7.2405014038086
            [memUsed] => 0.30946350097656
        )

    [5] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_user_levels,`alesiesc_clip322`.cb8p_user_levels_permissions  WHERE `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id='' 
							  AND `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id = `alesiesc_clip322`.cb8p_user_levels.user_level_id  
            [timetook] => 0.00024399999999999
            [memBefore] => 7.2405014038086
            [memAfter] => 7.4807434082031
            [memUsed] => 0.24024200439453
        )

    [6] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_user_levels,`alesiesc_clip322`.cb8p_user_levels_permissions  WHERE `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id='' 
							  AND `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id = `alesiesc_clip322`.cb8p_user_levels.user_level_id  
            [timetook] => 0.000274
            [memBefore] => 7.4807434082031
            [memAfter] => 7.4814376831055
            [memUsed] => 0.00069427490234375
        )

    [7] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session ='cdmo5jvve7m1oud9fc8rmmna77'   
            [timetook] => 0.000141
            [memBefore] => 7.4814376831055
            [memAfter] => 7.648323059082
            [memUsed] => 0.16688537597656
        )

    [8] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session ='cdmo5jvve7m1oud9fc8rmmna77'   
            [timetook] => 0.000168
            [memBefore] => 7.648323059082
            [memAfter] => 7.6490173339844
            [memUsed] => 0.00069427490234375
        )

    [9] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session_string='guest' AND  session ='cdmo5jvve7m1oud9fc8rmmna77'   
            [timetook] => 0.00012899999999999
            [memBefore] => 7.6533050537109
            [memAfter] => 7.6540451049805
            [memUsed] => 0.00074005126953125
        )

    [10] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session_string='guest' AND  session ='cdmo5jvve7m1oud9fc8rmmna77'   
            [timetook] => 0.00015000000000001
            [memBefore] => 7.6540451049805
            [memAfter] => 7.6547393798828
            [memUsed] => 0.00069427490234375
        )

    [11] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_user_levels,`alesiesc_clip322`.cb8p_user_levels_permissions  WHERE `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id='4' 
							  AND `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id = `alesiesc_clip322`.cb8p_user_levels.user_level_id  
            [timetook] => 0.000249
            [memBefore] => 7.6547393798828
            [memAfter] => 7.6561584472656
            [memUsed] => 0.0014190673828125
        )

    [12] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_user_levels,`alesiesc_clip322`.cb8p_user_levels_permissions  WHERE `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id='4' 
							  AND `alesiesc_clip322`.cb8p_user_levels_permissions.user_level_id = `alesiesc_clip322`.cb8p_user_levels.user_level_id  
            [timetook] => 0.00029099999999999
            [memBefore] => 7.6561584472656
            [memAfter] => 7.6631546020508
            [memUsed] => 0.0069961547851562
        )

    [13] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_plugins  WHERE  plugin_active='yes'   
            [timetook] => 0.00025999999999998
            [memBefore] => 7.6631546020508
            [memAfter] => 8.8209457397461
            [memUsed] => 1.1577911376953
        )

    [14] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_plugins  WHERE  plugin_active='yes'   
            [timetook] => 0.00029499999999999
            [memBefore] => 8.8209457397461
            [memAfter] => 8.8251647949219
            [memUsed] => 0.0042190551757812
        )

    [15] => Array
        (
            [q] => SELECT photos.photo_id, photos.photo_key, photos.userid, photos.photo_title, photos.photo_description, photos.photo_tags, photos.collection_id, photos.photo_details, photos.date_added, photos.filename, photos.ext, photos.active, photos.broadcast, photos.file_directory, photos.views, users.userid, users.username, users.email, users.avatar, users.sex, users.avatar_url, users.dob, users.level, users.usr_status, users.user_session_key, users.featured, users.ban_status, users.total_photos, users.profile_hits, users.total_videos, users.subscribers, users.total_subscriptions, collections.collection_name, collections.type, collections.category, collections.views as collection_views, collections.date_added as collection_added FROM `alesiesc_clip322`.cb8p_photos AS photos LEFT JOIN `alesiesc_clip322`.cb8p_collections AS collections ON photos.collection_id = collections.collection_id LEFT JOIN `alesiesc_clip322`.cb8p_users AS users ON collections.userid = users.userid WHERE  photos.broadcast = 'public' AND photos.active = 'yes' AND   CONCAT(YEAR(curdate()),DAYOFYEAR(curdate())-1) = CONCAT(YEAR(photos.date_added),DAYOFYEAR(photos.date_added))  AND  photos.featured = 'yes' AND  photos.collection_id <> '0' LIMIT 0,10
            [timetook] => 0.00201
            [memBefore] => 8.8251647949219
            [memAfter] => 8.8740921020508
            [memUsed] => 0.048927307128906
        )

    [16] => Array
        (
            [q] =>  SELECT `alesiesc_clip322`.cb8p_collections.*,`alesiesc_clip322`.cb8p_users.userid,`alesiesc_clip322`.cb8p_users.username FROM `alesiesc_clip322`.cb8p_collections,`alesiesc_clip322`.cb8p_users  WHERE  `alesiesc_clip322`.cb8p_collections.active = 'yes' AND   CONCAT(YEAR(curdate()),DAYOFYEAR(curdate())-1) = CONCAT(YEAR(date_added),DAYOFYEAR(date_added))  AND  `alesiesc_clip322`.cb8p_collections.featured = 'yes' AND `alesiesc_clip322`.cb8p_collections.userid = `alesiesc_clip322`.cb8p_users.userid LIMIT 0,10   
            [timetook] => 0.000198
            [memBefore] => 8.8740921020508
            [memAfter] => 8.8706436157227
            [memUsed] => -0.003448486328125
        )

    [17] => Array
        (
            [q] =>  SELECT `alesiesc_clip322`.cb8p_collections.*,`alesiesc_clip322`.cb8p_users.userid,`alesiesc_clip322`.cb8p_users.username FROM `alesiesc_clip322`.cb8p_collections,`alesiesc_clip322`.cb8p_users  WHERE  `alesiesc_clip322`.cb8p_collections.active = 'yes' AND   CONCAT(YEAR(curdate()),DAYOFYEAR(curdate())-1) = CONCAT(YEAR(date_added),DAYOFYEAR(date_added))  AND  `alesiesc_clip322`.cb8p_collections.featured = 'yes' AND `alesiesc_clip322`.cb8p_collections.userid = `alesiesc_clip322`.cb8p_users.userid LIMIT 0,10   
            [timetook] => 0.00021399999999999
            [memBefore] => 8.8706436157227
            [memAfter] => 8.8714599609375
            [memUsed] => 0.00081634521484375
        )

    [18] => Array
        (
            [q] => Select Count(photo_id) From `alesiesc_clip322`.cb8p_photos AS photos  Where  photos.broadcast = 'public' AND photos.active = 'yes' AND   CONCAT(YEAR(curdate()),DAYOFYEAR(curdate())-1) = CONCAT(YEAR(photos.date_added),DAYOFYEAR(photos.date_added))  AND  photos.featured = 'yes' AND  photos.collection_id <> '0' 
            [timetook] => 0.00011700000000001
            [memBefore] => 8.8714599609375
            [memAfter] => 8.8797302246094
            [memUsed] => 0.008270263671875
        )

)