Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.55 ms
(83.44%)
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
  343227
  384581
  387215
  391705
  420541
  428080
  429292
  456495
  504764
  552027
  558779
  566303
  569361
  570127
  570131
  570909
  571730
  574233
  574960
  577561
  577813
  586918
  589655
  590478
  592292
  594063
  603519
  608358
  614802
  615937
  616491
  618187
  618603
  622518
  623145
  625065
  627265
  628569
  628843
  630389
  642951
  655214
  657536
  660845
  661665
  664842
  665877
  667568
  679296
  679304
  682647
  684815
  696508
  697462
  700052
  701526
  702375
  705054
  707774
  710439
  711273
  712625
  716527
  716586
  718498
  721084
  721771
  723733
  725138
  726539
  726564
  727915
  729832
  730370
  731339
  732607
  733387
  733588
  733946
  734715
  734778
  734929
  736866
  738310
  738314
  738404
  738618
  739787
  740645
  742889
  742894
  742912
  742949
  743679
  743800
  746710
  749578
  749940
  752787
  757996
  767381
  768575
  779199
  780667
  781747
  782387
  782394
  785650
  787937
  789976
  790082
  794154
  795942
  796101
  800284
  802487
  803294
  807886
  809790
  812232
]
18.54 ms
(10.85%)
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
  574233
  577561
  570131
  570909
  574960
  558779
  571730
  679304
  684815
  700052
  707774
  712625
  655214
  664842
  679296
  682647
  697462
  701526
  705054
  711273
  718498
  657536
  661665
  667568
  569361
  570127
  577813
  614802
  615937
  623145
  628843
  592292
  603519
  618603
  589655
  628569
  630389
  594063
  616491
  627265
  642951
  790082
  795942
  796101
  800284
  807886
  727915
  731339
  733387
  738404
  740645
  742889
  743679
  746710
  767381
  782394
  785650
  787937
  789976
  802487
  803294
  809790
  812232
  733946
  734778
  738310
  742949
  749940
  757996
  723733
  726564
  730370
  734929
  738314
  738618
  752787
  726539
  739787
  742912
  743800
  749578
  733588
  618187
  625065
  702375
  710439
  721771
  780667
  782387
  794154
  391705
  343227
  504764
  420541
  429292
  608358
  384581
  428080
  566303
  552027
  660845
  768575
  456495
  696508
  665877
  781747
  729832
  734715
  716586
  721084
  736866
  725138
  387215
  716527
  590478
  586918
  622518
  779199
  732607
  742894
]
2.62 ms
(1.54%)
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
  343227
  384581
  387215
  391705
  420541
  428080
  429292
  456495
  504764
  552027
  558779
  566303
  569361
  570127
  570131
  570909
  571730
  574233
  574960
  577561
  577813
  586918
  589655
  590478
  592292
  594063
  603519
  608358
  614802
  615937
  616491
  618187
  618603
  622518
  623145
  625065
  627265
  628569
  628843
  630389
  642951
  655214
  657536
  660845
  661665
  664842
  665877
  667568
  679296
  679304
  682647
  684815
  696508
  697462
  700052
  701526
  702375
  705054
  707774
  710439
  711273
  712625
  716527
  716586
  718498
  721084
  721771
  723733
  725138
  726539
  726564
  727915
  729832
  730370
  731339
  732607
  733387
  733588
  733946
  734715
  734778
  734929
  736866
  738310
  738314
  738404
  738618
  739787
  740645
  742889
  742894
  742912
  742949
  743679
  743800
  746710
  749578
  749940
  752787
  757996
  767381
  768575
  779199
  780667
  781747
  782387
  782394
  785650
  787937
  789976
  790082
  794154
  795942
  796101
  800284
  802487
  803294
  807886
  809790
  812232
]
2.17 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "the wife old"
]
1.75 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен old"
]
1.61 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен old"
]

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.