Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.25 ms
(88.22%)
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
  64314
  83152
  330354
  383217
  397760
  401519
  402842
  405845
  419094
  420926
  434443
  453259
  475649
  488475
  496479
  499832
  518819
  527263
  530096
  530784
  532839
  536590
  536653
  540642
  540936
  544838
  545114
  546132
  546513
  553636
  554121
  558203
  558865
  583714
  592066
  598295
  606952
  613861
  616519
  626116
  628615
  629541
  635419
  637299
  638125
  641227
  693677
  697935
  698025
  698066
  698739
  699166
  700926
  707626
  708135
  708893
  711027
  712317
  715603
  715694
  716781
  716920
  720083
  720542
  722990
  723656
  724938
  725761
  730628
  734293
  734590
  735895
  740815
  741854
  741884
  752116
  752511
  753610
  757126
  758941
  759630
  761161
  762556
  762873
  764530
  765100
  767653
  768724
  770715
  771761
  776785
  779089
  779779
  780213
  783545
  783689
  783804
  785496
  786175
  792693
  792781
  793450
  793455
  794938
  795631
  795665
  797066
  797147
  809888
  811919
  819277
  820085
  823758
  824079
  824217
  825523
  826114
  826532
  826643
  826815
]
13.36 ms
(6.73%)
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
  809888
  64314
  616519
  598295
  735895
  475649
  496479
  629541
  83152
  397760
  420926
  819277
  823758
  824079
  826532
  826114
  826643
  826815
  820085
  824217
  825523
  540936
  720542
  698066
  698739
  707626
  708893
  693677
  716781
  626116
  628615
  637299
  613861
  635419
  638125
  783545
  783804
  792693
  780213
  793455
  795631
  752511
  757126
  758941
  762556
  770715
  786175
  794938
  730628
  734590
  753610
  762873
  724938
  752116
  759630
  761161
  764530
  725761
  741884
  606952
  712317
  715603
  715694
  716920
  722990
  785496
  792781
  793450
  795665
  797066
  797147
  330354
  402842
  383217
  401519
  419094
  540642
  518819
  488475
  554121
  697935
  708135
  720083
  546513
  592066
  776785
  779779
  811919
  741854
  767653
  768724
  734293
  765100
  771761
  740815
  641227
  711027
  779089
  783689
  527263
  532839
  536590
  536653
  530784
  583714
  544838
  434443
  405845
  723656
  453259
  530096
  499832
  558203
  553636
  545114
  546132
  558865
  698025
  699166
  700926
]
2.78 ms
(1.40%)
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
  64314
  83152
  330354
  383217
  397760
  401519
  402842
  405845
  419094
  420926
  434443
  453259
  475649
  488475
  496479
  499832
  518819
  527263
  530096
  530784
  532839
  536590
  536653
  540642
  540936
  544838
  545114
  546132
  546513
  553636
  554121
  558203
  558865
  583714
  592066
  598295
  606952
  613861
  616519
  626116
  628615
  629541
  635419
  637299
  638125
  641227
  693677
  697935
  698025
  698066
  698739
  699166
  700926
  707626
  708135
  708893
  711027
  712317
  715603
  715694
  716781
  716920
  720083
  720542
  722990
  723656
  724938
  725761
  730628
  734293
  734590
  735895
  740815
  741854
  741884
  752116
  752511
  753610
  757126
  758941
  759630
  761161
  762556
  762873
  764530
  765100
  767653
  768724
  770715
  771761
  776785
  779089
  779779
  780213
  783545
  783689
  783804
  785496
  786175
  792693
  792781
  793450
  793455
  794938
  795631
  795665
  797066
  797147
  809888
  811919
  819277
  820085
  823758
  824079
  824217
  825523
  826114
  826532
  826643
  826815
]
2.03 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм огромные"
]
1.79 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm huge"
]
1.60 ms
(0.80%)
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.