| 0.0029 |
SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = 'a0ef23f68898fc3b323613292290f1c6'
AND `user_agent` = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
|
| 0.0040 |
UPDATE `ci_sessions` SET `last_activity` = 1337394052, `session_id` = '3a3b02c5ca09b86a913c57f191d0c3e6' WHERE session_id = 'a0ef23f68898fc3b323613292290f1c6'
|
| 0.0032 |
SELECT DISTINCT aba.id_aba, aba.nome
FROM cruzeiro as p
INNER JOIN grupo as gp ON gp.id_grupo = p.grupo_id
INNER JOIN aba ON aba.id_aba = gp.aba_id
INNER JOIN area ON area.id_area = aba.area_id
LEFT OUTER JOIN cruzeiro_aereo_tarifa as pat ON pat.cruzeiro_id = p.id
LEFT OUTER JOIN aereo_tarifa as at ON at.id_tarifa = pat.aereo_tarifa_id AND at.cidade_origem_id = 50
WHERE p.status = 1 AND p.especial = 0
AND area.deletada = 0
AND area.liberar = 1
AND aba.id_aba = 264
ORDER BY aba.id_aba
|
| 0.0015 |
SELECT *
FROM (`gt_moedas`)
|
| 0.0023 |
SELECT DISTINCT fp.parcelas, p.cia_id, p.cia_aerea_id, fp.entrada, fp.juros, fp.coeficiente, p.id, p.titulo, p.saida, p.dias, p.navio_id, p.moeda_id, p.grupo_id, p.aba_id as id_aba,
(SELECT cidade_id FROM cruzeiro_destinos WHERE cruzeiro_id = p.id ORDER BY id ASC LIMIT 1) as menor_cidade_destino,
(SELECT cidade_id FROM cruzeiro_destinos WHERE cruzeiro_id = p.id ORDER BY id DESC LIMIT 1) as menor_cidade_retorno,
(SELECT COUNT(id) FROM cruzeiro_destinos WHERE cruzeiro_id = p.id) as menor_cidade_retorno_total
FROM cruzeiro as p
INNER JOIN forma_pagamento AS fp ON fp.id = p.forma_pagamento
WHERE p.status = 1 AND 1
AND p.aba_id = 264
ORDER BY p.titulo
|
| 0.0012 |
SELECT `id_grupo`, `nome`
FROM (`grupo`)
WHERE `id_grupo` IN ('704')
ORDER BY `indice`
|
| 0.0010 |
SELECT cruzeiro_destinos.cruzeiro_id, pec1.nome
FROM cruzeiro_destinos
INNER JOIN pais_estado_cidade as pec1 ON pec1.id = cruzeiro_destinos.cidade_id
WHERE cruzeiro_destinos.cruzeiro_id IN(1)
|
| 0.0010 |
SELECT DISTINCT cruzeiro_id FROM cruzeiro_saidas as ps WHERE ps.mes >= 5 AND ps.ano >= 2012
AND ps.cruzeiro_id IN (1)
|
| 0.0016 |
SELECT c.id as cruzeiro_id, min(valor_classe_t01) AS aereo, t.cia_id, t.cidade_origem_id as cid_id, t.cidade_retorno_id as cid_ret_id
FROM aereo_tarifa_valor AS v
INNER JOIN aereo_tarifa AS t ON v.tarifa_id = t.id_tarifa
INNER JOIN aereo_temporada AS m ON t.cia_id = m.cia_id AND m.deletada = 0
AND upper( v.tipo ) = upper( m.tipo )
INNER JOIN cruzeiro c on c.cia_aerea_id = t.cia_id
WHERE c.id IN(1)
AND 2012-05-18 >= m.data_fim
GROUP BY c.id, c.cia_aerea_id
ORDER BY c.id, aereo ASC
|
| 0.0017 |
SELECT `cruzeiro_id`, MIN(`qd`) AS preco
FROM (`cruzeiro_valores_periodo`)
WHERE `cruzeiro_id` IN ('1')
GROUP BY `cruzeiro_id`
|
| 0.0010 |
SELECT pv.cruzeiro_id, min(pv.adulto) AS preco
FROM cruzeiro_valores as pv
WHERE pv.cruzeiro_id IN (1) AND pv.adulto > 0 AND tipo_quarto != ''
AND data_end >= '2012-05-18'
GROUP BY pv.cruzeiro_id
ORDER BY pv.cruzeiro_id, preco ASC
|
| 0.0013 |
SELECT *
FROM (`pacotes_cotacoes`)
ORDER BY `data` desc
LIMIT 1
|
| 0.0030 |
SELECT `area_id`, `id_aba`, `nome`
FROM (`aba`)
|
| 0.0042 |
SELECT `grupo`.`nome`, `id_grupo`, `aba_id`
FROM (`grupo`)
WHERE `status` = 1
ORDER BY `indice` asc
|
| 0.0011 |
SELECT *
FROM (`area`)
WHERE `liberar` = 1
AND `deletada` = 0
AND `modulo` = 'pacotes'
ORDER BY `ordem` asc
|
| 0.0014 |
SELECT *
FROM (`area`)
WHERE `liberar` = 1
AND `deletada` = 0
AND `modulo` = 'pacotes-especiais'
ORDER BY `ordem` asc
|
| 0.0017 |
SELECT `thumb`
FROM (`weesh_navios_fotos`)
WHERE `navio_id` = '1'
ORDER BY `primaria` ASC
LIMIT 1
|
| 0.0032 |
SELECT *
FROM (`weesh_navios`)
WHERE `id` = '1'
LIMIT 1
|
| 0.0014 |
SELECT pec1.nome,
pec1.id,
pec1.url,
pec2.nome as pais
FROM cruzeiro_destinos,
pais_estado_cidade as pec1,
pais_estado_cidade as pec2
WHERE cruzeiro_destinos.cidade_id = pec1.id
AND pec1.id_pais = pec2.id
AND cruzeiro_destinos.cruzeiro_id = 1
|
| 0.0013 |
SELECT *
FROM (`weesh_cias`)
WHERE `id` = '2'
LIMIT 1
|
| 0.0011 |
SELECT `img_logo`
FROM (`aereo_cia_aerea`)
WHERE `id_cia` = '15'
LIMIT 1
|
+
