GET https://search.jues.net/search/embeds/8?q=russian%20girl%20hidden

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.43 ms
(86.10%)
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
  389821
  419013
  423767
  435290
  435746
  438312
  449039
  451307
  455339
  455471
  456857
  460548
  462272
  463168
  464268
  465481
  467227
  467368
  467494
  467810
  470340
  470716
  472038
  475008
  478340
  478753
  479394
  481849
  482927
  483256
  484124
  485429
  485485
  487372
  488512
  491721
  495678
  498827
  498855
  503798
  503920
  504152
  504185
  504351
  505477
  506718
  506786
  508588
  521963
  522514
  525565
  534105
  544725
  548780
  551030
  552862
  555973
  556449
  559035
  574580
  582592
  584784
  587443
  589014
  593512
  594987
  595601
  595884
  598557
  598772
  598781
  601277
  601551
  608833
  609402
  610595
  614417
  614979
  647255
  659197
  673533
  674516
  674620
  689956
  690748
  696070
  696178
  705020
  705399
  709484
  721241
  725441
  731164
  735687
  737465
  740096
  744368
  745193
  758158
  761603
  761637
  768939
  771658
  777900
  779607
  779624
  780328
  783531
  784200
  784228
  785127
  788120
  788416
  788428
  799712
  801675
  804422
  806212
  811876
  813761
]
15.79 ms
(8.75%)
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
  690748
  696070
  705020
  709484
  673533
  551030
  593512
  587443
  780328
  784228
  785127
  788120
  799712
  801675
  740096
  768939
  608833
  705399
  438312
  455339
  389821
  478340
  559035
  556449
  584784
  696178
  582592
  595884
  598781
  614979
  811876
  761603
  614417
  779624
  806212
  451307
  449039
  488512
  491721
  482927
  522514
  574580
  455471
  470716
  462272
  463168
  503798
  525565
  498827
  771658
  610595
  813761
  487372
  467227
  534105
  544725
  674620
  647255
  674516
  721241
  595601
  598772
  589014
  784200
  788428
  761637
  735687
  744368
  737465
  788416
  470340
  479394
  419013
  467810
  467368
  464268
  465481
  508588
  521963
  503920
  555973
  548780
  435746
  485485
  484124
  472038
  552862
  659197
  689956
  601277
  594987
  598557
  609402
  777900
  745193
  783531
  725441
  758158
  731164
  779607
  804422
  475008
  506786
  601551
  456857
  467494
  423767
  435290
  460548
  481849
  478753
  504185
  504351
  506718
  498855
  505477
  483256
  485429
  495678
  504152
]
2.38 ms
(1.32%)
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
  389821
  419013
  423767
  435290
  435746
  438312
  449039
  451307
  455339
  455471
  456857
  460548
  462272
  463168
  464268
  465481
  467227
  467368
  467494
  467810
  470340
  470716
  472038
  475008
  478340
  478753
  479394
  481849
  482927
  483256
  484124
  485429
  485485
  487372
  488512
  491721
  495678
  498827
  498855
  503798
  503920
  504152
  504185
  504351
  505477
  506718
  506786
  508588
  521963
  522514
  525565
  534105
  544725
  548780
  551030
  552862
  555973
  556449
  559035
  574580
  582592
  584784
  587443
  589014
  593512
  594987
  595601
  595884
  598557
  598772
  598781
  601277
  601551
  608833
  609402
  610595
  614417
  614979
  647255
  659197
  673533
  674516
  674620
  689956
  690748
  696070
  696178
  705020
  705399
  709484
  721241
  725441
  731164
  735687
  737465
  740096
  744368
  745193
  758158
  761603
  761637
  768939
  771658
  777900
  779607
  779624
  780328
  783531
  784200
  784228
  785127
  788120
  788416
  788428
  799712
  801675
  804422
  806212
  811876
  813761
]
1.92 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian girl hidden"
]
1.88 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск девушк скрыт"
]
1.47 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.