Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.97 ms
(82.68%)
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
  6840
  14534
  105023
  125944
  161969
  213614
  233500
  351216
  365865
  385436
  385928
  388313
  388769
  391083
  391567
  391850
  391908
  392031
  392579
  392588
  392599
  397439
  397852
  398958
  400696
  402255
  402733
  402982
  411418
  420736
  423483
  429111
  432304
  440715
  444666
  453629
  456023
  457580
  458223
  458408
  461414
  461460
  461553
  461619
  462538
  464244
  467549
  469277
  470510
  472019
  472298
  472400
  472609
  473611
  476481
  477963
  478008
  483242
  484403
  485087
  488955
  490709
  491090
  504167
  505293
  509230
  510794
  512645
  516312
  517548
  521422
  522655
  527634
  533782
  534147
  534497
  543619
  543717
  544397
  544864
  545527
  546661
  548713
  549578
  549624
  549785
  550238
  552248
  552633
  555787
  567830
  568847
  571401
  572497
  579072
  579893
  584841
  595473
  598577
  610835
  611422
  659300
  671250
  717662
  718643
  718658
  720031
  736185
  742938
  749907
  754104
  762277
  763463
  770278
  785049
  788457
  792317
  814973
  819786
]
16.64 ms
(10.84%)
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
  546661
  717662
  584841
  464244
  461460
  491090
  792317
  762277
  458408
  549624
  6840
  429111
  462538
  485087
  543717
  610835
  718643
  105023
  392599
  456023
  388313
  549578
  527634
  742938
  213614
  543619
  365865
  545527
  736185
  397852
  125944
  814973
  549785
  579072
  684768
  595473
  453629
  504167
  391083
  397439
  544864
  391567
  458223
  598577
  477963
  544397
  552633
  572497
  351216
  402255
  392579
  473611
  476481
  534497
  749907
  161969
  470510
  659300
  720031
  548713
  423483
  533782
  478008
  509230
  819786
  432304
  440715
  461619
  785049
  763463
  233500
  505293
  14534
  534147
  671250
  770278
  391908
  402982
  385436
  411418
  488955
  522655
  550238
  788457
  754104
  718658
  392588
  388769
  472019
  611422
  420736
  398958
  392031
  391850
  483242
  571401
  444666
  461414
  472298
  402733
  472609
  469277
  472400
  490709
  568847
  567830
  552248
  400696
  461553
  467549
  484403
  510794
  517548
  521422
  579893
  385928
  516312
  512645
  555787
  457580
]
2.48 ms
(1.61%)
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
  6840
  14534
  105023
  125944
  161969
  213614
  233500
  351216
  365865
  385436
  385928
  388313
  388769
  391083
  391567
  391850
  391908
  392031
  392579
  392588
  392599
  397439
  397852
  398958
  400696
  402255
  402733
  402982
  411418
  420736
  423483
  429111
  432304
  440715
  444666
  453629
  456023
  457580
  458223
  458408
  461414
  461460
  461553
  461619
  462538
  464244
  467549
  469277
  470510
  472019
  472298
  472400
  472609
  473611
  476481
  477963
  478008
  483242
  484403
  485087
  488955
  490709
  491090
  504167
  505293
  509230
  510794
  512645
  516312
  517548
  521422
  522655
  527634
  533782
  534147
  534497
  543619
  543717
  544397
  544864
  545527
  546661
  548713
  549578
  549624
  549785
  550238
  552248
  552633
  555787
  567830
  568847
  571401
  572497
  579072
  579893
  584841
  595473
  598577
  610835
  611422
  659300
  671250
  717662
  718643
  718658
  720031
  736185
  742938
  749907
  754104
  762277
  763463
  770278
  785049
  788457
  792317
  814973
  819786
]
2.17 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трах с русской"
]
1.87 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск"
]
1.82 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.05%)
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.