1 |
1.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.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.id = '4';
|
2 |
0.27 ms |
"START TRANSACTION"
"START TRANSACTION";
|
3 |
0.72 ms |
UPDATE post SET visits = ? WHERE id = ?
UPDATE post SET visits = 1031 WHERE id = 4;
|
4 |
1.10 ms |
"COMMIT"
|
5 |
0.44 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.subject_id = ?
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.subject_id = 4;
|
6 |
0.44 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.created_datetime AS created_datetime_1 FROM post p0_ WHERE p0_.subject_id = ? ORDER BY p0_.created_datetime ASC LIMIT 20
SELECT DISTINCT p0_.id AS id_0, p0_.created_datetime AS created_datetime_1 FROM post p0_ WHERE p0_.subject_id = 4 ORDER BY p0_.created_datetime ASC LIMIT 20;
|
7 |
0.56 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;
|
8 |
0.50 ms |
SELECT t0.id AS id_1, t0.created_datetime AS created_datetime_2, t0.player1position AS player1position_3, t0.player2position AS player2position_4, t0.player3position AS player3position_5, t0.player4position AS player4position_6, t0.player5position AS player5position_7, t0.player6position AS player6position_8, t0.player7position AS player7position_9, t0.player8position AS player8position_10, t0.player9position AS player9position_11, t0.player10position AS player10position_12, t0.player11position AS player11position_13, t0.player1dorsalgabe AS player1dorsalgabe_14, t0.player2dorsalgabe AS player2dorsalgabe_15, t0.player3dorsalgabe AS player3dorsalgabe_16, t0.player4dorsalgabe AS player4dorsalgabe_17, t0.player5dorsalgabe AS player5dorsalgabe_18, t0.player6dorsalgabe AS player6dorsalgabe_19, t0.player7dorsalgabe AS player7dorsalgabe_20, t0.player8dorsalgabe AS player8dorsalgabe_21, t0.player9dorsalgabe AS player9dorsalgabe_22, t0.player10dorsalgabe AS player10dorsalgabe_23, t0.player11dorsalgabe AS player11dorsalgabe_24, t0.post_id AS post_id_25, t0.player1dorsal_id AS player1dorsal_id_26, t0.player2dorsal_id AS player2dorsal_id_27, t0.player3dorsal_id AS player3dorsal_id_28, t0.player4dorsal_id AS player4dorsal_id_29, t0.player5dorsal_id AS player5dorsal_id_30, t0.player6dorsal_id AS player6dorsal_id_31, t0.player7dorsal_id AS player7dorsal_id_32, t0.player8dorsal_id AS player8dorsal_id_33, t0.player9dorsal_id AS player9dorsal_id_34, t0.player10dorsal_id AS player10dorsal_id_35, t0.player11dorsal_id AS player11dorsal_id_36 FROM startingteam t0 WHERE t0.post_id = ?
SELECT t0.id AS id_1, t0.created_datetime AS created_datetime_2, t0.player1position AS player1position_3, t0.player2position AS player2position_4, t0.player3position AS player3position_5, t0.player4position AS player4position_6, t0.player5position AS player5position_7, t0.player6position AS player6position_8, t0.player7position AS player7position_9, t0.player8position AS player8position_10, t0.player9position AS player9position_11, t0.player10position AS player10position_12, t0.player11position AS player11position_13, t0.player1dorsalgabe AS player1dorsalgabe_14, t0.player2dorsalgabe AS player2dorsalgabe_15, t0.player3dorsalgabe AS player3dorsalgabe_16, t0.player4dorsalgabe AS player4dorsalgabe_17, t0.player5dorsalgabe AS player5dorsalgabe_18, t0.player6dorsalgabe AS player6dorsalgabe_19, t0.player7dorsalgabe AS player7dorsalgabe_20, t0.player8dorsalgabe AS player8dorsalgabe_21, t0.player9dorsalgabe AS player9dorsalgabe_22, t0.player10dorsalgabe AS player10dorsalgabe_23, t0.player11dorsalgabe AS player11dorsalgabe_24, t0.post_id AS post_id_25, t0.player1dorsal_id AS player1dorsal_id_26, t0.player2dorsal_id AS player2dorsal_id_27, t0.player3dorsal_id AS player3dorsal_id_28, t0.player4dorsal_id AS player4dorsal_id_29, t0.player5dorsal_id AS player5dorsal_id_30, t0.player6dorsal_id AS player6dorsal_id_31, t0.player7dorsal_id AS player7dorsal_id_32, t0.player8dorsal_id AS player8dorsal_id_33, t0.player9dorsal_id AS player9dorsal_id_34, t0.player10dorsal_id AS player10dorsal_id_35, t0.player11dorsal_id AS player11dorsal_id_36 FROM startingteam t0 WHERE t0.post_id = 4;
|
9 |
0.77 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 1;
|
10 |
0.26 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 24;
|
11 |
0.32 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 6;
|
12 |
0.30 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 15;
|
13 |
0.30 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 18;
|
14 |
0.31 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 4;
|
15 |
0.36 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 14;
|
16 |
0.29 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 23;
|
17 |
0.31 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 7;
|
18 |
0.31 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 19;
|
19 |
0.28 ms |
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.dorsal AS dorsal_2, t0.playeralias AS playeralias_3, t0.playerfullname AS playerfullname_4, t0.seasonstaryear AS seasonstaryear_5 FROM player t0 WHERE t0.id = 11;
|
20 |
0.28 ms |
SELECT t0.id AS id_1, t0.option AS option_2, t0.porcent AS porcent_3, t0.creatoranswer AS creatoranswer_4, t0.post_id AS post_id_5 FROM inquestoption t0 WHERE t0.post_id = ?
SELECT t0.id AS id_1, t0.option AS option_2, t0.porcent AS porcent_3, t0.creatoranswer AS creatoranswer_4, t0.post_id AS post_id_5 FROM inquestoption t0 WHERE t0.post_id = 4;
|