Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.72 ms
(80.14%)
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
  7092
  339821
  385448
  392775
  395698
  396313
  396400
  400703
  400923
  413623
  417836
  423968
  427221
  428335
  429584
  429930
  433721
  435864
  437233
  437529
  442353
  443902
  457720
  462304
  463115
  464658
  470683
  470833
  486613
  487328
  488493
  491193
  492754
  494587
  495158
  495732
  496202
  499338
  506781
  508706
  509586
  519069
  519969
  520513
  520658
  522088
  524702
  526137
  526393
  528505
  529491
  529514
  530705
  531270
  533274
  534465
  534653
  534877
  539186
  540869
  541125
  541203
  543897
  545456
  546659
  550227
  551625
  552443
  552486
  552727
  553779
  553896
  554817
  559105
  559661
  562314
  563273
  564287
  566242
  567875
  568932
  569648
  575575
  583000
  585574
  586376
  586707
  587309
  587342
  588666
  589392
  589996
  592136
  592416
  592712
  594018
  594448
  594971
  597223
  601463
  606179
  607180
  608945
  613837
  618188
  620371
  620549
  624890
  625816
  626217
  628901
  634656
  641560
  646581
  647105
  650063
  655466
  656522
  710034
  802777
]
19.95 ms
(13.70%)
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
  597223
  339821
  442353
  562314
  587309
  417836
  462304
  494587
  522088
  464658
  575575
  546659
  551625
  646581
  710034
  553896
  566242
  625816
  592136
  594448
  589392
  620549
  641560
  396400
  423968
  495732
  519969
  7092
  429930
  433721
  463115
  529514
  531270
  520658
  533274
  534465
  543897
  552486
  568932
  541203
  552727
  559105
  655466
  552443
  586376
  608945
  588666
  620371
  585574
  589996
  594018
  601463
  626217
  586707
  606179
  618188
  802777
  437233
  443902
  492754
  396313
  427221
  486613
  392775
  491193
  400923
  429584
  428335
  540869
  487328
  470683
  488493
  529491
  530705
  534653
  534877
  528505
  539186
  519069
  520513
  526137
  499338
  509586
  564287
  567875
  569648
  541125
  553779
  563273
  545456
  583000
  647105
  656522
  559661
  592712
  607180
  613837
  634656
  587342
  594971
  624890
  628901
  592416
  413623
  435864
  457720
  470833
  496202
  506781
  524702
  526393
  508706
  495158
  550227
  554817
  650063
  437529
  395698
  400703
  385448
]
2.39 ms
(1.64%)
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
  7092
  339821
  385448
  392775
  395698
  396313
  396400
  400703
  400923
  413623
  417836
  423968
  427221
  428335
  429584
  429930
  433721
  435864
  437233
  437529
  442353
  443902
  457720
  462304
  463115
  464658
  470683
  470833
  486613
  487328
  488493
  491193
  492754
  494587
  495158
  495732
  496202
  499338
  506781
  508706
  509586
  519069
  519969
  520513
  520658
  522088
  524702
  526137
  526393
  528505
  529491
  529514
  530705
  531270
  533274
  534465
  534653
  534877
  539186
  540869
  541125
  541203
  543897
  545456
  546659
  550227
  551625
  552443
  552486
  552727
  553779
  553896
  554817
  559105
  559661
  562314
  563273
  564287
  566242
  567875
  568932
  569648
  575575
  583000
  585574
  586376
  586707
  587309
  587342
  588666
  589392
  589996
  592136
  592416
  592712
  594018
  594448
  594971
  597223
  601463
  606179
  607180
  608945
  613837
  618188
  620371
  620549
  624890
  625816
  626217
  628901
  634656
  641560
  646581
  647105
  650063
  655466
  656522
  710034
  802777
]
2.08 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мужик себя трах"
]
1.71 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин секс"
]
1.33 ms
(0.91%)
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.