Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.49 ms
(82.12%)
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
  386189
  400852
  415207
  415241
  421821
  421837
  421850
  422166
  422204
  422205
  422340
  423923
  424479
  425531
  425556
  427186
  428166
  434070
  439621
  439644
  439713
  439730
  439742
  439758
  439761
  439808
  440614
  442970
  445393
  445707
  446811
  452297
  453601
  454423
  455685
  456818
  461366
  466063
  469507
  470159
  470196
  470472
  474095
  474743
  475410
  477555
  480377
  484739
  489471
  491607
  492732
  493181
  494006
  494036
  500442
  503241
  505022
  506328
  508701
  512680
  514106
  514765
  517114
  517712
  518147
  520681
  521814
  522870
  526087
  526894
  528343
  533832
  541674
  545637
  546687
  549815
  550282
  558720
  558877
  560950
  561441
  565630
  565648
  566691
  570169
  572753
  576649
  576694
  581098
  581292
  586594
  590194
  594810
  597047
  600843
  605708
  605764
  611245
  622976
  625235
  626281
  644301
  647935
  665796
  701192
  704579
  714183
  720693
  722172
  780724
  784223
  789733
  791365
  798680
  798684
  810069
  814335
  823857
  827357
  828720
]
18.64 ms
(11.13%)
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
  644301
  810069
  440614
  827357
  514765
  461366
  428166
  474743
  500442
  520681
  581098
  439621
  823857
  722172
  421837
  508701
  453601
  425556
  611245
  518147
  546687
  545637
  550282
  560950
  439644
  421821
  424479
  439730
  581292
  439758
  422166
  452297
  590194
  493181
  549815
  561441
  665796
  565648
  522870
  446811
  558720
  789733
  526087
  445393
  526894
  386189
  442970
  456818
  491607
  503241
  566691
  492732
  480377
  477555
  528343
  470159
  791365
  720693
  505022
  422204
  445707
  647935
  798680
  422205
  425531
  798684
  421850
  494036
  814335
  597047
  701192
  576694
  439808
  506328
  400852
  466063
  475410
  439742
  439761
  558877
  455685
  415207
  572753
  489471
  517114
  484739
  470196
  533832
  512680
  521814
  454423
  474095
  470472
  434070
  828720
  423923
  517712
  714183
  605708
  780724
  541674
  576649
  594810
  415241
  586594
  626281
  784223
  565630
  469507
  570169
  605764
  704579
  494006
  625235
  600843
  622976
  439713
  422340
  427186
  514106
]
3.32 ms
(1.98%)
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
  386189
  400852
  415207
  415241
  421821
  421837
  421850
  422166
  422204
  422205
  422340
  423923
  424479
  425531
  425556
  427186
  428166
  434070
  439621
  439644
  439713
  439730
  439742
  439758
  439761
  439808
  440614
  442970
  445393
  445707
  446811
  452297
  453601
  454423
  455685
  456818
  461366
  466063
  469507
  470159
  470196
  470472
  474095
  474743
  475410
  477555
  480377
  484739
  489471
  491607
  492732
  493181
  494006
  494036
  500442
  503241
  505022
  506328
  508701
  512680
  514106
  514765
  517114
  517712
  518147
  520681
  521814
  522870
  526087
  526894
  528343
  533832
  541674
  545637
  546687
  549815
  550282
  558720
  558877
  560950
  561441
  565630
  565648
  566691
  570169
  572753
  576649
  576694
  581098
  581292
  586594
  590194
  594810
  597047
  600843
  605708
  605764
  611245
  622976
  625235
  626281
  644301
  647935
  665796
  701192
  704579
  714183
  720693
  722172
  780724
  784223
  789733
  791365
  798680
  798684
  810069
  814335
  823857
  827357
  828720
]
2.25 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "спящую мамку в жопу"
]
2.14 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ мам женщин анал"
]
1.99 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.96%)
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.