GET https://search.jues.net/search/embeds/9?q=anal%20big%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.66 ms
(83.68%)
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
  28625
  33284
  384593
  387522
  392538
  393741
  396088
  396235
  411184
  413649
  424370
  430709
  442084
  453130
  454092
  461686
  469294
  472906
  480727
  487359
  490562
  492523
  500442
  504083
  509108
  511269
  527649
  538997
  545199
  564765
  567311
  582222
  600543
  609854
  610589
  613494
  618363
  623290
  627708
  633238
  640891
  648514
  660698
  661935
  665727
  672070
  680751
  690510
  706535
  708677
  708909
  710391
  713067
  713507
  716286
  716289
  717134
  720117
  720395
  720397
  720753
  721187
  723946
  725549
  726277
  726847
  727575
  729280
  733321
  736203
  737173
  737178
  737298
  740283
  742005
  750260
  750549
  756096
  757590
  759910
  760828
  761740
  761754
  764344
  766884
  767272
  769311
  769584
  769797
  770522
  770532
  771179
  771579
  774684
  775179
  775732
  775800
  776617
  783576
  788845
  791370
  798319
  800815
  809133
  810210
  810410
  811557
  814218
  814789
  815557
  817150
  820559
  821057
  821068
  822271
  825221
  825909
  825910
  827071
  827590
]
14.85 ms
(10.05%)
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
  413649
  815557
  538997
  769584
  454092
  500442
  825909
  527649
  661935
  713507
  716286
  623290
  800815
  757590
  737298
  742005
  756096
  770522
  810210
  396235
  387522
  487359
  480727
  504083
  509108
  511269
  461686
  690510
  766884
  764344
  613494
  733321
  726277
  740283
  430709
  567311
  424370
  545199
  721187
  788845
  798319
  750549
  791370
  726847
  453130
  442084
  490562
  814789
  827590
  814218
  821057
  582222
  564765
  716289
  648514
  713067
  717134
  640891
  775800
  776617
  767272
  820559
  827071
  665727
  720397
  720753
  672070
  680751
  708677
  660698
  710391
  720395
  609854
  633238
  618363
  774684
  775179
  783576
  810410
  775732
  809133
  723946
  759910
  761754
  736203
  750260
  771579
  725549
  729280
  760828
  761740
  770532
  727575
  720117
  825910
  28625
  811557
  384593
  393741
  411184
  817150
  821068
  825221
  822271
  706535
  708909
  610589
  627708
  769311
  771179
  769797
  396088
  600543
  737173
  737178
  33284
  392538
  469294
  472906
  492523
]
2.63 ms
(1.78%)
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
  28625
  33284
  384593
  387522
  392538
  393741
  396088
  396235
  411184
  413649
  424370
  430709
  442084
  453130
  454092
  461686
  469294
  472906
  480727
  487359
  490562
  492523
  500442
  504083
  509108
  511269
  527649
  538997
  545199
  564765
  567311
  582222
  600543
  609854
  610589
  613494
  618363
  623290
  627708
  633238
  640891
  648514
  660698
  661935
  665727
  672070
  680751
  690510
  706535
  708677
  708909
  710391
  713067
  713507
  716286
  716289
  717134
  720117
  720395
  720397
  720753
  721187
  723946
  725549
  726277
  726847
  727575
  729280
  733321
  736203
  737173
  737178
  737298
  740283
  742005
  750260
  750549
  756096
  757590
  759910
  760828
  761740
  761754
  764344
  766884
  767272
  769311
  769584
  769797
  770522
  770532
  771179
  771579
  774684
  775179
  775732
  775800
  776617
  783576
  788845
  791370
  798319
  800815
  809133
  810210
  810410
  811557
  814218
  814789
  815557
  817150
  820559
  821057
  821068
  822271
  825221
  825909
  825910
  827071
  827590
]
1.85 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal big latina"
]
1.71 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал большие латинская"
]
1.56 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал большие латинская"
]
1.51 ms
(1.02%)
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.