Temps de génération: 0.30883383750916
Nombre requete SQL: 5
⧉⌕$ci->get(...)::$request array (5)
Table (5)
Contents (5)
0
1
0
SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM ...
0.0018329620361328
1
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE grou...
0.0034389495849609
2
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE grou...
0.001939058303833
3
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE grou...
0.0013020038604736
4
SELECT idx_produit FROM netlegis.produit WHERE id = :id AND LOWER(offre) = :o...
0.0017769336700439
⇄⧉0 => array (2)
$ci->get('mysql')::$request[0]
⇄⧉0 => string (171) "SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM...
$ci->get('mysql')::$request[0][0]
SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM legisocial.contenu_chiffretaux t LEFT JOIN cms_tag tag ON t.tag_id = tag.id WHERE t.url = :url
⇄1 => double 0.0018329620361328
$ci->get('mysql')::$request[0][1]
⇄⧉1 => array (2)
$ci->get('mysql')::$request[1]
⇄⧉0 => string (187) "SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE gro...
$ci->get('mysql')::$request[1][0]
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE groupe_id = :groupe_id AND date_publication < NOW() AND annee >= YEAR(NOW() - INTERVAL 5 YEAR) ORDER BY annee DESC
⇄1 => double 0.0034389495849609
$ci->get('mysql')::$request[1][1]
⇄⧉2 => array (2)
$ci->get('mysql')::$request[2]
⇄⧉0 => string (152) "SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE gro...
$ci->get('mysql')::$request[2][0]
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE groupe_id = :groupe_id AND date_publication < NOW() ORDER BY annee DESC LIMIT 1
⇄1 => double 0.001939058303833
$ci->get('mysql')::$request[2][1]
⇄⧉3 => array (2)
$ci->get('mysql')::$request[3]
⇄⧉0 => string (152) "SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE gro...
$ci->get('mysql')::$request[3][0]
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE groupe_id = :groupe_id AND date_publication < NOW() ORDER BY annee DESC LIMIT 1
⇄1 => double 0.0013020038604736
$ci->get('mysql')::$request[3][1]
⇄⧉4 => array (2)
$ci->get('mysql')::$request[4]
⇄⧉0 => string (81) "SELECT idx_produit FROM netlegis.produit WHERE id = :id AND LOWER(offre) = :...
$ci->get('mysql')::$request[4][0]
SELECT idx_produit FROM netlegis.produit WHERE id = :id AND LOWER(offre) = :offre