Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.11 ms
(84.14%)
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
  31329
  383558
  383985
  389218
  390002
  393705
  397207
  398484
  401657
  401921
  402101
  413286
  414833
  416795
  419979
  420132
  420301
  430293
  431643
  438430
  443134
  443184
  443581
  447694
  449093
  453239
  453244
  454195
  454565
  455353
  459897
  460010
  460418
  461136
  462815
  463898
  465571
  465698
  466886
  466891
  471659
  473219
  473468
  476229
  476307
  476316
  476319
  477296
  483885
  484373
  485599
  485692
  485745
  485755
  485763
  485766
  489721
  491865
  502832
  503994
  505963
  509643
  515952
  518859
  518922
  524907
  527423
  530098
  531532
  531547
  536557
  544859
  549236
  566387
  574649
  582440
  590870
  600502
  603507
  606192
  614742
  617390
  617659
  620748
  640350
  663449
  664798
  664813
  664966
  665384
  667536
  667756
  668192
  707518
  714047
  724309
  727900
  732782
  733148
  735942
  750948
  771642
  772062
  781812
  781851
  781853
  781859
  781892
  782024
  794622
  799180
  808057
  808752
  811883
  813801
  813808
  814112
  814704
  827201
  827290
]
16.68 ms
(10.09%)
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
  781851
  735942
  827201
  463898
  664966
  664813
  383558
  449093
  485755
  389218
  813801
  454195
  476316
  485692
  503994
  667536
  620748
  606192
  617390
  781859
  811883
  732782
  476307
  502832
  383985
  401657
  485599
  509643
  485766
  518859
  590870
  420132
  430293
  813808
  466886
  471659
  485763
  530098
  544859
  574649
  714047
  668192
  707518
  640350
  724309
  750948
  772062
  771642
  454565
  483885
  531547
  460010
  462815
  505963
  489721
  664798
  461136
  484373
  443581
  419979
  531532
  413286
  402101
  466891
  31329
  390002
  465698
  527423
  416795
  438430
  827290
  814704
  453244
  473219
  582440
  665384
  667756
  794622
  808752
  781892
  781853
  397207
  459897
  603507
  476319
  524907
  566387
  799180
  782024
  455353
  536557
  727900
  485745
  443134
  473468
  414833
  447694
  453239
  518922
  443184
  431643
  476229
  393705
  420301
  781812
  808057
  401921
  465571
  515952
  398484
  733148
  477296
  460418
  614742
  663449
  491865
  814112
  549236
  600502
  617659
]
2.68 ms
(1.62%)
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
  31329
  383558
  383985
  389218
  390002
  393705
  397207
  398484
  401657
  401921
  402101
  413286
  414833
  416795
  419979
  420132
  420301
  430293
  431643
  438430
  443134
  443184
  443581
  447694
  449093
  453239
  453244
  454195
  454565
  455353
  459897
  460010
  460418
  461136
  462815
  463898
  465571
  465698
  466886
  466891
  471659
  473219
  473468
  476229
  476307
  476316
  476319
  477296
  483885
  484373
  485599
  485692
  485745
  485755
  485763
  485766
  489721
  491865
  502832
  503994
  505963
  509643
  515952
  518859
  518922
  524907
  527423
  530098
  531532
  531547
  536557
  544859
  549236
  566387
  574649
  582440
  590870
  600502
  603507
  606192
  614742
  617390
  617659
  620748
  640350
  663449
  664798
  664813
  664966
  665384
  667536
  667756
  668192
  707518
  714047
  724309
  727900
  732782
  733148
  735942
  750948
  771642
  772062
  781812
  781851
  781853
  781859
  781892
  782024
  794622
  799180
  808057
  808752
  811883
  813801
  813808
  814112
  814704
  827201
  827290
]
1.99 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbw blow job"
]
1.92 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbw минет оральн секс"
]
1.37 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbw минет оральн секс"
]

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.