Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.38 ms
(83.72%)
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
  72285
  117876
  354774
  358200
  387453
  396924
  398534
  404602
  408433
  410979
  414782
  415633
  417457
  420151
  423653
  424411
  430314
  430411
  435662
  439470
  439591
  439784
  440614
  440908
  443173
  443278
  444045
  446059
  449375
  450649
  452254
  453138
  453262
  453263
  454053
  457852
  458930
  460138
  460187
  460689
  464291
  464970
  465341
  466217
  467626
  467926
  467974
  468685
  469455
  470295
  472148
  475676
  475875
  475881
  476168
  476908
  477587
  477716
  478503
  479717
  480305
  482505
  482575
  484310
  484439
  484558
  484591
  484705
  485267
  485693
  485945
  489317
  489388
  489398
  489400
  496724
  497517
  500458
  504692
  505636
  505641
  509204
  510333
  510915
  513131
  513635
  513976
  518828
  518839
  522140
  523929
  525133
  527964
  529246
  535452
  536625
  536824
  544464
  549728
  552850
  555181
  557022
  558289
  558490
  563196
  565726
  573742
  573801
  580913
  587272
  590797
  591883
  602974
  604018
  617389
  682303
  726294
  746114
  762208
  799369
]
18.44 ms
(9.94%)
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
  465341
  475881
  529246
  484591
  513635
  497517
  484439
  496724
  518828
  527964
  555181
  573742
  523929
  682303
  476908
  430314
  513976
  482575
  485267
  500458
  525133
  518839
  480305
  580913
  573801
  587272
  602974
  604018
  439784
  440614
  467626
  470295
  472148
  439591
  424411
  443278
  444045
  446059
  466217
  477716
  509204
  484558
  484705
  535452
  117876
  358200
  72285
  387453
  396924
  404602
  439470
  414782
  415633
  440908
  443173
  410979
  435662
  464291
  479717
  453262
  453263
  469455
  505636
  536824
  552850
  591883
  590797
  799369
  746114
  726294
  762208
  617389
  398534
  417457
  467926
  408433
  354774
  450649
  475875
  484310
  485945
  430411
  420151
  423653
  482505
  452254
  458930
  460187
  467974
  485693
  489317
  489398
  489400
  454053
  457852
  460138
  460689
  476168
  477587
  449375
  453138
  464970
  478503
  513131
  522140
  510915
  536625
  504692
  510333
  505641
  468685
  475676
  489388
  558289
  544464
  549728
  563196
  565726
  557022
  558490
]
3.44 ms
(1.85%)
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
  72285
  117876
  354774
  358200
  387453
  396924
  398534
  404602
  408433
  410979
  414782
  415633
  417457
  420151
  423653
  424411
  430314
  430411
  435662
  439470
  439591
  439784
  440614
  440908
  443173
  443278
  444045
  446059
  449375
  450649
  452254
  453138
  453262
  453263
  454053
  457852
  458930
  460138
  460187
  460689
  464291
  464970
  465341
  466217
  467626
  467926
  467974
  468685
  469455
  470295
  472148
  475676
  475875
  475881
  476168
  476908
  477587
  477716
  478503
  479717
  480305
  482505
  482575
  484310
  484439
  484558
  484591
  484705
  485267
  485693
  485945
  489317
  489388
  489398
  489400
  496724
  497517
  500458
  504692
  505636
  505641
  509204
  510333
  510915
  513131
  513635
  513976
  518828
  518839
  522140
  523929
  525133
  527964
  529246
  535452
  536625
  536824
  544464
  549728
  552850
  555181
  557022
  558289
  558490
  563196
  565726
  573742
  573801
  580913
  587272
  590797
  591883
  602974
  604018
  617389
  682303
  726294
  746114
  762208
  799369
]
2.17 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature in bed"
]
2.17 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature постел"
]
2.04 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.