Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.45 ms
(87.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
  398972
  412532
  413253
  417592
  420434
  421303
  422180
  424643
  434008
  439300
  439333
  439345
  440863
  441331
  441839
  442431
  443845
  447385
  455475
  455577
  455591
  456317
  459121
  459472
  460476
  463771
  465558
  470979
  471182
  486175
  490619
  493396
  499661
  499764
  502877
  503447
  503728
  509958
  511937
  513990
  514073
  514658
  517142
  517436
  517950
  524126
  524598
  526505
  542087
  545247
  548966
  551646
  552534
  553442
  553553
  555095
  557989
  558174
  560484
  563359
  564245
  565863
  572194
  581988
  583230
  589335
  589682
  595114
  598765
  598840
  599648
  600788
  603108
  603440
  604190
  605498
  606345
  607669
  612068
  624902
  629500
  629844
  643005
  658439
  662190
  664972
  666967
  669665
  672315
  685509
  701237
  701626
  725500
  727037
  729972
  738275
  742860
  755878
  757114
  760381
  760392
  765379
  769380
  770395
  770600
  772318
  776217
  784605
  784771
  790482
  791857
  793877
  795918
  799580
  801569
  806995
  809260
  812289
  812637
]
15.92 ms
(7.95%)
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
  589335
  793877
  795918
  801569
  776217
  784605
  809260
  812289
  729972
  770600
  772318
  791857
  727037
  760392
  725500
  755878
  765379
  784771
  417592
  439345
  434008
  459121
  398972
  439333
  442431
  486175
  526505
  624902
  738275
  440863
  422180
  443845
  463771
  455591
  456317
  503447
  503728
  509958
  513068
  514073
  514658
  511937
  513990
  563359
  551646
  552534
  553442
  555095
  583230
  685509
  701626
  672315
  701237
  666967
  600788
  607669
  629844
  790482
  799580
  806995
  812637
  760381
  769380
  742860
  757114
  770395
  629500
  455475
  460476
  470979
  471182
  439300
  490619
  499661
  502877
  517436
  459472
  605498
  612068
  598765
  595114
  499764
  412532
  421303
  662190
  599648
  603108
  603440
  589682
  604190
  424643
  465558
  572194
  598840
  606345
  643005
  447385
  493396
  441331
  413253
  420434
  441839
  455577
  524126
  524598
  517142
  517950
  545247
  558174
  560484
  565863
  581988
  542087
  548966
  557989
  669665
  658439
  664972
  553553
  564245
]
3.11 ms
(1.56%)
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
  398972
  412532
  413253
  417592
  420434
  421303
  422180
  424643
  434008
  439300
  439333
  439345
  440863
  441331
  441839
  442431
  443845
  447385
  455475
  455577
  455591
  456317
  459121
  459472
  460476
  463771
  465558
  470979
  471182
  486175
  490619
  493396
  499661
  499764
  502877
  503447
  503728
  509958
  511937
  513990
  514073
  514658
  517142
  517436
  517950
  524126
  524598
  526505
  542087
  545247
  548966
  551646
  552534
  553442
  553553
  555095
  557989
  558174
  560484
  563359
  564245
  565863
  572194
  581988
  583230
  589335
  589682
  595114
  598765
  598840
  599648
  600788
  603108
  603440
  604190
  605498
  606345
  607669
  612068
  624902
  629500
  629844
  643005
  658439
  662190
  664972
  666967
  669665
  672315
  685509
  701237
  701626
  725500
  727037
  729972
  738275
  742860
  755878
  757114
  760381
  760392
  765379
  769380
  770395
  770600
  772318
  776217
  784605
  784771
  790482
  791857
  793877
  795918
  799580
  801569
  806995
  809260
  812289
  812637
]
1.94 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade masturbating"
]
1.67 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск masturbating"
]
1.56 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск masturbating"
]
1.55 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.