Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.34 ms
(85.96%)
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
  188117
  384144
  414350
  454280
  461045
  461890
  464355
  480495
  488475
  512687
  524520
  528751
  532790
  538843
  540461
  542489
  545046
  547467
  547473
  547485
  547570
  548517
  549996
  550027
  551319
  551442
  552497
  552664
  553154
  553274
  554217
  555104
  557742
  557932
  559161
  560164
  560216
  561140
  562844
  563048
  565039
  567097
  567408
  569258
  569550
  569556
  569722
  572031
  572189
  572601
  572605
  573385
  573908
  574196
  574351
  574442
  575983
  577981
  579685
  582024
  582980
  582985
  583804
  585960
  586858
  586914
  589543
  590150
  590218
  590246
  592015
  592516
  593270
  593743
  594956
  596286
  598832
  598849
  598911
  599664
  599852
  599868
  599921
  599957
  600215
  600295
  600334
  600352
  601060
  603674
  604483
  604766
  604915
  607080
  617216
  617416
  622826
  623805
  623871
  643376
  646312
  660023
  660410
  671043
  673341
  685280
  726081
  727622
  760794
  770615
  773554
  775268
  776503
  797632
  798584
  800005
  800188
  809084
  814041
  816270
]
18.11 ms
(8.73%)
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
  560216
  569556
  551442
  567408
  599664
  617216
  598832
  528751
  524520
  414350
  532790
  547467
  547473
  547485
  559161
  552664
  561140
  572189
  660410
  553274
  569258
  572031
  582024
  598849
  598911
  604483
  589543
  599921
  599957
  599852
  600215
  600352
  585960
  590150
  593743
  599868
  600295
  600334
  643376
  760794
  617416
  461890
  188117
  623805
  384144
  814041
  816270
  461045
  464355
  538843
  540461
  554217
  572601
  572605
  575983
  583804
  548517
  563048
  565039
  569550
  569722
  574196
  574351
  579685
  549996
  547570
  562844
  567097
  573908
  590246
  593270
  601060
  607080
  622826
  592015
  594956
  596286
  603674
  604915
  590218
  775268
  776503
  727622
  770615
  798584
  809084
  773554
  797632
  512687
  555104
  671043
  557742
  557932
  577981
  586914
  586858
  623871
  454280
  480495
  488475
  542489
  552497
  573385
  550027
  560164
  582980
  582985
  660023
  685280
  646312
  673341
  545046
  551319
  553154
  574442
  592516
  604766
  800005
  800188
  726081
]
2.76 ms
(1.33%)
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
  188117
  384144
  414350
  454280
  461045
  461890
  464355
  480495
  488475
  512687
  524520
  528751
  532790
  538843
  540461
  542489
  545046
  547467
  547473
  547485
  547570
  548517
  549996
  550027
  551319
  551442
  552497
  552664
  553154
  553274
  554217
  555104
  557742
  557932
  559161
  560164
  560216
  561140
  562844
  563048
  565039
  567097
  567408
  569258
  569550
  569556
  569722
  572031
  572189
  572601
  572605
  573385
  573908
  574196
  574351
  574442
  575983
  577981
  579685
  582024
  582980
  582985
  583804
  585960
  586858
  586914
  589543
  590150
  590218
  590246
  592015
  592516
  593270
  593743
  594956
  596286
  598832
  598849
  598911
  599664
  599852
  599868
  599921
  599957
  600215
  600295
  600334
  600352
  601060
  603674
  604483
  604766
  604915
  607080
  617216
  617416
  622826
  623805
  623871
  643376
  646312
  660023
  660410
  671043
  673341
  685280
  726081
  727622
  760794
  770615
  773554
  775268
  776503
  797632
  798584
  800005
  800188
  809084
  814041
  816270
]
2.54 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother butt"
]
2.12 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин butt"
]
1.88 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин butt"
]
1.72 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.