Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
199.56 ms
(88.55%)
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
  402441
  409031
  417267
  423384
  424655
  427762
  432710
  432741
  434750
  436459
  436809
  437156
  438495
  448471
  450152
  451088
  451107
  451276
  451292
  454380
  455031
  456062
  456382
  458996
  459978
  460104
  461202
  461245
  461402
  462899
  463369
  470827
  474063
  478088
  478111
  478210
  478296
  479656
  479886
  481410
  484210
  489894
  493886
  496059
  496637
  503511
  506144
  506961
  508262
  510801
  511988
  512011
  515711
  518318
  519237
  521594
  522561
  522764
  522960
  525896
  527619
  527644
  530213
  546516
  553256
  557071
  557824
  558752
  560970
  562056
  562720
  564080
  568637
  568654
  572962
  574097
  575386
  577723
  583456
  586146
  588018
  594981
  595026
  595040
  595367
  596371
  599956
  603795
  604916
  606143
  606633
  616167
  616939
  627743
  644735
  654269
  662427
  662930
  664676
  672243
  684447
  693632
  707892
  739997
  757455
  771406
  777223
  778116
  781291
  784989
  791610
  792310
  794530
  799498
  802815
  810772
  812593
  813095
  825862
]
16.66 ms
(7.39%)
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
  481410
  417267
  456062
  474063
  508262
  512011
  825862
  409031
  458996
  451088
  522561
  586146
  596371
  599956
  402441
  436459
  456382
  448471
  437156
  455031
  461245
  463369
  519237
  510801
  515711
  461202
  503511
  810772
  478210
  436809
  424655
  434750
  427762
  438495
  423384
  432710
  432741
  450152
  451107
  451292
  479886
  484210
  489894
  454380
  460104
  462899
  451276
  478088
  478111
  506961
  518318
  496637
  521594
  511988
  522764
  522960
  527619
  527644
  530213
  496059
  506144
  525896
  459978
  461402
  470827
  478296
  479656
  493886
  546516
  558752
  564080
  568637
  568654
  574097
  575386
  583456
  553256
  557071
  572962
  693632
  707892
  654269
  672243
  662427
  662930
  664676
  684447
  557824
  560970
  562056
  562720
  577723
  595026
  595040
  603795
  606633
  594981
  604916
  616939
  644735
  588018
  595367
  606143
  616167
  627743
  777223
  778116
  781291
  802815
  812593
  813095
  784989
  794530
  739997
  757455
  769184
  771406
  791610
  792310
  799498
]
2.74 ms
(1.22%)
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
  402441
  409031
  417267
  423384
  424655
  427762
  432710
  432741
  434750
  436459
  436809
  437156
  438495
  448471
  450152
  451088
  451107
  451276
  451292
  454380
  455031
  456062
  456382
  458996
  459978
  460104
  461202
  461245
  461402
  462899
  463369
  470827
  474063
  478088
  478111
  478210
  478296
  479656
  479886
  481410
  484210
  489894
  493886
  496059
  496637
  503511
  506144
  506961
  508262
  510801
  511988
  512011
  515711
  518318
  519237
  521594
  522561
  522764
  522960
  525896
  527619
  527644
  530213
  546516
  553256
  557071
  557824
  558752
  560970
  562056
  562720
  564080
  568637
  568654
  572962
  574097
  575386
  577723
  583456
  586146
  588018
  594981
  595026
  595040
  595367
  596371
  599956
  603795
  604916
  606143
  606633
  616167
  616939
  627743
  644735
  654269
  662427
  662930
  664676
  672243
  684447
  693632
  707892
  739997
  757455
  771406
  777223
  778116
  781291
  784989
  791610
  792310
  794530
  799498
  802815
  810772
  812593
  813095
  825862
]
1.88 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов cumshot"
]
1.66 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov cumshot"
]
1.23 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов cumshot"
]

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.