GET https://search.jues.net/search/embeds/7?q=pov%20vagina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.44 ms
(82.09%)
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
  414078
  417238
  424778
  425422
  426968
  427916
  433814
  446218
  452290
  458545
  463793
  464855
  476153
  478069
  481383
  487268
  489165
  493858
  500880
  502854
  503069
  504866
  506243
  507018
  510901
  511247
  526590
  528511
  531000
  537173
  540766
  547103
  549102
  550525
  551729
  552689
  552737
  555251
  555467
  556289
  560990
  562018
  563005
  563684
  565762
  565935
  567614
  568334
  570131
  571353
  572649
  576421
  577020
  577446
  577460
  578156
  582931
  584155
  584469
  584944
  585289
  585595
  586309
  587769
  588181
  588526
  589857
  591822
  593722
  604747
  606991
  617974
  622529
  626298
  628677
  629443
  629784
  633634
  636252
  639260
  645698
  647108
  648057
  662889
  663174
  663704
  663738
  664745
  667098
  669279
  671218
  672795
  673212
  679000
  679660
  679836
  685805
  692841
  693345
  694614
  696373
  701819
  717127
  754865
  764833
  767276
  773002
  773844
  777320
  779890
  780764
  785328
  789180
  791252
  794582
  797012
  797682
  798718
  798793
  809307
]
16.26 ms
(10.64%)
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
  584469
  552689
  570131
  577460
  552737
  663704
  667098
  671218
  672795
  679660
  679836
  673212
  685805
  694614
  645698
  647108
  662889
  663174
  663738
  664745
  669279
  679000
  692841
  693345
  696373
  547103
  549102
  565935
  585289
  604747
  628677
  629784
  633634
  636252
  588526
  589857
  617974
  639260
  585595
  606991
  629443
  779890
  785328
  798718
  798793
  809307
  780764
  791252
  794582
  797012
  789180
  797682
  764833
  773002
  754865
  767276
  773844
  701819
  777320
  424778
  458545
  507018
  563684
  588181
  414078
  425422
  433814
  537173
  576421
  555467
  577020
  577446
  550525
  556289
  591822
  622529
  481383
  478069
  487268
  540766
  562018
  563005
  565762
  567614
  568334
  648057
  555251
  584944
  587769
  593722
  586309
  446218
  476153
  504866
  502854
  493858
  417238
  551729
  626298
  426968
  427916
  463793
  452290
  464855
  500880
  503069
  510901
  511247
  506243
  526590
  528511
  531000
  489165
  571353
  572649
  578156
  582931
  560990
  584155
  717127
]
3.39 ms
(2.22%)
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
  414078
  417238
  424778
  425422
  426968
  427916
  433814
  446218
  452290
  458545
  463793
  464855
  476153
  478069
  481383
  487268
  489165
  493858
  500880
  502854
  503069
  504866
  506243
  507018
  510901
  511247
  526590
  528511
  531000
  537173
  540766
  547103
  549102
  550525
  551729
  552689
  552737
  555251
  555467
  556289
  560990
  562018
  563005
  563684
  565762
  565935
  567614
  568334
  570131
  571353
  572649
  576421
  577020
  577446
  577460
  578156
  582931
  584155
  584469
  584944
  585289
  585595
  586309
  587769
  588181
  588526
  589857
  591822
  593722
  604747
  606991
  617974
  622529
  626298
  628677
  629443
  629784
  633634
  636252
  639260
  645698
  647108
  648057
  662889
  663174
  663704
  663738
  664745
  667098
  669279
  671218
  672795
  673212
  679000
  679660
  679836
  685805
  692841
  693345
  694614
  696373
  701819
  717127
  754865
  764833
  767276
  773002
  773844
  777320
  779890
  780764
  785328
  789180
  791252
  794582
  797012
  797682
  798718
  798793
  809307
]
2.24 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov vagina"
]
1.92 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов вагин"
]
1.69 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.