Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.06 ms
(85.22%)
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
  390813
  391184
  395706
  395970
  395981
  406525
  411237
  414184
  415746
  416772
  416886
  419064
  419550
  420559
  420587
  420635
  420695
  421557
  421871
  423329
  424428
  425316
  425473
  427182
  429449
  434702
  436718
  442494
  443163
  443871
  447009
  447400
  447401
  447759
  448031
  448982
  452474
  453672
  454521
  455816
  458309
  461090
  461928
  462515
  464368
  466355
  466369
  467555
  467558
  468676
  469444
  469909
  469918
  470588
  470941
  471781
  472333
  475927
  476244
  482506
  483352
  484681
  484738
  489241
  492050
  492701
  495149
  496794
  499566
  502326
  503453
  504769
  507646
  508599
  509507
  509998
  511810
  513126
  514069
  517125
  517567
  517841
  518547
  521832
  525133
  525287
  527888
  534147
  534823
  537970
  543536
  544668
  544863
  549799
  551130
  561980
  564203
  573800
  582821
  583670
  590469
  593886
  595977
  603592
  603635
  603653
  603675
  610314
  618561
  648539
  680633
  695282
  717636
  770882
  790036
  797560
  801471
  803793
  809520
  810775
]
17.37 ms
(9.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
  414184
  803793
  391184
  489241
  680633
  770882
  467558
  452474
  466355
  395970
  518547
  810775
  695282
  427182
  447400
  421871
  447401
  549799
  504769
  436718
  517125
  717636
  603592
  561980
  603675
  517841
  420635
  525133
  603653
  458309
  544863
  448031
  537970
  462515
  499566
  509507
  429449
  419550
  472333
  809520
  475927
  423329
  801471
  442494
  495149
  595977
  797560
  492701
  454521
  420559
  468676
  415746
  424428
  434702
  513126
  544668
  503453
  583670
  467555
  464368
  543536
  416886
  483352
  582821
  603635
  492050
  425473
  425316
  406525
  420587
  517567
  482506
  420695
  447009
  469918
  564203
  419064
  471781
  508599
  509998
  525287
  461090
  447759
  390813
  484681
  648539
  470941
  421557
  511810
  443163
  527888
  395981
  476244
  590469
  453672
  496794
  502326
  514069
  507646
  573800
  610314
  534823
  593886
  790036
  461928
  469909
  484738
  443871
  395706
  411237
  416772
  534147
  469444
  521832
  448982
  470588
  466369
  455816
  551130
  618561
]
3.59 ms
(1.90%)
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
  390813
  391184
  395706
  395970
  395981
  406525
  411237
  414184
  415746
  416772
  416886
  419064
  419550
  420559
  420587
  420635
  420695
  421557
  421871
  423329
  424428
  425316
  425473
  427182
  429449
  434702
  436718
  442494
  443163
  443871
  447009
  447400
  447401
  447759
  448031
  448982
  452474
  453672
  454521
  455816
  458309
  461090
  461928
  462515
  464368
  466355
  466369
  467555
  467558
  468676
  469444
  469909
  469918
  470588
  470941
  471781
  472333
  475927
  476244
  482506
  483352
  484681
  484738
  489241
  492050
  492701
  495149
  496794
  499566
  502326
  503453
  504769
  507646
  508599
  509507
  509998
  511810
  513126
  514069
  517125
  517567
  517841
  518547
  521832
  525133
  525287
  527888
  534147
  534823
  537970
  543536
  544668
  544863
  549799
  551130
  561980
  564203
  573800
  582821
  583670
  590469
  593886
  595977
  603592
  603635
  603653
  603675
  610314
  618561
  648539
  680633
  695282
  717636
  770882
  790036
  797560
  801471
  803793
  809520
  810775
]
1.96 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur threesome anal"
]
1.92 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск секс втро анал"
]
1.64 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.78%)
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.