Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.40 ms
(85.98%)
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
  33459
  282218
  388746
  388878
  397940
  398182
  398464
  401261
  405468
  417889
  418838
  418848
  423424
  424304
  425829
  430228
  433231
  433334
  433498
  434044
  434046
  434163
  438001
  443773
  444147
  447466
  447692
  448801
  449021
  452066
  452418
  454228
  455857
  456525
  457786
  457789
  458191
  461337
  462280
  465070
  466554
  467612
  470449
  470987
  471881
  472286
  473939
  474527
  474550
  474635
  474826
  479616
  481591
  490685
  492338
  502274
  503233
  504336
  505041
  507686
  509560
  510160
  510217
  511067
  513828
  517612
  517855
  520540
  522107
  524285
  524816
  531510
  541370
  542676
  549300
  550325
  551995
  552058
  557182
  569549
  576128
  581997
  585960
  588792
  590879
  592453
  596556
  604558
  606587
  609235
  615812
  616353
  620130
  621482
  629872
  630542
  632034
  636545
  636598
  642714
  664157
  681313
  682421
  691995
  696598
  698981
  699621
  710871
  716394
  719001
  726332
  734506
  764490
  788269
  789878
  805069
  811220
  814347
  815600
  817865
]
19.66 ms
(9.75%)
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
  805069
  388878
  524285
  524816
  398182
  492338
  474527
  664157
  592453
  616353
  726332
  430228
  510160
  615812
  817865
  447692
  681313
  466554
  467612
  576128
  629872
  504336
  698981
  550325
  479616
  405468
  397940
  455857
  433498
  814347
  448801
  470449
  474635
  531510
  447466
  452418
  470987
  424304
  517855
  511067
  588792
  465070
  509560
  462280
  472286
  541370
  716394
  418838
  557182
  33459
  433334
  474826
  682421
  636598
  585960
  636545
  699621
  691995
  719001
  569549
  606587
  734506
  632034
  630542
  764490
  401261
  282218
  454228
  434163
  507686
  604558
  811220
  789878
  398464
  434044
  510217
  461337
  549300
  710871
  642714
  590879
  609235
  503233
  481591
  696598
  444147
  456525
  788269
  473939
  418848
  542676
  433231
  457786
  423424
  471881
  474550
  438001
  417889
  596556
  620130
  443773
  520540
  815600
  517612
  458191
  513828
  425829
  449021
  522107
  581997
  457789
  551995
  434046
  502274
  490685
  505041
  388746
  552058
  621482
  452066
]
2.39 ms
(1.19%)
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
  33459
  282218
  388746
  388878
  397940
  398182
  398464
  401261
  405468
  417889
  418838
  418848
  423424
  424304
  425829
  430228
  433231
  433334
  433498
  434044
  434046
  434163
  438001
  443773
  444147
  447466
  447692
  448801
  449021
  452066
  452418
  454228
  455857
  456525
  457786
  457789
  458191
  461337
  462280
  465070
  466554
  467612
  470449
  470987
  471881
  472286
  473939
  474527
  474550
  474635
  474826
  479616
  481591
  490685
  492338
  502274
  503233
  504336
  505041
  507686
  509560
  510160
  510217
  511067
  513828
  517612
  517855
  520540
  522107
  524285
  524816
  531510
  541370
  542676
  549300
  550325
  551995
  552058
  557182
  569549
  576128
  581997
  585960
  588792
  590879
  592453
  596556
  604558
  606587
  609235
  615812
  616353
  620130
  621482
  629872
  630542
  632034
  636545
  636598
  642714
  664157
  681313
  682421
  691995
  696598
  698981
  699621
  710871
  716394
  719001
  726332
  734506
  764490
  788269
  789878
  805069
  811220
  814347
  815600
  817865
]
2.09 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation sex"
]
1.49 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк секс"
]
1.38 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.27 ms
(0.63%)
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.