Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.37 ms
(87.94%)
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
  307339
  384489
  394548
  400143
  404300
  404859
  405012
  406720
  412007
  415863
  425069
  426691
  427009
  429859
  430377
  430635
  439639
  439700
  439718
  442447
  443806
  444141
  445221
  449879
  451458
  452086
  453311
  455453
  457850
  462489
  463726
  464047
  464337
  464429
  465394
  465957
  466026
  468192
  468843
  469983
  470290
  471334
  471491
  471605
  472235
  473952
  474848
  475169
  478801
  480553
  482254
  482346
  482799
  483417
  484554
  484704
  485988
  486271
  489275
  489285
  492333
  492541
  493548
  495666
  499883
  504446
  505739
  505836
  508243
  508535
  512377
  512402
  513521
  513626
  514650
  515313
  515812
  515986
  517622
  518214
  520029
  520142
  520154
  520710
  522498
  522515
  523019
  524350
  525469
  526833
  527174
  533965
  538145
  544123
  555341
  564137
  565987
  565995
  566983
  567028
  567088
  570126
  572541
  576266
  583452
  584638
  586962
  589656
  596424
  601485
  604990
  611310
  617040
  617682
  623940
  630781
  643252
  671863
  733026
  746167
]
16.76 ms
(7.95%)
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
  520154
  464337
  576266
  746167
  508243
  430635
  566983
  451458
  452086
  489275
  429859
  443806
  473952
  430377
  522498
  475169
  468192
  522515
  474848
  512377
  515986
  394548
  480553
  515812
  630781
  468843
  643252
  404300
  493548
  471491
  505739
  471334
  617682
  733026
  567028
  455453
  463726
  492541
  471605
  604990
  596424
  412007
  464429
  478801
  449879
  482254
  538145
  469983
  527174
  470290
  482346
  445221
  405012
  520142
  453311
  426691
  505836
  485988
  404859
  495666
  508535
  515313
  486271
  611310
  523019
  586962
  564137
  439700
  472235
  504446
  517622
  513521
  520029
  466026
  623940
  499883
  439639
  457850
  462489
  526833
  583452
  544123
  465394
  442447
  489285
  524350
  512402
  570126
  483417
  439718
  533965
  492333
  671863
  307339
  406720
  513626
  484554
  415863
  425069
  482799
  525469
  565995
  617040
  400143
  444141
  601485
  465957
  589656
  427009
  464047
  584638
  565987
  520710
  555341
  384489
  518214
  572541
  484704
  567088
  514650
]
2.60 ms
(1.24%)
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
  307339
  384489
  394548
  400143
  404300
  404859
  405012
  406720
  412007
  415863
  425069
  426691
  427009
  429859
  430377
  430635
  439639
  439700
  439718
  442447
  443806
  444141
  445221
  449879
  451458
  452086
  453311
  455453
  457850
  462489
  463726
  464047
  464337
  464429
  465394
  465957
  466026
  468192
  468843
  469983
  470290
  471334
  471491
  471605
  472235
  473952
  474848
  475169
  478801
  480553
  482254
  482346
  482799
  483417
  484554
  484704
  485988
  486271
  489275
  489285
  492333
  492541
  493548
  495666
  499883
  504446
  505739
  505836
  508243
  508535
  512377
  512402
  513521
  513626
  514650
  515313
  515812
  515986
  517622
  518214
  520029
  520142
  520154
  520710
  522498
  522515
  523019
  524350
  525469
  526833
  527174
  533965
  538145
  544123
  555341
  564137
  565987
  565995
  566983
  567028
  567088
  570126
  572541
  576266
  583452
  584638
  586962
  589656
  596424
  601485
  604990
  611310
  617040
  617682
  623940
  630781
  643252
  671863
  733026
  746167
]
1.64 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с мамой в спальне…"
]
1.60 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин в спальн"
]
1.54 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.60%)
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.