GET https://search.jues.net/search/embeds/7?q=%D1%81%D0%BE%D1%81%D0%BA%D0%B8%20%D0%BF%D0%BE%D0%B4

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.41 ms
(88.26%)
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
  35405
  80916
  141458
  162863
  168687
  174791
  186988
  197587
  198365
  229180
  276780
  358857
  366004
  384772
  385189
  386065
  386074
  387696
  388149
  389460
  390350
  391216
  395384
  395457
  395689
  395983
  396146
  396817
  397934
  398451
  398580
  399412
  399806
  400730
  401751
  402439
  402483
  405248
  405730
  405761
  407449
  408776
  409577
  409610
  410217
  411161
  413999
  414594
  417233
  417406
  417821
  418182
  419056
  419075
  421639
  422231
  422415
  422421
  424793
  427011
  427268
  428632
  429138
  429259
  429410
  434086
  436628
  436899
  436953
  437360
  443327
  445088
  445216
  445427
  445731
  446954
  450649
  452842
  452845
  453266
  453374
  453443
  454301
  455887
  456199
  456332
  457384
  458591
  458650
  459239
  462018
  464493
  465555
  466422
  467977
  473095
  474190
  474456
  484094
  492404
  492439
  492441
  495037
  501672
  503843
  506944
  509176
  510901
  523146
  524656
  528883
  533142
  617777
  627056
  729458
  763785
  769411
  790952
  802333
  803972
]
13.41 ms
(6.39%)
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
  763785
  729458
  769411
  617777
  627056
  790952
  802333
  803972
  162863
  229180
  390350
  399806
  402439
  408776
  417406
  427011
  429259
  436953
  276780
  168687
  395384
  395457
  398580
  411161
  424793
  443327
  445216
  458591
  197587
  389460
  395689
  452842
  474190
  80916
  366004
  384772
  405248
  422415
  450649
  454301
  458650
  465555
  473095
  501672
  386065
  386074
  385189
  174791
  186988
  141458
  198365
  395983
  358857
  35405
  387696
  388149
  391216
  396817
  396146
  398451
  397934
  400730
  399412
  402483
  401751
  405730
  405761
  409610
  417821
  419075
  436899
  410217
  413999
  417233
  418182
  427268
  437360
  407449
  414594
  422421
  409577
  421639
  429138
  436628
  445088
  419056
  422231
  428632
  429410
  434086
  446954
  456332
  459239
  464493
  466422
  467977
  484094
  492404
  492441
  445731
  453266
  453443
  445427
  452845
  453374
  455887
  456199
  457384
  462018
  474456
  492439
  506944
  509176
  510901
  523146
  524656
  528883
  533142
  495037
  503843
]
3.86 ms
(1.84%)
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
  35405
  80916
  141458
  162863
  168687
  174791
  186988
  197587
  198365
  229180
  276780
  358857
  366004
  384772
  385189
  386065
  386074
  387696
  388149
  389460
  390350
  391216
  395384
  395457
  395689
  395983
  396146
  396817
  397934
  398451
  398580
  399412
  399806
  400730
  401751
  402439
  402483
  405248
  405730
  405761
  407449
  408776
  409577
  409610
  410217
  411161
  413999
  414594
  417233
  417406
  417821
  418182
  419056
  419075
  421639
  422231
  422415
  422421
  424793
  427011
  427268
  428632
  429138
  429259
  429410
  434086
  436628
  436899
  436953
  437360
  443327
  445088
  445216
  445427
  445731
  446954
  450649
  452842
  452845
  453266
  453374
  453443
  454301
  455887
  456199
  456332
  457384
  458591
  458650
  459239
  462018
  464493
  465555
  466422
  467977
  473095
  474190
  474456
  484094
  492404
  492439
  492441
  495037
  501672
  503843
  506944
  509176
  510901
  523146
  524656
  528883
  533142
  617777
  627056
  729458
  763785
  769411
  790952
  802333
  803972
]
1.98 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соск"
]
1.81 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соски под"
]
1.81 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.85%)
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.