Select Queries (18)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_config
            [timetook] => 0.00027298927307129
            [memBefore] => 0.41349792480469
            [memAfter] => 0.47120666503906
            [memUsed] => 0.057708740234375
        )

    [1] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_languages WHERE  language_default='yes'  
            [timetook] => 0.00016498565673828
            [memBefore] => 0.47120666503906
            [memAfter] => 0.73721313476562
            [memUsed] => 0.26600646972656
        )

    [2] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_languages WHERE  language_default='yes'  
            [timetook] => 0.00038800000000005
            [memBefore] => 0.73721313476562
            [memAfter] => 0.72276306152344
            [memUsed] => -0.014450073242188
        )

    [3] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_user_levels,`acamedia_V5`.v4_user_levels_permissions WHERE `acamedia_V5`.v4_user_levels_permissions.user_level_id='' 
							  AND `acamedia_V5`.v4_user_levels_permissions.user_level_id = `acamedia_V5`.v4_user_levels.user_level_id 
            [timetook] => 0.00034499168395996
            [memBefore] => 0.72276306152344
            [memAfter] => 0.97511291503906
            [memUsed] => 0.25234985351562
        )

    [4] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_user_levels,`acamedia_V5`.v4_user_levels_permissions WHERE `acamedia_V5`.v4_user_levels_permissions.user_level_id='' 
							  AND `acamedia_V5`.v4_user_levels_permissions.user_level_id = `acamedia_V5`.v4_user_levels.user_level_id 
            [timetook] => 0.00056899999999993
            [memBefore] => 0.97511291503906
            [memAfter] => 0.95944976806641
            [memUsed] => -0.015663146972656
        )

    [5] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session ='kq6dfmu7ctds669bnihmc75l15'  
            [timetook] => 0.00042390823364258
            [memBefore] => 0.95944976806641
            [memAfter] => 1.0058059692383
            [memUsed] => 0.046356201171875
        )

    [6] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session ='kq6dfmu7ctds669bnihmc75l15'  
            [timetook] => 0.00071099999999991
            [memBefore] => 1.0058059692383
            [memAfter] => 0.99060821533203
            [memUsed] => -0.01519775390625
        )

    [7] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session_string='guest' AND  session ='kq6dfmu7ctds669bnihmc75l15'  
            [timetook] => 0.00031900405883789
            [memBefore] => 0.99443054199219
            [memAfter] => 1.0102233886719
            [memUsed] => 0.015792846679688
        )

    [8] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session_string='guest' AND  session ='kq6dfmu7ctds669bnihmc75l15'  
            [timetook] => 0.00047799999999998
            [memBefore] => 1.0102233886719
            [memAfter] => 0.99502563476562
            [memUsed] => -0.01519775390625
        )

    [9] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_user_levels,`acamedia_V5`.v4_user_levels_permissions WHERE `acamedia_V5`.v4_user_levels_permissions.user_level_id='4' 
							  AND `acamedia_V5`.v4_user_levels_permissions.user_level_id = `acamedia_V5`.v4_user_levels.user_level_id 
            [timetook] => 0.00026583671569824
            [memBefore] => 0.99502563476562
            [memAfter] => 1.0129089355469
            [memUsed] => 0.01788330078125
        )

    [10] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_user_levels,`acamedia_V5`.v4_user_levels_permissions WHERE `acamedia_V5`.v4_user_levels_permissions.user_level_id='4' 
							  AND `acamedia_V5`.v4_user_levels_permissions.user_level_id = `acamedia_V5`.v4_user_levels.user_level_id 
            [timetook] => 0.000448
            [memBefore] => 1.0129089355469
            [memAfter] => 1.0009460449219
            [memUsed] => -0.011962890625
        )

    [11] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_plugins WHERE  plugin_active='yes'  
            [timetook] => 0.0001828670501709
            [memBefore] => 1.0009460449219
            [memAfter] => 1.1828842163086
            [memUsed] => 0.18193817138672
        )

    [12] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_plugins WHERE  plugin_active='yes'  
            [timetook] => 0.00044199999999994
            [memBefore] => 1.1828842163086
            [memAfter] => 1.1688766479492
            [memUsed] => -0.014007568359375
        )

    [13] => Array
        (
            [q] =>  SELECT 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, users.last_active, users.total_collections, users.total_groups, profile.rating, profile.rated_by, profile.voters, profile.first_name, profile.last_name, profile.profile_title, profile.profile_desc, profile.city, profile.hometown FROM `acamedia_V5`.v4_users AS users  LEFT JOIN `acamedia_V5`.v4_user_profile AS profile ON users.userid = profile.userid  WHERE  users.usr_status='Ok' AND users.ban_status ='no'  AND ( users.category LIKE '%all%' ) AND  CONCAT(YEAR(curdate()),DAYOFYEAR(curdate())-1) = CONCAT(YEAR(users.doj),DAYOFYEAR(users.doj))  ORDER BY  doj DESC  LIMIT  650,25
            [timetook] => 0.00090885162353516
            [memBefore] => 1.1688766479492
            [memAfter] => 1.1926574707031
            [memUsed] => 0.023780822753906
        )

    [14] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_counters WHERE section='channel' AND query_md5='2ae464d516ef4aad1ff4c53df02a3eb9' 
		AND '1696265291' < date_added 
            [timetook] => 0.00039982795715332
            [memBefore] => 1.1926574707031
            [memAfter] => 1.192268371582
            [memUsed] => -0.00038909912109375
        )

    [15] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_counters WHERE section='channel' AND query_md5='2ae464d516ef4aad1ff4c53df02a3eb9' 
		AND '1696265291' < date_added 
            [timetook] => 0.00063000000000002
            [memBefore] => 1.192268371582
            [memAfter] => 1.1770324707031
            [memUsed] => -0.015235900878906
        )

    [16] => Array
        (
            [q] => SELECT COUNT(userid) FROM `acamedia_V5`.v4_users AS users  WHERE  users.usr_status='Ok' AND users.ban_status ='no'  AND ( users.category LIKE '%all%' ) AND  CONCAT(YEAR(curdate()),DAYOFYEAR(curdate())-1) = CONCAT(YEAR(users.doj),DAYOFYEAR(users.doj))  
            [timetook] => 0.00063920021057129
            [memBefore] => 1.1770324707031
            [memAfter] => 1.1935348510742
            [memUsed] => 0.016502380371094
        )

    [17] => Array
        (
            [q] => SELECT COUNT(*) FROM `acamedia_V5`.v4_counters WHERE section='channel' AND query_md5='2ae464d516ef4aad1ff4c53df02a3eb9' 
            [timetook] => 0.00022697448730469
            [memBefore] => 1.1796340942383
            [memAfter] => 1.1954040527344
            [memUsed] => 0.015769958496094
        )

)