GET https://search.jues.net/search/embeds/7?q=russian%20solo%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.44 ms
(81.65%)
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
  391911
  391925
  391986
  392007
  392021
  416644
  417396
  418519
  418522
  419352
  421366
  421856
  428282
  429867
  429880
  429889
  429890
  429900
  430267
  430374
  439010
  439320
  439326
  439797
  439993
  440682
  444052
  444527
  444915
  445868
  452936
  452950
  452964
  453394
  456230
  456244
  459198
  460314
  462236
  466467
  467872
  467877
  467929
  468142
  493398
  493411
  493490
  495140
  495559
  509970
  511857
  513627
  513641
  516246
  517797
  519358
  521798
  522280
  524687
  526577
  526612
  528142
  533461
  534035
  541841
  546987
  547767
  547807
  554210
  555008
  555023
  555062
  556338
  556875
  565308
  571358
  573175
  576128
  579031
  587272
  590418
  597450
  597781
  598668
  599001
  601519
  601792
  604662
  605745
  613976
  620648
  624168
  645369
  655295
  656107
  683083
  697459
  718678
  718785
  737052
  742636
  751291
  752626
  763724
  766335
  769335
  769732
  791127
  791489
  802899
  805120
  805139
  805146
  806668
  808337
  811296
  811765
  814434
  825838
  825864
]
18.93 ms
(12.13%)
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
  391911
  556338
  576128
  597450
  590418
  752626
  392007
  467872
  421856
  428282
  444527
  439010
  452964
  429880
  429889
  429867
  524687
  791127
  546987
  555023
  418519
  655295
  599001
  751291
  392021
  421366
  526577
  526612
  419352
  613976
  439797
  417396
  493411
  445868
  825864
  468142
  718678
  565308
  791489
  467877
  467929
  429890
  391986
  430374
  444052
  444915
  456244
  513627
  493398
  511857
  814434
  493490
  456230
  571358
  547807
  579031
  697459
  718785
  555062
  597781
  598668
  604662
  624168
  620648
  737052
  802899
  805120
  766335
  806668
  462236
  439320
  440682
  459198
  516246
  519358
  513641
  439326
  452950
  495559
  825838
  601519
  495140
  555008
  573175
  541841
  742636
  805146
  430267
  453394
  533461
  509970
  769732
  808337
  811765
  466467
  429900
  416644
  683083
  645369
  656107
  391925
  460314
  528142
  769335
  439993
  554210
  587272
  605745
  418522
  452936
  522280
  517797
  521798
  534035
  547767
  556875
  601792
  811296
  763724
  805139
]
2.54 ms
(1.63%)
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
  391911
  391925
  391986
  392007
  392021
  416644
  417396
  418519
  418522
  419352
  421366
  421856
  428282
  429867
  429880
  429889
  429890
  429900
  430267
  430374
  439010
  439320
  439326
  439797
  439993
  440682
  444052
  444527
  444915
  445868
  452936
  452950
  452964
  453394
  456230
  456244
  459198
  460314
  462236
  466467
  467872
  467877
  467929
  468142
  493398
  493411
  493490
  495140
  495559
  509970
  511857
  513627
  513641
  516246
  517797
  519358
  521798
  522280
  524687
  526577
  526612
  528142
  533461
  534035
  541841
  546987
  547767
  547807
  554210
  555008
  555023
  555062
  556338
  556875
  565308
  571358
  573175
  576128
  579031
  587272
  590418
  597450
  597781
  598668
  599001
  601519
  601792
  604662
  605745
  613976
  620648
  624168
  645369
  655295
  656107
  683083
  697459
  718678
  718785
  737052
  742636
  751291
  752626
  763724
  766335
  769335
  769732
  791127
  791489
  802899
  805120
  805139
  805146
  806668
  808337
  811296
  811765
  814434
  825838
  825864
]
2.34 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian solo anal"
]
1.79 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск соло анал"
]
1.45 ms
(0.93%)
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.