Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.57 ms
(82.02%)
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
  188338
  197678
  197736
  358566
  382058
  387856
  388769
  389273
  389713
  391163
  391380
  391703
  391704
  391928
  400819
  409935
  411398
  411406
  418126
  420849
  421826
  421870
  421900
  421918
  422141
  423940
  426712
  427091
  429736
  433291
  434313
  434358
  434371
  434384
  435530
  439078
  439546
  439555
  439610
  439737
  440964
  443696
  443702
  445103
  451507
  452960
  455130
  456333
  460760
  460873
  462019
  463792
  465528
  465812
  466180
  466190
  466195
  466196
  466256
  473252
  475185
  476675
  476936
  478377
  478462
  478740
  479369
  482342
  483787
  484649
  486578
  490406
  491444
  491943
  493258
  494798
  495811
  499391
  500806
  502712
  506031
  508684
  513379
  513676
  516299
  519540
  520309
  520904
  528143
  536433
  540743
  543694
  546955
  546958
  549822
  549825
  549843
  552855
  555093
  556519
  583085
  668529
  683284
  709528
  714911
  719929
  725570
  728687
  733371
  740826
  758509
  777727
  796252
  797358
  802151
  807352
  807353
  816609
  824066
]
16.27 ms
(10.89%)
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
  411398
  427091
  476675
  388769
  391163
  411406
  452960
  460873
  473252
  462019
  540743
  491444
  494798
  495811
  520309
  389273
  358566
  391380
  391703
  466190
  797358
  391928
  460760
  389713
  482342
  478377
  490406
  486578
  420849
  556519
  714911
  668529
  555093
  802151
  807352
  807353
  777727
  733371
  758509
  740826
  725570
  719929
  188338
  479369
  391704
  400819
  409935
  478740
  434358
  466196
  500806
  536433
  508684
  506031
  520904
  824066
  728687
  484649
  816609
  827870
  683284
  709528
  796252
  197736
  543694
  387856
  382058
  435530
  439078
  455130
  546955
  552855
  426712
  475185
  478462
  197678
  429736
  434313
  434384
  439546
  463792
  421918
  422141
  476936
  418126
  434371
  443696
  443702
  456333
  465528
  421826
  421870
  445103
  451507
  528143
  493258
  499391
  513379
  513676
  516299
  519540
  483787
  491943
  423940
  439610
  440964
  421900
  502712
  583085
  549825
  549843
  546958
  549822
  433291
  466180
  466256
  439555
  439737
  465812
  466195
]
2.85 ms
(1.91%)
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
  188338
  197678
  197736
  358566
  382058
  387856
  388769
  389273
  389713
  391163
  391380
  391703
  391704
  391928
  400819
  409935
  411398
  411406
  418126
  420849
  421826
  421870
  421900
  421918
  422141
  423940
  426712
  427091
  429736
  433291
  434313
  434358
  434371
  434384
  435530
  439078
  439546
  439555
  439610
  439737
  440964
  443696
  443702
  445103
  451507
  452960
  455130
  456333
  460760
  460873
  462019
  463792
  465528
  465812
  466180
  466190
  466195
  466196
  466256
  473252
  475185
  476675
  476936
  478377
  478462
  478740
  479369
  482342
  483787
  484649
  486578
  490406
  491444
  491943
  493258
  494798
  495811
  499391
  500806
  502712
  506031
  508684
  513379
  513676
  516299
  519540
  520309
  520904
  528143
  536433
  540743
  543694
  546955
  546958
  549822
  549825
  549843
  552855
  555093
  556519
  583085
  668529
  683284
  709528
  714911
  719929
  725570
  728687
  733371
  740826
  758509
  777727
  796252
  797358
  802151
  807352
  807353
  816609
  824066
]
2.19 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с мамой русские"
]
2.02 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин русск"
]
1.79 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.16%)
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.