Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.12 ms
(84.80%)
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
  252608
  387545
  392986
  393127
  395654
  399332
  402979
  412155
  417173
  422453
  432383
  441427
  441577
  441615
  451012
  452490
  453514
  458902
  461585
  462116
  462304
  467169
  469740
  475541
  484011
  485039
  489022
  495131
  500152
  503721
  511182
  514150
  519683
  520337
  521019
  521179
  521939
  523935
  524973
  527262
  540724
  543330
  549146
  553142
  558218
  559928
  561310
  561916
  563870
  566517
  567523
  571765
  571772
  571777
  577887
  579159
  580491
  585835
  585930
  588844
  590807
  598869
  599481
  603910
  605928
  611518
  620060
  622465
  625134
  625259
  634799
  645369
  648762
  651794
  659330
  665418
  677015
  677132
  682573
  685051
  685055
  687408
  696688
  699674
  706912
  707384
  708869
  718933
  719573
  729836
  731794
  736911
  739905
  744290
  745214
  751725
  758270
  763850
  766342
  769324
  770718
  778588
  784110
  786383
  787906
  788007
  788144
  788669
  789157
  789856
  791413
  795440
  797817
  800003
  801274
  803142
  814073
  821864
  823217
]
15.21 ms
(8.65%)
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
  549146
  558218
  561916
  563870
  659330
  707384
  708869
  665418
  677132
  696688
  620060
  611518
  598869
  778588
  786383
  789157
  789856
  769324
  770718
  745214
  758270
  731794
  718933
  787906
  788669
  791413
  795440
  432383
  451012
  402979
  441427
  441577
  814073
  458902
  520337
  577887
  559928
  571772
  645369
  685051
  699674
  580491
  634799
  588844
  801274
  763850
  800003
  729836
  744290
  461585
  484011
  500152
  503721
  489022
  452490
  603910
  252608
  399332
  441615
  821864
  519683
  543330
  579159
  571765
  571777
  677015
  706912
  685055
  682573
  553142
  566517
  585835
  736911
  719573
  467169
  469740
  412155
  392986
  395654
  393127
  523935
  524973
  527262
  823217
  462304
  485039
  514150
  521019
  495131
  511182
  536850
  567523
  648762
  651794
  687408
  561310
  625259
  590807
  605928
  625134
  585930
  599481
  788007
  788144
  784110
  797817
  751725
  739905
  766342
  622465
  803142
  475541
  387545
  422453
  453514
  417173
  462116
  540724
  521179
  521939
]
3.62 ms
(2.06%)
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
  252608
  387545
  392986
  393127
  395654
  399332
  402979
  412155
  417173
  422453
  432383
  441427
  441577
  441615
  451012
  452490
  453514
  458902
  461585
  462116
  462304
  467169
  469740
  475541
  484011
  485039
  489022
  495131
  500152
  503721
  511182
  514150
  519683
  520337
  521019
  521179
  521939
  523935
  524973
  527262
  540724
  543330
  549146
  553142
  558218
  559928
  561310
  561916
  563870
  566517
  567523
  571765
  571772
  571777
  577887
  579159
  580491
  585835
  585930
  588844
  590807
  598869
  599481
  603910
  605928
  611518
  620060
  622465
  625134
  625259
  634799
  645369
  648762
  651794
  659330
  665418
  677015
  677132
  682573
  685051
  685055
  687408
  696688
  699674
  706912
  707384
  708869
  718933
  719573
  729836
  731794
  736911
  739905
  744290
  745214
  751725
  758270
  763850
  766342
  769324
  770718
  778588
  784110
  786383
  787906
  788007
  788144
  788669
  789157
  789856
  791413
  795440
  797817
  800003
  801274
  803142
  814073
  821864
  823217
]
2.16 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls student"
]
1.96 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк student"
]
1.95 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк student"
]
1.83 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.