GET https://search.jues.net/search/embeds/5?q=sex%20finger

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.52 ms
(83.08%)
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
  191117
  383299
  388184
  394006
  397655
  401734
  405699
  418663
  427112
  439264
  441210
  441295
  444241
  447778
  448906
  452914
  453759
  460070
  464755
  465720
  469080
  473767
  475177
  475637
  476166
  478023
  478029
  480829
  485657
  486169
  490519
  493789
  499884
  505034
  505968
  506418
  509305
  509386
  509760
  512096
  513176
  514769
  524487
  525173
  525466
  528191
  528374
  530722
  531079
  531838
  533922
  535458
  536912
  537042
  544773
  546566
  546702
  547546
  547813
  547881
  548556
  549574
  550175
  550334
  553229
  553291
  555418
  555463
  556805
  557284
  557582
  562706
  565547
  566948
  568864
  570615
  571657
  573303
  575610
  582826
  582829
  584456
  586285
  587731
  587954
  590702
  590807
  590981
  591205
  591596
  591970
  592644
  592875
  598039
  598493
  600688
  600790
  601790
  603085
  604206
  605966
  607214
  609998
  611192
  615065
  618997
  623377
  625762
  629770
  640975
  662922
  677240
  681501
  714289
  737786
  748874
  761591
  767130
  782094
]
16.96 ms
(10.80%)
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
  607214
  623377
  444241
  505034
  191117
  452914
  469080
  460070
  478023
  478029
  465720
  525173
  509760
  531079
  499884
  509386
  512096
  536912
  505968
  524487
  531838
  476166
  547546
  550334
  573303
  544773
  553291
  555418
  566948
  571657
  557284
  677240
  662922
  562706
  598493
  604206
  605966
  591205
  615065
  618997
  587731
  592875
  600790
  603085
  640975
  737786
  767130
  388184
  401734
  439264
  427112
  506418
  418663
  509305
  555463
  546566
  582826
  570615
  681501
  557582
  601790
  590807
  591806
  625762
  761591
  748874
  611192
  782094
  394006
  383299
  447778
  475177
  448906
  513176
  514769
  525466
  397655
  405699
  441210
  441295
  464755
  480829
  485657
  486169
  473767
  453759
  490519
  528191
  528374
  533922
  530722
  537042
  535458
  475637
  493789
  547881
  548556
  550175
  553229
  575610
  584456
  547813
  549574
  546702
  568864
  582829
  714289
  556805
  565547
  586285
  590981
  591596
  609998
  598039
  600688
  629770
  590702
  591970
  587954
  592644
]
2.97 ms
(1.89%)
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
  191117
  383299
  388184
  394006
  397655
  401734
  405699
  418663
  427112
  439264
  441210
  441295
  444241
  447778
  448906
  452914
  453759
  460070
  464755
  465720
  469080
  473767
  475177
  475637
  476166
  478023
  478029
  480829
  485657
  486169
  490519
  493789
  499884
  505034
  505968
  506418
  509305
  509386
  509760
  512096
  513176
  514769
  524487
  525173
  525466
  528191
  528374
  530722
  531079
  531838
  533922
  535458
  536912
  537042
  544773
  546566
  546702
  547546
  547813
  547881
  548556
  549574
  550175
  550334
  553229
  553291
  555418
  555463
  556805
  557284
  557582
  562706
  565547
  566948
  568864
  570615
  571657
  573303
  575610
  582826
  582829
  584456
  586285
  587731
  587954
  590702
  590807
  590981
  591205
  591596
  591970
  592644
  592875
  598039
  598493
  600688
  600790
  601790
  603085
  604206
  605966
  607214
  609998
  611192
  615065
  618997
  623377
  625762
  629770
  640975
  662922
  677240
  681501
  714289
  737786
  748874
  761591
  767130
  782094
]
1.97 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex finger"
]
1.76 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс палец"
]
1.34 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.