GET https://search.jues.net/search/embeds/4?q=dildo%20anal%20close-up

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.72 ms
(88.13%)
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
  386077
  410682
  415855
  416508
  416600
  416684
  416694
  416701
  416715
  416725
  416751
  417396
  418111
  419200
  420295
  423837
  428700
  434771
  437708
  439359
  439688
  440708
  440723
  441095
  445323
  446709
  448464
  451337
  452880
  452978
  456161
  458115
  464815
  467882
  467893
  471148
  475649
  478514
  482293
  482775
  486761
  493825
  495568
  499934
  502885
  505805
  510956
  511254
  511933
  513629
  520419
  531403
  537447
  538760
  540990
  548464
  555048
  561346
  564554
  573175
  585898
  590788
  600933
  620471
  621960
  625783
  626317
  628553
  632123
  633602
  635724
  641000
  641830
  642048
  644036
  654097
  656816
  656875
  667981
  683496
  685775
  696092
  697545
  699767
  706311
  709128
  712162
  718159
  735248
  742738
  750308
  756192
  759474
  762182
  765569
  769100
  770258
  775709
  777012
  778903
  782439
  782653
  783693
  783702
  783711
  784227
  785549
  789785
  793281
  795402
  800243
  801313
  808641
  814270
  816094
  819686
  821035
  824352
  826589
]
18.29 ms
(7.76%)
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
  785549
  471148
  573175
  439688
  486761
  446709
  448464
  520419
  467882
  467893
  750308
  452880
  821035
  537447
  531294
  656816
  656875
  685775
  635724
  641000
  620471
  783711
  782439
  789785
  762182
  742738
  775709
  416725
  416684
  440708
  458115
  493825
  464815
  416508
  735248
  511933
  632123
  456161
  418111
  416715
  540990
  756192
  709128
  440723
  423837
  795402
  437708
  420295
  696092
  718159
  778903
  759474
  386077
  814270
  816094
  531403
  548464
  641830
  628553
  782653
  777012
  808641
  416701
  502885
  561346
  600933
  416751
  415855
  416694
  419200
  478514
  482775
  475649
  625783
  451337
  495568
  538760
  626317
  783702
  793281
  769100
  770258
  765569
  642048
  644036
  697545
  784227
  417396
  441095
  428700
  555048
  590788
  482293
  416600
  452978
  439359
  513629
  511254
  621960
  445323
  824352
  826589
  819686
  564554
  654097
  683496
  699767
  706311
  585898
  633602
  800243
  801313
  712162
  783693
  505805
  499934
  510956
  667981
  434771
  410682
]
2.66 ms
(1.13%)
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
  386077
  410682
  415855
  416508
  416600
  416684
  416694
  416701
  416715
  416725
  416751
  417396
  418111
  419200
  420295
  423837
  428700
  434771
  437708
  439359
  439688
  440708
  440723
  441095
  445323
  446709
  448464
  451337
  452880
  452978
  456161
  458115
  464815
  467882
  467893
  471148
  475649
  478514
  482293
  482775
  486761
  493825
  495568
  499934
  502885
  505805
  510956
  511254
  511933
  513629
  520419
  531403
  537447
  538760
  540990
  548464
  555048
  561346
  564554
  573175
  585898
  590788
  600933
  620471
  621960
  625783
  626317
  628553
  632123
  633602
  635724
  641000
  641830
  642048
  644036
  654097
  656816
  656875
  667981
  683496
  685775
  696092
  697545
  699767
  706311
  709128
  712162
  718159
  735248
  742738
  750308
  756192
  759474
  762182
  765569
  769100
  770258
  775709
  777012
  778903
  782439
  782653
  783693
  783702
  783711
  784227
  785549
  789785
  793281
  795402
  800243
  801313
  808641
  814270
  816094
  819686
  821035
  824352
  826589
]
1.94 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo anal close-up"
]
1.75 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд анал close up"
]
1.69 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд анал close up"
]
1.64 ms
(0.70%)
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.