Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.90 ms
(85.31%)
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
  384457
  418761
  419599
  427997
  432618
  432663
  435114
  437793
  440779
  440788
  440860
  440897
  440923
  441359
  441416
  442211
  442775
  445350
  449158
  450371
  452862
  454306
  454926
  455218
  456202
  456587
  457171
  460660
  460873
  461767
  464800
  464808
  465097
  465270
  466797
  467631
  467935
  468288
  471538
  472438
  474444
  474894
  475452
  477007
  478740
  480718
  482191
  485273
  491583
  492460
  493426
  495437
  496539
  499840
  504450
  507674
  510937
  512937
  513510
  513975
  515959
  529249
  529331
  530005
  534808
  546107
  547584
  549686
  549708
  552664
  552697
  555377
  555592
  555593
  558883
  562975
  569094
  573751
  579471
  588082
  589070
  590929
  591355
  592596
  606626
  612235
  630351
  631607
  641160
  652010
  656498
  666695
  669275
  670625
  678868
  680440
  697010
  711417
  712549
  716693
  733144
  738347
  741779
  742728
  742735
  756990
  759920
  760980
  761137
  761169
  761722
  761848
  767116
  767252
  768031
  768032
  785530
  795485
  796804
  809666
]
16.28 ms
(9.21%)
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
  761169
  767116
  768031
  741779
  742728
  742735
  759920
  760980
  761722
  761848
  738347
  756990
  767252
  768032
  630351
  641160
  711417
  795485
  809666
  432618
  460660
  465097
  467935
  461767
  477007
  418761
  452862
  471538
  460873
  478740
  456587
  510937
  496539
  507674
  465270
  482191
  712549
  606626
  733144
  441416
  449158
  442775
  467631
  384457
  440788
  466797
  579471
  761137
  697010
  440779
  472438
  499840
  529249
  468288
  504450
  530005
  515959
  552664
  573751
  569094
  455218
  456202
  493426
  485273
  513510
  475452
  558883
  612235
  796804
  441359
  427997
  440923
  432663
  435114
  440860
  440897
  419599
  437793
  442211
  445350
  450371
  454306
  457171
  474894
  474444
  480718
  491583
  454926
  492460
  495437
  513975
  534808
  512937
  529331
  464800
  464808
  546107
  547584
  549686
  549708
  555377
  555592
  666695
  680440
  652010
  669275
  678868
  656498
  670625
  716693
  552697
  555593
  562975
  590929
  591355
  592596
  631607
  588082
  589070
  785530
]
2.74 ms
(1.55%)
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
  384457
  418761
  419599
  427997
  432618
  432663
  435114
  437793
  440779
  440788
  440860
  440897
  440923
  441359
  441416
  442211
  442775
  445350
  449158
  450371
  452862
  454306
  454926
  455218
  456202
  456587
  457171
  460660
  460873
  461767
  464800
  464808
  465097
  465270
  466797
  467631
  467935
  468288
  471538
  472438
  474444
  474894
  475452
  477007
  478740
  480718
  482191
  485273
  491583
  492460
  493426
  495437
  496539
  499840
  504450
  507674
  510937
  512937
  513510
  513975
  515959
  529249
  529331
  530005
  534808
  546107
  547584
  549686
  549708
  552664
  552697
  555377
  555592
  555593
  558883
  562975
  569094
  573751
  579471
  588082
  589070
  590929
  591355
  592596
  606626
  612235
  630351
  631607
  641160
  652010
  656498
  666695
  669275
  670625
  678868
  680440
  697010
  711417
  712549
  716693
  733144
  738347
  741779
  742728
  742735
  756990
  759920
  760980
  761137
  761169
  761722
  761848
  767116
  767252
  768031
  768032
  785530
  795485
  796804
  809666
]
1.97 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature wife creampie"
]
1.86 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature жен creampie"
]
1.63 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature жен creampie"
]
1.50 ms
(0.85%)
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.