GET https://search.jues.net/search/embeds/2?q=%D0%BB%D1%8E%D0%B1%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.18 ms
(85.38%)
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
  386179
  402134
  403765
  414720
  521659
  533766
  545900
  554310
  561516
  570821
  578357
  592979
  616827
  623348
  625577
  627276
  628040
  633704
  634036
  637938
  641331
  642086
  643801
  668371
  672802
  673247
  673746
  674795
  677972
  685768
  687949
  688377
  688849
  693719
  694551
  695001
  696293
  698132
  704998
  705024
  705112
  705241
  705853
  706687
  707515
  709777
  711050
  712825
  714179
  716452
  716711
  717193
  717387
  718123
  719401
  720149
  722930
  722957
  727956
  738659
  740064
  740829
  740880
  741202
  750458
  753574
  753658
  753661
  753682
  754370
  754602
  754984
  758571
  758683
  763573
  763803
  767321
  767632
  769483
  775109
  775121
  777486
  778354
  778357
  781542
  781581
  782664
  783131
  783263
  783853
  784025
  784162
  784380
  785512
  785734
  786751
  787786
  787958
  789243
  791193
  791642
  794948
  796419
  797159
  797313
  798672
  799779
  800547
  801307
  801676
  801945
  804032
  805559
  807540
  807643
  813736
  813872
]
9.69 ms
(6.77%)
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
  767632
  403765
  688377
  694551
  704998
  628040
  807643
  775121
  777486
  750458
  763803
  753574
  753658
  754984
  727956
  738659
  627276
  714179
  789243
  799779
  801307
  402134
  592979
  554310
  677972
  705853
  718123
  709777
  712825
  716452
  693719
  705112
  637938
  625577
  791193
  787786
  797313
  798672
  740829
  758571
  783131
  791642
  801945
  805559
  754602
  769483
  742877
  753661
  753682
  740880
  741202
  633704
  706687
  707515
  786751
  797159
  804032
  386179
  414720
  813872
  813736
  533766
  521659
  570821
  578357
  717387
  719401
  720149
  672802
  673247
  674795
  687949
  688849
  695001
  698132
  705024
  705241
  711050
  716711
  722930
  668371
  673746
  685768
  696293
  717193
  722957
  545900
  561516
  616827
  634036
  642086
  623348
  641331
  643801
  775109
  778354
  784380
  787958
  794948
  801676
  807540
  776744
  778357
  782664
  783263
  784162
  785512
  785734
  796419
  800547
  740064
  754370
  758683
  763573
  767321
  772628
  781542
  781581
  783853
  784025
]
3.90 ms
(2.72%)
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
  386179
  402134
  403765
  414720
  521659
  533766
  545900
  554310
  561516
  570821
  578357
  592979
  616827
  623348
  625577
  627276
  628040
  633704
  634036
  637938
  641331
  642086
  643801
  668371
  672802
  673247
  673746
  674795
  677972
  685768
  687949
  688377
  688849
  693719
  694551
  695001
  696293
  698132
  704998
  705024
  705112
  705241
  705853
  706687
  707515
  709777
  711050
  712825
  714179
  716452
  716711
  717193
  717387
  718123
  719401
  720149
  722930
  722957
  727956
  738659
  740064
  740829
  740880
  741202
  750458
  753574
  753658
  753661
  753682
  754370
  754602
  754984
  758571
  758683
  763573
  763803
  767321
  767632
  769483
  775109
  775121
  777486
  778354
  778357
  781542
  781581
  782664
  783131
  783263
  783853
  784025
  784162
  784380
  785512
  785734
  786751
  787786
  787958
  789243
  791193
  791642
  794948
  796419
  797159
  797313
  798672
  799779
  800547
  801307
  801676
  801945
  804032
  805559
  807540
  807643
  813736
  813872
]
2.09 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "люба"
]
2.09 ms
(1.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "люб"
]
1.66 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.04%)
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.