GET https://search.jues.net/search/embeds/4?q=%D0%BA%D0%BE%D0%BC%D0%BD%D0%B0%D1%82%D0%B5

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.85 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.30 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "комнате"
]
3 13.93 ms
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
  797434
  801594
  803218
  810064
  730645
  732508
  740208
  749994
  754864
  762152
  768732
  768982
  728249
  736502
  745849
  758506
  764623
  767680
  773178
  728898
  743129
  748693
  753429
  758136
  759346
  730356
  748911
  749373
  767475
  620570
  632938
  634948
  635167
  786494
  788383
  791746
  804037
  804816
  285023
  24243
  126450
  248084
  388417
  527586
  382958
  68967
  384268
  123070
  193890
  202872
  214560
  177522
  391607
  88614
  38857
  389648
  396816
  398948
  402585
  406428
  814593
  458836
  520190
  530562
  537630
  506568
  477285
  545034
  546101
  546649
  565792
  581275
  546296
  556282
  572705
  542246
  551543
  646533
  648693
  652468
  668810
  671350
  684876
  689923
  699346
  665324
  671567
  675356
  676130
  684874
  688398
  712647
  714563
  718143
  720088
  700775
  716066
  575269
  629667
  614538
  617496
  624590
  627880
  602915
  607859
  780423
  783843
  786276
  791327
  791985
  795897
  796567
  796864
  799215
  799311
  800135
  802387
  810201
  811399
  812489
]
4 3.76 ms
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
  24243
  38857
  68967
  88614
  123070
  126450
  177522
  193890
  202872
  214560
  248084
  285023
  382958
  384268
  388417
  389648
  391607
  396816
  398948
  402585
  406428
  458836
  477285
  506568
  520190
  527586
  530562
  537630
  542246
  545034
  546101
  546296
  546649
  551543
  556282
  565792
  572705
  575269
  581275
  602915
  607859
  614538
  617496
  620570
  624590
  627880
  629667
  632938
  634948
  635167
  646533
  648693
  652468
  665324
  668810
  671350
  671567
  675356
  676130
  684874
  684876
  688398
  689923
  699346
  700775
  712647
  714563
  716066
  718143
  720088
  728249
  728898
  730356
  730645
  732508
  736502
  740208
  743129
  745849
  748693
  748911
  749373
  749994
  753429
  754864
  758136
  758506
  759346
  762152
  764623
  767475
  767680
  768732
  768982
  773178
  780423
  783843
  786276
  786494
  788383
  791327
  791746
  791985
  795897
  796567
  796864
  797434
  799215
  799311
  800135
  801594
  802387
  803218
  804037
  804816
  810064
  810201
  811399
  812489
  814593
]
5 273.45 ms
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
  24243
  38857
  68967
  88614
  123070
  126450
  177522
  193890
  202872
  214560
  248084
  285023
  382958
  384268
  388417
  389648
  391607
  396816
  398948
  402585
  406428
  458836
  477285
  506568
  520190
  527586
  530562
  537630
  542246
  545034
  546101
  546296
  546649
  551543
  556282
  565792
  572705
  575269
  581275
  602915
  607859
  614538
  617496
  620570
  624590
  627880
  629667
  632938
  634948
  635167
  646533
  648693
  652468
  665324
  668810
  671350
  671567
  675356
  676130
  684874
  684876
  688398
  689923
  699346
  700775
  712647
  714563
  716066
  718143
  720088
  728249
  728898
  730356
  730645
  732508
  736502
  740208
  743129
  745849
  748693
  748911
  749373
  749994
  753429
  754864
  758136
  758506
  759346
  762152
  764623
  767475
  767680
  768732
  768982
  773178
  780423
  783843
  786276
  786494
  788383
  791327
  791746
  791985
  795897
  796567
  796864
  797434
  799215
  799311
  800135
  801594
  802387
  803218
  804037
  804816
  810064
  810201
  811399
  812489
  814593
]
6 1.94 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "комнат"
]
7 1.46 ms
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.