Forum sur le droit du travail

Posez votre question à la communauté LégiSocial ou répondez pour apporter votre contribution au forum sur le droit du travail de LégiSocial.

M'abonner aux alertes du forum

Filtrer par métier

Poser ma question

Thème	Nombre de réponses	Dernière réponse

1 2 3

...

409 410 411

Temps de génération: 0.38001298904419
Nombre requete SQL: 3

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

Table (3)
Contents (3)

 0 1
0 SELECT count(*) FROM legisocial.forum_question WHERE supprime IS NOT TRUE 0.0055959224700928
1 SELECT tq.*,
			UNIX_TIMESTAMP(tq.date_dernier_message) as date_dernier_mess... 0.25282597541809
2 SELECT *, nom as title FROM legisocial.cms_metier 0.0009920597076416

	0	1
0	SELECT count(*) FROM legisocial.forum_question WHERE supprime IS NOT TRUE	0.0055959224700928
1	SELECT tq.*, UNIX_TIMESTAMP(tq.date_dernier_message) as date_dernier_mess...	0.25282597541809
2	SELECT *, nom as title FROM legisocial.cms_metier	0.0009920597076416

⇄⧉ 0 => array (2) $ci->get('mysql')::$request[0]

⇄0 => string (73) "SELECT count(*) FROM legisocial.forum_question WHERE supprime IS NOT TRUE" $ci->get('mysql')::$request[0][0]

⇄1 => double 0.0055959224700928 $ci->get('mysql')::$request[0][1]

⇄⧉ 1 => array (2) $ci->get('mysql')::$request[1]

⇄⧉ 0 => string (1823) "SELECT tq.*, UNIX_TIMESTAMP(tq.date_dernier_message) as date_dernier_message... $ci->get('mysql')::$request[1][0]

SELECT tq.*,
			UNIX_TIMESTAMP(tq.date_dernier_message) as date_dernier_message,
			UNIX_TIMESTAMP(tq.date_creation) as date_creation,
			UNIX_TIMESTAMP(tq.date_supprime) as date_supprime,
			(SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id  AND supprime = 0 ORDER BY date DESC LIMIT 1) as dernier_message_id,
			(SELECT COUNT(DISTINCT client_id) FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id) as nbr_participants,
			(SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id  AND supprime = 0 ORDER BY date ASC LIMIT 1) as message_id,
			(SELECT nom FROM legisocial.cms_metier WHERE id = tq.metier_id) as metier,
			tq.id as id,
			(SELECT COUNT(*) FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id  AND supprime = 0) as reponses,
			"legisocial" as site,
			IF (ne.username != "", ne.username, CONCAT(ne.firstname," ", ne.lastname)) as auteur,
			IF (ne2.username != "", ne2.username, CONCAT(ne2.firstname," ", ne2.lastname)) as auteur_dernier_message,
			ne.id as auteur_id,
			ne2.id as dernier_message_client_id
			FROM legisocial.forum_question tq
			LEFT JOIN legisocial.forum_message tm ON tm.id = (SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id  AND supprime = 0 ORDER BY date ASC LIMIT 1)
			LEFT JOIN legisocial.forum_message tm2 ON tm2.id = (SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id  AND supprime = 0 ORDER BY date DESC LIMIT 1)
			LEFT JOIN netlegis.emails ne ON ne.id = tm.client_id
			LEFT JOIN netlegis.emails ne2 ON ne2.id = tm2.client_id WHERE tq.supprime IS NOT TRUE  AND tq.attente_moderation = 0  ORDER BY date_dernier_message DESC LIMIT 6135, 15

⇄1 => double 0.25282597541809 $ci->get('mysql')::$request[1][1]

⇄⧉ 2 => array (2) $ci->get('mysql')::$request[2]

⇄0 => string (49) "SELECT *, nom as title FROM legisocial.cms_metier" $ci->get('mysql')::$request[2][0]

⇄1 => double 0.0009920597076416 $ci->get('mysql')::$request[2][1]