Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.50 ms
(82.98%)
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
  98543
  129640
  188264
  400137
  400185
  403141
  404582
  405537
  422290
  429747
  429775
  430404
  430621
  443734
  443743
  444736
  467712
  468611
  469434
  469555
  470585
  470663
  476714
  482512
  482938
  494289
  512057
  513303
  516839
  518442
  524952
  524986
  526553
  531155
  531420
  532662
  532812
  532975
  534631
  534650
  535434
  536287
  536289
  541740
  541752
  541833
  541888
  543918
  556503
  576726
  586419
  588244
  588286
  591324
  595780
  599833
  599865
  599880
  599927
  600006
  600014
  600021
  600252
  600360
  603163
  603269
  604890
  609953
  611558
  617427
  619830
  628332
  628336
  630546
  630552
  631968
  632585
  632642
  634134
  634218
  635243
  635800
  636300
  636306
  636985
  637148
  637438
  639334
  639719
  639732
  639739
  639744
  639745
  639767
  639774
  641127
  642006
  642016
  642037
  642039
  643020
  644986
  646901
  647948
  648241
  650155
  651674
  666527
  666894
  674982
  675006
  675010
  675020
  676428
  680174
  685701
  686843
  687461
  725598
  728035
]
20.04 ms
(11.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
  599833
  632585
  524986
  403141
  603163
  728035
  725598
  429747
  467712
  476714
  470663
  556503
  635800
  400137
  422290
  443734
  526553
  595780
  518442
  470585
  541888
  631968
  588286
  576726
  642006
  675020
  642037
  543918
  643020
  541833
  648241
  634134
  642039
  617427
  641127
  430404
  513303
  644986
  532975
  676428
  666894
  674982
  639739
  639719
  586419
  637148
  642016
  531155
  532812
  541752
  651674
  686843
  599880
  600014
  600252
  609953
  611558
  628336
  639334
  588244
  600006
  632642
  630552
  634218
  639774
  524952
  531420
  646901
  675006
  666527
  628332
  630546
  636306
  639744
  600021
  636985
  599865
  636300
  639745
  639767
  430621
  532662
  541740
  647948
  599927
  635243
  600360
  639732
  536289
  687461
  675010
  685701
  516839
  444736
  469434
  536287
  512057
  429775
  129640
  188264
  469555
  534631
  619830
  405537
  98543
  534650
  535434
  494289
  482938
  680174
  603269
  637438
  443743
  650155
  400185
  404582
  482512
  604890
  591324
  468611
]
2.51 ms
(1.43%)
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
  98543
  129640
  188264
  400137
  400185
  403141
  404582
  405537
  422290
  429747
  429775
  430404
  430621
  443734
  443743
  444736
  467712
  468611
  469434
  469555
  470585
  470663
  476714
  482512
  482938
  494289
  512057
  513303
  516839
  518442
  524952
  524986
  526553
  531155
  531420
  532662
  532812
  532975
  534631
  534650
  535434
  536287
  536289
  541740
  541752
  541833
  541888
  543918
  556503
  576726
  586419
  588244
  588286
  591324
  595780
  599833
  599865
  599880
  599927
  600006
  600014
  600021
  600252
  600360
  603163
  603269
  604890
  609953
  611558
  617427
  619830
  628332
  628336
  630546
  630552
  631968
  632585
  632642
  634134
  634218
  635243
  635800
  636300
  636306
  636985
  637148
  637438
  639334
  639719
  639732
  639739
  639744
  639745
  639767
  639774
  641127
  642006
  642016
  642037
  642039
  643020
  644986
  646901
  647948
  648241
  650155
  651674
  666527
  666894
  674982
  675006
  675010
  675020
  676428
  680174
  685701
  686843
  687461
  725598
  728035
]
1.97 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "милфа групповуха"
]
1.96 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милф группов секс"
]
1.54 ms
(0.88%)
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.