1 |
1.38 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.subject_id IS NULL OR p0_.subject_id = 0
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.subject_id IS NULL OR p0_.subject_id = 0;
|
2 |
0.61 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.answer_datetime AS answer_datetime_1 FROM post p0_ WHERE p0_.subject_id IS NULL OR p0_.subject_id = 0 ORDER BY p0_.answer_datetime DESC LIMIT 20
SELECT DISTINCT p0_.id AS id_0, p0_.answer_datetime AS answer_datetime_1 FROM post p0_ WHERE p0_.subject_id IS NULL OR p0_.subject_id = 0 ORDER BY p0_.answer_datetime DESC LIMIT 20;
|
3 |
0.60 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_datetime AS created_datetime_3, p0_.answer_datetime AS answer_datetime_4, p0_.draft AS draft_5, p0_.visits AS visits_6, p0_.censored AS censored_7, p0_.hidetitle AS hidetitle_8, p0_.inquestcustomanswer AS inquestcustomanswer_9, p0_.user_id AS user_id_10, p0_.subject_id AS subject_id_11, p0_.quote_id AS quote_id_12, p0_.inquestanswer_id AS inquestanswer_id_13 FROM post p0_ WHERE (p0_.subject_id IS NULL OR p0_.subject_id = 0) AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.answer_datetime DESC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_datetime AS created_datetime_3, p0_.answer_datetime AS answer_datetime_4, p0_.draft AS draft_5, p0_.visits AS visits_6, p0_.censored AS censored_7, p0_.hidetitle AS hidetitle_8, p0_.inquestcustomanswer AS inquestcustomanswer_9, p0_.user_id AS user_id_10, p0_.subject_id AS subject_id_11, p0_.quote_id AS quote_id_12, p0_.inquestanswer_id AS inquestanswer_id_13 FROM post p0_ WHERE (p0_.subject_id IS NULL OR p0_.subject_id = 0) AND p0_.id IN (5, 4, 2, 1) ORDER BY p0_.answer_datetime DESC;
|
4 |
0.47 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = 5;
|
5 |
0.49 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.publicemailshow AS publicemailshow_3, t0.username AS username_4, t0.avatar AS avatar_5, t0.birddate AS birddate_6, t0.publicbirddateshow AS publicbirddateshow_7, t0.whatsapp AS whatsapp_8, t0.publicwhatsappshow AS publicwhatsappshow_9, t0.aboutyou AS aboutyou_10, t0.signature AS signature_11, t0.registered_datetime AS registered_datetime_12, t0.lastconection AS lastconection_13, t0.roles AS roles_14, t0.password AS password_15, t0.google_id AS google_id_16, t0.google_access_token AS google_access_token_17, t0.is_verified AS is_verified_18, t0.banned AS banned_19 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.publicemailshow AS publicemailshow_3, t0.username AS username_4, t0.avatar AS avatar_5, t0.birddate AS birddate_6, t0.publicbirddateshow AS publicbirddateshow_7, t0.whatsapp AS whatsapp_8, t0.publicwhatsappshow AS publicwhatsappshow_9, t0.aboutyou AS aboutyou_10, t0.signature AS signature_11, t0.registered_datetime AS registered_datetime_12, t0.lastconection AS lastconection_13, t0.roles AS roles_14, t0.password AS password_15, t0.google_id AS google_id_16, t0.google_access_token AS google_access_token_17, t0.is_verified AS is_verified_18, t0.banned AS banned_19 FROM user t0 WHERE t0.id = 1;
|
6 |
0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = 4;
|
7 |
0.36 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = 2;
|
8 |
0.33 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = 1;
|