GET https://search.jues.net/search/embeds/8?q=man%20to%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.34 ms
(82.05%)
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
  16776
  31490
  96341
  100075
  212873
  231163
  383734
  390858
  395609
  395896
  396647
  396654
  397995
  398390
  398655
  399209
  400962
  401273
  402771
  404059
  404366
  404746
  411769
  413137
  414361
  417476
  418332
  419248
  419861
  421797
  422576
  422985
  423653
  424663
  429036
  429181
  433694
  437707
  443903
  445900
  447471
  447858
  447913
  449109
  449434
  450779
  454444
  458414
  462208
  462583
  464111
  464925
  466921
  467372
  467604
  470847
  472251
  472705
  473291
  474385
  475804
  478853
  480420
  482794
  485600
  486643
  492509
  494339
  495270
  500077
  504145
  506844
  510858
  512088
  519935
  519947
  519977
  521361
  521459
  522079
  526037
  526111
  528788
  538358
  542961
  549575
  550051
  558064
  561929
  565542
  569427
  570061
  571268
  573743
  575819
  580237
  581660
  584537
  591600
  591673
  598545
  598625
  599400
  600516
  606822
  611661
  612023
  616994
  624799
  636750
  646244
  661570
  713840
  721551
  747461
  747858
  757976
  766524
  784260
  804377
]
17.80 ms
(11.47%)
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
  462583
  474385
  398390
  411769
  429036
  449109
  464925
  472705
  414361
  450779
  485600
  486643
  521361
  492509
  504145
  506844
  526037
  526111
  538358
  522079
  464111
  231163
  16776
  467372
  573743
  713840
  600516
  747858
  804377
  766524
  747461
  757976
  612023
  784260
  390858
  402771
  399209
  542961
  528788
  606822
  598545
  565542
  611661
  467604
  424663
  462208
  519977
  31490
  96341
  396654
  396647
  418332
  429181
  419248
  423653
  447913
  458414
  482794
  445900
  449434
  472251
  519947
  661570
  558064
  591673
  599400
  624799
  598625
  400962
  466921
  475804
  519935
  521459
  395896
  398655
  401273
  443903
  413137
  447471
  454444
  510858
  447858
  404746
  500077
  512088
  494339
  616994
  404366
  433694
  422576
  417476
  569427
  575819
  549575
  580237
  584537
  721551
  550051
  561929
  570061
  581660
  591600
  397995
  404059
  480420
  478853
  395609
  470847
  422985
  495270
  419861
  421797
  383734
  473291
  571268
  646244
  636750
  100075
  437707
  212873
]
2.82 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
  16776
  31490
  96341
  100075
  212873
  231163
  383734
  390858
  395609
  395896
  396647
  396654
  397995
  398390
  398655
  399209
  400962
  401273
  402771
  404059
  404366
  404746
  411769
  413137
  414361
  417476
  418332
  419248
  419861
  421797
  422576
  422985
  423653
  424663
  429036
  429181
  433694
  437707
  443903
  445900
  447471
  447858
  447913
  449109
  449434
  450779
  454444
  458414
  462208
  462583
  464111
  464925
  466921
  467372
  467604
  470847
  472251
  472705
  473291
  474385
  475804
  478853
  480420
  482794
  485600
  486643
  492509
  494339
  495270
  500077
  504145
  506844
  510858
  512088
  519935
  519947
  519977
  521361
  521459
  522079
  526037
  526111
  528788
  538358
  542961
  549575
  550051
  558064
  561929
  565542
  569427
  570061
  571268
  573743
  575819
  580237
  581660
  584537
  591600
  591673
  598545
  598625
  599400
  600516
  606822
  611661
  612023
  616994
  624799
  636750
  646244
  661570
  713840
  721551
  747461
  747858
  757976
  766524
  784260
  804377
]
1.89 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин жоп"
]
1.79 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин жоп"
]
1.72 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man to ass"
]

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.