1 |
SET NAMES utf8mb4
|
0.00034 |
2 |
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='8709d4227c06fa883d6db56e47e02e48902abc2c7be68444d646644ea47c8150'
WHERE u.id=1
|
0.00083 |
3 |
REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'8709d4227c06fa883d6db56e47e02e48902abc2c7be68444d646644ea47c8150',
1685464394, 'b7d5441f212a361a438da00339b9c5c4fe84a509',
'https://www.leshautsdechaumont.com/en/disponibilite')
|
0.00039 |
4 |
SELECT id_selection FROM oktopusV1_mod_resa_selection
WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP()
|
0.00058 |
5 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00041 |
6 |
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC
|
0.00134 |
7 |
SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM oktopusV1_mod_resa_reservation
c, oktopusV1_mod_resa_reservation_statut_ligne cl,
oktopusV1_mod_resa_reservation_statut cs
WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC
|
0.00046 |
8 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00033 |
9 |
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC
|
0.00115 |
10 |
SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM oktopusV1_mod_resa_reservation
c, oktopusV1_mod_resa_reservation_statut_ligne cl,
oktopusV1_mod_resa_reservation_statut cs
WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC
|
0.00071 |
11 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00036 |
12 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '345' ORDER BY
index_selection, libelle
|
0.00038 |
13 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '344' ORDER BY
index_selection, libelle
|
0.00034 |
14 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '343' ORDER BY
index_selection, libelle
|
0.00032 |
15 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '341' ORDER BY
index_selection, libelle
|
0.00033 |
16 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '340' ORDER BY
index_selection, libelle
|
0.00032 |
17 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '339' ORDER BY
index_selection, libelle
|
0.00034 |
18 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '337' ORDER BY
index_selection, libelle
|
0.00036 |
19 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '336' ORDER BY
index_selection, libelle
|
0.00031 |
20 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '334' ORDER BY
index_selection, libelle
|
0.00032 |
21 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '333' ORDER BY
index_selection, libelle
|
0.00033 |
22 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '329' ORDER BY
index_selection, libelle
|
0.00031 |
23 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '328' ORDER BY
index_selection, libelle
|
0.00031 |
24 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '327' ORDER BY
index_selection, libelle
|
0.00031 |
25 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '322' ORDER BY
index_selection, libelle
|
0.00031 |
26 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '321' ORDER BY
index_selection, libelle
|
0.00032 |
27 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '320' ORDER BY
index_selection, libelle
|
0.00032 |
28 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '319' ORDER BY
index_selection, libelle
|
0.00032 |
29 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '316' ORDER BY
index_selection, libelle
|
0.00032 |
30 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '313' ORDER BY
index_selection, libelle
|
0.00032 |
31 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '311' ORDER BY
index_selection, libelle
|
0.00033 |
32 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '310' ORDER BY
index_selection, libelle
|
0.00034 |
33 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '309' ORDER BY
index_selection, libelle
|
0.00031 |
34 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '308' ORDER BY
index_selection, libelle
|
0.00031 |
35 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '305' ORDER BY
index_selection, libelle
|
0.00034 |
36 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '303' ORDER BY
index_selection, libelle
|
0.00032 |
37 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '302' ORDER BY
index_selection, libelle
|
0.00030 |
38 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '301' ORDER BY
index_selection, libelle
|
0.00032 |
39 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '299' ORDER BY
index_selection, libelle
|
0.00031 |
40 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '296' ORDER BY
index_selection, libelle
|
0.00030 |
41 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '295' ORDER BY
index_selection, libelle
|
0.00030 |
42 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '293' ORDER BY
index_selection, libelle
|
0.00033 |
43 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '292' ORDER BY
index_selection, libelle
|
0.00031 |
44 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '291' ORDER BY
index_selection, libelle
|
0.00031 |
45 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '289' ORDER BY
index_selection, libelle
|
0.00031 |
46 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '288' ORDER BY
index_selection, libelle
|
0.00030 |
47 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '287' ORDER BY
index_selection, libelle
|
0.00030 |
48 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '286' ORDER BY
index_selection, libelle
|
0.00031 |
49 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '285' ORDER BY
index_selection, libelle
|
0.00031 |
50 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '267' ORDER BY
index_selection, libelle
|
0.00033 |
51 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '251' ORDER BY
index_selection, libelle
|
0.00032 |
52 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '242' ORDER BY
index_selection, libelle
|
0.00033 |
53 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '236' ORDER BY
index_selection, libelle
|
0.00031 |
54 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '232' ORDER BY
index_selection, libelle
|
0.00031 |
55 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '230' ORDER BY
index_selection, libelle
|
0.00031 |
56 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '225' ORDER BY
index_selection, libelle
|
0.00030 |
57 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '224' ORDER BY
index_selection, libelle
|
0.00033 |
58 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '223' ORDER BY
index_selection, libelle
|
0.00031 |
59 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '218' ORDER BY
index_selection, libelle
|
0.00030 |
60 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '217' ORDER BY
index_selection, libelle
|
0.00032 |
61 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '214' ORDER BY
index_selection, libelle
|
0.00032 |
62 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '211' ORDER BY
index_selection, libelle
|
0.00033 |
63 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '210' ORDER BY
index_selection, libelle
|
0.00032 |
64 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '206' ORDER BY
index_selection, libelle
|
0.00033 |
65 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '205' ORDER BY
index_selection, libelle
|
0.00031 |
66 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '204' ORDER BY
index_selection, libelle
|
0.00031 |
67 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '203' ORDER BY
index_selection, libelle
|
0.00031 |
68 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '202' ORDER BY
index_selection, libelle
|
0.00031 |
69 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '201' ORDER BY
index_selection, libelle
|
0.00031 |
70 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '199' ORDER BY
index_selection, libelle
|
0.00030 |
71 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '195' ORDER BY
index_selection, libelle
|
0.00032 |
72 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '193' ORDER BY
index_selection, libelle
|
0.00031 |
73 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '192' ORDER BY
index_selection, libelle
|
0.00031 |
74 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '191' ORDER BY
index_selection, libelle
|
0.00032 |
75 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '190' ORDER BY
index_selection, libelle
|
0.00031 |
76 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '188' ORDER BY
index_selection, libelle
|
0.00031 |
77 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '187' ORDER BY
index_selection, libelle
|
0.00032 |
78 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '186' ORDER BY
index_selection, libelle
|
0.00031 |
79 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '184' ORDER BY
index_selection, libelle
|
0.00032 |
80 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '183' ORDER BY
index_selection, libelle
|
0.00030 |
81 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '182' ORDER BY
index_selection, libelle
|
0.00031 |
82 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '181' ORDER BY
index_selection, libelle
|
0.00030 |
83 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '178' ORDER BY
index_selection, libelle
|
0.00031 |
84 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '176' ORDER BY
index_selection, libelle
|
0.00030 |
85 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '171' ORDER BY
index_selection, libelle
|
0.00032 |
86 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '170' ORDER BY
index_selection, libelle
|
0.00030 |
87 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '169' ORDER BY
index_selection, libelle
|
0.00030 |
88 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '168' ORDER BY
index_selection, libelle
|
0.00033 |
89 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '166' ORDER BY
index_selection, libelle
|
0.00031 |
90 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '165' ORDER BY
index_selection, libelle
|
0.00032 |
91 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '163' ORDER BY
index_selection, libelle
|
0.00033 |
92 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '161' ORDER BY
index_selection, libelle
|
0.00030 |
93 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '160' ORDER BY
index_selection, libelle
|
0.00032 |
94 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '157' ORDER BY
index_selection, libelle
|
0.00031 |
95 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '155' ORDER BY
index_selection, libelle
|
0.00030 |
96 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '153' ORDER BY
index_selection, libelle
|
0.00030 |
97 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '151' ORDER BY
index_selection, libelle
|
0.00031 |
98 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '149' ORDER BY
index_selection, libelle
|
0.00031 |
99 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '146' ORDER BY
index_selection, libelle
|
0.00030 |
100 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '145' ORDER BY
index_selection, libelle
|
0.00030 |
101 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '142' ORDER BY
index_selection, libelle
|
0.00031 |
102 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '141' ORDER BY
index_selection, libelle
|
0.00030 |
103 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '139' ORDER BY
index_selection, libelle
|
0.00030 |
104 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '120' ORDER BY
index_selection, libelle
|
0.00031 |
105 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '116' ORDER BY
index_selection, libelle
|
0.00030 |
106 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '107' ORDER BY
index_selection, libelle
|
0.00030 |
107 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '106' ORDER BY
index_selection, libelle
|
0.00032 |
108 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '105' ORDER BY
index_selection, libelle
|
0.00031 |
109 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '104' ORDER BY
index_selection, libelle
|
0.00032 |
110 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '103' ORDER BY
index_selection, libelle
|
0.00031 |
111 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '102' ORDER BY
index_selection, libelle
|
0.00041 |
112 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '101' ORDER BY
index_selection, libelle
|
0.00034 |
113 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '100' ORDER BY
index_selection, libelle
|
0.00042 |
114 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '99' ORDER BY index_selection,
libelle
|
0.00062 |
115 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '98' ORDER BY index_selection,
libelle
|
0.00037 |
116 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '96' ORDER BY index_selection,
libelle
|
0.00033 |
117 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '95' ORDER BY index_selection,
libelle
|
0.00041 |
118 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '94' ORDER BY index_selection,
libelle
|
0.00031 |
119 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '92' ORDER BY index_selection,
libelle
|
0.00037 |
120 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '91' ORDER BY index_selection,
libelle
|
0.00031 |
121 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '90' ORDER BY index_selection,
libelle
|
0.00030 |
122 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '89' ORDER BY index_selection,
libelle
|
0.00034 |
123 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '88' ORDER BY index_selection,
libelle
|
0.00032 |
124 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '87' ORDER BY index_selection,
libelle
|
0.00030 |
125 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '86' ORDER BY index_selection,
libelle
|
0.00030 |
126 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '85' ORDER BY index_selection,
libelle
|
0.00030 |
127 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '83' ORDER BY index_selection,
libelle
|
0.00030 |
128 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '82' ORDER BY index_selection,
libelle
|
0.00030 |
129 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '81' ORDER BY index_selection,
libelle
|
0.00030 |
130 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '78' ORDER BY index_selection,
libelle
|
0.00030 |
131 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '77' ORDER BY index_selection,
libelle
|
0.00031 |
132 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '76' ORDER BY index_selection,
libelle
|
0.00032 |
133 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '65' ORDER BY index_selection,
libelle
|
0.00030 |
134 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '64' ORDER BY index_selection,
libelle
|
0.00030 |
135 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '63' ORDER BY index_selection,
libelle
|
0.00031 |
136 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '61' ORDER BY index_selection,
libelle
|
0.00030 |
137 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '60' ORDER BY index_selection,
libelle
|
0.00030 |
138 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '56' ORDER BY index_selection,
libelle
|
0.00030 |
139 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '55' ORDER BY index_selection,
libelle
|
0.00032 |
140 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '51' ORDER BY index_selection,
libelle
|
0.00030 |
141 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '50' ORDER BY index_selection,
libelle
|
0.00033 |
142 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '48' ORDER BY index_selection,
libelle
|
0.00031 |
143 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '47' ORDER BY index_selection,
libelle
|
0.00031 |
144 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '43' ORDER BY index_selection,
libelle
|
0.00032 |
145 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '42' ORDER BY index_selection,
libelle
|
0.00031 |
146 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '33' ORDER BY index_selection,
libelle
|
0.00031 |
147 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '11' ORDER BY index_selection,
libelle
|
0.00031 |
148 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '8' ORDER BY index_selection,
libelle
|
0.00031 |
149 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '7' ORDER BY index_selection,
libelle
|
0.00031 |
150 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '6' ORDER BY index_selection,
libelle
|
0.00032 |
151 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '5' ORDER BY index_selection,
libelle
|
0.00031 |
152 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '4' ORDER BY index_selection,
libelle
|
0.00030 |
153 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00036 |
154 |
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC
|
0.00105 |
155 |
SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM oktopusV1_mod_resa_reservation
c, oktopusV1_mod_resa_reservation_statut_ligne cl,
oktopusV1_mod_resa_reservation_statut cs
WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC
|
0.00043 |
156 |
SELECT * FROM oktopusV1_mod_resa_rubrique WHERE id_parent =
'0' ORDER BY position
|
0.00077 |
157 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'rubrique'
|
0.00058 |
158 |
SELECT DISTINCT p.*, pr.position, IF(NOW() BETWEEN
p.debut_actif AND p.fin_actif, 1, 0) AS actif_date,
pr.id_rubrique,
DATE_FORMAT(p.debut_actif,
'%d/%m/%Y') AS debut_actif_fr,
DATE_FORMAT(p.fin_actif, '%d/%m/%Y') AS
fin_actif_fr
FROM oktopusV1_mod_resa_produit p
LEFT JOIN oktopusV1_mod_resa_produit_rubrique pr ON
pr.id_produit = p.id_produit
WHERE pr.id_rubrique IN (1) AND actif = '1' ORDER
BY nom
|
0.00135 |
159 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'produit'
|
0.00049 |
160 |
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC
|
0.00099 |
161 |
SELECT rd.*, rsl.id_reservation_statut, r.debut,
r.id_client,
DATE_FORMAT(r.debut, '%d/%m/%Y') AS
debut_fr,
IF(p.type = 1, DATE_SUB(r.fin,
INTERVAL 1 DAY), r.fin) AS fin,
IF(p.type = 1,
DATE_FORMAT(DATE_SUB(r.fin, INTERVAL 1 DAY), '%d/%m/%Y'),
DATE_FORMAT(r.fin, '%d/%m/%Y')) AS fin_fr
FROM oktopusV1_mod_resa_reservation
as r
JOIN
oktopusV1_mod_resa_reservation_detail as rd ON
rd.id_reservation = r.id_reservation
JOIN
oktopusV1_mod_resa_reservation_statut_ligne as rsl ON
rsl.id_reservation_statut_ligne =
r.id_reservation_statut_ligne
LEFT JOIN oktopusV1_mod_resa_produit as p ON
p.id_produit = rd.id_produit
WHERE ((r.debut >= '2023-05-01' AND r.fin <=
'2023-07-31') OR (r.debut < '2023-05-01' AND r.fin >
'2023-07-31')
OR (r.debut <= '2023-05-01' AND
r.fin >= '2023-05-01' AND r.fin <= '2023-07-31')
OR (r.debut >= '2023-05-01' AND
r.debut <= '2023-07-31' AND r.fin > '2023-07-31') ) ORDER BY
debut, fin
|
0.00213 |
162 |
SELECT *, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM oktopusV1_mod_resa_blocage
WHERE 1 AND id_rubrique IN (1) ORDER BY debut, fin
|
0.00092 |
163 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '3' ORDER BY
libelle
|
0.00133 |
164 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '2' ORDER BY
libelle
|
0.00070 |
165 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '7' ORDER BY
libelle
|
0.00070 |
166 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '8' ORDER BY
libelle
|
0.00066 |
167 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '6' ORDER BY
libelle
|
0.00068 |
168 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '4' ORDER BY
libelle
|
0.00067 |
169 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '5' ORDER BY
libelle
|
0.00069 |
170 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '3' ORDER BY
libelle
|
0.00036 |
171 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '2' ORDER BY
libelle
|
0.00030 |
172 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '7' ORDER BY
libelle
|
0.00029 |
173 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '8' ORDER BY
libelle
|
0.00030 |
174 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '6' ORDER BY
libelle
|
0.00032 |
175 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '4' ORDER BY
libelle
|
0.00033 |
176 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '5' ORDER BY
libelle
|
0.00034 |
177 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '3' ORDER BY
libelle
|
0.00032 |
178 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '2' ORDER BY
libelle
|
0.00033 |
179 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '7' ORDER BY
libelle
|
0.00031 |
180 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '8' ORDER BY
libelle
|
0.00031 |
181 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '6' ORDER BY
libelle
|
0.00031 |
182 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '4' ORDER BY
libelle
|
0.00031 |
183 |
SELECT pp.*, ppl.*
FROM oktopusV1_mod_resa_produit_personnalisation pp
JOIN
oktopusV1_mod_resa_produit_personnalisation_locales ppl ON
ppl.id_perso = pp.id_perso AND ppl.language = 'en'
WHERE 1 AND id_produit = '5' ORDER BY
libelle
|
0.00030 |
184 |
SELECT DISTINCT sn.*, snl.*
FROM oktopusV1_mod_social_network sn
JOIN
oktopusV1_mod_social_network_locales snl ON
snl.id_social_network = sn.id_social_network AND
snl.language = 'en' WHERE 1 AND sn.url != '' AND sn.type !=
'' AND type LIKE '%F%' ORDER BY sn.position
|
0.00163 |
185 |
SELECT p.*, pl.*,
DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
FROM oktopusV1_mod_home_popup p
LEFT JOIN
oktopusV1_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
WHERE 1 AND (
CURDATE() BETWEEN
p.debut AND p.fin
OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
)AND pl.content <> ''
AND (p.rubrique = '' OR p.rubrique LIKE
'%\'/en/disponibilite\'%') ORDER BY p.rubrique DESC
|
0.00070 |
186 |
SELECT p.*, pl.*,
DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
FROM oktopusV1_mod_home_popup p
LEFT JOIN
oktopusV1_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
WHERE 1 AND (
CURDATE() BETWEEN
p.debut AND p.fin
OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
)AND pl.content <> ''
AND (p.rubrique = '' OR p.rubrique LIKE
'%\'/en/disponibilite\'%') ORDER BY p.rubrique DESC
|
0.00064 |