Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.15 ms
(88.73%)
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
  6965
  7396
  189380
  391251
  392600
  394670
  397921
  400816
  415827
  418778
  418900
  421820
  421844
  421862
  421883
  421894
  425531
  426543
  426686
  428602
  429881
  432706
  439463
  439643
  440745
  440825
  440878
  440897
  440979
  441113
  441511
  443371
  445709
  446525
  447102
  449079
  452308
  454537
  459200
  459633
  461057
  461629
  462561
  465540
  465615
  466224
  466227
  466245
  466793
  474265
  474582
  483557
  483656
  489271
  491601
  492346
  493225
  493575
  494156
  495044
  497005
  498616
  512100
  513641
  514833
  519350
  536213
  546976
  554874
  555093
  582479
  582557
  590621
  592147
  708161
  709654
  709880
  710204
  711149
  715813
  718041
  719929
  725185
  728259
  730391
  733548
  734373
  738018
  742719
  746544
  747052
  751498
  756685
  759566
  759921
  759936
  760953
  768392
  768764
  775640
  777728
  779804
  780810
  785107
  785495
  788983
  791803
  794763
  794886
  795276
  795916
  796139
  800582
  800828
  801309
  802151
  802160
  802620
  803145
  818542
]
11.71 ms
(6.49%)
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
  800828
  7396
  441511
  418778
  440825
  445709
  796139
  421883
  443371
  462561
  454537
  391251
  449079
  421862
  519350
  439463
  440979
  400816
  483656
  493225
  428602
  708161
  432706
  440897
  440745
  441113
  465615
  483557
  497005
  494156
  546976
  582557
  791803
  751498
  421844
  440878
  429881
  466793
  466224
  536213
  498616
  466245
  777728
  734373
  802620
  392600
  459200
  461057
  397921
  465540
  474265
  780810
  425531
  779804
  785107
  775640
  800582
  728259
  760953
  725185
  730391
  756685
  768392
  759936
  788983
  6965
  446525
  555093
  802151
  709654
  719929
  489271
  493575
  514833
  439643
  466227
  426543
  426686
  452308
  512100
  513641
  418900
  768764
  710204
  189380
  459633
  715813
  794886
  802160
  801309
  738018
  746544
  785495
  733548
  747052
  742719
  759566
  794763
  795916
  803145
  394670
  582479
  447102
  421894
  421820
  491601
  495044
  554874
  592147
  590621
  709880
  415827
  795276
  474582
  492346
  759921
  718041
  461629
  818542
  711149
]
2.41 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
  6965
  7396
  189380
  391251
  392600
  394670
  397921
  400816
  415827
  418778
  418900
  421820
  421844
  421862
  421883
  421894
  425531
  426543
  426686
  428602
  429881
  432706
  439463
  439643
  440745
  440825
  440878
  440897
  440979
  441113
  441511
  443371
  445709
  446525
  447102
  449079
  452308
  454537
  459200
  459633
  461057
  461629
  462561
  465540
  465615
  466224
  466227
  466245
  466793
  474265
  474582
  483557
  483656
  489271
  491601
  492346
  493225
  493575
  494156
  495044
  497005
  498616
  512100
  513641
  514833
  519350
  536213
  546976
  554874
  555093
  582479
  582557
  590621
  592147
  708161
  709654
  709880
  710204
  711149
  715813
  718041
  719929
  725185
  728259
  730391
  733548
  734373
  738018
  742719
  746544
  747052
  751498
  756685
  759566
  759921
  759936
  760953
  768392
  768764
  775640
  777728
  779804
  780810
  785107
  785495
  788983
  791803
  794763
  794886
  795276
  795916
  796139
  800582
  800828
  801309
  802151
  802160
  802620
  803145
  818542
]
1.69 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "любительское мамаши с…"
]
1.60 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск мам женщин"
]
1.54 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.