GET https://search.jues.net/search/embeds/4?q=amateur%20teen%20tight

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.15 ms
(85.07%)
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
  398261
  398429
  403921
  417154
  418560
  421718
  422420
  428738
  434571
  444933
  451309
  452567
  452735
  452737
  452738
  455585
  490538
  493770
  497417
  510071
  512486
  540975
  541259
  549087
  549091
  559083
  575041
  579650
  581505
  586970
  591765
  593745
  598482
  611491
  617100
  618782
  619171
  619612
  620974
  625292
  625985
  628801
  629179
  631116
  631521
  634371
  634990
  639092
  648178
  656603
  661658
  664214
  669309
  682397
  684404
  698847
  707143
  712582
  715404
  717546
  719303
  720101
  720164
  720419
  720996
  726297
  726869
  728326
  729312
  734626
  735516
  735719
  737186
  738835
  739230
  739804
  740295
  741106
  744750
  748901
  749793
  750147
  751213
  755006
  757347
  759602
  760513
  761009
  761098
  761177
  761462
  762934
  763087
  763415
  765095
  765262
  765449
  767417
  769041
  769045
  769064
  771172
  775686
  777559
  777649
  779979
  781355
  783087
  784281
  788199
  791220
  791285
  794004
  794039
  794154
  800799
  805647
  809859
  816649
  816810
]
14.18 ms
(8.67%)
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
  805647
  809859
  729312
  761098
  761462
  769045
  761009
  765095
  726297
  738835
  728326
  735719
  739230
  739804
  744750
  749793
  760513
  761177
  777649
  784281
  788199
  794039
  422420
  455585
  720164
  444933
  403921
  418560
  490538
  510071
  625985
  634371
  398429
  421718
  417154
  816810
  816649
  712582
  717546
  707143
  719303
  720419
  779979
  791285
  794004
  777559
  781355
  783087
  791220
  765262
  748901
  751213
  759602
  763087
  767417
  741106
  715404
  775686
  794154
  591765
  398261
  619171
  619612
  800799
  428738
  452567
  434571
  512486
  497417
  540975
  452738
  451309
  452735
  549087
  579650
  648178
  656603
  664214
  669309
  698847
  682397
  684404
  598482
  628801
  631116
  639092
  586970
  593745
  617100
  611491
  620974
  625292
  618782
  629179
  737186
  631521
  634990
  541259
  559083
  581505
  549091
  661658
  493770
  452737
  575041
  720101
  720996
  734626
  757347
  769041
  740295
  763415
  769064
  726869
  765449
  735516
  762934
  771172
  750147
  755006
]
2.83 ms
(1.73%)
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
  398261
  398429
  403921
  417154
  418560
  421718
  422420
  428738
  434571
  444933
  451309
  452567
  452735
  452737
  452738
  455585
  490538
  493770
  497417
  510071
  512486
  540975
  541259
  549087
  549091
  559083
  575041
  579650
  581505
  586970
  591765
  593745
  598482
  611491
  617100
  618782
  619171
  619612
  620974
  625292
  625985
  628801
  629179
  631116
  631521
  634371
  634990
  639092
  648178
  656603
  661658
  664214
  669309
  682397
  684404
  698847
  707143
  712582
  715404
  717546
  719303
  720101
  720164
  720419
  720996
  726297
  726869
  728326
  729312
  734626
  735516
  735719
  737186
  738835
  739230
  739804
  740295
  741106
  744750
  748901
  749793
  750147
  751213
  755006
  757347
  759602
  760513
  761009
  761098
  761177
  761462
  762934
  763087
  763415
  765095
  765262
  765449
  767417
  769041
  769045
  769064
  771172
  775686
  777559
  777649
  779979
  781355
  783087
  784281
  788199
  791220
  791285
  794004
  794039
  794154
  800799
  805647
  809859
  816649
  816810
]
2.04 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск teen tight"
]
1.98 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск teen tight"
]
1.80 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur teen tight"
]
1.58 ms
(0.97%)
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.