Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.01 ms
(81.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
  4245
  384232
  388858
  391349
  396265
  397242
  412119
  420136
  420423
  422231
  427021
  427195
  431681
  441166
  450180
  451711
  453852
  454348
  455232
  456142
  463988
  468640
  469371
  471776
  480819
  481029
  482173
  484350
  487010
  490859
  496693
  517463
  519259
  542797
  543239
  545529
  546843
  556521
  560238
  563886
  573659
  583927
  584743
  604500
  610283
  616615
  620650
  620907
  621086
  626004
  626605
  633154
  637111
  647357
  650375
  653516
  667921
  675784
  676850
  682466
  683955
  684281
  690117
  695547
  699762
  702938
  704220
  707738
  714848
  717246
  720738
  723300
  725753
  727780
  731933
  734933
  748108
  754012
  757423
  757643
  758116
  759610
  760036
  761626
  762041
  762163
  762485
  763152
  764396
  766121
  767308
  767510
  774022
  775383
  778096
  778514
  784464
  785288
  788710
  789838
  789839
  797224
  800463
  800575
  801036
  803038
  804186
  807440
  807982
  811735
  816921
  821067
  821461
  821895
  822110
  822289
  822360
  822948
  823141
  827858
]
21.52 ms
(12.89%)
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
  811735
  762041
  621086
  456142
  821895
  823141
  816921
  822110
  542797
  714848
  616615
  788710
  725753
  761626
  760036
  427195
  748108
  422231
  759610
  807440
  767510
  774022
  784464
  4245
  731933
  391349
  583927
  637111
  468640
  563886
  420423
  471776
  778096
  734933
  695547
  723300
  717246
  827858
  573659
  650375
  633154
  801036
  490859
  684281
  797224
  620907
  450180
  496693
  560238
  800463
  803038
  764396
  620650
  699762
  396265
  420136
  821067
  675784
  702938
  704220
  707738
  720738
  653516
  690117
  800575
  789839
  727780
  757643
  384232
  821461
  822289
  822948
  454348
  543239
  556521
  682466
  626605
  610283
  766121
  767308
  789838
  807982
  626004
  754012
  453852
  412119
  676850
  778514
  785288
  762163
  775383
  388858
  484350
  455232
  647357
  427021
  482173
  584743
  545529
  480819
  431681
  463988
  469371
  481029
  822360
  517463
  604500
  451711
  441166
  546843
  487010
  683955
  763152
  757423
  519259
  667921
  762485
  758116
  804186
  397242
]
2.67 ms
(1.60%)
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
  4245
  384232
  388858
  391349
  396265
  397242
  412119
  420136
  420423
  422231
  427021
  427195
  431681
  441166
  450180
  451711
  453852
  454348
  455232
  456142
  463988
  468640
  469371
  471776
  480819
  481029
  482173
  484350
  487010
  490859
  496693
  517463
  519259
  542797
  543239
  545529
  546843
  556521
  560238
  563886
  573659
  583927
  584743
  604500
  610283
  616615
  620650
  620907
  621086
  626004
  626605
  633154
  637111
  647357
  650375
  653516
  667921
  675784
  676850
  682466
  683955
  684281
  690117
  695547
  699762
  702938
  704220
  707738
  714848
  717246
  720738
  723300
  725753
  727780
  731933
  734933
  748108
  754012
  757423
  757643
  758116
  759610
  760036
  761626
  762041
  762163
  762485
  763152
  764396
  766121
  767308
  767510
  774022
  775383
  778096
  778514
  784464
  785288
  788710
  789838
  789839
  797224
  800463
  800575
  801036
  803038
  804186
  807440
  807982
  811735
  816921
  821067
  821461
  821895
  822110
  822289
  822360
  822948
  823141
  827858
]
1.93 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex small"
]
1.68 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс маленькая"
]
1.63 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.94%)
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.