GET https://search.jues.net/search/embeds/3?q=public%20big%20booty

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.91 ms
(84.76%)
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
  31015
  205133
  386701
  390098
  394739
  396406
  397316
  398858
  401552
  402882
  403968
  404281
  407019
  416184
  419298
  419299
  419471
  421057
  426560
  430493
  433230
  435938
  444058
  444405
  444456
  447956
  452182
  452194
  452394
  453408
  453420
  453484
  453804
  454569
  454697
  454948
  456800
  457207
  457581
  458832
  462222
  464148
  464862
  465291
  465680
  466934
  468845
  472469
  474982
  482668
  483416
  486647
  487529
  489292
  494086
  500008
  502614
  503742
  503805
  507630
  507668
  510521
  512483
  518347
  518353
  519702
  520010
  521524
  521657
  524358
  527177
  529375
  530079
  532441
  535155
  536427
  536728
  554867
  557628
  557716
  577792
  584711
  590057
  592953
  594500
  596943
  599234
  602944
  605205
  612356
  623645
  631572
  642367
  642490
  644244
  647666
  652159
  658146
  662927
  663524
  663898
  685389
  689737
  690510
  691989
  745415
  767995
  774533
  775630
  776613
  781283
  782659
  786717
  787867
  792996
  796372
  803582
  809236
  809265
  813205
]
17.62 ms
(9.46%)
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
  623645
  809236
  536728
  403968
  447956
  518347
  592953
  584711
  205133
  444456
  532441
  685389
  658146
  813205
  774533
  803582
  776613
  433230
  689737
  419298
  782659
  402882
  407019
  464148
  494086
  590057
  444405
  454697
  453484
  521657
  458832
  465291
  512483
  652159
  642490
  781283
  786717
  435938
  454948
  486647
  487529
  663898
  745415
  809265
  518353
  557628
  419299
  457581
  464862
  792996
  457207
  452194
  430493
  612356
  527177
  397316
  690510
  647666
  605205
  444058
  507630
  519702
  472469
  452182
  503805
  421057
  453804
  466934
  691989
  775630
  796372
  767995
  452394
  453420
  510521
  520010
  483416
  500008
  524358
  530079
  535155
  398858
  557716
  396406
  529375
  386701
  394739
  426560
  419471
  456800
  454569
  554867
  577792
  662927
  642367
  596943
  787867
  474982
  465680
  462222
  489292
  502614
  482668
  404281
  468845
  602944
  416184
  507668
  644244
  503742
  453408
  521524
  536427
  594500
  599234
  631572
  401552
  31015
  390098
  663524
]
3.27 ms
(1.75%)
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
  31015
  205133
  386701
  390098
  394739
  396406
  397316
  398858
  401552
  402882
  403968
  404281
  407019
  416184
  419298
  419299
  419471
  421057
  426560
  430493
  433230
  435938
  444058
  444405
  444456
  447956
  452182
  452194
  452394
  453408
  453420
  453484
  453804
  454569
  454697
  454948
  456800
  457207
  457581
  458832
  462222
  464148
  464862
  465291
  465680
  466934
  468845
  472469
  474982
  482668
  483416
  486647
  487529
  489292
  494086
  500008
  502614
  503742
  503805
  507630
  507668
  510521
  512483
  518347
  518353
  519702
  520010
  521524
  521657
  524358
  527177
  529375
  530079
  532441
  535155
  536427
  536728
  554867
  557628
  557716
  577792
  584711
  590057
  592953
  594500
  596943
  599234
  602944
  605205
  612356
  623645
  631572
  642367
  642490
  644244
  647666
  652159
  658146
  662927
  663524
  663898
  685389
  689737
  690510
  691989
  745415
  767995
  774533
  775630
  776613
  781283
  782659
  786717
  787867
  792996
  796372
  803582
  809236
  809265
  813205
]
2.32 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.24 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public big booty"
]
1.54 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц большие booty"
]
1.42 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц большие booty"
]

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.