Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
413.99 ms
(94.60%)
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
  367962
  386751
  391296
  395662
  412330
  415878
  415977
  416029
  418697
  420774
  423971
  426994
  432679
  432692
  432708
  432727
  432735
  432736
  439071
  439078
  443309
  443475
  445401
  451121
  453234
  454533
  454535
  454537
  455640
  458383
  459970
  460167
  461372
  462198
  462930
  468969
  469591
  470411
  471082
  471445
  471648
  471666
  473005
  473129
  473317
  475885
  476292
  478949
  481846
  485966
  492454
  493164
  494649
  497773
  499350
  500341
  500982
  502717
  508164
  508257
  509427
  511186
  514254
  516940
  517397
  517513
  524864
  526744
  527144
  528671
  529356
  530270
  531303
  534557
  539282
  543129
  545905
  546981
  549707
  554372
  555131
  555281
  555328
  555420
  555592
  555964
  558261
  563036
  564188
  565734
  570940
  571708
  580242
  590410
  618847
  619828
  643380
  657777
  664972
  695386
  701569
  707556
  716550
  726753
  742318
  749242
  751546
  751609
  759014
  763876
  785856
  787488
  794248
  801795
  802256
  803424
  804434
  809811
  812542
  819511
]
14.04 ms
(3.21%)
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
  494649
  432679
  443309
  443475
  415977
  454533
  455640
  458383
  453234
  471082
  511186
  526744
  524864
  528671
  460167
  555281
  570940
  571708
  545905
  543129
  546981
  554372
  555131
  695386
  657777
  549707
  555328
  555964
  563036
  564188
  565734
  619828
  643380
  787488
  812542
  803424
  809811
  742318
  751609
  759014
  763876
  794248
  801795
  804434
  423971
  395662
  454537
  473005
  473317
  502717
  509427
  500341
  462930
  476292
  493164
  412330
  420774
  432708
  432727
  432735
  432736
  439071
  415878
  819511
  454535
  461372
  470411
  481846
  485966
  514254
  530270
  517513
  529356
  531303
  534557
  469591
  471666
  555592
  580242
  707556
  716550
  701569
  664972
  618847
  590410
  785856
  802256
  726753
  749242
  751546
  478949
  468969
  391296
  367962
  473129
  475885
  508164
  499350
  517397
  426994
  386751
  418697
  439078
  416029
  432692
  445401
  471445
  451121
  462198
  492454
  500982
  516940
  527144
  539282
  497773
  508257
  459970
  471648
  555420
  558261
]
3.10 ms
(0.71%)
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
  367962
  386751
  391296
  395662
  412330
  415878
  415977
  416029
  418697
  420774
  423971
  426994
  432679
  432692
  432708
  432727
  432735
  432736
  439071
  439078
  443309
  443475
  445401
  451121
  453234
  454533
  454535
  454537
  455640
  458383
  459970
  460167
  461372
  462198
  462930
  468969
  469591
  470411
  471082
  471445
  471648
  471666
  473005
  473129
  473317
  475885
  476292
  478949
  481846
  485966
  492454
  493164
  494649
  497773
  499350
  500341
  500982
  502717
  508164
  508257
  509427
  511186
  514254
  516940
  517397
  517513
  524864
  526744
  527144
  528671
  529356
  530270
  531303
  534557
  539282
  543129
  545905
  546981
  549707
  554372
  555131
  555281
  555328
  555420
  555592
  555964
  558261
  563036
  564188
  565734
  570940
  571708
  580242
  590410
  618847
  619828
  643380
  657777
  664972
  695386
  701569
  707556
  716550
  726753
  742318
  749242
  751546
  751609
  759014
  763876
  785856
  787488
  794248
  801795
  802256
  803424
  804434
  809811
  812542
  819511
]
1.97 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature shower вебкамер"
]
1.80 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature shower webcam"
]
1.34 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature shower вебкамер"
]

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.