GET https://search.jues.net/search/embeds/3?q=pussy%20sexy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.55 ms
(81.89%)
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
  46788
  357915
  359089
  381855
  382282
  386483
  450156
  455589
  484783
  488563
  501615
  530470
  534873
  572424
  573631
  581834
  588858
  589572
  592325
  603007
  603085
  605854
  608574
  611493
  615533
  617496
  620581
  622568
  628590
  643458
  643984
  644783
  645728
  666067
  667993
  672829
  676983
  679083
  684843
  684863
  684874
  684883
  689827
  689981
  696058
  696144
  697306
  698802
  702906
  704442
  707455
  708431
  713026
  716576
  718143
  720609
  722963
  723520
  723848
  724503
  725403
  729124
  730822
  730855
  731022
  732849
  733342
  733602
  734726
  735925
  736780
  737268
  737371
  737379
  738455
  738939
  741147
  741195
  752020
  753437
  755776
  757287
  760131
  760580
  770054
  773164
  776704
  777529
  778155
  778211
  780284
  781912
  782055
  783247
  784892
  786085
  786149
  786277
  787403
  790547
  793588
  795812
  800137
  800268
  800661
  801833
  802365
  802613
  802692
  803862
  804118
  804611
  808642
  809295
  809943
  811613
  817801
  818723
  824703
]
15.45 ms
(11.04%)
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
  676983
  684863
  698802
  679083
  696144
  697306
  684843
  572424
  589572
  620581
  603007
  622568
  643458
  776704
  777529
  786149
  793588
  801833
  808642
  811613
  783247
  784892
  800137
  800268
  730855
  735925
  737371
  773164
  786085
  730822
  723848
  729124
  737379
  737268
  770054
  738939
  760580
  702906
  716576
  782055
  787403
  790547
  802613
  804118
  357915
  359089
  450156
  501615
  603085
  643984
  781912
  800661
  733342
  720609
  786277
  795812
  382282
  381855
  455589
  386483
  46788
  723520
  818723
  824703
  817801
  484783
  488563
  530470
  534873
  667993
  672829
  684883
  696058
  707455
  708431
  645728
  666067
  684874
  689981
  704442
  718143
  722963
  689827
  713026
  573631
  581834
  588858
  605854
  608574
  615533
  617496
  592325
  611493
  628590
  644783
  778155
  780284
  809295
  809943
  778211
  802365
  802692
  804611
  725403
  733602
  734726
  738455
  741147
  741195
  753437
  755776
  757287
  770748
  803862
  724503
  731022
  732849
  736780
  760131
  752020
]
2.80 ms
(2.00%)
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
  46788
  357915
  359089
  381855
  382282
  386483
  450156
  455589
  484783
  488563
  501615
  530470
  534873
  572424
  573631
  581834
  588858
  589572
  592325
  603007
  603085
  605854
  608574
  611493
  615533
  617496
  620581
  622568
  628590
  643458
  643984
  644783
  645728
  666067
  667993
  672829
  676983
  679083
  684843
  684863
  684874
  684883
  689827
  689981
  696058
  696144
  697306
  698802
  702906
  704442
  707455
  708431
  713026
  716576
  718143
  720609
  722963
  723520
  723848
  724503
  725403
  729124
  730822
  730855
  731022
  732849
  733342
  733602
  734726
  735925
  736780
  737268
  737371
  737379
  738455
  738939
  741147
  741195
  752020
  753437
  755776
  757287
  760131
  760580
  770054
  773164
  776704
  777529
  778155
  778211
  780284
  781912
  782055
  783247
  784892
  786085
  786149
  786277
  787403
  790547
  793588
  795812
  800137
  800268
  800661
  801833
  802365
  802613
  802692
  803862
  804118
  804611
  808642
  809295
  809943
  811613
  817801
  818723
  824703
]
2.05 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy sexy"
]
1.79 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy sexy"
]
1.63 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy sexy"
]

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.