[1] SELECT @@SESSION.sql_mode (this query time : 0.000 s) (total SQL time : 0.000 s) (total time : 0.002 s) (num rows : 1 )
[2] SELECT param, value FROM g_config ; (this query time : 0.001 s) (total SQL time : 0.001 s) (total time : 0.003 s) (num rows : 126 )
[3] SELECT data FROM g_sessions WHERE id = 'D84994c5865d4976d8574ea7a73ebc1a7e53' ; (this query time : 0.000 s) (total SQL time : 0.001 s) (total time : 0.004 s) (num rows : 1 )
[4] SELECT * FROM g_plugins WHERE state='active' (this query time : 0.000 s) (total SQL time : 0.002 s) (total time : 0.004 s) (num rows : 9 )
[5]
SELECT
image_id,
date_available,
NOW() AS dbnow
FROM g_lounge
JOIN g_images ON image_id = id
ORDER BY image_id ASC
LIMIT 1
;
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.006 s)
(num rows : 0 )
[6]
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM g_users
WHERE id = '2'
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.007 s)
(num rows : 1 )
[7]
SELECT
ui.*,
uc.*,
t.name AS theme_name
FROM g_user_infos AS ui
LEFT JOIN g_user_cache AS uc ON ui.user_id = uc.user_id
LEFT JOIN g_themes AS t ON t.id = ui.theme
WHERE ui.user_id = 2
;
(this query time : 0.001 s)
(total SQL time : 0.003 s)
(total time : 0.007 s)
(num rows : 1 )
[8] SELECT * FROM g_user_infos WHERE user_id = 2 ; (this query time : 0.000 s) (total SQL time : 0.003 s) (total time : 0.008 s) (num rows : 1 )
[0.011 s, 8 queries] : start initialize_calendar
[9]
SELECT DISTINCT id FROM g_images
INNER JOIN g_image_category ON id = image_id
WHERE (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
AND date_creation BETWEEN '2015-01-01' AND '2015-12-31 23:59:59'
ORDER BY hit DESC,date_creation DESC, file ASC, id ASC
(this query time : 0.006 s)
(total SQL time : 0.010 s)
(total time : 0.017 s)
(num rows : 622 )
[0.017 s, 9 queries] : end initialize_calendar
[10] UPDATE g_images SET hit = hit+1, lastmodified = lastmodified WHERE id = 7 ; (this query time : 0.000 s) (total SQL time : 0.010 s) (total time : 0.018 s) (affected rows : 1 )
[11]
SELECT id,uppercats,commentable,visible,status,global_rank
FROM g_image_category
INNER JOIN g_categories ON category_id = id
WHERE image_id = 7
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.000 s)
(total SQL time : 0.011 s)
(total time : 0.019 s)
(num rows : 1 )
[12] SELECT * FROM g_images WHERE id IN (7,3810,3853,3918,3538) ; (this query time : 0.001 s) (total SQL time : 0.011 s) (total time : 0.019 s) (num rows : 5 )
[13]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (7)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.012 s)
(total time : 0.024 s)
(num rows : 11 )
[14] SELECT id, name, permalink FROM g_categories WHERE id IN (107,135,136) (this query time : 0.000 s) (total SQL time : 0.012 s) (total time : 0.025 s) (num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 7 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.012 s)
(total time : 0.027 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (3853,3734,3614,3848,3857,3715,3926,3859,3840,3574,3927,3845,3867,3577,3576,3905,3907,3541,3693,3847,3849,3841,3978,3844,3902,3704,3579,3897,3894,4004,3839,3745,3893,3738,3838,3977,3877,3863,3575,3741,3932,3868,3742,3744,3731,3935,3712,3881,3860,3568,3578,3878,3896,3837,3836,3882,3938,3697,3856,3682,3749,3733,3879,3975,3571,3944,3940,3692,3945,3864,3942,3947,3732,3876,4000,3946,3992,3743,3888,3933,4003,3993,3573,3705,3681,3954,3972,3701,3924,3994,3683,3706,3872,3937,3621,3540,3965,3572,3974,3339,3936,3953,3870,3892,3835,3885,3880,3943,3929,3959,3757,3756,3887,3735,3687,3961,3759,3884,3957,3941,3891,3850,3873,3904,3963,3899,3973,3858,3964,3310,3866,3930,3556,3861,3689,3869,3842,3928,3939,3622,3313,3750,3570,3949,3903,3714,3690,3958,3890,3871,3931,3710,3948,3547,3748,3910,3883,3886,4002,3696,3548,3969,3694,3951,3967,3955,3970,3985,3971,3348,3875,3747,3746,3966,2,3968,3716,3852,3618,3755,3925,3754,3707,3960,3636,3865,3549,3956,3300,3923,3986,3901,3934,3569,3713,3700,3717,3695,5,3995,3997,3862,3770,3895,3626,3908,3950,3900,3319,3874,3661,3551,3312,3898,3646,3663,5337,3617,3656,3615,3922,9,3984,3553,3306,3631,3643,3854,3642,3645,3662,3729,3649,3952,3318,3665,3641,3506,3983,3327,3659,3851,3648,3340,3337,3722,3644,3639,3991,3990,3616,3660,3330,4115,4,3651,3536,3619,3658,3657,3976,3343,3507,3652,3980,3335,4001,3325,4037,3533,3843,3550,3723,3328,3334,3316,3653,3724,3737,3314,3655,3650,3688,3317,3331,3304,3758,3324,3627,3329,3654,3338,3751,3981,3341,3322,3989,3669,3514,3332,3623,3323,3988,3638,3752,3647,3906,3730,3624,18,3637,3333,3736,3635,3336,3698,3513,3686,3634,3321,3537,3510,3720,3326,3640,3719,3740,3703,3833,3909,3633,3315,6,3725,3628,3632,3728,4827,3320,3630,3709,3625,3672,3512,3684,3794,3721,3996,3629,3855,3521,3666,3726,3718,3691,3979,3834,3727,3668,3509,3671,3674,3508,3999,3753,3711,3826,3670,3520,3818,3685,3664,3527,3802,3825,3819,3780,21,19,3831,3667,3708,17,3777,3673,3305,3760,3522,8,3998,3552,16,3524,27,3987,3832,3803,3534,3526,3823,3824,3566,3811,3919,3804,15,3982,3699,3962,3525,3821,13,3805,3555,3567,3554,3817,3515,3914,3830,3812,3829,3801,3523,3814,3913,3822,3511,3809,3827,3820,3810,7,3918,3789,3800,3763,3806,3828,3815,3581,3916,3808,3920,3795,3813,3921,3542,3816,3788,3807,3677,3,4771,3565,3799,3796,3564,3772,3611,3582,3786,3597,3790,3601,3591,3592,3798,3543,3768,3792,3791,3767,3562,3599,3501,3583,3596,3793,3301,3676,3779,3797,10,3612,3762,3602,3609,3787,3761,3584,3769,3529,3595,3679,3678,3606,20,3784,3785,3782,3590,3587,11,3766,3775,3535,3594,3604,12,3605,3600,3502,3776,3774,3771,3765,3598,3781,3613,3783,3503,3778,3764,3519,3607,3532,3739,3608,3530,3680,3563,3620,3531,3610,3516,3593,3518,3303,3308,3309,3589,3544,3557,3588,3586,3603,3517,3580,3702,3675,3559,3585,3504,3475,3307,3478,3528,3505,3472,3473,3495,3463,3462,3469,3471,3498,3477,3470,3494,3499,3476,3480,3545,3483,3500,3465,3466,3467,3496,3474,3479,3459,3458,3492,3464,3485,3481,3493,3468,3489,3497,3488,3486,3491,3487,3460,4005,3461,3490,3484,3482,30,31,29,28,23,24,14955,25,26,22,7623,7618,7615,7621,7620,7609,7622,7619,3539,3538)
ORDER BY FIELD(id, 3853,3734,3614,3848,3857,3715,3926,3859,3840,3574,3927,3845,3867,3577,3576,3905,3907,3541,3693,3847,3849,3841,3978,3844,3902,3704,3579,3897,3894,4004,3839,3745,3893,3738,3838,3977,3877,3863,3575,3741,3932,3868,3742,3744,3731,3935,3712,3881,3860,3568,3578,3878,3896,3837,3836,3882,3938,3697,3856,3682,3749,3733,3879,3975,3571,3944,3940,3692,3945,3864,3942,3947,3732,3876,4000,3946,3992,3743,3888,3933,4003,3993,3573,3705,3681,3954,3972,3701,3924,3994,3683,3706,3872,3937,3621,3540,3965,3572,3974,3339,3936,3953,3870,3892,3835,3885,3880,3943,3929,3959,3757,3756,3887,3735,3687,3961,3759,3884,3957,3941,3891,3850,3873,3904,3963,3899,3973,3858,3964,3310,3866,3930,3556,3861,3689,3869,3842,3928,3939,3622,3313,3750,3570,3949,3903,3714,3690,3958,3890,3871,3931,3710,3948,3547,3748,3910,3883,3886,4002,3696,3548,3969,3694,3951,3967,3955,3970,3985,3971,3348,3875,3747,3746,3966,2,3968,3716,3852,3618,3755,3925,3754,3707,3960,3636,3865,3549,3956,3300,3923,3986,3901,3934,3569,3713,3700,3717,3695,5,3995,3997,3862,3770,3895,3626,3908,3950,3900,3319,3874,3661,3551,3312,3898,3646,3663,5337,3617,3656,3615,3922,9,3984,3553,3306,3631,3643,3854,3642,3645,3662,3729,3649,3952,3318,3665,3641,3506,3983,3327,3659,3851,3648,3340,3337,3722,3644,3639,3991,3990,3616,3660,3330,4115,4,3651,3536,3619,3658,3657,3976,3343,3507,3652,3980,3335,4001,3325,4037,3533,3843,3550,3723,3328,3334,3316,3653,3724,3737,3314,3655,3650,3688,3317,3331,3304,3758,3324,3627,3329,3654,3338,3751,3981,3341,3322,3989,3669,3514,3332,3623,3323,3988,3638,3752,3647,3906,3730,3624,18,3637,3333,3736,3635,3336,3698,3513,3686,3634,3321,3537,3510,3720,3326,3640,3719,3740,3703,3833,3909,3633,3315,6,3725,3628,3632,3728,4827,3320,3630,3709,3625,3672,3512,3684,3794,3721,3996,3629,3855,3521,3666,3726,3718,3691,3979,3834,3727,3668,3509,3671,3674,3508,3999,3753,3711,3826,3670,3520,3818,3685,3664,3527,3802,3825,3819,3780,21,19,3831,3667,3708,17,3777,3673,3305,3760,3522,8,3998,3552,16,3524,27,3987,3832,3803,3534,3526,3823,3824,3566,3811,3919,3804,15,3982,3699,3962,3525,3821,13,3805,3555,3567,3554,3817,3515,3914,3830,3812,3829,3801,3523,3814,3913,3822,3511,3809,3827,3820,3810,7,3918,3789,3800,3763,3806,3828,3815,3581,3916,3808,3920,3795,3813,3921,3542,3816,3788,3807,3677,3,4771,3565,3799,3796,3564,3772,3611,3582,3786,3597,3790,3601,3591,3592,3798,3543,3768,3792,3791,3767,3562,3599,3501,3583,3596,3793,3301,3676,3779,3797,10,3612,3762,3602,3609,3787,3761,3584,3769,3529,3595,3679,3678,3606,20,3784,3785,3782,3590,3587,11,3766,3775,3535,3594,3604,12,3605,3600,3502,3776,3774,3771,3765,3598,3781,3613,3783,3503,3778,3764,3519,3607,3532,3739,3608,3530,3680,3563,3620,3531,3610,3516,3593,3518,3303,3308,3309,3589,3544,3557,3588,3586,3603,3517,3580,3702,3675,3559,3585,3504,3475,3307,3478,3528,3505,3472,3473,3495,3463,3462,3469,3471,3498,3477,3470,3494,3499,3476,3480,3545,3483,3500,3465,3466,3467,3496,3474,3479,3459,3458,3492,3464,3485,3481,3493,3468,3489,3497,3488,3486,3491,3487,3460,4005,3461,3490,3484,3482,30,31,29,28,23,24,14955,25,26,22,7623,7618,7615,7621,7620,7609,7622,7619,3539,3538)
;
(this query time : 0.014 s)
(total SQL time : 0.026 s)
(total time : 0.042 s)
(num rows : 622 )
[17] SELECT param, value FROM g_config WHERE param = "send_piwigo_infos_last_notice" ; (this query time : 0.001 s) (total SQL time : 0.027 s) (total time : 0.291 s) (num rows : 1 )