GET https://search.jues.net/search/embeds/6?q=threesome%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
250.87 ms
(87.28%)
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
  35344
  249637
  384306
  388957
  395684
  395706
  395723
  395863
  399401
  400178
  400191
  404412
  409184
  410038
  411745
  415540
  417837
  420891
  421073
  428474
  438424
  447814
  455890
  456148
  456423
  458200
  459896
  467815
  468536
  470631
  473969
  474549
  477361
  480468
  487174
  492691
  495740
  495741
  504161
  504930
  505318
  511557
  513608
  516221
  518589
  522832
  527413
  533851
  533954
  539073
  543509
  543618
  550305
  551195
  559029
  564668
  565929
  569070
  573394
  578610
  585332
  585753
  586940
  587852
  588762
  591369
  603724
  606540
  610108
  623178
  629969
  631908
  633079
  640029
  641930
  644268
  651190
  654246
  664845
  669175
  670056
  674495
  678128
  689650
  692859
  696949
  706960
  712826
  712828
  718747
  719887
  724425
  732559
  734481
  737394
  740690
  752164
  755082
  772024
  779567
  781990
  782002
  786230
  789694
  792621
  792626
  797849
  805541
  807191
  807907
  808621
  809932
  813913
  814781
  814975
  815202
  816553
  823242
  826663
  827828
]
24.98 ms
(8.69%)
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
  428474
  823242
  477361
  569070
  543618
  585753
  473969
  495740
  505318
  585332
  640029
  511557
  718747
  724425
  732559
  400191
  522832
  807191
  495741
  606540
  573394
  417837
  797849
  559029
  504161
  737394
  395706
  409184
  35344
  399401
  468536
  527413
  654246
  588762
  734481
  740690
  805541
  395723
  447814
  487174
  678128
  504930
  388957
  411745
  410038
  816553
  814975
  815202
  480468
  516221
  539073
  550305
  551195
  651190
  689650
  610108
  623178
  587852
  779567
  752164
  755082
  395684
  456423
  420891
  395863
  400178
  415540
  474549
  467815
  543509
  670056
  706960
  586940
  789694
  807907
  633079
  781990
  421073
  384306
  455890
  458200
  470631
  456148
  518589
  513608
  438424
  814781
  459896
  492691
  578610
  692859
  719887
  696949
  669175
  644268
  629969
  631908
  782002
  792621
  792626
  809932
  772024
  712826
  786230
  249637
  404412
  826663
  813913
  533851
  565929
  674495
  712828
  808621
  827828
  533954
  564668
  664845
  641930
  591369
  603724
]
4.14 ms
(1.44%)
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
  35344
  249637
  384306
  388957
  395684
  395706
  395723
  395863
  399401
  400178
  400191
  404412
  409184
  410038
  411745
  415540
  417837
  420891
  421073
  428474
  438424
  447814
  455890
  456148
  456423
  458200
  459896
  467815
  468536
  470631
  473969
  474549
  477361
  480468
  487174
  492691
  495740
  495741
  504161
  504930
  505318
  511557
  513608
  516221
  518589
  522832
  527413
  533851
  533954
  539073
  543509
  543618
  550305
  551195
  559029
  564668
  565929
  569070
  573394
  578610
  585332
  585753
  586940
  587852
  588762
  591369
  603724
  606540
  610108
  623178
  629969
  631908
  633079
  640029
  641930
  644268
  651190
  654246
  664845
  669175
  670056
  674495
  678128
  689650
  692859
  696949
  706960
  712826
  712828
  718747
  719887
  724425
  732559
  734481
  737394
  740690
  752164
  755082
  772024
  779567
  781990
  782002
  786230
  789694
  792621
  792626
  797849
  805541
  807191
  807907
  808621
  809932
  813913
  814781
  814975
  815202
  816553
  823242
  826663
  827828
]
2.08 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome hot"
]
1.94 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро hot"
]
1.74 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро hot"
]

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.