Chaînes - Acamedia

Quicklists

CARDIE

Vues 1,551 Vidéos 82

Abonnés 1 Photos 0

heiser

Vues 1,301 Vidéos 12

Abonnés 0 Photos 0

Pleyssieux

Vues 1,154 Vidéos 7

Abonnés 0 Photos 0

conan

Vues 1,122 Vidéos 12

Abonnés 0 Photos 0

S.Servat

Vues 890 Vidéos 5

Abonnés 0 Photos 0

D.Ragot

Vues 769 Vidéos 2

Abonnés 0 Photos 0

castel

Vues 749 Vidéos 0

Abonnés 0 Photos 0

Ctice

Vues 720 Vidéos 0

Abonnés 0 Photos 0

Non_au_harcelement

Vues 575 Vidéos 17

Abonnés 0 Photos 0

Select Queries (18)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_config
            [timetook] => 0.00020098686218262
            [memBefore] => 0.41322326660156
            [memAfter] => 0.47093200683594
            [memUsed] => 0.057708740234375
        )

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

    [2] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_languages WHERE  language_default='yes'  
            [timetook] => 0.00032199999999999
            [memBefore] => 0.7369384765625
            [memAfter] => 0.72248840332031
            [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.00020217895507812
            [memBefore] => 0.72248840332031
            [memAfter] => 0.97483825683594
            [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.00037800000000002
            [memBefore] => 0.97483825683594
            [memAfter] => 0.95917510986328
            [memUsed] => -0.015663146972656
        )

    [5] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session ='cdl6ghkjvu6o592ahpevuql30e'  
            [timetook] => 0.00034379959106445
            [memBefore] => 0.95917510986328
            [memAfter] => 1.0055313110352
            [memUsed] => 0.046356201171875
        )

    [6] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session ='cdl6ghkjvu6o592ahpevuql30e'  
            [timetook] => 0.00047700000000001
            [memBefore] => 1.0055313110352
            [memAfter] => 0.99033355712891
            [memUsed] => -0.01519775390625
        )

    [7] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session_string='guest' AND  session ='cdl6ghkjvu6o592ahpevuql30e'  
            [timetook] => 0.00025296211242676
            [memBefore] => 0.99409484863281
            [memAfter] => 1.0099182128906
            [memUsed] => 0.015823364257812
        )

    [8] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_sessions WHERE  session_string='guest' AND  session ='cdl6ghkjvu6o592ahpevuql30e'  
            [timetook] => 0.00039
            [memBefore] => 1.0099182128906
            [memAfter] => 0.99472045898438
            [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.00019502639770508
            [memBefore] => 0.99472045898438
            [memAfter] => 1.0126037597656
            [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.00034500000000001
            [memBefore] => 1.0126037597656
            [memAfter] => 1.0006408691406
            [memUsed] => -0.011962890625
        )

    [11] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_plugins WHERE  plugin_active='yes'  
            [timetook] => 0.0001521110534668
            [memBefore] => 1.0006408691406
            [memAfter] => 1.1825485229492
            [memUsed] => 0.18190765380859
        )

    [12] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_plugins WHERE  plugin_active='yes'  
            [timetook] => 0.00037799999999999
            [memBefore] => 1.1825485229492
            [memAfter] => 1.1685409545898
            [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 '%2%' ) AND  users.doj != ''  ORDER BY  profile_hits DESC  LIMIT  0,25
            [timetook] => 0.00097799301147461
            [memBefore] => 1.1685409545898
            [memAfter] => 1.2001113891602
            [memUsed] => 0.031570434570312
        )

    [14] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_counters WHERE section='channel' AND query_md5='946ec0d1ee13da5fa7cd61116e12c7e5' 
		AND '1696282395' < date_added 
            [timetook] => 0.00025606155395508
            [memBefore] => 1.2001113891602
            [memAfter] => 1.2076644897461
            [memUsed] => 0.0075531005859375
        )

    [15] => Array
        (
            [q] => SELECT * FROM `acamedia_V5`.v4_counters WHERE section='channel' AND query_md5='946ec0d1ee13da5fa7cd61116e12c7e5' 
		AND '1696282395' < date_added 
            [timetook] => 0.000386
            [memBefore] => 1.2076644897461
            [memAfter] => 1.1924285888672
            [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 '%2%' ) AND  users.doj != ''  
            [timetook] => 0.00061893463134766
            [memBefore] => 1.1924285888672
            [memAfter] => 1.2087173461914
            [memUsed] => 0.016288757324219
        )

    [17] => Array
        (
            [q] => SELECT COUNT(*) FROM `acamedia_V5`.v4_counters WHERE section='channel' AND query_md5='946ec0d1ee13da5fa7cd61116e12c7e5' 
            [timetook] => 0.00021696090698242
            [memBefore] => 1.1948165893555
            [memAfter] => 1.2107086181641
            [memUsed] => 0.015892028808594
        )

)

Update Queries (2)

Array
(
    [0] => Array
        (
            [q] => UPDATE `acamedia_V5`.v4_sessions SET last_active='2023-10-02 23:38:15',current_page='https://acamedia.ac-nice.fr/channels/2/DANE/most_viewed/all_time/' WHERE  session='cdl6ghkjvu6o592ahpevuql30e'  
            [timetook] => 0.000219
            [memBefore] => 0.99033355712891
            [memAfter] => 0.99409484863281
            [memUsed] => 0.0037612915039062
        )

    [1] => Array
        (
            [q] => UPDATE `acamedia_V5`.v4_counters SET counts='9',date_added='1696282695' WHERE section='channel' AND query_md5='946ec0d1ee13da5fa7cd61116e12c7e5' 
            [timetook] => 0.001579
            [memBefore] => 1.1961975097656
            [memAfter] => 1.196533203125
            [memUsed] => 0.000335693359375
        )

)

Delete Queries(0)

Sorry Ninja, nothing to show here

Insert Queries(0)

Sorry Ninja, nothing to show here

Execute Queries(1)

Array
(
    [0] => Array
        (
            [q] => SET NAMES "utf8"
            [timetook] => 0.00014901161193848
            [memBefore] => 0
            [memAfter] => 0.41322326660156
            [memUsed] => 0.41322326660156
        )

)

Expensive Query(0.41322326660156)

Array
(
    [q] => SET NAMES "utf8"
    [timetook] => 0.00014901161193848
    [memBefore] => 0
    [memAfter] => 0.41322326660156
    [memUsed] => 0.41322326660156
)

Cheapest Query(-0.015663146972656)

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.00037800000000002
    [memBefore] => 0.97483825683594
    [memAfter] => 0.95917510986328
    [memUsed] => -0.015663146972656
)

Overall Stats

Queries (23)
- Insert : 0
- Select : 18
- Update : 2
- Delete : 0
- Count : 2
- Execute : 1
Total Queries : 23
Total Execution Time : 0.0093090518798828
Total Memory Used : 1.196533203125
Base directory : /var/www