GET https://search.jues.net/search/embeds/6?q=anal%20fisting%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.78 ms
(85.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
  118008
  381903
  385021
  391392
  391756
  401768
  402619
  406086
  414292
  414601
  415319
  416537
  416738
  424581
  427539
  428231
  428255
  429603
  432274
  435539
  441124
  441849
  444281
  445397
  446781
  446797
  449075
  451775
  452637
  452642
  456240
  456244
  461612
  462377
  468680
  471666
  473450
  480452
  481935
  488713
  493490
  493749
  502286
  502457
  507956
  510807
  512543
  512943
  513576
  514236
  518464
  519722
  527926
  533382
  534555
  536128
  536377
  536403
  540680
  541755
  547467
  547473
  547481
  547485
  547494
  550298
  554858
  556338
  556884
  561021
  561038
  574951
  583936
  586760
  590281
  590299
  592576
  599875
  600289
  601535
  618276
  624925
  628094
  628384
  630564
  632654
  634773
  634786
  637034
  639718
  639792
  641997
  647939
  649579
  649580
  649596
  651674
  656186
  656568
  656921
  660362
  660399
  660410
  662046
  666850
  666898
  669370
  674943
  680200
  696216
  704205
  713184
  720614
  728540
  761176
  782790
  788181
  788767
  800282
  817210
]
16.27 ms
(9.31%)
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
  414292
  660399
  533382
  647939
  639718
  624925
  416537
  656186
  639792
  634786
  416738
  427539
  428255
  519722
  586760
  630564
  449075
  507956
  452642
  632654
  634773
  554858
  788181
  800282
  574951
  696216
  649579
  660362
  592576
  518464
  502286
  680200
  637034
  536403
  488713
  583936
  481935
  788767
  599875
  391756
  381903
  441124
  493749
  541755
  656921
  669370
  435539
  556884
  641997
  782790
  618276
  502457
  424581
  452637
  451775
  536128
  512943
  468680
  656568
  415319
  473450
  510807
  385021
  441849
  590299
  761176
  428231
  462377
  456244
  536377
  414601
  513576
  628384
  713184
  666898
  432274
  480452
  493490
  446781
  628094
  514236
  817210
  444281
  446797
  547481
  556338
  547494
  561038
  561021
  456240
  550298
  600289
  401768
  720614
  728540
  461612
  547467
  547473
  547485
  660410
  590281
  651674
  540680
  512543
  527926
  471666
  662046
  429603
  445397
  649596
  704205
  601535
  674943
  406086
  649580
  391392
  402619
  534555
  666850
  118008
]
3.17 ms
(1.81%)
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
  118008
  381903
  385021
  391392
  391756
  401768
  402619
  406086
  414292
  414601
  415319
  416537
  416738
  424581
  427539
  428231
  428255
  429603
  432274
  435539
  441124
  441849
  444281
  445397
  446781
  446797
  449075
  451775
  452637
  452642
  456240
  456244
  461612
  462377
  468680
  471666
  473450
  480452
  481935
  488713
  493490
  493749
  502286
  502457
  507956
  510807
  512543
  512943
  513576
  514236
  518464
  519722
  527926
  533382
  534555
  536128
  536377
  536403
  540680
  541755
  547467
  547473
  547481
  547485
  547494
  550298
  554858
  556338
  556884
  561021
  561038
  574951
  583936
  586760
  590281
  590299
  592576
  599875
  600289
  601535
  618276
  624925
  628094
  628384
  630564
  632654
  634773
  634786
  637034
  639718
  639792
  641997
  647939
  649579
  649580
  649596
  651674
  656186
  656568
  656921
  660362
  660399
  660410
  662046
  666850
  666898
  669370
  674943
  680200
  696216
  704205
  713184
  720614
  728540
  761176
  782790
  788181
  788767
  800282
  817210
]
1.79 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal fisting sex"
]
1.60 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал фистинг секс"
]
1.48 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.