GET https://search.jues.net/search/embeds/6?q=casting%20xxx%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.54 ms
(83.47%)
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
  53828
  386535
  411828
  411846
  415941
  417741
  418531
  424877
  426179
  427221
  432790
  447471
  447533
  448808
  448823
  451755
  458414
  467968
  474752
  482686
  484457
  489243
  491565
  495417
  496835
  498536
  503056
  515896
  523970
  525236
  525411
  527265
  528293
  528297
  536128
  537821
  540276
  550001
  552399
  565324
  580591
  580989
  592805
  598135
  598754
  600146
  600444
  605315
  610034
  615978
  628421
  634528
  637075
  642778
  650230
  650312
  652874
  652911
  673665
  673767
  680143
  683052
  690144
  691915
  699899
  701001
  702629
  702630
  702636
  704232
  706596
  707308
  708813
  709738
  715125
  715808
  717870
  717890
  717912
  717947
  718666
  718679
  718930
  720697
  721132
  721566
  722052
  722565
  724206
  725111
  725174
  727773
  728429
  730757
  735935
  735964
  740637
  741193
  743278
  745424
  746802
  746894
  747138
  747142
  747452
  747519
  748524
  748701
  750755
  756001
  756073
  758523
  758725
  758963
  758989
  760453
  761555
  766846
  795169
  800423
]
14.41 ms
(9.89%)
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
  451755
  458414
  550001
  552399
  411828
  411846
  418531
  432790
  447533
  537821
  525411
  503056
  523970
  528293
  536128
  540276
  580591
  642778
  748524
  724206
  708813
  721132
  722052
  427221
  415941
  474752
  605315
  467968
  386535
  615978
  680143
  743278
  702630
  426179
  424877
  417741
  447471
  448808
  448823
  498536
  565324
  491565
  495417
  496835
  525236
  528297
  527265
  482686
  484457
  489243
  515896
  53828
  580989
  650230
  650312
  673767
  699899
  701001
  704232
  717870
  720697
  652911
  673665
  683052
  706596
  717890
  718930
  652874
  690144
  691915
  709738
  717912
  717947
  721566
  722565
  592805
  600146
  600444
  610034
  637075
  598135
  598754
  628421
  795169
  725111
  725174
  730757
  746802
  746894
  747142
  747452
  747519
  756001
  758989
  760453
  800423
  747138
  750755
  758523
  728429
  745424
  748701
  758963
  735964
  740637
  761555
  766846
  727773
  735935
  741193
  756073
  758725
  634528
  702629
  702636
  707308
  715125
  715808
  718666
  718679
]
2.84 ms
(1.95%)
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
  53828
  386535
  411828
  411846
  415941
  417741
  418531
  424877
  426179
  427221
  432790
  447471
  447533
  448808
  448823
  451755
  458414
  467968
  474752
  482686
  484457
  489243
  491565
  495417
  496835
  498536
  503056
  515896
  523970
  525236
  525411
  527265
  528293
  528297
  536128
  537821
  540276
  550001
  552399
  565324
  580591
  580989
  592805
  598135
  598754
  600146
  600444
  605315
  610034
  615978
  628421
  634528
  637075
  642778
  650230
  650312
  652874
  652911
  673665
  673767
  680143
  683052
  690144
  691915
  699899
  701001
  702629
  702630
  702636
  704232
  706596
  707308
  708813
  709738
  715125
  715808
  717870
  717890
  717912
  717947
  718666
  718679
  718930
  720697
  721132
  721566
  722052
  722565
  724206
  725111
  725174
  727773
  728429
  730757
  735935
  735964
  740637
  741193
  743278
  745424
  746802
  746894
  747138
  747142
  747452
  747519
  748524
  748701
  750755
  756001
  756073
  758523
  758725
  758963
  758989
  760453
  761555
  766846
  795169
  800423
]
1.90 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting xxx anal"
]
1.75 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг xxx анал"
]
1.60 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг xxx анал"
]

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.