Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.57 ms
(82.53%)
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
  4279
  32874
  97231
  130022
  186793
  188501
  203516
  204672
  209664
  233186
  246509
  248814
  310742
  335642
  382567
  382702
  383656
  383715
  384059
  388254
  388393
  389388
  389526
  389642
  389855
  390629
  391837
  391895
  392373
  396010
  396395
  396601
  396684
  399089
  402123
  402724
  407515
  407753
  407929
  409334
  411372
  412975
  413989
  415615
  418226
  421108
  422824
  422859
  423806
  424261
  426466
  431082
  431167
  432531
  433140
  439515
  443732
  452447
  454392
  456078
  457149
  457569
  458701
  461115
  464159
  465926
  469483
  471619
  488603
  491926
  492947
  499194
  499507
  501082
  503502
  513243
  516543
  520640
  523280
  528157
  554840
  563020
  570123
  575243
  578816
  598138
  599664
  602492
  615575
  619894
  641658
  665446
  690434
  702896
  705296
  721670
  747072
  764154
  773775
  780311
  782913
  789128
  789317
  790983
  803254
  809172
  811467
  815401
  816495
  817247
  817315
  817887
  818616
  818854
  819568
  821141
  821711
  823278
  828755
]
14.37 ms
(10.09%)
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
  402123
  426466
  454392
  409334
  780311
  390629
  488603
  418226
  456078
  491926
  396684
  431167
  432531
  424261
  383656
  578816
  598138
  204672
  402724
  599664
  97231
  310742
  817887
  819568
  818616
  821141
  816495
  789128
  809172
  782913
  773775
  391837
  389855
  423806
  335642
  186793
  789317
  705296
  513243
  461115
  457149
  464159
  407753
  465926
  382702
  452447
  575243
  433140
  499507
  570123
  503502
  392373
  396395
  407929
  528157
  203516
  130022
  563020
  690434
  615575
  764154
  413989
  248814
  422859
  383715
  399089
  520640
  4279
  422824
  458701
  516543
  389388
  815401
  821711
  825928
  817315
  828755
  721670
  803254
  811467
  747072
  702896
  388393
  415615
  457569
  501082
  499194
  818854
  817247
  823278
  391895
  407515
  246509
  619894
  469483
  188501
  32874
  396601
  388254
  665446
  412975
  443732
  396010
  384059
  492947
  790983
  389526
  411372
  209664
  641658
  471619
  523280
  382567
  602492
  389642
  233186
  421108
  439515
  431082
  554840
]
2.52 ms
(1.77%)
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
  4279
  32874
  97231
  130022
  186793
  188501
  203516
  204672
  209664
  233186
  246509
  248814
  310742
  335642
  382567
  382702
  383656
  383715
  384059
  388254
  388393
  389388
  389526
  389642
  389855
  390629
  391837
  391895
  392373
  396010
  396395
  396601
  396684
  399089
  402123
  402724
  407515
  407753
  407929
  409334
  411372
  412975
  413989
  415615
  418226
  421108
  422824
  422859
  423806
  424261
  426466
  431082
  431167
  432531
  433140
  439515
  443732
  452447
  454392
  456078
  457149
  457569
  458701
  461115
  464159
  465926
  469483
  471619
  488603
  491926
  492947
  499194
  499507
  501082
  503502
  513243
  516543
  520640
  523280
  528157
  554840
  563020
  570123
  575243
  578816
  598138
  599664
  602492
  615575
  619894
  641658
  665446
  690434
  702896
  705296
  721670
  747072
  764154
  773775
  780311
  782913
  789128
  789317
  790983
  803254
  809172
  811467
  815401
  816495
  817247
  817315
  817887
  818616
  818854
  819568
  821141
  821711
  823278
  828755
]
2.38 ms
(1.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob stockings"
]
1.92 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс чулк нижн бел"
]
1.88 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.27%)
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.