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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.34 ms
(85.70%)
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
  384547
  402735
  408429
  413093
  413685
  417491
  417952
  419030
  422415
  426357
  427006
  429960
  432514
  432552
  435706
  436132
  437635
  439033
  441020
  444912
  444937
  448587
  452923
  454842
  455585
  456567
  457134
  460343
  465815
  470090
  470137
  470205
  477386
  491718
  494386
  496061
  496698
  496750
  522288
  530292
  533667
  533777
  534117
  535634
  537974
  539238
  543533
  543540
  543717
  543719
  543727
  543745
  543829
  545185
  574606
  575127
  579049
  595455
  595517
  595521
  596649
  598141
  598197
  598448
  598543
  598549
  598597
  598728
  605829
  608438
  610346
  614566
  618769
  623440
  625405
  626083
  626255
  643590
  655504
  656545
  683303
  688939
  694164
  705809
  713369
  714656
  715627
  720164
  731043
  731581
  734189
  735115
  745336
  751692
  768042
  768715
  769198
  775574
  777080
  778256
  781331
  786093
  787484
  790446
  794003
  799900
  800305
  800487
  801978
  819940
  821845
  825705
  828442
  828560
  828657
  828763
  828780
  828786
]
17.28 ms
(9.47%)
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
  470137
  470205
  432552
  435706
  439033
  441020
  444937
  448587
  427006
  530292
  598728
  805492
  800487
  595521
  787484
  408429
  384547
  537974
  543727
  437635
  543533
  539238
  643590
  778256
  731043
  470090
  543719
  786093
  768042
  534117
  828763
  768715
  781331
  429960
  417952
  496750
  543829
  705809
  777080
  801978
  800305
  751692
  402735
  465815
  419030
  432514
  456567
  460343
  575127
  494386
  598448
  610346
  714656
  422415
  828786
  828560
  595517
  457134
  683303
  713369
  656545
  626083
  595455
  598549
  794003
  775574
  596649
  436132
  452923
  426357
  454842
  417491
  522288
  491718
  715627
  477386
  496698
  545185
  655504
  688939
  605829
  625405
  608438
  825705
  821845
  769198
  745336
  828780
  828657
  828442
  790446
  496061
  533777
  598197
  614566
  799900
  805512
  734189
  543717
  598597
  819940
  694164
  579049
  598543
  618769
  735115
  731581
  543745
  413093
  533667
  535634
  543540
  413685
  455585
  574606
  720164
  623440
  598141
  626255
  444912
]
2.72 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
  384547
  402735
  408429
  413093
  413685
  417491
  417952
  419030
  422415
  426357
  427006
  429960
  432514
  432552
  435706
  436132
  437635
  439033
  441020
  444912
  444937
  448587
  452923
  454842
  455585
  456567
  457134
  460343
  465815
  470090
  470137
  470205
  477386
  491718
  494386
  496061
  496698
  496750
  522288
  530292
  533667
  533777
  534117
  535634
  537974
  539238
  543533
  543540
  543717
  543719
  543727
  543745
  543829
  545185
  574606
  575127
  579049
  595455
  595517
  595521
  596649
  598141
  598197
  598448
  598543
  598549
  598597
  598728
  605829
  608438
  610346
  614566
  618769
  623440
  625405
  626083
  626255
  643590
  655504
  656545
  683303
  688939
  694164
  705809
  713369
  714656
  715627
  720164
  731043
  731581
  734189
  735115
  745336
  751692
  768042
  768715
  769198
  775574
  777080
  778256
  781331
  786093
  787484
  790446
  794003
  799900
  800305
  800487
  801978
  819940
  821845
  825705
  828442
  828560
  828657
  828763
  828780
  828786
]
1.85 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur russian teen"
]
1.44 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск русск teen"
]
1.43 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск русск teen"
]
1.36 ms
(0.75%)
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.