Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.29 ms
(87.34%)
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
  388537
  398946
  399151
  402419
  412274
  421815
  421842
  421885
  421891
  421898
  422147
  422196
  422236
  440707
  443669
  445850
  446762
  448688
  448996
  449245
  449605
  449623
  457455
  457468
  457866
  460139
  462018
  462453
  465534
  465551
  475552
  481644
  482485
  482556
  483637
  489171
  496565
  502866
  508212
  516483
  523618
  534190
  536891
  538006
  552286
  557049
  559048
  560346
  560968
  562868
  563090
  564228
  565630
  568362
  570869
  573404
  577274
  590974
  591245
  603198
  610005
  610823
  614419
  625233
  637403
  638426
  662888
  668938
  669206
  669507
  678734
  682363
  689042
  694105
  697219
  701253
  712331
  714930
  716351
  722371
  726572
  726599
  726681
  726820
  727783
  737372
  738334
  741506
  756402
  756874
  759011
  760516
  763590
  779801
  780340
  788196
  788545
  790044
  793559
  793781
  794301
  795033
  798616
  801065
  801357
  802375
  804551
  806959
  807534
  807890
  808551
  809522
  809565
  809791
  811314
  813917
  818502
  824247
  824994
]
17.16 ms
(8.00%)
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
  701253
  780340
  798616
  399151
  422147
  398946
  422236
  445850
  421891
  443669
  449623
  465534
  446762
  448688
  559048
  421842
  449245
  523618
  536891
  402419
  462018
  712331
  668938
  694105
  610005
  591245
  637403
  759011
  726599
  737372
  726681
  722371
  802375
  412274
  457866
  482556
  496565
  552286
  563090
  716351
  560968
  788196
  788545
  727783
  794301
  462453
  475552
  421815
  421885
  421898
  440707
  457455
  422196
  465551
  538006
  483637
  502866
  516483
  489171
  813917
  460139
  678734
  568362
  457468
  388537
  448996
  669206
  807534
  726572
  806959
  824247
  824994
  818502
  565630
  714930
  662888
  603198
  801357
  808551
  738334
  793559
  811314
  726820
  741506
  756402
  638426
  697219
  793781
  809791
  449605
  481644
  534190
  508212
  482485
  560346
  570869
  577274
  562868
  669507
  682363
  662145
  689042
  557049
  564228
  573404
  590974
  610823
  614419
  625233
  779801
  790044
  804551
  809522
  809565
  756874
  760516
  763590
  795033
  801065
  807890
]
3.56 ms
(1.66%)
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
  388537
  398946
  399151
  402419
  412274
  421815
  421842
  421885
  421891
  421898
  422147
  422196
  422236
  440707
  443669
  445850
  446762
  448688
  448996
  449245
  449605
  449623
  457455
  457468
  457866
  460139
  462018
  462453
  465534
  465551
  475552
  481644
  482485
  482556
  483637
  489171
  496565
  502866
  508212
  516483
  523618
  534190
  536891
  538006
  552286
  557049
  559048
  560346
  560968
  562868
  563090
  564228
  565630
  568362
  570869
  573404
  577274
  590974
  591245
  603198
  610005
  610823
  614419
  625233
  637403
  638426
  662888
  668938
  669206
  669507
  678734
  682363
  689042
  694105
  697219
  701253
  712331
  714930
  716351
  722371
  726572
  726599
  726681
  726820
  727783
  737372
  738334
  741506
  756402
  756874
  759011
  760516
  763590
  779801
  780340
  788196
  788545
  790044
  793559
  793781
  794301
  795033
  798616
  801065
  801357
  802375
  804551
  806959
  807534
  807890
  808551
  809522
  809565
  809791
  811314
  813917
  818502
  824247
  824994
]
1.94 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин stepson"
]
1.60 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother stepson"
]
1.58 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин stepson"
]

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.