GET https://search.jues.net/search/embeds/10?q=public%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.63 ms
(83.85%)
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
  199865
  210576
  227502
  359260
  395349
  397780
  398870
  400226
  400696
  401154
  401814
  405775
  416832
  448180
  460395
  472812
  473278
  475983
  493314
  494165
  494281
  501039
  513482
  514719
  522857
  523943
  528350
  532286
  533430
  544353
  549959
  550498
  550539
  552547
  553807
  554702
  555615
  555967
  558264
  559785
  564242
  566912
  576478
  581041
  582461
  586186
  588549
  589580
  589799
  591888
  605290
  609918
  616276
  616457
  618069
  636151
  637988
  649863
  650232
  651075
  652451
  655509
  658469
  660115
  661356
  661371
  662861
  672369
  681546
  683568
  692437
  695968
  696044
  697073
  698214
  701321
  711320
  716146
  718904
  720482
  722020
  723383
  725441
  725483
  729567
  743993
  746840
  746970
  750345
  750686
  757569
  759313
  767495
  779141
  783535
  794030
  799017
  801589
  804271
  804877
  805225
  810757
  812235
  812307
  812890
  813585
  821525
  824277
  825147
  826901
  828034
  828066
  828158
  828160
  828271
  828327
  828377
]
14.93 ms
(9.51%)
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
  544353
  210576
  494281
  652451
  722020
  616276
  588549
  589799
  589580
  729567
  750686
  757569
  609918
  711320
  783535
  804271
  681546
  397780
  416832
  813585
  448180
  493314
  514719
  522857
  532286
  501039
  460395
  475983
  661371
  697073
  662861
  672369
  695968
  649863
  655509
  660115
  696044
  586186
  591888
  794030
  799017
  804877
  805225
  812890
  725441
  746840
  750345
  618069
  698214
  718904
  359260
  400696
  528350
  533430
  812307
  767495
  227502
  822787
  825147
  828066
  828377
  828160
  828327
  701321
  549959
  199865
  616457
  637988
  395349
  553807
  550539
  683568
  716146
  801589
  405775
  398870
  564242
  472812
  566912
  661356
  810757
  473278
  821525
  558264
  576478
  552547
  650232
  720482
  555615
  636151
  779141
  725483
  743993
  812235
  746970
  401154
  582461
  581041
  550498
  658469
  651075
  692437
  723383
  605290
  759313
  400226
  494165
  555967
  401814
  559785
  554702
  523943
  513482
  824277
  823060
  826901
  823899
  828271
  828034
  828158
]
2.73 ms
(1.74%)
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
  199865
  210576
  227502
  359260
  395349
  397780
  398870
  400226
  400696
  401154
  401814
  405775
  416832
  448180
  460395
  472812
  473278
  475983
  493314
  494165
  494281
  501039
  513482
  514719
  522857
  523943
  528350
  532286
  533430
  544353
  549959
  550498
  550539
  552547
  553807
  554702
  555615
  555967
  558264
  559785
  564242
  566912
  576478
  581041
  582461
  586186
  588549
  589580
  589799
  591888
  605290
  609918
  616276
  616457
  618069
  636151
  637988
  649863
  650232
  651075
  652451
  655509
  658469
  660115
  661356
  661371
  662861
  672369
  681546
  683568
  692437
  695968
  696044
  697073
  698214
  701321
  711320
  716146
  718904
  720482
  722020
  723383
  725441
  725483
  729567
  743993
  746840
  746970
  750345
  750686
  757569
  759313
  767495
  779141
  783535
  794030
  799017
  801589
  804271
  804877
  805225
  810757
  812235
  812307
  812890
  813585
  821525
  824277
  825147
  826901
  828034
  828066
  828158
  828160
  828271
  828327
  828377
]
2.28 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public pussy"
]
1.97 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на pussy улиц"
]
1.70 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на pussy улиц"
]

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.