1 |
SET NAMES utf8mb4
|
0.00037 |
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.00072 |
3 |
UPDATE oktopusV1_core_users_online SET logged=1685467970,
prev_url='https://www.leshautsdechaumont.com/en/la-longere'
WHERE
ident='8709d4227c06fa883d6db56e47e02e48902abc2c7be68444d646644ea47c8150'
|
0.00041 |
4 |
SELECT id_selection FROM oktopusV1_mod_resa_selection
WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP()
|
0.00052 |
5 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00037 |
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.00128 |
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.00040 |
8 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00031 |
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.00104 |
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.00076 |
11 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00040 |
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.00033 |
14 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '343' ORDER BY
index_selection, libelle
|
0.00031 |
15 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '341' ORDER BY
index_selection, libelle
|
0.00032 |
16 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '340' ORDER BY
index_selection, libelle
|
0.00031 |
17 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '339' ORDER BY
index_selection, libelle
|
0.00030 |
18 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '337' ORDER BY
index_selection, libelle
|
0.00031 |
19 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '336' ORDER BY
index_selection, libelle
|
0.00032 |
20 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '334' ORDER BY
index_selection, libelle
|
0.00030 |
21 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '333' ORDER BY
index_selection, libelle
|
0.00037 |
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.00033 |
25 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '322' ORDER BY
index_selection, libelle
|
0.00039 |
26 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '321' ORDER BY
index_selection, libelle
|
0.00030 |
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.00057 |
30 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '313' ORDER BY
index_selection, libelle
|
0.00031 |
31 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '311' ORDER BY
index_selection, libelle
|
0.00030 |
32 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '310' ORDER BY
index_selection, libelle
|
0.00032 |
33 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '309' ORDER BY
index_selection, libelle
|
0.00030 |
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.00031 |
36 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '303' ORDER BY
index_selection, libelle
|
0.00030 |
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.00031 |
39 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '299' ORDER BY
index_selection, libelle
|
0.00033 |
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.00031 |
42 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '293' ORDER BY
index_selection, libelle
|
0.00059 |
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.00056 |
46 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '288' ORDER BY
index_selection, libelle
|
0.00031 |
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.00099 |
49 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '285' ORDER BY
index_selection, libelle
|
0.00034 |
50 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '267' ORDER BY
index_selection, libelle
|
0.00036 |
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.00036 |
53 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '236' ORDER BY
index_selection, libelle
|
0.00034 |
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.00032 |
57 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '224' ORDER BY
index_selection, libelle
|
0.00032 |
58 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '223' ORDER BY
index_selection, libelle
|
0.00032 |
59 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '218' ORDER BY
index_selection, libelle
|
0.00031 |
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.00031 |
62 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '211' ORDER BY
index_selection, libelle
|
0.00709 |
63 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '210' ORDER BY
index_selection, libelle
|
0.00034 |
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.00033 |
66 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '204' ORDER BY
index_selection, libelle
|
0.00034 |
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.00033 |
69 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '201' ORDER BY
index_selection, libelle
|
0.00034 |
70 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '199' ORDER BY
index_selection, libelle
|
0.00033 |
71 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '195' ORDER BY
index_selection, libelle
|
0.00036 |
72 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '193' ORDER BY
index_selection, libelle
|
0.00032 |
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.00032 |
76 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '188' ORDER BY
index_selection, libelle
|
0.00043 |
77 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '187' ORDER BY
index_selection, libelle
|
0.00034 |
78 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '186' ORDER BY
index_selection, libelle
|
0.00032 |
79 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '184' ORDER BY
index_selection, libelle
|
0.00034 |
80 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '183' ORDER BY
index_selection, libelle
|
0.00034 |
81 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '182' ORDER BY
index_selection, libelle
|
0.00032 |
82 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '181' ORDER BY
index_selection, libelle
|
0.00034 |
83 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '178' ORDER BY
index_selection, libelle
|
0.00034 |
84 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '176' ORDER BY
index_selection, libelle
|
0.00032 |
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.00034 |
87 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '169' ORDER BY
index_selection, libelle
|
0.00031 |
88 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '168' ORDER BY
index_selection, libelle
|
0.00031 |
89 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '166' ORDER BY
index_selection, libelle
|
0.00032 |
90 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '165' ORDER BY
index_selection, libelle
|
0.00031 |
91 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '163' ORDER BY
index_selection, libelle
|
0.00031 |
92 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '161' ORDER BY
index_selection, libelle
|
0.00032 |
93 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '160' ORDER BY
index_selection, libelle
|
0.00031 |
94 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '157' ORDER BY
index_selection, libelle
|
0.00032 |
95 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '155' ORDER BY
index_selection, libelle
|
0.00033 |
96 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '153' ORDER BY
index_selection, libelle
|
0.00032 |
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.00033 |
99 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '146' ORDER BY
index_selection, libelle
|
0.00033 |
100 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '145' ORDER BY
index_selection, libelle
|
0.00033 |
101 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '142' ORDER BY
index_selection, libelle
|
0.00034 |
102 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '141' ORDER BY
index_selection, libelle
|
0.00031 |
103 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '139' ORDER BY
index_selection, libelle
|
0.00036 |
104 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '120' ORDER BY
index_selection, libelle
|
0.00034 |
105 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '116' ORDER BY
index_selection, libelle
|
0.00032 |
106 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '107' ORDER BY
index_selection, libelle
|
0.00033 |
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.00033 |
109 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '104' ORDER BY
index_selection, libelle
|
0.00035 |
110 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '103' ORDER BY
index_selection, libelle
|
0.00033 |
111 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '102' ORDER BY
index_selection, libelle
|
0.00033 |
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.00033 |
114 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '99' ORDER BY index_selection,
libelle
|
0.00034 |
115 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '98' ORDER BY index_selection,
libelle
|
0.00034 |
116 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '96' ORDER BY index_selection,
libelle
|
0.00032 |
117 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '95' ORDER BY index_selection,
libelle
|
0.00033 |
118 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '94' ORDER BY index_selection,
libelle
|
0.00032 |
119 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '92' ORDER BY index_selection,
libelle
|
0.00032 |
120 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '91' ORDER BY index_selection,
libelle
|
0.00032 |
121 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '90' ORDER BY index_selection,
libelle
|
0.00033 |
122 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '89' ORDER BY index_selection,
libelle
|
0.00031 |
123 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '88' ORDER BY index_selection,
libelle
|
0.00033 |
124 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '87' ORDER BY index_selection,
libelle
|
0.00033 |
125 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '86' ORDER BY index_selection,
libelle
|
0.00032 |
126 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '85' ORDER BY index_selection,
libelle
|
0.00031 |
127 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '83' ORDER BY index_selection,
libelle
|
0.00032 |
128 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '82' ORDER BY index_selection,
libelle
|
0.00032 |
129 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '81' ORDER BY index_selection,
libelle
|
0.00032 |
130 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '78' ORDER BY index_selection,
libelle
|
0.00033 |
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.00032 |
134 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '64' ORDER BY index_selection,
libelle
|
0.00031 |
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.00032 |
137 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '60' ORDER BY index_selection,
libelle
|
0.00031 |
138 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '56' ORDER BY index_selection,
libelle
|
0.00032 |
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.00032 |
141 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '50' ORDER BY index_selection,
libelle
|
0.00032 |
142 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '48' ORDER BY index_selection,
libelle
|
0.00032 |
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.00032 |
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.00032 |
148 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '8' ORDER BY index_selection,
libelle
|
0.00032 |
149 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '7' ORDER BY index_selection,
libelle
|
0.00032 |
150 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '6' ORDER BY index_selection,
libelle
|
0.00033 |
151 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '5' ORDER BY index_selection,
libelle
|
0.00032 |
152 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '4' ORDER BY index_selection,
libelle
|
0.00031 |
153 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00035 |
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.00108 |
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 p.id, p.original_id, p.user_id, p.category_id,
p.active, p.created_at, p.updated_at, p.images, p.files,
p.tpl, p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV1_mod_pages AS p INNER JOIN
oktopusV1_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en' LEFT OUTER JOIN
oktopusV1_mod_pages_categories AS r ON r.id=p.category_id
LEFT OUTER JOIN oktopusV1_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND
pl.language='en' AND pl.slug='la-longere' AND p.active=1
ORDER BY p.created_at DESC
|
0.00158 |
157 |
SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV1_mod_galleries AS r LEFT JOIN
oktopusV1_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV1_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.language='en' AND
r.active=1 GROUP BY r.id ORDER BY nleft asc
|
0.00205 |
158 |
SELECT m.*,
ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV1_mod_map AS m
LEFT JOIN oktopusV1_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='en' WHERE 1 AND ml.language='en' AND
m.active=1 ORDER BY m.created_at DESC
|
0.00120 |
159 |
SELECT DISTINCT snr.*, snrl.*,
DATE_FORMAT(snr.created_at,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
DATE_FORMAT(snr.updated_at,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
FROM
oktopusV1_mod_social_network_reseau snr
JOIN
oktopusV1_mod_social_network_reseau_locales snrl ON
snrl.id_reseau = snr.id_reseau AND snrl.language = 'en'
WHERE 1 AND active = '1' ORDER BY snrl.libelle
|
0.00118 |
160 |
SELECT p.id, p.original_id, p.user_id, p.category_id,
p.active, p.created_at, p.updated_at, p.images, p.files,
p.tpl, p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV1_mod_pages AS p INNER JOIN
oktopusV1_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en' LEFT OUTER JOIN
oktopusV1_mod_pages_categories AS r ON r.id=p.category_id
LEFT OUTER JOIN oktopusV1_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND
pl.language='en' AND p.active=1 ORDER BY p.created_at DESC
|
0.00126 |
161 |
SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id,
f.bloc, f.colonne, f.picto, f.options, f.info_personnelle,
fl.language, fl.title, fl.description, fl.value, fl.legend
FROM oktopusV1_mod_pages_forms_fields AS f LEFT JOIN
oktopusV1_mod_pages_forms_fields_locales AS fl ON
fl.field_id=f.id WHERE 1 AND active>0 AND page_id=2 AND
fl.language='en' ORDER BY ord ASC
|
0.00059 |
162 |
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.00115 |
163 |
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/la-longere\'%') ORDER BY p.rubrique DESC
|
0.00064 |
164 |
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/la-longere\'%') ORDER BY p.rubrique DESC
|
0.00055 |