Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.42 ms
(81.47%)
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
  389397
  391225
  392266
  392909
  393562
  393862
  395233
  396051
  396594
  397335
  398643
  398647
  401655
  406116
  406800
  410597
  410776
  410930
  412474
  413195
  413719
  413898
  419702
  420023
  425160
  429065
  429186
  430949
  439840
  440624
  443256
  444842
  446025
  446460
  449008
  450353
  451981
  454566
  455683
  456956
  461733
  470313
  475920
  479523
  479593
  482824
  488097
  491893
  491894
  499529
  500110
  501208
  501658
  506556
  515499
  517340
  519859
  523301
  524531
  525090
  535219
  536779
  543217
  546434
  546872
  548903
  552613
  558949
  560654
  567185
  571465
  571466
  571945
  572054
  573121
  573668
  574102
  575451
  577544
  578392
  578410
  581067
  584482
  585366
  585994
  586502
  590413
  590601
  594893
  595732
  595816
  597063
  598672
  653228
  654427
  654437
  655980
  659587
  665404
  666614
  668674
  675050
  680177
  684326
  693186
  734239
  736286
  765960
  777198
  780979
  803445
  804706
  809174
  810119
  814136
  816214
  817623
  821468
  821556
  824921
]
17.57 ms
(11.60%)
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
  560654
  594893
  491894
  515499
  571465
  653228
  803445
  456956
  446460
  446025
  395233
  444842
  517340
  548903
  817623
  449008
  571945
  501208
  573668
  412474
  425160
  684326
  429065
  546434
  451981
  574102
  585366
  406800
  392909
  397335
  810119
  410776
  461733
  572054
  391225
  430949
  577544
  680177
  523301
  410930
  597063
  590413
  439840
  578392
  410597
  543217
  584482
  567185
  590601
  393862
  488097
  413898
  479523
  821468
  666614
  734239
  777198
  398647
  586502
  440624
  419702
  578410
  581067
  595816
  585994
  392266
  475920
  535219
  546872
  598672
  479593
  501658
  525090
  491893
  482824
  499529
  401655
  519859
  429186
  575451
  470313
  814136
  654437
  406116
  536779
  420023
  552613
  668674
  665404
  804706
  809174
  765960
  524531
  595732
  450353
  389397
  824921
  693186
  736286
  396051
  443256
  393562
  455683
  454566
  398643
  413195
  816214
  659587
  573121
  558949
  506556
  500110
  654427
  675050
  780979
  413719
  396594
  821556
  571466
  655980
]
3.04 ms
(2.01%)
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
  389397
  391225
  392266
  392909
  393562
  393862
  395233
  396051
  396594
  397335
  398643
  398647
  401655
  406116
  406800
  410597
  410776
  410930
  412474
  413195
  413719
  413898
  419702
  420023
  425160
  429065
  429186
  430949
  439840
  440624
  443256
  444842
  446025
  446460
  449008
  450353
  451981
  454566
  455683
  456956
  461733
  470313
  475920
  479523
  479593
  482824
  488097
  491893
  491894
  499529
  500110
  501208
  501658
  506556
  515499
  517340
  519859
  523301
  524531
  525090
  535219
  536779
  543217
  546434
  546872
  548903
  552613
  558949
  560654
  567185
  571465
  571466
  571945
  572054
  573121
  573668
  574102
  575451
  577544
  578392
  578410
  581067
  584482
  585366
  585994
  586502
  590413
  590601
  594893
  595732
  595816
  597063
  598672
  653228
  654427
  654437
  655980
  659587
  665404
  666614
  668674
  675050
  680177
  684326
  693186
  734239
  736286
  765960
  777198
  780979
  803445
  804706
  809174
  810119
  814136
  816214
  817623
  821468
  821556
  824921
]
2.07 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny girls deepthroat"
]
1.97 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худая девушк глубокийминет минет оральн секс"
]
1.65 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.