Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
188.64 ms
(88.26%)
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
  13370
  143891
  233143
  233166
  233298
  233556
  233686
  326110
  365839
  366284
  366478
  382433
  384181
  386583
  387868
  388546
  389517
  391760
  394498
  397439
  397902
  400754
  401952
  412150
  414647
  420680
  422135
  424222
  425748
  426785
  426870
  426909
  426925
  426990
  427764
  428835
  431608
  433352
  435016
  440818
  441593
  443762
  443837
  443953
  444237
  450653
  451988
  453397
  453667
  455297
  458750
  460360
  460581
  461009
  461983
  461999
  464553
  464769
  468077
  470611
  470670
  471072
  471576
  471643
  472020
  473962
  474190
  476274
  476500
  476980
  484181
  485365
  489371
  490433
  494401
  495646
  496054
  496067
  496882
  497120
  501068
  505166
  506065
  506222
  506241
  506731
  509084
  509508
  510670
  512657
  513618
  517309
  519539
  522814
  523022
  523528
  524707
  526049
  543736
  555668
  557524
  563400
  563454
  566866
  571391
  571646
  571936
  571944
  573813
  575697
  578840
  578937
  655663
  696781
  764097
  767972
  778206
  778548
  784697
  804863
]
15.16 ms
(7.10%)
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
  428835
  461999
  143891
  394498
  233166
  426870
  426909
  233298
  400754
  431608
  470670
  573813
  13370
  386583
  458750
  512657
  578937
  804863
  366284
  382433
  233556
  387868
  388546
  422135
  426925
  555668
  444237
  426785
  443837
  472020
  460581
  543736
  566866
  563454
  764097
  453667
  326110
  412150
  451988
  461009
  365839
  453397
  476500
  433352
  489371
  495646
  485365
  496054
  509508
  571391
  384181
  233143
  490433
  506065
  443953
  470611
  424222
  557524
  571646
  476980
  474190
  460360
  522814
  501068
  510670
  391760
  473962
  471576
  696781
  778548
  767972
  778206
  784697
  233686
  366478
  389517
  471072
  571936
  563400
  420680
  443762
  397439
  464769
  578840
  655663
  513618
  506241
  524707
  455297
  509084
  496067
  476274
  575697
  571944
  397902
  401952
  435016
  450653
  425748
  427764
  440818
  414647
  468077
  506731
  523022
  484181
  494401
  496882
  505166
  526049
  523528
  506222
  519539
  497120
  426990
  441593
  471643
  517309
  461983
  464553
]
3.10 ms
(1.45%)
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
  13370
  143891
  233143
  233166
  233298
  233556
  233686
  326110
  365839
  366284
  366478
  382433
  384181
  386583
  387868
  388546
  389517
  391760
  394498
  397439
  397902
  400754
  401952
  412150
  414647
  420680
  422135
  424222
  425748
  426785
  426870
  426909
  426925
  426990
  427764
  428835
  431608
  433352
  435016
  440818
  441593
  443762
  443837
  443953
  444237
  450653
  451988
  453397
  453667
  455297
  458750
  460360
  460581
  461009
  461983
  461999
  464553
  464769
  468077
  470611
  470670
  471072
  471576
  471643
  472020
  473962
  474190
  476274
  476500
  476980
  484181
  485365
  489371
  490433
  494401
  495646
  496054
  496067
  496882
  497120
  501068
  505166
  506065
  506222
  506241
  506731
  509084
  509508
  510670
  512657
  513618
  517309
  519539
  522814
  523022
  523528
  524707
  526049
  543736
  555668
  557524
  563400
  563454
  566866
  571391
  571646
  571936
  571944
  573813
  575697
  578840
  578937
  655663
  696781
  764097
  767972
  778206
  778548
  784697
  804863
]
1.89 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "украинки в порно"
]
1.82 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск в порн"
]
1.65 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.68%)
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.