Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.72 ms
(32.84%)
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
  98951
  146508
  191407
  249637
  365924
  384582
  385427
  385946
  391477
  392602
  395564
  395699
  396258
  396758
  397456
  399631
  400137
  400478
  402137
  404582
  405485
  407424
  407786
  409184
  411738
  411864
  413783
  415734
  418928
  422806
  428869
  428890
  430411
  442407
  443669
  445060
  454058
  454897
  459896
  461035
  461367
  466217
  466930
  467502
  469345
  469475
  474151
  480780
  481933
  482505
  483364
  486958
  489851
  490188
  490910
  490931
  493099
  493117
  503046
  511181
  513523
  517953
  523191
  549646
  550643
  550644
  554897
  558523
  563444
  565147
  567423
  576262
  593527
  599543
  608049
  618404
  621971
  622826
  631970
  649940
  665139
  665311
  665465
  666844
  666849
  667536
  667644
  669768
  673056
  675524
  683066
  694715
  707368
  711671
  712668
  714743
  714748
  715234
  718556
  720603
  724226
  724481
  726543
  726553
  745394
  747258
  770992
  789998
  800864
  801350
  804109
  804619
  807379
  813750
  813916
  814940
  815263
  815598
  824466
  824791
]
205.21 ms
(32.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
196.43 ms
(31.20%)
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
  98951
  146508
  191407
  249637
  365924
  384582
  385427
  385946
  391477
  392602
  395564
  395699
  396258
  396758
  397456
  399631
  400137
  400478
  402137
  404582
  405485
  407424
  407786
  409184
  411738
  411864
  413783
  415734
  418928
  422806
  428869
  428890
  430411
  442407
  443669
  445060
  454058
  454897
  459896
  461035
  461367
  466217
  466930
  467502
  469345
  469475
  474151
  480780
  481933
  482505
  483364
  486958
  489851
  490188
  490910
  490931
  493099
  493117
  503046
  511181
  513523
  517953
  523191
  549646
  550643
  550644
  554897
  558523
  563444
  565147
  567423
  576262
  593527
  599543
  608049
  618404
  621971
  622826
  631970
  649940
  665139
  665311
  665465
  666844
  666849
  667536
  667644
  669768
  673056
  675524
  683066
  694715
  707368
  711671
  712668
  714743
  714748
  715234
  718556
  720603
  724226
  724481
  726543
  726553
  745394
  747258
  770992
  789998
  800864
  801350
  804109
  804619
  807379
  813750
  813916
  814940
  815263
  815598
  824466
  824791
]
15.69 ms
(2.49%)
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
  407424
  415734
  411738
  430411
  413783
  442407
  445060
  824791
  815598
  482505
  459896
  474151
  490931
  489851
  493117
  667644
  707368
  714748
  714743
  715234
  565147
  593527
  599543
  724481
  804619
  391477
  428869
  428890
  409184
  249637
  467502
  481933
  98951
  396758
  400137
  517953
  486958
  490910
  493099
  513523
  483364
  418928
  576262
  665139
  385427
  813750
  824466
  815263
  461367
  550644
  666844
  649940
  683066
  618404
  801350
  807379
  711671
  720603
  146508
  384582
  365924
  422806
  511181
  726543
  726553
  466217
  385946
  395699
  396258
  397456
  399631
  402137
  407786
  813916
  480780
  454897
  554897
  550643
  669768
  675524
  712668
  665465
  666849
  694715
  718556
  665311
  667536
  673056
  567423
  622826
  621971
  631970
  789998
  800864
  804109
  745394
  747258
  770992
  724226
  608049
  400478
  191407
  392602
  443669
  395564
  405485
  404582
  411864
  814940
  466930
  490188
  461035
  469345
  454058
  469475
  503046
  523191
  563444
  549646
  558523
]
2.05 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot young mature"
]
2.03 ms
(0.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot young mature"
]
1.36 ms
(0.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot young mature"
]

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.