Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.36 ms
(83.58%)
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
  7086
  130045
  143195
  386709
  404478
  405116
  407324
  407683
  407911
  408201
  420209
  426233
  428114
  432696
  432727
  441269
  441789
  443833
  444413
  445644
  453716
  454535
  457480
  458420
  462747
  462911
  465302
  466834
  468369
  469084
  469540
  470411
  472571
  474872
  475242
  478931
  487632
  503269
  504417
  512818
  514612
  515481
  518519
  523051
  533929
  544639
  545166
  554843
  564690
  567345
  580913
  583460
  640750
  643376
  650179
  703481
  709746
  714314
  714420
  724123
  724844
  726474
  726543
  726553
  726632
  727046
  729283
  730333
  731412
  732203
  733486
  733548
  739938
  742770
  744240
  747213
  759010
  759012
  759740
  761577
  765367
  766888
  767024
  767138
  767154
  767192
  767257
  768862
  776913
  784302
  785724
  788262
  790879
  801318
  802186
  807431
  807805
  808032
  808470
  810278
  810470
  811003
  811014
  811945
  812579
  814240
  814249
  814471
  815777
  816046
  816069
  817290
  817383
  820052
  820550
  821377
  821726
  823377
  824781
  826645
]
16.31 ms
(10.30%)
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
  790879
  808470
  468369
  453716
  814249
  821377
  820052
  821726
  815777
  823377
  824781
  472571
  583460
  714420
  703481
  544639
  545166
  554843
  567345
  640750
  807431
  808032
  811014
  812579
  776913
  785724
  802186
  729283
  744240
  759010
  767138
  767154
  767257
  801318
  807805
  733548
  724844
  726474
  726632
  742770
  759012
  724123
  730333
  747213
  759740
  761577
  766888
  767024
  727046
  731412
  732203
  739938
  765367
  767192
  768862
  709746
  714314
  784302
  810278
  810470
  386709
  7086
  405116
  404478
  426233
  428114
  432696
  444413
  407911
  432727
  441269
  454535
  469084
  474872
  458420
  470411
  457480
  462747
  462911
  514612
  518519
  465302
  466834
  811945
  811003
  407324
  478931
  407683
  420209
  441789
  475242
  503269
  523051
  512818
  515481
  445644
  469540
  504417
  650179
  564690
  643376
  788262
  443833
  533929
  580913
  733486
  726543
  726553
  487632
  130045
  143195
  408201
  814471
  816069
  817383
  826645
  814240
  816046
  817290
  820550
]
3.19 ms
(2.01%)
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
  7086
  130045
  143195
  386709
  404478
  405116
  407324
  407683
  407911
  408201
  420209
  426233
  428114
  432696
  432727
  441269
  441789
  443833
  444413
  445644
  453716
  454535
  457480
  458420
  462747
  462911
  465302
  466834
  468369
  469084
  469540
  470411
  472571
  474872
  475242
  478931
  487632
  503269
  504417
  512818
  514612
  515481
  518519
  523051
  533929
  544639
  545166
  554843
  564690
  567345
  580913
  583460
  640750
  643376
  650179
  703481
  709746
  714314
  714420
  724123
  724844
  726474
  726543
  726553
  726632
  727046
  729283
  730333
  731412
  732203
  733486
  733548
  739938
  742770
  744240
  747213
  759010
  759012
  759740
  761577
  765367
  766888
  767024
  767138
  767154
  767192
  767257
  768862
  776913
  784302
  785724
  788262
  790879
  801318
  802186
  807431
  807805
  808032
  808470
  810278
  810470
  811003
  811014
  811945
  812579
  814240
  814249
  814471
  815777
  816046
  816069
  817290
  817383
  820052
  820550
  821377
  821726
  823377
  824781
  826645
]
1.91 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature latina"
]
1.67 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature латинская"
]
1.43 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature латинская"
]

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.