Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.69 ms
(84.19%)
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
  150405
  357943
  382906
  383202
  383660
  389142
  391036
  401489
  404474
  404478
  404644
  406425
  407552
  409867
  411012
  415637
  415882
  418922
  421105
  427550
  430698
  430811
  435688
  435701
  437437
  444815
  447882
  459231
  459241
  459760
  464474
  465886
  471410
  475859
  476301
  481652
  486924
  493045
  494771
  496720
  498605
  499643
  499656
  504339
  506147
  506844
  506944
  510043
  511930
  518948
  520599
  520726
  531416
  538333
  555384
  557509
  558383
  559958
  560108
  560136
  566321
  569412
  580742
  584200
  584726
  584735
  591115
  593671
  599572
  608595
  615883
  623958
  625452
  625557
  634842
  643405
  643731
  659165
  668549
  686648
  696192
  702063
  726398
  726716
  735684
  737535
  741290
  743789
  744467
  744468
  744469
  758102
  768115
  776724
  782408
  782420
  784270
  789470
  789745
  792680
  793495
  793591
  795376
  796180
  799598
  800066
  803966
  804559
  804688
  810789
  811662
  814806
  815756
  815958
  816038
  816875
  818725
  820452
  825204
  828714
]
18.84 ms
(10.25%)
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
  476301
  404474
  471410
  493045
  557509
  686648
  696192
  625557
  415637
  430698
  511930
  150405
  486924
  702063
  799598
  810789
  795376
  804688
  811662
  744468
  744467
  735684
  726716
  784270
  818725
  825204
  659165
  510043
  520599
  804559
  518948
  643731
  538333
  584726
  816038
  820452
  643405
  741290
  357943
  407552
  444815
  599572
  406425
  435701
  593671
  435688
  499656
  475859
  615883
  591115
  625452
  427550
  401489
  814806
  481652
  465886
  504339
  506147
  555384
  558383
  569412
  580742
  634842
  608595
  758102
  464474
  437437
  499643
  404644
  411012
  459760
  459231
  383202
  391036
  409867
  506944
  796180
  768115
  792680
  744469
  782408
  815756
  828714
  803966
  531416
  418922
  816875
  815958
  498605
  496720
  776724
  789745
  800066
  737535
  421105
  668549
  520726
  506844
  789470
  793495
  584735
  404478
  559958
  459241
  726398
  382906
  743789
  389142
  560108
  782420
  793591
  415882
  383660
  560136
  584200
  623958
  566321
  494771
  430811
  447882
]
2.89 ms
(1.58%)
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
  150405
  357943
  382906
  383202
  383660
  389142
  391036
  401489
  404474
  404478
  404644
  406425
  407552
  409867
  411012
  415637
  415882
  418922
  421105
  427550
  430698
  430811
  435688
  435701
  437437
  444815
  447882
  459231
  459241
  459760
  464474
  465886
  471410
  475859
  476301
  481652
  486924
  493045
  494771
  496720
  498605
  499643
  499656
  504339
  506147
  506844
  506944
  510043
  511930
  518948
  520599
  520726
  531416
  538333
  555384
  557509
  558383
  559958
  560108
  560136
  566321
  569412
  580742
  584200
  584726
  584735
  591115
  593671
  599572
  608595
  615883
  623958
  625452
  625557
  634842
  643405
  643731
  659165
  668549
  686648
  696192
  702063
  726398
  726716
  735684
  737535
  741290
  743789
  744467
  744468
  744469
  758102
  768115
  776724
  782408
  782420
  784270
  789470
  789745
  792680
  793495
  793591
  795376
  796180
  799598
  800066
  803966
  804559
  804688
  810789
  811662
  814806
  815756
  815958
  816038
  816875
  818725
  820452
  825204
  828714
]
2.16 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother massage"
]
1.81 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин массаж"
]
1.70 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.90%)
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.