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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.12 ms
(82.24%)
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
  425875
  429077
  429328
  446126
  447147
  447436
  447507
  447551
  447934
  475413
  484879
  490176
  491657
  491683
  491705
  491717
  491721
  491733
  496585
  501653
  502722
  510618
  510619
  510623
  511707
  511728
  512236
  512256
  512257
  512283
  512286
  512333
  513272
  513281
  513284
  513292
  522590
  522811
  523285
  523999
  524694
  526774
  527623
  534103
  534114
  535640
  537971
  538217
  538229
  539126
  543749
  546603
  551211
  552121
  558840
  566630
  567764
  570046
  571619
  571647
  572999
  573015
  573022
  573083
  573421
  573568
  573573
  573663
  573788
  573852
  573901
  574511
  574522
  574808
  574810
  574818
  574873
  574902
  574914
  575066
  575085
  575122
  575137
  575159
  575162
  575202
  575203
  575207
  575452
  575454
  575478
  575479
  575483
  575520
  575751
  575757
  575805
  575812
  576028
  576054
  576057
  576059
  576076
  576084
  576351
  576406
  576414
  597977
  624829
  634504
  679380
  679385
  685425
  693278
  701501
  714948
  730724
  766248
  798990
  814556
]
19.83 ms
(11.55%)
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
  447436
  490176
  510619
  496585
  523999
  814556
  537971
  766248
  798990
  425875
  429077
  543749
  552121
  573083
  573421
  575757
  546603
  573901
  576084
  685425
  574522
  574902
  576059
  634504
  475413
  510623
  526774
  534103
  534114
  551211
  566630
  567764
  571647
  572999
  573852
  575159
  575805
  575085
  575202
  575454
  576057
  576406
  571619
  573568
  574810
  574818
  574914
  575452
  575520
  575812
  576028
  576054
  679380
  693278
  701501
  679385
  714948
  573015
  573022
  575478
  575483
  576076
  576351
  624829
  730724
  447934
  522590
  522811
  527623
  491721
  512236
  513292
  538217
  510618
  512283
  513284
  523285
  524694
  491705
  513281
  538229
  539126
  574808
  575066
  575122
  575203
  576414
  573573
  573788
  575137
  575207
  573663
  574873
  575751
  597977
  429328
  446126
  447507
  447147
  447551
  484879
  512256
  535640
  491657
  501653
  502722
  511707
  512286
  491717
  491733
  511728
  513272
  575479
  558840
  574511
  575162
  570046
  512257
  491683
  512333
]
3.49 ms
(2.04%)
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
  425875
  429077
  429328
  446126
  447147
  447436
  447507
  447551
  447934
  475413
  484879
  490176
  491657
  491683
  491705
  491717
  491721
  491733
  496585
  501653
  502722
  510618
  510619
  510623
  511707
  511728
  512236
  512256
  512257
  512283
  512286
  512333
  513272
  513281
  513284
  513292
  522590
  522811
  523285
  523999
  524694
  526774
  527623
  534103
  534114
  535640
  537971
  538217
  538229
  539126
  543749
  546603
  551211
  552121
  558840
  566630
  567764
  570046
  571619
  571647
  572999
  573015
  573022
  573083
  573421
  573568
  573573
  573663
  573788
  573852
  573901
  574511
  574522
  574808
  574810
  574818
  574873
  574902
  574914
  575066
  575085
  575122
  575137
  575159
  575162
  575202
  575203
  575207
  575452
  575454
  575478
  575479
  575483
  575520
  575751
  575757
  575805
  575812
  576028
  576054
  576057
  576059
  576076
  576084
  576351
  576406
  576414
  597977
  624829
  634504
  679380
  679385
  685425
  693278
  701501
  714948
  730724
  766248
  798990
  814556
]
1.97 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian teen porn"
]
1.81 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск teen porn"
]
1.66 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск teen 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.