Temps de génération: 0.22316098213196
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.0012381076812744
1
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE grou...
0.0035498142242432
2
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE grou...
0.0014121532440186
3
SELECT *, "legisocial" as site FROM legisocial.contenu_chiffretaux WHERE grou...
0.0014650821685791
4
SELECT idx_produit FROM netlegis.produit WHERE id = :id AND LOWER(offre) = :o...
0.003187894821167
⇄⧉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.0012381076812744
$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.0035498142242432
$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.0014121532440186
$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.0014650821685791
$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