Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.23 ms
(87.23%)
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
  73421
  73947
  97570
  188133
  387490
  395653
  400916
  407786
  415543
  445240
  450286
  457930
  457951
  457992
  457999
  459446
  460033
  463851
  465700
  470906
  474056
  477032
  478633
  479669
  485910
  489317
  490142
  499369
  503835
  516218
  521024
  525345
  526164
  530027
  530073
  532932
  535662
  546951
  547577
  549101
  553810
  556659
  559071
  563075
  576503
  584479
  588219
  591353
  603007
  604313
  629480
  641627
  648507
  666757
  668672
  675110
  693740
  696989
  697441
  698820
  710561
  714443
  714459
  716239
  718876
  719097
  724280
  726960
  730119
  732077
  732248
  734182
  734528
  734585
  735925
  736099
  738941
  746838
  748872
  751002
  751491
  753737
  754274
  759770
  759908
  759941
  759946
  762913
  766159
  767175
  767699
  767701
  769645
  773666
  774141
  777580
  784621
  785426
  789358
  790517
  798632
  798857
  801083
  802700
  806139
  816423
  817563
  817569
  817570
  817781
  818576
  819916
  820072
  823571
  824188
  824479
  824886
  824944
  825951
  828551
]
13.72 ms
(8.08%)
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
  588219
  629480
  641627
  603007
  789358
  802700
  734528
  735925
  751491
  754274
  724280
  774141
  773666
  806139
  407786
  816423
  820072
  817781
  457999
  477032
  459446
  490142
  457992
  479669
  516218
  526164
  532932
  576503
  719097
  714443
  547577
  591353
  604313
  777580
  732248
  767175
  726960
  759941
  736099
  769645
  714459
  785426
  387490
  474056
  73421
  400916
  457930
  478633
  535662
  584479
  668672
  696989
  549101
  556659
  767701
  801083
  762913
  759908
  710561
  718876
  784621
  790517
  395653
  445240
  470906
  460033
  465700
  499369
  503835
  525345
  521024
  188133
  489317
  559071
  563075
  759946
  450286
  463851
  457951
  415543
  546951
  675110
  73947
  97570
  817563
  817569
  817570
  819916
  823571
  818576
  824188
  824479
  825951
  824886
  824944
  828551
  485910
  530027
  530073
  697441
  648507
  666757
  693740
  698820
  553810
  798857
  732077
  746838
  766159
  734182
  738941
  751002
  748872
  753737
  759770
  730119
  734585
  767699
  716239
  798632
]
2.18 ms
(1.28%)
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
  73421
  73947
  97570
  188133
  387490
  395653
  400916
  407786
  415543
  445240
  450286
  457930
  457951
  457992
  457999
  459446
  460033
  463851
  465700
  470906
  474056
  477032
  478633
  479669
  485910
  489317
  490142
  499369
  503835
  516218
  521024
  525345
  526164
  530027
  530073
  532932
  535662
  546951
  547577
  549101
  553810
  556659
  559071
  563075
  576503
  584479
  588219
  591353
  603007
  604313
  629480
  641627
  648507
  666757
  668672
  675110
  693740
  696989
  697441
  698820
  710561
  714443
  714459
  716239
  718876
  719097
  724280
  726960
  730119
  732077
  732248
  734182
  734528
  734585
  735925
  736099
  738941
  746838
  748872
  751002
  751491
  753737
  754274
  759770
  759908
  759941
  759946
  762913
  766159
  767175
  767699
  767701
  769645
  773666
  774141
  777580
  784621
  785426
  789358
  790517
  798632
  798857
  801083
  802700
  806139
  816423
  817563
  817569
  817570
  817781
  818576
  819916
  820072
  823571
  824188
  824479
  824886
  824944
  825951
  828551
]
1.76 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy mother"
]
1.48 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy мам женщин"
]
1.22 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy мам женщин"
]

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.