GET https://search.jues.net/search/embeds/4?q=doggy%20pov%20%D1%85%D1%83%D0%B4%D1%8B%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.85 ms
(87.29%)
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
  406621
  416928
  420719
  443396
  444774
  445267
  445616
  451907
  452201
  462111
  462740
  477196
  478208
  478681
  479248
  481059
  481150
  485796
  490855
  494991
  496636
  499572
  504713
  506579
  508612
  509558
  510142
  511048
  511481
  511689
  514400
  516517
  520783
  521896
  523987
  525300
  527250
  528378
  529048
  529349
  529426
  534590
  534600
  538984
  539889
  540985
  541686
  541727
  541948
  546332
  547911
  548043
  548690
  549458
  551456
  551478
  553650
  553784
  555651
  559824
  560672
  560799
  560971
  561633
  561861
  562120
  562211
  562284
  563575
  564348
  566836
  567402
  567646
  567701
  568629
  568687
  568701
  569058
  569466
  569471
  569638
  570988
  574731
  575535
  578108
  578865
  579875
  581133
  583512
  584087
  584131
  584867
  588568
  588726
  589200
  589729
  591921
  595226
  595512
  598874
  599261
  602651
  605986
  610121
  610300
  612055
  614935
  616939
  617899
  617969
  619340
  626080
  627578
  637418
  648939
  664630
  678620
  764654
  779193
  812697
]
14.33 ms
(7.87%)
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
  499572
  523987
  529048
  527250
  534590
  511481
  534600
  538984
  481059
  541948
  548690
  551478
  553784
  560799
  562211
  567402
  567646
  568629
  569471
  569638
  578865
  548043
  549458
  559824
  560971
  561633
  561861
  562120
  564348
  566836
  568701
  541686
  547911
  560672
  567701
  569466
  581133
  583512
  584131
  584867
  648939
  664630
  678620
  555651
  562284
  563575
  568687
  569058
  570988
  578108
  579875
  588568
  598874
  610121
  617969
  626080
  589729
  591921
  595512
  602651
  612055
  614935
  637418
  588726
  599261
  616939
  589200
  610300
  617899
  812697
  764654
  619340
  627578
  779193
  462111
  444774
  477196
  479248
  445616
  462740
  478208
  511689
  521896
  525300
  528378
  508612
  511048
  509558
  510142
  516517
  496636
  553650
  574731
  595226
  584087
  575535
  406621
  551456
  605986
  445267
  506579
  514400
  529349
  443396
  416928
  420719
  451907
  478681
  481150
  485796
  452201
  539889
  504713
  520783
  494991
  529426
  490855
  540985
  541727
  546332
]
2.36 ms
(1.30%)
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
  406621
  416928
  420719
  443396
  444774
  445267
  445616
  451907
  452201
  462111
  462740
  477196
  478208
  478681
  479248
  481059
  481150
  485796
  490855
  494991
  496636
  499572
  504713
  506579
  508612
  509558
  510142
  511048
  511481
  511689
  514400
  516517
  520783
  521896
  523987
  525300
  527250
  528378
  529048
  529349
  529426
  534590
  534600
  538984
  539889
  540985
  541686
  541727
  541948
  546332
  547911
  548043
  548690
  549458
  551456
  551478
  553650
  553784
  555651
  559824
  560672
  560799
  560971
  561633
  561861
  562120
  562211
  562284
  563575
  564348
  566836
  567402
  567646
  567701
  568629
  568687
  568701
  569058
  569466
  569471
  569638
  570988
  574731
  575535
  578108
  578865
  579875
  581133
  583512
  584087
  584131
  584867
  588568
  588726
  589200
  589729
  591921
  595226
  595512
  598874
  599261
  602651
  605986
  610121
  610300
  612055
  614935
  616939
  617899
  617969
  619340
  626080
  627578
  637418
  648939
  664630
  678620
  764654
  779193
  812697
]
1.74 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy pov худые"
]
1.62 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак пов худые"
]
1.58 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак пов худые"
]
1.49 ms
(0.82%)
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.