Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.42 ms
(87.11%)
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
  397364
  397530
  400249
  401318
  401933
  404308
  406592
  407168
  412145
  412288
  413901
  416841
  421000
  421164
  421353
  425043
  425802
  426203
  429409
  430422
  430444
  430556
  430630
  431269
  431352
  434611
  442946
  445436
  445934
  447655
  458719
  461018
  462465
  462477
  462702
  464327
  465371
  466133
  471628
  473204
  474147
  475249
  476909
  476913
  480367
  481163
  482350
  482492
  486198
  486594
  489979
  490430
  490944
  492099
  492106
  492269
  494516
  494778
  497356
  497537
  498039
  505814
  508860
  510254
  514647
  515122
  517301
  518751
  528401
  530884
  531943
  531981
  532129
  533426
  533541
  534334
  534394
  535344
  536370
  542188
  543519
  550571
  558904
  560219
  562894
  563856
  571680
  581897
  584488
  586681
  596515
  599160
  603364
  604524
  605496
  609140
  612868
  621645
  623641
  629357
  631179
  633158
  639258
  643113
  650419
  650660
  650849
  674415
  682545
  688586
  690124
  691196
  698933
  712696
  716220
  717744
  719326
  799936
  808526
  815268
]
19.57 ms
(8.10%)
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
  425043
  462702
  426203
  480367
  492099
  497537
  490430
  494516
  430630
  397364
  434611
  489979
  462465
  534334
  534394
  530884
  514647
  558904
  650419
  690124
  717744
  674415
  691196
  650660
  650849
  623641
  629357
  633158
  604524
  643113
  808526
  612868
  621645
  719326
  401933
  404308
  462477
  400249
  425802
  465371
  445934
  447655
  397530
  442946
  466133
  528401
  430422
  416841
  412288
  815268
  461018
  476909
  492269
  536370
  533541
  563856
  560219
  682545
  698933
  688586
  712696
  716220
  799936
  412145
  421353
  482350
  407168
  421000
  431352
  406592
  430556
  476913
  518751
  505814
  486198
  482492
  471628
  481163
  531943
  543519
  550571
  581897
  571680
  584488
  599160
  631179
  474147
  473204
  486594
  494778
  490944
  497356
  498039
  508860
  510254
  429409
  421164
  445436
  458719
  492106
  517301
  531981
  532129
  533426
  515122
  535344
  542188
  562894
  639258
  605496
  596515
  609140
  586681
  603364
  401318
  464327
  475249
  431269
  413901
  430444
]
4.87 ms
(2.02%)
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
  397364
  397530
  400249
  401318
  401933
  404308
  406592
  407168
  412145
  412288
  413901
  416841
  421000
  421164
  421353
  425043
  425802
  426203
  429409
  430422
  430444
  430556
  430630
  431269
  431352
  434611
  442946
  445436
  445934
  447655
  458719
  461018
  462465
  462477
  462702
  464327
  465371
  466133
  471628
  473204
  474147
  475249
  476909
  476913
  480367
  481163
  482350
  482492
  486198
  486594
  489979
  490430
  490944
  492099
  492106
  492269
  494516
  494778
  497356
  497537
  498039
  505814
  508860
  510254
  514647
  515122
  517301
  518751
  528401
  530884
  531943
  531981
  532129
  533426
  533541
  534334
  534394
  535344
  536370
  542188
  543519
  550571
  558904
  560219
  562894
  563856
  571680
  581897
  584488
  586681
  596515
  599160
  603364
  604524
  605496
  609140
  612868
  621645
  623641
  629357
  631179
  633158
  639258
  643113
  650419
  650660
  650849
  674415
  682545
  688586
  690124
  691196
  698933
  712696
  716220
  717744
  719326
  799936
  808526
  815268
]
2.04 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old mom facesitting"
]
1.58 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old mom фейсситтинг"
]
1.49 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old mom фейсситтинг"
]

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.