Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.38 ms
(84.77%)
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
  61625
  150405
  185038
  383474
  387359
  390258
  394738
  399008
  402599
  404286
  404474
  404491
  406425
  409948
  411012
  418933
  419967
  426775
  427542
  427550
  432611
  435701
  437437
  456856
  459760
  461091
  465886
  469820
  473488
  475859
  476301
  481284
  481873
  490168
  493852
  498544
  498869
  499643
  506147
  506944
  509955
  510029
  513328
  518328
  518347
  520599
  531036
  535672
  538333
  539750
  547546
  555384
  557509
  558383
  560848
  564371
  580742
  583213
  588852
  591115
  593671
  599543
  599572
  600276
  604497
  605875
  608071
  610142
  610249
  610262
  610962
  623957
  634842
  643405
  644093
  645297
  651969
  659165
  662851
  668651
  702063
  707360
  726716
  727924
  728067
  735684
  738897
  738947
  741631
  742897
  744463
  744467
  744468
  744469
  744477
  744478
  744480
  750782
  756363
  758102
  758812
  765482
  768115
  784270
  785707
  791924
  794719
  795298
  795376
  796180
  799598
  804559
  804671
  804688
  810031
  810789
  811662
  814758
  814806
  816031
]
16.28 ms
(9.36%)
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
  61625
  399008
  481873
  535672
  547546
  509955
  583213
  610962
  744480
  610142
  427542
  564371
  742897
  738947
  744477
  185038
  741631
  539750
  765482
  600276
  409948
  469820
  814758
  727924
  810031
  426775
  513328
  404491
  387359
  473488
  651969
  668651
  623957
  804671
  738897
  795298
  490168
  394738
  402599
  744463
  404286
  816031
  498544
  791924
  518347
  599543
  383474
  604497
  605875
  588852
  728067
  493852
  498869
  756363
  481284
  456856
  750782
  432611
  531036
  662851
  645297
  707360
  610249
  610262
  794719
  785707
  744478
  758812
  390258
  461091
  644093
  510029
  419967
  418933
  518328
  560848
  476301
  404474
  557509
  150405
  702063
  799598
  810789
  795376
  804688
  811662
  744468
  744467
  735684
  726716
  784270
  659165
  520599
  804559
  538333
  643405
  599572
  406425
  435701
  593671
  475859
  591115
  427550
  814806
  465886
  506147
  555384
  558383
  580742
  634842
  758102
  437437
  499643
  411012
  459760
  506944
  796180
  768115
  744469
  608071
]
3.06 ms
(1.76%)
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
  61625
  150405
  185038
  383474
  387359
  390258
  394738
  399008
  402599
  404286
  404474
  404491
  406425
  409948
  411012
  418933
  419967
  426775
  427542
  427550
  432611
  435701
  437437
  456856
  459760
  461091
  465886
  469820
  473488
  475859
  476301
  481284
  481873
  490168
  493852
  498544
  498869
  499643
  506147
  506944
  509955
  510029
  513328
  518328
  518347
  520599
  531036
  535672
  538333
  539750
  547546
  555384
  557509
  558383
  560848
  564371
  580742
  583213
  588852
  591115
  593671
  599543
  599572
  600276
  604497
  605875
  608071
  610142
  610249
  610262
  610962
  623957
  634842
  643405
  644093
  645297
  651969
  659165
  662851
  668651
  702063
  707360
  726716
  727924
  728067
  735684
  738897
  738947
  741631
  742897
  744463
  744467
  744468
  744469
  744477
  744478
  744480
  750782
  756363
  758102
  758812
  765482
  768115
  784270
  785707
  791924
  794719
  795298
  795376
  796180
  799598
  804559
  804671
  804688
  810031
  810789
  811662
  814758
  814806
  816031
]
1.98 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "массаж мам"
]
1.78 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж мам женщин"
]
1.78 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 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.