Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.97 ms
(85.63%)
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
  74434
  145280
  153922
  161969
  197736
  212982
  213429
  232995
  233112
  233193
  233344
  233512
  233570
  233862
  311237
  365910
  365962
  365993
  382420
  382937
  385408
  388767
  391554
  391654
  391705
  392030
  392095
  392208
  392671
  394194
  395925
  395955
  397629
  400708
  401055
  401575
  402306
  402896
  402955
  402960
  419543
  419546
  443691
  453784
  459514
  465393
  466338
  470174
  470621
  470670
  470674
  470690
  471072
  477970
  482953
  485945
  486209
  487246
  490890
  493154
  503499
  508382
  508869
  510684
  513811
  520881
  521147
  523019
  526114
  526482
  532827
  534621
  536324
  537233
  543738
  545535
  550475
  551937
  569891
  578348
  581931
  583099
  586443
  601846
  603964
  604121
  609210
  614962
  617641
  617654
  619065
  620243
  622831
  665217
  696324
  718775
  721488
  721497
  721572
  731546
  741460
  741464
  748509
  754106
  754946
  755757
  766541
  777205
  777564
  781650
  781674
  781744
  782230
  789294
  795706
  816997
  819010
  825863
  827951
  827972
]
15.24 ms
(8.82%)
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
  493154
  419546
  617654
  161969
  365993
  510684
  782230
  392208
  520881
  816997
  741464
  459514
  382937
  401055
  232995
  233344
  382420
  609210
  545535
  471072
  402306
  490890
  391554
  617641
  400708
  543738
  604121
  526482
  827972
  721488
  721497
  766541
  781674
  755757
  731546
  385408
  145280
  477970
  453784
  534621
  395925
  470174
  827951
  486209
  521147
  392095
  212982
  391654
  466338
  233112
  394194
  470690
  601846
  550475
  482953
  620243
  523019
  392671
  532827
  665217
  721572
  777205
  795706
  470621
  470670
  153922
  213429
  402955
  419543
  470674
  508869
  487246
  583099
  603964
  74434
  391705
  233570
  233193
  401575
  537233
  578348
  696324
  748509
  388767
  397629
  402960
  503499
  233512
  311237
  365962
  619065
  551937
  513811
  233862
  392030
  465393
  485945
  819010
  825863
  536324
  569891
  614962
  586443
  789294
  741460
  754946
  754106
  718775
  777564
  781650
  781744
  526114
  197736
  395955
  622831
  508382
  581931
  365910
  402896
  443691
]
3.07 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
  74434
  145280
  153922
  161969
  197736
  212982
  213429
  232995
  233112
  233193
  233344
  233512
  233570
  233862
  311237
  365910
  365962
  365993
  382420
  382937
  385408
  388767
  391554
  391654
  391705
  392030
  392095
  392208
  392671
  394194
  395925
  395955
  397629
  400708
  401055
  401575
  402306
  402896
  402955
  402960
  419543
  419546
  443691
  453784
  459514
  465393
  466338
  470174
  470621
  470670
  470674
  470690
  471072
  477970
  482953
  485945
  486209
  487246
  490890
  493154
  503499
  508382
  508869
  510684
  513811
  520881
  521147
  523019
  526114
  526482
  532827
  534621
  536324
  537233
  543738
  545535
  550475
  551937
  569891
  578348
  581931
  583099
  586443
  601846
  603964
  604121
  609210
  614962
  617641
  617654
  619065
  620243
  622831
  665217
  696324
  718775
  721488
  721497
  721572
  731546
  741460
  741464
  748509
  754106
  754946
  755757
  766541
  777205
  777564
  781650
  781674
  781744
  782230
  789294
  795706
  816997
  819010
  825863
  827951
  827972
]
2.00 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "руских женщин"
]
1.77 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск женщин"
]
1.30 ms
(0.75%)
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.