Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.11 ms
(81.02%)
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
  68292
  83152
  94796
  105093
  123070
  123741
  142528
  143291
  162043
  209384
  209385
  209476
  209931
  213692
  213932
  214560
  285875
  313978
  384326
  386626
  391270
  401926
  404052
  407795
  411943
  447490
  451945
  452058
  452082
  457762
  457786
  460739
  467597
  467626
  470254
  471366
  474020
  480059
  489243
  490262
  501245
  510443
  513901
  516882
  530661
  533602
  534795
  538962
  557938
  557977
  558367
  560087
  571674
  572038
  595787
  597231
  597235
  603168
  603190
  603256
  603259
  622658
  625412
  627804
  637004
  637034
  645936
  671729
  672422
  679536
  680116
  680154
  680159
  680170
  680182
  681570
  690321
  697173
  697296
  702168
  708764
  709306
  712235
  712646
  714815
  716043
  716373
  716948
  722262
  722551
  723605
  726322
  732406
  734117
  743117
  745187
  748341
  775068
  775828
  775984
  775992
  780631
  788257
  792562
  802561
  803360
  803453
  803469
  803843
  807386
  815452
  817344
  820160
  822377
  823832
  825036
  827414
  827947
  828387
]
19.71 ms
(12.28%)
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
  538962
  708764
  803843
  748341
  803453
  285875
  411943
  697296
  407795
  447490
  474020
  513901
  516882
  557977
  572038
  557938
  680154
  681570
  595787
  603168
  627804
  807386
  467626
  471366
  467597
  452058
  457786
  490262
  510443
  817344
  732406
  722262
  68292
  83152
  94796
  209385
  209931
  142528
  313978
  391270
  401926
  827414
  679536
  672422
  712235
  716948
  697173
  776019
  213932
  716373
  775068
  743117
  775828
  775984
  775992
  457762
  645936
  680116
  680170
  603256
  603259
  637034
  625412
  637004
  716043
  470254
  788257
  384326
  213692
  123070
  209384
  209476
  214560
  404052
  823832
  723605
  815452
  827947
  828387
  501245
  534795
  533602
  558367
  560087
  671729
  690321
  722551
  712646
  603190
  780631
  803469
  803360
  734117
  726322
  745187
  622658
  709306
  714815
  792562
  802561
  452082
  489243
  530661
  571674
  680182
  702168
  680159
  597231
  597235
  480059
  451945
  460739
  386626
  105093
  123741
  162043
  143291
  820160
  825036
  822377
]
2.92 ms
(1.82%)
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
  68292
  83152
  94796
  105093
  123070
  123741
  142528
  143291
  162043
  209384
  209385
  209476
  209931
  213692
  213932
  214560
  285875
  313978
  384326
  386626
  391270
  401926
  404052
  407795
  411943
  447490
  451945
  452058
  452082
  457762
  457786
  460739
  467597
  467626
  470254
  471366
  474020
  480059
  489243
  490262
  501245
  510443
  513901
  516882
  530661
  533602
  534795
  538962
  557938
  557977
  558367
  560087
  571674
  572038
  595787
  597231
  597235
  603168
  603190
  603256
  603259
  622658
  625412
  627804
  637004
  637034
  645936
  671729
  672422
  679536
  680116
  680154
  680159
  680170
  680182
  681570
  690321
  697173
  697296
  702168
  708764
  709306
  712235
  712646
  714815
  716043
  716373
  716948
  722262
  722551
  723605
  726322
  732406
  734117
  743117
  745187
  748341
  775068
  775828
  775984
  775992
  780631
  788257
  792562
  802561
  803360
  803453
  803469
  803843
  807386
  815452
  817344
  820160
  822377
  823832
  825036
  827414
  827947
  828387
]
2.47 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "group pussy"
]
1.94 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "group pussy"
]
1.63 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "group pussy"
]

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.