Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.40 ms
(82.06%)
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
  382078
  401215
  404172
  416175
  416620
  418149
  418577
  428235
  428305
  432294
  434080
  439169
  442624
  443245
  448057
  448551
  448914
  452824
  452827
  454004
  455902
  455918
  464844
  469636
  470073
  470471
  471153
  472394
  475422
  475597
  480203
  482145
  487537
  488828
  492906
  492973
  500910
  508154
  513221
  513223
  513793
  514085
  514086
  514147
  518505
  518891
  532940
  534772
  534777
  536527
  545411
  548571
  550049
  550942
  560940
  569765
  583083
  583734
  592593
  596440
  606549
  607742
  625660
  631321
  640948
  642042
  651062
  651632
  664441
  670956
  670970
  677147
  680242
  692654
  700685
  705717
  708714
  720077
  720078
  730324
  734825
  738446
  738483
  738485
  748783
  750426
  750637
  751503
  752538
  752683
  758343
  766830
  770805
  776209
  777001
  777012
  777016
  777762
  779769
  780065
  782827
  782892
  783486
  785589
  785875
  786610
  788776
  790481
  796372
  796640
  797003
  806384
  806425
  806541
  806695
  808333
  808988
  809617
  815483
  825878
]
17.55 ms
(11.39%)
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
  382078
  401215
  434080
  432294
  416175
  448057
  448551
  452827
  464844
  475422
  492973
  482145
  452824
  469636
  470073
  472394
  518891
  500910
  514085
  536527
  513221
  545411
  569765
  550049
  670956
  670970
  705717
  651632
  692654
  700685
  642042
  596440
  592593
  606549
  631321
  777762
  779769
  780065
  782827
  783486
  785589
  796372
  777016
  797003
  808333
  808988
  809617
  750637
  770805
  785875
  790481
  806425
  806541
  806695
  750426
  734825
  738446
  738483
  748783
  730324
  738485
  751503
  752538
  766830
  758343
  640948
  720077
  720078
  777001
  786610
  404172
  416620
  439169
  442624
  448914
  480203
  428305
  475597
  487537
  488828
  518505
  492906
  418149
  418577
  443245
  428235
  825878
  815483
  583734
  454004
  455902
  455918
  470471
  508154
  514086
  532940
  534777
  513793
  514147
  513223
  534772
  471153
  550942
  548571
  651062
  664441
  677147
  680242
  708714
  560940
  583083
  607742
  625660
  806384
  776209
  777012
  796640
  752683
  782892
  788776
]
3.06 ms
(1.99%)
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
  382078
  401215
  404172
  416175
  416620
  418149
  418577
  428235
  428305
  432294
  434080
  439169
  442624
  443245
  448057
  448551
  448914
  452824
  452827
  454004
  455902
  455918
  464844
  469636
  470073
  470471
  471153
  472394
  475422
  475597
  480203
  482145
  487537
  488828
  492906
  492973
  500910
  508154
  513221
  513223
  513793
  514085
  514086
  514147
  518505
  518891
  532940
  534772
  534777
  536527
  545411
  548571
  550049
  550942
  560940
  569765
  583083
  583734
  592593
  596440
  606549
  607742
  625660
  631321
  640948
  642042
  651062
  651632
  664441
  670956
  670970
  677147
  680242
  692654
  700685
  705717
  708714
  720077
  720078
  730324
  734825
  738446
  738483
  738485
  748783
  750426
  750637
  751503
  752538
  752683
  758343
  766830
  770805
  776209
  777001
  777012
  777016
  777762
  779769
  780065
  782827
  782892
  783486
  785589
  785875
  786610
  788776
  790481
  796372
  796640
  797003
  806384
  806425
  806541
  806695
  808333
  808988
  809617
  815483
  825878
]
2.00 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex machine teens"
]
1.87 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин teens"
]
1.64 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сексмашин teens"
]

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.