Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.65 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
  14940
  47220
  70046
  80089
  86315
  86926
  87363
  195888
  196306
  281801
  305519
  330409
  373842
  382851
  387501
  387534
  387805
  388028
  388775
  389288
  390388
  390629
  390663
  393310
  393320
  393509
  396086
  396541
  396567
  396596
  396748
  396843
  396905
  398435
  400967
  404555
  405242
  407523
  409590
  409701
  417939
  417998
  419104
  419917
  422441
  436418
  442642
  443368
  452145
  455069
  457153
  457671
  459776
  461397
  467988
  470141
  471137
  475165
  476327
  481589
  482156
  486151
  488206
  490691
  500228
  506279
  508921
  522407
  529735
  530815
  531576
  536268
  539228
  539400
  539435
  539624
  540887
  542850
  542994
  543911
  549535
  550309
  557114
  559574
  566138
  567031
  585914
  589030
  605490
  624884
  625470
  632892
  635460
  639364
  639571
  643406
  647087
  648497
  650012
  650336
  681511
  696732
  698165
  699191
  716255
  717211
  717757
  730306
  734450
  738316
  752517
  763511
  763537
  772927
  776944
  779992
  780026
  801638
  805308
  809574
]
13.34 ms
(8.46%)
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
  557114
  417939
  467988
  476327
  442642
  330409
  648497
  639571
  388028
  650336
  716255
  681511
  730306
  390388
  481589
  47220
  393509
  396596
  455069
  624884
  549535
  459776
  539228
  567031
  776944
  699191
  506279
  393310
  400967
  443368
  470141
  809574
  80089
  393320
  530815
  531576
  539624
  529735
  539435
  508921
  539400
  542994
  550309
  696732
  717757
  639364
  589030
  635460
  407523
  409590
  305519
  396843
  540887
  650012
  643406
  805308
  734450
  752517
  738316
  396905
  70046
  522407
  387534
  419917
  559574
  566138
  436418
  471137
  422441
  475165
  452145
  373842
  404555
  543911
  195888
  417998
  647087
  585914
  801638
  772927
  382851
  388775
  396086
  486151
  542850
  780026
  632892
  717211
  87363
  387501
  14940
  457153
  405242
  605490
  763511
  281801
  419104
  779992
  409701
  387805
  482156
  488206
  625470
  396567
  196306
  86315
  86926
  698165
  763537
  396748
  390629
  396541
  389288
  390663
  461397
  398435
  490691
  457671
  500228
  536268
]
3.23 ms
(2.05%)
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
  14940
  47220
  70046
  80089
  86315
  86926
  87363
  195888
  196306
  281801
  305519
  330409
  373842
  382851
  387501
  387534
  387805
  388028
  388775
  389288
  390388
  390629
  390663
  393310
  393320
  393509
  396086
  396541
  396567
  396596
  396748
  396843
  396905
  398435
  400967
  404555
  405242
  407523
  409590
  409701
  417939
  417998
  419104
  419917
  422441
  436418
  442642
  443368
  452145
  455069
  457153
  457671
  459776
  461397
  467988
  470141
  471137
  475165
  476327
  481589
  482156
  486151
  488206
  490691
  500228
  506279
  508921
  522407
  529735
  530815
  531576
  536268
  539228
  539400
  539435
  539624
  540887
  542850
  542994
  543911
  549535
  550309
  557114
  559574
  566138
  567031
  585914
  589030
  605490
  624884
  625470
  632892
  635460
  639364
  639571
  643406
  647087
  648497
  650012
  650336
  681511
  696732
  698165
  699191
  716255
  717211
  717757
  730306
  734450
  738316
  752517
  763511
  763537
  772927
  776944
  779992
  780026
  801638
  805308
  809574
]
2.00 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие минет оральн секс"
]
1.92 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой отсос"
]
1.82 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.08%)
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.