GET https://search.jues.net/search/embeds/7?q=beautiful%20porn%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.90 ms
(84.47%)
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
  324288
  415818
  426173
  428392
  428409
  431759
  457974
  472350
  479352
  480821
  486086
  490176
  491672
  496585
  510528
  510619
  511762
  511766
  512257
  512333
  513781
  520572
  522567
  522791
  522792
  523100
  523966
  525957
  527620
  527626
  528034
  528254
  538205
  538221
  538234
  540925
  540930
  554356
  555830
  558840
  558844
  558958
  559771
  565400
  569791
  570046
  573056
  573074
  573127
  573587
  573603
  573643
  573694
  573873
  573960
  574481
  574512
  574546
  574553
  574599
  574615
  574804
  574823
  574884
  574916
  575058
  575079
  575087
  575094
  575104
  575109
  575115
  575117
  575134
  575150
  575165
  575479
  575505
  575514
  575522
  575726
  575729
  575734
  575748
  575764
  575771
  575784
  575791
  575795
  575799
  575811
  576023
  576025
  576030
  576041
  576046
  576047
  576056
  576075
  576079
  576119
  576343
  576344
  576345
  576360
  576364
  576401
  576403
  576416
  584813
  598704
  599531
  615645
  640690
  649566
  679379
  679389
  684802
  693269
  704044
]
17.80 ms
(9.90%)
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
  415818
  324288
  574553
  574599
  575134
  575505
  575522
  575799
  575811
  576046
  576403
  569791
  573074
  573603
  573960
  575079
  575150
  575165
  575771
  576360
  554356
  558844
  573056
  573127
  573587
  573873
  574512
  574615
  574804
  575104
  575726
  575748
  575764
  575784
  576047
  576345
  576401
  684802
  704044
  649566
  555830
  574481
  575058
  575117
  576025
  576041
  576079
  576119
  584813
  598704
  615645
  457974
  426173
  480821
  479352
  472350
  522792
  527620
  538205
  522791
  525957
  538221
  540930
  490176
  510619
  496585
  510528
  511762
  513781
  523100
  523966
  527626
  540925
  573694
  486086
  528034
  491672
  574546
  574916
  573643
  538234
  528254
  640690
  520572
  558958
  559771
  575087
  575094
  575115
  575479
  575514
  575729
  575795
  576023
  576364
  576416
  558840
  575109
  575791
  576056
  576075
  576344
  574823
  574884
  576030
  679379
  693269
  679389
  565400
  570046
  575734
  576343
  599531
  431759
  428409
  428392
  512257
  511766
  512333
  522567
]
2.69 ms
(1.49%)
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
  324288
  415818
  426173
  428392
  428409
  431759
  457974
  472350
  479352
  480821
  486086
  490176
  491672
  496585
  510528
  510619
  511762
  511766
  512257
  512333
  513781
  520572
  522567
  522791
  522792
  523100
  523966
  525957
  527620
  527626
  528034
  528254
  538205
  538221
  538234
  540925
  540930
  554356
  555830
  558840
  558844
  558958
  559771
  565400
  569791
  570046
  573056
  573074
  573127
  573587
  573603
  573643
  573694
  573873
  573960
  574481
  574512
  574546
  574553
  574599
  574615
  574804
  574823
  574884
  574916
  575058
  575079
  575087
  575094
  575104
  575109
  575115
  575117
  575134
  575150
  575165
  575479
  575505
  575514
  575522
  575726
  575729
  575734
  575748
  575764
  575771
  575784
  575791
  575795
  575799
  575811
  576023
  576025
  576030
  576041
  576046
  576047
  576056
  576075
  576079
  576119
  576343
  576344
  576345
  576360
  576364
  576401
  576403
  576416
  584813
  598704
  599531
  615645
  640690
  649566
  679379
  679389
  684802
  693269
  704044
]
2.14 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.12 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful porn russian"
]
1.62 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая porn русск"
]
1.57 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая porn русск"
]

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.