Select Queries (19)

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

    [1] => Array
        (
            [q] => SELECT * FROM `alesiesc_clip322`.cb8p_config
            [timetook] => 0.00024099999999999
            [memBefore] => 3.5784301757812
            [memAfter] => 3.8112869262695
            [memUsed] => 0.23285675048828
        )

    [2] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_languages  WHERE  language_default='yes'   
            [timetook] => 0.00017300000000003
            [memBefore] => 3.8112869262695
            [memAfter] => 6.9121856689453
            [memUsed] => 3.1008987426758
        )

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

    [4] => Array
        (
            [q] => SELECT * FROM `alesiesc_clip322`.cb8p_config
            [timetook] => 0.00027899999999997
            [memBefore] => 6.914306640625
            [memAfter] => 7.2238311767578
            [memUsed] => 0.30952453613281
        )

    [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.00019599999999997
            [memBefore] => 7.2238311767578
            [memAfter] => 7.4640808105469
            [memUsed] => 0.24024963378906
        )

    [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.00022699999999998
            [memBefore] => 7.4640808105469
            [memAfter] => 7.4647750854492
            [memUsed] => 0.00069427490234375
        )

    [7] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session ='o1sq03a95hruuua8v4448mlou7'   
            [timetook] => 0.00012699999999999
            [memBefore] => 7.4647750854492
            [memAfter] => 7.6306533813477
            [memUsed] => 0.16587829589844
        )

    [8] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session ='o1sq03a95hruuua8v4448mlou7'   
            [timetook] => 0.00014600000000003
            [memBefore] => 7.6306533813477
            [memAfter] => 7.63134765625
            [memUsed] => 0.00069427490234375
        )

    [9] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session_string='guest' AND  session ='o1sq03a95hruuua8v4448mlou7'   
            [timetook] => 8.5000000000002E-5
            [memBefore] => 7.6356430053711
            [memAfter] => 7.6363830566406
            [memUsed] => 0.00074005126953125
        )

    [10] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_sessions  WHERE  session_string='guest' AND  session ='o1sq03a95hruuua8v4448mlou7'   
            [timetook] => 9.8000000000042E-5
            [memBefore] => 7.6363830566406
            [memAfter] => 7.637077331543
            [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.000166
            [memBefore] => 7.637077331543
            [memAfter] => 7.6384963989258
            [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.00019200000000003
            [memBefore] => 7.6384963989258
            [memAfter] => 7.6454925537109
            [memUsed] => 0.0069961547851562
        )

    [13] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_plugins  WHERE  plugin_active='yes'   
            [timetook] => 0.00015599999999999
            [memBefore] => 7.6454925537109
            [memAfter] => 8.8014755249023
            [memUsed] => 1.1559829711914
        )

    [14] => Array
        (
            [q] =>  SELECT * FROM `alesiesc_clip322`.cb8p_plugins  WHERE  plugin_active='yes'   
            [timetook] => 0.00018400000000002
            [memBefore] => 8.8014755249023
            [memAfter] => 8.8056945800781
            [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.00031000000000003
            [memBefore] => 8.8056945800781
            [memAfter] => 8.8543853759766
            [memUsed] => 0.048690795898438
        )

    [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.00013800000000003
            [memBefore] => 8.8543853759766
            [memAfter] => 8.8509368896484
            [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.00015699999999996
            [memBefore] => 8.8509368896484
            [memAfter] => 8.8517532348633
            [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] => 9.9000000000016E-5
            [memBefore] => 8.8517532348633
            [memAfter] => 8.8600234985352
            [memUsed] => 0.008270263671875
        )

)