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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.53 ms
(84.52%)
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
  225519
  287436
  383249
  386771
  387006
  387678
  388078
  390776
  392632
  395825
  396088
  396186
  396190
  397063
  398425
  401135
  403904
  405088
  414194
  416898
  424386
  429323
  436627
  443489
  447137
  447634
  447912
  447999
  451594
  452864
  453663
  453790
  454790
  457030
  461738
  463912
  464903
  465315
  468094
  470273
  472353
  472450
  475250
  477082
  479987
  489888
  490076
  494062
  494409
  496750
  497467
  499134
  504672
  511722
  513299
  513690
  517990
  525523
  536262
  536271
  544782
  552430
  555801
  575065
  575484
  575618
  581229
  590165
  595512
  597041
  597560
  597968
  598479
  598599
  600159
  600945
  604180
  615148
  619780
  632118
  632593
  637851
  639959
  646662
  658728
  660321
  670997
  671616
  681198
  690439
  691217
  698434
  708413
  709589
  714667
  714994
  716633
  717902
  719292
  720749
  720967
  721322
  723539
  726176
  728404
  742161
  742242
  743069
  746802
  747153
  747502
  753304
  753327
  753351
  755677
  756687
  760908
  775919
  791663
  806332
]
13.79 ms
(9.00%)
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
  720967
  598479
  597041
  615148
  597560
  753351
  726176
  728404
  753304
  753327
  755677
  806332
  517990
  386771
  575065
  575484
  632593
  536262
  392632
  401135
  403904
  424386
  429323
  472450
  477082
  451594
  453663
  465315
  447912
  453790
  496750
  464903
  690439
  717902
  708413
  600159
  595512
  747153
  747502
  388078
  398425
  414194
  396186
  396190
  443489
  447634
  396088
  405088
  416898
  447999
  457030
  470273
  472353
  489888
  494062
  511722
  490076
  513690
  525523
  494409
  513299
  658728
  691217
  597968
  619780
  746802
  756687
  225519
  287436
  390776
  723539
  475250
  463912
  497467
  499134
  504672
  536271
  581229
  670997
  720749
  639959
  590165
  600945
  598599
  742161
  709589
  775919
  387678
  395825
  447137
  452864
  461738
  383249
  387006
  479987
  436627
  468094
  454790
  397063
  552430
  544782
  575618
  646662
  671616
  698434
  716633
  721322
  660321
  681198
  714667
  714994
  719292
  555801
  632118
  637851
  604180
  791663
  742242
  743069
  760908
]
3.18 ms
(2.08%)
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
  225519
  287436
  383249
  386771
  387006
  387678
  388078
  390776
  392632
  395825
  396088
  396186
  396190
  397063
  398425
  401135
  403904
  405088
  414194
  416898
  424386
  429323
  436627
  443489
  447137
  447634
  447912
  447999
  451594
  452864
  453663
  453790
  454790
  457030
  461738
  463912
  464903
  465315
  468094
  470273
  472353
  472450
  475250
  477082
  479987
  489888
  490076
  494062
  494409
  496750
  497467
  499134
  504672
  511722
  513299
  513690
  517990
  525523
  536262
  536271
  544782
  552430
  555801
  575065
  575484
  575618
  581229
  590165
  595512
  597041
  597560
  597968
  598479
  598599
  600159
  600945
  604180
  615148
  619780
  632118
  632593
  637851
  639959
  646662
  658728
  660321
  670997
  671616
  681198
  690439
  691217
  698434
  708413
  709589
  714667
  714994
  716633
  717902
  719292
  720749
  720967
  721322
  723539
  726176
  728404
  742161
  742242
  743069
  746802
  747153
  747502
  753304
  753327
  753351
  755677
  756687
  760908
  775919
  791663
  806332
]
2.00 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick teen"
]
1.83 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член teen"
]
1.52 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член teen"
]
1.40 ms
(0.92%)
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.