Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.97 ms
(78.67%)
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
  22861
  24944
  29971
  183506
  388438
  390518
  395638
  396838
  396893
  397421
  403028
  407429
  415815
  416240
  418434
  418441
  418458
  419100
  423445
  424404
  425577
  426482
  436231
  436675
  441295
  443019
  445801
  448995
  449691
  454537
  457392
  460451
  463310
  466205
  467988
  469477
  469727
  470372
  472078
  472373
  472791
  477964
  478617
  482641
  485332
  485535
  502823
  505462
  507191
  507371
  508048
  511635
  512259
  513937
  516382
  519422
  523248
  527811
  530341
  531303
  534655
  538405
  541591
  543224
  544552
  548263
  550279
  552179
  552586
  555410
  557031
  557254
  559740
  564475
  566684
  573219
  598399
  598811
  599559
  600725
  606696
  606995
  610061
  611532
  618619
  621499
  621775
  625038
  630254
  635227
  635707
  637708
  658943
  663547
  663968
  665250
  668937
  671560
  676586
  683037
  688025
  700028
  704586
  711861
  724993
  742356
  743939
  756118
  773436
  779707
  780410
  789023
  791710
  797846
  800968
  802196
  802488
  811263
  812395
  814851
]
24.91 ms
(15.19%)
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
  423445
  802196
  791710
  424404
  530341
  544552
  789023
  463310
  704586
  472373
  688025
  743939
  610061
  621775
  625038
  552586
  436675
  557031
  419100
  22861
  396838
  621499
  671560
  700028
  466205
  448995
  416240
  507191
  24944
  505462
  606696
  396893
  797846
  418434
  519422
  800968
  445801
  534655
  472078
  513937
  548263
  598399
  485535
  573219
  802488
  779707
  449691
  527811
  557254
  665250
  812395
  564475
  630254
  478617
  477964
  29971
  756118
  508048
  814851
  469727
  407429
  780410
  606995
  773436
  183506
  467988
  552179
  668937
  676586
  742356
  415815
  436231
  512259
  388438
  470372
  550279
  566684
  724993
  538405
  618619
  511635
  611532
  502823
  683037
  441295
  454537
  658943
  460451
  663968
  635227
  516382
  457392
  443019
  507371
  523248
  531303
  485332
  418441
  482641
  599559
  397421
  395638
  469477
  403028
  543224
  637708
  418458
  711861
  425577
  811263
  598811
  426482
  390518
  600725
  555410
  559740
  663547
  635707
  472791
  541591
]
2.72 ms
(1.66%)
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
  22861
  24944
  29971
  183506
  388438
  390518
  395638
  396838
  396893
  397421
  403028
  407429
  415815
  416240
  418434
  418441
  418458
  419100
  423445
  424404
  425577
  426482
  436231
  436675
  441295
  443019
  445801
  448995
  449691
  454537
  457392
  460451
  463310
  466205
  467988
  469477
  469727
  470372
  472078
  472373
  472791
  477964
  478617
  482641
  485332
  485535
  502823
  505462
  507191
  507371
  508048
  511635
  512259
  513937
  516382
  519422
  523248
  527811
  530341
  531303
  534655
  538405
  541591
  543224
  544552
  548263
  550279
  552179
  552586
  555410
  557031
  557254
  559740
  564475
  566684
  573219
  598399
  598811
  599559
  600725
  606696
  606995
  610061
  611532
  618619
  621499
  621775
  625038
  630254
  635227
  635707
  637708
  658943
  663547
  663968
  665250
  668937
  671560
  676586
  683037
  688025
  700028
  704586
  711861
  724993
  742356
  743939
  756118
  773436
  779707
  780410
  789023
  791710
  797846
  800968
  802196
  802488
  811263
  812395
  814851
]
2.07 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс ван"
]
1.86 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex bathroom"
]
1.51 ms
(0.92%)
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.