GET https://search.jues.net/search/embeds/3?q=%D0%B3%D0%BE%D1%81%D1%82%D1%8F%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.51 ms
(89.88%)
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
  34171
  82217
  94546
  97055
  233006
  233512
  294932
  382183
  382213
  382815
  383402
  384779
  385841
  387428
  389506
  392582
  393406
  397407
  399017
  400722
  401531
  403136
  403418
  405551
  409608
  409916
  410867
  411661
  413335
  413662
  414762
  423960
  429554
  429825
  432598
  442150
  443111
  443769
  444038
  445855
  449258
  451455
  452220
  452307
  453642
  454344
  455101
  455104
  457016
  457956
  458408
  458977
  459282
  459634
  461446
  461476
  461590
  466576
  470303
  470492
  472352
  472942
  477610
  478768
  489158
  492186
  508861
  511145
  526013
  527727
  549471
  552184
  559022
  562217
  570215
  570245
  570384
  570385
  570609
  570851
  571546
  572799
  573011
  605684
  606237
  615275
  617819
  628261
  635580
  644138
  659362
  686589
  703448
  711598
  711625
  721896
  723909
  725817
  736945
  738226
  739432
  742773
  749878
  753173
  755578
  758901
  761609
  766333
  766680
  770626
  779800
  780087
  784659
  788040
  791968
  799795
  800249
  801450
  804563
  812945
]
10.88 ms
(5.57%)
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
  570609
  572799
  562217
  711625
  686589
  549471
  570851
  628261
  635580
  644138
  779800
  780087
  812945
  758901
  791968
  799795
  755578
  742773
  725817
  753173
  761609
  617819
  711598
  804563
  233512
  382183
  392582
  397407
  401531
  455104
  429825
  457016
  461446
  384779
  432598
  451455
  470303
  472352
  233006
  393406
  442150
  454344
  478768
  443769
  466576
  508861
  489158
  526013
  385841
  383402
  82217
  382213
  34171
  97055
  399017
  400722
  405551
  413335
  414762
  409608
  413662
  411661
  410867
  445855
  453642
  459282
  459634
  492186
  449258
  458408
  458977
  477610
  527727
  511145
  472942
  552184
  570215
  570245
  559022
  570384
  571546
  573011
  721896
  659362
  703448
  570385
  605684
  615275
  606237
  788040
  800249
  736945
  749878
  766680
  723909
  739432
  770626
  738226
  766333
  784659
  801450
  294932
  403136
  452307
  457956
  461476
  470492
  94546
  387428
  389506
  455101
  423960
  429554
  444038
  461590
  382815
  403418
  409916
  443111
  452220
]
2.93 ms
(1.50%)
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
  34171
  82217
  94546
  97055
  233006
  233512
  294932
  382183
  382213
  382815
  383402
  384779
  385841
  387428
  389506
  392582
  393406
  397407
  399017
  400722
  401531
  403136
  403418
  405551
  409608
  409916
  410867
  411661
  413335
  413662
  414762
  423960
  429554
  429825
  432598
  442150
  443111
  443769
  444038
  445855
  449258
  451455
  452220
  452307
  453642
  454344
  455101
  455104
  457016
  457956
  458408
  458977
  459282
  459634
  461446
  461476
  461590
  466576
  470303
  470492
  472352
  472942
  477610
  478768
  489158
  492186
  508861
  511145
  526013
  527727
  549471
  552184
  559022
  562217
  570215
  570245
  570384
  570385
  570609
  570851
  571546
  572799
  573011
  605684
  606237
  615275
  617819
  628261
  635580
  644138
  659362
  686589
  703448
  711598
  711625
  721896
  723909
  725817
  736945
  738226
  739432
  742773
  749878
  753173
  755578
  758901
  761609
  766333
  766680
  770626
  779800
  780087
  784659
  788040
  791968
  799795
  800249
  801450
  804563
  812945
]
1.83 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "гост"
]
1.47 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "гостях"
]
1.33 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.68%)
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.