GET https://search.jues.net/search/embeds/6?q=pov%20ass%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.99 ms
(85.33%)
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
  399924
  402441
  410853
  413746
  418193
  420642
  420643
  422030
  423516
  424088
  424164
  426374
  427373
  428537
  429416
  433352
  440164
  441280
  441562
  441782
  441788
  441935
  441957
  442101
  443924
  443992
  444236
  448466
  453717
  456141
  456338
  456416
  459193
  464705
  470551
  476874
  486610
  487045
  491462
  492946
  496850
  499496
  500963
  502341
  505164
  505845
  505973
  508560
  509189
  511699
  517306
  527197
  529236
  533241
  558592
  565588
  565819
  566242
  574060
  575286
  583000
  584170
  584465
  588531
  589521
  591705
  592289
  593988
  594237
  595638
  596943
  599034
  599234
  601494
  612521
  615335
  626143
  632541
  634253
  634412
  637309
  641228
  641904
  643997
  646421
  646624
  650063
  691928
  692762
  699494
  732211
  734637
  750342
  755118
  760241
  766107
  767220
  768450
  770030
  770977
  775187
  776277
  777456
  783374
  783992
  785006
  791862
  794095
  796891
  810435
  819329
  819735
  823663
  823735
  824648
  827107
  827331
  828176
]
12.06 ms
(8.10%)
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
  632541
  641904
  588531
  637309
  634253
  785006
  750342
  760241
  768450
  755118
  791862
  796891
  505845
  491462
  784532
  783374
  584465
  418193
  453717
  574060
  583000
  699494
  650063
  566242
  595638
  470551
  476874
  517306
  529236
  599034
  591705
  766674
  399924
  443924
  424164
  441957
  426374
  824648
  584170
  646624
  766107
  427373
  456416
  422030
  424088
  441562
  444236
  433352
  456338
  500963
  511699
  499496
  527197
  828176
  626143
  767220
  776277
  783992
  732211
  734637
  770977
  413746
  428537
  423516
  441935
  459193
  456141
  505164
  508560
  575286
  593988
  596943
  440164
  429416
  509189
  827331
  615335
  601494
  641228
  775187
  810435
  823663
  823735
  827107
  819329
  643997
  442101
  492946
  448466
  533241
  464705
  565819
  777456
  420642
  410853
  420643
  443992
  441280
  487045
  558592
  599234
  594237
  402441
  502341
  486610
  496850
  505973
  819735
  691928
  565588
  589521
  592289
  612521
  634412
  794095
  770030
  646421
  692762
  441782
  441788
]
3.03 ms
(2.04%)
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
  399924
  402441
  410853
  413746
  418193
  420642
  420643
  422030
  423516
  424088
  424164
  426374
  427373
  428537
  429416
  433352
  440164
  441280
  441562
  441782
  441788
  441935
  441957
  442101
  443924
  443992
  444236
  448466
  453717
  456141
  456338
  456416
  459193
  464705
  470551
  476874
  486610
  487045
  491462
  492946
  496850
  499496
  500963
  502341
  505164
  505845
  505973
  508560
  509189
  511699
  517306
  527197
  529236
  533241
  558592
  565588
  565819
  566242
  574060
  575286
  583000
  584170
  584465
  588531
  589521
  591705
  592289
  593988
  594237
  595638
  596943
  599034
  599234
  601494
  612521
  615335
  626143
  632541
  634253
  634412
  637309
  641228
  641904
  643997
  646421
  646624
  650063
  691928
  692762
  699494
  732211
  734637
  750342
  755118
  760241
  766107
  767220
  768450
  770030
  770977
  775187
  776277
  777456
  783374
  783992
  785006
  791862
  794095
  796891
  810435
  819329
  819735
  823663
  823735
  824648
  827107
  827331
  828176
]
1.78 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov ass doggy"
]
1.77 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов жоп рак"
]
1.61 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов жоп рак"
]
1.57 ms
(1.06%)
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.