Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.97 ms
(81.90%)
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
  13011
  14232
  14700
  14711
  31218
  33755
  59007
  70852
  75936
  78536
  78637
  78926
  79082
  79331
  102626
  130054
  146523
  189230
  238809
  304063
  306045
  308331
  325648
  328446
  342269
  353299
  378272
  383088
  386198
  386743
  390508
  390857
  391144
  395398
  395405
  395406
  395450
  397519
  398240
  398518
  398828
  399222
  399355
  399717
  404124
  405979
  408611
  410956
  412858
  415115
  417053
  417113
  417929
  418052
  418453
  418897
  419358
  419808
  420203
  420614
  421250
  421743
  425125
  425587
  425601
  435715
  443661
  444442
  445601
  445741
  446976
  449353
  452228
  452601
  453590
  457240
  457401
  459012
  459226
  460079
  461044
  463894
  464146
  464147
  467028
  468352
  468423
  471859
  475821
  477801
  478556
  483251
  483457
  486268
  491239
  493808
  494997
  502179
  518438
  518587
  522140
  527988
  530557
  530587
  558432
  558657
  567208
  574460
  584749
  598178
  602010
  648906
  655358
  705793
  712776
  716065
  732753
  738648
  747879
  758829
]
16.17 ms
(11.04%)
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
  460079
  486268
  417929
  527988
  59007
  558432
  342269
  189230
  398240
  78536
  397519
  558657
  648906
  102626
  75936
  390857
  79331
  452601
  574460
  14711
  398518
  449353
  33755
  238809
  390508
  483251
  443661
  417053
  452228
  415115
  419358
  705793
  732753
  475821
  325648
  404124
  425587
  602010
  420614
  420203
  418453
  395398
  14700
  453590
  491239
  494997
  598178
  79082
  391144
  395405
  478556
  383088
  78637
  378272
  530587
  353299
  518438
  70852
  412858
  386198
  306045
  655358
  399717
  421250
  446976
  13011
  304063
  399222
  418052
  738648
  130054
  419808
  518587
  464147
  584749
  308331
  425601
  468423
  328446
  395450
  408611
  417113
  467028
  483457
  461044
  31218
  398828
  418897
  445741
  463894
  522140
  471859
  395406
  399355
  425125
  464146
  386743
  444442
  459226
  468352
  445601
  477801
  530557
  716065
  747879
  502179
  14232
  567208
  405979
  712776
  457240
  758829
  146523
  78926
  421743
  410956
  435715
  457401
  459012
  493808
]
3.17 ms
(2.16%)
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
  13011
  14232
  14700
  14711
  31218
  33755
  59007
  70852
  75936
  78536
  78637
  78926
  79082
  79331
  102626
  130054
  146523
  189230
  238809
  304063
  306045
  308331
  325648
  328446
  342269
  353299
  378272
  383088
  386198
  386743
  390508
  390857
  391144
  395398
  395405
  395406
  395450
  397519
  398240
  398518
  398828
  399222
  399355
  399717
  404124
  405979
  408611
  410956
  412858
  415115
  417053
  417113
  417929
  418052
  418453
  418897
  419358
  419808
  420203
  420614
  421250
  421743
  425125
  425587
  425601
  435715
  443661
  444442
  445601
  445741
  446976
  449353
  452228
  452601
  453590
  457240
  457401
  459012
  459226
  460079
  461044
  463894
  464146
  464147
  467028
  468352
  468423
  471859
  475821
  477801
  478556
  483251
  483457
  486268
  491239
  493808
  494997
  502179
  518438
  518587
  522140
  527988
  530557
  530587
  558432
  558657
  567208
  574460
  584749
  598178
  602010
  648906
  655358
  705793
  712776
  716065
  732753
  738648
  747879
  758829
]
1.90 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жена изменяет с негра%…"
]
1.86 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен жен чернокожий"
]
1.55 ms
(1.06%)
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.