Panier

Oups... Votre panier est vide

Temps de génération: 1.0867350101471
Nombre requete SQL: 7

⧉⌕ $ci->get(...)::$request array (7)

Table (7)
Contents (7)

 0 1
0 SELECT * FROM `legisocial`.cms_node WHERE abonne IS NULL or abonne = 0 ORDER ... 0.0041990280151367
1 INSERT INTO netlegis.caddie (fk_client, type, date_creation, fk_commercial) V... 0.0018501281738281
2 SELECT fk_promo FROM netlegis.caddie WHERE idx_caddie = :id 0.00053215026855469
3 SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp WH... 0.0025289058685303
4 DELETE FROM netlegis.caddie_produit WHERE fk_produit = :idx_produit AND fk_ca... 0.00080299377441406
5 SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp WH... 0.00081706047058105
6 UPDATE netlegis.caddie SET fk_client = :fk_client, livraison_ht = :livraison_... 0.0011069774627686

⇄⧉
0 => array (2)
$ci->get('mysql')::$request[0]
⇄⧉
0 => string (104) "SELECT * FROM `legisocial`.cms_node WHERE abonne IS NULL or abonne = 0 ORDER...
$ci->get('mysql')::$request[0][0]
SELECT * FROM `legisocial`.cms_node WHERE abonne IS NULL or abonne = 0 ORDER BY `tree_id` ASC, `lft` ASC
⇄1 => double 0.0041990280151367
$ci->get('mysql')::$request[0][1]
⇄⧉
1 => array (2)
$ci->get('mysql')::$request[1]
⇄⧉
0 => string (125) "INSERT INTO netlegis.caddie (fk_client, type, date_creation, fk_commercial) ...
$ci->get('mysql')::$request[1][0]
INSERT INTO netlegis.caddie (fk_client, type, date_creation, fk_commercial) VALUES (:client_id, :type, NOW(), :fk_commercial)
⇄1 => double 0.0018501281738281
$ci->get('mysql')::$request[1][1]
⇄⧉
2 => array (2)
$ci->get('mysql')::$request[2]
⇄0 => string (59) "SELECT fk_promo FROM netlegis.caddie WHERE idx_caddie = :id"
$ci->get('mysql')::$request[2][0]
⇄1 => double 0.00053215026855469
$ci->get('mysql')::$request[2][1]
⇄⧉
3 => array (2)
$ci->get('mysql')::$request[3]
⇄⧉
0 => string (407) "SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp W...
$ci->get('mysql')::$request[3][0]
SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp WHERE pp.fk_produit = p.idx_produit), (SELECT pp.prix_ht FROM netlegis.produit_prix pp WHERE cp.qte >= pp.qte AND pp.fk_produit = p.idx_produit ORDER BY pp.qte DESC LIMIT 1), p.prix_ht) as prix_ht, p.pack FROM netlegis.caddie_produit cp INNER JOIN netlegis.produit p ON p.idx_produit = cp.fk_produit WHERE cp.fk_caddie = :idx_caddie
⇄1 => double 0.0025289058685303
$ci->get('mysql')::$request[3][1]
⇄⧉
4 => array (2)
$ci->get('mysql')::$request[4]
⇄⧉
0 => string (95) "DELETE FROM netlegis.caddie_produit WHERE fk_produit = :idx_produit AND fk_c...
$ci->get('mysql')::$request[4][0]
DELETE FROM netlegis.caddie_produit WHERE fk_produit = :idx_produit AND fk_caddie = :idx_caddie
⇄1 => double 0.00080299377441406
$ci->get('mysql')::$request[4][1]
⇄⧉
5 => array (2)
$ci->get('mysql')::$request[5]
⇄⧉
0 => string (407) "SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp W...
$ci->get('mysql')::$request[5][0]
SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp WHERE pp.fk_produit = p.idx_produit), (SELECT pp.prix_ht FROM netlegis.produit_prix pp WHERE cp.qte >= pp.qte AND pp.fk_produit = p.idx_produit ORDER BY pp.qte DESC LIMIT 1), p.prix_ht) as prix_ht, p.pack FROM netlegis.caddie_produit cp INNER JOIN netlegis.produit p ON p.idx_produit = cp.fk_produit WHERE cp.fk_caddie = :idx_caddie
⇄1 => double 0.00081706047058105
$ci->get('mysql')::$request[5][1]
⇄⧉
6 => array (2)
$ci->get('mysql')::$request[6]
⇄⧉
0 => string (260) "UPDATE netlegis.caddie SET fk_client = :fk_client, livraison_ht = :livraison...
$ci->get('mysql')::$request[6][0]
UPDATE netlegis.caddie SET fk_client = :fk_client, livraison_ht = :livraison_ht, livraison_tva = :livraison_tva, total_ht = :total_ht, total_ht_remise = :total_ht_remise, tva = :tva, total_tva = :total_tva, total_ttc = :total_ttc WHERE idx_caddie = :idx_caddie
⇄1 => double 0.0011069774627686
$ci->get('mysql')::$request[6][1]

	0	1
0	SELECT * FROM `legisocial`.cms_node WHERE abonne IS NULL or abonne = 0 ORDER ...	0.0041990280151367
1	INSERT INTO netlegis.caddie (fk_client, type, date_creation, fk_commercial) V...	0.0018501281738281
2	SELECT fk_promo FROM netlegis.caddie WHERE idx_caddie = :id	0.00053215026855469
3	SELECT , IF(cp.qte > 1 AND (SELECT COUNT() FROM netlegis.produit_prix pp WH...	0.0025289058685303
4	DELETE FROM netlegis.caddie_produit WHERE fk_produit = :idx_produit AND fk_ca...	0.00080299377441406
5	SELECT , IF(cp.qte > 1 AND (SELECT COUNT() FROM netlegis.produit_prix pp WH...	0.00081706047058105
6	UPDATE netlegis.caddie SET fk_client = :fk_client, livraison_ht = :livraison_...	0.0011069774627686