Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.56 ms
(86.97%)
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
  426811
  432734
  437816
  446690
  451863
  455331
  456654
  459207
  460933
  464765
  464869
  470665
  485815
  490158
  490659
  492665
  503764
  503991
  504887
  506233
  509055
  511145
  516565
  524938
  530557
  533708
  536078
  537614
  548412
  551217
  552358
  552867
  553154
  557547
  560321
  561163
  584893
  590309
  593932
  594632
  598701
  602511
  615257
  619262
  620218
  620548
  621469
  623399
  627120
  628682
  632901
  639895
  643673
  644128
  651313
  661315
  661321
  662117
  662783
  673560
  679467
  682920
  685807
  690630
  692970
  696289
  701705
  702375
  711773
  713134
  714615
  719394
  719972
  721204
  729863
  732072
  735956
  737055
  737827
  738042
  738564
  738675
  740095
  740961
  741824
  745968
  750571
  751170
  751361
  753635
  754318
  757235
  757504
  760452
  761778
  761863
  764052
  766293
  777794
  778782
  781360
  781599
  782625
  783941
  784668
  787373
  789141
  789209
  792438
  792746
  797366
  798441
  800742
  801653
  803356
  805239
  805653
  810520
  811862
  814706
]
14.66 ms
(7.43%)
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
  737827
  732072
  737055
  740095
  751361
  632901
  721204
  789209
  792746
  714615
  741824
  639895
  460933
  503764
  584893
  719394
  690630
  719972
  781599
  778782
  789141
  792438
  805239
  729863
  738042
  766293
  702375
  784668
  798441
  456654
  590309
  464765
  530557
  503991
  490158
  490659
  651313
  662117
  696289
  621469
  644128
  594632
  801653
  627120
  548412
  553154
  811862
  426811
  537614
  516565
  536078
  673560
  682920
  628682
  598701
  810520
  761778
  754318
  735956
  740961
  745968
  750571
  753635
  757504
  761863
  643673
  803356
  446690
  506233
  432734
  814706
  459207
  485815
  511145
  557547
  711773
  685807
  560321
  619262
  782625
  805653
  757235
  781360
  787373
  751170
  760452
  764052
  783941
  797366
  800742
  464869
  470665
  451863
  492665
  552867
  561163
  552358
  661315
  701705
  662783
  679467
  692970
  713134
  593932
  620548
  623399
  602511
  620218
  437816
  509055
  738675
  504887
  533708
  524938
  661321
  615257
  777794
  455331
  738564
  551217
]
3.13 ms
(1.59%)
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
  426811
  432734
  437816
  446690
  451863
  455331
  456654
  459207
  460933
  464765
  464869
  470665
  485815
  490158
  490659
  492665
  503764
  503991
  504887
  506233
  509055
  511145
  516565
  524938
  530557
  533708
  536078
  537614
  548412
  551217
  552358
  552867
  553154
  557547
  560321
  561163
  584893
  590309
  593932
  594632
  598701
  602511
  615257
  619262
  620218
  620548
  621469
  623399
  627120
  628682
  632901
  639895
  643673
  644128
  651313
  661315
  661321
  662117
  662783
  673560
  679467
  682920
  685807
  690630
  692970
  696289
  701705
  702375
  711773
  713134
  714615
  719394
  719972
  721204
  729863
  732072
  735956
  737055
  737827
  738042
  738564
  738675
  740095
  740961
  741824
  745968
  750571
  751170
  751361
  753635
  754318
  757235
  757504
  760452
  761778
  761863
  764052
  766293
  777794
  778782
  781360
  781599
  782625
  783941
  784668
  787373
  789141
  789209
  792438
  792746
  797366
  798441
  800742
  801653
  803356
  805239
  805653
  810520
  811862
  814706
]
2.46 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "camera homemade"
]
1.93 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "camera домашн любительск"
]
1.63 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "camera домашн любительск"
]

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.