GET https://search.jues.net/search/embeds/10?q=threesome%20with%20milf

Query Metrics

7 Database Queries
7 Different statements
225.22 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
198.67 ms
(88.21%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  115206
  384522
  385483
  386623
  386846
  387235
  387281
  388591
  394853
  398177
  400139
  400550
  401673
  406946
  410753
  418923
  420275
  423376
  425957
  427202
  433718
  442299
  448755
  489973
  491768
  494085
  506550
  506552
  506580
  511392
  522888
  526429
  533547
  560210
  561047
  561113
  566558
  572202
  581394
  587226
  593839
  603571
  607168
  607202
  607376
  607403
  608038
  612812
  631927
  633815
  642832
  644270
  644301
  644306
  650780
  671279
  671759
  672122
  680657
  681271
  687271
  687544
  688325
  699596
  703051
  705663
  709624
  710412
  714864
  717034
  717862
  717880
  720925
  721187
  724111
  724133
  724182
  724328
  729819
  732029
  736141
  737549
  748432
  753248
  756083
  756869
  758617
  760825
  760837
  763624
  770196
  771821
  772804
  775473
  788936
  789647
  790026
  800162
  801944
  801974
  805585
  806777
  807949
  808112
  809421
  811072
  814255
  814353
  815056
  815080
  815982
  817457
  817768
  817917
  818457
  818471
  820743
  823622
  824996
  827903
]
17.22 ms
(7.64%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  511392
  581394
  672122
  631927
  587226
  593839
  775473
  790026
  736141
  756869
  418923
  814255
  824996
  688325
  788936
  729819
  388591
  533547
  607403
  398177
  814353
  815080
  687544
  699596
  710412
  772804
  805585
  732029
  760825
  387281
  572202
  384522
  607376
  756083
  386846
  801974
  410753
  817457
  818471
  406946
  423376
  433718
  506550
  494085
  561113
  703051
  717862
  400139
  427202
  820743
  817768
  818457
  506552
  560210
  671279
  671759
  681271
  709624
  608038
  801944
  807949
  763624
  811072
  448755
  526429
  680657
  721187
  809421
  724328
  724111
  771821
  644306
  705663
  789647
  386623
  385483
  815056
  817917
  491768
  489973
  714864
  687271
  607168
  607202
  642832
  644301
  806777
  770196
  760837
  724133
  737549
  753248
  717034
  720925
  400550
  522888
  420275
  815982
  823622
  566558
  650780
  612812
  800162
  758617
  401673
  394853
  442299
  425957
  717880
  748432
  506580
  827903
  644270
  561047
  724182
  387235
  633815
  808112
  603571
  115206
]
2.73 ms
(1.21%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  115206
  384522
  385483
  386623
  386846
  387235
  387281
  388591
  394853
  398177
  400139
  400550
  401673
  406946
  410753
  418923
  420275
  423376
  425957
  427202
  433718
  442299
  448755
  489973
  491768
  494085
  506550
  506552
  506580
  511392
  522888
  526429
  533547
  560210
  561047
  561113
  566558
  572202
  581394
  587226
  593839
  603571
  607168
  607202
  607376
  607403
  608038
  612812
  631927
  633815
  642832
  644270
  644301
  644306
  650780
  671279
  671759
  672122
  680657
  681271
  687271
  687544
  688325
  699596
  703051
  705663
  709624
  710412
  714864
  717034
  717862
  717880
  720925
  721187
  724111
  724133
  724182
  724328
  729819
  732029
  736141
  737549
  748432
  753248
  756083
  756869
  758617
  760825
  760837
  763624
  770196
  771821
  772804
  775473
  788936
  789647
  790026
  800162
  801944
  801974
  805585
  806777
  807949
  808112
  809421
  811072
  814255
  814353
  815056
  815080
  815982
  817457
  817768
  817917
  818457
  818471
  820743
  823622
  824996
  827903
]
1.95 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome with milf"
]
1.68 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро milf"
]
1.50 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро milf"
]
1.48 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.