GET https://search.jues.net/search/embeds/5?q=wife%20car

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.96 ms
(85.44%)
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
  151163
  221320
  393350
  394273
  416455
  417672
  423978
  432384
  437265
  438010
  438047
  438100
  456027
  456220
  461161
  469783
  472075
  476473
  478143
  481567
  483295
  486420
  487604
  487751
  488878
  498210
  498317
  499780
  501066
  503020
  506315
  506492
  509709
  512757
  520281
  537622
  545896
  546851
  550121
  554101
  555549
  555670
  555672
  556154
  557596
  558715
  573344
  580007
  582448
  584343
  593714
  594312
  595848
  599795
  599805
  599818
  613614
  615079
  617710
  620825
  623731
  626841
  627167
  627237
  627505
  627570
  629727
  631514
  632926
  636127
  638054
  640964
  645806
  648612
  649862
  650275
  659065
  660090
  665089
  691618
  694386
  704343
  713924
  718703
  721249
  729357
  729903
  748134
  748699
  759098
  763889
  764237
  766417
  773907
  776088
  777349
  779493
  779824
  780871
  783399
  784410
  793217
  796514
  796521
  798708
  798735
  798930
  804612
  804648
  805352
  807289
  807861
  811954
  812560
  817387
  817470
  817684
  818735
  827703
  828004
]
14.60 ms
(8.67%)
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
  632926
  777349
  780871
  804612
  805352
  481567
  438047
  520281
  721249
  817470
  827703
  817684
  828004
  537622
  556154
  595848
  599818
  631514
  798708
  394273
  393350
  221320
  498317
  573344
  729903
  766417
  438010
  487751
  501066
  472075
  748134
  417672
  469783
  483295
  478143
  506315
  486420
  476473
  423978
  438100
  456220
  151163
  432384
  437265
  487604
  499780
  503020
  488878
  545896
  558715
  580007
  550121
  555549
  555672
  555670
  582448
  584343
  649862
  650275
  659065
  691618
  694386
  645806
  648612
  660090
  665089
  704343
  718703
  546851
  554101
  627237
  636127
  599795
  615079
  620825
  623731
  593714
  594312
  599805
  627570
  798930
  811954
  779493
  779824
  793217
  796514
  807289
  812560
  729357
  773907
  784410
  798735
  748699
  764237
  617710
  627505
  640964
  713924
  776088
  783399
  804648
  807861
  456027
  416455
  461161
  498210
  512757
  817387
  818735
  613614
  627167
  638054
  759098
  763889
  629727
  509709
  557596
  626841
  796521
  506492
]
2.87 ms
(1.70%)
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
  151163
  221320
  393350
  394273
  416455
  417672
  423978
  432384
  437265
  438010
  438047
  438100
  456027
  456220
  461161
  469783
  472075
  476473
  478143
  481567
  483295
  486420
  487604
  487751
  488878
  498210
  498317
  499780
  501066
  503020
  506315
  506492
  509709
  512757
  520281
  537622
  545896
  546851
  550121
  554101
  555549
  555670
  555672
  556154
  557596
  558715
  573344
  580007
  582448
  584343
  593714
  594312
  595848
  599795
  599805
  599818
  613614
  615079
  617710
  620825
  623731
  626841
  627167
  627237
  627505
  627570
  629727
  631514
  632926
  636127
  638054
  640964
  645806
  648612
  649862
  650275
  659065
  660090
  665089
  691618
  694386
  704343
  713924
  718703
  721249
  729357
  729903
  748134
  748699
  759098
  763889
  764237
  766417
  773907
  776088
  777349
  779493
  779824
  780871
  783399
  784410
  793217
  796514
  796521
  798708
  798735
  798930
  804612
  804648
  805352
  807289
  807861
  811954
  812560
  817387
  817470
  817684
  818735
  827703
  828004
]
1.92 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife car"
]
1.79 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен вмашин"
]
1.61 ms
(0.96%)
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.