GET https://search.jues.net/search/embeds/2?q=man%20with%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.29 ms
(81.92%)
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
  36832
  54117
  68292
  83152
  107348
  145424
  209931
  381776
  383046
  383932
  384789
  385000
  390967
  392841
  392987
  393429
  393767
  394186
  397059
  397279
  397738
  400431
  400439
  400450
  400469
  400624
  400643
  401213
  401922
  401958
  402085
  402605
  402928
  404052
  422802
  429257
  444956
  455180
  458025
  462359
  466187
  467324
  469193
  469874
  484226
  486277
  486613
  491796
  492595
  495158
  505497
  514574
  515205
  517195
  558051
  558273
  558299
  560202
  560469
  566144
  567002
  568574
  569661
  569666
  570503
  571672
  581696
  588376
  596468
  599747
  605543
  615810
  617756
  622451
  655489
  657315
  665502
  666141
  667525
  670486
  677026
  679397
  684580
  701297
  702000
  706933
  710001
  718554
  720469
  720487
  726019
  726650
  727650
  727767
  730225
  734268
  734638
  739957
  741647
  741953
  741983
  743127
  743144
  750561
  755855
  755856
  759574
  759609
  767956
  771903
  774111
  782721
  789187
  789204
  794517
  794769
  800163
  804348
  807516
  813785
]
16.12 ms
(10.98%)
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
  794769
  727650
  759609
  400439
  401958
  393429
  558299
  657315
  665502
  622451
  782721
  804348
  755856
  392987
  397059
  599747
  794517
  743127
  743144
  741647
  469874
  458025
  517195
  569666
  560202
  469193
  400431
  486613
  462359
  560469
  569661
  767956
  617756
  402085
  401213
  467324
  400469
  505497
  68292
  83152
  383932
  209931
  107348
  54117
  402605
  701297
  679397
  615810
  789204
  726019
  755855
  726650
  771903
  383046
  145424
  567002
  655489
  667525
  684580
  706933
  710001
  718554
  666141
  720487
  571672
  807516
  750561
  759574
  720469
  429257
  466187
  36832
  400450
  390967
  397279
  394186
  444956
  397738
  402928
  401922
  566144
  558051
  570503
  588376
  455180
  495158
  514574
  384789
  393767
  400643
  404052
  813785
  702000
  670486
  677026
  596468
  605543
  800163
  730225
  734268
  774111
  734638
  739957
  727767
  741983
  741953
  789187
  385000
  392841
  381776
  400624
  422802
  491796
  486277
  558273
  568574
  581696
  484226
  492595
  515205
]
2.81 ms
(1.91%)
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
  36832
  54117
  68292
  83152
  107348
  145424
  209931
  381776
  383046
  383932
  384789
  385000
  390967
  392841
  392987
  393429
  393767
  394186
  397059
  397279
  397738
  400431
  400439
  400450
  400469
  400624
  400643
  401213
  401922
  401958
  402085
  402605
  402928
  404052
  422802
  429257
  444956
  455180
  458025
  462359
  466187
  467324
  469193
  469874
  484226
  486277
  486613
  491796
  492595
  495158
  505497
  514574
  515205
  517195
  558051
  558273
  558299
  560202
  560469
  566144
  567002
  568574
  569661
  569666
  570503
  571672
  581696
  588376
  596468
  599747
  605543
  615810
  617756
  622451
  655489
  657315
  665502
  666141
  667525
  670486
  677026
  679397
  684580
  701297
  702000
  706933
  710001
  718554
  720469
  720487
  726019
  726650
  727650
  727767
  730225
  734268
  734638
  739957
  741647
  741953
  741983
  743127
  743144
  750561
  755855
  755856
  759574
  759609
  767956
  771903
  774111
  782721
  789187
  789204
  794517
  794769
  800163
  804348
  807516
  813785
]
2.27 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man with pussy"
]
1.84 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин pussy"
]
1.82 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин pussy"
]
1.70 ms
(1.16%)
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.