GET https://search.jues.net/search/embeds/7?q=pov%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.27 ms
(82.76%)
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
  47079
  429298
  486274
  491136
  506312
  513057
  535929
  538026
  544947
  549518
  549626
  553087
  555030
  555338
  555461
  556109
  557935
  560164
  566240
  566612
  568650
  569505
  574293
  575450
  579681
  580962
  590450
  607319
  614265
  622283
  626307
  635283
  636419
  643830
  646381
  666661
  668281
  669715
  672349
  675570
  676215
  678608
  681379
  684686
  687421
  688386
  695475
  695575
  697896
  715620
  718703
  721909
  721918
  724141
  728280
  739256
  754243
  755013
  761880
  764725
  765071
  766006
  768456
  771534
  772342
  774058
  777693
  778523
  779614
  779702
  780201
  780580
  784023
  785103
  785162
  785485
  786248
  786353
  786651
  788309
  792757
  793025
  793973
  796891
  797665
  802006
  802491
  805178
  808849
  813158
  813298
  814377
  817641
  817897
  818657
  819086
  819189
  819432
  819446
  819450
  819895
  820646
  820949
  821165
  821478
  821494
  821661
  821677
  821685
  822741
  822981
  823050
  823154
  823405
  823488
  825536
  825813
  827347
  827857
]
14.02 ms
(9.65%)
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
  772342
  721909
  779614
  688386
  775265
  802491
  805178
  764725
  566612
  672349
  785485
  821165
  786248
  768456
  813298
  486274
  491136
  813158
  766006
  761880
  780580
  549626
  555030
  579681
  549518
  553087
  556109
  557935
  574293
  646381
  678608
  635283
  636419
  777693
  779702
  784023
  788309
  793025
  755013
  785162
  786353
  802006
  808849
  724141
  728280
  739256
  765071
  754243
  771534
  774058
  643830
  697896
  786651
  796891
  797665
  47079
  506312
  780201
  513057
  560164
  718703
  721918
  622283
  793973
  778523
  785103
  792757
  429298
  814377
  817641
  819450
  819895
  820646
  821661
  822981
  817897
  825813
  827347
  818657
  819189
  821677
  821685
  822741
  823154
  825536
  819086
  819432
  819446
  820949
  821478
  821494
  823050
  823405
  823488
  827857
  535929
  538026
  544947
  569505
  575450
  555338
  555461
  580962
  566240
  568650
  666661
  675570
  684686
  715620
  668281
  669715
  681379
  687421
  695475
  676215
  695575
  590450
  607319
  614265
  626307
]
3.15 ms
(2.17%)
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
  47079
  429298
  486274
  491136
  506312
  513057
  535929
  538026
  544947
  549518
  549626
  553087
  555030
  555338
  555461
  556109
  557935
  560164
  566240
  566612
  568650
  569505
  574293
  575450
  579681
  580962
  590450
  607319
  614265
  622283
  626307
  635283
  636419
  643830
  646381
  666661
  668281
  669715
  672349
  675570
  676215
  678608
  681379
  684686
  687421
  688386
  695475
  695575
  697896
  715620
  718703
  721909
  721918
  724141
  728280
  739256
  754243
  755013
  761880
  764725
  765071
  766006
  768456
  771534
  772342
  774058
  777693
  778523
  779614
  779702
  780201
  780580
  784023
  785103
  785162
  785485
  786248
  786353
  786651
  788309
  792757
  793025
  793973
  796891
  797665
  802006
  802491
  805178
  808849
  813158
  813298
  814377
  817641
  817897
  818657
  819086
  819189
  819432
  819446
  819450
  819895
  820646
  820949
  821165
  821478
  821494
  821661
  821677
  821685
  822741
  822981
  823050
  823154
  823405
  823488
  825536
  825813
  827347
  827857
]
2.26 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.18 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov public"
]
1.75 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов на улиц"
]
1.69 ms
(1.16%)
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.