GET https://search.jues.net/search/embeds/7?q=big%20anal%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.66 ms
(82.45%)
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
  79765
  360015
  388719
  389351
  389729
  391477
  395860
  396249
  397361
  398969
  399585
  401077
  403324
  404994
  411352
  411897
  413524
  424410
  432306
  443695
  464420
  466244
  467124
  482602
  511268
  513149
  519945
  554321
  557572
  575723
  578158
  580623
  589472
  591008
  598508
  604143
  608091
  609052
  609878
  626535
  626539
  632051
  640784
  640785
  645891
  655071
  666968
  670103
  670109
  671640
  675807
  677726
  679388
  680141
  685001
  687928
  689001
  694219
  697298
  697374
  698293
  699626
  709781
  716277
  716787
  717610
  717677
  717895
  720197
  720306
  722050
  722557
  724509
  728384
  728446
  731857
  732054
  733862
  734692
  736911
  737152
  740704
  741158
  741896
  744276
  746423
  749116
  749919
  752685
  753890
  757367
  757643
  758226
  759543
  765299
  777250
  788277
  788284
  792636
  797247
  799360
  800625
  801319
  803461
  805433
  806084
  807497
  807617
  811624
  814933
  815722
  818167
  818278
  818406
  819573
  821369
  826285
  827152
]
18.45 ms
(11.13%)
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
  815722
  554321
  801319
  805433
  807617
  737152
  765299
  792636
  411897
  580623
  733862
  388719
  397361
  685001
  666968
  413524
  519945
  814933
  467124
  557572
  716787
  640785
  806084
  741158
  803461
  728446
  758226
  788284
  799360
  360015
  389729
  391477
  411352
  424410
  432306
  443695
  403324
  466244
  513149
  818406
  821369
  827152
  818167
  826285
  677726
  680141
  670109
  679388
  697298
  697374
  716277
  722557
  675807
  687928
  694219
  718662
  591008
  604143
  608091
  598508
  632051
  800625
  777250
  744276
  749116
  753890
  759543
  731857
  757643
  746423
  482602
  398969
  484232
  79765
  399585
  819573
  818278
  575723
  578158
  699626
  709781
  645891
  655071
  671640
  717677
  717895
  670103
  717610
  720306
  589472
  609878
  626539
  626535
  609052
  811624
  734692
  740704
  757367
  797247
  724509
  728384
  741896
  752685
  732054
  749919
  736911
  698293
  722050
  788277
  395860
  389351
  401077
  404994
  464420
  396249
  689001
  640784
  720197
  511268
  807497
]
2.81 ms
(1.69%)
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
  79765
  360015
  388719
  389351
  389729
  391477
  395860
  396249
  397361
  398969
  399585
  401077
  403324
  404994
  411352
  411897
  413524
  424410
  432306
  443695
  464420
  466244
  467124
  482602
  511268
  513149
  519945
  554321
  557572
  575723
  578158
  580623
  589472
  591008
  598508
  604143
  608091
  609052
  609878
  626535
  626539
  632051
  640784
  640785
  645891
  655071
  666968
  670103
  670109
  671640
  675807
  677726
  679388
  680141
  685001
  687928
  689001
  694219
  697298
  697374
  698293
  699626
  709781
  716277
  716787
  717610
  717677
  717895
  720197
  720306
  722050
  722557
  724509
  728384
  728446
  731857
  732054
  733862
  734692
  736911
  737152
  740704
  741158
  741896
  744276
  746423
  749116
  749919
  752685
  753890
  757367
  757643
  758226
  759543
  765299
  777250
  788277
  788284
  792636
  797247
  799360
  800625
  801319
  803461
  805433
  806084
  807497
  807617
  811624
  814933
  815722
  818167
  818278
  818406
  819573
  821369
  826285
  827152
]
2.20 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big anal old"
]
1.86 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие анал old"
]
1.79 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие анал old"
]

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.