Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.15 ms
(85.07%)
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
  210880
  384482
  395332
  398527
  402458
  420020
  421573
  423905
  443118
  446963
  454967
  457540
  458477
  459326
  459918
  463029
  469133
  474290
  474972
  478223
  481317
  483329
  483452
  485804
  486513
  486970
  489787
  490976
  494676
  495303
  500996
  501539
  503482
  503485
  503830
  510779
  513110
  520839
  522293
  525967
  529048
  529453
  530144
  530432
  533641
  535058
  538119
  540132
  540752
  543598
  544614
  547028
  547429
  548403
  550946
  553331
  553857
  554634
  554717
  554915
  555378
  555776
  556995
  557397
  557606
  559744
  560220
  561191
  567498
  569547
  571094
  574300
  574385
  574645
  579724
  580147
  593994
  596512
  598839
  599808
  600875
  601842
  602860
  605134
  605903
  606271
  609507
  610872
  614348
  615420
  616347
  617724
  618189
  618300
  618952
  627667
  632820
  633656
  634614
  635519
  635689
  635752
  646669
  655582
  661889
  680741
  685034
  705705
  705708
  705726
  719880
  719883
  725767
  747048
  755868
  769331
  778162
  779979
  791682
  793992
]
14.31 ms
(8.81%)
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
  495303
  561191
  423905
  469133
  556995
  606271
  705705
  522293
  384482
  513110
  705726
  618189
  779979
  557606
  560220
  635752
  554634
  680741
  554717
  632820
  596512
  421573
  520839
  618952
  490976
  627667
  486513
  510779
  567498
  579724
  478223
  459918
  533641
  540132
  553331
  571094
  580147
  685034
  609507
  747048
  395332
  529453
  605134
  398527
  485804
  633656
  615420
  543598
  719883
  486970
  655582
  646669
  605903
  557397
  600875
  635519
  769331
  559744
  547429
  555776
  634614
  420020
  602860
  617724
  463029
  530144
  540752
  529048
  535058
  548403
  553857
  618300
  474972
  483329
  598839
  661889
  443118
  500996
  210880
  610872
  599808
  778162
  755868
  705708
  719880
  791682
  593994
  459326
  503485
  494676
  503482
  538119
  489787
  547028
  555378
  574385
  574645
  550946
  569547
  601842
  793992
  481317
  458477
  554915
  446963
  635689
  530432
  501539
  474290
  616347
  483452
  614348
  525967
  544614
  454967
  503830
  574300
  457540
  725767
  402458
]
3.07 ms
(1.89%)
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
  210880
  384482
  395332
  398527
  402458
  420020
  421573
  423905
  443118
  446963
  454967
  457540
  458477
  459326
  459918
  463029
  469133
  474290
  474972
  478223
  481317
  483329
  483452
  485804
  486513
  486970
  489787
  490976
  494676
  495303
  500996
  501539
  503482
  503485
  503830
  510779
  513110
  520839
  522293
  525967
  529048
  529453
  530144
  530432
  533641
  535058
  538119
  540132
  540752
  543598
  544614
  547028
  547429
  548403
  550946
  553331
  553857
  554634
  554717
  554915
  555378
  555776
  556995
  557397
  557606
  559744
  560220
  561191
  567498
  569547
  571094
  574300
  574385
  574645
  579724
  580147
  593994
  596512
  598839
  599808
  600875
  601842
  602860
  605134
  605903
  606271
  609507
  610872
  614348
  615420
  616347
  617724
  618189
  618300
  618952
  627667
  632820
  633656
  634614
  635519
  635689
  635752
  646669
  655582
  661889
  680741
  685034
  705705
  705708
  705726
  719880
  719883
  725767
  747048
  755868
  769331
  778162
  779979
  791682
  793992
]
2.04 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в лесу с женой"
]
1.54 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в лес природ жен"
]
1.31 ms
(0.81%)
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.